show columns from `enshangneng_site_setting` [ runtime:0.0022s ]
select `item`,`value` from `enshangneng_site_setting` [ runtime:0.0005s ]
show columns from `enshangneng_mobile_setting` [ runtime:0.0016s ]
select `value` from `enshangneng_mobile_setting` where ( item="m_site_theme" ) limit 1 [ runtime:0.0003s ]
show columns from `enshangneng_nav` [ runtime:0.0021s ]
select * from `enshangneng_nav` where ( status=1 and display_type in (1,3) ) [ runtime:0.0008s ]
select `id`,`name`,`type`,`display_type`,`module_id`,`class_id`,`path`,`open_type`,`link_type`,`link_url` from `enshangneng_nav` where ( status=1 ) order by sort desc,id asc [ runtime:0.0007s ]
select `id`,`name`,`path`,`sort` from `enshangneng_nav` where ( status=1 and display_type in (2,3) ) order by concat(path,",",id) asc [ runtime:0.0004s ]
show columns from `enshangneng_textblock` [ runtime:0.0017s ]
select `name`,`content`,`desc` from `enshangneng_textblock` where ( status=1 and scense="pc" ) [ runtime:0.0017s ]
show columns from `enshangneng_listblock` [ runtime:0.0018s ]
select * from `enshangneng_listblock` where ( status=1 and scense="pc" ) [ runtime:0.0002s ]
show columns from `enshangneng_news_class` [ runtime:0.0012s ]
select `path` from `enshangneng_news_class` where ( id=27 ) limit 1 [ runtime:0.0003s ]
select `id` from `enshangneng_news_class` where ( concat(path,",") like "0,27,%" or id=27 ) [ runtime:0.0002s ]
show columns from `enshangneng_news` [ runtime:0.0016s ]
select * from `enshangneng_news` where ( status=1 and isrecommend=0 and class_id in (27) ) order by id desc limit 5 [ runtime:0.0002s ]
show columns from `enshangneng_nav` [ runtime:0.0014s ]
select `id` from `enshangneng_nav` where ( module_id = 4 and class_id = 27 ) limit 1 [ runtime:0.0002s ]
select `path` from `enshangneng_news_class` where ( id=28 ) limit 1 [ runtime:0.0002s ]
select `id` from `enshangneng_news_class` where ( concat(path,",") like "0,28,%" or id=28 ) [ runtime:0.0002s ]
select * from `enshangneng_news` where ( status=1 and isrecommend=0 and class_id in (28) ) order by id desc limit 5 [ runtime:0.0002s ]
show columns from `enshangneng_service` [ runtime:0.0022s ]
select * from `enshangneng_service` where ( status=1 ) order by sort desc [ runtime:0.0002s ]
show columns from `enshangneng_ad` [ runtime:0.0016s ]
select `class_id`,`picurl`,`picdesc`,`url` from `enshangneng_ad` where ( status=1 ) order by sort desc [ runtime:0.0004s ]
show columns from `enshangneng_keywords_list` [ runtime:0.0011s ]
select `name` from `enshangneng_keywords_list` where ( hot_status=1 ) [ runtime:0.0005s ]
select `name` from `enshangneng_keywords_list` where ( tag_status=1 ) [ runtime:0.0002s ]
show columns from `enshangneng_link` [ runtime:0.0021s ]
select * from `enshangneng_link` where ( status=1 ) order by sort desc [ runtime:0.0004s ]
show columns from `enshangneng_message` [ runtime:0.0021s ]
select count(*) as tp_count from `enshangneng_message` where ( isread=0 ) limit 1 [ runtime:0.0004s ]
select `value` from `enshangneng_site_setting` where ( item="site_num_news" ) limit 1 [ runtime:0.0084s ]
select count(*) as tp_count from `enshangneng_news` where ( status=1 and class_id=27 ) limit 1 [ runtime:0.0007s ]
select `id` from `enshangneng_news_class` where ( concat(path,",",id,",") like "%,27,%" ) [ runtime:0.0012s ]
select * from `enshangneng_news` where ( status=1 and class_id in (27) ) order by class_id,sort desc,id desc limit 0,20 [ runtime:0.0008s ]
select * from `enshangneng_nav` where ( id=77 ) limit 1 [ runtime:0.0004s ]
select * from `enshangneng_nav` where ( id in (0,76) ) [ runtime:0.0010s ]
select * from `enshangneng_nav` where ( id=77 ) limit 1 [ runtime:0.0002s ]
select * from `enshangneng_nav` where ( status=1 and concat(path,",") like "0,76,%" ) order by concat(path,",",id),sort [ runtime:0.0002s ]
select * from `enshangneng_news_class` where ( id=27 and content_status=1 ) limit 1 [ runtime:0.0005s ]