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 (151240, 100635, 100548, 100547, 100527, 100307, 100268, 100265, 100264, 100263, 100192, 99971, 99765, 99763, 99743, 99064, 98975, 98282, 98051, 98033, 97487, 97411, 97226, 97142, 97141, 97131, 96902, 96838, 96760, 96463, 96461, 96460, 96457, 96456, 96317, 96264, 96262, 96252, 96249, 96247, 96246, 96243, 96222, 96081, 96079, 96077, 96076, 96072, 96065, 96062, 95154, 94079, 94036, 93542, 92523, 92336, 91845, 91842, 91841, 91698, 91236, 91107, 91105, 90630, 89718, 89717, 89510, 89385, 89322, 89117, 88600, 88598, 87825, 87365, 87077, 87001, 87000, 86978, 86927, 86794, 86787, 86353, 86156, 86154, 86063, 86058, 85428, 85406, 85079, 85045, 84715, 84698, 84515, 84405, 84219, 84119, 84117, 84086, 83594, 82930, 82749, 82224, 82039, 81142, 81101, 80942, 80701, 80670, 80518, 80474, 80467, 80178, 80095, 80057, 79849, 79419, 79283, 79230, 78997, 78937, 78936, 78868, 78846, 78845, 78831, 78785, 78738, 78603, 78591, 78551, 78550, 78464, 78376, 78374, 78367, 78365, 78284, 78161, 78160, 78067, 78066, 78023, 78020, 78019, 78010, 77763, 77755, 77717, 77711, 77666, 77665, 77664, 77662, 77576, 77416, 77314, 77061, 76987, 76985, 76972, 76971, 76968, 76911, 76907, 76906, 76905, 76904, 76897, 76650, 76320, 76250, 76249, 76197, 76137, 76134, 76133, 76132, 76128, 76091, 76089, 76076, 76075, 75916, 75904, 75879, 75867, 75811, 75801, 75800, 75790, 75789, 75469, 75464, 75463, 75371, 75330, 75325, 75269, 75199, 75146, 75143, 75117, 75084, 75082, 75081, 75077, 74973, 74876, 74873, 74867, 74841, 74815, 74795, 74760, 74759, 74755, 74471, 74402, 74365, 74364, 74016, 74015, 73999, 73998, 73980, 73686, 73603, 73539, 73538, 73082, 72852, 72848, 72847, 72767, 72457, 72361, 72319, 72308, 72299, 72298, 72281, 72279, 72157, 72155, 72138, 72059, 72041, 72034, 71974, 71966, 71963, 71961, 71937, 71928, 71908, 71906, 71905, 71904, 71903, 71902, 71901, 71900, 71891, 71889, 71887, 71886, 71885, 71884, 71882, 71788, 71784, 71783, 71782, 71781, 71652, 71651, 71650, 71623, 71622, 71541, 71332, 71319, 71315, 71303, 71173, 71161, 71123, 71021, 70964, 70962, 70842, 70800, 70789, 70785, 70709, 70699, 70686, 70674, 70664, 70650, 70632, 70631, 70630, 70629, 70628, 70626, 70518, 70517, 70489, 70487, 70431, 70330, 70320, 70318, 70298, 70279, 70269, 70263, 70253, 70245, 70244, 70190, 70189, 70187, 70183, 70182, 70159, 70138, 70125, 70122, 70121, 70118, 69952, 69949, 69948, 69945, 69893, 69892, 69868, 69860, 69852, 69805, 69803, 69779, 69778, 69742, 69591, 69442, 69424, 69420, 69413, 69394, 69372, 69371, 69370, 69369, 69368, 69364, 69357, 69306, 69304, 69296, 69278, 69275, 69274, 69125, 69091, 69087, 69084, 69080, 69076, 68949, 68700, 68686, 68685, 68684, 68683, 68682, 68681, 68651, 68647, 68646, 68643, 68626, 68625, 68590, 68444, 68443, 68433, 68369, 68367, 68365, 68364, 68363, 68277, 68273, 68271, 68264, 68257, 68226, 68224, 68221, 68220, 67947, 67944, 67791, 67775, 67771, 67727, 67726, 67716, 67715, 67708, 67707, 67523, 67520, 67493, 67446, 67440, 67437, 67436, 67435, 67356, 67354, 67351, 67299, 67298, 67297, 67296, 67295, 67293, 67292, 67291, 67290, 67242, 67210, 67200, 67199, 66925, 66924, 66896, 66752, 66733, 66729, 66726, 66664, 66661, 66659, 66654, 66653, 66652, 66648, 66642, 66436, 66433, 66431, 66429, 66396, 66395, 66375, 66361, 66355, 66353, 66346, 66256, 66255, 66224, 66211, 66210, 66206, 66192, 66191, 66189, 66186, 66185, 66184, 66183, 66182, 66175, 66171, 66170, 66167, 66166, 66163, 66161, 66086, 66084, 65853, 65851, 65804, 65803, 65802, 65801, 65761, 65733, 65411, 65408, 65329, 65326, 65325, 65324, 65323, 65322, 65308, 65306, 65202, 65201, 65199, 65198, 65012, 65010, 65008, 64910, 64890, 64888, 64880, 64879, 64876, 64870, 64866, 64864, 64856, 64841, 64840, 64781, 64770, 64769, 64767, 64754, 64752, 64748, 64686, 64684, 64673, 64508, 64485, 64484, 64473, 64454, 64428, 64217, 64166, 64165, 64163, 64162, 64150, 64149, 64131, 64129, 64127, 64115, 64035, 64034, 63942, 63774, 63687, 63682, 63681, 63663, 63527, 63503, 63465, 63464, 63369, 63368, 63358, 63291, 63290, 63131, 63119, 63105, 63102, 63098, 63010, 62926, 62925, 62923, 62922, 62921, 62876, 62872, 62831, 62829, 62822, 62813, 62810, 62799, 62790, 62785, 62784, 62725, 62609, 62606, 62577, 62576, 62562, 62543, 62539, 62534, 62533, 62528, 62526, 62523, 62518, 62516, 62312, 62311, 62268, 62261, 62258, 62256, 62249, 62244, 62242, 62239, 62234, 62229, 62226, 62218, 62215, 62213, 62205, 62203, 62198, 62100, 62099, 62094, 62087, 62059, 62028, 62027, 61923, 61916, 61915, 61912, 61901, 61898, 61888, 61887, 61883, 61830, 61827, 61826, 61825, 61818, 61816, 61814, 61812, 61811, 61697, 61689, 61676, 61645, 61636, 61635, 61634, 61632, 61603, 61593, 61592, 61575, 61574, 61511, 61473, 61443, 61429, 61427, 61426, 61405, 61387, 61383, 61376, 61375, 61366, 61365, 61345, 61342, 61337, 61330, 61326, 61324, 61322, 61321, 61320, 61318, 61302, 61300, 61296, 61290, 61281, 61276, 61273, 61272, 61270, 61256, 61250, 61237, 61228, 61208, 61200, 61193, 61185, 61166, 61165, 61164, 61065, 61057, 61025, 60950, 60943, 60938, 60928, 60915, 60907, 60906, 60905, 60901, 60900, 60898, 60896, 60895, 60893, 60892, 60891, 60890, 60887, 60884, 60881, 60878, 60877, 60874, 60873, 60840, 60839, 60838, 60834, 60826, 60822, 60819, 60818, 60817, 60815, 60813, 60810, 60808, 60800, 60799, 60798, 60797, 60796, 60795, 60794, 60793, 60792, 60788, 60787, 60782, 60637, 60619, 60616, 60615, 60614, 60591, 60589, 60584, 60575, 60570, 60569, 60568, 60523, 60519, 60518, 60515, 60514, 60513, 60483, 60479, 60478, 60477, 60476, 60475, 60463, 60462, 60460, 60455, 60453, 60451, 60446, 60445, 60423, 60418, 60413, 60409, 60403, 60398, 60390, 60381, 60373, 60372, 60371, 60285, 60243, 60223, 60171, 60170, 60169, 60168, 60167, 60166, 60165, 60164, 60163, 60162, 60161, 60149, 60134, 60130, 60129, 60127, 60118, 60117, 60116, 60115, 60106, 60092, 60057, 60054, 59912, 59911, 59910, 59894, 59893, 59887, 59876, 59869, 59861, 59860, 59852, 59850, 59849, 59845, 59844, 59843, 59838, 59832, 59831, 59825, 59810, 59806, 59802, 59784, 59783, 59780, 59764, 59672, 59671, 59664, 59663, 59662, 59661, 59658, 59654, 59652, 59632, 59603, 59276, 59274, 59272, 59271, 59265, 59225, 59224, 59144, 59143, 59142, 59053, 59050, 59033, 59031, 59028, 59025, 59016, 58909, 58908, 58907, 58899, 58887, 58875, 58758, 58740, 58733, 58727, 58626, 58625, 58609, 58596, 58484, 58482, 58478, 58457, 58456, 58442, 58441, 58439, 58428, 58420, 58419, 58414, 58348, 58346, 58345, 58323, 58322, 58321, 58260, 58245, 58244, 58214, 58198, 58190, 58189, 58186, 58184, 58094, 58088, 58007, 58006, 58005, 58004, 57904, 57902, 57878, 57872, 57871, 57868, 57867, 57758, 57756, 57748, 57747, 57746, 57739, 57729, 57725, 57700, 57629, 57628, 57627, 57614, 57611, 57444, 57419, 57403, 57378, 57218, 57106, 57103)
Run Time: 0.067166
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 | | 957 | 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) |