Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

11.15 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.78 ms
(42.87%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.car_model AS car_model_4 FROM happy_customer t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.title AS title_3,
  t0.car_model AS car_model_4
FROM
  happy_customer t0

SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.car_model AS car_model_4 FROM happy_customer t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\CatalogController->home (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

4.05 ms
(36.30%)

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.model AS model_3,
  t0.year AS year_4,
  t0.version AS version_5,
  t0.type AS type_6,
  t0.price_purchase AS price_purchase_7,
  t0.price_sale AS price_sale_8,
  t0.consignment_price AS consignment_price_9,
  t0.commission AS commission_10,
  t0.status AS status_11,
  t0.published AS published_12,
  t0.featured AS featured_13,
  t0.is_unique AS is_unique_14,
  t0.stock AS stock_15,
  t0.mileage AS mileage_16,
  t0.vehicle_condition AS vehicle_condition_17,
  t0.fuel_type AS fuel_type_18,
  t0.transmission AS transmission_19,
  t0.color AS color_20,
  t0.description AS description_21,
  t0.images AS images_22,
  t0.location AS location_23,
  t0.currency AS currency_24,
  t0.license_plate AS license_plate_25,
  t0.engine_number AS engine_number_26,
  t0.chassis_number AS chassis_number_27,
  t0.registration_date AS registration_date_28,
  t0.slug AS slug_29,
  t0.tire_type AS tire_type_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.provider_id AS provider_id_33,
  t0.owner_id AS owner_id_34
FROM
  vehicle t0

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\CatalogController->navHierarchy (line 213)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
13	__TwigTemplate_ef0ceade1a7f6914a9f54626ceb78b67->doDisplay (line 489)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_95f8474e88ba7858db88a07701900d1f->doDisplay (line 55)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\CatalogController->home (line 39)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.06 ms
(9.53%)

SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT v0_.type AS type_0
FROM
  vehicle v0_

SELECT DISTINCT v0_.type AS type_0 FROM vehicle v0_;

#	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\CatalogController->quickView (line 245)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
14	__TwigTemplate_ef0ceade1a7f6914a9f54626ceb78b67->doDisplay (line 482)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_95f8474e88ba7858db88a07701900d1f->doDisplay (line 55)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
25	App\Controller\CatalogController->home (line 39)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.67 ms
(6.04%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.whatsapp AS whatsapp_6,
  t0.instagram AS instagram_7,
  t0.email AS email_8,
  t0.primary_color AS primary_color_9,
  t0.banner AS banner_10,
  t0.privacy AS privacy_11,
  t0.terms AS terms_12,
  t0.hero_video AS hero_video_13,
  t0.popup_enabled AS popup_enabled_14,
  t0.popup_side_text AS popup_side_text_15,
  t0.popup_title AS popup_title_16,
  t0.popup_description AS popup_description_17
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.address AS address_4, t0.phone AS phone_5, t0.whatsapp AS whatsapp_6, t0.instagram AS instagram_7, t0.email AS email_8, t0.primary_color AS primary_color_9, t0.banner AS banner_10, t0.privacy AS privacy_11, t0.terms AS terms_12, t0.hero_video AS hero_video_13, t0.popup_enabled AS popup_enabled_14, t0.popup_side_text AS popup_side_text_15, t0.popup_title AS popup_title_16, t0.popup_description AS popup_description_17 FROM company 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\ServiceEntityRepository->findOneBy (line 86)
4	App\EventSubscriber\CompanyContextSubscriber->onKernelController (line 29)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.59 ms
(5.27%)

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.featured = ? AND t0.published = ? ORDER BY t0.created_at DESC LIMIT 6

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.model AS model_3,
  t0.year AS year_4,
  t0.version AS version_5,
  t0.type AS type_6,
  t0.price_purchase AS price_purchase_7,
  t0.price_sale AS price_sale_8,
  t0.consignment_price AS consignment_price_9,
  t0.commission AS commission_10,
  t0.status AS status_11,
  t0.published AS published_12,
  t0.featured AS featured_13,
  t0.is_unique AS is_unique_14,
  t0.stock AS stock_15,
  t0.mileage AS mileage_16,
  t0.vehicle_condition AS vehicle_condition_17,
  t0.fuel_type AS fuel_type_18,
  t0.transmission AS transmission_19,
  t0.color AS color_20,
  t0.description AS description_21,
  t0.images AS images_22,
  t0.location AS location_23,
  t0.currency AS currency_24,
  t0.license_plate AS license_plate_25,
  t0.engine_number AS engine_number_26,
  t0.chassis_number AS chassis_number_27,
  t0.registration_date AS registration_date_28,
  t0.slug AS slug_29,
  t0.tire_type AS tire_type_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.provider_id AS provider_id_33,
  t0.owner_id AS owner_id_34
FROM
  vehicle t0
WHERE
  t0.featured = ?
  AND t0.published = ?
ORDER BY
  t0.created_at DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.version AS version_5, t0.type AS type_6, t0.price_purchase AS price_purchase_7, t0.price_sale AS price_sale_8, t0.consignment_price AS consignment_price_9, t0.commission AS commission_10, t0.status AS status_11, t0.published AS published_12, t0.featured AS featured_13, t0.is_unique AS is_unique_14, t0.stock AS stock_15, t0.mileage AS mileage_16, t0.vehicle_condition AS vehicle_condition_17, t0.fuel_type AS fuel_type_18, t0.transmission AS transmission_19, t0.color AS color_20, t0.description AS description_21, t0.images AS images_22, t0.location AS location_23, t0.currency AS currency_24, t0.license_plate AS license_plate_25, t0.engine_number AS engine_number_26, t0.chassis_number AS chassis_number_27, t0.registration_date AS registration_date_28, t0.slug AS slug_29, t0.tire_type AS tire_type_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.provider_id AS provider_id_33, t0.owner_id AS owner_id_34 FROM vehicle t0 WHERE t0.featured = 1 AND t0.published = 1 ORDER BY t0.created_at DESC LIMIT 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\CatalogController->home (line 36)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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

Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
App\Entity\Vehicle	No errors.
App\Entity\Provider	No errors.
App\Entity\Owner	No errors.
App\Entity\HappyCustomer	No errors.

Symfony Profiler

GET https://cars.monkaidev.com/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CController%255CCatalogController%253A%253AnavHierarchy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping