Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

3.38 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.50 ms
(44.33%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t8.id AS id_9, t8.name AS name_10, t8.slug AS slug_11, t8.enabled AS enabled_12, t8.created_by AS created_by_13, t8.updated_by AS updated_by_14, t8.created_at AS created_at_15, t8.updated_at AS updated_at_16, t8.main_image_id AS main_image_id_17 FROM facility_type_image t0 LEFT JOIN facility_type t8 ON t8.main_image_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t8.id AS id_9,
  t8.name AS name_10,
  t8.slug AS slug_11,
  t8.enabled AS enabled_12,
  t8.created_by AS created_by_13,
  t8.updated_by AS updated_by_14,
  t8.created_at AS created_at_15,
  t8.updated_at AS updated_at_16,
  t8.main_image_id AS main_image_id_17
FROM
  facility_type_image t0
  LEFT JOIN facility_type t8 ON t8.main_image_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t8.id AS id_9, t8.name AS name_10, t8.slug AS slug_11, t8.enabled AS enabled_12, t8.created_by AS created_by_13, t8.updated_by AS updated_by_14, t8.created_at AS created_at_15, t8.updated_at AS updated_at_16, t8.main_image_id AS main_image_id_17 FROM facility_type_image t0 LEFT JOIN facility_type t8 ON t8.main_image_id = t0.id WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\FacilityTypeImage::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\FacilityTypeImage->__isset (line 258)
7	App\Entity\Image->__toString (line 56)
8	Twig\Extension\CoreExtension->testEmpty (line 1431)
9	__TwigTemplate_2ab1ccad70d533a8b07e74d5a794da08::block_body (line 105)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cd230494ddb12973d61cb39c6d702417->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_2ab1ccad70d533a8b07e74d5a794da08->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\Front\HomeController->index (line 39)
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 35)
27	require_once (line 32)
28	require_once (line 5)

0.91 ms
(26.86%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.main_image_id AS main_image_id_9 FROM facility_type t0 WHERE t0.enabled = ? ORDER BY t0.name ASC

Parameters:

[
  1
]

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,
  t0.enabled AS enabled_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.main_image_id AS main_image_id_9
FROM
  facility_type t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.main_image_id AS main_image_id_9 FROM facility_type t0 WHERE t0.enabled = 1 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Front\HomeController->index (line 24)
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 35)
9	require_once (line 32)
10	require_once (line 5)

0.57 ms
(16.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.multiple_registrations AS multiple_registrations_5, t0.enabled AS enabled_6, t0.ask_health_info AS ask_health_info_7, t0.ask_can_swim AS ask_can_swim_8, t0.ask_media_consent AS ask_media_consent_9, t0.registration_open AS registration_open_10, t0.age_start AS age_start_11, t0.age_end AS age_end_12, t0.age_limit AS age_limit_13, t0.registration_date_limit AS registration_date_limit_14, t0.visible AS visible_15, t0.slug AS slug_16, t0.description AS description_17, t0.capacity AS capacity_18, t0.ask_contact_phone AS ask_contact_phone_19, t0.ask_leaves_alone AS ask_leaves_alone_20, t0.ask_address AS ask_address_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.main_image_id AS main_image_id_26, t0.price_id AS price_id_27 FROM event t0 WHERE t0.enabled = ? AND t0.visible = ? ORDER BY t0.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start AS start_3,
  t0.end AS end_4,
  t0.multiple_registrations AS multiple_registrations_5,
  t0.enabled AS enabled_6,
  t0.ask_health_info AS ask_health_info_7,
  t0.ask_can_swim AS ask_can_swim_8,
  t0.ask_media_consent AS ask_media_consent_9,
  t0.registration_open AS registration_open_10,
  t0.age_start AS age_start_11,
  t0.age_end AS age_end_12,
  t0.age_limit AS age_limit_13,
  t0.registration_date_limit AS registration_date_limit_14,
  t0.visible AS visible_15,
  t0.slug AS slug_16,
  t0.description AS description_17,
  t0.capacity AS capacity_18,
  t0.ask_contact_phone AS ask_contact_phone_19,
  t0.ask_leaves_alone AS ask_leaves_alone_20,
  t0.ask_address AS ask_address_21,
  t0.created_by AS created_by_22,
  t0.updated_by AS updated_by_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.main_image_id AS main_image_id_26,
  t0.price_id AS price_id_27
FROM
  event t0
WHERE
  t0.enabled = ?
  AND t0.visible = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.multiple_registrations AS multiple_registrations_5, t0.enabled AS enabled_6, t0.ask_health_info AS ask_health_info_7, t0.ask_can_swim AS ask_can_swim_8, t0.ask_media_consent AS ask_media_consent_9, t0.registration_open AS registration_open_10, t0.age_start AS age_start_11, t0.age_end AS age_end_12, t0.age_limit AS age_limit_13, t0.registration_date_limit AS registration_date_limit_14, t0.visible AS visible_15, t0.slug AS slug_16, t0.description AS description_17, t0.capacity AS capacity_18, t0.ask_contact_phone AS ask_contact_phone_19, t0.ask_leaves_alone AS ask_leaves_alone_20, t0.ask_address AS ask_address_21, t0.created_by AS created_by_22, t0.updated_by AS updated_by_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.main_image_id AS main_image_id_26, t0.price_id AS price_id_27 FROM event t0 WHERE t0.enabled = 1 AND t0.visible = 1 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\Front\HomeController->index (line 31)
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 35)
9	require_once (line 32)
10	require_once (line 5)

0.41 ms
(12.11%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_id AS event_id_8 FROM event_image t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.image_size AS image_size_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.event_id AS event_id_8
FROM
  event_image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_id AS event_id_8 FROM event_image t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\EventImage::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\EventImage->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\EventImage->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromFirstField (line 96)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 146)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 68)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_2ab1ccad70d533a8b07e74d5a794da08->block_body (line 183)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_cd230494ddb12973d61cb39c6d702417->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_2ab1ccad70d533a8b07e74d5a794da08->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Front\HomeController->index (line 39)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	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\FacilityType	4
App\Entity\FacilityTypeImage	4
App\Entity\Event	1
App\Entity\EventImage	1
App\Entity\EventPrice	1

Entities Mapping

Class	Mapping errors
App\Entity\FacilityType	No errors.
App\Entity\Image	No errors.
App\Entity\FacilityTypeImage	No errors.
App\Entity\Zone	No errors.
App\Entity\Event	No errors.
App\Entity\EventImage	No errors.
App\Entity\DualPrice	No errors.
App\Entity\EventPrice	No errors.
App\Entity\EventDiscount	No errors.
App\Entity\EventBooking	No errors.
App\Entity\EventRegistration	No errors.

Symfony Profiler

GET https://deportes-eltiemblo-test.pixelarus.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping