Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails 1
• VichUploader
• Configuration

Query Metrics

SELECT pg_try_advisory_lock(1)

[]

SELECT
  pg_try_advisory_lock(1)

SELECT pg_try_advisory_lock(1);

select m.id from message m where m.sent = false and m.scheduled_at <= now()

[]

select
  m.id
from
  message m
where
  m.sent = false
  and m.scheduled_at <= now()

select m.id from message m where m.sent = false and m.scheduled_at <= now();

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.target AS target_3, t0.subject AS subject_4, t0.twig AS twig_5, t0.data AS data_6, t0.sent AS sent_7, t0.scheduled_at AS scheduled_at_8, t0.send_at AS send_at_9, t0.from_email AS from_email_10, t0.from_name AS from_name_11, t0.reply_to AS reply_to_12 FROM message t0 WHERE t0.id = ?

[
  "a581c37c-9eec-b568-9128-31f0e7eb5fb9"
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.target AS target_3,
  t0.subject AS subject_4,
  t0.twig AS twig_5,
  t0.data AS data_6,
  t0.sent AS sent_7,
  t0.scheduled_at AS scheduled_at_8,
  t0.send_at AS send_at_9,
  t0.from_email AS from_email_10,
  t0.from_name AS from_name_11,
  t0.reply_to AS reply_to_12
FROM
  message t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.target AS target_3, t0.subject AS subject_4, t0.twig AS twig_5, t0.data AS data_6, t0.sent AS sent_7, t0.scheduled_at AS scheduled_at_8, t0.send_at AS send_at_9, t0.from_email AS from_email_10, t0.from_name AS from_name_11, t0.reply_to AS reply_to_12 FROM message t0 WHERE t0.id = 'a581c37c-9eec-b568-9128-31f0e7eb5fb9';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE message SET sent = ?, send_at = ? WHERE id = ?

[
  1
  "2025-05-14 19:50:00"
  "a581c37c-9eec-b568-9128-31f0e7eb5fb9"
]

UPDATE
  message
SET
  sent = ?,
  send_at = ?
WHERE
  id = ?

UPDATE message SET sent = 1, send_at = '2025-05-14 19:50:00' WHERE id = 'a581c37c-9eec-b568-9128-31f0e7eb5fb9';

"COMMIT"

[]

"COMMIT"

"COMMIT";

select pg_advisory_unlock(1)

[]

select
  pg_advisory_unlock(1)

select pg_advisory_unlock(1);

select q.id 
            from smartemailing_queue q 
            where processed_at is null

[]

select
  q.id
from
  smartemailing_queue q
where
  processed_at is null

select q.id 
            from smartemailing_queue q 
            where processed_at is null
        ;