Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

1.49 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.70 ms
(47.18%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.position AS position_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_image t0 WHERE t0.vehicle_id = ? ORDER BY t0.position ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.position AS position_3,
  t0.vehicle_id AS vehicle_id_4
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.position AS position_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_image t0 WHERE t0.vehicle_id = 10 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1281)
9	__TwigTemplate_c3b63f2c34d863ae286a641a3abd6717::block_body (line 126)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_8f2cf527facb94b9abf7375cdbd43228->doDisplay (line 100)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_c3b63f2c34d863ae286a641a3abd6717->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\VehicleController->show (line 66)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.28 ms
(19.09%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.year AS year_6, t0.mileage AS mileage_7, t0.fuel AS fuel_8, t0.transmission AS transmission_9, t0.power AS power_10, t0.length AS length_11, t0.width AS width_12, t0.height AS height_13, t0.sleeping_capacity AS sleeping_capacity_14, t0.location AS location_15, t0.status AS status_16, t0.featured AS featured_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM vehicle t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "weinsberg-caracompact-600-meg-pepper"
]

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.description AS description_4,
  t0.price AS price_5,
  t0.year AS year_6,
  t0.mileage AS mileage_7,
  t0.fuel AS fuel_8,
  t0.transmission AS transmission_9,
  t0.power AS power_10,
  t0.length AS length_11,
  t0.width AS width_12,
  t0.height AS height_13,
  t0.sleeping_capacity AS sleeping_capacity_14,
  t0.location AS location_15,
  t0.status AS status_16,
  t0.featured AS featured_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19
FROM
  vehicle t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.year AS year_6, t0.mileage AS mileage_7, t0.fuel AS fuel_8, t0.transmission AS transmission_9, t0.power AS power_10, t0.length AS length_11, t0.width AS width_12, t0.height AS height_13, t0.sleeping_capacity AS sleeping_capacity_14, t0.location AS location_15, t0.status AS status_16, t0.featured AS featured_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM vehicle t0 WHERE t0.slug = 'weinsberg-caracompact-600-meg-pepper' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\VehicleController->show (line 51)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.27 ms
(17.97%)

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.slug AS slug_2, v0_.description AS description_3, v0_.price AS price_4, v0_.year AS year_5, v0_.mileage AS mileage_6, v0_.fuel AS fuel_7, v0_.transmission AS transmission_8, v0_.power AS power_9, v0_.length AS length_10, v0_.width AS width_11, v0_.height AS height_12, v0_.sleeping_capacity AS sleeping_capacity_13, v0_.location AS location_14, v0_.status AS status_15, v0_.featured AS featured_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18 FROM vehicle v0_ WHERE v0_.id <> ? AND v0_.status = ? LIMIT 3

Parameters:

[
  10
  "available"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.slug AS slug_2,
  v0_.description AS description_3,
  v0_.price AS price_4,
  v0_.year AS year_5,
  v0_.mileage AS mileage_6,
  v0_.fuel AS fuel_7,
  v0_.transmission AS transmission_8,
  v0_.power AS power_9,
  v0_.length AS length_10,
  v0_.width AS width_11,
  v0_.height AS height_12,
  v0_.sleeping_capacity AS sleeping_capacity_13,
  v0_.location AS location_14,
  v0_.status AS status_15,
  v0_.featured AS featured_16,
  v0_.created_at AS created_at_17,
  v0_.updated_at AS updated_at_18
FROM
  vehicle v0_
WHERE
  v0_.id <> ?
  AND v0_.status = ?
LIMIT
  3

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.slug AS slug_2, v0_.description AS description_3, v0_.price AS price_4, v0_.year AS year_5, v0_.mileage AS mileage_6, v0_.fuel AS fuel_7, v0_.transmission AS transmission_8, v0_.power AS power_9, v0_.length AS length_10, v0_.width AS width_11, v0_.height AS height_12, v0_.sleeping_capacity AS sleeping_capacity_13, v0_.location AS location_14, v0_.status AS status_15, v0_.featured AS featured_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18 FROM vehicle v0_ WHERE v0_.id <> 10 AND v0_.status = 'available' LIMIT 3;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\VehicleController->show (line 64)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.24 ms
(15.75%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.email AS email_4, t0.address AS address_5, t0.messenger_link AS messenger_link_6, t0.facebook_link AS facebook_link_7, t0.instagram_link AS instagram_link_8, t0.hero_title AS hero_title_9, t0.hero_subtitle AS hero_subtitle_10 FROM site_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.address AS address_5,
  t0.messenger_link AS messenger_link_6,
  t0.facebook_link AS facebook_link_7,
  t0.instagram_link AS instagram_link_8,
  t0.hero_title AS hero_title_9,
  t0.hero_subtitle AS hero_subtitle_10
FROM
  site_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.phone AS phone_3, t0.email AS email_4, t0.address AS address_5, t0.messenger_link AS messenger_link_6, t0.facebook_link AS facebook_link_7, t0.instagram_link AS instagram_link_8, t0.hero_title AS hero_title_9, t0.hero_subtitle AS hero_subtitle_10 FROM site_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\SiteSettingsRepository->getSettings (line 21)
5	App\Service\SettingsService->getGlobals (line 20)
6	Twig\ExtensionSet->getGlobals (line 365)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 406)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Controller\VehicleController->show (line 66)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	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\Vehicle	4
App\Entity\SiteSettings	1

Entities Mapping

Class	Mapping errors
App\Entity\Vehicle	No errors.
App\Entity\VehicleImage	No errors.
App\Entity\SiteSettings	No errors.

Symfony Profiler

GET https://kamperypolska.com/pojazdy/weinsberg-caracompact-600-meg-pepper

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping