SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000169
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_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000932
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 185 | Using where; Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000370
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 362 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (12, 91, 44, 42, 156, 97, 89, 100, 93, 41, 139, 242, 144, 146, 164, 143, 167, 161, 26, 22, 81, 25, 280, 94, 95, 108, 113, 107, 50, 52, 136, 171, 135, 173, 51, 53, 255, 170, 172, 54, 231, 64, 230, 229, 196, 90, 36, 197, 198, 199, 200, 130, 35, 193, 194, 37, 195, 189, 188, 129, 38, 60, 236, 237, 235, 28, 238, 176, 177, 182, 87, 183, 131, 82, 240, 43, 241, 47, 48, 16, 72, 69, 169, 15, 70, 19, 56, 205, 140, 202, 207, 206, 208, 209, 215, 210, 212, 213, 57, 216, 217, 218, 219, 220, 223, 224, 225, 84, 61, 74, 85)
Run Time: 0.001427
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 121 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.forum.node_id | 1 | Using index |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1618440031)
ORDER BY session_activity.view_date DESC
Run Time: 0.000914
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 29 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.session_activity.user_id | 1 | |
SELECT xf_user.user_id,
xf_user.username,
xf_user.avatar_date,
COUNT(xf_post.likes) AS mostLikes
FROM xf_post
LEFT JOIN xf_user ON xf_user.user_id = xf_post.user_id
LEFT JOIN xf_liked_content ON xf_liked_content.content_id = xf_post.post_id
WHERE xf_post.likes > ?
AND xf_liked_content.like_date >= ?
AND xf_user.username IS NOT NULL
GROUP BY xf_post.user_id
ORDER BY mostLikes DESC, xf_user.username ASC
LIMIT ?
Params: 0, 1615848931, 12
Run Time: 0.002751
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liked_content | range | like_date | like_date | 4 | | 491 | Using index condition; Using temporary; Using filesort |
SIMPLE | xf_post | eq_ref | PRIMARY,user_id | PRIMARY | 4 | thelawc_primo1.xf_liked_content.content_id | 1 | Using where |
SIMPLE | xf_user | eq_ref | PRIMARY,username | PRIMARY | 4 | thelawc_primo1.xf_post.user_id | 1 | Using where |
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.000819
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 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 ('3')) AND (article.featured = 1) AND (article.article_state = 'visible')
ORDER BY rand() DESC, article.last_update DESC
LIMIT 3
Run Time: 0.002240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,category_last_update,category_rating_weighted | category_id | 4 | const | 5 | 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 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 ('3')) AND (category.rate_review_system <> 0) AND (article.article_state = 'visible')
ORDER BY article.rating_avg DESC, article.rating_count DESC, article.likes DESC, article.article_view_count DESC
LIMIT 3
Run Time: 0.001023
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ref | category_id,category_last_update,category_rating_weighted | category_id | 4 | const | 5 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.article.category_id | 1 | Using where |
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 | |
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, , , XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1618440931,
Run Time: 0.000147
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000452
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.000170
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', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'node_link_level_n', 'node_link_level_2', 'node_category_level_2', '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', 'forum_list', '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.002738
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 31 | 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.000091
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.000118
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.000072
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.000073
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 | |