SHORTLIST
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-14 14:44:29 HTTP/1.1 GET : www.xunmeizhiku.com/index/award/shortlist/year/2019-2020/c1/11/c2/86/c3/29.html
- 运行时间 : 0.168461s [ 吞吐率：5.94req/s ] 内存消耗：3,679.41kb 文件加载：149
- 查询信息 : 71 queries 0 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 82
- 会话信息 : SESSION_ID=81nta3nf2hrd36tpdee996s506
- [ LANG ] /www/wwwroot/xunmei-dichanxian/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'index',
1 => 'award',
2 => 'shortlist',
),
)
- [ HEADER ] array (
'host' => 'www.xunmeizhiku.com',
'cookie' => 'PHPSESSID=81nta3nf2hrd36tpdee996s506',
'accept-encoding' => 'gzip, br, zstd, deflate',
'referer' => 'https://xunmeizhiku.com/index/award/shortlist/year/2019-2020/c1/11/c2/86/c3/29.html',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'year' => '2019-2020',
'c1' => '11',
'c2' => '86',
'c3' => '29',
)
- [ SESSION ] INIT array (
'id' => '',
'var_session_id' => '',
'prefix' => 'think',
'type' => 'redis',
'host' => '127.0.0.1',
'port' => 6379,
'timeout' => 3600,
'persistent' => true,
'auto_start' => true,
'expire' => 144000,
)
- [ DB ] INIT mysql
- [ CACHE ] INIT redis
- [ RUN ] app\index\controller\Award->shortlist[ /www/wwwroot/xunmei-dichanxian/application/index/controller/Award.php ]
- [ VIEW ] /www/wwwroot/xunmei-dichanxian/application/index/view/award/award-shortlist.html [ array (
0 => 'identity',
1 => 'default_login',
2 => 'template',
3 => 'template_path',
4 => 'template_dir',
5 => 'title',
6 => 'subtitle',
7 => 'keywords',
8 => 'description',
9 => 'config',
10 => 'version',
11 => 'auth_phone',
12 => 'years',
13 => 'list1',
14 => 'list2',
15 => 'list3',
16 => 'category1',
17 => 'category2',
18 => 'category3',
) ]
- [ DB ] CONNECT:[ UseTime:0.004412s ] mysql:host=172.19.53.252;port=3306;dbname=xumeidichannew;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.001258s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'template' LIMIT 1 [ RunTime:0.000354s ]
- [ SQL ] SELECT * FROM `config` [ RunTime:0.000279s ]
- [ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.000973s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 8 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000339s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 9 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000282s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 10 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000335s ]
- [ SQL ] SHOW COLUMNS FROM `award_project` [ RunTime:0.001110s ]
- [ SQL ] SELECT `rankedyear` FROM `award_project` WHERE `payed` = 1 AND `ranked` = 1 AND `rankedyear` <> 'NULL' GROUP BY `rankedyear` ORDER BY `rankedyear` asc [ RunTime:0.000334s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 11 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.060744s ]
- [ SQL ] SHOW COLUMNS FROM `review` [ RunTime:0.001120s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 428 LIMIT 1 [ RunTime:0.000246s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 444 LIMIT 1 [ RunTime:0.000210s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 571 LIMIT 1 [ RunTime:0.000241s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 605 LIMIT 1 [ RunTime:0.000231s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 671 LIMIT 1 [ RunTime:0.000535s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 684 LIMIT 1 [ RunTime:0.000493s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 760 LIMIT 1 [ RunTime:0.000400s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 807 LIMIT 1 [ RunTime:0.000193s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 809 LIMIT 1 [ RunTime:0.000195s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 818 LIMIT 1 [ RunTime:0.000196s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 855 LIMIT 1 [ RunTime:0.000183s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 892 LIMIT 1 [ RunTime:0.000207s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 982 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 990 LIMIT 1 [ RunTime:0.000184s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1011 LIMIT 1 [ RunTime:0.000186s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1115 LIMIT 1 [ RunTime:0.000491s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1170 LIMIT 1 [ RunTime:0.000444s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1186 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1207 LIMIT 1 [ RunTime:0.000594s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1216 LIMIT 1 [ RunTime:0.000232s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1315 LIMIT 1 [ RunTime:0.000220s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1331 LIMIT 1 [ RunTime:0.000208s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1439 LIMIT 1 [ RunTime:0.000222s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1454 LIMIT 1 [ RunTime:0.000185s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1480 LIMIT 1 [ RunTime:0.000249s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1524 LIMIT 1 [ RunTime:0.000194s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1536 LIMIT 1 [ RunTime:0.000455s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1625 LIMIT 1 [ RunTime:0.000424s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1630 LIMIT 1 [ RunTime:0.000289s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1638 LIMIT 1 [ RunTime:0.000252s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1639 LIMIT 1 [ RunTime:0.000610s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1791 LIMIT 1 [ RunTime:0.000256s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1822 LIMIT 1 [ RunTime:0.000304s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1846 LIMIT 1 [ RunTime:0.000311s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1873 LIMIT 1 [ RunTime:0.000282s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1910 LIMIT 1 [ RunTime:0.000463s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1991 LIMIT 1 [ RunTime:0.000466s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2041 LIMIT 1 [ RunTime:0.000272s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2081 LIMIT 1 [ RunTime:0.000290s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2096 LIMIT 1 [ RunTime:0.000258s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2112 LIMIT 1 [ RunTime:0.000458s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2129 LIMIT 1 [ RunTime:0.000477s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2226 LIMIT 1 [ RunTime:0.000288s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2351 LIMIT 1 [ RunTime:0.000263s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2398 LIMIT 1 [ RunTime:0.000269s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2404 LIMIT 1 [ RunTime:0.000432s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2441 LIMIT 1 [ RunTime:0.000509s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 86 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.001351s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 29 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.001211s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 423 LIMIT 1 [ RunTime:0.000452s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 483 LIMIT 1 [ RunTime:0.000358s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 717 LIMIT 1 [ RunTime:0.000298s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 916 LIMIT 1 [ RunTime:0.000276s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1069 LIMIT 1 [ RunTime:0.000264s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1585 LIMIT 1 [ RunTime:0.000264s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1880 LIMIT 1 [ RunTime:0.000334s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2371 LIMIT 1 [ RunTime:0.000319s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2523 LIMIT 1 [ RunTime:0.000339s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000780s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000295s ]
0.180871s
