Page Time: 0.0130s

Memory: 1.9221 MB (Peak: 1.9225 MB)

Queries (6, time: 0.0024s, 18.4%)

```
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.000716
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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000232
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/Pub/Controller/AbstractController.php at line 224
7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in /var/www/playconquer-forum/src/XF/Pub/Controller/AbstractController.php at line 20
8. XF\Pub\Controller\AbstractController->preDispatchType() in /var/www/playconquer-forum/src/XF/Mvc/Controller.php at line 88
9. XF\Mvc\Controller->preDispatch() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 231
10. XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
11. XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
12. XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
13. XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
14. 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_permission_combination	const	PRIMARY	PRIMARY	4	const	1

SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT 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` = '3240')


LIMIT 1

Run Time: 0.000623

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows
SIMPLE	xf_user	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	xf_user_option_Option_1	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	xf_user_privacy_Privacy_2	const	PRIMARY	PRIMARY	4	const	1
SIMPLE	xf_user_profile_Profile_3	const	PRIMARY	PRIMARY	4	const	1

XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1105
XF\Mvc\Entity\Finder->fetchOne() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Manager.php at line 131
XF\Mvc\Entity\Manager->find() in /var/www/playconquer-forum/src/XF/Pub/Controller/Member.php at line 1022
XF\Pub\Controller\Member->assertViewableUser() in /var/www/playconquer-forum/src/XF/Pub/Controller/Member.php at line 918
XF\Pub\Controller\Member->actionTrophies() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
XF::runApp() in /var/www/playconquer-forum/index.php at line 13

SELECT `xf_user_trophy`.*, `xf_trophy_Trophy_1`.*
FROM `xf_user_trophy`
LEFT JOIN `xf_trophy` AS `xf_trophy_Trophy_1` ON (`xf_trophy_Trophy_1`.`trophy_id` = `xf_user_trophy`.`trophy_id`)
WHERE (`xf_user_trophy`.`user_id` = 3240)
ORDER BY `xf_user_trophy`.`award_date` DESC

Run Time: 0.000318

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_user_trophy	ref	user_id_award_date	user_id_award_date	4	const	2	Using where; Using index
SIMPLE	xf_trophy_Trophy_1	eq_ref	PRIMARY	PRIMARY	4	forums.xf_user_trophy.trophy_id	1

XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1138
XF\Mvc\Entity\Finder->fetch() in /var/www/playconquer-forum/src/XF/Pub/Controller/Member.php at line 929
XF\Pub\Controller\Member->actionTrophies() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
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\Member, Trophies, valid, user_id=3240, 1611653776,
Run Time: 0.000190
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
```
-- 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: Lt-RnC53_Aj1JhrI4Mizw-_uCs8LsdXH, , 1611668176
Run Time: 0.000311
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

Included Files (95, XenForo Classes: 67)

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/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/Finder/User.php
src/XF/Mvc/Entity/Finder.php
src/XF/Repository/Trophy.php
src/XF/Entity/UserTrophy.php
src/XF/Entity/Trophy.php
src/XF/Mvc/Entity/ArrayCollection.php
src/XF/Mvc/Entity/AbstractCollection.php
src/XF/Mvc/Reply/View.php
src/XF/Mvc/Reply/AbstractReply.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/Http/Response.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/s1/public/member_trophies.php
src/XF/PreEscaped.php
src/XF/Phrase.php
internal_data/code_cache/phrase_groups/l1/trophy_title.php
internal_data/code_cache/phrase_groups/l1/trophy_description.php
internal_data/code_cache/navigation_cache.php
src/XF/Pub/Route/Search.php
src/XF/NoticeList.php
internal_data/code_cache/templates/l1/s1/public/PAGE_CONTAINER.php
internal_data/code_cache/templates/l1/s1/public/metadata_macros.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	5078
bytes_received	96268
packets_sent	64
packets_received	303
protocol_overhead_in	1212
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	14342
bytes_received_change_user_packet	81392
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	210
packets_received_change_user	53
result_set_queries	8
non_result_set_queries	4
no_index_used	2
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	17
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	16
proto_binary_fetched_int24	5
proto_binary_fetched_int	0
proto_binary_fetched_bigint	29
proto_binary_fetched_decimal	16
proto_binary_fetched_float	0
proto_binary_fetched_double	0
proto_binary_fetched_date	8
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	105
proto_binary_fetched_blob	44
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	80891