Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT pc.name, COUNT(s.id) as count
            FROM subscription s
            JOIN payment_connector pc ON s.payment_connector_id = pc.id
            WHERE s.created_at >= ? AND s.is_test = false
            GROUP BY pc.id, pc.name
            ORDER BY count DESC
            LIMIT 8

[
  "2025-12-01 00:00:00"
]

SELECT
  pc.name,
  COUNT(s.id) as count
FROM
  subscription s
  JOIN payment_connector pc ON s.payment_connector_id = pc.id
WHERE
  s.created_at >= ?
  AND s.is_test = false
GROUP BY
  pc.id,
  pc.name
ORDER BY
  count DESC
LIMIT
  8

SELECT pc.name, COUNT(s.id) as count
            FROM subscription s
            JOIN payment_connector pc ON s.payment_connector_id = pc.id
            WHERE s.created_at >= '2025-12-01 00:00:00' AND s.is_test = false
            GROUP BY pc.id, pc.name
            ORDER BY count DESC
            LIMIT 8
        ;

SELECT DATE(created_at) as day, COALESCE(SUM(eur_amount), 0) as revenue
            FROM charge
            WHERE created_at >= ? AND status = ? AND is_test = false
            GROUP BY DATE(created_at)

[
  "2025-11-16 00:00:00"
  2
]

SELECT
  DATE(created_at) as day,
  COALESCE(
    SUM(eur_amount),
    0
  ) as revenue
FROM
  charge
WHERE
  created_at >= ?
  AND status = ?
  AND is_test = false
GROUP BY
  DATE(created_at)

SELECT DATE(created_at) as day, COALESCE(SUM(eur_amount), 0) as revenue
            FROM charge
            WHERE created_at >= '2025-11-16 00:00:00' AND status = 2 AND is_test = false
            GROUP BY DATE(created_at)
        ;

SELECT
                DATE(created_at) as day,
                SUM(CASE WHEN is_confirmed = true THEN 1 ELSE 0 END) as confirmed,
                SUM(CASE WHEN is_confirmed = false THEN 1 ELSE 0 END) as pending
            FROM subscription
            WHERE created_at >= ? AND is_test = false
            GROUP BY DATE(created_at)

[
  "2025-11-16 00:00:00"
]

SELECT
  DATE(created_at) as day,
  SUM(
    CASE WHEN is_confirmed = true THEN
      1
    ELSE
      0
    END
  ) as confirmed,
  SUM(
    CASE WHEN is_confirmed = false THEN
      1
    ELSE
      0
    END
  ) as pending
FROM
  subscription
WHERE
  created_at >= ?
  AND is_test = false
GROUP BY
  DATE(created_at)

SELECT
                DATE(created_at) as day,
                SUM(CASE WHEN is_confirmed = true THEN 1 ELSE 0 END) as confirmed,
                SUM(CASE WHEN is_confirmed = false THEN 1 ELSE 0 END) as pending
            FROM subscription
            WHERE created_at >= '2025-11-16 00:00:00' AND is_test = false
            GROUP BY DATE(created_at)
        ;

SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone_number AS phone_number_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM "user" t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.email AS email_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone_number AS phone_number_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.is_verified AS is_verified_7,
  t0.id AS id_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone_number AS phone_number_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM "user" t0 WHERE t0.id = 1;