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.003405
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.000305
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.000294
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.trophy_points > 0) AND (user.is_banned = 0)
ORDER BY user.trophy_points DESC
LIMIT 20
Run Time: 0.013625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | trophy_points | trophy_points | 4 | | 3000 | 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 > 1698450847) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 4, 25
Run Time: 0.016283
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 43 | 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 > 1698450847) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.000606
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: 22029ad83729e17f780ffad7aaf08ac9, , 1714006447
Run Time: 0.000261
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, , 1714002847,
Run Time: 0.000218
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.000559
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_fac6f3d1cc0fa055240e4', 'wfc__1_member_notable')
Run Time: 0.000637
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_fa925588bbc7fb53a475a')
Run Time: 0.000484
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_fa925588bbc7fb53a475a, a:1:{s:26:"member_notable_lock_7200_9";a:2:{s:4:"html";s:1:"1";s:4:"time";i:1714002847;}}
Run Time: 0.000350
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 = '25' AND user_profile.dob_month = '04'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.011233
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 43 | 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_fac6f3d1cc0fa055240e4, a:1:{s:21:"member_notable_7200_9";a:2:{s:4:"html";s:8976:"<h4 class="minorHeading">Today is 33 people's birthday.</h4>
<ul class="followedOnline">
<li title="25041953, 71" class="Tooltip user-1831">
<a href="members/25041953.1831/" class="avatar Av1831s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="25041953" /></a>
</li>
<li title="Bigma, 43" class="Tooltip user-9481">
<a href="members/bigma.9481/" class="avatar Av9481s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Bigma" /></a>
</li>
<li title="ceyyild, 49" class="Tooltip user-51189">
<a href="members/ceyyild.51189/" class="avatar Av51189s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ceyyild" /></a>
</li>
<li title="Daniel Maticevic, 44" class="Tooltip user-44713">
<a href="members/daniel-maticevic.44713/" class="avatar Av44713s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Daniel Maticevic" /></a>
</li>
<li title="Eocar, 57" class="Tooltip user-5561">
<a href="members/eocar.5561/" class="avatar Av5561s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Eocar" /></a>
</li>
<li title="franky25, 60" class="Tooltip user-8607">
<a href="members/franky25.8607/" class="avatar Av8607s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="franky25" /></a>
</li>
<li title="FWAlberts, 78" class="Tooltip user-2664">
<a href="members/fwalberts.2664/" class="avatar Av2664s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="FWAlberts" /></a>
</li>
<li title="giogio, 50" class="Tooltip user-30414">
<a href="members/giogio.30414/" class="avatar Av30414s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="giogio" /></a>
</li>
<li title="gregory7730, 47" class="Tooltip user-37775">
<a href="members/gregory7730.37775/" class="avatar Av37775s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="gregory7730" /></a>
</li>
<li title="Heinrich Lichtenwald, 51" class="Tooltip user-10471">
<a href="members/heinrich-lichtenwald.10471/" class="avatar Av10471s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Heinrich Lichtenwald" /></a>
</li>
<li title="Helmut55, 57" class="Tooltip user-35204">
<a href="members/helmut55.35204/" class="avatar Av35204s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Helmut55" /></a>
</li>
<li title="hw2504, 74" class="Tooltip user-14936">
<a href="members/hw2504.14936/" class="avatar Av14936s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="hw2504" /></a>
</li>
<li title="ixejumu, 35" class="Tooltip user-7930">
<a href="members/ixejumu.7930/" class="avatar Av7930s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ixejumu" /></a>
</li>
<li title="jcmcosta, 46" class="Tooltip user-49290">
<a href="members/jcmcosta.49290/" class="avatar Av49290s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="jcmcosta" /></a>
</li>
<li title="Lutz Andreas, 48" class="Tooltip user-44858">
<a href="members/lutz-andreas.44858/" class="avatar Av44858s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Lutz Andreas" /></a>
</li>
<li title="Lutzo, 27" class="Tooltip user-53787">
<a href="members/lutzo.53787/" class="avatar Av53787s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Lutzo" /></a>
</li>
<li title="mann007, 47" class="Tooltip user-10441">
<a href="members/mann007.10441/" class="avatar Av10441s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="mann007" /></a>
</li>
<li title="megeiver, 55" class="Tooltip user-20864">
<a href="members/megeiver.20864/" class="avatar Av20864s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="megeiver" /></a>
</li>
<li title="Meiky1904, 44" class="Tooltip user-44211">
<a href="members/meiky1904.44211/" class="avatar Av44211s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Meiky1904" /></a>
</li>
<li title="mfmcgn, 52" class="Tooltip user-49338">
<a href="members/mfmcgn.49338/" class="avatar Av49338s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="mfmcgn" /></a>
</li>
<li title="Octaman, 71" class="Tooltip user-15579">
<a href="members/octaman.15579/" class="avatar Av15579s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Octaman" /></a>
</li>
<li title="ovidiumarius, 46" class="Tooltip user-2348">
<a href="members/ovidiumarius.2348/" class="avatar Av2348s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ovidiumarius" /></a>
</li>
<li title="Pascha08, 45" class="Tooltip user-1305">
<a href="members/pascha08.1305/" class="avatar Av1305s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Pascha08" /></a>
</li>
<li title="paulinplaistow, 58" class="Tooltip user-8163">
<a href="members/paulinplaistow.8163/" class="avatar Av8163s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="paulinplaistow" /></a>
</li>
<li title="pgtosh2012, 25" class="Tooltip user-19106">
<a href="members/pgtosh2012.19106/" class="avatar Av19106s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="pgtosh2012" /></a>
</li>
<li title="Propisnov, 60" class="Tooltip user-113">
<a href="members/propisnov.113/" class="avatar Av113s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Propisnov" /></a>
</li>
<li title="Redbirom, 44" class="Tooltip user-25290">
<a href="members/redbirom.25290/" class="avatar Av25290s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Redbirom" /></a>
</li>
<li title="rentüb, 62" class="Tooltip user-11369">
<a href="members/rentueb.11369/" class="avatar Av11369s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="rentüb" /></a>
</li>
<li title="rikkid, 59" class="Tooltip user-42760">
<a href="members/rikkid.42760/" class="avatar Av42760s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="rikkid" /></a>
</li>
<li title="soulworks, 38" class="Tooltip user-47716">
<a href="members/soulworks.47716/" class="avatar Av47716s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="soulworks" /></a>
</li>
<li title="uwitos, 37" class="Tooltip user-7361">
<a href="members/uwitos.7361/" class="avatar Av7361s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="uwitos" /></a>
</li>
<li title="UZO 8, 59" class="Tooltip user-10274">
<a href="members/uzo-8.10274/" class="avatar Av10274s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="UZO 8" /></a>
</li>
<li title="Williehax, 41" class="Tooltip user-15374">
<a href="members/williehax.15374/" class="avatar Av15374s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="Williehax" /></a>
</li>
</ul>";s:4:"time";i:1714002847;}}
Run Time: 0.000732
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: wfc_fa925588bbc7fb53a475a, a:1:{s:26:"member_notable_lock_7200_9";a:2:{s:4:"html";s:1:"0";s:4:"time";i:1714002847;}}
Run Time: 0.000184
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 4
Run Time: 0.000439
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.000198
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |