SHORTLIST
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-13 17:16:00 HTTP/1.1 GET : www.xunmeizhiku.com/index.php/index/award/shortlist/year/2020/c1/18/c2/21.html
- 运行时间 : 0.230542s [ 吞吐率：4.34req/s ] 内存消耗：6,660.43kb 文件加载：149
- 查询信息 : 98 queries 0 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 82
- 会话信息 : SESSION_ID=lk1089h4sqnvlm5nffj71pv332
- [ 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',
'referer' => 'https://xunmeizhiku.com/index.php/index/award/shortlist/year/2020/c1/18/c2/21.html',
'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-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'year' => '2020',
'c1' => '18',
'c2' => '21',
)
- [ 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.001281s ] mysql:host=172.19.53.252;port=3306;dbname=xumeidichannew;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.001280s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'template' LIMIT 1 [ RunTime:0.000311s ]
- [ SQL ] SELECT * FROM `config` [ RunTime:0.000618s ]
- [ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.000926s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 8 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000408s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 9 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000340s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 10 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000230s ]
- [ SQL ] SHOW COLUMNS FROM `award_project` [ RunTime:0.006562s ]
- [ SQL ] SELECT `rankedyear` FROM `award_project` WHERE `payed` = 1 AND `ranked` = 1 AND `rankedyear` <> 'NULL' GROUP BY `rankedyear` ORDER BY `rankedyear` asc [ RunTime:0.001118s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 18 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2020') [ RunTime:0.001586s ]
- [ SQL ] SHOW COLUMNS FROM `review` [ RunTime:0.000823s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1395 LIMIT 1 [ RunTime:0.000177s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1470 LIMIT 1 [ RunTime:0.000174s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1500 LIMIT 1 [ RunTime:0.000179s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1580 LIMIT 1 [ RunTime:0.000154s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1691 LIMIT 1 [ RunTime:0.000241s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1706 LIMIT 1 [ RunTime:0.000235s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2428 LIMIT 1 [ RunTime:0.000237s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2438 LIMIT 1 [ RunTime:0.000242s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 21 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2020') [ RunTime:0.051754s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 998 LIMIT 1 [ RunTime:0.000492s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1413 LIMIT 1 [ RunTime:0.000300s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1443 LIMIT 1 [ RunTime:0.000265s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1450 LIMIT 1 [ RunTime:0.000231s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1467 LIMIT 1 [ RunTime:0.000246s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1491 LIMIT 1 [ RunTime:0.000319s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1519 LIMIT 1 [ RunTime:0.000258s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1532 LIMIT 1 [ RunTime:0.000265s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1660 LIMIT 1 [ RunTime:0.000235s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1663 LIMIT 1 [ RunTime:0.000232s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1670 LIMIT 1 [ RunTime:0.000222s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1713 LIMIT 1 [ RunTime:0.000221s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1718 LIMIT 1 [ RunTime:0.000201s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1747 LIMIT 1 [ RunTime:0.000236s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1776 LIMIT 1 [ RunTime:0.000243s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1779 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1793 LIMIT 1 [ RunTime:0.000231s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1827 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1845 LIMIT 1 [ RunTime:0.000301s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1847 LIMIT 1 [ RunTime:0.000245s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1865 LIMIT 1 [ RunTime:0.000239s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1870 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1888 LIMIT 1 [ RunTime:0.000239s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1928 LIMIT 1 [ RunTime:0.000212s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1943 LIMIT 1 [ RunTime:0.000215s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1962 LIMIT 1 [ RunTime:0.000199s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1970 LIMIT 1 [ RunTime:0.000167s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1971 LIMIT 1 [ RunTime:0.000207s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1984 LIMIT 1 [ RunTime:0.000209s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2008 LIMIT 1 [ RunTime:0.000230s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2016 LIMIT 1 [ RunTime:0.000225s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2037 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2044 LIMIT 1 [ RunTime:0.000239s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2048 LIMIT 1 [ RunTime:0.000668s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2051 LIMIT 1 [ RunTime:0.000278s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2074 LIMIT 1 [ RunTime:0.000238s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2079 LIMIT 1 [ RunTime:0.000229s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2090 LIMIT 1 [ RunTime:0.000238s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2104 LIMIT 1 [ RunTime:0.000235s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2131 LIMIT 1 [ RunTime:0.000610s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2142 LIMIT 1 [ RunTime:0.000198s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2150 LIMIT 1 [ RunTime:0.000264s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2158 LIMIT 1 [ RunTime:0.000243s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2163 LIMIT 1 [ RunTime:0.000225s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2197 LIMIT 1 [ RunTime:0.000237s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2218 LIMIT 1 [ RunTime:0.000195s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2228 LIMIT 1 [ RunTime:0.000259s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2257 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2303 LIMIT 1 [ RunTime:0.000242s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2321 LIMIT 1 [ RunTime:0.000229s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2354 LIMIT 1 [ RunTime:0.000209s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2394 LIMIT 1 [ RunTime:0.000220s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2440 LIMIT 1 [ RunTime:0.000207s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2467 LIMIT 1 [ RunTime:0.000259s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2530 LIMIT 1 [ RunTime:0.000225s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 41 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2020') [ RunTime:0.054821s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1586 LIMIT 1 [ RunTime:0.000534s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1641 LIMIT 1 [ RunTime:0.000308s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1649 LIMIT 1 [ RunTime:0.000214s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1651 LIMIT 1 [ RunTime:0.000319s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1754 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1762 LIMIT 1 [ RunTime:0.000243s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1819 LIMIT 1 [ RunTime:0.000225s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1863 LIMIT 1 [ RunTime:0.000224s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1893 LIMIT 1 [ RunTime:0.000201s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1941 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1953 LIMIT 1 [ RunTime:0.000209s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1964 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2007 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2059 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2136 LIMIT 1 [ RunTime:0.000268s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2138 LIMIT 1 [ RunTime:0.000235s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2191 LIMIT 1 [ RunTime:0.000343s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2259 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2389 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2506 LIMIT 1 [ RunTime:0.000243s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000447s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000345s ]
0.242340s
