Symfony Profiler

Query Metrics

23 Database Queries

5 Different statements

39.89 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.55 ms
(76.58%)

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.hit = true) AND (p0_.available=true)) AND p0_.p_type IN ('1', '2')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  p0_.p_type AS p_type_34
FROM
  product p0_
WHERE
  (
    (p0_.hit = true)
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1', '2')

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.hit = true) AND (p0_.available=true)) AND p0_.p_type IN ('1', '2');

#	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 170)
7	App\Controller\MainController->App\Controller\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 164)
13	App\Controller\MainController->getHits (line 412)
14	App\Controller\MainController->diski (line 178)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

5.58 ms
(14.00%)

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = ?

Parameters:

[
  "D_[REPLAY]_00-00006530"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'D_[REPLAY]_00-00006530';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 600)
8	App\Entity\Product->isCalculatedExternal (line 1635)
9	twig_get_attribute (line 64)
10	__TwigTemplate_84819288042a54e187276d9190c0e53b->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 77)
13	__TwigTemplate_fe7442623f2acc1a7091c5824b90cfc2->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 160)
16	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->block_diski (line 171)
17	Twig\Template->displayBlock (line 95)
18	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->block_content (line 171)
19	Twig\Template->displayBlock (line 82)
20	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
21	Twig\Template->displayBlock (line 151)
22	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 50)
25	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 52)
28	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->doDisplay (line 394)
29	Twig\Template->displayWithErrorHandling (line 367)
30	Twig\Template->display (line 379)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 280)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 411)
37	App\Controller\MainController->diski (line 178)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

1.34 ms
(3.36%)

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = ? LIMIT 1

Parameters:

[
  "samara"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'samara' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\EnvironmentProcessors\KolexTownProcessor->getEnv (line 368)
5	Symfony\Component\DependencyInjection\Container->getEnv (line 2200)
6	ContainerJvrhMxj\App_KernelDevDebugContainer::getTwigService (line 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 431)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 411)
12	App\Controller\MainController->diski (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.29 ms
(3.22%)

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.title AS title_2,
  i0_.text AS text_3,
  i0_.image AS image_4,
  i0_.description_add AS description_add_5,
  i0_.keywords AS keywords_6,
  i0_.slug AS slug_7,
  i0_.expires_after AS expires_after_8,
  i0_.show_as_action AS show_as_action_9,
  i0_.show_as_banner AS show_as_banner_10,
  i0_.banner_priority AS banner_priority_11,
  i0_.banner_url AS banner_url_12,
  i0_.url AS url_13,
  i0_.erid AS erid_14,
  i0_.ib_type AS ib_type_15,
  i0_.group_id AS group_id_16
FROM
  info_block i0_
WHERE
  (
    i0_.show_as_banner = true
    AND i0_.created_at <= CURRENT_DATE
    AND i0_.expires_after >= CURRENT_DATE
  )
  AND i0_.ib_type IN ('2')
ORDER BY
  i0_.banner_priority ASC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.title AS title_2, i0_.text AS text_3, i0_.image AS image_4, i0_.description_add AS description_add_5, i0_.keywords AS keywords_6, i0_.slug AS slug_7, i0_.expires_after AS expires_after_8, i0_.show_as_action AS show_as_action_9, i0_.show_as_banner AS show_as_banner_10, i0_.banner_priority AS banner_priority_11, i0_.banner_url AS banner_url_12, i0_.url AS url_13, i0_.erid AS erid_14, i0_.ib_type AS ib_type_15, i0_.group_id AS group_id_16 FROM info_block i0_ WHERE (i0_.show_as_banner = true AND i0_.created_at <= CURRENT_DATE AND i0_.expires_after >= CURRENT_DATE) AND i0_.ib_type IN ('2') ORDER BY i0_.banner_priority 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 41)
7	App\Service\Kolex->getBanners (line 1635)
8	twig_get_attribute (line 48)
9	__TwigTemplate_eece128f3eff990c429d6e9cd99d616d->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 55)
12	__TwigTemplate_4f28926632ebbcc43d875daa4f43ea76->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 89)
15	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
16	Twig\Template->displayBlock (line 151)
17	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 50)
20	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 52)
23	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 379)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 280)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 411)
32	App\Controller\MainController->diski (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

1.13 ms
(2.83%)

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id 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 76)
7	App\Service\Kolex->getTowns (line 1635)
8	twig_get_attribute (line 50)
9	__TwigTemplate_197b4befe5916dd7153adeae6f55ca00->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 47)
12	__TwigTemplate_1094c4c770ee184fd3c5eb201bfdb008->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 100)
15	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->block_content (line 171)
16	Twig\Template->displayBlock (line 82)
17	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
18	Twig\Template->displayBlock (line 151)
19	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 52)
25	__TwigTemplate_c833af8ce108a3c09b879fb2ead44e00->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 379)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 280)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 411)
34	App\Controller\MainController->diski (line 178)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	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\Product	No errors.
App\Entity\Tire	No errors.
App\Entity\Disk	No errors.
App\Entity\Order	No errors.
App\Entity\Rest	No errors.
App\Entity\SearchByVehicle	No errors.
App\Entity\Town	No errors.
App\Entity\Store	No errors.
App\Entity\InfoBlock	No errors.
App\Entity\Action	No errors.
App\Entity\InfoBlockGroup	No errors.

Symfony Profiler

GET https://test.kolex.ru/diski

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping