SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.001539
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 34 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/App.php at line 1511
- XF\App->preLoadData() in src/XF/App.php at line 1501
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 312
- XF::setupApp() in src/XF.php at line 324
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000293
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 901
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 224
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 117
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`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_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_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '57001')
LIMIT 1
Run Time: 0.001468
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1254
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 13
- XF\Pub\Controller\Thread->actionIndex() in src/addons/XenMax/SamCategory/XF/Pub/Controller/Thread.php at line 23
- XenMax\SamCategory\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_profile_Profile_2`.*, `xf_user_privacy_Privacy_3`.*, `xf_session_activity_Activity_4`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_4` ON (`xf_session_activity_Activity_4`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_4`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 57001) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.001985
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_post.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_session_activity_Activity_4 | eq_ref | PRIMARY | PRIMARY | 22 | thol.xf_user_User_1.user_id,func | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 36
- XF\Pub\Controller\Thread->actionIndex() in src/addons/XenMax/SamCategory/XF/Pub/Controller/Thread.php at line 23
- XenMax\SamCategory\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 57001
Run Time: 0.000115
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 157
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 83
- XF\Pub\Controller\Thread->actionIndex() in src/addons/XenMax/SamCategory/XF/Pub/Controller/Thread.php at line 23
- XenMax\SamCategory\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`node_id` = 166) AND (`xf_thread`.`thread_id` <> 57001) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect')
ORDER BY `xf_thread`.`thread_id` DESC
LIMIT 5
Run Time: 0.001244
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | index | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | | 70 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenMax/SamCategory/Repository/Helper.php at line 17
- XenMax\SamCategory\Repository\Helper->getSameForumThread() in src/addons/XenMax/SamCategory/XF/Pub/Controller/Thread.php at line 30
- XenMax\SamCategory\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `ewr_porta_articles`.*
FROM `ewr_porta_articles`
WHERE (`ewr_porta_articles`.`thread_id` = 57001)
LIMIT 1
Run Time: 0.000289
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 373
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 171
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 95
- XF\Mvc\Entity\Entity->__get() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 19
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `ewr_porta_features`.*
FROM `ewr_porta_features`
WHERE (`ewr_porta_features`.`thread_id` = 57001)
LIMIT 1
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/EWR/Porta/Repository/Feature.php at line 22
- EWR\Porta\Repository\Feature->fetchFeatureByThread() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 50
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/VNNET/UpThread/XF/Pub/Controller/Thread.php at line 13
- VNNET\UpThread\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- 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\Thread, Index, valid, thread_id=57001, 1550686843,
Run Time: 0.000147
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 66
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 270
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 26854) AND (`xf_session_activity`.`unique_key` = '26854')
LIMIT 1
Run Time: 0.000286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 352
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 373
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 171
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 95
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 298
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 95
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 465
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 226
- XF\Entity\User->isOnline()
- call_user_func_array() in src/XF/Template/Templater.php at line 938
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s16/public/message_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 661
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s16/public/XMMT_more_thread.php at line 43
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 661
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s16/public/thread_view.php at line 634
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1248
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_user_option`.*
FROM `xf_user_option`
WHERE (`xf_user_option`.`user_id` = 26854)
LIMIT 1
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 352
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 373
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 171
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 95
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/UserProfile.php at line 149
- XF\Entity\UserProfile->getAge() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s16/public/message_macros.php at line 123
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 661
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s16/public/XMMT_more_thread.php at line 43
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 661
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s16/public/thread_view.php at line 634
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1248
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
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` > 1548094843) AND (`xf_thread`.`node_id` IN (11, 23, 35, 21, 154, 153, 155, 156, 168, 39, 141, 36, 28, 12, 30, 167, 65, 127, 138, 113, 66, 122, 137, 117, 119, 121, 68, 132, 134, 136, 159, 67, 139, 69, 120, 2, 9, 10, 40, 14, 33, 102, 25, 37, 16, 94, 58, 45, 46, 49, 52, 51, 50, 142, 59, 47, 165, 53, 4, 24, 74, 125, 64, 72, 106, 144, 118, 61, 158, 145, 146, 147, 157, 54, 95, 96, 97, 98, 99, 100, 48, 104, 44, 56, 93, 62, 81, 101, 60, 79, 114, 82, 135, 162, 5, 151, 152))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.003184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 481 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thol.xf_node_Node_2.node_id | 1 | |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 87
- XF\Widget\NewPosts->render() in src/XF/Template/Templater.php at line 1524
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s16/public/thread_view.php at line 835
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1248
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
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_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')
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`reply_count` > 0)
ORDER BY `xf_thread`.`reply_count` DESC
LIMIT 20
Run Time: 0.059544
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | | | | | 25421 | Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thol.xf_node_Node_2.node_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/addons/DL6/MLTP/XF/Widget/MostRepliedThreads.php at line 157
- DL6\MLTP\XF\Widget\MostRepliedThreads->render() in src/XF/Template/Templater.php at line 1524
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s16/public/thread_view.php at line 835
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1248
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
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.001501
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | index | | post_date | 4 | | 10 | Using where |
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_user_ProfileUser_1.user_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thol.xf_profile_post.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1164
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewProfilePosts.php at line 66
- XF\Widget\NewProfilePosts->render() in src/XF/Template/Templater.php at line 1524
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s16/public/thread_view.php at line 835
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1248
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- 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: JuBJC91GpLOWS5uPw1iprZDSSwueVlLa, , 1550701243
Run Time: 0.000285
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in src/XF/Pub/App.php at line 360
- XF\Pub\App->complete() in src/XF/App.php at line 1894
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
bytes_sent | 16504 |
bytes_received | 555522 |
packets_sent | 166 |
packets_received | 1623 |
protocol_overhead_in | 6492 |
protocol_overhead_out | 664 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 369 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 175 |
bytes_received_prepare_response_packet | 103575 |
bytes_received_change_user_packet | 450762 |
packets_sent_command | 82 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 41 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 29 |
packets_received_prepare_response | 1375 |
packets_received_change_user | 149 |
result_set_queries | 24 |
non_result_set_queries | 5 |
no_index_used | 2 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 24 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 26 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 125 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 125 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 4 |
rows_skipped_normal | 0 |
rows_skipped_ps | 125 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estndup_count | 0 |
mem_strdup_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 325 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1009 |
proto_binary_fetched_int24 | 402 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2665 |
proto_binary_fetched_decimal | 63 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 1826 |
proto_binary_fetched_blob | 566 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 27 |
com_stmt_execute | 27 |
com_stmt_send_long_data | 0 |
com_stmt_close | 26 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 446389 |