SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_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)
WHERE thread.thread_id IN (9580550, 9551498, 9478169, 9478096, 9474311, 9474307, 9473475, 9472895, 9470673, 9470670, 9470666, 9470665, 9470661, 9469363, 9468806, 9467133, 9467131, 9467130, 9465512, 9465511, 9465138, 9464386, 9464185, 9463219, 9463037, 9462287, 9461728, 9461727, 9461112, 9460849, 9460847, 9460844, 9460842, 9459807, 9459798, 9459769, 9458829, 9457261, 9457258, 9455995, 9455700, 9455696, 9454855, 9454854, 9454852, 9454851, 9453736, 9453664, 9452144, 9451953, 9451074, 9450157, 9449248, 9449212, 9449208, 9448814, 9448234, 9447941, 9447939, 9447758, 9447694, 9447691, 9447499, 9447427, 9447426, 9447183, 9447180, 9446810, 9446809, 9446807, 9446804, 9445552, 9445547, 9445543, 9444200, 9444195, 9442186, 9441859, 9439570, 9437097, 9437095, 9436408, 9435894, 9435889, 9435764, 9432753, 9432746, 9429745, 9428240, 9425735, 9423908, 9423626, 9422695, 9419249, 9413714, 9409457, 9406280, 9405940, 9405782, 9405781, 9405236, 9404094, 9402031, 9401711, 9401710, 9399887, 9399433, 9397609, 9397332, 9396959, 9396435, 9394952, 9393842, 9391824, 9391822, 9390156, 9387291, 9387186, 9385922, 9385739, 9383574, 9381850, 9379754, 9378689, 9377277, 9376984, 9376319, 9376307, 9375670, 9374744, 9374685, 9372345, 9371356, 9371355, 9371352, 9369578, 9368911, 9368018, 9365485, 9363733, 9363093, 9361084, 9358053, 9357035, 9355779, 9349216, 9348090, 9347277, 9347275, 9346185, 9343648, 9340392, 9340389, 9339649, 9338405, 9338249, 9337896, 9337589, 9337272, 9336946, 9335326, 9334843, 9332832, 9332544, 9332307, 9330689, 9327922, 9327822, 9327821, 9324530, 9319796, 9319795, 9319789, 9317710, 9316307, 9314792, 9314674, 9313332, 9311590, 9311589, 9311587, 9309609, 9307693, 9303939, 9302389, 9302103, 9300849, 9300324, 9299505, 9299299, 9298508, 9297006, 9295408, 9294366, 9293232, 9290769, 9290767, 9290558, 9290274, 9288832, 9285230, 9281501, 9280558, 9278197, 9277980, 9277324, 9277278, 9273540, 9271903, 9269616, 9269451, 9268789, 9268378, 9267587, 9266818, 9260922, 9259551, 9259017, 9258432, 9257818, 9257514, 9257427, 9254690, 9254315, 9254217, 9252833, 9252385, 9249384, 9248535, 9248495, 9248472, 9248241, 9248240, 9248047, 9247746, 9245873, 9245558, 9243798, 9243795, 9241941, 9241057, 9237481, 9235432, 9234702, 9234329, 9231161, 9227973, 9226586, 9224396, 9221755, 9221063, 9219542, 9219260, 9217845, 9213771, 9211735, 9210037, 9208598, 9206768, 9205840, 9205123, 9204803, 9201774, 9198537, 9198426, 9198082, 9194618, 9194422, 9194421, 9191793, 9190045, 9189450, 9189059, 9188943, 9188374, 9187701, 9187418, 9184562, 9184554, 9183787, 9183229, 9182042, 9181663, 9181375, 9180268, 9180169, 9179721, 9179067, 9178468, 9177722, 9177163, 9177162, 9177128, 9176935, 9176921, 9176534, 9175402, 9174758, 9174619, 9173166, 9173067, 9172712, 9172491, 9171067, 9169711, 9167317, 9165303, 9164847, 9164764, 9161808, 9161556, 9160956, 9160689, 9160561, 9157411, 9155256, 9154242, 9154233, 9152675, 9150220, 9149939, 9149802, 9146946, 9145993, 9145142, 9145141, 9144975, 9136462, 9135729, 9135100, 9134912, 9134421, 9133820, 9132134, 9130548, 9130506, 9127914, 9127890, 9124964, 9124963, 9123954, 9123032, 9122966, 9122797, 9122796, 9122596, 9119864, 9118350, 9117472, 9115879, 9115256, 9115179, 9114520, 9112857, 9112670, 9111782, 9109602, 9108737, 9108387, 9108337, 9108223, 9107343, 9107140, 9106548, 9105109, 9104265, 9103154, 9101888, 9100863, 9098677, 9098510, 9095608, 9095569, 9095412, 9094319, 9093885, 9093762, 9093434, 9093284, 9093108, 9093061, 9093050, 9091723, 9091701, 9090934, 9090928, 9090236, 9090234, 9090224, 9089360, 9088947, 9088944, 9088942, 9088775, 9087530, 9087048, 9086784, 9085868, 9085314, 9084252, 9084058, 9083814, 9083489, 9083152, 9082712, 9082256, 9081346, 9079488, 9077765, 9077147, 9077134, 9076823, 9076800, 9076521, 9076198, 9075136, 9074420, 9073845, 9073430, 9072893, 9072718, 9072661, 9071468, 9069340, 9068494, 9067552, 9067425, 9066786, 9066658, 9065360, 9063715, 9063126, 9062743, 9062543, 9062319, 9061860, 9061491, 9060623, 9059749, 9059147, 9058325, 9058090, 9058035, 9057520, 9056749, 9056748, 9056744, 9056743, 9056740, 9056695, 9056650, 9056513, 9056114, 9056113, 9056112, 9055835, 9055350, 9054124, 9054123, 9053319, 9053312, 9052924, 9052406, 9052396, 9052387, 9052314, 9052172, 9052151, 9051505, 9050663, 9050566, 9050548, 9049842, 9049678, 9049081, 9048919, 9048918, 9048661, 9048480, 9047994, 9047816, 9047587, 9047585, 9046770, 9045276, 9044788, 9044472, 9044470, 9043709, 9043707, 9039046, 9038970, 9038071, 9037168, 9037162, 9036781, 9034129, 9033572, 9031357, 9027583, 9027330, 9026119, 9026117, 9026112, 9025878, 9023036, 9021882, 9021099, 9020336, 9020335, 9020107, 9019209, 9017069, 9016742, 9016577, 9016073, 9016069, 9015084, 9013069, 9012062, 9012061, 9011751, 9011652, 9011416, 9008490, 9008343, 9007712, 9007287, 9006200, 9005626, 9005595, 9005591, 9005489, 9005132, 9005072, 9005069, 9004963, 9002978, 9001460, 9001453, 8999653, 8999652, 8999095, 8999077, 8998635, 8998634, 8998432, 8997620, 8997577, 8996410, 8995963, 8995896, 8995784, 8992783, 8992512, 8991861, 8991854, 8991438, 8990483, 8990158, 8990040, 8989824, 8988033, 8987376, 8987374, 8986495, 8984672, 8984428, 8984345, 8983907, 8982881, 8980847, 8980840, 8980189, 8979927, 8978886, 8977719, 8977436, 8977430, 8976648, 8976300, 8974372, 8972942, 8971717, 8967562, 8966278, 8965795, 8965085, 8964838, 8961316, 8961120, 8959962, 8957936, 8957587, 8957413, 8957410, 8957409, 8957276, 8957274, 8957273, 8956841, 8954891, 8954478, 8954303, 8953648, 8952857, 8952661, 8952098, 8947626, 8947251, 8945523, 8943502, 8942457, 8942452, 8942383, 8940673, 8940021, 8939530, 8938490, 8938037, 8938033, 8938029, 8933573, 8932272, 8932271, 8932125, 8930636, 8929316, 8929294, 8928396, 8927376, 8927369, 8926928, 8924719, 8923480, 8922277, 8920669, 8919889, 8916645, 8916484, 8914491, 8914270, 8914093, 8913968, 8913640, 8912982, 8912776, 8911750, 8911053, 8910773, 8910772, 8910323, 8910144, 8909765, 8909684, 8907458, 8905406, 8903294, 8902245, 8901186, 8900753, 8899868, 8899807, 8895330, 8894662, 8894649, 8894646, 8894103, 8893169, 8892086, 8891330, 8891179, 8891174, 8891164, 8890103, 8889990, 8889987, 8889981, 8889776, 8889662, 8889193, 8888974, 8888912, 8888911, 8888489, 8887955, 8887952, 8886721, 8885769, 8885725, 8885717, 8885018, 8885001, 8884954, 8884708, 8883820, 8882777, 8882767, 8882761, 8882751, 8882502, 8882312, 8882278, 8882134, 8881641, 8881634, 8881243, 8881061, 8880773, 8880772, 8880771, 8880770, 8880573, 8880567, 8879871, 8879858, 8879126, 8879073, 8879066, 8879061, 8879025, 8878416, 8877452, 8877451, 8877450, 8876184, 8875912, 8875906, 8875897, 8875786, 8875732, 8875248, 8875092, 8874711, 8874708, 8874487, 8873970, 8873595, 8873386, 8873164, 8872819, 8872817, 8872810, 8871590, 8871587, 8871581, 8871537, 8871520, 8871501, 8871203, 8871202, 8871003, 8870825, 8870382, 8870379, 8870302, 8870268, 8870237, 8869828, 8869777, 8869550, 8869404, 8869398, 8869391, 8868985, 8868866, 8868830, 8868680, 8868461, 8868209, 8868201, 8868199, 8867434, 8867429, 8867426, 8866969, 8866425, 8866423, 8866422, 8866224, 8866165, 8866107, 8865762, 8865757, 8865754, 8865752, 8865144, 8864755, 8864749, 8864746, 8864742, 8864711, 8864552, 8864503, 8864457, 8863961, 8863865, 8863864, 8863863, 8863695, 8862815, 8862767, 8862765, 8862759, 8862755, 8861909, 8861900, 8861894, 8861887, 8861880, 8861333, 8860549, 8860545, 8860538, 8859869, 8859867, 8859861, 8859694, 8859690, 8859564, 8859478, 8859298, 8859291, 8859229, 8858797, 8858444, 8858173, 8858171, 8858169, 8858163, 8857767, 8857763, 8857748, 8857046, 8856968, 8856202, 8856145, 8856142, 8856066, 8855992, 8855919, 8855631, 8855515, 8855019, 8855014, 8854802, 8854737, 8854325, 8854095, 8853745, 8853656, 8853655, 8853654, 8853436, 8853427, 8853199, 8852586, 8852545, 8851530, 8851448, 8851083, 8850828, 8850754, 8850398, 8850023, 8849491, 8849297, 8849261, 8848900, 8848378, 8848360, 8848113, 8847822, 8847481, 8847469, 8847468, 8847405, 8847350, 8847325, 8847315, 8847308, 8847291, 8847289, 8846796, 8846467, 8846465, 8846359, 8845789, 8845772, 8845719, 8845718, 8845688, 8845682, 8845680, 8845552, 8845429, 8845394, 8845175, 8845174, 8844614, 8844607, 8844598, 8844531, 8844530, 8844528, 8844029, 8844028, 8843942, 8843905, 8843746, 8843580, 8843574, 8843566, 8843135, 8842854, 8842737, 8842726, 8842718, 8842402, 8842325, 8842116, 8841496, 8841491, 8841488, 8841433, 8841175, 8841041, 8840540, 8840539, 8840263, 8840007, 8840000, 8839993, 8839989, 8839483, 8839479, 8839476, 8839470, 8839158, 8838692, 8838691, 8838683, 8838673, 8838555, 8837836, 8837639, 8837638, 8837432, 8837426, 8837420, 8837416, 8837313, 8837304, 8836622, 8836619, 8836593, 8836588, 8836297, 8836205, 8836130, 8836038, 8835715, 8835625, 8835606, 8835483, 8835474, 8835444, 8835439, 8834560, 8834229, 8834204, 8834197, 8834104, 8834072, 8834071, 8833480, 8833269, 8833157, 8833115, 8833106, 8833104, 8832761, 8832152, 8831654, 8831310, 8831309, 8830875, 8830527, 8830520, 8830516, 8830300, 8830120, 8830119, 8829748, 8829747, 8829745, 8829744, 8829684, 8829678, 8829670, 8829659, 8829465, 8828964, 8828556, 8828497, 8828487, 8828484, 8828185, 8828116, 8827474, 8827467, 8827465, 8827153, 8826996, 8826977, 8826923, 8826912, 8826910, 8826715, 8826538, 8826472, 8826467, 8826453, 8826448, 8825970, 8825967, 8825966, 8825964, 8825960, 8825645, 8825461, 8825250, 8825242, 8825230, 8825106, 8824793, 8824720, 8824711, 8824710, 8824709, 8824477, 8824417, 8824403, 8824178, 8824168, 8824055, 8823818, 8823747, 8823642, 8823641, 8823639, 8823634, 8823315, 8822910, 8822669, 8822616, 8822610, 8822608, 8822599, 8821995, 8821977, 8821819, 8821743, 8821517, 8821514, 8821511, 8821493, 8820760, 8820554, 8820455, 8820430, 8820428, 8820425, 8820419, 8819911, 8819789, 8819762, 8819398, 8818743, 8818734, 8818724, 8818718, 8818085, 8818022, 8817976, 8817945, 8817661, 8817336, 8817321, 8816920, 8816865, 8816846, 8816774, 8816771, 8816653, 8816647, 8816645, 8816589, 8816473, 8816067, 8815421, 8815415, 8815412, 8815277, 8815113, 8815103, 8815091, 8815089, 8815071, 8815067, 8814966, 8814745, 8814695, 8814685, 8814674, 8814654, 8814342, 8814084, 8813497, 8813225, 8813204, 8813179, 8813175, 8812937, 8812823, 8812819, 8812670, 8812665, 8812658, 8812656, 8812381, 8811948, 8811941, 8811938, 8811929, 8811055, 8810876, 8810836, 8810580, 8810493, 8810483, 8810480, 8810478, 8810107, 8810099, 8809837, 8809781, 8809648, 8809311, 8809305, 8809303, 8809299, 8809253, 8809178, 8808957, 8808949, 8808745, 8808684, 8808682, 8808674, 8808669, 8808661, 8808358, 8808247, 8807742, 8807702, 8807699, 8807692, 8807383, 8807349, 8807213, 8807208, 8807194, 8807191, 8807170, 8806007, 8805869, 8805861, 8805853, 8805682, 8805659, 8805171, 8805168, 8805166, 8805143, 8805131, 8804849, 8804784, 8804217, 8804091, 8803762, 8803747, 8803672, 8802962, 8802727, 8802719, 8802544, 8802542, 8802540, 8802538, 8802536, 8801965, 8801953, 8801946, 8801942, 8801939, 8801936, 8801888, 8801737, 8801571, 8801134, 8800889, 8800862, 8800857, 8800846, 8800843, 8800658, 8799788, 8799532, 8798960, 8798841, 8798833, 8798804, 8798803, 8798802, 8798340, 8798336, 8797591, 8797563, 8797545, 8797431, 8797301, 8797083, 8797080, 8797077, 8796934, 8796931, 8796926, 8796920, 8796918, 8796469, 8796464, 8795796, 8795794, 8795793, 8795539, 8795537, 8795534, 8795528, 8795522, 8795520, 8795471, 8795409, 8795237, 8795086, 8795073, 8794546, 8794499, 8794498, 8794497, 8794486, 8794090, 8794011, 8793316, 8793313, 8793306, 8793223, 8793116, 8792967, 8792826, 8792825, 8792821, 8792819, 8791994, 8791341, 8790846, 8790843, 8790721, 8790709, 8790509, 8790402, 8790371, 8790368, 8790366, 8790161, 8789764, 8789419, 8789029, 8788873, 8788572, 8788192, 8788000, 8787893, 8787818, 8787815, 8787810, 8787579, 8787572, 8787570, 8787567, 8787518, 8787516, 8787493, 8787492, 8787156, 8787087, 8786899, 8786800, 8786613, 8786609, 8786606, 8785894, 8785884, 8785128, 8784848, 8784720, 8783751, 8783629, 8783505, 8783501, 8783310, 8782043, 8780819, 8780140, 8779996, 8779875, 8779698, 8779596, 8779509, 8779493, 8778886, 8778759, 8778661, 8778251, 8778250, 8778248, 8778247, 8778071, 8777932, 8777787, 8777595, 8777534, 8777462, 8777227, 8777125, 8777075, 8777063, 8777062, 8777059, 8777057, 8776621, 8775881, 8775718, 8775581, 8775258, 8774759, 8774756, 8774754, 8774750, 8774706, 8774331, 8773923, 8773921, 8773917, 8773915, 8773620, 8773268, 8773265, 8773264, 8773196, 8773193, 8772933, 8772839, 8772833, 8772829, 8772827, 8772826, 8772824, 8772647, 8772646, 8772645, 8772644, 8772125, 8771690, 8771683, 8771681, 8771679, 8771678, 8771565, 8770676, 8770576, 8770573, 8770571, 8770566, 8770562, 8770323, 8769689, 8769687, 8769686, 8769680, 8769672, 8769319, 8769222, 8768676, 8768675, 8768568, 8768566, 8768563, 8768559, 8767640, 8767505, 8767473, 8767291, 8767290, 8767286, 8766955, 8766667, 8766665, 8766663, 8766431, 8766428, 8766426, 8766423, 8766311, 8766275, 8765782, 8765774, 8765650, 8765629, 8765410, 8765409, 8765407, 8765404, 8765403, 8765301, 8765148, 8764992, 8764965, 8764921, 8764920, 8764919, 8764569, 8764567, 8764561, 8764523, 8764242, 8764011, 8763928, 8763817, 8763816, 8763559, 8763557, 8763555, 8763335, 8763322, 8763130, 8763125, 8763121, 8763119, 8763115, 8762922, 8762533, 8762128, 8762126, 8762125, 8762120, 8762118, 8761429, 8760985, 8760983, 8760977, 8760975, 8760733, 8760731, 8760728, 8760643, 8760603, 8760560, 8760166, 8759811, 8759808, 8759806, 8759801, 8759778, 8759518, 8759341, 8759086, 8759009, 8759004, 8759002, 8759001, 8758752, 8758526, 8758501, 8758499, 8758497, 8758489, 8758300, 8758285, 8758243, 8757827, 8757466, 8757465, 8757463, 8757183, 8757095, 8757092, 8757042, 8757041, 8757036, 8756897, 8756710, 8756426, 8756372, 8756370, 8756368, 8756009, 8756005, 8756003, 8755998, 8755624, 8755402, 8755364, 8755359, 8755127, 8755123, 8755116, 8754739, 8753879, 8753877, 8753874, 8753627, 8753625, 8753620, 8752763, 8752759, 8752755, 8752460, 8752456, 8752455, 8752454, 8751766, 8751721, 8751719, 8751718, 8751717, 8751141, 8751069, 8751022, 8751021, 8751019, 8750897, 8750895, 8750893, 8750892, 8750886, 8750183, 8750181, 8750180, 8750000, 8749984, 8749979, 8749973, 8749318, 8749035, 8749033, 8748920, 8748916, 8748910, 8748822, 8748817, 8748812, 8748807, 8748378, 8748376, 8748255, 8748254, 8748238, 8747901, 8747896, 8747893, 8747795, 8747792, 8747787, 8747784, 8747348, 8747299, 8747296, 8746890, 8746886, 8746885, 8746756, 8746755, 8746753, 8746750, 8746749, 8746020, 8745839, 8745837, 8745835, 8745831, 8745829, 8745563, 8745334, 8745333, 8745330, 8745169, 8745163, 8745127, 8745125, 8744635, 8744595, 8744592, 8744591, 8744590, 8744439, 8744438, 8744435, 8743724, 8743717, 8743715, 8743713, 8743711, 8743188, 8742444, 8742360, 8742355, 8742353, 8742229, 8742226, 8742224, 8742222, 8742221, 8741699, 8741696, 8741695, 8741693, 8741678, 8741672, 8741661, 8741544, 8741542, 8741541, 8740610, 8740609, 8740608, 8740606, 8740605, 8739729, 8739727, 8739725, 8739255, 8739254, 8739252, 8739248, 8739246, 8738850, 8738849, 8738847, 8738707, 8738705, 8738704, 8738699, 8738698, 8738578, 8738388, 8738318, 8738317, 8738316, 8738314, 8738313, 8737823, 8737822, 8737821, 8737817, 8737814, 8737488, 8737487, 8737486, 8737317, 8736760, 8736304, 8736303, 8736302, 8736300, 8736298, 8736249, 8736217, 8736134, 8736133, 8736132, 8736131, 8736130, 8735946, 8735945, 8735944, 8735943, 8735942, 8735862, 8735817, 8735730, 8735708, 8735707, 8735706, 8735681, 8735680, 8735679, 8735662, 8735660, 8735549, 8735324, 8735323, 8735322, 8735318, 8735315, 8735313, 8735312, 8735311, 8734789, 8734787, 8734786, 8734696, 8734692, 8734690, 8734687, 8734683, 8734502, 8734493, 8734371, 8734313, 8734278, 8734276, 8734272, 8734113, 8734109, 8734108, 8734106, 8734103, 8733615, 8733614, 8733613, 8733432, 8733431, 8733413, 8733409, 8733407, 8733401, 8733395, 8733392, 8733101, 8733100, 8733099, 8732941, 8732722, 8732721, 8732718, 8732715, 8732714, 8732246, 8732244, 8732243, 8732229, 8732228, 8732226, 8732224, 8732221, 8732174, 8731458, 8731190, 8731183, 8731180, 8731178, 8731163, 8731154, 8731151, 8731148, 8731067, 8730899, 8730634, 8730303, 8730299, 8730296, 8730120, 8730057, 8730056, 8730054, 8729541, 8729537, 8729307, 8729301, 8729292, 8729031, 8729030, 8729028, 8729027, 8729026, 8728334, 8728292, 8728083, 8728081, 8728080, 8728079, 8728076, 8728075, 8727931, 8727497, 8727489, 8727488, 8727485, 8727468, 8727458, 8727457, 8727455, 8727265, 8726841, 8726834, 8726830, 8726829, 8726729, 8726726, 8726722, 8726717, 8726715, 8726133, 8725610, 8725599, 8725571, 8725568, 8725567, 8725564, 8725241, 8725209, 8725124, 8724967, 8724818, 8724817, 8724815, 8724800, 8724789, 8724786, 8724784, 8724702, 8724686, 8724327, 8724042, 8724039, 8724038, 8724036, 8723966, 8723961, 8723958, 8723948, 8723944, 8723940, 8723823, 8723647, 8723643, 8723570, 8723199, 8723126, 8722856, 8722620, 8722565, 8722564, 8722563, 8722551, 8722543, 8722532, 8722362, 8722167, 8721962, 8721946, 8721563, 8721560, 8721557, 8721547, 8721536, 8721200, 8720720, 8720719, 8720715, 8720672, 8720671, 8720665, 8720662, 8720658, 8720652, 8720387, 8720278, 8720128, 8719781, 8719780, 8719776, 8719713, 8719708, 8719681, 8719619, 8719612, 8719597, 8719591, 8719316, 8718950, 8718949, 8718942, 8718847, 8718601, 8718581, 8718578, 8718574, 8718377, 8718336, 8718316, 8717848, 8717747, 8717577, 8717576, 8717485, 8717482, 8717475, 8717291, 8717272, 8717270, 8717268, 8717267, 8717266, 8717262, 8717261, 8717235, 8717229, 8717182, 8717063, 8716440, 8716438, 8716430, 8716387, 8716168, 8716112, 8716110, 8716105, 8715325, 8715236, 8715161, 8715159, 8715154, 8715149, 8715040, 8715004, 8714960, 8714934, 8714932, 8714931, 8714930, 8714747, 8714326, 8714256, 8714207, 8714205, 8714198, 8714183, 8714181, 8714178, 8714177, 8713582, 8713400, 8713394, 8713391, 8713090, 8713089, 8712637, 8711640, 8711554, 8711069, 8710749, 8709897, 8709891, 8709888, 8709880, 8709526, 8709422, 8709385, 8709384, 8708873, 8707999, 8707380, 8707160, 8707153, 8707147, 8707109, 8706923, 8706260, 8706125, 8705697, 8705691, 8705681, 8705630, 8705629, 8705628, 8705517, 8705390, 8705380, 8705065, 8704049, 8703972, 8703951, 8703948, 8703410, 8702647, 8701188, 8701172, 8701170, 8700969, 8700735, 8700015, 8699161, 8698501, 8698209, 8698136, 8698016, 8698003, 8697075, 8696481, 8695983, 8695981, 8695959, 8695779, 8695277, 8695155, 8695138, 8695009, 8693920, 8693127, 8693117, 8693110, 8692207, 8691935, 8691922, 8691908, 8691778, 8691544, 8691074, 8690841, 8689937, 8689814, 8688693, 8688671, 8688116, 8687567, 8687347, 8687135, 8686934, 8686835, 8686833, 8686775, 8686259, 8686225, 8685267, 8685264, 8685182, 8683866, 8683568, 8683285, 8683206, 8682534, 8682520, 8681671, 8681303, 8680958, 8680855, 8679996, 8679338, 8678596, 8677905, 8677673, 8677371, 8677247, 8677244, 8676407, 8676282, 8675798, 8674874, 8674134, 8673718, 8672953, 8671861, 8671824, 8671601, 8671383, 8670161, 8669256, 8668800, 8668761, 8668453, 8668016, 8667959, 8667722, 8667499, 8666799, 8666624, 8666230, 8665056, 8664533, 8664530, 8664302, 8663830, 8662994, 8662224, 8661722, 8661552, 8660150, 8660148, 8659545, 8659403, 8659124, 8659097, 8658393, 8657396, 8656892, 8656887, 8655668, 8654891, 8654815, 8654771, 8652793, 8652363, 8652353, 8650250, 8649495, 8648228, 8648110, 8647476, 8647147, 8646658, 8645700, 8645115, 8644530, 8644490, 8644054, 8641973, 8641327, 8640385, 8639928, 8639586, 8639437, 8639416, 8639366, 8638554, 8636984, 8636752, 8634810, 8634239, 8634176, 8634159, 8633971, 8633809, 8633500, 8633374, 8632322, 8632164, 8630612, 8629633, 8629310, 8629114, 8627853, 8627517, 8627515, 8627104, 8625824, 8624682, 8624247, 8622619, 8619281, 8619264, 8618670, 8618593, 8617948, 8617099, 8616924, 8616492, 8615668, 8615518, 8614898, 8614610, 8614595, 8613839, 8612693, 8612692, 8612690, 8612689, 8612685, 8612040, 8611990, 8611986, 8611962, 8610358, 8610345, 8610118, 8609344, 8609103, 8609102, 8608667, 8608230, 8607369, 8606333, 8605382, 8605209, 8604741, 8604368, 8603733, 8603346, 8602851, 8602302, 8601651, 8600827, 8600350, 8600343, 8592007, 8591355, 8590899, 8590729, 8589557, 8587709, 8586756, 8584386, 8583488, 8583477, 8580976, 8578767, 8577182, 8576561, 8576263, 8575125, 8574875, 8574228, 8573138, 8571429, 8570837, 8569207, 8568443, 8568396, 8568348, 8568137, 8568016, 8568015, 8567386, 8566974, 8566972, 8565438, 8564726, 8564609, 8564218, 8564171, 8564170, 8564169, 8564168, 8562956, 8561899, 8561785, 8561779, 8561676, 8561521, 8560947, 8560239, 8559316, 8558841, 8558143, 8557621, 8557238, 8557090, 8556781, 8551329, 8549235, 8549077, 8546647, 8546646, 8546341, 8545899, 8545409, 8544879, 8543846, 8542314, 8542310, 8540835, 8539933, 8539625, 8536671, 8536670, 8536535, 8536275, 8536237, 8535973, 8535593, 8534009, 8533774, 8533440, 8533076, 8532933, 8532283, 8530066, 8529418, 8529417, 8529086, 8527470, 8527159, 8526821, 8525136, 8525135, 8524845, 8523911, 8523396, 8523269, 8523026, 8522017, 8514596, 8509328, 8505030, 8500462, 8499623, 8490509, 8487740, 8485705, 8474036, 8472890, 8469644, 8468797, 8467593, 8458634, 8458544, 8446473, 8441077, 8440787, 8434659, 8430791, 8422854, 8417381, 8416907, 8416001, 8415739, 8413375, 8401020, 8392296, 8391274, 8378336, 8374995, 8374618, 8374035, 8372304, 8372156, 8367741, 8362658, 8362285, 8362088, 8357944, 8356560, 8336958, 8288213, 7130664, 6993909)
Run Time: 0.059685
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 2357 | |
PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 2357 | |
DERIVED | | | | | | | | No tables used |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["tinhte_xentag_forum",22],["thread",9580550],["thread",9478169],["thread",9439570],["thread",9436408],["thread",9435764],["thread",9405236],["thread",9385922],["thread",9383574],["thread",9379754],["thread",9327922],["thread",9314674],["thread",9281501],["thread",9277278],["thread",9269451],["thread",9268378],["thread",9259551],["thread",9252833],["thread",9252385],["thread",9248535],["thread",9248241],["thread",9241941],["thread",9219542],["thread",9219260],["thread",9198426],["thread",9194422],["thread",9190045],["thread",9184554],["thread",9182042],["thread",9157411],["thread",9152675],["thread",9150220],["thread",9146946],["thread",9145993],["thread",9130548],["thread",9122797],["thread",9118350],["thread",9117472],["thread",9104265],["thread",9093885],["thread",9093434],["thread",9090224],["thread",9089360],["thread",9088942],["thread",9083489],["thread",9074420],["thread",9068494],["thread",9067425],["thread",9066786],["thread",9063126],["thread",9058090],["thread",9050566],["thread",9048919],["thread",9047585],["thread",9043707],["thread",9023036],["thread",9020107],["thread",9007287],["thread",9006200],["thread",9005626],["thread",9005595],["thread",9005132],["thread",8999653],["thread",8998432],["thread",8984428],["thread",8974372],["thread",8957587],["thread",8957413],["thread",8957276],["thread",8953648],["thread",8952098],["thread",8945523],["thread",8942383],["thread",8930636],["thread",8913968],["thread",8912982],["thread",8911053],["thread",8910323],["thread",8910144],["thread",8907458],["thread",8900753],["thread",8893169],["thread",8889776],["thread",8886721],["thread",8885725],["thread",8885717],["thread",8883820],["thread",8874711],["thread",8869777],["thread",8868985],["thread",8868461],["thread",8866224],["thread",8864711],["thread",8859690],["thread",8856066],["thread",8855992],["thread",8855919],["thread",8854737],["thread",8853656],["thread",8850754],["thread",8849297],["thread",8845175],["thread",8843942],["thread",8842402],["thread",8841433],["thread",8840539],["thread",8837639],["thread",8835474],["thread",8834560],["thread",8832761],["thread",8831654],["thread",8830120],["thread",8829748],["thread",8826448],["thread",8825461],["thread",8824477],["thread",8819398],["thread",8816067],["thread",8815277],["thread",8814966],["thread",8814695],["thread",8809781],["thread",8809253],["thread",8807170],["thread",8804849],["thread",8804784],["thread",8801965],["thread",8797301],["thread",8795539],["thread",8794486],["thread",8794090],["thread",8793316],["thread",8792826],["thread",8788192],["thread",8786899],["thread",8778071],["thread",8777932],["thread",8777595],["thread",8776621],["thread",8775881],["thread",8772647],["thread",8769319],["thread",8768675],["thread",8766311],["thread",8766275],["thread",8765782],["thread",8765301],["thread",8763816],["thread",8759778],["thread",8758243],["thread",8751141],["thread",8748238],["thread",8738578],["thread",8736760],["thread",8735730],["thread",8734493],["thread",8733432],["thread",8730899],["thread",8730120],["thread",8727931],["thread",8726133],["thread",8723199],["thread",8718336],["thread",8717291],["thread",8717268],["thread",8716387],["thread",8713090],["thread",8709888],["thread",8708873],["thread",8707380],["thread",8707109],["thread",8706923],["thread",8706260],["thread",8705630],["thread",8705517],["thread",8705380],["thread",8703410],["thread",8702647],["thread",8700735],["thread",8700015],["thread",8698501],["thread",8698136],["thread",8696481],["thread",8695779],["thread",8695277],["thread",8695138],["thread",8692207],["thread",8691935],["thread",8687567],["thread",8687135],["thread",8686934],["thread",8686775],["thread",8682534],["thread",8682520],["thread",8680958],["thread",8679996],["thread",8679338],["thread",8668761],["thread",8668453],["thread",8667959],["thread",8666799],["thread",8666624],["thread",8664533],["thread",8663830],["thread",8662224],["thread",8661552],["thread",8660150],["thread",8659545],["thread",8658393],["thread",8657396],["thread",8655668],["thread",8652793],["thread",8650250],["thread",8648110],["thread",8646658],["thread",8644490],["thread",8644054],["thread",8641973],["thread",8640385],["thread",8634810],["thread",8630612],["thread",8627853],["thread",8618593],["thread",8617948],["thread",8615668],["thread",8614898],["thread",8612693],["thread",8610358],["thread",8610345],["thread",8609103],["thread",8607369],["thread",8605382],["thread",8604741],["thread",8604368],["thread",8603346],["thread",8602851],["thread",8602302],["thread",8601651],["thread",8600350],["thread",8600343],["thread",8592007],["thread",8590899],["thread",8590729],["thread",8589557],["thread",8586756],["thread",8583488],["thread",8580976],["thread",8573138],["thread",8571429],["thread",8570837],["thread",8568443],["thread",8568348],["thread",8568137],["thread",8568016],["thread",8567386],["thread",8564726],["thread",8564609],["thread",8564171],["thread",8562956],["thread",8561779],["thread",8560239],["thread",8558841],["thread",8557621],["thread",8557238],["thread",8556781],["thread",8549235],["thread",8549077],["thread",8545899],["thread",8536535],["thread",8536275],["thread",8536237],["thread",8535973],["thread",8533440],["thread",8530066],["thread",8527470],["thread",8526821],["thread",8524845],["thread",8523911],["thread",8523396],["thread",8523269],["thread",8523026],["thread",8522017],["thread",8514596],["thread",8505030],["thread",8499623],["thread",8485705],["thread",8474036],["thread",8472890],["thread",8469644],["thread",8468797],["thread",8458544],["thread",8441077],["thread",8440787],["thread",8434659],["thread",8430791],["thread",8422854],["thread",8416907],["thread",8416001],["thread",8413375],["thread",8392296],["thread",8391274],["thread",8378336],["thread",8374995],["thread",8374618],["thread",8374035],["thread",8372304],["thread",8372156],["thread",8367741],["thread",8362658],["thread",8362088],["thread",8357944],["thread",8288213],["thread",7130664],["thread",6993909]], 314, tinhte_xentag_tag, , {"tags":["samsung galaxy s7"]}, date, 0, , [], 0, 1652976631, 802026a1c1c6a0c5b3b4198219c4f9c0
Run Time: 0.000858