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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.34 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:
[
  "b.robio1981@gmail.com"
]
2 5813.96 ms
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 '%-23232' OR p.id like '23232-%') LIMIT 1
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.