GET https://isaacetoil.hop-linweb-20.sos-data.fr/page/presentation-pole-enseignement-superieur

Query Metrics

42 Database Queries
20 Different statements
12.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "presentation-pole-enseignement-superieur"
]
2 0.53 ms
SELECT
                b.titre_bloc_diaporama,
                ba.titre_bloc_accordeon,
                c.titre_bloc_colonne,
                cp.bloc_accordeon_id,
                cp.bloc_diaporama_id,
                cp.bloc_video_id,
                bvideo.titre_bloc_video,
                cp.colonne_id_id,
                cp.text_image_id_id,
                ti.titre_bloc_text_image
            FROM page p
            LEFT JOIN position cp ON p.id = cp.page_id_id
            LEFT JOIN bloc_colonne c ON cp.colonne_id_id = c.id
            LEFT JOIN bloc_text_image ti ON ti.id =  cp.text_image_id_id
            LEFT JOIN bloc_diaporama b ON b.id =  cp.bloc_diaporama_id
            LEFT JOIN bloc_accordeon ba ON ba.id =  cp.bloc_accordeon_id
            LEFT JOIN bloc_video bvideo ON bvideo.id =  cp.bloc_video_id
            WHERE cp.page_id_id = :page ORDER BY cp.position
Parameters:
[
  "page" => 4
]
3 0.24 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 69
]
4 0.26 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  69
]
5 0.24 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 70
]
6 0.18 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  70
]
7 0.18 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 71
]
8 0.24 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  71
]
9 0.28 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 73
]
10 0.22 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  73
]
11 0.18 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 125
]
12 0.16 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  125
]
13 0.18 ms
SELECT

            * FROM bloc_text_image c
            INNER JOIN media ON c.media_id = media.id
            WHERE c.id = :id ORDER BY c.id
Parameters:
[
  "id" => 160
]
14 0.16 ms
SELECT t0.id AS id_1, t0.titre_bloc_text_image AS titre_bloc_text_image_2, t0.contenu_bloc_text_image AS contenu_bloc_text_image_3, t0.label_bouton_bloc_text_image AS label_bouton_bloc_text_image_4, t0.lien_bouton_bloc_text_image AS lien_bouton_bloc_text_image_5, t0.position_bloc_text_image AS position_bloc_text_image_6, t0.background_bloc_text_image AS background_bloc_text_image_7, t0.picture_bloc_text_image AS picture_bloc_text_image_8, t0.media_id AS media_id_9 FROM bloc_text_image t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  160
]
15 0.32 ms
SELECT *
            FROM page as p
                INNER JOIN seo_parent as sp ON p.seo_parent_id = sp.id
                INNER JOIN seo as s ON s.id = sp.seo_id
            WHERE p.id = :id
Parameters:
[
  "id" => 4
]
16 0.31 ms
SELECT *
                FROM options
                WHERE name IN ("metaTitre", "metaDescription", "metaKeywords")
Parameters:
[]
17 0.19 ms
SELECT DATABASE()
Parameters:
[]
18 0.63 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "isaacetoil_dev"
]
19 0.12 ms
SELECT DATABASE()
Parameters:
[]
20 0.52 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "isaacetoil_dev"
]
21 0.14 ms
SELECT DATABASE()
Parameters:
[]
22 0.58 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"
]
23 0.11 ms
SELECT DATABASE()
Parameters:
[]
24 0.94 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"
]
25 1.29 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"
]
26 0.22 ms
SELECT DATABASE()
Parameters:
[]
27 0.33 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"
]
28 0.33 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
29 0.17 ms
SELECT DATABASE()
Parameters:
[]
30 0.24 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.id = ?
Parameters:
[
  6
]
31 0.25 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"
]
32 0.16 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:
[]
33 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  40
]
34 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:
[]
35 0.20 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.id = ?
Parameters:
[
  "presentation-pole-enseignement-superieur"
]
36 0.18 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.titre AS titre_4, t0.introduction AS introduction_5, t0.slug AS slug_6, t0.is_special AS is_special_7, t0.visible AS visible_8, t0.pole_id_id AS pole_id_id_9, t0.id_page_parent_id AS id_page_parent_id_10, t0.banniere_id AS banniere_id_11, t0.seo_parent_id AS seo_parent_id_12 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "presentation-pole-enseignement-superieur"
]
37 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  94
]
38 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  90
]
39 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  93
]
40 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  97
]
41 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.alt AS alt_3, t0.longdesc AS longdesc_4, t0.filepath AS filepath_5, t0.created_at AS created_at_6, t0.type AS type_7 FROM media t0 WHERE t0.id = ?
Parameters:
[
  96
]
42 0.72 ms
SELECT o0_.name AS name_0, o0_.value AS value_1 FROM options o0_
Parameters:
[]

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\EntityBase No errors.
App\Entity\Page No errors.
App\Entity\Pole No errors.
App\Entity\Media No errors.
App\Entity\Seo\SeoParent 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\PositionBlocsFormation No errors.
App\Entity\PositionBlocsActualite No errors.
App\Entity\Formation No errors.
App\Entity\Actualite No errors.
App\Entity\Agenda No errors.
App\Entity\User No errors.
App\Entity\OffreEmploi No errors.
App\Entity\Seo\Seo No errors.
App\Entity\BlocAccordeonItem No errors.
App\Entity\BlocDiaporamaItem No errors.
App\Entity\BlocColonneItem No errors.
App\Entity\BlocVideo No errors.
App\Entity\Options No errors.
App\Entity\Domaines No errors.
App\Entity\Diplomes No errors.
App\Entity\Contrats No errors.
App\Entity\Duree No errors.
App\Entity\DiaporamaFormation No errors.
App\Entity\CategorieActu No errors.
App\Entity\Theme No errors.
App\Entity\Region No errors.
App\Entity\TypeEmploi No errors.
App\Entity\DiaporamaFormationItem No errors.