SHOW FULL COLUMNS FROM `lb_city` [ RunTime:0.000519s ]
SELECT `id`,`name`,`province_id` FROM `lb_city` [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `lb_county` [ RunTime:0.000355s ]
SELECT `id`,`name`,`city_id` FROM `lb_county` WHERE ( `city_id` = 167 ) [ RunTime:0.001342s ]
SHOW FULL COLUMNS FROM `lb_amap_shop` [ RunTime:0.000397s ]
SELECT COUNT(*) AS think_count FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 167 [ RunTime:0.000555s ]
SELECT `id`,`name`,`cityname`,`photos` FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 167 ORDER BY `id` DESC LIMIT 144,12 [ RunTime:0.000429s ]
SELECT `id`,`name`,`province_id` FROM `lb_city` WHERE ( `province_id` = 11 ) [ RunTime:0.000392s ]