基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-31 15:21:05 HTTP/2.0 GET : https://haiyi.mifenlei.com/?res=6SQL2rP4
- 运行时间 : 0.916027s [ 吞吐率：1.09req/s ] 内存消耗：4,815.69kb 文件加载：151
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=341e72846bd7b2ae3e376f9ea2e94545
- CONNECT:[ UseTime:0.001297s ] mysql:host=127.0.0.1;port=3306;dbname=youpin_mifenlei_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `my_ip` [ RunTime:0.008071s ]
- SELECT * FROM `my_ip` WHERE `ip` = '216.73.216.185' LIMIT 1 [ RunTime:0.000444s ]
- UPDATE `my_ip` SET `times` = '1780212065' , `method` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `view` = 228911 , `url` = 'https://haiyi.mifenlei.com/?res=6SQL2rP4' WHERE `id` = 1261 [ RunTime:0.001396s ]
- DELETE FROM `my_ip` WHERE `open` = 1 AND `view` < 10 AND `time` < 1779866465 [ RunTime:0.005220s ]
- SHOW FULL COLUMNS FROM `my_set` [ RunTime:0.011735s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000198s ]
- SHOW FULL COLUMNS FROM `my_diqu` [ RunTime:0.036325s ]
- SELECT * FROM `my_diqu` WHERE `id` = 511700000000 LIMIT 1 [ RunTime:0.001422s ]
- SHOW FULL COLUMNS FROM `my_hook` [ RunTime:0.033288s ]
- SELECT * FROM `my_hook` WHERE `name` = 'indexindex' LIMIT 1 [ RunTime:0.007599s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005372s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003189s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007098s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000221s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000192s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000278s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000312s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003798s ]
- SHOW FULL COLUMNS FROM `my_model` [ RunTime:0.004134s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4 [ RunTime:0.001083s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4,30 [ RunTime:0.002502s ]
- SHOW FULL COLUMNS FROM `my_article` [ RunTime:0.019365s ]
- SELECT * FROM `my_article` WHERE `open` = 1 AND `settop` = 1 ORDER BY `times` DESC LIMIT 10 [ RunTime:0.002553s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.000801s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `view` DESC LIMIT 5 [ RunTime:0.004540s ]
- SELECT * FROM `my_model` WHERE `open` = 1 [ RunTime:0.000404s ]
- SHOW FULL COLUMNS FROM `my_pinche` [ RunTime:0.020154s ]
- SHOW FULL COLUMNS FROM `my_zhaopin` [ RunTime:0.011152s ]
- SHOW FULL COLUMNS FROM `my_fang` [ RunTime:0.011715s ]
- SHOW FULL COLUMNS FROM `my_zhuanrang` [ RunTime:0.029815s ]
- SHOW FULL COLUMNS FROM `my_zhuangxiu` [ RunTime:0.005030s ]
- SHOW FULL COLUMNS FROM `my_ershou` [ RunTime:0.027673s ]
- SHOW FULL COLUMNS FROM `my_che` [ RunTime:0.020265s ]
- SHOW FULL COLUMNS FROM `my_fuwu` [ RunTime:0.009275s ]
- SHOW FULL COLUMNS FROM `my_nongmao` [ RunTime:0.009810s ]
- SHOW FULL COLUMNS FROM `my_gonqiu` [ RunTime:0.004930s ]
- SHOW FULL COLUMNS FROM `my_xunqiu` [ RunTime:0.015122s ]
- SHOW FULL COLUMNS FROM `my_jiaoyou` [ RunTime:0.009202s ]
- SHOW FULL COLUMNS FROM `my_shangye` [ RunTime:0.004321s ]
- SHOW FULL COLUMNS FROM `my_qiye` [ RunTime:0.015639s ]
- SHOW FULL COLUMNS FROM `my_sj` [ RunTime:0.017361s ]
- SHOW FULL COLUMNS FROM `my_smcp` [ RunTime:0.014876s ]
- SHOW FULL COLUMNS FROM `my_jj` [ RunTime:0.008688s ]
- SHOW FULL COLUMNS FROM `my_jd` [ RunTime:0.027127s ]
-
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.013953s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC [ RunTime:0.007788s ]
- SHOW FULL COLUMNS FROM `my_shop` [ RunTime:0.011268s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `id` DESC LIMIT 12 [ RunTime:0.001914s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `settop` DESC,`times` DESC LIMIT 12 [ RunTime:0.008491s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002372s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006640s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.018422s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.017541s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.009776s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.010859s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.012436s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005469s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.010060s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.010673s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005057s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001071s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002432s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001658s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000193s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000187s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001185s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000420s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000205s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003121s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000192s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000199s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003108s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000193s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001886s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000195s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.007773s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000282s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005900s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000234s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000280s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000236s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005427s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005561s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003489s ]
- 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.005925s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002021s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002661s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004411s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000247s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002362s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000297s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004338s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001509s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005471s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000452s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000237s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003590s ]
- SHOW FULL COLUMNS FROM `my_dan` [ RunTime:0.003552s ]
- SELECT * FROM `my_dan` WHERE `open` = 1 ORDER BY `time` DESC LIMIT 50 [ RunTime:0.006771s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000475s ]
0.981622s
