SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000106
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT tag.*
FROM xf_nflj_showcase_tag AS tag
WHERE (tag.tag_text = 'avid')
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 1 | Using index condition |
SELECT category.*
,
permission.cache_value AS category_permission_cache
FROM xf_nflj_showcase_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'showcase_category'
AND permission.content_id = category.category_id)
ORDER BY category.lft
Run Time: 0.000293
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 85 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foromtb_www.category.category_id | 1 | Using where |
SELECT COUNT(*)
FROM xf_nflj_showcase_item as item
LEFT JOIN xf_nflj_showcase_category AS category ON
(category.category_id = item.category_id)
WHERE (item.category_id IN (45, 47, 46, 5, 48, 49, 4, 50, 51, 53, 54, 55, 56, 57, 58, 59, 6, 52, 60, 11, 16, 18, 19, 61, 62, 17, 63, 15, 64, 65, 14, 12, 22, 66, 13, 24, 67, 23, 68, 25, 69, 70, 71, 72, 73, 21, 74, 75, 76, 39, 9, 109, 77, 78, 107, 79, 80, 43, 82, 83, 84, 85, 86, 87, 108, 88, 110, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106)) AND (item.item_id IN (86)) AND (item.item_state IN ('visible'))
Run Time: 0.000372
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | item | const | PRIMARY,categoryID,category_last_update,category_rating_weighted | PRIMARY | 4 | const | 1 | |
SELECT item.*
,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, item.username, user.username) AS username
FROM xf_nflj_showcase_item AS item
LEFT JOIN xf_nflj_showcase_category AS category ON
(category.category_id = item.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = item.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = item.user_id)
WHERE (item.category_id IN (45, 47, 46, 5, 48, 49, 4, 50, 51, 53, 54, 55, 56, 57, 58, 59, 6, 52, 60, 11, 16, 18, 19, 61, 62, 17, 63, 15, 64, 65, 14, 12, 22, 66, 13, 24, 67, 23, 68, 25, 69, 70, 71, 72, 73, 21, 74, 75, 76, 39, 9, 109, 77, 78, 107, 79, 80, 43, 82, 83, 84, 85, 86, 87, 108, 88, 110, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106)) AND (item.item_id IN (86)) AND (item.item_state IN ('visible'))
ORDER BY item.date_added DESC
LIMIT 20
Run Time: 0.000836
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | item | const | PRIMARY,categoryID,category_last_update,category_rating_weighted | PRIMARY | 4 | const | 1 | |
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 (86)
ORDER BY attachment.content_id, attachment.attach_date
Params: showcase_item
Run Time: 0.000375
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 | foromtb_www.attachment.data_id | 1 | |
SELECT SUM(item.attach_count) images,
SUM(item.view_count) views,
SUM(item.comment_count) comments,
SUM(item.review_count) reviews,
COUNT(*) AS items
FROM xf_nflj_showcase_item AS item
WHERE (item.item_state = 'visible')
ORDER BY views DESC
Run Time: 0.000049
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | item | ALL | | | | | 376 | Using where; Using temporary |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d9aadc7bbaabc72fae51a8652f37cadb, a:8:{s:12:"sessionStart";i:1714963984;s:2:"ip";s:4:"ڨ";s:11:"sessionCsrf";s:16:"zhTBBd8502UUiGFj";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1674410163;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1674410030;}}, 1714967584
Run Time: 0.000136
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_Showcase_ControllerPublic_Tag, View, valid, tag_text=avid, 1714963984,
Run Time: 0.000070
SELECT activity.*, user.username
FROM xc_trade_activity AS activity
LEFT JOIN xf_user AS user ON user.user_id=activity.user_id
WHERE activity.user_id=?
ORDER BY activity.dateline DESC
LIMIT 0, ?
Params: 0, 10
Run Time: 0.000060
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | activity | ref | user_id_dateline | user_id_dateline | 4 | const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.activity.user_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'nflj_showcase_tag_view', 'nflj_showcase_tab_links', 'xcxt_navtabs', 'waindigo_you_are_using_as_user_loginasuser', 'waindigo_moderator_bar_loginasuser', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'xcfw_copyright', 'xcxt_headinclude', 'xcxt_trading_preferences_link_list', 'xcxt_visitor_panel_addon', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 24 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xcxt_trade')
Params: 2
Run Time: 0.000041
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT tag.*
FROM xf_nflj_showcase_tag AS tag
WHERE 1=1
ORDER BY tag.content_count DESC
LIMIT 25
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ALL | | | | | 530 | Using filesort |
SELECT *
FROM xf_notification
ORDER BY notification_id
Run Time: 0.000099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_notification | index | | PRIMARY | 4 | | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('GritterNotifications')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000058
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |