Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.89 ms Query time

0 Invalid entities

24 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.10 ms	SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1 SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = 1 LIMIT 1;
2	0.97 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = ? SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = 4;
3	0.83 ms	SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1 SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = 1 LIMIT 1;

#▲

Time

Info

1.10 ms

SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.notification AS notification_2,
  t0.actif AS actif_3,
  t0.imagefond AS imagefond_4,
  t0.site AS site_5,
  t0.description AS description_6,
  t0.optionblog AS optionblog_7,
  t0.optionmessagerie AS optionmessagerie_8,
  t0.photo AS photo_9,
  t0.adresse AS adresse_10,
  t0.telephone AS telephone_11,
  t0.info1 AS info1_12,
  t0.info2 AS info2_13,
  t0.nbdiapos AS nbdiapos_14,
  t0.optionconseil AS optionconseil_15,
  t0.optionproduits AS optionproduits_16,
  t0.email AS email_17,
  t0.optionfinance AS optionfinance_18,
  t0.adresseinternet AS adresseinternet_19,
  t0.licence AS licence_20,
  t0.administrateur_id AS administrateur_id_21,
  t0.proprietaire_id AS proprietaire_id_22,
  t0.theme_id AS theme_id_23
FROM
  parametres t0
WHERE
  t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = 1 LIMIT 1;

0.97 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.taillepolice AS taillepolice_3,
  t0.couleurtexte AS couleurtexte_4,
  t0.couleurfond AS couleurfond_5,
  t0.couleurlien AS couleurlien_6,
  t0.couleurhovertexte AS couleurhovertexte_7,
  t0.couleurhoverfond AS couleurhoverfond_8,
  t0.couleurbordure AS couleurbordure_9,
  t0.stylebordure AS stylebordure_10,
  t0.taillebordure AS taillebordure_11,
  t0.decoration AS decoration_12,
  t0.epaisseurpolice AS epaisseurpolice_13,
  t0.stylepolice AS stylepolice_14,
  t0.theme_id AS theme_id_15
FROM
  style t0
WHERE
  t0.theme_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.taillepolice AS taillepolice_3, t0.couleurtexte AS couleurtexte_4, t0.couleurfond AS couleurfond_5, t0.couleurlien AS couleurlien_6, t0.couleurhovertexte AS couleurhovertexte_7, t0.couleurhoverfond AS couleurhoverfond_8, t0.couleurbordure AS couleurbordure_9, t0.stylebordure AS stylebordure_10, t0.taillebordure AS taillebordure_11, t0.decoration AS decoration_12, t0.epaisseurpolice AS epaisseurpolice_13, t0.stylepolice AS stylepolice_14, t0.theme_id AS theme_id_15 FROM style t0 WHERE t0.theme_id = 4;

0.83 ms

SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.notification AS notification_2,
  t0.actif AS actif_3,
  t0.imagefond AS imagefond_4,
  t0.site AS site_5,
  t0.description AS description_6,
  t0.optionblog AS optionblog_7,
  t0.optionmessagerie AS optionmessagerie_8,
  t0.photo AS photo_9,
  t0.adresse AS adresse_10,
  t0.telephone AS telephone_11,
  t0.info1 AS info1_12,
  t0.info2 AS info2_13,
  t0.nbdiapos AS nbdiapos_14,
  t0.optionconseil AS optionconseil_15,
  t0.optionproduits AS optionproduits_16,
  t0.email AS email_17,
  t0.optionfinance AS optionfinance_18,
  t0.adresseinternet AS adresseinternet_19,
  t0.licence AS licence_20,
  t0.administrateur_id AS administrateur_id_21,
  t0.proprietaire_id AS proprietaire_id_22,
  t0.theme_id AS theme_id_23
FROM
  parametres t0
WHERE
  t0.actif = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.notification AS notification_2, t0.actif AS actif_3, t0.imagefond AS imagefond_4, t0.site AS site_5, t0.description AS description_6, t0.optionblog AS optionblog_7, t0.optionmessagerie AS optionmessagerie_8, t0.photo AS photo_9, t0.adresse AS adresse_10, t0.telephone AS telephone_11, t0.info1 AS info1_12, t0.info2 AS info2_13, t0.nbdiapos AS nbdiapos_14, t0.optionconseil AS optionconseil_15, t0.optionproduits AS optionproduits_16, t0.email AS email_17, t0.optionfinance AS optionfinance_18, t0.adresseinternet AS adresseinternet_19, t0.licence AS licence_20, t0.administrateur_id AS administrateur_id_21, t0.proprietaire_id AS proprietaire_id_22, t0.theme_id AS theme_id_23 FROM parametres t0 WHERE t0.actif = 1 LIMIT 1;

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\Style	20
App\Entity\User	2
App\Entity\Parametres	1
App\Entity\Theme	1

Entities Mapping

Class	Mapping errors
App\Entity\Style	No errors.
App\Entity\Parametres	No errors.
App\Entity\User	No errors.
App\Entity\Theme	No errors.
App\Entity\Fil	No errors.
App\Entity\Fildonnees	No errors.
App\Entity\Message	No errors.
App\Entity\Messagedonnees	No errors.
App\Entity\Vuproduits	No errors.
App\Entity\Questionchallenge	No errors.
App\Entity\Questionvu	No errors.
App\Entity\Quizzreponse	No errors.
App\Entity\Questionmembre	No errors.
App\Entity\Questionmembrevu	No errors.
App\Entity\Quizz	No errors.
App\Entity\Typesite	No errors.

Symfony Profiler

GET https://www.base.aproximite.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DApp%255CController%255CParametresController%253A%253Asession

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping