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.001139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000409
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.001249
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, 165, 971, 489, 1276, 922, 538, 149, 3225, 920, 743, 612, 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.002024
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | PRIMARY | PRIMARY | 4 | | 100 | Using where; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: bd9eab5f97fdc9ced792afb380d7989f, , 1715263021
Run Time: 0.000287
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, , 1715259421,
Run Time: 0.000217
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000255
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.000273
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.000514
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 < 1715259421 AND advertisement.end_date > 1715259421))) 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.001415
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.000477
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.000250
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.000524
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.000139
UPDATE `admon_advertisement` SET `impressions` = ?, `last_modified` = ? WHERE (advertisement_id = 'quinstreet_banner')
Params: 159104915, 1715259421
Run Time: 0.000281
commit
Run Time: 0.008957
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1715212800, impression, , quinstreet_banner
Run Time: 0.041910
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58276 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58308
Run Time: 0.000321
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.000197
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58308)
Params: 80617
Run Time: 0.000249
commit
Run Time: 0.000871