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.001597
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.000299
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_rm_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_rm_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_rm_category`.`resource_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
ORDER BY `xf_rm_category`.`lft` ASC
Run Time: 0.000801
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | ALL | | | | | 32 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category.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/Repository/AbstractCategoryTree.php at line 70
- XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XFRM/ControllerPlugin/Overview.php at line 16
- XFRM\ControllerPlugin\Overview->getCategoryListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 71
- XFRM\Pub\Controller\ResourceItem->actionIndex() 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_rm_resource`
WHERE (`xf_rm_resource`.`resource_category_id` IN (32, 28, 31, 30, 29, 27, 23, 26, 25, 24, 2, 20, 15, 12, 4, 3, 11, 18, 19, 17, 8, 33, 14, 13, 10, 9, 5, 22, 21, 16, 7, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
Run Time: 0.000743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | category_last_update,category_rating_weighted | | | | 145 | 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/addons/XFRM/ControllerPlugin/Overview.php at line 43
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 74
- XFRM\Pub\Controller\ResourceItem->actionIndex() 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_user_User_1`.*, `xf_rm_resource_version_CurrentVersion_2`.*, `xf_rm_category_Category_3`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_2` ON (`xf_rm_resource_version_CurrentVersion_2`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_3` ON (`xf_rm_category_Category_3`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (32, 28, 31, 30, 29, 27, 23, 26, 25, 24, 2, 20, 15, 12, 4, 3, 11, 18, 19, 17, 8, 33, 14, 13, 10, 9, 5, 22, 21, 16, 7, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
ORDER BY `xf_rm_resource`.`resource_date` DESC
LIMIT 20 OFFSET 20
Run Time: 0.001917
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | category_last_update,category_rating_weighted | | | | 145 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_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/addons/XFRM/ControllerPlugin/Overview.php at line 49
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 74
- XFRM\Pub\Controller\ResourceItem->actionIndex() 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�D
Run Time: 0.000211
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_featured_content`.*, `xf_user_ContentUser_1`.*
FROM `xf_featured_content`
LEFT JOIN `xf_user` AS `xf_user_ContentUser_1` ON (`xf_user_ContentUser_1`.`user_id` = `xf_featured_content`.`content_user_id`)
WHERE (`xf_featured_content`.`content_visible` = 1) AND (`xf_featured_content`.`content_type` = 'resource')
ORDER BY `xf_featured_content`.`feature_date` DESC
LIMIT 10
Run Time: 0.000647
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_featured_content | ref | content_type_content_id,content_visible_feature_date | content_type_content_id | 77 | const | 3 | Using where; Using filesort |
SIMPLE | xf_user_ContentUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_featured_content.content_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/Widget/FeaturedContent.php at line 75
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_16_xfrm_list_featured_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 33
- 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`.*, `xf_rm_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*, `xf_rm_resource_update_Description_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_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_4` ON (`xf_rm_resource_update_Description_4`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
WHERE (`xf_rm_resource`.`resource_id` IN (124, 123, 11))
Run Time: 0.000704
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_4 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.description_update_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/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/FeaturedContent/AbstractHandler.php at line 384
- XF\FeaturedContent\AbstractHandler->getContent() in src/XF/Repository/FeaturedContentRepository.php at line 58
- XF\Repository\FeaturedContentRepository->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 76
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_16_xfrm_list_featured_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 33
- 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_attachment`.*, `xf_attachment_data_Data_1`.*, `xf_mg_media_item_XfmgMirrorMedia_2`.*, `xf_mg_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_XfmgMirrorMedia_2` ON (`xf_mg_media_item_XfmgMirrorMedia_2`.`media_id` = `xf_attachment_data_Data_1`.`xfmg_mirror_media_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_media_item_XfmgMirrorMedia_2`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mg_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_attachment`.`content_type` = 'resource_update' AND `xf_attachment`.`content_id` IN (11, 197))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.001121
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | range | content_type_id_date | content_type_id_date | 31 | | 2 | Using index condition; Using filesort |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_attachment.data_id | 1 | |
SIMPLE | xf_mg_media_item_XfmgMirrorMedia_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_attachment_data_Data_1.xfmg_mirror_media_id | 1 | |
SIMPLE | xf_mg_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_mg_media_item_XfmgMirrorMedia_2.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_mg_category_Category_3.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/Repository/AttachmentRepository.php at line 247
- XF\Repository\AttachmentRepository->addAttachmentsToContent() in src/addons/XFRM/FeaturedContent/ResourceItem.php at line 100
- XFRM\FeaturedContent\ResourceItem->addAttachmentsToContent() in src/XF/FeaturedContent/AbstractHandler.php at line 411
- XF\FeaturedContent\AbstractHandler->addAttachmentsToContentExternal() in src/XF/Repository/FeaturedContentRepository.php at line 77
- XF\Repository\FeaturedContentRepository->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 76
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_16_xfrm_list_featured_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 33
- 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 title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xfrm_resource_x')
Params: 1
Run Time: 0.000312
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 387
- XF\Language->loadPhrases() in src/XF/Language.php at line 279
- XF\Language->getPhraseText() in src/XF/Language.php at line 136
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/FeaturedContent/AbstractHandler.php at line 170
- XF\FeaturedContent\AbstractHandler->getContentTitle() in src/XF/Entity/FeaturedContent.php at line 122
- XF\Entity\FeaturedContent->getTitle() in src/XF/Mvc/Entity/Entity.php at line 182
- 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/featured_content_item.php at line 202
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1093
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1029
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l1/s7/public/content_display_macros.php at line 324
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 913
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 913
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 967
- XF\Template\Templater->renderMacro() in src/XF/FeaturedContent/AbstractHandler.php at line 331
- XF\FeaturedContent\AbstractHandler->render() in src/XF/Entity/FeaturedContent.php at line 87
- XF\Entity\FeaturedContent->render() in src/XF/Template/Templater.php at line 1283
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s7/public/widget_featured_content.php at line 46
- 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/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 33
- 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`.*, `xf_rm_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*
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_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_rm_resource`.`user_id`)
WHERE (`xf_rm_resource`.`resource_state` = 'visible')
ORDER BY `xf_rm_resource`.`rating_weighted` DESC
LIMIT 10
Run Time: 0.002142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | index | | rating_weighted | 4 | | 10 | Using where; Backward index scan |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.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/addons/XFRM/Widget/TopResources.php at line 86
- XFRM\Widget\TopResources->render() in internal_data/code_cache/widgets/_11_xfrm_list_top_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_trending_result`.*
FROM `xf_trending_result`
WHERE (`xf_trending_result`.`order` = 'hot') AND (`xf_trending_result`.`duration` = 7) AND (`xf_trending_result`.`content_type` = 'resource') AND (`xf_trending_result`.`content_container_id` = 0)
ORDER BY `xf_trending_result`.`result_date` DESC
LIMIT 1
Run Time: 0.000594
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_trending_result | ref | order_duration_content_type_content_container_id_result_date | order_duration_content_type_content_container_id_result_date | 86 | const,const,const,const | 50 | Backward index scan |
- 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/TrendingContentRepository.php at line 42
- XF\Repository\TrendingContentRepository->getResult() in src/XF/Widget/TrendingContent.php at line 66
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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`.*, `xf_rm_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*
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_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_rm_resource`.`user_id`)
WHERE (`xf_rm_resource`.`resource_id` IN (8, 54, 10, 15, 53, 16, 52, 123, 124, 57))
Run Time: 0.001441
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 10 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource.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/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/TrendingContent/AbstractHandler.php at line 95
- XF\TrendingContent\AbstractHandler->getContent() in src/XF/Repository/TrendingContentRepository.php at line 355
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 8)
LIMIT 1
Run Time: 0.000610
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 10)
LIMIT 1
Run Time: 0.000387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 15)
LIMIT 1
Run Time: 0.000425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 16)
LIMIT 1
Run Time: 0.000370
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 52)
LIMIT 1
Run Time: 0.000378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 53)
LIMIT 1
Run Time: 0.000543
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 54)
LIMIT 1
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_update`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_update`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_update`.`resource_id`)
WHERE (`xf_rm_resource_update`.`resource_update_id` = 58)
LIMIT 1
Run Time: 0.000405
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_update | 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 134
- XF\Mvc\Entity\Entity->__get() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 50
- XFRM\TrendingContent\ResourceItemHandler->XFRM\TrendingContent\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 248
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 48
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_attachment`.*, `xf_attachment_data_Data_1`.*, `xf_mg_media_item_XfmgMirrorMedia_2`.*, `xf_mg_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_XfmgMirrorMedia_2` ON (`xf_mg_media_item_XfmgMirrorMedia_2`.`media_id` = `xf_attachment_data_Data_1`.`xfmg_mirror_media_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_media_item_XfmgMirrorMedia_2`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mg_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_attachment`.`content_type` = 'resource_update' AND `xf_attachment`.`content_id` IN (8, 10, 15, 16, 197))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.001122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | range | content_type_id_date | content_type_id_date | 31 | | 5 | Using index condition; Using filesort |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_attachment.data_id | 1 | |
SIMPLE | xf_mg_media_item_XfmgMirrorMedia_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_attachment_data_Data_1.xfmg_mirror_media_id | 1 | |
SIMPLE | xf_mg_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_mg_media_item_XfmgMirrorMedia_2.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_mg_category_Category_3.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/Repository/AttachmentRepository.php at line 247
- XF\Repository\AttachmentRepository->addAttachmentsToContent() in src/addons/XFRM/TrendingContent/ResourceItemHandler.php at line 55
- XFRM\TrendingContent\ResourceItemHandler->addAttachmentsToContent() in src/XF/Repository/TrendingContentRepository.php at line 357
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_20_xfrm_list_trending_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_rating`.*, `xf_rm_resource_Resource_1`.*, `xf_rm_category_Category_2`.*, `xf_permission_cache_content_Permissions_3`.*, `xf_user_User_4`.*
FROM `xf_rm_resource_rating`
INNER JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_rating`.`resource_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_2` ON (`xf_rm_category_Category_2`.`resource_category_id` = `xf_rm_resource_Resource_1`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_rm_category_Category_2`.`resource_category_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_rm_resource_rating`.`user_id`)
WHERE (`xf_rm_resource_Resource_1`.`resource_state` = 'visible' AND `xf_rm_resource_rating`.`rating_state` = 'visible' AND `xf_rm_resource_rating`.`is_review` = 1) AND (`xf_rm_resource_rating`.`rating_date` > 1748743789)
ORDER BY `xf_rm_resource_rating`.`rating_date` DESC
LIMIT 10
Run Time: 0.001404
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_rating | range | resource_id_rating_date,rating_date | rating_date | 4 | | 1 | Using index condition; Using where; Backward index scan |
SIMPLE | xf_rm_resource_Resource_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource_rating.resource_id | 1 | Using where |
SIMPLE | xf_rm_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource_Resource_1.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.xf_rm_category_Category_2.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_rm_resource_rating.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/addons/XFRM/Widget/LatestReviews.php at line 30
- XFRM\Widget\LatestReviews->render() in internal_data/code_cache/widgets/_12_xfrm_overview_latest_reviews.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_member_stat`.*
FROM `xf_member_stat`
WHERE (`xf_member_stat`.`member_stat_key` = 'xfrm_most_resources')
LIMIT 1
Run Time: 0.000343
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_member_stat | const | member_stat_key | member_stat_key | 52 | 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 178
- XF\Mvc\Entity\Manager->findOne() in src/XF/Widget/AbstractWidget.php at line 201
- XF\Widget\AbstractWidget->findOne() in src/XF/Widget/MemberStat.php at line 40
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_14_xfrm_overview_top_authors.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_user`.*
FROM `xf_user`
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND ((`xf_user`.`xfrm_resource_count` > 0) OR (`xf_user`.`xfrm_resource_count` < 0))
ORDER BY `xf_user`.`xfrm_resource_count` DESC
LIMIT 60
Run Time: 0.000770
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | user_state,resource_count | resource_count | 4 | | 18 | Using index condition; 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/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Service/MemberStat/PreparerService.php at line 242
- XF\Service\MemberStat\PreparerService->getResultsData() in src/XF/Service/MemberStat/PreparerService.php at line 108
- XF\Service\MemberStat\PreparerService->getResults() in src/XF/Entity/MemberStat.php at line 129
- XF\Entity\MemberStat->getResults() in src/XF/Widget/MemberStat.php at line 48
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_14_xfrm_overview_top_authors.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (75559, 67242, 1, 49680, 51900, 93406, 118713, 48931, 61380, 51259, 100777, 54659, 53860, 53781, 50553, 49040, 48653, 22797)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.001112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY,user_state | PRIMARY | 4 | | 18 | Using where |
SIMPLE | xf_user_option_Option_1 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_user.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.xf_user.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/Widget/MemberStat.php at line 59
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_14_xfrm_overview_top_authors.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8164
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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 title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('user_name', 'join_date', 'last_activity', 'messages', 'solutions', 'trophy_points', 'reaction_score', 'xfmg_media_count', 'xfmg_album_count', 'xfrm_resource_count', 'xfrm_resource_statistics')
Params: 1
Run Time: 0.000461
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 11 | 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/Language.php at line 387
- XF\Language->loadPhrases() in src/XF/Language.php at line 279
- XF\Language->getPhraseText() in src/XF/Language.php at line 136
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/Phrase.php at line 61
- XF\Phrase->__toString() in src/XF.php at line 1546
- XF::escapeString() in src/XF/Template/Templater.php at line 1293
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l1/s7/public/xfrm_widget_resource_statistics.php at line 57
- 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/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2137
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s7/public/xfrm_overview.php at line 152
- 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 | 30991 |
bytes_received | 1266440 |
packets_sent | 330 |
packets_received | 3860 |
protocol_overhead_in | 15440 |
protocol_overhead_out | 1320 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 801 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 292 |
bytes_received_prepare_response_packet | 291823 |
bytes_received_change_user_packet | 972247 |
packets_sent_command | 163 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 89 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 56 |
packets_received_prepare_response | 3352 |
packets_received_change_user | 305 |
result_set_queries | 54 |
non_result_set_queries | 2 |
no_index_used | 6 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 54 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 53 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 251 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 251 |
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 | 53 |
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 | 710 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1763 |
proto_binary_fetched_int24 | 681 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 4446 |
proto_binary_fetched_decimal | 136 |
proto_binary_fetched_float | 52 |
proto_binary_fetched_double | 104 |
proto_binary_fetched_date | 64 |
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 | 2251 |
proto_binary_fetched_blob | 915 |
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 | 54 |
com_stmt_execute | 54 |
com_stmt_send_long_data | 0 |
com_stmt_close | 53 |
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 | 965759 |