Query Metrics

25 Database Queries
12 Different statements
26.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
16.63 ms
(62.53%)
1
SELECT       c.COLUMN_NAME        AS field,
           IF(
        x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext',
        'json',
        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
    LEFT JOIN information_schema.CHECK_CONSTRAINTS x
    ON (
        c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA
        AND c.TABLE_NAME = x.TABLE_NAME
        AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)')
    ) WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "tressol-chabrier"
  "doctrine_migration_versions"
]
1.92 ms
(7.21%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "tressol-chabrier"
]
1.37 ms
(5.16%)
6
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
1.20 ms
(4.53%)
3
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_our_jobs_detail"
]
1.15 ms
(4.32%)
6
SELECT DATABASE()
Parameters:
[]
1.13 ms
(4.24%)
1
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.photos AS photos_2, j0_.code_romes AS code_romes_3, j0_.family AS family_4, j0_.nature_du_travail AS nature_du_travail_5, j0_.tasks AS tasks_6, j0_.quality AS quality_7, j0_.skills AS skills_8, j0_.les_profils_qui_nous_plaisent AS les_profils_qui_nous_plaisent_9, j0_.univers_du_poste AS univers_du_poste_10, j0_.evolution AS evolution_11, j0_.category_id AS category_id_12 FROM job j0_ ORDER BY j0_.category_id ASC
Parameters:
[]
1.04 ms
(3.93%)
1
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 = 'tressol-chabrier' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
0.51 ms
(1.92%)
1
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:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
0.51 ms
(1.91%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.legales_text AS legales_text_5 FROM promo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.41 ms
(1.55%)
1
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:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
0.36 ms
(1.36%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]
0.36 ms
(1.35%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.identifier AS identifier_4, t0.content AS content_5, t0.hektor_text_logged AS hektor_text_logged_6, t0.hektor_text_not_logged AS hektor_text_not_logged_7, t0.hektor_text_is_differnet AS hektor_text_is_differnet_8, t0.cms_page_id AS cms_page_id_9 FROM cms_bloc t0 WHERE t0.cms_page_id = ?
Parameters:
[
  36
]

Database Connections

Name Service
default doctrine.dbal.default_connection
internal doctrine.dbal.internal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
internal doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Job No errors.
App\Entity\Offre No errors.
App\Entity\CmsPage No errors.
App\Entity\CmsBloc No errors.
App\Entity\DataCount No errors.
App\Entity\Promo No errors.
App\Entity\PromoSlider No errors.

internal entity manager

No loaded entities.