Symfony Profiler

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

Query Metrics

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 pg_try_advisory_lock(1)

[]

SELECT
  pg_try_advisory_lock(1)

SELECT pg_try_advisory_lock(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
        ;

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.birthday AS birthday_5, t0.company AS company_6, t0.list_id AS list_id_7, t0.processed_at AS processed_at_8, t0.response AS response_9 FROM smartemailing_queue t0 WHERE t0.id = ?

[
  "d3c59fe4-38ed-4e57-b4ea-78c907523ca6"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.birthday AS birthday_5,
  t0.company AS company_6,
  t0.list_id AS list_id_7,
  t0.processed_at AS processed_at_8,
  t0.response AS response_9
FROM
  smartemailing_queue t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.birthday AS birthday_5, t0.company AS company_6, t0.list_id AS list_id_7, t0.processed_at AS processed_at_8, t0.response AS response_9 FROM smartemailing_queue t0 WHERE t0.id = 'd3c59fe4-38ed-4e57-b4ea-78c907523ca6';

select pg_advisory_unlock(1)

[]

select
  pg_advisory_unlock(1)

select pg_advisory_unlock(1);