Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

10.56 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.39 ms
(88.94%)

SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.logo_path AS logo_path_3, t0.email_from AS email_from_4, t0.email_copy_send AS email_copy_send_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.accent_color AS accent_color_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.text_secondary_color AS text_secondary_color_11, t0.border_color AS border_color_12, t0.color_hover AS color_hover_13, t0.color_active_background AS color_active_background_14, t0.color_menu_icon_inactive AS color_menu_icon_inactive_15, t0.color_menu_active_border AS color_menu_active_border_16, t0.company_name AS company_name_17, t0.company_address AS company_address_18, t0.company_zip AS company_zip_19, t0.company_city AS company_city_20, t0.company_siret AS company_siret_21, t0.company_contact_email AS company_contact_email_22, t0.company_contact_phone AS company_contact_phone_23, t0.company_ape AS company_ape_24, t0.company_capital AS company_capital_25, t0.company_vat_number AS company_vat_number_26, t0.company_representative_last_name AS company_representative_last_name_27, t0.company_representative_first_name AS company_representative_first_name_28, t0.company_representative_title AS company_representative_title_29, t0.front_base_url AS front_base_url_30, t0.front_title AS front_title_31, t0.front_meta_description AS front_meta_description_32, t0.front_breadcrumb_root_label AS front_breadcrumb_root_label_33, t0.front_breadcrumb_home_label AS front_breadcrumb_home_label_34, t0.front_h1 AS front_h1_35, t0.front_description AS front_description_36, t0.front_custom_javascript_header AS front_custom_javascript_header_37, t0.front_custom_javascript_body AS front_custom_javascript_body_38, t0.footer_left_html AS footer_left_html_39, t0.brightdata_api_key AS brightdata_api_key_40, t0.brightdata_dataset_id AS brightdata_dataset_id_41, t0.front_homepage_page_id AS front_homepage_page_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.app_name AS app_name_2,
  t0.logo_path AS logo_path_3,
  t0.email_from AS email_from_4,
  t0.email_copy_send AS email_copy_send_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.accent_color AS accent_color_8,
  t0.background_color AS background_color_9,
  t0.text_color AS text_color_10,
  t0.text_secondary_color AS text_secondary_color_11,
  t0.border_color AS border_color_12,
  t0.color_hover AS color_hover_13,
  t0.color_active_background AS color_active_background_14,
  t0.color_menu_icon_inactive AS color_menu_icon_inactive_15,
  t0.color_menu_active_border AS color_menu_active_border_16,
  t0.company_name AS company_name_17,
  t0.company_address AS company_address_18,
  t0.company_zip AS company_zip_19,
  t0.company_city AS company_city_20,
  t0.company_siret AS company_siret_21,
  t0.company_contact_email AS company_contact_email_22,
  t0.company_contact_phone AS company_contact_phone_23,
  t0.company_ape AS company_ape_24,
  t0.company_capital AS company_capital_25,
  t0.company_vat_number AS company_vat_number_26,
  t0.company_representative_last_name AS company_representative_last_name_27,
  t0.company_representative_first_name AS company_representative_first_name_28,
  t0.company_representative_title AS company_representative_title_29,
  t0.front_base_url AS front_base_url_30,
  t0.front_title AS front_title_31,
  t0.front_meta_description AS front_meta_description_32,
  t0.front_breadcrumb_root_label AS front_breadcrumb_root_label_33,
  t0.front_breadcrumb_home_label AS front_breadcrumb_home_label_34,
  t0.front_h1 AS front_h1_35,
  t0.front_description AS front_description_36,
  t0.front_custom_javascript_header AS front_custom_javascript_header_37,
  t0.front_custom_javascript_body AS front_custom_javascript_body_38,
  t0.footer_left_html AS footer_left_html_39,
  t0.brightdata_api_key AS brightdata_api_key_40,
  t0.brightdata_dataset_id AS brightdata_dataset_id_41,
  t0.front_homepage_page_id AS front_homepage_page_id_42
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.app_name AS app_name_2, t0.logo_path AS logo_path_3, t0.email_from AS email_from_4, t0.email_copy_send AS email_copy_send_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.accent_color AS accent_color_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.text_secondary_color AS text_secondary_color_11, t0.border_color AS border_color_12, t0.color_hover AS color_hover_13, t0.color_active_background AS color_active_background_14, t0.color_menu_icon_inactive AS color_menu_icon_inactive_15, t0.color_menu_active_border AS color_menu_active_border_16, t0.company_name AS company_name_17, t0.company_address AS company_address_18, t0.company_zip AS company_zip_19, t0.company_city AS company_city_20, t0.company_siret AS company_siret_21, t0.company_contact_email AS company_contact_email_22, t0.company_contact_phone AS company_contact_phone_23, t0.company_ape AS company_ape_24, t0.company_capital AS company_capital_25, t0.company_vat_number AS company_vat_number_26, t0.company_representative_last_name AS company_representative_last_name_27, t0.company_representative_first_name AS company_representative_first_name_28, t0.company_representative_title AS company_representative_title_29, t0.front_base_url AS front_base_url_30, t0.front_title AS front_title_31, t0.front_meta_description AS front_meta_description_32, t0.front_breadcrumb_root_label AS front_breadcrumb_root_label_33, t0.front_breadcrumb_home_label AS front_breadcrumb_home_label_34, t0.front_h1 AS front_h1_35, t0.front_description AS front_description_36, t0.front_custom_javascript_header AS front_custom_javascript_header_37, t0.front_custom_javascript_body AS front_custom_javascript_body_38, t0.footer_left_html AS footer_left_html_39, t0.brightdata_api_key AS brightdata_api_key_40, t0.brightdata_dataset_id AS brightdata_dataset_id_41, t0.front_homepage_page_id AS front_homepage_page_id_42 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 17)
5	App\Controller\FrontController->home (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.17 ms
(11.06%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.label AS label_3, t0.url AS url_4, t0.parent_id AS parent_id_5 FROM menu t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.label AS label_3,
  t0.url AS url_4,
  t0.parent_id AS parent_id_5
FROM
  menu t0
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.label AS label_3, t0.url AS url_4, t0.parent_id AS parent_id_5 FROM menu t0 WHERE t0.parent_id IS NULL ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 18)
5	App\Controller\FrontController->home (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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
App\Entity\Setting	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\Menu	No errors.

Symfony Profiler

GET https://www.410-gone.fr/llmtracker/

Configuration Settings

Theme

Page Width