SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000671
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_tinhte_xentag_tag` AS tag
WHERE 1=1
ORDER BY tag.content_count DESC
LIMIT 100
Run Time: 0.002474
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ALL | | | | | 51 | Using filesort |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: Tinhte_XenTag_trending
Run Time: 0.000891
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT tagged.tag_id, count(*) AS tagged_count
FROM `xf_tinhte_xentag_tagged_content` AS tagged
WHERE tagged.tagged_date > ?
GROUP BY tagged.tag_id
ORDER BY tagged_count DESC
LIMIT ?;
Params: 1713935285, 10
Run Time: 0.001587
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tagged | ALL | | | | | 52 | Using where; Using temporary; Using filesort |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: Tinhte_XenTag_trending, a:2:{s:4:"tags";a:0:{}s:4:"time";i:1715144885;}
Run Time: 0.000947
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, , , Tinhte_XenTag_ControllerPublic_Tag, Index, valid, , 1715144885,
Run Time: 0.000357
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'tinhte_xentag_tag_list', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_hook_message_below', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_navigation_tabs_forums', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.001593
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 10 | Using where |