SHOW FULL COLUMNS FROM `yf_nav` [ RunTime:0.000656s ]
SELECT * FROM `yf_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `yf_set_city` [ RunTime:0.000533s ]
SELECT `shortname` FROM `yf_set_city` WHERE `id` = 310100 LIMIT 1 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `yf_website_links` [ RunTime:0.000485s ]
SELECT * FROM `yf_website_links` WHERE `status` = 1 [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `yf_office` [ RunTime:0.000665s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND `is_recommend` = 1 LIMIT 28,20 [ RunTime:0.000519s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659021,659083,659025,659051,659054,200433,659047,200071,659074,659024,659073,659031,659085,201104,201708,201615,659084,310115,310114,310112,310110,310109,200001,310105,310118,310117) ORDER BY `id` DESC [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `yf_lx` [ RunTime:0.000517s ]
SELECT `name` FROM `yf_lx` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000253s ]
SELECT COUNT(*) AS think_count FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND FIND_IN_SET('19', `lxs`) LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND FIND_IN_SET('19', `lxs`) ORDER BY `update_time` DESC LIMIT 1860,10 [ RunTime:0.000413s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659110,659055,659020,659054,659128,659034,659105,659115,310104,310110,310115) ORDER BY `id` DESC [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `yf_work` [ RunTime:0.000623s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2313 LIMIT 6 [ RunTime:0.000272s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2310 LIMIT 6 [ RunTime:0.000264s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2309 LIMIT 6 [ RunTime:0.000248s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2299 LIMIT 6 [ RunTime:0.000266s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2295 LIMIT 6 [ RunTime:0.000245s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2293 LIMIT 6 [ RunTime:0.000272s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2288 LIMIT 6 [ RunTime:0.000254s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2283 LIMIT 6 [ RunTime:0.000269s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2276 LIMIT 6 [ RunTime:0.000269s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2275 LIMIT 6 [ RunTime:0.000238s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 2559,10 [ RunTime:0.009981s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,200073,659022,659104,659100,659017,200072,659033,659048,659105,659045,200001,310107,310106,310112,310101,310104) ORDER BY `id` DESC [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `yf_jiage` [ RunTime:0.000492s ]
SELECT *,jianame as text FROM `yf_jiage` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `yf_mj` [ RunTime:0.000416s ]
SELECT *,value_name as text,'mj' as type FROM `yf_mj` ORDER BY `id` ASC [ RunTime:0.000186s ]
SELECT *,name as text FROM `yf_lx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000165s ]
SHOW FULL COLUMNS FROM `yf_metro` [ RunTime:0.000435s ]
SELECT * FROM `yf_metro` WHERE `pid` = 0 AND `status` = 1 AND `city` = 'sh' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `yf_zx` [ RunTime:0.000381s ]
SELECT *,name as text FROM `yf_zx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000179s ]
SELECT id,pid,shortname as name,shortname as text,'qu' as type,level FROM `yf_set_city` WHERE `city_code` = 310100 AND `is_show` = 1 AND `level` > 2 ORDER BY `id` ASC [ RunTime:0.000254s ]
SELECT id,name,pid,'di' as type,name as text FROM `yf_metro` WHERE `status` = 1 AND `city_id` = 310100 ORDER BY `id` DESC [ RunTime:0.000468s ]