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 (9604616, 9603212, 9602752, 9602440, 9602439, 9602438, 9602437, 9602436, 9602435, 9602428, 9597271, 9581611, 9574425, 9573532, 9572449, 9571394, 9571131, 9567713, 9563694, 9563681, 9561372, 9561344, 9561078, 9560580, 9560577, 9552168, 9552167, 9551772, 9520187, 9514893, 9514892, 9496813, 9496810, 9496714, 9495131, 9486085, 9460172, 9460171, 9460165, 9460164, 9454261, 9453368, 9453362, 9451917, 9451741, 9451589, 9451416, 9449454, 9441738, 9437881, 9423027, 9422592, 9422309, 9412605, 9410526, 9409691, 9409690, 9405148, 9393534, 9388546, 9388545, 9388544, 9388543, 9384954, 9378980, 9377895, 9370995, 9370936, 9364871, 9361874, 9361873, 9361872, 9352435, 9344850, 9338589, 9319735, 9318245, 9311932, 9304378, 9303418, 9300316, 9300311, 9300037, 9298424, 9294204, 9292082, 9292072, 9286312, 9286085, 9286045, 9285191, 9284459, 9279266, 9276814, 9267521, 9260245, 9257538, 9248157, 9235641, 9233813, 9231302, 9231301, 9226803, 9224741, 9222534, 9220957, 9220588, 9220495, 9220438, 9216250, 9211401, 9210768, 9203258, 9193078, 9192686, 9192098, 9192097, 9189595, 9189277, 9184432, 9183274, 9183259, 9177119, 9169433, 9161052, 9160068, 9150689, 9150028, 9147693, 9145317, 9144732, 9143475, 9140986, 9140267, 9136498, 9130833, 9129576, 9125318, 9121804, 9115030, 9111172, 9111171, 9107902, 9106776, 9106769, 9104452, 9090410, 9089108, 9088506, 9086345, 9077155, 9069797, 9069796, 9067518, 9060766, 9060611, 9060610, 9054753, 9054599, 9050066, 9048256, 9046557, 9046352, 9041488, 9039584, 9039583, 9034465, 9029850, 9028103, 9026891, 9025101, 9022221, 9019351, 9018858, 9017509, 9017507, 9009704, 9009664, 9009663, 9004356, 9002181, 8997011, 8993782, 8991685, 8991683, 8986333, 8986331, 8982453, 8976816, 8975460, 8975459, 8974082, 8969048, 8963201, 8961856, 8961855, 8961853, 8961852, 8961851, 8960610, 8956385, 8956384, 8956383, 8956382, 8956381, 8955602, 8953113, 8949086, 8944439, 8944437, 8943074, 8943071, 8939965, 8939133, 8935136, 8933963, 8932688, 8930589, 8929281, 8925009, 8924082, 8921866, 8921851, 8921814, 8918162, 8918121, 8918029, 8918028, 8917246, 8916635, 8916154, 8915702, 8915667, 8915552, 8909439, 8908426, 8906263, 8906246, 8903097, 8902753, 8902690, 8902680, 8902599, 8901487, 8901486, 8901485, 8898555, 8896179, 8895513, 8894629, 8894490, 8893201, 8892587, 8892428, 8892426, 8892414, 8892407, 8890961, 8890556, 8890301, 8890299, 8889678, 8888565, 8887542, 8887254, 8886553, 8886437, 8886127, 8885281, 8885033, 8885031, 8885030, 8885029, 8885020, 8885016, 8884740, 8884739, 8884729, 8883442, 8882958, 8882758, 8882739, 8882719, 8882533, 8882354, 8882289, 8881700, 8880932, 8880586, 8880569, 8880534, 8880533, 8880063, 8880062, 8879809, 8879416, 8879085, 8878905, 8878241, 8877709, 8877457, 8877168, 8877167, 8876467, 8876439, 8876276, 8876045, 8875488, 8875150, 8873682, 8871810, 8871069, 8870196, 8869930, 8869503, 8868623, 8868617, 8868454, 8867840, 8867324, 8866438, 8865522, 8864023, 8862626, 8861562, 8861561, 8861386, 8860218, 8855980, 8855491, 8855252, 8853932, 8853849, 8853440, 8853439, 8852332, 8852330, 8851736, 8850269, 8847402, 8846978, 8846977, 8846273, 8845896, 8845764, 8845100, 8842533, 8842425, 8841458, 8841053, 8841001, 8840170, 8838987, 8838682, 8836923, 8836712, 8835536, 8834542, 8833821, 8833324, 8832805, 8831906, 8831114, 8830922, 8830560, 8830226, 8830075, 8829785, 8829450, 8829310, 8829301, 8829279, 8829075, 8827001, 8826284, 8826283, 8826281, 8825702, 8821757, 8817227, 8815400, 8813730, 8813728, 8812052, 8811814, 8811193, 8811191, 8811188, 8809932, 8808962, 8808960, 8808954, 8808953, 8808951, 8808950, 8808520, 8808512, 8808511, 8807785, 8806966, 8806965, 8806964, 8806470, 8805288, 8804126, 8803184, 8803182, 8799146, 8798657, 8798046, 8797711, 8797532, 8797176, 8796425, 8792809, 8791308, 8791122, 8790825, 8789089, 8788936, 8788912, 8788665, 8788007, 8787447, 8787142, 8786288, 8785409, 8785407, 8784651, 8784650, 8784649, 8781202, 8781183, 8780473, 8780444, 8780312, 8780311, 8779877, 8776545, 8776115, 8775174, 8774538, 8771236, 8771235, 8770946, 8769728, 8769200, 8768207, 8768206, 8767119, 8766896, 8766655, 8765623, 8763857, 8762845, 8762276, 8762245, 8762090, 8761997, 8758336, 8758335, 8757768, 8757591, 8756562, 8755098, 8753366, 8752669, 8751412, 8751280, 8751159, 8751149, 8751102, 8751078, 8748463, 8747477, 8746687, 8744493, 8744492, 8744491, 8744214, 8744208, 8744194, 8743970, 8743055, 8742597, 8741051, 8739012, 8738433, 8738273, 8738040, 8736689, 8736681, 8735886, 8731795, 8731793, 8730471, 8726965, 8726071, 8725897, 8724519, 8724122, 8723523, 8723354, 8722921, 8722531, 8721682, 8721616, 8721614, 8721128, 8720134, 8719895, 8717414, 8717120, 8716953, 8716951, 8716844, 8715555, 8715471, 8714970, 8714818, 8714807, 8714657, 8714655, 8714015, 8713580, 8712288, 8712287, 8710847, 8710422, 8710364, 8708869, 8707640, 8707150, 8706388, 8706292, 8706035, 8706034, 8705685, 8705538, 8705166, 8704696, 8703495, 8703176, 8702923, 8702869, 8701905, 8701831, 8701473, 8701184, 8699789, 8699610, 8697810, 8697177, 8696541, 8695995, 8695988, 8694375, 8694143, 8693898, 8693134, 8693121, 8690250, 8689848, 8689544, 8689505, 8688824, 8688315, 8687463, 8687199, 8687140, 8686710, 8686709, 8685455, 8685025, 8684344, 8684335, 8683555, 8683139, 8683112, 8683105, 8680275, 8680272, 8680231, 8678650, 8678439, 8678438, 8678315, 8677383, 8676947, 8676946, 8676941, 8675739, 8675681, 8674472, 8673653, 8673534, 8672587, 8672288, 8670360, 8669797, 8669215, 8668506, 8668498, 8668399, 8668013, 8667346, 8667313, 8666784, 8665874, 8664936, 8664721, 8664322, 8661482, 8661359, 8661149, 8660220, 8660085, 8660075, 8659093, 8657666, 8657365, 8655631, 8654498, 8654327, 8654232, 8654169, 8653842, 8653156, 8652961, 8652364, 8652239, 8651781, 8650539, 8650149, 8650133, 8650082, 8648519, 8648412, 8647438, 8646126, 8645924, 8645431, 8645167, 8644794, 8644593, 8644267, 8644175, 8643270, 8643240, 8641373, 8640737, 8639780, 8639749, 8639747, 8639745, 8638321, 8636714, 8636690, 8634906, 8634243, 8634032, 8632805, 8632618, 8631854, 8631853, 8631821, 8631820, 8631819, 8630746, 8630640, 8629629, 8628338, 8626469, 8622119, 8620605, 8618841, 8617497, 8615686, 8614914, 8614171, 8612708, 8612688, 8612659, 8612233, 8612184, 8612182, 8612181, 8611618, 8611356, 8611242, 8611224, 8609131, 8609125, 8605917, 8603866, 8602250, 8602208, 8601013, 8600339, 8599545, 8599471, 8598956, 8598658, 8598656, 8595440, 8594895, 8594022, 8593526, 8591737, 8591117, 8590992, 8590914, 8590097, 8589306, 8589231, 8589223, 8588010, 8587887, 8586752, 8586465, 8586382, 8585883, 8584457, 8583533, 8583453, 8583056, 8582612, 8580262, 8579746, 8579647, 8579469, 8579239, 8579033, 8579021, 8578984, 8578373, 8578370, 8578344, 8577558, 8577174, 8575881, 8575880, 8574480, 8574398, 8574236, 8573540, 8572202, 8567236, 8565767, 8562804, 8562796, 8562265, 8558995, 8558406, 8551500, 8550955, 8550273, 8548920, 8546819, 8546384, 8545184, 8544604, 8543881, 8543863, 8537041, 8535913, 8535419, 8534376, 8534375, 8534374, 8533859, 8533858, 8531707, 8531468, 8528969, 8525959, 8524613, 8524609, 8521973, 8521971, 8521920, 8521391, 8507731, 8507419, 8501363, 8493221, 8484453, 8483236, 8478659, 8476451, 8472842, 8470454, 8466297, 8460133, 8457749, 8454721, 8454339, 8451362, 8451075, 8448136, 8447927, 8447389, 8444615, 8440610, 8439041, 8435637, 8435348, 8432937, 8432110, 8424321, 8424079, 8419844, 8417171, 8415867, 8407824, 8400014, 8384692, 8376680, 8339665, 8338897, 8338812, 8337864, 8328936, 8328932, 8328539, 8327817, 8327110, 8326921, 8324534, 8323484, 8321072, 8320789, 8318923, 8316242, 8314147, 8313493, 8312602, 8311857, 8309123, 8308959, 8304709, 8303952, 8300245, 8299133, 8298231, 8297575, 8296680, 8295420, 8292358, 8290580, 8290430, 8287710, 8281381, 8280187, 8276807, 8275676, 8275058, 8272383, 8272378, 8267595, 8266356, 8265154, 8263895, 8260962, 8258404, 8258190, 8258170, 8258147, 8257549, 8242095, 8242094, 8221990, 8187488, 8148956, 8125727, 7982332, 6794700, 3918371, 3874940, 3519463, 2720765, 1938725, 1563002, 1561182)
Run Time: 0.024223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 884 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
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",43],["thread",9602437],["thread",9602436],["thread",9602435],["thread",9602428],["thread",9552168],["thread",9495131],["thread",9486085],["thread",9460172],["thread",9449454],["thread",9441738],["thread",9437881],["thread",9393534],["thread",9361874],["thread",9303418],["thread",9248157],["thread",9233813],["thread",9231302],["thread",9210768],["thread",9160068],["thread",9143475],["thread",9140986],["thread",9125318],["thread",9111172],["thread",9090410],["thread",9088506],["thread",9067518],["thread",9054753],["thread",9054599],["thread",9048256],["thread",9034465],["thread",9025101],["thread",9018858],["thread",9017509],["thread",9009664],["thread",9004356],["thread",9002181],["thread",8982453],["thread",8976816],["thread",8974082],["thread",8969048],["thread",8963201],["thread",8961856],["thread",8953113],["thread",8949086],["thread",8933963],["thread",8932688],["thread",8921866],["thread",8918121],["thread",8917246],["thread",8916635],["thread",8915702],["thread",8915667],["thread",8915552],["thread",8895513],["thread",8893201],["thread",8890961],["thread",8889678],["thread",8888565],["thread",8886437],["thread",8886127],["thread",8885016],["thread",8882958],["thread",8882289],["thread",8880063],["thread",8878905],["thread",8876439],["thread",8871810],["thread",8871069],["thread",8867324],["thread",8866438],["thread",8865522],["thread",8862626],["thread",8855980],["thread",8855252],["thread",8845896],["thread",8845764],["thread",8838987],["thread",8835536],["thread",8834542],["thread",8833821],["thread",8832805],["thread",8831906],["thread",8830560],["thread",8829075],["thread",8817227],["thread",8806966],["thread",8798046],["thread",8797711],["thread",8797176],["thread",8791122],["thread",8788936],["thread",8788912],["thread",8786288],["thread",8781202],["thread",8780312],["thread",8779877],["thread",8769200],["thread",8768206],["thread",8763857],["thread",8757591],["thread",8755098],["thread",8753366],["thread",8751280],["thread",8751149],["thread",8751102],["thread",8751078],["thread",8748463],["thread",8747477],["thread",8746687],["thread",8744194],["thread",8742597],["thread",8741051],["thread",8738040],["thread",8730471],["thread",8723523],["thread",8722531],["thread",8713580],["thread",8710847],["thread",8706292],["thread",8706035],["thread",8704696],["thread",8703176],["thread",8702923],["thread",8702869],["thread",8701905],["thread",8697810],["thread",8697177],["thread",8695995],["thread",8693898],["thread",8689848],["thread",8688824],["thread",8687463],["thread",8687199],["thread",8685455],["thread",8683139],["thread",8683112],["thread",8678439],["thread",8678315],["thread",8676947],["thread",8673534],["thread",8672288],["thread",8670360],["thread",8668399],["thread",8659093],["thread",8654498],["thread",8654327],["thread",8654232],["thread",8652364],["thread",8652239],["thread",8651781],["thread",8650082],["thread",8648519],["thread",8647438],["thread",8645431],["thread",8645167],["thread",8644593],["thread",8644267],["thread",8643240],["thread",8641373],["thread",8636714],["thread",8628338],["thread",8622119],["thread",8618841],["thread",8615686],["thread",8612233],["thread",8612184],["thread",8611242],["thread",8603866],["thread",8600339],["thread",8599545],["thread",8598956],["thread",8598658],["thread",8595440],["thread",8591737],["thread",8590914],["thread",8590097],["thread",8589306],["thread",8587887],["thread",8586465],["thread",8584457],["thread",8583453],["thread",8583056],["thread",8580262],["thread",8579647],["thread",8579469],["thread",8578984],["thread",8577558],["thread",8577174],["thread",8575881],["thread",8574398],["thread",8562804],["thread",8562796],["thread",8558995],["thread",8558406],["thread",8550955],["thread",8546819],["thread",8546384],["thread",8543881],["thread",8543863],["thread",8537041],["thread",8535419],["thread",8534376],["thread",8531707],["thread",8528969],["thread",8525959],["thread",8524613],["thread",8507419],["thread",8493221],["thread",8484453],["thread",8483236],["thread",8478659],["thread",8476451],["thread",8472842],["thread",8470454],["thread",8466297],["thread",8460133],["thread",8457749],["thread",8454721],["thread",8451362],["thread",8451075],["thread",8447927],["thread",8444615],["thread",8440610],["thread",8439041],["thread",8435637],["thread",8435348],["thread",8432937],["thread",8432110],["thread",8424321],["thread",8424079],["thread",8419844],["thread",8417171],["thread",8415867],["thread",8400014],["thread",8384692],["thread",8376680],["thread",8339665],["thread",8338897],["thread",8338812],["thread",8337864],["thread",8328936],["thread",8328932],["thread",8328539],["thread",8327817],["thread",8327110],["thread",8324534],["thread",8323484],["thread",8321072],["thread",8320789],["thread",8318923],["thread",8313493],["thread",8312602],["thread",8311857],["thread",8309123],["thread",8308959],["thread",8304709],["thread",8303952],["thread",8300245],["thread",8299133],["thread",8298231],["thread",8297575],["thread",8296680],["thread",8295420],["thread",8292358],["thread",8290580],["thread",8290430],["thread",8287710],["thread",8281381],["thread",8280187],["thread",8276807],["thread",8275676],["thread",8275058],["thread",8272383],["thread",8272378],["thread",8267595],["thread",8266356],["thread",8265154],["thread",8263895],["thread",8258404],["thread",8258190],["thread",8258170],["thread",8258147],["thread",8257549],["thread",8148956],["thread",8125727],["thread",7982332],["thread",1938725]], 288, tinhte_xentag_tag, , {"tags":["vespa lx"]}, date, 0, , [], 0, 1656113920, 60ad946a6dff68cbbf010b4f7fd05464
Run Time: 0.005213