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 (9647181, 9485668, 9485665, 9485653, 9482133, 9480628, 9461715, 9461703, 9461684, 9461683, 9459372, 9459370, 9448178, 9448147, 9442569, 9438289, 9437737, 9437701, 9433736, 9433646, 9425636, 9425634, 9425620, 9418243, 9404015, 9403993, 9403952, 9396913, 9396903, 9396892, 9396888, 9396891, 9396879, 9396877, 9394225, 9389812, 9386837, 9386801, 9385074, 9381398, 9381374, 9381367, 9380536, 9372645, 9356165, 9350947, 9347489, 9347469, 9347467, 9344349, 9343672, 9342239, 9333265, 9329355, 9329354, 9329333, 9326419, 9326418, 9326392, 9323035, 9323034, 9323030, 9323029, 9323009, 9323008, 9323005, 9323000, 9321470, 9319863, 9317002, 9316995, 9316994, 9290129, 9287984, 9259212, 9258593, 9257956, 9257926, 9257925, 9257920, 9257911, 9257909, 9255448, 9254868, 9254867, 9254506, 9254114, 9254101, 9252869, 9252862, 9252811, 9249212, 9244811, 9240218, 9235488, 9235430, 9233869, 9233862, 9233856, 9233812, 9233788, 9233691, 9227470, 9225131, 9224827, 9224144, 9222075, 9222068, 9222041, 9222040, 9222033, 9220743, 9220114, 9220079, 9220075, 9220064, 9220036, 9220033, 9220023, 9220007, 9216754, 9214954, 9214305, 9214288, 9214283, 9214242, 9213404, 9213359, 9212782, 9212477, 9211599, 9210384, 9210369, 9208518, 9190242, 9185656, 9185655, 9175047, 9161383, 9150022, 9147630, 9140324, 9123980, 9113217, 9110985, 9093251, 9091154, 9065900, 9055248, 9054131, 9037099, 9037091, 9031743, 8995252, 8988425, 8961875, 8961791, 8940108, 8940107, 8939466, 8937839, 8928537, 8925365, 8915112, 8906012, 8905919, 8899283, 8896861, 8894571, 8893233, 8892027, 8887433, 8885498, 8885496, 8883178, 8882905, 8881330, 8880114, 8880113, 8880112, 8880111, 8875641, 8875640, 8871679, 8870022, 8870021, 8866546, 8866542, 8866541, 8866538, 8859582, 8859580, 8859579, 8857993, 8856094, 8854520, 8853947, 8853942, 8853933, 8853931, 8852355, 8850602, 8850588, 8850422, 8850417, 8849064, 8848954, 8848623, 8848551, 8848548, 8847750, 8843186, 8842937, 8840821, 8839517, 8837385, 8836900, 8833625, 8832924, 8831518, 8830502, 8828075, 8815890, 8815137, 8814134, 8811872, 8808753, 8808744, 8804983, 8804980, 8804970, 8802074, 8799174, 8796269, 8795130, 8793483, 8791691, 8791033, 8790525, 8782613, 8782610, 8781708, 8781051, 8773370, 8765275, 8763811, 8763069, 8762428, 8756491, 8752443, 8750276, 8750274, 8747971, 8747511, 8743025, 8743024, 8741889, 8741884, 8741245, 8740565, 8734310, 8731467, 8731465, 8727008, 8725820, 8725314, 8723877, 8722091, 8719759, 8719747, 8718980, 8718979, 8718774, 8718311, 8718309, 8718284, 8718283, 8716795, 8716465, 8713781, 8713780, 8710692, 8710691, 8710690, 8710595, 8710587, 8710585, 8710580, 8709710, 8709489, 8709488, 8709453, 8707394, 8707348, 8705899, 8705898, 8705378, 8702853, 8702192, 8699714, 8695958, 8695490, 8694168, 8693677, 8692733, 8687386, 8687251, 8686752, 8685252, 8685220, 8684461, 8683897, 8682847, 8680691, 8679878, 8679570, 8677864, 8676063, 8676040, 8674116, 8673129, 8669428, 8668890, 8668410, 8666607, 8664191, 8661731, 8657209, 8655540, 8654926, 8654796, 8648768, 8646079, 8643983, 8643338, 8643057, 8639023, 8638144, 8638073, 8635846, 8634775, 8633477, 8633410, 8632586, 8629857, 8628934, 8628189, 8626385, 8626356, 8623947, 8622399, 8622390, 8620380, 8619874, 8619150, 8618087, 8618084, 8614461, 8614438, 8607806, 8605995, 8599590, 8598990, 8596198, 8589706, 8589312, 8587278, 8580279, 8577835, 8576960, 8571857, 8571395, 8571259, 8570779, 8569482, 8566857, 8561308, 8559525, 8558301, 8557469, 8555384, 8548231, 8545719, 8545524, 8544618, 8544198, 8544197, 8542840, 8542137, 8541635, 8540493, 8540492, 8537685, 8535042, 8533829, 8533177, 8528833, 8528832, 8528831, 8525928, 8525438, 8524893, 8524548, 8522756, 8522755, 8522407, 8518393, 8517854, 8507715, 8506210, 8502978, 8502434, 8500030, 8496993, 8492291, 8489871, 8489576, 8486059, 8452637, 8448243, 8448099, 8443792, 8435519, 8425371, 8423872, 8418725, 8418149, 8411899, 8411353, 8395361, 8391750, 8388441, 8381893, 8374572, 8368423, 8363293, 8355626, 8347208, 8326845, 8322809, 8294797, 8291125, 8286810, 8286565, 8284103, 8283139, 8251036, 8248551, 8243316, 8241178, 8240380, 8239707, 8236041, 8233282, 8228449, 8223665, 8222460, 8217350, 8216395, 8146941, 7964002, 7569675, 7561493, 7544500)
Run Time: 0.010572
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 464 | 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",27],["thread",9356165],["thread",9287984],["thread",9123980],["thread",9091154],["thread",9065900],["thread",8940108],["thread",8937839],["thread",8928537],["thread",8925365],["thread",8899283],["thread",8894571],["thread",8883178],["thread",8880114],["thread",8870022],["thread",8854520],["thread",8848954],["thread",8848623],["thread",8848548],["thread",8843186],["thread",8836900],["thread",8828075],["thread",8815890],["thread",8799174],["thread",8796269],["thread",8763069],["thread",8762428],["thread",8752443],["thread",8740565],["thread",8734310],["thread",8723877],["thread",8718980],["thread",8718311],["thread",8716465],["thread",8713781],["thread",8709710],["thread",8709489],["thread",8709453],["thread",8707348],["thread",8702853],["thread",8699714],["thread",8687386],["thread",8686752],["thread",8684461],["thread",8680691],["thread",8676063],["thread",8676040],["thread",8668890],["thread",8655540],["thread",8654796],["thread",8648768],["thread",8643983],["thread",8639023],["thread",8638073],["thread",8628934],["thread",8628189],["thread",8626385],["thread",8626356],["thread",8622390],["thread",8620380],["thread",8619150],["thread",8618087],["thread",8614461],["thread",8607806],["thread",8598990],["thread",8589706],["thread",8587278],["thread",8580279],["thread",8577835],["thread",8570779],["thread",8569482],["thread",8561308],["thread",8555384],["thread",8548231],["thread",8545524],["thread",8544198],["thread",8542137],["thread",8541635],["thread",8537685],["thread",8533829],["thread",8525928],["thread",8524893],["thread",8522407],["thread",8518393],["thread",8517854],["thread",8507715],["thread",8502978],["thread",8502434],["thread",8500030],["thread",8492291],["thread",8489871],["thread",8486059],["thread",8448243],["thread",8448099],["thread",8443792],["thread",8435519],["thread",8425371],["thread",8423872],["thread",8418725],["thread",8418149],["thread",8411899],["thread",8411353],["thread",8395361],["thread",8391750],["thread",8388441],["thread",8381893],["thread",8368423],["thread",8363293],["thread",8355626],["thread",8347208],["thread",8322809],["thread",8294797],["thread",8291125],["thread",8286810],["thread",8286565],["thread",8284103],["thread",8283139],["thread",8251036],["thread",8248551],["thread",8239707],["thread",8236041],["thread",8233282],["thread",8228449],["thread",8223665],["thread",8222460],["thread",8217350],["thread",8216395],["thread",8146941],["thread",7964002],["thread",7569675],["thread",7544500]], 131, tinhte_xentag_tag, , {"tags":["dell latitude e6420"]}, date, 0, , [], 0, 1660205622, 463c8eff7a863c39b66e14b4e514d036
Run Time: 0.000555