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.000752
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.000088
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.000090
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_de_DE')
Params: 4
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_en_GB')
Params: 4
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_fr_FR')
Params: 4
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_nl_NL')
Params: 4
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_pt_PT')
Params: 4
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('language_es_LA')
Params: 4
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT *
FROM phc_linkdirectory_categories
WHERE ld_cat_id = ?
Params: 42
Run Time: 0.000159
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | phc_linkdirectory_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT ld_cat_id
FROM phc_linkdirectory_categories_map
WHERE view_user_groups IN (1)
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | phc_linkdirectory_categories_map | index | | PRIMARY | 8 | | 420 | Using where; Using index |
SELECT ld_cat.*
FROM phc_linkdirectory_categories as ld_cat
ORDER BY ld_cat.lft
Run Time: 0.000184
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 ('ld_links_top_rating', 'ld_links_top_recent_links', 'ld_trending_links', 'ld_random_links', 'ld_links_top_most_liked', 'ld_links_top_visited', 'ld_title', 'all')
Params: 4
Run Time: 0.000090
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 8 | Using where |
SELECT
ld.ld_id
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible') AND ((ld.vip = 1 AND ld.vip_mode IN ('0', '2')))
Run Time: 0.000299
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | Using index |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id,
ld.user_id as user_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible') AND ((ld.vip = 1 AND ld.vip_mode IN ('')))
ORDER BY dateline DESC
Run Time: 0.000856
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id,
ld.user_id as user_id
,
0 AS like_date, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id IN (42)) AND (ld.status = 'visible') AND (ld.vip = 0)
ORDER BY ld.dateline DESC
LIMIT 10
Run Time: 0.000829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT COUNT(*)
FROM phc_linkdirectory as ld
WHERE ( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id IN (42)) AND (ld.status = 'visible') AND (ld.vip = 0)
Run Time: 0.000225
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where |
SELECT ld_cat.*
FROM phc_linkdirectory_categories as ld_cat
ORDER BY ld_cat.lft
Run Time: 0.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld_cat | ALL | | | | | 68 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000124
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000125
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
SELECT field.*
FROM phc_linkdirectory_field AS field
WHERE 1=1
ORDER BY field.display_group, field.display_order
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 1 | Using filesort |
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
ld.ld_id
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible') AND (ld.vip = 1)
Run Time: 0.000465
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | Using index |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible') AND (ld.vip = 1)
ORDER BY dateline DESC
LIMIT 5
Run Time: 0.000867
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible')
ORDER BY ld.rating_sum DESC, ld.dateline
LIMIT 5
Run Time: 0.000820
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible')
ORDER BY ld.dateline DESC
LIMIT 5
Run Time: 0.000920
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, (ld.thread_reply_count / ((1576422940 - ld.last_thread_post_date) / (60*60))) as latestposts, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_thread as thread USING (thread_id) LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible')
ORDER BY latestposts DESC
LIMIT 5
Run Time: 0.000939
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.thread_id | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible')
ORDER BY ld.likes DESC, ld.dateline
LIMIT 5
Run Time: 0.000862
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
SELECT
ld.*,
ldc.title as category_title,
ldc.node_id,
ldc.thread_prefix_id
, user.*
FROM phc_linkdirectory as ld
LEFT JOIN phc_linkdirectory_categories as ldc USING(ld_cat_id)
LEFT JOIN xf_user as user ON (user.user_id = ld.user_id)
WHERE
( IF(ld.ld_cat_id > 0, ld.ld_cat_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 65, 66, 67, 71, 72, 73, 74, 75), NULL)) AND (ld.ld_cat_id = 42) AND (ld.status = 'visible')
ORDER BY ld.clicks DESC, ld.dateline
LIMIT 5
Run Time: 0.000818
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | ld_cat_id,status | ld_cat_id | 4 | const | 25 | Using where; Using filesort |
SIMPLE | ldc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.ld.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 1d28571cefeaffe2a9a3981a88aa50a4, , 1576426540
Run Time: 0.000192
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, , , phc_LinkDirectory_ControllerPublic_Categories, Index, valid, ld_cat_id=42, 1576422940,
Run Time: 0.000120
SELECT COUNT(ld_id)
FROM phc_linkdirectory as ld
WHERE (ld.status != 'visible' OR lastcheck = 0)
AND user_id = 0
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | user_id,status | user_id | 4 | const | 1 | Using where |
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.000309
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.000156
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_index', 'nat_childlinks')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('ld_language', 'atendo2_calendar', 'ld_nav_title')
Params: 4
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 3 | 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.000183
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.000173
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.000165
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000504
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.000210
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.000092
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000450
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000396
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000379
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000370
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000366
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 < 1576422940 AND advertisement.end_date > 1576422940))) 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.000385
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.000082
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.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |