SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000347
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000057
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: brmsModernStatisticCache
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: modLogCounts
Run Time: 0.000043
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT user.*, permission_combination.cache_value AS global_permission_cache
FROM xf_moderator AS moderator
INNER JOIN xf_user AS user ON (user.user_id = moderator.user_id)
LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id)
Run Time: 0.000132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | moderator | index | PRIMARY | PRIMARY | 4 | | 8 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.moderator.user_id | 1 | |
SIMPLE | permission_combination | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.user.permission_combination_id | 1 | |
DELETE FROM `xf_data_registry` WHERE (data_key = 'modLogCounts')
Run Time: 0.000142
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000075
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
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 9120
Run Time: 0.000442
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 | |
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: 18
Run Time: 0.000203
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.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
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, session.view_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
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))LEFT OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
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: 9120
Run Time: 0.001844
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 | 4 | Using where; Using filesort |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.thread_id | 1 | |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,prav110_pravorg.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,prav110_pravorg.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | prav110_pravorg.post.user_id,func | 1 | Using where |
SIMPLE | session | ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.post.user_id | 11 | |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 9120
Run Time: 0.000072
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
node.title AS node_title, node.node_name
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
WHERE thread.thread_id IN ('8964', '8712')
Run Time: 0.000373
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.thread.node_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 28
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 66
Run Time: 0.000051
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 89586847d717dff6880f5fe0848e36d1, , 1713915181
Run Time: 0.000161
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=9120, 1713911581,
Run Time: 0.000401
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'BRMS_ModernStatistic', 'BRMS_modern_statistic_header', 'anonymous_posting_checkbox_lite', 'anonymous_posting_reveal', 'doublepost_bb_code_tag', 'modess_thread_log', 'qriu_page_container_js_body', 'similar_threads', 'thread_view', 'xfa_blog_navigation_links', 'waindigo_navigation_visitor_tab_joinusergroup', 'xfa_blog_navigation_tab_link', 'modess_moderator_bar_mod_log_counts', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000354
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 21 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRMS_thread_view_tools_links')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('message_user_online')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('offline')
Params: 1
Run Time: 0.000053
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
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, 175997, a:7:{i:0;s:25:"Приветствую!
";i:1;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:17:"Проблема
";}}i:2;s:618:"
Мой отец не хочет(боится) получать заграничный паспорт с биометрической идентификацией, а так же отказывается путешествовать за границу(печать на лоб поставят, чип вживят, и т.д.). В итоге он отказывается от визитов к своим детям и внукам, которые живут за границей. Причем раньше он еще путешествовал пару раз к нам, а теперь полный отказ.
";i:3;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:12:"Вопрос";}}i:4;s:258:"
Как с этим справиться? Как победить предубеждения? Как убедить его в том, что он может безопасно путешествовать к нам. Что не нагрешит, и т.д.
";i:5;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:33:"Что я уже пробовал";}}i:6;s:1708:"
- Говорил о паломничествах, о том что с семьей христианин должен проводить время, и т.д.
- Ссылаться на священников которые говорят что путешествовать можно и печатей нет. Его ответ: продались они.
- Обсуждал и читал книгу Апокалипсиса(по его совету). Объяснял что и никаких прямых запретов или предзнаменований не видел. И вообще, все что там написано невозможно без огромной фантазии притянуть к тому, что происходит сейчас. Мои отсылки к тому что это
Ничего не помогает. Он все время ссылается на то, что в книге Апокалипсиса описано что это принятие печати и грех. Также ссылается на разные видеоролики и лекции в которых сконцентрирован околонаучный бред.
Сам я, как крещенный агностик, стараюсь всегда быть вне религиозных обсуждений. Однако, всегда показываю что мне не чужда мораль нового завета. Просто, не считаю, что надо исповедовать какую-либо религию, чтобы не убивать и красть, или просто быть человеком а не зверем.
Спасибо.";}, 1697463804, 1713911581
Run Time: 0.001100
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, 175998, a:1:{i:0;s:43:"Анна, вопрос СВЯЩЕННИКУ";}, 1697463804, 1713911581
Run Time: 0.000906
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, 176004, a:1:{i:0;s:33:"Вопрос СВЯЩЕННИКУ";}, 1697463804, 1713911581
Run Time: 0.000891
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, 176022, a:1:{i:0;s:556:"Скажите папе, что печать на лоб - это состояние ума, а печать на правой руке - это состояние воли (желаний, цели в жизни). 666 ( это сто одиннадцать шестерок) - это знак мира сего: чуствственности, плотолюбия, земскости и всего подобного.
В книге Апокалипсис ничего не говорится о биопаспортах, и даже нет намека.";}, 1697463804, 1713911581
Run Time: 0.000851
SELECT * FROM xf_thread
WHERE
node_id = ? AND
last_post_date < ? AND
discussion_state = 'visible' AND
sticky = ?
ORDER BY
last_post_date DESC
Params: 18, 1555869067, 0
Run Time: 0.009788
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,last_post_date | node_id_sticky_state_last_post | 6 | const,const,const | 2221 | Using where |
SELECT * FROM xf_thread
WHERE
node_id = ? AND
last_post_date > ? AND
discussion_state = 'visible' AND
sticky = ?
ORDER BY
last_post_date ASC
Params: 18, 1555869067, 0
Run Time: 0.000521
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | node_id_last_post_date,node_id_sticky_state_last_post,last_post_date | node_id_sticky_state_last_post | 10 | | 38 | Using index condition |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xfa_previous_next_thread_links')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbms_twitter_css')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000086
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('kin_postthread_main')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('social_connect_status_editor')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xxtW_js')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000058
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbms_twitter_XFormer')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000056
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |