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 (839856, 838181, 837956, 834746, 834326, 834038, 832586, 832002, 830969, 830796, 830241, 830209, 829049, 828694, 827825, 827662, 825533, 824635, 823840, 822688, 822580, 822450, 822356, 821780, 821431, 821339, 820825, 820817, 820629, 819859, 819777, 819629, 818929, 818683, 818356, 817889, 817409, 817117, 817064, 816169, 815872, 815769, 815083, 813907, 813440, 813223, 812867, 812852, 812226, 811625, 811566, 811014, 810545, 810485, 809756, 809022, 808851, 808401, 807643, 807392, 806473, 806279, 805931, 805347, 805210, 804380, 804313, 803983, 802978, 801374, 801354, 801251, 800865, 800219, 800174, 798927, 798842, 798254, 798245, 798241, 798016, 796584, 795588, 795162, 795001, 794071, 793878, 793732, 793008, 791599, 791483, 790568, 790351, 790007, 789558, 789498, 789306, 788796, 788486, 788209, 787778, 786800, 785727, 784890, 784864, 784744, 783823, 783738, 782982, 782826, 782333, 782249, 781645, 781135, 781021, 780010, 779166, 777704, 776401, 775690, 774500, 774089, 773565, 772373, 771222, 770816, 769779, 768884, 768353, 767325, 767080, 766837, 765740, 765553, 765134, 765006, 764850, 764301, 764135, 764119, 763943, 763368, 763129, 761279, 761134, 760995, 760988, 760901, 759092, 758533, 758195, 757889, 757690, 757600, 757438, 757002, 756995, 755633, 755330, 754958, 754773, 754272, 753937, 753555, 753487, 752814, 752301, 752094, 751787, 750907, 750505, 750494, 749966, 749495, 749113, 748858, 748203, 748179, 747771, 747751, 745857, 744209, 743585, 743539, 743476, 742417, 740955, 740146, 738887, 738480, 738389, 738264, 738172, 737939, 737731, 737671, 737198, 736477, 736475, 735590, 735531, 735257, 735023, 734121, 733669, 733225, 733137, 732818, 732365, 732155, 731679, 731570, 731376, 730858, 730511, 730374, 730169, 729676, 729667, 728827, 728199, 727816, 727627, 726439, 724603, 724278, 723478, 723155, 723135, 722517, 721954, 720275, 720153, 719889, 719695, 719682, 719643, 719537, 719406, 719249, 719183, 718714, 718259, 717766, 717682, 717229, 717014, 716943, 716918, 716720, 716319, 716235, 715190, 714266, 713795, 713284, 712583, 711885, 711690, 711633, 711501, 711443, 711270, 711227, 710295, 708438, 708405, 707836, 707834, 707735, 707132, 707110, 707080, 707014, 706230, 706070, 705585, 704960, 704959, 704789, 704788, 704639, 704524, 704031, 704030, 703996, 703816, 703775, 703406, 703387, 702672, 702670, 702305, 702171, 701013, 700974, 700415, 700150, 699195, 698383, 697925, 697618, 697382, 697194, 697043, 696976, 696244, 695300, 695203, 694818, 694248, 694213, 694094, 693861, 693553, 693334, 693284, 692952, 692782, 692550, 691815, 690041, 689471, 689349, 688904, 688679, 688204, 687698, 687548, 686556, 686200, 685347, 685090, 684878, 684437, 683625, 682476, 682447, 682064, 681940, 681918, 681778, 681114, 681101, 680282, 679973, 679720, 679143, 678323, 677835, 677574, 677446, 677350, 677058, 676885, 676270, 674885, 674777, 674344, 674333, 673592, 673487, 672575, 671923, 671523, 671475, 671431, 671353, 671110, 670867, 670743, 670316, 670167, 668810, 668309, 668223, 668055, 667930, 667880, 667842, 667833, 667709, 667652, 666936, 666797, 666352, 665992, 665813, 665695, 665276, 664564, 663940, 663562, 663535, 663244, 663171, 663166, 662957, 662246, 662136, 661932, 661906, 661643, 661572, 660627, 660276, 660231, 659942, 659647, 659267, 658697, 658143, 658072, 657863, 656879, 656028, 655258, 655067, 654873, 654858, 654679, 654467, 654187, 653881, 653449, 653121, 653120, 652918, 652609, 652496, 652438, 651976, 651362, 651244, 651182, 651141, 648758, 648691, 647102, 647057, 646594, 646442, 646417, 646139, 645241, 644664, 644220, 643493, 643316, 642510, 642233, 641311, 641175, 641064, 640929, 640109, 639417, 639397, 638889, 638258, 637717, 636477, 636213, 636180, 635455, 635091, 634776, 634607, 634135, 634072, 633995, 633314, 631979, 631866, 631622, 631323, 630448, 629504, 629489, 628827, 628785, 628475, 628364, 628345, 628141, 626937, 626894, 626801, 626287, 626192, 625938, 625000, 624057, 623697, 622622, 622235, 622229, 621943, 621920, 621747, 621679, 621493, 621455, 621423, 621341, 620887, 620607, 620282, 619122, 619115, 618673, 618623, 618621, 618620, 618619, 618618, 618189, 618128, 618016, 617782, 617536, 617392, 617301, 617012, 617007, 616664, 616412, 615696, 615317, 615133, 614950, 614431, 613892, 612711, 612495, 611756, 611459, 611176, 610525, 610494, 610007, 609751, 609727, 609702, 609531, 608209, 607670, 607503, 606867, 606698, 606587, 604997, 604830, 604599, 603342, 603193, 601695, 600635, 600424, 599780, 599779, 598035, 597399, 597118, 595879, 595633, 594930, 585440, 582234, 581348, 581113, 576328, 576146, 574924, 572408, 572401, 571290, 569857, 568934, 568205, 567937, 566342, 563484, 562925, 562890, 562844, 561934, 561573, 561083, 558355, 553553, 552848, 552584, 551527, 551083, 549613, 549504, 548905, 548469, 547145, 546705, 545228, 545005, 544919, 544790, 544617, 544536, 544061, 543594, 543589, 541993, 541676, 541521, 541115, 540880, 539508, 539231, 537484, 537343, 537079, 536976, 536426, 534722, 534457, 533935, 533376, 533209, 532724, 532333, 531875, 531026, 530151, 529900, 529818, 529269, 528761, 528554, 528369, 528350, 528346, 528342, 528312, 528300, 528279, 528239, 528117, 528019, 527869, 527819, 527795, 527747, 527700, 527433, 527417, 527358, 527302, 526553, 526552, 526548, 526025, 525620, 525570, 525490, 525469, 525264, 525218, 524972, 524960, 524790, 524321, 524152, 523866, 523319, 521512, 521387, 519552, 518932, 518833, 518624, 518144, 516509, 515211, 514100, 514060, 513928, 513535, 513245, 512469, 512141, 512023, 511571, 510711, 510560, 510501, 509413, 508797, 508643, 505022, 504828, 503789, 503548, 503449, 502892, 501882, 501664, 501503, 499893, 497551, 496678, 496458, 495848, 495686, 495637, 495565, 495158, 495115, 495106, 493931, 493346, 493122, 492937, 492936, 492885, 492229, 491549, 489608, 488738, 487491, 485075, 485072, 483743, 483366, 483270, 483014, 482667, 481303, 481228, 480959, 479889, 478487, 477911, 477342, 477133, 473967, 472852, 472277, 471332, 469947, 468733, 467721, 467587, 467377, 466755, 465340, 465010, 464704, 463603, 460571, 458794, 457797, 457101, 454164, 295450, 191120))
Run Time: 0.023985
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 764 | 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