SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000348
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.000237
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT * FROM xf_permission_entry_content AS entry_content
WHERE entry_content.content_type = "xz_category"
AND
(
entry_content.user_group_id IN (1)
)
OR
(
entry_content.user_id = 0 AND entry_content.user_group_id = 0
AND entry_content.content_type = "xz_category"
)
Run Time: 0.000449
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | entry_content | range | user_group_id_unique,content_type_content_id | user_group_id_unique | 35 | | 35 | Using index condition |
SELECT COUNT(article.article_id)
FROM xz_article AS article
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
WHERE ((article.keywords like '%ballistic' OR article.keywords like '%ballistic%' OR article.keywords like '%,ballistic%')) AND (article.is_page_of = 0) AND (article.state = 'published') AND (article.subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (article.category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
Run Time: 0.001679
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ALL | | | | | 274 | Using where |
SELECT article.*
,
user.*, IF(user.username IS NULL, article.username, user.username) AS username
FROM xz_article AS article
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
WHERE ((article.keywords like '%ballistic' OR article.keywords like '%ballistic%' OR article.keywords like '%,ballistic%')) AND (article.is_page_of = 0) AND (article.state = 'published') AND (article.subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (article.category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
ORDER BY article.published_time DESC
LIMIT 25
Run Time: 0.002139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ALL | | | | | 274 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | fishingk_xen.article.user_id | 1 | Using where |
SELECT user.*
FROM xf_user AS user
WHERE user.user_id IN (4442)
ORDER BY user.username
Run Time: 0.000455
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT * FROM xz_article
WHERE
article_id in
(
SELECT * FROM (
SELECT article_id
FROM xz_article
WHERE
(
category_id = 279
OR subcategory_id = 279
)
AND (subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
AND state = "published"
ORDER BY editors_pick DESC, pick_order ASC limit 4
) as t279)
OR
article_id in
(
SELECT * FROM (
SELECT article_id
FROM xz_article
WHERE
(
category_id = 1
OR subcategory_id = 1
)
AND (subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
AND state = "published"
ORDER BY editors_pick DESC, pick_order ASC limit 4
) as t1)
OR
article_id in
(
SELECT * FROM (
SELECT article_id
FROM xz_article
WHERE
(
category_id = 275
OR subcategory_id = 275
)
AND (subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
AND state = "published"
ORDER BY editors_pick DESC, pick_order ASC limit 4
) as t275)
OR
article_id in
(
SELECT * FROM (
SELECT article_id
FROM xz_article
WHERE
(
category_id = 7
OR subcategory_id = 7
)
AND (subcategory_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) OR (category_id IN (280, 277, 43, 281, 278, 279, 272, 274, 91, 94, 276, 273, 46, 45, 1, 84, 44, 275, 7) AND subcategory_id = 0))
AND state = "published"
ORDER BY editors_pick DESC, pick_order ASC limit 4
) as t7)
ORDER BY editors_pick DESC, pick_order ASC
Run Time: 0.005692
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | xz_article | ALL | | | | | 274 | Using where; Using filesort |
MATERIALIZED | <derived9> | ALL | | | | | 4 | |
DERIVED | xz_article | ALL | | | | | 274 | Using where; Using filesort |
MATERIALIZED | <derived7> | ALL | | | | | 4 | |
DERIVED | xz_article | ALL | | | | | 274 | Using where; Using filesort |
MATERIALIZED | <derived5> | ALL | | | | | 4 | |
DERIVED | xz_article | ALL | | | | | 274 | Using where; Using filesort |
MATERIALIZED | <derived3> | ALL | | | | | 4 | |
DERIVED | xz_article | ALL | | | | | 274 | Using where; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 6eb3cdb8f8583555814d5568aa76aa00, , 1715741912
Run Time: 0.000294
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, , , XenZine_ControllerPublic_Article, Index, valid, , 1715738312,
Run Time: 0.000227
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bdmedal_message_medals', 'xengallery_bb_code_tag_gallery', 'xenzine_article_list', '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_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.000913
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 26 | Using index condition |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xz_article_list', 'home', 'iversia_faq', 'xz_articles_nav')
Params: 1
Run Time: 0.000322
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 4 | 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.000303
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.000253
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.000787
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.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 | |
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.000300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |