:)
NO_ERROR
页面自动 跳转 等待时间: 3
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-05-18 21:33:07 HTTP/1.1 GET : wap.yyhuyu.com/game/detail?game_id=6057
- 运行时间 : 0.172129s [ 吞吐率:5.81req/s ] 内存消耗:7,518.77kb 文件加载:221
- 查询信息 : 89 queries 1 writes
- 缓存信息 : 373 reads,1 writes
- 配置加载 : 118
- 会话信息 : SESSION_ID=2642tvoq0t5rplcj5k23v4opqr
- [ RUN ] wap\wap\controller\GameController->detail[ /data/code/branch/v920220328/wap/wap/controller/GameController.php ]
- [ VIEW ] /data/code/branch/v920220328/simplewind/thinkphp/tpl/dispatch_jump.tpl [ array (
0 => 'site_info',
1 => 'agent_id',
2 => 'agent_site',
3 => 'h5i_site',
4 => 'static_site',
5 => 'baseUrl',
6 => 'staticUrl',
7 => 'code',
8 => 'msg',
9 => 'data',
10 => 'url',
11 => 'wait',
) ]
- [ SQL ] SHOW COLUMNS FROM `h_game` [ RunTime:0.001136s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6057 [ RunTime:0.000640s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000881s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6057 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000708s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_server` [ RunTime:0.000898s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game_server` WHERE `is_delete` = 2 AND `app_id` = 6057 AND `start_time` > 1716039187 LIMIT 1 [ RunTime:0.000681s ]
- [ SQL ] SHOW COLUMNS FROM `h_posts` [ RunTime:0.001007s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716039187 AND `published_time` <= 1716039187 ) AND `post_type` = 2 AND `app_id` = 6057 AND `end_time` > 1716039187 ORDER BY `published_time` DESC [ RunTime:0.000723s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716039187 AND `published_time` <= 1716039187 ) AND `post_type` = 1 AND `app_id` = 6057 ORDER BY `published_time` DESC [ RunTime:0.000677s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_category` [ RunTime:0.000982s ]
- [ SQL ] SELECT `app_id` FROM `h_game_category` WHERE `cate_id` IN (10074) AND `app_id` NOT IN (100,101) ORDER BY `list_order` DESC,`id` DESC [ RunTime:0.000736s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `id` IN (6288,6275,6271,6279,6204,6203,6199,6194,6164,6162,6161,6151,6149,6028,6145,6133,6132,6125,6124,6108,6107,6104,6103,6096,6097,6095,6094,6093,6088,6056,6008,6000) AND `is_sdk` = 2 AND `classify` = 3 AND `is_delete` = 2 AND `status` = 2 [ RunTime:0.000818s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6288 [ RunTime:0.000625s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000913s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6288 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000602s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6288 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000640s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000729s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6275 [ RunTime:0.000505s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000826s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6275 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000625s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6275 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000678s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000746s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6279 [ RunTime:0.000504s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000816s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6279 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000678s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6279 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000610s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000693s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6203 [ RunTime:0.000544s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000800s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6203 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000600s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6203 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000667s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000701s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6164 [ RunTime:0.000545s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6164 [ RunTime:0.000672s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000797s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6164 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000581s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6164 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000592s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000704s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6161 [ RunTime:0.000562s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6161 [ RunTime:0.000766s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000794s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6161 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000609s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6161 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000657s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000689s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6149 [ RunTime:0.000573s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000925s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6149 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000649s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6149 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000662s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000729s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6132 [ RunTime:0.000526s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6132 [ RunTime:0.000720s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000784s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6132 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000702s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6132 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000624s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000706s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6124 [ RunTime:0.000522s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6124 [ RunTime:0.000681s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000834s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6124 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000615s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6124 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000609s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000796s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6107 [ RunTime:0.000565s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6107 [ RunTime:0.000738s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000846s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6107 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000614s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716039187 AND `app_id` = 6107 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000571s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000773s ]
- [ SQL ] SHOW COLUMNS FROM `h_comment` [ RunTime:0.001016s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000650s ]
- [ SQL ] SELECT SUM(star_cnt) AS tp_sum FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 2 ) AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000618s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` IN (1,2) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000610s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` IN (3,4) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000607s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` IN (5,6) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000599s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` IN (7,8) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000584s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6057 AND `table_name` = 'game' AND `star_cnt` IN (9,10) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000541s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_ext` [ RunTime:0.000953s ]
- [ SQL ] UPDATE `h_game_ext` SET `agent_cnt`=0,`gift_cnt`=0,`real_gift_cnt`=101,`last_end_time`=0,`mem_cnt`=0,`add_down_cnt`=0,`install_cnt`=0,`star_cnt`=10,`like_cnt`=0,`share_cnt`=0,`active_cnt`=0,`down_cnt`=669845,`real_down_cnt`=0,`user_cnt`=0,`reg_device_cnt`=0,`reg_cnt`=0,`pay_user_cnt`=0,`first_pay_user_cnt`=0,`order_cnt`=0,`fail_order_cnt`=0,`un_order_cnt`=0,`reg_order_cnt`=0,`reg_pay_cnt`=0,`sum_money`=0,`first_pay_money`=0,`first_pay_sum_money`=0,`reg_sum_money`=0,`sum_real_money`=0 WHERE `app_id` = 6057 [ RunTime:0.000764s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `object_id` = 6057 AND `table_name` = 'game' AND `parent_id` = 0 AND ( `status` = 2 ) LIMIT 1 [ RunTime:0.000675s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_qq` [ RunTime:0.000876s ]
- [ SQL ] SELECT `id` FROM `h_game_qq` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND `app_id` = 6057 AND `status` = 2 LIMIT 1 [ RunTime:0.000575s ]
- [ SQL ] SELECT * FROM `h_game_qq` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000542s ]
0.173817s