SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache,
apppromotions.posid AS posid
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN xf_snog_applications_promotions AS apppromotions
ON (apppromotions.post_id = post.post_id)
WHERE post.post_id IN (133989, 131295, 131294, 101518, 101517, 100638, 100637, 100595, 100593, 100459, 100360, 100359, 100162, 99884, 99880, 99787, 99735, 99629, 99442, 99422, 99301, 99300, 99299, 99187, 99172, 99097, 99094, 99085, 99084, 99050, 99049, 99046, 99045, 99044, 98951, 98950, 98877, 98811, 98796, 98795, 98773, 98736, 98657, 98643, 98600, 98585, 98579, 98451, 98425, 98423, 98422, 98417, 98390, 98389, 98376, 98303, 98008, 98006, 97693, 97660, 97591, 97576, 97569, 97567, 97534, 97472, 97470, 97410, 97384, 97383, 97317, 97284, 97270, 97225, 97157, 97042, 97039, 97015, 96893, 96816, 96810, 96777, 96740, 96727, 96665, 96663, 96530, 96529, 96528, 96501, 96479, 96476, 96469, 96421, 96417, 96352, 96312, 96287, 96253, 96187, 96184, 96108, 96106, 96105, 96104, 96033, 96031, 96007, 95988, 95987, 95986, 95939, 95938, 95826, 95787, 95603, 95429, 95356, 95347, 95344, 95343, 95342, 95307, 95306, 95297, 95270, 95158, 95031, 94941, 94894, 94842, 94831, 94819, 94818, 94816, 94740, 94730, 94722, 94702, 94615, 94611, 94512, 94401, 94357, 94353, 94348, 94313, 94308, 94298, 94255, 94250, 94205, 94194, 94164, 94142, 94131, 94075, 94073, 94062, 94061, 93978, 93957, 93674, 93668, 93664, 93594, 93537, 93531, 93530, 93527, 93520, 93515, 93496, 93490, 93454, 93429, 93409, 93295, 93277, 93275, 93244, 93240, 93237, 93235, 93234, 93223, 93216, 93182, 93181, 93173, 93165, 93113, 93102, 93065, 93056, 93054, 93053, 93052, 93051, 93047, 92983, 92810, 92804, 92802, 92799, 92790, 92778, 92757, 92697, 92696, 92671, 92650, 92649, 92639, 92567, 92565, 92534, 92532, 92422, 92377, 92358, 92357, 92354, 92314, 92311, 92310, 92300, 92265, 92234, 92229, 92228, 92224, 92175, 92119, 92118, 92111, 92091, 92059, 91982, 91967, 91907, 91889, 91873, 91871, 91865, 91851, 91850, 91717, 91633, 91625, 91621, 91603, 91532, 91402, 91401, 91343, 91326, 91310, 91309, 91254, 91251, 91131, 91124, 91095, 91039, 90962, 90961, 90959, 90895, 90866, 90740, 90738, 90657, 90656, 90632, 90585, 90506, 90493, 90338, 90325, 90324, 90312, 90284, 90120, 90116, 90014, 90011, 89997, 89995, 89945, 89926, 89907, 89900, 89897, 89894, 89806, 89805, 89804, 89801, 89724, 89690, 89688, 89661, 89652, 89649, 89643, 89638, 89620, 89617, 89549, 89547, 89545, 89543, 89542, 89539, 89530, 89525, 89523, 89329, 89092, 89056, 89018, 88999, 88946, 88877, 88871, 88841, 88786, 88766, 88713, 88709, 88708, 88697, 88695, 88693, 88672, 88669, 88662, 88659, 88657, 88656, 88645, 88612, 88543, 88542, 88535, 88534, 88532, 88479, 88460, 88190, 88189, 88174, 88131, 87934, 87924, 87777, 87759, 87752, 87749, 87730, 87729, 87727, 87683, 87641, 87640, 87637, 87616, 87610, 87596, 87594, 87475, 87459, 87440, 87432, 87303, 87238, 87223, 87218, 87209, 87194, 87192, 87188, 87185, 87173, 87161, 87143, 87120, 86860, 86853, 86836, 86834, 86822, 86820, 86815, 86812, 86783, 86782, 86776, 86775, 86773, 86769, 86764, 86665, 86664, 86663, 86661, 86655, 86646, 86629, 86621, 86610, 86598, 86492, 86400, 86371, 86359, 86314, 86304, 86224, 86137, 86088, 86064, 85974, 85970, 85892, 85846, 85565, 84912, 84911, 84879, 84843, 84812, 84804, 84803, 84801, 84738, 84730, 84706, 84696, 84694, 84692, 84674, 84671, 84610, 84564, 84561, 84557, 84556, 84555, 84551, 84550, 84549, 84501, 84441, 84165, 84164, 84094, 84026, 84019, 84011, 83993, 83986, 83981, 83961, 83879, 83876, 83874, 83736, 83734, 83729, 83726, 83723, 83721, 83720, 83718, 83592, 83553, 83547, 83482, 83479, 83472, 83470, 83449, 83381, 83375, 83373, 83371, 83230, 83225, 83219, 83212, 83200, 83191, 83190, 83187, 83186, 83185, 83183, 83174, 83107, 83063, 83062, 82964, 82957, 82951, 82899, 82893, 82890, 82888, 82879, 82869, 82834, 82832, 82806, 82790, 82789, 82788, 82787, 82780, 82725, 82696, 82659, 82656, 82655, 82654, 82653, 82652, 82651, 82650, 82615, 82554, 82540, 82480, 82450, 82444, 82409, 82404, 82401, 82394, 82393, 82392, 82391, 82390, 82376, 82355, 82344, 82342, 82341, 82338, 82327, 82321, 82207, 82205, 82186, 82183, 82163, 82160, 82150, 82064, 82060, 82059, 82058, 82056, 82038, 82035, 82019, 82018, 82017, 82002, 81978, 81959, 81940, 81937, 81936, 81922, 81920, 81919, 81916, 81910, 81797, 81782, 81775, 81763, 81743, 81691, 81554, 81531, 81220, 81197, 81193, 81159, 81140, 81069, 81053, 81049, 81048, 80955, 80945, 80928, 80814, 80813, 80812, 80808, 80807, 80806, 80805, 80804, 80803, 80800, 80798, 80770, 80760, 80753, 80750, 80749, 80744, 80743, 80736, 80735, 80730, 80722, 80721, 80715, 80713, 80712, 80708, 80705, 80704, 80703, 80702, 80700, 80636, 80547, 80472, 80459, 80458, 80456, 80455, 80453, 80446, 80438, 80399, 80397, 80395, 80388, 80291, 80278, 80267, 80260, 80255, 80253, 80203, 80194, 80180, 80172, 80169, 80168, 80167, 80161, 80076, 80065, 80064, 80058, 80037, 80033, 80032, 80031, 80023, 80020, 80017, 79998, 79936, 79890, 79875, 79874, 79873, 79872, 79870, 79868, 79866, 79772, 79463, 79462, 79461, 79449, 79448, 79444, 79436, 79422, 79421, 79409, 79402, 79396, 79383, 79368, 79367, 79361, 79347, 79325, 79315, 79236, 79229, 79225, 79222, 79220, 79219, 79211, 79208, 79129, 79128, 78989, 78970, 78968, 78910, 78894, 78893, 78892, 78890, 78886, 78885, 78850, 78796, 78749, 78740, 78730, 78728, 78716, 78707, 78700, 78699, 78697, 78695, 78694, 78693, 78692, 78691, 78687, 78686, 78685, 78684, 78683, 78620, 78555, 78532, 78519, 78514, 78498, 78497, 78486, 78477, 78476, 78436, 78411, 78409, 78372, 78241, 78091, 78088, 78087, 78058, 78051, 77976, 77948, 77942, 77826, 77824, 77820, 77810, 77809, 77808, 77807, 77805, 77761, 77738, 77728, 77700, 77699, 77695, 77693, 77667, 77661, 77659, 77658, 77656, 77654, 77651, 77648, 77647, 77569, 77505, 77419, 77207, 77034, 77027, 76918, 76915, 76837, 76834, 76827, 76823, 76726, 76725, 76724, 76689, 76671, 76646, 76628, 76627, 76623, 76591, 76577, 76562, 76440, 76328, 76327, 76185, 76175, 75922, 75920, 75897, 75875, 75869, 75726, 75724, 75719, 75706, 75700, 75698, 75697, 75695, 75694, 75675, 75671, 75669, 75602, 75600, 75584, 75582, 75544, 75543, 75542, 75380, 75358, 75350, 75349, 75326, 75319, 75316, 75308, 75306, 75305, 75304, 75301, 75298, 75295, 75293, 75292, 75290, 75281, 75278, 75277, 75193, 75190, 75181, 75174, 75155, 75154, 75145, 75144, 75050, 74926, 74868, 74836, 74668, 74667, 74664, 74660, 74651, 74648, 74618, 74495, 74449, 74448, 74445, 74444)
Run Time: 0.053108
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 886 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | wristhax_forum.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,wristhax_forum.thread.node_id | 1 | Using where |
SIMPLE | apppromotions | ALL | post_id | | | | 1 | Using where; Using join buffer (flat, BNL join) |