GET https://sezam.space/cron/fe96586f-4fb6-c2cf-3812-cbc28f43c8e7

Query Metrics

24 Database Queries
7 Different statements
70.94 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

# Time Info
1 1.96 ms
SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM config t0
Parameters:
[]
2 0.87 ms
SELECT pg_try_advisory_lock(1)
Parameters:
[]
3 35.99 ms
select m.id from message m where m.sent = false and m.scheduled_at <= now()
Parameters:
[]
4 1.03 ms
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 = ?
Parameters:
[
  "490f8ba6-69ce-409f-1842-f03192ebac5f"
]
5 0.75 ms
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 = ?
Parameters:
[
  "33a575b3-9bf3-46b1-ae10-3140135cff84"
]
6 1.32 ms
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 = ?
Parameters:
[
  "519785b6-d9ab-48f2-85ff-bb9ff1f1b008"
]
7 0.65 ms
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 = ?
Parameters:
[
  "748a0c17-ee09-4711-acdb-534a7c9bf880"
]
8 0.58 ms
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 = ?
Parameters:
[
  "892ef87f-b6df-44b4-aeeb-f6211afb5d00"
]
9 0.65 ms
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 = ?
Parameters:
[
  "9289c5b2-8fa3-4462-ad5a-218cd6a6451b"
]
10 0.67 ms
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 = ?
Parameters:
[
  "9781eeaa-8d56-486a-8cf7-8709358e3743"
]
11 0.70 ms
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 = ?
Parameters:
[
  "00163629-7281-4e66-b374-c2cd131ce4df"
]
12 0.66 ms
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 = ?
Parameters:
[
  "77bd125d-2400-421a-a3fb-9bae9e592383"
]
13 0.67 ms
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 = ?
Parameters:
[
  "5971d689-db08-44b0-bcec-33449c6e4f36"
]
14 0.68 ms
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 = ?
Parameters:
[
  "0fdd1be9-df5d-4d8b-8203-b9510fed4e6e"
]
15 1.03 ms
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 = ?
Parameters:
[
  "c827560a-1e6b-4ac9-bb49-1684d8ae6c81"
]
16 0.75 ms
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 = ?
Parameters:
[
  "c355b034-eaf5-420c-b293-be1e3862d812"
]
17 0.52 ms
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 = ?
Parameters:
[
  "8597d10f-ccdd-48f8-a9a2-6370152bb045"
]
18 0.64 ms
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 = ?
Parameters:
[
  "7e8992ac-932a-43f7-8323-b5fce3acd833"
]
19 0.57 ms
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 = ?
Parameters:
[
  "a5fbe356-591e-48fa-88e5-e4c9f70c0b07"
]
20 0.69 ms
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 = ?
Parameters:
[
  "f4dc7bc6-a7da-4d39-879e-dcce4ce6a95c"
]
21 0.82 ms
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 = ?
Parameters:
[
  "a67c30aa-3d7e-4966-9769-8c89e91ef857"
]
22 0.84 ms
select pg_advisory_unlock(1)
Parameters:
[]
23 3.59 ms
select q.id 
            from smartemailing_queue q 
            where processed_at is null
Parameters:
[]
24 14.31 ms
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 = ?
Parameters:
[
  "14746713-8699-40e4-a1f2-5d0d849862d0"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Config 20
App\Entity\Message 18
App\Entity\SmartemailingQueue 1

Entities Mapping

Class Mapping errors
App\Entity\Config No errors.
App\Entity\Message No errors.
App\Entity\SmartemailingQueue No errors.