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.001729
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 102
- XF\DataRegistry->get() in src/XF/App.php at line 2276
- XF\App->preLoadData() in src/XF/App.php at line 2261
- XF\App->setup() in src/XF/Pub/App.php at line 116
- XF\Pub\App->setup() in src/XF.php at line 775
- XF::setupApp() in src/XF.php at line 798
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000416
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 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1271
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 266
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 138
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 361
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = '49680')
LIMIT 1
Run Time: 0.000493
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | 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 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Controller.php at line 577
- XF\Mvc\Controller->assertRecordExistsByUnique() in src/XF/Mvc/Controller.php at line 557
- XF\Mvc\Controller->assertRecordExists() in src/addons/XFRM/Pub/Controller/Author.php at line 51
- XFRM\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_rm_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_rm_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_rm_category`.`resource_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
ORDER BY `xf_rm_category`.`lft` ASC
Run Time: 0.001130
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | ALL | | | | | 32 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category.resource_category_id | 1 | Using where |
- 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/AbstractCategoryTree.php at line 70
- XF\Repository\AbstractCategoryTree->getViewableCategories() in src/XF/Repository/AbstractCategoryTree.php at line 82
- XF\Repository\AbstractCategoryTree->getViewableCategoryIds() in src/addons/XFRM/Pub/Controller/Author.php at line 53
- XFRM\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT COUNT(*)
FROM `xf_rm_resource`
WHERE (`xf_rm_resource`.`user_id` = 49680) AND (`xf_rm_resource`.`resource_category_id` IN (32, 28, 31, 30, 29, 27, 23, 26, 25, 24, 2, 20, 15, 12, 4, 3, 11, 18, 19, 17, 8, 33, 14, 13, 10, 9, 5, 22, 21, 16, 7, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
Run Time: 0.000722
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | category_last_update,category_rating_weighted,user_id_last_update | user_id_last_update | 4 | const | 10 | 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 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1407
- XF\Mvc\Entity\Finder->total() in src/addons/XFRM/Pub/Controller/Author.php at line 78
- XFRM\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_rm_resource_version_CurrentVersion_2`.*, `xf_rm_category_Category_3`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_2` ON (`xf_rm_resource_version_CurrentVersion_2`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_3` ON (`xf_rm_category_Category_3`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
WHERE (`xf_rm_resource`.`user_id` = 49680) AND (`xf_rm_resource`.`resource_category_id` IN (32, 28, 31, 30, 29, 27, 23, 26, 25, 24, 2, 20, 15, 12, 4, 3, 11, 18, 19, 17, 8, 33, 14, 13, 10, 9, 5, 22, 21, 16, 7, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
ORDER BY `xf_rm_resource`.`last_update` DESC
LIMIT 20
Run Time: 0.001354
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | category_last_update,category_rating_weighted,user_id_last_update | user_id_last_update | 4 | const | 10 | Using where; Backward index scan |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_id | 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 1445
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/Pub/Controller/Author.php at line 86
- XFRM\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �I�
Run Time: 0.000191
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/SessionActivityRepository.php at line 133
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
bytes_sent | 6665 |
bytes_received | 858436 |
packets_sent | 90 |
packets_received | 692 |
protocol_overhead_in | 2768 |
protocol_overhead_out | 360 |
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 | 92 |
bytes_received_prepare_response_packet | 40953 |
bytes_received_change_user_packet | 816729 |
packets_sent_command | 43 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 25 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 16 |
packets_received_prepare_response | 524 |
packets_received_change_user | 109 |
result_set_queries | 14 |
non_result_set_queries | 2 |
no_index_used | 2 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 14 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 13 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 95 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 95 |
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 | 13 |
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 | 31 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 488 |
proto_binary_fetched_int24 | 173 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 892 |
proto_binary_fetched_decimal | 23 |
proto_binary_fetched_float | 8 |
proto_binary_fetched_double | 16 |
proto_binary_fetched_date | 11 |
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 | 423 |
proto_binary_fetched_blob | 305 |
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 | 14 |
com_stmt_execute | 14 |
com_stmt_send_long_data | 0 |
com_stmt_close | 13 |
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 | 814980 |