SHOW COLUMNS FROM `demo_site_setting` [ RunTime:0.0014s ]
SELECT `item`,`value` FROM `demo_site_setting` [ RunTime:0.0011s ]
SHOW COLUMNS FROM `demo_mobile_setting` [ RunTime:0.0017s ]
SELECT `value` FROM `demo_mobile_setting` WHERE ( item="m_site_theme" ) LIMIT 1 [ RunTime:0.0018s ]
SHOW COLUMNS FROM `demo_nav` [ RunTime:0.0017s ]
SELECT * FROM `demo_nav` WHERE ( status=1 and display_type in (1,3) ) [ RunTime:0.0171s ]
SELECT `id`,`name`,`type`,`display_type`,`module_id`,`class_id`,`path`,`open_type`,`link_type`,`link_url` FROM `demo_nav` WHERE ( status=1 ) ORDER BY sort desc,id asc [ RunTime:0.0010s ]
SELECT * FROM `demo_nav` WHERE ( status=1 and display_type in (2,3) ) [ RunTime:0.0014s ]
SHOW COLUMNS FROM `demo_textblock` [ RunTime:0.0013s ]
SELECT `name`,`content`,`desc` FROM `demo_textblock` WHERE ( status=1 and scense="pc" ) [ RunTime:0.0014s ]
SHOW COLUMNS FROM `demo_listblock` [ RunTime:0.0016s ]
SELECT * FROM `demo_listblock` WHERE ( status=1 and scense="pc" ) [ RunTime:0.0014s ]
SHOW COLUMNS FROM `demo_service` [ RunTime:0.0014s ]
SELECT * FROM `demo_service` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0010s ]
SHOW COLUMNS FROM `demo_ad` [ RunTime:0.0022s ]
SELECT `class_id`,`picurl`,`url`,`picdesc`,`picname` FROM `demo_ad` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0015s ]
SHOW COLUMNS FROM `demo_product` [ RunTime:0.0015s ]
SELECT `id`,`name`,`picurl` FROM `demo_product` WHERE ( status=1 and isrecommend=1 ) ORDER BY sort desc LIMIT 0,4 [ RunTime:0.0033s ]
SHOW COLUMNS FROM `demo_children` [ RunTime:0.0020s ]
SELECT * FROM `demo_children` WHERE ( status=1 ) ORDER BY sort desc,id desc [ RunTime:0.0010s ]
SHOW COLUMNS FROM `demo_keywords_list` [ RunTime:0.0012s ]
SELECT `name` FROM `demo_keywords_list` WHERE ( hot_status=1 ) [ RunTime:0.0011s ]
SELECT `name` FROM `demo_keywords_list` WHERE ( tag_status=1 ) [ RunTime:0.0010s ]
SHOW COLUMNS FROM `demo_link` [ RunTime:0.0016s ]
SELECT * FROM `demo_link` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0010s ]
SHOW COLUMNS FROM `demo_message` [ RunTime:0.0014s ]
SELECT COUNT(*) AS tp_count FROM `demo_message` WHERE ( isread=0 ) LIMIT 1 [ RunTime:0.0010s ]
SELECT * FROM `demo_product` ORDER BY sort desc [ RunTime:0.0011s ]
SHOW COLUMNS FROM `demo_region` [ RunTime:0.0017s ]
SELECT `alias`,`name` FROM `demo_region` [ RunTime:0.0013s ]
SHOW COLUMNS FROM `demo_region` [ RunTime:0.0023s ]
SELECT * FROM `demo_region` [ RunTime:0.0010s ]
SELECT * FROM `demo_product` WHERE ( id=10 ) LIMIT 1 [ RunTime:0.0029s ]
SELECT `id`,`name` FROM `demo_product` WHERE ( id<10 ) ORDER BY id desc LIMIT 1 [ RunTime:0.0020s ]
SELECT `id`,`name` FROM `demo_product` WHERE ( id>10 ) LIMIT 1 [ RunTime:0.0047s ]
SHOW COLUMNS FROM `demo_product_class` [ RunTime:0.0015s ]
SELECT * FROM `demo_product_class` WHERE ( id=2 ) LIMIT 1 [ RunTime:0.0011s ]
SELECT `value` FROM `demo_site_setting` WHERE ( item="site_keywords" ) LIMIT 1 [ RunTime:0.0017s ]
SELECT `value` FROM `demo_site_setting` WHERE ( item="site_description" ) LIMIT 1 [ RunTime:0.0011s ]
SELECT * FROM `demo_nav` WHERE ( id=0 ) LIMIT 1 [ RunTime:0.0011s ]
SELECT * FROM `demo_nav` WHERE ( type=5 ) LIMIT 1 [ RunTime:0.0018s ]
SELECT * FROM `demo_nav` WHERE ( status=1 and concat(path,",") like "0,157,%" ) ORDER BY concat(path,",",id),sort [ RunTime:0.0010s ]
SELECT `value` FROM `demo_site_setting` WHERE ( item="site_relate_product_num" ) LIMIT 1 [ RunTime:0.0010s ]
SELECT `value` FROM `demo_site_setting` WHERE ( item="site_relate_news_num" ) LIMIT 1 [ RunTime:0.0016s ]
SELECT `id`,`name`,`picurl` FROM `demo_product` WHERE ( class_id=2 and id<>10 and status=1 ) ORDER BY rand() LIMIT 5 [ RunTime:0.0018s ]
SHOW COLUMNS FROM `demo_news` [ RunTime:0.0014s ]
SELECT `id`,`name` FROM `demo_news` WHERE ( status=1 ) ORDER BY rand() LIMIT 2 [ RunTime:0.0038s ]
UPDATE `demo_product` SET `readnum`=readnum+1 WHERE ( id=10 ) [ RunTime:0.0042s ]
SHOW COLUMNS FROM `demo_link` [ RunTime:0.0015s ]
SELECT * FROM `demo_link` WHERE ( status=1 ) ORDER BY sort desc LIMIT 0,10 [ RunTime:0.0010s ]