SHOW FULL COLUMNS FROM `yf_nav` [ RunTime:0.000660s ]
SELECT * FROM `yf_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `yf_set_city` [ RunTime:0.000475s ]
SELECT `shortname` FROM `yf_set_city` WHERE `id` = 310100 LIMIT 1 [ RunTime:0.000219s ]
SHOW FULL COLUMNS FROM `yf_website_links` [ RunTime:0.000403s ]
SELECT * FROM `yf_website_links` WHERE `status` = 1 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `yf_office` [ RunTime:0.000604s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND `is_recommend` = 1 LIMIT 28,20 [ RunTime:0.000441s ]
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.000339s ]
SHOW FULL COLUMNS FROM `yf_lx` [ RunTime:0.000583s ]
SELECT `name` FROM `yf_lx` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000219s ]
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.000227s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND FIND_IN_SET('19', `lxs`) ORDER BY `update_time` DESC LIMIT 1870,10 [ RunTime:0.015289s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659054,659115,659034,659128,659129,310110,310104) ORDER BY `id` DESC [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `yf_work` [ RunTime:0.000657s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2274 LIMIT 6 [ RunTime:0.000277s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2261 LIMIT 6 [ RunTime:0.000396s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2252 LIMIT 6 [ RunTime:0.000370s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2248 LIMIT 6 [ RunTime:0.000357s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2234 LIMIT 6 [ RunTime:0.000224s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2216 LIMIT 6 [ RunTime:0.000392s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2214 LIMIT 6 [ RunTime:0.000377s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2213 LIMIT 6 [ RunTime:0.000247s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2212 LIMIT 6 [ RunTime:0.000225s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2205 LIMIT 6 [ RunTime:0.000360s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 1463,10 [ RunTime:0.000355s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,201104,310112) ORDER BY `id` DESC [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `yf_jiage` [ RunTime:0.000535s ]
SELECT *,jianame as text FROM `yf_jiage` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `yf_mj` [ RunTime:0.000448s ]
SELECT *,value_name as text,'mj' as type FROM `yf_mj` ORDER BY `id` ASC [ RunTime:0.000193s ]
SELECT *,name as text FROM `yf_lx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000169s ]
SHOW FULL COLUMNS FROM `yf_metro` [ RunTime:0.000459s ]
SELECT * FROM `yf_metro` WHERE `pid` = 0 AND `status` = 1 AND `city` = 'sh' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `yf_zx` [ RunTime:0.000411s ]
SELECT *,name as text FROM `yf_zx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000197s ]
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.000291s ]
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.000445s ]