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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
3.61 ms
(0.00%)
1
INSERT INTO contact (civilite, nom, prenom, fonction, email, fixe, mobile, active, datecreation, datemodification, rgpd, prospect_id, collaborateur_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "Madame"
  2 => "GOTTARDI"
  3 => "Brigitte"
  4 => "Directrice"
  5 => ""
  6 => ""
  7 => ""
  8 => 1
  9 => "2025-01-10 17:15:09"
  10 => "2025-01-10 17:15:09"
  11 => null
  12 => 24547
  13 => 65
]
0.97 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
0.91 ms
(0.00%)
1
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:
[
  24547
  "GOTTARDI"
  " Brigitte "
]
0.49 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:
[
  "sana@itsales.fr"
]
0.18 ms
(0.00%)
1
"START TRANSACTION"
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.