SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000475
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.000312
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000410
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.000402
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | stream | ref | stream_name | stream_name | 767 | const | 33 | Using where; Using index |
SELECT stream.*
FROM `sonnb_xengallery_stream` AS stream
WHERE (stream.stream_name = 'Мормышка')
LIMIT 40
Run Time: 0.011271
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | stream | ref | stream_name | stream_name | 767 | const | 33 | 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 (638, 651, 867)) AND (album.album_state IN ('visible','moderated'))
Run Time: 0.010477
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | range | PRIMARY | PRIMARY | 4 | | 3 | 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 (12322, 12688, 13800))
Run Time: 0.010985
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,content_type_id | PRIMARY | 4 | | 3 | 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 (12535, 10718, 12455, 11411, 10734, 10713, 11340, 10413, 2738, 11069, 10456, 2860, 2941, 110, 3430, 7219, 12531, 12447, 11139, 380, 10414, 57, 1005, 10452, 10758, 646, 3366, 10434, 11042)) AND (content.content_state IN ('visible','moderated'))
Run Time: 0.085465
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,album_id_position,content_type_id | PRIMARY | 4 | | 29 | 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: 0fefd21b304dc14be4f146a366771df8, , 1715142792
Run Time: 0.000263
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%9C%D0%BE%D1%80%D0%BC%D1%8B%D1%88%D0%BA%D0%B0, 1715139192,
Run Time: 0.000241
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.012644
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.000324
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.000359
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.000294
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.000269
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.000275
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.000311
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.000343
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |