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', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.175809
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 126
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1752
- XF\App->preLoadData() in src/XF/App.php at line 1740
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 363
- XF::setupApp() in src/XF.php at line 386
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000389
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 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 101
- 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 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
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` = '5633')
LIMIT 1
Run Time: 0.000850
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
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 src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1079
- XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 290
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user_follow`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_option_Option_3`.*
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_follow`.`follow_user_id` = 5633)
ORDER BY RAND() ASC
LIMIT 12
Run Time: 0.001501
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 309
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_follow`.`follow_user_id` = 5633)
Run Time: 0.000372
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 1 | Using index |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | Using index |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_follow.user_id | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 101
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Member.php at line 310
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
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` = 5633)
ORDER BY `xf_user_trophy`.`award_date` DESC
Run Time: 0.000418
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 | 1 | Using where; Using index |
SIMPLE | xf_trophy_Trophy_1 | eq_ref | PRIMARY | PRIMARY | 4 | user7041_forumbd.xf_user_trophy.trophy_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 316
- XF\Pub\Controller\Member->actionAbout() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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, "̵[, "̵[, XF\Pub\Controller\Member, About, valid, user_id=5633, 1695452383,
Run Time: 0.000174
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 7
Run Time: 0.000259
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 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 101
- 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 926
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 850
- XF\Entity\User->canReceiveConversation() in src/XF/Entity/User.php at line 830
- XF\Entity\User->canStartConversationWith()
- call_user_func_array() in src/XF/Template/Templater.php at line 978
- XF\Template\Templater->method() in internal_data/code_cache/templates/l5/s8/public/member_about.php at line 117
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
bytes_sent | 7293 |
bytes_received | 262535 |
packets_sent | 94 |
packets_received | 580 |
protocol_overhead_in | 2320 |
protocol_overhead_out | 376 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 297 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 103 |
bytes_received_prepare_response_packet | 32079 |
bytes_received_change_user_packet | 229642 |
packets_sent_command | 46 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 33 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 17 |
packets_received_prepare_response | 441 |
packets_received_change_user | 72 |
result_set_queries | 14 |
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 | 14 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 14 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 58 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 58 |
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 | 58 |
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_estndup_count | 0 |
mem_strdup_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 | 17 |
proto_binary_fetched_int24 | 5 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 26 |
proto_binary_fetched_decimal | 35 |
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 | 185 |
proto_binary_fetched_blob | 48 |
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 | 15 |
com_stmt_execute | 15 |
com_stmt_send_long_data | 0 |
com_stmt_close | 14 |
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 | 228941 |