show columns from `shengjiu_site_setting` [ runtime:0.0108s ]
select `item`,`value` from `shengjiu_site_setting` [ runtime:0.0008s ]
show columns from `shengjiu_mobile_setting` [ runtime:0.0011s ]
select `value` from `shengjiu_mobile_setting` where ( item="m_site_theme" ) limit 1 [ runtime:0.0002s ]
show columns from `shengjiu_nav` [ runtime:0.0043s ]
select * from `shengjiu_nav` where ( status=1 and display_type in (1,3) ) [ runtime:0.0012s ]
select `id`,`name`,`type`,`display_type`,`module_id`,`class_id`,`path`,`open_type`,`link_type`,`link_url` from `shengjiu_nav` where ( status=1 ) order by sort desc,id asc [ runtime:0.0011s ]
select * from `shengjiu_nav` where ( status=1 and display_type in (2,3) ) [ runtime:0.0026s ]
show columns from `shengjiu_textblock` [ runtime:0.0093s ]
select `name`,`content`,`desc` from `shengjiu_textblock` where ( status=1 and scense="pc" ) [ runtime:0.0012s ]
show columns from `shengjiu_listblock` [ runtime:0.0069s ]
select * from `shengjiu_listblock` where ( status=1 and scense="pc" ) [ runtime:0.0027s ]
show columns from `shengjiu_service` [ runtime:0.0045s ]
select * from `shengjiu_service` where ( status=1 ) order by sort desc [ runtime:0.0003s ]
show columns from `shengjiu_ad` [ runtime:0.0016s ]
select `class_id`,`picurl`,`url`,`picdesc`,`picname` from `shengjiu_ad` where ( status=1 ) order by sort desc [ runtime:0.0009s ]
show columns from `shengjiu_product` [ runtime:0.0040s ]
select `id`,`name`,`picurl` from `shengjiu_product` where ( status=1 and isrecommend=1 ) order by sort desc limit 0,3 [ runtime:0.0038s ]
show columns from `shengjiu_children` [ runtime:0.0025s ]
select * from `shengjiu_children` where ( status=1 ) order by sort desc,id desc [ runtime:0.0011s ]
show columns from `shengjiu_keywords_list` [ runtime:0.0022s ]
select `name` from `shengjiu_keywords_list` where ( hot_status=1 ) [ runtime:0.0002s ]
select `name` from `shengjiu_keywords_list` where ( tag_status=1 ) [ runtime:0.0030s ]
show columns from `shengjiu_link` [ runtime:0.0012s ]
select * from `shengjiu_link` where ( status=1 ) order by sort desc [ runtime:0.0004s ]
show columns from `shengjiu_message` [ runtime:0.0050s ]
select count(*) as tp_count from `shengjiu_message` where ( isread=0 ) limit 1 [ runtime:0.0019s ]
select * from `shengjiu_product` order by sort desc [ runtime:0.0684s ]
show columns from `shengjiu_region` [ runtime:0.0114s ]
select `alias`,`name` from `shengjiu_region` [ runtime:0.0003s ]
show columns from `shengjiu_region` [ runtime:0.0019s ]
select * from `shengjiu_region` [ runtime:0.0003s ]
select * from `shengjiu_product` where ( id=883 ) limit 1 [ runtime:0.0025s ]
select `id`,`name` from `shengjiu_product` where ( id<883 ) order by id desc limit 1 [ runtime:0.0006s ]
select `id`,`name` from `shengjiu_product` where ( id>883 ) limit 1 [ runtime:0.0004s ]
show columns from `shengjiu_product_class` [ runtime:0.0019s ]
select * from `shengjiu_product_class` where ( id=53 ) limit 1 [ runtime:0.0017s ]
select `value` from `shengjiu_site_setting` where ( item="site_keywords" ) limit 1 [ runtime:0.0031s ]
select * from `shengjiu_nav` where ( id=144 ) limit 1 [ runtime:0.0006s ]
select * from `shengjiu_nav` where ( id in (0,74,89) ) [ runtime:0.0002s ]
select * from `shengjiu_nav` where ( id=144 ) limit 1 [ runtime:0.0002s ]
select * from `shengjiu_nav` where ( status=1 and concat(path,",") like "0,74,%" ) order by concat(path,",",id),sort [ runtime:0.0006s ]
select `value` from `shengjiu_site_setting` where ( item="site_relate_product_num" ) limit 1 [ runtime:0.0004s ]
select `value` from `shengjiu_site_setting` where ( item="site_relate_news_num" ) limit 1 [ runtime:0.0008s ]
select `id`,`name`,`picurl` from `shengjiu_product` where ( class_id=53 and id<>883 and status=1 ) order by rand() limit 5 [ runtime:0.0024s ]
show columns from `shengjiu_news` [ runtime:0.0018s ]
select `id`,`name` from `shengjiu_news` where ( status=1 ) order by rand() limit 2 [ runtime:0.0005s ]
update `shengjiu_product` set `readnum`=readnum 1 where ( id=883 ) [ runtime:0.0114s ]
