基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-18 13:48:54 HTTP/2.0 GET : https://haiyi.mifenlei.com/?res=LR2MkDIe
- 运行时间 : 2.500300s [ 吞吐率：0.40req/s ] 内存消耗：4,815.68kb 文件加载：151
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=3919ae31e15d3bc3fd97c155f0a530e4
- CONNECT:[ UseTime:0.015724s ] mysql:host=127.0.0.1;port=3306;dbname=youpin_mifenlei_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `my_ip` [ RunTime:0.013542s ]
- SELECT * FROM `my_ip` WHERE `ip` = '216.73.216.138' LIMIT 1 [ RunTime:0.014395s ]
- UPDATE `my_ip` SET `times` = '1779083335' , `method` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `view` = 2310948 , `url` = 'https://haiyi.mifenlei.com/?res=LR2MkDIe' WHERE `id` = 1374 [ RunTime:0.019114s ]
- DELETE FROM `my_ip` WHERE `open` = 1 AND `view` < 10 AND `time` < 1778737735 [ RunTime:0.016778s ]
- SHOW FULL COLUMNS FROM `my_set` [ RunTime:0.033149s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.016535s ]
- SHOW FULL COLUMNS FROM `my_diqu` [ RunTime:0.013202s ]
- SELECT * FROM `my_diqu` WHERE `id` = 511700000000 LIMIT 1 [ RunTime:0.014317s ]
- SHOW FULL COLUMNS FROM `my_hook` [ RunTime:0.018624s ]
- SELECT * FROM `my_hook` WHERE `name` = 'indexindex' LIMIT 1 [ RunTime:0.010768s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.024104s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.018738s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.016476s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.017762s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000744s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.016017s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.023024s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.024873s ]
- SHOW FULL COLUMNS FROM `my_model` [ RunTime:0.015065s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4 [ RunTime:0.017232s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4,30 [ RunTime:0.041406s ]
- SHOW FULL COLUMNS FROM `my_article` [ RunTime:0.024119s ]
- SELECT * FROM `my_article` WHERE `open` = 1 AND `settop` = 1 ORDER BY `times` DESC LIMIT 10 [ RunTime:0.013854s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.000382s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `view` DESC LIMIT 5 [ RunTime:0.005374s ]
- SELECT * FROM `my_model` WHERE `open` = 1 [ RunTime:0.006027s ]
- SHOW FULL COLUMNS FROM `my_pinche` [ RunTime:0.012603s ]
- SHOW FULL COLUMNS FROM `my_zhaopin` [ RunTime:0.023409s ]
- SHOW FULL COLUMNS FROM `my_fang` [ RunTime:0.026390s ]
- SHOW FULL COLUMNS FROM `my_zhuanrang` [ RunTime:0.019409s ]
- SHOW FULL COLUMNS FROM `my_zhuangxiu` [ RunTime:0.012698s ]
- SHOW FULL COLUMNS FROM `my_ershou` [ RunTime:0.012181s ]
- SHOW FULL COLUMNS FROM `my_che` [ RunTime:0.002113s ]
- SHOW FULL COLUMNS FROM `my_fuwu` [ RunTime:0.032942s ]
- SHOW FULL COLUMNS FROM `my_nongmao` [ RunTime:0.017098s ]
- SHOW FULL COLUMNS FROM `my_gonqiu` [ RunTime:0.015420s ]
- SHOW FULL COLUMNS FROM `my_xunqiu` [ RunTime:0.013615s ]
- SHOW FULL COLUMNS FROM `my_jiaoyou` [ RunTime:0.018509s ]
- SHOW FULL COLUMNS FROM `my_shangye` [ RunTime:0.033195s ]
- SHOW FULL COLUMNS FROM `my_qiye` [ RunTime:0.036214s ]
- SHOW FULL COLUMNS FROM `my_sj` [ RunTime:0.015374s ]
- SHOW FULL COLUMNS FROM `my_smcp` [ RunTime:0.012023s ]
- SHOW FULL COLUMNS FROM `my_jj` [ RunTime:0.016451s ]
- SHOW FULL COLUMNS FROM `my_jd` [ RunTime:0.021267s ]
-
SELECT * FROM ((( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_pinche` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_zhaopin` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_fang` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_zhuanrang` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_zhuangxiu` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_ershou` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_che` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_fuwu` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_nongmao` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_gonqiu` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_xunqiu` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_jiaoyou` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_shangye` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_qiye` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_sj` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_smcp` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_jj` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 )) UNION ALL (( SELECT `id`,`m`,`settop`,`open`,`times`,`diqu` FROM `my_jd` WHERE `diqu` LIKE '%511700000000%' AND `open` = 1 ))) AS combined_table
ORDER BY
CASE WHEN settop != '0000-00-00 00:00:00' THEN 0 ELSE 1 END,
times DESC
LIMIT 0, 20 [ RunTime:0.009488s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC [ RunTime:0.004202s ]
- SHOW FULL COLUMNS FROM `my_shop` [ RunTime:0.047104s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `id` DESC LIMIT 12 [ RunTime:0.031855s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `settop` DESC,`times` DESC LIMIT 12 [ RunTime:0.019926s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.016063s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.011007s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.029613s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.015690s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012691s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.011056s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000309s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003715s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000831s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.014844s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001532s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000223s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002558s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.011718s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001064s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007293s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.009110s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.018453s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000222s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005655s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.031376s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012274s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.031980s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.008161s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000217s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002449s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006838s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.027343s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000216s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.026900s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000232s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.008783s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.014588s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.023386s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000268s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012921s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.014876s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.031682s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.028443s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012501s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.015352s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.024431s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.022406s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.024270s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.017635s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.011356s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.020478s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.020039s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.017799s ]
- SHOW FULL COLUMNS FROM `my_dan` [ RunTime:0.017561s ]
- SELECT * FROM `my_dan` WHERE `open` = 1 ORDER BY `time` DESC LIMIT 50 [ RunTime:0.010821s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.025309s ]
2.697137s
