Page Time: 0.1087s

Memory: 10.9002 MB (Peak: 11.0884 MB)

Queries (27, time: 0.0111s, 10.2%)

1. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')

   Run Time: 0.000355

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	ALL	PRIMARY				40	Using where

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
   3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
   4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
   5. XF\DataRegistry->get() in src/XF/App.php at line 1509
   6. XF\App->preLoadData() in src/XF/App.php at line 1499
   7. XF\App->setup() in src/XF/Pub/App.php at line 45
   8. XF\Pub\App->setup() in src/XF.php at line 312
   9. XF::setupApp() in src/XF.php at line 324
   10. XF::runApp() in index.php at line 13

2. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000178

   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 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
   4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
   5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 915
   6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 224
   7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
   8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 117
   9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
   10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   13. XF\App->run() in src/XF.php at line 328
   14. XF::runApp() in index.php at line 13

3. 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` = '324')
   
   
   LIMIT 1

   Run Time: 0.000820

   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 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1117
   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 1042
   5. XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 524
   6. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   10. XF\App->run() in src/XF.php at line 328
   11. XF::runApp() in index.php at line 13

4. SELECT `xf_node`.*
   FROM `xf_node`
   
   
   ORDER BY `xf_node`.`lft` ASC

   Run Time: 0.000285

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_node	ALL					19	Using filesort

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
   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 240
   5. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   6. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   7. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   8. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   12. XF\App->run() in src/XF.php at line 328
   13. XF::runApp() in index.php at line 13

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, 5, 8, 15, 13))

   Run Time: 0.000255

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

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
   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 121
   5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Search/Data/Post.php at line 241
   6. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   7. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   8. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   9. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   13. XF\App->run() in src/XF.php at line 328
   14. XF::runApp() in index.php at line 13

6. SELECT `xf_forum`.*, `xf_node_Node_1`.*
   FROM `xf_forum`
   LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
   WHERE (`xf_forum`.`node_id` IN (2, 3, 4, 20, 6, 19, 10, 7, 9, 11, 16, 17, 18, 14))

   Run Time: 0.000433

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_forum	ALL	PRIMARY				14	Using where
   SIMPLE	xf_node_Node_1	eq_ref	PRIMARY	PRIMARY	4	forum.xf_forum.node_id	1

   
   
   1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
   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 121
   5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Search/Data/Post.php at line 241
   6. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   7. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   8. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   9. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   13. XF\App->run() in src/XF.php at line 328
   14. XF::runApp() in index.php at line 13

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.000153

   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 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
   6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
   8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
   9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   16. XF\App->run() in src/XF.php at line 328
   17. XF::runApp() in index.php at line 13

8. 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.000111

   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 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
   6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
   8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
   9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   16. XF\App->run() in src/XF.php at line 328
   17. XF::runApp() in index.php at line 13

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

   Params: 1, node, 4
   Run Time: 0.000164

   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 79
   2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
   3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
   4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
   5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
   6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
   7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
   8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
   9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
   10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
   11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
   12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
   13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
   14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
   15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
   16. XF\App->run() in src/XF.php at line 328
   17. XF::runApp() in index.php at line 13

10. 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.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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

11. 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.000094

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

12. 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.000095

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

13. 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.000102

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

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

    Params: 1, node, 7
    Run Time: 0.000138

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

15. 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.000108

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

16. 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.000089

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

17. 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.000198

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

18. 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.000087

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

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

    Params: 1, node, 18
    Run Time: 0.000102

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

20. 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.000098

    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 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 72
    4. XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
    5. XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 925
    6. XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
    7. XF\Entity\AbstractNode->canView() in src/XF/Entity/Node.php at line 47
    8. XF\Entity\Node->canView() in src/XF/Search/Data/Post.php at line 251
    9. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 189
    10. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 162
    11. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

21. SELECT search_index.content_type, search_index.content_id
    FROM xf_search_index AS search_index
    
    WHERE MATCH(search_index.title, search_index.metadata) AGAINST ('-_md_hidden_1 +_md_user_324' IN BOOLEAN MODE)
    
    ORDER BY search_index.item_date DESC
    LIMIT 200

    Run Time: 0.002205

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	search_index	fulltext	title_metadata	title_metadata	0		1	Using where; Using filesort

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 101
    3. XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 292
    4. XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 164
    5. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    6. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    10. XF\App->run() in src/XF.php at line 328
    11. XF::runApp() in index.php at line 13

22. 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 (214, 209))

    Run Time: 0.001593

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_thread	range	PRIMARY	PRIMARY	4		2	Using where
    SIMPLE	xf_forum_Forum_1	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.node_id	1
    SIMPLE	xf_node_Node_2	eq_ref	PRIMARY	PRIMARY	4	forum.xf_forum_Forum_1.node_id	1	Using where
    SIMPLE	xf_post_FirstPost_3	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.first_post_id	1
    SIMPLE	xf_user_User_4	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.user_id	1
    SIMPLE	xf_permission_cache_content_Permissions_5	eq_ref	PRIMARY	PRIMARY	35	const,const,forum.xf_node_Node_2.node_id	1	Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
    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 2245
    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 216
    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 166
    12. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    13. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    17. XF\App->run() in src/XF.php at line 328
    18. XF::runApp() in index.php at line 13

23. 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 (918, 896, 895, 894, 893))

    Run Time: 0.001074

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

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
    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 2245
    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 216
    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 166
    12. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 532
    13. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    17. XF\App->run() in src/XF.php at line 328
    18. XF::runApp() in index.php at line 13

24. 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 (214, 209))

    Run Time: 0.000528

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_thread	range	PRIMARY	PRIMARY	4		2	Using where
    SIMPLE	xf_forum_Forum_1	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.node_id	1
    SIMPLE	xf_node_Node_2	eq_ref	PRIMARY	PRIMARY	4	forum.xf_forum_Forum_1.node_id	1	Using where
    SIMPLE	xf_post_FirstPost_3	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.first_post_id	1
    SIMPLE	xf_user_User_4	eq_ref	PRIMARY	PRIMARY	4	forum.xf_thread.user_id	1
    SIMPLE	xf_permission_cache_content_Permissions_5	eq_ref	PRIMARY	PRIMARY	35	const,const,forum.xf_node_Node_2.node_id	1	Using where

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
    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 2245
    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 216
    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 533
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

25. 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 (918, 896, 895, 894, 893))

    Run Time: 0.000552

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

    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1150
    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 2245
    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 216
    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 533
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 249
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    14. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    15. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    16. XF\App->run() in src/XF.php at line 328
    17. XF::runApp() in index.php at line 13

26. -- 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=324, 1575596854,
    Run Time: 0.000227
    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 66
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 40
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 270
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    10. XF\App->run() in src/XF.php at line 328
    11. XF::runApp() in index.php at line 13

27. -- XFDB=noForceAllWrite
    INSERT INTO xf_session
    	(session_id, session_data, expiry_date)
    VALUES
    	(?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	session_data = VALUES(session_data),
    	expiry_date = VALUES(expiry_date)

    Params: CuqaS2ZCJJGknme3_eZzEjt3wmD4L6JQ, , 1575611254
    Run Time: 0.000975
    
    
    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
    3. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
    4. XF\Session\Session->save() in src/XF/Pub/App.php at line 360
    5. XF\Pub\App->complete() in src/XF/App.php at line 1892
    6. XF\App->run() in src/XF.php at line 328
    7. XF::runApp() in index.php at line 13

Included Files (126, XenForo Classes: 95)

1. index.php
2. src/XF.php
3. src/vendor/autoload.php
4. src/vendor/composer/autoload_real.php
5. src/vendor/composer/ClassLoader.php
6. src/vendor/composer/autoload_namespaces.php
7. src/vendor/composer/autoload_psr4.php
8. src/vendor/composer/autoload_classmap.php
9. src/vendor/composer/autoload_files.php
10. src/vendor/symfony/polyfill-mbstring/bootstrap.php
11. src/vendor/react/promise/src/functions_include.php
12. src/vendor/react/promise/src/functions.php
13. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
14. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
15. src/vendor/symfony/var-dumper/Resources/functions/dump.php
16. src/vendor/dokuwiki/utf8/utf8.php
17. src/XF/Pub/App.php
18. src/XF/App.php
19. src/XF/Container.php
20. src/config.php
21. src/XF/DataRegistry.php
22. src/XF/Db/Mysqli/Adapter.php
23. src/XF/Db/AbstractAdapter.php
24. src/XF/Db/Mysqli/Statement.php
25. src/XF/Db/AbstractStatement.php
26. src/XF/Extension.php
27. src/XF/Http/Request.php
28. src/XF/InputFilterer.php
29. src/XF/Session/Session.php
30. src/XF/Session/DbStorage.php
31. src/XF/Session/StorageInterface.php
32. src/XF/Util/Ip.php
33. src/XF/Util/Random.php
34. src/XF/Data/Robot.php
35. src/XF/Mvc/Entity/Manager.php
36. src/XF/Mvc/Entity/ValueFormatter.php
37. src/XF/Repository/User.php
38. src/XF/Mvc/Entity/Repository.php
39. src/XF/Entity/User.php
40. src/XF/Mvc/Entity/Entity.php
41. src/XF/Mvc/Entity/Structure.php
42. src/XF/Entity/UserAuth.php
43. src/XF/Entity/UserOption.php
44. src/XF/Entity/UserProfile.php
45. src/XF/Entity/UserPrivacy.php
46. src/XF/Util/File.php
47. src/XF/Language.php
48. src/XF/Mvc/Dispatcher.php
49. src/XF/Mvc/Router.php
50. src/addons/TurkishFriendlyLink/Listener.php
51. src/XF/Mvc/RouteMatch.php
52. src/XF/Util/Arr.php
53. src/XF/Mvc/ParameterBag.php
54. src/XF/Pub/Controller/Member.php
55. src/XF/Pub/Controller/AbstractController.php
56. src/XF/Mvc/Controller.php
57. src/XF/Util/Php.php
58. src/XF/PermissionCache.php
59. src/XF/PermissionSet.php
60. src/XF/Finder/User.php
61. src/XF/Mvc/Entity/Finder.php
62. src/XF/Search/Search.php
63. src/XF/ResultSetInterface.php
64. src/XF/Search/Source/MySqlFt.php
65. src/XF/Search/Source/AbstractSource.php
66. src/XF/Search/Query/Query.php
67. src/XF/Search/Data/Page.php
68. src/XF/Search/Data/AbstractData.php
69. src/XF/Search/Data/Post.php
70. src/XF/Search/Data/ProfilePost.php
71. src/XF/Search/Data/ProfilePostComment.php
72. src/XF/Search/Data/Thread.php
73. src/XF/Repository/Node.php
74. src/XF/Entity/Node.php
75. src/XF/Finder/Node.php
76. src/XF/Mvc/Entity/ArrayCollection.php
77. src/XF/Mvc/Entity/AbstractCollection.php
78. src/XF/Entity/Category.php
79. src/XF/Entity/AbstractNode.php
80. src/XF/Entity/Forum.php
81. src/XF/Search/Query/MetadataConstraint.php
82. src/XF/ResultSet.php
83. src/XF/Entity/Thread.php
84. src/XF/Finder/Thread.php
85. src/XF/Entity/Post.php
86. src/XF/Entity/QuotableInterface.php
87. src/XF/BbCode/RenderableContentInterface.php
88. src/XF/Entity/PermissionCacheContent.php
89. src/XF/Mvc/Entity/Proxyable.php
90. src/XF/Mvc/Entity/FinderCollection.php
91. src/XF/Finder/Post.php
92. src/XF/Search/RenderWrapper.php
93. src/XF/PreEscapedInterface.php
94. src/XF/Mvc/Reply/View.php
95. src/XF/Mvc/Reply/AbstractReply.php
96. src/XF/Repository/SessionActivity.php
97. src/XF/Style.php
98. src/XF/Template/Templater.php
99. src/XF/SubContainer/BbCode.php
100. src/XF/SubContainer/AbstractSubContainer.php
101. src/XF/SubContainer/Widget.php
102. src/XF/SimpleCache.php
103. src/XF/Http/Response.php
104. src/XF/Mvc/Renderer/Html.php
105. src/XF/Mvc/Renderer/AbstractRenderer.php
106. src/XF/Mvc/View.php
107. src/XF/Template/Template.php
108. internal_data/code_cache/templates/l5/s1/public/member_recent_content.php
109. src/XF/PreEscaped.php
110. internal_data/code_cache/templates/l5/s1/public/search_result_thread.php
111. src/XF/Str/Formatter.php
112. internal_data/code_cache/templates/l5/s1/public/search_result_post.php
113. src/XF/Pub/Route/Search.php
114. internal_data/code_cache/navigation_cache.php
115. src/XF/Phrase.php
116. src/XF/NoticeList.php
117. internal_data/code_cache/templates/l5/s1/public/PAGE_CONTAINER.php
118. internal_data/code_cache/templates/l5/s1/public/metadata_macros.php
119. internal_data/code_cache/templates/l5/s1/public/helper_js_global.php
120. internal_data/code_cache/templates/l5/s1/public/google_analytics.php
121. internal_data/code_cache/templates/l5/s1/public/_ads.php
122. internal_data/code_cache/phrase_groups/l5/nav.php
123. internal_data/code_cache/phrase_groups/l5/button.php
124. internal_data/code_cache/templates/l5/s1/public/browser_warning_macros.php
125. internal_data/code_cache/templates/l5/s1/public/debug_macros.php
126. src/XF/Debugger.php