基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-05-18 23:04:47 HTTP/1.1 GET : wap.yyhuyu.com/game/detail?game_id=6054
- 运行时间 : 0.200631s [ 吞吐率:4.98req/s ] 内存消耗:8,652.25kb 文件加载:278
- 查询信息 : 94 queries 1 writes
- 缓存信息 : 374 reads,1 writes
- 配置加载 : 118
- 会话信息 : SESSION_ID=8e8tp202umu1betaqfkpg1faph
- [ 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.001028s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6054 [ RunTime:0.000556s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6054 [ RunTime:0.000771s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000864s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6054 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000661s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_server` [ RunTime:0.000917s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game_server` WHERE `is_delete` = 2 AND `app_id` = 6054 AND `start_time` > 1716044687 LIMIT 1 [ RunTime:0.000620s ]
- [ SQL ] SHOW COLUMNS FROM `h_posts` [ RunTime:0.000957s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716044687 AND `published_time` <= 1716044687 ) AND `post_type` = 2 AND `app_id` = 6054 AND `end_time` > 1716044687 ORDER BY `published_time` DESC [ RunTime:0.000741s ]
- [ SQL ] SELECT `id`,`post_title` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND ( `published_time` BETWEEN 1 AND 1716044687 AND `published_time` <= 1716044687 ) AND `post_type` = 1 AND `app_id` = 6054 ORDER BY `published_time` DESC [ RunTime:0.000677s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_category` [ RunTime:0.000802s ]
- [ SQL ] SELECT `app_id` FROM `h_game_category` WHERE `cate_id` IN (10062) 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 (6273,6263,6238,6233,6216,6215,6210,6202,6181,6185,6184,6180,6176,6167,6166,6029,6027,6139,6130,6122,6121,6120,6119,6118,6112,6105,6106,6102,6103,6101,6077,6044,6076,6033,6034,6083,6082,6036,6079,6078,6071,6070,6048,6067,6066,6053,6052,6030,6012,6006,6000) AND `is_sdk` = 2 AND `classify` = 3 AND `is_delete` = 2 AND `status` = 2 [ RunTime:0.001245s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6273 [ RunTime:0.000568s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000883s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6273 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000608s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6273 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.000685s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6238 [ RunTime:0.000550s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000897s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6238 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000726s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6238 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000719s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000808s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6215 [ RunTime:0.000617s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6215 [ RunTime:0.000896s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001015s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6215 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000785s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6215 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000649s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000709s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6184 [ RunTime:0.000546s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6184 [ RunTime:0.000892s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000978s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6184 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 1716044687 AND `app_id` = 6184 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000787s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000830s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6180 [ RunTime:0.000660s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6180 [ RunTime:0.000755s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000954s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6180 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000687s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6180 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000808s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000804s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6176 [ RunTime:0.000720s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6176 [ RunTime:0.000857s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000836s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6176 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000610s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6176 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000780s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000747s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6166 [ RunTime:0.000593s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `mg_parent_id` = 6166 [ RunTime:0.000841s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000842s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6166 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000572s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6166 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.000728s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6130 [ RunTime:0.000589s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000831s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6130 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000634s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6130 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000697s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000748s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6122 [ RunTime:0.000602s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000867s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6122 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000647s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6122 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000689s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000740s ]
- [ SQL ] SELECT `id` FROM `h_game` WHERE `parent_id` = 6121 [ RunTime:0.000565s ]
- [ SQL ] SELECT * FROM `h_game` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000829s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_game` WHERE `parent_id` = 6121 AND `is_sdk` = 1 AND `status` = 2 AND `is_delete` = 2 LIMIT 1 [ RunTime:0.000593s ]
- [ SQL ] SELECT `id` FROM `h_posts` WHERE `delete_time` = 0 AND `post_status` = 2 AND `published_time` BETWEEN 1 AND 1716044687 AND `app_id` = 6121 AND `post_type` = 12 ORDER BY `published_time` DESC LIMIT 1 [ RunTime:0.000669s ]
- [ SQL ] SELECT * FROM `h_posts` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000760s ]
- [ SQL ] SHOW COLUMNS FROM `h_comment` [ RunTime:0.001005s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000768s ]
- [ SQL ] SELECT SUM(star_cnt) AS tp_sum FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 2 ) AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` > 0 AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000722s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` IN (1,2) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000692s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` IN (3,4) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000658s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` IN (5,6) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000668s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` IN (7,8) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000756s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `status` = 2 AND `object_id` = 6054 AND `table_name` = 'game' AND `star_cnt` IN (9,10) AND `parent_id` = 0 LIMIT 1 [ RunTime:0.000830s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_ext` [ RunTime:0.000909s ]
- [ 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`=9.9,`like_cnt`=0,`share_cnt`=0,`active_cnt`=0,`down_cnt`=3397532,`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` = 6054 [ RunTime:0.000692s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `object_id` = 6054 AND `table_name` = 'game' AND `parent_id` = 0 AND ( `status` = 2 ) LIMIT 1 [ RunTime:0.000867s ]
- [ SQL ] SELECT * FROM `h_comment` WHERE `object_id` = 6054 AND `table_name` = 'game' AND `parent_id` = 0 AND ( `status` = 2 ) ORDER BY `create_time` DESC LIMIT 0,3 [ RunTime:0.000908s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 1 ) AND `object_id` = 6054 AND `table_name` = 'game' AND `parent_id` = 611 LIMIT 1 [ RunTime:0.000641s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 1 ) AND `object_id` = 6054 AND `table_name` = 'game' AND `parent_id` = 609 LIMIT 1 [ RunTime:0.000550s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `h_comment` WHERE `delete_time` = 0 AND ( `status` = 2 AND `status` = 1 ) AND `object_id` = 6054 AND `table_name` = 'game' AND `parent_id` = 545 LIMIT 1 [ RunTime:0.000583s ]
- [ SQL ] SHOW COLUMNS FROM `h_game_qq` [ RunTime:0.000869s ]
- [ SQL ] SELECT `id` FROM `h_game_qq` WHERE ( `is_delete` = 2 AND `is_delete` = 2 ) AND `app_id` = 6054 AND `status` = 2 LIMIT 1 [ RunTime:0.000576s ]
- [ SQL ] SELECT * FROM `h_game_qq` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000567s ]
0.202365s