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 (839879, 836980, 836644, 836617, 835765, 835450, 834910, 834497, 831090, 830131, 829431, 827252, 827077, 826147, 822081, 820657, 820536, 820265, 820184, 819793, 819714, 819147, 818867, 818353, 818251, 818180, 817758, 817608, 817568, 816978, 816199, 814005, 812885, 811665, 811664, 811450, 811033, 810028, 810012, 809784, 808982, 808981, 808621, 808319, 808072, 806995, 805945, 805583, 805210, 804817, 804565, 804133, 803936, 803611, 803345, 802308, 802129, 802075, 799807, 799559, 799070, 798842, 798362, 798356, 798069, 797950, 797938, 797258, 796378, 795683, 795362, 794288, 793239, 792027, 791128, 790996, 790794, 790717, 790198, 790175, 789879, 789169, 788998, 787590, 785656, 785573, 784855, 784489, 783201, 782629, 781645, 780615, 779144, 778378, 776718, 774686, 774530, 773314, 772814, 772618, 772271, 771217, 771198, 770946, 770708, 769891, 769779, 768999, 768498, 768404, 768166, 768124, 768024, 767115, 766921, 766906, 766648, 766445, 766402, 765725, 765553, 765366, 765150, 765004, 764448, 763940, 763665, 763618, 763341, 763188, 762815, 762019, 761062, 760878, 760726, 760583, 759993, 759775, 758785, 758719, 757873, 755943, 755802, 755750, 754983, 754737, 753795, 753385, 753167, 752636, 751435, 751288, 750878, 750625, 749468, 749053, 747711, 747466, 747384, 746507, 746272, 745937, 745601, 744880, 743507, 743465, 743212, 742129, 741752, 741598, 741384, 741258, 740093, 738559, 738264, 737803, 736640, 736273, 735636, 735103, 734603, 734384, 734073, 733782, 733740, 733455, 733139, 732686, 731947, 727273, 726754, 724418, 723245, 723077, 722810, 722756, 722600, 722583, 720065, 718462, 718288, 718217, 718030, 716968, 716754, 715859, 715452, 715106, 714898, 714570, 714546, 714425, 714130, 712694, 712672, 712284, 711702, 711674, 710967, 709987, 709411, 709299, 709189, 709125, 709037, 708718, 708485, 707881, 707836, 707724, 706891, 705753, 704556, 704068, 703954, 703434, 703341, 702694, 702657, 702543, 702401, 702330, 702259, 701593, 698777, 698243, 697772, 697618, 697382, 697160, 696535, 694972, 694679, 693935, 693814, 693680, 693601, 693535, 693255, 692982, 692930, 690860, 690749, 689858, 688886, 688425, 687509, 686279, 686020, 685459, 683414, 683183, 683083, 682842, 682806, 680030, 679352, 678956, 678864, 678065, 676932, 676795, 676274, 675936, 675771, 675657, 675546, 675104, 674354, 674163, 673496, 673487, 671836, 670274, 670106, 670059, 669792, 669715, 667725, 667493, 667037, 667005, 666838, 666753, 666745, 666689, 665603, 665000, 664294, 663766, 663293, 661932, 661702, 661551, 661549, 661213, 661178, 660642, 660381, 660287, 660141, 659942, 659678, 658564, 657718, 657299, 657231, 656860, 656007, 655067, 654667, 652962, 652922, 652859, 652548, 652540, 651473, 650064, 649270, 649006, 648993, 648650, 648484, 648176, 647383, 647308, 647193, 646928, 646860, 646815, 646376, 645992, 645678, 645357, 642121, 642064, 641150, 640929, 640267, 639647, 639588, 638441, 637973, 637627, 637594, 637046, 636916, 636464, 636358, 636224, 636182, 636180, 636073, 635955, 635442, 635353, 635344, 635137, 635014, 634557, 634196, 633683, 633341, 633009, 630406, 629665, 629337, 629292, 629268, 628614, 628576, 628141, 627422, 626994, 626894, 625176, 624339, 623893, 623030, 622505, 621654, 621000, 620217, 620042, 619932, 619636, 619224, 619024, 618623, 618622, 618621, 618619, 618618, 617433, 615910, 615884, 615449, 614663, 614218, 613724, 613399, 612696, 612294, 611658, 610835, 610618, 610479, 610372, 609679, 609065, 607431, 607262, 606801, 606610, 606089, 603789, 598880, 598530, 597995, 597399, 593986, 592786, 585440, 579931, 579418, 579227, 570211, 570110, 569150, 567996, 567299, 565915, 565808, 563842, 563041, 561299, 561068, 560478, 560473, 560112, 552598, 548639, 548469, 548309, 546890, 544330, 544317, 542686, 541111, 538785, 538302, 534796, 533117, 531260, 530685, 529536, 529485, 529484, 529301, 529263, 528755, 528528, 528311, 528253, 528036, 527542, 527438, 526907, 526906, 526834, 525613, 525264, 525080, 524961, 523446, 523303, 522716, 522627, 521523, 520906, 520552, 519645, 519304, 519135, 458868, 518902, 516008, 515779, 514631, 512644, 512643, 512640, 511696, 511270, 510531, 510242, 510210, 510042, 509271, 508527, 508117, 507842, 507237, 506229, 501443, 500737, 497878, 497510, 496319, 495925, 495575, 495225, 494211, 493341, 492885, 491434, 489482, 486311, 486171, 485213, 485072, 483743, 482843, 482667, 482200, 481895, 480208, 477665, 477342, 476054, 475850, 475469, 471591, 465950, 465878, 465064, 462702, 462659, 462542, 461771, 459515, 459116, 456438, 455852, 455121, 453729, 452369))
Run Time: 0.021331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 567 | 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