SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 49 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/App.php at line 1546
- XF\App->preLoadData() in src/XF/App.php at line 1536
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 312
- XF::setupApp() in src/XF.php at line 324
- XF::runApp() in index.php at line 13
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('svContentRatingsRT')
Run Time: 0.000148
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 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 225
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1439
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2758
- XF\App->container() in src/addons/SV/ContentRatings/Repository/RatingType.php at line 405
- SV\ContentRatings\Repository\RatingType->getContainerRatingTypes() in src/addons/SV/ContentRatings/Repository/RatingType.php at line 795
- SV\ContentRatings\Repository\RatingType->getRatingTypesAsEntities() in src/addons/SV/ContentRatings/Entity/DynamicRatingCounts.php at line 286
- SV\ContentRatings\Entity\DynamicRatingCounts::getRatingStructure() in src/addons/SV/ContentRatings/Entity/DynamicRatingCounts.php at line 325
- SV\ContentRatings\Entity\DynamicRatingCounts::getStructure() in src/XF/Mvc/Entity/Manager.php at line 70
- XF\Mvc\Entity\Manager->getEntityStructure() in src/addons/SV/ContentRatings/Entity/Ratable.php at line 558
- SV\ContentRatings\XF\Entity\User::getStructure() in src/addons/XFRM/XF/Entity/User.php at line 38
- XFRM\XF\Entity\User::getStructure() in src/addons/XFMG/XF/Entity/User.php at line 74
- XFMG\XF\Entity\User::getStructure() in src/XF/Mvc/Entity/Manager.php at line 70
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 57
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 31
- XF\Repository\User->getVisitor() in src/XF/App.php at line 1560
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 97
- XF\Pub\App->start() in src/XF/App.php at line 1927
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('svContentRatingsBlacklist')
Run Time: 0.000112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/addons/SV/ContentRatings/Repository/RatingType.php at line 242
- SV\ContentRatings\Repository\RatingType->getRatingBlacklist() in src/addons/SV/ContentRatings/Repository/RatingType.php at line 253
- SV\ContentRatings\Repository\RatingType->isRatingBlacklistedForContent() in src/addons/SV/ContentRatings/Entity/DynamicRatingCounts.php at line 288
- SV\ContentRatings\Entity\DynamicRatingCounts::getRatingStructure() in src/addons/SV/ContentRatings/Entity/DynamicRatingCounts.php at line 325
- SV\ContentRatings\Entity\DynamicRatingCounts::getStructure() in src/XF/Mvc/Entity/Manager.php at line 70
- XF\Mvc\Entity\Manager->getEntityStructure() in src/addons/SV/ContentRatings/Entity/Ratable.php at line 558
- SV\ContentRatings\XF\Entity\User::getStructure() in src/addons/XFRM/XF/Entity/User.php at line 38
- XFRM\XF\Entity\User::getStructure() in src/addons/XFMG/XF/Entity/User.php at line 74
- XFMG\XF\Entity\User::getStructure() in src/XF/Mvc/Entity/Manager.php at line 70
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 57
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 31
- XF\Repository\User->getVisitor() in src/XF/App.php at line 1560
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 97
- XF\Pub\App->start() in src/XF/App.php at line 1927
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000135
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 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- 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 903
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 225
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 117
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
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.000334
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | ALL | | | | | 3 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,paypercallers.xf_rm_category.resource_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- 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 12
- XFRM\ControllerPlugin\Overview->getCategoryListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 31
- XFRM\Pub\Controller\ResourceItem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT COUNT(*)
FROM `xf_rm_resource`
WHERE (`xf_rm_resource`.`resource_category_id` IN (2, 4, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
Run Time: 0.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | category_last_update,category_rating_weighted | | | | 13 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1118
- XF\Mvc\Entity\Finder->total() in src/addons/XFRM/ControllerPlugin/Overview.php at line 39
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 34
- XFRM\Pub\Controller\ResourceItem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_rm_resource_version_CurrentVersion_2`.*, `xf_rm_resource_feature_Featured_3`.*, `xf_rm_category_Category_4`.*
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_resource_feature` AS `xf_rm_resource_feature_Featured_3` ON (`xf_rm_resource_feature_Featured_3`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_4` ON (`xf_rm_category_Category_4`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (2, 4, 6)) AND ((`xf_rm_resource`.`resource_state` IN ('visible')))
ORDER BY `xf_rm_resource`.`last_update` DESC
LIMIT 20
Run Time: 0.000699
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | category_last_update,category_rating_weighted | | | | 13 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_2 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_resource_feature_Featured_3 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.resource_id | 1 | |
SIMPLE | xf_rm_category_Category_4 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.resource_category_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/ControllerPlugin/Overview.php at line 45
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 34
- XFRM\Pub\Controller\ResourceItem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_rm_resource`.*, `xf_rm_resource_feature_Featured_1`.*, `xf_user_User_2`.*, `xf_rm_resource_version_CurrentVersion_3`.*, `xf_rm_category_Category_4`.*
FROM `xf_rm_resource`
INNER JOIN `xf_rm_resource_feature` AS `xf_rm_resource_feature_Featured_1` ON (`xf_rm_resource_feature_Featured_1`.`resource_id` = `xf_rm_resource`.`resource_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_3` ON (`xf_rm_resource_version_CurrentVersion_3`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_4` ON (`xf_rm_category_Category_4`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
WHERE (`xf_rm_resource`.`resource_category_id` IN (2, 4, 6)) AND (`xf_rm_resource`.`resource_state` = 'visible')
ORDER BY RAND() ASC
LIMIT 5
Run Time: 0.000977
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_feature_Featured_1 | index | PRIMARY | feature_date | 4 | | 1 | Using index; Using temporary; Using filesort |
SIMPLE | xf_rm_resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | paypercallers.xf_rm_resource_feature_Featured_1.resource_id | 1 | Using where |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_3 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.current_version_id | 1 | |
SIMPLE | xf_rm_category_Category_4 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.resource_category_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/ControllerPlugin/Overview.php at line 50
- XFRM\ControllerPlugin\Overview->getCoreListData() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 34
- XFRM\Pub\Controller\ResourceItem->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XFRM\Pub\Controller\ResourceItem, Index, valid, , 1715218761,
Run Time: 0.000092
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 66
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 278
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
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.000560
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | | | | | 13 | Using where; Using filesort |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,paypercallers.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/Widget/TopResources.php at line 80
- XFRM\Widget\TopResources->render() in src/XF/Template/Templater.php at line 1525
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/xfrm_overview.php at line 153
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1249
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
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` > 1712626761)
ORDER BY `xf_rm_resource_rating`.`rating_date` DESC
LIMIT 10
Run Time: 0.000577
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 where |
SIMPLE | xf_rm_resource_Resource_1 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource_rating.resource_id | 1 | Using where |
SIMPLE | xf_rm_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource_Resource_1.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,paypercallers.xf_rm_category_Category_2.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | paypercallers.xf_rm_resource_rating.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFRM/Widget/LatestReviews.php at line 27
- XFRM\Widget\LatestReviews->render() in src/XF/Template/Templater.php at line 1525
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/xfrm_overview.php at line 153
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1249
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_member_stat`.*
FROM `xf_member_stat`
WHERE (`xf_member_stat`.`member_stat_key` = 'xfrm_most_resources')
LIMIT 1
Run Time: 0.000177
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 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1130
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 168
- XF\Mvc\Entity\Manager->findOne() in src/XF/Widget/AbstractWidget.php at line 184
- XF\Widget\AbstractWidget->findOne() in src/XF/Widget/MemberStat.php at line 37
- XF\Widget\MemberStat->render() in src/XF/Template/Templater.php at line 1525
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/xfrm_overview.php at line 153
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1249
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*, `xf_sv_rating_cache_User_RatingData_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_sv_rating_cache_User` AS `xf_sv_rating_cache_User_RatingData_1` ON (`xf_sv_rating_cache_User_RatingData_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (4)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.000639
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY,user_state | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_sv_rating_cache_User_RatingData_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/MemberStat.php at line 55
- XF\Widget\MemberStat->render() in src/XF/Template/Templater.php at line 1525
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s1/public/xfrm_overview.php at line 153
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1249
- 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 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (46))
Run Time: 0.000208
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | 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 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 173
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 99
- XF\Navigation\NodeType::displayNode() in internal_data/code_cache/navigation_cache.php at line 179
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 5748
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 462
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 415
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1766
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 310
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_forum`.*, `xf_node_Node_1`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` IN (46))
Run Time: 0.000279
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1163
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 121
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 202
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 99
- XF\Navigation\NodeType::displayNode() in internal_data/code_cache/navigation_cache.php at line 179
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 5748
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 462
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 415
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1766
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 310
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session
(session_id, session_data, expiry_date)
VALUES
(?, ?, ?)
ON DUPLICATE KEY UPDATE
session_data = VALUES(session_data),
expiry_date = VALUES(expiry_date)
Params: 3PtWm-iqdghC3RVPkszzIR_tpJAWVLdJ, , 1715233161
Run Time: 0.000158
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in src/XF/Pub/App.php at line 360
- XF\Pub\App->complete() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
bytes_sent | 17725 |
bytes_received | 303433 |
packets_sent | 184 |
packets_received | 1749 |
protocol_overhead_in | 6996 |
protocol_overhead_out | 736 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 414 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 184 |
bytes_received_prepare_response_packet | 133938 |
bytes_received_change_user_packet | 168180 |
packets_sent_command | 91 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 46 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 32 |
packets_received_prepare_response | 1510 |
packets_received_change_user | 129 |
result_set_queries | 28 |
non_result_set_queries | 4 |
no_index_used | 6 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 28 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 29 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 101 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 101 |
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 | 101 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 50 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 405 |
proto_binary_fetched_int24 | 182 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1221 |
proto_binary_fetched_decimal | 70 |
proto_binary_fetched_float | 22 |
proto_binary_fetched_double | 44 |
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 | 797 |
proto_binary_fetched_blob | 211 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 30 |
com_stmt_execute | 30 |
com_stmt_send_long_data | 0 |
com_stmt_close | 29 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 166007 |