SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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 (838991, 837757, 837456, 829195, 828116, 826717, 808841, 808224, 804854, 804176, 804091, 799852, 797775, 797513, 797446, 797282, 797153, 796766, 796374, 796342, 794744, 794619, 794166, 793357, 789508, 789254, 786137, 785427, 784069, 777996, 777877, 777688, 776348, 776251, 775884, 775878, 774895, 774629, 770055, 769752, 768708, 767491, 766041, 765926, 765275, 764261, 764018, 761371, 760400, 759157, 758763, 758043, 756487, 755786, 755449, 753798, 751766, 751093, 751065, 750566, 749495, 747707, 746342, 743539, 740900, 740420, 739211, 739113, 737788, 736708, 736016, 735413, 734519, 732690, 732531, 731153, 731104, 730950, 729751, 725945, 725036, 724944, 724821, 724740, 722086, 719400, 718565, 717943, 717078, 716984, 716538, 716182, 715262, 712423, 712413, 712222, 710619, 710272, 709631, 708976, 704133, 702625, 702075, 701092, 698617, 698056, 697901, 697885, 694926, 694305, 693636, 692601, 691152, 690464, 690073, 687679, 687337, 686932, 686218, 686125, 684622, 684575, 684456, 684151, 684048, 683975, 682507, 681370, 681199, 680971, 680837, 680714, 680323, 679857, 678441, 677439, 676068, 675966, 675892, 674349, 673008, 672068, 671472, 670805, 670384, 664314, 662077, 661488, 661397, 661130, 661016, 659989, 658775, 658399, 655418, 654978, 654898, 654267, 654050, 653794, 653385, 653348, 653132, 652947, 650871, 650075, 648409, 648278, 647352, 646693, 645523, 645165, 644563, 643844, 643600, 642596, 642321, 641496, 641096, 639652, 639352, 635812, 634920, 634573, 634094, 634008, 633564, 633484, 633114, 632487, 631674, 631671, 631666, 631367, 630670, 629545, 629534, 629424, 629132, 629012, 625909, 625605, 625373, 625251, 625235, 624847, 624422, 623850, 623768, 623590, 623460, 622759, 622560, 622358, 622160, 621578, 620969, 620748, 618884, 618625, 617711, 617532, 617328, 615851, 615794, 615772, 614168, 613008, 612981, 612970, 612612, 612571, 612218, 611805, 611567, 609007, 608946, 608803, 608448, 608342, 605999, 605727, 605581, 605379, 603872, 603523, 603176, 602741, 602729, 602576, 601913, 601237, 597129, 594626, 593370, 591641, 591416, 583175, 579920, 579241, 578470, 577265, 576444, 576077, 572596, 570832, 568185, 568112, 567946, 567890, 566592, 566050, 564308, 563878, 563620, 563612, 562845, 562643, 562231, 560806, 560482, 560253, 557022, 554557, 554538, 553172, 552406, 552173, 551906, 551519, 550938, 550915, 549375, 549295, 548380, 547822, 547562, 547306, 545871, 545653, 544798, 543623, 543146, 542667, 542408, 541998, 541161, 540242, 540172, 540163, 539222, 538989, 538260, 537662, 537263, 537037, 536948, 536346, 536092, 535729, 535307, 535079, 534911, 534617, 534573, 533540, 533508, 533361, 533209, 533085, 533043, 531812, 531736, 531680, 531092, 530870, 530765, 530555, 530260, 530213, 529399, 529024, 527639, 527549, 527458, 527355, 527270, 527078, 526726, 526710, 526555, 526454, 526128, 525227, 525224, 525146, 525137, 525081, 524869, 524754, 524129, 524038, 523635, 523567, 523447, 523465, 523431, 523331, 523030, 522855, 522764, 522308, 521929, 521928, 521575, 521202, 521048, 520540, 520116, 520044, 519852, 519746, 519663, 519200, 519199, 519086, 519050, 518921, 518891, 518266, 518204, 518080, 517436, 517123, 517021, 516921, 516373, 515573, 515432, 515319, 515259, 515061, 514929, 514861, 514623, 514487, 513931, 513498, 513334, 513333, 512969, 512715, 512712, 512707, 512562, 512527, 512290, 511942, 511693, 511519, 511498, 511238, 511219, 510960, 510621, 510363, 509513, 508901, 508900, 508809, 508385, 508383, 508322, 508033, 507909, 507665, 507502, 507447, 506711, 505938, 505696, 505321, 505259, 504988, 504782, 503983, 502305, 501811, 500695, 499890, 499719, 499562, 498831, 499160, 498193, 498032, 498031, 497924, 497661, 497659, 497281, 497275, 497120, 497119, 496502, 496115, 496103, 496089, 495894, 495802, 495398, 493772, 493743, 492231, 491716, 491702, 491604, 491483, 491341, 491299, 491042, 490741, 490617, 489610, 489031, 487481, 487118, 487003, 486886, 486872, 486868, 486824, 486676, 486522, 486325, 486282, 485829, 484809, 484654, 484361, 483408, 483171, 481995, 479888, 479840, 479621, 479234, 478959, 478775, 478702, 478419, 478339, 478309, 478269, 478196, 478144, 478136, 477949, 477357, 476920, 476914, 476511, 476426, 476177, 476153, 476051, 475839, 475365, 474354, 474108, 473307, 473182, 470944, 470192, 469887, 469271, 469261, 468826, 468522, 467498, 466844, 465164, 465070, 464986, 464956, 461014, 460898, 460459, 459409, 459319, 459287, 459279, 459264, 459249, 458387, 458326, 457869, 457414, 456802, 456462, 456430, 456394, 456293, 455946, 455721, 455519, 455513, 455512, 454996, 454986, 454979, 454572, 454420, 454418, 453440, 453225, 452819, 452326, 452164, 451928, 451894, 451411, 451037))
Run Time: 0.021172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 583 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sdn_xenforo.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 2870
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->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/Pub/Controller/Tag.php at line 138
- XF\Pub\Controller\Tag->actionTag() 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