Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

20.07 ms Query time

0 Invalid entities

10 Managed entities

Show all queries

Time▼

Count

Info

5.43 ms
(27.04%)

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_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id WHERE t1_.slug = ? AND d2_.slug = ? AND v0_.construction_year = ? AND m3_.slug = ? AND s4_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t1_.name ASC LIMIT 20

Parameters:

  0 of 0   
[▼
  "610-f-150-lightning"
  "18-pick-up"
  "2005"
  "4-matchbox"
  "2"
  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_.brand_id AS brand_id_11,
  v0_.design_type_id AS design_type_id_12,
  v0_.bottom_embossing_id AS bottom_embossing_id_13,
  v0_.type_id AS type_id_14,
  v0_.tire_type_id AS tire_type_id_15,
  v0_.scale_id AS scale_id_16,
  v0_.series_id AS series_id_17,
  v0_.manufacturer_id AS manufacturer_id_18,
  v0_.category_id AS category_id_19
FROM
  vehicle v0_
  LEFT JOIN type t1_ ON v0_.type_id = t1_.id
  LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id
  LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id
  LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id
WHERE
  t1_.slug = ?
  AND d2_.slug = ?
  AND v0_.construction_year = ?
  AND m3_.slug = ?
  AND s4_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  t1_.name ASC
LIMIT
  20

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_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id WHERE t1_.slug = '610-f-150-lightning' AND d2_.slug = '18-pick-up' AND v0_.construction_year = '2005' AND m3_.slug = '4-matchbox' AND s4_.slug = '2' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY t1_.name ASC LIMIT 20;

#	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 438)
7	App\Controller\MainController->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)

3.81 ms
(18.99%)

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id WHERE t1_.slug = ? AND d2_.slug = ? AND v0_.construction_year = ? AND m3_.slug = ? AND s4_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY t1_.name ASC

Parameters:

  0 of 0   
[▼
  "610-f-150-lightning"
  "18-pick-up"
  "2005"
  "4-matchbox"
  "2"
  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 type t1_ ON v0_.type_id = t1_.id
  LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id
  LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id
  LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id
WHERE
  t1_.slug = ?
  AND d2_.slug = ?
  AND v0_.construction_year = ?
  AND m3_.slug = ?
  AND s4_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  t1_.name ASC

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN type t1_ ON v0_.type_id = t1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN manufacturer m3_ ON v0_.manufacturer_id = m3_.id LEFT JOIN scale s4_ ON v0_.scale_id = s4_.id WHERE t1_.slug = '610-f-150-lightning' AND d2_.slug = '18-pick-up' AND v0_.construction_year = '2005' AND m3_.slug = '4-matchbox' AND s4_.slug = '2' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY t1_.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 345)
8	App\Service\VehicleFilterCompiler->getPagingInfo (line 439)
9	App\Controller\MainController->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)

3.78 ms
(18.83%)

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:

  0 of 0   
[▼
  "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 168)
5	App\Service\VehicleFilterCompiler->compile (line 429)
6	App\Controller\MainController->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.27 ms
(16.31%)

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:

  0 of 0   
[▼
  "2"
]

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 = '2' 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 168)
5	App\Service\VehicleFilterCompiler->compile (line 429)
6	App\Controller\MainController->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)

2.17 ms
(10.79%)

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:

  0 of 0   
[▼
  "610-f-150-lightning"
]

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 = '610-f-150-lightning' 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 168)
5	App\Service\VehicleFilterCompiler->compile (line 429)
6	App\Controller\MainController->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)

1.61 ms
(8.04%)

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:

  0 of 0   
[▼
  "18-pick-up"
]

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 = '18-pick-up' 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 168)
5	App\Service\VehicleFilterCompiler->compile (line 429)
6	App\Controller\MainController->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)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

default entity manager

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

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

Symfony Profiler

GET https://tcc.se-ck.de/_fragment?_path=_format%3Dhtml%26_locale%3Dde%26_controller%3DApp%255CController%255CMainController%253A%253Aheader

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping

Symfony Profiler

GET https://tcc.se-ck.de/_fragment?_path=_format%3Dhtml%26_locale%3Dde%26_controller%3DApp%255CController%255CMainController%253A%253Aheader

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping