SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.001153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 40 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 99
- XF\DataRegistry->get() in src/XF/App.php at line 2103
- XF\App->preLoadData() in src/XF/App.php at line 2088
- XF\App->setup() in src/XF/Pub/App.php at line 95
- XF\Pub\App->setup() in src/XF.php at line 506
- XF::setupApp() in src/XF.php at line 529
- XF::runApp() in index.php at line 20
SELECT `xf_connected_account_provider`.*
FROM `xf_connected_account_provider`
ORDER BY `xf_connected_account_provider`.`display_order` ASC
Run Time: 0.000093
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_connected_account_provider | ALL | | | | | 9 | Using filesort |
- 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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/ConnectedAccount.php at line 32
- XF\Repository\ConnectedAccount->getUsableProviders() in src/XF/Pub/Controller/Login.php at line 31
- XF\Pub\Controller\Login->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 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1244
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 636
- XF\Entity\User->canSearch() in src/XF/Template/Templater.php at line 1259
- XF\Template\Templater->method() in internal_data/code_cache/navigation_cache.php at line 297
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 8093
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 603
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 554
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2379
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT `xf_addon`.*
FROM `xf_addon`
WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
LIMIT 1
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 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 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
- Tapatalk\Listener\Hook::templateHook() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 3146
- XF\App->fire() in src/XF/Template/Templater.php at line 1719
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 590
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2379
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('mh_strip_visited_thread')
Params: 2
Run Time: 0.000086
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 391
- XF\Language->loadPhrases() in src/XF/Language.php at line 278
- XF\Language->getPhraseText() in src/XF/Language.php at line 135
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/Phrase.php at line 61
- XF\Phrase->__toString()
- preg_replace() in src/addons/MMO/Hide/Data/HideTags.php at line 47
- MMO\Hide\Data\HideTags->stripHideTags() in src/addons/MMO/Hide/XF/Str/Formatter.php at line 44
- MMO\Hide\XF\Str\Formatter->snippetString() in src/XF/Template/Templater.php at line 4388
- XF\Template\Templater->fnSnippet() in src/XF/Template/Templater.php at line 1196
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/metadata_macros.php at line 121
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 898
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/PAGE_CONTAINER.php at line 417
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 590
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2379
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
-- 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: aXBpCpPfNyc0yAH1IJx1GO03jfSeoyJK, , 1715240020
Run Time: 0.008368
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 221
- XF\Session\Session->save() in src/XF/Pub/App.php at line 486
- XF\Pub\App->complete() in src/XF/App.php at line 2607
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
bytes_sent | 3864 |
bytes_received | 1571740 |
packets_sent | 70 |
packets_received | 261 |
protocol_overhead_in | 1044 |
protocol_overhead_out | 280 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 225 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 83 |
bytes_received_prepare_response_packet | 6727 |
bytes_received_change_user_packet | 1564375 |
packets_sent_command | 34 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 25 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 13 |
packets_received_prepare_response | 143 |
packets_received_change_user | 67 |
result_set_queries | 10 |
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 | 10 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 10 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 57 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 57 |
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 | 57 |
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 | 3 |
proto_binary_fetched_int24 | 9 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1 |
proto_binary_fetched_decimal | 5 |
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 | 103 |
proto_binary_fetched_blob | 51 |
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 | 11 |
com_stmt_execute | 11 |
com_stmt_send_long_data | 0 |
com_stmt_close | 10 |
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 | 1563785 |