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 (8674986, 8674548, 8673764, 8669840, 8665493, 8664376, 8663275, 8661512, 8661203, 8658883, 8658082, 8656030, 8653676, 8652956, 8650673, 8642907, 8641055, 8640762, 8636703, 8633903, 8631870, 8629406, 8628813, 8624602, 8624394, 8624253, 8623748, 8621052, 8620950, 8620427, 8619981, 8616978, 8615531, 8613992, 8609354, 8607590, 8606192, 8606174, 8603735, 8602764, 8599115, 8598715, 8598692, 8593741, 8592748, 8591099, 8589676, 8589630, 8588964, 8587586, 8584969, 8584694, 8579482, 8579412, 8576202, 8575400, 8574043, 8573234, 8573186, 8572876, 8572806, 8567723, 8566632, 8566369, 8564284, 8563687, 8562495, 8558273, 8549150, 8545289, 8545287, 8542218, 8541435, 8540957, 8540908, 8532723, 8532722, 8530882, 8527803, 8525328, 8525025, 8522336, 8522204, 8520696, 8518630, 8518461, 8518166, 8517959, 8517559, 8514406, 8512513, 8507694, 8506975, 8506526, 8496779, 8495989, 8494723, 8489902, 8484756, 8483869, 8483868, 8483843, 8483455, 8482887, 8482882, 8482813, 8482764, 8481288, 8477148, 8471903, 8471901, 8467155, 8464468, 8464268, 8463363, 8463091, 8462055, 8461158, 8460922, 8459809, 8459808, 8459806, 8458936, 8458317, 8457949, 8457100, 8457086, 8454347, 8453733, 8453173, 8451157, 8449915, 8445053, 8444585, 8439463, 8439369, 8438092, 8437937, 8437911, 8436514, 8436044, 8432395, 8432055, 8428307, 8427936, 8427025, 8426338, 8422013, 8421639, 8420844, 8420626, 8418164, 8417609, 8415288, 8412197, 8412111, 8411271, 8411092, 8407853, 8405175, 8405139, 8402943, 8402878, 8401157, 8400502, 8399914, 8398380, 8395630, 8388728, 8388674, 8382299, 8378806, 8376102, 8372731, 8372630, 8372628, 8371366, 8366041, 8365702, 8365119, 8357475, 8353115, 8352697, 8352028, 8351013, 8350273, 8349168, 8347269, 8345356, 8340216, 8339840, 8339100, 8337391, 8337010, 8334810, 8334612, 8331749, 8328702, 8327626, 8326201, 8324865, 8321875, 8318409, 8316161, 8315614, 8312318, 8310112, 8306264, 8305110, 8302345, 8300276, 8299831, 8299681, 8298881, 8297556, 8297285, 8296989, 8296932, 8296378, 8295005, 8294967, 8293027, 8288575, 8288270, 8287998, 8287450, 8287410, 8286506, 8285464, 8281450, 8281356, 8281204, 8278944, 8278753, 8278533, 8276912, 8276859, 8275530, 8274597, 8272713, 8271843, 8268820, 8265935, 8265761, 8263660, 8262962, 8260602, 8258672, 8258671, 8258036, 8257287, 8256560, 8254876, 8254700, 8254227, 8251828, 8250813, 8249460, 8248519, 8248455, 8247374, 8245724, 8245708, 8244082, 8242563, 8240051, 8238330, 8238309, 8238262, 8238052, 8237053, 8236961, 8235696, 8235532, 8235161, 8233151, 8233110, 8233109, 8231003, 8228971, 8227859, 8225839, 8224004, 8221671, 8221670, 8220207, 8219594, 8219541, 8218288, 8218001, 8217645, 8217393, 8216068, 8215461, 8215391, 8214887, 8214785, 8214453, 8210491, 8209464, 8208782, 8208706, 8207830, 8206264, 8206173, 8206082, 8203649, 8203218, 8200642, 8196858, 8195489, 8195371, 8195218, 8193976, 8192418, 8191171, 8191076, 8191010, 8190926, 8190925, 8190389, 8190355, 8189470, 8189372, 8189358, 8187837, 8187551, 8187550, 8187235, 8187134, 8187129, 8185926, 8185925, 8185736, 8183832, 8182887, 8181892, 8181559, 8181365, 8180185, 8174570, 8172497, 8172495, 8171735, 8170248, 8164779, 8164778, 8155997, 8155856, 8155814, 8154385, 8154215, 8153350, 8153140, 8134542, 8097110, 7652586, 6479350)
Run Time: 0.011390
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 358 | 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: [["thread",8674548],["thread",8669840],["thread",8664376],["thread",8661203],["thread",8658883],["thread",8658082],["thread",8642907],["thread",8636703],["thread",8633903],["thread",8631870],["thread",8629406],["thread",8624602],["thread",8624394],["thread",8624253],["thread",8620427],["thread",8619981],["thread",8616978],["thread",8609354],["thread",8607590],["thread",8599115],["thread",8598715],["thread",8598692],["thread",8593741],["thread",8589630],["thread",8588964],["thread",8587586],["thread",8579482],["thread",8579412],["thread",8576202],["thread",8575400],["thread",8574043],["thread",8573234],["thread",8573186],["thread",8567723],["thread",8566632],["thread",8566369],["thread",8564284],["thread",8558273],["thread",8549150],["thread",8542218],["thread",8540957],["thread",8540908],["thread",8532723],["thread",8525328],["thread",8522336],["thread",8520696],["thread",8518630],["thread",8518461],["thread",8517959],["thread",8507694],["thread",8506526],["thread",8496779],["thread",8495989],["thread",8484756],["thread",8483869],["thread",8483843],["thread",8482887],["thread",8482882],["thread",8482813],["thread",8482764],["thread",8481288],["thread",8477148],["thread",8467155],["thread",8463091],["thread",8462055],["thread",8461158],["thread",8460922],["thread",8458936],["thread",8457949],["thread",8457100],["thread",8457086],["thread",8453733],["thread",8453173],["thread",8451157],["thread",8445053],["thread",8444585],["thread",8439463],["thread",8439369],["thread",8438092],["thread",8437937],["thread",8436044],["thread",8432055],["thread",8427936],["thread",8427025],["thread",8422013],["thread",8421639],["thread",8420844],["thread",8420626],["thread",8417609],["thread",8415288],["thread",8411271],["thread",8411092],["thread",8407853],["thread",8405175],["thread",8405139],["thread",8402943],["thread",8402878],["thread",8401157],["thread",8400502],["thread",8399914],["thread",8398380],["thread",8395630],["thread",8388728],["thread",8388674],["thread",8382299],["thread",8378806],["thread",8376102],["thread",8372731],["thread",8371366],["thread",8366041],["thread",8365702],["thread",8357475],["thread",8353115],["thread",8352697],["thread",8352028],["thread",8351013],["thread",8350273],["thread",8349168],["thread",8347269],["thread",8345356],["thread",8339100],["thread",8337391],["thread",8334810],["thread",8334612],["thread",8331749],["thread",8328702],["thread",8327626],["thread",8326201],["thread",8321875],["thread",8318409],["thread",8316161],["thread",8315614],["thread",8312318],["thread",8310112],["thread",8302345],["thread",8300276],["thread",8299831],["thread",8299681],["thread",8298881],["thread",8297556],["thread",8297285],["thread",8296989],["thread",8296932],["thread",8296378],["thread",8295005],["thread",8294967],["thread",8293027],["thread",8288575],["thread",8288270],["thread",8287998],["thread",8287450],["thread",8286506],["thread",8281450],["thread",8281356],["thread",8278944],["thread",8278753],["thread",8278533],["thread",8276912],["thread",8276859],["thread",8275530],["thread",8274597],["thread",8272713],["thread",8271843],["thread",8268820],["thread",8265935],["thread",8265761],["thread",8263660],["thread",8262962],["thread",8260602],["thread",8258672],["thread",8258036],["thread",8257287],["thread",8256560],["thread",8254876],["thread",8254700],["thread",8254227],["thread",8251828],["thread",8250813],["thread",8249460],["thread",8248519],["thread",8248455],["thread",8247374],["thread",8245724],["thread",8245708],["thread",8244082],["thread",8242563],["thread",8240051],["thread",8238330],["thread",8238309],["thread",8238262],["thread",8238052],["thread",8237053],["thread",8236961],["thread",8235696],["thread",8235532],["thread",8235161],["thread",8233110],["thread",8231003],["thread",8227859],["thread",8225839],["thread",8224004],["thread",8221671],["thread",8220207],["thread",8219594],["thread",8219541],["thread",8218288],["thread",8218001],["thread",8217645],["thread",8217393],["thread",8216068],["thread",8215461],["thread",8215391],["thread",8214887],["thread",8214785],["thread",8210491],["thread",8209464],["thread",8208782],["thread",8208706],["thread",8207830],["thread",8206264],["thread",8206173],["thread",8206082],["thread",8203649],["thread",8203218],["thread",8196858],["thread",8195489],["thread",8195371],["thread",8195218],["thread",8192418],["thread",8191171],["thread",8191076],["thread",8191010],["thread",8190926],["thread",8190389],["thread",8190355],["thread",8189470],["thread",8189372],["thread",8189358],["thread",8187837],["thread",8187551],["thread",8187134],["thread",8187129],["thread",8185926],["thread",8185736],["thread",8183832],["thread",8182887],["thread",8181892],["thread",8181559],["thread",8181365],["thread",8180185],["thread",8174570],["thread",8172497],["thread",8171735],["thread",8170248],["thread",8164779],["thread",8155997],["thread",8155856],["thread",8155814],["thread",8154215],["thread",8153350],["thread",8153140],["thread",8134542],["thread",8097110],["thread",7652586]], 264, tinhte_xentag_tag, , {"tags":["m\u00e1y ch\u01a1i game kh\u00e1c"]}, date, 0, , [], 0, 1656542319, 8eeca909eeaa7a8ee111a6cb438d92d2
Run Time: 0.000737