SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000171
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: 15486
Run Time: 0.000622
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: 10
Run Time: 0.000331
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: 15486
Run Time: 0.002150
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 | 3 | 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: 15486
Run Time: 0.008796
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=15486, 1713475274,
Run Time: 0.000564
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, 347956, a:1:{i:0;s:428:"Народ кто проходил игру дайте совет.Застрял на уровне "Entering the base".Там где с базы на базу протянут широкий канат.Т.е поднимаюсь по ящикам на верх.Надо мной канат.А как залездь или зацепиться за него чтобы попасть на соседнюю базу не знаю.";}, 1701116101, 1713475274
Run Time: 0.001270
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, 348025, a:1:{i:0;s:4724:"ENTERING THE BASE
-----------------
Grab the Medikit and Poison Arrows on the right, then move behind the
tower with the searchlight and face the main path. Poison Arrow the
patrolling guard and, using the tanks for cover, move along the right
side wall and stop at the corner. Turn right and poison the walking
guard. If you set the alarm off, run to the end of this area to where
all the boxes are and wait it out. Then/Otherwise move up to the opening
in the wall, there's two guards inside this square "room." A well placed
Explosive Arrow will get both of them, and set off the alarm(it would go
off anyway, so no big deal) Stay inside the small room and Explosive
Arrow any enemies that come at you until the alarm stops. Then make
your way back to the tanks. There's nothing but enemies in the big
building to the left, so skip it. The smaller building in the middle
has a Spider Mine which will be useful coming up(but there's another
one up ahead as well, which is easier to grab usually). The gate you
need to get through is on the right at the end of the wall. Quickly
run to the gate between the patrolling Slegs and E.Arrow any one who
comes at you. If the alarm goes off, wait by the gate until it stops,
then hit the switch and go in.
Wait for the first gate to close and the second will open, then move
quickly to the small nook on the right with the two boxes. Break them
for some health/ammo then Poison Arrow snipe the two patrolling guards
near the watch towers. Move along the right wall, turn right, and go
to the door on the right by the barricade. If you need a Spider Mine,
and you should get one for the next part, go to the water beyone the
watch towers, jump in and go under on the right side. There's a small
hole that leades to the inside of the building by the right watch tower,
on a table in there is a Spider Mine. Go through the doors and back to
the door on the right side of the barricade.
Go through the door, into the room with a crate and some chairs,
get the health/ammo inside the crate then move to the other door in the
room and go through. You'll be in the room with the hostages in cages
along the left wall. Go to the opposite end of the room and hit the
switch by the opening to free them. Go outside the opening for some
Poison Arrows on the left, and a Medikit on the right. Go back in to the
hostage room, and the door you came in on is the one on the left, and
the one you want to go through now is on the right.
Exit the door and run across to the bushes near the opposite wall's
corner. Move quickly to the next set of bushes and turn back towards the
way you came. Poison Arrow the walking guard by the wall, then turn and
face the lightpost in front of you. Poison the walking Sleg there as well.
Now, look over at the far wall, across the base, there's another Sleg
walking there so zoom in and poison it. Run across the field towards the
door with torches on either side. Enter the doorway and you'll see a
doorway into a room full of sleeping Slegs. Go past it and follow the
U turn of the building to the area with some boxes. Use a Spider Mine
from here to go into the room and use the speaker(1st mode) to wake
them up, then use the gas(second one down) or Explosion(3rd one down)
to kill most of them, then run in and kill the rest with the shotgun or
Flechettes. Get your Explosive Arrows ready and move through the door
on the left. There's a Huge Sleg in there, so strafe left into the room
and fire an E. Arrow as soon as you see him. Keep using them until he
doesn't try to get back up. WHen he's dead, break the crate in the other
corner to get the Minigun Barrels for the Flechette gun. Grab the Minigun
ammo the Huge Sleg dropped and go out the door(the one you didn't come
in from). Usually there's a guy standing right by the door, so he sounds
the alarm. Blast him(save the Minigun for now) and run to the right,
keeping the big barricade wall to your left, go across the path to the
next building on your right. Go in the door on the right and use the
Shotgun to take out the three Slegs on the ground floor inside. Switch
to the Minigun and move to the stairs, go up and blast the Huge Sleg
with the Minigun to take him down quickly. Move up the stairs and go
right, then right again and get the Large Medikit in the crate.
Climb up the ladder to the tower and jump up on the crates to reach the
rope. Use the rope to move across the whole area, to another tower
behind the big barricade. Jump down from the tower and avoid the lone
Sleg walking in front of the ramp. Jump up from the side of the ramp
and go right, into the entrance, to end this chapter.";}, 1701116101, 1713475274
Run Time: 0.001459
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, 37, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:47:"http://gamercards.exophase.com/psn/user/Zxtole/";s:8:"original";a:2:{i:0;s:53:"[url=http://gamercards.exophase.com/psn/user/Zxtole/]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;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:41:"http://gamercards.exophase.com/548213.png";}}}}}, 1701116101, 1713475274
Run Time: 0.000675
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, 348036, a:1:{i:0;s:401:"Спасибо конечно.Я уже читал подобное.Тут конкретно не описано что нажимать.Просто переместитесь по веревке.А этого иногда бывает мало.Вообщем как оказалось необходимо точно встать под канатом и нажать одновременно R3,L3";}, 1701116101, 1713475274
Run Time: 0.016938