welcome
- 本文标签:
welcome
- 浏览次数:114 次浏览
- 发布日期:2020-10-03 23:14:44
- 浏览更多:
上一篇
下一篇
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2021-01-21 15:05:13 HTTP/1.1 GET : https://ztuc.cn/detail?Art=MjE=&ZcT=NQ==&NcT=6IGK5aSp
- 运行时间 : 0.101562s [ 吞吐率:9.85req/s ] 内存消耗:5,138.30kb 文件加载:160
- 查询信息 : 34 queries
- 缓存信息 : 7 reads,0 writes
- 会话信息 : SESSION_ID=db63a6718ce15bd20f06ede01a6c6a25
- CONNECT:[ UseTime:0.000534s ] mysql:host=127.0.0.1;port=3306;dbname=thinkphp;charset=utf8
- SHOW FULL COLUMNS FROM `chat_tourist` [ RunTime:0.000702s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' AND `locks` = 2 LIMIT 1 /* 查询是否黑名单 */ [ RunTime:0.001116s ]
- UPDATE `chat_tourist` SET `locks` = 1 WHERE `updatetime` <= 1611126313 AND `locks` = 2 [ RunTime:0.009217s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.001163s ]
- INSERT INTO `chat_tourist` SET `tourist_name` = 'SB_77b4' , `ip` = '3.227.247.17' , `agent` = 'CCBot/2.0 (https://commoncrawl.org/faq/)' , `createtime` = 1611212713 , `updatetime` = 1611212713 [ RunTime:0.002953s ]
- UPDATE `chat_tourist` SET `status` = 0 WHERE `updatetime` <= 1610607913 AND `status` = 1 [ RunTime:0.006996s ]
- SELECT * FROM `chat_tourist` WHERE `ip` = '3.227.247.17' LIMIT 1 /* 查询IP是否存在 */ [ RunTime:0.000871s ]
- SHOW FULL COLUMNS FROM `chat_category` [ RunTime:0.000480s ]
- SHOW FULL COLUMNS FROM `chat_banner` [ RunTime:0.000322s ]
- SHOW FULL COLUMNS FROM `chat_images` [ RunTime:0.000379s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 1 LIMIT 1 [ RunTime:0.000285s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 2 AND `types` = 1 LIMIT 1 [ RunTime:0.000200s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 3 AND `types` = 1 LIMIT 1 [ RunTime:0.000199s ]
- SHOW FULL COLUMNS FROM `chat_article` [ RunTime:0.000373s ]
- SELECT * FROM `chat_article` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000201s ]
- UPDATE `chat_article` SET `view` = view+1 , `updatetime` = 1611212713 WHERE `id` = 21 [ RunTime:0.000212s ]
- SHOW FULL COLUMNS FROM `chat_article_log` [ RunTime:0.000477s ]
- SELECT * FROM `chat_article_log` WHERE `createtime` BETWEEN 1611158400 AND 1611244799 AND `article_id` = 21 LIMIT 1 [ RunTime:0.000298s ]
- UPDATE `chat_article_log` SET `view` = view+1 WHERE `createtime` BETWEEN 1611158400 AND 1611244799 AND `article_id` = 21 [ RunTime:0.005217s ]
- SELECT * FROM `chat_article` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000244s ]
- SELECT * FROM `chat_article` WHERE `status` = 1 AND `cat_id` = 5 AND `id` < 21 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000281s ]
- SELECT * FROM `chat_article` WHERE `status` = 1 AND `cat_id` = 5 AND `id` > 21 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000261s ]
- SELECT MIN(`id`) AS think_min FROM `chat_article` WHERE `cat_id` = 5 [ RunTime:0.000193s ]
- SELECT MAX(`id`) AS think_max FROM `chat_article` WHERE `cat_id` = 5 [ RunTime:0.000206s ]
- SHOW FULL COLUMNS FROM `chat_click_log` [ RunTime:0.000356s ]
- SELECT * FROM `chat_click_log` WHERE `article_id` = 21 AND `uid` = 0 AND `ip` = '3.227.247.17' AND `createtime` BETWEEN 1611158400 AND 1611244799 LIMIT 1 [ RunTime:0.000259s ]
- SHOW FULL COLUMNS FROM `chat_comment` [ RunTime:0.000350s ]
- SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 21 AND `status` = 1 [ RunTime:0.000282s ]
- SELECT * FROM `chat_comment` WHERE `article_id` = 21 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000304s ]
- SHOW FULL COLUMNS FROM `chat_user` [ RunTime:0.003087s ]
- SELECT `id`,`avatar`,`nickname`,`qq`,`username`,`group_id`,`mobile`,`email`,`openid`,`level`,`bio`,`money`,`score`,`logintime`,`maxsuccessions`,`successions`,`prevtime` FROM `chat_user` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000236s ]
- SELECT * FROM `chat_images` FORCE INDEX ( images ) WHERE `table_id` = 1 AND `types` = 3 LIMIT 1 [ RunTime:0.000221s ]
- SELECT COUNT(*) AS think_count FROM `chat_comment` WHERE `article_id` = 21 AND `status` = 1 [ RunTime:0.000236s ]
- SHOW FULL COLUMNS FROM `chat_system` [ RunTime:0.000440s ]

0.102685s
kdQSHZ