Symfony Profiler

Query Metrics

65 Database Queries

25 Different statements

41.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.45 ms
(22.62%)

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 WHERE t0.car_make_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.engine_capacity AS engine_capacity_2,
  t0.horsepower AS horsepower_3,
  t0.torque AS torque_4,
  t0.price_guide AS price_guide_5,
  t0.sunroof AS sunroof_6,
  t0.features AS features_7,
  t0.dimensions AS dimensions_8,
  t0.zero_to_hundred_time AS zero_to_hundred_time_9,
  t0.yom AS yom_10,
  t0.image AS image_11,
  t0.description AS description_12,
  t0.video_url AS video_url_13,
  t0.listing_position AS listing_position_14,
  t0.title AS title_15,
  t0.transparent_bg_image AS transparent_bg_image_16,
  t0.slug AS slug_17,
  t0.meta_description AS meta_description_18,
  t0.used AS used_19,
  t0.car_make_id AS car_make_id_20,
  t0.drive_type_id AS drive_type_id_21,
  t0.fuel_type_id AS fuel_type_id_22,
  t0.transmission_id AS transmission_id_23,
  t0.car_model_id AS car_model_id_24
FROM
  car t0
WHERE
  t0.car_make_id = ?

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 WHERE t0.car_make_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1799)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1744)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2699)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 394)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 204)
10	__TwigTemplate_aed10c04e3f35a69bec222971b1f0b46->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 214)
13	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
14	Twig\Template->displayBlock (line 376)
15	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 63)
18	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
27	App\Controller\IndexController->category (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

8.34 ms
(19.95%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.keywords AS keywords_6,
  t0.image AS image_7,
  t0.slug AS slug_8
FROM
  car_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 353)
6	App\Controller\IndexController->category (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

2.92 ms
(7.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.keywords AS keywords_6,
  t0.image AS image_7,
  t0.slug AS slug_8
FROM
  car_make t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 354)
6	App\Controller\IndexController->category (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

2.85 ms
(6.81%)

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 INNER JOIN car_category_car ON t0.id = car_category_car.car_id WHERE car_category_car.car_category_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.engine_capacity AS engine_capacity_2,
  t0.horsepower AS horsepower_3,
  t0.torque AS torque_4,
  t0.price_guide AS price_guide_5,
  t0.sunroof AS sunroof_6,
  t0.features AS features_7,
  t0.dimensions AS dimensions_8,
  t0.zero_to_hundred_time AS zero_to_hundred_time_9,
  t0.yom AS yom_10,
  t0.image AS image_11,
  t0.description AS description_12,
  t0.video_url AS video_url_13,
  t0.listing_position AS listing_position_14,
  t0.title AS title_15,
  t0.transparent_bg_image AS transparent_bg_image_16,
  t0.slug AS slug_17,
  t0.meta_description AS meta_description_18,
  t0.used AS used_19,
  t0.car_make_id AS car_make_id_20,
  t0.drive_type_id AS drive_type_id_21,
  t0.fuel_type_id AS fuel_type_id_22,
  t0.transmission_id AS transmission_id_23,
  t0.car_model_id AS car_model_id_24
FROM
  car t0
  INNER JOIN car_category_car ON t0.id = car_category_car.car_id
WHERE
  car_category_car.car_category_id = ?

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 INNER JOIN car_category_car ON t0.id = car_category_car.car_id WHERE car_category_car.car_category_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1047)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 976)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2703)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 394)
8	Doctrine\ORM\PersistentCollection->count (line 1127)
9	twig_length_filter (line 156)
10	__TwigTemplate_aed10c04e3f35a69bec222971b1f0b46->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 214)
13	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
14	Twig\Template->displayBlock (line 376)
15	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 63)
18	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
27	App\Controller\IndexController->category (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.43 ms
(5.81%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1

Parameters:

[
  "header-cta"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content_text AS content_text_4,
  t0.screenshot AS screenshot_5
FROM
  content t0
WHERE
  t0.description = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = 'header-cta' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 234)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 157)
5	Doctrine\ORM\EntityRepository->__call (line 100)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 38)
7	App\Twig\Render->renderContent (line 226)
8	__TwigTemplate_824d319966540ff00563b3e709af0d9f->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 367)
11	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 63)
14	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
23	App\Controller\IndexController->category (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

2.06 ms
(4.92%)

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.content AS content_2,
  b0_.publication_date AS publication_date_3,
  b0_.is_published AS is_published_4,
  b0_.slug AS slug_5,
  b0_.featured_image AS featured_image_6,
  b0_.meta_title AS meta_title_7,
  b0_.meta_description AS meta_description_8,
  b0_.video_url AS video_url_9,
  b0_.author_id AS author_id_10
FROM
  blog b0_
WHERE
  b0_.is_published = ?
ORDER BY
  b0_.id DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = 1 ORDER BY b0_.id DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 39)
7	App\Repository\BlogRepository->findPublished (line 53)
8	App\Twig\GlobalVars->getGlobalVars (line 62)
9	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 63)
12	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
21	App\Controller\IndexController->category (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.56 ms
(3.72%)

SELECT c0_.id AS id_0, c0_.engine_capacity AS engine_capacity_1, c0_.horsepower AS horsepower_2, c0_.torque AS torque_3, c0_.price_guide AS price_guide_4, c0_.sunroof AS sunroof_5, c0_.features AS features_6, c0_.dimensions AS dimensions_7, c0_.zero_to_hundred_time AS zero_to_hundred_time_8, c0_.yom AS yom_9, c0_.image AS image_10, c0_.description AS description_11, c0_.video_url AS video_url_12, c0_.listing_position AS listing_position_13, c0_.title AS title_14, c0_.transparent_bg_image AS transparent_bg_image_15, c0_.slug AS slug_16, c0_.meta_description AS meta_description_17, c0_.used AS used_18, c0_.car_make_id AS car_make_id_19, c0_.drive_type_id AS drive_type_id_20, c0_.fuel_type_id AS fuel_type_id_21, c0_.transmission_id AS transmission_id_22, c0_.car_model_id AS car_model_id_23 FROM car c0_ INNER JOIN car_category_car c2_ ON c0_.id = c2_.car_id INNER JOIN car_category c1_ ON c1_.id = c2_.car_category_id WHERE c1_.id = ? ORDER BY c0_.id DESC

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.engine_capacity AS engine_capacity_1,
  c0_.horsepower AS horsepower_2,
  c0_.torque AS torque_3,
  c0_.price_guide AS price_guide_4,
  c0_.sunroof AS sunroof_5,
  c0_.features AS features_6,
  c0_.dimensions AS dimensions_7,
  c0_.zero_to_hundred_time AS zero_to_hundred_time_8,
  c0_.yom AS yom_9,
  c0_.image AS image_10,
  c0_.description AS description_11,
  c0_.video_url AS video_url_12,
  c0_.listing_position AS listing_position_13,
  c0_.title AS title_14,
  c0_.transparent_bg_image AS transparent_bg_image_15,
  c0_.slug AS slug_16,
  c0_.meta_description AS meta_description_17,
  c0_.used AS used_18,
  c0_.car_make_id AS car_make_id_19,
  c0_.drive_type_id AS drive_type_id_20,
  c0_.fuel_type_id AS fuel_type_id_21,
  c0_.transmission_id AS transmission_id_22,
  c0_.car_model_id AS car_model_id_23
FROM
  car c0_
  INNER JOIN car_category_car c2_ ON c0_.id = c2_.car_id
  INNER JOIN car_category c1_ ON c1_.id = c2_.car_category_id
WHERE
  c1_.id = ?
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.engine_capacity AS engine_capacity_1, c0_.horsepower AS horsepower_2, c0_.torque AS torque_3, c0_.price_guide AS price_guide_4, c0_.sunroof AS sunroof_5, c0_.features AS features_6, c0_.dimensions AS dimensions_7, c0_.zero_to_hundred_time AS zero_to_hundred_time_8, c0_.yom AS yom_9, c0_.image AS image_10, c0_.description AS description_11, c0_.video_url AS video_url_12, c0_.listing_position AS listing_position_13, c0_.title AS title_14, c0_.transparent_bg_image AS transparent_bg_image_15, c0_.slug AS slug_16, c0_.meta_description AS meta_description_17, c0_.used AS used_18, c0_.car_make_id AS car_make_id_19, c0_.drive_type_id AS drive_type_id_20, c0_.fuel_type_id AS fuel_type_id_21, c0_.transmission_id AS transmission_id_22, c0_.car_model_id AS car_model_id_23 FROM car c0_ INNER JOIN car_category_car c2_ ON c0_.id = c2_.car_id INNER JOIN car_category c1_ ON c1_.id = c2_.car_category_id WHERE c1_.id = NULL ORDER BY c0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 363)
7	App\Controller\IndexController->category (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.37 ms
(3.28%)

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8 FROM page p0_ WHERE p0_.is_service = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.heading AS heading_1,
  p0_.meta_title AS meta_title_2,
  p0_.meta_description AS meta_description_3,
  p0_.url AS url_4,
  p0_.featured_image AS featured_image_5,
  p0_.page_content AS page_content_6,
  p0_.content_first AS content_first_7,
  p0_.is_service AS is_service_8
FROM
  page p0_
WHERE
  p0_.is_service = ?

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8 FROM page p0_ WHERE p0_.is_service = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\PageRepository->findByIsService (line 55)
8	App\Twig\GlobalVars->getGlobalVars (line 62)
9	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 63)
12	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
21	App\Controller\IndexController->category (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.18 ms
(2.83%)

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.phone_number AS phone_number_3,
  t0.work_hours AS work_hours_4,
  t0.instagram_link AS instagram_link_5,
  t0.facebook_link AS facebook_link_6,
  t0.youtube_link AS youtube_link_7,
  t0.tiktok_link AS tiktok_link_8,
  t0.business_location AS business_location_9,
  t0.twitter_link AS twitter_link_10,
  t0.linkedin_link AS linkedin_link_11,
  t0.google_map_embed AS google_map_embed_12,
  t0.email_address AS email_address_13
FROM
  setting t0

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 51)
6	App\Twig\GlobalVars->getGlobalVars (line 62)
7	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 63)
10	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
19	App\Controller\IndexController->category (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

1.18 ms
(2.82%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.template_path AS template_path_3,
  t0.priority AS priority_4
FROM
  section t0
  INNER JOIN page_section ON t0.id = page_section.section_id
WHERE
  page_section.page_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1047)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 976)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2703)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	iterator_to_array (line 898)
9	twig_sort_filter (line 124)
10	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
11	Twig\Template->displayBlock (line 376)
12	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 63)
15	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
24	App\Controller\IndexController->category (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.90 ms
(2.16%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9 FROM page t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "category"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.url AS url_5,
  t0.featured_image AS featured_image_6,
  t0.page_content AS page_content_7,
  t0.content_first AS content_first_8,
  t0.is_service AS is_service_9
FROM
  page t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9 FROM page t0 WHERE t0.url = 'category' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 234)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 157)
5	Doctrine\ORM\EntityRepository->__call (line 100)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 398)
7	App\Controller\IndexController->category (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.80 ms
(1.93%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.content_text AS content_text_4,
  t0.screenshot AS screenshot_5
FROM
  content t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 386)
6	App\Controller\IndexController->category (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.78 ms
(1.87%)

SELECT DISTINCT c0_.name AS name_0 FROM car_model c0_ WHERE c0_.name IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.name AS name_0
FROM
  car_model c0_
WHERE
  c0_.name IS NOT NULL

SELECT DISTINCT c0_.name AS name_0 FROM car_model c0_ WHERE c0_.name IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 220)
7	App\Controller\IndexController->getBrandsModelsYears (line 382)
8	App\Controller\IndexController->category (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.76 ms
(1.81%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.logo_path AS logo_path_5,
  t0.keywords AS keywords_6
FROM
  seo t0

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 50)
6	App\Twig\GlobalVars->getGlobalVars (line 62)
7	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 63)
10	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
19	App\Controller\IndexController->category (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.75 ms
(1.79%)

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0 ORDER BY t0.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.logo_path AS logo_path_5,
  t0.keywords AS keywords_6
FROM
  seo t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 84)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 404)
5	App\Controller\IndexController->category (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.64 ms
(1.53%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.src AS src_4
FROM
  image t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 387)
6	App\Controller\IndexController->category (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.58 ms
(1.39%)

SELECT DISTINCT c0_.yom AS yom_0 FROM car c0_ WHERE c0_.yom IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.yom AS yom_0
FROM
  car c0_
WHERE
  c0_.yom IS NOT NULL

SELECT DISTINCT c0_.yom AS yom_0 FROM car c0_ WHERE c0_.yom IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 226)
7	App\Controller\IndexController->getBrandsModelsYears (line 382)
8	App\Controller\IndexController->category (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.58 ms
(1.38%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM fuel_type t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  fuel_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM fuel_type t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\FuelType::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\FuelType->__get (line 31)
8	App\Entity\FuelType->__toString (line 101)
9	App\Entity\Car->__toString (line 193)
10	twig_escape_filter (line 129)
11	__TwigTemplate_6d17a49a0ca805c404e367bb87d6517f->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 1347)
16	twig_include (line 197)
17	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
18	Twig\Template->displayBlock (line 376)
19	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 63)
22	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
31	App\Controller\IndexController->category (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.52 ms
(1.25%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.keywords AS keywords_5, c0_.image AS image_6, c0_.slug AS slug_7 FROM car_make c0_ WHERE c0_.name IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.meta_title AS meta_title_3,
  c0_.meta_description AS meta_description_4,
  c0_.keywords AS keywords_5,
  c0_.image AS image_6,
  c0_.slug AS slug_7
FROM
  car_make c0_
WHERE
  c0_.name IS NOT NULL

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.keywords AS keywords_5, c0_.image AS image_6, c0_.slug AS slug_7 FROM car_make c0_ WHERE c0_.name IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 214)
7	App\Controller\IndexController->getBrandsModelsYears (line 382)
8	App\Controller\IndexController->category (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.51 ms
(1.23%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM transmission t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  transmission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM transmission t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Transmission::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Transmission->__get (line 31)
8	App\Entity\Transmission->__toString (line 193)
9	twig_escape_filter (line 137)
10	__TwigTemplate_6d17a49a0ca805c404e367bb87d6517f->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 197)
16	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
17	Twig\Template->displayBlock (line 376)
18	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 63)
21	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
30	App\Controller\IndexController->category (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.43 ms
(1.03%)

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 WHERE t0.car_make_id = ? ORDER BY t0.id DESC

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.engine_capacity AS engine_capacity_2,
  t0.horsepower AS horsepower_3,
  t0.torque AS torque_4,
  t0.price_guide AS price_guide_5,
  t0.sunroof AS sunroof_6,
  t0.features AS features_7,
  t0.dimensions AS dimensions_8,
  t0.zero_to_hundred_time AS zero_to_hundred_time_9,
  t0.yom AS yom_10,
  t0.image AS image_11,
  t0.description AS description_12,
  t0.video_url AS video_url_13,
  t0.listing_position AS listing_position_14,
  t0.title AS title_15,
  t0.transparent_bg_image AS transparent_bg_image_16,
  t0.slug AS slug_17,
  t0.meta_description AS meta_description_18,
  t0.used AS used_19,
  t0.car_make_id AS car_make_id_20,
  t0.drive_type_id AS drive_type_id_21,
  t0.fuel_type_id AS fuel_type_id_22,
  t0.transmission_id AS transmission_id_23,
  t0.car_model_id AS car_model_id_24
FROM
  car t0
WHERE
  t0.car_make_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.used AS used_19, t0.car_make_id AS car_make_id_20, t0.drive_type_id AS drive_type_id_21, t0.fuel_type_id AS fuel_type_id_22, t0.transmission_id AS transmission_id_23, t0.car_model_id AS car_model_id_24 FROM car t0 WHERE t0.car_make_id = 14 ORDER BY t0.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 76)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 370)
5	App\Controller\IndexController->category (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.34 ms
(0.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Mitsubishi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.keywords AS keywords_6,
  t0.image AS image_7,
  t0.slug AS slug_8
FROM
  car_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_category t0 WHERE t0.slug = 'Mitsubishi' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 234)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 157)
5	Doctrine\ORM\EntityRepository->__call (line 100)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 356)
7	App\Controller\IndexController->category (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.34 ms
(0.81%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "widget-chag-img"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.src AS src_4
FROM
  image t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0 WHERE t0.slug = 'widget-chag-img' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 84)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 159)
5	App\Twig\Render->renderImage (line 405)
6	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 63)
9	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
18	App\Controller\IndexController->category (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.30 ms
(0.72%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Mitsubishi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.keywords AS keywords_6,
  t0.image AS image_7,
  t0.slug AS slug_8
FROM
  car_make t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0 WHERE t0.slug = 'Mitsubishi' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 234)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 157)
5	Doctrine\ORM\EntityRepository->__call (line 100)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 367)
7	App\Controller\IndexController->category (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.22 ms
(0.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.car_make_id AS car_make_id_3 FROM car_model t0 WHERE t0.id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.car_make_id AS car_make_id_3
FROM
  car_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.car_make_id AS car_make_id_3 FROM car_model t0 WHERE t0.id = 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\CarModel::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\CarModel->__get (line 34)
8	App\Entity\CarModel->__toString (line 101)
9	App\Entity\Car->__toString (line 193)
10	twig_escape_filter (line 129)
11	__TwigTemplate_6d17a49a0ca805c404e367bb87d6517f->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 1347)
16	twig_include (line 197)
17	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->block_page (line 171)
18	Twig\Template->displayBlock (line 376)
19	__TwigTemplate_58083025ead149c377b43d59548e284b->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 63)
22	__TwigTemplate_adb84d54dca237c6fe27fd38fcd9f0f6->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 425)
31	App\Controller\IndexController->category (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	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\CarCategory	No errors.
App\Entity\Car	No errors.
App\Entity\CarMake	No errors.
App\Entity\CarModel	No errors.
App\Entity\DriveType	No errors.
App\Entity\FuelType	No errors.
App\Entity\Transmission	No errors.
App\Entity\CarImages	No errors.
App\Entity\Content	No errors.
App\Entity\Image	No errors.
App\Entity\Page	No errors.
App\Entity\Section	No errors.
App\Entity\SEO	No errors.
App\Entity\Setting	No errors.
App\Entity\Blog	No errors.
App\Entity\User	No errors.
App\Entity\BlogCategory	No errors.

Symfony Profiler

GET https://gybird.co.ke/category/Mitsubishi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping