Symfony Profiler

Query Metrics

21 Database Queries

6 Different statements

8.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.56 ms
(31.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = ?

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.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	IteratorIterator->__construct (line 1943)
9	Twig\Extension\CoreExtension::filter (line 170)
10	__TwigTemplate_c88fb3a694da3fa30704477c5e8cb892->block_content (line 432)
11	Twig\Template->yieldBlock (line 100)
12	__TwigTemplate_2ffcdd88f4d43bbae35903c0b3fcc0a7->doDisplay (line 388)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_c88fb3a694da3fa30704477c5e8cb892->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
23	App\Controller\Frontoffice\ProductController->catalogue (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.49 ms
(30.28%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "address_ofici"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  site_setting t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM site_setting t0 WHERE t0.setting_key = 'address_ofici' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 43)
5	App\Twig\GlobalVariablesExtension->getSetting (line 27)
6	App\Twig\GlobalVariablesExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
17	App\Controller\Frontoffice\ProductController->catalogue (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.34 ms
(16.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "melanges-d-epices"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.category_id AS category_id_5
FROM
  subcategory t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.category_id AS category_id_5 FROM subcategory t0 WHERE t0.slug = 'melanges-d-epices' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 37)
5	App\Controller\Frontoffice\ProductController->catalogue (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.83 ms
(10.12%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = ? OR p0_.status = ?) AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = ? ORDER BY p0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "active"
  "out-of-stock"
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.extra AS extra_2,
          p0_.slug AS slug_3,
          p0_.description AS description_4,
          p0_.origin AS origin_5,
          p0_.price AS price_6,
          p0_.stock AS stock_7,
          p0_.sku AS sku_8,
          p0_.weight AS weight_9,
          p0_.created_at AS created_at_10,
          p0_.updated_at AS updated_at_11,
          p0_.reference AS reference_12,
          p0_.status AS status_13,
          p0_.is_mts_product AS is_mts_product_14
        FROM
          product p0_
        WHERE
          (
            p0_.status = ?
            OR p0_.status = ?
          )
          AND p0_.subcategory_id IS NOT NULL
          AND p0_.subcategory_id = ?
        ORDER BY
          p0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = 5 ORDER BY p0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerTVJtxm4\PaginatorProxyBa079e5->paginate (line 58)
16	App\Controller\Frontoffice\ProductController->catalogue (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.66 ms
(8.09%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = ? OR p0_.status = ?) AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 36

Parameters:

[
  "active"
  "out-of-stock"
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.name AS name_1,
          p0_.extra AS extra_2,
          p0_.slug AS slug_3,
          p0_.description AS description_4,
          p0_.origin AS origin_5,
          p0_.price AS price_6,
          p0_.stock AS stock_7,
          p0_.sku AS sku_8,
          p0_.weight AS weight_9,
          p0_.created_at AS created_at_10,
          p0_.updated_at AS updated_at_11,
          p0_.reference AS reference_12,
          p0_.status AS status_13,
          p0_.is_mts_product AS is_mts_product_14
        FROM
          product p0_
        WHERE
          (
            p0_.status = ?
            OR p0_.status = ?
          )
          AND p0_.subcategory_id IS NOT NULL
          AND p0_.subcategory_id = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  36

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.sku AS sku_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14 FROM product p0_ WHERE (p0_.status = 'active' OR p0_.status = 'out-of-stock') AND p0_.subcategory_id IS NOT NULL AND p0_.subcategory_id = 5) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 36;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
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 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerTVJtxm4\PaginatorProxyBa079e5->paginate (line 58)
16	App\Controller\Frontoffice\ProductController->catalogue (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.33 ms
(4.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4,
  t0.is_active AS is_active_5,
  t0.image AS image_6
FROM
  category t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 49)
5	App\Twig\GlobalVariablesExtension->getCategories (line 37)
6	App\Twig\GlobalVariablesExtension->getGlobals (line 352)
7	Twig\ExtensionSet->getGlobals (line 901)
8	Twig\Environment->getGlobals (line 384)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 67)
17	App\Controller\Frontoffice\ProductController->catalogue (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Subcategory	No errors.
App\Entity\Category	No errors.
App\Entity\Product	No errors.
App\Entity\SiteSetting	No errors.

Symfony Profiler

GET https://aosow.dev/produits?subcategory=melanges-d-epices

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping