SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.001524
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.001817
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.000853
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 >= 3120 AND post.position < 3140)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 119
Run Time: 0.003250
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: 119
Run Time: 0.000265
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=157, 1715798951,
Run Time: 0.000290
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, 772750, 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/DNbmRktX0AET-J5.jpg";}}}, 1701116101, 1715798951
Run Time: 0.000420
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, 1715798951
Run Time: 0.000286
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, 772765, a:2:{i:0;s:70:"67.5M PS4s Shipped As of Sept 30th. March 2018 Estimate Raised to 79M
";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:54:"https://www.dualshockers.com/ps4-sales-september-30th/";}}}, 1701116101, 1715798951
Run Time: 0.000273
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, 772813, a:2:{i:0;s:23:"Атач рейты.
";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/DNeg734UIAADSGq.jpg";}}}, 1701116101, 1715798951
Run Time: 0.000318
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, 772817, a:1:{i:0;s:58:"А на нормальные системы есть чё?";}, 1701116101, 1715798951
Run Time: 0.000256
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, 1314, a:1:{i:0;s:107:"eat, sleep, play - олл зе вей | c восьми бит не слежу за сюжетом (с) vova";}, 1701116101, 1715798951
Run Time: 0.000296
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, 772818, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"Vitiaz, post: 772817, member: 1314";s:8:"original";a:2:{i:0;s:44:"[QUOTE="Vitiaz, post: 772817, member: 1314"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:58:"А на нормальные системы есть чё?";}}i:1;s:108:"
Они никому не интересны :)
На нормальной пс4 сейчас вроде 2.78";}, 1701116101, 1715798951
Run Time: 0.000361
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, 772819, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 772813, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 772813, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:2:{i:0;s:22:"Атач рейты.
";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/DNeg734UIAADSGq.jpg";}}}}i:1;s:62:"
Больше лучше или наоборот? :nailbiting:";}, 1701116101, 1715798951
Run Time: 0.000313
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, 772821, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 772818, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 772818, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:107:"Они никому не интересны :)
На нормальной пс4 сейчас вроде 2.78";}}i:1;s:363:"
Просто на ПС4 такие крутые игры, что народ может в одну годами играть =). У меня во френдах есть такие =).
А вообще не верю, учитывая что есть плюс и народ на распродажах может игрухи за беесценок брать.";}, 1701116101, 1715798951
Run Time: 0.000298
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, 772822, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"-A-, post: 772821, member: 517";s:8:"original";a:2:{i:0;s:40:"[QUOTE="-A-, post: 772821, member: 517"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:175:"
А вообще не верю, учитывая что есть плюс и народ на распродажах может игрухи за беесценок брать.";}}i:1;s:238:"
Ты просто не совсем понимаешь о чём речь. Тут как раз количество это враг данного графика. Что, кстати, Сони прекрасно доказывает
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Каин, post: 772819, member: 3850";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Каин, post: 772819, member: 3850"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:61:"Больше лучше или наоборот? :nailbiting:";}}i:3;s:24:"
Больше лучше";}, 1701116101, 1715798951
Run Time: 0.000273
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, 1715798951
Run Time: 0.000277
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, 772823, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:30:"-A-, post: 772821, member: 517";s:8:"original";a:2:{i:0;s:40:"[QUOTE="-A-, post: 772821, member: 517"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:361:"Просто на ПС4 такие крутые игры, что народ может в одну годами играть =). У меня во френдах есть такие =).
А вообще не верю, учитывая что есть плюс и народ на распродажах может игрухи за беесценок брать.";}}i:1;s:377:"
Просто на геймкубе было много классных игр, а кубов мало. Вот Вии удивила конечно.
Ну и конечно старая песня о диком разнообразии игр на пс4. Приставок много, а игр покупают мало, из-за разнообразия наверное :)";}, 1701116101, 1715798951
Run Time: 0.000203
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, 772824, a:2:{i:0;s:89:"Раз уж всех так заинтересовало, вот в дополнение
";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:76:"http://nintendoenthusiast.com/wp-content/uploads/2016/07/Image-1170x4245.jpg";}}}, 1701116101, 1715798951
Run Time: 0.000258
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, 772841, a:8:{i:0;s:192:"Япония:
Не любят Марио японцы :)
462,038 units. This also gave the Nintendo Switch a huge boost as Nintendo shifted 126K units. Here’s the best-sellers this week:
";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:14:"Software Sales";}}i:2;s:31:" (followed by lifetime 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:17:{i:0;s:63:"
[*][NSW] Super Mario Odyssey (Nintendo, 10/27/17) – 462,038 ";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:5:"(New)";}}i:2;s:70:"
[*][PS4] ARK: Survival Evolved (Spike Chunsoft, 10/26/17) – 70,177 ";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:5:"(New)";}}i:4;s:108:"
[*][3DS] Shin Megami Tensei: Strange Journey Redux (Limited Edition Included) (Atlus, 10/26/17) – 60,848 ";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:"(New)";}}i:6;s:68:"
[*][PS4] Assassin’s Creed Origins (Ubisoft, 10/27/17) – 49,419 ";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:5:"(New)";}}i:8;s:104:"
[*][PS4] Taiko Drum Master: Drum Session (Bundle Edition Included) (Bandai Namco, 10/26/17) – 28,245 ";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:5:"(New)";}}i:10;s:248:"
[*][NSW] Splatoon 2 (Nintendo, 07/21/17) – 22,445 (1,271,451)
[*][PS4] Gran Turismo Sport (Limited Edition Included) (SIE, 10/19/17) – 17,670 (167,956)
[*][3DS] Idol Time PriPara: Yume All-Star Live! (Takara Tomy A.R.T.S, 10/26/17) – 14,885 ";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:5:"(New)";}}i:12;s:541:"
[*][NSW] Mario Kart 8 Deluxe (Nintendo, 04,28,17) – 13,936 (772,533)
[*][PS4] The Evil Within 2 (Bethesda Softworks, 10/19/17) – 12,624 (55,565)
[*][PS4] Itadaki Street: Dragon Quest & Final Fantasy 30th Anniversary (Square Enix, 10/19/17) – 9,570 (51,662)
[*][PS4] City Shrouded in Shadow (Bandai Namco, 10/19/17) – 8,117 (57,052)
[*][NSW] The Legend of Zelda: Breath of the Wild (Limited Edition Included) (Nintendo, 03/03/17) – 6,307 (622,690)
[*][3DS] 12-Sai. Torokeru Puzzle: Futari no Harmony (Happinet, 10/26/17) – 6,195 ";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:5:"(New)";}}i:14;s:429:"
[*][PS4] Middle-earth: Shadow of War (Warner Bros., 10/12/17) – 5,869 (34,095)
[*][NSW] Pokken Tournament DX (Nintendo, 09/22/17) – 4,588 (106,947)
[*][PSV] Itadaki Street: Dragon Quest & Final Fantasy 30th Anniversary (Square Enix, 10/19/17) – 4,210 (22,994)
[*][3DS] Animal Crossing: New Leaf Amiibo+ (Nintendo, 11/23/16) – 3,815 (260,228)
[*][3DS] Rune Factory 4 (Platinum Collection) (Marvelous, 10/26/17) – 3,567 ";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:5:"(New)";}}i:16;s:101:"
[*][3DS] Mario & Luigi: Superstar Saga + Bowser’s Minions (Nintendo, 10/05/17) – 3,480 (46,575)
";}}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:14:"Hardware Sales";}}i:6;s:36:" (followed by last week’s sales)
";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:334:"
[*]Switch – 126,701 (31,092)
[*]PlayStation 4 – 18,719 (25,075)
[*]New 2DS LL – 9,203 (8,449)
[*]New 3DS LL – 6,448 (6,187)
[*]PlayStation 4 Pro – 5,934 (6,203)
[*]PlayStation Vita – 3,705 (3,535)
[*]2DS – 1,412 (1,367)
[*]New 3DS – 220 (195)
[*]Xbox One – 97 (69)
[*]PlayStation 3 – 45 (50)
[*]Wii U – 41 (40)
";}}}, 1701116101, 1715798951
Run Time: 0.000364
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, 773257, a:21:{i:0;s:17:"Англия:
- ";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:"http://www.chart-track.co.uk/art/chartNew.gif";}}i:2;s:78:" 1 CALL OF DUTY: WWII SLEDGEHAMMER GAMES ACTIVISION ACTIVISION BLIZZARD
1 ";i:3;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:46:"http://www.chart-track.co.uk/art/chartDown.gif";}}i:4;s:69:" 2 ASSASSIN'S CREED ORIGINS UBISOFT (MONTREAL) UBISOFT UBISOFT
3 ";i:5;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:46:"http://www.chart-track.co.uk/art/chartSame.gif";}}i:6;s:53:" 3 FIFA 18 EA CANADA EA SPORTS ELECTRONIC ARTS
2 ";i:7;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:46:"http://www.chart-track.co.uk/art/chartDown.gif";}}i:8;s:56:" 4 SUPER MARIO ODYSSEY NINTENDO NINTENDO NINTENDO
5 ";i:9;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:46:"http://www.chart-track.co.uk/art/chartSame.gif";}}i:10;s:85:" 5 GRAN TURISMO: SPORT POLYPHONY DIGITAL SONY COMPUTER ENT. SONY COMPUTER ENT.
4 ";i:11;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:46:"http://www.chart-track.co.uk/art/chartDown.gif";}}i:12;s:94:" 6 WOLFENSTEIN II: THE NEW COLOSSUS MACHINEGAMES BETHESDA SOFTWORKS BETHESDA SOFTWORKS
12 ";i:13;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:44:"http://www.chart-track.co.uk/art/chartUp.gif";}}i:14;s:65:" 7 FORZA MOTORSPORT 7 TURN 10 STUDIOS MICROSOFT MICROSOFT
11 ";i:15;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:44:"http://www.chart-track.co.uk/art/chartUp.gif";}}i:16;s:57:" 8 MARIO KART 8 DELUXE NINTENDO NINTENDO NINTENDO
15 ";i:17;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:44:"http://www.chart-track.co.uk/art/chartUp.gif";}}i:18;s:62:" 9 FORZA HORIZON 3 PLAYGROUND GAMES MICROSOFT MICROSOFT
9 ";i:19;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:46:"http://www.chart-track.co.uk/art/chartDown.gif";}}i:20;s:94:" 10 MIDDLE-EARTH: SHADOW OF WAR MONOLITH WARNER BROS. INTERACTIVE WARNER BROS. INTERACTIVE";}, 1701116101, 1715798951
Run Time: 0.000358
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, 773326, a:8:{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:14:"Software Sales";}}i:2;s:31:" (followed by lifetime 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:7:{i:0;s:57:"
[*][PS4] Call of Duty: WWII (SIE, 11/03/17) – 168,234 ";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:5:"(New)";}}i:2;s:169:"
[*][NSW] Super Mario Odyssey (Nintendo, 10/27/17) – 116,931 (578,969)
[*][PS4] .hack//G.U. Last Recode (Limited Edition Included) (Bandai Namco, 11/02/17) – 61,816 ";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:5:"(New)";}}i:4;s:68:"
[*][3DS] Style Savvy: Styling Star (Nintendo, 11/03/17) – 32,176 ";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:"(New)";}}i:6;s:1427:"
[*][NSW] Splatoon 2 (Nintendo, 07/21/17) – 23,557 (1,295,008)
[*][PS4] ARK: Survival Evolved (Spike Chunsoft, 10/26/17) – 23,370 (93,547)
[*][PS4] Assassin’s Creed Origins (Ubisoft, 10/27/17) – 22,272 (71,692)
[*][NSW] Mario Kart 8 Deluxe (Nintendo, 04,28,17) – 15,913 (788,445)
[*][3DS] Shin Megami Tensei: Strange Journey Redux (Limited Edition Included) (Atlus, 10/26/17) – 9,978 (70,647)
[*][PS4] Gran Turismo Sport (Limited Edition Included) (SIE, 10/19/17) – 9,045 (177,001)
[*][PS4] Taiko Drum Master: Drum Session (Bundle Edition Included) (Bandai Namco, 10/26/17) – 7,679 (35,924)
[*][NSW] The Legend of Zelda: Breath of the Wild (Limited Edition Included) (Nintendo, 03/03/17) – 6,662 (629,352)
[*][PS4] The Evil Within 2 (Bethesda Softworks, 10/19/17) – 5,809 (61,374)
[*][NSW] Pokken Tournament DX (Nintendo, 09/22/17) – 4,882 (111,829)
[*][PS4] Itadaki Street: Dragon Quest & Final Fantasy 30th Anniversary (Square Enix, 10/19/17) – 4,858 (56,520)
[*][3DS] Animal Crossing: New Leaf Amiibo+ (Nintendo, 11/23/16) – 4,008 (264,236)
[*][PS4] City Shrouded in Shadow (Bandai Namco, 10/19/17) – 3,511 (60,563)
[*][PS4] Middle-earth: Shadow of War (Warner Bros., 10/12/17) – 3,367 (37,462)
[*][3DS] Mario & Luigi: Superstar Saga + Bowser’s Minions (Nintendo, 10/05/17) – 3,171 (49,746)
[*][3DS] Idol Time PriPara: Yume All-Star Live! (Takara Tomy A.R.T.S, 10/26/17) – 3,080 (17,965)
";}}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:14:"Hardware Sales";}}i:6;s:36:" (followed by last week’s sales)
";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:336:"
[*]Switch – 64,387 (126,701)
[*]PlayStation 4 – 21,830 (18,719)
[*]New 2DS LL – 11,116 (9,203)
[*]New 3DS LL – 7,914 (6,448)
[*]PlayStation 4 Pro – 6,993 (5,934)
[*]PlayStation Vita – 3,576 (3,705)
[*]2DS – 1,539 (1,412)
[*]New 3DS – 287 (220)
[*]Xbox One – 114 (97)
[*]PlayStation 3 – 56 (45)
[*]Wii U – 38 (41)
";}}}, 1701116101, 1715798951
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: post, 773736, a:3:{i:0;s:81:"В ЮК Икса накупили более 80К за первую неделю
";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:94:"http://www.gamesindustry.biz/articles/2017-11-13-xbox-one-x-hits-80-000-uk-sales-in-first-week";}}i:2;s:130:"
Для сравнения Про понадобился месяц для достижения такого показателя";}, 1701116101, 1715798951
Run Time: 0.000366
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, 773738, a:1:{i:0;s:171:"Будет прикольно, если так и продолжится. Да ещё по всем регионам. И как будет продаваться хуан.";}, 1701116101, 1715798951
Run Time: 0.000229
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, 773739, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 773738, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 773738, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:171:"Будет прикольно, если так и продолжится. Да ещё по всем регионам. И как будет продаваться хуан.";}}i:1;s:334:"
Что то я не очень понял, что Вова хотел сказать, но тем не менее ГеймСтоп пока без цифр, но весь сток стартовый, как они сообщают, продали.
Думаю по США будет цифра достаточно приличная";}, 1701116101, 1715798951
Run Time: 0.000167
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, 773740, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"Chakie, post: 773739, member: 777";s:8:"original";a:2:{i:0;s:43:"[QUOTE="Chakie, post: 773739, member: 777"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:332:"Что то я не очень понял, что Вова хотел сказать, но тем не менее ГеймСтоп пока без цифр, но весь сток стартовый, как они сообщают, продали.
Думаю по США будет цифра достаточно приличная";}}i:1;s:149:"
Я имел ввиду, что продолжится продаваться больше прошки. Ну и сам хуан не сдуется.";}, 1701116101, 1715798951
Run Time: 0.000200
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, 773741, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:29:"vova, post: 773740, member: 4";s:8:"original";a:2:{i:0;s:39:"[QUOTE="vova, post: 773740, member: 4"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:148:"Я имел ввиду, что продолжится продаваться больше прошки. Ну и сам хуан не сдуется.";}}i:1;s:160:"
Ну вот я этого как раз и не понял, с чего ему сдуваться и причём тут хуан. Про него и речь.";}, 1701116101, 1715798951
Run Time: 0.000265
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, 773742, a:16:{i:0;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:933:"‘Call of Duty: WWII’ holds the fort for a second week at No.1
Activision Blizzard’s ‘Call of Duty: WWII’ retains the No1 spot for the All Formats Chart in its second week since launch. Its second week figure tops ‘Fifa 18s’ second week, making it the highest selling second week for a title of not only this year, but 2016 as well.
‘Fifa 18’ does climb one position into No2 this week, pushing Ubisoft’s ‘Assassin’s Creed Origins’ in the opposite direction down to No3.
EA’s new release ‘Need for Speed Payback’ debuts in at No4, one place below what its predecessor ‘Need for Speed’ did back in 2015. Sega have 2 new releases in the top 10 this week with ‘Sonic Forces’ debuting in at No5 and ‘Football Manager 2018’ in at No10. Elsewhere in the top 40 we have 2 more new releases in Microsoft’s ‘Super Lucky’s Tale’ in at No23 and EA’s ‘The Sims 4: Cats & Dogs’ at No27.";}}i:1;s:1:"
";i:2;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:"United Kingdom:";}}i:3;s:1:"
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:129:"http://www.chart-track.co.uk/index.jsp?c=p%2Fsoftware%2Fuk%2Farchive%2Findex_test.jsp&ct=110015&arch=t&lyr=2017&year=2017&week=45";s:8:"original";a:2:{i:0;s:137:"[URL='http://www.chart-track.co.uk/index.jsp?c=p%2Fsoftware%2Fuk%2Farchive%2Findex_test.jsp&ct=110015&arch=t&lyr=2017&year=2017&week=45']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;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:35:"Week 45, 2017 - All Formats (Units)";}}}}i:5;s:120:"
01 (01) CALL OF DUTY: WWII (ACTIVISION)
02 (03) FIFA 18 (EA SPORTS)
03 (02) ASSASSIN'S CREED ORIGINS (UBISOFT)
04 (NE) ";i:6;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:33:"NEED FOR SPEED PAYBACK (EA GAMES)";}}i:7;s:9:"
05 (NE) ";i:8;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:"SONIC FORCES (SEGA)";}}i:9;s:173:"
06 (04) SUPER MARIO ODYSSEY (NINTENDO)
07 (07) FORZA MOTORSPORT 7 (MICROSOFT)
08 (09) FORZA HORIZON 3 (MICROSOFT)
09 (05) GRAN TURISMO: SPORT ( SONY COMPUTER ENT.)
10 (NE) ";i:10;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:"FOOTBALL MANAGER 2018 ( SEGA)";}}i:11;s:594:"
11 (10) MIDDLE-EARTH: SHADOW OF WAR (WARNER BROS. INTERACTIVE)
12 (11) GRAND THEFT AUTO V (ROCKSTAR)
13 (13) TOM CLANCY'S RAINBOW 6: SIEGE (UBISOFT)
14 (06 WOLFENSTEIN II: THE NEW COLOSSUS (BETHESDA SOFTWORKS)
15 (16) CRASH BANDICOOT N.SANE TRILOGY (ACTIVISION)
16 (23) DOOM (BETHESDA SOFTWORKS)
17 (15) WWE 2K18 (2K)
18 (08) MARIO KART 8 DELUXE (NINTENDO)
19 (12) SOUTH PARK: THE FRACTURED BUT WHOLE (UBISOFT)
20 (18) LEGO WORLDS (WARNER BROS. INTERACTIVE)
21 (21) THE LEGO NINJAGO MOVIE VIDEOGAME (WARNER BROS. INTERACTIVE)
22 (17) THE LEGEND OF ZELDA: BREATH OF THE WILD (NINTENDO)
23 (NE) ";i:12;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:31:"SUPER LUCKY'S TALE (MICROSOFT) ";}}i:13;s:136:"
24 (19) FALLOUT 4 (BETHESDA SOFTWORKS)
25 (14) DESTINY 2 (ACTIVISION)
26 (36) CARS 3: DRIVEN TO WIN (WARNER BROS. INTERACTIVE)
27 (NE) ";i:14;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:35:"THE SIMS 4: CATS & DOGS (EA GAMES) ";}}i:15;s:571:"
28 (28) MINECRAFT: PLAYSTATION EDITION (SONY COMPUTER ENT.)
29 (32) UNCHARTED: THE LOST LEGACY (SONY COMPUTER ENT.)
30 (22) RESIDENT EVIL 7: BIOHAZARD (CAPCOM)
31 (25) MARIO KART 7 (NINTENDO)
32 (20) THE EVIL WITHIN 2 (BETHESDA SOFTWORKS)
33 (26) NEW SUPER MARIO BROS. 2 (NINTENDO)
34 (38) MINECRAFT: XBOX EDITION (MICROSOFT)
35 (35) SPLATOON 2 (NINTENDO)
36 (29) LEGO CITY UNDERCOVER (WARNER BROS. INTERACTIVE)
37 (RE) JUST DANCE 2018 (UBISOFT)
38 (33) SUPER MARIO 3D LAND (NINTENDO SELECTS)
39 (RE) ARK: SURVIVAL EVOLVED (STUDIO WILDCARD)
40 (39) 1-2 SWITCH (NINTENDO)";}, 1701116101, 1715798951
Run Time: 0.000405
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, 773762, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Каин, post: 773742, member: 3850";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Каин, post: 773742, member: 3850"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:33:"16 (23) DOOM (BETHESDA SOFTWORKS)";}}i:1;s:107:"
В индивидуальном чарте Дум на Свитче стартовал на 23 месте.";}, 1701116101, 1715798951
Run Time: 0.000371