SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000365
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.000487
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000621
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT hotspot.*
,
hotspot_category.icon_url, hotspot_category.shadow_url
FROM xf_hotspot AS hotspot
LEFT JOIN xf_hotspot_category AS hotspot_category ON
(hotspot_category.hotspot_category_id = hotspot.hotspot_category_id)
WHERE (hotspot.hotspot_id = 203)
Run Time: 0.000617
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | hotspot | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | hotspot_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT hotspot_category.*
FROM xf_hotspot_category AS hotspot_category
WHERE 1=1
Run Time: 0.000394
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | hotspot_category | ALL | | | | | 71 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 85b5d3a66f3fb590591d803ca7530260, , 1714827277
Run Time: 0.000299
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, , , Waindigo_Hotspots_ControllerPublic_Hotspot, View, valid, hotspot_id=203, 1714823677,
Run Time: 0.000286
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', 'xengallery_bb_code_tag_gallery', 'waindigo_hotspot_view_hotspots', 'EWRporta_Navtabs', 'iversia_faq_navtabs', 'xenzine_nav', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', '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.001562
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 ('hotspot_category_22_title', 'hotspot_category_74_title', 'hotspot_category_75_title', 'hotspot_category_76_title', 'hotspot_category_77_title', 'hotspot_category_78_title', 'hotspot_category_79_title', 'hotspot_category_80_title', 'hotspot_category_81_title', 'hotspot_category_82_title', 'hotspot_category_83_title', 'hotspot_category_84_title', 'hotspot_category_85_title', 'hotspot_category_86_title', 'hotspot_category_87_title', 'hotspot_category_88_title', 'hotspot_category_89_title', 'hotspot_category_90_title', 'hotspot_category_91_title', 'hotspot_category_92_title', 'hotspot_category_93_title', 'hotspot_category_94_title', 'hotspot_category_95_title', 'hotspot_category_96_title', 'hotspot_category_97_title', 'hotspot_category_98_title', 'hotspot_category_99_title', 'hotspot_category_100_title', 'hotspot_category_101_title', 'hotspot_category_102_title', 'hotspot_category_103_title', 'hotspot_category_104_title', 'hotspot_category_105_title', 'hotspot_category_106_title', 'hotspot_category_107_title', 'hotspot_category_108_title', 'hotspot_category_109_title', 'hotspot_category_110_title', 'hotspot_category_111_title', 'hotspot_category_112_title', 'hotspot_category_113_title', 'hotspot_category_114_title', 'hotspot_category_115_title', 'hotspot_category_116_title', 'hotspot_category_117_title', 'hotspot_category_118_title', 'hotspot_category_119_title', 'hotspot_category_120_title', 'hotspot_category_121_title', 'hotspot_category_122_title', 'hotspot_category_123_title', 'hotspot_category_124_title', 'hotspot_category_125_title', 'hotspot_category_126_title', 'hotspot_category_127_title', 'hotspot_category_128_title', 'hotspot_category_129_title', 'hotspot_category_130_title', 'hotspot_category_131_title', 'hotspot_category_132_title', 'hotspot_category_133_title', 'hotspot_category_134_title', 'hotspot_category_135_title', 'hotspot_category_136_title', 'hotspot_category_137_title', 'hotspot_category_138_title', 'hotspot_category_139_title', 'hotspot_category_140_title', 'hotspot_category_141_title', 'hotspot_category_142_title', 'hotspot_category_143_title', 'home', 'iversia_faq', 'xz_articles_nav')
Params: 1
Run Time: 0.020392
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 74 | 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.000366
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.000584
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.000516
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.000609
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.000538
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |