Query Metrics

9 Database Queries
6 Different statements
5.31 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
SELECT t0.id AS ID_1, t0.structure AS STRUCTURE_2, t0.name AS NAME_3, t0.CAS_numero AS CAS_NUMERO_4, t0.properties AS PROPERTIES_5, t0.protein_target_name AS PROTEIN_TARGET_NAME_6, t0.mecanism AS MECANISM_7, t0.probe_availability AS PROBE_AVAILABILITY_8, t0.bib_primary_reference AS BIB_PRIMARY_REFERENCE_9, t0.bib_references AS BIB_REFERENCES_10, t0.probe_details AS PROBE_DETAILS_11, t0.target_details AS TARGET_DETAILS_12, t0.selectivity_profile AS SELECTIVITY_PROFILE_13, t0.in_vitro_data AS IN_VITRO_DATA_14, t0.in_vivo_data AS IN_VIVO_DATA_15, t0.toxicity AS TOXICITY_16, t0.inserted_at AS INSERTED_AT_17, t0.modified_at AS MODIFIED_AT_18, t0.status AS STATUS_19, t0.status_changed_at AS STATUS_CHANGED_AT_20, t0.creator_id AS CREATOR_ID_21, t0.modified_by_id AS MODIFIED_BY_ID_22 FROM sonde t0 WHERE t0.id = ?
Parameters:
[
  "18"
]
2 0.90 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.orderNumber AS ORDERNUMBER_4 FROM header_section t0 ORDER BY t0.orderNumber ASC
Parameters:
[]
3 0.71 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id IS NULL AND t0.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
4 0.72 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
5 0.35 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id = ? ORDER BY t0.order_number ASC
Parameters:
[
  2
]
6 0.79 ms
SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.password AS PASSWORD_3, t0.phone AS PHONE_4, t0.phone2 AS PHONE2_5, t0.roles AS ROLES_6, t0.firstname AS FIRSTNAME_7, t0.lastname AS LASTNAME_8, t0.adresse AS ADRESSE_9, t0.postalcode AS POSTALCODE_10, t0.city AS CITY_11, t0.enabled AS ENABLED_12, t0.token AS TOKEN_13, t0.last_connexion AS LAST_CONNEXION_14, t0.is_public AS IS_PUBLIC_15, t0.bio AS BIO_16, t0.bio_en AS BIO_EN_17, t0.web AS WEB_18, t0.created_at AS CREATED_AT_19, t0.team_id AS TEAM_ID_20, t0.profile_picture_id AS PROFILE_PICTURE_ID_21 FROM t_user t0 WHERE t0.id = ?
Parameters:
[
  18
]
7 0.40 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.orderNumber AS ORDERNUMBER_4 FROM header_section t0 ORDER BY t0.orderNumber ASC
Parameters:
[]
8 0.23 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.section_id IS NULL AND t0.is_public = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
9 0.44 ms
SELECT t0.id AS ID_1, t0.name AS NAME_2, t0.name_en AS NAME_EN_3, t0.content AS CONTENT_4, t0.contentEn AS CONTENTEN_5, t0.is_public AS IS_PUBLIC_6, t0.static AS STATIC_7, t0.order_number AS ORDER_NUMBER_8, t0.should_be_logged AS SHOULD_BE_LOGGED_9, t0.url AS URL_10, t0.url_en AS URL_EN_11, t0.section_id AS SECTION_ID_12 FROM PAGE t0 WHERE t0.is_public = ? ORDER BY t0.order_number ASC
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.

Entities Mapping

Class Mapping errors
App\Entity\Sonde No errors.
App\UserBundle\Entity\User No errors.
App\Entity\HeaderSection
  • The mappings App\Entity\HeaderSection#pages and App\Entity\Page#section are inconsistent with each other.
App\Entity\Page
  • The association App\Entity\Page#section refers to the inverse side field App\Entity\HeaderSection#paragraphs which does not exist.
App\Entity\Paragraph No errors.
App\Entity\Equipe No errors.
App\Entity\File No errors.