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.001047
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.000361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 9156
Run Time: 0.000531
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 3
Run Time: 0.000561
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 9156
Run Time: 0.001497
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 17 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.post.user_id | 1 | |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | degreeinfo_xenforo.post.user_id,func | 1 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 9156
Run Time: 0.000321
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3638f9d28a03be9545df6dd6f1980120, a:10:{s:12:"sessionStart";i:1714595659;s:2:"ip";s:4:"4UL";s:11:"sessionCsrf";s:16:"XBg_WaMppgJoOW5k";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0;
[email protected])";s:7:"robotId";s:0:"";s:7:"referer";s:76:"http://www.degreeinfo.com/index.php?threads/clep-us-history-2.9156/&_debug=1";s:10:"fromSearch";b:0;s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1675305802;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1616500259;}}, 1714599259
Run Time: 0.000315
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, 4UL, 4UL, XenForo_ControllerPublic_Thread, Index, valid, thread_id=9156, 1714595659,
Run Time: 0.000217
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000288
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.000294
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | uix_node_layout | ALL | | | | | 2 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: uix_nodeCache
Run Time: 0.000290
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000553
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 < 1714595659 AND advertisement.end_date > 1714595659))) 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.001171
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', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'thread_view', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000579
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 9 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('admon_active')
Params: 1
Run Time: 0.000233
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: admon_affiliateLinks
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT advertisement.*
FROM admon_advertisement AS advertisement
WHERE advertisement.advertisement_id=?
Params: edudyn_banner_1
Run Time: 0.000378
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 | |
SELECT *
FROM admon_advertisement_group
WHERE group_id=?
Params: 1
Run Time: 0.000269
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_advertisement_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000199
UPDATE `admon_advertisement` SET `impressions` = ?, `last_modified` = ? WHERE (advertisement_id = 'edudyn_banner_1')
Params: 15327764, 1714595659
Run Time: 0.000271
commit
Run Time: 0.000798
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1714521600, impression, , edudyn_banner_1
Run Time: 0.038146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58043 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58099
Run Time: 0.000282
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.000069
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58099)
Params: 13442
Run Time: 0.000257
commit
Run Time: 0.000763
SELECT advertisement.*
FROM admon_advertisement AS advertisement
WHERE advertisement.advertisement_id=?
Params: edudyn_banner_15b
Run Time: 0.000571
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 | |
SELECT *
FROM admon_advertisement_group
WHERE group_id=?
Params: 1
Run Time: 0.000310
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_advertisement_group | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000193
UPDATE `admon_advertisement` SET `impressions` = ?, `last_modified` = ? WHERE (advertisement_id = 'edudyn_banner_15b')
Params: 10587305, 1714595659
Run Time: 0.000322
commit
Run Time: 0.000870
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1714521600, impression, , edudyn_banner_15b
Run Time: 0.034101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58043 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58094
Run Time: 0.000303
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.000164
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58094)
Params: 9434
Run Time: 0.000251
commit
Run Time: 0.000670
SELECT advertisement.*
FROM admon_advertisement AS advertisement
WHERE advertisement.advertisement_id=?
Params: quinstreet_banner
Run Time: 0.000428
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.000129
UPDATE `admon_advertisement` SET `impressions` = ? WHERE (advertisement_id = 'quinstreet_banner')
Params: 157665696
Run Time: 0.000241
commit
Run Time: 0.000619
SELECT *
FROM admon_statistic
WHERE statistic_date=?
AND statistic_type=?
AND statistic_data=?
AND advertisement_id=?
Params: 1714521600, impression, , quinstreet_banner
Run Time: 0.030488
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | admon_statistic | ALL | | | | | 58043 | Using where |
SELECT *
FROM admon_statistic
WHERE statistic_id=?
Params: 58089
Run Time: 0.000262
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.000154
UPDATE `admon_statistic` SET `statistic_value` = ? WHERE (statistic_id = 58089)
Params: 182523
Run Time: 0.000236
commit
Run Time: 0.000707