SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 225
Run Time: 0.000483
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT COUNT(*)
FROM xf_thread AS thread
WHERE ((thread.node_id = 225) AND (thread.prefix_id = 29) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible')))
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 4348 | Using index condition; Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id = 225) AND (thread.prefix_id = 29) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible')))
ORDER BY thread.last_post_date DESC
LIMIT 20
Run Time: 0.011777
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 4348 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.thread.user_id | 1 | |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id = 225) AND (thread.prefix_id = 29) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible')))
ORDER BY thread.last_post_date DESC
Run Time: 0.000871
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_primo1.thread.user_id | 1 | |
SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(225))
ORDER BY field.materialized_order
Run Time: 0.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | ff | eq_ref | PRIMARY,field_id | PRIMARY | 198 | const,thelawc_primo1.field.field_id | 1 | Using index |
SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(225))
ORDER BY field.materialized_order
Run Time: 0.000192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | ff | eq_ref | PRIMARY,field_id | PRIMARY | 198 | const,thelawc_primo1.field.field_id | 1 | Using index |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 225
Run Time: 0.000457
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT prefix.*
FROM xf_thread_prefix AS prefix
WHERE (prefix.prefix_id IN(1, 2, 3, 4, 5, 6, 230, 231, 232, 233, 234, 235, 7, 8, 9, 10, 11, 12, 13, 236, 237, 238, 239, 240, 241, 242, 14, 15, 16, 17, 18, 19, 243, 244, 245, 246, 247, 248, 21, 24, 27, 29, 31, 32, 33, 34, 250, 253, 256, 258, 260, 261, 262, 263))
ORDER BY prefix.materialized_order
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | prefix | range | PRIMARY | PRIMARY | 4 | | 54 | Using where; Using filesort |
SELECT COUNT(thread_id)
FROM xf_thread
WHERE user_id = ?
AND post_date > ?
Params: 0, 1618386479
Run Time: 0.000255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | post_date,user_id | post_date | 4 | | 14 | Using index condition; 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.000739
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 |
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, dzu, dzu, XenForo_ControllerPublic_Forum, Forum, valid, node_id=225, 1618472879,
Run Time: 0.000146
SELECT *
FROM adnavigation
ORDER BY
parent_navigation_id,
display_order
Run Time: 0.000737
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', 'waindigo_thread_list_item_socialgroups', 'forum_view', '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.000702
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 17 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thread_field_Jurisdiction_desc', 'nixfifty_tickets_tab', 'adnavigation_navitem_guide', 'adnavigation_navitem_journal', 'adnavigation_navitem_attorneys')
Params: 1
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 5 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('pfl_prefixes_list')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000090
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 ('waindigo_thread_list_item_customfields')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000080
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 ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000096
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.000061
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.000051
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.000052
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ads | const | PRIMARY | PRIMARY | 4 | const | 1 | |