28 | 8414.30.8030 |
福利1:入资深讲师答疑群
福利2:领取32G外贸干货包
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-12-21 12:09:46 HTTP/2.0 GET : https://demo.ixinguwen.com/articles/159.html
- 运行时间 : 0.170924s [ 吞吐率:5.85req/s ] 内存消耗:6,101.04kb 文件加载:180
- 查询信息 : 99 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=1014d27fc2117c3ce70e5350c49a6158
- CONNECT:[ UseTime:0.008150s ] mysql:host=127.0.0.1;port=3306;dbname=xinguwen2;charset=utf8
- SHOW FULL COLUMNS FROM `xgw_url_beautify` [ RunTime:0.001008s ]
- SELECT * FROM `xgw_url_beautify` WHERE `app` = 'home' AND `status` = 1 AND `type` IN (2,3,4) [ RunTime:0.002181s ]
- SHOW FULL COLUMNS FROM `xgw_coupon` [ RunTime:0.000947s ]
- SELECT `id`,`full_deduction`,`nums`,`curact`,`type`,`use_conditions_type`,`use_full_deduction`,`use_endtime`,`use_starttime` FROM `xgw_coupon` WHERE `type` = 1 AND `is_home` = 1 AND `starttime` <= 1766290186 AND `endtime` >= 1766290186 AND `delete_time` IS NULL ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000214s ]
- SHOW FULL COLUMNS FROM `xgw_hot_search` [ RunTime:0.000837s ]
- SELECT `id`,`name`,`link`,`link_type`,`link_id` FROM `xgw_hot_search` WHERE ( `status` = 1 AND `delete_time` IS NULL ) AND `xgw_hot_search`.`delete_time` IS NULL ORDER BY `weigh` DESC,`id` DESC LIMIT 12 [ RunTime:0.000195s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.000194s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 13 LIMIT 1 [ RunTime:0.000953s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 108 LIMIT 1 [ RunTime:0.000174s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 107 LIMIT 1 [ RunTime:0.000149s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000141s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 267 LIMIT 1 [ RunTime:0.000134s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 229 LIMIT 1 [ RunTime:0.000137s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 73 LIMIT 1 [ RunTime:0.000138s ]
- SHOW FULL COLUMNS FROM `xgw_links` [ RunTime:0.004215s ]
- SELECT * FROM `xgw_links` WHERE `status` = '1' AND `delete_time` IS NULL ORDER BY `weigh` DESC [ RunTime:0.001470s ]
- SHOW FULL COLUMNS FROM `xgw_invitation` [ RunTime:0.002678s ]
- SELECT * FROM `xgw_invitation` WHERE `status` = 2 LIMIT 1 [ RunTime:0.000246s ]
- SHOW FULL COLUMNS FROM `xgw_article` [ RunTime:0.000998s ]
- SHOW FULL COLUMNS FROM `xgw_article_classify` [ RunTime:0.000855s ]
- SHOW FULL COLUMNS FROM `xgw_course` [ RunTime:0.001853s ]
- SELECT `category_id`,`name` FROM `xgw_article_classify` ORDER BY `weigh` DESC,`category_id` DESC [ RunTime:0.000536s ]
- SELECT `actual_views` FROM `xgw_article` WHERE `id` = 159 LIMIT 1 [ RunTime:0.000632s ]
- UPDATE `xgw_article` SET `actual_views` = 2475 , `update_time` = 1766290186 WHERE `id` = 159 [ RunTime:0.002115s ]
- SHOW FULL COLUMNS FROM `xgw_play_log_article` [ RunTime:0.000788s ]
- SELECT * FROM `xgw_play_log_article` WHERE `article_id` = 159 AND `user_id` = 0 LIMIT 1 [ RunTime:0.002380s ]
- UPDATE `xgw_play_log_article` SET `update_time` = 1766290186 WHERE `article_id` = 159 AND `user_id` = 0 [ RunTime:0.000827s ]
- SELECT * FROM `xgw_article` WHERE `id` IN (=,159) AND `status` IN (=,2) AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000794s ]
- SELECT `id`,`title` FROM `xgw_article` WHERE `id` = 0 ORDER BY `weigh` DESC,`id` DESC LIMIT 6 [ RunTime:0.001250s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 9 LIMIT 1 [ RunTime:0.002735s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.001715s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000201s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 111 LIMIT 1 [ RunTime:0.013125s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 8 LIMIT 1 [ RunTime:0.001283s ]
- SHOW FULL COLUMNS FROM `xgw_course_video` [ RunTime:0.001675s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000193s ]
- SHOW FULL COLUMNS FROM `xgw_play_log_video` [ RunTime:0.000792s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1448,44,108,41,42,107,40,250,251,252,270,271,272,273,274,275,276,277,287) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000240s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000158s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1448 LIMIT 1 [ RunTime:0.000142s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000203s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000165s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1448,44,108,41,42,107,40,250,251,252,270,271,272,273,274,275,276,277,287) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000193s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 13 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000167s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1448 LIMIT 1 [ RunTime:0.000148s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000181s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000186s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1986,1990,1994,1998,2002,2006,2010,2014,2018,2022,2026,2030,2034,2038,2094,2099,382,2039,344,345,346,347,1197,1198,1199,1200,1201,1203,1814,1818,1822,1826,1830,1834,1838,1850,1845,1849,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000368s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000202s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2014 LIMIT 1 [ RunTime:0.000140s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000201s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000206s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1986,1990,1994,1998,2002,2006,2010,2014,2018,2022,2026,2030,2034,2038,2094,2099,382,2039,344,345,346,347,1197,1198,1199,1200,1201,1203,1814,1818,1822,1826,1830,1834,1838,1850,1845,1849,1861,1862,1863,1864,1865,1866,1867,1868,1869,1870) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000314s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 108 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000199s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2014 LIMIT 1 [ RunTime:0.000143s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000213s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000222s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (2209,2206,2207,2205,2208,1645,1646,1647,1648,1649,1650,1651,1652) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000184s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000209s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2209 LIMIT 1 [ RunTime:0.000198s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000160s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.001067s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (2209,2206,2207,2205,2208,1645,1646,1647,1648,1649,1650,1651,1652) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000201s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 107 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000212s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 2209 LIMIT 1 [ RunTime:0.000174s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000166s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000827s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000165s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 2 AND `prim_id` = 57 LIMIT 1 [ RunTime:0.000204s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000206s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000181s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000266s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000193s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1495 LIMIT 1 [ RunTime:0.000182s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000188s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000206s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000241s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 267 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000206s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1495 LIMIT 1 [ RunTime:0.000172s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000227s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000199s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1466,126,179,180,181,182,183,185,184,137,189,138,127,195,196,197,198,199,200,215,227,228,229,230,264,265,266,267,268,269) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000303s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000196s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1466 LIMIT 1 [ RunTime:0.000145s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000157s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000163s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1466,126,179,180,181,182,183,185,184,137,189,138,127,195,196,197,198,199,200,215,227,228,229,230,264,265,266,267,268,269) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000220s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 229 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000158s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1466 LIMIT 1 [ RunTime:0.000152s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000172s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000154s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1455,307,309,310,311,308,312) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000169s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000152s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1455 LIMIT 1 [ RunTime:0.000148s ]
- SELECT * FROM `xgw_hot_search` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000166s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000154s ]
- SELECT `course_id`,`video_id` FROM `xgw_play_log_video` WHERE `video_id` IN (1455,307,309,310,311,308,312) AND `user_id` = 0 ORDER BY `update_time` DESC,`create_time` DESC,`id` DESC LIMIT 1 [ RunTime:0.000169s ]
- SELECT `id` FROM `xgw_course_video` WHERE ( `course_id` = 73 AND `status` = 2 AND `is_free` = 1 ) AND `xgw_course_video`.`delete_time` IS NULL ORDER BY `weigh` ASC [ RunTime:0.000160s ]
- SELECT `url_beautify` FROM `xgw_url_beautify` WHERE `type` = 4 AND `prim_id` = 1455 LIMIT 1 [ RunTime:0.000147s ]

0.172315s
|