Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

0.95 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.37 ms

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.28 ms

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\Controller\CatalogController->getCompany (line 28)
5	App\Controller\CatalogController->branch (line 318)
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)

0.30 ms

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_6b20ff8fe8509a86be58ed4605dfe0f5->doDisplay (line 54)
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->branch (line 317)
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)

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping