https://api.sales-synergy.com/api/statistique/appelparstatut Return to referer URL

Query Metrics

2 Database Queries
2 Different statements
34.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.