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.000424
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.000080
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.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_tag
WHERE tag_url = ?
Params: trinken
Run Time: 0.000286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
SELECT *
FROM xf_tag_result_cache
WHERE tag_id = ?
AND user_id = ?
AND expiry_date > ?
Params: 445, 0, 1576425298
Run Time: 0.000173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id,expiration_date | tag_id_user_id | 8 | const,const | 1 | |
SELECT tag_content_id, content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 445
Run Time: 0.000263
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 55 | Using where |
SELECT ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id,
user.*, ld.user_id as user_id
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user USING(user_id)
WHERE ld_id IN (2083, 2037, 2035)
Run Time: 0.000908
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
SIMPLE | ldc | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.ld_cat_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT ld_cat.*
FROM phc_linkdirectory_categories as ld_cat
ORDER BY ld_cat.lft
Run Time: 0.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld_cat | ALL | | | | | 68 | Using filesort |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_en_GB')
Params: 4
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_pt_PT')
Params: 4
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_de_DE')
Params: 4
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
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_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_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.thread_id IN (46114, 45758, 45686, 45296, 45096, 44899, 44653, 44471, 43852, 43740, 43735, 43727, 43720, 43255, 43159, 42995, 42833, 42828, 42824, 42627, 42585, 42551, 42509, 42432, 42408, 42387, 42287, 41998, 41128, 40998, 40908, 40577, 39427, 36223, 40367, 35291, 33627, 33497, 31841, 31731, 30847, 29122, 28093, 27660, 27477, 25399, 23319, 18764, 40036, 14927, 40031, 4756, 4074)
Run Time: 0.001841
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 53 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.thread.node_id | 1 | Using where |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000094
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 40, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 16, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 40, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 7, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 7, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 40, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 40, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000066
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000098
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000106
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 7, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 32, 0
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 445, 0, 1576425298, 1576428898, [["ld_links",2083],["thread",46114],["thread",45758],["thread",45686],["thread",45296],["thread",45096],["thread",44899],["thread",44653],["ld_links",2037],["ld_links",2035],["thread",44471],["thread",43852],["thread",43740],["thread",43735],["thread",43727],["thread",43720],["thread",43255],["thread",43159],["thread",42995],["thread",42833],["thread",42828],["thread",42824],["thread",42627],["thread",42585],["thread",42551],["thread",42509],["thread",42432],["thread",42408],["thread",42387],["thread",42287],["thread",41998],["thread",41128],["thread",40998],["thread",40908],["thread",40577],["thread",39427],["thread",36223],["thread",40367],["thread",35291],["thread",33627],["thread",33497],["thread",31841],["thread",31731],["thread",30847],["thread",29122],["thread",28093],["thread",27660],["thread",27477],["thread",25399],["thread",23319],["thread",18764],["thread",40036],["thread",14927],["thread",40031],["thread",4756],["thread",4074]]
Run Time: 0.000270
SELECT synonym.*, tag.tag as tag_name
FROM tagess_synonym AS synonym
LEFT JOIN xf_tag as tag
ON tag.tag_id = synonym.tag_id
WHERE (synonym.tag_id = 445)
Run Time: 0.000206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT synonym.*, tag.tag as tag_name
FROM tagess_synonym AS synonym
LEFT JOIN xf_tag as tag
ON tag.tag_id = synonym.tag_id
WHERE (synonym.parent_tag_id = 445)
Run Time: 0.000168
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | synonym | ref | parent_tag_id | parent_tag_id | 4 | const | 1 | Using index |
SIMPLE | tag | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.synonym.tag_id | 1 | Using where |
SELECT COUNT(*)
FROM tagess_tag_watch
WHERE user_id = ?
AND tag_id = ?
Params: 0, 445
Run Time: 0.000141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d35573bb234a0008f69b13a81cec77f3, , 1576428898
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_Tag, Tag, valid, tag_url=trinken, 1576425298,
Run Time: 0.000109
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 4 | Using filesort |
SELECT options.*, node.*,
permission.cache_value AS node_permission_cache
FROM nat_options AS options
INNER JOIN xf_node AS node
ON (node.node_id = options.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = options.node_id)
WHERE nat_display_tab = 1
ORDER BY options.nat_display_order
ASC
Params: 1
Run Time: 0.000256
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | options | ALL | node_id | | | | 45 | Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.options.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.options.node_id | 1 | Using where |
SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (68, 69, 71, 72, 73)
ORDER BY node.lft
ASC
Params: 1
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.node.node_id | 1 | Using where |
SIMPLE | options | eq_ref | node_id | node_id | 4 | db25061_47.node.node_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'ld_links_search_item', 'search_result_thread', 'quattro_bbcode_xtable', 'bbm_viewer_content_protected', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'sonnb_xengallery_bbcode_photo', 'sonnb_xengallery_bbcode_video', 'sonnb_xengallery_bbcode_album', 'doublepost_bb_code_tag', '__bbm_tool_template', 'tag_view', 'nat_childlinks')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 18 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('atendo2_calendar', 'ld_nav_title')
Params: 4
Run Time: 0.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |
SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (66, 67, 81, 87, 85, 60)
ORDER BY node.lft
ASC
Params: 1
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 6 | Using where; Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.node.node_id | 1 | Using where |
SIMPLE | options | eq_ref | node_id | node_id | 4 | db25061_47.node.node_id | 1 | |
SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (75, 78, 79, 80, 92, 77, 76)
ORDER BY node.lft
ASC
Params: 1
Run Time: 0.000122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 7 | Using where; Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.node.node_id | 1 | Using where |
SIMPLE | options | eq_ref | node_id | node_id | 4 | db25061_47.node.node_id | 1 | |
SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (84, 86)
ORDER BY node.lft
ASC
Params: 1
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 2 | Using where; Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.node.node_id | 1 | Using where |
SIMPLE | options | eq_ref | node_id | node_id | 4 | db25061_47.node.node_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000653
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('notice_cookies', 'EWRporta2_Navtabs', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'dark_taigachat_links', 'EWRatendo2_Navtabs', 'nat_linkstemplate', 'ld_sub_nav', 'sonnb_xengallery_nav_visitor', 'dark_taigachat', 'dark_taigachat_list', 'GritterNotifications', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 14 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000088
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 advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000403
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000363
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000355
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000364
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000357
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1576425298 AND advertisement.end_date > 1576425298))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.000350
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRAFR_navigation_tabs_link')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000075
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 ('nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |