Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

387.31 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

97.02 ms
(25.05%)

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"
  "Génie Civil"
]

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 = 'Génie Civil' 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)

71.91 ms
(18.57%)

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"
  "Génie Civil"
]

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 = 'Génie Civil';

#	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)

71.66 ms
(18.50%)

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"
  "Génie Civil"
]

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 = 'Génie Civil';

#	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)

47.36 ms
(12.23%)

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"
  "Génie Civil"
]

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 = 'Génie Civil';

#	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)

44.80 ms
(11.57%)

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 480

Parameters:

[
  "PNEUS NEUFS"
  "Génie Civil"
]

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 480

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 = 'Génie Civil' ORDER BY p0_.stock DESC LIMIT 30 OFFSET 480;

#	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)

44.76 ms
(11.56%)

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"
  "Génie Civil"
]

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 = 'Génie Civil';

#	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)

9.80 ms
(2.53%)

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"
  "Génie Civil"
  "0004992047"
  "0004992048"
  "0004992049"
  "0004992050"
  "0004992051"
  "0005002572"
  "0005002573"
  "0005002574"
  "0005002575"
  "0005002576"
  "0005002577"
  "0005002578"
  "0005002579"
  "0005002580"
  "0005023273"
  "0005023274"
  "0005023304"
  "0005071296"
  "0005085518"
  "0005085519"
  "0005085520"
  "0005085522"
  "0005085524"
  "0005085525"
  "0005085526"
  "0005085527"
  "0005143158"
  "0005148598"
  "0005148599"
  "0005148600"
]

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 = 'Génie Civil' AND p0_.id IN ('0004992047', '0004992048', '0004992049', '0004992050', '0004992051', '0005002572', '0005002573', '0005002574', '0005002575', '0005002576', '0005002577', '0005002578', '0005002579', '0005002580', '0005023273', '0005023274', '0005023304', '0005071296', '0005085518', '0005085519', '0005085520', '0005085522', '0005085524', '0005085525', '0005085526', '0005085527', '0005143158', '0005148598', '0005148599', '0005148600') 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/17?type_categorie=G%C3%A9nie%20Civil

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping