Symfony Profiler

Query Metrics

19 Database Queries

13 Different statements

7.25 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.pole654_text AS pole654_text_2, t0.pole32_text AS pole32_text_3, t0.pole1_ttext AS pole1_ttext_4, t0.pole_lycee_pro_text AS pole_lycee_pro_text_5, t0.pole_es_text AS pole_es_text_6, t0.pole_cf_text AS pole_cf_text_7 FROM contact_infos t0 WHERE t0.id = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.color AS color_2, p0_.url_pole_id AS url_pole_id_3 FROM pole p0_
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM options t0 WHERE t0.name IN (?, ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'isaacetoil_dev' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.name IS NULL LIMIT 1
SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_

#▲	Time	Info
1	0.59 ms	SELECT t0.id AS id_1, t0.pole654_text AS pole654_text_2, t0.pole32_text AS pole32_text_3, t0.pole1_ttext AS pole1_ttext_4, t0.pole_lycee_pro_text AS pole_lycee_pro_text_5, t0.pole_es_text AS pole_es_text_6, t0.pole_cf_text AS pole_cf_text_7 FROM contact_infos t0 WHERE t0.id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pole654_text AS pole654_text_2, t0.pole32_text AS pole32_text_3, t0.pole1_ttext AS pole1_ttext_4, t0.pole_lycee_pro_text AS pole_lycee_pro_text_5, t0.pole_es_text AS pole_es_text_6, t0.pole_cf_text AS pole_cf_text_7 FROM contact_infos t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.pole654_text AS pole654_text_2, t0.pole32_text AS pole32_text_3, t0.pole1_ttext AS pole1_ttext_4, t0.pole_lycee_pro_text AS pole_lycee_pro_text_5, t0.pole_es_text AS pole_es_text_6, t0.pole_cf_text AS pole_cf_text_7 FROM contact_infos t0 WHERE t0.id = 1 LIMIT 1;
2	0.33 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.color AS color_2, p0_.url_pole_id AS url_pole_id_3 FROM pole p0_ Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.color AS color_2, p0_.url_pole_id AS url_pole_id_3 FROM pole p0_ SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.color AS color_2, p0_.url_pole_id AS url_pole_id_3 FROM pole p0_;
3	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM options t0 WHERE t0.name IN (?, ?) Parameters: [`"information" "informationIsCritique"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM options t0 WHERE t0.name IN (?, ?) SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM options t0 WHERE t0.name IN ('information', 'informationIsCritique');
4	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0;
5	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
6	0.73 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"isaacetoil_dev"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'isaacetoil_dev' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
7	0.13 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
8	0.56 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"isaacetoil_dev"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'isaacetoil_dev' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
9	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
10	0.48 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"isaacetoil_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'isaacetoil_dev' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
11	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
12	0.83 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'isaacetoil_dev' / ORDER BY k.ORDINAL_POSITION Parameters: [`"isaacetoil_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'isaacetoil_dev' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'isaacetoil_dev' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'isaacetoil_dev' / ORDER BY k.ORDINAL_POSITION;
13	1.20 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"isaacetoil_dev" "isaacetoil_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'isaacetoil_dev' AND t.TABLE_SCHEMA = 'isaacetoil_dev' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
14	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
15	0.24 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"isaacetoil_dev" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'isaacetoil_dev' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
16	0.16 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
17	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	0.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.name IS NULL LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.name IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.url_pole_id AS url_pole_id_4 FROM pole t0 WHERE t0.name IS NULL LIMIT 1;
19	0.40 ms	SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_ Parameters: [] View formatted query View runnable query Explain query SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_ SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Pole	No errors.
App\Entity\ContactInfos	No errors.
App\Entity\EntityBase	No errors.
App\Entity\Page	No errors.
App\Entity\Formation	No errors.
App\Entity\Actualite	No errors.
App\Entity\Agenda	No errors.
App\Entity\User	No errors.
App\Entity\Options	No errors.
App\Entity\BlocTextImage	No errors.
App\Entity\BlocAccordeon	No errors.
App\Entity\BlocDiaporama	No errors.
App\Entity\BlocColonne	No errors.
App\Entity\Position	No errors.
App\Entity\Media	No errors.
App\Entity\Seo\SeoParent	No errors.
App\Entity\Domaines	No errors.
App\Entity\Diplomes	No errors.
App\Entity\Contrats	No errors.
App\Entity\PositionBlocsFormation	No errors.
App\Entity\Duree	No errors.
App\Entity\DiaporamaFormation	No errors.
App\Entity\CategorieActu	No errors.
App\Entity\PositionBlocsActualite	No errors.
App\Entity\Theme	No errors.
App\Entity\BlocAccordeonItem	No errors.
App\Entity\BlocDiaporamaItem	No errors.
App\Entity\BlocColonneItem	No errors.
App\Entity\BlocVideo	No errors.
App\Entity\OffreEmploi	No errors.
App\Entity\Seo\Seo	No errors.
App\Entity\DiaporamaFormationItem	No errors.
App\Entity\Region	No errors.
App\Entity\TypeEmploi	No errors.

Symfony Profiler

GET https://isaacetoil.hop-linweb-20.sos-data.fr/contact

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping