SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.001016
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: 6d759093322acd2d9341de555281c752, 1715944140
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT tag_id
FROM xf_tag
WHERE use_count >= ?
ORDER BY use_count DESC
LIMIT 100
Params: 1
Run Time: 0.000633
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | use_count | use_count | 4 | | 1483 | Using where; Using index |
SELECT *
FROM xf_tag
WHERE tag_id IN (86, 70, 255, 163, 75, 84, 606, 439, 3, 111, 66, 179, 74, 170, 971, 489, 165, 1276, 922, 149, 3225, 920, 743, 612, 538, 491, 423, 256, 220, 130, 107, 95, 54, 3224, 3179, 770, 659, 417, 408, 333, 246, 152, 97, 583, 486, 254, 224, 177, 153, 46, 805, 796, 686, 634, 344, 307, 273, 247, 72, 50, 39, 941, 790, 736, 667, 477, 437, 415, 356, 338, 334, 329, 227, 214, 210, 207, 201, 188, 101, 98, 76, 69, 11, 3196, 1904, 1901, 995, 928, 905, 899, 778, 692, 671, 670, 664, 560, 510, 490, 480, 473)
ORDER BY tag
Run Time: 0.001405
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | PRIMARY | PRIMARY | 4 | | 100 | Using where; Using filesort |
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = '6d759093322acd2d9341de555281c752')
Params: 1715947740
Run Time: 0.000273
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_Tag, Index, valid, , 1715944140,
Run Time: 0.000218
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000279
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM uix_node_layout
Run Time: 0.000243
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | uix_node_layout | ALL | | | | | 2 | |
SELECT node.*,
node_field.uix_node_icons,
node_field.uix_styling,
node_field.collapsed,
node_field.inheritClass,
node_field.inheritStyling
FROM xf_node AS node
LEFT JOIN uix_node_fields AS node_field ON (node.node_id = node_field.node_id)
Run Time: 0.000478
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | ALL | | | | | 23 | |
SIMPLE | node_field | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.node.node_id | 1 | |
SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
user.*, IF(user.user_id IS NULL, advertisement.user_id, user.user_id) AS user_id,
purchase.*,
IF(user.user_id IS NULL, purchase.user_id, user.user_id) AS user_id
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN xf_user AS user ON
(user.user_id = advertisement.user_id)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1715944140 AND advertisement.end_date > 1715944140))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))
Run Time: 0.001053
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 17 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | degreeinfo_xenforo.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.advertisement.user_id | 1 | |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'tag_search', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000390
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('admon_active')
Params: 1
Run Time: 0.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT advertisement.*
FROM admon_advertisement AS advertisement
WHERE advertisement.advertisement_id=?
Params: quinstreet_banner
Run Time: 0.000492
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | const | advertisement_id_2,advertisement_id | advertisement_id_2 | 52 | const | 1 | |
begin
Run Time: 0.000092
UPDATE `admon_advertisement` SET `impressions` = ? WHERE (advertisement_id = 'quinstreet_banner')
Params: 160319597
Run Time: 0.000231
commit
Run Time: 0.000688
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1715904000, impression, , quinstreet_banner
Run Time: 0.053836
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58567 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58516
Run Time: 0.000255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000086
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58516)
Params: 80056
Run Time: 0.000200
commit
Run Time: 0.000726