SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category.*
,
permission.cache_value AS category_permission_cache,
0 AS forum_is_watched
FROM xf_nflj_ams_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = category.category_id)
WHERE category.category_id = ?
Params: 41
Run Time: 0.000496
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT category.*
,
permission.cache_value AS category_permission_cache
FROM xf_nflj_ams_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = category.category_id)
ORDER BY category.lft
Run Time: 0.000574
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 37 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelawc_primo1.category.category_id | 1 | Using where |
SELECT COUNT(*)
FROM xf_nflj_ams_article as article
LEFT JOIN xf_nflj_ams_category AS category ON
(category.category_id = article.category_id)
WHERE (article.category_id IN (42, 44, 67, 45, 54, 58, 59, 60, 61, 63, 64, 62, 65, 66, 68, 69, 70, 71, 43, 74, 75, 76, 56, 55, 57, 48, 72, 47, 41)) AND (article.prefix_id = 354) AND (article.article_state IN ('visible'))
Run Time: 0.000756
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,prefix_id,category_last_update,category_rating_weighted | prefix_id | 4 | const | 52 | Using where |
SELECT article.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username
FROM xf_nflj_ams_article AS article
LEFT JOIN xf_nflj_ams_category AS category ON
(category.category_id = article.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = article.user_id)
WHERE (article.category_id IN (42, 44, 67, 45, 54, 58, 59, 60, 61, 63, 64, 62, 65, 66, 68, 69, 70, 71, 43, 74, 75, 76, 56, 55, 57, 48, 72, 47, 41)) AND (article.featured = 1) AND (article.article_state = 'visible')
ORDER BY rand() DESC, article.last_update DESC
LIMIT 1
Run Time: 0.005462
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ALL | category_id,category_last_update,category_rating_weighted | | | | 483 | Using where; Using temporary; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.user_id | 1 | |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000346
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 7 | Using filesort |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (564)
ORDER BY attachment.content_id, attachment.attach_date
Params: ams_article
Run Time: 0.000135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.attachment.data_id | 1 | |
SELECT article.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username
FROM xf_nflj_ams_article AS article
LEFT JOIN xf_nflj_ams_category AS category ON
(category.category_id = article.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = article.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = article.user_id)
WHERE (article.category_id IN (42, 44, 67, 45, 54, 58, 59, 60, 61, 63, 64, 62, 65, 66, 68, 69, 70, 71, 43, 74, 75, 76, 56, 55, 57, 48, 72, 47, 41)) AND (article.prefix_id = 354) AND (article.article_state IN ('visible'))
ORDER BY article.publish_date DESC
LIMIT 10 OFFSET 50
Run Time: 0.001949
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,prefix_id,category_last_update,category_rating_weighted | prefix_id | 4 | const | 52 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.user_id | 1 | |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000354
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 7 | Using filesort |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000364
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 7 | Using filesort |
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, , , NFLJ_AMS_ControllerPublic_Category, Index, valid, category_id=41, 1576452807,
Run Time: 0.000144
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000395
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 7 | Using filesort |
SELECT *
FROM adnavigation
ORDER BY
parent_navigation_id,
display_order
Run Time: 0.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adnavigation | ALL | | | | | 19 | Using filesort |
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bbm_bbcode_spoiler', 'bbm_viewer_content_protected', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', '__bbm_tool_template', 'nflj_ams_category', 'nflj_ams_tab_links', 'nixfifty_tickets_tab_links', 'resources_tab_links', 'EWRcarta_Navtabs', 'wf_hook_moderator_bar', 'wf_revealer', 'modess_moderator_bar_mod_log_counts', 'ThreadStarter', 'siropu_ads_manager_tab_title', 'siropu_ads_manager_ad_type_code', 'siropu_ads_manager_ad_type_banner', 'siropu_ads_manager_ad_type_text', 'siropu_ads_manager_ad_type_link', 'siropu_ads_manager_ad_type_keyword', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000794
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 26 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('nixfifty_tickets_tab', 'adnavigation_navitem_guide', 'adnavigation_navitem_journal', 'adnavigation_navitem_attorneys')
Params: 1
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 4 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000144
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 states from xf_siropu_ads_manager_ads where ad_id = 3
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ads | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Select states from xf_siropu_ads_manager_ads where ad_id = 4
Run Time: 0.000059
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ads | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Select states from xf_siropu_ads_manager_ads where ad_id = 2
Run Time: 0.000048
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ads | const | PRIMARY | PRIMARY | 4 | const | 1 | |