SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_user_LastPoster_4`.*
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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_forum`.`last_post_user_id`)
WHERE (`xf_forum`.`node_id` IN (78, 91, 79, 90, 98, 141, 148, 155, 150, 247, 156, 172, 23, 26, 171, 184, 183, 170, 6, 205, 161, 4, 5, 7, 8, 25, 160, 159, 28, 173, 175, 176, 174, 177, 178, 179, 27, 31, 94, 206, 30, 180, 182, 2, 93, 29, 185, 186, 187, 203, 168, 95, 204, 207, 10, 55, 54, 53, 224, 225, 226, 227, 11, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 19, 16, 48, 240, 241, 242, 56, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 76, 75, 74, 73, 72, 71, 58, 41, 18, 87, 12, 35, 36, 37, 38, 39, 40, 243, 244, 42, 238, 239, 44, 46, 45, 47, 88, 20, 57, 136, 228, 229, 230, 231, 232, 233, 234, 49, 235, 236, 237, 21, 33, 32, 22, 147, 50, 52, 15, 208, 162, 245, 163, 164, 165, 166, 209, 210, 211, 212, 213, 13, 149, 246, 129, 97, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 17, 14, 89, 102, 115, 114, 111, 131, 100, 116, 117, 118, 120, 121, 122, 123, 126, 127, 134, 135, 103, 104, 105, 106, 107, 108, 109, 110, 112, 113, 96, 133, 137, 138, 151, 143, 144))
Run Time: 0.006133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 208 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum.last_thread_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum.last_post_user_id | 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/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/XF/Pub/Controller/Forum.php at line 54
- XF\Pub\Controller\Forum->actionList() 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 26