SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000174
| 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: 8870
Run Time: 0.000883
| 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: 4
Run Time: 0.000512
| 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 >= 120 AND post.position < 140)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASCParams: 8870
Run Time: 0.241245
| 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 | | 7 | 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: 8870
Run Time: 0.000391
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=8870&page=7, 1714620585,
Run Time: 0.000395
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, 518206, a:1:{i:0;s:684:"DRAGON QUEST THE CHAPTERS OF THE CHOSEN DS (EU) 800
PRO EVOLUTION SOCCER 2008 DS (US) 800
PROFESSOR LAYTON AND THE DIABOLICAL BOX DS (US) 1000
POKEMON XD GALE OF DARKNESS GameCube (PAL) 500
TRAUMA CENTER SECOND OPINION WII (PAL) 1300
RESIDENT EVIL THE UMBRELLA CHRONICLES (Рус. док.) WII (PAL) 550
GUITAR HERO III+ 2 ГИТАРЫ WII (PAL) 1300
ARMORED CORE FOR ANSWER PS3 (EU) 800
GRAN TURISMO THE REAL DRIVING SIMULATOR (RUS) PSP (EU) 900
COLIN MCRAE DIRT 2 XBOX360 (PAL) 1350
DRAGON AGE НАЧАЛО (RUS) XBOX360 (PAL) 900
NEED FOR SPEED CARBON Classics XBOX360 (PAL) 450
PRO EVOLUTION SOCCER 2010 (RUS SUB) XBOX360 (PAL) 1300
уходит из списка";}, 1701116101, 1714620585
Run Time: 0.036456
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, 523083, a:1:{i:0;s:422:"OVERLORD II PS3 (EU) 800
BAYONETTA PS3 (EU) 1000
RATCHET & CLANK TOOLS OF DESTRUCTION PS3 (EU) 800
TRANSFORMERS REVENGE OF THE FALLEN PS3 (EU) 1100
МИССИЯ ДАРВИНА (RUS) PS3 (EU) 1000
LEGO INDIANA JONES THE ORIGINAL ADVENTURES WII (PAL) 450
SUPERMAN RETURNS XBOX360 (PAL) 900
FIGHT NIGHT ROUND 4 XBOX360 (PAL) 900
GREAT BATTLES OF ROME THE HISTORY CHANNEL PSP (EU) 800
уходит из списка";}, 1701116101, 1714620585
Run Time: 0.000413
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, 525708, a:1:{i:0;s:275:"NINTENDOGS CHIHUAHUA & FRIENDS DS (EU) 800
BAJA EDGE OF CONTROL PS3 (EU) 900
BAYONETTA PS3 (EU) 1000
ELDER SCROLLS IV OBLIVION GOTY EDITION PS3 (EU) 800
WWE SMACKDOWN VS. RAW 2008 WII (PAL) 900
ARMY OF TWO THE 40TH DAY XBOX360 (PAL) 900
уходит из списка";}, 1701116101, 1714620585
Run Time: 0.069059
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, 526352, a:1:{i:0;s:43:"Привет, отписал в личку.";}, 1701116101, 1714620585
Run Time: 0.036252
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, 529914, a:1:{i:0;s:200:"FINAL FANTASY XIII PS3 (EU) 1100
ОФИСНОЕ КУНГ ФУ ( PS MOVE, RUS) PS3 (EU) 1250
SID MEIER'S PIRATES PSP (EU) 800
INFINITE UNDISCOVERY XBOX360 (PAL) 900
уходят из списка";}, 1701116101, 1714620585
Run Time: 0.000378
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, 534492, a:1:{i:0;s:2521:"BLACK PS2 (PAL) 600
GOD OF WAR COLLECTION PS3 (US) 1000
RESIDENT EVIL 5 XBOX360 (PAL) 900
SUPER MONKEY BALL BANANA BLITZ WII (PAL) 700
LEGO BATMAN THE VIDEOGAME WII (PAL) 450
HELLBOY THE SCIENCE OF EVIL PSP (US) 900
уходит из списка
добавлено 04 апреля
NBA LIVE 07 PC 100
BEE MOVIE GAME PS2 (PAL) 450
FIFA 07 (RUS) PS2 (PAL) 350
FIFA STREET 2 PS2 (PAL) 350
GODFATHER PS2 (PAL) 350
SCOOBY- DOO AND THE SPOOKY SWAMP PS2 (PAL) 700
SPLINTER CELL PS2 (PAL) 450
BIOSHOCK 2 PS3 (EU) 900
BLUR PS3 (EU) 1100
DANTE'S INFERNO PS3 (EU) 700
EA SPORTS MMA PS3 (EU) 1450
GRAND THEFT AUTO IV THE COMPLETE EDITION PS3 (EU) 1450
JUST CAUSE 2 PS3 (EU) 800
KILLZONE 3 ( PS MOVE, 3D, RUS) PS3 (EU) 1850
LAST REBELLION PS3 (US) 1300
MADDEN NFL 11 PS3 (EU) 1900
MAFIA II КОЛЛЕКЦИОННОЕ ИЗДАНИЕ (RUS) PS3 (EU) 1750
MARVEL VS. CAPCOM 3 FATE OF TWO WORLDS PS3 (EU) 1650
MEDAL OF HONOR LIMITED EDITION (EU) PS3 (EU) 1450
PRINCE OF PERSIA TRILOGY CLASSICS HD PS3 (EU) 1000
RED DEAD REDEMPTION UNDEAD NIGHTMARE PS3 (EU) 950
RESIDENT EVIL 5 GOLD EDITION (PS MOVE) PS3 (EU) 950
TERMINATOR SALVATION PS3 (EU) 750
TEST DRIVE UNLIMITED 2 PS3 (EU) 1600
TOM CLANCY'S H.A.W.X. 2 PS3 (EU) 1100
WAY OF THE SAMURAI 3 PS3 (EU) 850
WRC FIA WORLD RALLY CHAMPIONSHIP 2010 PS3 (EU) 1350
WWE SMACKDOWN VS RAW 2011 PS3 (EU) 1500
GOD OF WAR ПРИЗРАК СПАРТЫ (RUS) PSP (EU) 1000
KINGDOM HEARTS BIRTH BY SLEEP PSP (EU) 1000
KINGDOM HEARTS BIRTH BY SLEEP LIMITED EDITION PSP (EU) 1350
GOD OF WAR CHAINS 0F OLYMPUS PSP (EU) 550
TEKKEN DARK RESURRECTION PSP (EU) 550
GUITAR HERO III+ ГИТАРА WII (PAL) 900
SCOOBY-DOO AND THE SPOOKY SWAMP WII (PAL) 950
SUPER SMASH BROS. BRAWL WII (PAL) 1150
TOURNAMENT OF LEGENDS WII (PAL) 850
BEN 10 ULTIMATE ALIEN COSMIC DESTRUCTION XBOX360 (PAL) 1200
FABLE III (RUS SUB) XBOX360 (PAL) 1550
FUZION FRENZY 2 XBOX360 (PAL) 350
GET FIT WITH MEL B BUNDLE (KINECT) XBOX360 (PAL) 1750
HALO REACH LIMITED EDITION XBOX360 (PAL) 1750
LAST REMNANT XBOX360 (PAL) 600
MEDAL OF HONOR LIMITED EDITION (EU) XBOX360 (PAL) 1450
NIER XBOX360 (PAL) 750
PROJECT GOTHAM RACING 4 (RUS) XBOX360 (PAL) 450
RED DEAD REDEMPTION UNDEAD NIGHTMARE XBOX360 (PAL) 950
SCENE IT + 4 WIRLESS CONTROLLER XBOX360 (PAL) 400
SUPREME COMMANDER 2 XBOX360 (PAL) 650
WRC FIA WORLD RALLY CHAMPIONSHIP 2010 XBOX360 (PAL) 1350
XBOX360 KINECT SENSOR+KINECT ADVENTURES (RUS) XBOX360 (PAL) 5700
YOUR SHAPE FITNESS EVOLVED (KINECT) XBOX360 (PAL) 1500
YOU'RE IN THE MOVIES (RUS) + КАМЕРА XBOX360 (PAL) 450";}, 1701116101, 1714620585
Run Time: 0.000365
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, 572932, a:1:{i:0;s:624:"NARUTO ULTIMATE NINJA 3 PS2 (PAL) 650
NARUTO ULTIMATE NINJA PS2 (PAL) 650
DANTE'S INFERNO PS3 (EU) 700
EA SPORTS MMA PS3 (EU) 1450
GRAND THEFT AUTO IV THE COMPLETE EDITION PS3 (EU) 1450
MAFIA II КОЛЛЕКЦИОННОЕ ИЗДАНИЕ (RUS) PS3 (EU) 1750
WAY OF THE SAMURAI 3 PS3 (EU) 850
DISGAEA INFINITE PSP (US) 800
SOULCALIBUR BROKEN DESTINY (RUS) PSP (EU) 800
WII FIT PLUS + BALANCE BOARD WII (PAL) (без коробки, новый) 2900
FABLE III (RUS SUB) XBOX360 (PAL) 1550
HALO REACH LIMITED EDITION XBOX360 (PAL) 1750
XBOX360 KINECT SENSOR+KINECT ADVENTURES (RUS) XBOX360 (PAL) 5700
ушло из списка";}, 1701116101, 1714620585
Run Time: 0.000438