Query Metrics

5 Database Queries
4 Different statements
3.36 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 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:
[
  "96"
]
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.63 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.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 = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
5 0.40 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
]

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.