SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000312
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: 13570
Run Time: 0.001077
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.000470
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: 13570
Run Time: 0.002733
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 | 2 | 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: 13570
Run Time: 0.000366
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=13570, 1711709132,
Run Time: 0.000416
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, 292550, a:29:{i:0;s:200:"Предлагаем вашему вниманию следующие лоты!
Картриджи Super Nintendo US NTSC, в отличном состоянии! Проверены лично!
";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:1:{i:0;s:11:"Лот №1";}}i:2;s:81:"
Donkey Kong Country
Spiderman X-man
American Gladiators
1300 руб.
";i:3;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99287976.jpg";}}i:4;s:4:"
";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:1:{i:0;s:11:"Лот №2";}}i:6;s:79:"
Mortal Combat
Mortal Combat 3
John Madden Football 93
1300 руб.
";i:7;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99309654.jpg";}}i:8;s:4:"
";i:9;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:11:"Лот №3";}}i:10;s:112:"
Castelvania IV (наклейка немного поюзана)
NHL 94
NHLPA Hockey 93
1300 руб.
";i:11;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99309652.jpg";}}i:12;s:4:"
";i:13;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:"Лот№4";}}i:14;s:74:"
Star Fox
Prince of Persia
Royal Rumble Wrestling
1300 руб.
";i:15;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99346665.jpg";}}i:16;s:4:"
";i:17;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:11:"Лот №5";}}i:18;s:211:"
Очень редкие игры!
Shangai Dragon's Eye - очень редкая, отличное состояние!
Raiden Trad - редкая, как новая!
Super Bases Loaded
1500 руб.
";i:19;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99346666.jpg";}}i:20;s:4:"
";i:21;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:12:"Лот № 6";}}i:22;s:83:"
Super Mario World
Mario is Missing
Battleship
Paperboy 2
1500 руб.
";i:23;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99382061.jpg";}}i:24;s:4:"
";i:25;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:12:"Лот № 7";}}i:26;s:318:"
Vegas Stakes
- классное казино!
Pool
- довольно редкий отличный биллиард.
Brunswick Bowling
- редкий трехмерный боулинг. супер мультиплеер.
Clue
- следы от наклеек, надпись. :~(
1500 руб.
";i:27;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:70:"http://photofile.ru/photo/polundra-warrior/95061673/large/99382062.jpg";}}i:28;s:43:"
Спасибо за внимание!";}, 1701116101, 1711709132
Run Time: 0.001847
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, 294841, a:9:{i:0;s:22:"Внимание!
";i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[size=7]";i:1;s:7:"[/size]";}s:8:"children";a:2:{i:0;s:111:"Предлагаю вашему вниманию громадную коллекцию мануалов для ";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:14:"Super Nintendo";}}}}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:1:"!";}}i:3;s:57:"
Всего коллекция насчитывает ";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:3:"202";}}i:5;s:501:" (!!!) мануала.
В общем коллекция в очень хорошем состоянии. Дефекты отмечены отдельно. Фото высылаю по требованию.
(b&w) - глянцевые черно-белые мануалы, по-видимому копии.
Не пропустите возможность заиметь эту прекрасную коллекцию, в которую было вбито немало сил и денег.
";i:6;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:6:"purple";s:8:"original";a:2:{i:0;s:14:"[color=purple]";i:1;s:8:"[/color]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[size=7]";i:1;s:7:"[/size]";}s:8:"children";a:1:{i:0;s:59:"Жду ваших предложений, дерзайте!";}}}}i:7;s:5031:"
1 Addams family Values
2 Aero the acro-bat
3 Aero the acro-bat (scotch&sticker)
4 Air strike patrol
5 Alien 3
6 Barkley shut up and jam!
7 Batman returns
8 Battle clash
9 Battleship (b&w)
10 Battletoads in battlemaniacs
11 Beavis and butt-head (b&w)
12 Biometal
13 Black thorne
14 Bonkers
15 Brutal Paws of Fury
16 Bubsy
17 Bugs Bunny rabbit rampage
18 Bulls vs Blazers
19 Bust-a-move (sticker)
20 Capcom’s MVP Football
21 Captain commando
22 Choplifter III rescue survive
23 Clay Fighter
24 Clay fighter 2
25 Cliffhanger
26 Clue (b&w)
27 Cool spot
28 D-force
29 Donkey kong country
30 Donkey Kong country
31 Donkey Kong country 2. Diddy’s kong quest
32 Donkey Kong Country 3 Dixi’s Double trouble
33 Doom
34 Doom (with stickers)
35 Doom troopers
36 Dragon View
37 Dragon. The Bruce Lee Story
38 Drakkhen
39 Earthworm Jim
40 F1Roc Race of champions
41 FIFA 96 soccer
42 Final Fantasy Mystic quest (map)
43 Final fight
44 Final fight (sticker)
45 First Samurai
46 F-zero
47 GP-1
48 Gradius
49 Inspector Gadget (sticker)
50 Jeopardy! Deluxe edition (b&w)
51 Joe & Mac
52 John Madden Football 93
53 John Madden Football 93 defense&offence (map)
54 Jungle strike (b&w)
55 Jurassic park (b&w)
56 Jurassic park (b&w)
57 Ka-bloofy
58 Killer Instinct
59 Killer Instinct (scotch)
60 King Arthur’s world
61 King of Dragons
62 King of the monsters 2
63 Kirby’s Dream house
64 Krusty’s super fun house
65 Last action hero
66 Lethal enforcers
67 Lock on
68 Madden 95
69 Madden 96
70 Madden 97
71 Madden 97 (map)
72 Mario is missing
73 Mario is missing
74 Mario Paint
75 Mario’s time machine (sticker)
76 Mark Davis’ The fishing master
77 Mary Shelley’s Frankenstein
78 Maximum carnage
79 Mega man x
80 Mega man x 2 (torn&scotch)
81 Metal combat. Falcon’s revenge
82 Michael Andretti’s Indy car challenge
83 Mighty Morpin Power Rangers
84 MLBPA Baseball
85 MLBPA Baseball
86 Monopoly (b&w)
87 Mortal Combat
88 Mortal combat 2
89 Mortal combat 3
90 Ms. Pac-man
91 NB live 98
92 NBA give ‘n go
93 NBA JAM
94 NFL quarterback club
95 NHL 96
96 Nigel Mansell’s world championship racing
97 Nolan Ryan’s baseball
98 Outlander
99 Paper boy2
100 Phalanx
101 Pink goes to Hollywood
102 Pitfall the mayan adventure
103 Pit-fighter
104 Plok
105 Power Moves
106 Primal rage (scotch)
107 Prince of Persia
108 Ranma ½ hard battle
109 Real monsters
110 Rise of the robots
111 Robocop vs Terminator
112 Royal Rumble
113 Royal Rumble
114 RPM racing
115 Scooby-doo mystery (b&w)
116 Simcity. Dr. Wright’s Urban planning guide
117 Snes instruction
118 SNES mouse
119 Space invaders
120 Spectre
121 Spider-man X-man arcade’s revenge
122 Stanley Cup
123 Star trek the next generation “Future’s past” (torn)
124 Starfox FX
125 Street fighter 2 turbo
126 Street hockey ‘95
127 Stunt Race
128 Sunsetriders
129 Super adventure island
130 Super adventure island
131 Super base loaded
132 Super Battle tank2
133 Super battletank
134 Super Black Bass
135 Super Caesars palace
136 Super Game boy
137 Super Ghouls’n ghost
138 Super Godzilla (b&w)
139 Super James pond (with sticker)
140 Super Mario all stars
141 Super Mario all stars
142 Super Mario all stars super Mario world
143 Super Mario World
144 Super Mario World
145 Super mario world 2 Yoshi’s island
146 Super NES Super scope
147 Super NES super scope 6
148 Super Ninja boy
149 Super Nova
150 Super play action football
151 Super R-type
152 Super Smash TV
153 Super star wars
154 Super star wars. The empire strikes back
155 Super stars wars. Return of the Jedi
156 Super Street fighter 2
157 Super Turrucan
158 Super Wrestle Mania (b&w)
159 Suzuka 8 hours
160 T2, Judgment day
161 Taz-mania (b&w)
162 Tecmo super NBA basketball
163 Tetris 2
164 Tetris attack
165 The adventures of Dr. Tranken
166 The Flintstones. The treasure of Sierra Madrock (sticker&torn)
167 The itchy&scratchy game
168 The Jetsons. Invasion of the planet pirates
169 The Legend of Zelda
170 The Lion King
171 The Lion king
172 The rocketteer
173 The simpsons Bart nightmare
174 The sporting news baseball
175 The terminator
176 The tick
177 The wizards of oz
178 Tiny Toon adventures. Buster busts loose!
179 Topgear (b&w)
180 Total carnage
181 True Lies
182 Turn and burn no fly zone
183 Ultimate mortal combat 3
184 Uniracers
185 Urban Strike (b&w)
186 Vegas stakes
187 Vortex
188 Warlock
189 Wayne Gretzky and the NHLPA ALL STARS
190 We’re back! A dinosaur’s story
191 Wheel of Fortune deluxe edition (b&w)
192 Wild Snake
193 Williams Greatest Hits
194 Wings2 aces high
195 Winter extreme skiing and snowboarding
196 Winter extreme skiing and snowboarding (with sticker)
197 Wrestle Mania
198 Yoshi’s safari
199 Young Merlin
200 Zombies ate my neighbours
201 Zool
202 Инструкция к приставке и джойстику.
Спасибо за внимание!
";i:8;a:4:{s:3:"tag";s:5:"email";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[email]";i:1;s:8:"[/email]";}s:8:"children";a:1:{i:0;s:17:"
[email protected]";}}}, 1701116101, 1711709132
Run Time: 0.001450