Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.66 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.33 ms

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) ORDER BY e0_.sort ASC

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.post_code AS post_code_1,
  e0_.facebook_link AS facebook_link_2,
  e0_.instagram_link AS instagram_link_3,
  e0_.pinterest_link AS pinterest_link_4,
  e0_.linkedin_link AS linkedin_link_5,
  e0_.tiktok_link AS tiktok_link_6,
  e0_.youtube_link AS youtube_link_7,
  e0_.vimeo_link AS vimeo_link_8,
  e0_.email_link AS email_link_9,
  e0_.phone_link AS phone_link_10,
  e0_.email_order AS email_order_11,
  e0_.mollie_api_key AS mollie_api_key_12,
  e0_.image AS image_13,
  e0_.is_active AS is_active_14,
  e0_.sort AS sort_15,
  e1_.id AS id_16,
  e1_.title AS title_17,
  e1_.slug AS slug_18,
  e1_.short_title AS short_title_19,
  e1_.sub_title AS sub_title_20,
  e1_.address AS address_21,
  e1_.city AS city_22,
  e1_.country AS country_23,
  e1_.schedule AS schedule_24,
  e1_.additional_information AS additional_information_25,
  e1_.seo_title AS seo_title_26,
  e1_.seo_description AS seo_description_27,
  e1_.seo_image AS seo_image_28,
  e1_.locale AS locale_29,
  e1_.translatable_id AS translatable_id_30
FROM
  establishment e0_
  LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id
  AND (e1_.locale = ?)
ORDER BY
  e0_.sort ASC

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = 'fr') ORDER BY e0_.sort ASC;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\FormFactory->createNamedBuilder (line 75)
19	Symfony\Component\Form\FormBuilder->create (line 80)
20	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
21	Symfony\Component\Form\FormBuilder->getForm (line 160)
22	Symfony\Component\Form\FormFactory->create (line 32)
23	App\Controller\Front\AppController->newsletterForm (line 108)
24	App\Controller\Front\AppController->__construct (line 47)
25	ContainerNcGtccx\getBookingController2Service->do (line 25)
26	ContainerNcGtccx\App_KernelDevDebugContainer::load (line 695)
27	Symfony\Component\DependencyInjection\Container->make (line 221)
28	Symfony\Component\DependencyInjection\Container::get (line 203)
29	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
30	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
31	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
32	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
33	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 191)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 32)
39	require_once (line 5)

0.32 ms

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) WHERE e0_.is_active = ? ORDER BY e0_.sort ASC

Parameters:

[
  "fr"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.post_code AS post_code_1,
  e0_.facebook_link AS facebook_link_2,
  e0_.instagram_link AS instagram_link_3,
  e0_.pinterest_link AS pinterest_link_4,
  e0_.linkedin_link AS linkedin_link_5,
  e0_.tiktok_link AS tiktok_link_6,
  e0_.youtube_link AS youtube_link_7,
  e0_.vimeo_link AS vimeo_link_8,
  e0_.email_link AS email_link_9,
  e0_.phone_link AS phone_link_10,
  e0_.email_order AS email_order_11,
  e0_.mollie_api_key AS mollie_api_key_12,
  e0_.image AS image_13,
  e0_.is_active AS is_active_14,
  e0_.sort AS sort_15,
  e1_.id AS id_16,
  e1_.title AS title_17,
  e1_.slug AS slug_18,
  e1_.short_title AS short_title_19,
  e1_.sub_title AS sub_title_20,
  e1_.address AS address_21,
  e1_.city AS city_22,
  e1_.country AS country_23,
  e1_.schedule AS schedule_24,
  e1_.additional_information AS additional_information_25,
  e1_.seo_title AS seo_title_26,
  e1_.seo_description AS seo_description_27,
  e1_.seo_image AS seo_image_28,
  e1_.locale AS locale_29,
  e1_.translatable_id AS translatable_id_30
FROM
  establishment e0_
  LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id
  AND (e1_.locale = ?)
WHERE
  e0_.is_active = ?
ORDER BY
  e0_.sort ASC

SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = 'fr') WHERE e0_.is_active = 1 ORDER BY e0_.sort ASC;

#	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\Repository\Establishment\EstablishmentRepository->findAllEstablishments (line 34)
7	App\Controller\Front\BookingController->index (line 53)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\Establishment\Establishment	2
App\Entity\Establishment\EstablishmentTranslation	2

Entities Mapping

Class	Mapping errors
App\Entity\Establishment\Establishment	No errors.
App\Entity\Establishment\EstablishmentTranslation	No errors.
App\Entity\Establishment\Room	No errors.
App\Entity\Establishment\Option	No errors.
App\Entity\Content\Content	No errors.

Symfony Profiler

GET https://www.boa.hb-preprod.com/reserver

Configuration Settings

Theme

Page Width