Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.90 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.55 ms

SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.site_url AS site_url_3, t0.copyright_text AS copyright_text_4, t0.meta_description AS meta_description_5, t0.email AS email_6, t0.email_sender AS email_sender_7, t0.email_sender_name AS email_sender_name_8, t0.telephone AS telephone_9, t0.whatsapp AS whatsapp_10, t0.address AS address_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.primary_color AS primary_color_14, t0.secondary_color AS secondary_color_15, t0.theme AS theme_16, t0.flash_library AS flash_library_17, t0.flash_position AS flash_position_18, t0.flash_duration AS flash_duration_19, t0.is_captcha_login_enabled AS is_captcha_login_enabled_20, t0.is_captcha_register_enabled AS is_captcha_register_enabled_21, t0.is_captcha_contact_enabled AS is_captcha_contact_enabled_22, t0.student_code_prefix AS student_code_prefix_23, t0.worker_code_prefix AS worker_code_prefix_24, t0.bank_details AS bank_details_25, t0.currency AS currency_26, t0.student_eligibility_fee AS student_eligibility_fee_27, t0.student_eligible_advance AS student_eligible_advance_28, t0.student_eligible_balance AS student_eligible_balance_29, t0.student_non_eligible_advance1 AS student_non_eligible_advance1_30, t0.student_non_eligible_advance2 AS student_non_eligible_advance2_31, t0.student_non_eligible_balance AS student_non_eligible_balance_32, t0.worker_eligibility_fee AS worker_eligibility_fee_33, t0.worker_eligible_advance AS worker_eligible_advance_34, t0.worker_eligible_balance AS worker_eligible_balance_35, t0.worker_non_eligible_advance1 AS worker_non_eligible_advance1_36, t0.worker_non_eligible_advance2 AS worker_non_eligible_advance2_37, t0.worker_non_eligible_balance AS worker_non_eligible_balance_38, t0.logo_dark_id AS logo_dark_id_39, t0.logo_light_id AS logo_light_id_40, t0.favicon_id AS favicon_id_41, t0.email_img_id AS email_img_id_42 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_title AS site_title_2,
  t0.site_url AS site_url_3,
  t0.copyright_text AS copyright_text_4,
  t0.meta_description AS meta_description_5,
  t0.email AS email_6,
  t0.email_sender AS email_sender_7,
  t0.email_sender_name AS email_sender_name_8,
  t0.telephone AS telephone_9,
  t0.whatsapp AS whatsapp_10,
  t0.address AS address_11,
  t0.facebook_url AS facebook_url_12,
  t0.instagram_url AS instagram_url_13,
  t0.primary_color AS primary_color_14,
  t0.secondary_color AS secondary_color_15,
  t0.theme AS theme_16,
  t0.flash_library AS flash_library_17,
  t0.flash_position AS flash_position_18,
  t0.flash_duration AS flash_duration_19,
  t0.is_captcha_login_enabled AS is_captcha_login_enabled_20,
  t0.is_captcha_register_enabled AS is_captcha_register_enabled_21,
  t0.is_captcha_contact_enabled AS is_captcha_contact_enabled_22,
  t0.student_code_prefix AS student_code_prefix_23,
  t0.worker_code_prefix AS worker_code_prefix_24,
  t0.bank_details AS bank_details_25,
  t0.currency AS currency_26,
  t0.student_eligibility_fee AS student_eligibility_fee_27,
  t0.student_eligible_advance AS student_eligible_advance_28,
  t0.student_eligible_balance AS student_eligible_balance_29,
  t0.student_non_eligible_advance1 AS student_non_eligible_advance1_30,
  t0.student_non_eligible_advance2 AS student_non_eligible_advance2_31,
  t0.student_non_eligible_balance AS student_non_eligible_balance_32,
  t0.worker_eligibility_fee AS worker_eligibility_fee_33,
  t0.worker_eligible_advance AS worker_eligible_advance_34,
  t0.worker_eligible_balance AS worker_eligible_balance_35,
  t0.worker_non_eligible_advance1 AS worker_non_eligible_advance1_36,
  t0.worker_non_eligible_advance2 AS worker_non_eligible_advance2_37,
  t0.worker_non_eligible_balance AS worker_non_eligible_balance_38,
  t0.logo_dark_id AS logo_dark_id_39,
  t0.logo_light_id AS logo_light_id_40,
  t0.favicon_id AS favicon_id_41,
  t0.email_img_id AS email_img_id_42
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.site_url AS site_url_3, t0.copyright_text AS copyright_text_4, t0.meta_description AS meta_description_5, t0.email AS email_6, t0.email_sender AS email_sender_7, t0.email_sender_name AS email_sender_name_8, t0.telephone AS telephone_9, t0.whatsapp AS whatsapp_10, t0.address AS address_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.primary_color AS primary_color_14, t0.secondary_color AS secondary_color_15, t0.theme AS theme_16, t0.flash_library AS flash_library_17, t0.flash_position AS flash_position_18, t0.flash_duration AS flash_duration_19, t0.is_captcha_login_enabled AS is_captcha_login_enabled_20, t0.is_captcha_register_enabled AS is_captcha_register_enabled_21, t0.is_captcha_contact_enabled AS is_captcha_contact_enabled_22, t0.student_code_prefix AS student_code_prefix_23, t0.worker_code_prefix AS worker_code_prefix_24, t0.bank_details AS bank_details_25, t0.currency AS currency_26, t0.student_eligibility_fee AS student_eligibility_fee_27, t0.student_eligible_advance AS student_eligible_advance_28, t0.student_eligible_balance AS student_eligible_balance_29, t0.student_non_eligible_advance1 AS student_non_eligible_advance1_30, t0.student_non_eligible_advance2 AS student_non_eligible_advance2_31, t0.student_non_eligible_balance AS student_non_eligible_balance_32, t0.worker_eligibility_fee AS worker_eligibility_fee_33, t0.worker_eligible_advance AS worker_eligible_advance_34, t0.worker_eligible_balance AS worker_eligible_balance_35, t0.worker_non_eligible_advance1 AS worker_non_eligible_advance1_36, t0.worker_non_eligible_advance2 AS worker_non_eligible_advance2_37, t0.worker_non_eligible_balance AS worker_non_eligible_balance_38, t0.logo_dark_id AS logo_dark_id_39, t0.logo_light_id AS logo_light_id_40, t0.favicon_id AS favicon_id_41, t0.email_img_id AS email_img_id_42 FROM setting 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\Service\SettingService->getSetting (line 17)
5	App\Service\SettingService->get (line 31)
6	App\Twig\SettingExtension->getSetting (line 36)
7	__TwigTemplate_d53eb3a9aac7495f2d10083f4f020bf6->doDisplay (line 57)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_0bb20bb8f9f83e9b0c2eb960ed539a1d->doDisplay (line 56)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8458d34870223f3b5ffd2f65262364d6->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\LandingController->home (line 27)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.36 ms

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2,
  l0_.is_active AS is_active_3,
  l0_.is_default AS is_default_4,
  l0_.created_at AS created_at_5,
  l0_.updated_at AS updated_at_6,
  l0_.deleted_at AS deleted_at_7
FROM
  language l0_
WHERE
  l0_.is_active = 1
ORDER BY
  l0_.is_default DESC,
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.is_active AS is_active_3, l0_.is_default AS is_default_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.deleted_at AS deleted_at_7 FROM language l0_ WHERE l0_.is_active = 1 ORDER BY l0_.is_default DESC, l0_.name 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\LanguageRepository->findActive (line 24)
7	App\Twig\SettingExtension->getLanguages (line 42)
8	__TwigTemplate_0bb20bb8f9f83e9b0c2eb960ed539a1d->block_body (line 248)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_d53eb3a9aac7495f2d10083f4f020bf6->doDisplay (line 158)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_0bb20bb8f9f83e9b0c2eb960ed539a1d->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8458d34870223f3b5ffd2f65262364d6->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
23	App\Controller\LandingController->home (line 27)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	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\Language	2
App\Entity\Setting	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\Media	No errors.
App\Entity\Language	No errors.

Symfony Profiler

GET https://govoyage.ekrea.cloud/fr

Configuration Settings

Theme

Page Width