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.003320
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.000340
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.000335
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.is_staff = 1)
ORDER BY user.username ASC
Run Time: 0.001918
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | ref | staff_username | staff_username | 1 | const | 6 | 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 > 1698829034) AND (user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 12
Params: 4, 29
Run Time: 0.014821
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 35 | 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 > 1698829034) AND (user.user_state = 'valid') AND (user.is_banned = 0)
ORDER BY user.register_date DESC
LIMIT 12
Run Time: 0.000590
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: 3a6a712a09f1d8243692be58c4b9630e, , 1714384634
Run Time: 0.000301
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, , 1714381034,
Run Time: 0.000196
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.000806
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.000552
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.000389
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:1714381034;}}
Run Time: 0.000509
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 = '29' AND user_profile.dob_month = '04'))) AND (user_option.show_dob_date = 1)
ORDER BY user.username ASC
Run Time: 0.011424
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 35 | 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:8330:"<h4 class="minorHeading">Today is 31 people's birthday.</h4>
<ul class="followedOnline">
<li title="44gewuerz, 80" class="Tooltip user-12095">
<a href="members/44gewuerz.12095/" class="avatar Av12095s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="44gewuerz" /></a>
</li>
<li title="Agatka1, 66" class="Tooltip user-16540">
<a href="members/agatka1.16540/" class="avatar Av16540s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Agatka1" /></a>
</li>
<li title="AndreyAqua, 20" class="Tooltip user-1030">
<a href="members/andreyaqua.1030/" class="avatar Av1030s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="AndreyAqua" /></a>
</li>
<li title="andy68, 56" class="Tooltip user-19383">
<a href="members/andy68.19383/" class="avatar Av19383s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="andy68" /></a>
</li>
<li title="arty4u, 38" class="Tooltip user-4459">
<a href="members/arty4u.4459/" class="avatar Av4459s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="arty4u" /></a>
</li>
<li title="Boss, 71" class="Tooltip user-17059">
<a href="members/boss.17059/" class="avatar Av17059s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Boss" /></a>
</li>
<li title="cakraz74, 57" class="Tooltip user-4621">
<a href="members/cakraz74.4621/" class="avatar Av4621s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="cakraz74" /></a>
</li>
<li title="carlos1pt, 66" class="Tooltip user-16517">
<a href="members/carlos1pt.16517/" class="avatar Av16517s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="carlos1pt" /></a>
</li>
<li title="chinchin87, 37" class="Tooltip user-55582">
<a href="members/chinchin87.55582/" class="avatar Av55582s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="chinchin87" /></a>
</li>
<li title="gaul, 85" class="Tooltip user-39146">
<a href="members/gaul.39146/" class="avatar Av39146s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="gaul" /></a>
</li>
<li title="Geopi, 76" class="Tooltip user-3166">
<a href="members/geopi.3166/" class="avatar Av3166s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Geopi" /></a>
</li>
<li title="gogoen, 37" class="Tooltip user-4974">
<a href="members/gogoen.4974/" class="avatar Av4974s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="gogoen" /></a>
</li>
<li title="grubyman" class="Tooltip user-13454">
<a href="members/grubyman.13454/" class="avatar Av13454s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="grubyman" /></a>
</li>
<li title="Hayde, 58" class="Tooltip user-7343">
<a href="members/hayde.7343/" class="avatar Av7343s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Hayde" /></a>
</li>
<li title="maarif1975, 49" class="Tooltip user-6943">
<a href="members/maarif1975.6943/" class="avatar Av6943s _plainImage" data-avatarhtml="true"><img src="data/avatars/s/6/6943.jpg?1509697381" width="48" height="48" alt="maarif1975" /></a>
</li>
<li title="majmariu, 65" class="Tooltip user-2826">
<a href="members/majmariu.2826/" class="avatar Av2826s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="majmariu" /></a>
</li>
<li title="ngc.ie, 42" class="Tooltip user-10733">
<a href="members/ngc-ie.10733/" class="avatar Av10733s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="ngc.ie" /></a>
</li>
<li title="Osso1964, 60" class="Tooltip user-27958">
<a href="members/osso1964.27958/" class="avatar Av27958s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Osso1964" /></a>
</li>
<li title="polygraf, 44" class="Tooltip user-9239">
<a href="members/polygraf.9239/" class="avatar Av9239s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="polygraf" /></a>
</li>
<li title="polygraf80, 44" class="Tooltip user-23396">
<a href="members/polygraf80.23396/" class="avatar Av23396s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="polygraf80" /></a>
</li>
<li title="Rafal, 45" class="Tooltip user-19048">
<a href="members/rafal.19048/" class="avatar Av19048s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Rafal" /></a>
</li>
<li title="rika0010, 58" class="Tooltip user-51420">
<a href="members/rika0010.51420/" class="avatar Av51420s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="rika0010" /></a>
</li>
<li title="seppi, 64" class="Tooltip user-49204">
<a href="members/seppi.49204/" class="avatar Av49204s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="seppi" /></a>
</li>
<li title="St@rik, 73" class="Tooltip user-3735">
<a href="members/st-rik.3735/" class="avatar Av3735s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="St@rik" /></a>
</li>
<li title="ukaraagil, 52" class="Tooltip user-51111">
<a href="members/ukaraagil.51111/" class="avatar Av51111s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="ukaraagil" /></a>
</li>
<li title="Valhalla198, 43" class="Tooltip user-423">
<a href="members/valhalla198.423/" class="avatar Av423s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="Valhalla198" /></a>
</li>
<li title="WAgner1983, 20" class="Tooltip user-11834">
<a href="members/wagner1983.11834/" class="avatar Av11834s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="WAgner1983" /></a>
</li>
<li title="walkowa48, 76" class="Tooltip user-3713">
<a href="members/walkowa48.3713/" class="avatar Av3713s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="walkowa48" /></a>
</li>
<li title="wik3bk, 54" class="Tooltip user-37923">
<a href="members/wik3bk.37923/" class="avatar Av37923s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="wik3bk" /></a>
</li>
<li title="wilfnep, 71" class="Tooltip user-2144">
<a href="members/wilfnep.2144/" class="avatar Av2144s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="wilfnep" /></a>
</li>
<li title="younes_farhan, 51" class="Tooltip user-31250">
<a href="members/younes_farhan.31250/" class="avatar Av31250s _plainImage" data-avatarhtml="true"><img src="styles/aurora/xenforo/avatars/avatar_male_s.png" width="48" height="48" alt="younes_farhan" /></a>
</li>
</ul>";s:4:"time";i:1714381034;}}
Run Time: 0.000652
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:1714381034;}}
Run Time: 0.000210
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('birthday', 'staff_members')
Params: 4
Run Time: 0.000621
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.000301
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |