SHOW FULL COLUMNS FROM `yf_nav` [ RunTime:0.000687s ]
SELECT * FROM `yf_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `yf_set_city` [ RunTime:0.000511s ]
SELECT `shortname` FROM `yf_set_city` WHERE `id` = 310100 LIMIT 1 [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `yf_website_links` [ RunTime:0.000429s ]
SELECT * FROM `yf_website_links` WHERE `status` = 1 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `yf_office` [ RunTime:0.000547s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND `is_recommend` = 1 LIMIT 25,20 [ RunTime:0.000377s ]
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.000321s ]
SELECT `id`,`pid`,shortname as name FROM `yf_set_city` WHERE `id` = 310106 AND `is_show` = 1 LIMIT 1 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `yf_office_share` [ RunTime:0.000797s ]
SELECT COUNT(*) AS think_count FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 AND `qu_id` = 310106 LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 AND `qu_id` = 310106 ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000290s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659039,659049,200078,310106) ORDER BY `id` DESC [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `yf_work_share` [ RunTime:0.000571s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 175 LIMIT 6 [ RunTime:0.000252s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 145 LIMIT 6 [ RunTime:0.000234s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 173 LIMIT 6 [ RunTime:0.000202s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 154 LIMIT 6 [ RunTime:0.000213s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 158 LIMIT 6 [ RunTime:0.000200s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 180 LIMIT 6 [ RunTime:0.000212s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 168 LIMIT 6 [ RunTime:0.000217s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 252 LIMIT 6 [ RunTime:0.000201s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 167 LIMIT 6 [ RunTime:0.000230s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 149 LIMIT 6 [ RunTime:0.000226s ]
SELECT COUNT(*) AS think_count FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000194s ]
SELECT * FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 50,10 [ RunTime:0.000714s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,200122,310115) ORDER BY `id` DESC [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `yf_gw` [ RunTime:0.000578s ]
SELECT *,value_name as text FROM `yf_gw` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `yf_zj` [ RunTime:0.000520s ]
SELECT *,value_name as text FROM `yf_zj` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `yf_metro` [ RunTime:0.000496s ]
SELECT * FROM `yf_metro` WHERE `pid` = 0 AND `status` = 1 AND `city` = 'sh' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000308s ]
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.000339s ]
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.000509s ]