Page Time: 0.1593s

Memory: 5.8585 MB (Peak: 7.9663 MB)

Queries (9, time: 0.0242s, 15.2%)

  1. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000203
    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` = '87640')


LIMIT 1
    Run Time: 0.000772
    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.000758
    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_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 (214974, 212576, 212046, 211416, 209869, 209796, 209565, 209002, 208928, 208856, 208688, 208543, 208488, 208159, 208116, 208011, 207949, 207238, 206462, 205647, 205590, 205502, 205246, 205203, 205120, 205018, 204511, 204439, 204386, 204258, 204159, 204041, 203959, 203697, 203525, 203438, 203334, 203062, 202984, 202851, 202790, 202674, 202586, 202453, 202307, 202080, 201701, 201434, 201302, 201229, 201109, 200903, 200562, 200451, 200371, 200180, 199876, 199785, 199620, 199603, 199442, 199314, 199268, 199167, 199082, 198964, 198963, 198823, 198607, 198138, 197875, 197874, 197721, 197514, 197321, 197264, 197204, 197075, 197063, 196870, 196711, 196563, 196444, 195778, 195376, 194314))
    Run Time: 0.006529
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARYPRIMARY4 86Using 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
  5. 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 (2256786, 2256785, 2256783, 2239504, 2239486, 2230104, 2220741, 2217385, 2212446, 2208233, 2205087, 2205086, 2204279, 2204273, 2187291, 2187289, 2183016, 2181492, 2178560, 2177943, 2177210, 2177208, 2176743, 2175980, 2174924, 2170794, 2170793, 2170792, 2166443, 2165761, 2165266, 2163524, 2162408, 2162407, 2162405, 2160795, 2159914, 2159913, 2159911, 2157038, 2157036, 2157033, 2156177, 2155268, 2154343, 2153401, 2153400, 2153395, 2150807, 2148344, 2147363, 2145459, 2145458, 2145455, 2143939, 2143938, 2143936, 2142292, 2141182, 2139885, 2139882, 2139881, 2138898, 2135689, 2131866, 2131313, 2130293, 2129421, 2127741, 2125578, 2125546, 2125545, 2125544, 2125542, 2121744, 2120736, 2119929, 2118685, 2115752, 2114725, 2113669, 2112718, 2112710, 2112709, 2111635, 2107121, 2106303, 2096361, 2093749, 2093747, 2091832, 2089286, 2085400, 2081358, 2079495, 2079494, 2079473, 2079299, 2078233, 2072443, 2071186, 2052966, 2052350, 2052347, 2052345, 2049153, 2043824, 2042143, 2039534, 2030838, 2029693, 2025865, 2022600, 2017054))
    Run Time: 0.007157
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrangePRIMARYPRIMARY4 114Using 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
  6. 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 (214974, 212576, 212046, 211416, 209869, 209796, 209565, 209002, 208928, 208856, 208688, 208543, 208488, 208159, 208116, 208011, 207949, 207238, 206462, 205647, 205590, 205502, 205246, 205203, 205120, 205018, 204511, 204439, 204386, 204258, 204159, 204041, 203959, 203697, 203525, 203438, 203334, 203062, 202984, 202851, 202790, 202674, 202586, 202453, 202307, 202080, 201701, 201434, 201302, 201229, 201109, 200903, 200562, 200451, 200371, 200180, 199876, 199785, 199620, 199603, 199442, 199314, 199268, 199167, 199082, 198964, 198963, 198823, 198607, 198138, 197875, 197874, 197721, 197514, 197321, 197264, 197204, 197075, 197063, 196870, 196711, 196563, 196444, 195778, 195376, 194314))
    Run Time: 0.003924
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARYPRIMARY4 86Using 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
  7. 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 (2256786, 2256785, 2256783, 2239504, 2239486, 2230104, 2220741, 2217385, 2212446, 2208233, 2205087, 2205086, 2204279, 2204273, 2187291, 2187289, 2183016, 2181492, 2178560, 2177943, 2177210, 2177208, 2176743, 2175980, 2174924, 2170794, 2170793, 2170792, 2166443, 2165761, 2165266, 2163524, 2162408, 2162407, 2162405, 2160795, 2159914, 2159913, 2159911, 2157038, 2157036, 2157033, 2156177, 2155268, 2154343, 2153401, 2153400, 2153395, 2150807, 2148344, 2147363, 2145459, 2145458, 2145455, 2143939, 2143938, 2143936, 2142292, 2141182, 2139885, 2139882, 2139881, 2138898, 2135689, 2131866, 2131313, 2130293, 2129421, 2127741, 2125578, 2125546, 2125545, 2125544, 2125542, 2121744, 2120736, 2119929, 2118685, 2115752, 2114725, 2113669, 2112718, 2112710, 2112709, 2111635, 2107121, 2106303, 2096361, 2093749, 2093747, 2091832, 2089286, 2085400, 2081358, 2079495, 2079494, 2079473, 2079299, 2078233, 2072443, 2071186, 2052966, 2052350, 2052347, 2052345, 2049153, 2043824, 2042143, 2039534, 2030838, 2029693, 2025865, 2022600, 2017054))
    Run Time: 0.004468
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrangePRIMARYPRIMARY4 114Using 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
  8. SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
    Params: 0,
    Run Time: 0.000205
    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
  9. -- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
	ip = ?,
	controller_name = ?,
	controller_action = ?,
	view_state = ?,
	params = ?,
	view_date = ?,
	robot_key = ?
WHERE user_id = ? AND unique_key = ?
    Params: , XF\Pub\Controller\Member, RecentContent, valid, user_id=87640, 1715854910, , 0,
    Run Time: 0.000160

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

Included Files (225, XenForo Classes: 117)

  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/Data/Search.php
  63. src/XF/CookieConsent.php
  64. src/XF/Captcha/HCaptcha.php
  65. src/XF/Captcha/AbstractCaptcha.php
  66. src/XF/SubContainer/BbCode.php
  67. src/XF/SubContainer/AbstractSubContainer.php
  68. src/XF/Mvc/Entity/Manager.php
  69. src/XF/Mvc/Entity/ValueFormatter.php
  70. src/XF/Repository/Payment.php
  71. src/XF/Mvc/Entity/Repository.php
  72. src/XF/Repository/User.php
  73. src/XF/Entity/User.php
  74. src/XF/Mvc/Entity/Entity.php
  75. src/XF/Entity/LinkableInterface.php
  76. src/addons/xenMade/LAU/XF/Entity/User.php
  77. src/XF/Mvc/Entity/Structure.php
  78. src/XF/Entity/UserAuth.php
  79. src/XF/Entity/UserOption.php
  80. src/XF/Entity/UserProfile.php
  81. src/XF/Entity/UserPrivacy.php
  82. src/XF/Util/File.php
  83. src/XF/Language.php
  84. src/XF/Mvc/Dispatcher.php
  85. src/XF/Mvc/Router.php
  86. src/addons/XF301VB/Mvc/Router.php
  87. src/XF/Mvc/RouteMatch.php
  88. src/XF/Util/Arr.php
  89. src/XF/Mvc/ParameterBag.php
  90. src/XF/Pub/Controller/Member.php
  91. src/XF/Pub/Controller/AbstractController.php
  92. src/XF/Mvc/Controller.php
  93. src/XF/Util/Php.php
  94. src/XF/PermissionCache.php
  95. src/XF/PermissionSet.php
  96. src/XF/Db/Mysqli/Statement.php
  97. src/XF/Db/AbstractStatement.php
  98. src/XF/Finder/User.php
  99. src/XF/Mvc/Entity/Finder.php
  100. src/XF/Search/Search.php
  101. src/XF/ResultSetInterface.php
  102. src/addons/XFES/XF/Search/Search.php
  103. src/addons/XFES/Listener.php
  104. src/addons/XFES/Elasticsearch/Api.php
  105. src/XF/SubContainer/Http.php
  106. src/vendor/guzzlehttp/psr7/src/Uri.php
  107. src/vendor/psr/http-message/src/UriInterface.php
  108. src/vendor/guzzlehttp/guzzle/src/Client.php
  109. src/vendor/guzzlehttp/guzzle/src/ClientInterface.php
  110. src/vendor/guzzlehttp/guzzle/src/HandlerStack.php
  111. src/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php
  112. src/vendor/guzzlehttp/guzzle/src/Handler/CurlMultiHandler.php
  113. src/vendor/guzzlehttp/guzzle/src/Handler/CurlFactory.php
  114. src/vendor/guzzlehttp/guzzle/src/Handler/CurlFactoryInterface.php
  115. src/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php
  116. src/vendor/guzzlehttp/guzzle/src/Handler/StreamHandler.php
  117. src/vendor/guzzlehttp/guzzle/src/Middleware.php
  118. src/vendor/guzzlehttp/psr7/src/Utils.php
  119. src/vendor/guzzlehttp/guzzle/src/RedirectMiddleware.php
  120. src/addons/XFES/Search/Source/Elasticsearch.php
  121. src/XF/Search/Source/AbstractSource.php
  122. src/XF/Search/Query/KeywordQuery.php
  123. src/XF/Search/Query/Query.php
  124. src/XF/Search/Data/Page.php
  125. src/XF/Search/Data/AbstractData.php
  126. src/XF/Search/Data/Post.php
  127. src/XF/Search/Data/ProfilePost.php
  128. src/XF/Search/Data/ProfilePostComment.php
  129. src/XF/Search/Data/Thread.php
  130. src/XF/Entity/Forum.php
  131. src/XF/Entity/AbstractNode.php
  132. src/addons/XFES/XF/Entity/Forum.php
  133. src/XF/Entity/Node.php
  134. src/XF/Entity/BookmarkTrait.php
  135. src/XF/Entity/PermissionCacheContent.php
  136. src/XF/Mvc/Entity/Proxyable.php
  137. src/XF/Mvc/Entity/FinderCollection.php
  138. src/XF/Mvc/Entity/AbstractCollection.php
  139. src/XF/Mvc/Entity/ArrayCollection.php
  140. src/XF/Search/Query/MetadataConstraint.php
  141. src/vendor/guzzlehttp/psr7/src/Request.php
  142. src/vendor/guzzlehttp/psr7/src/MessageTrait.php
  143. src/vendor/psr/http-message/src/RequestInterface.php
  144. src/vendor/psr/http-message/src/MessageInterface.php
  145. src/vendor/guzzlehttp/guzzle/src/RequestOptions.php
  146. src/vendor/guzzlehttp/psr7/src/UriResolver.php
  147. src/vendor/guzzlehttp/guzzle/src/Utils.php
  148. src/vendor/guzzlehttp/psr7/src/Stream.php
  149. src/vendor/psr/http-message/src/StreamInterface.php
  150. src/vendor/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php
  151. src/vendor/guzzlehttp/guzzle/src/Handler/EasyHandle.php
  152. src/vendor/guzzlehttp/psr7/src/Response.php
  153. src/vendor/psr/http-message/src/ResponseInterface.php
  154. src/vendor/guzzlehttp/promises/src/FulfilledPromise.php
  155. src/vendor/guzzlehttp/promises/src/PromiseInterface.php
  156. src/vendor/guzzlehttp/promises/src/Utils.php
  157. src/vendor/guzzlehttp/promises/src/TaskQueue.php
  158. src/vendor/guzzlehttp/promises/src/TaskQueueInterface.php
  159. src/vendor/guzzlehttp/promises/src/Promise.php
  160. src/vendor/guzzlehttp/promises/src/Create.php
  161. src/vendor/guzzlehttp/promises/src/Is.php
  162. src/addons/XFES/Elasticsearch/Response.php
  163. src/XF/ResultSet.php
  164. src/XF/Entity/Thread.php
  165. src/XF/Entity/ContentVoteTrait.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/Finder/Thread.php
  170. src/XF/Entity/Post.php
  171. src/XF/Entity/ReactionTrait.php
  172. src/XF/Entity/QuotableInterface.php
  173. src/XF/BbCode/RenderableContentInterface.php
  174. src/addons/XFES/XF/Entity/Post.php
  175. src/XF/CustomField/DefinitionSet.php
  176. src/XF/CustomField/Set.php
  177. src/XF/Finder/Post.php
  178. src/XF/Search/RenderWrapper.php
  179. src/XF/PreEscapedInterface.php
  180. src/XF/Mvc/Reply/View.php
  181. src/XF/Mvc/Reply/AbstractReply.php
  182. src/XF/Repository/SessionActivity.php
  183. src/addons/xenMade/LAU/XF/Repository/SessionActivity.php
  184. src/XF/Data/Robot.php
  185. src/XF/Style.php
  186. src/XF/Template/Templater.php
  187. src/addons/xenMade/LAU/XF/Template/Templater.php
  188. src/XF/DevelopmentOutput.php
  189. src/XF/DevelopmentOutput/Template.php
  190. src/XF/DevelopmentOutput/AbstractHandler.php
  191. src/XF/Template/WatcherInterface.php
  192. src/XF/SubContainer/Widget.php
  193. src/XF/SimpleCache.php
  194. src/XF/Mvc/Renderer/Html.php
  195. src/XF/Mvc/Renderer/AbstractRenderer.php
  196. src/XF/Mvc/View.php
  197. src/XF/Template/Template.php
  198. internal_data/code_cache/templates/l1/s7/public/member_recent_content.php
  199. src/XF/PreEscaped.php
  200. internal_data/code_cache/templates/l1/s7/public/search_result_thread.php
  201. src/XF/Util/Color.php
  202. src/XF/Str/Formatter.php
  203. src/XF/Str/MentionFormatter.php
  204. internal_data/code_cache/templates/l1/s7/public/search_result_post.php
  205. src/XF/Pub/Route/Search.php
  206. internal_data/code_cache/navigation_cache.php
  207. src/XF/Phrase.php
  208. src/XF/NoticeList.php
  209. src/XF/Criteria/User.php
  210. src/XF/Criteria/AbstractCriteria.php
  211. src/XF/Criteria/Page.php
  212. internal_data/code_cache/templates/l1/s7/public/PAGE_CONTAINER.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_sent18831
bytes_received2792600
packets_sent106
packets_received2081
protocol_overhead_in8324
protocol_overhead_out424
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet333
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet154
bytes_received_prepare_response_packet129249
bytes_received_change_user_packet2662408
packets_sent_command52
packets_received_ok0
packets_received_eof0
packets_received_rset_header37
packets_received_rset_field_meta0
packets_received_rset_row19
packets_received_prepare_response1537
packets_received_change_user469
result_set_queries16
non_result_set_queries3
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_executed16
rows_fetched_from_server_normal0
rows_fetched_from_server_ps453
rows_buffered_from_client_normal0
rows_buffered_from_client_ps453
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_ps453
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_bit1460
proto_binary_fetched_tinyint0
proto_binary_fetched_short6536
proto_binary_fetched_int243240
proto_binary_fetched_int0
proto_binary_fetched_bigint27151
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_json12078
proto_binary_fetched_blob5912
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_prepare17
com_stmt_execute17
com_stmt_send_long_data0
com_stmt_close16
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps2632748