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 (9695024, 9691796, 9691795, 9681835, 9681634, 9675861, 9656441, 9656440, 9655040, 9651218, 9651217, 9648317, 9648089, 9647633, 9647575, 9647506, 9647038, 9646788, 9645710, 9644822, 9644821, 9644591, 9642649, 9638614, 9638613, 9638320, 9634015, 9632962, 9629581, 9629580, 9629579, 9625137, 9623418, 9623417, 9621109, 9619970, 9619968, 9619967, 9618253, 9617405, 9617380, 9615452, 9614450, 9614251, 9613783, 9613227, 9613014, 9611910, 9611909, 9611048, 9609893, 9609892, 9609890, 9609850, 9607818, 9605597, 9604637, 9600978, 9597087, 9588456, 9588434, 9588432, 9588429, 9584000, 9583966, 9583365, 9583364, 9577850, 9577653, 9577160, 9575327, 9572622, 9572091, 9571704, 9570858, 9570531, 9568846, 9568133, 9568132, 9566000, 9565999, 9565590, 9564177, 9563581, 9559177, 9554787, 9550943, 9550942, 9550941, 9546367, 9546366, 9545951, 9545004, 9543765, 9539780, 9539776, 9539775, 9537392, 9537391, 9531170, 9531169, 9531168, 9531167, 9517595, 9515101, 9515090, 9511170, 9506672, 9501648, 9500567, 9498427, 9497015, 9482458, 9482457, 9482014, 9482013, 9482012, 9482011, 9481124, 9479275, 9469711, 9465671, 9460217, 9459215, 9455412, 9455201, 9455200, 9454062, 9454061, 9453683, 9453682, 9453681, 9453679, 9453678, 9453677, 9453671, 9453670, 9453669, 9453668, 9453212, 9453211, 9452438, 9452437, 9450603, 9450006, 9450005, 9450004, 9448115, 9442343, 9442307, 9442306, 9441505, 9441433, 9427831, 9427830, 9424644, 9424643, 9415274, 9415273, 9409068, 9408614, 9404047, 9387800, 9385298, 9385021, 9379096, 9379066, 9376412, 9375842, 9375841, 9375494, 9369997, 9366570, 9365882, 9364462, 9361891, 9360923, 9360922, 9358182, 9358181, 9357360, 9357211, 9357210, 9357209, 9355491, 9353083, 9352753, 9348413, 9344410, 9344173, 9344096, 9343106, 9332627, 9332626, 9331899, 9331895, 9329618, 9327673, 9327651, 9327650, 9327649, 9326133, 9326120, 9326116, 9323199, 9322898, 9319175, 9315144, 9313261, 9313242, 9308486, 9308111, 9306910, 9306388, 9303492, 9297727, 9294124, 9293338, 9289217, 9288403, 9287466, 9287046, 9286784, 9285969, 9279525, 9278882, 9278881, 9276171, 9276127, 9274970, 9273944, 9273589, 9272727, 9272646, 9272645, 9272644, 9272643, 9272642, 9272640, 9272639, 9272638, 9272637, 9272635, 9268836, 9268835, 9267710, 9263529, 9262018, 9257393, 9257213, 9255301, 9255239, 9254947, 9251672, 9249662, 9249661, 9248948, 9242605, 9241432, 9240072, 9235930, 9233197, 9232910, 9232894, 9232878, 9229542, 9227967, 9227966, 9222797, 9222795, 9222794, 9219691, 9219689, 9219688, 9219680, 9219007, 9218995, 9218874, 9218868, 9218867, 9218361, 9217583, 9217582, 9217576, 9217381, 9216146, 9209540, 9208875, 9208434, 9208433, 9208144, 9196651, 9196649, 9196555, 9196100, 9193371, 9191254, 9188041, 9183729, 9179361, 9179350, 9179346, 9179338, 9179328, 9178730, 9178718, 9178707, 9178698, 9178485, 9178483, 9178467, 9175142, 9167620, 9165933, 9158188, 9158187, 9158186, 9150774, 9145455, 9138986, 9137821, 9131613, 9131362, 9131361, 9131247, 9126336, 9121935, 9121925, 9121918, 9121917, 9121903, 9121900, 9121897, 9121896, 9114421, 9114148, 9114089, 9114006, 9113997, 9113988, 9113986, 9113023, 9112396, 9112366, 9112359, 9112345, 9112344, 9112343, 9112342, 9112256, 9107517, 9107516, 9104284, 9104283, 9104282, 9103188, 9103128, 9101829, 9099844, 9096899, 9096890, 9096818, 9091685, 9091370, 9090202, 9083010, 9078064, 9078063, 9072309, 9072308, 9072307, 9064152, 9054096, 9051619, 9051563, 9051153, 9050822, 9045489, 9045488, 9043773, 9041287, 9038184, 9038183, 9033281, 9030904, 9030903, 9029627, 9026413, 9025291, 9025290, 9025051, 9024996, 9023922, 9023645, 9014274, 9011741, 9011427, 9009866, 9008157, 9008156, 9006121, 9003181, 8999725, 8998485, 8997361, 8996873, 8995041, 8992590, 8992589, 8991622, 8989513, 8988215, 8988213, 8984434, 8983274, 8981840, 8977456, 8976771, 8976766, 8976760, 8976758, 8976750, 8976748, 8976747, 8974651, 8960217, 8954565, 8954535, 8954534, 8954421, 8947094, 8944036, 8937309, 8936972, 8936971, 8936969, 8936968, 8935791, 8931470, 8928810, 8928111, 8928110, 8919817, 8919653, 8911771, 8907089, 8906505, 8906080, 8905866, 8901885, 8900280, 8882986, 8881999, 8881816, 8880789, 8880788, 8880787, 8880786, 8878771, 8878770, 8877785, 8877782, 8875790, 8875722, 8875440, 8873658, 8871940, 8869267, 8867512, 8867511, 8866814, 8864537, 8864536, 8864535, 8857847, 8857846, 8857845, 8856251, 8853185, 8853184, 8852166, 8852165, 8852164, 8851192, 8851191, 8851189, 8851188, 8851186, 8851185, 8850063, 8850010, 8850009, 8850008, 8850007, 8849285, 8849284, 8849000, 8846912, 8846911, 8846676, 8846675, 8842029, 8837573, 8837565, 8837564, 8837369, 8836124, 8835049, 8835046, 8835039, 8834584, 8834580, 8833929, 8833879, 8833878, 8833669, 8833226, 8832023, 8831634, 8827162, 8827161, 8826217, 8826216, 8819923, 8819922, 8815197, 8813254, 8813253, 8813251, 8811884, 8811883, 8810185, 8810184, 8809331, 8805504, 8803901, 8803331, 8803330, 8802649, 8802646, 8801024, 8799960, 8799959, 8799955, 8799954, 8799234, 8799231, 8799230, 8796669, 8796668, 8796260, 8793593, 8793591, 8791792, 8790184, 8790183, 8778360, 8775529, 8774799, 8773442, 8772962, 8772961, 8771453, 8771452, 8770153, 8769272, 8766049, 8765464, 8764708, 8764707, 8764703, 8764539, 8764538, 8763941, 8758671, 8755600, 8751745, 8749240, 8749079, 8749078, 8748991, 8748600, 8747126, 8747031, 8741400, 8740002, 8738376, 8738375, 8738374, 8738373, 8738372, 8738371, 8732297, 8729893, 8729892, 8729891, 8723021, 8722083, 8719834, 8712036, 8711692, 8710153, 8706446, 8701385, 8700893, 8697701, 8696386, 8696384, 8694913, 8694902, 8694901, 8694868, 8693555, 8682221, 8674467, 8657642, 8657462, 8653623, 8651986, 8649298, 8644898, 8644049, 8642062, 8641823, 8636859, 8636093, 8635381, 8633256, 8632440, 8630408, 8630187, 8629442, 8629023, 8623319, 8620556, 8620552, 8620195, 8620192, 8620188, 8620186, 8620180, 8620179, 8620178, 8611203, 8610896, 8609487, 8604738, 8604378, 8603601, 8601895, 8601893, 8600105, 8598689, 8598521, 8598508, 8597626, 8597340, 8597191, 8597190, 8591750, 8590564, 8590560, 8586651, 8586529, 8586134, 8584715, 8583398, 8583180, 8583178, 8582334, 8580633, 8580632, 8580630, 8580552, 8576069, 8576065, 8574954, 8574944, 8571581, 8570300, 8567805, 8565388, 8565286, 8565285, 8565284, 8562360, 8560538, 8560537, 8558821, 8558820, 8558616, 8558614, 8558613, 8557703, 8557701, 8552025, 8551352, 8551337, 8550272, 8548103, 8545726, 8545723, 8545720, 8543829, 8542266, 8540735, 8540348, 8539903, 8539902, 8536340, 8533996, 8533378, 8532529, 8528680, 8528659, 8528658, 8527385, 8527384, 8522655, 8490003, 8488792, 8488358, 8486182, 8473519, 8473518, 8473438, 8473053, 8473050, 8463787, 8463119, 8450414, 8412150, 8408785, 8408644, 8407428, 8407354, 8407340, 8406709, 8406552, 8405830, 8404884, 8404644, 8404054, 8404045, 8400799, 8386900, 8361548, 8357179, 8356327, 8282899, 8282691, 8282690, 8281793, 8281367, 8280938, 8280937, 8280936, 8273935, 8273870, 8266752, 8241474, 8231322, 8218594, 8216135, 8216132, 8216130, 8207969, 8207968, 8207967, 8207966, 8206895, 8185367, 8185366, 8181620, 8178322, 8177817, 8176702, 8168882, 8168881, 8168879, 8168877, 8168405, 8167737, 8167702, 8166990, 8166412, 8166202, 8162258, 8162168, 8161960, 8161425, 8161314, 8160701, 8158401, 8158400, 8156981, 8156176, 8156042, 8156040, 8155998, 8155690, 8153721, 8153432, 8153430, 8152754, 8149798, 8143333, 8136964, 8093006, 8091778, 7503804, 2558200)
Run Time: 0.016246
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 812 | 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",87],["thread",9695024],["thread",9691796],["thread",9681835],["thread",9656441],["thread",9651218],["thread",9647575],["thread",9647506],["thread",9647038],["thread",9646788],["thread",9644822],["thread",9644591],["thread",9638614],["thread",9638320],["thread",9634015],["thread",9623418],["thread",9619970],["thread",9618253],["thread",9617405],["thread",9615452],["thread",9614450],["thread",9614251],["thread",9613783],["thread",9613227],["thread",9613014],["thread",9611048],["thread",9609893],["thread",9609850],["thread",9607818],["thread",9605597],["thread",9597087],["thread",9588456],["thread",9584000],["thread",9583966],["thread",9583365],["thread",9577850],["thread",9577653],["thread",9577160],["thread",9575327],["thread",9572622],["thread",9572091],["thread",9571704],["thread",9570531],["thread",9568846],["thread",9568133],["thread",9566000],["thread",9565590],["thread",9564177],["thread",9563581],["thread",9559177],["thread",9554787],["thread",9550943],["thread",9546367],["thread",9545004],["thread",9543765],["thread",9539780],["thread",9539776],["thread",9537392],["thread",9531170],["thread",9517595],["thread",9515101],["thread",9515090],["thread",9511170],["thread",9501648],["thread",9500567],["thread",9498427],["thread",9482458],["thread",9482014],["thread",9481124],["thread",9479275],["thread",9455412],["thread",9455201],["thread",9454062],["thread",9453683],["thread",9450603],["thread",9450006],["thread",9442343],["thread",9442307],["thread",9441505],["thread",9427831],["thread",9424644],["thread",9415274],["thread",9409068],["thread",9408614],["thread",9379096],["thread",9379066],["thread",9375494],["thread",9369997],["thread",9366570],["thread",9358182],["thread",9355491],["thread",9353083],["thread",9352753],["thread",9344410],["thread",9343106],["thread",9322898],["thread",9319175],["thread",9315144],["thread",9313261],["thread",9308486],["thread",9297727],["thread",9285969],["thread",9279525],["thread",9274970],["thread",9273944],["thread",9272727],["thread",9268836],["thread",9257393],["thread",9257213],["thread",9251672],["thread",9241432],["thread",9235930],["thread",9227967],["thread",9222797],["thread",9217381],["thread",9216146],["thread",9208875],["thread",9208434],["thread",9208144],["thread",9196555],["thread",9193371],["thread",9183729],["thread",9175142],["thread",9158188],["thread",9145455],["thread",9138986],["thread",9131362],["thread",9121935],["thread",9121918],["thread",9121900],["thread",9114006],["thread",9113988],["thread",9112366],["thread",9112256],["thread",9104284],["thread",9103188],["thread",9103128],["thread",9099844],["thread",9091685],["thread",9091370],["thread",9083010],["thread",9078064],["thread",9072309],["thread",9064152],["thread",9054096],["thread",9051563],["thread",9045489],["thread",9038184],["thread",9030904],["thread",9025291],["thread",9024996],["thread",9023645],["thread",8988215],["thread",8984434],["thread",8977456],["thread",8976771],["thread",8976766],["thread",8976758],["thread",8976750],["thread",8976748],["thread",8960217],["thread",8954565],["thread",8954535],["thread",8944036],["thread",8931470],["thread",8928810],["thread",8919653],["thread",8911771],["thread",8906080],["thread",8905866],["thread",8901885],["thread",8900280],["thread",8882986],["thread",8881816],["thread",8878771],["thread",8877785],["thread",8875440],["thread",8867512],["thread",8866814],["thread",8857847],["thread",8853185],["thread",8851192],["thread",8850010],["thread",8846912],["thread",8846676],["thread",8836124],["thread",8835039],["thread",8834584],["thread",8834580],["thread",8833929],["thread",8833669],["thread",8826217],["thread",8819923],["thread",8809331],["thread",8803901],["thread",8803331],["thread",8801024],["thread",8796260],["thread",8790184],["thread",8774799],["thread",8773442],["thread",8772962],["thread",8769272],["thread",8764708],["thread",8764539],["thread",8763941],["thread",8758671],["thread",8749240],["thread",8749079],["thread",8748991],["thread",8748600],["thread",8741400],["thread",8740002],["thread",8729893],["thread",8719834],["thread",8710153],["thread",8700893],["thread",8696386],["thread",8694913],["thread",8694902],["thread",8694868],["thread",8693555],["thread",8674467],["thread",8657642],["thread",8657462],["thread",8653623],["thread",8651986],["thread",8649298],["thread",8644898],["thread",8636859],["thread",8636093],["thread",8635381],["thread",8633256],["thread",8632440],["thread",8630408],["thread",8630187],["thread",8629442],["thread",8623319],["thread",8620556],["thread",8611203],["thread",8610896],["thread",8609487],["thread",8604378],["thread",8601895],["thread",8600105],["thread",8598689],["thread",8598521],["thread",8597340],["thread",8597191],["thread",8591750],["thread",8590564],["thread",8586651],["thread",8586529],["thread",8586134],["thread",8584715],["thread",8583398],["thread",8583180],["thread",8582334],["thread",8576069],["thread",8574954],["thread",8571581],["thread",8570300],["thread",8567805],["thread",8565286],["thread",8562360],["thread",8560538],["thread",8558821],["thread",8558616],["thread",8550272],["thread",8545726],["thread",8543829],["thread",8542266],["thread",8540735],["thread",8533996],["thread",8528680],["thread",8528659],["thread",8490003],["thread",8488792],["thread",8488358],["thread",8486182],["thread",8473519],["thread",8473438],["thread",8473053],["thread",8473050],["thread",8463787],["thread",8463119],["thread",8412150],["thread",8407428],["thread",8407354],["thread",8407340],["thread",8406552],["thread",8405830],["thread",8404884],["thread",8386900],["thread",8361548],["thread",8357179],["thread",8356327],["thread",8282899],["thread",8282691],["thread",8281793],["thread",8281367],["thread",8280938],["thread",8273935],["thread",8273870],["thread",8266752],["thread",8241474],["thread",8231322],["thread",8216135],["thread",8207969],["thread",8206895],["thread",8185367],["thread",8181620],["thread",8178322],["thread",8177817],["thread",8176702],["thread",8168882],["thread",8168405],["thread",8167737],["thread",8167702],["thread",8166990],["thread",8166202],["thread",8162168],["thread",8161960],["thread",8161425],["thread",8161314],["thread",8160701],["thread",8158401],["thread",8156981],["thread",8155998],["thread",8155690],["thread",8153721],["thread",8153432],["thread",8152754],["thread",8143333],["thread",8136964],["thread",8093006],["thread",8091778],["thread",7503804]], 338, tinhte_xentag_tag, , {"tags":["\u00e1o thun c\u00e1 s\u1ea5u"]}, date, 0, , [], 0, 1660680496, 3b67401181357d055e24fbc8c355252e
Run Time: 0.000761