Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2021-12-17T19:59:13.826508Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.827465Z 266 Query set session transaction isolation level repeatable read
- 2021-12-17T19:59:13.828458Z 266 Query start transaction
- 2021-12-17T19:59:13.829801Z 266 Query UPDATE `user_sessions` SET `last_modified` = timestamp('2021-12-17 19:59:15.699848')
- WHERE `user_guid` = '66358d2c-cfde-4840-b507-a997e4bbbe7c' AND `session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1';
- 2021-12-17T19:59:13.830358Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T19:59:13.831439Z 266 Query commit
- 2021-12-17T19:59:13.843386Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.844469Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T19:59:13.847507Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.849064Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T19:59:13.851665Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.852688Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T19:59:13.855346Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.856946Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1'
- LIMIT 2
- 2021-12-17T19:59:13.860892Z 266 Query SET NAMES utf8mb4
- 2021-12-17T19:59:13.862777Z 266 Query set session transaction isolation level repeatable read
- 2021-12-17T19:59:13.863724Z 266 Query start transaction
- 2021-12-17T19:59:13.865049Z 266 Query UPDATE `user_sessions` SET `last_modified` = timestamp('2021-12-17 19:59:15.762829')
- WHERE `user_guid` = '66358d2c-cfde-4840-b507-a997e4bbbe7c' AND `session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1';
- 2021-12-17T19:59:13.865203Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T19:59:13.866331Z 266 Query commit
- 2021-12-17T20:00:03.053338Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.054590Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.082790Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.083882Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.088286Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.089451Z 266 Query set session transaction isolation level repeatable read
- 2021-12-17T20:00:03.090452Z 266 Query start transaction
- 2021-12-17T20:00:03.091890Z 266 Query INSERT INTO `photon_room_user_log` (`action`, `photon_region`, `photon_room_guid`, `timestamp`, `user_guid`, `world_guid`)
- VALUES ('U', 'us', 'b258f0a7-c58c-437f-a430-27d9b390c211', timestamp('2021-12-17 20:00:04.990727'), '66358d2c-cfde-4840-b507-a997e4bbbe7c', '8fa2080e-af64-456d-aeb7-ce9193340b4f');
- 2021-12-17T20:00:03.092510Z 266 Query SELECT `entry_id`
- FROM `photon_room_user_log`
- WHERE ROW_COUNT() = 1 AND `entry_id` = LAST_INSERT_ID()
- 2021-12-17T20:00:03.093965Z 266 Query INSERT INTO `photon_room_user_log` (`action`, `photon_region`, `photon_room_guid`, `timestamp`, `user_guid`, `world_guid`)
- VALUES ('U', 'us', 'b258f0a7-c58c-437f-a430-27d9b390c211', timestamp('2021-12-17 20:00:04.990917'), 'fddfab6c-f1b7-490a-b81e-05f6eb460431', '8fa2080e-af64-456d-aeb7-ce9193340b4f');
- 2021-12-17T20:00:03.094145Z 266 Query SELECT `entry_id`
- FROM `photon_room_user_log`
- WHERE ROW_COUNT() = 1 AND `entry_id` = LAST_INSERT_ID()
- 2021-12-17T20:00:03.095441Z 266 Query commit
- 2021-12-17T20:00:03.105593Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.106645Z 266 Query set session transaction isolation level repeatable read
- 2021-12-17T20:00:03.107598Z 266 Query start transaction
- 2021-12-17T20:00:03.110468Z 266 Query DELETE FROM `photon_room_users`
- WHERE `user_guid` = '66358d2c-cfde-4840-b507-a997e4bbbe7c' AND `photon_room_guid` = 'b258f0a7-c58c-437f-a430-27d9b390c211';
- 2021-12-17T20:00:03.111069Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.112245Z 266 Query DELETE FROM `photon_room_users`
- WHERE `user_guid` = 'fddfab6c-f1b7-490a-b81e-05f6eb460431' AND `photon_room_guid` = 'b258f0a7-c58c-437f-a430-27d9b390c211';
- 2021-12-17T20:00:03.112462Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.113419Z 266 Query DELETE FROM `photon_rooms`
- WHERE `photon_room_guid` = 'b258f0a7-c58c-437f-a430-27d9b390c211';
- 2021-12-17T20:00:03.113702Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.114514Z 266 Query commit
- 2021-12-17T20:00:03.126311Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.127605Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T20:00:03.130318Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.131500Z 266 Query set session transaction isolation level repeatable read
- 2021-12-17T20:00:03.132618Z 266 Query start transaction
- 2021-12-17T20:00:03.133709Z 266 Query DELETE FROM `user_sessions`
- WHERE `user_guid` = '66358d2c-cfde-4840-b507-a997e4bbbe7c' AND `session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1';
- 2021-12-17T20:00:03.134252Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.135334Z 266 Query DELETE FROM `user_sessions`
- WHERE `user_guid` = 'fddfab6c-f1b7-490a-b81e-05f6eb460431' AND `session_guid` = 'b7151a3a-f28b-4b11-92f5-58e2eb337544';
- 2021-12-17T20:00:03.135610Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.137010Z 266 Query DELETE FROM `user_sessions`
- WHERE `user_guid` = 'fddfab6c-f1b7-490a-b81e-05f6eb460431' AND `session_guid` = 'e4725903-deb4-4908-930f-a9f6959cf732';
- 2021-12-17T20:00:03.137268Z 266 Query SELECT ROW_COUNT()
- 2021-12-17T20:00:03.138323Z 266 Query commit
- 2021-12-17T20:00:03.147089Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.148337Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'e4725903-deb4-4908-930f-a9f6959cf732'
- LIMIT 2
- 2021-12-17T20:00:03.180028Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.181172Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.183807Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.184800Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.186882Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.187737Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T20:00:03.189961Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.190935Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'e4725903-deb4-4908-930f-a9f6959cf732'
- LIMIT 2
- 2021-12-17T20:00:03.324305Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.325736Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.349073Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.350327Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:03.353684Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.355071Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T20:00:03.357198Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.358411Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1'
- LIMIT 2
- 2021-12-17T20:00:03.453861Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.472585Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE (`u`.`user_guid` = 'fddfab6c-f1b7-490a-b81e-05f6eb460431') AND (`u`.`client_type` = 'U')
- LIMIT 2
- 2021-12-17T20:00:03.475375Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:03.476393Z 266 Query SELECT `p`.`photon_room_guid`, `p`.`friendly_id`, `p`.`game_rules`, `p`.`host_user_guid`, `p`.`is_private`, `p`.`max_players`, `p`.`photon_region`, `p`.`world_guid`
- FROM `photon_rooms` AS `p`
- WHERE `p`.`photon_room_guid` = 'b258f0a7-c58c-437f-a430-27d9b390c211'
- LIMIT 2
- 2021-12-17T20:00:04.440062Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:04.441134Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:04.444009Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:04.444989Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:00:04.447734Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:04.448777Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T20:00:04.451236Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:00:04.452197Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'e4725903-deb4-4908-930f-a9f6959cf732'
- LIMIT 2
- 2021-12-17T20:00:50.658064Z 268 Query /* mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout
- 2021-12-17T20:00:50.687128Z 268 Query SET NAMES utf8mb4
- 2021-12-17T20:00:50.707780Z 268 Query SET autocommit=1
- 2021-12-17T20:00:50.730823Z 268 Query select version(), @@version_comment, database()
- 2021-12-17T20:00:50.751546Z 268 Query show variables like 'aurora\_version'
- 2021-12-17T20:00:50.805488Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:00:50.828205Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ set session transaction read write
- 2021-12-17T20:00:50.880767Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:50.910276Z 268 Query SELECT @@session.transaction_read_only
- 2021-12-17T20:00:50.941096Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ use massiveloop_test
- 2021-12-17T20:00:50.980278Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:51.003496Z 268 Query SELECT @@session.transaction_read_only
- 2021-12-17T20:00:51.035569Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:51.058576Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ select database()
- 2021-12-17T20:00:51.085443Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:51.107517Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:51.128831Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SET net_write_timeout=600
- 2021-12-17T20:00:51.149386Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SELECT t.*
- FROM massiveloop_test.user_sessions t
- 2021-12-17T20:00:51.185314Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:51.227448Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:00:59.114310Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:00:59.134537Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ set session transaction read write
- 2021-12-17T20:00:59.154768Z 268 Query SELECT @@session.transaction_read_only
- 2021-12-17T20:00:59.178346Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:59.198839Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ select database()
- 2021-12-17T20:00:59.226288Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:59.247836Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:59.269042Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SET net_write_timeout=600
- 2021-12-17T20:00:59.288938Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SELECT t.*
- FROM massiveloop_test.user_sessions t
- 2021-12-17T20:00:59.317136Z 268 Query SHOW WARNINGS
- 2021-12-17T20:00:59.368397Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:01:02.559947Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:02.561337Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:01:02.580192Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:02.581364Z 266 Query SELECT `p0`.`user_guid`, `p0`.`photon_room_guid`, `p0`.`session_guid`, `p0`.`time_entered`, `p0`.`user_alias`, `p0`.`world_name`, `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`, `p1`.`photon_room_guid`, `p1`.`friendly_id`, `p1`.`game_rules`, `p1`.`host_user_guid`, `p1`.`is_private`, `p1`.`max_players`, `p1`.`photon_region`, `p1`.`world_guid`, (
- SELECT COUNT(*)
- FROM `photon_room_users` AS `p`
- WHERE `p1`.`photon_room_guid` = `p`.`photon_room_guid`), `p2`.`user_guid`, `p2`.`photon_room_guid`, `p2`.`session_guid`, `p2`.`time_entered`, `p2`.`user_alias`, `p2`.`world_name`
- FROM `photon_room_users` AS `p0`
- INNER JOIN `user_sessions` AS `u` ON `p0`.`session_guid` = `u`.`session_guid`
- INNER JOIN `photon_rooms` AS `p1` ON `p0`.`photon_room_guid` = `p1`.`photon_room_guid`
- LEFT JOIN `photon_room_users` AS `p2` ON `p1`.`photon_room_guid` = `p2`.`photon_room_guid`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- ORDER BY `p0`.`user_guid`, `p0`.`photon_room_guid`, `u`.`user_guid`, `u`.`session_guid`, `p1`.`photon_room_guid`, `p2`.`user_guid`, `p2`.`photon_room_guid`
- 2021-12-17T20:01:02.583849Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:02.585067Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`last_modified` < (UTC_TIMESTAMP() - time '0:10:00.000000')
- 2021-12-17T20:01:02.587768Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:02.589359Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = 'fa660667-91b4-48dc-a2b7-9dfb93a348b1'
- LIMIT 2
- 2021-12-17T20:01:30.095266Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:30.096380Z 266 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE (`u`.`user_guid` = '66358d2c-cfde-4840-b507-a997e4bbbe7c') AND (`u`.`client_type` = 'U')
- LIMIT 2
- 2021-12-17T20:01:30.098897Z 266 Query SET NAMES utf8mb4
- 2021-12-17T20:01:30.099879Z 266 Query SELECT `p`.`photon_room_guid`, `p`.`friendly_id`, `p`.`game_rules`, `p`.`host_user_guid`, `p`.`is_private`, `p`.`max_players`, `p`.`photon_region`, `p`.`world_guid`
- FROM `photon_rooms` AS `p`
- WHERE `p`.`photon_room_guid` = 'b258f0a7-c58c-437f-a430-27d9b390c211'
- LIMIT 2
- 2021-12-17T20:01:32.240647Z 267 Quit
- 2021-12-17T20:01:57.082618Z 265 Quit
- 2021-12-17T20:01:57.083285Z 266 Quit
- 2021-12-17T20:02:54.399100Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:02:54.419705Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ set session transaction read write
- 2021-12-17T20:02:54.441220Z 268 Query SELECT @@session.transaction_read_only
- 2021-12-17T20:02:54.471980Z 268 Query SHOW WARNINGS
- 2021-12-17T20:02:54.492538Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ select database()
- 2021-12-17T20:02:54.515856Z 268 Query SHOW WARNINGS
- 2021-12-17T20:02:54.537927Z 268 Query SHOW WARNINGS
- 2021-12-17T20:02:54.558613Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SET net_write_timeout=600
- 2021-12-17T20:02:54.579202Z 268 Query /* ApplicationName=DataGrip 2021.3.2 */ SELECT t.*
- FROM massiveloop_test.user_sessions t
- 2021-12-17T20:02:54.607546Z 268 Query SHOW WARNINGS
- 2021-12-17T20:02:54.651222Z 268 Query SELECT @@session.transaction_isolation
- 2021-12-17T20:02:59.738266Z 269 Connect mlbetauser@ml-beta-ws01.internal.cloudapp.net on massiveloop_beta using SSL/TLS
- 2021-12-17T20:02:59.739293Z 269 Query SET NAMES utf8mb4
- 2021-12-17T20:02:59.740072Z 269 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = '87fdf4cc-8f7d-463d-ab16-26ce06abdf37'
- LIMIT 2
- 2021-12-17T20:02:59.744251Z 269 Query SET NAMES utf8mb4
- 2021-12-17T20:02:59.745666Z 269 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = '87fdf4cc-8f7d-463d-ab16-26ce06abdf37'
- LIMIT 2
- 2021-12-17T20:02:59.749365Z 269 Query SET NAMES utf8mb4
- 2021-12-17T20:02:59.750271Z 269 Query set session transaction isolation level repeatable read
- 2021-12-17T20:02:59.751707Z 269 Query start transaction
- 2021-12-17T20:02:59.752674Z 269 Query UPDATE `user_sessions` SET `last_modified` = timestamp('2021-12-17 20:03:01.356709')
- WHERE `user_guid` = '78943d0e-6d4c-42d4-855c-202092a6a96b' AND `session_guid` = '87fdf4cc-8f7d-463d-ab16-26ce06abdf37';
- 2021-12-17T20:02:59.753316Z 269 Query SELECT ROW_COUNT()
- 2021-12-17T20:02:59.753912Z 269 Query commit
- 2021-12-17T20:02:59.763837Z 269 Query SET NAMES utf8mb4
- 2021-12-17T20:02:59.764779Z 269 Query SELECT `u`.`user_guid`, `u`.`session_guid`, `u`.`client_ip`, `u`.`client_type`, `u`.`created_at`, `u`.`last_modified`, `u`.`user_agent`
- FROM `user_sessions` AS `u`
- WHERE `u`.`session_guid` = '87fdf4cc-8f7d-463d-ab16-26ce06abdf37'
- LIMIT 2
- 2021-12-17T20:02:59.766957Z 269 Query SET NAMES utf8mb4
- 2021-12-17T20:02:59.768015Z 269 Query set session transaction isolation level repeatable read
- 2021-12-17T20:02:59.768858Z 269 Query start transaction
- 2021-12-17T20:02:59.769574Z 269 Query UPDATE `user_sessions` SET `last_modified` = timestamp('2021-12-17 20:03:01.379792')
- WHERE `user_guid` = '78943d0e-6d4c-42d4-855c-202092a6a96b' AND `session_guid` = '87fdf4cc-8f7d-463d-ab16-26ce06abdf37';
- 2021-12-17T20:02:59.769752Z 269 Query SELECT ROW_COUNT()
- 2021-12-17T20:02:59.770590Z 269 Query commit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement