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 (9280929, 9280928, 9280927, 9092990, 9092989, 8710310, 8709837, 8709800, 8703651, 8696388, 8691717, 8687831, 8687525, 8686120, 8684656, 8680101, 8675402, 8675296, 8674909, 8663587, 8663226, 8660335, 8659019, 8658722, 8658505, 8656330, 8655292, 8652270, 8652267, 8645878, 8643724, 8643035, 8638503, 8637681, 8636416, 8636159, 8636135, 8629726, 8629709, 8629244, 8627118, 8625866, 8620697, 8620644, 8619510, 8619320, 8617998, 8617443, 8615971, 8615512, 8615373, 8614889, 8613925, 8611376, 8611035, 8608954, 8608679, 8605489, 8605488, 8605487, 8605484, 8605483, 8605400, 8605399, 8605247, 8604801, 8598704, 8595118, 8593661, 8591610, 8588596, 8587977, 8587968, 8587961, 8587733, 8580006, 8580002, 8579996, 8579925, 8579677, 8579676, 8579231, 8578608, 8577996, 8577019, 8576462, 8570152, 8569754, 8567646, 8562703, 8562701, 8562263, 8562261, 8562258, 8561943, 8560424, 8559663, 8559628, 8556235, 8556234, 8555045, 8554908, 8554783, 8551122, 8547896, 8547895, 8547894, 8547473, 8547455, 8545572, 8545568, 8545456, 8543577, 8543027, 8538615, 8537420, 8536748, 8536074, 8535993, 8535991, 8535990, 8535988, 8535982, 8535980, 8535979, 8535977, 8535976, 8535974, 8535971, 8535970, 8535968, 8535805, 8533623, 8527887, 8527192, 8524438, 8521963, 8520685, 8520349, 8520138, 8519203, 8519155, 8516857, 8516808, 8516458, 8515558, 8515328, 8515326, 8513618, 8513601, 8513577, 8513570, 8512566, 8512559, 8510790, 8509126, 8509024, 8508740, 8504066, 8504058, 8503560, 8503223, 8502922, 8501545, 8501206, 8501112, 8499883, 8496509, 8494748, 8488884, 8486937, 8486880, 8485636, 8485622, 8485010, 8483813, 8483811, 8482747, 8482706, 8481755, 8479588, 8477838, 8474662, 8473669, 8470095, 8469603, 8469547, 8467856, 8466021, 8465891, 8464168, 8459301, 8456822, 8455841, 8453130, 8451298, 8445657, 8443830, 8442967, 8441834, 8440534, 8440008, 8439486, 8439108, 8436321, 8435740, 8430436, 8429069, 8426957, 8424354, 8423433, 8422517, 8422335, 8418971, 8415769, 8415693, 8414925, 8412466, 8411157, 8408364, 8406218, 8405638, 8405637, 8405416, 8404491, 8404407, 8404169, 8401999, 8400750, 8400727, 8400579, 8399526, 8398317, 8398149, 8397904, 8397587, 8396999, 8396998, 8396514, 8394576, 8394378, 8394219, 8393884, 8389890, 8388128, 8387133, 8386845, 8382881, 8381657, 8380401, 8379695, 8379444, 8376693, 8374952, 8372717, 8371028, 8369452, 8365410, 8364334, 8364188, 8362596, 8361052, 8360025, 8359660, 8357240, 8356840, 8356044, 8355886, 8351028, 8350590, 8349123, 8348396, 8348257, 8347211, 8347198, 8346757, 8346752, 8346751, 8346699, 8345041, 8344424, 8344423, 8344422, 8344420, 8343479, 8343471, 8342553, 8341596, 8341053, 8341052, 8340856, 8340169, 8339180, 8339026, 8336409, 8336386, 8336262, 8335588, 8335587, 8335584, 8335583, 8335507, 8334614, 8331040, 8330927, 8330797, 8329785, 8326112, 8325599, 8325230, 8322575, 8321139, 8320996, 8320868, 8320451, 8318741, 8318586, 8317605, 8317596, 8317351, 8316252, 8316247, 8315374, 8314882, 8314266, 8313890, 8313708, 8313683, 8312889, 8312350, 8311122, 8309350, 8308842, 8308222, 8307697, 8307326, 8307101, 8306292, 8302848, 8301407, 8298570, 8298497, 8298129, 8297447, 8297399, 8297353, 8297345, 8296657, 8295811, 8295810, 8295502, 8294979, 8294909, 8294762, 8293016, 8291148, 8291146, 8291024, 8290820, 8290578, 8290577, 8290362, 8289801, 8289171, 8288924, 8288912, 8288720, 8288306, 8286051, 8285670, 8285563, 8285100, 8285099, 8285008, 8284592, 8284581, 8283794, 8283727, 8282869, 8282106, 8282100, 8282074, 8282066, 8280311, 8280286, 8280175, 8280067, 8280017, 8279908, 8279879, 8279812, 8278279, 8278278, 8277334, 8277009, 8276296, 8275986, 8275984, 8275809, 8275795, 8275780, 8274955, 8273932, 8272425, 8271675, 8270379, 8268966, 8268040, 8267638, 8267045, 8266546, 8262257, 8261885, 8261468, 8261012, 8259899, 8258457, 8258455, 8255593, 8253546, 8253545, 8253201, 8253006, 8252998, 8252800, 8252627, 8251999, 8251545, 8250905, 8250589, 8247631, 8246774, 8246279, 8246278, 8246060, 8245067, 8244747, 8244727, 8243825, 8243824, 8243224, 8242829, 8242430, 8242065, 8242063, 8242031, 8241801, 8241120, 8240855, 8240471, 8238903, 8238901, 8237297, 8237168, 8235368, 8233771, 8232631, 8231279, 8230583, 8230574, 8227922, 8227650, 8226297, 8224525, 8222970, 8222782, 8221285, 8220158, 8219889, 8219112, 8219110, 8218919, 8218768, 8217117, 8216648, 8216643, 8214791, 8213010, 8211672, 8211584, 8211521, 8211231, 8210568, 8210076, 8209917, 8209196, 8208586, 8208480, 8207331, 8207211, 8206031, 8205998, 8205150, 8204588, 8202994, 8200120, 8200119, 8199241, 8199046, 8197650, 8197589, 8196934, 8196199, 8194545, 8194532, 8191921, 8190761, 8190395, 8190331, 8190201, 8189178, 8188461, 8186245, 8184024, 8183691, 8183477, 8183426, 8182454, 8182361, 8182225, 8182018, 8181881, 8181782, 8181604, 8181557, 8180587, 8180513, 8180367, 8180362, 8180361, 8179906, 8179415, 8179092, 8179082, 8179059, 8178977, 8178871, 8178844, 8176530, 8175770, 8175354, 8174984, 8174983, 8174625, 8173775, 8173320, 8173317, 8172904, 8172763, 8172762, 8172016, 8171037, 8168857, 8168344, 8168319, 8168314, 8168311, 8168303, 8168291, 8168264, 8168263, 8166500, 8165760, 8165628, 8165627, 8165380, 8165379, 8165125, 8164972, 8164916, 8164649, 8164059, 8161234, 8159900, 8159520, 8158794, 8158530, 8156662, 8156661, 8156659, 8156433, 8155287, 8153085, 8151424, 8117994, 8058619, 8030039, 8017487, 7896181, 7768676, 7447030, 7398741, 7369282, 7279806, 7204209, 6989116)
Run Time: 0.017858
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 596 | 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",8710310],["thread",8709800],["thread",8703651],["thread",8696388],["thread",8691717],["thread",8687831],["thread",8686120],["thread",8684656],["thread",8680101],["thread",8675296],["thread",8674909],["thread",8663587],["thread",8663226],["thread",8660335],["thread",8659019],["thread",8658722],["thread",8658505],["thread",8656330],["thread",8655292],["thread",8652270],["thread",8645878],["thread",8643724],["thread",8643035],["thread",8638503],["thread",8637681],["thread",8636416],["thread",8636159],["thread",8636135],["thread",8629709],["thread",8627118],["thread",8620697],["thread",8620644],["thread",8619510],["thread",8619320],["thread",8617998],["thread",8617443],["thread",8615971],["thread",8615512],["thread",8615373],["thread",8614889],["thread",8613925],["thread",8608954],["thread",8608679],["thread",8605247],["thread",8604801],["thread",8598704],["thread",8595118],["thread",8591610],["thread",8588596],["thread",8587977],["thread",8587968],["thread",8587961],["thread",8587733],["thread",8580006],["thread",8579996],["thread",8579925],["thread",8579677],["thread",8579676],["thread",8579231],["thread",8577996],["thread",8577019],["thread",8570152],["thread",8569754],["thread",8567646],["thread",8561943],["thread",8559663],["thread",8559628],["thread",8556235],["thread",8555045],["thread",8554908],["thread",8554783],["thread",8551122],["thread",8545572],["thread",8545568],["thread",8545456],["thread",8543577],["thread",8538615],["thread",8537420],["thread",8536748],["thread",8535805],["thread",8527887],["thread",8527192],["thread",8521963],["thread",8520685],["thread",8520349],["thread",8520138],["thread",8519203],["thread",8519155],["thread",8516857],["thread",8516808],["thread",8516458],["thread",8515558],["thread",8515328],["thread",8515326],["thread",8513618],["thread",8513601],["thread",8513577],["thread",8513570],["thread",8512566],["thread",8512559],["thread",8510790],["thread",8509126],["thread",8509024],["thread",8504066],["thread",8504058],["thread",8503560],["thread",8503223],["thread",8502922],["thread",8501545],["thread",8501206],["thread",8501112],["thread",8499883],["thread",8494748],["thread",8488884],["thread",8486937],["thread",8486880],["thread",8485636],["thread",8485622],["thread",8485010],["thread",8483813],["thread",8482747],["thread",8482706],["thread",8481755],["thread",8479588],["thread",8474662],["thread",8473669],["thread",8470095],["thread",8469603],["thread",8467856],["thread",8466021],["thread",8465891],["thread",8459301],["thread",8456822],["thread",8453130],["thread",8451298],["thread",8445657],["thread",8443830],["thread",8442967],["thread",8441834],["thread",8440534],["thread",8440008],["thread",8439486],["thread",8439108],["thread",8435740],["thread",8430436],["thread",8426957],["thread",8424354],["thread",8423433],["thread",8422517],["thread",8422335],["thread",8418971],["thread",8415769],["thread",8415693],["thread",8412466],["thread",8408364],["thread",8406218],["thread",8405638],["thread",8404491],["thread",8404407],["thread",8404169],["thread",8401999],["thread",8400750],["thread",8400727],["thread",8400579],["thread",8399526],["thread",8398317],["thread",8398149],["thread",8397904],["thread",8397587],["thread",8396514],["thread",8394576],["thread",8394378],["thread",8394219],["thread",8393884],["thread",8389890],["thread",8388128],["thread",8387133],["thread",8386845],["thread",8382881],["thread",8381657],["thread",8380401],["thread",8379695],["thread",8379444],["thread",8376693],["thread",8374952],["thread",8372717],["thread",8371028],["thread",8369452],["thread",8365410],["thread",8364334],["thread",8364188],["thread",8362596],["thread",8361052],["thread",8360025],["thread",8359660],["thread",8357240],["thread",8356840],["thread",8356044],["thread",8351028],["thread",8350590],["thread",8349123],["thread",8348396],["thread",8348257],["thread",8347211],["thread",8347198],["thread",8346757],["thread",8346752],["thread",8346751],["thread",8346699],["thread",8343479],["thread",8343471],["thread",8342553],["thread",8341596],["thread",8340856],["thread",8340169],["thread",8339180],["thread",8339026],["thread",8336409],["thread",8336386],["thread",8336262],["thread",8335507],["thread",8334614],["thread",8331040],["thread",8330797],["thread",8329785],["thread",8326112],["thread",8325599],["thread",8325230],["thread",8322575],["thread",8321139],["thread",8320996],["thread",8320451],["thread",8318741],["thread",8317605],["thread",8317596],["thread",8317351],["thread",8315374],["thread",8314882],["thread",8314266],["thread",8313890],["thread",8313708],["thread",8313683],["thread",8312889],["thread",8312350],["thread",8309350],["thread",8308842],["thread",8308222],["thread",8307697],["thread",8307326],["thread",8307101],["thread",8306292],["thread",8302848],["thread",8301407],["thread",8298570],["thread",8298497],["thread",8298129],["thread",8297447],["thread",8297399],["thread",8297353],["thread",8297345],["thread",8296657],["thread",8295811],["thread",8295810],["thread",8295502],["thread",8294979],["thread",8294909],["thread",8294762],["thread",8293016],["thread",8291148],["thread",8291146],["thread",8291024],["thread",8290820],["thread",8290578],["thread",8290362],["thread",8289171],["thread",8288924],["thread",8288912],["thread",8288720],["thread",8288306],["thread",8286051],["thread",8285670],["thread",8285563],["thread",8285100],["thread",8285008],["thread",8284592],["thread",8284581],["thread",8283794],["thread",8283727],["thread",8282869],["thread",8282106],["thread",8282100],["thread",8282074],["thread",8282066],["thread",8280311],["thread",8280286],["thread",8280067],["thread",8280017],["thread",8279908],["thread",8279879],["thread",8279812],["thread",8278279],["thread",8277334],["thread",8277009],["thread",8276296],["thread",8275986],["thread",8275809],["thread",8275795],["thread",8275780],["thread",8274955],["thread",8273932],["thread",8272425],["thread",8271675],["thread",8270379],["thread",8268966],["thread",8268040],["thread",8267638],["thread",8267045],["thread",8262257],["thread",8261885],["thread",8261468],["thread",8261012],["thread",8259899],["thread",8258457],["thread",8258455],["thread",8255593],["thread",8253546],["thread",8253201],["thread",8253006],["thread",8252998],["thread",8252800],["thread",8252627],["thread",8251999],["thread",8251545],["thread",8250905],["thread",8250589],["thread",8247631],["thread",8246774],["thread",8246279],["thread",8246060],["thread",8245067],["thread",8244747],["thread",8244727],["thread",8243825],["thread",8243224],["thread",8242829],["thread",8242430],["thread",8242065],["thread",8242031],["thread",8241801],["thread",8241120],["thread",8240855],["thread",8240471],["thread",8238903],["thread",8237297],["thread",8237168],["thread",8235368],["thread",8233771],["thread",8232631],["thread",8230583],["thread",8227922],["thread",8227650],["thread",8226297],["thread",8224525],["thread",8222970],["thread",8222782],["thread",8221285],["thread",8220158],["thread",8219889],["thread",8218919],["thread",8218768],["thread",8217117],["thread",8216648],["thread",8216643],["thread",8214791],["thread",8213010],["thread",8211672],["thread",8211584],["thread",8211521],["thread",8211231],["thread",8210568],["thread",8210076],["thread",8209917],["thread",8209196],["thread",8208586],["thread",8208480],["thread",8207331],["thread",8207211],["thread",8206031],["thread",8205150],["thread",8204588],["thread",8202994],["thread",8200120],["thread",8199241],["thread",8197650],["thread",8197589],["thread",8196934],["thread",8196199],["thread",8194545],["thread",8194532],["thread",8191921],["thread",8190761],["thread",8190395],["thread",8189178],["thread",8188461],["thread",8186245],["thread",8184024],["thread",8183691],["thread",8183477],["thread",8183426],["thread",8182454],["thread",8182361],["thread",8182225],["thread",8182018],["thread",8181881],["thread",8181782],["thread",8181604],["thread",8181557],["thread",8180513],["thread",8180367],["thread",8179906],["thread",8179415],["thread",8179092],["thread",8179082],["thread",8179059],["thread",8178977],["thread",8178871],["thread",8176530],["thread",8175770],["thread",8175354],["thread",8174984],["thread",8174625],["thread",8173775],["thread",8173320],["thread",8173317],["thread",8172904],["thread",8172763],["thread",8172016],["thread",8171037],["thread",8168857],["thread",8168344],["thread",8168319],["thread",8168314],["thread",8168311],["thread",8168303],["thread",8168291],["thread",8168264],["thread",8166500],["thread",8165760],["thread",8165628],["thread",8165380],["thread",8165125],["thread",8164972],["thread",8164916],["thread",8164649],["thread",8164059],["thread",8159520],["thread",8156662],["thread",8153085],["thread",8151424],["thread",8117994],["thread",8017487],["thread",7896181],["thread",7768676],["thread",7447030],["thread",7369282],["thread",7279806],["thread",7204209],["thread",6989116]], 468, tinhte_xentag_tag, , {"tags":["xe ch\u1edf kh\u00e1ch"]}, date, 0, , [], 0, 1660821265, 2fd0f8a94d2cba7fa259ec4a45e3b6c2
Run Time: 0.000727