1 |
2.86 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"Qwert@ma.r"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.email = 'Qwert@ma.r' LIMIT 1;
|
2 |
0.33 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"Qwert@ma.r"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.email = 'Qwert@ma.r' LIMIT 1;
|
3 |
0.63 ms |
SELECT user1_id, user2_id
FROM communication.conversation
WHERE id = ?
Parameters: [
"0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
]
SELECT user1_id, user2_id
FROM communication.conversation
WHERE id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea';
|
4 |
0.19 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.id = ?
Parameters: [
"7bb2c305-0384-40ee-8c13-f490a91adbeb"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM "account"."user" t0 WHERE t0.id = '7bb2c305-0384-40ee-8c13-f490a91adbeb';
|
5 |
0.70 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = '7bb2c305-0384-40ee-8c13-f490a91adbeb';
|
6 |
0.17 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = 'b19cf6bf-4799-4796-aa11-ee31467761cd';
|
7 |
1.07 ms |
SELECT id, sender_id, sent, message_data
FROM communication.messages
WHERE conversation_id = ?
ORDER BY sent
Parameters: [
"0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
]
SELECT id, sender_id, sent, message_data
FROM communication.messages
WHERE conversation_id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea'
ORDER BY sent;
|
8 |
0.29 ms |
UPDATE communication.messages SET is_read = TRUE
WHERE conversation_id = ? AND sender_id != ?
Parameters: [
"0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
"b19cf6bf-4799-4796-aa11-ee31467761cd"
]
UPDATE communication.messages SET is_read = TRUE
WHERE conversation_id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea' AND sender_id != 'b19cf6bf-4799-4796-aa11-ee31467761cd';
|