SHOW COLUMNS FROM `sjzdh_site_setting` [ RunTime:0.0018s ]
SELECT `item`,`value` FROM `sjzdh_site_setting` [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_mobile_setting` [ RunTime:0.0015s ]
SELECT `value` FROM `sjzdh_mobile_setting` WHERE ( item="m_site_theme" ) LIMIT 1 [ RunTime:0.0016s ]
SHOW COLUMNS FROM `sjzdh_nav` [ RunTime:0.0017s ]
SELECT * FROM `sjzdh_nav` WHERE ( status=1 and display_type in (1,3) ) [ RunTime:0.0026s ]
SELECT `id`,`name`,`type`,`display_type`,`module_id`,`class_id`,`path`,`open_type`,`link_type`,`link_url` FROM `sjzdh_nav` WHERE ( status=1 ) ORDER BY sort desc,id asc [ RunTime:0.0014s ]
SELECT * FROM `sjzdh_nav` WHERE ( status=1 and display_type in (2,3) ) [ RunTime:0.0019s ]
SHOW COLUMNS FROM `sjzdh_textblock` [ RunTime:0.0015s ]
SELECT `name`,`content`,`desc` FROM `sjzdh_textblock` WHERE ( status=1 and scense="pc" ) [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_listblock` [ RunTime:0.0016s ]
SELECT * FROM `sjzdh_listblock` WHERE ( status=1 and scense="pc" ) [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_news_class` [ RunTime:0.0016s ]
SELECT `path` FROM `sjzdh_news_class` WHERE ( id=28 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT `id` FROM `sjzdh_news_class` WHERE ( concat(path,",") like "0,28,%" or id=28 ) [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_news` [ RunTime:0.0017s ]
SELECT * FROM `sjzdh_news` WHERE ( status=1 and isrecommend=0 and class_id in (28) ) ORDER BY id desc LIMIT 5 [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_nav` [ RunTime:0.0016s ]
SELECT `id` FROM `sjzdh_nav` WHERE ( module_id = 4 and class_id = 28 ) LIMIT 1 [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_service` [ RunTime:0.0016s ]
SELECT * FROM `sjzdh_service` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_ad` [ RunTime:0.0015s ]
SELECT `class_id`,`picurl`,`url`,`picdesc`,`picname` FROM `sjzdh_ad` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_keywords_list` [ RunTime:0.0015s ]
SELECT `name` FROM `sjzdh_keywords_list` WHERE ( hot_status=1 ) [ RunTime:0.0013s ]
SELECT `name` FROM `sjzdh_keywords_list` WHERE ( tag_status=1 ) [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_link` [ RunTime:0.0015s ]
SELECT * FROM `sjzdh_link` WHERE ( status=1 ) ORDER BY sort desc [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_message` [ RunTime:0.0015s ]
SELECT COUNT(*) AS tp_count FROM `sjzdh_message` WHERE ( isread=0 ) LIMIT 1 [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_region` [ RunTime:0.0015s ]
SELECT `alias`,`name` FROM `sjzdh_region` [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_region` [ RunTime:0.0016s ]
SELECT * FROM `sjzdh_region` [ RunTime:0.0013s ]
SHOW COLUMNS FROM `sjzdh_product_class` [ RunTime:0.0016s ]
SELECT * FROM `sjzdh_product_class` WHERE ( pid=22 ) [ RunTime:0.0014s ]
SELECT `value` FROM `sjzdh_site_setting` WHERE ( item="site_num_product" ) LIMIT 1 [ RunTime:0.0013s ]
SELECT `id` FROM `sjzdh_product_class` WHERE ( concat(path,",",id,",") like "%,22,%" ) [ RunTime:0.0014s ]
SHOW COLUMNS FROM `sjzdh_product` [ RunTime:0.0019s ]
SELECT COUNT(*) AS tp_count FROM `sjzdh_product` WHERE ( (name like "%%" or tag like "%,,%") and status=1 and class_id in (22) and 1 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT `id` FROM `sjzdh_product_class` WHERE ( concat(path,",",id,",") like "%,22,%" ) [ RunTime:0.0013s ]
SELECT * FROM `sjzdh_product` WHERE ( (name like "%%" or tag like "%,,%") and status=1 and class_id in (22) and 1 ) ORDER BY class_id,sort desc,id desc LIMIT 0,6 [ RunTime:0.0029s ]
SELECT * FROM `sjzdh_nav` WHERE ( id=88 ) LIMIT 1 [ RunTime:0.0018s ]
SELECT * FROM `sjzdh_nav` WHERE ( id in (0,74) ) [ RunTime:0.0014s ]
SELECT `mls_ids` FROM `sjzdh_product` WHERE ( (name like "%%" or tag like "%,,%") and status=1 and class_id in (22) and 1 ) [ RunTime:0.0015s ]
SELECT * FROM `sjzdh_nav` WHERE ( id=88 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT * FROM `sjzdh_nav` WHERE ( status=1 and concat(path,",") like "0,74,%" ) ORDER BY concat(path,",",id),sort [ RunTime:0.0014s ]
SELECT * FROM `sjzdh_product_class` WHERE ( id=22 and content_status=1 ) LIMIT 1 [ RunTime:0.0014s ]
已有账号，立即登录
