Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.91 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.73 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.display_name AS display_name_3, m0_.model_code AS model_code_4, m0_.image_name AS image_name_5, m0_.image_original_name AS image_original_name_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.model_id AS model_id_9 FROM model_year m0_ INNER JOIN model m1_ ON m0_.model_id = m1_.id INNER JOIN maker m2_ ON m1_.maker_id = m2_.id WHERE m0_.slug = ? AND m1_.slug = ? AND m2_.slug = ?

Parameters:

[
  "c4-11-20"
  "c4"
  "citroen"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2,
  m0_.display_name AS display_name_3,
  m0_.model_code AS model_code_4,
  m0_.image_name AS image_name_5,
  m0_.image_original_name AS image_original_name_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.model_id AS model_id_9
FROM
  model_year m0_
  INNER JOIN model m1_ ON m0_.model_id = m1_.id
  INNER JOIN maker m2_ ON m1_.maker_id = m2_.id
WHERE
  m0_.slug = ?
  AND m1_.slug = ?
  AND m2_.slug = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.display_name AS display_name_3, m0_.model_code AS model_code_4, m0_.image_name AS image_name_5, m0_.image_original_name AS image_original_name_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.model_id AS model_id_9 FROM model_year m0_ INNER JOIN model m1_ ON m0_.model_id = m1_.id INNER JOIN maker m2_ ON m1_.maker_id = m2_.id WHERE m0_.slug = 'c4-11-20' AND m1_.slug = 'c4' AND m2_.slug = 'citroen';

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 36)
7	App\Repository\Front\ModelYearRepository->getMakerModelYearSlug (line 35)
8	App\Controller\Front\ShopController->modelYearProducts (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)

1.80 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sku AS sku_2, p0_.is_in_stock AS is_in_stock_3, p0_.car_position AS car_position_4, p0_.is_genuine AS is_genuine_5, c1_.display_name AS display_name_6, p2_.regular AS regular_7, p0_.slug AS slug_8 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id INNER JOIN product_model_year p3_ ON p0_.id = p3_.product_id INNER JOIN price p2_ ON p0_.id = p2_.product_id WHERE p3_.model_year_id = ? ORDER BY p0_.name ASC

Parameters:

[
  670
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.sku AS sku_2,
  p0_.is_in_stock AS is_in_stock_3,
  p0_.car_position AS car_position_4,
  p0_.is_genuine AS is_genuine_5,
  c1_.display_name AS display_name_6,
  p2_.regular AS regular_7,
  p0_.slug AS slug_8
FROM
  product p0_
  INNER JOIN category c1_ ON p0_.category_id = c1_.id
  INNER JOIN product_model_year p3_ ON p0_.id = p3_.product_id
  INNER JOIN price p2_ ON p0_.id = p2_.product_id
WHERE
  p3_.model_year_id = ?
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sku AS sku_2, p0_.is_in_stock AS is_in_stock_3, p0_.car_position AS car_position_4, p0_.is_genuine AS is_genuine_5, c1_.display_name AS display_name_6, p2_.regular AS regular_7, p0_.slug AS slug_8 FROM product p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id INNER JOIN product_model_year p3_ ON p0_.id = p3_.product_id INNER JOIN price p2_ ON p0_.id = p2_.product_id WHERE p3_.model_year_id = 670 ORDER BY p0_.name 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 47)
7	App\Repository\Front\ProductRepository->findByModelYear (line 38)
8	App\Controller\Front\ShopController->modelYearProducts (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.17 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.is_visible AS is_visible_5, t0.group_name AS group_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.maker_id AS maker_id_9 FROM model t0 WHERE t0.id = ?

Parameters:

[
  371
]

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.display_name AS display_name_4,
  t0.is_visible AS is_visible_5,
  t0.group_name AS group_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.maker_id AS maker_id_9
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.is_visible AS is_visible_5, t0.group_name AS group_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.maker_id AS maker_id_9 FROM model t0 WHERE t0.id = 371;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\Model->__get (line 106)
7	App\Entity\Model->getMaker (line 44)
8	App\Controller\Front\ShopController->modelYearProducts (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.20 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.image_original_name AS image_original_name_6, t0.is_car_maker AS is_car_maker_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM maker t0 WHERE t0.id = ?

Parameters:

[
  7
]

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.display_name AS display_name_4,
  t0.image_name AS image_name_5,
  t0.image_original_name AS image_original_name_6,
  t0.is_car_maker AS is_car_maker_7,
  t0.is_visible AS is_visible_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  maker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4, t0.image_name AS image_name_5, t0.image_original_name AS image_original_name_6, t0.is_car_maker AS is_car_maker_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM maker t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 79)
6	Proxies\__CG__\App\Entity\Maker->__load (line 79)
7	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 122)
8	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 60)
9	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 35)
10	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 28)
11	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 96)
12	__TwigTemplate_b4f1eba453a9579e5b7a710f3ced6be3->block_body (line 430)
13	Twig\Template->yieldBlock (line 75)
14	__TwigTemplate_b6e818542f275fa9defd5e7fb0b4c1b7->doDisplay (line 360)
15	Twig\Template->yield (line 50)
16	__TwigTemplate_b4f1eba453a9579e5b7a710f3ced6be3->doDisplay (line 360)
17	Twig\Template->yield (line 335)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 307)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 39)
24	App\Controller\Front\ShopController->modelYearProducts (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\ModelYear	No errors.
App\Entity\Model	No errors.
App\Entity\Maker	No errors.
App\Entity\ProductModelYear	No errors.
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Price	No errors.

Symfony Profiler

GET https://devsite.gewrgakopoulos.gr/shop/citroen/c4/c4-11-20

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping