SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', '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.001023
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | 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 2092
- XF\App->preLoadData() in src/XF/App.php at line 2077
- XF\App->setup() in src/XF/Pub/App.php at line 95
- XF\Pub\App->setup() in src/XF.php at line 505
- XF::setupApp() in src/XF.php at line 528
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000101
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/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/Misc.php at line 733
- XF\Pub\Controller\Misc->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 129
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_liamw_accountdelete_account_deletions`.*, `xf_user_User_1`.*
FROM `xf_liamw_accountdelete_account_deletions`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_liamw_accountdelete_account_deletions`.`user_id`)
WHERE (`xf_liamw_accountdelete_account_deletions`.`user_id` = 0) AND (`xf_liamw_accountdelete_account_deletions`.`status` = 'pending')
LIMIT 1
Run Time: 0.000229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liamw_accountdelete_account_deletions | ref | user_id | user_id | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | 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/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 392
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 415
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 207
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 130
- XF\Mvc\Entity\Entity->__get() in src/addons/LiamW/AccountDelete/Listener.php at line 43
- LiamW\AccountDelete\Listener::controllerPreDispatch() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 3134
- XF\App->fire() in src/XF/Mvc/Controller.php at line 131
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_language`.*
FROM `xf_language`
ORDER BY `xf_language`.`language_id` ASC
Run Time: 0.000164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_language | index | | PRIMARY | 4 | | 2 | |
- 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/Language.php at line 37
- XF\Repository\Language->getLanguageTree() in src/XF/Repository/Language.php at line 54
- XF\Repository\Language->getUserSelectableLanguages() in src/XF/Pub/Controller/Misc.php at line 220
- XF\Pub\Controller\Misc->actionLanguage() 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 2592
- XF\App->run() in src/XF.php at line 532
- 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.000314
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | 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 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: �+�, XF\Pub\Controller\Misc, Language, valid, , 1714692946, anthropic, 0, �+�
Run Time: 0.000326
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
bytes_sent | 4094 |
bytes_received | 1479470 |
packets_sent | 70 |
packets_received | 386 |
protocol_overhead_in | 1544 |
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 | 19063 |
bytes_received_change_user_packet | 1459769 |
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 | 277 |
packets_received_change_user | 58 |
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 | 48 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 48 |
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 | 0 |
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 | 9 |
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 | 3 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 4 |
proto_binary_fetched_int24 | 0 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 4 |
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 | 122 |
proto_binary_fetched_blob | 42 |
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 | 1459215 |