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.000194
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.000076
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` = '44691')
LIMIT 1
Run Time: 0.000727
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 | 0 | unique row not found |
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` = 44691) 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.000865
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 10 | Using index condition; 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: 44691
Run Time: 0.000066
- 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.000132
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.000090
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.000252
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.000080
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.000130
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 '%Organization%') AND (`xf_thread`.`title` LIKE '%Chart%') AND (`xf_thread`.`title` LIKE '%Control%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 44691) 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.116293
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 | | 29554 | 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 '%Organization%') AND (`xf_thread`.`title` LIKE '%Chart%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 44691) AND (`xf_thread`.`thread_id` <> 47757) 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 4
Run Time: 0.023370
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 | | 29554 | 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`.`thread_id` = 47757) OR (`xf_thread`.`thread_id` = 70500) OR (`xf_thread`.`thread_id` = 66814) OR (`xf_thread`.`thread_id` = 65151) OR (`xf_thread`.`thread_id` = 64583))
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=44691, 1576033972,
Run Time: 0.000110
- 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.000322
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.000142
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.000825
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: 44691
Run Time: 0.000251
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 | 16 | 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_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 255997)
LIMIT 1
Run Time: 0.000338
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` = 154003)
LIMIT 1
Run Time: 0.000157
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: waxuStWs2c3I7st6gTK7uVPpkK9hAiSJ, , 1576048372
Run Time: 0.000121
- 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 |