Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

5.81 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.23 ms
(21.12%)

SELECT DISTINCT p0_.id AS id_0, p0_.final_price AS final_price_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC LIMIT 21 OFFSET 126

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.final_price AS final_price_1
FROM
  product_variant p0_
WHERE
  (p0_.is_active = 1)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.final_price DESC
LIMIT
  21 OFFSET 126

SELECT DISTINCT p0_.id AS id_0, p0_.final_price AS final_price_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC LIMIT 21 OFFSET 126;

#	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 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZKaurdB\PaginatorProxy9cc2a8f->paginate (line 56)
16	App\Repository\ProductVariantRepository->findSearch (line 86)
17	App\Controller\App\ShopController->shop (line 178)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.10 ms
(18.89%)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product_variant p0_
WHERE
  (p0_.is_active = 1)
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL);

#	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 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZKaurdB\PaginatorProxy9cc2a8f->paginate (line 56)
16	App\Repository\ProductVariantRepository->findSearch (line 86)
17	App\Controller\App\ShopController->shop (line 178)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.03 ms
(17.74%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.image_path AS image_path_6, c0_.banner_image_path AS banner_image_path_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE (c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.tree_root ASC, c0_.lft ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.lft AS lft_3,
  c0_.lvl AS lvl_4,
  c0_.rgt AS rgt_5,
  c0_.image_path AS image_path_6,
  c0_.banner_image_path AS banner_image_path_7,
  c0_.is_active AS is_active_8
FROM
  category c0_
WHERE
  (c0_.is_active = 1)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.image_path AS image_path_6, c0_.banner_image_path AS banner_image_path_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE (c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.tree_root ASC, c0_.lft 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 913)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 67)
7	App\Repository\CategoryRepository->getCategories (line 73)
8	App\Controller\App\ShopController->shop (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.91 ms
(15.59%)

SELECT MIN(p0_.final_price) AS sclr_0, MAX(p0_.final_price) AS sclr_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p0_.final_price) AS sclr_0,
  MAX(p0_.final_price) AS sclr_1
FROM
  product_variant p0_
WHERE
  (p0_.is_active = 1)
  AND (p0_.deleted_at IS NULL)

SELECT MIN(p0_.final_price) AS sclr_0, MAX(p0_.final_price) AS sclr_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL);

#	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 68)
7	App\Repository\ProductVariantRepository->findMinMax (line 87)
8	App\Controller\App\ShopController->shop (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.89 ms
(15.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.image_path AS image_path_6, t0.banner_image_path AS banner_image_path_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM brand t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL))

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.description AS description_4,
  t0.is_active AS is_active_5,
  t0.image_path AS image_path_6,
  t0.banner_image_path AS banner_image_path_7,
  t0.is_visible AS is_visible_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  brand t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.image_path AS image_path_6, t0.banner_image_path AS banner_image_path_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM brand t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 65)
4	App\Controller\App\ShopController->shop (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.66 ms
(11.32%)

SELECT p0_.id AS sclr_0, p0_.name AS sclr_1, p0_.slug AS sclr_2, p0_.sale_price AS sclr_3, p0_.solde_price AS sclr_4, p0_.discount AS sclr_5, p0_.final_price AS sclr_6, p0_.is_new_arrival AS sclr_7, p0_.is_special_offer AS sclr_8, p0_.main_image_path AS sclr_9 FROM product_variant p0_ WHERE (p0_.is_active = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS sclr_0,
  p0_.name AS sclr_1,
  p0_.slug AS sclr_2,
  p0_.sale_price AS sclr_3,
  p0_.solde_price AS sclr_4,
  p0_.discount AS sclr_5,
  p0_.final_price AS sclr_6,
  p0_.is_new_arrival AS sclr_7,
  p0_.is_special_offer AS sclr_8,
  p0_.main_image_path AS sclr_9
FROM
  product_variant p0_
WHERE
  (
    p0_.is_active = 1
    AND p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.final_price DESC

SELECT p0_.id AS sclr_0, p0_.name AS sclr_1, p0_.slug AS sclr_2, p0_.sale_price AS sclr_3, p0_.solde_price AS sclr_4, p0_.discount AS sclr_5, p0_.final_price AS sclr_6, p0_.is_new_arrival AS sclr_7, p0_.is_special_offer AS sclr_8, p0_.main_image_path AS sclr_9 FROM product_variant p0_ WHERE (p0_.is_active = 1 AND p0_.id IN (299, 306, 323, 296, 148, 154, 167, 168, 81, 211, 236, 43, 65, 66, 225, 233, 221, 325, 141, 144, 8)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price 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 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerZKaurdB\PaginatorProxy9cc2a8f->paginate (line 56)
16	App\Repository\ProductVariantRepository->findSearch (line 86)
17	App\Controller\App\ShopController->shop (line 178)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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\Category	No errors.
App\Entity\Brand	No errors.
App\Entity\Product	No errors.
App\Entity\ProductVariant	No errors.

Symfony Profiler

GET https://cpanel.officechoice.sn/shop?categories%5B0%5D=5&direction=desc&page=7&sort=pv.finalPrice

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping