SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000340
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: 7155
Run Time: 0.001232
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: 7
Run Time: 0.000624
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: 7155
Run Time: 0.007387
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 | 13 | 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: 7155
Run Time: 0.000522
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=7155, 1714108081,
Run Time: 0.001677
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, 135324, a:1:{i:0;s:259:"Народ, может кто знает, какой самый лучший теннисный сим на плойке 2. А то есть у меня только Outlaw
Tennis и ему до нормального тенниса ой как далеко.";}, 1701116101, 1714108081
Run Time: 0.000533
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, 135421, a:1:{i:0;s:454:"Top Spin --> Smash Court Tennis Pro Tournament --> Sega Sports Tennis --> Smash Court Tennis Pro Tournament 2
Top Spin имхо самая слабая за счет довольно долгих загрузок, ну а все остальные - более-менее нормальные (ну разве что SCTPT чуть послабее остальных двух игр). Остальные честно говоря не помню. :)";}, 1701116101, 1714108081
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: signature, 109, a:1:{i:0;s:19:"Filled with wisdom.";}, 1701116101, 1714108081
Run Time: 0.000264
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, 135436, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"DeaD, post: 135421";s:8:"original";a:2:{i:0;s:28:"[quote="DeaD, post: 135421"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:454:"Top Spin --> Smash Court Tennis Pro Tournament --> Sega Sports Tennis --> Smash Court Tennis Pro Tournament 2
Top Spin имхо самая слабая за счет довольно долгих загрузок, ну а все остальные - более-менее нормальные (ну разве что SCTPT чуть послабее остальных двух игр). Остальные честно говоря не помню. :)";}}i:1;s:30:"
Пасиб за инфу:)";}, 1701116101, 1714108081
Run Time: 0.005197
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, 135438, a:1:{i:0;s:169:"И еще немного не в тему, сегодня юзал Virtua Tennis 3 на РС, игруха - жесть...
А с чего она портирована?";}, 1701116101, 1714108081
Run Time: 0.002369
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, 135439, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:25:"fatal_error, post: 135438";s:8:"original";a:2:{i:0;s:35:"[quote="fatal_error, post: 135438"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:169:"И еще немного не в тему, сегодня юзал Virtua Tennis 3 на РС, игруха - жесть...
А с чего она портирована?";}}i:1;s:108:"
VT 3 насколько мне известна вышла в одно время на X360, PS3 и PSP.";}, 1701116101, 1714108081
Run Time: 0.000436
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, 135444, a:1:{i:0;s:462:"Лучший теннис на PS2 (как впрочем и на любой другой платформе вроде) это Sega Sports Tennis (Sega Sports Tennis 2K2 [working title], Sega Sports Tennis 2002, Sega the Best 2800 Vol. 1 - Power Smash 2 (JPN), Virtua Tennis 2 (UK)). А в третью часть на PC вы играть не могли, потому как её не существует - Available On: Arcade, Xbox 360, PlayStation 3, PSP.";}, 1701116101, 1714108081
Run Time: 0.005364
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, 135450, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:3:"cir";s:8:"original";a:2:{i:0;s:11:"[QUOTE=cir]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:177:"А в третью часть на PC вы играть не могли, потому как её не существует - Available On: Arcade, Xbox 360, PlayStation 3, PSP.";}}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:40:"http://www.ag.ru/reviews/virtua_tennis_3";}}}, 1701116101, 1714108081
Run Time: 0.000623
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, 135453, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:19:"OGGIS, post: 135450";s:8:"original";a:2:{i:0;s:29:"[quote="OGGIS, post: 135450"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;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:40:"http://www.ag.ru/reviews/virtua_tennis_3";}}}}i:1;s:143:"
Не хило однако (проверил в инете релиз лежит)! Я даже анонса не видел, и кстати ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:42:"http://psp.ign.com/objects/849/849918.html";s:8:"original";a:2:{i:0;s:50:"[URL="http://psp.ign.com/objects/849/849918.html"]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:35:"ign.com тоже не в курсе";}}i:3;s:3235:".
Наверно я слепой, оказывается анонс был ещё в середине прошлого года - PC версия символично объявлена вместе с PSP обрезком:
SEGA Announce New Stars And Multi-Platform Release For Virtua Tennis 3!
Brand New Innovative Content, Top International Players and New Multi-Format Release Strategy for SEGA's Benchmark Tennis Franchise
LONDON & SAN FRANCISCO (August 23rd, 2006) – SEGA Europe Ltd. and SEGA® of America, Inc. today announced the complete line up of top tennis stars, plus a whole host of new features destined to set the courts alight in Virtua Tennis 3. By releasing on the PSP and PC, as well as on PS3 and X360 in Spring 2007, this will be the first time this classic franchise has had a simultaneous multi-platform release.
Virtua Tennis 3 will include a host of superstar tennis players from both the male and female circuits. World No.1 and 2006 Wimbledon Champion Amelie Mauresmo heads up the roster of womens tennis greats alongside global superstar Maria Sharapova, world renowned powerhouse Venus Williams and the resurgent Martina Hingis. Rising star Nicole Vaidisova, hard hitting Lindsay Davenport and Slovakian Daniela Hantuchova complete the list of women’s headliners you can chose to either play as or against as you compete in one of Virtua Tennis 3’s many tournaments.
The very best of men’s tennis is also available in Virtua Tennis 3 with top seed and four times Wimbledon Champion Roger Federer leading the men’s line up. Gamers can also sample the raw power of World No.2 Rafael Nadal, the dangerous serve of Andy Roddick, the serve and volley skills of Tim Henman or the tenacity of Lleyton Hewitt. New to Virtua Tennis 3 are the next generation of tennis superstars in James Blake, Mario Ancic, Gael Monfils and Taylor Dent. Completing the list are global stars David Nalbandian, Sebastien Grosjean, Juan Carlos Ferrero, and Tommy Haas.
Virtua Tennis 3 will again allow players to create their own tennis superstar to take part in a brand new iteration of the popular World Tour Mode. By using the extensive player creation module, building up your stats and winning exhibition and tournament matches you too could become a World No.1! In addition to this the World Tour mode will include 10 brand new addictive Mini Games that feature all the hallmarks of the classic games fans know and love. And that’s not all! There are also two classic mini games that will help you perfect your skills on your quest to the top.
Also new to the series, Court Games will add a fresh feel to the multiplayer side of Virtua Tennis 3. These quirky variants of the beloved mini-games allow for frantic games against up to three human opponents, offering a new multiplayer experience for all and further deepening the longevity of the definitive next gen tennis experience.
The final addition of five set matches rounds off Virtua Tennis 3’s comprehensive list of new and improved features, cementing the franchises’ position as the benchmark tennis videogame available on any videogames format.
Virtua Tennis 3 is set for release on PS3, X360, PSP and PC in Spring 2007.";}, 1701116101, 1714108081
Run Time: 0.000570
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, 135505, a:1:{i:0;s:137:"Кстати, никто не играл в Agassi Tennis Genaration, который в геймпарке за 300 р продают? :)";}, 1701116101, 1714108081
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: post, 135567, a:1:{i:0;s:449:"to cir, прикольно, я твое сообщение прочитал и подумал - может у меня глюк?:-) Включил,
еще раз посмотрел-не глюк:-). Графика кстати там классная. Лица так себе, а вот все остальное-супер. Особенно понравилась одежка на теннисистах, ну прям как настоящая.";}, 1701116101, 1714108081
Run Time: 0.000858
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, 135841, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:19:"OGGIS, post: 135505";s:8:"original";a:2:{i:0;s:29:"[quote="OGGIS, post: 135505"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:137:"Кстати, никто не играл в Agassi Tennis Genaration, который в геймпарке за 300 р продают? :)";}}i:1;s:65:"
Судя по рейтингу от gamerankings треш. :)";}, 1701116101, 1714108081
Run Time: 0.001296
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, 135929, a:5:{i:0;s:7:"[off]
";i:1;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:4:"DeaD";s:8:"original";a:2:{i:0;s:12:"[QUOTE=DeaD]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:57:"Судя по рейтингу от gamerankings треш";}}i:2;s:149:"
Кстати, у меня почему-то уже очень давно не работает геймранкингс. Просто пишет:
";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:162:"We're sorry, we are temporarily offline. We'll be back as soon as possible.
Meanwhile, please visit one of our sister sites like MetaCritic.com or GameSpot.com.";}}i:4;s:6:" :huh:";}, 1701116101, 1714108081
Run Time: 0.000311
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, 136327, a:1:{i:0;s:127:"Фиг знает, он почему-то в офллайне был, сейчас вышел, ну и славно. :)
[/off]";}, 1701116101, 1714108081
Run Time: 0.000681