GET https://cbfadmin-dev.cn.cnrs.fr/fr/team/57

Response
200 OK
IP
3.149.243.29
Profiled on
Token
36f661

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 1.33 ms 
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.29 ms 
SELECT t0.id AS ID_1, t0.intitule AS INTITULE_2, t0.acronyme AS ACRONYME_3, t0.adresse AS ADRESSE_4, t0.contact_1 AS CONTACT_1_5, t0.contact_2 AS CONTACT_2_6, t0.tutelles AS TUTELLES_7, t0.date_de_creation AS DATE_DE_CREATION_8, t0.demarche_qualite AS DEMARCHE_QUALITE_9, t0.certifications AS CERTIFICATIONS_10, t0.savoir_faire AS SAVOIR_FAIRE_11, t0.savoir_faire_en AS SAVOIR_FAIRE_EN_12, t0.specificite AS SPECIFICITE_13, t0.specificite_en AS SPECIFICITE_EN_14, t0.domaine_application AS DOMAINE_APPLICATION_15, t0.domaine_application_en AS DOMAINE_APPLICATION_EN_16, t0.tests_proposes AS TESTS_PROPOSES_17, t0.tests_proposes_en AS TESTS_PROPOSES_EN_18, t0.autres_activites AS AUTRES_ACTIVITES_19, t0.autres_activites_en AS AUTRES_ACTIVITES_EN_20, t0.equipements AS EQUIPEMENTS_21, t0.equipements_en AS EQUIPEMENTS_EN_22, t0.RH AS RH_23, t0.technologies AS TECHNOLOGIES_24, t0.technologies_en AS TECHNOLOGIES_EN_25, t0.debit AS DEBIT_26, t0.debit_en AS DEBIT_EN_27, t0.delai_reponse AS DELAI_REPONSE_28, t0.delai_reponse_en AS DELAI_REPONSE_EN_29, t0.reference AS REFERENCE_30, t0.reference_en AS REFERENCE_EN_31, t0.latitude AS LATITUDE_32, t0.longitude AS LONGITUDE_33, t0.category AS CATEGORY_34, t0.created_at AS CREATED_AT_35, t0.updated_at AS UPDATED_AT_36, t0.labocn_id AS LABOCN_ID_37 FROM equipe t0 WHERE t0.id = ?
Parameters: 
[
  "57"
]
View formatted query    View runnable query    Explain query
3 0.39 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: 
[]
View formatted query    View runnable query    Explain query
4 0.22 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
]
View formatted query    View runnable query    Explain query
5 0.46 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
]
View formatted query    View runnable query    Explain query
6 0.15 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
]
View formatted query    View runnable query    Explain query
7 0.25 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: 
[]
View formatted query    View runnable query    Explain query
8 0.13 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
]
View formatted query    View runnable query    Explain query
9 0.22 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
]
View formatted query    View runnable query    Explain query

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\Equipe 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.