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 (9674541, 9665141, 9663501, 9661184, 9659775, 9657689, 9657688, 9656750, 9654894, 9653693, 9651887, 9651790, 9651349, 9651348, 9651347, 9646449, 9644390, 9644389, 9643722, 9643721, 9643720, 9637154, 9634461, 9633278, 9612027, 9610297, 9608986, 9608220, 9598192, 9595977, 9595849, 9586708, 9580529, 9566371, 9566201, 9562919, 9560856, 9557987, 9552656, 9546984, 9546545, 9543882, 9541753, 9541696, 9526682, 9521955, 9519013, 9518980, 9515688, 9514684, 9514408, 9513382, 9513378, 9504580, 9504291, 9499761, 9489667, 9479926, 9473864, 9473863, 9472709, 9467449, 9462614, 9461651, 9461650, 9461649, 9448981, 9446499, 9445841, 9441031, 9434449, 9434041, 9432173, 9431759, 9429101, 9427259, 9427160, 9423689, 9423264, 9422612, 9418781, 9416966, 9416381, 9414710, 9411579, 9408900, 9406524, 9393922, 9392913, 9388265, 9385661, 9382783, 9382222, 9371229, 9371227, 9371226, 9371225, 9369122, 9368042, 9366098, 9366097, 9364929, 9359089, 9356277, 9355033, 9353926, 9348070, 9345413, 9338778, 9331525, 9330674, 9325113, 9323831, 9321610, 9320821, 9320251, 9319188, 9299364, 9297218, 9286914, 9286254, 9284968, 9284967, 9280769, 9280767, 9278602, 9276659, 9275398, 9275397, 9273946, 9267896, 9266684, 9263101, 9259938, 9249156, 9229709, 9229706, 9228445, 9227781, 9223743, 9214752, 9198485, 9197577, 9194815, 9173339, 9172037, 9155225, 9143397, 9133243, 9126136, 9112473, 9098067, 9097754, 9090813, 9088688, 9083994, 9083441, 9081444, 9077049, 9072148, 9071984, 9069995, 9067539, 9067527, 9066654, 9066460, 9065513, 9064759, 9064266, 9062518, 9059648, 9059154, 9058841, 9057911, 9056971, 9056925, 9051694, 9047781, 9047407, 9043748, 9043607, 9039069, 9038213, 9037325, 9036585, 9029786, 9029783, 9025198, 9015897, 9014842, 9012391, 9012358, 9007303, 9003663, 9003627, 8999029, 8991988, 8991807, 8991805, 8987270, 8986594, 8986593, 8976134, 8975185, 8974408, 8971675, 8970372, 8968420, 8967648, 8965706, 8965531, 8961810, 8958900, 8958766, 8957935, 8956755, 8946968, 8945782, 8941637, 8941134, 8939253, 8939250, 8939245, 8939242, 8939186, 8937404, 8935122, 8934622, 8932153, 8931338, 8930285, 8930173, 8929058, 8928997, 8926745, 8923489, 8921755, 8919118, 8916953, 8912153, 8912038, 8910948, 8910091, 8907745, 8906073, 8905355, 8903783, 8898916, 8896937, 8894661, 8894659, 8893440, 8892574, 8891387, 8891084, 8887927, 8886257, 8885909, 8885571, 8884993, 8884992, 8883971, 8883535, 8882679, 8880711, 8880705, 8876495, 8875155, 8874716, 8873686, 8873522, 8865222, 8855578, 8849467, 8845230, 8842926, 8842442, 8840104, 8838525, 8836637, 8835710, 8834915, 8834262, 8832279, 8831854, 8830451, 8828123, 8821396, 8820532, 8817340, 8815059, 8814788, 8812652, 8811092, 8807918, 8804943, 8804096, 8804081, 8802314, 8800179, 8798823, 8797019, 8795546, 8793649, 8793295, 8793003, 8792116, 8791776, 8791167, 8790412, 8789585, 8788699, 8788540, 8788425, 8788186, 8787689, 8787282, 8787280, 8786574, 8784304, 8783767, 8783216, 8783214, 8782002, 8781728, 8781127, 8780722, 8779606, 8778933, 8778472, 8777686, 8777289, 8776595, 8776329, 8775913, 8775880, 8774861, 8774123, 8773498, 8773267, 8771901, 8771824, 8771804, 8771092, 8770892, 8769725, 8768663, 8767580, 8767548, 8765505, 8765485, 8764576, 8764529, 8763531, 8761895, 8758749, 8758734, 8758315, 8757438, 8753737, 8753736, 8752345, 8749056, 8742726, 8742513, 8742503, 8742208, 8740069, 8739668, 8736707, 8735983, 8735155, 8734861, 8734037, 8733820, 8733434, 8732774, 8732541, 8732080, 8731977, 8731743, 8731526, 8731044, 8730347, 8730205, 8730122, 8729476, 8729175, 8728331, 8728092, 8727417, 8727392, 8726766, 8726737, 8726591, 8725698, 8725584, 8725025, 8724990, 8724715, 8724245, 8724068, 8723598, 8722906, 8722693, 8722576, 8721941, 8721910, 8721322, 8721307, 8720945, 8720747, 8720660, 8720609, 8720174, 8719560, 8719085, 8718868, 8718810, 8718584, 8718547, 8717869, 8717560, 8717378, 8716513, 8716481, 8716312, 8716172, 8715342, 8714975, 8714729, 8714616, 8714546, 8714303, 8714165, 8714062, 8713620, 8713618, 8713610, 8713551, 8713446, 8713129, 8713002, 8712833, 8712827, 8712823, 8712820, 8712679, 8712561, 8710899, 8710801, 8710740, 8710492, 8710002, 8710001, 8709704, 8709407, 8709377, 8708657, 8708622, 8708601, 8706885, 8706623, 8706534, 8706497, 8705974, 8705821, 8704616, 8704237, 8703725, 8702849, 8702815, 8702689, 8702596, 8701826, 8701819, 8701644, 8701494, 8701442, 8700703, 8700599, 8700593, 8700398, 8700222, 8699464, 8699225, 8698818, 8698735, 8698570, 8698214, 8697755, 8697745, 8697730, 8697673, 8697524, 8697398, 8697389, 8697251, 8697149, 8697139, 8697007, 8696167, 8696064, 8696001, 8695770, 8695718, 8695666, 8695008, 8694977, 8694960, 8694801, 8694800, 8694644, 8694552, 8693731, 8693696, 8693680, 8693623, 8693605, 8693428, 8693236, 8692710, 8692680, 8692665, 8692620, 8691992, 8691514, 8691470, 8691295, 8691221, 8691196, 8691133, 8690337, 8690014, 8689943, 8689267, 8689247, 8689000, 8688662, 8688263, 8688192, 8688071, 8688064, 8687864, 8687558, 8687410, 8686964, 8686781, 8686693, 8686671, 8686646, 8686565, 8686502, 8686317, 8686109, 8685683, 8685279, 8685222, 8685209, 8685205, 8684898, 8684748, 8683868, 8683858, 8683541, 8683441, 8683051, 8683048, 8682988, 8682977, 8682863, 8682694, 8682574, 8682471, 8682120, 8681951, 8681939, 8681859, 8681689, 8681669, 8681654, 8681616, 8681031, 8680711, 8680610, 8680571, 8680561, 8680430, 8680257, 8680250, 8679752, 8679722, 8679716, 8679562, 8679436, 8679180, 8679058, 8678732, 8678681, 8678680, 8677773, 8677484, 8677241, 8676851, 8676354, 8676351, 8675864, 8675646, 8675593, 8675454, 8675437, 8675377, 8675347, 8675075, 8675056, 8674952, 8674852, 8674398, 8674279, 8673331, 8672927, 8672892, 8672813, 8672398, 8672395, 8667254, 8667095, 8667085, 8665275, 8664269, 8663589, 8663397, 8662543, 8662317, 8661486, 8661047, 8659851, 8659850, 8659575, 8656176, 8653626, 8653217, 8652784, 8652514, 8651203, 8651032, 8648999, 8648838, 8645777, 8642976, 8641341, 8640775, 8639853, 8630001, 8627350, 8623240, 8622302, 8619772, 8609364, 8608918, 8608917, 8606161, 8602132, 8595676, 8595222, 8592913, 8591485, 8589320, 8587612, 8587611, 8568045, 8565252, 8564102, 8561980, 8560891, 8560864, 8560324, 8558012, 8557616, 8547160, 8544219, 8541137, 8540093, 8539207, 8536620, 8533435, 8526059, 8525955, 8522644, 8520726, 8510534, 8504603, 8499207, 8494417, 8492019, 8486788, 8483615, 8480700, 8474478, 8471778, 8463815, 8453052, 8447971, 8441498, 8438031, 8430180, 8414013, 8412680, 8412103, 8411345, 8391502, 8386840, 8385674, 8382236, 8254885, 8070746)
Run Time: 0.023388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 716 | 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",145],["thread",9674541],["thread",9665141],["thread",9661184],["thread",9657689],["thread",9653693],["thread",9634461],["thread",9633278],["thread",9608986],["thread",9608220],["thread",9598192],["thread",9595977],["thread",9580529],["thread",9566201],["thread",9562919],["thread",9557987],["thread",9552656],["thread",9543882],["thread",9541753],["thread",9504580],["thread",9423689],["thread",9423264],["thread",9422612],["thread",9414710],["thread",9406524],["thread",9368042],["thread",9366098],["thread",9345413],["thread",9280769],["thread",9278602],["thread",9263101],["thread",9228445],["thread",9227781],["thread",9223743],["thread",9088688],["thread",9081444],["thread",9064266],["thread",9059648],["thread",9047781],["thread",9043607],["thread",9038213],["thread",9037325],["thread",9014842],["thread",9003663],["thread",8991988],["thread",8991807],["thread",8987270],["thread",8986594],["thread",8976134],["thread",8958900],["thread",8941637],["thread",8932153],["thread",8930285],["thread",8923489],["thread",8921755],["thread",8919118],["thread",8916953],["thread",8907745],["thread",8898916],["thread",8894661],["thread",8893440],["thread",8885909],["thread",8875155],["thread",8873522],["thread",8845230],["thread",8842926],["thread",8821396],["thread",8817340],["thread",8812652],["thread",8807918],["thread",8797019],["thread",8793295],["thread",8783216],["thread",8752345],["thread",8717560],["thread",8705821],["thread",8682120],["thread",8681669],["thread",8680561],["thread",8679722],["thread",8667254],["thread",8661486],["thread",8648838],["thread",8630001],["thread",8619772],["thread",8602132],["thread",8595676],["thread",8592913],["thread",8591485],["thread",8568045],["thread",8565252],["thread",8561980],["thread",8560891],["thread",8558012],["thread",8557616],["thread",8547160],["thread",8541137],["thread",8533435],["thread",8526059],["thread",8525955],["thread",8522644],["thread",8510534],["thread",8504603],["thread",8499207],["thread",8494417],["thread",8492019],["thread",8480700],["thread",8474478],["thread",8471778],["thread",8463815],["thread",8453052],["thread",8441498],["thread",8438031],["thread",8414013],["thread",8412680],["thread",8412103],["thread",8411345],["thread",8386840],["thread",8254885]], 119, tinhte_xentag_tag, , {"tags":["ipad pro 12'9"]}, date, 0, , [], 0, 1652795446, 9bcedc6fa5166d0dd6d30ea079b07c87
Run Time: 0.000863