GET https://chanoine.cms.agence-twco.com/api/pages?slug=%2F

Query Metrics

24 Database Queries
9 Different statements
75.59 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
34.13 ms
(45.15%)
4
SELECT c.TABLE_NAME,       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' ORDER BY ORDINAL_POSITION
Parameters:
[
  "cmsagencetwco_chanoine"
  "cmsagencetwco_chanoine"
]
21.08 ms
(27.89%)
4
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_TYPE = 'BASE TABLE'
Parameters:
[
  "cmsagencetwco_chanoine"
]
12.86 ms
(17.01%)
4
SELECT DISTINCT k.TABLE_NAME,            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.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'cmsagencetwco_chanoine' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "cmsagencetwco_chanoine"
]
4.96 ms
(6.56%)
4
SELECT TABLE_NAME,        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 = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "cmsagencetwco_chanoine"
]
1.08 ms
(1.43%)
4
SELECT DATABASE()
Parameters:
[]
0.40 ms
(0.54%)
1
SELECT l0_.code AS code_0 FROM locale l0_
Parameters:
[]
0.39 ms
(0.52%)
1
SELECT p0_.current_version AS current_version_0, p0_.publish AS publish_1, p0_.publish_date AS publish_date_2, p0_.id AS id_3, p0_.initial_locale AS initial_locale_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.type_id AS type_id_7, p0_.user_id AS user_id_8 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.slug = ?)
Parameters:
[
  "/"
]
0.38 ms
(0.51%)
1
SELECT t0.category AS category_1, t0.name AS name_2, t0._key AS _key_3, t0.type AS type_4, t0.value AS value_5, t0.id AS id_6 FROM config t0 WHERE t0._key = ? LIMIT 1
Parameters:
[
  "404_translation"
]
0.31 ms
(0.41%)
1
SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = ? LIMIT 1
Parameters:
[
  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.