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.007418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT COUNT(*) AS total FROM (
SELECT xf_thread.thread_id
FROM EWRporta2_articles
INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.article_date < ?
AND xf_thread.discussion_state = 'visible'
AND (EWRporta2_articles.article_exclude = '0' OR EWRporta2_articles.article_exclude IS NULL)
GROUP BY xf_thread.thread_id
) q
Params: 1715740804
Run Time: 0.002900
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <derived2> | ALL | | | | | 2 | |
DERIVED | EWRporta2_articles | ALL | PRIMARY,article_date | | | | 85 | Using where; Using temporary; Using filesort |
DERIVED | xf_thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,last_post_date,post_date,user_id | PRIMARY | 4 | base.EWRporta2_articles.thread_id | 1 | Using where |
DERIVED | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | base.xf_thread.user_id | 1 | Using index |
SELECT COUNT(*) AS total FROM (
SELECT xf_thread.thread_id
FROM xf_thread
LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
WHERE xf_thread.post_date < ?
AND xf_thread.discussion_state = 'visible'
AND xf_thread.node_id IN ('2')
AND EWRporta2_articles.article_date IS NULL
AND (EWRporta2_articles.article_exclude = '0' OR EWRporta2_articles.article_exclude IS NULL)
GROUP BY xf_thread.thread_id
) q
Params: 1715740804
Run Time: 0.006240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <derived2> | ALL | | | | | 146 | |
DERIVED | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,last_post_date,post_date,user_id | node_id_last_post_date | 4 | const | 273 | Using where; Using temporary; Using filesort |
DERIVED | EWRporta2_articles | ALL | PRIMARY | | | | 85 | Using where; Not exists; Using join buffer (Block Nested Loop) |
DERIVED | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | base.xf_thread.user_id | 1 | Using index |
(
SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_forum.*, xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count,
IF(NOT ISNULL(xf_user.user_id), xf_user.username, xf_thread.username) AS username,
'0' AS sticky_article, xf_thread.post_date AS order_date
FROM xf_thread
INNER JOIN xf_forum ON (xf_forum.node_id = xf_thread.node_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_articles ON (EWRporta2_articles.thread_id = xf_thread.thread_id)
WHERE xf_thread.post_date < ?
AND xf_thread.discussion_state = 'visible'
AND xf_thread.node_id IN ('2')
AND EWRporta2_articles.article_date IS NULL
AND (EWRporta2_articles.article_exclude = '0' OR EWRporta2_articles.article_exclude IS NULL)
GROUP BY xf_thread.thread_id
ORDER BY xf_thread.post_date DESC
) UNION ALL (
SELECT EWRporta2_articles.*, EWRporta2_authors.*, xf_forum.*, xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count,
IF(NOT ISNULL(xf_user.user_id), xf_user.username, xf_thread.username) AS username,
EWRporta2_articles.article_sticky AS sticky_article, EWRporta2_articles.article_date AS order_date
FROM EWRporta2_articles
INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
INNER JOIN xf_forum ON (xf_forum.node_id = xf_thread.node_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.article_date < ?
AND xf_thread.discussion_state = 'visible'
AND (EWRporta2_articles.article_exclude = '0' OR EWRporta2_articles.article_exclude IS NULL)
GROUP BY xf_thread.thread_id
ORDER BY EWRporta2_articles.article_sticky DESC, EWRporta2_articles.article_date DESC
)
ORDER BY sticky_article DESC, order_date DESC
LIMIT ?, ?
Params: 1715740804, 1715740804, 200, 10
Run Time: 0.032380
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 (16906)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000452
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (16899)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000311
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (16565)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000240
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (16532)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000320
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (15463)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000382
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (15120)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000379
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (15091)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000347
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (15059)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000261
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (15049)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000301
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
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 (14924)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000227
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 | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | base.attachment.data_id | 1 | |
SELECT EWRporta2_catlinks.*, EWRporta2_categories.*, xf_user.*
FROM EWRporta2_catlinks
INNER JOIN EWRporta2_categories ON (EWRporta2_categories.category_id = EWRporta2_catlinks.category_id)
LEFT JOIN xf_user ON (xf_user.user_id = EWRporta2_catlinks.user_id)
WHERE EWRporta2_catlinks.thread_id IN (1124, 1123, 1100, 1097, 1037, 1012, 1006, 1001, 999, 989)
ORDER BY EWRporta2_categories.category_name
Run Time: 0.000818
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta2_categories | ALL | PRIMARY | | | | 4 | Using temporary; Using filesort |
SIMPLE | EWRporta2_catlinks | ALL | thread_id | | | | 32 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | base.EWRporta2_catlinks.user_id | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 2
Run Time: 0.000322
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: 2e86c9bdadfb1f45167bf13adb758c47, , 1715744404
Run Time: 0.000380
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, , , EWRporta2_ControllerPublic_Articles, Index, valid, , 1715740804,
Run Time: 0.000435
SELECT *
FROM EWRporta2_layouts
WHERE (layout_template = ?
)
AND active = 1
ORDER BY layout_priority ASC
Params: EWRporta2_ArticleList
Run Time: 0.000416
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta2_layouts | ref | layout_template | layout_template | 302 | const | 1 | Using index condition; Using where; Using filesort |
SELECT EWRporta2_widlinks.*, EWRporta2_widgets.widget_values, EWRporta2_widopts.widopt_values,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.widopt_id, 0) AS widopt_id,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.locked, EWRporta2_widgets.locked) AS locked,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.display, EWRporta2_widgets.display) AS display,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.groups, EWRporta2_widgets.groups) AS groups,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.ctime, EWRporta2_widgets.ctime) AS ctime,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cdate, EWRporta2_widgets.cdate) AS cdate,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cache, EWRporta2_widgets.cache) AS cache
FROM EWRporta2_widlinks
INNER JOIN EWRporta2_widgets ON (EWRporta2_widgets.widget_id = EWRporta2_widlinks.widget_id)
LEFT JOIN EWRporta2_widopts ON (EWRporta2_widopts.widopt_id = EWRporta2_widlinks.widopt_id)
WHERE layout_id = ?
AND EWRporta2_widgets.active = 1
ORDER by widlink_order
Params: article_list
Run Time: 0.001229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta2_widgets | ALL | PRIMARY | | | | 10 | Using where; Using temporary; Using filesort |
SIMPLE | EWRporta2_widlinks | ref | layout_id,widget_id | widget_id | 302 | base.EWRporta2_widgets.widget_id | 1 | Using where |
SIMPLE | EWRporta2_widopts | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SELECT *
FROM xf_addon
WHERE addon_id = ?
Params: siropu_chat
Run Time: 0.000342
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1715739904)
ORDER BY session_activity.view_date DESC
Run Time: 0.001000
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 4 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | base.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000283
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.*, IF(user.username IS NULL, thread.username, user.username) AS username,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.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 = thread.node_id)
WHERE (thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1715136004) AND (forum.find_new = 1) AND thread.node_id IN ('86', '44', '45', '92', '6', '1', '94', '2', '7', '84', '4', '5', '28', '30', '34', '32', '29', '31', '33', '8', '89', '88', '85', '16', '58', '79', '13', '17', '20', '11', '19', '82', '18', '21', '15', '9', '23', '10', '12', '81', '14', '56', '57', '71', '72', '68', '69', '73', '74', '75', '76', '77', '78', '63', '64', '65', '66', '59', '60', '61', '46', '49', '53', '54', '55', '48', '47', '50', '51', '52', '35', '38', '42', '36', '37', '39', '40')
ORDER BY thread.last_post_date DESC
LIMIT 12
Run Time: 0.002572
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_state_last_post,last_post_date | last_post_date | 4 | | 1 | Using index condition; Using where |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | base.thread.node_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | base.thread.user_id | 1 | |
SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | base.thread.last_post_user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | base.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,base.thread.node_id | 1 | Using where |
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', 'aadvapp_sidebar', 'EWRwidget_SiropuChat', 'EWRwidget_UsersOnline', 'EWRwidget_StatusUpdates', 'EWRwidget_ForumStats', 'EWRwidget_Threads', 'EWRporta2_ArticleList', 'notice_cookies', 'lime_game_navtabs', 'EWRporta2_Navtabs', 'siropu_chat', 'siropu_chat_disabled', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 6, 2
Run Time: 0.001117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 20 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('acp_home')
Params: 2
Run Time: 0.000243
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |