美景舒适家--成都地暖,成都中央空调专业安装公司

基本文件流程错误 SQL 调试

SHOW COLUMNS FROM `wp_systerm` [ RunTime:0.0004s ]
SELECT `name`,`value` FROM `wp_systerm` [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_order_info` [ RunTime:0.0005s ]
SELECT * FROM `wp_order_info` WHERE `order_status` = 5 AND `shipping_status` = 1 AND `pay_status` = 2 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_goods` [ RunTime:0.0004s ]
UPDATE `wp_goods` SET `is_promote`='0' WHERE `promote_end_date` < 1732194772 AND `is_promote` = 1 [ RunTime:0.0002s ]
UPDATE `wp_goods` SET `promote_price`='0' WHERE `promote_end_date` < 1732194772 AND `is_promote` = 1 [ RunTime:0.0001s ]
UPDATE `wp_goods` SET `promote_start_date`='0' WHERE `promote_end_date` < 1732194772 AND `is_promote` = 1 [ RunTime:0.0001s ]
UPDATE `wp_goods` SET `promote_end_date`='0' WHERE `promote_end_date` < 1732194772 AND `is_promote` = 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_nav` [ RunTime:0.0002s ]
SELECT `nav_name`,`url`,`id` FROM `wp_nav` WHERE `parent_id` = 0 AND `status` = '1' AND `type` = 'top' AND `classify` = 'pc' ORDER BY sequence desc,id asc [ RunTime:0.0000s ]
SELECT `nav_name`,`url`,`id` FROM `wp_nav` WHERE `parent_id` = 0 AND `status` = '1' AND `type` = 'bottom' AND `classify` = 'pc' ORDER BY sequence desc,id asc [ RunTime:0.0000s ]
SELECT `value` FROM `wp_systerm` WHERE `name` = 'shop_address' LIMIT 1 [ RunTime:0.0000s ]
SELECT `value` FROM `wp_systerm` WHERE `name` = 'icp_number' LIMIT 1 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_ad_info` [ RunTime:0.0002s ]
SELECT * FROM `wp_ad_info` WHERE `status` = '1' AND `classify_id` = 20 AND `is_font` = '1' [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_goods` [ RunTime:0.0004s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0002s ]
SELECT * FROM `wp_category` ORDER BY sequence desc,classify_id asc [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_brand` [ RunTime:0.0002s ]
SELECT * FROM `wp_brand` WHERE `status` = 1 AND `brand_classify_id` = 12 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_house_area` [ RunTime:0.0002s ]
SELECT * FROM `wp_house_area` [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_offer_template` [ RunTime:0.0002s ]
SELECT * FROM `wp_offer_template` WHERE `type` = 2 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_ad_info` [ RunTime:0.0002s ]
SELECT * FROM `wp_ad_info` WHERE `classify_id` = 42 AND `is_font` = '0' AND `status` = '1' ORDER BY sequence desc,id asc [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0002s ]
SELECT * FROM `wp_category` WHERE `classify_id` = 12 LIMIT 1 [ RunTime:0.0000s ]
SELECT COUNT(*) AS tp_count FROM wp_goods a WHERE `classify_id` = 12 AND `status` = 1 AND `is_on_sale` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.0002s ]
SELECT a.goods_id,a.goods_name,a.goods_thumb,a.goods_thumb1,a.goods_thumb2,a.goods_desc FROM wp_goods a WHERE `classify_id` = 12 AND `status` = 1 AND `is_on_sale` = 1 AND `is_delete` = 0 ORDER BY a.create_time desc LIMIT 0,10 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_article` [ RunTime:0.0003s ]
SELECT * FROM `wp_article` WHERE `status` = '1' AND `is_delete` = 0 ORDER BY create_time desc LIMIT 10 [ RunTime:0.0004s ]
SHOW COLUMNS FROM `wp_case` [ RunTime:0.0003s ]
SELECT * FROM `wp_case` WHERE `status` = '1' AND `is_delete` = 0 LIMIT 10 [ RunTime:0.0001s ]
SELECT * FROM `wp_ad_info` WHERE `classify_id` = 41 AND `is_font` = '0' AND `status` = '1' ORDER BY sequence desc,id asc [ RunTime:0.0000s ]

品牌	全部	更多 ∨