Query Metrics
2
Database Queries
2
Different statements
34.58 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
34.24 ms (0.00%) |
1 |
SELECT DATE_FORMAT(a0_.dateappel, '%d/%m/%Y') AS sclr_0, a1_.libelle AS libelle_1, a1_.couleur AS couleur_2, count(a0_.id) AS sclr_3 FROM appel a0_ LEFT JOIN appelstatut a1_ ON (a0_.appelstatut_id = a1_.id) LEFT JOIN campagneprospect c2_ ON (a0_.campagneprospect_id = c2_.id) LEFT JOIN campagne c3_ ON (c2_.campagne_id = c3_.id) LEFT JOIN client c4_ ON (c3_.client_id = c4_.id) WHERE a0_.dateappel >= 20241223 AND a0_.utilisateur_id = 23 GROUP BY sclr_0, a1_.libelle ORDER BY a0_.dateappel ASC
Parameters:
[] |
0.34 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.session_active AS session_active_7, t0.parametres AS parametres_8, t0.erreur AS erreur_9, t0.erreurdate AS erreurdate_10, t0.groupe_id AS groupe_id_11, t0.photo_id AS photo_id_12, t0.client_id AS client_id_13 FROM utilisateur t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"salwa@itsales.fr"
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Utilisateur | No errors. |
App\Entity\Groupe | No errors. |
App\Entity\Fichier | No errors. |
App\Entity\Client | No errors. |
App\Entity\Appel | No errors. |
App\Entity\Appelstatut | No errors. |
App\Entity\Campagneprospect | No errors. |
App\Entity\Campagne | No errors. |