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.003105
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.000318
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.000320
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.002733
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | message_count | message_count | 4 | | 2881 | 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 > 1698388054) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 4, 24
Run Time: 0.012766
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 38 | 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 > 1698388054) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.000563
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: 8afe2236acddf11b754af49f74f40015, , 1713943654
Run Time: 0.000295
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, , 1713940054,
Run Time: 0.000257
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.000980
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.000799
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.000665
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:1713940054;}}
Run Time: 0.000554
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 = '24' AND user_profile.dob_month = '04'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.011643
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 38 | 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:7280:"<h4 class="minorHeading">Today is 27 people's birthday.</h4>
<ul class="followedOnline">
<li title="atujyju, 36" class="Tooltip user-9508">
<a href="members/atujyju.9508/" class="avatar Av9508s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="atujyju" /></a>
</li>
<li title="batar.a, 55" class="Tooltip user-44673">
<a href="members/batar-a.44673/" class="avatar Av44673s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="batar.a" /></a>
</li>
<li title="benkhaldoun, 54" class="Tooltip user-9235">
<a href="members/benkhaldoun.9235/" class="avatar Av9235s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="benkhaldoun" /></a>
</li>
<li title="bigich, 59" class="Tooltip user-7464">
<a href="members/bigich.7464/" class="avatar Av7464s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="bigich" /></a>
</li>
<li title="buka68, 49" class="Tooltip user-16250">
<a href="members/buka68.16250/" class="avatar Av16250s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="buka68" /></a>
</li>
<li title="Data, 55" class="Tooltip user-31152">
<a href="members/data.31152/" class="avatar Av31152s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Data" /></a>
</li>
<li title="David 7112, 54" class="Tooltip user-22130">
<a href="members/david-7112.22130/" class="avatar Av22130s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="David 7112" /></a>
</li>
<li title="DR250, 63" class="Tooltip user-49412">
<a href="members/dr250.49412/" class="avatar Av49412s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="DR250" /></a>
</li>
<li title="eff244, 75" class="Tooltip user-21804">
<a href="members/eff244.21804/" class="avatar Av21804s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="eff244" /></a>
</li>
<li title="EksTRIM, 40" class="Tooltip user-6287">
<a href="members/ekstrim.6287/" class="avatar Av6287s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="EksTRIM" /></a>
</li>
<li title="gmendieta, 47" class="Tooltip user-13188">
<a href="members/gmendieta.13188/" class="avatar Av13188s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_female_s.png" width="48" height="48" alt="gmendieta" /></a>
</li>
<li title="halcon1970, 54" class="Tooltip user-32386">
<a href="members/halcon1970.32386/" class="avatar Av32386s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="halcon1970" /></a>
</li>
<li title="kingleon, 49" class="Tooltip user-17709">
<a href="members/kingleon.17709/" class="avatar Av17709s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="kingleon" /></a>
</li>
<li title="kw-wb, 48" class="Tooltip user-23211">
<a href="members/kw-wb.23211/" class="avatar Av23211s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="kw-wb" /></a>
</li>
<li title="Lejyon, 38" class="Tooltip user-18721">
<a href="members/lejyon.18721/" class="avatar Av18721s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="Lejyon" /></a>
</li>
<li title="mladenm692, 55" class="Tooltip user-30982">
<a href="members/mladenm692.30982/" class="avatar Av30982s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="mladenm692" /></a>
</li>
<li title="Nash, 28" class="Tooltip user-49160">
<a href="members/nash.49160/" class="avatar Av49160s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Nash" /></a>
</li>
<li title="pass-one, 80" class="Tooltip user-6463">
<a href="members/pass-one.6463/" class="avatar Av6463s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="pass-one" /></a>
</li>
<li title="Plepkeshenkie, 69" class="Tooltip user-10613">
<a href="members/plepkeshenkie.10613/" class="avatar Av10613s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Plepkeshenkie" /></a>
</li>
<li title="RiomondBunSe, 48" class="Tooltip user-40114">
<a href="members/riomondbunse.40114/" class="avatar Av40114s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="RiomondBunSe" /></a>
</li>
<li title="rudi-franz, 72" class="Tooltip user-50350">
<a href="members/rudi-franz.50350/" class="avatar Av50350s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="rudi-franz" /></a>
</li>
<li title="Sawran, 35" class="Tooltip user-20451">
<a href="members/sawran.20451/" class="avatar Av20451s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Sawran" /></a>
</li>
<li title="SteveX56, 57" class="Tooltip user-48591">
<a href="members/stevex56.48591/" class="avatar Av48591s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="SteveX56" /></a>
</li>
<li title="Subzero1986, 38" class="Tooltip user-19273">
<a href="members/subzero1986.19273/" class="avatar Av19273s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Subzero1986" /></a>
</li>
<li title="udoich, 58" class="Tooltip user-17232">
<a href="members/udoich.17232/" class="avatar Av17232s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="udoich" /></a>
</li>
<li title="uliw, 65" class="Tooltip user-3920">
<a href="members/uliw.3920/" class="avatar Av3920s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="uliw" /></a>
</li>
<li title="usamuh, 36" class="Tooltip user-7315">
<a href="members/usamuh.7315/" class="avatar Av7315s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="usamuh" /></a>
</li>
</ul>";s:4:"time";i:1713940054;}}
Run Time: 0.000470
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:1713940054;}}
Run Time: 0.000250
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 4
Run Time: 0.000507
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.000264
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |