SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000238
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/addons/TickTackk/DeveloperTools/XF/PermissionSet.php at line 26
- TickTackk\DeveloperTools\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 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_profile_post`.*, `xf_user_User_1`.*, `xf_user_ProfileUser_2`.*, `xf_user_privacy_Privacy_3`.*
FROM `xf_profile_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_profile_post`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_ProfileUser_2` ON (`xf_user_ProfileUser_2`.`user_id` = `xf_profile_post`.`profile_user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user_ProfileUser_2`.`user_id`)
WHERE (`xf_profile_post`.`profile_post_id` = '3010')
LIMIT 1
Run Time: 0.000517
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_ProfileUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | 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 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/ProfilePost.php at line 661
- XF\Pub\Controller\ProfilePost->assertViewableProfilePost() in src/XF/Pub/Controller/ProfilePost.php at line 302
- XF\Pub\Controller\ProfilePost->actionLoadPrevious() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_profile_post_comment`.*, `xf_profile_post_ProfilePost_1`.*, `xf_user_User_2`.*
FROM `xf_profile_post_comment`
LEFT JOIN `xf_profile_post` AS `xf_profile_post_ProfilePost_1` ON (`xf_profile_post_ProfilePost_1`.`profile_post_id` = `xf_profile_post_comment`.`profile_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_profile_post_comment`.`user_id`)
WHERE (`xf_profile_post_comment`.`profile_post_id` = 3010) AND ((`xf_profile_post_comment`.`message_state` IN ('visible'))) AND (`xf_profile_post_comment`.`comment_date` < 1520810342)
ORDER BY `xf_profile_post_comment`.`comment_date` DESC
LIMIT 20
Run Time: 0.000537
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post_comment | range | profile_post_id_comment_date,comment_date | profile_post_id_comment_date | 8 | | 3 | Using where |
SIMPLE | xf_profile_post_ProfilePost_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | mmaspot_forum.xf_profile_post_comment.user_id | 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 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/ProfilePost.php at line 311
- XF\Pub\Controller\ProfilePost->actionLoadPrevious() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_profile_post_comment`
WHERE (`xf_profile_post_comment`.`profile_post_id` = 3010) AND ((`xf_profile_post_comment`.`message_state` IN ('visible'))) AND (`xf_profile_post_comment`.`comment_date` < 1520619396)
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post_comment | range | profile_post_id_comment_date,comment_date | profile_post_id_comment_date | 8 | | 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/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/ProfilePost.php at line 321
- XF\Pub\Controller\ProfilePost->actionLoadPrevious() 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 2190
- XF\App->run() in src/XF.php at line 391
- 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\ProfilePost, LoadPrevious, valid, profile_post_id=3010, 1618723578, ccbot
Run Time: 0.000130
- 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/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 35
- SV\UserActivity\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 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_donate_drive`.*, `xf_dbtech_donate_currency_PrimaryCurrency_1`.*, `xf_dbtech_donate_donation_LastDonation_2`.*, `xf_permission_cache_content_Permissions_3`.*
FROM `xf_dbtech_donate_drive`
LEFT JOIN `xf_dbtech_donate_currency` AS `xf_dbtech_donate_currency_PrimaryCurrency_1` ON (`xf_dbtech_donate_currency_PrimaryCurrency_1`.`primary_currency` = 1)
LEFT JOIN `xf_dbtech_donate_donation` AS `xf_dbtech_donate_donation_LastDonation_2` ON (`xf_dbtech_donate_donation_LastDonation_2`.`donation_id` = `xf_dbtech_donate_drive`.`last_donation_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'dbtech_donate_drive' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_dbtech_donate_drive`.`drive_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
Run Time: 0.000433
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_donate_drive | ALL | | | | | 2 | |
SIMPLE | xf_dbtech_donate_currency_PrimaryCurrency_1 | ALL | | | | | 5 | Using where |
SIMPLE | xf_dbtech_donate_donation_LastDonation_2 | eq_ref | PRIMARY | PRIMARY | 4 | mmaspot_forum.xf_dbtech_donate_drive.last_donation_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,mmaspot_forum.xf_dbtech_donate_drive.drive_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 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Donate/Listener.php at line 111
- DBTech\Donate\Listener::navigationSetup()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2660
- XF\App->fire() in src/XF/Pub/App.php at line 572
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2001
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
bytes_sent | 6560 |
bytes_received | 65105 |
packets_sent | 70 |
packets_received | 705 |
protocol_overhead_in | 2820 |
protocol_overhead_out | 280 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 207 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 83 |
bytes_received_prepare_response_packet | 54979 |
bytes_received_change_user_packet | 9502 |
packets_sent_command | 34 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 23 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 13 |
packets_received_prepare_response | 627 |
packets_received_change_user | 29 |
result_set_queries | 10 |
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 | 10 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 10 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 19 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 19 |
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 | 19 |
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 | 17 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 35 |
proto_binary_fetched_int24 | 24 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 172 |
proto_binary_fetched_decimal | 32 |
proto_binary_fetched_float | 5 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 15 |
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 | 160 |
proto_binary_fetched_blob | 26 |
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 | 11 |
com_stmt_execute | 11 |
com_stmt_send_long_data | 0 |
com_stmt_close | 10 |
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 | 9098 |