https://api.sales-synergy.com/api/espaceagent/verifierdoublon/22939

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5766.18 ms
(100.00%)
1
SELECT
                p.id as id,
                p.doublonSiret as siret,
                p.doublonStandard as standard
                FROM prospectdoublon AS p
                WHERE p.id NOT IN (SELECT c.uid FROM cleaningdb as c WHERE c.action <>0) 
                AND (p.id like '%-22939' OR p.id like '22939-%') LIMIT 1
Parameters:
[]
1.09 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:
[
  "jamila@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.