SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000319
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: 21941
Run Time: 0.001518
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.000735
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 >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 21941
Run Time: 0.006543
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 10 | 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: 21941
Run Time: 0.000811
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=21941, 1713561338,
Run Time: 0.000449
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, 607771, a:6:{i:0;s:94:"Уже начинают сливать эксклюзивы на NextXbox, вроде PGR 5?
";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:89:"http://s4.hostingkartinok.com/uploads/images/2013/02/75bfc820dafd297bc8cbd201d9fe852e.png";}}i:2;s:2:"
";i:3;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:91:"http://www.vg247.com/2013/02/06/project-gotham-5-in-development-for-xbox-720-launch-rumour/";}}i:4;s:80:"
Серия PGR из самых успешных на платформе XBOX
";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:37:"http://www.abload.de/img/pgr4zk9d.gif";}}}, 1701116101, 1713561338
Run Time: 0.000704
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, 1960, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:51:"https://www.trueachievements.com/gamer/VLADIMIR+RUS";s:8:"original";a:2:{i:0;s:57:"[URL=https://www.trueachievements.com/gamer/VLADIMIR+RUS]";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:60:"https://www.trueachievements.com/gamercards/VLADIMIR+RUS.png";}}}}}, 1701116101, 1713561338
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, 607774, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:26:"Vladimir Rus, post: 607771";s:8:"original";a:2:{i:0;s:36:"[quote="Vladimir Rus, post: 607771"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:92:"Уже начинают сливать эксклюзивы на NextXbox, вроде PGR 5?";}}i:1;s:127:"
Угу, вроде как "слух", что может быть стартовой игрой для нового бокса";}, 1701116101, 1713561338
Run Time: 0.000320
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, 1713561338
Run Time: 0.000297
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, 607788, a:1:{i:0;s:18:"Очень жду!";}, 1701116101, 1713561338
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, 607789, a:1:{i:0;s:321:"Lucid Games, который по слухам занимается PGR5 состоит из чуваков когда-то работавших в Bizzare и Criterion. А бывший глава Bizzare ушел под крылышко Сони, где они готовят некст-ген ответ Forza Horizon =)";}, 1701116101, 1713561338
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: signature, 3212, a:1:{i:0;s:17:"There only be ONE";}, 1701116101, 1713561338
Run Time: 0.000237
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, 607790, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"dimm, post: 607789";s:8:"original";a:2:{i:0;s:28:"[quote="dimm, post: 607789"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:152:"А бывший глава Bizzare ушел под крылышко Сони, где они готовят некст-ген ответ Forza Horizon =)";}}i:1;s:189:"
То что я слышал, они как раз именно клон PGR и делают. Причем там часть остальных из разогнанной Liverpool Studio.";}, 1701116101, 1713561338
Run Time: 0.000274
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, 191, a:1:{i:0;s:75:"I am Lrrr! Ruler of the planet Omicron Persei 8! May I crash on your couch?";}, 1701116101, 1713561338
Run Time: 0.000275
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, 607871, a:1:{i:0;s:401:"Все гонки тупое каталово, но в PGR самое тупое каталово из всех гонок в которые я играл. Надо что-то делать разработчикам. Просто не интересно играть. Хотя физика супер. Погода супер. Графика отличная. А играть не интересно.";}, 1701116101, 1713561338
Run Time: 0.000860
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, 607879, a:2:{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:9:"Bahamut2k";}}i:1;s:118:",
Убавь-ка градус по отношению к Димму, а то захлебнешься скоро. =)";}, 1701116101, 1713561338
Run Time: 0.000635
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, 472, a:3:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://shenmue.link/order/";s:8:"original";a:2:{i:0;s:34:"[URL='http://shenmue.link/order/']";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:64:"Помоги дядe Ю, поддержи, б**дь, Шенму!";}}}}i:1;s:2:"
";i:2;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:26:"http://shenmue.link/order/";}}}, 1701116101, 1713561338
Run Time: 0.000228
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, 610481, a:6:{i:0;s:229:"Судя по всему игру Люсиду помогает делать RARE, уж больно много race-разрабов последние попринимали на работу. Вот состав Lucid Games:
";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:1:{i:0;s:2361:"Art Manager: was lead 3D artist on PGR2 and 3. Joined Lucid in February 2012 after a stint at Criterion Games working as Contract 3D artist and World Builder on Need for Speed Most Wanted 2. (Source)
Audio Lead: was contract Audio Designer on Blood Stone. Joined Lucid in January 2012 after a three month contract on a Kinect title at Rare. (Source)
Character Animator: joined Lucid in October 2012 and notes he is working on a soon to be announced game. (Source)
Computer Games Artist: was Technical Artist on PGR3 and 4. He joined Lucid in February 2012. (Source)
Designer: was a Games Designer on Blood Stone and The Club. (Source)
Designer: was Level Designer on The Club and Blood Stone. He joined Lucid in October 2011 after a five month stint as Environment Artist Wipeout 2048 at SCEE. (Source)
Developer: notes on his linkedin on a Top Secret project. (Source)
Doing art: was Art Director on Blur and Lead Environment Artist, Lead Effects and Lighting Artist on PGR4. (Source)
Doing production: served as Senior Producer on Blur, Producer on PGR4 and Co-Producer on PGR3. (Source)
Game Developer: was Senior Designer on Sonic All Stars Racing: Transformed at Sumo Digital, Senior Designer on Blood Stone at Bizarre Creations and Lead Designer on the Wipeout franchise at Sony. (Source)
Lead artist: served as Art Manager on PGR2, 3, 4 and Blood Stone. He joined Lucid in February 2012 after a stint as Art Manager on Forza Horizon at Playground Games. (Source)
Programmer: was Gameplay Programmer for Blur. (Source)
Programmer: was Vehicle Programmer at Bizarre Creations and Programmer on Motorstorm: Pacific Rift at Sony. (Source)
Programmer: was Audio Programmer on PGR3 and 4. Joined Lucid in October of 2011 after a three month contract at Rare. (Source)
Programmer: was Gameplay Programmer on The Club. (Source)
Technical Artist: was a Technical Artist on PGR4. (Source)
The Co-Founder and Programmer: served as Lead Technical Programmer on Blur and as Programmer on PGR3 and 4. (Source)
The Co-Founder and Programmer: served as Lead Programmer on Blood Stone. (Source)
The Co-Founder: served as Studio Design Director on PGR 4. (Source)
The Co-founder: served as Producer on Blood Stone and The Club. (Source)
The Studio Head: served as Development Director and Producer for the Project Gotham Racing franchise over. (Source)";}}i:2;s:76:"
А вот кого за последние 2 года принял RARE:
";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:1850:"On October 2011 as Software Director. Previously at Codemasters working as Lead Programmer on titles like DiRT 3 and Operation Flashpoint: Dragon Rising. (Source)
On November 2011 as Studio Audio Director. Previously at Ubisoft Reflections working on Driver: San Francisco. (Source)
On December 2011 as Technical Art Director. Previously at Codemasters working as Technical Art Supervisor on titles like GRID2, DiRT3, F1 Race Stars and more. (Source)
On June 2012 as Lead Artist. Previously at Codemasters working as Lead Artist on titles like DiRT3. (Source)
On October 2012 as Senior Producer. Previously at Codemasters working as Producer on titles like DiRT Showdown, DiRT 3 and more. (Source)
On November 2012 as Senior Game Designer. Previously at Codemasters working as Senior Game Designer on DiRT Showdown and DiRT 3. (Source)
On December 2012 as Principal Lighting Artist. Previously at Codemasters working as Environment Artist on titles like GRID2 and DiRT Showdown. (Source)
On December 2012 as Lead Character Artist. Previously at SCEE working on Evolution Studios' Motorstorm: Apocalypse and Studio Liverpool's WipeOut 2048. (Source)
On December 2012 as Principle environment artist. Previously Senior Lead Artist at Codemasters working on titles like GRID2 and F1 Race Stars. (Source)
On January 2013 as Principal Rendering Engineer. Previously at Codemasters working as Principal Rendering Programmer at Central Technology Group. (Source)
On January 2013 as Senior Rendering Engineer. Previously at Codemasters working as Senior Rendering Programmer. (Source)
On February 2013 as Audio Engineer. Previously at Codemasters working as Senior Programmer on GRID2 and DiRT Showdown. (Source)
On February 2013 as Principal Artist. Previously Character Artist at Playground Games, Codemasters and Slightly Mad Studios. (Source)";}}i:4;s:116:"
Ходят слухи, что и какая-то третья команда помогает им (Turn 10?):
";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:37:"http://i7.minus.com/jcBktM3ZA9EKO.png";}}}, 1701116101, 1713561338
Run Time: 0.001602
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, 610501, a:1:{i:0;s:155:"Даа.. PGR шикарная игра ! Четвёртую часть аж на лицухе взял .
Так что ждём с нетерпением !";}, 1701116101, 1713561338
Run Time: 0.001056
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, 1059, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:31:"http://exophase.com/gamercards/";s:8:"original";a:2:{i:0;s:37:"[URL=http://exophase.com/gamercards/]";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:40:"http://gamercards.exophase.com/11541.png";}}}}}, 1701116101, 1713561338
Run Time: 0.000599