基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-14 12:25:39 HTTP/2.0 GET : https://haiyi.mifenlei.com/?res=SmsgQuXT
- 运行时间 : 2.107660s [ 吞吐率：0.47req/s ] 内存消耗：4,815.69kb 文件加载：151
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=2a5e44fcbf67345d9179598c35e13b7c
- CONNECT:[ UseTime:0.014556s ] mysql:host=127.0.0.1;port=3306;dbname=youpin_mifenlei_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `my_ip` [ RunTime:0.018993s ]
- SELECT * FROM `my_ip` WHERE `ip` = '216.73.216.152' LIMIT 1 [ RunTime:0.010858s ]
- UPDATE `my_ip` SET `times` = '1778732739' , `method` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `view` = 48586 , `url` = 'https://haiyi.mifenlei.com/?res=SmsgQuXT' WHERE `id` = 1466 [ RunTime:0.019465s ]
- DELETE FROM `my_ip` WHERE `open` = 1 AND `view` < 10 AND `time` < 1778387139 [ RunTime:0.017486s ]
- SHOW FULL COLUMNS FROM `my_set` [ RunTime:0.016950s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.018633s ]
- SHOW FULL COLUMNS FROM `my_diqu` [ RunTime:0.021069s ]
- SELECT * FROM `my_diqu` WHERE `id` = 511700000000 LIMIT 1 [ RunTime:0.022640s ]
- SHOW FULL COLUMNS FROM `my_hook` [ RunTime:0.025733s ]
- SELECT * FROM `my_hook` WHERE `name` = 'indexindex' LIMIT 1 [ RunTime:0.005339s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006159s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.009228s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.030129s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.020390s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.019392s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006474s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.016359s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012597s ]
- SHOW FULL COLUMNS FROM `my_model` [ RunTime:0.016098s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4 [ RunTime:0.008389s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4,30 [ RunTime:0.020013s ]
- SHOW FULL COLUMNS FROM `my_article` [ RunTime:0.018130s ]
- SELECT * FROM `my_article` WHERE `open` = 1 AND `settop` = 1 ORDER BY `times` DESC LIMIT 10 [ RunTime:0.028661s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.005464s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `view` DESC LIMIT 5 [ RunTime:0.026118s ]
- SELECT * FROM `my_model` WHERE `open` = 1 [ RunTime:0.017868s ]
- SHOW FULL COLUMNS FROM `my_pinche` [ RunTime:0.020490s ]
- SHOW FULL COLUMNS FROM `my_zhaopin` [ RunTime:0.026030s ]
- SHOW FULL COLUMNS FROM `my_fang` [ RunTime:0.027459s ]
- SHOW FULL COLUMNS FROM `my_zhuanrang` [ RunTime:0.013461s ]
- SHOW FULL COLUMNS FROM `my_zhuangxiu` [ RunTime:0.020805s ]
- SHOW FULL COLUMNS FROM `my_ershou` [ RunTime:0.008994s ]
- SHOW FULL COLUMNS FROM `my_che` [ RunTime:0.018745s ]
- SHOW FULL COLUMNS FROM `my_fuwu` [ RunTime:0.008057s ]
- SHOW FULL COLUMNS FROM `my_nongmao` [ RunTime:0.009638s ]
- SHOW FULL COLUMNS FROM `my_gonqiu` [ RunTime:0.023931s ]
- SHOW FULL COLUMNS FROM `my_xunqiu` [ RunTime:0.019358s ]
- SHOW FULL COLUMNS FROM `my_jiaoyou` [ RunTime:0.025178s ]
- SHOW FULL COLUMNS FROM `my_shangye` [ RunTime:0.022862s ]
- SHOW FULL COLUMNS FROM `my_qiye` [ RunTime:0.009581s ]
- SHOW FULL COLUMNS FROM `my_sj` [ RunTime:0.035886s ]
- SHOW FULL COLUMNS FROM `my_smcp` [ RunTime:0.015751s ]
- SHOW FULL COLUMNS FROM `my_jj` [ RunTime:0.012493s ]
- SHOW FULL COLUMNS FROM `my_jd` [ RunTime:0.026824s ]
-
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.028988s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC [ RunTime:0.011228s ]
- SHOW FULL COLUMNS FROM `my_shop` [ RunTime:0.033439s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `id` DESC LIMIT 12 [ RunTime:0.025543s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `settop` DESC,`times` DESC LIMIT 12 [ RunTime:0.017788s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002037s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.015889s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.014007s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006995s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.008308s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006982s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.009371s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004833s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007804s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002750s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002857s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006512s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005049s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002439s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004280s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003619s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002109s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001572s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003091s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000790s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004376s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000349s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003777s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001917s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005355s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000264s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007573s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003779s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000260s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000190s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006852s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006421s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000957s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004428s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006637s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012272s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003553s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002825s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003719s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002026s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004956s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003987s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003607s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.010407s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007755s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001119s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003025s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007794s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.013820s ]
- SHOW FULL COLUMNS FROM `my_dan` [ RunTime:0.003605s ]
- SELECT * FROM `my_dan` WHERE `open` = 1 ORDER BY `time` DESC LIMIT 50 [ RunTime:0.006090s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007482s ]
2.188715s
