SHOW FULL COLUMNS FROM `lb_county` [ RunTime:0.000380s ]
SELECT * FROM `lb_county` WHERE `id` = 686 LIMIT 1 [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `lb_city` [ RunTime:0.000713s ]
SELECT * FROM `lb_city` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000192s ]
SELECT `id`,`name`,`city_id` FROM `lb_county` WHERE ( `city_id` = 167 ) [ RunTime:0.001268s ]
SELECT `id`,`name`,`province_id` FROM `lb_city` WHERE ( `province_id` = 11 ) [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `lb_amap_shop` [ RunTime:0.000367s ]
SELECT COUNT(*) AS think_count FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 167 AND `adname` = '铜山区' [ RunTime:0.000485s ]
SELECT `id`,`name`,`cityname`,`photos` FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 167 AND `adname` = '铜山区' ORDER BY `id` DESC LIMIT 24,12 [ RunTime:0.000564s ]