SELECT * FROM xf_brivium_addon ORDER BY addon_id
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)
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
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" )
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.category_id = 7 OR article.subcategory_id = 7) 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))
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.category_id = 7 OR article.subcategory_id = 7) 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
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 (3, 4442, 28, 67, 1, 1107, 1147) ORDER BY user.username
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | 7 | Using index condition; Using filesort |
SELECT picks.* FROM xz_article AS picks WHERE state = ? AND editors_pick = 1 AND (subcategory_id = 7 OR category_id = 7 AND subcategory_id = "0") ORDER BY picks.pick_order LIMIT 0, 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | picks | ALL | 274 | Using where; Using filesort |
SELECT * FROM xz_article WHERE article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 281 OR subcategory_id = 281 ) 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 t281) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 278 OR subcategory_id = 278 ) 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 t278) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 272 OR subcategory_id = 272 ) 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 t272) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 274 OR subcategory_id = 274 ) 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 t274) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 91 OR subcategory_id = 91 ) 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 t91) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 94 OR subcategory_id = 94 ) 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 t94) OR article_id in ( SELECT * FROM ( SELECT article_id FROM xz_article WHERE ( category_id = 273 OR subcategory_id = 273 ) 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 t273) ORDER BY editors_pick DESC, pick_order ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
PRIMARY | xz_article | ALL | 274 | Using where; Using filesort | ||||
MATERIALIZED | <derived15> | ALL | 4 | |||||
DERIVED | xz_article | ALL | 274 | Using where; Using filesort | ||||
MATERIALIZED | <derived13> | ALL | 4 | |||||
DERIVED | xz_article | ALL | 274 | Using where; Using filesort | ||||
MATERIALIZED | <derived11> | ALL | 4 | |||||
DERIVED | 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 (?, ?, ?)
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)
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 = ?
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 ('home', 'iversia_faq', 'xz_articles_nav')
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 ('bbms_twitter_css') AND style_id = ? AND language_id = ?
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 = ?
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 = ?
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 = ?
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 = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 |