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.000188
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 1549
- XF\App->preLoadData() in src/XF/App.php at line 1539
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 317
- XF::setupApp() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000075
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 908
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 225
- 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 1934
- XF\App->run() in src/XF.php at line 333
- 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` = '51236')
LIMIT 1
Run Time: 0.000672
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 1277
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 13
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/STTA/XF/Pub/Controller/Thread.php at line 13
- xenMade\STTA\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- 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` = 51236) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 10)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.000756
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 | 4 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_post.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_3 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_4 | eq_ref | PRIMARY | PRIMARY | 22 | elsmar_xenforo201810.xf_user_User_1.user_id,func | 1 | 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/XF/Pub/Controller/Thread.php at line 36
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/STTA/XF/Pub/Controller/Thread.php at line 13
- xenMade\STTA\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- 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: 51236
Run Time: 0.000057
- 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 156
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 83
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/STTA/XF/Pub/Controller/Thread.php at line 13
- xenMade\STTA\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_node`.*
FROM `xf_node`
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 162 | Using where; Using filesort |
- 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/Repository/Node.php at line 17
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
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 (76, 110, 158, 194, 5, 6, 79, 94, 7, 87))
Run Time: 0.000082
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 10 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_category.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/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 121
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_forum`.*, `xf_node_Node_1`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
WHERE (`xf_forum`.`node_id` IN (107, 146, 174, 220, 160, 120, 112, 111, 156, 119, 113, 167, 95, 192, 172, 217, 137, 15, 222, 235, 236, 204, 151, 179, 181, 90, 175, 208, 25, 10, 214, 162, 215, 132, 225, 159, 216, 213, 97, 37, 43, 233, 183, 44, 182, 189, 186, 185, 202, 195, 198, 200, 197, 199, 212, 180, 196, 201, 203, 147, 219, 3, 12, 193, 133, 22, 118, 123, 116, 77, 149, 168, 58, 163, 16, 21, 205, 13, 128, 145, 140, 91, 135, 114, 134, 157, 14, 40, 55, 41, 223, 178, 101, 169, 89, 36, 136, 150, 102, 92, 93, 19, 131, 75, 103, 115, 18, 31, 39, 231, 109, 88, 30, 100, 108, 78, 171, 83, 23, 211, 173, 33, 191, 80, 177, 121, 152, 230, 74, 153))
Run Time: 0.000211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 145 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_forum.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/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 121
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_link_forum`.*, `xf_node_Node_1`.*
FROM `xf_link_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_link_forum`.`node_id`)
WHERE (`xf_link_forum`.`node_id` IN (234, 187, 125, 206, 207))
Run Time: 0.000084
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_link_forum | ALL | PRIMARY | | | | 7 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_link_forum.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/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 121
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 288 | 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/PermissionCache.php at line 100
- XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 929
- XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 135
- XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Revision%') AND (`xf_thread`.`title` LIKE '%CFR%') AND (`xf_thread`.`title` LIKE '%sections%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 51236) AND ((`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 120) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 172) OR (`xf_thread`.`node_id` = 217) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 15) OR (`xf_thread`.`node_id` = 222) OR (`xf_thread`.`node_id` = 235) OR (`xf_thread`.`node_id` = 236) OR (`xf_thread`.`node_id` = 204) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 208) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 214) OR (`xf_thread`.`node_id` = 234) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 215) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 225) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 216) OR (`xf_thread`.`node_id` = 213) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 194) OR (`xf_thread`.`node_id` = 233) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 202) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 195) OR (`xf_thread`.`node_id` = 198) OR (`xf_thread`.`node_id` = 200) OR (`xf_thread`.`node_id` = 197) OR (`xf_thread`.`node_id` = 199) OR (`xf_thread`.`node_id` = 212) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 196) OR (`xf_thread`.`node_id` = 201) OR (`xf_thread`.`node_id` = 203) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 219) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 133) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 123) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 206) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 149) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 163) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 205) OR (`xf_thread`.`node_id` = 13) OR (`xf_thread`.`node_id` = 128) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 140) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 207) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 223) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 169) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 150) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 131) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 231) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 171) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 211) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 152) OR (`xf_thread`.`node_id` = 230) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 153))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 5
Run Time: 0.114734
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 30169 | 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/Andy/SimilarThreads/Repository/SimilarThreads.php at line 210
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Revision%') AND (`xf_thread`.`title` LIKE '%CFR%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 51236) AND (1) AND ((`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 120) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 172) OR (`xf_thread`.`node_id` = 217) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 15) OR (`xf_thread`.`node_id` = 222) OR (`xf_thread`.`node_id` = 235) OR (`xf_thread`.`node_id` = 236) OR (`xf_thread`.`node_id` = 204) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 208) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 214) OR (`xf_thread`.`node_id` = 234) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 215) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 225) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 216) OR (`xf_thread`.`node_id` = 213) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 194) OR (`xf_thread`.`node_id` = 233) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 202) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 195) OR (`xf_thread`.`node_id` = 198) OR (`xf_thread`.`node_id` = 200) OR (`xf_thread`.`node_id` = 197) OR (`xf_thread`.`node_id` = 199) OR (`xf_thread`.`node_id` = 212) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 196) OR (`xf_thread`.`node_id` = 201) OR (`xf_thread`.`node_id` = 203) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 219) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 133) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 123) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 206) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 149) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 163) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 205) OR (`xf_thread`.`node_id` = 13) OR (`xf_thread`.`node_id` = 128) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 140) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 207) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 223) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 169) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 150) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 131) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 231) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 171) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 211) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 152) OR (`xf_thread`.`node_id` = 230) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 153))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 5
Run Time: 0.113806
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 30169 | 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/Andy/SimilarThreads/Repository/SimilarThreads.php at line 259
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Revision%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 51236) AND (`xf_thread`.`thread_id` <> 62362 AND `xf_thread`.`thread_id` <> 20352) AND ((`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 120) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 172) OR (`xf_thread`.`node_id` = 217) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 15) OR (`xf_thread`.`node_id` = 222) OR (`xf_thread`.`node_id` = 235) OR (`xf_thread`.`node_id` = 236) OR (`xf_thread`.`node_id` = 204) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 208) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 214) OR (`xf_thread`.`node_id` = 234) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 215) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 225) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 216) OR (`xf_thread`.`node_id` = 213) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 194) OR (`xf_thread`.`node_id` = 233) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 202) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 195) OR (`xf_thread`.`node_id` = 198) OR (`xf_thread`.`node_id` = 200) OR (`xf_thread`.`node_id` = 197) OR (`xf_thread`.`node_id` = 199) OR (`xf_thread`.`node_id` = 212) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 196) OR (`xf_thread`.`node_id` = 201) OR (`xf_thread`.`node_id` = 203) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 219) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 133) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 123) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 206) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 149) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 163) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 205) OR (`xf_thread`.`node_id` = 13) OR (`xf_thread`.`node_id` = 128) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 140) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 207) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 223) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 169) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 150) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 131) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 231) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 171) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 211) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 152) OR (`xf_thread`.`node_id` = 230) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 153))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 3
Run Time: 0.003696
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 30169 | 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/Andy/SimilarThreads/Repository/SimilarThreads.php at line 308
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE ((`xf_thread`.`thread_id` = 62362) OR (`xf_thread`.`thread_id` = 20352) OR (`xf_thread`.`thread_id` = 78000) OR (`xf_thread`.`thread_id` = 77399) OR (`xf_thread`.`thread_id` = 77173))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000261
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using filesort |
- 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/Andy/SimilarThreads/Repository/SimilarThreads.php at line 449
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\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 1934
- XF\App->run() in src/XF.php at line 333
- 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=51236, 1575703530,
Run Time: 0.000135
- 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 67
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 278
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000312
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 77 | const | 4 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | 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/Siropu/AdsManager/Template/Ad.php at line 395
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 254
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 25
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2395
- XF\App->fire() in src/XF/App.php at line 1705
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1590
- XF\App->preRender() in src/XF/Pub/App.php at line 363
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 280
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 0) AND (`xf_session_activity`.`unique_key` = '0')
LIMIT 1
Run Time: 0.000130
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/addons/Siropu/AdsManager/Entity/Ad.php at line 274
- Siropu\AdsManager\Entity\Ad->matchesUserCriteria() in src/addons/Siropu/AdsManager/Template/Ad.php at line 399
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 167
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 403
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 254
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 25
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2395
- XF\App->fire() in src/XF/App.php at line 1705
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1590
- XF\App->preRender() in src/XF/Pub/App.php at line 363
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 280
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
Run Time: 0.000750
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 77 | const | 4 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | elsmar_xenforo201810.xf_siropu_ads_manager_ad.package_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/Siropu/AdsManager/Template/Ad.php at line 505
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 258
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 25
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2395
- XF\App->fire() in src/XF/App.php at line 1705
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1590
- XF\App->preRender() in src/XF/Pub/App.php at line 363
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 280
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT SUM(attach_count) FROM xf_post as post WHERE thread_id = ? AND message_state = 'visible'
Params: 51236
Run Time: 0.000187
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 4 | 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 91
- XF\Db\AbstractAdapter->fetchOne() in src/addons/xenMade/STTA/XF/Repository/Thread.php at line 13
- xenMade\STTA\XF\Repository\Thread->_countAttachmentsForThread() in src/addons/xenMade/STTA/XF/Entity/Thread.php at line 14
- xenMade\STTA\XF\Entity\Thread->canViewAttachmentsList()
- call_user_func_array() in src/XF/Template/Templater.php at line 940
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s2/public/stta_thread_insert.php at line 6
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 196
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 24791) AND (`xf_session_activity`.`unique_key` = '24791')
LIMIT 1
Run Time: 0.000107
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 300
- 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 467
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 228
- XF\Entity\User->isOnline()
- call_user_func_array() in src/XF/Template/Templater.php at line 940
- XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s2/public/message_macros.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 663
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s2/public/post_macros.php at line 39
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 663
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 555
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 296379)
LIMIT 1
Run Time: 0.000147
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | 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 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s2/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 731
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 317494)
LIMIT 1
Run Time: 0.000281
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | 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 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s2/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 731
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 314136)
LIMIT 1
Run Time: 0.000141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | 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 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s2/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 731
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 265509)
LIMIT 1
Run Time: 0.000257
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 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s2/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 731
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 34367)
LIMIT 1
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | 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 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s2/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1324
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s2/public/thread_view.php at line 731
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 1934
- XF\App->run() in src/XF.php at line 333
- 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: b1bCR9fsEMztdKh-r5LFGu45fqEWAcMd, , 1575717930
Run Time: 0.000116
- 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 373
- XF\Pub\App->complete() in src/XF/App.php at line 1937
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
bytes_sent | 0 |
bytes_received | 0 |
packets_sent | 0 |
packets_received | 0 |
protocol_overhead_in | 0 |
protocol_overhead_out | 0 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 0 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 0 |
bytes_received_prepare_response_packet | 0 |
bytes_received_change_user_packet | 0 |
packets_sent_command | 0 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 0 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 0 |
packets_received_prepare_response | 0 |
packets_received_change_user | 0 |
result_set_queries | 0 |
non_result_set_queries | 0 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 0 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 0 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 0 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 0 |
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 | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 0 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 0 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 0 |
active_connections | 0 |
active_persistent_connections | 0 |
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 | 0 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 0 |
proto_binary_fetched_int24 | 0 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 0 |
proto_binary_fetched_decimal | 0 |
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 | 0 |
proto_binary_fetched_blob | 0 |
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 | 0 |
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 | 0 |
com_stmt_execute | 0 |
com_stmt_send_long_data | 0 |
com_stmt_close | 0 |
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 | 0 |