Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

6.84 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

6.84 ms

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.prenom AS prenom_2, a0_.email AS email_3, a0_.telephone AS telephone_4, a0_.portable AS portable_5, a0_.ville AS ville_6, a0_.pays AS pays_7, a0_.code_postal AS code_postal_8, a0_.etat AS etat_9, a0_.competences AS competences_10, a0_.password AS password_11, a0_.adresse AS adresse_12, a0_.type AS type_13, a0_.filiale_id AS filiale_id_14, a0_.entreprise_id AS entreprise_id_15 FROM agent a0_ WHERE a0_.email = '' AND (a0_.password = '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' OR '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' = '80077ec5d3a78ea5bb10d9a1a959e378ff9a621d')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.prenom AS prenom_2,
  a0_.email AS email_3,
  a0_.telephone AS telephone_4,
  a0_.portable AS portable_5,
  a0_.ville AS ville_6,
  a0_.pays AS pays_7,
  a0_.code_postal AS code_postal_8,
  a0_.etat AS etat_9,
  a0_.competences AS competences_10,
  a0_.password AS password_11,
  a0_.adresse AS adresse_12,
  a0_.type AS type_13,
  a0_.filiale_id AS filiale_id_14,
  a0_.entreprise_id AS entreprise_id_15
FROM
  agent a0_
WHERE
  a0_.email = ''
  AND (
    a0_.password = '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c'
    OR '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' = '80077ec5d3a78ea5bb10d9a1a959e378ff9a621d'
  )

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.prenom AS prenom_2, a0_.email AS email_3, a0_.telephone AS telephone_4, a0_.portable AS portable_5, a0_.ville AS ville_6, a0_.pays AS pays_7, a0_.code_postal AS code_postal_8, a0_.etat AS etat_9, a0_.competences AS competences_10, a0_.password AS password_11, a0_.adresse AS adresse_12, a0_.type AS type_13, a0_.filiale_id AS filiale_id_14, a0_.entreprise_id AS entreprise_id_15 FROM agent a0_ WHERE a0_.email = '' AND (a0_.password = '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' OR '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' = '80077ec5d3a78ea5bb10d9a1a959e378ff9a621d');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 344)
7	App\Service\SuperAdmin->getAgent (line 549)
8	App\Controller\AuthenticationController->login_agent (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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\Agent	No errors.
App\Entity\Filiale	The association App\Entity\Filiale#gestionnaire refers to the inverse side field App\Entity\GestionnaireFiliale#filiales which does not exist.
App\Entity\Entreprise	No errors.
App\Entity\GestionnaireFiliale	No errors.
App\Entity\Niveau	No errors.
App\Entity\Etat	No errors.
App\Entity\GestionnaireEntreprise	No errors.

Symfony Profiler

GET https://mitih-back.synexta-developpement.fr/login_agent

Configuration Settings

Theme