SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
0 AS author_is_watched
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
WHERE user.user_id = ?
Params: 114205
Run Time: 0.000961
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | 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.000961
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.user_id = 114205) AND (article.category_id IN (41, 42, 43, 74, 75, 44, 67, 45, 76, 54, 56, 55, 57, 58, 59, 48, 60, 72, 47, 61, 63, 64, 62, 65, 66, 68, 69, 70, 71, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 31, 22, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 77, 34, 35, 36, 37, 40, 39)) AND (article.article_state IN ('visible'))
Run Time: 0.001326
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,user_id,category_last_update,user_id_last_update,category_rating_weighted | user_id | 4 | const | 4 | Using where |
SELECT article.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, article.username, user.username) AS username,
permission.cache_value AS category_permission_cache
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)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'ams_category'
AND permission.content_id = article.category_id)
WHERE (article.user_id = 114205) AND (article.category_id IN (41, 42, 43, 74, 75, 44, 67, 45, 76, 54, 56, 55, 57, 58, 59, 48, 60, 72, 47, 61, 63, 64, 62, 65, 66, 68, 69, 70, 71, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 31, 22, 23, 24, 25, 26, 27, 28, 29, 30, 32, 33, 77, 34, 35, 36, 37, 40, 39)) AND (article.article_state IN ('visible'))
ORDER BY article.publish_date DESC
LIMIT 15
Run Time: 0.003166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,user_id,category_last_update,user_id_last_update,category_rating_weighted | user_id | 4 | const | 4 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.category_id | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelawc_primo1.article.category_id | 1 | Using where |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000592
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.000450
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, d*u, d*u, NFLJ_AMS_ControllerPublic_Author, Author, valid, user_id=114205, 1618887694,
Run Time: 0.000149
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000631
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.000212
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | adnavigation | ALL | | | | | 19 | Using filesort |
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_author', 'nflj_ams_tab_links', 'nixfifty_tickets_tab_links', 'resources_tab_links', '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.002140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 25 | 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.000131
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.000148
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.000097
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.000067
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.000063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ads | const | PRIMARY | PRIMARY | 4 | const | 1 | |