SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000980
| 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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1218
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_user`
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` = '292889')
LIMIT 1
Run Time: 0.001057
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Member.php at line 1238
- XF\Pub\Controller\Member->assertViewableUser() in src/XF/Pub/Controller/Member.php at line 671
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Run Time: 0.005054
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_forum | ALL | | | | | 125 | |
| SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum.node_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_1.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Search/Data/Post.php at line 259
- XF\Search\Data\Post->getTypePermissionConstraints() in src/XF/Search/Search.php at line 239
- XF\Search\Search->applyPermissionConstraints() in src/XF/Search/Search.php at line 212
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (855141, 855121, 827833, 822388, 703688, 652705, 460736, 424193, 330996, 289610, 289607, 289401))
Run Time: 0.001458
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 12 | Using where |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.node_id | 1 | |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_1.node_id | 1 | Using where |
| SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.first_post_id | 1 | |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`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_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (9102249, 9060188, 8958850, 8928194, 8914718, 8907941, 8897737, 8879747, 8879744, 8879739, 8879737, 8861973, 8861965, 8861963, 8853902, 8853899, 8791227, 8791096, 8399452, 8398525, 8369903, 8364927, 8335329, 8335326, 8326883, 8325759, 8323900, 8313975, 8309088, 8300392, 8299007, 8248501, 8066954, 8066953, 8037875, 8037871, 8033740, 8033738, 7819745, 7819736, 7784134, 7767006, 7756209, 7750984, 7750977, 7750972, 7737349, 7719798, 7684324, 7672347, 7665310, 7659551, 7655954, 7609159, 7596298, 7573199, 7566809, 7508712, 7487902, 7477737, 7443969, 7302672, 7139548, 6922396, 6729505, 6729212, 6418333, 6418329, 6418328, 6418326, 6409083, 6409082, 6409080, 6409079, 6384823, 6384818, 6384817, 6384519, 6372836, 6372833, 6372832, 6372826, 6214429, 6214426, 6214423, 6214413, 6171983, 6171972, 6171970, 6171966, 6101565, 6101563, 6101561, 6101559, 5956375, 5956369, 5956368, 5956362, 5953528, 5953526, 5953525, 5953524, 5870605, 5870603, 5870602, 5870600, 5828408, 5828406, 5828405, 5828404, 5776699, 5776698, 5776697, 5776696, 5732017, 5732015, 5732014, 5732013, 5718131, 5718130, 5718129, 5718127, 5715234, 5715232, 5715230, 5715229, 5674447, 5674446, 5674445, 5674443, 5660755, 5660754, 5660753, 5660752, 5597435, 5597434, 5597433, 5597432, 5575785, 5575783, 5575780, 5575778, 5565178, 5565176, 5565175, 5565174, 5552457, 5552456, 5552455, 5552454, 5540459, 5540458, 5540454, 5540453, 5531378, 5531377, 5531376, 5531375, 5527662, 5527660, 5527658, 5527656, 5512110, 5512108, 5512107, 5512104, 5426900, 5426897, 5426894, 5426893, 5362562, 5362558, 5362557, 5362556, 5361015, 5361013, 5361011, 5361010, 5332285, 5332283, 5332282, 5332281, 5332280, 5314597, 5314594, 5314591, 5314590, 5309524, 5309522, 5309520, 5309517, 5237950, 5237949, 5237948, 5237947, 5234369, 5234368, 5234367, 5234365, 5229622, 5229621, 5229618, 5229617, 5220390, 5220387, 5220386, 5220384, 5193098, 5193097, 5193096, 5193095, 5175633, 5175629, 5175628, 5175627, 5154035, 5154034, 5154031, 5154030, 5143304, 5143302, 5143300, 5143299, 5134823, 5134822, 5134820, 5134819, 5122956, 5122954, 5122953, 5122952, 5111483, 5111482, 5111481, 5078277, 5078276, 5078275, 5077307, 5077303, 5077301, 5069259, 5069258, 5069257, 5062652, 5062650, 5062649, 5024352, 5024349, 5024348, 5016800, 5016798, 5016796, 4994308, 4994305, 4994304, 4993478, 4993477, 4993473, 4985775, 4985774, 4985771, 4981493, 4981492, 4981491, 4980794, 4980793, 4980790, 4918370, 4918367, 4918365, 4910012, 4910006, 4910002, 4898154, 4898151, 4898148, 4889307, 4889306, 4889303, 4857363, 4857360, 4857358, 4792897, 4792896, 4792894, 4706853, 4706851, 4706850, 4672064, 4672062, 4672060, 4611728, 4611727, 4611724, 4285900, 4285896, 4285893, 4218293, 4142767, 4142764, 4142761, 4142760, 4099749, 4099747, 4099745, 4099739, 4091644, 4091642, 4091634, 4091631, 4015663, 4015656, 4015654, 4015652, 3927534, 3927533, 3927530, 3927529, 3826982, 3826981, 3826980, 3826979, 3773948, 3773947, 3773946, 3773945, 3725983, 3725982, 3725979, 3725978, 3691441, 3691440, 3691439, 3691437, 3683781, 3683780, 3683779, 3683778, 3675235, 3675233, 3675231, 3675230, 3651440, 3651437, 3651435, 3651433, 3634770, 3634765, 3634763, 3634761, 3628498, 3628490, 3628483, 3628476, 3621684, 3621683, 3621681, 3621676, 3611809, 3611807, 3611805, 3611802, 3592404, 3592400, 3592398, 3592387, 3581822, 3581820, 3581819, 3581812, 3576849, 3576807, 3567426, 3567419, 3567409, 3567399, 3564057, 3564051, 3564046, 3560425, 3555490, 3172535, 3169459, 3090995, 3089877, 3087415, 3087192, 3086927))
Run Time: 0.012341
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 388 | Using where |
| SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_post.thread_id | 1 | |
| SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread_Thread_1.node_id | 1 | Using where |
| SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_2.node_id | 1 | Using where |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_post.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.*
FROM `xf_profile_post`
LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`)
WHERE (`xf_profile_post`.`profile_post_id` IN (46375))
Run Time: 0.001640
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_ProfileUser_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 181
- XF\Search\Search->search() in src/XF/Pub/Controller/Member.php at line 679
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (855141, 855121, 827833, 822388, 703688, 652705, 460736, 424193, 330996, 289610, 289607, 289401))
Run Time: 0.001566
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 12 | Using where |
| SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.node_id | 1 | |
| SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_1.node_id | 1 | Using where |
| SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.first_post_id | 1 | |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`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_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` IN (9102249, 9060188, 8958850, 8928194, 8914718, 8907941, 8897737, 8879747, 8879744, 8879739, 8879737, 8861973, 8861965, 8861963, 8853902, 8853899, 8791227, 8791096, 8399452, 8398525, 8369903, 8364927, 8335329, 8335326, 8326883, 8325759, 8323900, 8313975, 8309088, 8300392, 8299007, 8248501, 8066954, 8066953, 8037875, 8037871, 8033740, 8033738, 7819745, 7819736, 7784134, 7767006, 7756209, 7750984, 7750977, 7750972, 7737349, 7719798, 7684324, 7672347, 7665310, 7659551, 7655954, 7609159, 7596298, 7573199, 7566809, 7508712, 7487902, 7477737, 7443969, 7302672, 7139548, 6922396, 6729505, 6729212, 6418333, 6418329, 6418328, 6418326, 6409083, 6409082, 6409080, 6409079, 6384823, 6384818, 6384817, 6384519, 6372836, 6372833, 6372832, 6372826, 6214429, 6214426, 6214423, 6214413, 6171983, 6171972, 6171970, 6171966, 6101565, 6101563, 6101561, 6101559, 5956375, 5956369, 5956368, 5956362, 5953528, 5953526, 5953525, 5953524, 5870605, 5870603, 5870602, 5870600, 5828408, 5828406, 5828405, 5828404, 5776699, 5776698, 5776697, 5776696, 5732017, 5732015, 5732014, 5732013, 5718131, 5718130, 5718129, 5718127, 5715234, 5715232, 5715230, 5715229, 5674447, 5674446, 5674445, 5674443, 5660755, 5660754, 5660753, 5660752, 5597435, 5597434, 5597433, 5597432, 5575785, 5575783, 5575780, 5575778, 5565178, 5565176, 5565175, 5565174, 5552457, 5552456, 5552455, 5552454, 5540459, 5540458, 5540454, 5540453, 5531378, 5531377, 5531376, 5531375, 5527662, 5527660, 5527658, 5527656, 5512110, 5512108, 5512107, 5512104, 5426900, 5426897, 5426894, 5426893, 5362562, 5362558, 5362557, 5362556, 5361015, 5361013, 5361011, 5361010, 5332285, 5332283, 5332282, 5332281, 5332280, 5314597, 5314594, 5314591, 5314590, 5309524, 5309522, 5309520, 5309517, 5237950, 5237949, 5237948, 5237947, 5234369, 5234368, 5234367, 5234365, 5229622, 5229621, 5229618, 5229617, 5220390, 5220387, 5220386, 5220384, 5193098, 5193097, 5193096, 5193095, 5175633, 5175629, 5175628, 5175627, 5154035, 5154034, 5154031, 5154030, 5143304, 5143302, 5143300, 5143299, 5134823, 5134822, 5134820, 5134819, 5122956, 5122954, 5122953, 5122952, 5111483, 5111482, 5111481, 5078277, 5078276, 5078275, 5077307, 5077303, 5077301, 5069259, 5069258, 5069257, 5062652, 5062650, 5062649, 5024352, 5024349, 5024348, 5016800, 5016798, 5016796, 4994308, 4994305, 4994304, 4993478, 4993477, 4993473, 4985775, 4985774, 4985771, 4981493, 4981492, 4981491, 4980794, 4980793, 4980790, 4918370, 4918367, 4918365, 4910012, 4910006, 4910002, 4898154, 4898151, 4898148, 4889307, 4889306, 4889303, 4857363, 4857360, 4857358, 4792897, 4792896, 4792894, 4706853, 4706851, 4706850, 4672064, 4672062, 4672060, 4611728, 4611727, 4611724, 4285900, 4285896, 4285893, 4218293, 4142767, 4142764, 4142761, 4142760, 4099749, 4099747, 4099745, 4099739, 4091644, 4091642, 4091634, 4091631, 4015663, 4015656, 4015654, 4015652, 3927534, 3927533, 3927530, 3927529, 3826982, 3826981, 3826980, 3826979, 3773948, 3773947, 3773946, 3773945, 3725983, 3725982, 3725979, 3725978, 3691441, 3691440, 3691439, 3691437, 3683781, 3683780, 3683779, 3683778, 3675235, 3675233, 3675231, 3675230, 3651440, 3651437, 3651435, 3651433, 3634770, 3634765, 3634763, 3634761, 3628498, 3628490, 3628483, 3628476, 3621684, 3621683, 3621681, 3621676, 3611809, 3611807, 3611805, 3611802, 3592404, 3592400, 3592398, 3592387, 3581822, 3581820, 3581819, 3581812, 3576849, 3576807, 3567426, 3567419, 3567409, 3567399, 3564057, 3564051, 3564046, 3560425, 3555490, 3172535, 3169459, 3090995, 3089877, 3087415, 3087192, 3086927))
Run Time: 0.008542
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | | 388 | Using where |
| SIMPLE | xf_thread_Thread_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_post.thread_id | 1 | |
| SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread_Thread_1.node_id | 1 | Using where |
| SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_2.node_id | 1 | Using where |
| SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_post.user_id | 1 | |
| SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.xf_node_Node_3.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.*
FROM `xf_profile_post`
LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`)
WHERE (`xf_profile_post`.`profile_post_id` IN (46375))
Run Time: 0.001318
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_ProfileUser_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2866
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Pub/Controller/Member.php at line 680
- XF\Pub\Controller\Member->actionRecentContent() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000962
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 29
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 84
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 44
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20