基本
文件
流程
错误
SQL
调试
- 请求信息 : 2021-01-21 15:42:30 HTTP/1.1 GET : https://ztuc.cn/column?ZcT=NQ==&NcT=6IGK5aSp
- 运行时间 : 0.107638s [ 吞吐率:9.29req/s ] 内存消耗:5,002.20kb 文件加载:155
- 查询信息 : 24 queries
- 缓存信息 : 7 reads,0 writes
- 会话信息 : SESSION_ID=0b50c292e5672cb26cad47b040881fb7
- CONNECT:[ UseTime:0.000555s ] mysql:host=127.0.0.1;port=3306;dbname=thinkphp;charset=utf8
- SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000874s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.001036s ]
- UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611128550 AND `locks` = 2 [ RunTime:0.007394s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.001473s ]
- UPDATE `chat_tourist` SET `times` = 1 WHERE `updatetime` <= 1611211350 AND `ip` = '3.227.247.17' [ RunTime:0.027368s ]
- UPDATE `chat_tourist` SET `status` = 1 , `updatetime` = 1611214950 WHERE `ip` = '3.227.247.17' [ RunTime:0.007074s ]
- UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610610150 AND `status` = 1 [ RunTime:0.006711s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000918s ]
- SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000545s ]
- SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.000376s ]
- SHOW FULL COLUMNS FROM `chat_images` [ RunTime:0.000348s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 1 LIMIT 1 [ RunTime:0.000260s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000209s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000215s ]
- SELECT * FROM `chat_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000193s ]
- SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000387s ]
- SELECT COUNT(*) AS think_count FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 5 [ RunTime:0.000226s ]
- SELECT * FROM `chat_article` FORCE INDEX ( idx_status ) WHERE `status` = 1 AND `cat_id` = 5 ORDER BY `weigh` DESC,`createtime` DESC LIMIT 0,5 [ RunTime:0.000247s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 32 AND `types` = 4 LIMIT 1 [ RunTime:0.000201s ]
- SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000308s ]
- SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 32 [ RunTime:0.000218s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 21 AND `types` = 4 LIMIT 1 [ RunTime:0.000226s ]
- SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 21 [ RunTime:0.000233s ]
- SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000325s ]

0.109357s