Page Time: 0.0600s

Memory: 3.7126 MB (Peak: 3.8126 MB)

Queries (11, time: 0.0180s, 30.0%)

```
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000212
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 96
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1218
6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
14. XF\App->run() in src/XF.php at line 525
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.000527

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	sammyboy_xenforo.xf_member_stat.addon_id	1	Using where

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 60
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 525
XF::runApp() in index.php at line 20

```
SELECT user_id
FROM xf_user
WHERE question_solution_count > 0
LIMIT 1
```
Run Time: 0.000283
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user range question_solution_count question_solution_count 4 1 Using where; Using index
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
3. XF\Db\AbstractAdapter->fetchOne() in src/XF/MemberStat/Solutions.php at line 11
4. XF\MemberStat\Solutions::isVisible() in src/XF/Entity/MemberStat.php at line 60
5. XF\Entity\MemberStat->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 328
6. XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
7. array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
8. XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 329
9. XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Pub/Controller/Member.php at line 61
10. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
15. XF\App->run() in src/XF.php at line 525
16. XF::runApp() in index.php at line 20
```
SELECT `xf_user`.*
FROM `xf_user`

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.001449
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user range user_state,message_count message_count 4 24515 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 235
4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
12. XF\App->run() in src/XF.php at line 525
13. XF::runApp() in index.php at line 20
```
SELECT `xf_user`.*
FROM `xf_user`

WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`reaction_score` > 0) OR (`xf_user`.`reaction_score` < 0))
ORDER BY `xf_user`.`reaction_score` DESC

LIMIT 60
```
Run Time: 0.001482
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user range user_state,reaction_score reaction_score 4 4348 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 235
4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
12. XF\App->run() in src/XF.php at line 525
13. XF::runApp() in index.php at line 20
```
SELECT `xf_user`.*
FROM `xf_user`

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.001482
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user range user_state,trophy_points trophy_points 4 2787 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 235
4. XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
5. XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
6. XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
7. XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
12. XF\App->run() in src/XF.php at line 525
13. XF::runApp() in index.php at line 20

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	question_solution_count	question_solution_count	4		1	Using where; Using index

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,message_count	message_count	4		24515	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,reaction_score	reaction_score	4		4348	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	user_state,trophy_points	trophy_points	4		2787	Using where

SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_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`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 27) AND (`xf_user_profile_Profile_1`.`dob_month` = 4) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1682674831) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`username` ASC

LIMIT 60

Run Time: 0.006285

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user_profile_Profile_1	ref	PRIMARY,dob	dob	2	const,const	116	Using temporary; Using filesort
SIMPLE	xf_user_option_Option_2	eq_ref	PRIMARY	PRIMARY	4	sammyboy_xenforo.xf_user_profile_Profile_1.user_id	1	Using where
SIMPLE	xf_user	eq_ref	PRIMARY,user_state,last_activity	PRIMARY	4	sammyboy_xenforo.xf_user_profile_Profile_1.user_id	1	Using where

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
XF\Mvc\Entity\Finder->fetch() in src/XF/MemberStat/Birthdays.php at line 14
XF\MemberStat\Birthdays::getBirthdayUsers() in src/XF/Service/MemberStat/Preparer.php at line 139
XF\Service\MemberStat\Preparer->applyCallback() in src/XF/Service/MemberStat/Preparer.php at line 202
XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 124
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 525
XF::runApp() in index.php at line 20

SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (14573, 181510, 185567, 185534, 182712, 181869, 177876, 176669, 176032, 174190, 172438, 170908, 166557, 165609, 165533, 164212, 163593, 163575, 163523, 162858, 162383, 162170, 161339, 160973, 160601, 159698, 159369, 159309, 159215, 158612, 158588, 158366, 158299, 157843, 157200, 157076, 156941, 156871, 156613, 155762, 155361, 154213, 153578, 153115, 119256, 117941, 115640, 111836, 107473, 107284, 107196, 107194, 107029, 106490, 106375, 105978, 105498, 105465, 94302, 93722, 89835, 89822, 89736, 16248, 2710, 977, 64347, 1775, 1, 278, 4371, 5250, 48502, 2522, 6083, 1299, 3679, 16966, 1159, 26351, 31356, 2686, 12757, 26707, 2612, 4592, 2856, 11934, 1165, 2617, 38122, 7139, 15229, 67756, 2174, 5994, 1317, 23219, 25152, 1011, 2102, 16778, 3229, 1737, 1572, 1288, 73, 2036, 2642, 1139, 3098, 2255, 143, 2115, 81517, 9902, 1168, 34973, 24669, 7975, 28316, 1478, 8492)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')

Run Time: 0.004600

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	range	PRIMARY,user_state	PRIMARY	4		123	Using where
SIMPLE	xf_user_profile_Profile_2	eq_ref	PRIMARY	PRIMARY	4	sammyboy_xenforo.xf_user.user_id	1
SIMPLE	xf_user_option_Option_1	eq_ref	PRIMARY	PRIMARY	4	sammyboy_xenforo.xf_user.user_id	1

XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 134
XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
XF\App->run() in src/XF.php at line 525
XF::runApp() in index.php at line 20

```
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
```
Params: 0,
Run Time: 0.000204
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_session_activity const PRIMARY PRIMARY 22 const,const 1
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
5. xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
6. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
7. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
8. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
13. XF\App->run() in src/XF.php at line 525
14. XF::runApp() in index.php at line 20
```
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
	ip = ?,
	controller_name = ?,
	controller_action = ?,
	view_state = ?,
	params = ?,
	view_date = ?,
	robot_key = ?
WHERE user_id = ? AND unique_key = ?
```
Params: , XF\Pub\Controller\Member, Index, valid, , 1714210831, , 0,
Run Time: 0.000154
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
3. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
4. xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
12. XF\App->run() in src/XF.php at line 525
13. XF::runApp() in index.php at line 20
```
SELECT `xf_user`.*
FROM `xf_user`

WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`register_date` DESC

LIMIT 12
```
Run Time: 0.001310
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_user index user_state register_date 4 24 Using where
1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewestMembers.php at line 24
4. XF\Widget\NewestMembers->render() in internal_data/code_cache/widgets/_2_member_wrapper_newest_members.php at line 5
5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7679
6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1937
8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/member_wrapper.php at line 39
9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1652
10. XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1049
11. XF\Template\Templater->applyWrappedTemplate() in src/XF/Template/Templater.php at line 1667
12. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
13. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
19. XF\App->run() in src/XF.php at line 525
20. XF::runApp() in index.php at line 20

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_session_activity	const	PRIMARY	PRIMARY	22	const,const	1

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user	index	user_state	register_date	4		24	Using where

Included Files (167, XenForo Classes: 98)

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/laminas/laminas-zendframework-bridge/src/autoload.php
src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
src/vendor/symfony/polyfill-php72/bootstrap.php
src/vendor/symfony/polyfill-intl-idn/bootstrap.php
src/vendor/symfony/polyfill-mbstring/bootstrap.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/autoload-php7.php
src/vendor/paragonie/sodium_compat/src/Compat.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/lib/php72compat_const.php
src/vendor/paragonie/sodium_compat/lib/php72compat.php
src/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
src/vendor/paragonie/sodium_compat/lib/ristretto255.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/CacheFactory.php
src/XF/Cache/MemcachedCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MemcachedCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
src/XF/Extension.php
src/XF/AddOn/Manager.php
src/XF/Session/Session.php
src/XF/Session/CacheStorage.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/XF/Entity/LinkableInterface.php
src/addons/xenMade/LAU/XF/Entity/User.php
src/XF/Mvc/Entity/Structure.php
src/XF/Entity/UserAuth.php
src/XF/Entity/UserOption.php
src/XF/Entity/UserProfile.php
src/XF/Entity/UserPrivacy.php
src/XF/Util/File.php
src/XF/Language.php
src/XF/Mvc/Dispatcher.php
src/XF/Mvc/Router.php
src/addons/XF301VB/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/Db/Mysqli/Statement.php
src/XF/Db/AbstractStatement.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/MemberStat/TrophyPoints.php
src/XF/MemberStat/Solutions.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/XF/MemberStat/Birthdays.php
src/XF/Mvc/Reply/View.php
src/XF/Mvc/Reply/AbstractReply.php
src/XF/Repository/SessionActivity.php
src/addons/xenMade/LAU/XF/Repository/SessionActivity.php
src/XF/Data/Robot.php
src/XF/Style.php
src/XF/Template/Templater.php
src/addons/xenMade/LAU/XF/Template/Templater.php
src/XF/DevelopmentOutput.php
src/XF/DevelopmentOutput/Template.php
src/XF/DevelopmentOutput/AbstractHandler.php
src/XF/Template/WatcherInterface.php
src/XF/SubContainer/BbCode.php
src/XF/SubContainer/AbstractSubContainer.php
src/XF/SubContainer/Widget.php
src/XF/CookieConsent.php
src/XF/Captcha/HCaptcha.php
src/XF/Captcha/AbstractCaptcha.php
src/XF/Repository/Payment.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/s7/public/member_notable.php
src/XF/PreEscaped.php
internal_data/code_cache/templates/l1/s7/public/metadata_macros.php
src/XF/Template/MacroState.php
internal_data/code_cache/phrase_groups/l1/member_stat.php
src/XF/Util/Color.php
internal_data/code_cache/templates/l1/s7/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/s7/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/s7/public/widget_newest_members.php
internal_data/code_cache/navigation_cache.php
src/XF/Pub/Route/Search.php
src/XF/NoticeList.php
src/XF/Criteria/User.php
src/XF/Criteria/AbstractCriteria.php
src/XF/Criteria/Page.php
internal_data/code_cache/templates/l1/s7/public/PAGE_CONTAINER.php
src/XF/Str/Formatter.php
internal_data/code_cache/templates/l1/s7/public/helper_js_global.php
internal_data/code_cache/templates/l1/s7/public/font_awesome_setup.php
internal_data/code_cache/templates/l1/s7/public/google_analytics.php
internal_data/code_cache/templates/l1/s7/public/lau_staff_bar.php
internal_data/code_cache/templates/l1/s7/public/_ads.php
internal_data/code_cache/phrase_groups/l1/nav.php
internal_data/code_cache/phrase_groups/l1/button.php
internal_data/code_cache/templates/l1/s7/public/notice_macros.php
internal_data/code_cache/templates/l1/s7/public/browser_warning_macros.php
internal_data/code_cache/templates/l1/s7/public/debug_macros.php
src/XF/Debugger.php

DB Connection Stats

bytes_sent	9066
bytes_received	201931
packets_sent	130
packets_received	1326
protocol_overhead_in	5304
protocol_overhead_out	520
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	405
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	174
bytes_received_prepare_response_packet	64701
bytes_received_change_user_packet	136111
packets_sent_command	64
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	45
packets_received_rset_field_meta	0
packets_received_rset_row	23
packets_received_prepare_response	875
packets_received_change_user	360
result_set_queries	20
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	20
ps_unbuffered_sets	0
flushed_normal_sets	0
flushed_ps_sets	0
ps_prepared_never_executed	0
ps_prepared_once_executed	20
rows_fetched_from_server_normal	0
rows_fetched_from_server_ps	340
rows_buffered_from_client_normal	0
rows_buffered_from_client_ps	340
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	340
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	308
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	3492
proto_binary_fetched_int24	1710
proto_binary_fetched_int	0
proto_binary_fetched_bigint	6948
proto_binary_fetched_decimal	30
proto_binary_fetched_float	0
proto_binary_fetched_double	0
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	3517
proto_binary_fetched_blob	1133
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	21
com_stmt_execute	21
com_stmt_send_long_data	0
com_stmt_close	20
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	127149