Symfony Profiler

Query Metrics

6 Database Queries

2 Different statements

7.56 ms Query time

0 Invalid entities

29 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.85 ms
(64.17%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.unite AS unite_5, t0.icone AS icone_6, t0.position AS position_7, t0.actif AS actif_8, t0.categorie AS categorie_9, t0.type AS type_10, t0.details AS details_11, t0.populaire AS populaire_12 FROM tarif t0 WHERE t0.categorie = ? AND t0.type = ? AND t0.actif = ? ORDER BY t0.position ASC

Parameters:

[
  "informatique"
  "forfait"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.prix AS prix_4,
  t0.unite AS unite_5,
  t0.icone AS icone_6,
  t0.position AS position_7,
  t0.actif AS actif_8,
  t0.categorie AS categorie_9,
  t0.type AS type_10,
  t0.details AS details_11,
  t0.populaire AS populaire_12
FROM
  tarif t0
WHERE
  t0.categorie = ?
  AND t0.type = ?
  AND t0.actif = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.unite AS unite_5, t0.icone AS icone_6, t0.position AS position_7, t0.actif AS actif_8, t0.categorie AS categorie_9, t0.type AS type_10, t0.details AS details_11, t0.populaire AS populaire_12 FROM tarif t0 WHERE t0.categorie = 'informatique' AND t0.type = 'forfait' AND t0.actif = 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\TarifsController->index (line 17)
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)

2.71 ms
(35.83%)

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\Controller\TarifsController->index (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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\Tarif	28
App\Entity\Settings	1

Entities Mapping

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width