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.000957
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: b2ad27bac7ce7c42e28d5f64a03db3b9, 1716080299
Run Time: 0.000259
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.000285
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.000621
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.001377
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 = 'b2ad27bac7ce7c42e28d5f64a03db3b9')
Params: 1716083899
Run Time: 0.000250
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, , 1716080299,
Run Time: 0.000252
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000291
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.000284
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.000479
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 < 1716080299 AND advertisement.end_date > 1716080299))) 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.001197
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.000466
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.000261
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.000477
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.000157
UPDATE `admon_advertisement` SET `impressions` = ? WHERE (advertisement_id = 'quinstreet_banner')
Params: 160598421
Run Time: 0.000262
commit
Run Time: 0.000793
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1716076800, impression, , quinstreet_banner
Run Time: 0.042170
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58532 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58572
Run Time: 0.000329
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.000193
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58572)
Params: 8403
Run Time: 0.000230
commit
Run Time: 0.000956