SHOW FULL COLUMNS FROM `lb_county` [ RunTime:0.000455s ]
SELECT * FROM `lb_county` WHERE `id` = 521 LIMIT 1 [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `lb_city` [ RunTime:0.000562s ]
SELECT * FROM `lb_city` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000234s ]
SELECT `id`,`name`,`city_id` FROM `lb_county` WHERE ( `city_id` = 143 ) [ RunTime:0.001281s ]
SELECT `id`,`name`,`province_id` FROM `lb_city` WHERE ( `province_id` = 9 ) [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `lb_amap_shop` [ RunTime:0.000429s ]
SELECT COUNT(*) AS think_count FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 143 AND `adname` = '金州区' [ RunTime:0.000503s ]
SELECT `id`,`name`,`cityname`,`photos` FROM `lb_amap_shop` WHERE `delete_time` = 0 AND `city_id` = 143 AND `adname` = '金州区' ORDER BY `id` DESC LIMIT 12,12 [ RunTime:0.000377s ]