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.000850
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 34 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/App.php at line 1546
- XF\App->preLoadData() in src/XF/App.php at line 1536
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 313
- XF::setupApp() in src/XF.php at line 325
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000156
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 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- 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 903
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 225
- 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 117
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT `xf_tag`.*
FROM `xf_tag`
WHERE (`xf_tag`.`tag_url` = 'meet-and-greet')
LIMIT 1
Run Time: 0.001382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Tag.php at line 115
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT `xf_tag_result_cache`.*
FROM `xf_tag_result_cache`
WHERE (`xf_tag_result_cache`.`tag_id` = 153 AND `xf_tag_result_cache`.`user_id` = 0)
LIMIT 1
Run Time: 0.000212
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/Tag.php at line 694
- XF\Repository\Tag->getTagResultCache() in src/XF/Pub/Controller/Tag.php at line 131
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 153
Run Time: 0.000859
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 2 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Tag.php at line 666
- XF\Repository\Tag->getTagSearchResults() in src/XF/Pub/Controller/Tag.php at line 135
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (6888, 4015))
Run Time: 0.001697
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | aav_xf14.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | aav_xf14.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | aav_xf14.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | aav_xf14.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,aav_xf14.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2287
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 728
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in 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\Tag, Tag, valid, tag_url=meet-and-greet, 1610763686,
Run Time: 0.000193
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- 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 67
- 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 278
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT `xf_th_xlink_platform_link`.*
FROM `xf_th_xlink_platform_link`
WHERE (`xf_th_xlink_platform_link`.`platform_id` IN (1))
Run Time: 0.000273
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_xlink_platform_link | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 122
- ThemeHouse\XLink\Navigation\RemoteNavigation::loadPlatformLinks() in src/addons/ThemeHouse/XLink/Navigation/RemoteNavigation.php at line 79
- ThemeHouse\XLink\Navigation\RemoteNavigation::displayPlatformExtended() in internal_data/code_cache/navigation_cache.php at line 96
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 5768
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 475
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 428
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1766
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 310
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in 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: 9PjPXMFZZpFpkkgX-pzdkcyVEyX6DqSy, a:4:{s:3:"_ip";s:4:"腍";s:5:"robot";s:0:"";s:10:"fromSearch";b:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1583177900;}}, 1610778086
Run Time: 0.001911
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in src/XF/Pub/App.php at line 373
- XF\Pub\App->complete() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
bytes_sent | 6893 |
bytes_received | 258839 |
packets_sent | 100 |
packets_received | 582 |
protocol_overhead_in | 2328 |
protocol_overhead_out | 400 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 306 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 114 |
bytes_received_prepare_response_packet | 29028 |
bytes_received_change_user_packet | 228961 |
packets_sent_command | 49 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 34 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 18 |
packets_received_prepare_response | 446 |
packets_received_change_user | 66 |
result_set_queries | 14 |
non_result_set_queries | 4 |
no_index_used | 0 |
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 | 15 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 52 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 52 |
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 | 3 |
rows_skipped_normal | 0 |
rows_skipped_ps | 52 |
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 | 12 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 37 |
proto_binary_fetched_int24 | 14 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 119 |
proto_binary_fetched_decimal | 23 |
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 | 180 |
proto_binary_fetched_blob | 59 |
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 | 16 |
com_stmt_execute | 16 |
com_stmt_send_long_data | 0 |
com_stmt_close | 15 |
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 | 228254 |