Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 4
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Notifications
• Serializer
• Elastica
• Configuration

Query Metrics

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

[
  "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 = ?
LIMIT
  1

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;

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

[
  "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 = ?
LIMIT
  1

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;

SELECT user1_id, user2_id
            FROM communication.conversation
            WHERE id = ?

[
  "0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
]

SELECT
  user1_id,
  user2_id
FROM
  communication.conversation
WHERE
  id = ?

SELECT user1_id, user2_id
            FROM communication.conversation
            WHERE id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea';

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"
]

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 = ?

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';

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 = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#899
    __toString(): "7bb2c305-0384-40ee-8c13-f490a91adbeb"
  }
]

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';

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 = ?

[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#815
    __toString(): "b19cf6bf-4799-4796-aa11-ee31467761cd"
  }
]

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';

SELECT id, sender_id, sent, message_data 
            FROM communication.messages
            WHERE conversation_id = ?
            ORDER BY sent

[
  "0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
]

SELECT
  id,
  sender_id,
  sent,
  message_data
FROM
  communication.messages
WHERE
  conversation_id = ?
ORDER BY
  sent

SELECT id, sender_id, sent, message_data 
            FROM communication.messages
            WHERE conversation_id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea'
            ORDER BY sent;

UPDATE communication.messages SET is_read = TRUE
                              WHERE conversation_id = ? AND sender_id != ?

[
  "0b9bfe11-b9bd-4400-bcf9-aab81ea120ea"
  "b19cf6bf-4799-4796-aa11-ee31467761cd"
]

UPDATE
  communication.messages
SET
  is_read = TRUE
WHERE
  conversation_id = ?
  AND sender_id != ?

UPDATE communication.messages SET is_read = TRUE
                              WHERE conversation_id = '0b9bfe11-b9bd-4400-bcf9-aab81ea120ea' AND sender_id != 'b19cf6bf-4799-4796-aa11-ee31467761cd';