SHORTLIST
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-14 14:51:59 HTTP/1.1 GET : www.xunmeizhiku.com/index/award/shortlist/year/2019-2020/c1/15/c2/23/c3/real-estate-home.html
- 运行时间 : 0.144030s [ 吞吐率：6.94req/s ] 内存消耗：3,550.98kb 文件加载：149
- 查询信息 : 69 queries 0 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 82
- 会话信息 : SESSION_ID=o42df6b4j7v5obg5u28pknc1vs
- [ 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' => 'RWSESSID=0520772a35438c504e80ee521ab5f7b8; fly_ab_uid=783f205e-9674-49a3-88ee-1d4f559cc05d; handl_ip=18.117.91.221; handl_landing_page=https%3A%2F%2Fsprutcam.com%2Ftr%2Fetkinlikler%2Fliste%2F%3Ftribe-bar-date%3D2024-11-15; HandLtestDomainNameServer=HandLtestDomainValueServer; fly_geo={"countryCode":"us","region":"oh","dma":"535"}; handl_url_base=https%3A%2F%2Fsprutcam.com%2Ftr%2Fetkinlikler%2Fliste%2F; handl_url=https%3A%2F%2Fsprutcam.com%2Ftr%2Fetkinlikler%2Fliste%2F%3Ftribe-bar-date%3D2024-11-15; fly_device=desktop; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29',
'accept-encoding' => 'gzip, br, zstd, deflate',
'referer' => 'https://xunmeizhiku.com/index/award/shortlist/year/2019-2020/c1/15/c2/23/c3/real-estate-home.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' => '15',
'c2' => '23',
'c3' => 'real-estate-home',
)
- [ 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.000481s ] mysql:host=172.19.53.252;port=3306;dbname=xumeidichannew;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.000975s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'template' LIMIT 1 [ RunTime:0.000343s ]
- [ SQL ] SELECT * FROM `config` [ RunTime:0.000288s ]
- [ SQL ] SHOW COLUMNS FROM `category` [ RunTime:0.001024s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 8 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000435s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 9 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000379s ]
- [ SQL ] SELECT * FROM `category` WHERE `pid` = 10 ORDER BY `sort` asc,`updatetime` desc,`id` desc [ RunTime:0.000365s ]
- [ SQL ] SHOW COLUMNS FROM `award_project` [ RunTime:0.000986s ]
- [ SQL ] SELECT `rankedyear` FROM `award_project` WHERE `payed` = 1 AND `ranked` = 1 AND `rankedyear` <> 'NULL' GROUP BY `rankedyear` ORDER BY `rankedyear` asc [ RunTime:0.000344s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 15 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.056739s ]
- [ SQL ] SHOW COLUMNS FROM `review` [ RunTime:0.001076s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 664 LIMIT 1 [ RunTime:0.000303s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 704 LIMIT 1 [ RunTime:0.000247s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 757 LIMIT 1 [ RunTime:0.000240s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 777 LIMIT 1 [ RunTime:0.000211s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 850 LIMIT 1 [ RunTime:0.000207s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 856 LIMIT 1 [ RunTime:0.000219s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 858 LIMIT 1 [ RunTime:0.000249s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 908 LIMIT 1 [ RunTime:0.000229s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 953 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 957 LIMIT 1 [ RunTime:0.000228s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 962 LIMIT 1 [ RunTime:0.000248s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 993 LIMIT 1 [ RunTime:0.000221s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 994 LIMIT 1 [ RunTime:0.000226s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1081 LIMIT 1 [ RunTime:0.000241s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1139 LIMIT 1 [ RunTime:0.000245s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1167 LIMIT 1 [ RunTime:0.000219s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1173 LIMIT 1 [ RunTime:0.000205s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1404 LIMIT 1 [ RunTime:0.000196s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1465 LIMIT 1 [ RunTime:0.000232s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1492 LIMIT 1 [ RunTime:0.000240s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1495 LIMIT 1 [ RunTime:0.000240s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1515 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1522 LIMIT 1 [ RunTime:0.000297s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1640 LIMIT 1 [ RunTime:0.000238s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1694 LIMIT 1 [ RunTime:0.000233s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1698 LIMIT 1 [ RunTime:0.000230s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1702 LIMIT 1 [ RunTime:0.000231s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1812 LIMIT 1 [ RunTime:0.000201s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1869 LIMIT 1 [ RunTime:0.000219s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1886 LIMIT 1 [ RunTime:0.000211s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1913 LIMIT 1 [ RunTime:0.000230s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2012 LIMIT 1 [ RunTime:0.000229s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2030 LIMIT 1 [ RunTime:0.000227s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2052 LIMIT 1 [ RunTime:0.000224s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2100 LIMIT 1 [ RunTime:0.000331s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2144 LIMIT 1 [ RunTime:0.000255s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2156 LIMIT 1 [ RunTime:0.000244s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2263 LIMIT 1 [ RunTime:0.000238s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2317 LIMIT 1 [ RunTime:0.000238s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2339 LIMIT 1 [ RunTime:0.000196s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2349 LIMIT 1 [ RunTime:0.000204s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2352 LIMIT 1 [ RunTime:0.000194s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 23 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.001118s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 432 LIMIT 1 [ RunTime:0.000384s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 463 LIMIT 1 [ RunTime:0.000260s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 479 LIMIT 1 [ RunTime:0.000210s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 615 LIMIT 1 [ RunTime:0.000223s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1028 LIMIT 1 [ RunTime:0.000210s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1029 LIMIT 1 [ RunTime:0.000201s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1393 LIMIT 1 [ RunTime:0.000215s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 1464 LIMIT 1 [ RunTime:0.000223s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2147 LIMIT 1 [ RunTime:0.000259s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2154 LIMIT 1 [ RunTime:0.000245s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2178 LIMIT 1 [ RunTime:0.000244s ]
- [ SQL ] SELECT SUM(score_v2) AS tp_sum FROM `review` WHERE `award_project_id` = 2519 LIMIT 1 [ RunTime:0.000224s ]
- [ SQL ] SELECT * FROM `award_project` WHERE `category_id` = 0 AND `ranked` = 1 AND `payed` = 1 AND `rankedyear` IN ('2019','2020') [ RunTime:0.000610s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000368s ]
- [ SQL ] SELECT * FROM `config` WHERE `name` = 'openart' LIMIT 1 [ RunTime:0.000289s ]
0.155705s
