SELECT conversation_master.*,
conversation_user.*,
conversation_starter.*,
conversation_message.username AS username,
conversation_recipient.recipient_state, conversation_recipient.last_read_date,
conversation_message.*
FROM xf_conversation_message AS conversation_message
INNER JOIN xf_conversation_user AS conversation_user ON
(conversation_message.conversation_id = conversation_user.conversation_id)
INNER JOIN xf_conversation_master AS conversation_master ON
(conversation_user.conversation_id = conversation_master.conversation_id)
INNER JOIN xf_conversation_recipient AS conversation_recipient ON
(conversation_user.conversation_id = conversation_recipient.conversation_id
AND conversation_user.owner_user_id = conversation_recipient.user_id)
INNER JOIN xf_user AS conversation_starter ON
(conversation_starter.user_id = conversation_message.user_id)
WHERE conversation_user.owner_user_id = ?
AND conversation_message.message_id IN (23797, 23688, 23460, 23197, 23091, 22792, 22338, 22202, 22130, 22112, 22108, 22102, 22077, 21793, 21603, 21482, 21338, 21330, 21329, 21327, 21319, 21262, 21261, 21222, 21221, 21050, 21010, 21007, 20903, 20886, 20377, 20371, 20370, 20363, 20358, 19822, 19646, 19619, 19504, 19496, 19491, 19489, 19479, 19187, 19175, 19105, 19000, 18956, 18834, 18786, 18784, 18772, 18740, 18613, 18610, 18606, 18598, 18532, 18518, 18514, 18513, 18504, 18495, 18491, 18482, 18480, 18479, 18476, 18468, 18295, 18026, 17585, 17580, 16643, 16637, 16627, 16624, 16614, 16538, 15770, 15711, 15658, 15657, 15656, 15617, 14739, 14142, 12409, 11803, 11799, 11461, 11444, 11433, 11405, 11321, 10914, 10736, 10711, 10706, 10386, 10383, 10343, 10337, 10327, 10287, 10250, 10248, 10236, 10225, 10095, 10093, 10034, 10031, 10028, 10026, 10023, 10019, 10017, 10015, 10010, 9974, 9969, 9967, 9960, 9956, 9955, 9954, 9941, 9937, 9931, 9930, 9915, 9880, 9849, 9835, 9826, 9793, 9792, 9718, 9714, 9712, 9710, 9707, 9677, 9671, 9667, 9605, 9600, 9585, 9583, 9582, 9576, 9575, 9573, 9570, 9566, 9564, 9510, 9509, 9499, 9475, 9472, 9466, 9465, 9458, 9454, 9453, 9451, 9448, 9435, 9432, 9429, 9416, 9369, 9343, 9341, 9319, 9315, 9311, 9308, 9295, 9282, 9222, 9221, 9214, 9199, 9114, 9110, 9106, 9097, 9094, 9086, 9081, 9074, 9049, 9040, 9038, 9033, 9025, 9013)
ORDER BY conversation_user.last_message_date DESC
Params: 0
Run Time: 0.001814
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | conversation_user | ref | PRIMARY,owner_user_id_last_message_date,owner_user_id_is_unread,owner_starred_date | owner_user_id_last_message_date | 4 | const | 1 | Using where |
SIMPLE | conversation_recipient | eq_ref | PRIMARY,user_id | PRIMARY | 8 | k46624_forum.conversation_user.conversation_id,const | 1 | Using where |
SIMPLE | conversation_master | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.conversation_user.conversation_id | 1 | |
SIMPLE | conversation_message | ref | PRIMARY,conversation_id_message_date,user_id | conversation_id_message_date | 4 | k46624_forum.conversation_user.conversation_id | 9 | Using index condition |
SIMPLE | conversation_starter | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.conversation_message.user_id | 1 | |