SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000338
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000219
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 6ace3029b6dc1f468ff0d61860371405, 1716129772
Run Time: 0.000308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
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 album.*
,
0 AS like_date,
0 AS watch_date,
IF(user.username IS NULL, album.username, user.username) AS username, user.avatar_date, user.gravatar,
0 AS following_0,
category.category_privacy
FROM `sonnb_xengallery_album` AS album
LEFT JOIN `xf_user` AS user ON
(user.user_id = album.user_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
WHERE (album.album_id = 610)
LIMIT 1
Run Time: 0.000468
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT COUNT(*)
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
LEFT JOIN `sonnb_xengallery_photo` AS photo ON
(photo.content_id = content.content_id)
LEFT JOIN `sonnb_xengallery_video` AS video ON
(video.content_id = content.content_id)
WHERE (content.album_id = 610) AND (content.content_state IN ('visible','moderated'))
Run Time: 0.000532
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | ref | album_id_position | album_id_position | 4 | const | 59 | Using where |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | fishingk_xen.content.content_data_id | 1 | Using index |
SELECT content.*
,
0 AS like_date,
0 AS watch_date,
content_data.*,
photo.photo_exif,
video.video_key, video.video_type,
0 AS following_0
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
LEFT JOIN `sonnb_xengallery_photo` AS photo ON
(photo.content_id = content.content_id)
LEFT JOIN `sonnb_xengallery_video` AS video ON
(video.content_id = content.content_id)
WHERE (content.album_id = 610) AND (content.content_state IN ('visible','moderated'))
ORDER BY content.position ASC
LIMIT 40
Run Time: 0.000915
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | ref | album_id_position | album_id_position | 4 | const | 59 | Using where |
SIMPLE | photo | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.content.content_id | 1 | |
SIMPLE | video | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.content.content_id | 1 | |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | fishingk_xen.content.content_data_id | 1 | |
SELECT comment.*
,
0 AS like_date,
IF(user.username IS NULL, comment.username, user.username) AS username, user.avatar_date, user.gravatar
FROM `sonnb_xengallery_comment` AS comment
LEFT JOIN `xf_user` AS user ON
(user.user_id = comment.user_id)
WHERE (comment.content_type = 'album') AND (comment.content_id = 610) AND (comment.comment_state IN ('visible'))
ORDER BY comment.comment_date DESC
LIMIT 5
Run Time: 0.000440
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | comment | ref | content_type_id_date,content_type_id,comment_date | content_type_id_date | 5 | const,const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.comment.user_id | 1 | |
INSERT DELAYED INTO sonnb_xengallery_album_view
(album_id)
VALUES
(?)
Params: 610
Run Time: 0.000203
SELECT field.*
FROM `sonnb_xengallery_field` AS field
WHERE 1=1
Run Time: 0.000333
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | system | | | | | 0 | Const row not found |
UPDATE `xf_session` SET `expiry_date` = ?, `session_data` = ? WHERE (session_id = '6ace3029b6dc1f468ff0d61860371405')
Params: 1716133372,
Run Time: 0.000292
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, , , sonnb_XenGallery_ControllerPublic_XenGallery_Album, Index, valid, album_id=610, 1716129772,
Run Time: 0.000246
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_bb_code_tag_hashtag', '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', 'bdmedal_message_medals', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'xengallery_bb_code_tag_gallery', 'sonnb_xengallery_album_view', 'EWRporta_Navtabs', 'iversia_faq_navtabs', 'xenzine_nav', 'sonnb_xengallery_navbar_template', 'xenCODE_Meta_Keywords', 'bdmedal_navigation_tabs_help', 'wf_hook_moderator_bar', 'wf_revealer', 'tinhte_xentag_hook_message_below', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_navigation_tabs_forums', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'rotating_ads_slider', 'sonnb_xengallery_nav_visitor', 'xengallery_media_block_items', 'xengallery_comments_block', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000848
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 36 | Using index condition |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home', 'iversia_faq', 'xz_articles_nav')
Params: 1
Run Time: 0.000333
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 3 | Using index condition |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('sonnbXG_copyright', 'sonnb_xengallery_copyright')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000337
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using index condition |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbms_twitter_css')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000313
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 ('xxbb_css')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000280
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 ('BRME_page_container_head')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000302
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 ('SFP_js_first_post')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000298
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 ('bbms_twitter_XFormer')
AND style_id = ?
AND language_id = ?
Params: 2, 1
Run Time: 0.000315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |