SHOW FULL COLUMNS FROM `lb_county` [ RunTime:0.004224s ]
SELECT * FROM `lb_county` WHERE `id` = 686 LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `lb_city` [ RunTime:0.001190s ]
SELECT * FROM `lb_city` WHERE `id` = 167 LIMIT 1 [ RunTime:0.000261s ]
SELECT `id`,`name`,`city_id` FROM `lb_county` WHERE ( `city_id` = 167 ) [ RunTime:0.001423s ]
SELECT `id`,`name`,`province_id` FROM `lb_city` WHERE ( `province_id` = 11 ) [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `lb_amap_shop` [ RunTime:0.000518s ]
SELECT COUNT(*) AS think_count FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 167 AND `adname` = '铜山区' [ RunTime:0.000588s ]
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.000726s ]