文章的标题，如何批处理数据
发布于 2020-11-03 13:10:07
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-19 20:36:56 HTTP/1.1 GET : youthra.cn/article/9.html
- 运行时间 : 0.055956s [ 吞吐率：17.87req/s ] 内存消耗：5,392.30kb 文件加载：163
- 查询信息 : 25 queries 1 writes
- 缓存信息 : 7 reads,1 writes
- 配置加载 : 74
- 会话信息 : SESSION_ID=uc2vp99d4oiala2ub75gga6p5j
- [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000014s ]
- [ CACHE ] INIT File
- [ BEHAVIOR ] Run \addons\xunsearch\Xunsearch @app_init [ RunTime:0.001975s ]
- [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.001997s ]
- [ LANG ] /www/wwwroot/www.youthra.cn/thinkphp/lang/zh-cn.php
- [ BEHAVIOR ] Run app\common\behavior\Common @app_dispatch [ RunTime:0.000160s ]
- [ ROUTE ] array (
'type' => 'method',
'method' =>
array (
0 => '\\think\\addons\\Route',
1 => 'execute',
),
'var' =>
array (
'addon' => 'ask',
'controller' => 'article',
'action' => 'show',
),
)
- [ HEADER ] array (
'host' => 'youthra.cn',
'accept-encoding' => 'gzip, br, zstd, deflate',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '9',
)
- [ RUN ] think\addons\Route->execute[ /www/wwwroot/www.youthra.cn/vendor/karsonzhang/fastadmin-addons/src/addons/Route.php ]
- [ LANG ] /www/wwwroot/www.youthra.cn/public/../application/common/lang/zh-cn/addon.php
- [ BEHAVIOR ] Run app\common\behavior\Common @addon_begin [ RunTime:0.001027s ]
- [ LANG ] /www/wwwroot/www.youthra.cn/addons/ask/lang/zh-cn.php
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/www.youthra.cn/addons/ask/view/article/show.html [ array (
0 => 'config',
1 => 'user',
2 => 'site',
3 => 'isAdmin',
4 => 'askConfig',
5 => 'topZoneList',
6 => 'page',
7 => 'type',
8 => 'source_id',
9 => 'commentList',
10 => '__article__',
11 => 'relatedArticleList',
12 => 'title',
) ]
- [ SESSION ] INIT array (
'id' => '',
'var_session_id' => '',
'prefix' => 'think',
'type' => '',
'auto_start' => true,
)
- [ BEHAVIOR ] Run \addons\ask\Ask @view_filter [ RunTime:0.000193s ]
- [ DB ] CONNECT:[ UseTime:0.000304s ] mysql:host=127.0.0.1;port=3306;dbname=www_youthra_cn;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `fa_ask_article` [ RunTime:0.000673s ]
- [ SQL ] SELECT * FROM `fa_ask_article` WHERE ( `id` = 9 ) AND `fa_ask_article`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000529s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_category` [ RunTime:0.000733s ]
- [ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` = 0 [ RunTime:0.000140s ]
- [ SQL ] UPDATE `fa_ask_article` SET `views`=`views`+1 WHERE `id` = 9 [ RunTime:0.003162s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_user` [ RunTime:0.000553s ]
- [ SQL ] SELECT * FROM `fa_ask_user` WHERE `user_id` = 6 LIMIT 1 [ RunTime:0.000341s ]
- [ SQL ] SHOW COLUMNS FROM `fa_user` [ RunTime:0.000546s ]
- [ SQL ] SELECT * FROM `fa_user` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000168s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_tag` [ RunTime:0.000527s ]
- [ SQL ] SELECT `t`.*,`ta`.`source_id`,ta.id AS taggable_id FROM `fa_ask_tag` `t` RIGHT JOIN `fa_ask_taggable` `ta` ON `ta`.`tag_id`=`t`.`id` WHERE ( `ta`.`source_id` = 9 AND `ta`.`type` = 'article' ) AND `t`.`deletetime` IS NULL [ RunTime:0.000170s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_question` [ RunTime:0.000538s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_taggable` [ RunTime:0.000409s ]
- [ SQL ] SELECT * FROM `fa_ask_question` WHERE ( ( `id` IN ( SELECT `source_id` FROM `fa_ask_taggable` WHERE `tag_id` IN ('') AND `type` = 'question' ) AND `id` <> 9 ) AND `status` <> 'hidden' ) AND `fa_ask_question`.`deletetime` IS NULL LIMIT 10 [ RunTime:0.000454s ]
- [ SQL ] SHOW COLUMNS FROM `fa_ask_comment` [ RunTime:0.000513s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_ask_comment` WHERE ( `type` = 'article' AND `source_id` = 9 ) AND `fa_ask_comment`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000140s ]
- [ SQL ] SELECT * FROM `fa_ask_comment` WHERE ( `type` = 'article' AND `source_id` = 9 ) AND `fa_ask_comment`.`deletetime` IS NULL ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000139s ]
- [ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000166s ]
- [ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (1) [ RunTime:0.000158s ]
- [ SQL ] SELECT `t`.*,`ta`.`source_id` FROM `fa_ask_taggable` `ta` LEFT JOIN `fa_ask_tag` `t` ON `ta`.`tag_id`=`t`.`id` WHERE `source_id` IN (34,73,71,55,76,68,69,75,74,40) AND `type` = 'article' AND `t`.`deletetime` IS NULL [ RunTime:0.000206s ]
- [ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000156s ]
- [ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (1) [ RunTime:0.000148s ]
- [ SQL ] SELECT `t`.*,`ta`.`source_id` FROM `fa_ask_taggable` `ta` LEFT JOIN `fa_ask_tag` `t` ON `ta`.`tag_id`=`t`.`id` WHERE `source_id` IN (73,71,57,75,66,79,68,82,78,60) AND `type` = 'question' AND `t`.`deletetime` IS NULL [ RunTime:0.000182s ]
- [ SQL ] SELECT * FROM `fa_ask_category` WHERE `id` IN (0) [ RunTime:0.000153s ]
- [ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (15,1,3) [ RunTime:0.000156s ]
- [ SQL ] SELECT `t`.*,`ta`.`source_id` FROM `fa_ask_taggable` `ta` LEFT JOIN `fa_ask_tag` `t` ON `ta`.`tag_id`=`t`.`id` WHERE `source_id` IN (88,82,81,80,78,74,73,72,71,70) AND `type` = 'question' AND `t`.`deletetime` IS NULL [ RunTime:0.000176s ]
0.060934s
