Page Time: 0.0272s

Memory: 2.9814 MB (Peak: 3.1533 MB)

Queries (8, time: 0.0034s, 12.4%)

  1. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('noticesLastReset')
    Run Time: 0.000222
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       no matching row in const table

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
    3. XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
    4. XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
    5. XF\DataRegistry->get() in src/XF/App.php at line 1509
    6. XF\App->preLoadData() in src/XF/App.php at line 1499
    7. XF\App->setup() in src/XF/Pub/App.php at line 45
    8. XF\Pub\App->setup() in src/XF.php at line 312
    9. XF::setupApp() in src/XF.php at line 324
    10. XF::runApp() in index.php at line 13
  2. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000290
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 915
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 224
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 117
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    13. XF\App->run() in src/XF.php at line 328
    14. XF::runApp() in index.php at line 13
  3. SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
    FROM `xf_forum`
    INNER 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')
    WHERE (`xf_forum`.`node_id` = '113')
    
    
    LIMIT 1
    Run Time: 0.000455
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_forumconstPRIMARYPRIMARY4const1 
    SIMPLExf_node_Node_1constPRIMARYPRIMARY4const1 
    SIMPLExf_permission_cache_content_Permissions_2constPRIMARYPRIMARY35const,const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1116
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 997
    4. XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 190
    5. XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 249
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    9. XF\App->run() in src/XF.php at line 328
    10. XF::runApp() in index.php at line 13
  4. SELECT `xf_thread`.*, `xf_user_User_1`.*
    FROM `xf_thread`
    LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
    WHERE (`xf_thread`.`node_id` = 113) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 1)
    ORDER BY `xf_thread`.`last_post_date` DESC
    Run Time: 0.000643
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrefnode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post6const,const,const3Using where
    SIMPLExf_user_User_1eq_refPRIMARYPRIMARY4tor4.xf_thread.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1149
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 216
    4. XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 249
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    6. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    7. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    8. XF\App->run() in src/XF.php at line 328
    9. XF::runApp() in index.php at line 13
  5. SELECT `xf_thread`.*, `xf_user_User_1`.*
    FROM `xf_thread`
    LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
    WHERE (`xf_thread`.`node_id` = 113) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0)
    ORDER BY `xf_thread`.`last_post_date` DESC
    
    LIMIT 20
    Run Time: 0.000895
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrefnode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post6const,const,const140Using where
    SIMPLExf_user_User_1eq_refPRIMARYPRIMARY4tor4.xf_thread.user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1149
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 227
    4. XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 249
    5. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    6. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    7. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    8. XF\App->run() in src/XF.php at line 328
    9. XF::runApp() in index.php at line 13
  6. SELECT COUNT(*)
    FROM `xf_thread`
    
    WHERE (`xf_thread`.`node_id` = 113) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0)
    Run Time: 0.000340
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrefnode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post6const,const,const140Using index

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1104
    4. XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Forum.php at line 228
    5. XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 249
    6. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    7. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    8. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    9. XF\App->run() in src/XF.php at line 328
    10. XF::runApp() in index.php at line 13
  7. -- 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, Forum, valid, node_id=113, 1534345242,
    Run Time: 0.000205

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 65
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 40
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 270
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
    8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
    9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
    10. XF\App->run() in src/XF.php at line 328
    11. XF::runApp() in index.php at line 13
  8. -- XFDB=noForceAllWrite
    INSERT INTO xf_session
    	(session_id, session_data, expiry_date)
    VALUES
    	(?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	session_data = VALUES(session_data),
    	expiry_date = VALUES(expiry_date)
    Params: 4KOFpOTEKZCDbz2FLSzkHDOW_y_aBWad, , 1534359642
    Run Time: 0.000312

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

Included Files (128, XenForo Classes: 86)

  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/react/promise/src/functions_include.php
  9. src/vendor/react/promise/src/functions.php
  10. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  11. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  12. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  13. src/vendor/dokuwiki/utf8/utf8.php
  14. src/XF/Pub/App.php
  15. src/XF/App.php
  16. src/XF/Container.php
  17. src/config.php
  18. src/XF/DataRegistry.php
  19. src/XF/Db/Mysqli/Adapter.php
  20. src/XF/Db/AbstractAdapter.php
  21. src/XF/CacheFactory.php
  22. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
  23. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
  24. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  25. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  26. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  27. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  28. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  29. src/XF/Db/Mysqli/Statement.php
  30. src/XF/Db/AbstractStatement.php
  31. src/XF/Extension.php
  32. src/addons/XFRM/Listener.php
  33. src/addons/Siropu/Chat/Listener.php
  34. src/XF/Http/Request.php
  35. src/XF/InputFilterer.php
  36. src/XF/Session/Session.php
  37. src/XF/Session/DbStorage.php
  38. src/XF/Session/StorageInterface.php
  39. src/XF/Util/Ip.php
  40. src/XF/Util/Random.php
  41. src/XF/Data/Robot.php
  42. src/XF/Mvc/Entity/Manager.php
  43. src/XF/Mvc/Entity/ValueFormatter.php
  44. src/XF/Repository/User.php
  45. src/XF/Mvc/Entity/Repository.php
  46. src/XF/Entity/User.php
  47. src/XF/Mvc/Entity/Entity.php
  48. src/addons/XFRM/XF/Entity/User.php
  49. src/addons/Siropu/Chat/XF/Entity/User.php
  50. src/XF/Mvc/Entity/Structure.php
  51. src/XF/Entity/UserAuth.php
  52. src/XF/Entity/UserOption.php
  53. src/XF/Entity/UserProfile.php
  54. src/XF/Entity/UserPrivacy.php
  55. src/XF/Util/File.php
  56. src/XF/Language.php
  57. src/XF/Mvc/Dispatcher.php
  58. src/XF/Mvc/Router.php
  59. src/XF/Mvc/RouteMatch.php
  60. src/XF/Util/Arr.php
  61. src/XF/Mvc/ParameterBag.php
  62. src/XF/Pub/Controller/Forum.php
  63. src/XF/Pub/Controller/AbstractController.php
  64. src/XF/Mvc/Controller.php
  65. src/XF/Util/Php.php
  66. src/XF/PermissionCache.php
  67. src/XF/PermissionSet.php
  68. src/XF/Mvc/Reply/Reroute.php
  69. src/XF/Mvc/Reply/AbstractReply.php
  70. src/XF/Entity/Forum.php
  71. src/XF/Entity/AbstractNode.php
  72. src/XF/Mvc/Entity/Finder.php
  73. src/XF/Entity/Node.php
  74. src/XF/Entity/PermissionCacheContent.php
  75. src/XF/Mvc/Entity/Proxyable.php
  76. src/XF/Mvc/Entity/FinderCollection.php
  77. src/XF/Mvc/Entity/AbstractCollection.php
  78. src/XF/ControllerPlugin/Node.php
  79. src/XF/ControllerPlugin/AbstractPlugin.php
  80. src/XF/Repository/Thread.php
  81. src/XF/Entity/Thread.php
  82. src/XF/Finder/Thread.php
  83. src/XF/Mvc/Entity/ArrayCollection.php
  84. src/XF/Repository/Node.php
  85. src/XF/Mvc/Reply/View.php
  86. src/XF/Repository/SessionActivity.php
  87. src/XF/Style.php
  88. src/XF/Template/Templater.php
  89. src/XF/SubContainer/BbCode.php
  90. src/XF/SubContainer/AbstractSubContainer.php
  91. src/XF/SubContainer/Widget.php
  92. src/XF/SimpleCache.php
  93. src/XF/Http/Response.php
  94. src/XF/Mvc/Renderer/Html.php
  95. src/XF/Mvc/Renderer/AbstractRenderer.php
  96. src/XF/Mvc/View.php
  97. src/XF/Template/Template.php
  98. internal_data/code_cache/templates/l1/s11/public/forum_view.php
  99. src/XF/PreEscaped.php
  100. internal_data/code_cache/templates/l1/s11/public/metadata_macros.php
  101. internal_data/code_cache/templates/l1/s11/public/forum_macros.php
  102. src/XF/Pub/Route/Category.php
  103. src/XF/Mvc/RouteBuiltLink.php
  104. internal_data/code_cache/templates/l1/s11/public/_ads.php
  105. internal_data/code_cache/templates/l1/s11/public/page_nav.php
  106. internal_data/code_cache/templates/l1/s11/public/thread_list_macros.php
  107. src/XF/Str/Formatter.php
  108. src/XF/Util/Color.php
  109. internal_data/code_cache/navigation_cache.php
  110. src/XF/Phrase.php
  111. src/XF/Pub/Route/Search.php
  112. src/addons/Siropu/Chat/Navigation/Tab.php
  113. src/XF/NoticeList.php
  114. src/XF/Criteria/User.php
  115. src/XF/Criteria/AbstractCriteria.php
  116. src/XF/Criteria/Page.php
  117. internal_data/code_cache/templates/l1/s11/public/PAGE_CONTAINER.php
  118. internal_data/code_cache/templates/l1/s11/public/helper_js_global.php
  119. internal_data/code_cache/templates/l1/s11/public/google_analytics.php
  120. internal_data/code_cache/phrase_groups/l1/nav.php
  121. internal_data/code_cache/phrase_groups/l1/button.php
  122. internal_data/code_cache/templates/l1/s11/public/notice_macros.php
  123. internal_data/code_cache/templates/l1/s11/public/browser_warning_macros.php
  124. src/XF/Widget/WidgetConfig.php
  125. src/addons/Siropu/Chat/Widget/Chat.php
  126. src/XF/Widget/AbstractWidget.php
  127. internal_data/code_cache/templates/l1/s11/public/debug_macros.php
  128. src/XF/Debugger.php

DB Connection Stats

bytes_sent5374
bytes_received48818
packets_sent88
packets_received540
protocol_overhead_in2160
protocol_overhead_out352
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet198
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet104
bytes_received_prepare_response_packet29840
bytes_received_change_user_packet18286
packets_sent_command43
packets_received_ok0
packets_received_eof0
packets_received_rset_header22
packets_received_rset_field_meta0
packets_received_rset_row16
packets_received_prepare_response438
packets_received_change_user48
result_set_queries12
non_result_set_queries4
no_index_used0
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets12
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed13
rows_fetched_from_server_normal0
rows_fetched_from_server_ps36
rows_buffered_from_client_normal0
rows_buffered_from_client_ps36
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_ps36
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_bit599
proto_binary_fetched_tinyint0
proto_binary_fetched_short134
proto_binary_fetched_int2442
proto_binary_fetched_int0
proto_binary_fetched_bigint474
proto_binary_fetched_decimal20
proto_binary_fetched_float0
proto_binary_fetched_double0
proto_binary_fetched_date9
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json283
proto_binary_fetched_blob56
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_prepare14
com_stmt_execute14
com_stmt_send_long_data0
com_stmt_close13
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps17452