SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000339
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000343
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 101 | Using where; Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000523
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 103 | Using where |
SELECT prefix.*
FROM xf_thread_prefix AS prefix
WHERE 1=1
ORDER BY prefix.materialized_order
Run Time: 0.000592
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | prefix | ALL | | | | | 89 | Using filesort |
SELECT prefix.prefix_id, node.*, forum.*, cache.cache_value AS node_permission_cache
FROM xf_thread_prefix AS prefix
INNER JOIN xf_forum_prefix AS fp ON (fp.prefix_id = prefix.prefix_id)
INNER JOIN xf_node AS node ON (fp.node_id = node.node_id)
INNER JOIN xf_forum AS forum ON (node.node_id = forum.node_id)
INNER JOIN xf_permission_cache_content AS cache ON
(cache.content_type = 'node' AND cache.content_id = node.node_id AND cache.permission_combination_id = ?)
ORDER BY prefix.materialized_order
Params: 1
Run Time: 0.002717
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | fp | index | PRIMARY,prefix_id | PRIMARY | 8 | | 27 | Using index; Using temporary; Using filesort |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.fp.node_id | 1 | |
SIMPLE | prefix | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.fp.prefix_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.fp.node_id | 1 | |
SIMPLE | cache | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.fp.node_id | 1 | Using where |
SELECT field.*
FROM xf_thread_field AS field
WHERE 1=1
ORDER BY field.materialized_order
Run Time: 0.000504
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | field | ALL | | | | | 27 | Using filesort |
SELECT *
FROM xf_region
WHERE r_parentid = ? ORDER BY r_displayorder ASC
Params: 0
Run Time: 0.000212
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_region | ref | r_parentid | r_parentid | 4 | const | 65 | Using where; Using filesort |
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, , , XenForo_ControllerPublic_Search, Index, valid, , 1656450619,
Run Time: 0.000410
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_widget | ALL | | | | | 17 | Using where; Using filesort |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thread_field_productauction_desc', 'thread_field_startprice_desc', 'thread_field_stepprice_desc', 'thread_field_final_desc', 'thread_field_status_desc', 'thread_field_phone_desc', 'thread_field_address_desc', 'thread_field_time_desc', 'thread_field_product_desc', 'thread_field_property_desc', 'thread_field_poststatus_desc', 'thread_field_price_desc', 'thread_field_km_desc', 'thread_field_ownerstatus_desc', 'thread_field_real_price_desc', 'thread_field_discount_price_desc', 'thread_field_quantity_desc', 'thread_field_seller_desc', 'thread_field_mobile_desc', 'thread_field_postaddress_desc', 'thread_field_city_desc', 'thread_field_district_desc')
Params: 4
Run Time: 0.000446
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 22 | Using where |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1656449719)
ORDER BY session_activity.view_date DESC
Run Time: 0.003138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1814 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |