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.001093
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 47 | 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 1898
- XF\App->preLoadData() in src/XF/App.php at line 1886
- 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.000350
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/Entity/User.php at line 913
- XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/XF/Entity/User.php at line 13
- EAEAddons\ConversationTools\XF\Entity\User->canStartConversation() in src/addons/EAEAddons/ConversationTools/Listener.php at line 189
- EAEAddons\ConversationTools\Listener::appPubStartEnd()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2834
- XF\App->fire() in src/XF/Pub/App.php at line 199
- XF\Pub\App->start() in src/XF/App.php at line 2333
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_find_new`.*
FROM `xf_find_new`
WHERE (`xf_find_new`.`find_new_id` = '105869')
LIMIT 1
Run Time: 0.000315
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
- 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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/ControllerPlugin/FindNew.php at line 111
- XF\ControllerPlugin\FindNew->getFindNewRecord() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 26
- XF\Pub\Controller\AbstractWhatsNewFindType->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_find_new`.*
FROM `xf_find_new`
WHERE (`xf_find_new`.`content_type` = 'xfmg_comment' AND `xf_find_new`.`user_id` = 0 AND `xf_find_new`.`filter_hash` = 'd751713988987e9331980363e24189ce') AND (`xf_find_new`.`cache_date` >= 1711616736)
ORDER BY `xf_find_new`.`cache_date` DESC
LIMIT 1
Run Time: 0.000437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_find_new | range | cache_date,type_user_date | cache_date | 4 | | 1 | Using index condition; 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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/FindNew.php at line 22
- XF\Repository\FindNew->getAvailableCachedFindNewRecord() in src/XF/ControllerPlugin/FindNew.php at line 56
- XF\ControllerPlugin\FindNew->runFindNewSearch() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 74
- XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 30
- XF\Pub\Controller\AbstractWhatsNewFindType->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*, `xf_permission_cache_content_Permissions_6`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_mg_category_Category_2`.`category_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1')
WHERE (`xf_mg_media_item`.`last_comment_date` > 0) AND (`xf_mg_media_item`.`media_state` <> 'deleted') AND (`xf_mg_media_item`.`last_comment_date` > 1709024781)
ORDER BY `xf_mg_media_item`.`last_comment_date` DESC, `xf_mg_media_item`.`media_id` DESC
LIMIT 200
Run Time: 0.001645
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | last_comment_date | last_comment_date | 4 | | 1 | Using index condition; Using where |
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum_maagalim.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum_maagalim.xf_mg_media_item.category_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum_maagalim.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,forum_maagalim.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | forum_maagalim.xf_attachment_Attachment_4.data_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum_maagalim.xf_mg_category_Category_2.category_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/addons/XFMG/FindNew/MediaComment.php at line 79
- XFMG\FindNew\MediaComment->getResultIds() in src/XF/ControllerPlugin/FindNew.php at line 63
- XF\ControllerPlugin\FindNew->runFindNewSearch() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 74
- XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 30
- XF\Pub\Controller\AbstractWhatsNewFindType->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_mg_album`.*, `xf_mg_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_mg_album`
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_1` ON (`xf_mg_category_Category_1`.`category_id` = `xf_mg_album`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_mg_category_Category_1`.`category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
WHERE (`xf_mg_album`.`last_comment_date` > 0) AND (`xf_mg_album`.`album_state` <> 'deleted') AND (`xf_mg_album`.`last_comment_date` > 1709024781)
ORDER BY `xf_mg_album`.`last_comment_date` DESC, `xf_mg_album`.`album_id` DESC
LIMIT 200
Run Time: 0.000868
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_album | range | last_comment_date | last_comment_date | 4 | | 1 | Using index condition; Using where |
SIMPLE | xf_mg_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum_maagalim.xf_mg_album.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum_maagalim.xf_mg_category_Category_1.category_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/addons/XFMG/FindNew/MediaComment.php at line 91
- XFMG\FindNew\MediaComment->getResultIds() in src/XF/ControllerPlugin/FindNew.php at line 63
- XF\ControllerPlugin\FindNew->runFindNewSearch() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 74
- XF\Pub\Controller\AbstractWhatsNewFindType->triggerNewFindNewAction() in src/XF/Pub/Controller/AbstractWhatsNewFindType.php at line 30
- XF\Pub\Controller\AbstractWhatsNewFindType->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 2337
- 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, , , XFMG\Pub\Controller\WhatsNewComment, Index, valid, find_new_id=105869, 1711616781,
Run Time: 0.000201
- 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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
bytes_sent | 8986 |
bytes_received | 193781 |
packets_sent | 82 |
packets_received | 667 |
protocol_overhead_in | 2668 |
protocol_overhead_out | 328 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 189 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 93 |
bytes_received_prepare_response_packet | 46811 |
bytes_received_change_user_packet | 146314 |
packets_sent_command | 40 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 21 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 15 |
packets_received_prepare_response | 551 |
packets_received_change_user | 65 |
result_set_queries | 12 |
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 | 12 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 12 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 53 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 53 |
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 | 53 |
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 | 34 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 0 |
proto_binary_fetched_int24 | 0 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 0 |
proto_binary_fetched_decimal | 27 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 13 |
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 | 132 |
proto_binary_fetched_blob | 39 |
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 | 13 |
com_stmt_execute | 13 |
com_stmt_send_long_data | 0 |
com_stmt_close | 12 |
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 | 145723 |