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.001081
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: 8ba9865cb0fc4526fed4ecd22b817e60, 1715933294
Run Time: 0.000322
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.000362
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.000479
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.001028
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 = '8ba9865cb0fc4526fed4ecd22b817e60')
Params: 1715936894
Run Time: 0.000376
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, , 1715933294,
Run Time: 0.000268
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000334
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.000343
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.000547
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 < 1715933294 AND advertisement.end_date > 1715933294))) 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.001194
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.000556
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.000332
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.000518
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.000147
UPDATE `admon_advertisement` SET `impressions` = ?, `last_modified` = ? WHERE (advertisement_id = 'quinstreet_banner')
Params: 160293903, 1715933294
Run Time: 0.000279
commit
Run Time: 0.000721
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1715904000, impression, , quinstreet_banner
Run Time: 0.044420
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: 58516
Run Time: 0.000224
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.000095
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58516)
Params: 54961
Run Time: 0.000141
commit
Run Time: 0.000504