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.003362
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 99
- XF\DataRegistry->get() in src/XF/App.php at line 2103
- XF\App->preLoadData() in src/XF/App.php at line 2088
- XF\App->setup() in src/XF/Pub/App.php at line 95
- XF\Pub\App->setup() in src/XF.php at line 506
- XF::setupApp() in src/XF.php at line 529
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000116
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 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1244
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 129
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
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')
WHERE (`xf_rm_category`.`resource_category_id` = '5')
LIMIT 1
Run Time: 0.000359
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,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/addons/XFRM/Pub/Controller/Category.php at line 445
- XFRM\Pub\Controller\Category->assertViewableCategory() in src/addons/XFRM/Pub/Controller/Category.php at line 25
- XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
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.000185
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | ALL | | | | | 12 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.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 67
- XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XFRM/ControllerPlugin/Overview.php at line 14
- XFRM\ControllerPlugin\Overview->getCategoryListData() in src/addons/XFRM/Pub/Controller/Category.php at line 30
- XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_rm_resource`
WHERE (`xf_rm_resource`.`resource_category_id` IN (5)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
Run Time: 0.012533
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | category_last_update,category_rating_weighted | category_last_update | 4 | const | 9 | 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 1405
- XF\Mvc\Entity\Finder->total() in src/addons/XFRM/ControllerPlugin/Overview.php at line 41
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/Category.php at line 42
- XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
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 (5)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
ORDER BY `xf_rm_resource`.`last_update` DESC
LIMIT 20
Run Time: 0.004708
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | category_last_update,category_rating_weighted | category_last_update | 4 | const | 9 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_category_Category_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/ControllerPlugin/Overview.php at line 47
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/Category.php at line 42
- XFRM\Pub\Controller\Category->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ��q
Run Time: 0.000219
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/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 14
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: ��q, XFRM\Pub\Controller\Category, Index, valid, resource_category_id=5, 1714958457, anthropic, 0, ��q
Run Time: 0.000325
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 14
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ��q
Run Time: 0.000209
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/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 28
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
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') AND (`xf_featured_content`.`content_container_id` = 5)
ORDER BY `xf_featured_content`.`feature_date` DESC
LIMIT 16
Run Time: 0.006559
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_featured_content | ref | PRIMARY,content_visible_feature_date | PRIMARY | 102 | const | 10 | Using where; Using filesort |
SIMPLE | xf_user_ContentUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.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 76
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_52_xfrm_list_featured_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8120
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2103
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/xfrm_category_view.php at line 57
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
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 (66, 35, 31, 30))
Run Time: 0.010104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_4 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.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 3018
- XF\App->findByContentType() in src/XF/FeaturedContent/AbstractHandler.php at line 377
- XF\FeaturedContent\AbstractHandler->getContent() in src/XF/Repository/FeaturedContent.php at line 52
- XF\Repository\FeaturedContent->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 77
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_52_xfrm_list_featured_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8120
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2103
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/xfrm_category_view.php at line 57
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xfrm_resource_x')
Params: 2
Run Time: 0.000089
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 391
- XF\Language->loadPhrases() in src/XF/Language.php at line 278
- XF\Language->getPhraseText() in src/XF/Language.php at line 135
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/FeaturedContent/AbstractHandler.php at line 166
- XF\FeaturedContent\AbstractHandler->getContentTitle() in src/XF/Entity/FeaturedContent.php at line 119
- XF\Entity\FeaturedContent->getTitle() in src/XF/Mvc/Entity/Entity.php at line 178
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 136
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/featured_content_item.php at line 201
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1069
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1005
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/content_display_macros.php at line 324
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 898
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 889
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 889
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 943
- XF\Template\Templater->renderMacro() in src/XF/FeaturedContent/AbstractHandler.php at line 322
- XF\FeaturedContent\AbstractHandler->render() in src/XF/Entity/FeaturedContent.php at line 84
- XF\Entity\FeaturedContent->render() in src/XF/Template/Templater.php at line 1259
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/widget_featured_content.php at line 46
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 2103
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/xfrm_category_view.php at line 57
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('xfrmPrefixes')
Run Time: 0.000182
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | 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/DataRegistry.php at line 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 99
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 268
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1992
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 3661
- XF\App->container() in src/XF/Template/Templater.php at line 3702
- XF\Template\Templater->fnPrefix() in src/XF/Template/Templater.php at line 1196
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/xfrm_resource_list_macros.php at line 132
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 898
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/xfrm_category_view.php at line 151
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_user_User_1`.*
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`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (5)) AND (`xf_rm_resource`.`resource_state` = 'visible')
ORDER BY `xf_rm_resource`.`rating_weighted` DESC
LIMIT 10
Run Time: 0.000791
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ref | category_last_update,category_rating_weighted | category_rating_weighted | 4 | const | 9 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.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 82
- XFRM\Widget\TopResources->render() in internal_data/code_cache/widgets/_53_xfrm_list_top_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8120
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2103
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/xfrm_category_view.php at line 205
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1760
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2604
- XF\App->run() in src/XF.php at line 533
- XF::runApp() in index.php at line 20
bytes_sent | 12402 |
bytes_received | 1819694 |
packets_sent | 166 |
packets_received | 1572 |
protocol_overhead_in | 6288 |
protocol_overhead_out | 664 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 549 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 163 |
bytes_received_prepare_response_packet | 108627 |
bytes_received_change_user_packet | 1709689 |
packets_sent_command | 82 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 61 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 29 |
packets_received_prepare_response | 1319 |
packets_received_change_user | 134 |
result_set_queries | 26 |
non_result_set_queries | 3 |
no_index_used | 1 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 26 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 26 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 108 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 108 |
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 | 25 |
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 | 32 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 550 |
proto_binary_fetched_int24 | 217 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1484 |
proto_binary_fetched_decimal | 25 |
proto_binary_fetched_float | 22 |
proto_binary_fetched_double | 122 |
proto_binary_fetched_date | 0 |
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 | 865 |
proto_binary_fetched_blob | 346 |
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 | 27 |
com_stmt_execute | 27 |
com_stmt_send_long_data | 0 |
com_stmt_close | 26 |
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 | 1707149 |