SHOW FULL COLUMNS FROM `yf_nav` [ RunTime:0.000634s ]
SELECT * FROM `yf_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000339s ]
SHOW FULL COLUMNS FROM `yf_set_city` [ RunTime:0.000568s ]
SELECT `shortname` FROM `yf_set_city` WHERE `id` = 310100 LIMIT 1 [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `yf_website_links` [ RunTime:0.000553s ]
SELECT * FROM `yf_website_links` WHERE `status` = 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `yf_office` [ RunTime:0.000692s ]
SELECT * FROM `yf_office` WHERE `status` = 2 AND `is_delete` = 0 AND `is_recommend` = 1 LIMIT 0,20 [ RunTime:0.000559s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659039,659089,659054,659047,201702,659040,659024,659048,659090,659021,659072,659032,659070,659059,200122,659075,310106,310105,310110,310115,310118,310104,310112,310101) ORDER BY `id` DESC [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `yf_office_share` [ RunTime:0.000835s ]
SELECT COUNT(*) AS think_count FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000759s ]
SELECT * FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 ORDER BY `update_time` DESC LIMIT 0,10 [ RunTime:0.000372s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659074,659088,659039,310152,659075,200083,659030,659049,659047,310105,310104,310106,310101,310109,310115) ORDER BY `id` DESC [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `yf_work_share` [ RunTime:0.000620s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 187 LIMIT 6 [ RunTime:0.000346s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 114 LIMIT 6 [ RunTime:0.000278s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 175 LIMIT 6 [ RunTime:0.000254s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 33 LIMIT 6 [ RunTime:0.000297s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 203 LIMIT 6 [ RunTime:0.000297s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 229 LIMIT 6 [ RunTime:0.000276s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 45 LIMIT 6 [ RunTime:0.000284s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 145 LIMIT 6 [ RunTime:0.000303s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 68 LIMIT 6 [ RunTime:0.000268s ]
SELECT `id`,`mianji`,`gongwei` FROM `yf_work_share` WHERE `status` = 2 AND `is_delete` = 0 AND `share_office_id` = 23 LIMIT 6 [ RunTime:0.000297s ]
SELECT * FROM `yf_office_share` WHERE `status` = 2 AND `is_delete` = 0 LIMIT 22,10 [ RunTime:0.000329s ]
SELECT `id`,shortname as name FROM `yf_set_city` WHERE `id` IN (310100,659030,659036,659076,659029,310152,310101) ORDER BY `id` DESC [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `yf_gw` [ RunTime:0.000560s ]
SELECT *,value_name as text FROM `yf_gw` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `yf_zj` [ RunTime:0.000644s ]
SELECT *,value_name as text FROM `yf_zj` ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `yf_metro` [ RunTime:0.000554s ]
SELECT * FROM `yf_metro` WHERE `pid` = 0 AND `status` = 1 AND `city` = 'sh' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000388s ]
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.000375s ]
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.001071s ]