Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.95 ms Query time

0 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.94 ms
(31.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.adresse AS adresse_4, t0.vignette AS vignette_5, t0.photo_salle AS photo_salle_6, t0.slug AS slug_7, t0.creates_at AS creates_at_8, t0.enabled AS enabled_9 FROM salles t0 WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.adresse AS adresse_4,
  t0.vignette AS vignette_5,
  t0.photo_salle AS photo_salle_6,
  t0.slug AS slug_7,
  t0.creates_at AS creates_at_8,
  t0.enabled AS enabled_9
FROM
  salles t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.adresse AS adresse_4, t0.vignette AS vignette_5, t0.photo_salle AS photo_salle_6, t0.slug AS slug_7, t0.creates_at AS creates_at_8, t0.enabled AS enabled_9 FROM salles t0 WHERE t0.enabled = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MainController->index (line 62)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.86 ms
(29.05%)

SELECT f0_.id AS id_0, f0_.numero AS numero_1, f0_.motif AS motif_2, f0_.locataire AS locataire_3, f0_.telephone AS telephone_4, f0_.remise_clef AS remise_clef_5, f0_.retour_clef AS retour_clef_6, f0_.retour_prevu AS retour_prevu_7, f0_.etat_remise AS etat_remise_8, f0_.etat_retour AS etat_retour_9, f0_.signature_agent AS signature_agent_10, f0_.signature_locataire AS signature_locataire_11, f0_.created_at AS created_at_12, f0_.update_at AS update_at_13, f0_.slug AS slug_14, f0_.absent AS absent_15, f0_.remise_prevu AS remise_prevu_16, f0_.email AS email_17, f0_.message_remise AS message_remise_18, f0_.message_retour AS message_retour_19, f0_.salle_id AS salle_id_20, f0_.user_id AS user_id_21, f0_.agent_id AS agent_id_22 FROM fiches f0_ WHERE f0_.etat_retour <> 1 ORDER BY f0_.remise_prevu ASC, f0_.retour_prevu ASC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.numero AS numero_1,
  f0_.motif AS motif_2,
  f0_.locataire AS locataire_3,
  f0_.telephone AS telephone_4,
  f0_.remise_clef AS remise_clef_5,
  f0_.retour_clef AS retour_clef_6,
  f0_.retour_prevu AS retour_prevu_7,
  f0_.etat_remise AS etat_remise_8,
  f0_.etat_retour AS etat_retour_9,
  f0_.signature_agent AS signature_agent_10,
  f0_.signature_locataire AS signature_locataire_11,
  f0_.created_at AS created_at_12,
  f0_.update_at AS update_at_13,
  f0_.slug AS slug_14,
  f0_.absent AS absent_15,
  f0_.remise_prevu AS remise_prevu_16,
  f0_.email AS email_17,
  f0_.message_remise AS message_remise_18,
  f0_.message_retour AS message_retour_19,
  f0_.salle_id AS salle_id_20,
  f0_.user_id AS user_id_21,
  f0_.agent_id AS agent_id_22
FROM
  fiches f0_
WHERE
  f0_.etat_retour <> 1
ORDER BY
  f0_.remise_prevu ASC,
  f0_.retour_prevu ASC
LIMIT
  10

SELECT f0_.id AS id_0, f0_.numero AS numero_1, f0_.motif AS motif_2, f0_.locataire AS locataire_3, f0_.telephone AS telephone_4, f0_.remise_clef AS remise_clef_5, f0_.retour_clef AS retour_clef_6, f0_.retour_prevu AS retour_prevu_7, f0_.etat_remise AS etat_remise_8, f0_.etat_retour AS etat_retour_9, f0_.signature_agent AS signature_agent_10, f0_.signature_locataire AS signature_locataire_11, f0_.created_at AS created_at_12, f0_.update_at AS update_at_13, f0_.slug AS slug_14, f0_.absent AS absent_15, f0_.remise_prevu AS remise_prevu_16, f0_.email AS email_17, f0_.message_remise AS message_remise_18, f0_.message_retour AS message_retour_19, f0_.salle_id AS salle_id_20, f0_.user_id AS user_id_21, f0_.agent_id AS agent_id_22 FROM fiches f0_ WHERE f0_.etat_retour <> 1 ORDER BY f0_.remise_prevu ASC, f0_.retour_prevu ASC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FichesRepository->getAllPaginated (line 38)
7	App\Controller\MainController->index (line 67)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.72 ms
(24.44%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.numero AS numero_1, f0_.motif AS motif_2, f0_.locataire AS locataire_3, f0_.telephone AS telephone_4, f0_.remise_clef AS remise_clef_5, f0_.retour_clef AS retour_clef_6, f0_.retour_prevu AS retour_prevu_7, f0_.etat_remise AS etat_remise_8, f0_.etat_retour AS etat_retour_9, f0_.signature_agent AS signature_agent_10, f0_.signature_locataire AS signature_locataire_11, f0_.created_at AS created_at_12, f0_.update_at AS update_at_13, f0_.slug AS slug_14, f0_.absent AS absent_15, f0_.remise_prevu AS remise_prevu_16, f0_.email AS email_17, f0_.message_remise AS message_remise_18, f0_.message_retour AS message_retour_19 FROM fiches f0_ WHERE f0_.etat_retour <> 1 ORDER BY f0_.remise_prevu ASC, f0_.retour_prevu ASC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          f0_.id AS id_0,
          f0_.numero AS numero_1,
          f0_.motif AS motif_2,
          f0_.locataire AS locataire_3,
          f0_.telephone AS telephone_4,
          f0_.remise_clef AS remise_clef_5,
          f0_.retour_clef AS retour_clef_6,
          f0_.retour_prevu AS retour_prevu_7,
          f0_.etat_remise AS etat_remise_8,
          f0_.etat_retour AS etat_retour_9,
          f0_.signature_agent AS signature_agent_10,
          f0_.signature_locataire AS signature_locataire_11,
          f0_.created_at AS created_at_12,
          f0_.update_at AS update_at_13,
          f0_.slug AS slug_14,
          f0_.absent AS absent_15,
          f0_.remise_prevu AS remise_prevu_16,
          f0_.email AS email_17,
          f0_.message_remise AS message_remise_18,
          f0_.message_retour AS message_retour_19
        FROM
          fiches f0_
        WHERE
          f0_.etat_retour <> 1
        ORDER BY
          f0_.remise_prevu ASC,
          f0_.retour_prevu ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.numero AS numero_1, f0_.motif AS motif_2, f0_.locataire AS locataire_3, f0_.telephone AS telephone_4, f0_.remise_clef AS remise_clef_5, f0_.retour_clef AS retour_clef_6, f0_.retour_prevu AS retour_prevu_7, f0_.etat_remise AS etat_remise_8, f0_.etat_retour AS etat_retour_9, f0_.signature_agent AS signature_agent_10, f0_.signature_locataire AS signature_locataire_11, f0_.created_at AS created_at_12, f0_.update_at AS update_at_13, f0_.slug AS slug_14, f0_.absent AS absent_15, f0_.remise_prevu AS remise_prevu_16, f0_.email AS email_17, f0_.message_remise AS message_remise_18, f0_.message_retour AS message_retour_19 FROM fiches f0_ WHERE f0_.etat_retour <> 1 ORDER BY f0_.remise_prevu ASC, f0_.retour_prevu ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Repository\FichesRepository->getAllPaginated (line 40)
8	App\Controller\MainController->index (line 67)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.43 ms
(14.66%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.nom2 AS nom2_4, t0.visite_remise AS visite_remise_5, t0.visite_retour AS visite_retour_6, t0.cretaed_at AS cretaed_at_7, t0.slug AS slug_8, t0.telephone2 AS telephone2_9, t0.email2 AS email2_10, t0.email AS email_11, t0.slug2 AS slug2_12, t0.numero_id AS numero_id_13 FROM previsite t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.telephone AS telephone_3,
  t0.nom2 AS nom2_4,
  t0.visite_remise AS visite_remise_5,
  t0.visite_retour AS visite_retour_6,
  t0.cretaed_at AS cretaed_at_7,
  t0.slug AS slug_8,
  t0.telephone2 AS telephone2_9,
  t0.email2 AS email2_10,
  t0.email AS email_11,
  t0.slug2 AS slug2_12,
  t0.numero_id AS numero_id_13
FROM
  previsite t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.nom2 AS nom2_4, t0.visite_remise AS visite_remise_5, t0.visite_retour AS visite_retour_6, t0.cretaed_at AS cretaed_at_7, t0.slug AS slug_8, t0.telephone2 AS telephone2_9, t0.email2 AS email2_10, t0.email AS email_11, t0.slug2 AS slug2_12, t0.numero_id AS numero_id_13 FROM previsite t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\MainController->index (line 69)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Salles	4
App\Entity\Fiches	4
App\Entity\Previsite	4
App\Entity\Users	2

Entities Mapping

Class	Mapping errors
App\Entity\Salles	No errors.
App\Entity\Fiches	No errors.
App\Entity\Users	No errors.
App\Entity\LieuRemise	No errors.
App\Entity\LieuRetour	No errors.
App\Entity\Previsite	No errors.

Symfony Profiler

GET https://test.dev1.mairie-plv-web1.ext.fprt.net/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping