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 (9568155, 9567073, 9565856, 9560648, 9558337, 9558210, 9553317, 9543361, 9541095, 9539103, 9535647, 9532905, 9531701, 9530701, 9529730, 9528635, 9527120, 9525358, 9524881, 9523649, 9501120, 9494443, 9444257, 9444254, 9440090, 9436452, 9425968, 9418799, 9418793, 9417844, 9414661, 9413958, 9407137, 9393603, 9389573, 9388364, 9387814, 9385637, 9383755, 9383589, 9383583, 9383577, 9383311, 9382361, 9376032, 9374629, 9374190, 9374189, 9373883, 9373441, 9373150, 9372891, 9368505, 9368469, 9368468, 9357896, 9354821, 9351812, 9351807, 9351718, 9350758, 9347862, 9344633, 9344398, 9344271, 9342681, 9341578, 9334835, 9334540, 9334103, 9333882, 9333592, 9330688, 9330299, 9327818, 9326669, 9326665, 9320651, 9312496, 9305464, 9303397, 9293011, 9285331, 9280158, 9278560, 9275355, 9275249, 9267712, 9258979, 9256039, 9252456, 9251456, 9250858, 9248351, 9242199, 9241847, 9241347, 9235696, 9231888, 9231819, 9225355, 9224274, 9221084, 9219534, 9218957, 9213426, 9211908, 9208058, 9201478, 9195206, 9194251, 9193461, 9192559, 9190783, 9185298, 9180935, 9179480, 9176924, 9173929, 9173927, 9173926, 9173402, 9170555, 9167097, 9167037, 9166197, 9165799, 9164656, 9158599, 9142208, 9137724, 9135363, 9131212, 9131136, 9130408, 9120585, 9120054, 9118832, 9115718, 9110447, 9109391, 9107603, 9106394, 9098981, 9098753, 9097920, 9095917, 9094728, 9093982, 9092422, 9089803, 9088956, 9086244, 9072644, 9071250, 9071182, 9068146, 9059267, 9057934, 9056825, 9056760, 9056756, 9056752, 9052706, 9052323, 9050546, 9049835, 9049296, 9048532, 9046830, 9039026, 9038807, 9037194, 9030046, 9023989, 9023951, 9021159, 9020225, 9019373, 9014895, 9014395, 9010950, 9010949, 9006860, 9006128, 9001753, 9000818, 8997776, 8996932, 8996552, 8991788, 8990569, 8984681, 8983249, 8980165, 8978767, 8971915, 8971079, 8970481, 8969095, 8967915, 8967449, 8966719, 8956302, 8951735, 8950169, 8949958, 8949109, 8945145, 8943760, 8942211, 8936838, 8936837, 8934637, 8933835, 8933834, 8933399, 8932563, 8931622, 8930203, 8913645, 8913611, 8910704, 8905178, 8901108, 8898179, 8896177, 8896079, 8892660, 8892063, 8887395, 8884665, 8884095, 8882137, 8879271, 8878122, 8875201, 8873321, 8873079, 8864910, 8863733, 8863332, 8862237, 8857435, 8857011, 8855975, 8855974, 8853622, 8853453, 8852754, 8852273, 8852219, 8851891, 8851362, 8849947, 8849848, 8848083, 8848059, 8847840, 8847503, 8846297, 8845639, 8843011, 8842302, 8841461, 8841267, 8837933, 8835717, 8835701, 8835135, 8828436, 8827303, 8825897, 8825272, 8823825, 8823660, 8821167, 8819806, 8819605, 8817979, 8816660, 8815417, 8814678, 8813192, 8807239, 8801048, 8800716, 8799915, 8799744, 8782322, 8779310, 8777344, 8776467, 8775135, 8775133, 8775132, 8775131, 8771316, 8768825, 8766155, 8756479, 8755971, 8753562, 8748491, 8748490, 8748489, 8747552, 8745729, 8744039, 8743864, 8742121, 8741048, 8741047, 8740895, 8734911, 8732867, 8732673, 8732149, 8730726, 8730595, 8730424, 8725655, 8721840, 8721839, 8716803, 8716680, 8716679, 8715130, 8712267, 8708916, 8708915, 8706512, 8699017, 8696581, 8694747, 8686967, 8682740, 8679862, 8679498, 8678104, 8677789, 8673128, 8666487, 8664824, 8654480, 8649280, 8648432, 8640570, 8640064, 8636287, 8626456, 8625613, 8620606, 8618101, 8613345, 8611654, 8611048, 8609409, 8608849, 8606284, 8596073, 8592031, 8587758, 8580563, 8578879, 8578875, 8578851, 8569268, 8568465, 8568207, 8567239, 8565296, 8562119, 8558705, 8554504, 8551750, 8546756, 8544090, 8541290, 8536936, 8534592, 8529213, 8528258, 8527733, 8516624, 8507830, 8507807, 8507279, 8506525, 8502767, 8501688, 8471479, 8434168, 8429601, 8399708, 8376051, 8334499, 8326510, 8113008)
Run Time: 0.010276
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 399 | 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",9558210],["thread",9530701],["thread",9494443],["thread",9436452],["thread",9385637],["thread",9383755],["thread",9383589],["thread",9383583],["thread",9383577],["thread",9376032],["thread",9373150],["thread",9372891],["thread",9368505],["thread",9357896],["thread",9347862],["thread",9334103],["thread",9333882],["thread",9333592],["thread",9305464],["thread",9280158],["thread",9267712],["thread",9250858],["thread",9242199],["thread",9231888],["thread",9231819],["thread",9221084],["thread",9219534],["thread",9218957],["thread",9173929],["thread",9173927],["thread",9173926],["thread",9170555],["thread",9166197],["thread",9164656],["thread",9158599],["thread",9120585],["thread",9110447],["thread",9109391],["thread",9089803],["thread",9072644],["thread",9059267],["thread",9057934],["thread",9049835],["thread",9023989],["thread",9014395],["thread",8983249],["thread",8978767],["thread",8971079],["thread",8969095],["thread",8956302],["thread",8945145],["thread",8934637],["thread",8933399],["thread",8932563],["thread",8905178],["thread",8901108],["thread",8898179],["thread",8892660],["thread",8879271],["thread",8878122],["thread",8864910],["thread",8862237],["thread",8857435],["thread",8851891],["thread",8849848],["thread",8847840],["thread",8847503],["thread",8837933],["thread",8821167],["thread",8801048],["thread",8800716],["thread",8799915],["thread",8766155],["thread",8756479],["thread",8725655],["thread",8716680],["thread",8715130],["thread",8699017],["thread",8694747],["thread",8686967],["thread",8679862],["thread",8677789],["thread",8673128],["thread",8649280],["thread",8640570],["thread",8640064],["thread",8626456],["thread",8620606],["thread",8618101],["thread",8613345],["thread",8611048],["thread",8609409],["thread",8608849],["thread",8606284],["thread",8587758],["thread",8580563],["thread",8568465],["thread",8567239],["thread",8554504],["thread",8551750],["thread",8546756],["thread",8544090],["thread",8541290],["thread",8534592],["thread",8529213],["thread",8528258],["thread",8527733],["thread",8516624],["thread",8507279],["thread",8501688],["thread",8429601],["thread",8399708],["thread",8376051],["thread",8334499],["thread",8326510],["thread",8113008]], 116, tinhte_xentag_tag, , {"tags":["\u0111i\u1ec7n tho\u1ea1i lg"]}, date, 0, , [], 0, 1653077503, bbbc74e8db5ca86fa754896b3baa792d
Run Time: 0.000699