SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
IF(rate.count IS NULL, 0, rate.count) AS thread_rate_count, IF(rate.sum IS NULL, 0, rate.sum) AS thread_rate_sum, IF(rate.avg IS NULL, 0, rate.avg) AS thread_rate_avg
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN ns_threadrating_rate AS rate ON (rate.thread_id = thread.thread_id)
WHERE thread.thread_id = ?
Params: 22763
Run Time: 0.006030
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | rate | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 15
Run Time: 0.000639
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 180 AND post.position < 200)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 22763
Run Time: 0.005135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 20 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,user_nextstagerussia.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,user_nextstagerussia.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | user_nextstagerussia.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 22763
Run Time: 0.000384
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=22763&page=10, 1714779284,
Run Time: 0.000553
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 779547, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Каин, post: 779545, member: 3850";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Каин, post: 779545, member: 3850"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:5:"tweet";s:8:"original";a:2:{i:0;s:13:"[MEDIA=tweet]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:18:"971756643938545670";}}}}i:1;s:75:"
Пойдёт лесом :))) ведь есть про контроллер";}, 1701116101, 1714779284
Run Time: 0.004053
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 4, a:2:{i:0;s:58:"vova: Versatile Online Violence Android
SW 6368 9221 0229
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:45:"https://card.psnprofiles.com/1/Wiizardwii.png";}}}, 1701116101, 1714779284
Run Time: 0.000462
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 779557, a:2:{i:0;s:23:"Через 3 часа:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"ES0zWwqRm1A";}}}, 1701116101, 1714779284
Run Time: 0.000385
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 3212, a:1:{i:0;s:17:"There only be ONE";}, 1701116101, 1714779284
Run Time: 0.000312
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 779600, a:1:{i:0;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"NsFna-Z1MjU";}}}, 1701116101, 1714779284
Run Time: 0.000402
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 779874, a:2:{i:0;s:38:"Ниндюшатину покажут
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"https://pbs.twimg.com/media/DYXltmEVAAAm9id.jpg";}}}, 1701116101, 1714779284
Run Time: 0.000439
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 777, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:45:"https://www.trueachievements.com/gamer/Chakie";s:8:"original";a:2:{i:0;s:51:"[URL=https://www.trueachievements.com/gamer/Chakie]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:54:"https://www.trueachievements.com/gamercards/Chakie.png";}}}}}, 1701116101, 1714779284
Run Time: 0.000371
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 786063, a:2:{i:0;s:215:"Блять, можно подумать нам было мало полчаса на E3, посвященному смэшбросу. Давайте еще и новый дайрект под него займем:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:5:"tweet";s:8:"original";a:2:{i:0;s:13:"[MEDIA=tweet]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:19:"1026203451712319488";}}}, 1701116101, 1714779284
Run Time: 0.016691
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 786065, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"dimm, post: 786063, member: 3212";s:8:"original";a:2:{i:0;s:42:"[QUOTE="dimm, post: 786063, member: 3212"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:2:{i:0;s:215:"Блять, можно подумать нам было мало полчаса на E3, посвященному смэшбросу. Давайте еще и новый дайрект под него займем:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:5:"tweet";s:8:"original";a:2:{i:0;s:13:"[MEDIA=tweet]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:19:"1026203451712319488";}}}}i:1;s:79:"
Ну может кто-то подзабыл или не все понял )))";}, 1701116101, 1714779284
Run Time: 0.000846
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 786697, a:2:{i:0;s:42:"Сегодняшнее нинди-шоу:
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"qNUSrhEEvL0";}}}, 1701116101, 1714779284
Run Time: 0.014271
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787171, a:6:{i:0;s:68:"Америкосам сегодня показали директ.
";i:1;a:4:{s:3:"tag";s:5:"quote";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[QUOTE]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:1:"
";i:1;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:15:{i:0;s:1426:"
[*]Into the Breach: The hit turn-based strategy game is headed to Nintendo Switch. In the stylish Into the Breach, players will suit up in powerful mechs and defend against the Vek infestation across randomly generated islands. Players can perfect their strategy and build the ultimate mech by finding powerful new weapons and unique pilots throughout the campaign. Into the Breach is available for Nintendo Switch starting … TODAY!
[*]Hyper Light Drifter – Special Edition: In the Nintendo Switch version of this critically acclaimed action/adventure game, players can equip an exclusive outfit that will help them locate hidden items. The Special Edition also includes new weapons like the Crystal Shot and deadly Blade Caster. Hyper Light Drifter – Special Edition is available for pre-purchase today, and launches for Nintendo Switch on Sept. 6.
[*]TowerFall: Anyone who is interested in the indie game scene has most likely heard of TowerFall. The extremely popular action game is beloved by many people for its slick fast-paced gameplay and raucous local multiplayer matches. This version of the game includes all the original and add-on content, as well as a new six-player battle mode, four additional Variants and the ability to play as Madeline and Badeline, two characters from indie game Celeste. TowerFall ascends onto Nintendo Switch on Sept. 27, but is also available for pre-purchase starting today.
[*]";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:241:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Ftreasure-stack-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Treasure+Stack&index=8&md5=7cacda7be15fa89112c1c518d83e2d0b";s:8:"original";a:2:{i:0;s:249:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Ftreasure-stack-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Treasure+Stack&index=8&md5=7cacda7be15fa89112c1c518d83e2d0b']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:14:"Treasure Stack";}}i:2;s:806:": Treasure Stack adds a unique platforming mechanic with hookshots and grappling hooks to the traditional falling block puzzle formula. In the game, players control a whimsical cast of heroes as they navigate obstacles to stack treasure chests and solve puzzles. With cross-platform play with Xbox One and PC, players will be able to stack online with even more players. Treasure Stack launches for Nintendo Switch this winter.
[*]Zarvot: Charcoal and Mustard are the stars of this charming arcade game about friendship among cubes. In the game’s story mode, players adventure through nine worlds as they attempt to cheer up their best friend. And in Versus Mode, friends can challenge friends to some cutthroat cube action across five game modes. Zarvot launches first on Nintendo Switch in October.
[*]";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:256:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fminekos-night-market-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Mineko%27s+Night+Market&index=9&md5=2b884f83e801f13c68bbe55bc621982b";s:8:"original";a:2:{i:0;s:264:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fminekos-night-market-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Mineko%27s+Night+Market&index=9&md5=2b884f83e801f13c68bbe55bc621982b']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:23:"Mineko’s Night Market";}}i:4;s:451:": While Mineko’s Night Market boasts more than 20 hours of story-based gameplay, including four regions to explore, diverse villagers to meet, interesting quests to undertake, and activities like sewing and woodworking to partake in, it also features cats. A lot of them. But even though this is a game starring cats, dog people will love it as well! Mineko’s Night Market opens for business first on consoles on Nintendo Switch in early 2019.
[*]";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:242:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fsamurai-gunn-2-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Samurai+Gunn+2&index=10&md5=6d1534a4c2ea65d03892946fbb7deb4c";s:8:"original";a:2:{i:0;s:250:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fsamurai-gunn-2-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Samurai+Gunn+2&index=10&md5=6d1534a4c2ea65d03892946fbb7deb4c']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:14:"Samurai Gunn 2";}}i:6;s:765:": This sequel to the original lightning-fast Bushido brawler features a new adventure mode. Players can explore a medieval metropolis on the brink of crisis to discover the mystery behind Gunn City’s ghostly threat. Classic Versus Mode returns, with up to four players battling it out in sword-and-gun battles. Samurai Gunn 2launches on Nintendo Switch in early 2019.
[*]Bullet Age: In this co-op action game, players can team up with another player in an intuitive mix of sword-and-gun gameplay. Bullet Age also features challenging platforming, fully upgradable weapons and a charming cartoon art style. Players will feel HD Rumble when they attack and when locating hidden secrets. Bullet Age launches as a console exclusive on Nintendo Switch in November.
[*]";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:252:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fthe-world-next-door-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=The+World+Next+Door&index=11&md5=ff5cf742565248bc2f934f5aee297773";s:8:"original";a:2:{i:0;s:260:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fthe-world-next-door-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=The+World+Next+Door&index=11&md5=ff5cf742565248bc2f934f5aee297773']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:19:"The World Next Door";}}i:8;s:419:": Influenced by anime, The World Next Door is a story-driven game that follows a rebellious teenage girl trapped in a parallel world inhabited by magical creatures. Players will meet and develop friendships with an eclectic cast of characters by means of a reputation system, which features branching dialogue based on player choice. The World Next Door becomes a friendly neighbor on Nintendo Switch in early 2019.
[*]";i:9;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:232:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Flevelhead-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Levelhead&index=12&md5=256e2c09140bf2ab9da33498fe1a228d";s:8:"original";a:2:{i:0;s:240:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Flevelhead-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Levelhead&index=12&md5=256e2c09140bf2ab9da33498fe1a228d']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:9:"Levelhead";}}i:10;s:709:": Players that have a head for level building have found a game for them. In Levelhead, players can design their own game levels using a robust level maker using both touch-screen and traditional controls. Subscribing to other people’s content allows players to create a curated feed of levels they can play. With leaderboards, level sharing and couch co-op, the possibilities are endless! With cross-platform capabilities, content can be shared with players on all platforms that also support Levelhead, including PC, iOS and Android. Players can also take control of GR-18, a delivery robot in training, through a full-fledged single-player campaign. Levelhead launches on Nintendo Switch in November.
[*]";i:11;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:244:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fking-of-the-hat-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=King+of+the+Hat&index=13&md5=63b3f6fb24cf814705e0e99f138bf940";s:8:"original";a:2:{i:0;s:252:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Fking-of-the-hat-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=King+of+the+Hat&index=13&md5=63b3f6fb24cf814705e0e99f138bf940']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:15:"King of the Hat";}}i:12;s:456:": This fast-paced, hat-based party game finds players crushing their friends’ hats before they crush their own! All in game, of course. No actual hats were harmed in the making of this game. Matches in the game are short and action-packed – perfect for playing on the couch or on the go. And thanks to simple two-button controls, anyone can pick up and play in local or online multiplayer. King of the Hat launches on Nintendo Switch in early 2019.
[*]";i:13;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:252:"http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Funtitled-goose-game-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Untitled+Goose+Game&index=14&md5=0f2b2abc0dd32924dcdb00893ed5da4b";s:8:"original";a:2:{i:0;s:260:"[URL='http://cts.businesswire.com/ct/CT?id=smartlink&url=https%3A%2F%2Fwww.nintendo.com%2Fgames%2Fdetail%2Funtitled-goose-game-switch&esheet=51858371&newsitemid=20180828005261&lan=en-US&anchor=Untitled+Goose+Game&index=14&md5=0f2b2abc0dd32924dcdb00893ed5da4b']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:19:"Untitled Goose Game";}}i:14;s:303:": With a name like Untitled Goose Game, what’s not to love? In a game that defies all genres, Untitled Goose Game is part stealth, part sandbox and all goose simulator. Play as a goose to take on challenges and cause general goose chaos. Untitled Goose Game launches on Nintendo Switch in early 2019.
";}}i:2;s:1:"
";}}i:2;s:94:"
Additional indie games that are coming to Nintendo Switch this year include the following:
";i:3;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:317:"
[*]The Messenger (Aug. 30)
[*]Bastion (Sept. 13)
[*]Wasteland 2: Director’s Cut (Sept. 13)
[*]Undertale (Sept. 18)
[*]Light Fingers (Sept. 20)
[*]Superbrothers: Sword & Sworcery EP (October)
[*]Jackbox Party Pack 5 (October)
[*]Transistor (November)
[*]Desert Child (December)
[*]Dragon Marked for Death (Dec. 13)
";}}i:4;s:2:"
";i:5;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"UHzsecqX-zU";}}}, 1701116101, 1714779284
Run Time: 0.007888
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787469, a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"https://pbs.twimg.com/media/DmVeI9cVsAAfdFl.jpg";}}}, 1701116101, 1714779284
Run Time: 0.004899
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787471, a:1:{i:0;s:30:"Теку как сучка )))";}, 1701116101, 1714779284
Run Time: 0.000519
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787483, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 787469, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 787469, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"https://pbs.twimg.com/media/DmVeI9cVsAAfdFl.jpg";}}}}i:1;s:63:"
Перенесли на неопределенный срок
";i:2;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:5:"tweet";s:8:"original";a:2:{i:0;s:13:"[MEDIA=tweet]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:19:"1037596415999004672";}}}, 1701116101, 1714779284
Run Time: 0.000357
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787489, a:1:{i:0;s:32:"бедный вова :rolleyes:";}, 1701116101, 1714779284
Run Time: 0.000416
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787496, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Каин, post: 787489, member: 3850";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Каин, post: 787489, member: 3850"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:32:"бедный вова :rolleyes:";}}i:1;s:44:"
Не увижу 30 минут смэша :(";}, 1701116101, 1714779284
Run Time: 0.000520
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787725, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 787483, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 787483, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:2:{i:0;s:62:"Перенесли на неопределенный срок
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:5:"tweet";s:8:"original";a:2:{i:0;s:13:"[MEDIA=tweet]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:19:"1037596415999004672";}}}}i:1;s:1:"
";i:2;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"https://pbs.twimg.com/media/Dm5hne_VsAEziRQ.jpg";}}}, 1701116101, 1714779284
Run Time: 0.001800
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787732, a:1:{i:0;s:180:"Ну если утечка про дату директа оказалась верной, то может инфа про новую зельду тоже будет верной.";}, 1701116101, 1714779284
Run Time: 0.023331
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787734, a:1:{i:0;s:71:"что такое директ? уже начинать дрочить?";}, 1701116101, 1714779284
Run Time: 0.000411
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 146, a:1:{i:0;s:242:"Хурма - Бешеная (01:43)
Сашенька! Хочу слюнявить твой клиторок и верезжать как ослик
Бешеная (02:37) Ребят вы придурки))))) но я вас обожаю))))";}, 1701116101, 1714779284
Run Time: 0.000424
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787735, a:1:{i:0;s:55:"И массировать простату :nailbiting:";}, 1701116101, 1714779284
Run Time: 0.000555
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787736, a:1:{i:0;s:66:"Что, ещё полчаса смэш-броса покажут?)";}, 1701116101, 1714779284
Run Time: 0.008026
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: signature, 2988, a:2:{i:0;s:117:"Монахи Шаолиня могут многое, но в основном шароёбятся без дела.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:35:"http://psnprofiles.com/hidding88_87";s:8:"original";a:2:{i:0;s:43:"[URL='http://psnprofiles.com/hidding88_87']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:47:"https://card.psnprofiles.com/1/hidding88_87.png";}}}}}, 1701116101, 1714779284
Run Time: 0.000279
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787738, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"RussianSwine, post: 787736, member: 2988";s:8:"original";a:2:{i:0;s:50:"[QUOTE="RussianSwine, post: 787736, member: 2988"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:66:"Что, ещё полчаса смэш-броса покажут?)";}}i:1;s:95:"
Смэш, марио с вию и зельда какая-то )) это типа утечка";}, 1701116101, 1714779284
Run Time: 0.000342
INSERT INTO xf_bb_code_parse_cache
(content_type, content_id, parse_tree, cache_version, cache_date)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
cache_version = VALUES(cache_version),
cache_date = VALUES(cache_date)
Params: post, 787739, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 787738, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 787738, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:94:"Смэш, марио с вию и зельда какая-то )) это типа утечка";}}i:1;s:112:"
Марио с Вии Ю хорошо - надеюсь 3d world. Зельда - три раза ха! :ROFLMAO:";}, 1701116101, 1714779284
Run Time: 0.005546