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.000221
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.000062
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` = '33889')
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` = 33889) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 20) AND (`xf_post`.`position` < 30)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.000936
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: 33889
Run Time: 0.000048
- 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.000165
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.000100
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.000230
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.000093
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.000121
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 '%Puzzle%') AND (`xf_thread`.`title` LIKE '%given%') AND (`xf_thread`.`title` LIKE '%Company%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 33889) 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.101914
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 '%Puzzle%') AND (`xf_thread`.`title` LIKE '%given%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 33889) 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.106269
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 '%Puzzle%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 33889) 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.054593
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` = 57823) OR (`xf_thread`.`thread_id` = 55338) OR (`xf_thread`.`thread_id` = 50396) OR (`xf_thread`.`thread_id` = 43473) OR (`xf_thread`.`thread_id` = 42027))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000282
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=33889&page=3, 1575721431,
Run Time: 0.000091
- 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.000686
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.000149
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.000739
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: 33889
Run Time: 0.000422
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 | 33 | 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` = 56337)
LIMIT 1
Run Time: 0.000152
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` = 88767)
LIMIT 1
Run Time: 0.000186
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` = 1)
LIMIT 1
Run Time: 0.000143
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: oJ4l6y_8HgEAZtx8881FFbQchzOrwMrr, , 1575735831
Run Time: 0.000117
- 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 |