http://api.sales-synergy.com/api/espaceagent/verifierdoublon/23649

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
5434.28 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 '%-23649' OR p.id like '23649-%') LIMIT 1
Parameters:
[]
0.27 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:
[
  "widad@sales-synergy.com"
]

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.