Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 321
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT 
            m.id,
            m.content,
            m.created_at,
            m.is_read,

            s.id as sender_id,
            s.firstname as sender_firstname,
            s.email as sender_email,

            r.id as receiver_id,
            r.firstname as receiver_firstname,
            r.email as receiver_email

        FROM message m

        INNER JOIN (
            SELECT sender_id, MAX(created_at) as last_date
            FROM message
            WHERE receiver_id = :userId
            GROUP BY sender_id
        ) last_messages

        ON m.sender_id = last_messages.sender_id 
        AND m.created_at = last_messages.last_date

        JOIN user s ON s.id = m.sender_id
        JOIN user r ON r.id = m.receiver_id

        WHERE m.receiver_id = :userId
        ORDER BY m.created_at DESC

[
  "userId" => 6
]

SELECT
  m.id,
  m.content,
  m.created_at,
  m.is_read,
  s.id as sender_id,
  s.firstname as sender_firstname,
  s.email as sender_email,
  r.id as receiver_id,
  r.firstname as receiver_firstname,
  r.email as receiver_email
FROM
  message m
  INNER JOIN (
    SELECT
      sender_id,
      MAX(created_at) as last_date
    FROM
      message
    WHERE
      receiver_id = :userId
    GROUP BY
      sender_id
  ) last_messages ON m.sender_id = last_messages.sender_id
  AND m.created_at = last_messages.last_date
  JOIN user s ON s.id = m.sender_id
  JOIN user r ON r.id = m.receiver_id
WHERE
  m.receiver_id = :userId
ORDER BY
  m.created_at DESC

SELECT 
            m.id,
            m.content,
            m.created_at,
            m.is_read,

            s.id as sender_id,
            s.firstname as sender_firstname,
            s.email as sender_email,

            r.id as receiver_id,
            r.firstname as receiver_firstname,
            r.email as receiver_email

        FROM message m

        INNER JOIN (
            SELECT sender_id, MAX(created_at) as last_date
            FROM message
            WHERE receiver_id = 6
            GROUP BY sender_id
        ) last_messages

        ON m.sender_id = last_messages.sender_id 
        AND m.created_at = last_messages.last_date

        JOIN user s ON s.id = m.sender_id
        JOIN user r ON r.id = m.receiver_id

        WHERE m.receiver_id = 6
        ORDER BY m.created_at DESC
    ;