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 (1047277, 1045576, 1045562, 1044280, 1043969, 1041573, 1035604, 1034496, 1032879, 1032826, 1031163, 1030943, 1030174, 1029789, 1028658, 1028301, 1028144, 1026018, 1025524, 1025107, 1024928, 1024609, 1023229, 1022780, 1021526, 1021524, 1021523, 1021465, 1021460, 1021445, 1021158, 1021150, 1021127, 1020871, 1019693, 1019354, 1019301, 1018377, 1018376, 1018121, 1017217, 1017139, 1016882, 1016871, 1016465, 1016346, 1016207, 1016068, 1015619, 1015550, 1015383, 1015366, 1015320, 1015309, 1015159, 1015017, 1014922, 1014878, 1014684, 1014557, 1014555, 1013666, 1013392, 1013336, 1013049, 1012655, 1012511, 1011941, 1011938, 1011650, 1011527, 1011280, 1011279, 1010701, 1010700, 1010698, 1010681, 1010679, 1010473, 1010373, 1010371, 1010369, 1010368, 1010364, 1010363, 1010362, 1010361, 1010350, 1010171, 1009851, 1009750, 1009490, 1009489, 1009359, 1009357, 1009058, 1009035, 1009000, 1008494, 1008481, 1008219, 1008069, 1007856, 1007817, 1007815, 1000364, 1007777, 1007697, 1007632, 1007436, 1007129, 1006847, 1006765, 1006484, 1006212, 1006211, 1006164, 1005923, 1005415, 1005231, 1005230, 1005172, 1004995, 1004862, 1004653, 1004651, 1004624, 1004609, 1003944, 1003547, 1003398, 1003326, 1002918, 1002680, 1002679, 1002675, 1002036, 1001920, 1001626, 1001402, 1001369, 1001310, 1001270, 1000981, 1000338, 1000248, 999827, 998667, 997882, 999450, 997410, 994970, 994698, 993947, 993919, 993724, 993477, 992498, 992483, 992210, 992088, 991721, 991679, 991510, 991498, 991378, 991181, 990911, 990189, 988693, 988640, 988455, 988114, 987747, 987347, 986991, 986826, 986791, 986780, 986749, 986734, 986506, 986244, 986201, 986200, 917485, 985883, 985092, 979529, 980657, 985081, 985065, 984626, 984585, 984446, 983935, 983753, 983751, 983561, 983558, 983556, 983555, 983553, 983439, 982711, 982413, 944215, 981748, 981669, 980854, 980826, 982543, 980277, 979673, 978902, 978801, 978762, 978501, 978423, 978142, 978057, 977794, 977656, 977574, 977502, 977491, 977490, 977486, 977023, 976997, 976943, 976757, 976370, 976313, 976047, 975805, 904698, 975709, 975414, 974896, 974816, 974813, 974810, 974808, 974703, 974702, 974485, 974463, 974462, 974439, 974375, 974370, 974361, 974224, 974222, 971990, 971700, 971669, 971289, 971283, 971279, 970826, 986614, 970699, 970470, 970468, 970362, 969519, 969396, 969291, 969217, 969214, 968963, 968838, 968748, 968581, 968221, 967905, 967856, 967827, 969468, 967670, 967668, 967455, 967330, 967175, 967170, 967139, 966960, 966574, 966436, 966422, 965699, 965445, 965296, 979469, 964548, 963904, 963641, 963623, 963569, 963530, 963493, 963490, 963474, 963364, 963169, 963152, 963057, 963044, 962881, 962617, 962229, 961921, 961356, 961243, 961083, 961031, 960694, 960592, 960402, 959973, 959967, 959889, 959858, 959856, 959542, 958322, 958207, 956187, 955970, 955939, 955462, 955163, 954643, 953932, 953689, 952841, 952630, 952224, 952195, 951333, 951086, 950376, 950019, 949901, 949179, 949178, 948774, 948700, 948688, 946254, 946176, 946141, 946046, 945820, 945767, 945766, 945738, 945246, 944648, 944592, 944061, 943729, 943581, 943233, 943140, 942022, 941875, 941363, 941045, 940673, 940585, 940399, 939993, 945248, 939410, 939319, 939285, 938805, 938561, 938042, 937671, 937006, 936153, 935755, 935078, 934981, 934111, 933341, 933146, 932736, 932100, 932037, 931804, 931680, 930028, 929736, 929484, 928694, 928476, 927961, 927927, 926409, 926203, 926199, 926053, 925724, 925353, 925298, 924442, 923393, 923228, 922678, 922518, 921281, 920230, 920203, 920014, 919201, 918347, 918095, 917888, 917674, 915794, 915793, 915736, 913424, 71225, 911268, 910380, 528815, 906671, 905865, 905722, 905662, 905379, 904628, 904440, 904439, 904438, 904427, 903335, 901318, 904547, 900608, 900369, 899035, 897686, 897383, 896790, 896457, 894553, 894382, 894018, 891551, 890130, 887728, 886862, 885872, 885834, 884465, 912139, 882792, 885034, 884398, 880473, 879810, 879346, 879268, 878194, 877843, 877774, 876802, 876436, 876241, 875716, 875436, 875425, 875422, 875378, 875044, 874971, 908343, 875541, 872500, 872499, 872491, 872248, 872215, 870199, 868256, 868157, 867889, 867177, 865736, 919995, 875028, 864798, 863652))
Run Time: 0.022481
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 500 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | board.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,board.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 2866
- 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 137
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20