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

基本文件流程错误 SQL 调试

SHOW COLUMNS FROM `wp_systerm` [ RunTime:0.0005s ]
SELECT `name`,`value` FROM `wp_systerm` [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_order_info` [ RunTime:0.0008s ]
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.0007s ]
UPDATE `wp_goods` SET `is_promote`='0' WHERE `promote_end_date` < 1733392527 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_price`='0' WHERE `promote_end_date` < 1733392527 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_start_date`='0' WHERE `promote_end_date` < 1733392527 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_end_date`='0' WHERE `promote_end_date` < 1733392527 AND `is_promote` = 1 [ RunTime:0.0002s ]
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` = 'top' AND `classify` = 'pc' ORDER BY sequence desc,id asc [ RunTime:0.0001s ]
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.0003s ]
SELECT * FROM `wp_ad_info` WHERE `status` = '1' AND `classify_id` = 20 AND `is_font` = '1' [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_goods` [ RunTime:0.0006s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0004s ]
SELECT `goods_id`,`status`,`supplier_type`,`supplier_id`,`supplier_status`,`supplier_status_txt`,`click_number`,`collect_number`,`brand_id`,`classify_id`,`goods_sn`,`goods_type`,`goods_name`,`goods_name_style`,`market_price`,`provider_name`,`goods_weight`,`goods_number`,`sale_number`,`shop_price`,`zhekou`,`is_promote`,`promote_flag`,`promote_price`,`promote_start_date`,`promote_end_date`,`cost_price`,`is_buy`,`buymax`,`limit_price`,`buymax_start_date`,`buymax_end_date`,`warn_number`,`keywords`,`goods_brief`,`goods_desc`,`goods_wap_desc`,`goods_thumb`,`goods_img`,`original_img`,`is_real`,`extension_code`,`is_on_sale`,`is_alone_sale`,`is_shipping`,`integral`,`is_delete`,`is_best`,`is_new`,`is_hot`,`bonus_type_id`,`last_update`,`seller_note`,`reword`,`rank_reword`,`is_check`,`is_catindex`,`valid_date`,`is_virtual`,`create_time`,`end_time`,`sequence`,`indexsequence`,`description`,`attr_id`,`goods_thumb1`,`goods_thumb2`,`pattern1`,`norm`,`features`,`quantity`,`unit`,`place`,`norm_desc`,`match_product`,`show_price`,`question`,`comment` FROM `wp_goods` WHERE `status` = 1 AND `supplier_status` = 1 AND `is_on_sale` = 1 AND `is_delete` = 0 AND `goods_id` = 42 LIMIT 1 [ RunTime:0.0003s ]
SHOW COLUMNS FROM `wp_brand` [ RunTime:0.0004s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=18 ) LIMIT 1 [ RunTime:0.0001s ]
UPDATE `wp_goods` SET `click_number`=click_number+1 WHERE ( goods_id=42 ) [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_order_goods` [ RunTime:0.0005s ]
SELECT COUNT(*) AS tp_count FROM wp_order_goods a INNER JOIN wp_order_info as b on a.order_id = b.order_id INNER JOIN wp_member as c on b.mem_id = c.id WHERE ( b.pay_status = 2 and a.goods_id = 42 and a.extension_code='' ) LIMIT 1 [ RunTime:0.0001s ]
SELECT * FROM `wp_goods` WHERE `supplier_id` = 0 AND `is_best` = 1 AND `status` = 1 AND `supplier_status` = 1 AND `is_on_sale` = 1 AND `is_delete` = 0 AND `is_alone_sale` = 1 AND `goods_id` <> '42' ORDER BY sequence desc,goods_id desc LIMIT 3 [ RunTime:0.0008s ]
SHOW COLUMNS FROM `wp_photo_album` [ RunTime:0.0005s ]
SELECT * FROM `wp_photo_album` WHERE ( goods_id=42 ) ORDER BY sequence asc [ RunTime:0.0001s ]
SELECT COUNT(*) AS tp_count FROM `wp_goods` WHERE `status` = 1 AND `is_new` = 1 AND `supplier_status` = 1 AND `goods_id` <> '42' LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `wp_goods` WHERE `status` = 1 AND `is_new` = 1 AND `supplier_status` = 1 AND `goods_id` <> '42' ORDER BY sequence desc,goods_id desc LIMIT 0,10 [ RunTime:0.0004s ]
SHOW COLUMNS FROM `wp_supplier_shop_config` [ RunTime:0.0005s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=19 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=17 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=17 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=18 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=18 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=18 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=21 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=29 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `shop_name` FROM `wp_supplier_shop_config` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT `brand_name` FROM `wp_brand` WHERE ( brand_id=0 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT * FROM `wp_category` WHERE `status` = 1 ORDER BY sequence desc,classify_id asc [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_shaidan` [ RunTime:0.0004s ]
SELECT COUNT(*) AS tp_count FROM wp_shaidan a INNER JOIN wp_member as b on a.mem_id = b.id INNER JOIN wp_order_goods as c on a.car_id = c.car_id WHERE ( a.status = '1' and a.content is not null and a.content <> '' and a.goods_id = 42 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT a.*,b.username,c.goods_number FROM wp_shaidan a INNER JOIN wp_member as b on a.mem_id = b.id INNER JOIN wp_order_goods as c on a.car_id = c.car_id WHERE ( a.status = '1' and a.content is not null and a.content <> '' and a.goods_id = 42 ) GROUP BY a.shaidan_id ORDER BY a.create_time desc LIMIT 0,10 [ RunTime:0.0001s ]
SELECT COUNT(*) AS tp_count FROM wp_order_goods a INNER JOIN wp_order_info as b on a.order_id = b.order_id INNER JOIN wp_member as c on b.mem_id = c.id WHERE ( b.pay_status = 2 and a.goods_id = 42 and a.extension_code='' ) LIMIT 1 [ RunTime:0.0000s ]
SELECT a.goods_name,a.goods_number,b.create_time,c.username,a.goods_attr FROM wp_order_goods a INNER JOIN wp_order_info as b on a.order_id = b.order_id INNER JOIN wp_member as c on b.mem_id = c.id WHERE ( b.pay_status = 2 and a.goods_id = 42 and a.extension_code='' ) ORDER BY a.create_time desc LIMIT 0,2 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_goods_type` [ RunTime:0.0003s ]
SELECT `attr_group` FROM wp_goods_type gt INNER JOIN wp_goods as g on gt.cat_id=g.goods_type WHERE ( g.goods_id=42 ) LIMIT 1 [ RunTime:0.0001s ]
SELECT a.attr_id, a.attr_name, a.attr_group, a.is_linked, a.attr_type,a.attr_input_type,g.goods_attr_id, g.attr_value, g.attr_price ,g.attr_price1 FROM wp_goods_attr AS g inner JOIN wp_goods_attribute AS a ON a.attr_id = g.attr_id WHERE g.goods_id = '42' ORDER BY a.sort_order desc, g.attr_price, g.goods_attr_id [ RunTime:0.0001s ]
select goods_attr from wp_products where product_number>0 and goods_id='42' order by goods_attr [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_photo_album` [ RunTime:0.0003s ]
SELECT * FROM `wp_photo_album` WHERE `goods_id` = 42 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_ad_info` [ RunTime:0.0004s ]
SELECT * FROM `wp_ad_info` WHERE `classify_id` = 44 AND `is_font` = '0' AND `status` = '1' ORDER BY sequence desc,id asc [ RunTime:0.0001s ]
SELECT * FROM `wp_goods` WHERE `status` = 1 AND `is_best` = 1 AND `is_delete` = 0 AND `classify_id` = 1 ORDER BY goods_id desc LIMIT 4 [ RunTime:0.0003s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0004s ]
SELECT * FROM `wp_category` WHERE `classify_id` = 1 LIMIT 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_article` [ RunTime:0.0004s ]
SELECT * FROM `wp_article` INNER JOIN wp_article_data on wp_article_data.id=wp_article.id WHERE `classify_id` = '41' [ RunTime:0.0004s ]
SELECT * FROM `wp_systerm` WHERE `id` = 115 LIMIT 1 [ RunTime:0.0000s ]
SELECT * FROM `wp_systerm` WHERE `id` = 1107 LIMIT 1 [ RunTime:0.0000s ]
SHOW COLUMNS FROM `wp_supplier` [ RunTime:0.0006s ]
SELECT * FROM `wp_supplier` WHERE ( supplier_id=0 ) LIMIT 1 [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_look_log` [ RunTime:0.0003s ]

常见问题