Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

52.12 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.36 ms
(35.23%)

SELECT DISTINCT p0_.id AS id_0, p0_.stock AS stock_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 ORDER BY p0_.stock DESC LIMIT 30

Parameters:

[
  "CHAMBRES"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.stock AS stock_1
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
ORDER BY
  p0_.stock DESC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.stock AS stock_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'CHAMBRES' AND p0_.prix_ttc > 1 ORDER BY p0_.stock DESC LIMIT 30;

#	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 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGZtbEYh\PaginatorProxy9cc2a8f->paginate (line 154)
16	App\Controller\AccueilController->chambres (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 4)

17.18 ms
(32.96%)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1

Parameters:

[
  "CHAMBRES"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM pneus p0_ WHERE p0_.libelle_famille = 'CHAMBRES' AND p0_.prix_ttc > 1;

#	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 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGZtbEYh\PaginatorProxy9cc2a8f->paginate (line 154)
16	App\Controller\AccueilController->chambres (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 4)

15.75 ms
(30.22%)

SELECT MIN(p0_.prix_ttc) AS sclr_0, MAX(p0_.prix_ttc) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1

Parameters:

[
  "CHAMBRES"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p0_.prix_ttc) AS sclr_0,
  MAX(p0_.prix_ttc) AS sclr_1
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1

SELECT MIN(p0_.prix_ttc) AS sclr_0, MAX(p0_.prix_ttc) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'CHAMBRES' AND p0_.prix_ttc > 1;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 146)
7	App\Repository\PneusRepository->findPrixMinMax (line 152)
8	App\Controller\AccueilController->chambres (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 4)

0.83 ms
(1.59%)

SELECT p0_.id AS id_0, p0_.marque AS marque_1, p0_.famille AS famille_2, p0_.categorie AS categorie_3, p0_.code_manuf AS code_manuf_4, p0_.code_ean AS code_ean_5, p0_.libelle_categorie AS libelle_categorie_6, p0_.libelle_marque AS libelle_marque_7, p0_.libelle_famille AS libelle_famille_8, p0_.libelle AS libelle_9, p0_.profil AS profil_10, p0_.url_profil AS url_profil_11, p0_.type_categorie AS type_categorie_12, p0_.largeur AS largeur_13, p0_.serie AS serie_14, p0_.structure AS structure_15, p0_.diametre AS diametre_16, p0_.indice_charge AS indice_charge_17, p0_.indice_vitesse AS indice_vitesse_18, p0_.tubless AS tubless_19, p0_.renfort AS renfort_20, p0_.runflat AS runflat_21, p0_.consommation AS consommation_22, p0_.freinage AS freinage_23, p0_.nb_decibels AS nb_decibels_24, p0_.bruit AS bruit_25, p0_.classe_pneu AS classe_pneu_26, p0_.prix_ht AS prix_ht_27, p0_.prix_ttc AS prix_ttc_28, p0_.hauteur_pneus AS hauteur_pneus_29, p0_.gam AS gam_30, p0_.saison AS saison_31, p0_.toutes_saisons AS toutes_saisons_32, p0_.promo AS promo_33, p0_.stock AS stock_34 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.stock DESC

Parameters:

[
  "CHAMBRES"
  "0004035775"
  "0006179910"
  "0006179909"
  "0006179908"
  "0006179907"
  "0006179906"
  "0004268657"
  "0004083700"
  "0004035778"
  "0004035777"
  "0004035776"
  "0004035759"
  "0004035773"
  "0004035772"
  "0004035771"
  "0004035768"
  "0004035767"
  "0004035765"
  "0004035764"
  "0004035763"
  "0004035762"
  "0004035760"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.marque AS marque_1,
  p0_.famille AS famille_2,
  p0_.categorie AS categorie_3,
  p0_.code_manuf AS code_manuf_4,
  p0_.code_ean AS code_ean_5,
  p0_.libelle_categorie AS libelle_categorie_6,
  p0_.libelle_marque AS libelle_marque_7,
  p0_.libelle_famille AS libelle_famille_8,
  p0_.libelle AS libelle_9,
  p0_.profil AS profil_10,
  p0_.url_profil AS url_profil_11,
  p0_.type_categorie AS type_categorie_12,
  p0_.largeur AS largeur_13,
  p0_.serie AS serie_14,
  p0_.structure AS structure_15,
  p0_.diametre AS diametre_16,
  p0_.indice_charge AS indice_charge_17,
  p0_.indice_vitesse AS indice_vitesse_18,
  p0_.tubless AS tubless_19,
  p0_.renfort AS renfort_20,
  p0_.runflat AS runflat_21,
  p0_.consommation AS consommation_22,
  p0_.freinage AS freinage_23,
  p0_.nb_decibels AS nb_decibels_24,
  p0_.bruit AS bruit_25,
  p0_.classe_pneu AS classe_pneu_26,
  p0_.prix_ht AS prix_ht_27,
  p0_.prix_ttc AS prix_ttc_28,
  p0_.hauteur_pneus AS hauteur_pneus_29,
  p0_.gam AS gam_30,
  p0_.saison AS saison_31,
  p0_.toutes_saisons AS toutes_saisons_32,
  p0_.promo AS promo_33,
  p0_.stock AS stock_34
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.stock DESC

SELECT p0_.id AS id_0, p0_.marque AS marque_1, p0_.famille AS famille_2, p0_.categorie AS categorie_3, p0_.code_manuf AS code_manuf_4, p0_.code_ean AS code_ean_5, p0_.libelle_categorie AS libelle_categorie_6, p0_.libelle_marque AS libelle_marque_7, p0_.libelle_famille AS libelle_famille_8, p0_.libelle AS libelle_9, p0_.profil AS profil_10, p0_.url_profil AS url_profil_11, p0_.type_categorie AS type_categorie_12, p0_.largeur AS largeur_13, p0_.serie AS serie_14, p0_.structure AS structure_15, p0_.diametre AS diametre_16, p0_.indice_charge AS indice_charge_17, p0_.indice_vitesse AS indice_vitesse_18, p0_.tubless AS tubless_19, p0_.renfort AS renfort_20, p0_.runflat AS runflat_21, p0_.consommation AS consommation_22, p0_.freinage AS freinage_23, p0_.nb_decibels AS nb_decibels_24, p0_.bruit AS bruit_25, p0_.classe_pneu AS classe_pneu_26, p0_.prix_ht AS prix_ht_27, p0_.prix_ttc AS prix_ttc_28, p0_.hauteur_pneus AS hauteur_pneus_29, p0_.gam AS gam_30, p0_.saison AS saison_31, p0_.toutes_saisons AS toutes_saisons_32, p0_.promo AS promo_33, p0_.stock AS stock_34 FROM pneus p0_ WHERE p0_.libelle_famille = 'CHAMBRES' AND p0_.prix_ttc > 1 AND p0_.id IN ('0004035775', '0006179910', '0006179909', '0006179908', '0006179907', '0006179906', '0004268657', '0004083700', '0004035778', '0004035777', '0004035776', '0004035759', '0004035773', '0004035772', '0004035771', '0004035768', '0004035767', '0004035765', '0004035764', '0004035763', '0004035762', '0004035760') ORDER BY p0_.stock DESC;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 92)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerGZtbEYh\PaginatorProxy9cc2a8f->paginate (line 154)
16	App\Controller\AccueilController->chambres (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 4)

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\Pneus	The association App\Entity\Pneus#commandeProduits refers to the owning side field App\Entity\CommandeProduit#id_Produit which does not exist.
App\Entity\CommandePresta	The mappings App\Entity\CommandePresta#id_commande and App\Entity\Commande#commandePrestas are inconsistent with each other.
App\Entity\CommandeProduit	The mappings App\Entity\CommandeProduit#id_produit and App\Entity\Pneus#commandeProduits are inconsistent with each other. The mappings App\Entity\CommandeProduit#id_commande and App\Entity\Commande#commandeProduits are inconsistent with each other.
App\Entity\Commande	The association App\Entity\Commande#commandePrestas refers to the owning side field App\Entity\CommandePresta#id_Commande which does not exist. The association App\Entity\Commande#commandeProduits refers to the owning side field App\Entity\CommandeProduit#id_Commande which does not exist.
App\Entity\User	No errors.
App\Entity\StatutCommande	No errors.

Symfony Profiler

GET http://5.250.181.167/chambres

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping