SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000096
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 = 'ruedas')
Run Time: 0.002588
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.000314
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 (408, 368, 246, 187, 53)) AND (item.item_state IN ('visible'))
Run Time: 0.001904
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | item | range | PRIMARY,categoryID,category_last_update,category_rating_weighted | PRIMARY | 4 | | 5 | Using where |
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 (408, 368, 246, 187, 53)) AND (item.item_state IN ('visible'))
ORDER BY item.date_added DESC
LIMIT 20
Run Time: 0.002494
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | item | range | PRIMARY,categoryID,category_last_update,category_rating_weighted | PRIMARY | 4 | | 5 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.item.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.item.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.item.user_id | 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 (246, 187, 53)
ORDER BY attachment.content_id, attachment.attach_date
Params: showcase_item
Run Time: 0.000274
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 4 | Using index condition |
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.000492
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: aa75597542209729e12db48535843155, , 1715059439
Run Time: 0.000158
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=ruedas, 1715055839,
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.000083
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.000204
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.000052
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.000111
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.000127
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 | |