基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-05-18 22:00:12 HTTP/1.1 GET : wap.yyhuyu.com/game/detail?game_id=6049
- 运行时间 : 0.249215s [ 吞吐率:4.01req/s ] 内存消耗:8,914.59kb 文件加载:285
- 查询信息 : 104 queries 1 writes
- 缓存信息 : 240 reads,35 writes
- 配置加载 : 118
- 会话信息 : SESSION_ID=7u1i5uh3f8u2f4dbgbi8hca0d4
- [ 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.001174s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6049 [ RunTime:0.000604s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001023s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6049 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000879s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_server` [ RunTime:0.001113s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game_server` WHERE `is_delete` = 2 AND `app_id` = 6049 AND `start_time` > 1716040813 LIMIT 1 [ RunTime:0.000684s ]
- [ SQL ] SHOW COLUMNS FROM `h_posts` [ RunTime:0.001783s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716040813 AND `published_time` <= 1716040813 ) AND `post_type` = 2 AND `app_id` = 6049 AND `end_time` > 1716040813 ORDER BY `published_time` DESC [ RunTime:0.000784s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716040813 AND `published_time` <= 1716040813 ) AND `post_type` = 1 AND `app_id` = 6049 ORDER BY `published_time` DESC [ RunTime:0.000750s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_category` [ RunTime:0.000883s ]
- [ SQL ] SELECT `app_id` FROM `h_game_category` WHERE `cate_id` IN (10059) AND `app_id` NOT IN (100,101) ORDER BY `list_order` DESC,`id` DESC [ RunTime:0.000774s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `id` IN (6282,6236,6210,6208,6207,6206,6148,6156,6128,6000,6118,6076) AND `is_sdk` = 2 AND `classify` = 3 AND `is_delete` = 2 AND `status` = 2 [ RunTime:0.000775s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6282 [ RunTime:0.000598s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_version` [ RunTime:0.000994s ]
- [ SQL ] SELECT * FROM `h_game_version` WHERE `id` = 314 LIMIT 1 [ RunTime:0.000708s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001045s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6282 AND `post_type` = 11 LIMIT 1 [ RunTime:0.000772s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6282 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000715s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6282 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000722s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000764s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6236 [ RunTime:0.000631s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000994s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6236 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000774s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6236 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000777s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000876s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 6208 LIMIT 1 [ RunTime:0.001033s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6208 [ RunTime:0.000579s ]
- [ SQL ] SELECT `id` FROM `h_game_version` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6208 LIMIT 1 [ RunTime:0.000649s ]
- [ SQL ] SELECT * FROM `h_game_version` WHERE `id` = 240 LIMIT 1 [ RunTime:0.001093s ]
- [ SQL ] SHOW COLUMNS FROM `h_agent_game_rate` [ RunTime:0.001278s ]
- [ SQL ] SELECT `id` FROM `h_agent_game_rate` WHERE `app_id` = 6208 AND `agent_id` = 0 LIMIT 1 [ RunTime:0.000800s ]
- [ SQL ] SELECT * FROM `h_agent_game_rate` WHERE `id` = 5908 LIMIT 1 [ RunTime:0.000720s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000859s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6208 AND `post_type` = 11 LIMIT 1 [ RunTime:0.000709s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 290 LIMIT 1 [ RunTime:0.000748s ]
- [ SQL ] SHOW COLUMNS FROM `h_agent_game` [ RunTime:0.002347s ]
- [ SQL ] SELECT `id` FROM `h_agent_game` WHERE `agent_id` = 0 AND `app_id` = 6208 LIMIT 1 [ RunTime:0.000700s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6208 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000704s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6208 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000959s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 291 LIMIT 1 [ RunTime:0.000814s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 6206 LIMIT 1 [ RunTime:0.000899s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6206 [ RunTime:0.000614s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_ext` [ RunTime:0.001114s ]
- [ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6206 LIMIT 1 [ RunTime:0.000636s ]
- [ SQL ] SELECT `id` FROM `h_game_version` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6206 LIMIT 1 [ RunTime:0.000597s ]
- [ SQL ] SELECT * FROM `h_game_version` WHERE `id` = 238 LIMIT 1 [ RunTime:0.000601s ]
- [ SQL ] SELECT `id` FROM `h_agent_game_rate` WHERE `app_id` = 6206 AND `agent_id` = 0 LIMIT 1 [ RunTime:0.000512s ]
- [ SQL ] SELECT * FROM `h_agent_game_rate` WHERE `id` = 5907 LIMIT 1 [ RunTime:0.000613s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000863s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6206 AND `post_type` = 11 LIMIT 1 [ RunTime:0.000687s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 287 LIMIT 1 [ RunTime:0.000721s ]
- [ SQL ] SELECT `id` FROM `h_agent_game` WHERE `agent_id` = 0 AND `app_id` = 6206 LIMIT 1 [ RunTime:0.000687s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6206 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000711s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6206 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000726s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 289 LIMIT 1 [ RunTime:0.000748s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6156 [ RunTime:0.000717s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6156 [ RunTime:0.000991s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000843s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6156 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000759s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6156 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000848s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000725s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 6128 LIMIT 1 [ RunTime:0.000768s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6128 [ RunTime:0.000612s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 6129 LIMIT 1 [ RunTime:0.000792s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6128 [ RunTime:0.000758s ]
- [ SQL ] SELECT * FROM `h_game_ext` WHERE `app_id` = 6128 LIMIT 1 [ RunTime:0.000652s ]
- [ SQL ] SELECT `id` FROM `h_game_version` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND ( `is_default` = 2 AND `is_default` = 2 ) AND `app_id` = 6128 LIMIT 1 [ RunTime:0.000742s ]
- [ SQL ] SELECT * FROM `h_game_version` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000769s ]
- [ SQL ] SELECT `id` FROM `h_agent_game_rate` WHERE `app_id` = 6128 AND `agent_id` = 0 LIMIT 1 [ RunTime:0.000686s ]
- [ SQL ] SELECT * FROM `h_agent_game_rate` WHERE `id` = 2550 LIMIT 1 [ RunTime:0.000795s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000787s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6128 AND `post_type` = 11 LIMIT 1 [ RunTime:0.000685s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000745s ]
- [ SQL ] SELECT `id` FROM `h_agent_game` WHERE `agent_id` = 0 AND `app_id` = 6128 LIMIT 1 [ RunTime:0.000642s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6128 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000652s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716040813 AND `app_id` = 6128 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000721s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001099s ]
- [ SQL ] SHOW COLUMNS FROM `h_comment` [ RunTime:0.000975s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000671s ]
- [ SQL ] SELECT SUM(star_cnt) AS tp_sum FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 2 ) AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000835s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` IN (1,2) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000671s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` IN (3,4) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000697s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` IN (5,6) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000614s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` IN (7,8) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000590s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6049 AND `table_name` = 'game' AND `star_cnt` IN (9,10) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000670s ]
- [ SQL ] UPDATE `h_game_ext` SET `agent_cnt`=0,`gift_cnt`=0,`real_gift_cnt`=0,`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`=31,`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` = 6049 [ RunTime:0.000661s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `object_id` = 6049 AND `table_name` = 'game' AND `parent_id` = 0 AND ( `status` = 2 ) LIMIT 1 [ RunTime:0.000678s ]
- [ SQL ] SELECT * FROM `h_comment` WHERE `object_id` = 6049 AND `table_name` = 'game' AND `parent_id` = 0 AND ( `status` = 2 ) ORDER BY `create_time` DESC LIMIT 0,3 [ RunTime:0.000760s ]
- [ SQL ] SHOW COLUMNS FROM `h_member` [ RunTime:0.001007s ]
- [ SQL ] SELECT * FROM `h_member` WHERE `id` = 13000 LIMIT 1 [ RunTime:0.000665s ]
- [ SQL ] SHOW COLUMNS FROM `h_country_conf` [ RunTime:0.000946s ]
- [ SQL ] SELECT `mobile_prefix` FROM `h_country_conf` WHERE `is_delete` = 2 AND `cn_name_abbr` = '中国' LIMIT 1 [ RunTime:0.000628s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 1 ) AND `object_id` = 6049 AND `table_name` = 'game' AND `parent_id` = 616 LIMIT 1 [ RunTime:0.000578s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_qq` [ RunTime:0.001460s ]
- [ SQL ] SELECT `id` FROM `h_game_qq` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND `app_id` = 6049 AND `status` = 2 LIMIT 1 [ RunTime:0.000626s ]
- [ SQL ] SELECT * FROM `h_game_qq` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000552s ]
0.252084s