精品套餐

基本文件流程错误 SQL 调试

SHOW COLUMNS FROM `wp_systerm` [ RunTime:0.0006s ]
SELECT `name`,`value` FROM `wp_systerm` [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_order_info` [ RunTime:0.0010s ]
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.0008s ]
UPDATE `wp_goods` SET `is_promote`='0' WHERE `promote_end_date` < 1745621597 AND `is_promote` = 1 [ RunTime:0.0004s ]
UPDATE `wp_goods` SET `promote_price`='0' WHERE `promote_end_date` < 1745621597 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_start_date`='0' WHERE `promote_end_date` < 1745621597 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_end_date`='0' WHERE `promote_end_date` < 1745621597 AND `is_promote` = 1 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_ad_info` [ RunTime:0.0004s ]
SELECT * FROM `wp_ad_info` WHERE `classify_id` = 1 AND `is_font` = '0' AND `status` = '1' ORDER BY sequence desc,id asc [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_nav` [ RunTime:0.0004s ]
SELECT `nav_name`,`url`,`id` FROM `wp_nav` WHERE `parent_id` = 0 AND `status` = '1' AND `type` = 'bottom' AND `classify` = 'mobile' 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` = 'top' AND `classify` = 'mobile' ORDER BY sequence desc,id asc [ RunTime:0.0000s ]
SELECT * FROM `wp_ad_info` WHERE `classify_id` = 18 AND `is_font` = '0' AND `status` = '1' ORDER BY sequence desc,id asc [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_goods` [ RunTime:0.0007s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0005s ]
SELECT * FROM `wp_category` WHERE `status` = 1 AND `classify_id` = 6 LIMIT 1 [ RunTime:0.0001s ]
SELECT * FROM `wp_category` WHERE `status` = 1 ORDER BY sequence desc,classify_id asc [ RunTime:0.0001s ]
SELECT * FROM `wp_category` WHERE `status` = 1 ORDER BY sequence desc,classify_id asc [ RunTime:0.0000s ]
SELECT goods_id FROM wp_goods_cat AS g WHERE g.classify_id IN ('6') [ RunTime:0.0000s ]
SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM wp_brand AS b, wp_goods AS g LEFT JOIN wp_goods_cat AS gc ON g.goods_id = gc.goods_id WHERE g.brand_id = b.brand_id AND (g.classify_id IN ('6') OR g.goods_id IN ('') ) AND b.status = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY b.sequence, b.brand_id DESC [ RunTime:0.0010s ]
SELECT goods_id FROM wp_goods_cat AS g WHERE g.classify_id IN ('6') [ RunTime:0.0000s ]
SELECT COUNT(*) AS tp_count FROM wp_goods g inner join wp_category as c on c.classify_id = g.classify_id WHERE ( 1=1 AND g.status =1 AND supplier_status=1 AND is_on_sale =1 AND is_delete =0 AND (g.classify_id IN (6) OR g.goods_id IN ('') ) ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM wp_goods g left join wp_category as c on c.classify_id = g.classify_id WHERE ( 1=1 AND g.status =1 AND supplier_status=1 AND is_on_sale =1 AND is_delete =0 AND (g.classify_id IN (6) OR g.goods_id IN ('') ) ) ORDER BY g.sequence ASC LIMIT 0,12 [ RunTime:0.0004s ]
SELECT * FROM `wp_category` ORDER BY sequence desc,classify_id asc [ RunTime:0.0001s ]