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 (837667, 837271, 837213, 836866, 836554, 835936, 835477, 834746, 834236, 833355, 833207, 833002, 832963, 832586, 832288, 832197, 832080, 832002, 831718, 831204, 830819, 830744, 830586, 830236, 829938, 828835, 828631, 828223, 828007, 827825, 827589, 827022, 826279, 825760, 825744, 825031, 824863, 824794, 824238, 824189, 823687, 822758, 822348, 821714, 821481, 821437, 821431, 821339, 821019, 820629, 820433, 820353, 820334, 820268, 819963, 819859, 819697, 819338, 819211, 818879, 818384, 818371, 818356, 818291, 818207, 818061, 818046, 818043, 817889, 817731, 817522, 817466, 817064, 816750, 816432, 816203, 816010, 815769, 815360, 814552, 814471, 813852, 813850, 813615, 812867, 812852, 812387, 811091, 811067, 810854, 810631, 810233, 810156, 810150, 810114, 809942, 809835, 809730, 809252, 808406, 808380, 808335, 808269, 808090, 807754, 807748, 807720, 807692, 806969, 806590, 806514, 806445, 806279, 806203, 805458, 804566, 804380, 803998, 803900, 803897, 803853, 803146, 803038, 802519, 802461, 802424, 802257, 801845, 800174, 800138, 800064, 799577, 798969, 798927, 798521, 798241, 798150, 798016, 797367, 797195, 795726, 795588, 795162, 795159, 794720, 794426, 793726, 793490, 792985, 792515, 790560, 790546, 790531, 788029, 787713, 787691, 787539, 786800, 786188, 785727, 785242, 785050, 783823, 783260, 782982, 782826, 782494, 782183, 782177, 782152, 782013, 782012, 781498, 781339, 780724, 780615, 780252, 780233, 779759, 779549, 777135, 777071, 776635, 775099, 774990, 774865, 774332, 774089, 772825, 772504, 772373, 772282, 771222, 770253, 768720, 768258, 767877, 767615, 767380, 767314, 766875, 766610, 766106, 765553, 765524, 765142, 765134, 765028, 764850, 764523, 764342, 764301, 764273, 764129, 762628, 762400, 761551, 761279, 760974, 760957, 760694, 760241, 760190, 759876, 759640, 759339, 759246, 759092, 759046, 758808, 758028, 757600, 757595, 757447, 757127, 756906, 756637, 756460, 756432, 755283, 755200, 754735, 753937, 753911, 753751, 753527, 753190, 752914, 752759, 752487, 752477, 752367, 752302, 752096, 752094, 752012, 751535, 751350, 751288, 750914, 750494, 750412, 749730, 749495, 749383, 749304, 749224, 749156, 748403, 747779, 747771, 747706, 747688, 747472, 747239, 746516, 745705, 745700, 745634, 744516, 744493, 744209, 744123, 743585, 743539, 742675, 742656, 742454, 742416, 742350, 742313, 742044, 741737, 741563, 741506, 741347, 741162, 741022, 740841, 740346, 739678, 739665, 739599, 739565, 739400, 739388, 739187, 739091, 738887, 738523, 738486, 738389, 737680, 737587, 737549, 736952, 736741, 736228, 736093, 735257, 734565, 734479, 734364, 734145, 734005, 733988, 733768, 733669, 733626, 733600, 733454, 733349, 733137, 732515, 732477, 732450, 732095, 731679, 731570, 731550, 731195, 730927, 730858, 730794, 730755, 730473, 730295, 730119, 729990, 729576, 729513, 729460, 729154, 729147, 728827, 728711, 728660, 727627, 727237, 726621, 726470, 726439, 725536, 724825, 724406, 724252, 723347, 723342, 722686, 722517, 722306, 721668, 721560, 721345, 721150, 721083, 720046, 719629, 719557, 719435, 719421, 719406, 719249, 718951, 718358, 718259, 718234, 718095, 718088, 717573, 717459, 717379, 716919, 716879, 716673, 716235, 715775, 715639, 715395, 715236, 714479, 714405, 714085, 714029, 713611, 713577, 713086, 712875, 712510, 712408, 712112, 711982, 711885, 711507, 711443, 711014, 710559, 710392, 710295, 709725, 709601, 709317, 708748, 708406, 708326, 707767, 707694, 707512, 707436, 707365, 706392, 706230, 705725, 705585, 705127, 704960, 704959, 704639, 704183, 704031, 703896, 703802, 703406, 703363, 702876, 702763, 702683, 702672, 702668, 702295, 701752, 701237, 700504, 700168, 699227, 699149, 698913, 698517, 698416, 698328, 698323, 698289, 698239, 697882, 697618, 697336, 697215, 697064, 696976, 696313, 694972, 694202, 694094, 693747, 693710, 693284, 693075, 693072, 692930, 692550, 692154, 692150, 691795, 691546, 690489, 690050, 689914, 689856, 689471, 688936, 688780, 688679, 688575, 688513, 688468, 687970, 687909, 687724, 687698, 687548, 687378, 687076, 687059, 687041, 687028, 686503, 685842, 685656, 685139, 685127, 685122, 685117, 684969, 684459, 683400, 682620, 682262, 681877, 681778, 681517, 681483, 680192, 679720, 679621, 679084, 678439, 678323, 678213, 677859, 677766, 677574, 677241, 677157, 677058, 676171, 676036, 675666, 675638, 675553, 675524, 674885, 674882, 674777, 674558, 674502, 674501, 674438, 674344, 674286, 674026, 673836, 673753, 673553, 673486, 672841, 672836, 672786, 672752, 672735, 672575, 672408, 672340, 672245, 672067, 671529, 671523, 671404, 671351, 671309, 671146, 671082, 671036, 670328, 670321, 670210, 670179, 670149, 669952, 669769, 669171, 669041, 668691, 668685, 667848, 667671, 667337, 667237, 667226, 667094, 666982, 666664, 666495, 666115, 665992, 665930, 665785, 665566, 665463, 665399, 665344, 665093, 665063, 664770, 664626, 664240, 664151, 663692, 663562, 663530, 662530, 662424, 662246, 662136, 661967, 661772, 661737, 661643, 661578, 661572, 661556, 661525, 661175, 660996, 660817, 660627, 660287, 660276, 660271, 659942, 659938, 659886, 659835, 659570, 659569, 659508, 659418, 659267, 659176, 659119, 659043, 658835, 658638, 658356, 658296, 658154, 657983, 657863, 657718, 657683, 657318, 656986, 656840, 656793, 656160, 655945, 655850, 655685, 655601, 655500, 655472, 655211, 654852, 654800, 654749, 654679, 654241, 654187, 653449, 653156, 653129, 653121, 653120, 652994, 652971, 652892, 652067, 651939, 651427, 651362, 651141, 649830, 649823, 649491, 648894, 648334, 648260, 647848, 647547, 647057, 646685, 646577, 646469, 646442, 646410, 646163, 646139, 646058, 646003, 645748, 644884, 644818, 644501, 644402, 643493, 643450, 642908, 642337, 641175, 641064, 640629, 640282, 640276, 640242, 639835, 639324, 639322, 638773, 638257, 638131, 638074, 637759, 637548, 636917, 636871, 636658, 636469, 636341, 636309, 635919, 635716, 635031, 634718, 634714, 634607, 634503, 634373, 634352, 634158, 634071, 633022, 632896, 632522, 632149, 631979, 631866, 631687, 631619, 631467, 630508, 630355, 630279, 629588, 629504, 629416, 628933, 628913, 628750, 628475, 627678, 627262, 626937, 626870, 626801, 626287, 626193, 626192, 626144, 625790, 625685, 624945, 624832, 624797, 624533, 624524, 624057, 623964, 623663, 623306, 623148, 623091, 621813, 621779, 621734, 621679, 621455, 621423, 621359, 621350, 620895, 620887, 620856, 620596, 620531, 620288, 620282, 620163, 619976, 619864, 619374, 619169, 619107, 618743, 618623, 618622, 618621, 618620, 618619, 618618, 618417, 618243, 617660, 617536, 617450, 617301, 617030, 617007, 616845, 616751, 616349, 616097, 615696, 615317, 615240, 615132, 615116, 615049, 614620, 614431, 614095, 613951, 613897, 613075, 612197, 612159, 611990, 611622, 611274, 611126, 610975, 610570, 610494, 610419, 610130, 609951, 609469, 609412, 609075, 609064, 608788, 608468, 608328, 608094, 607503, 607208, 606914, 606903, 606587, 606113, 605416, 605231, 604997, 604599, 603193, 601962, 601751, 598040, 597924, 597399, 597073, 596499, 595878, 595855, 595289, 595266, 595040, 595033, 594747, 594701, 594200, 593341, 593113, 591948, 591548, 591433, 591406, 591282, 590279, 587542, 587172, 585784, 585713, 583521, 582152, 579382, 579244, 579227, 577326, 577195, 577174, 576559, 576421, 576113, 575780, 573557, 573477, 572848, 572408, 572401, 569647, 568934, 568145, 567937, 567888, 567352, 566906, 566249, 565650, 565631, 563999, 563936, 563779, 563647, 562844, 562708, 562654, 561934, 561336, 561335, 561233, 560982, 560539, 560315, 559284, 558667, 558623, 558516, 557381, 557317, 554316, 554303, 554253, 550002, 549634, 549633, 549613, 549279, 549192, 549083, 548956, 548672, 547543, 547145, 547123, 546705, 546395, 546099, 544790, 544617, 544477, 544214, 543775, 543594, 543540, 543526, 542527, 542423, 542260, 541521, 541115, 540882, 540880, 539183, 538405, 538261, 538223, 537922, 537638, 537484, 536974, 536926, 536380, 536118, 536036, 535975, 535915, 535500, 535482, 535322, 535001, 534818, 534722, 534608, 533970, 533685, 533465, 533376, 533011, 532764, 532725, 532682, 532461, 531924, 531840, 531121, 530956, 529818, 529566, 529419, 529416, 528919, 528800, 528613, 528555, 528350, 528346, 528342, 528255, 528239, 528067, 528019, 527869, 527843, 527819, 527795, 527700, 527633, 527576, 527556, 527483, 527433, 527349, 527302, 527283, 527070, 526986, 526771, 526694, 526400, 526300, 526136, 526119, 525907, 525696, 525523, 525469, 525218, 525190, 525117, 525100, 524960, 524941, 524883, 524831, 524727, 524719, 524674, 524673, 524458, 524064, 522738, 522523, 522440, 522276, 521545, 521485, 521387, 521056, 520931, 520316, 520228, 518638, 518283, 516691, 515786, 515715, 515556, 515379, 515155, 515013, 514518, 514517, 514046, 513947, 513876, 513535, 512963, 512675, 512262, 511864, 511852, 511595, 511494, 511285, 511018, 510967, 510919, 510827, 510711, 510584, 510341, 510294, 510143, 508961, 508949, 508812, 508090, 507661, 505622, 505113, 504260, 503748, 503721, 503597, 502892, 502834, 501679, 501664, 501624, 501520, 501503, 500833, 500515, 500246, 500057, 499579, 498751, 498298, 498251, 497628, 497594, 497551, 497398, 496911, 496678, 496238, 496098, 495848, 495758, 495686, 495643, 495637, 495631, 495619, 495554, 495106, 494984, 494722, 493995, 493342, 492885, 492229, 491907, 491549, 491176, 490968, 490832, 489608, 489160, 487239, 486975, 486752, 486670, 485897, 483743, 483509, 483290, 482868, 482792, 482260, 481630, 481434, 481303, 481245, 480857, 480079, 479804, 478781, 478632, 478288, 477911, 477585, 477342, 476908, 476601, 476159, 475673, 475410, 474873, 474534, 474397, 473967, 473509, 473417, 473235, 472910, 472852, 472631, 472304, 472277, 471679, 471097, 471059, 471012, 470271, 470236, 469295, 469057, 468732, 468228, 467736, 467562, 467492, 467199, 467016, 466808, 466249, 465433, 465395, 463603, 463031, 462008, 461619, 460948, 460571, 459877, 459657, 458178, 457525, 457202, 457101, 457025, 456990, 456577, 456416, 456355, 455723, 455610, 455449, 455005, 454250, 454164, 454014, 453903, 453589, 453324, 453064, 452719, 452555, 452510, 452221, 452115, 451291))
Run Time: 0.037001
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1252 | |
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 | | | | | 1252 | |
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