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.002383
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.000280
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.000299
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.027459
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 > 1698634583) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 4, 27
Run Time: 0.014122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 48 | 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 > 1698634583) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.000548
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: 16b6b2d988205a04c1872d520e1967d8, , 1714190183
Run Time: 0.000316
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, , 1714186583,
Run Time: 0.000210
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.000516
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.000592
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.000339
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:1714186583;}}
Run Time: 0.000306
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 = '27' AND user_profile.dob_month = '04'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.012335
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 48 | 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:12058:"<h4 class="minorHeading">Today is 45 people's birthday.</h4>
<ul class="followedOnline">
<li title="abdou-w16, 32" class="Tooltip user-42693">
<a href="members/abdou-w16.42693/" class="avatar Av42693s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="abdou-w16" /></a>
</li>
<li title="afifiku, 35" class="Tooltip user-7851">
<a href="members/afifiku.7851/" class="avatar Av7851s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="afifiku" /></a>
</li>
<li title="Alan Kral, 52" class="Tooltip user-15634">
<a href="members/alan-kral.15634/" class="avatar Av15634s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Alan Kral" /></a>
</li>
<li title="Alex.B, 60" class="Tooltip user-24294">
<a href="members/alex-b.24294/" class="avatar Av24294s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Alex.B" /></a>
</li>
<li title="Boomer333, 61" class="Tooltip user-33407">
<a href="members/boomer333.33407/" class="avatar Av33407s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Boomer333" /></a>
</li>
<li title="dl6uf, 60" class="Tooltip user-13577">
<a href="members/dl6uf.13577/" class="avatar Av13577s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="dl6uf" /></a>
</li>
<li title="elefant, 60" class="Tooltip user-13841">
<a href="members/elefant.13841/" class="avatar Av13841s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="elefant" /></a>
</li>
<li title="Elvir, 47" class="Tooltip user-42790">
<a href="members/elvir.42790/" class="avatar Av42790s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Elvir" /></a>
</li>
<li title="erdi01, 41" class="Tooltip user-6443">
<a href="members/erdi01.6443/" class="avatar Av6443s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="erdi01" /></a>
</li>
<li title="fbvu5er, 54" class="Tooltip user-56843">
<a href="members/fbvu5er.56843/" class="avatar Av56843s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="fbvu5er" /></a>
</li>
<li title="Feldmaus70, 74" class="Tooltip user-22084">
<a href="members/feldmaus70.22084/" class="avatar Av22084s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Feldmaus70" /></a>
</li>
<li title="ferra, 64" class="Tooltip user-5445">
<a href="members/ferra.5445/" class="avatar Av5445s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ferra" /></a>
</li>
<li title="flayer75, 49" class="Tooltip user-23402">
<a href="members/flayer75.23402/" class="avatar Av23402s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="flayer75" /></a>
</li>
<li title="Friedo2017, 65" class="Tooltip user-2211">
<a href="members/friedo2017.2211/" class="avatar Av2211s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Friedo2017" /></a>
</li>
<li title="Gekko, 46" class="Tooltip user-44781">
<a href="members/gekko.44781/" class="avatar Av44781s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Gekko" /></a>
</li>
<li title="gibhei, 77" class="Tooltip user-3206">
<a href="members/gibhei.3206/" class="avatar Av3206s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="gibhei" /></a>
</li>
<li title="GR1x?!, 65" class="Tooltip user-21710">
<a href="members/gr1x.21710/" class="avatar Av21710s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="GR1x?!" /></a>
</li>
<li title="hans otten, 83" class="Tooltip user-2155">
<a href="members/hans-otten.2155/" class="avatar Av2155s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="hans otten" /></a>
</li>
<li title="HeineKing, 36" class="Tooltip user-30555">
<a href="members/heineking.30555/" class="avatar Av30555s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="HeineKing" /></a>
</li>
<li title="herbert Grässle, 64" class="Tooltip user-16908">
<a href="members/herbert-graessle.16908/" class="avatar Av16908s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="herbert Grässle" /></a>
</li>
<li title="huehnerscheck56, 68" class="Tooltip user-10268">
<a href="members/huehnerscheck56.10268/" class="avatar Av10268s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="huehnerscheck56" /></a>
</li>
<li title="ivahyx, 36" class="Tooltip user-8170">
<a href="members/ivahyx.8170/" class="avatar Av8170s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ivahyx" /></a>
</li>
<li title="JorCarrondo, 49" class="Tooltip user-3812">
<a href="members/jorcarrondo.3812/" class="avatar Av3812s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="JorCarrondo" /></a>
</li>
<li title="KikasDE, 43" class="Tooltip user-1173">
<a href="members/kikasde.1173/" class="avatar Av1173s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="KikasDE" /></a>
</li>
<li title="manne, 79" class="Tooltip user-9983">
<a href="members/manne.9983/" class="avatar Av9983s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="manne" /></a>
</li>
<li title="mici, 48" class="Tooltip user-13790">
<a href="members/mici.13790/" class="avatar Av13790s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="mici" /></a>
</li>
<li title="mohammadrs, 43" class="Tooltip user-4397">
<a href="members/mohammadrs.4397/" class="avatar Av4397s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="mohammadrs" /></a>
</li>
<li title="Oliver44, 80" class="Tooltip user-27223">
<a href="members/oliver44.27223/" class="avatar Av27223s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Oliver44" /></a>
</li>
<li title="osebeqe, 37" class="Tooltip user-9065">
<a href="members/osebeqe.9065/" class="avatar Av9065s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="osebeqe" /></a>
</li>
<li title="Osmankara, 39" class="Tooltip user-45207">
<a href="members/osmankara.45207/" class="avatar Av45207s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Osmankara" /></a>
</li>
<li title="petrat, 54" class="Tooltip user-12456">
<a href="members/petrat.12456/" class="avatar Av12456s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_female_s.png" width="48" height="48" alt="petrat" /></a>
</li>
<li title="pgritsch, 57" class="Tooltip user-41948">
<a href="members/pgritsch.41948/" class="avatar Av41948s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="pgritsch" /></a>
</li>
<li title="polifranco, 47" class="Tooltip user-23909">
<a href="members/polifranco.23909/" class="avatar Av23909s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="polifranco" /></a>
</li>
<li title="ramos, 57" class="Tooltip user-598">
<a href="members/ramos.598/" class="avatar Av598s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ramos" /></a>
</li>
<li title="rudi27, 69" class="Tooltip user-12025">
<a href="members/rudi27.12025/" class="avatar Av12025s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="rudi27" /></a>
</li>
<li title="samce, 55" class="Tooltip user-10273">
<a href="members/samce.10273/" class="avatar Av10273s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="samce" /></a>
</li>
<li title="serov, 52" class="Tooltip user-55031">
<a href="members/serov.55031/" class="avatar Av55031s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="serov" /></a>
</li>
<li title="sourex, 41" class="Tooltip user-25741">
<a href="members/sourex.25741/" class="avatar Av25741s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="sourex" /></a>
</li>
<li title="Spike2704, 55" class="Tooltip user-16512">
<a href="members/spike2704.16512/" class="avatar Av16512s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Spike2704" /></a>
</li>
<li title="tomas1977, 47" class="Tooltip user-41931">
<a href="members/tomas1977.41931/" class="avatar Av41931s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="tomas1977" /></a>
</li>
<li title="Treacle, 64" class="Tooltip user-44517">
<a href="members/treacle.44517/" class="avatar Av44517s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Treacle" /></a>
</li>
<li title="trewi, 49" class="Tooltip user-30806">
<a href="members/trewi.30806/" class="avatar Av30806s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="trewi" /></a>
</li>
<li title="tutci, 56" class="Tooltip user-2021">
<a href="members/tutci.2021/" class="avatar Av2021s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="tutci" /></a>
</li>
<li title="valdinho, 62" class="Tooltip user-2995">
<a href="members/valdinho.2995/" class="avatar Av2995s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="valdinho" /></a>
</li>
<li title="woko9033, 65" class="Tooltip user-12477">
<a href="members/woko9033.12477/" class="avatar Av12477s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="woko9033" /></a>
</li>
</ul>";s:4:"time";i:1714186583;}}
Run Time: 0.000830
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:1714186583;}}
Run Time: 0.000253
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 4
Run Time: 0.000521
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.000255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |