Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

4.97 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.84 ms
(57.06%)

SELECT t0.id AS id_1, t0.vendor AS vendor_2, t0.model AS model_3, t0.image AS image_4, t0.image_name_opt AS image_name_opt_5, t0.sale AS sale_6, t0.hit AS hit_7, t0.weight AS weight_8, t0.width AS width_9, t0.diameter AS diameter_10, t0.int_code AS int_code_11, t0.vendor_code AS vendor_code_12, t0.updated_at AS updated_at_13, t0.available AS available_14, t0.calculated_price AS calculated_price_15, t0.calculated_price_ext AS calculated_price_ext_16, t0.calculated_external AS calculated_external_17, t0.season AS season_18, t0.studded AS studded_19, t0.height AS height_20, t0."load" AS load_21, t0.speed AS speed_22, t0.design AS design_23, t0.runflat AS runflat_24, t0.usa AS usa_25, t0.screws AS screws_26, t0.hole AS hole_27, t0.pcd AS pcd_28, t0.et AS et_29, t0.color AS color_30, t0.stamped AS stamped_31, t0.calculated_pcd AS calculated_pcd_32, t0.calculated_count AS calculated_count_33, t0.slug AS slug_34, t0.p_type FROM product t0 WHERE t0.slug = ? AND t0.p_type IN ('1') AND ((t0.available=true)) LIMIT 1

Parameters:

[
  "michelin-x-ice-north-4-225-45-r17-94t"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.vendor AS vendor_2,
  t0.model AS model_3,
  t0.image AS image_4,
  t0.image_name_opt AS image_name_opt_5,
  t0.sale AS sale_6,
  t0.hit AS hit_7,
  t0.weight AS weight_8,
  t0.width AS width_9,
  t0.diameter AS diameter_10,
  t0.int_code AS int_code_11,
  t0.vendor_code AS vendor_code_12,
  t0.updated_at AS updated_at_13,
  t0.available AS available_14,
  t0.calculated_price AS calculated_price_15,
  t0.calculated_price_ext AS calculated_price_ext_16,
  t0.calculated_external AS calculated_external_17,
  t0.season AS season_18,
  t0.studded AS studded_19,
  t0.height AS height_20,
  t0."load" AS load_21,
  t0.speed AS speed_22,
  t0.design AS design_23,
  t0.runflat AS runflat_24,
  t0.usa AS usa_25,
  t0.screws AS screws_26,
  t0.hole AS hole_27,
  t0.pcd AS pcd_28,
  t0.et AS et_29,
  t0.color AS color_30,
  t0.stamped AS stamped_31,
  t0.calculated_pcd AS calculated_pcd_32,
  t0.calculated_count AS calculated_count_33,
  t0.slug AS slug_34,
  t0.p_type
FROM
  product t0
WHERE
  t0.slug = ?
  AND t0.p_type IN ('1')
  AND (
    (t0.available = true)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.vendor AS vendor_2, t0.model AS model_3, t0.image AS image_4, t0.image_name_opt AS image_name_opt_5, t0.sale AS sale_6, t0.hit AS hit_7, t0.weight AS weight_8, t0.width AS width_9, t0.diameter AS diameter_10, t0.int_code AS int_code_11, t0.vendor_code AS vendor_code_12, t0.updated_at AS updated_at_13, t0.available AS available_14, t0.calculated_price AS calculated_price_15, t0.calculated_price_ext AS calculated_price_ext_16, t0.calculated_external AS calculated_external_17, t0.season AS season_18, t0.studded AS studded_19, t0.height AS height_20, t0."load" AS load_21, t0.speed AS speed_22, t0.design AS design_23, t0.runflat AS runflat_24, t0.usa AS usa_25, t0.screws AS screws_26, t0.hole AS hole_27, t0.pcd AS pcd_28, t0.et AS et_29, t0.color AS color_30, t0.stamped AS stamped_31, t0.calculated_pcd AS calculated_pcd_32, t0.calculated_count AS calculated_count_33, t0.slug AS slug_34, t0.p_type FROM product t0 WHERE t0.slug = 'michelin-x-ice-north-4-225-45-r17-94t' AND t0.p_type IN ('1') AND ((t0.available=true)) 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 1002)
4	App\Controller\MainController->catalogTireModelItem (line 891)
5	App\Controller\MainController->catalogTireVendor (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.78 ms
(15.62%)

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:

[
  "S_[MICHELIN]_183785"
]

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 = 'S_[MICHELIN]_183785';

#	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 462)
8	App\Entity\Product->getTownCount (line 1635)
9	twig_get_attribute (line 43)
10	__TwigTemplate_a1ba83f2b13799c33e47deca6833b070->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 166)
13	__TwigTemplate_f9ebc2a938528ea685e73f63e01b8045->block_content (line 171)
14	Twig\Template->displayBlock (line 80)
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 48)
23	__TwigTemplate_f9ebc2a938528ea685e73f63e01b8045->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 1015)
32	App\Controller\MainController->catalogTireModelItem (line 891)
33	App\Controller\MainController->catalogTireVendor (line 178)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

0.77 ms
(15.54%)

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:

[
  "nsk"
]

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 = 'nsk' 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	ContainerG0Am81P\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 1015)
12	App\Controller\MainController->catalogTireModelItem (line 891)
13	App\Controller\MainController->catalogTireVendor (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.59 ms
(11.78%)

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 54)
9	__TwigTemplate_af3255f4a26e139158aac2b1209ce55b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 99)
12	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
13	Twig\Template->displayBlock (line 151)
14	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 50)
17	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 48)
20	__TwigTemplate_f9ebc2a938528ea685e73f63e01b8045->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1015)
29	App\Controller\MainController->catalogTireModelItem (line 891)
30	App\Controller\MainController->catalogTireVendor (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\Town	No errors.
App\Entity\Store	No errors.

Symfony Profiler

GET https://nsk.stokuznecov.ru/shiny/michelin-x-ice-north-4-225-45-r17-94t

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping