Page Time: 0.0094s

Memory: 1.9273 MB (Peak: 1.9717 MB)

Queries (6, time: 0.0015s, 15.6%)

```
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
```
Run Time: 0.000531
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_data_registry ALL PRIMARY 51 Using where
1. XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 104
3. XF\Db\AbstractAdapter->fetchPairs() in /var/www/playconquer-forum/src/XF/DataRegistry.php at line 132
4. XF\DataRegistry->readFromDb() in /var/www/playconquer-forum/src/XF/DataRegistry.php at line 82
5. XF\DataRegistry->get() in /var/www/playconquer-forum/src/XF/App.php at line 1425
6. XF\App->preLoadData() in /var/www/playconquer-forum/src/XF/App.php at line 1415
7. XF\App->setup() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 45
8. XF\Pub\App->setup() in /var/www/playconquer-forum/src/XF.php at line 304
9. XF::setupApp() in /var/www/playconquer-forum/src/XF.php at line 316
10. XF::runApp() in /var/www/playconquer-forum/index.php at line 13
```
SELECT `xf_help_page`.*
FROM `xf_help_page`

WHERE (`xf_help_page`.`page_name` = 'terms')


LIMIT 1
```
Run Time: 0.000164
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_help_page const page_name page_name 152 const 1
1. XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1105
3. XF\Mvc\Entity\Finder->fetchOne() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 40
4. XF\Pub\Controller\Help->handleHelpPage() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 19
5. XF\Pub\Controller\Help->actionIndex() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
6. XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
7. XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
8. XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
9. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
10. XF::runApp() in /var/www/playconquer-forum/index.php at line 13
```
SELECT `xf_help_page`.*
FROM `xf_help_page`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_help_page`.`addon_id`)
WHERE (`xf_help_page`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_help_page`.`addon_id` = ''))
ORDER BY `xf_help_page`.`display_order` ASC
```
Run Time: 0.000226
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_help_page ALL 5 Using where; Using filesort
SIMPLE xf_addon_AddOn_1 eq_ref PRIMARY PRIMARY 52 forums.xf_help_page.addon_id 1 Using where
1. XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1138
3. XF\Mvc\Entity\Finder->fetch() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 68
4. XF\Pub\Controller\Help->addWrapperParams() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 59
5. XF\Pub\Controller\Help->handleHelpPage() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 19
6. XF\Pub\Controller\Help->actionIndex() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
7. XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
8. XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
9. XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
10. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
11. XF::runApp() in /var/www/playconquer-forum/index.php at line 13
```
-- 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\Help, Index, valid, page_name=terms%2F, 1614319837,
Run Time: 0.000107
1. XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Repository/SessionActivity.php at line 152
3. XF\Repository\SessionActivity->updateSessionActivity() in /var/www/playconquer-forum/src/XF/Pub/Controller/AbstractController.php at line 65
4. XF\Pub\Controller\AbstractController->updateSessionActivity() in /var/www/playconquer-forum/src/XF/Pub/Controller/AbstractController.php at line 40
5. XF\Pub\Controller\AbstractController->postDispatchType() in /var/www/playconquer-forum/src/XF/Mvc/Controller.php at line 241
6. XF\Mvc\Controller->postDispatch() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 254
7. XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
8. XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
9. XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
10. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
11. XF::runApp() in /var/www/playconquer-forum/index.php at line 13
```
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000256
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 /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 79
3. XF\Db\AbstractAdapter->fetchOne() in /var/www/playconquer-forum/src/XF/PermissionCache.php at line 35
4. XF\PermissionCache->getGlobalPerms() in /var/www/playconquer-forum/src/XF/PermissionSet.php at line 35
5. XF\PermissionSet->hasGlobalPermission() in /var/www/playconquer-forum/src/XF/Entity/User.php at line 848
6. XF\Entity\User->hasPermission() in /var/www/playconquer-forum/src/XF/Entity/User.php at line 473
7. XF\Entity\User->canSearch()
8. call_user_func_array() in /var/www/playconquer-forum/src/XF/Template/Templater.php at line 846
9. XF\Template\Templater->method() in /var/www/playconquer-forum/internal_data/code_cache/navigation_cache.php at line 221
10. XF\Pub\App->{closure}() in /var/www/playconquer-forum/src/XF/Template/Templater.php at line 5313
11. XF\Template\Templater->renderNavigationClosure() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 442
12. XF\Pub\App->getNavigation() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 398
13. XF\Pub\App->renderPageHtml() in /var/www/playconquer-forum/src/XF/App.php at line 1612
14. XF\App->renderPage() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 293
15. XF\Mvc\Dispatcher->render() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 44
16. XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
17. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
18. XF::runApp() in /var/www/playconquer-forum/index.php at line 13
```
-- XFDB=noForceAllWrite
INSERT INTO xf_session
	(session_id, session_data, expiry_date)
VALUES
	(?, ?, ?)
ON DUPLICATE KEY UPDATE
	session_data = VALUES(session_data),
	expiry_date = VALUES(expiry_date)
```
Params: oazHBQIkeeNkc86W1IBsKP936QcOvrWF, , 1614334237
Run Time: 0.000175
1. XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
2. XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Session/DbStorage.php at line 57
3. XF\Session\DbStorage->writeSession() in /var/www/playconquer-forum/src/XF/Session/Session.php at line 215
4. XF\Session\Session->save() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 343
5. XF\Pub\App->complete() in /var/www/playconquer-forum/src/XF/App.php at line 1780
6. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
7. XF::runApp() in /var/www/playconquer-forum/index.php at line 13

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_data_registry	ALL	PRIMARY				51	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_help_page	const	page_name	page_name	152	const	1

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_help_page	ALL					5	Using where; Using filesort
SIMPLE	xf_addon_AddOn_1	eq_ref	PRIMARY	PRIMARY	52	forums.xf_help_page.addon_id	1	Using where

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

Included Files (98, XenForo Classes: 69)

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/react/promise/src/functions_include.php
src/vendor/react/promise/src/functions.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/vendor/symfony/polyfill-mbstring/Mbstring.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/Http/Request.php
src/XF/InputFilterer.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/Data/Robot.php
src/XF/Mvc/Entity/Manager.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/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/XF/Mvc/RouteMatch.php
src/XF/Util/Arr.php
src/XF/Mvc/ParameterBag.php
src/XF/Pub/Controller/Help.php
src/XF/Pub/Controller/AbstractController.php
src/XF/Mvc/Controller.php
src/XF/Entity/HelpPage.php
src/XF/Mvc/Entity/Finder.php
src/XF/Mvc/Reply/View.php
src/XF/Mvc/Reply/AbstractReply.php
src/XF/Help/Terms.php
src/XF/Phrase.php
src/XF/Mvc/Reply/Redirect.php
src/XF/Repository/HelpPage.php
src/XF/Entity/AddOn.php
src/XF/Mvc/Entity/ArrayCollection.php
src/XF/Mvc/Entity/AbstractCollection.php
src/XF/Repository/SessionActivity.php
src/XF/Style.php
src/XF/Template/Templater.php
src/XF/SubContainer/BbCode.php
src/XF/SubContainer/AbstractSubContainer.php
src/XF/SubContainer/Widget.php
src/XF/SimpleCache.php
src/XF/Util/Php.php
src/XF/Http/Response.php
src/XF/Mvc/Renderer/Html.php
src/XF/Mvc/Renderer/AbstractRenderer.php
src/XF/Pub/View/Help/Page.php
src/XF/Mvc/View.php
internal_data/code_cache/templates/l1/s1/public/_help_page_terms.php
src/XF/Template/Template.php
internal_data/code_cache/templates/l1/s1/public/help_page.php
internal_data/code_cache/phrase_groups/l1/help_page_title.php
src/XF/PreEscaped.php
internal_data/code_cache/templates/l1/s1/public/metadata_macros.php
internal_data/code_cache/templates/l1/s1/public/help_wrapper.php
internal_data/code_cache/navigation_cache.php
src/XF/PermissionCache.php
src/XF/PermissionSet.php
src/XF/Pub/Route/Search.php
src/XF/NoticeList.php
internal_data/code_cache/templates/l1/s1/public/PAGE_CONTAINER.php
src/XF/Str/Formatter.php
internal_data/code_cache/templates/l1/s1/public/helper_js_global.php
internal_data/code_cache/templates/l1/s1/public/google_analytics.php
internal_data/code_cache/templates/l1/s1/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/s1/public/browser_warning_macros.php
internal_data/code_cache/templates/l1/s1/public/debug_macros.php
src/XF/Debugger.php

DB Connection Stats

bytes_sent	4267
bytes_received	86362
packets_sent	64
packets_received	193
protocol_overhead_in	772
protocol_overhead_out	256
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	144
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	84
bytes_received_prepare_response_packet	4934
bytes_received_change_user_packet	80894
packets_sent_command	31
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	16
packets_received_rset_field_meta	0
packets_received_rset_row	12
packets_received_prepare_response	100
packets_received_change_user	53
result_set_queries	8
non_result_set_queries	4
no_index_used	4
bad_index_used	0
slow_queries	0
buffered_sets	0
unbuffered_sets	0
ps_buffered_sets	8
ps_unbuffered_sets	0
flushed_normal_sets	0
flushed_ps_sets	0
ps_prepared_never_executed	0
ps_prepared_once_executed	9
rows_fetched_from_server_normal	0
rows_fetched_from_server_ps	45
rows_buffered_from_client_normal	0
rows_buffered_from_client_ps	45
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	45
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	14
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	12
proto_binary_fetched_int24	0
proto_binary_fetched_int	0
proto_binary_fetched_bigint	6
proto_binary_fetched_decimal	10
proto_binary_fetched_float	0
proto_binary_fetched_double	0
proto_binary_fetched_date	5
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	94
proto_binary_fetched_blob	34
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	10
com_stmt_execute	10
com_stmt_send_long_data	0
com_stmt_close	9
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	80419