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.001080
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.000113
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: dark_postrating_ratings
Run Time: 0.000114
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | 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,
privacy.snog_flag_view
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_user_privacy AS privacy ON
(privacy.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 551
Run Time: 0.000922
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 | privacy | 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: 51
Run Time: 0.000399
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
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,14,2,3,4,5)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (7,8,9,10,11,12)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (13)) as neutral_rating_count
,
pr_cache.rating_cache,
pr2.rating
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))
left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 25)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 551
Run Time: 0.002373
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 13 | Using where; Using filesort |
PRIMARY | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,sculptan_base.post.post_id | 1 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.post.user_id | 1 | |
PRIMARY | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.post.user_id | 1 | |
PRIMARY | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.post.user_id | 1 | |
PRIMARY | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,sculptan_base.post.user_id | 1 | Using where |
PRIMARY | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | sculptan_base.post.user_id,func | 1 | Using where |
PRIMARY | pr_cache | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.post.post_id | 1 | |
PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | sculptan_base.post.post_id,const | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | eq_ref | user_id_rating | user_id_rating | 8 | sculptan_base.post.user_id,const | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | sculptan_base.post.user_id | 1 | Using index condition |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (8865)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 5 | Using index condition; Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.attachment.data_id | 1 | |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 551
Run Time: 0.000151
SELECT
post.*
,
pr_cache.rating_cache,
pr2.rating
FROM xf_post AS post
left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
WHERE post.post_id IN (8865)
Run Time: 0.000838
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | pr_cache | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | pr2 | const | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | const,const | 0 | unique row not found |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (8865)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000457
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 5 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.attachment.data_id | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 16c1a95691cbc082dd8805ea9355083b, , 1714299517
Run Time: 0.000318
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=551, 1714295917,
Run Time: 0.000470
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', 'xengallery_bb_code_tag_gallery', 'thread_view', 'notice_cookies', 'oxy_news_nav_tab', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000700
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 27 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('MMOCS_my_buys')
Params: 2
Run Time: 0.000079
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, 8865, a:14:{i:0;s:726:"Друзья, коллеги!
Команда форума с радостью сообщает, что нами реализована возможность награждения пользователей - участников конкурсов и приравненных к ним мероприятий Памятными Знаками, сиречь - Орденами и Медалями, короче - Наградами сообщества S&P.
Хочу немного рассказать что, где и как.
Информация о Наградах сообщества S&P может быть найдена на странице форума "Помощь". Вот под этими ссылками:
";i:1;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"9839";}}i:1;s:1:"
";}}i:2;s:236:"
Щёлкнув по одной из ссылок вы увидите полный перечень доступных на текущий момент Наград сообщества S&P с описанием их статутов:
";i:3;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"9840";}}i:1;s:1:"
";}}i:4;s:291:"
Награды пользователя отображаются под его аватаром в сообщениях пользователя и под статистикой пользователя рядом его аватаром на главной странице форума:
";i:5;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"9841";}}i:1;s:1:"
";}}i:6;s:608:"
При наведении указателя мыши на изображение одной из наград во всплывающем окне вы увидите наименование награды и дату её вручения. Щелчок левой кнопки мыши по одной из наград вызовет всплывающее окно со всеми наградами пользователя.
Также информация о наградах пользователя доступна в специальной вкладке профиля пользователя:
";i:7;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:3:{i:0;s:1:"
";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"9842";}}i:2;s:1:"
";}}i:8;s:226:"
1. Специальная вкладка "Награждён Медалями".
2. Изображение награды и её описание.
3. Основание для награждения пользователя. ";i:9;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;s:385:"Обращаю ваше внимание на то, что оно может быть различным у разных пользователей. Это своего рода Наградной Лист, точнее - описание Подвига, за который пользователь получил знак отличия или награду сообщества S&P";}}i:10;s:356:".
4. Кнопка "Просмотреть все Награды" вызывает страницу с описанием Наград сообщества S&P и их статутов.
Надеюсь, что это нововведение добавить мотивации к участию в Конкурсах и Дуэлях.:);)
P.S. Кстати, ";i:11;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:2:"21";s:8:"original";a:2:{i:0;s:9:"[USER=21]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:9:"@serg1971";}}i:12;s:201:", Серёж! Поздравляю! На текущий момент - ты лидер-орденоносец!!! Поэтому и занесён в гайд по Наградам навечно.:D;)
";i:13;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:4:"9843";}}}}}, 1632305603, 1714295917
Run Time: 0.005176
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, 3, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:36:"https://www.puttyandpaint.com/Sychev";s:8:"original";a:2:{i:0;s:44:"[URL='https://www.puttyandpaint.com/Sychev']";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:28:"http://pnp.li/badge/2449.png";}}}}}, 1632305603, 1714295917
Run Time: 0.002947
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, 8877, a:1:{i:0;s:78:"Или грудь в крестах или голова в кустах =)))))";}, 1632305603, 1714295917
Run Time: 0.002924
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, 96, a:1:{i:0;s:80:"В работе: --------------------------------------------------------------.";}, 1632305603, 1714295917
Run Time: 0.002570
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, 8888, a:1:{i:0;s:123:"Еще бы организаторам конкурсов давать медальку, было бы здорово:good:";}, 1632305603, 1714295917
Run Time: 0.003636
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, 89, a:3:{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:28:"http://pnp.li/badge/1761.png";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:42:"https://www.puttyandpaint.com/Vasily_Orlov";s:8:"original";a:2:{i:0;s:50:"[url="https://www.puttyandpaint.com/Vasily_Orlov"]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:17:"Me on Putty&Paint";}}}, 1632305603, 1714295917
Run Time: 0.002761
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, 8889, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:49:"Василий Орлов, post: 8888, member: 89";s:8:"original";a:2:{i:0;s:59:"[QUOTE="Василий Орлов, post: 8888, member: 89"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:123:"Еще бы организаторам конкурсов давать медальку, было бы здорово:good:";}}i:1;s:132:"
За это Награды не полагаются. Это - наша работа на Ваше, надеюсь, благо.:);)";}, 1632305603, 1714295917
Run Time: 0.002751
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, 8892, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:50:"Владимир Сычёв, post: 8889, member: 3";s:8:"original";a:2:{i:0;s:60:"[QUOTE="Владимир Сычёв, post: 8889, member: 3"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:131:"За это Награды не полагаются. Это - наша работа на Ваше, надеюсь, благо.:);)";}}i:1;s:48:"
Тут я полностью согласен:)";}, 1632305603, 1714295917
Run Time: 0.002711
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, 8895, a:1:{i:0;s:83:"С каким из утверждений Вы согласны больше?:D:D;)";}, 1632305603, 1714295917
Run Time: 0.002826
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, 8896, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:50:"Владимир Сычёв, post: 8895, member: 3";s:8:"original";a:2:{i:0;s:60:"[QUOTE="Владимир Сычёв, post: 8895, member: 3"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:83:"С каким из утверждений Вы согласны больше?:D:D;)";}}i:1;s:19:"
Со всеми :)";}, 1632305603, 1714295917
Run Time: 0.002586
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, 8897, a:3:{i:0;s:34:"В таком случее это
";i:1;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:49:"Василий Орлов, post: 8888, member: 89";s:8:"original";a:2:{i:0;s:59:"[QUOTE="Василий Орлов, post: 8888, member: 89"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:123:"Еще бы организаторам конкурсов давать медальку, было бы здорово:good:";}}i:2;s:53:"
можно было не предлагать.:D:D;)";}, 1632305603, 1714295917
Run Time: 0.002790
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, 8937, a:1:{i:0;s:203:"Ух ты ! Это только админы видят флаг страны в профиле пользователя ? Можно его как-нибудь добавить в настройках ?";}, 1632305603, 1714295917
Run Time: 0.002840
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, 11, 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:32:"http://s2.uploads.ru/t/bwlzp.png";}}}, 1632305603, 1714295917
Run Time: 0.003194
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, 8951, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:31:"Krest63, post: 8937, member: 11";s:8:"original";a:2:{i:0;s:41:"[QUOTE="Krest63, post: 8937, member: 11"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:110:"Это только админы видят флаг страны в профиле пользователя ?";}}i:1;s:126:"
Да, Андрей. Только админы. Но мы и над этим поработаем. Но не сейчас.:);)";}, 1632305603, 1714295917
Run Time: 0.003070
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, 15231, a:1:{i:0;s:82:"А за что выдаётся префикс или шеврон "Мастер"?";}, 1632305603, 1714295917
Run Time: 0.002847
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, 17, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:102:"http://[url="http://www.puttyandpaint.com/AndreyPetrenko"][img]http://pnp.li/badge/854.png[/img][/url]";s:8:"original";a:2:{i:0;s:110:"[URL='http://[url="http://www.puttyandpaint.com/AndreyPetrenko"][img]http://pnp.li/badge/854.png[/img][/url]']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://www.puttyandpaint.com/AndreyPetrenko";s:8:"original";a:2:{i:0;s:51:"[url="http://www.puttyandpaint.com/AndreyPetrenko"]";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:27:"http://pnp.li/badge/854.png";}}}}}}}, 1632305603, 1714295917
Run Time: 0.003189
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, 15232, a:2:{i:0;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:2:"17";s:8:"original";a:2:{i:0;s:9:"[USER=17]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:29:"Андрей Петренко";}}i:1;s:116:", Андрей, за соответствующую награду. 35 симпатий (лайков) работе.";}, 1632305603, 1714295917
Run Time: 0.003001
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, 15233, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:51:"Владимир Сычёв, post: 15232, member: 3";s:8:"original";a:2:{i:0;s:61:"[QUOTE="Владимир Сычёв, post: 15232, member: 3"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:2:{i:0;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:2:"17";s:8:"original";a:2:{i:0;s:9:"[USER=17]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:29:"Андрей Петренко";}}i:1;s:116:", Андрей, за соответствующую награду. 35 симпатий (лайков) работе.";}}i:1;s:46:"
Все, разобрался, спасибо.";}, 1632305603, 1714295917
Run Time: 0.002902
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('notices')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000146
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 ('wf_widget_wrapper')
AND style_id = ?
AND language_id = ?
Params: 14, 2
Run Time: 0.000109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |