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.002207
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.000351
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_tag`.*
FROM `xf_tag`
WHERE (`xf_tag`.`tag_url` = 'document')
LIMIT 1
Run Time: 0.000401
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/TagController.php at line 122
- XF\Pub\Controller\TagController->actionTag() 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_tag_result_cache`.*
FROM `xf_tag_result_cache`
WHERE (`xf_tag_result_cache`.`tag_id` = 522 AND `xf_tag_result_cache`.`user_id` = 0)
LIMIT 1
Run Time: 0.000223
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/Repository/TagRepository.php at line 712
- XF\Repository\TagRepository->getTagResultCache() in src/XF/Pub/Controller/TagController.php at line 138
- XF\Pub\Controller\TagController->actionTag() 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 content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 522
Run Time: 0.000586
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 | 8 | Using where; Backward index scan |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/TagRepository.php at line 677
- XF\Repository\TagRepository->getTagSearchResults() in src/XF/Pub/Controller/TagController.php at line 142
- XF\Pub\Controller\TagController->actionTag() 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_rm_resource`.*, `xf_rm_category_Category_1`.*, `xf_user_User_2`.*, `xf_rm_resource_update_Description_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_1` ON (`xf_rm_category_Category_1`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_3` ON (`xf_rm_resource_update_Description_3`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` IN (109, 107, 70, 69, 68, 65, 63, 62))
Run Time: 0.001397
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 8 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.description_update_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
- 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/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3227
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 77
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/TagRepository.php at line 746
- XF\Repository\TagRepository->getResultSetData() in src/XF/ResultSet.php at line 313
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 294
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/TagController.php at line 143
- XF\Pub\Controller\TagController->actionTag() 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.000323
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_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 166)
LIMIT 1
Run Time: 0.000407
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 164)
LIMIT 1
Run Time: 0.000467
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 98)
LIMIT 1
Run Time: 0.000395
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 97)
LIMIT 1
Run Time: 0.000498
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 96)
LIMIT 1
Run Time: 0.000449
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 93)
LIMIT 1
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 91)
LIMIT 1
Run Time: 0.000484
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 90)
LIMIT 1
Run Time: 0.000454
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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/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 140
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s7/public/search_result_resource.php at line 20
- 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/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 31
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/tag_view.php at line 91
- 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 | 12089 |
bytes_received | 912060 |
packets_sent | 186 |
packets_received | 1477 |
protocol_overhead_in | 5908 |
protocol_overhead_out | 744 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 459 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 172 |
bytes_received_prepare_response_packet | 106535 |
bytes_received_change_user_packet | 804121 |
packets_sent_command | 91 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 51 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 32 |
packets_received_prepare_response | 1236 |
packets_received_change_user | 124 |
result_set_queries | 30 |
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 | 30 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 29 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 94 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 94 |
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 | 29 |
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 | 75 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 177 |
proto_binary_fetched_int24 | 72 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 724 |
proto_binary_fetched_decimal | 53 |
proto_binary_fetched_float | 16 |
proto_binary_fetched_double | 32 |
proto_binary_fetched_date | 26 |
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 | 548 |
proto_binary_fetched_blob | 177 |
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 | 30 |
com_stmt_execute | 30 |
com_stmt_send_long_data | 0 |
com_stmt_close | 29 |
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 | 802421 |