Symfony Profiler

Query Metrics

27 Database Queries

7 Different statements

116.78 ms Query time

4 Invalid entities

Queries


SELECT DATABASE()
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
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
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_demo' */ ORDER BY k.ORDINAL_POSITION
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'
SELECT l0_.code AS code_0 FROM locale l0_
SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = ? LIMIT 1
SELECT DATABASE()
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
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
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_demo' */ ORDER BY k.ORDINAL_POSITION
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'
SELECT DATABASE()
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
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
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_demo' */ ORDER BY k.ORDINAL_POSITION
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'
SELECT DATABASE()
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
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
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_demo' */ ORDER BY k.ORDINAL_POSITION
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'
SELECT DATABASE()
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
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
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_demo' */ ORDER BY k.ORDINAL_POSITION
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'

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\Locale	No errors.
App\Entity\Block\AbstractBlock	No errors.
App\Entity\Block\AbstractBlockTranslation	No errors.
App\Entity\Block\AbstractBlockType	No errors.
App\Entity\Block\AbstractBlockTypeTranslation	No errors.
App\Entity\Block\Block	No errors.
App\Entity\Block\BlockContent	No errors.
App\Entity\Block\BlockContentType	No errors.
App\Entity\Block\BlockTranslation	No errors.
App\Entity\Block\BlockType	The association App\Entity\Block\BlockType#blocks refers to the owning side field App\Entity\Block\BlockType#blockType which does not exist.
App\Entity\Data	No errors.
App\Entity\Block\DataBlock	No errors.
App\Entity\Config	No errors.
App\Entity\Content\ContentType	No errors.
App\Entity\Content\ContentTypeTranslation	No errors.
App\Entity\Content\DataPage	No errors.
App\Entity\Content\Page	No errors.
App\Entity\Content\PageTranslation	No errors.
App\Entity\Content\Section	No errors.
App\Entity\Content\SectionTranslation	No errors.
App\Entity\Field\BaseField	No errors.
App\Entity\Field\BlockField	No errors.
App\Entity\Field\ChoiceField	No errors.
App\Entity\Field\BaseFieldTranslation	No errors.
App\Entity\Field\ChoiceFieldTranslation	No errors.
App\Entity\Field\DateField	No errors.
App\Entity\Field\MailField	No errors.
App\Entity\Field\MediaField	No errors.
App\Entity\Field\NumericField	No errors.
App\Entity\Field\NumericFieldTranslation	No errors.
App\Entity\Field\PhoneField	No errors.
App\Entity\Field\TextField	No errors.
App\Entity\Field\WebformField	No errors.
App\Entity\Field\CoordField	No errors.
App\Entity\Field\LinkField	No errors.
App\Entity\Field\WidgetField	No errors.
App\Entity\Log	No errors.
App\Entity\Media\File	No errors.
App\Entity\Media\Document	No errors.
App\Entity\Media\FileTranslation	No errors.
App\Entity\Media\DocumentTranslation	No errors.
App\Entity\Media\FileForm	No errors.
App\Entity\Media\Image	No errors.
App\Entity\Media\ImageTranslation	No errors.
App\Entity\Media\Video	No errors.
App\Entity\Menu\Menu	No errors.
App\Entity\Menu\MenuLinks	The association App\Entity\Menu\MenuLinks#menu refers to the inverse side field App\Entity\Menu\Menu#links which does not exist.
App\Entity\Menu\MenuLinksTranslation	No errors.
App\Entity\Menu\MenuTranslation	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Taxonomy\Taxonomy	No errors.
App\Entity\Taxonomy\TaxonomyTranslation	No errors.
App\Entity\Taxonomy\TaxonomyType	No errors.
App\Entity\Taxonomy\TaxonomyTypeTranslation	No errors.
App\Entity\Translation	No errors.
App\Entity\User\Permissions	No errors.
App\Entity\User\Roles	No errors.
App\Entity\User\User	No errors.
App\Entity\Version\Version	No errors.
App\Entity\Version\Block\BlockVersion	No errors.
App\Entity\Version\VersionTranslation	No errors.
App\Entity\Version\Block\BlockVersionTranslation	No errors.
App\Entity\Version\Content\PageVersion	No errors.
App\Entity\Version\Content\PageVersionTranslation	No errors.
App\Entity\Version\DataVersion	The association App\Entity\Version\DataVersion#version refers to the inverse side field App\Entity\Version\Version#data which does not exist.
App\Entity\Version\Taxonomy\TaxonomyVersion	The association App\Entity\Version\Taxonomy\TaxonomyVersion#taxonomy refers to the inverse side field App\Entity\Taxonomy\Taxonomy#versions which does not exist.
App\Entity\Version\Taxonomy\TaxonomyVersionTranslation	No errors.
App\Entity\Webform\DataWebform	No errors.
App\Entity\Webform\Result	No errors.
App\Entity\Webform\Webform	No errors.
App\Entity\Webform\WebformTranslation	No errors.
App\Entity\Cartographie\Poi	No errors.
App\Entity\Cartographie\PoiTranslation	No errors.
App\Entity\Marketing\Notification	No errors.
App\Entity\Marketing\Subscriber	No errors.
App\Entity\Marketing\Subscription	No errors.
App\Entity\Marketing\SubscriptionList	No errors.
App\Entity\Marketing\SubscriptionListTranslation	No errors.

Symfony Profiler

GET https://demo.cms.agence-twco.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping