SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', '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.001182
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 40 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/App.php at line 2276
- XF\App->preLoadData() in src/XF/App.php at line 2261
- XF\App->setup() in src/XF/Pub/App.php at line 116
- XF\Pub\App->setup() in src/XF.php at line 775
- XF::setupApp() in src/XF.php at line 798
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000257
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 266
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 138
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 361
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '75559')
LIMIT 1
Run Time: 0.000426
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/MemberController.php at line 1284
- XF\Pub\Controller\MemberController->assertViewableUser() in src/XF/Pub/Controller/MemberController.php at line 261
- XF\Pub\Controller\MemberController->actionView() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_profile_post`.*, `xf_user_User_1`.*
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`)
WHERE (`xf_profile_post`.`profile_user_id` = 75559) AND ((`xf_profile_post`.`message_state` IN ('visible')))
ORDER BY `xf_profile_post`.`post_date` DESC
LIMIT 20
Run Time: 0.000747
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 69 | Using where; Backward index scan |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_profile_post.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/MemberController.php at line 280
- XF\Pub\Controller\MemberController->actionView() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT COUNT(*)
FROM `xf_profile_post`
WHERE (`xf_profile_post`.`profile_user_id` = 75559) AND ((`xf_profile_post`.`message_state` IN ('visible')))
Run Time: 0.000356
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 69 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1407
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/MemberController.php at line 284
- XF\Pub\Controller\MemberController->actionView() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
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_comment_id` IN (51704, 50593, 50595, 50596, 50582, 50583, 50212, 49996, 49998, 49950, 49953, 50214, 49387, 49388, 49394, 49228, 49243, 49244, 49101, 49103, 49106, 48148, 48147, 48194, 47225, 47226, 47227, 46675, 46680, 46585, 46586, 46748, 45626, 45627, 45630, 47817))
ORDER BY `xf_profile_post_comment`.`comment_date` ASC
Run Time: 0.001037
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post_comment | range | PRIMARY | PRIMARY | 4 | | 36 | Using where; Using filesort |
SIMPLE | xf_profile_post_ProfilePost_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_profile_post_comment.profile_post_id | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_profile_post_comment.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/ProfilePostRepository.php at line 149
- XF\Repository\ProfilePostRepository->addCommentsToProfilePosts() in src/XF/Pub/Controller/MemberController.php at line 287
- XF\Pub\Controller\MemberController->actionView() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT COUNT(*)
FROM `xf_user_follow`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_follow`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_3` ON (`xf_user_option_Option_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_user_User_1`.`is_banned` = 0) AND (`xf_user_User_1`.`user_state` = 'valid') AND (`xf_user_follow`.`follow_user_id` = 75559)
Run Time: 0.000653
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 21 | Using index |
SIMPLE | xf_user_option_Option_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_user_follow.user_id | 1 | Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | nma_xen.xf_user_follow.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_user_follow.user_id | 1 | Using index |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1407
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/MemberController.php at line 376
- XF\Pub\Controller\MemberController->actionView() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, �I�
Run Time: 0.000161
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivityRepository.php at line 133
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 75559) AND (`xf_session_activity`.`unique_key` = '75559')
LIMIT 1
Run Time: 0.000197
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 397
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 419
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 211
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 134
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 341
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 182
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 134
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 553
- XF\Entity\User->canViewOnlineStatus() in src/XF/Template/Templater.php at line 4508
- XF\Template\Templater->fnUserActivity() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 174
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 190
Run Time: 0.000150
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 1009
- XF\Entity\User->canReceiveConversation() in src/XF/Entity/User.php at line 984
- XF\Entity\User->canStartConversationWith() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/member_macros.php at line 244
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 247
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 212
Run Time: 0.000161
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 641
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 365
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000119
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 641
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 365
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 17
Run Time: 0.000130
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 641
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 365
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 16
Run Time: 0.000133
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 641
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 365
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 217
Run Time: 0.000125
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 133
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 222
Run Time: 0.000122
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Entity/User.php at line 286
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 269
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2600
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1220
- XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 641
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/profile_post_macros.php at line 365
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s7/public/member_view.php at line 422
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1792
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2813
- XF\App->run() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
bytes_sent | 10669 |
bytes_received | 915899 |
packets_sent | 198 |
packets_received | 1047 |
protocol_overhead_in | 4188 |
protocol_overhead_out | 792 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 594 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 182 |
bytes_received_prepare_response_packet | 53520 |
bytes_received_change_user_packet | 860788 |
packets_sent_command | 97 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 66 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 34 |
packets_received_prepare_response | 746 |
packets_received_change_user | 165 |
result_set_queries | 32 |
non_result_set_queries | 2 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 32 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 31 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 133 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 133 |
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 | 0 |
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 | 31 |
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 | 676 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 395 |
proto_binary_fetched_int24 | 333 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2115 |
proto_binary_fetched_decimal | 51 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 24 |
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 | 980 |
proto_binary_fetched_blob | 367 |
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 | 32 |
com_stmt_execute | 32 |
com_stmt_send_long_data | 0 |
com_stmt_close | 31 |
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 | 857891 |