SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
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`)
WHERE (`xf_forum`.`node_id` IN (560, 55, 443, 551, 522, 524, 552, 553, 559, 317, 349, 558, 538, 526, 531, 544, 548, 547, 355, 360, 361, 362, 364, 395, 549, 350, 403, 351, 402, 352, 404, 353, 405, 376, 388, 386, 387, 399, 401, 442, 455, 456, 454, 468, 517, 515, 518, 519, 521, 523, 554, 555, 557, 359, 363, 356, 319, 382, 13, 469, 238, 239, 22, 34, 206, 215, 208, 210, 213, 214, 278, 207, 314, 313, 330, 240, 209, 211, 212, 315, 205, 340, 14, 258, 334, 223, 241, 242, 257, 228, 21, 225, 17, 43, 175, 78, 247, 71, 226, 97, 72, 74, 84, 73, 76, 77, 75, 98, 227, 164, 99, 106, 168, 107, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 125, 126, 123, 188, 165, 166, 167, 101, 174, 104, 105, 169, 100, 85, 171, 170, 86, 87, 176, 185, 186, 187, 177, 88, 172, 179, 180, 178, 173, 181, 182, 248, 20, 19, 44, 183, 184, 216, 217, 218, 328, 30, 200, 23, 50, 159, 336, 309, 27, 68, 306, 57, 81, 298, 301, 302, 299, 300, 66, 303, 297, 79, 307, 82, 89, 93, 128, 312, 250, 65, 58, 83, 59, 60, 61, 62, 63, 64, 108, 94, 520, 463, 464, 109, 152, 154, 129, 156, 157, 131, 132, 139, 143, 147, 148, 150, 155, 151, 195, 196, 197, 331, 332, 338, 127, 341, 344, 345, 346, 347, 348, 458, 459, 460, 461, 471, 475, 476, 477, 478, 472, 479, 480, 481, 482, 483, 484, 473, 485, 486, 487, 488, 489, 490, 474, 492, 493, 494, 230, 231, 232, 233, 234, 235, 236, 237, 198, 435, 189, 465, 470, 499, 512, 406, 418, 427, 432, 433, 412, 413, 424, 419, 421, 422, 423, 416, 438, 440, 441, 415, 436, 437, 417, 425, 192, 244, 245, 191, 219, 220, 221, 194, 190, 193, 202, 203, 201, 243, 305, 310, 260, 329, 366, 367, 371, 372, 396, 397, 369, 373, 370, 374, 368, 377, 383, 18, 280, 264, 326, 324, 325, 339, 390, 262, 265, 266, 273, 199, 496, 510, 509, 274, 308, 161, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 261, 284, 285, 282, 316, 29, 222, 52, 53, 162, 54, 158, 500, 502, 503, 504, 501, 505, 511, 3, 5, 6, 15, 11, 506, 7, 8, 9, 10, 16, 507, 24, 462))
Run Time: 0.013625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 397 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_thread_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/addons/Andy/Banner/XF/Pub/Controller/Forum.php at line 16
- Andy\Banner\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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20