Symfony Profiler

Query Metrics

51 Database Queries

15 Different statements

88.60 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.46 ms
(20.84%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM design_type t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "50-kompaktwagen"
]

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
FROM
  design_type t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM design_type t0 WHERE t0.slug = '50-kompaktwagen' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Service\VehicleFilterCompiler->compile (line 307)
6	App\Controller\FrontendController->lib (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

10.18 ms
(11.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "4-matchbox"
]

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
FROM
  manufacturer t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = '4-matchbox' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Service\VehicleFilterCompiler->compile (line 307)
6	App\Controller\FrontendController->lib (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

10.11 ms
(11.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.vehicle_id = ? ORDER BY t0.name_original ASC

Parameters:

[
  1263
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_original AS name_original_3,
  t0.mime_type AS mime_type_4,
  t0.path AS path_5,
  t0.path_base AS path_base_6,
  t0.category AS category_7,
  t0.vehicle_id AS vehicle_id_8,
  t0.article_id AS article_id_9
FROM
  file t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.name_original ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.vehicle_id = 1263 ORDER BY t0.name_original ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 518)
8	Doctrine\ORM\PersistentCollection->first (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 50)
10	__TwigTemplate_757040f8759c6f5831f14a1a2c73f8f1->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 1520)
15	Twig\Extension\CoreExtension::include (line 72)
16	__TwigTemplate_35bd65265800d6ac19e13830f0196e51->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1520)
21	Twig\Extension\CoreExtension::include (line 116)
22	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
23	Twig\Template->yieldBlock (line 137)
24	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
25	Twig\Template->yield (line 65)
26	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 333)
31	Twig\Environment->render (line 459)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
35	App\Controller\FrontendController->lib (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

9.77 ms
(11.03%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "1-ohne-angabe"
]

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
FROM
  scale t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = '1-ohne-angabe' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Service\VehicleFilterCompiler->compile (line 307)
6	App\Controller\FrontendController->lib (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

9.65 ms
(10.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "74-mini"
]

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
FROM
  brand t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = '74-mini' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Service\VehicleFilterCompiler->compile (line 307)
6	App\Controller\FrontendController->lib (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

9.12 ms
(10.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "136-evening-news-v…"
]

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
FROM
  type t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = '136-evening-news-v…' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Service\VehicleFilterCompiler->compile (line 307)
6	App\Controller\FrontendController->lib (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

3.85 ms
(4.35%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM brand b0_ LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND d2_.slug = ? AND v1_.construction_year = ? AND s3_.slug = ? AND m4_.slug = ? ORDER BY b0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2
FROM
  brand b0_
  LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id)
  LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id)
  LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id)
  LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND d2_.slug = ?
  AND v1_.construction_year = ?
  AND s3_.slug = ?
  AND m4_.slug = ?
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM brand b0_ LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND d2_.slug = '50-kompaktwagen' AND v1_.construction_year = '2024' AND s3_.slug = '1-ohne-angabe' AND m4_.slug = '4-matchbox' ORDER BY b0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.41 ms
(2.72%)

SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.description_extra AS description_extra_11, v0_.brand_id AS brand_id_12, v0_.design_type_id AS design_type_id_13, v0_.bottom_embossing_id AS bottom_embossing_id_14, v0_.type_id AS type_id_15, v0_.tire_type_id AS tire_type_id_16, v0_.scale_id AS scale_id_17, v0_.series_id AS series_id_18, v0_.manufacturer_id AS manufacturer_id_19, v0_.category_id AS category_id_20 FROM vehicle v0_ LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id LEFT JOIN series s5_ ON v0_.series_id = s5_.id WHERE d1_.slug = ? AND b2_.slug = ? AND v0_.construction_year = ? AND s3_.slug = ? AND m4_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s5_.name ASC LIMIT 50

Parameters:

[
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
  1
  "collection"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.construction_year AS construction_year_1,
  v0_.labeling AS labeling_2,
  v0_.article_number AS article_number_3,
  v0_.purchased_at AS purchased_at_4,
  v0_.storage_location AS storage_location_5,
  v0_.condition_rating AS condition_rating_6,
  v0_.approved AS approved_7,
  v0_.visible AS visible_8,
  v0_.status AS status_9,
  v0_.description AS description_10,
  v0_.description_extra AS description_extra_11,
  v0_.brand_id AS brand_id_12,
  v0_.design_type_id AS design_type_id_13,
  v0_.bottom_embossing_id AS bottom_embossing_id_14,
  v0_.type_id AS type_id_15,
  v0_.tire_type_id AS tire_type_id_16,
  v0_.scale_id AS scale_id_17,
  v0_.series_id AS series_id_18,
  v0_.manufacturer_id AS manufacturer_id_19,
  v0_.category_id AS category_id_20
FROM
  vehicle v0_
  LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id
  LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id
  LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id
  LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id
  LEFT JOIN series s5_ ON v0_.series_id = s5_.id
WHERE
  d1_.slug = ?
  AND b2_.slug = ?
  AND v0_.construction_year = ?
  AND s3_.slug = ?
  AND m4_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  s5_.name ASC
LIMIT
  50

SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.description_extra AS description_extra_11, v0_.brand_id AS brand_id_12, v0_.design_type_id AS design_type_id_13, v0_.bottom_embossing_id AS bottom_embossing_id_14, v0_.type_id AS type_id_15, v0_.tire_type_id AS tire_type_id_16, v0_.scale_id AS scale_id_17, v0_.series_id AS series_id_18, v0_.manufacturer_id AS manufacturer_id_19, v0_.category_id AS category_id_20 FROM vehicle v0_ LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id LEFT JOIN series s5_ ON v0_.series_id = s5_.id WHERE d1_.slug = '50-kompaktwagen' AND b2_.slug = '74-mini' AND v0_.construction_year = '2024' AND s3_.slug = '1-ohne-angabe' AND m4_.slug = '4-matchbox' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY s5_.name ASC LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 316)
7	App\Controller\FrontendController->lib (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.33 ms
(2.63%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM manufacturer m0_ LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND d2_.slug = ? AND b3_.slug = ? AND v1_.construction_year = ? AND s4_.slug = ? ORDER BY m0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "1-ohne-angabe"
]

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
FROM
  manufacturer m0_
  LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id)
  LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id)
  LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id)
  LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND d2_.slug = ?
  AND b3_.slug = ?
  AND v1_.construction_year = ?
  AND s4_.slug = ?
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM manufacturer m0_ LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND d2_.slug = '50-kompaktwagen' AND b3_.slug = '74-mini' AND v1_.construction_year = '2024' AND s4_.slug = '1-ohne-angabe' ORDER BY m0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.32 ms
(2.62%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM design_type d0_ LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id) LEFT JOIN brand b2_ ON (b2_.id = v1_.brand_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND b2_.slug = ? AND v1_.construction_year = ? AND s3_.slug = ? AND m4_.slug = ? ORDER BY d0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "74-mini"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  design_type d0_
  LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id)
  LEFT JOIN brand b2_ ON (b2_.id = v1_.brand_id)
  LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id)
  LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND b2_.slug = ?
  AND v1_.construction_year = ?
  AND s3_.slug = ?
  AND m4_.slug = ?
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM design_type d0_ LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id) LEFT JOIN brand b2_ ON (b2_.id = v1_.brand_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND b2_.slug = '74-mini' AND v1_.construction_year = '2024' AND s3_.slug = '1-ohne-angabe' AND m4_.slug = '4-matchbox' ORDER BY d0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.21 ms
(2.50%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM type t0_ LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND d2_.slug = ? AND b3_.slug = ? AND v1_.construction_year = ? AND s4_.slug = ? AND m5_.slug = ? ORDER BY t0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2
FROM
  type t0_
  LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id)
  LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id)
  LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id)
  LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id)
  LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND d2_.slug = ?
  AND b3_.slug = ?
  AND v1_.construction_year = ?
  AND s4_.slug = ?
  AND m5_.slug = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM type t0_ LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND d2_.slug = '50-kompaktwagen' AND b3_.slug = '74-mini' AND v1_.construction_year = '2024' AND s4_.slug = '1-ohne-angabe' AND m5_.slug = '4-matchbox' ORDER BY t0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.16 ms
(2.44%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM series s0_ LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND d2_.slug = ? AND b3_.slug = ? AND v1_.construction_year = ? AND s4_.slug = ? AND m5_.slug = ? ORDER BY s0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2
FROM
  series s0_
  LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id)
  LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id)
  LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id)
  LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id)
  LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND d2_.slug = ?
  AND b3_.slug = ?
  AND v1_.construction_year = ?
  AND s4_.slug = ?
  AND m5_.slug = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM series s0_ LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) LEFT JOIN manufacturer m5_ ON (m5_.id = v1_.manufacturer_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND d2_.slug = '50-kompaktwagen' AND b3_.slug = '74-mini' AND v1_.construction_year = '2024' AND s4_.slug = '1-ohne-angabe' AND m5_.slug = '4-matchbox' ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.06 ms
(2.32%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM scale s0_ LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND d2_.slug = ? AND b3_.slug = ? AND v1_.construction_year = ? AND m4_.slug = ? ORDER BY s0_.name ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2
FROM
  scale s0_
  LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id)
  LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id)
  LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id)
  LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND d2_.slug = ?
  AND b3_.slug = ?
  AND v1_.construction_year = ?
  AND m4_.slug = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM scale s0_ LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id) LEFT JOIN design_type d2_ ON (d2_.id = v1_.design_type_id) LEFT JOIN brand b3_ ON (b3_.id = v1_.brand_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v1_.manufacturer_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND d2_.slug = '50-kompaktwagen' AND b3_.slug = '74-mini' AND v1_.construction_year = '2024' AND m4_.slug = '4-matchbox' ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.04 ms
(2.30%)

SELECT v0_.construction_year AS construction_year_0 FROM vehicle v0_ LEFT JOIN design_type d1_ ON (d1_.id = v0_.design_type_id) LEFT JOIN brand b2_ ON (b2_.id = v0_.brand_id) LEFT JOIN scale s3_ ON (s3_.id = v0_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v0_.manufacturer_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = ? AND v0_.approved = ? AND v0_.visible = ? AND d1_.slug = ? AND b2_.slug = ? AND s3_.slug = ? AND m4_.slug = ? GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC

Parameters:

[
  "collection"
  1
  1
  "50-kompaktwagen"
  "74-mini"
  "1-ohne-angabe"
  "4-matchbox"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.construction_year AS construction_year_0
FROM
  vehicle v0_
  LEFT JOIN design_type d1_ ON (d1_.id = v0_.design_type_id)
  LEFT JOIN brand b2_ ON (b2_.id = v0_.brand_id)
  LEFT JOIN scale s3_ ON (s3_.id = v0_.scale_id)
  LEFT JOIN manufacturer m4_ ON (m4_.id = v0_.manufacturer_id)
WHERE
  v0_.construction_year IS NOT NULL
  AND v0_.construction_year <> 0
  AND v0_.status = ?
  AND v0_.approved = ?
  AND v0_.visible = ?
  AND d1_.slug = ?
  AND b2_.slug = ?
  AND s3_.slug = ?
  AND m4_.slug = ?
GROUP BY
  v0_.construction_year
ORDER BY
  v0_.construction_year ASC

SELECT v0_.construction_year AS construction_year_0 FROM vehicle v0_ LEFT JOIN design_type d1_ ON (d1_.id = v0_.design_type_id) LEFT JOIN brand b2_ ON (b2_.id = v0_.brand_id) LEFT JOIN scale s3_ ON (s3_.id = v0_.scale_id) LEFT JOIN manufacturer m4_ ON (m4_.id = v0_.manufacturer_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = 'collection' AND v0_.approved = 1 AND v0_.visible = 1 AND d1_.slug = '50-kompaktwagen' AND b2_.slug = '74-mini' AND s3_.slug = '1-ohne-angabe' AND m4_.slug = '4-matchbox' GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 104)
7	App\Service\VehicleFilterSetLoader->get (line 154)
8	App\Controller\FrontendController->filter (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 94)
16	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->block_body (line 446)
17	Twig\Template->yieldBlock (line 137)
18	__TwigTemplate_3dd7a1fce45b790724e88552e56a713b->doDisplay (line 402)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_91d7de6389a910a4cec7d0e14bc079e5->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 326)
29	App\Controller\FrontendController->lib (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

1.91 ms
(2.16%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id LEFT JOIN series s5_ ON v0_.series_id = s5_.id WHERE d1_.slug = ? AND b2_.slug = ? AND v0_.construction_year = ? AND s3_.slug = ? AND m4_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s5_.name ASC

Parameters:

[
  "50-kompaktwagen"
  "74-mini"
  "2024"
  "1-ohne-angabe"
  "4-matchbox"
  1
  "collection"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicle v0_
  LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id
  LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id
  LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id
  LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id
  LEFT JOIN series s5_ ON v0_.series_id = s5_.id
WHERE
  d1_.slug = ?
  AND b2_.slug = ?
  AND v0_.construction_year = ?
  AND s3_.slug = ?
  AND m4_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  s5_.name ASC

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN design_type d1_ ON v0_.design_type_id = d1_.id LEFT JOIN brand b2_ ON v0_.brand_id = b2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN manufacturer m4_ ON v0_.manufacturer_id = m4_.id LEFT JOIN series s5_ ON v0_.series_id = s5_.id WHERE d1_.slug = '50-kompaktwagen' AND b2_.slug = '74-mini' AND v0_.construction_year = '2024' AND s3_.slug = '1-ohne-angabe' AND m4_.slug = '4-matchbox' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY s5_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 349)
8	App\Service\VehicleFilterCompiler->getPagingInfo (line 317)
9	App\Controller\FrontendController->lib (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Brand	5
App\Entity\File	3
App\Entity\Vehicle	2
App\Entity\DesignType	1
App\Entity\Scale	1
App\Entity\Manufacturer	1
App\Entity\BottomEmbossing	1
App\Entity\Type	1
App\Entity\TireType	1
App\Entity\Series	1
App\Entity\Category	1

Entities Mapping

Class	Mapping errors
App\Entity\Vehicle	No errors.
App\Entity\Type	No errors.
App\Entity\DesignType	No errors.
App\Entity\Brand	No errors.
App\Entity\Scale	No errors.
App\Entity\Manufacturer	No errors.
App\Entity\Series	No errors.
App\Entity\BottomEmbossing	No errors.
App\Entity\TireType	No errors.
App\Entity\Category	No errors.
App\Entity\Color	No errors.
App\Entity\File	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://tcc.se-ck.de/en/vehicles/sortierung/serie/modell/136-evening-news-v%E2%80%A6/bauart/50-kompaktwagen/marke/74-mini/jahr/2024/ma%C3%9Fstab/1-ohne-angabe/h…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping