GET https://cbfadmin-test.cn.cnrs.fr/en/job/129

Query Metrics

10 Database Queries
7 Different statements
4.09 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.19 ms
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIME_FORMAT = '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:
[]
2 0.39 ms
SELECT t0.id AS ID_1, t0.title AS TITLE_2, t0.title_en AS TITLE_EN_3, t0.place AS PLACE_4, t0.type AS TYPE_5, t0.type_en AS TYPE_EN_6, t0.quotite AS QUOTITE_7, t0.quotite_en AS QUOTITE_EN_8, t0.employer AS EMPLOYER_9, t0.employer_en AS EMPLOYER_EN_10, t0.wage AS WAGE_11, t0.start_date AS START_DATE_12, t0.duration AS DURATION_13, t0.duration_en AS DURATION_EN_14, t0.mission AS MISSION_15, t0.mission_en AS MISSION_EN_16, t0.degree AS DEGREE_17, t0.degree_en AS DEGREE_EN_18, t0.experience AS EXPERIENCE_19, t0.experience_en AS EXPERIENCE_EN_20, t0.skills AS SKILLS_21, t0.skills_en AS SKILLS_EN_22, t0.context AS CONTEXT_23, t0.context_en AS CONTEXT_EN_24, t0.misc AS MISC_25, t0.misc_en AS MISC_EN_26, t0.contact_name AS CONTACT_NAME_27, t0.contact_email AS CONTACT_EMAIL_28, t0.contact_web AS CONTACT_WEB_29, t0.verified AS VERIFIED_30, t0.team_id AS TEAM_ID_31, t0.author_id AS AUTHOR_ID_32 FROM job t0 WHERE t0.id = ?
Parameters:
[
  129
]
3 0.34 ms
SELECT t0.id AS ID_1, t0.job_id AS JOB_ID_2, t0.file_id AS FILE_ID_3 FROM file_job t0 WHERE t0.job_id = ?
Parameters:
[
  129
]
4 0.63 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:
[]
5 0.33 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
]
6 0.36 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
]
7 0.16 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
]
8 0.26 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:
[]
9 0.14 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
]
10 0.30 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\Job No errors.
App\Entity\Equipe No errors.
App\UserBundle\Entity\User No errors.
App\Entity\FileJob No errors.
App\Entity\File 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.