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 (183893, 84853, 84475, 83916, 83701, 83700, 83427, 83168, 82954, 82932, 82931, 82568, 82565, 82439, 82255, 82253, 82252, 82241, 82228, 82227, 82225, 82223, 82001, 81999, 81529, 81528, 81513, 81506, 81502, 81496, 81495, 81494, 81044, 80877, 80875, 80872, 80871, 80638, 80419, 80418, 79918, 79916, 79915, 79857, 79301, 79300, 78966, 78867, 78663, 78660, 78263, 78236, 77859, 77539, 77189, 77187, 77186, 77185, 77184, 77183, 77182, 77091, 76889, 76888, 76887, 76886, 76546, 76380, 75913, 75912, 75689, 75633, 75406, 75405, 75404, 75403, 75401, 75399, 75321, 75033, 74909, 73983, 73804, 73803, 73802, 73801, 73800, 73446, 72664, 72661, 72660, 71957, 71772, 71771, 71214, 71213, 71212, 71145, 71104, 71101, 71097, 71096, 70983, 70981, 70802, 70507, 70506, 70033, 70025, 69691, 69690, 69689, 69688, 69267, 69266, 69213, 69212, 69211, 69208, 69206, 69201, 69199, 69197, 68888, 68886, 68482, 68480, 68372, 67904, 67903, 67457, 67133, 66875, 66874, 66839, 66836, 66478, 66476, 66448, 66179, 65952, 65902, 65900, 65899, 65897, 65686, 65685, 65684, 65683, 65647, 65645, 65464, 65463, 65342, 65104, 64656, 64655, 64654, 64585, 64583, 64582, 64581, 64580, 64578, 64566, 64360, 64357, 64356, 64353, 64348, 64307, 64306, 64305, 64304, 64303, 64302, 64299, 64095, 64070, 64060, 63661, 63639, 63471, 63312, 63310, 63309, 63043, 63042, 63040, 62840, 62838, 62061, 62060, 62011, 62002, 61983, 61982, 61981, 61980, 61869, 61868, 61867, 61866, 61625, 61624, 61623, 61245, 61244, 61243, 61242, 61241, 61240, 61178, 61177, 61176, 61171, 60361, 60354, 60254, 60235, 60234, 60232, 60230, 60229, 60226, 60225, 60224, 59414, 59413, 58892, 58527, 57441, 57044, 56628, 56624, 56574, 56573, 56474, 56473, 56374, 56373, 56060, 56026, 56024, 56022, 56021, 55855, 55854, 55437, 55314, 55312, 55084, 55037, 55029, 55018, 55016, 54837, 54836, 54646, 54485, 54473, 54466, 54465, 54463, 54461, 54460, 54436, 54435, 54340, 54065, 54042, 53970, 53920, 53890, 53885, 53798, 53797, 53773, 53675, 53672, 53671, 53667, 53650, 53649, 53648, 53407, 53403, 53345, 53105, 53104, 53076, 53073, 52838, 52837, 52834, 52833, 52832, 52830, 52828, 52454, 52342, 52331, 52329, 52321, 52319, 52316, 52127, 51863, 51740, 51582, 51541, 51535, 51534, 51528, 51519, 51518, 51516, 51514, 51513, 51349, 51328, 51073, 50988, 50984, 50830, 50829, 50648, 50477, 50476, 50047, 50033, 50019, 50017, 50015, 49880, 49879, 49815, 49802, 49535, 48771, 48766, 48758, 48756, 48755, 48754, 48752, 48645, 48507, 48497, 48492, 48479, 48478, 48477, 48001, 47988, 47982, 47919, 47813, 47799, 47796, 47792, 47776, 47770, 47769, 47758, 47757, 47756, 47755, 47649, 47641, 47529, 47497, 47409, 47403, 47398, 47387, 47352, 46949, 46558, 46557, 46394, 46336, 46325, 46166, 46129, 46113, 46112, 46030, 46029, 45999, 45895, 45782, 45753, 45743, 45722, 45707, 45670, 45665, 45664, 45663, 45661, 45660, 45659, 45568, 45512, 45511, 45368, 45367, 45357, 45343, 45322, 45320, 45318, 45316, 45314, 45173, 45168, 45167, 45166, 45165, 45164, 45163, 45162, 45161, 44741, 44210, 44131, 44130, 44128, 44010, 43809, 43797, 43796, 43673, 43669, 43566, 43565, 43223, 43191, 43151, 42970, 42954, 42471, 41462, 41427, 41410, 41409, 41332, 41247, 40632, 40631, 40630, 40616, 40613, 40553, 40419, 40331, 40330, 40268, 40220, 40037, 40034, 39442, 39284, 38922, 38006, 37935, 37934, 37918, 37912, 37910, 37823, 37697, 37688, 37686, 37658, 37633, 37427, 37317, 37316, 37309, 37254, 36968, 36950, 36945, 36944, 36930, 36784, 36783, 36677, 36549, 36548, 36547, 36416, 36407, 36403, 36395, 36195, 36194, 36191, 36180, 35103, 34805, 34658, 34650, 34649, 34513, 34512, 34405, 34256, 34219, 33874, 33873, 33655, 33570, 33393, 33066, 32772, 32750, 32749, 32748, 32747, 32658, 32648, 32647, 32504, 32492, 32489, 32342, 32325, 32185, 32176, 32173, 32070, 32069, 32068, 32016, 31925, 31895, 31860, 31851, 31764, 31759, 31758, 31756, 31754, 31408, 31249, 31248, 31083, 31082, 31081, 31080, 31046, 31044, 31032, 30992, 30965, 30945, 30924, 30914, 30900, 30898, 30688, 30677, 30567, 30558, 30557, 30438, 30437, 30436, 30435, 30434, 30433, 30432, 30303, 30129, 30112, 30077, 30076, 30075, 30074, 30043, 30036, 29823, 29779, 29778, 29775, 29737, 29606, 29514, 29484, 29324, 29287, 29160, 29111, 29108, 29071, 28913, 28912, 28911, 28890, 28814, 28629, 28607, 28604, 28550, 28526, 28485, 28484, 28483, 28452, 28450, 28449, 28423, 28312, 28244, 28187, 28186, 28154, 28153, 28133, 28093, 27934, 27832, 27772, 27765, 27763, 27762, 27761, 27716, 27693, 27680, 27667, 27666, 27660, 27602, 27564, 27554, 27506, 27502, 27501, 27489, 27448, 27434, 27406, 27059, 27058, 26998, 26961, 26940, 26939, 26929, 26924, 26821, 26803, 26802, 26801, 26800, 26799, 26798, 26797, 26796, 26706, 26677, 26676, 26657, 26607, 26600, 26588, 26390, 26388, 26281, 26265, 26259, 26246, 26176, 26175, 26173, 26117, 26054, 26046, 26045, 25984, 25983, 25949, 25948, 25936, 25927, 25926, 25743, 25734, 25728, 25727, 25726, 25663, 25632, 25630, 25629, 25619, 25614, 25610, 25609, 25608, 25607, 25606, 25600, 25599, 25598, 25557, 25470, 25338, 25327, 25323, 25322, 25321, 25256, 25255, 25253, 25240, 25239, 25148, 25141, 24987, 24977, 24975, 24915, 24771, 24597, 24584, 24581, 24475, 24454, 24453, 24451, 24450, 24344, 24343, 24283, 24281, 24278, 24234, 24192, 24177, 24176, 24167, 24126, 24125, 24076, 24029, 24028, 24024, 24023, 24022, 24021, 24020, 24004, 23995, 23990, 23989, 23985, 23973, 23970, 23958, 23924, 23919, 23908, 23907, 23905, 23904, 23848, 23847, 23759, 23753, 23738, 23722, 23682, 23643, 23630, 23629, 23628, 23627, 23500, 23488, 23487, 23431, 23384, 23378, 23373, 23370, 23369, 23366, 23364, 23361, 23359, 23358, 23356, 23353, 23347, 23313, 23227, 23220, 23219, 23214, 23212, 23207, 23204, 23202, 23201, 23099, 23098, 22951, 22946, 22944, 22917, 22916, 22832, 22781, 22779, 22778, 22777, 22744, 22742, 22683, 22633, 22632, 22631, 22562, 22555, 22539, 22538, 22537, 22536, 22530, 22369, 22368, 22363, 22360, 22346, 22186, 22175, 22171, 22151, 22149, 22147, 22145, 22141, 22135, 22127, 22125, 22115, 22106, 22102, 22052, 22021, 22020, 22018, 22017, 22014, 21983, 21919, 21917, 21912, 21911, 21906, 21902, 21894, 21887, 21885, 21884, 21862, 21844, 21843, 21842, 21841, 21840, 21838, 21827, 21824, 21793, 21699, 21696, 21695, 21549, 21547, 21546, 21463, 21462, 21461, 21459, 21458, 21303, 21275, 21263, 21235, 21221, 21220, 21219, 21217, 21175, 21139, 21121, 21037, 21024, 21023, 20901, 20837, 20835, 20833, 20830, 20814, 20810, 20809, 20808, 20807, 20806, 20759, 20753, 20732, 20722, 20643, 20626, 20611, 20610, 20609, 20608, 20590, 20589, 20588, 20587, 20548, 20541, 20534, 20499, 20490, 20486, 20483, 20457, 20453, 20452, 20451, 20450, 20448, 20431, 20400, 20390, 20389, 20388, 20387, 20334, 20332, 20331, 20330, 20329, 20313, 20302, 20294, 20290, 20289, 20263)
Run Time: 0.060392
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 | | 960 | 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) |