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.000645
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.000285
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE (user.message_count > 0) AND (user.is_banned = 0)
ORDER BY user.message_count DESC
LIMIT 20
Run Time: 0.001682
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | message_count | message_count | 4 | | 3468 | Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.user.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.user.user_id | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE user_profile.dob_month = ?
AND user_profile.dob_day = ?
AND user_option.show_dob_date = 1
AND ((user.last_activity > 1700338743) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 5, 16
Run Time: 0.002713
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY,user_state,last_activity | last_activity | 4 | | 18 | Using where; Using filesort |
SIMPLE | user_profile | eq_ref | PRIMARY,dob | PRIMARY | 4 | mersedesclub_xf.user.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.user.user_id | 1 | Using where |
SELECT user.*
FROM xf_user AS user
WHERE (user.last_activity > 1700338743) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.001177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | user_state,last_activity | last_activity | 4 | | 18 | Using where; Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ba5dbb91bf9e39ff628834f51de51805, a:6:{s:12:"sessionStart";i:1715890743;s:2:"ip";b:0;s:11:"sessionCsrf";s:16:"UUCu5pAKTDpBBwq7";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;}, 1715894343
Run Time: 0.000292
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_Member, Index, valid, , 1715890743,
Run Time: 0.000199
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 17
Run Time: 0.000337
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_users_find', 'wf_widget_wrapper', 'wf_widget_birthday', 'wf_widget_users', 'wf_widget_threads', 'member_notable', 'wf_home_navtab_links', 'mkdgCatalog_Links', 'Counters', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.001643
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('catalog')
Params: 2
Run Time: 0.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000129
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000126
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000098
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000100
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000098
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 16
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 20
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 9
Run Time: 0.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000107
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc_508cd80fe63361209d657', 'wfc__1_member_notable')
Run Time: 0.000437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc_bf1ad5a2b9f0111ac0147')
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_bf1ad5a2b9f0111ac0147, a:1:{s:28:"member_notable_lock_10800_30";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1715890743;}}
Run Time: 0.001480
SELECT user.*
,
user_profile.*,
user_option.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
WHERE ((user.user_state = 'valid') AND (user.is_banned = 0)) AND (((user_profile.dob_day = '16' AND user_profile.dob_month = '05'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.006203
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 33 | Using where; Using temporary; Using filesort |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.user_profile.user_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY,user_state | PRIMARY | 4 | mersedesclub_xf.user_option.user_id | 1 | Using where |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_508cd80fe63361209d657, a:1:{s:23:"member_notable_10800_30";a:2:{s:4:"html";s:4173:"<h4 class="minorHeading"></h4>
<ul class="followedOnline">
<li title="any, 40" class="Tooltip user-779">
<a href="index.php?members/any.779/" class="username" dir="auto" itemprop="name">any</a>
</li>
<li title="Aspi, 39" class="Tooltip user-4440">
<a href="index.php?members/aspi.4440/" class="username" dir="auto" itemprop="name">Aspi</a>
</li>
<li title="bradld60, 42" class="Tooltip user-8307">
<a href="index.php?members/bradld60.8307/" class="username" dir="auto" itemprop="name">bradld60</a>
</li>
<li title="carmelafh18, 40" class="Tooltip user-6646">
<a href="index.php?members/carmelafh18.6646/" class="username" dir="auto" itemprop="name">carmelafh18</a>
</li>
<li title="ellatz11, 44" class="Tooltip user-6942">
<a href="index.php?members/ellatz11.6942/" class="username" dir="auto" itemprop="name">ellatz11</a>
</li>
<li title="estelazd69, 45" class="Tooltip user-9482">
<a href="index.php?members/estelazd69.9482/" class="username" dir="auto" itemprop="name">estelazd69</a>
</li>
<li title="EugeneSK, 32" class="Tooltip user-4253">
<a href="index.php?members/eugenesk.4253/" class="username" dir="auto" itemprop="name">EugeneSK</a>
</li>
<li title="jesushe18, 37" class="Tooltip user-9489">
<a href="index.php?members/jesushe18.9489/" class="username" dir="auto" itemprop="name">jesushe18</a>
</li>
<li title="JohnnyHop, 41" class="Tooltip user-6048">
<a href="index.php?members/johnnyhop.6048/" class="username" dir="auto" itemprop="name">JohnnyHop</a>
</li>
<li title="karynry3, 49" class="Tooltip user-8930">
<a href="index.php?members/karynry3.8930/" class="username" dir="auto" itemprop="name">karynry3</a>
</li>
<li title="kazzzka, 37" class="Tooltip user-2100">
<a href="index.php?members/kazzzka.2100/" class="username" dir="auto" itemprop="name">kazzzka</a>
</li>
<li title="leannaxi18, 48" class="Tooltip user-8064">
<a href="index.php?members/leannaxi18.8064/" class="username" dir="auto" itemprop="name">leannaxi18</a>
</li>
<li title="MishGun" class="Tooltip user-1013">
<a href="index.php?members/mishgun.1013/" class="username" dir="auto" itemprop="name">MishGun</a>
</li>
<li title="ramonavj3, 45" class="Tooltip user-7403">
<a href="index.php?members/ramonavj3.7403/" class="username" dir="auto" itemprop="name">ramonavj3</a>
</li>
<li title="rebeccajp2, 42" class="Tooltip user-7304">
<a href="index.php?members/rebeccajp2.7304/" class="username" dir="auto" itemprop="name">rebeccajp2</a>
</li>
<li title="ricardovs16, 45" class="Tooltip user-8986">
<a href="index.php?members/ricardovs16.8986/" class="username" dir="auto" itemprop="name">ricardovs16</a>
</li>
<li title="rosscd18, 38" class="Tooltip user-8279">
<a href="index.php?members/rosscd18.8279/" class="username" dir="auto" itemprop="name">rosscd18</a>
</li>
<li title="ruthielh1, 41" class="Tooltip user-8947">
<a href="index.php?members/ruthielh1.8947/" class="username" dir="auto" itemprop="name">ruthielh1</a>
</li>
<li title="tashadv2, 40" class="Tooltip user-7720">
<a href="index.php?members/tashadv2.7720/" class="username" dir="auto" itemprop="name">tashadv2</a>
</li>
<li title="traceyts16, 40" class="Tooltip user-7953">
<a href="index.php?members/traceyts16.7953/" class="username" dir="auto" itemprop="name">traceyts16</a>
</li>
<li title="VladimirJailE, 45" class="Tooltip user-6082">
<a href="index.php?members/vladimirjaile.6082/" class="username" dir="auto" itemprop="name">VladimirJailE</a>
</li>
<li title="Алекса, 38" class="Tooltip user-4600">
<a href="index.php?members/aleksa.4600/" class="username" dir="auto" itemprop="name">Алекса</a>
</li>
<li title="Алмаз" class="Tooltip user-1583">
<a href="index.php?members/almaz.1583/" class="username" dir="auto" itemprop="name">Алмаз</a>
</li>
</ul>";s:4:"time";i:1715890743;}}
Run Time: 0.001141
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_bf1ad5a2b9f0111ac0147, a:1:{s:28:"member_notable_lock_10800_30";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1715890743;}}
Run Time: 0.000517
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN ('11', '67', '68', '45', '64', '109', '110', '92', '35', '93', '111', '112', '113', '114', '115', '116', '117', '39', '94', '118', '119', '120', '74', '121', '122', '123', '124', '125', '128', '129', '130', '38', '50', '97', '131', '132', '133', '98', '43', '99', '42', '134', '135', '37', '136', '137', '138', '139', '140', '44', '41', '103', '143', '40', '104', '144', '145', '84', '105', '146', '147', '86', '148', '149', '108', '23', '60', '62', '65', '46', '21', '58', '172', '173', '174', '18', '19', '47', '89', '4', '5', '6', '48')) AND (thread.prefix_id IN ('149')) AND (thread.discussion_state IN ('visible')))
ORDER BY thread.post_date DESC
LIMIT 6
Run Time: 0.000426
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | post_date | 4 | | 6 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | mersedesclub_xf.thread.user_id | 1 | |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 2
Run Time: 0.000422
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('mkdgCatalog_TopLinks')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000224
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MKDG_navigation_visitor_tab_top')
AND style_id = ?
AND language_id = ?
Params: 2, 2
Run Time: 0.000267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |