SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000208
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: 17728
Run Time: 0.000734
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.000455
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: 17728
Run Time: 0.001978
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 | 1 | 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: 17728
Run Time: 0.000239
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=17728, 1711639512,
Run Time: 0.000304
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, 430411, a:71:{i:0;s:98:"Приветствую, итак, я распродаю большую коллекцию игр, ";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:2:{i:0;s:39:"пока выкладываю игры ";i:1;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:3:"PS2";}}}}i:2;s:32:", потом еще будут: ";i:3;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"blue";s:8:"original";a:2:{i:0;s:12:"[color=blue]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:57:"PS1, PS3, PSP, NDS, GC, Wii, XBox, Xbox 360, N64 + Guides";}}i:4;s:360:"...
Сейчас выкладываю просто списком, без цен, без описания состояния/комплекта. По мере проявления вашего интереса к играм, я буду обновлять информацию, просто сразу осилить такой список сложно... ";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:3:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"blue";s:8:"original";a:2:{i:0;s:12:"[color=blue]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:34:"Все игры PAL региона";}}i:1;s:58:", кроме тех, где указано, что они ";i:2;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:4:"NTSC";}}}}i:6;s:5:".
";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:17:"Контакты:";}}i:8;s:180:"
ICQ 173841566
Mail.Ru Agent: alexeybunak[улитка]mail[точка]ru
Jabber: alexeybunak[улитка]gmail[точка]com
QIP: InSaneXZ[улитка]qip[точка]ru
";i:9;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[COLOR=red]";i:1;s:8:"[/COLOR]";}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:131:"ВНИМАНИЕ: Здесь бываю не так часто, поэтому лучше пишите в Мессенджеры ;)";}}}}i:10;s:106:"
1 24: The Game
2 50 Cent Bulletproof
3 Age Of Empires 2: The Age of Kings
4 All Star Pro-Wrestling ";i:11;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:12;s:1:" ";i:13;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"blue";s:8:"original";a:2:{i:0;s:12:"[color=blue]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:3:"NEW";}}i:14;s:29:"
5 All Star Pro-Wrestling 2 ";i:15;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:16;s:125:"
6 Area 51
7 Athens 2004
8 Beyond Good & Evil
9 Bionicle
10 BRATZ Forever Diamond
11 Brother in Arms: Road to Hill 30
";i:17;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:44:"12 Brother in Arms: Road to Hill 30 Platinum";}}i:18;s:31:"
13 Burnout Revenge
14 Busin ";i:19;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:20;s:152:"
15 Canis Canem Edit (Bully)
16 Chaos Legion
17 Crazy Frog Racer
18 Cricket 2002
19 Cricket 2005
20 Crouching Tiger Hidden Dragon
21 Dark Angel
";i:21;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:25:"22 Devil May Cry Platinum";}}i:22;s:108:"
23 Disney Pirates of The Caribbean At Worlds End
24 Disney's Tarzan Freeride
25 Dragon Ball Z Budokai 2 ";i:23;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:4:"NTSC";}}i:24;s:13:"
26 DRIV3R
";i:25;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:18:"27 DRIV3R Platinum";}}i:26;s:40:"
28 Dynasty Warriors 3 Xtreme Legends
";i:27;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:28:"29 Enter the Matrix Platinum";}}i:28;s:67:"
30 EOE: Eve of Extinction
31 Evil Dead: A Fistful of Boomstick
";i:29;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:26:"32 EyeToy: Groove Platinum";}}i:30;s:1:" ";i:31;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"blue";s:8:"original";a:2:{i:0;s:12:"[color=blue]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:3:"NEW";}}i:32;s:146:"
33 EyeToy: Play
34 Fahrenheit
35 Fallout: Brotherhood of Steel
36 FIFA Football 2003
37 FIFA Football 2004
38 FIFA 08
39 Final Fantasy X
";i:33;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:27:"40 Final Fantasy X Platinum";}}i:34;s:24:"
41 Final Fantasy XII
";i:35;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:26:"42 Formula One 04 Platinum";}}i:36;s:55:"
43 Genji
44 Ghosthunter
45 Giants: Citizen Kabuto
";i:37;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:22:"46 God of War Platinum";}}i:38;s:2:"
";i:39;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:33:"47 Gran Turismo 3 A-Spec Platinum";}}i:40;s:51:"
48 Gran Turismo 4 Prologue
49 G-Round G-Breaker ";i:41;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:42;s:1:" ";i:43;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"blue";s:8:"original";a:2:{i:0;s:12:"[color=blue]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:3:"NEW";}}i:44;s:274:"
50 GTC Africa
51 Gungriffon Blaze
52 Harry Potter: And the Chamber of Secrets
53 Harry Potter: And the Prisoner of Azkaban
54 Harry Potter: And the Goblet of Fire
55 Haven: Call of The Kings
56 Headhunter Redemption
57 Hitman: Contracts
58 International Cue Club
";i:45;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:17:"59 Jak 3 Platinum";}}i:46;s:13:"
60 Juiced
";i:47;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:18:"61 Juiced Platinum";}}i:48;s:36:"
62 Killzone
63 King of Colosseum ";i:49;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:50;s:80:"
64 Lake Masters EX
65 L.A. Rush
66 Legend of Kay
67 Legends of Wrestling 2 ";i:51;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:5:"Promo";}}i:52;s:424:"
68 LEGO Star Wars: The Video Game
69 Lemony Snicket's A Series of Unfortunate Events
70 Little Britain: The Video Game
71 LMA Manager 2003
72 LMA Manager 2004
73 LMA Manager 2006
74 MAGIX Music Maker
75 Max Payne
76 Max Payne 2
77 Maximo vs Army of Zin
78 Metal Gear Solid 2: Sons of Liberty
79 Mortal Kombat: Deadly Alliance
80 Mortal Kombat: Shaolin Monks
81 MX World Tour
82 Need For Speed Underground 2
";i:53;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:40:"83 Need For Speed Underground 2 Platinum";}}i:54;s:90:"
84 Need For Speed Carbon: Collector's Edition
85 Ninja Assault
86 Onimusha: Warlords
";i:55;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:30:"87 Onimusha: Warlords Platinum";}}i:56;s:589:"
88 Open Season (Сезон Охоты)
89 Perfect Ace 2: The Championships
90 Pop Idol
91 Primal
92 Pro Evolution Soccer 2
93 Psi-Ops: The Mindgate Conspiracy
94 Rayman 3: Hoodlum Havoc
95 Rayman M
96 Rayman Raving Rebbids
97 Resident Evil Outbreak
98 Return to Castle Wolfenstein: Operation Resurrection
99 Road Trip Adventure
100 Robot Wars: Arenas of Destruction
101 Rugby 2005
102 Second Sight
103 Shadow of Rome
104 Shadow The Hedgehog
105 Shark Tale
106 ShellShock: Nam '67
107 Silent Hill 2: Director's Cut
108 Sky Surfer
109 SmackDown!: Here Comes The Pain
";i:57;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:44:"110 SmackDown!: Here Comes The Pain Platinum";}}i:58;s:340:"
111 SmackDown!: Shut Your Mouth
112 SmackDown! Vs. Raw 2006
113 SmackDown! Vs. Raw 2007
114 SmackDown! Vs. Raw 2008
115 Smuggler's Run
116 SNK vs Capcom: SVC Chaos
117 SOCOM: U.S. Navy SEALs
118 Sonic Heroes
119 SoulCalibur 2
120 Space Race
121 Spartan: Total Warrior
122 SpongeBob SquarePants: Revenge of the Flying Dutchman
";i:59;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:23:"123 SSX Tricky Platinum";}}i:60;s:196:"
124 SSX On Tour
125 State of Emergency
126 Stuntman Platinum
127 Stuntman Ignition
128 Summer Heat Beach Volleyball
129 Summoner
130 Summoner 2
131 SWAT Global Strike Team
132 Tekken 4
";i:61;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:21:"133 Tekken 5 Platinum";}}i:62;s:109:"
134 The Getaway
135 The Godfather
136 The Godfather Limited Edition
137 The Simpsons Game
138 The SIMS ";i:63;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:4:"NTSC";}}i:64;s:226:"
139 The Sum of All Fears
140 This is Football 2002
141 This is Football 2003
142 This is Football 2004
143 Tiger Woods PGA Tour 2003
144 TOCA Race Driver 2
145 Tom Clancy's Ghost Recon
146 Tom Clancy's Splinter Cell
";i:65;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:39:"147 Tom Clancy's Splinter Cell Platinum";}}i:66;s:47:"
148 Tom Clancy's Splinter Cell Double Agent
";i:67;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:4:"gray";s:8:"original";a:2:{i:0;s:12:"[color=gray]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:37:"149 Tony Hawk's Pro Skater 3 Platinum";}}i:68;s:231:"
150 Tony Hawk's Project 8
151 True Crime: New York City
152 True Crime: Streets of LA
153 Twin Caliber
154 TY The Tasmanian Tiger
155 UEFA Euro 2004
156 Viewtiful Joe
157 Wild Wild Racing
158 Winning Post 5: Maximum 2002 ";i:69;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:3:"red";s:8:"original";a:2:{i:0;s:11:"[color=red]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;s:6:"NTSC/J";}}i:70;s:27:"
159 XG3: Extreme-G Racing";}, 1701116101, 1711639512
Run Time: 0.000584