SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000531
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 51 | Using where |
- XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 104
- XF\Db\AbstractAdapter->fetchPairs() in /var/www/playconquer-forum/src/XF/DataRegistry.php at line 132
- XF\DataRegistry->readFromDb() in /var/www/playconquer-forum/src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in /var/www/playconquer-forum/src/XF/App.php at line 1425
- XF\App->preLoadData() in /var/www/playconquer-forum/src/XF/App.php at line 1415
- XF\App->setup() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in /var/www/playconquer-forum/src/XF.php at line 304
- XF::setupApp() in /var/www/playconquer-forum/src/XF.php at line 316
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
SELECT `xf_help_page`.*
FROM `xf_help_page`
WHERE (`xf_help_page`.`page_name` = 'terms')
LIMIT 1
Run Time: 0.000164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | const | page_name | page_name | 152 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1105
- XF\Mvc\Entity\Finder->fetchOne() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 40
- XF\Pub\Controller\Help->handleHelpPage() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 19
- XF\Pub\Controller\Help->actionIndex() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
- XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
- XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
- XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
SELECT `xf_help_page`.*
FROM `xf_help_page`
LEFT JOIN `xf_addon` AS `xf_addon_AddOn_1` ON (`xf_addon_AddOn_1`.`addon_id` = `xf_help_page`.`addon_id`)
WHERE (`xf_help_page`.`active` = 1) AND ((`xf_addon_AddOn_1`.`active` = 1) OR (`xf_help_page`.`addon_id` = ''))
ORDER BY `xf_help_page`.`display_order` ASC
Run Time: 0.000226
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | ALL | | | | | 5 | Using where; Using filesort |
SIMPLE | xf_addon_AddOn_1 | eq_ref | PRIMARY | PRIMARY | 52 | forums.xf_help_page.addon_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Mvc/Entity/Finder.php at line 1138
- XF\Mvc\Entity\Finder->fetch() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 68
- XF\Pub\Controller\Help->addWrapperParams() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 59
- XF\Pub\Controller\Help->handleHelpPage() in /var/www/playconquer-forum/src/XF/Pub/Controller/Help.php at line 19
- XF\Pub\Controller\Help->actionIndex() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 232
- XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
- XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
- XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
-- 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\Help, Index, valid, page_name=terms%2F, 1614319837,
Run Time: 0.000107
- XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Repository/SessionActivity.php at line 152
- XF\Repository\SessionActivity->updateSessionActivity() in /var/www/playconquer-forum/src/XF/Pub/Controller/AbstractController.php at line 65
- XF\Pub\Controller\AbstractController->updateSessionActivity() in /var/www/playconquer-forum/src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->postDispatchType() in /var/www/playconquer-forum/src/XF/Mvc/Controller.php at line 241
- XF\Mvc\Controller->postDispatch() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 254
- XF\Mvc\Dispatcher->dispatchClass() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 85
- XF\Mvc\Dispatcher->dispatchLoop() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
- XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000256
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 /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->fetchOne() in /var/www/playconquer-forum/src/XF/PermissionCache.php at line 35
- XF\PermissionCache->getGlobalPerms() in /var/www/playconquer-forum/src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in /var/www/playconquer-forum/src/XF/Entity/User.php at line 848
- XF\Entity\User->hasPermission() in /var/www/playconquer-forum/src/XF/Entity/User.php at line 473
- XF\Entity\User->canSearch()
- call_user_func_array() in /var/www/playconquer-forum/src/XF/Template/Templater.php at line 846
- XF\Template\Templater->method() in /var/www/playconquer-forum/internal_data/code_cache/navigation_cache.php at line 221
- XF\Pub\App->{closure}() in /var/www/playconquer-forum/src/XF/Template/Templater.php at line 5313
- XF\Template\Templater->renderNavigationClosure() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 442
- XF\Pub\App->getNavigation() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 398
- XF\Pub\App->renderPageHtml() in /var/www/playconquer-forum/src/XF/App.php at line 1612
- XF\App->renderPage() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 293
- XF\Mvc\Dispatcher->render() in /var/www/playconquer-forum/src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in /var/www/playconquer-forum/src/XF/App.php at line 1777
- XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
-- 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: oazHBQIkeeNkc86W1IBsKP936QcOvrWF, , 1614334237
Run Time: 0.000175
- XF\Db\Mysqli\Statement->execute() in /var/www/playconquer-forum/src/XF/Db/AbstractAdapter.php at line 67
- XF\Db\AbstractAdapter->query() in /var/www/playconquer-forum/src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in /var/www/playconquer-forum/src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in /var/www/playconquer-forum/src/XF/Pub/App.php at line 343
- XF\Pub\App->complete() in /var/www/playconquer-forum/src/XF/App.php at line 1780
- XF\App->run() in /var/www/playconquer-forum/src/XF.php at line 320
- XF::runApp() in /var/www/playconquer-forum/index.php at line 13
bytes_sent | 4267 |
bytes_received | 86362 |
packets_sent | 64 |
packets_received | 193 |
protocol_overhead_in | 772 |
protocol_overhead_out | 256 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 144 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 84 |
bytes_received_prepare_response_packet | 4934 |
bytes_received_change_user_packet | 80894 |
packets_sent_command | 31 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 16 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 12 |
packets_received_prepare_response | 100 |
packets_received_change_user | 53 |
result_set_queries | 8 |
non_result_set_queries | 4 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 8 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 9 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 45 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 45 |
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 | 45 |
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 | 14 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 12 |
proto_binary_fetched_int24 | 0 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 6 |
proto_binary_fetched_decimal | 10 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 5 |
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 | 94 |
proto_binary_fetched_blob | 34 |
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 | 10 |
com_stmt_execute | 10 |
com_stmt_send_long_data | 0 |
com_stmt_close | 9 |
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 | 80419 |