SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000200
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
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.001694
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 64 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelawc_xlawforumxf.category.category_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.featured = 1) AND (article.article_state = 'visible')
ORDER BY rand() DESC, article.last_update DESC
LIMIT 6
Run Time: 0.002447
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | ALL | | | | | 580 | Using where; Using temporary; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000515
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.000490
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 (664, 564)
ORDER BY attachment.content_id, attachment.attach_date
Params: ams_article
Run Time: 0.000289
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 2 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.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.article_state = 'visible')
ORDER BY article.publish_date DESC
LIMIT 6
Run Time: 0.002321
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | range | category_id,category_last_update,category_rating_weighted | category_id | 4 | | 431 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000429
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.000441
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.000423
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.000438
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.000422
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.000433
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 (664, 631, 564)
ORDER BY attachment.content_id, attachment.attach_date
Params: ams_article
Run Time: 0.000211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 3 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.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 (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, 3)) AND (article.article_state = 'visible')
ORDER BY article.publish_date DESC
LIMIT 6
Run Time: 0.001700
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | article | range | category_id,category_last_update,category_rating_weighted | category_id | 4 | | 130 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.article.user_id | 1 | |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000503
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.000430
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.000430
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.000414
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.000431
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.000432
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 (490, 489, 488, 484, 483, 482)
ORDER BY attachment.content_id, attachment.attach_date
Params: ams_article
Run Time: 0.000277
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 7 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | thelawc_xlawforumxf.attachment.data_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, , , NFLJ_AMS_ControllerPublic_Article, Modular, valid, , 1524701584,
Run Time: 0.000100
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000587
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.000309
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.000136
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', 'wf_widget_wrapper', 'wf_widget_feed_reader', 'nflj_ams_index_modular_news', '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.000959
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 28 | 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.000183
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.000217
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.000165
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.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 = 2
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 | |