Page Time: 0.1541s

Memory: 5.2080 MB (Peak: 6.2306 MB)

Queries (8, time: 0.0203s, 13.2%)

  1. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1218
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    14. XF\App->run() in src/XF.php at line 525
    15. 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` = '3894')


LIMIT 1
    Run Time: 0.000743
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_userconstPRIMARYPRIMARY4const1 
    SIMPLExf_user_option_Option_1constPRIMARYPRIMARY4const1 
    SIMPLExf_user_privacy_Privacy_2constPRIMARYPRIMARY4const1 
    SIMPLExf_user_profile_Profile_3constPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
    4. XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1238
    5. XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 671
    6. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    11. XF\App->run() in src/XF.php at line 525
    12. XF::runApp() in index.php at line 20
  3. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
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_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
    Run Time: 0.000885
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_forumALL    17 
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_forum.node_id1 
    SIMPLExf_permission_cache_content_Permissions_2eq_refPRIMARYPRIMARY35const,const,sammyboy_xenforo.xf_node_Node_1.node_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Search/Data/Post.php at line 259
    4. XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 239
    5. XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 212
    6. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
    7. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
    8. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    13. XF\App->run() in src/XF.php at line 525
    14. XF::runApp() in index.php at line 20
  4. 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 (3299830, 2922096, 2874374, 2793433, 2759666, 2736417, 2694139, 2693928, 2645711, 2533850, 2533337, 2533336, 2533334, 2533003, 2532999, 2532998, 2505307, 2505303, 2505301, 2500365, 2473125, 2450547, 2421633, 2412996, 2392061, 2383692, 2383689, 2383679, 2376328, 2346313, 2345978, 2338348, 2297580, 2278571, 2226732, 2169565, 2138798, 2135276, 2121303, 2051930, 2044648, 1861903, 1718129, 1497180, 1497050, 919882, 905477, 853676, 844294, 834166, 825823, 758446, 692822, 684559, 668454, 645029, 645028, 645027, 645026, 640073, 640071, 620197, 612369, 588646, 559674, 547284, 544404, 544403, 544401, 533765, 475109, 469322, 468422, 468331, 425259, 425258, 425257, 425256, 425255, 425254, 425253, 425252, 407323, 404096, 388181, 381878, 369921, 353010, 340673, 314733, 314718, 312933, 312931, 297012, 293367, 261397, 261395, 186693, 178433, 178414, 169283, 129535, 106154, 104912, 96480, 67112, 32665, 32663, 32660, 32659))
    Run Time: 0.007282
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrangePRIMARYPRIMARY4 110Using where
    SIMPLExf_thread_Thread_1eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_post.thread_id1 
    SIMPLExf_forum_Forum_2eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread_Thread_1.node_id1Using where
    SIMPLExf_node_Node_3eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_forum_Forum_2.node_id1Using where
    SIMPLExf_user_User_4eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_post.user_id1 
    SIMPLExf_permission_cache_content_Permissions_5eq_refPRIMARYPRIMARY35const,const,sammyboy_xenforo.xf_node_Node_3.node_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
    11. XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
    12. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
    13. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
    14. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    15. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    16. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    17. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    19. XF\App->run() in src/XF.php at line 525
    20. XF::runApp() in index.php at line 20
  5. 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 (277863, 257904, 256548, 251312, 243824, 239867, 237437, 237436, 230648, 221051, 221049, 221046, 213387, 212264, 212190, 204939, 204792, 201985, 200986, 188545, 180604, 180407, 169396, 149794, 112750, 109311, 107398, 106156, 104364, 103604, 103201, 103173, 103107, 101877, 101245, 96815, 94508, 89977, 85161, 84784, 84338, 83342, 81621, 81599, 71582, 60720, 60414, 54404, 51707, 51089, 48568, 42680, 38975, 38900, 36331, 36330, 36267, 35707, 26453, 20129, 10583, 10581, 9761, 8180, 6902, 6808, 6806))
    Run Time: 0.004326
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARYPRIMARY4 67Using where
    SIMPLExf_forum_Forum_1eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.node_id1 
    SIMPLExf_node_Node_2eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_forum_Forum_1.node_id1Using where
    SIMPLExf_post_FirstPost_3eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.first_post_id1 
    SIMPLExf_user_User_4eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.user_id1 
    SIMPLExf_permission_cache_content_Permissions_5eq_refPRIMARYPRIMARY35const,const,sammyboy_xenforo.xf_node_Node_2.node_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
    11. XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
    12. XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
    13. XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
    14. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    15. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    16. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    17. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    19. XF\App->run() in src/XF.php at line 525
    20. XF::runApp() in index.php at line 20
  6. 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 (3299830, 2922096, 2874374, 2793433, 2759666, 2736417, 2694139, 2693928, 2645711, 2533850, 2533337, 2533336, 2533334, 2533003, 2532999, 2532998, 2505307, 2505303, 2505301, 2500365, 2473125, 2450547, 2421633, 2412996, 2392061, 2383692, 2383689, 2383679, 2376328, 2346313, 2345978, 2338348, 2297580, 2278571, 2226732, 2169565, 2138798, 2135276, 2121303, 2051930, 2044648, 1861903, 1718129, 1497180, 1497050, 919882, 905477, 853676, 844294, 834166, 825823, 758446, 692822, 684559, 668454, 645029, 645028, 645027, 645026, 640073, 640071, 620197, 612369, 588646, 559674, 547284, 544404, 544403, 544401, 533765, 475109, 469322, 468422, 468331, 425259, 425258, 425257, 425256, 425255, 425254, 425253, 425252, 407323, 404096, 388181, 381878, 369921, 353010, 340673, 314733, 314718, 312933, 312931, 297012, 293367, 261397, 261395, 186693, 178433, 178414, 169283, 129535, 106154, 104912, 96480, 67112, 32665, 32663, 32660, 32659))
    Run Time: 0.003847
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrangePRIMARYPRIMARY4 110Using where
    SIMPLExf_thread_Thread_1eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_post.thread_id1 
    SIMPLExf_forum_Forum_2eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread_Thread_1.node_id1Using where
    SIMPLExf_node_Node_3eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_forum_Forum_2.node_id1Using where
    SIMPLExf_user_User_4eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_post.user_id1 
    SIMPLExf_permission_cache_content_Permissions_5eq_refPRIMARYPRIMARY35const,const,sammyboy_xenforo.xf_node_Node_3.node_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
    11. XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    17. XF\App->run() in src/XF.php at line 525
    18. XF::runApp() in index.php at line 20
  7. 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 (277863, 257904, 256548, 251312, 243824, 239867, 237437, 237436, 230648, 221051, 221049, 221046, 213387, 212264, 212190, 204939, 204792, 201985, 200986, 188545, 180604, 180407, 169396, 149794, 112750, 109311, 107398, 106156, 104364, 103604, 103201, 103173, 103107, 101877, 101245, 96815, 94508, 89977, 85161, 84784, 84338, 83342, 81621, 81599, 71582, 60720, 60414, 54404, 51707, 51089, 48568, 42680, 38975, 38900, 36331, 36330, 36267, 35707, 26453, 20129, 10583, 10581, 9761, 8180, 6902, 6808, 6806))
    Run Time: 0.002803
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARYPRIMARY4 67Using where
    SIMPLExf_forum_Forum_1eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.node_id1 
    SIMPLExf_node_Node_2eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_forum_Forum_1.node_id1Using where
    SIMPLExf_post_FirstPost_3eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.first_post_id1 
    SIMPLExf_user_User_4eq_refPRIMARYPRIMARY4sammyboy_xenforo.xf_thread.user_id1 
    SIMPLExf_permission_cache_content_Permissions_5eq_refPRIMARYPRIMARY35const,const,sammyboy_xenforo.xf_node_Node_2.node_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
    5. XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
    6. XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
    7. XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
    8. XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
    9. XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
    10. XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
    11. XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
    12. XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
    13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    17. XF\App->run() in src/XF.php at line 525
    18. XF::runApp() in index.php at line 20
  8. SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
    Params: 0,
    Run Time: 0.000187
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityconstPRIMARYPRIMARY22const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
    4. XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 16
    5. xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
    6. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
    7. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
    8. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
    13. XF\App->run() in src/XF.php at line 525
    14. XF::runApp() in index.php at line 20

Included Files (225, XenForo Classes: 116)

  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_static.php
  7. src/vendor/laminas/laminas-zendframework-bridge/src/autoload.php
  8. src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
  9. src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
  10. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
  11. src/vendor/symfony/polyfill-php72/bootstrap.php
  12. src/vendor/symfony/polyfill-intl-idn/bootstrap.php
  13. src/vendor/symfony/polyfill-mbstring/bootstrap.php
  14. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  15. src/vendor/guzzlehttp/promises/src/functions_include.php
  16. src/vendor/guzzlehttp/promises/src/functions.php
  17. src/vendor/guzzlehttp/psr7/src/functions_include.php
  18. src/vendor/guzzlehttp/psr7/src/functions.php
  19. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  20. src/vendor/guzzlehttp/guzzle/src/functions.php
  21. src/vendor/paragonie/sodium_compat/autoload.php
  22. src/vendor/paragonie/sodium_compat/autoload-php7.php
  23. src/vendor/paragonie/sodium_compat/src/Compat.php
  24. src/vendor/paragonie/sodium_compat/src/SodiumException.php
  25. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  26. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  27. src/vendor/paragonie/sodium_compat/lib/constants.php
  28. src/vendor/paragonie/sodium_compat/lib/php72compat_const.php
  29. src/vendor/paragonie/sodium_compat/lib/php72compat.php
  30. src/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
  31. src/vendor/paragonie/sodium_compat/lib/ristretto255.php
  32. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  33. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  34. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  35. src/vendor/dokuwiki/utf8/utf8.php
  36. src/XF/Http/Request.php
  37. src/XF/InputFilterer.php
  38. src/XF/Pub/App.php
  39. src/XF/App.php
  40. src/XF/Container.php
  41. src/config.php
  42. src/XF/DataRegistry.php
  43. src/XF/Db/Mysqli/Adapter.php
  44. src/XF/Db/AbstractAdapter.php
  45. src/XF/CacheFactory.php
  46. src/XF/Cache/MemcachedCache.php
  47. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MemcachedCache.php
  48. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  49. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  50. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  51. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  52. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  53. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  54. src/XF/Extension.php
  55. src/XF/AddOn/Manager.php
  56. src/XF/Session/Session.php
  57. src/XF/Session/CacheStorage.php
  58. src/XF/Session/StorageInterface.php
  59. src/XF/Util/Ip.php
  60. src/XF/Util/Random.php
  61. src/XF/Http/Response.php
  62. src/XF/Mvc/Entity/Manager.php
  63. src/XF/Mvc/Entity/ValueFormatter.php
  64. src/XF/Repository/User.php
  65. src/XF/Mvc/Entity/Repository.php
  66. src/XF/Entity/User.php
  67. src/XF/Mvc/Entity/Entity.php
  68. src/XF/Entity/LinkableInterface.php
  69. src/addons/xenMade/LAU/XF/Entity/User.php
  70. src/XF/Mvc/Entity/Structure.php
  71. src/XF/Entity/UserAuth.php
  72. src/XF/Entity/UserOption.php
  73. src/XF/Entity/UserProfile.php
  74. src/XF/Entity/UserPrivacy.php
  75. src/XF/Util/File.php
  76. src/XF/Language.php
  77. src/XF/Mvc/Dispatcher.php
  78. src/XF/Mvc/Router.php
  79. src/addons/XF301VB/Mvc/Router.php
  80. src/XF/Mvc/RouteMatch.php
  81. src/XF/Util/Arr.php
  82. src/XF/Mvc/ParameterBag.php
  83. src/XF/Pub/Controller/Member.php
  84. src/XF/Pub/Controller/AbstractController.php
  85. src/XF/Mvc/Controller.php
  86. src/XF/Util/Php.php
  87. src/XF/PermissionCache.php
  88. src/XF/PermissionSet.php
  89. src/XF/Db/Mysqli/Statement.php
  90. src/XF/Db/AbstractStatement.php
  91. src/XF/Finder/User.php
  92. src/XF/Mvc/Entity/Finder.php
  93. src/XF/Search/Search.php
  94. src/XF/ResultSetInterface.php
  95. src/addons/XFES/XF/Search/Search.php
  96. src/addons/XFES/Listener.php
  97. src/addons/XFES/Elasticsearch/Api.php
  98. src/XF/SubContainer/Http.php
  99. src/XF/SubContainer/AbstractSubContainer.php
  100. src/vendor/guzzlehttp/psr7/src/Uri.php
  101. src/vendor/psr/http-message/src/UriInterface.php
  102. src/vendor/guzzlehttp/guzzle/src/Client.php
  103. src/vendor/guzzlehttp/guzzle/src/ClientInterface.php
  104. src/vendor/guzzlehttp/guzzle/src/HandlerStack.php
  105. src/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php
  106. src/vendor/guzzlehttp/guzzle/src/Handler/CurlMultiHandler.php
  107. src/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php
  108. src/vendor/guzzlehttp/guzzle/src/Handler/CurlFactoryInterface.php
  109. src/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php
  110. src/vendor/guzzlehttp/guzzle/src/Handler/StreamHandler.php
  111. src/vendor/guzzlehttp/guzzle/src/Middleware.php
  112. src/vendor/guzzlehttp/psr7/src/Utils.php
  113. src/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php
  114. src/addons/XFES/Search/Source/Elasticsearch.php
  115. src/XF/Search/Source/AbstractSource.php
  116. src/XF/Search/Query/KeywordQuery.php
  117. src/XF/Search/Query/Query.php
  118. src/XF/Search/Data/Page.php
  119. src/XF/Search/Data/AbstractData.php
  120. src/XF/Search/Data/Post.php
  121. src/XF/Search/Data/ProfilePost.php
  122. src/XF/Search/Data/ProfilePostComment.php
  123. src/XF/Search/Data/Thread.php
  124. src/XF/Entity/Forum.php
  125. src/XF/Entity/AbstractNode.php
  126. src/addons/XFES/XF/Entity/Forum.php
  127. src/XF/Entity/Node.php
  128. src/XF/Entity/BookmarkTrait.php
  129. src/XF/Entity/PermissionCacheContent.php
  130. src/XF/Mvc/Entity/Proxyable.php
  131. src/XF/Mvc/Entity/FinderCollection.php
  132. src/XF/Mvc/Entity/AbstractCollection.php
  133. src/XF/Mvc/Entity/ArrayCollection.php
  134. src/XF/Search/Query/MetadataConstraint.php
  135. src/vendor/guzzlehttp/psr7/src/Request.php
  136. src/vendor/guzzlehttp/psr7/src/MessageTrait.php
  137. src/vendor/psr/http-message/src/RequestInterface.php
  138. src/vendor/psr/http-message/src/MessageInterface.php
  139. src/vendor/guzzlehttp/guzzle/src/RequestOptions.php
  140. src/vendor/guzzlehttp/psr7/src/UriResolver.php
  141. src/vendor/guzzlehttp/guzzle/src/Utils.php
  142. src/vendor/guzzlehttp/psr7/src/Stream.php
  143. src/vendor/psr/http-message/src/StreamInterface.php
  144. src/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php
  145. src/vendor/guzzlehttp/guzzle/src/Handler/EasyHandle.php
  146. src/vendor/guzzlehttp/psr7/src/Response.php
  147. src/vendor/psr/http-message/src/ResponseInterface.php
  148. src/vendor/guzzlehttp/promises/src/FulfilledPromise.php
  149. src/vendor/guzzlehttp/promises/src/PromiseInterface.php
  150. src/vendor/guzzlehttp/promises/src/Utils.php
  151. src/vendor/guzzlehttp/promises/src/TaskQueue.php
  152. src/vendor/guzzlehttp/promises/src/TaskQueueInterface.php
  153. src/vendor/guzzlehttp/promises/src/Promise.php
  154. src/vendor/guzzlehttp/promises/src/Create.php
  155. src/vendor/guzzlehttp/promises/src/Is.php
  156. src/addons/XFES/Elasticsearch/Response.php
  157. src/XF/ResultSet.php
  158. src/XF/Entity/Post.php
  159. src/XF/Entity/ReactionTrait.php
  160. src/XF/Entity/ContentVoteTrait.php
  161. src/XF/Entity/QuotableInterface.php
  162. src/XF/BbCode/RenderableContentInterface.php
  163. src/addons/XFES/XF/Entity/Post.php
  164. src/XF/Finder/Post.php
  165. src/XF/Entity/Thread.php
  166. src/addons/cfgeoblock/XF/Entity/Thread.php
  167. src/addons/XFES/XF/Entity/Thread.php
  168. src/addons/cfgeoblock/Listener.php
  169. src/XF/CustomField/DefinitionSet.php
  170. src/XF/CustomField/Set.php
  171. src/XF/Finder/Thread.php
  172. src/XF/Search/RenderWrapper.php
  173. src/XF/PreEscapedInterface.php
  174. src/XF/Mvc/Reply/View.php
  175. src/XF/Mvc/Reply/AbstractReply.php
  176. src/XF/Repository/SessionActivity.php
  177. src/addons/xenMade/LAU/XF/Repository/SessionActivity.php
  178. src/XF/Data/Robot.php
  179. src/XF/Style.php
  180. src/XF/Template/Templater.php
  181. src/addons/xenMade/LAU/XF/Template/Templater.php
  182. src/XF/DevelopmentOutput.php
  183. src/XF/DevelopmentOutput/Template.php
  184. src/XF/DevelopmentOutput/AbstractHandler.php
  185. src/XF/Template/WatcherInterface.php
  186. src/XF/SubContainer/BbCode.php
  187. src/XF/SubContainer/Widget.php
  188. src/XF/CookieConsent.php
  189. src/XF/Captcha/HCaptcha.php
  190. src/XF/Captcha/AbstractCaptcha.php
  191. src/XF/Repository/Payment.php
  192. src/XF/SimpleCache.php
  193. src/XF/Mvc/Renderer/Html.php
  194. src/XF/Mvc/Renderer/AbstractRenderer.php
  195. src/XF/Mvc/View.php
  196. src/XF/Template/Template.php
  197. internal_data/code_cache/templates/l1/s7/public/member_recent_content.php
  198. src/XF/PreEscaped.php
  199. internal_data/code_cache/templates/l1/s7/public/search_result_post.php
  200. src/XF/Str/Formatter.php
  201. src/XF/Str/MentionFormatter.php
  202. internal_data/code_cache/templates/l1/s7/public/search_result_thread.php
  203. src/XF/Phrase.php
  204. internal_data/code_cache/phrase_groups/l1/thread_prefix.php
  205. src/XF/Pub/Route/Search.php
  206. internal_data/code_cache/navigation_cache.php
  207. src/XF/NoticeList.php
  208. src/XF/Criteria/User.php
  209. src/XF/Criteria/AbstractCriteria.php
  210. src/XF/Criteria/Page.php
  211. internal_data/code_cache/templates/l1/s7/public/PAGE_CONTAINER.php
  212. src/XF/Util/Color.php
  213. internal_data/code_cache/templates/l1/s7/public/metadata_macros.php
  214. src/XF/Template/MacroState.php
  215. internal_data/code_cache/templates/l1/s7/public/helper_js_global.php
  216. internal_data/code_cache/templates/l1/s7/public/font_awesome_setup.php
  217. internal_data/code_cache/templates/l1/s7/public/google_analytics.php
  218. internal_data/code_cache/templates/l1/s7/public/lau_staff_bar.php
  219. internal_data/code_cache/templates/l1/s7/public/_ads.php
  220. internal_data/code_cache/phrase_groups/l1/nav.php
  221. internal_data/code_cache/phrase_groups/l1/button.php
  222. internal_data/code_cache/templates/l1/s7/public/notice_macros.php
  223. internal_data/code_cache/templates/l1/s7/public/browser_warning_macros.php
  224. internal_data/code_cache/templates/l1/s7/public/debug_macros.php
  225. src/XF/Debugger.php

DB Connection Stats

bytes_sent17237
bytes_received1516317
packets_sent100
packets_received2023
protocol_overhead_in8092
protocol_overhead_out400
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet324
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet102
bytes_received_prepare_response_packet129006
bytes_received_change_user_packet1386445
packets_sent_command49
packets_received_ok0
packets_received_eof0
packets_received_rset_header36
packets_received_rset_field_meta0
packets_received_rset_row18
packets_received_prepare_response1528
packets_received_change_user423
result_set_queries16
non_result_set_queries2
no_index_used1
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets16
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed15
rows_fetched_from_server_normal0
rows_fetched_from_server_ps407
rows_buffered_from_client_normal0
rows_buffered_from_client_ps407
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps407
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success1
connect_failure0
connection_reused0
reconnect0
pconnect_success1
active_connections1
active_persistent_connections1
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result0
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estrdup_count0
mem_strdup_count0
mem_edupl_count0
mem_dupl_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit1765
proto_binary_fetched_tinyint0
proto_binary_fetched_short5800
proto_binary_fetched_int242872
proto_binary_fetched_int0
proto_binary_fetched_bigint23714
proto_binary_fetched_decimal66
proto_binary_fetched_float0
proto_binary_fetched_double0
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json10744
proto_binary_fetched_blob5134
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query2
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare16
com_stmt_execute16
com_stmt_send_long_data0
com_stmt_close15
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps1360537