Query Metrics
7
Database Queries
7
Different statements
8.69 ms
Query time
0
Invalid entities
4
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.52 ms |
SELECT n0_.id AS id_0, n0_.date_crea AS date_crea_1, n0_.date_modif AS date_modif_2, n0_.date_envoi AS date_envoi_3, n0_.statut AS statut_4, n0_.titre AS titre_5, n0_.envoi_en_cours AS envoi_en_cours_6, n0_.envoi_progression AS envoi_progression_7, n0_.envoi_total AS envoi_total_8, n0_.envoi_demarre_le AS envoi_demarre_le_9, n0_.envoi_termine_le AS envoi_termine_le_10, n0_.user_crea_id AS user_crea_id_11, n0_.user_modif_id AS user_modif_id_12, n0_.redaction_id AS redaction_id_13 FROM newsletter_campagne n0_ WHERE n0_.envoi_en_cours = 1 OR (n0_.date_envoi IS NOT NULL AND n0_.date_envoi <= ? AND (n0_.envoi_progression = 0 OR n0_.envoi_progression IS NULL))
Parameters:
[
"2026-04-17 15:27:04"
]
|
| 2 | 1.80 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.actif AS actif_3, t0.invalide AS invalide_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.sexe AS sexe_7, t0.groupe AS groupe_8, t0.crit1 AS crit1_9, t0.crit2 AS crit2_10, t0.crit3 AS crit3_11, t0.crit4 AS crit4_12, t0.sent AS sent_13, t0.sent_at AS sent_at_14, t0.campagne_id AS campagne_id_15 FROM newsletter_destinataire t0 WHERE t0.campagne_id = ? AND t0.actif = ? AND t0.sent = ? LIMIT 1
Parameters:
[ 12 1 0 ] |
| 3 | 1.59 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.chapeau AS chapeau_3, t0.visuel AS visuel_4, t0.texte AS texte_5, t0.date_crea AS date_crea_6, t0.date_modif AS date_modif_7, t0.link AS link_8, t0.pieces_jointes AS pieces_jointes_9, t0.user_crea_id AS user_crea_id_10, t0.user_modif_id AS user_modif_id_11 FROM newsletter_redaction t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 4 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 1.14 ms |
UPDATE newsletter_campagne SET envoi_progression = ? WHERE id = ?
Parameters:
[ 174 12 ] |
| 6 | 1.06 ms |
UPDATE newsletter_destinataire SET sent = ? WHERE id = ?
Parameters:
[ 1 2466 ] |
| 7 | 1.09 ms |
"COMMIT"
Parameters:
[] |
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\Newsletter\NewsletterCampagne | 1 |
| App\Entity\Securite\SecurAdmin | 1 |
| App\Entity\Newsletter\NewsletterRedaction | 1 |
| App\Entity\Newsletter\NewsletterDestinataire | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Newsletter\NewsletterCampagne | No errors. |
| App\Entity\Securite\SecurAdmin | No errors. |
| App\Entity\Newsletter\NewsletterRedaction | No errors. |
| App\Entity\Newsletter\NewsletterDestinataire | No errors. |