Page Time: 0.0881s

Memory: 4.9215 MB (Peak: 5.1377 MB)

Queries (14, time: 0.0177s, 20.1%)

SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')

Run Time: 0.000447

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		36	Using where

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
XF\DataRegistry->get() in src/XF/App.php at line 1753
XF\App->preLoadData() in src/XF/App.php at line 1741
XF\App->setup() in src/XF/Pub/App.php at line 89
XF\Pub\App->setup() in src/XF.php at line 363
XF::setupApp() in src/XF.php at line 386
XF::runApp() in index.php at line 20

```
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000104
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_permission_combination const PRIMARY PRIMARY 4 const 1
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
14. XF\App->run() in src/XF.php at line 390
15. XF::runApp() in index.php at line 20

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

SELECT `xf_member_stat`.*
FROM `xf_member_stat`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_member_stat`.`addon_id`)
WHERE (`xf_member_stat`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_member_stat`.`addon_id` = ''))
ORDER BY `xf_member_stat`.`display_order` ASC

Run Time: 0.000614

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_member_stat	ALL					6	Using where; Using filesort
SIMPLE	xf_addon_AddOn_1	eq_ref	PRIMARY	PRIMARY	52	xenforo_testsquadron.xf_member_stat.addon_id	1	Using where

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 50
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`message_count` > 0) OR (`xf_user`.`message_count` < 0))
ORDER BY `xf_user`.`message_count` DESC

LIMIT 60

Run Time: 0.001534

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,message_count	message_count	4		4778	Using where
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 232
XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 101
XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 105
XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 114
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`trophy_points` > 0) OR (`xf_user`.`trophy_points` < 0))
ORDER BY `xf_user`.`trophy_points` DESC

LIMIT 60

Run Time: 0.005555

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,trophy_points	trophy_points	4		8420	Using where
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 232
XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 101
XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 105
XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 114
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (1138, 199, 7685, 2543, 760, 3500, 2, 1196, 171, 1825, 1166, 172, 1, 2946, 292, 5989, 3288, 4728, 2995, 3241, 807, 2544, 565, 2897, 954, 450, 3331, 1751, 3750, 3285, 1749, 3425, 3753, 3748, 3583, 1199, 3079, 1100, 3276, 2676, 1265, 3839, 3808, 3402, 2825, 1648, 3467, 1813, 3490, 2432, 1555, 3919, 3004, 1158, 628, 3364, 1373, 1229, 4801, 2152, 822, 284, 2420, 1809, 1024, 2966, 1652, 1314, 578, 3164, 3478, 5449, 5456, 5273, 3222, 4265, 4253, 4927, 5596, 4338, 6343, 2685, 2627, 4986, 7368, 6904, 5460, 3627, 1228, 5093, 6878, 3962, 6664, 5274, 6411, 5052, 4299, 5170, 4525, 4081, 6553, 6522, 1283, 7462, 8066, 6898, 3746, 8667, 6443, 7010, 2609, 8590, 1157, 3178, 7542, 4478, 8330, 1686, 6094, 6794, 2508, 2964, 6883, 4615, 5938, 8543, 2931, 3479, 8089, 4775, 7082, 8637, 2749, 6756, 8424, 4476, 6791, 7001, 8056, 5126, 1029, 5179, 2280, 2471, 655)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')

Run Time: 0.005540

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	PRIMARY,user_state	PRIMARY	4		145	Using where
SIMPLE	xf_user_option_Option_2	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1
SIMPLE	xf_user_profile_Profile_3	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 123
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`message_count` > 0) OR (`xf_user`.`message_count` < 0))
ORDER BY `xf_user`.`message_count` DESC

LIMIT 60

Run Time: 0.000383

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,message_count	message_count	4		4778	Using where
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 232
XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 101
XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 105
XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 127
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`trophy_points` > 0) OR (`xf_user`.`trophy_points` < 0))
ORDER BY `xf_user`.`trophy_points` DESC

LIMIT 60

Run Time: 0.000397

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,trophy_points	trophy_points	4		8420	Using where
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 232
XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 101
XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 105
XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 127
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

```
-- XFDB=noForceAllWrite
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, , , XF\Pub\Controller\Member, Index, valid, , 1660042400,
Run Time: 0.000392
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
11. XF\App->run() in src/XF.php at line 390
12. XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`register_date` DESC

LIMIT 12

Run Time: 0.000899

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	index	user_state	register_date	4		12	Using where
SIMPLE	xf_user_privacy_Privacy_1	eq_ref	PRIMARY	PRIMARY	4	xenforo_testsquadron.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewestMembers.php at line 24
XF\Widget\NewestMembers->render() in internal_data/code_cache/widgets/_2_member_wrapper_newest_members.php at line 5
XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6670
XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s40/public/member_wrapper.php at line 38
XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 856
XF\Template\Templater->applyWrappedTemplate() in src/XF/Template/Templater.php at line 1370
XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

```
SELECT
	SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
	SUM(IF(user_id > 0, 1, 0)) AS members,
	SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
```
Params: 1660038800
Run Time: 0.000655
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_session_activity range view_date view_date 4 203 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
3. XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
4. XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
5. XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
6. XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6670
8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
10. XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
11. ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
12. ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
13. call_user_func_array() in src/XF/Extension.php at line 67
14. XF\Extension->fire() in src/XF/App.php at line 2648
15. XF\App->fire() in src/XF/Pub/App.php at line 545
16. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
17. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
18. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
19. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
20. XF\App->run() in src/XF.php at line 390
21. XF::runApp() in index.php at line 20

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_session_activity	range	view_date	view_date	4		203	Using where

SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1660038800)
ORDER BY `xf_session_activity`.`view_date` DESC

LIMIT 50

Run Time: 0.000751

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_session_activity	range	PRIMARY,view_date	PRIMARY	4		7	Using where; Using filesort
SIMPLE	xf_user_User_1	eq_ref	PRIMARY,user_state	PRIMARY	4	xenforo_testsquadron.xf_session_activity.user_id	1	Using where

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6670
XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
call_user_func_array() in src/XF/Extension.php at line 67
XF\Extension->fire() in src/XF/App.php at line 2648
XF\App->fire() in src/XF/Pub/App.php at line 545
XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20

```
SELECT
	SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
	SUM(IF(user_id > 0, 1, 0)) AS members,
	SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
```
Params: 1660038800
Run Time: 0.000211
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_session_activity range view_date view_date 4 203 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
3. XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
4. XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Widget/OnlineStatistics.php at line 13
5. XF\Widget\OnlineStatistics->render() in internal_data/code_cache/widgets/_13_footer_onlineStatistics.php at line 5
6. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6670
7. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
8. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
9. XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
10. ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
11. ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
12. call_user_func_array() in src/XF/Extension.php at line 67
13. XF\Extension->fire() in src/XF/App.php at line 2648
14. XF\App->fire() in src/XF/Pub/App.php at line 545
15. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
16. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
19. XF\App->run() in src/XF.php at line 390
20. XF::runApp() in index.php at line 20
```
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('forumStatistics')
```
Run Time: 0.000209
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_data_registry const PRIMARY PRIMARY 27 const 1
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
5. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
6. XF\DataRegistry->offsetGet() in src/XF/App.php at line 1644
7. XF\App->XF\{closure}() in src/XF/Container.php at line 28
8. XF\Container->offsetGet() in src/XF/App.php at line 2251
9. XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
10. XF\Widget\ForumStatistics->render() in internal_data/code_cache/widgets/_11_footer_forumStatistics.php at line 5
11. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6670
12. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
13. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
14. XF\Template\Templater->widgetPosition() in src/addons/ThemeHouse/UIX/Util/UIX.php at line 70
15. ThemeHouse\UIX\Util\UIX->getFooterWidgets() in src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php at line 31
16. ThemeHouse\UIX\Listener\AppPubRenderPage::appPubRenderPage()
17. call_user_func_array() in src/XF/Extension.php at line 67
18. XF\Extension->fire() in src/XF/App.php at line 2648
19. XF\App->fire() in src/XF/Pub/App.php at line 545
20. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1989
21. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
22. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
23. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
24. XF\App->run() in src/XF.php at line 390
25. XF::runApp() in index.php at line 20

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_session_activity	range	view_date	view_date	4		203	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	27	const	1

Included Files (168, XenForo Classes: 84)

index.php
src/XF.php
src/vendor/autoload.php
src/vendor/composer/autoload_real.php
src/vendor/composer/ClassLoader.php
src/vendor/composer/autoload_static.php
src/vendor/symfony/polyfill-mbstring/bootstrap.php
src/vendor/paragonie/random_compat/lib/random.php
src/vendor/ralouphie/getallheaders/src/getallheaders.php
src/vendor/guzzlehttp/promises/src/functions_include.php
src/vendor/guzzlehttp/promises/src/functions.php
src/vendor/guzzlehttp/psr7/src/functions_include.php
src/vendor/guzzlehttp/psr7/src/functions.php
src/vendor/guzzlehttp/guzzle/src/functions_include.php
src/vendor/guzzlehttp/guzzle/src/functions.php
src/vendor/paragonie/sodium_compat/autoload.php
src/vendor/paragonie/sodium_compat/src/SodiumException.php
src/vendor/paragonie/sodium_compat/lib/namespaced.php
src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
src/vendor/paragonie/sodium_compat/lib/constants.php
src/vendor/paragonie/sodium_compat/src/Compat.php
src/vendor/symfony/polyfill-ctype/bootstrap.php
src/vendor/symfony/polyfill-php56/bootstrap.php
src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
src/vendor/symfony/var-dumper/Resources/functions/dump.php
src/vendor/dokuwiki/utf8/utf8.php
src/XF/Http/Request.php
src/XF/InputFilterer.php
src/XF/Pub/App.php
src/XF/App.php
src/XF/Container.php
src/config.php
src/XF/DataRegistry.php
src/XF/Db/Mysqli/Adapter.php
src/XF/Db/AbstractAdapter.php
src/XF/Db/Mysqli/Statement.php
src/XF/Db/AbstractStatement.php
src/XF/Extension.php
src/XF/AddOn/Manager.php
src/addons/ThemeHouse/UIX/Listener/AppSetup.php
src/XF/Session/Session.php
src/XF/Session/DbStorage.php
src/XF/Session/StorageInterface.php
src/XF/Util/Ip.php
src/XF/Util/Random.php
src/XF/Http/Response.php
src/XF/Mvc/Entity/Manager.php
src/XF/Mvc/Entity/ValueFormatter.php
src/XF/Repository/User.php
src/XF/Mvc/Entity/Repository.php
src/XF/Entity/User.php
src/XF/Mvc/Entity/Entity.php
src/addons/Snog/Flags/XF/Entity/User.php
src/addons/ThemeHouse/Donate/XF/Entity/User.php
src/XF/Mvc/Entity/Structure.php
src/XF/Entity/UserAuth.php
src/XF/Entity/UserOption.php
src/addons/ThemeHouse/UIX/Listener/EntityStructure.php
src/XF/Entity/UserProfile.php
src/XF/Entity/UserPrivacy.php
src/addons/ThemeHouse/Donate/XF/Entity/UserPrivacy.php
src/addons/Snog/Flags/XF/Entity/UserPrivacy.php
src/addons/Snog/Flags/Listener.php
src/XF/Util/File.php
src/XF/Language.php
src/XF/Mvc/Dispatcher.php
src/XF/Mvc/Router.php
src/XF/Mvc/RouteMatch.php
src/XF/Util/Arr.php
src/XF/Mvc/ParameterBag.php
src/XF/Pub/Controller/Member.php
src/XF/Pub/Controller/AbstractController.php
src/XF/Mvc/Controller.php
src/XF/Util/Php.php
src/XF/PermissionCache.php
src/XF/PermissionSet.php
src/XF/Repository/MemberStat.php
src/XF/Entity/MemberStat.php
src/XF/Finder/MemberStat.php
src/XF/Mvc/Entity/Finder.php
src/XF/Entity/AddOn.php
src/XF/Mvc/Entity/ArrayCollection.php
src/XF/Mvc/Entity/AbstractCollection.php
src/XF/Finder/User.php
src/XF/Service/MemberStat/Preparer.php
src/XF/Service/AbstractService.php
src/XF/Searcher/User.php
src/XF/Searcher/AbstractSearcher.php
src/XF/Phrase.php
src/addons/ThemeHouse/Donate/Listener/UserSearcherOrders.php
src/XF/Mvc/Reply/View.php
src/XF/Mvc/Reply/AbstractReply.php
src/XF/Repository/SessionActivity.php
src/XF/Data/Robot.php
src/XF/Style.php
src/XF/Template/Templater.php
src/addons/ThemeHouse/UIX/XF/Template/Templater.php
src/XF/SubContainer/BbCode.php
src/XF/SubContainer/AbstractSubContainer.php
src/XF/SubContainer/Widget.php
src/addons/ThemeHouse/UIX/Listener/TemplaterSetup.php
src/addons/ThemeHouse/Nodes/Listener/TemplaterSetup.php
src/addons/ThemeHouse/Donate/Listener/TemplaterSetup.php
src/XF/SimpleCache.php
src/XF/Mvc/Renderer/Html.php
src/XF/Mvc/Renderer/AbstractRenderer.php
src/XF/Mvc/View.php
src/XF/Template/Template.php
internal_data/code_cache/templates/l1/s40/public/member_notable.php
src/XF/PreEscaped.php
internal_data/code_cache/templates/l1/s40/public/metadata_macros.php
internal_data/code_cache/phrase_groups/l1/member_stat.php
internal_data/code_cache/templates/l1/s40/public/member_wrapper.php
internal_data/code_cache/widgets/_1_member_wrapper_find_member.php
src/XF/Widget/WidgetConfig.php
src/XF/Widget/FindMember.php
src/XF/Widget/AbstractWidget.php
internal_data/code_cache/phrase_groups/l1/widget.php
internal_data/code_cache/phrase_groups/l1/widget_def.php
src/XF/Widget/WidgetRenderer.php
internal_data/code_cache/templates/l1/s40/public/widget_find_member.php
internal_data/code_cache/widgets/_2_member_wrapper_newest_members.php
src/XF/Widget/NewestMembers.php
internal_data/code_cache/templates/l1/s40/public/widget_newest_members.php
internal_data/code_cache/navigation_cache.php
src/XF/Pub/Route/Search.php
src/addons/EWR/Rio/Listener/Navigation.php
src/XF/NoticeList.php
src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php
src/addons/ThemeHouse/UIX/Util/UIX.php
internal_data/code_cache/widgets/_6_forum_overview_members_online.php
src/XF/Widget/MembersOnline.php
src/XF/Entity/SessionActivity.php
src/XF/Finder/SessionActivity.php
internal_data/code_cache/templates/l1/s40/public/widget_members_online.php
internal_data/code_cache/widgets/_13_footer_onlineStatistics.php
src/XF/Widget/OnlineStatistics.php
internal_data/code_cache/templates/l1/s40/public/widget_online_statistics.php
internal_data/code_cache/widgets/_11_footer_forumStatistics.php
src/XF/Widget/ForumStatistics.php
internal_data/code_cache/templates/l1/s40/public/widget_forum_statistics.php
internal_data/code_cache/templates/l1/s40/public/PAGE_CONTAINER.php
internal_data/code_cache/phrase_groups/l1/button.php
internal_data/code_cache/templates/l1/s40/public/uix_socialMedia.php
internal_data/code_cache/phrase_groups/l1/nav.php
internal_data/code_cache/templates/l1/s40/public/_ads.php
internal_data/code_cache/templates/l1/s40/public/uix_extendedFooter.php
src/addons/ThemeHouse/Core/Branding.php
src/addons/ThemeHouse/Core/Branding/20180420.php
internal_data/code_cache/templates/l1/s40/public/debug_macros.php
src/XF/Str/Formatter.php
internal_data/code_cache/templates/l1/s40/public/helper_js_global.php
internal_data/code_cache/templates/l1/s40/public/font_awesome_setup.php
internal_data/code_cache/templates/l1/s40/public/google_analytics.php
internal_data/code_cache/templates/l1/s40/public/page_style.php
internal_data/code_cache/templates/l1/s40/public/uix_megaMenu.php
internal_data/code_cache/templates/l1/s40/public/uix_welcomeSection.php
internal_data/code_cache/templates/l1/s40/public/uix_canvasTabs.php
internal_data/code_cache/templates/l1/s40/public/uix_canvasPanels.php
internal_data/code_cache/templates/l1/s40/public/browser_warning_macros.php
internal_data/code_cache/templates/l1/s40/public/uix_config.php
src/addons/ThemeHouse/UIX/Listener/Pub/TemplaterMacroPreRender.php
internal_data/code_cache/templates/l1/s40/public/uix_js.php
internal_data/code_cache/phrase_groups/l1/reaction_title.php
internal_data/code_cache/templates/l1/s40/public/login.php
internal_data/code_cache/templates/l1/s40/public/password_box.php
src/XF/Debugger.php

DB Connection Stats

bytes_sent	13883
bytes_received	776523
packets_sent	166
packets_received	1738
protocol_overhead_in	6952
protocol_overhead_out	664
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	531
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	163
bytes_received_prepare_response_packet	90465
bytes_received_change_user_packet	684671
packets_sent_command	82
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	59
packets_received_rset_field_meta	0
packets_received_rset_row	29
packets_received_prepare_response	1127
packets_received_change_user	494
result_set_queries	26
non_result_set_queries	3
no_index_used	1
bad_index_used	0
slow_queries	0
buffered_sets	0
unbuffered_sets	0
ps_buffered_sets	26
ps_unbuffered_sets	0
flushed_normal_sets	0
flushed_ps_sets	0
ps_prepared_never_executed	0
ps_prepared_once_executed	26
rows_fetched_from_server_normal	0
rows_fetched_from_server_ps	468
rows_buffered_from_client_normal	0
rows_buffered_from_client_ps	468
rows_fetched_from_client_normal_buffered	0
rows_fetched_from_client_normal_unbuffered	0
rows_fetched_from_client_ps_buffered	0
rows_fetched_from_client_ps_unbuffered	0
rows_fetched_from_client_ps_cursor	0
rows_affected_normal	0
rows_affected_ps	0
rows_skipped_normal	0
rows_skipped_ps	468
copy_on_write_saved	0
copy_on_write_performed	0
command_buffer_too_small	0
connect_success	1
connect_failure	0
connection_reused	0
reconnect	0
pconnect_success	1
active_connections	1
active_persistent_connections	1
explicit_close	0
implicit_close	0
disconnect_close	0
in_middle_of_command_close	0
explicit_free_result	0
implicit_free_result	0
explicit_stmt_close	0
implicit_stmt_close	0
mem_emalloc_count	0
mem_emalloc_amount	0
mem_ecalloc_count	0
mem_ecalloc_amount	0
mem_erealloc_count	0
mem_erealloc_amount	0
mem_efree_count	0
mem_efree_amount	0
mem_malloc_count	0
mem_malloc_amount	0
mem_calloc_count	0
mem_calloc_amount	0
mem_realloc_count	0
mem_realloc_amount	0
mem_free_count	0
mem_free_amount	0
mem_estrndup_count	0
mem_strndup_count	0
mem_estrdup_count	0
mem_strdup_count	0
mem_edupl_count	0
mem_dupl_count	0
proto_text_fetched_null	0
proto_text_fetched_bit	0
proto_text_fetched_tinyint	0
proto_text_fetched_short	0
proto_text_fetched_int24	0
proto_text_fetched_int	0
proto_text_fetched_bigint	0
proto_text_fetched_decimal	0
proto_text_fetched_float	0
proto_text_fetched_double	0
proto_text_fetched_date	0
proto_text_fetched_year	0
proto_text_fetched_time	0
proto_text_fetched_datetime	0
proto_text_fetched_timestamp	0
proto_text_fetched_string	0
proto_text_fetched_blob	0
proto_text_fetched_enum	0
proto_text_fetched_set	0
proto_text_fetched_geometry	0
proto_text_fetched_other	0
proto_binary_fetched_null	0
proto_binary_fetched_bit	16
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	4841
proto_binary_fetched_int24	1741
proto_binary_fetched_int	0
proto_binary_fetched_bigint	9136
proto_binary_fetched_decimal	191
proto_binary_fetched_float	6
proto_binary_fetched_double	1197
proto_binary_fetched_date	0
proto_binary_fetched_year	0
proto_binary_fetched_time	0
proto_binary_fetched_datetime	0
proto_binary_fetched_timestamp	0
proto_binary_fetched_string	0
proto_binary_fetched_json	7467
proto_binary_fetched_blob	1353
proto_binary_fetched_enum	0
proto_binary_fetched_set	0
proto_binary_fetched_geometry	0
proto_binary_fetched_other	0
init_command_executed_count	0
init_command_failed_count	0
com_quit	0
com_init_db	0
com_query	2
com_field_list	0
com_create_db	0
com_drop_db	0
com_refresh	0
com_shutdown	0
com_statistics	0
com_process_info	0
com_connect	0
com_process_kill	0
com_debug	0
com_ping	0
com_time	0
com_delayed_insert	0
com_change_user	0
com_binlog_dump	0
com_table_dump	0
com_connect_out	0
com_register_slave	0
com_stmt_prepare	27
com_stmt_execute	27
com_stmt_send_long_data	0
com_stmt_close	26
com_stmt_reset	0
com_stmt_set_option	0
com_stmt_fetch	0
com_deamon	0
bytes_received_real_data_normal	0
bytes_received_real_data_ps	669589