SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000263
| 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: 7965
Run Time: 0.001153
| 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: 2
Run Time: 0.000663
| 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 >= 20 AND post.position < 40)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 7965
Run Time: 0.003254
| 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 | | 2 | 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: 7965
Run Time: 0.000330
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=7965&page=2, 1714759205,
Run Time: 0.000375
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, 154293, a:5:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:26:"RGB Nameless, post: 153905";s:8:"original";a:2:{i:0;s:36:"[quote="RGB Nameless, post: 153905"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:49:"На исоханте только 3 нарыл )";}}i:1;s:175:"
Возможно, что остальные две серии еще не пустили в эфир.
Кстати, вот описание всех эпизодов:
";i:2;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:10:{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:10:"Episode 1 ";}}i:1;s:1139:"
In the 1950s, the Cold War quickly evolved between the world superpowers of the United States and the Soviet Union. Mutually assured destruction enforced an uneasy stalemate, yet also drove computer technology to create missile simulations in order to predict the results of a nuclear war. This same computer technology was used to develop the first computer game in 1958 – Tennis for Two. The Space Race and the Vietnam war coincided with Steve Russell’s game Space War! and the emergence of the first true giants in the videogame business – Nolan Bushnell and Atari. In post-World War II Japan, electronics and computer technology emerged to rebuild a land and economy devastated by the atomic bomb. Space Invaders and Pac-Man soon followed, and the Golden Age of videogames was born. Among others, individuals featured in this episode include Steve Russell, Nolan Bushnell, Ralph Baer (considered by many to be the inventor of the videogame) and Toru Iwatani (Pac-Man designer). Videogames emerged as a form of entertainment where the player was in control, as opposed to the more passive diversion of watching television.
";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:9:"Episode 2";}}i:3;s:1138:"
In the late 1970s and 1980s, instead of controlling “things” like spaceships and tennis rackets, videogame technology let players command recognizable characters with real faces and back stories. Game developers were liberated to create more complex videogames with heroic journeys – and Japanese creators like Shigeru Miyamoto rose to prominence with star characters Mario, Donkey Kong and Zelda. But in the 1990s, Generation X emerged and the games of their childhood couldn’t satisfy the new teen angst that now permeated pop culture. With Sega’s Genesis and Sony’s PlayStation, gamers dismissed cutesy cartoon characters in favour of grittier heroes like Sonic the Hedgehog and anti-heroes in games like Grand Theft Auto III. As players grew up, their youthful idealism was replaced with a warier view of the world and a yearning for photorealistic, angry anti-heroes. This episode features interviews with Trip Hawkins (Silicon Valley entrepreneur and co-founder of Electronic Arts), Al Lowe (creator of Leisure Suit Larry), Tim Schafer (creator of Full Throttle) and other notable figures in the gaming industry.
";i:4;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:"Episode 3";}}i:5;s:1347:"
It was a foreign concept to the early game designers, but with games like Castle Wolfenstein 3-D and Doom, videogames grew from their primitive 2-D roots into richly detailed 3-D worlds. These groundbreaking 3-D games led the industry down new paths – both thrilling and troubling. Designers now had the technology to create games that accurately simulated the real world. For the first time, game designers had to grapple with a difficult question – how long before a game was nearly indistinguishable from reality? For all the controversy surrounding the first-person shooter genre in videogames, its popularity was undeniable. And in the wake of the September 11th terrorist attacks, the same government that fought to regulate videogames quickly designed their own as a recruiting tool for the army. America’s Army was born and an even more sensitive debate arose as to the morality of recruiting young men for real war through the fun of a videogame. Were games desensitizing us to the very real pain of violence and war? And more importantly, were videogames leading us on a march towards virtual war? Some people interviewed in this episode include Colonel Casey Wardynski (Director and project originator of America’s Army) and Asi Burak (producer of Peacemaker – a computer game simulation of the Israeli-Arab conflict).
";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:9:"Episode 4";}}i:7;s:1145:"
Ever since the invention of the computer, man has feared “the machine” and its ability to think. But a computer’s unique computational power has also led to the development of games that are unpredictable, intelligent and malleable. “God games” like SimCity and Civilization simulate entire worlds and let players experiment with cause and effect. As the 1990s dawned, global turmoil forced gamers to find solace in the world of videogames – a virtual world that offered control at a time when the real world seemed dangerously out of control. Now, videogames have become tools for learning and creative expression. Players use games like Halo and Unreal Tournament 3 to tell their own stories via Machinima or through custom content that is shared with others over the internet. The line between producer and customer has forever blurred – further proof that videogames are destined to become the dominant form of entertainment. This episode features Will Wright (creator of SimCity, The Sims and Spore), Sid Meier (developed the game series Civilization) and John Brennan (voice actor from the Jerky Boys and Family Guy).
";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:9:"Episode 5";}}i:9;s:1422:"
The advent of the internet has changed everything – including videogames. When ARPNET, a military precursor to the internet, went live in 1969, gamers almost immediately began using this new technology for gaming. But what began as text-based adventure games called MUDs (multi-user dungeons) quickly evolved into graphic-based online adventure games called MMOs (massively multi-player online games). Millions worldwide have battled together and against one another in the latest genre of videogame. From Ultima Online to the most successful MMO of all time, World of Warcraft, gamers now are attracted to virtual second lives as they battle friends and foes across the globe from the safety of their home computers. In the virtual world, gamers have found they can be anyone or anything. The ability to reinvent oneself virtually has become an irresistible experience for many, and has some critics wondering whether the line between the real world and the virtual world has become dangerously blurred. Many gamers spend more time in the virtual world than the real world, but they argue that the virtual experiences of MMOs are still human experiences simply delivered via the latest wave of technology – the videogame. This episode includes interviews with Cory Ondrejka (Chief Technology Officer at Linden Lab) and Richard Bartle (British writer and game researcher best known for being the co-author of MUD) ";}}i:3;s:4:"
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:66:"http://www.discoverychannel.com.au/i_videogame/html/synopsis.shtml";s:8:"original";a:2:{i:0;s:74:"[URL="http://www.discoverychannel.com.au/i_videogame/html/synopsis.shtml"]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:66:"http://www.discoverychannel.com.au/i_videogame/html/synopsis.shtml";}}}, 1701116101, 1714759205
Run Time: 0.001631
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, 1714759205
Run Time: 0.000601
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, 154531, 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:17:"4-й эпизод";}}i:1;s:40:" в торренты выложили :)";}, 1701116101, 1714759205
Run Time: 0.001138