Query Metrics
17
Database Queries
5
Different statements
56.53 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
46.18 ms (0.00%) |
1 |
SELECT c0_.id AS id_0, c0_.rappelprive AS rappelprive_1, c0_.daterappel AS daterappel_2, c0_.historique AS historique_3, c0_.commentaire AS commentaire_4, c0_.traitementdate AS traitementdate_5, c0_.traitementencore AS traitementencore_6, c0_.campagne_id AS campagne_id_7, c0_.prospect_id AS prospect_id_8, c0_.utilisateur_id AS utilisateur_id_9, c0_.appelstatut_id AS appelstatut_id_10, c0_.traitementpar_id AS traitementpar_id_11 FROM campagneprospect c0_ WHERE c0_.rappelprive = ? AND DATE(c0_.daterappel) = ?
Parameters:
[ 1 "2025-05-01" ] |
5.39 ms (0.00%) |
8 |
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.siren AS siren_3, t0.adresse AS adresse_4, t0.adressesuite AS adressesuite_5, t0.chiffre_affaire AS chiffre_affaire_6, t0.active AS active_7, t0.standard AS standard_8, t0.email AS email_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.siteweb AS siteweb_12, t0.effectif AS effectif_13, t0.siret AS siret_14, t0.description AS description_15, t0.ville_id AS ville_id_16, t0.codenaf_id AS codenaf_id_17, t18.id AS id_19, t18.consultationderniere AS consultationderniere_20, t18.consultationprochaine AS consultationprochaine_21, t18.prestataire AS prestataire_22, t18.sitedecionnaire AS sitedecionnaire_23, t18.societedecisionnaire AS societedecisionnaire_24, t18.effectif2 AS effectif2_25, t18.description AS description_26, t18.segmentmarche_id AS segmentmarche_id_27, t18.prospect_id AS prospect_id_28, t18.politiquerenouvellement_id AS politiquerenouvellement_id_29 FROM prospect t0 LEFT JOIN prospectdetail t18 ON t18.prospect_id = t0.id WHERE t0.id = ?
Parameters:
[
15494
]
|
2.39 ms (0.00%) |
4 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.active AS active_4, t0.datecreation AS datecreation_5, t0.datedebut AS datedebut_6, t0.datefin AS datefin_7, t0.objectif AS objectif_8, t0.objectifagent AS objectifagent_9, t0.type AS type_10, t0.campagnecible AS campagnecible_11, t0.recuperer_tous_historique AS recuperer_tous_historique_12, t0.client_id AS client_id_13, t0.reponsable_id AS reponsable_id_14, t0.clientmanager_id AS clientmanager_id_15 FROM campagne t0 WHERE t0.id = ?
Parameters:
[
118
]
|
1.94 ms (0.00%) |
3 |
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.id = ?
Parameters:
[
67
]
|
0.64 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.active AS active_3, t0.horscible AS horscible_4, t0.nrp AS nrp_5, t0.rdv AS rdv_6, t0.rappel AS rappel_7, t0.couleur AS couleur_8, t0.objectif AS objectif_9, t0.fichequalifie AS fichequalifie_10, t0.fichearequalifie AS fichearequalifie_11, t0.ordre_affichage AS ordre_affichage_12 FROM appelstatut t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Campagneprospect | No errors. |
App\Entity\Campagne | No errors. |
App\Entity\Prospect |
|
App\Entity\Utilisateur | No errors. |
App\Entity\Appelstatut | No errors. |
App\Entity\Groupe | No errors. |
App\Entity\Fichier | No errors. |
App\Entity\Client | No errors. |
App\Entity\Ville | No errors. |
App\Entity\Codenaf | No errors. |
App\Entity\Prospectdetail | No errors. |
App\Entity\Segmentmarche | No errors. |
App\Entity\Politiquerenouvellement | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Appareil | No errors. |