Page Time: 0.1062s

Memory: 16.2365 MB (Peak: 16.6669 MB)

Queries (12, time: 0.0073s, 6.8%)

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

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
    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 123
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    14. XF\App->run() in src/XF.php at line 391
    15. XF::runApp() in index.php at line 20
  2. SELECT `xf_node`.*
    FROM `xf_node`
    
    WHERE (`xf_node`.`display_in_list` = 1)
    ORDER BY `xf_node`.`lft` ASC
    Run Time: 0.001174
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALLdisplay_in_list   113Using where; Using filesort

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 17
    4. XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 50
    5. XF\Pub\Controller\Forum->actionList() in src/XF/Mvc/Dispatcher.php at line 350
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    7. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    10. XF\App->run() in src/XF.php at line 391
    11. XF::runApp() in index.php at line 20
  3. 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 (8, 9, 46, 58, 102, 10))
    Run Time: 0.000276
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_categoryindexPRIMARYPRIMARY4 6Using where; Using index
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4xenforo.xf_category.node_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
    6. XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 50
    7. XF\Pub\Controller\Forum->actionList() in src/XF/Mvc/Dispatcher.php at line 350
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    12. XF\App->run() in src/XF.php at line 391
    13. XF::runApp() in index.php at line 20
  4. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
    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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
    LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
    WHERE (`xf_forum`.`node_id` IN (13, 14, 59, 69, 96, 113, 116, 123, 26, 12, 64, 37, 47, 49, 57, 89, 98, 99, 114, 115, 118, 121, 124, 125, 126, 27, 65, 77, 84, 86, 120, 92, 61, 15, 17, 28, 16, 18, 30, 60, 54, 62, 24, 25, 40, 63, 20, 55, 56, 21, 53, 22, 43, 23, 45, 108, 94, 66, 93, 70, 97, 79, 82, 80, 109, 38, 42, 48, 52, 75, 76, 83, 88, 90, 95, 100, 50, 87, 119, 67, 72, 19, 31, 33, 34, 35, 36, 39, 41, 44, 73, 85, 32, 51, 74, 110, 111, 107, 106, 104, 103, 29, 68, 78, 81, 91))
    Run Time: 0.001953
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_forumALLPRIMARY   107Using where
    SIMPLExf_node_Node_1eq_refPRIMARYPRIMARY4xenforo.xf_forum.node_id1 
    SIMPLExf_user_LastPostUser_2eq_refPRIMARYPRIMARY4xenforo.xf_forum.last_post_user_id1 
    SIMPLExf_thread_LastThread_3eq_refPRIMARYPRIMARY4xenforo.xf_forum.last_thread_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
    4. XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
    5. XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
    6. XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 50
    7. XF\Pub\Controller\Forum->actionList() in src/XF/Mvc/Dispatcher.php at line 350
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    12. XF\App->run() in src/XF.php at line 391
    13. XF::runApp() in index.php at line 20
  5. SELECT content_id, cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    Params: 1, node
    Run Time: 0.000514
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const113Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/PermissionCache.php at line 102
    4. XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 947
    5. XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 158
    6. XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
    7. XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 50
    8. XF\Pub\Controller\Forum->actionList() in src/XF/Mvc/Dispatcher.php at line 350
    9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    13. XF\App->run() in src/XF.php at line 391
    14. XF::runApp() in index.php at line 20
  6. -- 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\Forum, List, valid, , 1624079883,
    Run Time: 0.000147

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    11. XF\App->run() in src/XF.php at line 391
    12. XF::runApp() in index.php at line 20
  7. SELECT
    	SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
    	SUM(IF(user_id > 0, 1, 0)) AS members,
    	SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
    FROM xf_session_activity
    WHERE view_date >= ?
    Params: 1624078083
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activitysystemview_date   1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
    3. XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
    4. XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
    5. XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
    6. XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
    7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
    8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
    10. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 217
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    12. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    13. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    19. XF\App->run() in src/XF.php at line 391
    20. XF::runApp() in index.php at line 20
  8. SELECT `xf_session_activity`.*, `xf_user_User_1`.*
    FROM `xf_session_activity`
    INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
    WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1624078083)
    ORDER BY `xf_session_activity`.`view_date` DESC
    
    LIMIT 50
    Run Time: 0.000364
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
    4. XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
    5. XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
    6. XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
    7. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
    8. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    9. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
    10. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 217
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    12. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    13. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    14. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    15. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    16. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    17. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    18. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    19. XF\App->run() in src/XF.php at line 391
    20. XF::runApp() in index.php at line 20
  9. SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
    FROM `xf_thread` FORCE INDEX (`last_post_date`)
    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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
    LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
    LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
    WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1621487883)
    ORDER BY `xf_thread`.`last_post_date` DESC
    
    LIMIT 10
    Run Time: 0.000746
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangelast_post_datelast_post_date4 3Using where
    SIMPLExf_forum_Forum_1eq_refPRIMARYPRIMARY4xenforo.xf_thread.node_id1Using where
    SIMPLExf_node_Node_2eq_refPRIMARYPRIMARY4xenforo.xf_thread.node_id1 
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4xenforo.xf_thread.user_id1 
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,xenforo.xf_node_Node_2.node_id1Using where
    SIMPLExf_user_LastPoster_5eq_refPRIMARYPRIMARY4xenforo.xf_thread.last_post_user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 87
    4. XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_9_forum_overview_new_posts.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 217
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    17. XF\App->run() in src/XF.php at line 391
    18. XF::runApp() in index.php at line 20
  10. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('forumStatistics')
    Run Time: 0.000168
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
    5. XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
    6. XF\DataRegistry->offsetGet() in src/XF/App.php at line 1656
    7. XF\App->XF\{closure}() in src/XF/Container.php at line 28
    8. XF\Container->offsetGet() in src/XF/App.php at line 2263
    9. XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
    10. XF\Widget\ForumStatistics->render() in internal_data/code_cache/widgets/_7_forum_overview_forum_statistics.php at line 5
    11. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
    12. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    13. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
    14. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 217
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    16. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    17. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    18. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    19. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    20. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    21. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    22. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    23. XF\App->run() in src/XF.php at line 391
    24. XF::runApp() in index.php at line 20
  11. SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.*
    FROM `xf_profile_post`
    LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`)
    LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`)
    LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`)
    WHERE (`xf_profile_post`.`message_state` = 'visible')
    ORDER BY `xf_profile_post`.`post_date` DESC
    
    LIMIT 10
    Run Time: 0.000546
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_profile_postALL    53Using where; Using filesort
    SIMPLExf_user_ProfileUser_1eq_refPRIMARYPRIMARY4xenforo.xf_profile_post.profile_user_id1 
    SIMPLExf_user_privacy_Privacy_2eq_refPRIMARYPRIMARY4xenforo.xf_user_ProfileUser_1.user_id1Using where
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4xenforo.xf_profile_post.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewProfilePosts.php at line 66
    4. XF\Widget\NewProfilePosts->render() in internal_data/code_cache/widgets/_10_forum_overview_new_profile_posts.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6684
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1634
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 217
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    17. XF\App->run() in src/XF.php at line 391
    18. XF::runApp() in index.php at line 20
  12. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('th_nodeStyling_nodes_5')
    Run Time: 0.001037
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
    5. XF\DataRegistry->get() in src/addons/ThemeHouse/Nodes/XF/Entity/Node.php at line 65
    6. ThemeHouse\Nodes\XF\Entity\Node->getNodeStylingFromCacheForStyle() in src/addons/ThemeHouse/Nodes/Repository/NodeStyling.php at line 304
    7. ThemeHouse\Nodes\Repository\NodeStyling->getClassesForNode() in src/addons/ThemeHouse/Nodes/Listener/TemplaterSetup.php at line 45
    8. ThemeHouse\Nodes\Listener\TemplaterSetup::fnNodeClasses()
    9. call_user_func_array() in src/XF/Template/Templater.php at line 936
    10. XF\Template\Templater->func() in internal_data/code_cache/templates/l1/s5/public/node_list_category.php at line 62
    11. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    12. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 24
    13. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    14. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 58
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
    16. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s5/public/forum_list.php at line 240
    17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
    18. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    19. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
    20. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
    21. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
    22. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
    23. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
    24. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
    25. XF\App->run() in src/XF.php at line 391
    26. XF::runApp() in index.php at line 20

Included Files (197, XenForo Classes: 106)

  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/symfony/polyfill-mbstring/bootstrap.php
  8. src/vendor/paragonie/random_compat/lib/random.php
  9. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  10. src/vendor/guzzlehttp/promises/src/functions_include.php
  11. src/vendor/guzzlehttp/promises/src/functions.php
  12. src/vendor/guzzlehttp/psr7/src/functions_include.php
  13. src/vendor/guzzlehttp/psr7/src/functions.php
  14. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  15. src/vendor/guzzlehttp/guzzle/src/functions.php
  16. src/vendor/paragonie/sodium_compat/autoload.php
  17. src/vendor/paragonie/sodium_compat/autoload-php7.php
  18. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  19. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  20. src/vendor/paragonie/sodium_compat/lib/constants.php
  21. src/vendor/paragonie/sodium_compat/src/Compat.php
  22. src/vendor/symfony/polyfill-ctype/bootstrap.php
  23. src/vendor/symfony/polyfill-php56/bootstrap.php
  24. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  25. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  26. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  27. src/vendor/dokuwiki/utf8/utf8.php
  28. src/XF/Http/Request.php
  29. src/XF/InputFilterer.php
  30. src/XF/Pub/App.php
  31. src/XF/App.php
  32. src/XF/Container.php
  33. src/config.php
  34. src/XF/DataRegistry.php
  35. src/XF/Db/Mysqli/Adapter.php
  36. src/XF/Db/AbstractAdapter.php
  37. src/XF/CacheFactory.php
  38. src/XF/Cache/RedisCache.php
  39. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/RedisCache.php
  40. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  41. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  42. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  43. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  44. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  45. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  46. src/XF/Extension.php
  47. src/XF/AddOn/Manager.php
  48. src/addons/ThemeHouse/UIX/Listener/AppSetup.php
  49. src/XF/Session/Session.php
  50. src/XF/Session/CacheStorage.php
  51. src/XF/Session/StorageInterface.php
  52. src/XF/Util/Ip.php
  53. src/XF/Util/Random.php
  54. src/XF/Http/Response.php
  55. src/XF/Mvc/Entity/Manager.php
  56. src/XF/Mvc/Entity/ValueFormatter.php
  57. src/XF/Repository/User.php
  58. src/XF/Mvc/Entity/Repository.php
  59. src/XF/Entity/User.php
  60. src/XF/Mvc/Entity/Entity.php
  61. src/XF/Mvc/Entity/Structure.php
  62. src/XF/Entity/UserAuth.php
  63. src/XF/Entity/UserOption.php
  64. src/addons/ThemeHouse/UIX/Listener/EntityStructure.php
  65. src/XF/Entity/UserProfile.php
  66. src/XF/Entity/UserPrivacy.php
  67. src/XF/Util/File.php
  68. src/XF/Language.php
  69. src/XF/Mvc/Dispatcher.php
  70. src/XF/Mvc/Router.php
  71. src/XF/Mvc/RouteMatch.php
  72. src/XF/Util/Arr.php
  73. src/XF/Mvc/ParameterBag.php
  74. src/XF/Pub/Controller/Index.php
  75. src/XF/Pub/Controller/AbstractController.php
  76. src/XF/Mvc/Controller.php
  77. src/XF/Util/Php.php
  78. src/XF/PermissionCache.php
  79. src/XF/PermissionSet.php
  80. src/XF/Db/Mysqli/Statement.php
  81. src/XF/Db/AbstractStatement.php
  82. src/XF/Mvc/Reply/Reroute.php
  83. src/XF/Mvc/Reply/AbstractReply.php
  84. src/XF/Pub/Controller/Forum.php
  85. src/XF/Repository/Node.php
  86. src/XF/Entity/Node.php
  87. src/XF/Entity/BookmarkTrait.php
  88. src/addons/ThemeHouse/Nodes/XF/Entity/Node.php
  89. src/addons/ThemeHouse/UIX/XF/Entity/Node.php
  90. src/XF/Template/Templater.php
  91. src/addons/ThemeHouse/UIX/XF/Template/Templater.php
  92. src/XF/SubContainer/BbCode.php
  93. src/XF/SubContainer/AbstractSubContainer.php
  94. src/XF/SubContainer/Widget.php
  95. src/addons/ThemeHouse/Nodes/Listener/TemplaterSetup.php
  96. src/addons/ThemeHouse/UIX/Listener/TemplaterSetup.php
  97. src/XF/Finder/Node.php
  98. src/XF/Mvc/Entity/Finder.php
  99. src/XF/Mvc/Entity/ArrayCollection.php
  100. src/XF/Mvc/Entity/AbstractCollection.php
  101. src/XF/Entity/Category.php
  102. src/XF/Entity/AbstractNode.php
  103. src/XF/Entity/Forum.php
  104. src/XF/Entity/Thread.php
  105. src/XF/Tree.php
  106. src/XF/SubTree.php
  107. src/XF/Str/Formatter.php
  108. src/XF/Mvc/Reply/View.php
  109. src/XF/Repository/SessionActivity.php
  110. src/XF/Data/Robot.php
  111. src/XF/Style.php
  112. src/XF/SimpleCache.php
  113. src/XF/Mvc/Renderer/Html.php
  114. src/XF/Mvc/Renderer/AbstractRenderer.php
  115. src/XF/Mvc/View.php
  116. src/XF/Template/Template.php
  117. internal_data/code_cache/templates/l1/s5/public/forum_list.php
  118. src/XF/PreEscaped.php
  119. internal_data/code_cache/templates/l1/s5/public/metadata_macros.php
  120. internal_data/code_cache/widgets/_6_forum_overview_members_online.php
  121. src/XF/Widget/WidgetConfig.php
  122. src/XF/Widget/MembersOnline.php
  123. src/XF/Widget/AbstractWidget.php
  124. src/XF/Entity/SessionActivity.php
  125. src/XF/Finder/SessionActivity.php
  126. src/XF/Phrase.php
  127. internal_data/code_cache/phrase_groups/l1/widget.php
  128. internal_data/code_cache/phrase_groups/l1/widget_def.php
  129. src/XF/Widget/WidgetRenderer.php
  130. internal_data/code_cache/templates/l1/s5/public/widget_members_online.php
  131. internal_data/code_cache/widgets/_9_forum_overview_new_posts.php
  132. src/XF/Widget/NewPosts.php
  133. src/XF/Repository/Thread.php
  134. src/XF/Finder/Thread.php
  135. src/XF/Entity/PermissionCacheContent.php
  136. src/XF/Mvc/Entity/Proxyable.php
  137. src/XF/Mvc/Entity/FinderCollection.php
  138. internal_data/code_cache/templates/l1/s5/public/widget_new_posts.php
  139. internal_data/code_cache/widgets/_7_forum_overview_forum_statistics.php
  140. src/XF/Widget/ForumStatistics.php
  141. internal_data/code_cache/templates/l1/s5/public/widget_forum_statistics.php
  142. internal_data/code_cache/widgets/_10_forum_overview_new_profile_posts.php
  143. src/XF/Widget/NewProfilePosts.php
  144. src/XF/Entity/ProfilePost.php
  145. src/XF/Entity/ReactionTrait.php
  146. src/XF/BbCode/RenderableContentInterface.php
  147. src/XF/Finder/ProfilePost.php
  148. internal_data/code_cache/templates/l1/s5/public/widget_new_profile_posts.php
  149. internal_data/code_cache/templates/l1/s5/public/profile_post_macros.php
  150. src/XF/BbCode/Parser.php
  151. src/XF/BbCode/RuleSet.php
  152. src/XF/BbCode/Renderer/Html.php
  153. src/XF/BbCode/Renderer/AbstractRenderer.php
  154. src/XF/BbCode/Traverser.php
  155. src/XF/Str/EmojiFormatter.php
  156. src/vendor/emojione/emojione/lib/php/src/Client.php
  157. src/vendor/emojione/emojione/lib/php/src/ClientInterface.php
  158. src/vendor/emojione/emojione/lib/php/src/Ruleset.php
  159. src/vendor/emojione/emojione/lib/php/src/RulesetInterface.php
  160. internal_data/code_cache/widgets/_8_forum_overview_share_page.php
  161. src/XF/Widget/SharePage.php
  162. internal_data/code_cache/templates/l1/s5/public/widget_share_page.php
  163. internal_data/code_cache/templates/l1/s5/public/share_page_macros.php
  164. internal_data/code_cache/templates/l1/s5/public/node_list_category.php
  165. src/XF/Pub/Route/Category.php
  166. src/XF/Mvc/RouteBuiltLink.php
  167. src/addons/ThemeHouse/Nodes/Repository/NodeStyling.php
  168. internal_data/code_cache/templates/l1/s5/public/node_list_forum.php
  169. internal_data/code_cache/templates/l1/s5/public/forum_overview_wrapper.php
  170. internal_data/code_cache/templates/l1/s5/public/_ads.php
  171. internal_data/code_cache/navigation_cache.php
  172. src/XF/Pub/Route/Search.php
  173. src/XF/NoticeList.php
  174. src/addons/ThemeHouse/UIX/Listener/AppPubRenderPage.php
  175. src/addons/ThemeHouse/UIX/Util/UIX.php
  176. internal_data/code_cache/templates/l1/s5/public/PAGE_CONTAINER.php
  177. internal_data/code_cache/phrase_groups/l1/button.php
  178. internal_data/code_cache/templates/l1/s5/public/uix_socialMedia.php
  179. internal_data/code_cache/templates/l1/s5/public/uix_welcomeSection.php
  180. internal_data/code_cache/phrase_groups/l1/nav.php
  181. internal_data/code_cache/templates/l1/s5/public/uix_mainTabSets.php
  182. internal_data/code_cache/templates/l1/s5/public/uix_extendedFooter.php
  183. src/addons/ThemeHouse/Core/Branding.php
  184. src/addons/ThemeHouse/Core/Branding/20180420.php
  185. internal_data/code_cache/templates/l1/s5/public/debug_macros.php
  186. internal_data/code_cache/templates/l1/s5/public/helper_js_global.php
  187. internal_data/code_cache/templates/l1/s5/public/font_awesome_setup.php
  188. internal_data/code_cache/templates/l1/s5/public/google_analytics.php
  189. internal_data/code_cache/templates/l1/s5/public/page_style.php
  190. internal_data/code_cache/templates/l1/s5/public/uix_canvasTabs.php
  191. internal_data/code_cache/templates/l1/s5/public/uix_canvasPanels.php
  192. internal_data/code_cache/templates/l1/s5/public/browser_warning_macros.php
  193. internal_data/code_cache/templates/l1/s5/public/uix_config.php
  194. src/addons/ThemeHouse/UIX/Listener/Pub/TemplaterMacroPreRender.php
  195. internal_data/code_cache/templates/l1/s5/public/uix_js.php
  196. internal_data/code_cache/phrase_groups/l1/reaction_title.php
  197. src/XF/Debugger.php

DB Connection Stats

bytes_sent11095
bytes_received537782
packets_sent142
packets_received1563
protocol_overhead_in6252
protocol_overhead_out568
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet459
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet143
bytes_received_prepare_response_packet75333
bytes_received_change_user_packet461243
packets_sent_command70
packets_received_ok0
packets_received_eof0
packets_received_rset_header51
packets_received_rset_field_meta0
packets_received_rset_row25
packets_received_prepare_response1063
packets_received_change_user399
result_set_queries22
non_result_set_queries3
no_index_used4
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets22
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed22
rows_fetched_from_server_normal0
rows_fetched_from_server_ps377
rows_buffered_from_client_normal0
rows_buffered_from_client_ps377
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_ps377
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_bit1215
proto_binary_fetched_tinyint0
proto_binary_fetched_short1963
proto_binary_fetched_int24672
proto_binary_fetched_int0
proto_binary_fetched_bigint5873
proto_binary_fetched_decimal23
proto_binary_fetched_float3
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_json3101
proto_binary_fetched_blob1234
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_prepare23
com_stmt_execute23
com_stmt_send_long_data0
com_stmt_close22
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps452372