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 (8689171, 8689168, 8689088, 8689087, 8688811, 8688588, 8688587, 8688415, 8687505, 8687504, 8686935, 8684324, 8684089, 8680512, 8680403, 8680401, 8679725, 8679215, 8678753, 8677486, 8676176, 8675860, 8675430, 8675270, 8675269, 8675235, 8674469, 8674425, 8674309, 8673211, 8671716, 8671248, 8671097, 8670436, 8669924, 8669838, 8669802, 8669783, 8669702, 8669700, 8668909, 8668319, 8668254, 8667992, 8667615, 8666343, 8666213, 8664265, 8664090, 8663895, 8663068, 8662701, 8662327, 8661780, 8660590, 8659654, 8659631, 8659200, 8655171, 8654843, 8654842, 8653548, 8653286, 8653285, 8653282, 8652804, 8652801, 8652274, 8651425, 8651415, 8651412, 8651396, 8651369, 8650965, 8650963, 8650790, 8649736, 8648951, 8647689, 8646921, 8646917, 8646661, 8646429, 8645827, 8645414, 8645111, 8643849, 8643596, 8643595, 8642511, 8642455, 8642266, 8641670, 8641238, 8641217, 8641161, 8641159, 8640051, 8638645, 8638644, 8638193, 8638163, 8638148, 8637628, 8637565, 8637101, 8637047, 8636312, 8636283, 8636281, 8635784, 8635560, 8635553, 8635023, 8634697, 8634487, 8633590, 8633085, 8633043, 8630397, 8628990, 8628651, 8625902, 8625823, 8625087, 8624654, 8621459, 8621452, 8621451, 8620127, 8618858, 8618057, 8617641, 8617467, 8617465, 8616666, 8616608, 8616211, 8614711, 8613767, 8613731, 8613282, 8612163, 8611713, 8611245, 8611155, 8611154, 8610991, 8610941, 8610209, 8609254, 8609253, 8608686, 8608591, 8607990, 8606729, 8605316, 8605046, 8604216, 8603320, 8601770, 8601565, 8601293, 8600691, 8600689, 8600687, 8597530, 8596853, 8596849, 8596697, 8595335, 8594950, 8593906, 8592303, 8591337, 8588036, 8587004, 8587001, 8586352, 8586351, 8586348, 8585930, 8583246, 8577545, 8576430, 8575530, 8575529, 8575527, 8574606, 8572160, 8571136, 8571131, 8569779, 8569775, 8569773, 8569772, 8569771, 8569616, 8569576, 8569430, 8569257, 8569105, 8566114, 8564037, 8561323, 8561289, 8557155, 8555592, 8555242, 8555066, 8552401, 8552068, 8548497, 8548406, 8546958, 8544729, 8544202, 8544146, 8543361, 8543042, 8543039, 8542143, 8541257, 8540815, 8540585, 8540223, 8540001, 8538652, 8538651, 8538500, 8538493, 8538363, 8537435, 8535434, 8535268, 8534993, 8530827, 8530820, 8529478, 8529477, 8529476, 8525786, 8525015, 8524559, 8524558, 8524557, 8521171, 8521022, 8519616, 8519249, 8516972, 8515687, 8515133, 8514992, 8513546, 8512680, 8512305, 8512140, 8511467, 8510926, 8508784, 8508779, 8508771, 8507761, 8507760, 8507754, 8507753, 8507620, 8507355, 8506158, 8504278, 8504063, 8503108, 8502453, 8502332, 8502140, 8501776, 8501470, 8500124, 8499707, 8497662, 8495697, 8494422, 8494402, 8494380, 8493930, 8492442, 8491492, 8490234, 8490066, 8489813, 8488154, 8488150, 8487902, 8486921, 8486464, 8485651, 8485403, 8484378, 8484164, 8482672, 8480985, 8476612, 8476517, 8475712, 8474976, 8474397, 8474225, 8472888, 8472426, 8470045, 8469996, 8469200, 8466763, 8465460, 8465351, 8465139, 8463087, 8461799, 8460879, 8459925, 8453051, 8452796, 8451929, 8451001, 8450798, 8450606, 8450574, 8450213, 8449811, 8449675, 8447280, 8445968, 8443700, 8442972, 8441939, 8441421, 8441340, 8441018, 8441010, 8439813, 8439679, 8439016, 8438944, 8438919, 8437568, 8437507, 8435956, 8435038, 8434481, 8433862, 8433202, 8430267, 8425796, 8425577, 8425398, 8425241, 8424400, 8424257, 8424019, 8423720, 8422545, 8421068, 8418376, 8418317, 8417584, 8417260, 8416230, 8416169, 8415752, 8415647, 8414887, 8414856, 8413497, 8413311, 8413168, 8411862, 8410152, 8410115, 8408899, 8408567, 8408000, 8407718, 8406840, 8404850, 8404819, 8404515, 8404513, 8404511, 8404510, 8402757, 8402047, 8401806, 8401782, 8401781, 8401694, 8401475, 8400144, 8399632, 8398394, 8398299, 8396373, 8393181, 8392027, 8390792, 8389893, 8389651, 8389518, 8389094, 8387006, 8386239, 8386234, 8383636, 8380588, 8380344, 8379502, 8378874, 8378048, 8377831, 8377808, 8377802, 8377632, 8376468, 8376337, 8375230, 8374224, 8373701, 8371684, 8371306, 8371016, 8368913, 8367553, 8364724, 8364701, 8364681, 8363503, 8363155, 8362690, 8360873, 8359451, 8358892, 8358027, 8356003, 8355190, 8354142, 8350963, 8350513, 8350338, 8347701, 8347620, 8347162, 8346373, 8345411, 8345132, 8343293, 8342341, 8341659, 8341482, 8340683, 8339489, 8339478, 8339428, 8339170, 8336407, 8335686, 8335569, 8335138, 8334210, 8331074, 8330813, 8327098, 8326104, 8325663, 8322570, 8321581, 8319461, 8318008, 8317409, 8317408, 8316831, 8316121, 8315835, 8315820, 8315093, 8312515, 8312396, 8312393, 8311935, 8311483, 8310077, 8310058, 8309748, 8308358, 8307856, 8306215, 8306129, 8305072, 8302874, 8302841, 8300819, 8299595, 8299153, 8298644, 8298620, 8297788, 8297773, 8296692, 8295581, 8294908, 8294525, 8294502, 8294416, 8291581, 8291164, 8290928, 8290887, 8290101, 8289613, 8289610, 8288586, 8287469, 8286396, 8285143, 8284840, 8283972, 8283583, 8283064, 8283062, 8282897, 8281747, 8281619, 8280635, 8280248, 8280223, 8280222, 8279655, 8279332, 8277680, 8277679, 8276660, 8276497, 8274850, 8274754, 8273315, 8272989, 8272926, 8272852, 8272619, 8272617, 8272338, 8270859, 8269639, 8268753, 8268752, 8268750, 8268749, 8268744, 8268742, 8268740, 8267828, 8267806, 8267209, 8267208, 8266340, 8265659, 8265084, 8265064, 8264916, 8264570, 8263769, 8263666, 8263187, 8263152, 8262621, 8261697, 8261644, 8261209, 8259964, 8257851, 8257550, 8257457, 8256941, 8256940, 8256939, 8256938, 8256937, 8255202, 8255044, 8254564, 8254516, 8254278, 8253565, 8253564, 8252930, 8252515, 8252338, 8252216, 8252214, 8251127, 8250801, 8249989, 8249977, 8249968, 8249956, 8248657, 8248647, 8248646, 8246292, 8245610, 8244745, 8244282, 8243968, 8243967, 8242650, 8240883, 8240882, 8240311, 8239527, 8238905, 8237004, 8236872, 8236462, 8235705, 8235412, 8234822, 8234361, 8234080, 8230025, 8230018, 8226530, 8225443, 8224039, 8223670, 8223668, 8222602, 8222292, 8221949, 8219833, 8219538, 8219176, 8218571, 8216288, 8216287, 8216286, 8216252, 8215614, 8215016, 8214440, 8213919, 8213668, 8212695, 8212382, 8211727, 8210932, 8210769, 8207726, 8207679, 8207667, 8207533, 8207335, 8206995, 8206771, 8206770, 8206769, 8206491, 8206452, 8203082, 8202643, 8197834, 8197407, 8194517, 8194516, 8194378, 8189406, 8189405, 8183986, 8183919, 8182600, 8182584, 8182578, 8182286, 8181332, 8181331, 8180294, 8177626, 8176293, 8175896, 8175894, 8173873, 8173861, 8173088, 8172709, 8172506, 8172504, 8172375, 8172077, 8169059, 8168565, 8168564, 8162917, 8162060, 8161856, 8161854, 8159196, 8157163, 8155809, 8155676, 8153504, 8153443, 8153273, 8151759, 8071470, 7895267, 7219044, 7112185, 7091884, 6546073, 5195113)
Run Time: 0.024520
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 718 | 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",8689171],["thread",8689088],["thread",8688811],["thread",8688588],["thread",8688415],["thread",8686935],["thread",8684324],["thread",8684089],["thread",8680512],["thread",8679725],["thread",8675430],["thread",8675270],["thread",8675235],["thread",8674469],["thread",8674425],["thread",8673211],["thread",8671248],["thread",8671097],["thread",8669924],["thread",8669802],["thread",8669783],["thread",8668319],["thread",8668254],["thread",8667992],["thread",8666343],["thread",8663895],["thread",8662701],["thread",8662327],["thread",8659654],["thread",8659631],["thread",8655171],["thread",8653286],["thread",8652804],["thread",8651425],["thread",8651415],["thread",8651396],["thread",8651369],["thread",8650790],["thread",8648951],["thread",8647689],["thread",8646661],["thread",8645827],["thread",8645414],["thread",8643596],["thread",8642511],["thread",8642266],["thread",8641161],["thread",8638148],["thread",8637101],["thread",8636312],["thread",8636283],["thread",8635560],["thread",8635553],["thread",8635023],["thread",8634697],["thread",8633590],["thread",8630397],["thread",8628990],["thread",8625823],["thread",8625087],["thread",8621459],["thread",8618057],["thread",8617467],["thread",8616666],["thread",8616608],["thread",8616211],["thread",8614711],["thread",8613731],["thread",8612163],["thread",8611713],["thread",8611245],["thread",8611155],["thread",8610991],["thread",8610941],["thread",8610209],["thread",8608686],["thread",8608591],["thread",8606729],["thread",8605316],["thread",8604216],["thread",8603320],["thread",8601770],["thread",8597530],["thread",8596853],["thread",8594950],["thread",8591337],["thread",8588036],["thread",8587004],["thread",8586352],["thread",8585930],["thread",8583246],["thread",8577545],["thread",8576430],["thread",8575530],["thread",8574606],["thread",8572160],["thread",8571136],["thread",8571131],["thread",8569616],["thread",8569430],["thread",8569105],["thread",8566114],["thread",8564037],["thread",8561323],["thread",8561289],["thread",8557155],["thread",8555242],["thread",8552401],["thread",8552068],["thread",8548497],["thread",8548406],["thread",8544146],["thread",8543361],["thread",8543042],["thread",8542143],["thread",8541257],["thread",8540815],["thread",8540585],["thread",8540223],["thread",8538652],["thread",8538500],["thread",8538363],["thread",8537435],["thread",8535268],["thread",8530827],["thread",8530820],["thread",8525786],["thread",8525015],["thread",8519249],["thread",8515133],["thread",8513546],["thread",8512680],["thread",8512140],["thread",8511467],["thread",8508779],["thread",8508771],["thread",8507761],["thread",8507754],["thread",8507753],["thread",8504278],["thread",8503108],["thread",8502332],["thread",8502140],["thread",8499707],["thread",8497662],["thread",8494402],["thread",8494380],["thread",8493930],["thread",8491492],["thread",8490066],["thread",8489813],["thread",8488154],["thread",8488150],["thread",8487902],["thread",8485651],["thread",8484378],["thread",8484164],["thread",8476517],["thread",8475712],["thread",8474976],["thread",8474397],["thread",8472426],["thread",8465351],["thread",8465139],["thread",8463087],["thread",8461799],["thread",8460879],["thread",8459925],["thread",8453051],["thread",8452796],["thread",8451929],["thread",8451001],["thread",8450798],["thread",8450606],["thread",8450574],["thread",8450213],["thread",8449811],["thread",8447280],["thread",8445968],["thread",8443700],["thread",8442972],["thread",8441939],["thread",8441421],["thread",8441340],["thread",8441018],["thread",8441010],["thread",8439813],["thread",8439679],["thread",8439016],["thread",8438944],["thread",8438919],["thread",8437568],["thread",8437507],["thread",8435956],["thread",8435038],["thread",8434481],["thread",8433862],["thread",8433202],["thread",8430267],["thread",8425577],["thread",8425398],["thread",8425241],["thread",8424400],["thread",8424257],["thread",8424019],["thread",8423720],["thread",8422545],["thread",8421068],["thread",8418376],["thread",8418317],["thread",8417584],["thread",8417260],["thread",8416230],["thread",8416169],["thread",8415752],["thread",8415647],["thread",8414887],["thread",8414856],["thread",8413497],["thread",8413311],["thread",8411862],["thread",8410152],["thread",8410115],["thread",8408899],["thread",8408567],["thread",8408000],["thread",8406840],["thread",8404850],["thread",8404819],["thread",8404515],["thread",8402757],["thread",8402047],["thread",8401806],["thread",8401782],["thread",8401694],["thread",8401475],["thread",8399632],["thread",8398394],["thread",8398299],["thread",8393181],["thread",8392027],["thread",8390792],["thread",8389893],["thread",8389651],["thread",8389518],["thread",8387006],["thread",8386239],["thread",8386234],["thread",8383636],["thread",8380588],["thread",8380344],["thread",8379502],["thread",8378874],["thread",8378048],["thread",8377831],["thread",8377808],["thread",8377802],["thread",8377632],["thread",8376468],["thread",8376337],["thread",8375230],["thread",8374224],["thread",8373701],["thread",8371684],["thread",8371306],["thread",8371016],["thread",8368913],["thread",8367553],["thread",8364724],["thread",8364701],["thread",8364681],["thread",8363503],["thread",8363155],["thread",8362690],["thread",8360873],["thread",8359451],["thread",8358892],["thread",8358027],["thread",8356003],["thread",8355190],["thread",8354142],["thread",8350963],["thread",8350513],["thread",8350338],["thread",8347701],["thread",8347620],["thread",8347162],["thread",8346373],["thread",8345411],["thread",8345132],["thread",8343293],["thread",8342341],["thread",8341659],["thread",8341482],["thread",8340683],["thread",8339489],["thread",8339478],["thread",8339428],["thread",8339170],["thread",8336407],["thread",8335686],["thread",8335569],["thread",8335138],["thread",8334210],["thread",8331074],["thread",8330813],["thread",8327098],["thread",8326104],["thread",8325663],["thread",8322570],["thread",8321581],["thread",8318008],["thread",8316831],["thread",8316121],["thread",8315835],["thread",8315093],["thread",8312515],["thread",8312396],["thread",8312393],["thread",8311483],["thread",8310077],["thread",8310058],["thread",8309748],["thread",8308358],["thread",8307856],["thread",8306215],["thread",8306129],["thread",8305072],["thread",8302874],["thread",8302841],["thread",8300819],["thread",8299595],["thread",8299153],["thread",8298644],["thread",8298620],["thread",8297788],["thread",8297773],["thread",8296692],["thread",8295581],["thread",8294908],["thread",8294525],["thread",8294502],["thread",8294416],["thread",8291581],["thread",8291164],["thread",8290928],["thread",8290887],["thread",8290101],["thread",8289613],["thread",8288586],["thread",8287469],["thread",8286396],["thread",8285143],["thread",8284840],["thread",8283972],["thread",8283583],["thread",8283064],["thread",8282897],["thread",8281747],["thread",8281619],["thread",8280635],["thread",8280248],["thread",8280223],["thread",8279332],["thread",8277680],["thread",8276660],["thread",8276497],["thread",8274850],["thread",8274754],["thread",8273315],["thread",8272989],["thread",8272926],["thread",8272852],["thread",8272619],["thread",8272338],["thread",8270859],["thread",8269639],["thread",8267828],["thread",8266340],["thread",8265659],["thread",8265084],["thread",8265064],["thread",8264916],["thread",8264570],["thread",8263769],["thread",8263187],["thread",8263152],["thread",8262621],["thread",8261697],["thread",8261644],["thread",8261209],["thread",8259964],["thread",8257851],["thread",8257550],["thread",8257457],["thread",8255202],["thread",8254564],["thread",8254516],["thread",8254278],["thread",8253565],["thread",8252930],["thread",8252515],["thread",8252338],["thread",8251127],["thread",8250801],["thread",8249989],["thread",8249977],["thread",8249968],["thread",8249956],["thread",8248657],["thread",8248647],["thread",8246292],["thread",8245610],["thread",8244745],["thread",8244282],["thread",8243968],["thread",8242650],["thread",8240311],["thread",8239527],["thread",8238905],["thread",8237004],["thread",8236872],["thread",8236462],["thread",8235705],["thread",8235412],["thread",8234822],["thread",8234080],["thread",8230018],["thread",8226530],["thread",8225443],["thread",8224039],["thread",8223670],["thread",8222602],["thread",8219833],["thread",8219538],["thread",8219176],["thread",8218571],["thread",8216252],["thread",8215614],["thread",8215016],["thread",8214440],["thread",8213919],["thread",8213668],["thread",8212695],["thread",8212382],["thread",8211727],["thread",8210932],["thread",8210769],["thread",8207726],["thread",8207679],["thread",8207667],["thread",8207533],["thread",8207335],["thread",8206995],["thread",8206771],["thread",8206491],["thread",8206452],["thread",8203082],["thread",8197834],["thread",8197407],["thread",8194517],["thread",8194378],["thread",8189406],["thread",8183986],["thread",8183919],["thread",8182600],["thread",8182584],["thread",8182578],["thread",8182286],["thread",8181332],["thread",8180294],["thread",8177626],["thread",8176293],["thread",8175896],["thread",8173873],["thread",8173861],["thread",8173088],["thread",8172709],["thread",8172506],["thread",8172375],["thread",8172077],["thread",8169059],["thread",8168565],["thread",8168564],["thread",8162917],["thread",8162060],["thread",8161856],["thread",8159196],["thread",8157163],["thread",8155809],["thread",8155676],["thread",8153504],["thread",8153443],["thread",8153273],["thread",8071470],["thread",7895267],["thread",7219044],["thread",7112185],["thread",7091884],["thread",6546073],["thread",5195113]], 501, tinhte_xentag_tag, , {"tags":["du l\u1ecbch d\u1ecbch v\u1ee5"]}, date, 0, , [], 0, 1660512241, 28e2b295b2041023410dccb046284d42
Run Time: 0.000966