Page Time: 0.0969s

Memory: 13.2432 MB (Peak: 14.6466 MB)

Queries (5, time: 0.0139s, 14.3%)

```
SELECT `xf_help_page`.*
FROM `xf_help_page`

WHERE (`xf_help_page`.`page_name` = 'bb-codes')


LIMIT 1
```
Run Time: 0.013083
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 src/XF/Db/AbstractAdapter.php at line 94
2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Help.php at line 57
4. XF\Pub\Controller\Help->handleHelpPage() in src/XF/Pub/Controller/Help.php at line 19
5. XF\Pub\Controller\Help->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
10. XF\App->run() in src/XF.php at line 391
11. XF::runApp() in index.php at line 20
```
SELECT `xf_bb_code`.*
FROM `xf_bb_code`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_bb_code`.`addon_id`)
WHERE (`xf_bb_code`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_bb_code`.`addon_id` = ''))
ORDER BY `xf_bb_code`.`bb_code_id` ASC
```
Run Time: 0.000222
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_bb_code index PRIMARY 27 1 Using where
SIMPLE xf_addon_AddOn_1 eq_ref PRIMARY PRIMARY 52 xenforo.xf_bb_code.addon_id 1 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/Mvc/Entity/Finder.php at line 1294
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Help/BbCodes.php at line 13
4. XF\Help\BbCodes::renderBbCodes()
5. call_user_func_array() in src/XF/Pub/Controller/Help.php at line 73
6. XF\Pub\Controller\Help->handleHelpPage() in src/XF/Pub/Controller/Help.php at line 19
7. XF\Pub\Controller\Help->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
12. XF\App->run() in src/XF.php at line 391
13. XF::runApp() in index.php at line 20
```
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.000206
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_help_page ALL 6 Using where; Using filesort
SIMPLE xf_addon_AddOn_1 eq_ref PRIMARY PRIMARY 52 xenforo.xf_help_page.addon_id 1 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/Mvc/Entity/Finder.php at line 1294
3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Help.php at line 85
4. XF\Pub\Controller\Help->addWrapperParams() in src/XF/Pub/Controller/Help.php at line 76
5. XF\Pub\Controller\Help->handleHelpPage() in src/XF/Pub/Controller/Help.php at line 19
6. XF\Pub\Controller\Help->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
11. XF\App->run() in src/XF.php at line 391
12. 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, x, x, XF\Pub\Controller\Help, Index, valid, page_name=bb-codes%2F, 1714062061,
Run Time: 0.000118
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 383
7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
11. XF\App->run() in src/XF.php at line 391
12. XF::runApp() in index.php at line 20
```
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
```
Params: 1
Run Time: 0.000245
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/Entity/User.php at line 559
7. XF\Entity\User->canSearch()
8. call_user_func_array() in src/XF/Template/Templater.php at line 999
9. XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 211
10. XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6660
11. XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
12. XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
13. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2001
14. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
17. XF\App->run() in src/XF.php at line 391
18. XF::runApp() in index.php at line 20

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_bb_code	index		PRIMARY	27		1	Using where
SIMPLE	xf_addon_AddOn_1	eq_ref	PRIMARY	PRIMARY	52	xenforo.xf_bb_code.addon_id	1	Using where

Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
SIMPLE	xf_help_page	ALL					6	Using where; Using filesort
SIMPLE	xf_addon_AddOn_1	eq_ref	PRIMARY	PRIMARY	52	xenforo.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 (166, XenForo Classes: 83)

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/autoload-php7.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/CacheFactory.php
src/XF/Cache/RedisCache.php
src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/RedisCache.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/addons/ThemeHouse/UIX/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/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/Db/Mysqli/Statement.php
src/XF/Db/AbstractStatement.php
src/XF/Mvc/Reply/View.php
src/XF/Mvc/Reply/AbstractReply.php
src/XF/Help/BbCodes.php
src/XF/Repository/BbCode.php
src/XF/Entity/BbCode.php
src/XF/Entity/AddOn.php
src/XF/Mvc/Entity/ArrayCollection.php
src/XF/Mvc/Entity/AbstractCollection.php
src/XF/Repository/HelpPage.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/Nodes/Listener/TemplaterSetup.php
src/addons/ThemeHouse/UIX/Listener/TemplaterSetup.php
src/XF/SimpleCache.php
src/XF/Util/Php.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/s5/public/_help_page_bb_codes.php
src/XF/PreEscaped.php
src/XF/BbCode/Parser.php
src/XF/BbCode/RuleSet.php
src/XF/BbCode/Renderer/Html.php
src/XF/BbCode/Renderer/AbstractRenderer.php
src/XF/BbCode/Traverser.php
src/XF/Str/Formatter.php
src/XF/Str/EmojiFormatter.php
src/vendor/emojione/emojione/lib/php/src/Client.php
src/vendor/emojione/emojione/lib/php/src/ClientInterface.php
src/vendor/emojione/emojione/lib/php/src/Ruleset.php
src/vendor/emojione/emojione/lib/php/src/RulesetInterface.php
src/XF/SubContainer/Proxy.php
src/XF/Proxy/Linker.php
internal_data/code_cache/templates/l1/s5/public/bb_code_tag_img.php
internal_data/code_cache/templates/l1/s5/public/lightbox_macros.php
internal_data/code_cache/templates/l1/s5/public/bb_code_tag_quote.php
internal_data/code_cache/templates/l1/s5/public/bb_code_tag_spoiler.php
src/XF/Data/CodeLanguage.php
src/XF/Phrase.php
internal_data/code_cache/templates/l1/s5/public/bb_code_tag_code.php
internal_data/code_cache/templates/l1/s5/public/prism_macros.php
internal_data/code_cache/phrase_groups/l1/code_language.php
internal_data/code_cache/phrase_groups/l1/custom_bb_code_example.php
src/XF/Template/Template.php
internal_data/code_cache/templates/l1/s5/public/help_page.php
internal_data/code_cache/phrase_groups/l1/help_page_title.php
internal_data/code_cache/templates/l1/s5/public/metadata_macros.php
internal_data/code_cache/phrase_groups/l1/help_page_desc.php
internal_data/code_cache/templates/l1/s5/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
src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php
src/addons/ThemeHouse/UIX/Util/UIX.php
src/addons/ThemeHouse/UIX/Listener/Pub/TemplaterTemplatePreRender.php
internal_data/code_cache/templates/l1/s5/public/PAGE_CONTAINER.php
internal_data/code_cache/phrase_groups/l1/button.php
internal_data/code_cache/templates/l1/s5/public/uix_socialMedia.php
internal_data/code_cache/phrase_groups/l1/nav.php
internal_data/code_cache/templates/l1/s5/public/_ads.php
internal_data/code_cache/templates/l1/s5/public/uix_extendedFooter.php
src/addons/ThemeHouse/Core/Branding.php
src/addons/ThemeHouse/Core/Branding/20180420.php
internal_data/code_cache/templates/l1/s5/public/debug_macros.php
internal_data/code_cache/templates/l1/s5/public/helper_js_global.php
internal_data/code_cache/templates/l1/s5/public/font_awesome_setup.php
internal_data/code_cache/templates/l1/s5/public/google_analytics.php
internal_data/code_cache/templates/l1/s5/public/page_style.php
internal_data/code_cache/templates/l1/s5/public/uix_welcomeSection.php
internal_data/code_cache/templates/l1/s5/public/uix_canvasTabs.php
internal_data/code_cache/templates/l1/s5/public/uix_canvasPanels.php
internal_data/code_cache/templates/l1/s5/public/browser_warning_macros.php
internal_data/code_cache/templates/l1/s5/public/uix_config.php
src/addons/ThemeHouse/UIX/Listener/Pub/TemplaterMacroPreRender.php
internal_data/code_cache/templates/l1/s5/public/uix_js.php
internal_data/code_cache/phrase_groups/l1/reaction_title.php
src/XF/Debugger.php

DB Connection Stats

bytes_sent	3072
bytes_received	12539
packets_sent	58
packets_received	229
protocol_overhead_in	916
protocol_overhead_out	232
bytes_received_ok_packet	0
bytes_received_eof_packet	0
bytes_received_rset_header_packet	171
bytes_received_rset_field_meta_packet	0
bytes_received_rset_row_packet	73
bytes_received_prepare_response_packet	8715
bytes_received_change_user_packet	3270
packets_sent_command	28
packets_received_ok	0
packets_received_eof	0
packets_received_rset_header	19
packets_received_rset_field_meta	0
packets_received_rset_row	11
packets_received_prepare_response	165
packets_received_change_user	23
result_set_queries	8
non_result_set_queries	3
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	8
rows_fetched_from_server_normal	0
rows_fetched_from_server_ps	15
rows_buffered_from_client_normal	0
rows_buffered_from_client_ps	15
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	15
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	6
proto_binary_fetched_tinyint	0
proto_binary_fetched_short	22
proto_binary_fetched_int24	0
proto_binary_fetched_int	0
proto_binary_fetched_bigint	7
proto_binary_fetched_decimal	6
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	91
proto_binary_fetched_blob	5
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	9
com_stmt_execute	9
com_stmt_send_long_data	0
com_stmt_close	8
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	3035