SHOW FULL COLUMNS FROM `yf_nav` [ RunTime:0.000936s ]
SELECT * FROM `yf_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `yf_set_city` [ RunTime:0.000711s ]
SELECT `shortname` FROM `yf_set_city` WHERE `id` = 310100 LIMIT 1 [ RunTime:0.000323s ]
SHOW FULL COLUMNS FROM `yf_website_links` [ RunTime:0.000653s ]
SELECT * FROM `yf_website_links` WHERE `status` = 1 [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `yf_office` [ RunTime:0.000952s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND `is_recommend` = 1 LIMIT 25,20 [ RunTime:0.000647s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659083,659046,659020,659021,659025,659051,659054,200433,659047,200071,659074,659024,659073,659031,659085,201104,310114,310104,310115,310112,310110,310109,200001,310105) ORDER BY `id` DESC [ RunTime:0.000460s ]
SELECT COUNT(*) AS think_count FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001766s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.002151s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,201406,201601,659124,659075,659047,200086,659089,200434,310120,310117,310105,310115,310109) ORDER BY `id` DESC [ RunTime:0.000385s ]
SHOW FULL COLUMNS FROM `yf_work` [ RunTime:0.000855s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 3648 LIMIT 6 [ RunTime:0.000663s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 3721 LIMIT 6 [ RunTime:0.000321s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2034 LIMIT 6 [ RunTime:0.000266s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2687 LIMIT 6 [ RunTime:0.000715s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2345 LIMIT 6 [ RunTime:0.000331s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 2967 LIMIT 6 [ RunTime:0.001303s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 1066 LIMIT 6 [ RunTime:0.000298s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 3632 LIMIT 6 [ RunTime:0.000288s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 3535 LIMIT 6 [ RunTime:0.000401s ]
SELECT `id`,`mianji` FROM `yf_work` WHERE `status` = 2 AND `is_delete` = 0 AND `office_id` = 1060 LIMIT 6 [ RunTime:0.000431s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 2018,10 [ RunTime:0.008732s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659104,659045,200333,659084,659034,659094,659017,310152,659065,659105,310106,310104,310107,310114,310101) ORDER BY `id` DESC [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `yf_jiage` [ RunTime:0.010117s ]
SELECT *,jianame as text FROM `yf_jiage` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.013125s ]
SHOW FULL COLUMNS FROM `yf_mj` [ RunTime:0.000671s ]
SELECT *,value_name as text,'mj' as type FROM `yf_mj` ORDER BY `id` ASC [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `yf_lx` [ RunTime:0.013100s ]
SELECT *,name as text FROM `yf_lx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000960s ]
SHOW FULL COLUMNS FROM `yf_metro` [ RunTime:0.000736s ]
SELECT * FROM `yf_metro` WHERE `pid` = 0 AND `status` = 1 AND `city` = 'sh' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `yf_zx` [ RunTime:0.000669s ]
SELECT *,name as text FROM `yf_zx` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000357s ]
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.000468s ]
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.000845s ]