https://api.sales-synergy.com/app/publique/rappelnotifications

Query Metrics

17 Database Queries
5 Different statements
56.53 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The field App\Entity\Prospect#appareils is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Appareil#prospect does not contain the required 'inversedBy="appareils"' attribute.
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.