SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000085
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 = 'manillar carbono')
Run Time: 0.000077
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.000274
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 (331)) AND (category.rate_review_system <> 0) AND (item.item_state IN ('visible'))
Run Time: 0.000389
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 | |
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 (331)) AND (category.rate_review_system <> 0) AND (item.item_state IN ('visible'))
ORDER BY item.rating_avg DESC, item.rating_count DESC, item.likes DESC, item.view_count DESC
LIMIT 20
Run Time: 0.000922
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 (331)
ORDER BY attachment.content_id, attachment.attach_date
Params: showcase_item
Run Time: 0.000491
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 | 3 | 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.000064
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: 0e9f1d92f05c4bc954f0515f0488e6ff, , 1711726223
Run Time: 0.000217
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=manillar+carbono, 1711722623,
Run Time: 0.000093
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.000069
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.000180
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.000049
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.000082
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.000095
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 | |