SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000129
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 = 'bravoshimano')
Run Time: 0.000120
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.000252
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 (73)) AND (item.item_state IN ('visible'))
Run Time: 0.000352
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 (73)) AND (item.item_state IN ('visible'))
ORDER BY item.date_added DESC
LIMIT 20
Run Time: 0.000577
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 (73)
ORDER BY attachment.content_id, attachment.attach_date
Params: showcase_item
Run Time: 0.000438
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.000581
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: 75601608e2a544d32c1b5ba532535f1c, , 1716316259
Run Time: 0.000125
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=bravoshimano, 1716312659,
Run Time: 0.000062
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.000061
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.000191
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.000059
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.000107
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.000108
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.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |