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 (9676754, 9655556, 9648073, 9644157, 9643725, 9641583, 9641038, 9627424, 9621196, 9615285, 9615282, 9609098, 9608880, 9607605, 9607604, 9607603, 9607602, 9601228, 9575094, 9572318, 9572317, 9568746, 9568745, 9567933, 9562081, 9555344, 9555310, 9555302, 9555182, 9555178, 9555172, 9555169, 9555162, 9555125, 9555115, 9555104, 9555081, 9543749, 9540167, 9540165, 9533742, 9530912, 9530224, 9530208, 9524182, 9522343, 9521455, 9521016, 9518186, 9518184, 9518183, 9518181, 9514554, 9512623, 9512622, 9512621, 9506497, 9506496, 9506495, 9506493, 9489536, 9488393, 9488222, 9488221, 9482026, 9481778, 9472865, 9470687, 9470230, 9470227, 9467367, 9459311, 9459056, 9459018, 9458016, 9442020, 9433005, 9427489, 9422594, 9419659, 9419651, 9419424, 9419388, 9417914, 9417913, 9417912, 9412747, 9412547, 9409649, 9399305, 9394033, 9394032, 9390924, 9387888, 9385457, 9381004, 9377344, 9377343, 9376492, 9376013, 9374413, 9374412, 9365088, 9362782, 9362777, 9362484, 9362479, 9362475, 9362471, 9362468, 9362462, 9362457, 9362451, 9362447, 9362442, 9362434, 9362427, 9362423, 9362420, 9362415, 9362411, 9362405, 9362397, 9362393, 9362377, 9362372, 9361780, 9361520, 9361519, 9361515, 9361514, 9361512, 9361511, 9361508, 9361507, 9361506, 9361505, 9361501, 9361499, 9361498, 9361497, 9361494, 9361493, 9361492, 9361491, 9361483, 9361462, 9361459, 9361456, 9361455, 9361454, 9361452, 9361450, 9361447, 9361444, 9361443, 9361438, 9361436, 9361432, 9361429, 9361421, 9361417, 9361414, 9361409, 9361405, 9361404, 9361402, 9361401, 9361399, 9361368, 9361364, 9361358, 9360627, 9359594, 9359593, 9358948, 9358945, 9358051, 9358050, 9357669, 9357657, 9357655, 9357494, 9356877, 9356842, 9355611, 9348384, 9346577, 9342421, 9341563, 9341562, 9339884, 9339214, 9336756, 9329115, 9324193, 9323028, 9322372, 9317168, 9315638, 9315637, 9314452, 9314451, 9314040, 9307759, 9307748, 9307726, 9306243, 9306242, 9299134, 9299133, 9299132, 9299131, 9294646, 9290760, 9290759, 9289346, 9284992, 9283397, 9283396, 9282100, 9281644, 9280741, 9277523, 9277522, 9275970, 9273536, 9271273, 9270487, 9266138, 9265786, 9253669, 9252109, 9251585, 9251528, 9251071, 9251006, 9244284, 9240862, 9239597, 9237761, 9237050, 9237048, 9237046, 9236262, 9236260, 9236259, 9236258, 9235634, 9232930, 9232628, 9226376, 9225071, 9224530, 9223393, 9220091, 9219253, 9218039, 9218038, 9217715, 9211861, 9208818, 9204323, 9203470, 9202413, 9201719, 9201382, 9201381, 9200700, 9200699, 9198817, 9197534, 9197180, 9196294, 9195680, 9192948, 9192502, 9192475, 9192372, 9192273, 9181571, 9181168, 9181167, 9179355, 9179354, 9179353, 9178618, 9178617, 9177611, 9172175, 9171243, 9166160, 9166154, 9163264, 9163263, 9163262, 9161325, 9158002, 9158001, 9158000, 9157995, 9157979, 9148720, 9148466, 9148465, 9146548, 9145007, 9143626, 9143625, 9142283, 9140639, 9131750, 9125116, 9123333, 9119461, 9119459, 9113474, 9105870, 9101639, 9098528, 9098163, 9087415, 9087271, 9082398, 9082077, 9079677, 9079139, 9078930, 9077736, 9074956, 9072703, 9070978, 9069114, 9069070, 9062415, 9054766, 9054765, 9054762, 9054759, 9053931, 9050872, 9050871, 9050870, 9046536, 9044209, 9044208, 9041911, 9041035, 9041033, 9037843, 9037305, 9037161, 9036765, 9036764, 9032471, 9032470, 9032469, 9031391, 9031241, 9025668, 9023015, 9021501, 9021364, 9018088, 9018087, 9012251, 9012250, 9011733, 9011694, 9010901, 9010900, 8998445, 8998426, 8996190, 8993760, 8988709, 8981764, 8977772, 8976133, 8974938, 8965974, 8965973, 8964886, 8961727, 8956629, 8947853, 8945157, 8944326, 8943748, 8942399, 8937157, 8937156, 8937155, 8936680, 8933481, 8932851, 8930213, 8928560, 8926376, 8925275, 8924536, 8916086, 8915219, 8911914, 8911402, 8911089, 8910153, 8908701, 8907811, 8906865, 8905933, 8904745, 8903817, 8901262, 8898534, 8898533, 8895173, 8895172, 8894689, 8892811, 8892048, 8891538, 8890582, 8890523, 8888305, 8888295, 8888135, 8888134, 8888133, 8888131, 8887491, 8886139, 8881697, 8879780, 8879778, 8876717, 8876716, 8876715, 8876714, 8876712, 8869189, 8863151, 8860933, 8858466, 8855205, 8855204, 8855202, 8855200, 8850710, 8850678, 8849269, 8849268, 8848049, 8843175, 8839980, 8835273, 8833600, 8830773, 8830772, 8824288, 8824281, 8824279, 8822338, 8809418, 8808911, 8803711, 8803709, 8801149, 8801146, 8786752, 8781102, 8781101, 8781099, 8781096, 8780849, 8780848, 8776166, 8772837, 8772361, 8768743, 8763339, 8758273, 8757189, 8756325, 8754475, 8751867, 8751866, 8751255, 8746395, 8746394, 8746259, 8745438, 8744540, 8744279, 8743949, 8743621, 8743620, 8742558, 8734429, 8734121, 8733419, 8723398, 8723397, 8709758, 8687893, 8680751, 8679927, 8674386, 8649004, 8647032, 8628812, 8581505, 8581504, 8571503, 8570204, 8563344, 8563268, 8548674, 8547382, 8538414, 8534385, 8530680, 8524251, 8519978, 8517524, 8508601, 8500503, 8497549, 8497539, 8493201, 8493184, 8483994, 8482707, 8482322, 8461104, 8450963, 8444724, 8425620, 8405290, 8374693, 8340717, 8324164, 8205453, 8170058, 8146503, 8090308, 7598795)
Run Time: 0.010741
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 547 | 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",119],["thread",9648073],["thread",9644157],["thread",9643725],["thread",9615282],["thread",9607605],["thread",9607604],["thread",9607602],["thread",9572318],["thread",9568746],["thread",9555310],["thread",9555302],["thread",9555182],["thread",9555178],["thread",9555172],["thread",9555169],["thread",9555162],["thread",9555125],["thread",9555115],["thread",9555104],["thread",9555081],["thread",9543749],["thread",9533742],["thread",9530912],["thread",9530224],["thread",9530208],["thread",9522343],["thread",9521016],["thread",9506497],["thread",9488393],["thread",9482026],["thread",9472865],["thread",9470687],["thread",9470230],["thread",9470227],["thread",9467367],["thread",9459311],["thread",9458016],["thread",9419659],["thread",9419424],["thread",9419388],["thread",9412747],["thread",9399305],["thread",9381004],["thread",9365088],["thread",9362484],["thread",9362479],["thread",9362475],["thread",9362471],["thread",9362468],["thread",9362462],["thread",9362457],["thread",9362451],["thread",9362447],["thread",9362442],["thread",9362434],["thread",9362427],["thread",9362423],["thread",9362420],["thread",9362415],["thread",9362411],["thread",9362405],["thread",9362397],["thread",9362393],["thread",9362377],["thread",9362372],["thread",9361780],["thread",9360627],["thread",9359594],["thread",9357669],["thread",9357657],["thread",9348384],["thread",9346577],["thread",9342421],["thread",9329115],["thread",9324193],["thread",9323028],["thread",9322372],["thread",9314040],["thread",9307759],["thread",9307748],["thread",9307726],["thread",9306243],["thread",9290760],["thread",9281644],["thread",9275970],["thread",9271273],["thread",9270487],["thread",9266138],["thread",9252109],["thread",9237050],["thread",9226376],["thread",9225071],["thread",9224530],["thread",9223393],["thread",9219253],["thread",9217715],["thread",9211861],["thread",9204323],["thread",9203470],["thread",9198817],["thread",9192475],["thread",9192372],["thread",9192273],["thread",9181571],["thread",9179355],["thread",9177611],["thread",9171243],["thread",9148720],["thread",9148466],["thread",9145007],["thread",9105870],["thread",9098528],["thread",9098163],["thread",9082077],["thread",9079139],["thread",9078930],["thread",9070978],["thread",9069114],["thread",9054766],["thread",9050872],["thread",9046536],["thread",9041911],["thread",9037843],["thread",9031391],["thread",9031241],["thread",9023015],["thread",9021364],["thread",9018088],["thread",9012251],["thread",9012250],["thread",9011733],["thread",9011694],["thread",9010901],["thread",8998426],["thread",8993760],["thread",8976133],["thread",8964886],["thread",8943748],["thread",8942399],["thread",8932851],["thread",8925275],["thread",8911089],["thread",8906865],["thread",8905933],["thread",8903817],["thread",8895173],["thread",8891538],["thread",8890582],["thread",8888305],["thread",8886139],["thread",8881697],["thread",8876716],["thread",8876712],["thread",8869189],["thread",8860933],["thread",8855205],["thread",8848049],["thread",8835273],["thread",8809418],["thread",8801149],["thread",8786752],["thread",8781102],["thread",8772837],["thread",8751867],["thread",8751255],["thread",8746259],["thread",8734429],["thread",8709758],["thread",8687893],["thread",8679927],["thread",8649004],["thread",8647032],["thread",8628812],["thread",8571503],["thread",8570204],["thread",8563344],["thread",8563268],["thread",8548674],["thread",8547382],["thread",8538414],["thread",8534385],["thread",8530680],["thread",8524251],["thread",8519978],["thread",8508601],["thread",8500503],["thread",8497549],["thread",8497539],["thread",8493184],["thread",8483994],["thread",8482707],["thread",8482322],["thread",8461104],["thread",8450963],["thread",8444724],["thread",8405290],["thread",8374693],["thread",8324164],["thread",8170058],["thread",8146503],["thread",8090308]], 202, tinhte_xentag_tag, , {"tags":["n\u1ec7m cao su"]}, date, 0, , [], 0, 1656143299, dbf67b18ec1167420cc0a89e9479d66b
Run Time: 0.000551