基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-05-27 00:15:24 HTTP/2.0 GET : https://haiyi.mifenlei.com/?res=ockDBca4
- 运行时间 : 0.561476s [ 吞吐率：1.78req/s ] 内存消耗：4,815.68kb 文件加载：151
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=294e6b540606977c4866a2c23bc4f82a
- CONNECT:[ UseTime:0.001010s ] mysql:host=127.0.0.1;port=3306;dbname=youpin_mifenlei_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `my_ip` [ RunTime:0.003663s ]
- SELECT * FROM `my_ip` WHERE `ip` = '216.73.216.214' LIMIT 1 [ RunTime:0.001282s ]
- UPDATE `my_ip` SET `times` = '1779812124' , `method` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `view` = 1319766 , `url` = 'https://haiyi.mifenlei.com/?res=ockDBca4' WHERE `id` = 1530 [ RunTime:0.002996s ]
- DELETE FROM `my_ip` WHERE `open` = 1 AND `view` < 10 AND `time` < 1779466524 [ RunTime:0.000388s ]
- SHOW FULL COLUMNS FROM `my_set` [ RunTime:0.004060s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000233s ]
- SHOW FULL COLUMNS FROM `my_diqu` [ RunTime:0.002634s ]
- SELECT * FROM `my_diqu` WHERE `id` = 511700000000 LIMIT 1 [ RunTime:0.003641s ]
- SHOW FULL COLUMNS FROM `my_hook` [ RunTime:0.003081s ]
- SELECT * FROM `my_hook` WHERE `name` = 'indexindex' LIMIT 1 [ RunTime:0.003646s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000262s ]
- 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.004344s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000937s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002187s ]
- 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.001016s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002305s ]
- SHOW FULL COLUMNS FROM `my_model` [ RunTime:0.004505s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4 [ RunTime:0.000659s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC LIMIT 4,30 [ RunTime:0.000263s ]
- SHOW FULL COLUMNS FROM `my_article` [ RunTime:0.001965s ]
- SELECT * FROM `my_article` WHERE `open` = 1 AND `settop` = 1 ORDER BY `times` DESC LIMIT 10 [ RunTime:0.001032s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.001568s ]
- SELECT * FROM `my_article` WHERE `open` = 1 ORDER BY `view` DESC LIMIT 5 [ RunTime:0.000351s ]
- SELECT * FROM `my_model` WHERE `open` = 1 [ RunTime:0.001475s ]
- SHOW FULL COLUMNS FROM `my_pinche` [ RunTime:0.005567s ]
- SHOW FULL COLUMNS FROM `my_zhaopin` [ RunTime:0.001873s ]
- SHOW FULL COLUMNS FROM `my_fang` [ RunTime:0.007334s ]
- SHOW FULL COLUMNS FROM `my_zhuanrang` [ RunTime:0.008193s ]
- SHOW FULL COLUMNS FROM `my_zhuangxiu` [ RunTime:0.004146s ]
- SHOW FULL COLUMNS FROM `my_ershou` [ RunTime:0.012623s ]
- SHOW FULL COLUMNS FROM `my_che` [ RunTime:0.005868s ]
- SHOW FULL COLUMNS FROM `my_fuwu` [ RunTime:0.005625s ]
- SHOW FULL COLUMNS FROM `my_nongmao` [ RunTime:0.003049s ]
- SHOW FULL COLUMNS FROM `my_gonqiu` [ RunTime:0.002047s ]
- SHOW FULL COLUMNS FROM `my_xunqiu` [ RunTime:0.006124s ]
- SHOW FULL COLUMNS FROM `my_jiaoyou` [ RunTime:0.003758s ]
- SHOW FULL COLUMNS FROM `my_shangye` [ RunTime:0.005932s ]
- SHOW FULL COLUMNS FROM `my_qiye` [ RunTime:0.006359s ]
- SHOW FULL COLUMNS FROM `my_sj` [ RunTime:0.011733s ]
- SHOW FULL COLUMNS FROM `my_smcp` [ RunTime:0.005718s ]
- SHOW FULL COLUMNS FROM `my_jj` [ RunTime:0.011847s ]
- SHOW FULL COLUMNS FROM `my_jd` [ RunTime:0.010750s ]
-
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.008543s ]
- SELECT * FROM `my_model` WHERE `open` = 1 ORDER BY `px` DESC [ RunTime:0.005274s ]
- SHOW FULL COLUMNS FROM `my_shop` [ RunTime:0.006116s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `id` DESC LIMIT 12 [ RunTime:0.006224s ]
- SELECT * FROM `my_shop` WHERE `open` = 1 AND `diqu` LIKE '%511700000000%' ORDER BY `settop` DESC,`times` DESC LIMIT 12 [ RunTime:0.004279s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001708s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000262s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000259s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003364s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.005452s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004620s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001712s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003692s ]
- 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.002226s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006110s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000231s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001987s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003060s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.006507s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003707s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000273s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003324s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002638s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000220s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002142s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.003603s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000369s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004018s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.004297s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000943s ]
- 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.001726s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002895s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001493s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001701s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000299s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001674s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001453s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001746s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002971s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001562s ]
- 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.000990s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001525s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001468s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001710s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002277s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001528s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001569s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.000839s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001615s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001612s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.001359s ]
- SHOW FULL COLUMNS FROM `my_dan` [ RunTime:0.004055s ]
- SELECT * FROM `my_dan` WHERE `open` = 1 ORDER BY `time` DESC LIMIT 50 [ RunTime:0.001514s ]
- SELECT `config` FROM `my_set` WHERE `alias` = 'set' LIMIT 1 [ RunTime:0.002339s ]
0.590517s
