Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

39.13 ms Query time

0 Invalid entities

75 Managed entities

Queries

Group similar statements

#▲

Time

Info

13.85 ms

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM ingredients i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  ingredients i0_

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM ingredients i0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQdFVxuf\PaginatorProxyBa079e5->paginate (line 25)
15	App\Repository\IngredientRepository->paginatedList (line 41)
16	App\Controller\IngredientController->index (line 26)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

23.25 ms

SELECT DISTINCT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1 FROM ingredients i0_ ORDER BY i0_.ingredient_name ASC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.id AS id_0,
  i0_.ingredient_name AS ingredient_name_1
FROM
  ingredients i0_
ORDER BY
  i0_.ingredient_name ASC
LIMIT
  50

SELECT DISTINCT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1 FROM ingredients i0_ ORDER BY i0_.ingredient_name ASC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQdFVxuf\PaginatorProxyBa079e5->paginate (line 25)
15	App\Repository\IngredientRepository->paginatedList (line 41)
16	App\Controller\IngredientController->index (line 26)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

1.32 ms

SELECT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1, i0_.slug AS slug_2, i0_.ingredient_image AS ingredient_image_3, i0_.ingredient_second_name AS ingredient_second_name_4, i0_.is_goodie AS is_goodie_5, i0_.all_functions AS all_functions_6, i0_.ingr_irritancy AS ingr_irritancy_7, i0_.ingr_comedogencity AS ingr_comedogencity_8, i0_.ingr_description AS ingr_description_9, i0_.ingr_cas_1 AS ingr_cas_1_10, i0_.ingr_ec_number_1 AS ingr_ec_number_1_11, i0_.ingr_ec_number_2 AS ingr_ec_number_2_12, i0_.ingr_details AS ingr_details_13, i0_.UPAC_Name AS UPAC_Name_14, i0_.Ph_Eur_Name AS Ph_Eur_Name_15, i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16, i0_.Details AS Details_17, i0_.Geeky_Details AS Geeky_Details_18 FROM ingredients i0_ WHERE i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.ingredient_name ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.ingredient_name AS ingredient_name_1,
  i0_.slug AS slug_2,
  i0_.ingredient_image AS ingredient_image_3,
  i0_.ingredient_second_name AS ingredient_second_name_4,
  i0_.is_goodie AS is_goodie_5,
  i0_.all_functions AS all_functions_6,
  i0_.ingr_irritancy AS ingr_irritancy_7,
  i0_.ingr_comedogencity AS ingr_comedogencity_8,
  i0_.ingr_description AS ingr_description_9,
  i0_.ingr_cas_1 AS ingr_cas_1_10,
  i0_.ingr_ec_number_1 AS ingr_ec_number_1_11,
  i0_.ingr_ec_number_2 AS ingr_ec_number_2_12,
  i0_.ingr_details AS ingr_details_13,
  i0_.UPAC_Name AS UPAC_Name_14,
  i0_.Ph_Eur_Name AS Ph_Eur_Name_15,
  i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16,
  i0_.Details AS Details_17,
  i0_.Geeky_Details AS Geeky_Details_18
FROM
  ingredients i0_
WHERE
  i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  i0_.ingredient_name ASC

SELECT i0_.id AS id_0, i0_.ingredient_name AS ingredient_name_1, i0_.slug AS slug_2, i0_.ingredient_image AS ingredient_image_3, i0_.ingredient_second_name AS ingredient_second_name_4, i0_.is_goodie AS is_goodie_5, i0_.all_functions AS all_functions_6, i0_.ingr_irritancy AS ingr_irritancy_7, i0_.ingr_comedogencity AS ingr_comedogencity_8, i0_.ingr_description AS ingr_description_9, i0_.ingr_cas_1 AS ingr_cas_1_10, i0_.ingr_ec_number_1 AS ingr_ec_number_1_11, i0_.ingr_ec_number_2 AS ingr_ec_number_2_12, i0_.ingr_details AS ingr_details_13, i0_.UPAC_Name AS UPAC_Name_14, i0_.Ph_Eur_Name AS Ph_Eur_Name_15, i0_.Cosmetic_Restrictions AS Cosmetic_Restrictions_16, i0_.Details AS Details_17, i0_.Geeky_Details AS Geeky_Details_18 FROM ingredients i0_ WHERE i0_.id IN (11740, 12734, 8632, 15232, 9011, 5978, 11946, 8970, 9542, 7963, 14666, 10809, 10395, 9411, 8310, 6807, 1051, 16022, 13142, 14785, 16490, 10491, 10179, 16280, 10905, 4150, 4157, 20115, 4151, 16357, 18650, 18539, 15083, 14720, 12257, 10735, 4995, 16895, 10547, 1487, 3815, 7713, 12332, 5708, 18043, 18651, 5210, 5944, 18652, 11433) ORDER BY i0_.ingredient_name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQdFVxuf\PaginatorProxyBa079e5->paginate (line 25)
15	App\Repository\IngredientRepository->paginatedList (line 41)
16	App\Controller\IngredientController->index (line 26)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.71 ms

SELECT f0_.id AS id_0, f0_.function_name AS function_name_1, f0_.slug AS slug_2, f0_.function_desctiption AS function_desctiption_3, f0_.readable AS readable_4, f0_.official AS official_5 FROM functions f0_ WHERE f0_.readable = 1 ORDER BY f0_.function_name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.function_name AS function_name_1,
  f0_.slug AS slug_2,
  f0_.function_desctiption AS function_desctiption_3,
  f0_.readable AS readable_4,
  f0_.official AS official_5
FROM
  functions f0_
WHERE
  f0_.readable = 1
ORDER BY
  f0_.function_name ASC

SELECT f0_.id AS id_0, f0_.function_name AS function_name_1, f0_.slug AS slug_2, f0_.function_desctiption AS function_desctiption_3, f0_.readable AS readable_4, f0_.official AS official_5 FROM functions f0_ WHERE f0_.readable = 1 ORDER BY f0_.function_name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\IngredientFunctionRepository->findAllReadable (line 28)
7	App\Controller\IngredientController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Ingredient	50
App\Entity\IngredientFunction	25

Entities Mapping

Class	Mapping errors
App\Entity\Ingredient	No errors.
App\Entity\IngredientList	No errors.
App\Entity\IngredientFunction	No errors.
App\Entity\IngredientAka	No errors.
App\Entity\QuickFact	No errors.
App\Entity\SccsOpinion	No errors.

Symfony Profiler

GET https://indecoder.ru/ingredients

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping