SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000080
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 = 'baratos')
Run Time: 0.000072
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.000308
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 (102)) AND (item.item_state IN ('visible'))
Run Time: 0.000315
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 (102)) AND (item.item_state IN ('visible'))
ORDER BY item.date_added DESC
LIMIT 20
Run Time: 0.000733
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 (102)
ORDER BY attachment.content_id, attachment.attach_date
Params: showcase_item
Run Time: 0.000233
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.000508
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: b9573889b254de841c0336d20f0d8526, , 1714822269
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=baratos, 1714818669,
Run Time: 0.000072
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.000077
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.000273
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.000050
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.000102
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.000078
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.000044
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |