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 (840034, 839675, 839230, 839229, 838791, 838675, 837430, 837194, 837174, 837173, 835573, 835317, 834672, 834148, 830696, 829902, 829419, 829125, 829031, 828891, 828718, 825610, 825600, 825221, 825012, 823576, 823245, 823162, 822226, 822225, 821395, 820069, 819558, 819461, 818817, 818370, 818351, 818308, 816752, 816732, 816325, 816321, 815057, 814838, 813820, 813417, 812721, 812215, 812038, 811664, 811451, 811360, 810877, 809708, 809313, 809251, 808996, 808974, 808586, 808224, 808073, 808063, 807453, 807287, 806997, 806915, 806670, 806517, 806107, 805901, 805368, 804892, 804241, 803799, 802884, 802875, 801794, 801540, 801489, 801477, 800054, 798928, 798868, 798137, 797938, 797904, 797826, 797513, 797282, 797028, 796754, 796478, 795917, 795112, 795067, 794983, 794218, 793869, 793648, 793477, 793243, 792754, 791775, 791401, 791014, 791003, 790441, 790335, 789431, 789367, 789179, 788795, 788447, 787720, 787516, 786611, 785573, 785367, 785181, 784306, 783637, 783026, 781665, 781350, 780945, 780692, 780253, 779765, 779667, 778392, 778391, 778062, 777469, 776942, 776734, 776634, 776241, 776230, 776208, 775772, 775764, 775750, 775588, 774871, 774085, 773218, 772839, 772296, 772015, 771080, 769734, 769578, 769083, 768708, 768498, 768185, 768041, 767101, 766825, 766744, 765886, 765584, 765583, 765480, 765373, 765275, 764840, 764670, 764598, 763206, 762458, 762059, 762007, 761873, 761660, 761413, 761068, 761067, 761065, 761063, 760776, 760742, 759993, 759777, 759664, 759638, 758504, 758235, 757924, 757313, 756788, 756295, 755686, 755449, 754994, 753881, 753418, 752014, 751677, 751670, 751584, 751537, 751385, 751069, 750704, 750471, 749750, 749644, 749495, 749425, 747771, 747294, 746366, 745718, 745129, 744781, 744344, 744340, 743963, 743539, 742001, 741534, 741236, 740219, 739656, 739403, 739222, 738651, 738632, 738449, 738380, 738286, 738264, 737814, 737560, 736575, 736467, 736179, 736153, 735917, 735875, 735216, 735194, 734562, 734186, 734166, 733638, 733549, 733474, 733231, 733092, 731870, 731754, 731689, 731133, 731056, 731006, 730550, 729554, 729510, 729396, 729099, 728499, 728493, 727107, 727059, 726509, 726475, 724906, 724821, 724703, 724577, 723018, 722539, 721946, 721559, 721277, 721089, 720266, 720134, 719249, 717336, 716275, 716221, 715967, 715954, 715453, 714890, 714607, 713765, 713747, 713665, 713631, 713586, 713167, 712786, 712475, 712461, 712222, 712103, 711850, 711553, 711549, 711401, 711270, 711084, 710948, 710090, 709987, 709641, 709102, 709037, 709029, 708987, 708380, 708145, 707948, 707896, 707552, 707345, 707314, 707260, 706975, 706875, 706737, 706602, 706369, 705764, 704975, 704959, 704940, 704741, 704639, 704380, 704260, 704075, 704021, 704020, 704019, 703881, 703705, 703573, 703491, 703358, 702956, 702928, 702861, 702674, 702625, 702423, 702318, 701646, 701592, 701227, 700977, 700800, 700504, 699730, 699720, 699532, 699413, 699270, 698259, 698061, 697524, 696993, 696746, 696321, 696257, 696136, 695903, 695262, 694933, 694468, 693572, 693407, 693362, 693157, 693078, 692903, 692895, 692627, 692616, 692601, 692121, 691950, 691748, 691519, 691253, 690710, 690691, 690124, 689658, 689574, 689543, 689507, 689486, 689475, 688871, 688579, 688457, 688394, 687484, 686754, 686399, 686395, 686260, 685291, 684983, 684936, 684707, 684554, 684387, 684258, 684059, 683902, 683802, 683486, 683417, 683306, 681641, 681375, 681348, 681314, 681094, 680935, 680472, 680282, 679963, 679939, 679847, 679682, 679474, 679404, 679208, 679034, 678912, 678791, 678537, 678528, 678432, 678134, 678108, 677883, 677798, 677690, 677488, 677023, 676975, 676962, 676819, 676755, 676745, 676307, 676247, 675771, 675007, 674196, 673784, 673478, 673273, 671728, 671624, 670805, 670203, 669760, 669705, 669703, 669634, 669067, 668978, 668819, 668639, 668277, 668148, 667905, 667875, 667840, 667671, 667667, 667565, 667325, 667322, 667276, 667258, 667215, 666999, 666986, 666469, 666323, 666005, 665492, 665475, 665466, 665108, 665000, 664642, 664443, 664374, 664104, 663769, 663753, 663665, 663229, 662417, 661847, 661820, 661442, 661057, 660991, 660784, 660489, 660457, 660114, 659952, 659822, 659773, 659246, 658874, 658823, 658775, 658550, 658301, 657915, 657794, 657231, 656882, 656859, 656799, 656599, 656474, 656436, 655930, 655646, 655453, 655094, 654900, 654898, 654144, 653768, 653765, 653232, 653166, 653120, 653077, 653044, 653031, 653012, 653002, 651863, 651784, 651096, 650944, 650809, 650384, 650076, 649390, 649266, 649107, 648288, 647611, 647343, 647271, 647258, 647005, 646944, 646746, 646744, 646263, 645986, 645003, 644854, 644811, 644568, 644497, 644005, 643844, 643770, 643467, 643431, 643257, 642886, 642686, 642557, 642554, 642322, 642280, 642193, 642096, 642018, 641989, 641946, 641903, 641645, 641600, 641595, 641457, 641006, 640971, 640649, 640476, 640149, 639340, 639158, 638984, 638453, 638128, 637837, 637825, 637756, 637379, 637321, 636977, 636973, 636547, 636538, 636527, 636526, 636353, 636138, 635911, 635594, 635549, 635491, 635360, 635339, 635336, 634639, 634282, 634055, 633778, 633085, 632842, 632628, 632552, 632487, 632403, 632287, 632259, 632190, 631849, 631716, 631344, 630978, 630798, 630724, 630670, 630633, 630549, 629949, 629935, 629630, 629493, 629486, 629474, 629460, 629450, 629245, 629150, 629116, 629012, 628764, 628753, 628530, 628356, 628311, 628086, 628012, 627983, 618789, 627283, 627006, 626867, 626706, 626651, 626633, 626350, 626333, 626297, 626296, 625906, 625857, 625713, 625530, 625447, 625443, 625354, 625328, 625301, 625283, 625252, 625244, 625155, 625118, 625102, 625051, 625027, 623992, 623768, 623469, 623263, 623202, 623174, 622822, 622810, 622467, 622358, 621830, 621442, 621439, 621403, 621356, 621329, 621252, 621142, 621078, 620983, 620877, 620642, 620276, 620230, 620090, 620071, 620051, 619103, 618950, 618884, 618627, 618060, 617710, 617591, 617460, 617454, 617381, 617309, 617049, 616896, 616704, 616641, 616225, 615910, 615851, 615794, 615182, 614971, 614774, 614666, 614287, 614191, 613808, 613685, 613639, 613541, 613212, 613008, 612977, 612970, 612962, 612863, 612592, 612533, 612484, 612279, 612077, 611829, 611456, 611370, 611280, 610968, 610808, 610727, 610305, 609806, 609757, 608209, 607597, 607575, 607230, 606859, 606671, 606627, 606606, 606259, 606230, 606089, 605899, 605258, 604070, 603872, 603709, 603691, 602741, 602522, 601994, 601977, 601356, 600611, 598855, 597991, 596636, 595807, 595326, 594044, 593938, 591953, 591660, 591641, 590710, 590708, 587168, 586893, 586862, 586861, 586857, 586832, 586138, 586103, 585754, 584959, 584447, 582672, 582268, 581842, 581809, 581350, 579358, 578441, 577214, 575987, 575345, 574805, 573453, 572580, 572398, 570086, 569418, 568639, 568123, 567341, 567281, 566906, 565990, 565966, 565710, 565568, 565520, 565074, 564507, 564361, 564331, 564307, 563702, 563649, 563636, 563558, 563450, 562823, 562456, 561353, 560843, 560470, 560198, 559550, 559358, 557540, 557319, 556448, 554550, 553822, 553561, 552569, 552416, 552306, 552173, 551938, 551936, 551519, 550970, 550959, 550875, 550853, 550519, 550247, 550244, 550177, 549837, 549453, 549423, 548893, 548892, 548876, 548111, 547674, 547396, 547344, 547195, 547086, 546706, 546391, 546313, 546123, 546026, 545809, 545525, 545444, 545266, 544850, 544792, 544083, 544004, 543900, 543759, 543710, 543694, 543376, 543335, 543190, 543079, 542906, 542790, 542774, 542651, 542222, 541950, 541733, 541710, 541702, 541685, 541677, 541641, 541536, 541473, 541107, 540885, 540862, 540210, 540198, 539775, 539770, 539768, 539681, 539675, 538434, 538302, 537729, 537656, 536956, 536809, 536471, 536454, 536383, 536241, 536150, 536051, 535742, 534832, 534794, 534617, 534582, 534293, 534193, 534047, 533819, 533689, 533642, 533540, 533532, 533509, 533507, 533217, 533112, 533043, 532528, 532509, 532391, 532263, 532166, 531899, 531717, 531526, 531409, 530890, 530661, 530442, 529930, 529906, 529849, 529605, 529418, 529303, 529263, 528755, 528714, 528710, 528705, 530178, 528640, 528586, 528559, 528394, 528382, 527988, 527924, 527850, 527791, 527448, 527254, 527251, 527137, 527136, 527056, 526980, 526932, 526819, 526559, 526514, 526495, 526480, 526457, 526438, 526421, 526068, 526016, 525482, 525321, 525240, 525227, 524963, 524931, 524810, 524785, 524767, 524706, 524676, 524672, 524623, 524504, 524498, 524376, 524152, 524113, 524048, 524041, 524025, 524021, 523827, 522963, 523190, 523009, 522997, 522929, 522821, 522768, 522645, 522565, 522537, 522526, 522375, 522331, 522308, 522244, 522193, 522127, 521833, 521824, 521791, 521701, 521679, 521656, 521578, 521576, 521541, 521451, 521440, 521317, 521292, 521273, 521260, 521227, 521205, 521116, 520576, 520517, 520515, 520509, 520507, 520476, 520287, 520177, 520171, 520161, 520132, 520019, 519998, 519992, 519966, 519669, 519521, 519268, 519257, 519170, 519068, 519051, 519008, 518872, 518778, 518722, 518721, 518508, 518504, 503732, 518296, 518270, 518167, 518125, 517914, 517906, 517863, 517777, 517637, 517552, 517499, 517496, 517478, 517363, 517194, 517167, 517094, 517050, 499222, 516815, 516771, 516530, 516482, 516239, 516229, 516104, 516094, 515707, 515415, 515412, 515320, 515065, 514692, 514641, 514639, 514636, 514497, 514422, 514197, 514196, 514056, 514042, 514020, 513846, 513539, 513286, 513217, 512823, 512725, 512718, 512717, 512709, 512615, 512547, 512285, 512206, 512044, 511787, 511282, 511034, 510999, 510991, 510718, 510592, 510414, 510348, 510331, 510320, 510177, 510120, 510013, 510011, 509996, 509737, 509517, 509409, 509044, 509015, 508934, 508659, 508649, 508385, 508292, 508107, 507773, 507738, 507622, 507608, 507117, 507114, 506849, 506663, 506351, 506064, 506057, 505943, 505909, 505905, 504862, 504760, 504494, 504252, 504231, 503917, 503911, 503714, 503485, 503457, 503419, 503371, 503295, 502808, 502798, 502353, 502318, 502309, 501852, 501662, 501440, 501237, 501191, 501155, 501136, 501070, 500541, 500485, 500377, 499980, 499896, 499820, 499636, 499448, 498916, 498264, 497603, 496994, 496621, 496341, 495503, 495385, 495374, 494920, 494889, 494128, 493796, 493733, 493331, 493209, 493175, 493166, 493143, 493129, 492883, 492388, 492196, 492151, 491318, 491083, 489674, 489662, 489560, 489430, 489231, 488426, 487819, 487618, 487468, 486884, 486824, 486733, 486610, 486524, 486270, 485961, 485365, 484825, 484621, 484381, 484206, 484092, 484054, 482989, 482605, 482287, 482169, 482164, 481995, 481810, 481660, 481400, 481201, 481085, 481022, 480812, 480489, 480485, 479899, 479861, 479838, 479762, 479621, 479508, 479477, 479353, 479039, 478630, 478399, 477942, 477890, 477611, 477381, 477088, 477030, 476929, 476787, 476326, 476114, 476070, 476063, 476054, 475879, 475528, 475519, 475492, 475270, 474771, 474710, 474479, 474361, 474194, 474108, 473907, 473224, 471930, 471763, 471546, 471332, 471223, 470851, 470745, 470511, 470485, 470374, 470316, 470241, 470096, 469988, 469912, 469906, 469812, 469503, 469283, 469155, 468772, 468398, 468233, 468221, 467565, 467412, 466523, 466128, 466040, 465489, 465307, 465172, 464969, 464956, 464949, 464937, 463967, 463774, 463037, 462693, 462094, 462082, 461924, 461896, 460934, 460929, 460839, 460790, 460285, 459419, 459416, 459139, 458727, 458469, 458387, 458179, 458072, 458015, 457542, 457467, 457421, 457196, 457055, 457053, 457023, 456961, 456951, 456623, 456577, 456567, 456522, 456481, 456368, 456349, 456174, 456169, 455987, 455944, 455866, 455748, 455682, 455602, 455535, 455495, 455172, 455121, 455032, 455020, 454997, 454793, 454766, 454728, 454705, 454692, 454690, 454647, 454631, 454620, 454596, 454132, 454124, 454024, 453785, 453491, 453473, 453402, 453324, 453207, 453169, 453155, 452998, 452781, 452656, 452427, 452414, 452026, 451863, 451636, 451581, 451224, 451154, 451089, 385972))
Run Time: 0.038063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1467 | |
PRIMARY | xf_thread | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.node_id | 1 | |
PRIMARY | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
PRIMARY | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.user_id | 1 | |
PRIMARY | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | sdn_xenforo.xf_thread.first_post_id | 1 | |
PRIMARY | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sdn_xenforo.xf_node_Node_2.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 1467 | |
DERIVED | | | | | | | | No tables used |
- 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