学知识-详情

基本文件流程错误 SQL 调试

SHOW COLUMNS FROM `wp_systerm` [ RunTime:0.0005s ]
SELECT `name`,`value` FROM `wp_systerm` [ RunTime:0.0001s ]
SHOW COLUMNS FROM `wp_order_info` [ RunTime:0.0011s ]
SELECT * FROM `wp_order_info` WHERE `order_status` = 5 AND `shipping_status` = 1 AND `pay_status` = 2 [ RunTime:0.0002s ]
SHOW COLUMNS FROM `wp_goods` [ RunTime:0.0009s ]
UPDATE `wp_goods` SET `is_promote`='0' WHERE `promote_end_date` < 1745619747 AND `is_promote` = 1 [ RunTime:0.0003s ]
UPDATE `wp_goods` SET `promote_price`='0' WHERE `promote_end_date` < 1745619747 AND `is_promote` = 1 [ RunTime:0.0002s ]
UPDATE `wp_goods` SET `promote_start_date`='0' WHERE `promote_end_date` < 1745619747 AND `is_promote` = 1 [ RunTime:0.0002s ]
UPDATE `wp_goods` SET `promote_end_date`='0' WHERE `promote_end_date` < 1745619747 AND `is_promote` = 1 [ RunTime:0.0003s ]
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.0002s ]
SHOW COLUMNS FROM `wp_nav` [ RunTime:0.0013s ]
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.0001s ]
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_article` [ RunTime:0.0005s ]
SHOW COLUMNS FROM `wp_article_classify` [ RunTime:0.0006s ]
SHOW COLUMNS FROM `wp_article_data` [ RunTime:0.0011s ]
SELECT COUNT(*) AS tp_count FROM `wp_article` WHERE ( id=4 ) LIMIT 1 [ RunTime:0.0006s ]
SELECT `id`,`status`,`title`,`classify_id`,`other_classify`,`is_delete`,`model_id`,`flag`,`sequence`,`click_number`,`author`,`is_seo`,`keywords`,`description`,`out_url`,`s_image`,`confirm`,`relation_id`,`water`,`create_time`,`end_time`,`recommend`,`prase_num` FROM `wp_article` WHERE `id` = 4 LIMIT 1 [ RunTime:0.0006s ]
SHOW COLUMNS FROM `wp_article_data` [ RunTime:0.0005s ]
SELECT `id`,`content`,`readpoint`,`groupids_view`,`template`,`allow_comment` FROM `wp_article_data` WHERE `id` = 4 LIMIT 1 [ RunTime:0.0000s ]
UPDATE `wp_article` SET `click_number`=click_number+1 WHERE ( id=4 ) [ RunTime:0.0003s ]
SHOW COLUMNS FROM `wp_category` [ RunTime:0.0004s ]
SELECT * FROM `wp_category` WHERE `status` = 1 ORDER BY sequence desc,classify_id asc [ RunTime:0.0011s ]
SELECT * FROM `wp_article_classify` WHERE ( classify_id=44 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT `parent_id` FROM `wp_article_classify` WHERE ( classify_id=44 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT * FROM `wp_article_classify` WHERE ( classify_id=43 ) LIMIT 1 [ RunTime:0.0000s ]
SELECT * FROM `wp_article_classify` WHERE ( parent_id=43 ) ORDER BY sequence desc,classify_id asc [ RunTime:0.0000s ]
SELECT * FROM `wp_article_classify` WHERE `status` = '1' AND `classify_id` = 44 LIMIT 1 [ RunTime:0.0000s ]
SELECT * FROM `wp_article_classify` WHERE `status` = '1' ORDER BY sequence desc,classify_id asc [ RunTime:0.0001s ]
SELECT * FROM `wp_article` WHERE ( classify_id in(44) and status='1' and id < 4 ) ORDER BY sequence desc,id desc LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `wp_article` WHERE ( classify_id in(44) and status='1' and id > 4 ) ORDER BY sequence asc,id asc LIMIT 1 [ RunTime:0.0016s ]
SELECT * FROM `wp_article` WHERE `recommend` = 1 [ RunTime:0.0003s ]