Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.64 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(53.98%)

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone AS phone_3, t0.email AS email_4, t0.address AS address_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.google_url AS google_url_8, t0.tel_message AS tel_message_9, t0.tel_exemples AS tel_exemples_10, t0.tel_delai AS tel_delai_11, t0.tel_garantie AS tel_garantie_12, t0.tel_brands AS tel_brands_13, t0.hero_title AS hero_title_14, t0.hero_description AS hero_description_15, t0.hero_rating AS hero_rating_16, t0.hero_cta_text AS hero_cta_text_17, t0.services_title AS services_title_18, t0.why_title AS why_title_19, t0.brands_title AS brands_title_20, t0.brands_subtitle AS brands_subtitle_21, t0.brands_note AS brands_note_22, t0.print3d_title AS print3d_title_23, t0.hero_image_path AS hero_image_path_24, t0.print3d_image_path AS print3d_image_path_25, t0.print3d_description AS print3d_description_26, t0.print3d_features AS print3d_features_27, t0.print3d_cta_text AS print3d_cta_text_28, t0.print3d_note AS print3d_note_29, t0.microsoudure_intro AS microsoudure_intro_30, t0.microsoudure_note AS microsoudure_note_31, t0.microsoudure_mc75_path AS microsoudure_mc75_path_32, t0.microsoudure_t12_path AS microsoudure_t12_path_33, t0.microsoudure958ht_path AS microsoudure958ht_path_34 FROM settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.address AS address_5,
  t0.facebook_url AS facebook_url_6,
  t0.instagram_url AS instagram_url_7,
  t0.google_url AS google_url_8,
  t0.tel_message AS tel_message_9,
  t0.tel_exemples AS tel_exemples_10,
  t0.tel_delai AS tel_delai_11,
  t0.tel_garantie AS tel_garantie_12,
  t0.tel_brands AS tel_brands_13,
  t0.hero_title AS hero_title_14,
  t0.hero_description AS hero_description_15,
  t0.hero_rating AS hero_rating_16,
  t0.hero_cta_text AS hero_cta_text_17,
  t0.services_title AS services_title_18,
  t0.why_title AS why_title_19,
  t0.brands_title AS brands_title_20,
  t0.brands_subtitle AS brands_subtitle_21,
  t0.brands_note AS brands_note_22,
  t0.print3d_title AS print3d_title_23,
  t0.hero_image_path AS hero_image_path_24,
  t0.print3d_image_path AS print3d_image_path_25,
  t0.print3d_description AS print3d_description_26,
  t0.print3d_features AS print3d_features_27,
  t0.print3d_cta_text AS print3d_cta_text_28,
  t0.print3d_note AS print3d_note_29,
  t0.microsoudure_intro AS microsoudure_intro_30,
  t0.microsoudure_note AS microsoudure_note_31,
  t0.microsoudure_mc75_path AS microsoudure_mc75_path_32,
  t0.microsoudure_t12_path AS microsoudure_t12_path_33,
  t0.microsoudure958ht_path AS microsoudure958ht_path_34
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone AS phone_3, t0.email AS email_4, t0.address AS address_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.google_url AS google_url_8, t0.tel_message AS tel_message_9, t0.tel_exemples AS tel_exemples_10, t0.tel_delai AS tel_delai_11, t0.tel_garantie AS tel_garantie_12, t0.tel_brands AS tel_brands_13, t0.hero_title AS hero_title_14, t0.hero_description AS hero_description_15, t0.hero_rating AS hero_rating_16, t0.hero_cta_text AS hero_cta_text_17, t0.services_title AS services_title_18, t0.why_title AS why_title_19, t0.brands_title AS brands_title_20, t0.brands_subtitle AS brands_subtitle_21, t0.brands_note AS brands_note_22, t0.print3d_title AS print3d_title_23, t0.hero_image_path AS hero_image_path_24, t0.print3d_image_path AS print3d_image_path_25, t0.print3d_description AS print3d_description_26, t0.print3d_features AS print3d_features_27, t0.print3d_cta_text AS print3d_cta_text_28, t0.print3d_note AS print3d_note_29, t0.microsoudure_intro AS microsoudure_intro_30, t0.microsoudure_note AS microsoudure_note_31, t0.microsoudure_mc75_path AS microsoudure_mc75_path_32, t0.microsoudure_t12_path AS microsoudure_t12_path_33, t0.microsoudure958ht_path AS microsoudure958ht_path_34 FROM settings 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\Repository\SettingsRepository->getSettings (line 21)
5	App\Twig\AppExtension->getGlobals (line 16)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
16	App\Controller\ServicesController->index (line 20)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

1.21 ms
(46.02%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.badge AS badge_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.features AS features_8 FROM service t0 WHERE t0.is_active = ? ORDER BY t0.position 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.description AS description_3,
  t0.icon AS icon_4,
  t0.badge AS badge_5,
  t0.is_active AS is_active_6,
  t0.position AS position_7,
  t0.features AS features_8
FROM
  service t0
WHERE
  t0.is_active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.badge AS badge_5, t0.is_active AS is_active_6, t0.position AS position_7, t0.features AS features_8 FROM service t0 WHERE t0.is_active = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\ServicesController->index (line 15)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
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\Service	9
App\Entity\Settings	1

Entities Mapping

Class	Mapping errors
App\Entity\Service	No errors.
App\Entity\Settings	No errors.

Symfony Profiler

GET https://msi36.synology.me/services

Configuration Settings

Theme

Page Width