Page Time: 0.1006s

Memory: 12.0718 MB (Peak: 12.9015 MB)

Queries (60, time: 0.0161s, 16.0%)

1. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000168

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
   4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
   5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
   6. XF\Entity\User->hasPermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 273
   7. DBTech\Shop\XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 242
   8. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
   9. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
   10. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
   11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   15. XF\App->run() in src/XF.php at line 488
   16. XF::runApp() in index.php at line 20

2. SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
   FROM `xf_user`
   LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
   LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
   LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
   WHERE (`xf_user`.`user_id` = '687')
   
   
   LIMIT 1

   Run Time: 0.000421

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_option_Option_1	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_privacy_Privacy_2	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_user_profile_Profile_3	const	PRIMARY	PRIMARY	4	const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
   3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
   4. XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1209
   5. XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 642
   6. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   7. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   12. XF\App->run() in src/XF.php at line 488
   13. XF::runApp() in index.php at line 20

3. SELECT `xf_dbtech_shop_category`.*, `xf_permission_cache_content_Permissions_1`.*
   FROM `xf_dbtech_shop_category`
   LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'dbtech_shop_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_dbtech_shop_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
   
   ORDER BY `xf_dbtech_shop_category`.`lft` ASC

   Run Time: 0.000256

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_dbtech_shop_category	ALL					8	Using filesort
   SIMPLE	xf_permission_cache_content_Permissions_1	eq_ref	PRIMARY	PRIMARY	35	const,const,fire.xf_dbtech_shop_category.category_id	1	Using where

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
   3. XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Shop/Search/Data/Item.php at line 262
   4. DBTech\Shop\Search\Data\Item->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   5. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   6. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   7. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   8. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   9. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   14. XF\App->run() in src/XF.php at line 488
   15. XF::runApp() in index.php at line 20

4. SELECT `xf_node`.*, `xf_snog_groups_Group_1`.*, `xf_snog_groups_subforums_Subforum_2`.*, `xf_snog_tv_forum_TVForum_3`.*
   FROM `xf_node`
   LEFT JOIN `xf_snog_groups` AS `xf_snog_groups_Group_1` ON (`xf_snog_groups_Group_1`.`node_id` = `xf_node`.`node_id`)
   LEFT JOIN `xf_snog_groups_subforums` AS `xf_snog_groups_subforums_Subforum_2` ON (`xf_snog_groups_subforums_Subforum_2`.`node_id` = `xf_node`.`node_id`)
   LEFT JOIN `xf_snog_tv_forum` AS `xf_snog_tv_forum_TVForum_3` ON (`xf_snog_tv_forum_TVForum_3`.`node_id` = `xf_node`.`node_id`)
   
   ORDER BY `xf_node`.`lft` ASC

   Run Time: 0.000470

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_node	ALL					54	Using filesort
   SIMPLE	xf_snog_groups_Group_1	ref	node_id	node_id	4	fire.xf_node.node_id	1
   SIMPLE	xf_snog_groups_subforums_Subforum_2	eq_ref	PRIMARY	PRIMARY	4	fire.xf_node.node_id	1
   SIMPLE	xf_snog_tv_forum_TVForum_3	eq_ref	PRIMARY	PRIMARY	4	fire.xf_node.node_id	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
   3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 36
   4. XF\Repository\Node->getFullNodeList() in src/XF/Search/Data/Post.php at line 255
   5. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   6. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   7. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   8. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   9. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   10. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   15. XF\App->run() in src/XF.php at line 488
   16. XF::runApp() in index.php at line 20

5. SELECT `xf_category`.*, `xf_node_Node_1`.*
   FROM `xf_category`
   LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
   WHERE (`xf_category`.`node_id` IN (1, 39, 4, 7, 12, 27, 21))

   Run Time: 0.000136

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_category	index	PRIMARY	PRIMARY	4		7	Using where; Using index
   SIMPLE	xf_node_Node_1	eq_ref	PRIMARY	PRIMARY	4	fire.xf_category.node_id	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
   3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
   4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
   5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Search/Data/Post.php at line 256
   6. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   7. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   8. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   9. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   10. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   11. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   12. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   13. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   16. XF\App->run() in src/XF.php at line 488
   17. XF::runApp() in index.php at line 20

6. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_snog_groups_Group_2`.*, `xf_snog_groups_settings_Settings_3`.*, `xf_snog_groups_subforums_Subforum_4`.*, `xf_snog_movies_forum_Movieforum_5`.*, `xf_snog_tv_forum_TVForum_6`.*, `xf_snog_tv_node_TVnode_7`.*, `xf_user_LastPostUser_8`.*, `xf_thread_LastThread_9`.*
   FROM `xf_forum`
   LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
   LEFT JOIN `xf_snog_groups` AS `xf_snog_groups_Group_2` ON (`xf_snog_groups_Group_2`.`node_id` = `xf_node_Node_1`.`node_id`)
   LEFT JOIN `xf_snog_groups_settings` AS `xf_snog_groups_settings_Settings_3` ON (`xf_snog_groups_settings_Settings_3`.`id` = 1)
   LEFT JOIN `xf_snog_groups_subforums` AS `xf_snog_groups_subforums_Subforum_4` ON (`xf_snog_groups_subforums_Subforum_4`.`node_id` = `xf_node_Node_1`.`node_id`)
   LEFT JOIN `xf_snog_movies_forum` AS `xf_snog_movies_forum_Movieforum_5` ON (`xf_snog_movies_forum_Movieforum_5`.`node_id` = `xf_forum`.`node_id`)
   LEFT JOIN `xf_snog_tv_forum` AS `xf_snog_tv_forum_TVForum_6` ON (`xf_snog_tv_forum_TVForum_6`.`node_id` = `xf_forum`.`node_id`)
   LEFT JOIN `xf_snog_tv_node` AS `xf_snog_tv_node_TVnode_7` ON (`xf_snog_tv_node_TVnode_7`.`node_id` = `xf_forum`.`node_id`)
   LEFT JOIN `xf_user` AS `xf_user_LastPostUser_8` ON (`xf_user_LastPostUser_8`.`user_id` = `xf_forum`.`last_post_user_id`)
   LEFT JOIN `xf_thread` AS `xf_thread_LastThread_9` ON (`xf_thread_LastThread_9`.`thread_id` = `xf_forum`.`last_thread_id`)
   WHERE (`xf_forum`.`node_id` IN (2, 31, 3, 24, 25, 54, 62, 53, 61, 63, 56, 60, 55, 41, 46, 42, 47, 43, 44, 5, 67, 65, 28, 6, 29, 33, 8, 10, 9, 11, 66, 13, 17, 19, 14, 15, 16, 20, 49, 26, 35, 48, 68, 51, 57, 64, 22))

   Run Time: 0.001608

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_forum	ALL	PRIMARY				47	Using where
   SIMPLE	xf_node_Node_1	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.node_id	1
   SIMPLE	xf_snog_groups_Group_2	ref	node_id	node_id	4	fire.xf_node_Node_1.node_id	1	Using where
   SIMPLE	xf_snog_groups_settings_Settings_3	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	xf_snog_groups_subforums_Subforum_4	eq_ref	PRIMARY	PRIMARY	4	fire.xf_node_Node_1.node_id	1	Using where
   SIMPLE	xf_snog_movies_forum_Movieforum_5	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.node_id	1
   SIMPLE	xf_snog_tv_forum_TVForum_6	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.node_id	1
   SIMPLE	xf_snog_tv_node_TVnode_7	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.node_id	1
   SIMPLE	xf_user_LastPostUser_8	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.last_post_user_id	1
   SIMPLE	xf_thread_LastThread_9	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum.last_thread_id	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
   3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
   4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
   5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Search/Data/Post.php at line 256
   6. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   7. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   8. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   9. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   10. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   11. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   12. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   13. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   16. XF\App->run() in src/XF.php at line 488
   17. XF::runApp() in index.php at line 20

7. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, node, 2
   Run Time: 0.000088

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
   6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
   7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
   9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
   10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
   11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   21. XF\App->run() in src/XF.php at line 488
   22. XF::runApp() in index.php at line 20

8. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, node, 31
   Run Time: 0.000080

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
   6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
   7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
   9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
   10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
   11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   21. XF\App->run() in src/XF.php at line 488
   22. XF::runApp() in index.php at line 20

9. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, node, 3
   Run Time: 0.000066

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
   6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
   7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
   9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
   10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
   11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
   12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
   13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
   14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
   15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
   16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
   17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
   18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
   19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
   20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
   21. XF\App->run() in src/XF.php at line 488
   22. XF::runApp() in index.php at line 20

10. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 24
    Run Time: 0.000062

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

11. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 25
    Run Time: 0.000061

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

12. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 54
    Run Time: 0.000066

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

13. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 62
    Run Time: 0.000062

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

14. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 53
    Run Time: 0.000061

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

15. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 61
    Run Time: 0.000059

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

16. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 63
    Run Time: 0.000059

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

17. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 56
    Run Time: 0.000058

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

18. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 60
    Run Time: 0.000059

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

19. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 55
    Run Time: 0.000047

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

20. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 41
    Run Time: 0.000047

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

21. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 46
    Run Time: 0.000058

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

22. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 42
    Run Time: 0.000047

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

23. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 47
    Run Time: 0.000047

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

24. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 43
    Run Time: 0.000046

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

25. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 44
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

26. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 5
    Run Time: 0.000061

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

27. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 67
    Run Time: 0.000053

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

28. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 65
    Run Time: 0.000072

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

29. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 28
    Run Time: 0.000058

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

30. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 6
    Run Time: 0.000052

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

31. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 29
    Run Time: 0.000051

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

32. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 33
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

33. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 8
    Run Time: 0.000064

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

34. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 10
    Run Time: 0.000101

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

35. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 9
    Run Time: 0.000054

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

36. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 11
    Run Time: 0.000054

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

37. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 66
    Run Time: 0.000067

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

38. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 13
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

39. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 17
    Run Time: 0.000060

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

40. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 19
    Run Time: 0.000059

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

41. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 14
    Run Time: 0.000059

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

42. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 15
    Run Time: 0.000060

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

43. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 16
    Run Time: 0.000072

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

44. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 20
    Run Time: 0.000071

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

45. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 49
    Run Time: 0.000075

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

46. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 26
    Run Time: 0.000071

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

47. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 35
    Run Time: 0.000070

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

48. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 48
    Run Time: 0.000072

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

49. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 68
    Run Time: 0.000071

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

50. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 51
    Run Time: 0.000070

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

51. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 57
    Run Time: 0.000070

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

52. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 64
    Run Time: 0.000071

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

53. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, node, 22
    Run Time: 0.000070

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 1186
    6. XF\Entity\User->hasNodePermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 332
    7. DBTech\Shop\XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    8. XF\Entity\AbstractNode->canView() in src/addons/Snog/Groups/XF/Entity/Forum.php at line 11
    9. Snog\Groups\XF\Entity\Forum->canView() in src/XF/Entity/Node.php at line 52
    10. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 266
    11. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 237
    12. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 210
    13. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    14. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    15. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    16. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    17. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    18. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    19. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    20. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    21. XF\App->run() in src/XF.php at line 488
    22. XF::runApp() in index.php at line 20

54. SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
    FROM `xf_post`
    LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
    LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
    LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
    WHERE (`xf_post`.`post_id` IN (3568089, 3567105, 3566723, 3566368, 3565002, 3564455, 3563532, 3557475, 3554793, 3554788, 3554015, 3548811, 3548690, 3546493, 3546356, 3545748, 3544501, 3544177, 3542214, 3542206, 3541489, 3541094, 3540995, 3540967, 3540700, 3540377, 3539933, 3539906, 3538834, 3538828, 3538763, 3538755, 3538754, 3538495, 3538100, 3537318, 3536940, 3536732, 3536597, 3536276, 3529649, 3528471, 3526297, 3526066, 3526044, 3525632, 3525619, 3522365, 3520185, 3519287, 3516243, 3511991, 3511978, 3511938, 3511936, 3509841, 3507933, 3507298, 3506781, 3506748, 3503464, 3503460, 3500992, 3499236, 3493372, 3493232, 3486906, 3484594, 3483282, 3483130, 3483122, 3482992, 3476552, 3469981, 3469212, 3468285, 3463740, 3460230, 3457546, 3453798, 3453785, 3453677, 3452781, 3451714, 3448402, 3447926, 3443327, 3442435, 3440511, 3439814, 3439671, 3435027, 3433774, 3432658, 3432633, 3430504, 3429100, 3428776, 3425853, 3423262, 3423237, 3422044, 3421851, 3421842, 3421832, 3421830, 3419827, 3419578, 3417169, 3416838, 3415461, 3414141, 3413594, 3411886, 3411322, 3410759, 3409300, 3405150, 3402130, 3401932, 3399050, 3399045, 3393880, 3389545, 3389537, 3388747, 3385373, 3382625, 3381857, 3379584, 3379087, 3376906, 3375098, 3375097, 3375032, 3372059, 3370500, 3368826, 3368547, 3365523, 3364168, 3363053, 3362926, 3362911, 3360553, 3359401, 3359386, 3357130, 3355545, 3355542, 3355405, 3355393, 3354518, 3354178, 3353081, 3353067, 3352951, 3351508, 3350142, 3346119, 3344563, 3344353, 3343096, 3340458, 3339555, 3339449, 3338229, 3337103, 3333620, 3333459, 3332834, 3328618, 3328610, 3328352, 3323795, 3320346, 3319578, 3319237, 3319234, 3315152, 3315148, 3314153, 3313771, 3312800, 3312779, 3308865, 3308380, 3307159, 3304742, 3296621, 3296535, 3294124, 3287953, 3285715, 3285709, 3282573, 3278429, 3276180, 3268896))

    Run Time: 0.004690

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_post	range	PRIMARY	PRIMARY	4		199	Using where
    SIMPLE	xf_thread_Thread_1	eq_ref	PRIMARY	PRIMARY	4	fire.xf_post.thread_id	1
    SIMPLE	xf_forum_Forum_2	eq_ref	PRIMARY	PRIMARY	4	fire.xf_thread_Thread_1.node_id	1	Using where
    SIMPLE	xf_node_Node_3	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum_Forum_2.node_id	1	Using where
    SIMPLE	xf_user_User_4	eq_ref	PRIMARY	PRIMARY	4	fire.xf_post.user_id	1
    SIMPLE	xf_permission_cache_content_Permissions_5	eq_ref	PRIMARY	PRIMARY	35	const,const,fire.xf_node_Node_3.node_id	1	Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
    11. XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 214
    12. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    13. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    14. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    15. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    16. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    17. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    18. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    19. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    20. XF\App->run() in src/XF.php at line 488
    21. XF::runApp() in index.php at line 20

55. SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
    FROM `xf_thread`
    LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
    LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
    LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
    WHERE (`xf_thread`.`thread_id` IN (12107))

    Run Time: 0.000594

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_thread	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_forum_Forum_1	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_node_Node_2	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_post_FirstPost_3	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_user_User_4	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_permission_cache_content_Permissions_5	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
    11. XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 214
    12. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 179
    13. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 650
    14. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    15. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    16. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    17. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    18. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    19. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    20. XF\App->run() in src/XF.php at line 488
    21. XF::runApp() in index.php at line 20

56. SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
    FROM `xf_post`
    LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
    LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
    LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
    WHERE (`xf_post`.`post_id` IN (3568089, 3567105, 3566723, 3566368, 3565002, 3564455, 3563532, 3557475, 3554793, 3554788, 3554015, 3548811, 3548690, 3546493, 3546356, 3545748, 3544501, 3544177, 3542214, 3542206, 3541489, 3541094, 3540995, 3540967, 3540700, 3540377, 3539933, 3538834, 3538828, 3538763, 3538755, 3538754, 3538495, 3538100, 3537318, 3536940, 3536732, 3536597, 3536276, 3529649, 3528471, 3526297, 3526066, 3526044, 3525632, 3525619, 3522365, 3520185, 3519287, 3511991, 3511978, 3511938, 3511936, 3509841, 3507933, 3507298, 3506781, 3506748, 3503464, 3503460, 3500992, 3499236, 3493372, 3493232, 3486906, 3484594, 3483282, 3483130, 3483122, 3482992, 3476552, 3469981, 3468285, 3463740, 3460230, 3457546, 3453798, 3453785, 3453677, 3452781, 3451714, 3448402, 3443327, 3442435, 3440511, 3439814, 3439671, 3435027, 3433774, 3432658, 3432633, 3430504, 3429100, 3428776, 3425853, 3423262, 3422044, 3421851, 3421842, 3421832, 3421830, 3419827, 3419578, 3417169, 3416838, 3415461, 3414141, 3413594, 3411886, 3411322, 3410759, 3409300, 3405150, 3402130, 3401932, 3399050, 3399045, 3393880, 3389545, 3389537, 3388747, 3385373, 3382625, 3381857, 3379584, 3379087, 3376906, 3375098, 3375097, 3375032, 3372059, 3370500, 3368826, 3368547, 3365523, 3364168, 3363053, 3362911, 3360553, 3359401, 3359386, 3357130, 3355545, 3355542, 3355405, 3355393, 3354518, 3353067, 3352951, 3351508, 3350142, 3346119, 3344563, 3344353, 3343096, 3340458, 3339555, 3339449, 3338229, 3337103, 3333620, 3333459, 3332834, 3328618, 3328610, 3328352, 3323795, 3320346, 3319578, 3319237, 3319234, 3315152, 3315148, 3314153, 3313771, 3312800, 3312779, 3308865, 3308380, 3307159, 3304742, 3296621, 3296535, 3294124, 3287953, 3285715, 3285709, 3282573, 3278429, 3276180, 3268896))

    Run Time: 0.003077

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_post	range	PRIMARY	PRIMARY	4		191	Using where
    SIMPLE	xf_thread_Thread_1	eq_ref	PRIMARY	PRIMARY	4	fire.xf_post.thread_id	1
    SIMPLE	xf_forum_Forum_2	eq_ref	PRIMARY	PRIMARY	4	fire.xf_thread_Thread_1.node_id	1	Using where
    SIMPLE	xf_node_Node_3	eq_ref	PRIMARY	PRIMARY	4	fire.xf_forum_Forum_2.node_id	1	Using where
    SIMPLE	xf_user_User_4	eq_ref	PRIMARY	PRIMARY	4	fire.xf_post.user_id	1
    SIMPLE	xf_permission_cache_content_Permissions_5	eq_ref	PRIMARY	PRIMARY	35	const,const,fire.xf_node_Node_3.node_id	1	Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
    11. XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 651
    12. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    13. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    18. XF\App->run() in src/XF.php at line 488
    19. XF::runApp() in index.php at line 20

57. SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
    FROM `xf_thread`
    LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
    LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
    LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
    WHERE (`xf_thread`.`thread_id` IN (12107))

    Run Time: 0.000405

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_thread	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_forum_Forum_1	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_node_Node_2	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_post_FirstPost_3	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_user_User_4	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	xf_permission_cache_content_Permissions_5	const	PRIMARY	PRIMARY	35	const,const,const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 135
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 264
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 228
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 181
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 191
    11. XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 651
    12. XF\Pub\Controller\Member->actionRecentContent() in src/addons/SV/ReportImprovements/XF/Pub/Controller/Member.php at line 22
    13. SV\ReportImprovements\XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 350
    14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    18. XF\App->run() in src/XF.php at line 488
    19. XF::runApp() in index.php at line 20

58. -- 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, , , XF\Pub\Controller\Member, RecentContent, valid, user_id=687, 1610745982,
    Run Time: 0.000079
    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/Yugensoft/TimeSpentOnline/XF/Repository/SessionActivity.php at line 27
    4. Yugensoft\TimeSpentOnline\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
    5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
    6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
    7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    12. XF\App->run() in src/XF.php at line 488
    13. XF::runApp() in index.php at line 20

59. SELECT `xf_dbtech_shop_item`.*, `xf_user_User_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_dbtech_shop_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
    FROM `xf_dbtech_shop_item`
    LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_dbtech_shop_item`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'dbtech_shop_item' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_dbtech_shop_item`.`item_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
    LEFT JOIN `xf_dbtech_shop_category` AS `xf_dbtech_shop_category_Category_3` ON (`xf_dbtech_shop_category_Category_3`.`category_id` = `xf_dbtech_shop_item`.`category_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'dbtech_shop_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_dbtech_shop_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')

    Run Time: 0.001076

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_dbtech_shop_item	ALL					81
    SIMPLE	xf_user_User_1	eq_ref	PRIMARY	PRIMARY	4	fire.xf_dbtech_shop_item.user_id	1
    SIMPLE	xf_permission_cache_content_Permissions_2	eq_ref	PRIMARY	PRIMARY	35	const,const,fire.xf_dbtech_shop_item.item_id	1	Using where
    SIMPLE	xf_dbtech_shop_category_Category_3	eq_ref	PRIMARY	PRIMARY	4	fire.xf_dbtech_shop_item.category_id	1
    SIMPLE	xf_permission_cache_content_Permissions_4	eq_ref	PRIMARY	PRIMARY	35	const,const,fire.xf_dbtech_shop_category_Category_3.category_id	1	Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/DBTech/Shop/XF/Entity/User.php at line 228
    4. DBTech\Shop\XF\Entity\User->getDbtechShopPurchase() in src/XF/Mvc/Entity/Entity.php at line 157
    5. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
    6. XF\Mvc\Entity\Entity->__get() in src/addons/DBTech/Shop/Repository/Purchase.php at line 296
    7. DBTech\Shop\Repository\Purchase->getViewablePurchasesForUser() in src/addons/DBTech/Shop/Repository/Purchase.php at line 331
    8. DBTech\Shop\Repository\Purchase->filterActivePurchasesForUser() in src/addons/DBTech/Shop/XF/Template/Templater.php at line 101
    9. DBTech\Shop\XF\Template\Templater->fnUsernameClasses() in src/addons/ThemeHouse/UserImprovements/XF/Template/Templater.php at line 24
    10. ThemeHouse\UserImprovements\XF\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4454
    11. XF\Template\Templater->fnUsernameLink()
    12. call_user_func_array() in src/XF/Template/Templater.php at line 1103
    13. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s66/public/search_result_post.php at line 39
    14. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
    15. XF\Template\Templater->renderTemplate() in src/XF/Search/Data/AbstractData.php at line 51
    16. XF\Search\Data\AbstractData->renderResult() in src/XF/Search/RenderWrapper.php at line 31
    17. XF\Search\RenderWrapper->render()
    18. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    19. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s66/public/member_recent_content.php at line 33
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
    21. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    22. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    23. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    24. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    25. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    26. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    27. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    28. XF\App->run() in src/XF.php at line 488
    29. XF::runApp() in index.php at line 20

60. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?

    Params: 851
    Run Time: 0.000121

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
    6. XF\Entity\User->hasPermission() in src/addons/DBTech/Shop/XF/Entity/User.php at line 273
    7. DBTech\Shop\XF\Entity\User->hasPermission() in src/addons/ThemeHouse/UserImprovements/XF/Template/Templater.php at line 27
    8. ThemeHouse\UserImprovements\XF\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 4454
    9. XF\Template\Templater->fnUsernameLink()
    10. call_user_func_array() in src/XF/Template/Templater.php at line 1103
    11. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s66/public/search_result_post.php at line 39
    12. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
    13. XF\Template\Templater->renderTemplate() in src/XF/Search/Data/AbstractData.php at line 51
    14. XF\Search\Data\AbstractData->renderResult() in src/XF/Search/RenderWrapper.php at line 31
    15. XF\Search\RenderWrapper->render()
    16. call_user_func_array() in src/XF/Template/Templater.php at line 1166
    17. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s66/public/member_recent_content.php at line 33
    18. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1626
    19. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    20. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    21. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    22. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    23. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    24. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    25. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    26. XF\App->run() in src/XF.php at line 488
    27. XF::runApp() in index.php at line 20