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

Query Metrics

5 Database Queries
5 Different statements
4.96 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
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:
[
  "halimaelmekhfi01@gmail.com"
]
2 1.09 ms
SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.email AS email_6, t0.fixe AS fixe_7, t0.mobile AS mobile_8, t0.active AS active_9, t0.datecreation AS datecreation_10, t0.datemodification AS datemodification_11, t0.rgpd AS rgpd_12, t0.prospect_id AS prospect_id_13, t0.collaborateur_id AS collaborateur_id_14 FROM contact t0 WHERE t0.prospect_id = ? AND t0.nom = ? AND t0.prenom = ? LIMIT 1
Parameters:
[
  23898
  "COULON"
  "BOb"
]
3 0.34 ms
"START TRANSACTION"
Parameters:
[]
4 1.53 ms
INSERT INTO contact (civilite, nom, prenom, fonction, email, fixe, mobile, active, datecreation, datemodification, rgpd, prospect_id, collaborateur_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "Monsieur"
  2 => "COULON"
  3 => "BOb"
  4 => "Responsable informatique décisionnelle "
  5 => ""
  6 => ""
  7 => ""
  8 => 1
  9 => "2025-02-25 13:37:27"
  10 => "2025-02-25 13:37:27"
  11 => null
  12 => 23898
  13 => 74
]
5 1.43 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.

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\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\Contact No errors.
App\Entity\Ville No errors.
App\Entity\Campagne No errors.
App\Entity\Importation No errors.
App\Entity\Rdv No errors.
App\Entity\Commentaire No errors.
App\Entity\Rdvstatut No errors.
App\Entity\Commercial No errors.
App\Entity\Codenaf No errors.