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', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.005889
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- 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 1888
- XF\App->preLoadData() in src/XF/App.php at line 1876
- XF\App->setup() in src/XF/Pub/App.php at line 91
- XF\Pub\App->setup() in src/XF.php at line 461
- XF::setupApp() in src/XF.php at line 484
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000414
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 242
- 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 349
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_member_stat`.*
FROM `xf_member_stat`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_member_stat`.`addon_id`)
WHERE (`xf_member_stat`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_member_stat`.`addon_id` = ''))
ORDER BY `xf_member_stat`.`display_order` ASC
Run Time: 0.000660
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_member_stat | ALL | | | | | 7 | Using where; Using filesort |
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | xf2_slions_net.xf_member_stat.addon_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 58
- XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT user_id
FROM xf_user
WHERE question_solution_count > 0
LIMIT 1
Run Time: 0.000284
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | question_solution_count | question_solution_count | 4 | | 1 | Using where; Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/MemberStat/Solutions.php at line 9
- XF\MemberStat\Solutions::isVisible()
- call_user_func_array() in src/XF/Entity/MemberStat.php at line 58
- XF\Entity\MemberStat->canView() in src/XF/Mvc/Entity/AbstractCollection.php at line 320
- XF\Mvc\Entity\AbstractCollection->XF\Mvc\Entity\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 189
- XF\Mvc\Entity\AbstractCollection->filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 321
- XF\Mvc\Entity\AbstractCollection->filterViewable() in src/XF/Pub/Controller/Member.php at line 59
- XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT user_id
FROM xf_user
WHERE question_solution_count > 0
LIMIT 1
Run Time: 0.000322
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | question_solution_count | question_solution_count | 4 | | 1 | Using where; Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/MemberStat/Solutions.php at line 9
- XF\MemberStat\Solutions::isVisible()
- call_user_func_array() in src/XF/Entity/MemberStat.php at line 58
- XF\Entity\MemberStat->canView() in src/XF/Pub/Controller/Member.php at line 74
- XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`question_solution_count` > 0) OR (`xf_user`.`question_solution_count` < 0))
ORDER BY `xf_user`.`question_solution_count` DESC
LIMIT 60
Run Time: 0.000969
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | user_state,question_solution_count | question_solution_count | 4 | | 1 | Using index condition; Using where; Backward index scan |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/Preparer.php at line 234
- XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 101
- XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 122
- XF\Entity\MemberStat->getResults() in src/XF/Pub/Controller/Member.php at line 79
- XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (1)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.000964
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY,user_state | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 86
- XF\Pub\Controller\Member->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- 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, Index, valid, , 1702329514,
Run Time: 0.000656
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- 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 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`register_date` DESC
LIMIT 12
Run Time: 0.001233
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | index | user_state | register_date | 4 | | 12 | Using where; Backward index scan |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewestMembers.php at line 24
- XF\Widget\NewestMembers->render() in internal_data/code_cache/widgets/_2_member_wrapper_newest_members.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7405
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1901
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s15/public/member_wrapper.php at line 39
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1023
- XF\Template\Templater->applyWrappedTemplate() in src/XF/Template/Templater.php at line 1641
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2326
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
bytes_sent | 6321 |
bytes_received | 450365 |
packets_sent | 106 |
packets_received | 623 |
protocol_overhead_in | 2492 |
protocol_overhead_out | 424 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 243 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 113 |
bytes_received_prepare_response_packet | 34641 |
bytes_received_change_user_packet | 414910 |
packets_sent_command | 52 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 27 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 19 |
packets_received_prepare_response | 469 |
packets_received_change_user | 89 |
result_set_queries | 16 |
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 | 16 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 16 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 73 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 73 |
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 | 73 |
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 | 31 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 130 |
proto_binary_fetched_int24 | 71 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 336 |
proto_binary_fetched_decimal | 22 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
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 | 305 |
proto_binary_fetched_blob | 57 |
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 | 17 |
com_stmt_execute | 17 |
com_stmt_send_long_data | 0 |
com_stmt_close | 16 |
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 | 413904 |