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.004529
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.000634
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.000534
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT EWRmedio_media.*, EWRmedio_categories.*, EWRmedio_services.*, xf_user.*, EWRmedio_media.service_value2 AS service_value2, EWRmedio_watch.media_id AS media_is_watched,
IF(xf_user.username IS NULL, EWRmedio_media.username, xf_user.username) AS username, xf_liked_content.like_date
FROM EWRmedio_media
LEFT JOIN EWRmedio_categories ON (EWRmedio_categories.category_id = EWRmedio_media.category_id)
LEFT JOIN EWRmedio_services ON (EWRmedio_services.service_id = EWRmedio_media.service_id)
LEFT JOIN EWRmedio_watch ON (EWRmedio_media.media_id = EWRmedio_watch.media_id AND EWRmedio_watch.user_id = ?)
LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_media.user_id)
LEFT JOIN xf_liked_content
ON (xf_liked_content.content_type = 'media'
AND xf_liked_content.content_id = EWRmedio_media.media_id
AND xf_liked_content.like_user_id = 0)
WHERE EWRmedio_media.media_id = ?
Params: 0, 203
Run Time: 0.001205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_media | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_services | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_watch | const | PRIMARY,media_id_email_subscribe | PRIMARY | 8 | const,const | 1 | Using index |
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_liked_content | const | content_type_id_like_user_id,like_user_content_type_id | content_type_id_like_user_id | 35 | const,const,const | 1 | Using where |
SELECT COUNT(*) AS total
FROM EWRmedio_comments
WHERE media_id = 203
Run Time: 0.000384
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_comments | ref | media_id | media_id | 4 | const | 1 | Using index |
SELECT *
FROM EWRmedio_categories
WHERE category_id = ?
Params: 3
Run Time: 0.000400
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
UPDATE EWRmedio_media
SET media_views = media_views+1
WHERE media_id = ?
Params: 203
Run Time: 0.002352
SELECT EWRmedio_media.*, EWRmedio_categories.*, EWRmedio_services.*, xf_user.*, EWRmedio_media.service_value2 AS service_value2, EWRmedio_watch.media_id AS media_is_watched,
IF(xf_user.username IS NULL, EWRmedio_media.username, xf_user.username) AS username, xf_liked_content.like_date
FROM EWRmedio_media
LEFT JOIN EWRmedio_categories ON (EWRmedio_categories.category_id = EWRmedio_media.category_id)
LEFT JOIN EWRmedio_services ON (EWRmedio_services.service_id = EWRmedio_media.service_id)
LEFT JOIN EWRmedio_watch ON (EWRmedio_media.media_id = EWRmedio_watch.media_id AND EWRmedio_watch.user_id = ?)
LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_media.user_id)
LEFT JOIN xf_liked_content
ON (xf_liked_content.content_type = 'media'
AND xf_liked_content.content_id = EWRmedio_media.media_id
AND xf_liked_content.like_user_id = 0)
WHERE EWRmedio_media.media_id = ?
Params: 0, 203
Run Time: 0.001100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_media | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_services | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | EWRmedio_watch | const | PRIMARY,media_id_email_subscribe | PRIMARY | 8 | const,const | 1 | Using index |
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_liked_content | const | content_type_id_like_user_id,like_user_content_type_id | content_type_id_like_user_id | 35 | const,const,const | 1 | Using where |
begin
Run Time: 0.000239
commit
Run Time: 0.000438
SELECT EWRmedio_keywords.*, EWRmedio_keylinks.*, xf_user.*
FROM EWRmedio_keywords
LEFT JOIN EWRmedio_keylinks ON (EWRmedio_keylinks.keyword_id = EWRmedio_keywords.keyword_id)
LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_keylinks.user_id)
WHERE EWRmedio_keylinks.media_id = ?
ORDER BY EWRmedio_keywords.keyword_text ASC
Params: 203
Run Time: 0.001124
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_keylinks | ref | UNIQUE,media_id | media_id | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | EWRmedio_keywords | eq_ref | PRIMARY | PRIMARY | 4 | xen.EWRmedio_keylinks.keyword_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | xen.EWRmedio_keylinks.user_id | 1 | |
SELECT EWRmedio_userlinks.*, xf_user.*, tag.username AS tagger
FROM EWRmedio_userlinks
INNER JOIN xf_user ON (xf_user.user_id = EWRmedio_userlinks.username_id)
LEFT JOIN xf_user AS tag ON (tag.user_id = EWRmedio_userlinks.user_id)
WHERE media_id = ?
ORDER BY xf_user.username ASC
Params: 203
Run Time: 0.001029
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_userlinks | ref | UNIQUE,media_id | media_id | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | xen.EWRmedio_userlinks.username_id | 1 | |
SIMPLE | tag | eq_ref | PRIMARY | PRIMARY | 4 | xen.EWRmedio_userlinks.user_id | 1 | |
SELECT *
FROM EWRmedio_playlists
WHERE user_id = ?
ORDER BY playlist_update DESC
Params: 0
Run Time: 0.000417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_playlists | ref | user_id | user_id | 4 | const | 1 | Using index condition; Using filesort |
SELECT EWRmedio_comments.*, xf_user.*, xf_user.register_date AS userValid,
IF(NOT ISNULL(xf_user.user_id), xf_user.username, EWRmedio_comments.username) AS username
FROM EWRmedio_comments
LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_comments.user_id)
WHERE EWRmedio_comments.media_id = ?
ORDER BY EWRmedio_comments.comment_date DESC
LIMIT ?, ?
Params: 203, 0, 5
Run Time: 0.000740
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRmedio_comments | ref | media_id | media_id | 4 | const | 1 | Using index condition; Using filesort |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | xen.EWRmedio_comments.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 4ebdc40534166705995c3fe9b7d68bde, , 1713950574
Run Time: 0.000368
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, , , EWRmedio_ControllerPublic_Media_Media, Media, valid, action_id=203, 1713946974,
Run Time: 0.000228
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.000440
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | kingk_bbcm | system | | | | | 1 | |
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000339
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
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.000855
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | options | ALL | node_id | | | | 24 | Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | xen.options.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xen.options.node_id | 1 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('BRSTS_support_tickets', 'media')
Params: 2
Run Time: 0.000366
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |