GET https://betatest.sentinelle-securite.com/campagne/0198cc2b-a0e3-708a-936f-53e94c740c26/launch

Query Metrics

24 Database Queries
7 Different statements
4.96 ms Query time
4 Invalid entities
9 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.98 ms
(60.15%)
6
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  """
    O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:28:\"Symfony\\Component\\Mime\\Email\":6:{i:0;N;i:1;N;i:2;s:468:\"<p>Bonjour Christian,</p>\n
    <p>Dans le cadre de la mise en conformité avec les nouvelles normes internes, merci de <a href=\"https://intra-ecobank-docs.com/hr-policy\">cliquer ici</a> pour lire et signer le nouveau règlement intérieur avant ce soir.</p>\n
    <p>Merci,</p>\n
    <p>Direction des Ressources Humaines</p><a href=\"https://betatest.sentinelle-securite.com/campagne/phish/track/0198cc2b-a0e3-708a-936f-53e94c740c26/32000000-0000-0000-0000-000000000000\">Cliquez ici</a>\";i:3;s:5:\"utf-8\";i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:4:{s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:32:\"no-reply@sentinelle-securite.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:8:\"reply-to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:8:\"Reply-To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:31:\"contact@sentinelle-securite.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:17:\"cnzecke@gmail.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:67:\"[URGENT] Signature requise pour le nouveau règlement intérieur RH\";}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}
    """
  "[]"
  "default"
  "2026-02-20 15:58:28"
  "2026-02-20 15:58:28"
]
0.65 ms
(13.05%)
7
"COMMIT"
Parameters:
[]
0.43 ms
(8.74%)
7
"START TRANSACTION"
Parameters:
[]
0.28 ms
(5.57%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.date_lancement AS date_lancement_3, t0.etat AS etat_4, t0.description AS description_5, t0.real_date_lancement AS real_date_lancement_6, t0.entreprise_id AS entreprise_id_7, t0.scenario_id AS scenario_id_8 FROM campagne t0 WHERE t0.id = ?
Parameters:
[
  b"\x01˜Ì+ ãpŠ“oSéLt\f&"
]
0.26 ms
(5.20%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.departement AS departement_7, t0.created_at AS created_at_8, t0.job_fonction AS job_fonction_9, t0.telephone AS telephone_10, t0.actif AS actif_11, t0.organisation_id AS organisation_id_12 FROM `user` t0 INNER JOIN campagne_user ON t0.id = campagne_user.user_id WHERE campagne_user.campagne_id = ?
Parameters:
[
  b"\x01˜Ì+ ãpŠ“oSéLt\f&"
]
0.19 ms
(3.91%)
1
UPDATE campagne SET real_date_lancement = ? WHERE id = ?
Parameters:
[
  "2026-02-20 15:58:28"
  b"\x01˜Ì+ ãpŠ“oSéLt\f&"
]
0.17 ms
(3.37%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sujet_mail AS sujet_mail_3, t0.contenu_html AS contenu_html_4, t0.piecejointe AS piecejointe_5, t0.url_facilite AS url_facilite_6, t0.niveau_difficulte AS niveau_difficulte_7, t0.created_at AS created_at_8 FROM scenario t0 WHERE t0.id = ?
Parameters:
[
  "2\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00"
]

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\User 6
App\Entity\Campagne 1
App\Entity\Organisation 1
App\Entity\Scenario 1

Entities Mapping

Class Mapping errors
App\Entity\Campagne
  • The association App\Entity\Campagne#entreprise refers to the inverse side field App\Entity\Organisation#nom which does not exist.
App\Entity\Organisation
  • The mappings App\Entity\Organisation#campagnes and App\Entity\Campagne#entreprise are inconsistent with each other.
App\Entity\Scenario No errors.
App\Entity\Resultats No errors.
App\Entity\Formation No errors.
App\Entity\User No errors.
App\Entity\Attestation
  • The association App\Entity\Attestation#formation refers to the inverse side field App\Entity\Formation#dateGeneration which does not exist.
App\Entity\UserBadge
  • The association App\Entity\UserBadge#badge refers to the inverse side field App\Entity\Badge#userBadges which does not exist.
App\Entity\Enrollment No errors.
App\Entity\Progression No errors.