SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000189
| 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: 119
Run Time: 0.001647
| 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: 45
Run Time: 0.000564
| 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 >= 3480 AND post.position < 3500)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 119
Run Time: 0.073923
| 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 |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (796263, 796358, 796756)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000846
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 5 | Using index condition |
| SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | user_nextstagerussia.attachment.data_id | 1 | |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 119
Run Time: 0.002962
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=119&page=175, 1714937733,
Run Time: 0.000470
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, 795600, a:26:{i:0;s:15:"Англия:
";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"Last Week";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"This Week";}}i:4;s:1:" ";i:5;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Title";}}i:6;s:5:"
1 1 ";i:7;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:6:"Anthem";}}i:8;s:5:"
3 2 ";i:9;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:7:"FIFA 19";}}i:10;s:5:"
2 3 ";i:11;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:17:"Far Cry: New Dawn";}}i:12;s:13:"
New Entry 4 ";i:13;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:27:"The LEGO Movie 2: Videogame";}}i:14;s:5:"
4 5 ";i:15;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:21:"Red Dead Redemption 2";}}i:16;s:13:"
New Entry 6 ";i:17;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:8:"Dirt 2.0";}}i:18;s:5:"
5 7 ";i:19;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:12:"Metro Exodus";}}i:20;s:5:"
8 8 ";i:21;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:20:"Mario Kart 8: Deluxe";}}i:22;s:6:"
10 9 ";i:23;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:25:"Super Smash Bros Ultimate";}}i:24;s:14:"
New Entry 10 ";i:25;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:27:"Trials Rising: Gold Edition";}}}, 1701116101, 1714937733
Run Time: 0.004363
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, 1714937733
Run Time: 0.000518
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, 795690, a:4:{i:0;s:93:"Япония:
Отличный старт DOA
Software Sales (followed by lifetime sales)
";i:1;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:1792:"
[*][PS4] Dead or Alive 6 (Koei Tecmo, 03/01/19) – 26,442 (New)
[*][NSW] Super Smash Bros. Ultimate (Nintendo, 12/07/18) – 25,617 (2,909,033)
[*][NSW] New Super Mario Bros. U Deluxe (Nintendo, 01/11/19) – 24,436 (479,443)
[*][PS4] Anthem (Limited Edition Included) (Electronic Arts, 02/22/19) – 20,368 (98,306)
[*][PS4] Left Alive (Square Enix, 02/28/19) – 17,622 (New)
[*][NSW] Pokemon: Let’s Go, Pikachu! / Let’s Go, Eevee! (Bundle Editions Included) (Nintendo, 11/16/18) – 12,864 (1,514,711)
[*][NSW] Mario Kart 8 Deluxe (Nintendo, 04/28/17) – 12,369 (2,154,698)
[*][PS4] Kingdom Hearts III (Limited Edition Included) (Square Enix, 01/25/19) – 10,983 (781,051)
[*][NSW] Zoids Wild: King of Blast (Takara Tomy, 02/28/19) – 10,030 (New)
[*][NSW] Super Mario Party (Bundle Version Included) (Nintendo, 10/05/18) – 9,900 (1,037,559)
[*][NSW] Darius Cozmic Collection (Limited Edition Included) (Taito, 02/28/19) – 9,495 (New)
[*][NSW] Splatoon 2 (Bundle Version Included) (Nintendo, 07/21/17) – 8,986 (2,947,577)
[*][PS4] Jump Force (Bandai Namco, 02/14/19) – 8,655 (103,020)
[*][NSW] Minecraft: Nintendo Switch Edition (Bundle Version Included) (Microsoft, 06/21/18) – 8,638 (624,521)
[*][NSW] The Legend of Zelda: Breath of the Wild (Limited Edition Included) (Nintendo, 03/03/17) – 7,694 (1,307,507)
[*][PS4] NieR: Automata Game of the YoRHa Edition (Square Enix, 02/21/19) – 6,625 (27,950)
[*][PS4] Far Cry: New Dawn (Ubisoft, 02/15/19) – 6,000 (44,668)
[*][PS4] Resident Evil 2 (Z Version and Limited Edition Included) (Capcom, 01/25/19) – 4,505 (348,778)
[*][NSW] Doraemon: Nobita’s Chronicle of the Moon Exploration (FuRyu, 02/28/19) – 3,370 (New)
[*][PS4] Catherine: Full Body (Limited Edition Included) (Atlus, 02/14/19) – 3,000 (61,855)
";}}i:2;s:51:"
Hardware Sales (followed by last week’s sales)
";i:3;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:280:"
[*]Switch – 68,666 (53,270)
[*]PlayStation 4 – 11,871 (10,632)
[*]PlayStation 4 Pro – 7,986 (6,956)
[*]New 2DS LL – 6,202 (3,388)
[*]PlayStation Vita – 3,287 (3,600)
[*]New 3DS LL – 1,203 (1,052)
[*]2DS – 116 (113)
[*]Xbox One X – 67 (51)
[*]Xbox One – 23 (21)
";}}}, 1701116101, 1714937733
Run Time: 0.004287
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, 795820, a:3:{i:0;s:130:"Что там с чартом популярных игорей для скачки в европейском Playstation Store?
";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:7:{i:0;s:1:"
";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:86:"Caмые cкачиваемые игpы для PlayStation 4: фeврaль 2019 годa";}}i:2;s:526:"
Anthem (New)
Grand Theft Auto V (2)
The Forest (8)
Red Dead Redemption 2 (17)
Far Cry New Dawn (New)
Jump Force (New)
Metro Exodus (New)
Minecraft (14)
Assassin’s Creed Odyssey (Re-entry)
Rainbow Six: Siege (13)
FIFA 2019 (13)
Resident Evil 2 (1)
Far Cry 5 (Re-entry)
Rocket League (9)
Watch Dogs 2 (Re-entry)
The Witcher 3: Wild Hunt (Re-entry)
Playerunknown’s Battlegrounds (5)
Battlefield V (10)
Metro Redux (Re-entry)
Gang Beasts (16)
";i:3;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:83:"Сaмыe cкачиваeмыe игpы для PlayStation VR: фeвpaль 2019 гoдa";}}i:4;s:275:"
Beat Saber (1)
Job Simulator (4)
Surgeon Simulator (Re-entry)
Rick and Morty Virtual Rick-ality (Re-entry)
Superhot VR (5)
Moss (Re-entry)
Creed: Rise to Glory (3)
Arizona Sunshine (6)
Affected: The Manor (New)
Crisis VRigade (New)
";i:5;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:61:"Cамые скaчивaемые DLC: февpаль 2019 гoдa";}}i:6;s:412:"
Fortnite – The Cobalt Pack (1)
Fortnite – Fallen Love Ranger Challenge Pack (New)
Fortnite – Standard Founder’s Pack (4)
Fortnite – Frozen Legends Pack (3)
Apex Legends Starter Pack (New)
Rainbow Six Siege – Year 4 Pass (10)
Apex Legends Founder’s Pack (New)
Marvel’s Spider-Man – The City that Never Sleeps (5)
Rocket League – McLaren 570S Car Pack (6)
";}}i:2;s:200:"
Среди двадцатки самых популярных для скачки игр - ни одного Сони экза! )))) PS4 - лучшая консоль для эксклюзивов!";}, 1701116101, 1714937733
Run Time: 0.001079
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, 1714937733
Run Time: 0.000293
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, 795823, a:1:{i:0;s:159:"Слишком толсто, Димм. Последний эксклюзив аж от сентября. Подожди апреля, всё изменится";}, 1701116101, 1714937733
Run Time: 0.000291
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, 1714937733
Run Time: 0.000250
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, 795824, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 795823, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 795823, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:159:"Слишком толсто, Димм. Последний эксклюзив аж от сентября. Подожди апреля, всё изменится";}}i:1;s:74:"
Это не толстота, эта суровая статистика.";}, 1701116101, 1714937733
Run Time: 0.000251
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, 795827, a:1:{i:0;s:56:"Даже вован так не толстит :pompous:";}, 1701116101, 1714937733
Run Time: 0.000257
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, 795828, a:1:{i:0;s:99:"Сборище ценителей тонкого юмора собралось на нексте ))";}, 1701116101, 1714937733
Run Time: 0.002064
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, 795970, a:26:{i:0;s:15:"Англия:
";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"Last Week";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"This Week";}}i:4;s:1:" ";i:5;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Title";}}i:6;s:13:"
New Entry 1 ";i:7;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:15:"Devil May Cry 5";}}i:8;s:5:"
5 2 ";i:9;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:21:"Red Dead Redemption 2";}}i:10;s:5:"
8 3 ";i:11;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:20:"Mario Kart 8: Deluxe";}}i:12;s:5:"
1 4 ";i:13;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:6:"Anthem";}}i:14;s:5:"
2 5 ";i:15;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:7:"FIFA 19";}}i:16;s:5:"
3 6 ";i:17;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:17:"Far Cry: New Dawn";}}i:18;s:5:"
4 7 ";i:19;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:27:"The LEGO Movie 2: Videogame";}}i:20;s:5:"
9 8 ";i:21;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:25:"Super Smash Bros Ultimate";}}i:22;s:5:"
7 9 ";i:23;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:12:"Metro Exodus";}}i:24;s:7:"
11 10 ";i:25;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:18:"Grand Theft Auto V";}}}, 1701116101, 1714937733
Run Time: 0.000760
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, 796014, a:4:{i:0;s:64:"Япония:
Дмс5 бустанул продажи пс4 )
";i:1;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:1622:"
[*]Ultimate (Nintendo, 12/07/18) – 23,407 (2,932,439)
[*][NSW] New Super Mario Bros. U Deluxe (Nintendo, 01/11/19) – 20,101 (499,543)
[*][NSW] Mario Kart 8 Deluxe (Nintendo, 04/28/17) – 12,301 (2,166,999)
[*][NSW] Pokemon: Let’s Go, Pikachu! / Let’s Go, Eevee! (Bundle Editions Included) (Nintendo, 11/16/18) – 11,394 (1,526,105)
[*][3DS] Kirby’s Extra Epic Yarn (Nintendo, 03/07/19) – 10,607 (New)
[*][NSW] The Legend of Zelda: Breath of the Wild (Limited Edition Included) (Nintendo, 03/03/17) – 9,838 (1,317,346)
[*][NSW] Super Mario Party (Bundle Version Included) (Nintendo, 10/05/18) – 9,230 (1,046,789)
[*][NSW] Minecraft: Nintendo Switch Edition (Bundle Version Included) (Microsoft, 06/21/18) – 8,350 (632,871)
[*][NSW] Splatoon 2 (Bundle Version Included) (Nintendo, 07/21/17) – 7,739 (2,955,316)
[*][PS4] Dead or Alive 6 (Koei Tecmo, 03/01/19) – 5,223 (31,665)
[*][PS4] Anthem (Limited Edition Included) (Electronic Arts, 02/22/19) – 5,204 (103,510)
[*][PS4] Kingdom Hearts III (Limited Edition Included) (Square Enix, 01/25/19) – 4,518 (785,569)
[*][PS4] Jump Force (Bandai Namco, 02/14/19) – 4,492 (107,512)
[*][PS4] Left Alive (Square Enix, 02/28/19) – 3,530 (21,152)
[*][PS4] Resident Evil 2 (Z Version and Limited Edition Included) (Capcom, 01/25/19) – 3,415 (352,193)
[*][PS4] NieR: Automata Game of the YoRHa Edition (Square Enix, 02/21/19) – 3,363 (31,313)
[*][PS4] Far Cry: New Dawn (Ubisoft, 02/15/19) – 2,859 (47,527)
[*][NSW] Kirby: Star Allies (Nintendo, 03/16/18) – 2,788 (740,899)
[*][NSW] Super Mario Odyssey (Nintendo, 10/27/17) – 2,693 (1,960,058)
";}}i:2;s:51:"
Hardware Sales (followed by last week’s sales)
";i:3;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:280:"
[*]Switch – 69,766 (68,666)
[*]PlayStation 4 – 25,154 (11,871)
[*]PlayStation 4 Pro – 7,208 (7,986)
[*]New 2DS LL – 4,424 (6,202)
[*]PlayStation Vita – 3,002 (3,287)
[*]New 3DS LL – 1,182 (1,203)
[*]2DS – 112 (116)
[*]Xbox One X – 83 (67)
[*]Xbox One – 14 (23)
";}}}, 1701116101, 1714937733
Run Time: 0.000363
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, 796154, a:5:{i:0;s:185:"Чую скоро японских чартов от Вовы мы не увидим. Media Create подумает делиться ли этими данными просто так:
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[URL]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:113:"https://www.bloomberg.com/news/articles/2019-03-10/hedge-funds-use-unknown-data-guru-to-make-millions-on-nintendo";}}i:2;s:62:"
и позже выяснилось, что не будут:
";i:3;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:1:{i:0;s:125:"Now, after a company review, the team has decided to no longer share sales figures with the general public on a weekly basis.";}}i:4;s:53:"
По крайней мере еженедельно.";}, 1701116101, 1714937733
Run Time: 0.000548
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, 796156, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"dimm, post: 796154, member: 3212";s:8:"original";a:2:{i:0;s:42:"[QUOTE="dimm, post: 796154, member: 3212"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:185:"Чую скоро японских чартов от Вовы мы не увидим. Media Create подумает делиться ли этими данными просто так:
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[URL]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:113:"https://www.bloomberg.com/news/articles/2019-03-10/hedge-funds-use-unknown-data-guru-to-make-millions-on-nintendo";}}i:2;s:115:"
и позже выяснилось, что не будут:
По крайней мере еженедельно.";}}i:1;s:72:"
Скорее всего за деньги будут делиться )";}, 1701116101, 1714937733
Run Time: 0.000452
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, 796263, a:1:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32359";}}}, 1701116101, 1714937733
Run Time: 0.000497
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, 796266, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 796263, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 796263, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32359";}}}}i:1;s:39:"
Это где оплот бояр? )))";}, 1701116101, 1714937733
Run Time: 0.000467
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, 796267, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 796266, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 796266, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:38:"Это где оплот бояр? )))";}}i:1;s:18:"
Монтана) )";}, 1701116101, 1714937733
Run Time: 0.001209
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, 796269, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 796267, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 796267, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:17:"Монтана) )";}}i:1;s:78:"
А вторая поменьше это козырная Монтана? )))";}, 1701116101, 1714937733
Run Time: 0.000428
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, 796272, a:26:{i:0;s:16:"Англия:
";i:1;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"Last Week";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:9:"This Week";}}i:4;s:1:" ";i:5;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:5:"Title";}}i:6;s:13:"
New Entry 1 ";i:7;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:14:"The Division 2";}}i:8;s:5:"
2 2 ";i:9;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:21:"Red Dead Redemption 2";}}i:10;s:6:"
10 3 ";i:11;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:18:"Grand Theft Auto V";}}i:12;s:5:"
5 4 ";i:13;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:7:"FIFA 19";}}i:14;s:5:"
7 5 ";i:15;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:27:"The LEGO Movie 2: Videogame";}}i:16;s:5:"
1 6 ";i:17;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:15:"Devil May Cry 5";}}i:18;s:5:"
3 7 ";i:19;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:19:"Mario Kart 8 Deluxe";}}i:20;s:5:"
6 8 ";i:21;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:17:"Far Cry: New Dawn";}}i:22;s:5:"
8 9 ";i:23;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:25:"Super Smash Bros Ultimate";}}i:24;s:7:"
11 10 ";i:25;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;s:29:"New Super Mario Bros U Deluxe";}}}, 1701116101, 1714937733
Run Time: 0.000438
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, 796342, a:8:{i:0;s:59:"NPD:
The best-selling games of February 2019 in the U.S.
";i:1;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:484:"
[*]Anthem**
[*]Jump Force
[*]Kingdom Hearts III
[*]Far Cry New Dawn
[*]Red Dead Redemption II
[*]Resident Evil 2 2019
[*]Super Smash Bros. Ultimate*
[*]Metro: Exodus**
[*]NBA 2K19
[*]Call of Duty: Black Ops IIII**
[*]New Super Mario Bros. U Deluxe*
[*]Mario Kart 8*
[*]Grand Theft Auto V
[*]Assassin’s Creed: Odyssey
[*]The Legend of Zelda: Breath of the Wild*
[*]Minecraft ***
[*]Super Mario Party*
[*]Tom Clancy’s Rainbow Six: Siege
[*]Madden NFL 19**
[*]Marvel’s Spider-Man
";}}i:2;s:1:"
";i:3;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:129:"*Digital sales not included
**PC digital sales not included
**Xbox One and PlayStation 4 digital sales not included for Minecraft";}}i:4;s:41:"
The best-selling games of 2019 so far
";i:5;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:242:"
[*] Kingdom Hearts III
[*]Anthem**
[*]Resident Evil 2 2019
[*]Jump Force
[*]Red Dead Redemption II
[*]Super Smash Bros. Ultimate*
[*]Call of Duty: Black Ops IIII^
[*]New Super Mario Bros. U Deluxe*
[*]NBA 2K19
[*]Ace Combat 7: Skies Unknown
";}}i:6;s:47:"
The best-selling games of the last 12 months
";i:7;a:4:{s:3:"tag";s:4:"list";s:6:"option";s:1:"1";s:8:"original";a:2:{i:0;s:8:"[LIST=1]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:228:"
[*]Red Dead Redemption II
[*]Call of Duty: Black Ops IIII**
[*]NBA 2K19
[*]Super Smash Bros. Ultimate*
[*]Madden NFL 19**
[*]Marvel’s Spider-Man
[*]Far Cry 5
[*]God of War 2018
[*]Assassin’s Creed: Odyssey
[*]Mario Kart 8*
";}}}, 1701116101, 1714937733
Run Time: 0.005414
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, 796358, a:4:{i:0;s:15:"Япония:
";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32369";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32370";}}}, 1701116101, 1714937733
Run Time: 0.000600
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, 796691, a:1:{i:0;s:448:"Англия:
1 (NE) SEKIRO: SHADOWS DIE TWICE (ACTIVISION BLIZZARD)
02 (01) TOM CLANCY’S THE DIVISION 2 (UBISOFT)
03 (04) FIFA 19 (ELECTRONIC ARTS)
04 (03) GRAND THEFT AUTO V (TAKE 2)
05 (02) RED DEAD REDEMPTION 2 (TAKE 2)
06 (07) MARIO KART 8 DELUXE (NINTENDO)
07 (05) THE LEGO MOVIE 2 VIDEOGAME (WARNER BROS. INTERACTIVE)
08 (12) FORZA HORIZON 4 (MICROSOFT)
09 (08) FAR CRY NEW DAWN (UBISOFT)
10 (10) NEW SUPER MARIO BROS. U DELUXE (NINTENDO)";}, 1701116101, 1714937733
Run Time: 0.000975
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, 796756, a:4:{i:0;s:15:"Япония:
";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32411";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"32412";}}}, 1701116101, 1714937733
Run Time: 0.000332