SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000454
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.000241
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT COUNT(*)
FROM `sonnb_xengallery_stream` AS stream
WHERE (stream.stream_name = 'окунь')
Run Time: 0.000359
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | stream | ref | stream_name | stream_name | 767 | const | 83 | Using where; Using index |
SELECT stream.*
FROM `sonnb_xengallery_stream` AS stream
WHERE (stream.stream_name = 'окунь')
LIMIT 40
Run Time: 0.008944
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | stream | ref | stream_name | stream_name | 767 | const | 83 | Using index condition |
SELECT album.*
,
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 IN (625, 658)) AND (album.album_state IN ('visible','moderated'))
Run Time: 0.011219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition; Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.album.user_id | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.album.category_id | 1 | |
SELECT content.*
,
content_data.*
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)
WHERE (content.content_id IN (11765, 12770))
Run Time: 0.027745
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,content_type_id | PRIMARY | 4 | | 2 | Using index condition |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | fishingk_xen.content.content_data_id | 1 | |
SELECT content.*
,
album.category_id, album.album_state, album.album_type,
album.content_count, album.photo_count, album.video_count, album.audio_count,
album.album_privacy, album.album_location,
album.cover_content_id, album.cover_content_type,
album.latest_content_ids, album.latest_photo_ids, album.latest_video_ids, album.latest_audio_ids,
album.album_date, album.album_updated_date,
album.title AS album_title, album.description AS album_description,
album.user_id AS album_user_id, album.username AS album_username,
album.comment_count AS album_comment_count,
album.view_count AS album_view_count,
album.likes AS album_likes, album.like_users AS album_like_users,
album.latest_comment_ids AS album_latest_comment_ids,
album.collection_id AS album_collection_id,
category.category_privacy
,
0 AS following_0,
IF(user.username IS NULL, content.username, user.username) AS username, user.avatar_date, user.gravatar,
content_data.*,
0 AS following_0
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_album` AS album ON
(album.album_id = content.album_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
LEFT JOIN `xf_user` AS user ON
(user.user_id = content.user_id)
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
WHERE (content.content_id IN (12745, 12746, 12747, 12748, 12749, 12750, 12751, 12752, 12753, 12754, 12755, 12756, 12757, 12758, 12759, 12760, 12761, 12762, 12763, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12772, 12773, 12774, 12775, 12776, 12777, 12778, 12779, 12780, 12781, 12782)) AND (content.content_state IN ('visible','moderated'))
Run Time: 0.003370
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,album_id_position,content_type_id | PRIMARY | 4 | | 38 | Using index condition; Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.content.album_id | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.album.category_id | 1 | |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | fishingk_xen.content.content_data_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.content.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c07f3d1a3090b4941243b3148b2c4538, , 1714596648
Run Time: 0.000375
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_Strea, View, valid, stream_name=%D0%BE%D0%BA%D1%83%D0%BD%D1%8C, 1714593048,
Run Time: 0.000210
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bdmedal_message_medals', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'xengallery_bb_code_tag_gallery', 'sonnb_xengallery_album_list_item', 'sonnb_xengallery_photo_list_item', 'sonnb_xengallery_stream_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_bb_code_tag_tag', '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.017855
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 28 | 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.000576
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.000492
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.000398
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.000367
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.000514
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.000423
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.000375
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |