Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

209.51 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

78.64 ms
(37.53%)

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

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

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
  AND p0_.type_categorie = ?

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

#	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 76)
16	App\Controller\AccueilController->boutique (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)

33.79 ms
(16.13%)

SELECT p0_.libelle_marque AS libelle_marque_0, COUNT(p0_.libelle_marque) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ? GROUP BY p0_.libelle_marque ORDER BY p0_.libelle_marque ASC

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.libelle_marque AS libelle_marque_0,
  COUNT(p0_.libelle_marque) AS sclr_1
FROM
  pneus p0_
WHERE
  p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
  AND p0_.type_categorie = ?
GROUP BY
  p0_.libelle_marque
ORDER BY
  p0_.libelle_marque ASC

SELECT p0_.libelle_marque AS libelle_marque_0, COUNT(p0_.libelle_marque) AS sclr_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' GROUP BY p0_.libelle_marque ORDER BY p0_.libelle_marque ASC;

#	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 123)
7	App\Repository\PneusRepository->findMarque (line 73)
8	App\Controller\AccueilController->boutique (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)

33.18 ms
(15.84%)

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

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

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
  AND p0_.type_categorie = ?
ORDER BY
  p0_.stock DESC
LIMIT
  30 OFFSET 17040

SELECT DISTINCT p0_.id AS id_0, p0_.stock AS stock_1 FROM pneus p0_ WHERE p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' ORDER BY p0_.stock DESC LIMIT 30 OFFSET 17040;

#	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 76)
16	App\Controller\AccueilController->boutique (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)

23.25 ms
(11.10%)

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 AND p0_.type_categorie = ?

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

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
  AND p0_.type_categorie = ?

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

#	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 75)
8	App\Controller\AccueilController->boutique (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)

22.13 ms
(10.56%)

SELECT COUNT(p0_.tubless) AS sclr_0 FROM pneus p0_ WHERE p0_.tubless = 1 AND p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.tubless) AS sclr_0
FROM
  pneus p0_
WHERE
  p0_.tubless = 1
  AND p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
  AND p0_.type_categorie = ?

SELECT COUNT(p0_.tubless) AS sclr_0 FROM pneus p0_ WHERE p0_.tubless = 1 AND p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

#	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 73)
7	App\Repository\PneusRepository->findNbTubless (line 69)
8	App\Controller\AccueilController->boutique (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)

17.75 ms
(8.47%)

SELECT COUNT(p0_.runflat) AS sclr_0 FROM pneus p0_ WHERE p0_.runflat = 1 AND p0_.libelle_famille = ? AND p0_.prix_ttc > 1 AND p0_.type_categorie = ?

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(p0_.runflat) AS sclr_0
FROM
  pneus p0_
WHERE
  p0_.runflat = 1
  AND p0_.libelle_famille = ?
  AND p0_.prix_ttc > 1
  AND p0_.type_categorie = ?

SELECT COUNT(p0_.runflat) AS sclr_0 FROM pneus p0_ WHERE p0_.runflat = 1 AND p0_.libelle_famille = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme';

#	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 97)
7	App\Repository\PneusRepository->findNbRunFlat (line 70)
8	App\Controller\AccueilController->boutique (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.78 ms
(0.37%)

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_.type_categorie = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.stock DESC

Parameters:

[
  "PNEUS NEUFS"
  "Tourisme"
  "0006780894"
  "0006780895"
  "0006780896"
  "0006780940"
  "0006780941"
  "0006780942"
  "0006782629"
  "0006782630"
  "0006782631"
  "0006782632"
  "0006782659"
  "0006782660"
  "0006782661"
  "0006782662"
  "0006782663"
]

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_.type_categorie = ?
  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 = 'PNEUS NEUFS' AND p0_.prix_ttc > 1 AND p0_.type_categorie = 'Tourisme' AND p0_.id IN ('0006780894', '0006780895', '0006780896', '0006780940', '0006780941', '0006780942', '0006782629', '0006782630', '0006782631', '0006782632', '0006782659', '0006782660', '0006782661', '0006782662', '0006782663') 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 76)
16	App\Controller\AccueilController->boutique (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 https://point-pneus.fr/boutique/569?type_categorie=Tourisme

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping