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.004197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000253
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.002613
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | message_count | message_count | 4 | | 2871 | Using index condition; Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.user.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.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 > 1696104444) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 3, 28
Run Time: 0.019415
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 26 | Using index condition; Using temporary; Using filesort |
SIMPLE | user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | k46624_forum.user_profile.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.user_profile.user_id | 1 | Using where |
SELECT user.*
FROM xf_user AS user
WHERE (user.last_activity > 1696104444) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.000591
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | index | user_state,last_activity | register_date | 4 | | 24 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 7bda302fa2eb2bd0fc806f2ecf1f07c6, , 1711660044
Run Time: 0.000279
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, , 1711656444,
Run Time: 0.000212
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_facebook_facepile', 'member_notable', 'notice_cookies', 'resources_tab_links', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000767
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 12 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc_a74448284672e6b740125', 'wfc__1_member_notable')
Run Time: 0.000468
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_5393547d8780671aedf93')
Run Time: 0.000447
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_5393547d8780671aedf93, a:1:{s:26:"member_notable_lock_3600_9";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1711656444;}}
Run Time: 0.000431
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 = '28' AND user_profile.dob_month = '03'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.012165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 26 | Using index condition; Using temporary; Using filesort |
SIMPLE | user | eq_ref | PRIMARY,user_state | PRIMARY | 4 | k46624_forum.user_profile.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.user_profile.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_a74448284672e6b740125, a:1:{s:21:"member_notable_3600_9";a:2:{s:4:"html";s:5656:"<h4 class="minorHeading">Today is 21 people's birthday.</h4>
<ul class="followedOnline">
<li title="alex61, 63" class="Tooltip user-4413">
<a href="members/alex61.4413/" class="avatar Av4413s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="alex61" /></a>
</li>
<li title="Bera, 66" class="Tooltip user-38202">
<a href="members/bera.38202/" class="avatar Av38202s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Bera" /></a>
</li>
<li title="Craig, 49" class="Tooltip user-20852">
<a href="members/craig.20852/" class="avatar Av20852s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Craig" /></a>
</li>
<li title="Dragoonfly, 68" class="Tooltip user-2834">
<a href="members/dragoonfly.2834/" class="avatar Av2834s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Dragoonfly" /></a>
</li>
<li title="Funja, 33" class="Tooltip user-11406">
<a href="members/funja.11406/" class="avatar Av11406s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Funja" /></a>
</li>
<li title="gregland, 61" class="Tooltip user-5604">
<a href="members/gregland.5604/" class="avatar Av5604s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="gregland" /></a>
</li>
<li title="kalad, 47" class="Tooltip user-6950">
<a href="members/kalad.6950/" class="avatar Av6950s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="kalad" /></a>
</li>
<li title="kaulchma, 63" class="Tooltip user-40655">
<a href="members/kaulchma.40655/" class="avatar Av40655s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="kaulchma" /></a>
</li>
<li title="Maro, 61" class="Tooltip user-16463">
<a href="members/maro.16463/" class="avatar Av16463s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Maro" /></a>
</li>
<li title="michka, 77" class="Tooltip user-14406">
<a href="members/michka.14406/" class="avatar Av14406s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="michka" /></a>
</li>
<li title="milanzib, 62" class="Tooltip user-50969">
<a href="members/milanzib.50969/" class="avatar Av50969s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="milanzib" /></a>
</li>
<li title="Okragon, 49" class="Tooltip user-3610">
<a href="members/okragon.3610/" class="avatar Av3610s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_female_s.png" width="48" height="48" alt="Okragon" /></a>
</li>
<li title="Questra61, 63" class="Tooltip user-44123">
<a href="members/questra61.44123/" class="avatar Av44123s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Questra61" /></a>
</li>
<li title="RichardS, 65" class="Tooltip user-52284">
<a href="members/richards.52284/" class="avatar Av52284s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="RichardS" /></a>
</li>
<li title="Sami-1012HD, 48" class="Tooltip user-355">
<a href="members/sami-1012hd.355/" class="avatar Av355s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Sami-1012HD" /></a>
</li>
<li title="thundedome, 41" class="Tooltip user-3039">
<a href="members/thundedome.3039/" class="avatar Av3039s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="thundedome" /></a>
</li>
<li title="valeriks, 69" class="Tooltip user-1848">
<a href="members/valeriks.1848/" class="avatar Av1848s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="valeriks" /></a>
</li>
<li title="vedat, 48" class="Tooltip user-1592">
<a href="members/vedat.1592/" class="avatar Av1592s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="vedat" /></a>
</li>
<li title="Weanni65, 59" class="Tooltip user-49190">
<a href="members/weanni65.49190/" class="avatar Av49190s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Weanni65" /></a>
</li>
<li title="Whitemoe, 31" class="Tooltip user-49916">
<a href="members/whitemoe.49916/" class="avatar Av49916s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Whitemoe" /></a>
</li>
<li title="Wizard1, 65" class="Tooltip user-24494">
<a href="members/wizard1.24494/" class="avatar Av24494s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Wizard1" /></a>
</li>
</ul>";s:4:"time";i:1711656444;}}
Run Time: 0.000391
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_5393547d8780671aedf93, a:1:{s:26:"member_notable_lock_3600_9";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1711656444;}}
Run Time: 0.000258
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 4
Run Time: 0.000468
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 ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000458
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |