GET https://cbfadmin-dev.cn.cnrs.fr/fr/publications

Response
200 OK
IP
18.219.23.150
Profiled on
Token
8b8c89

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 1.26 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 10.14 ms 
SELECT b0_.id AS ID_0, b0_.type AS TYPE_1, b0_.address AS ADDRESS_2, b0_.abstract AS ABSTRACT_3, b0_.annote AS ANNOTE_4, b0_.author AS AUTHOR_5, b0_.booktitle AS BOOKTITLE_6, b0_.chapter AS CHAPTER_7, b0_.crossref AS CROSSREF_8, b0_.edition AS EDITION_9, b0_.editor AS EDITOR_10, b0_.eprint AS EPRINT_11, b0_.howpublished AS HOWPUBLISHED_12, b0_.institution AS INSTITUTION_13, b0_.organization AS ORGANIZATION_14, b0_.publisher AS PUBLISHER_15, b0_.school AS SCHOOL_16, b0_.series AS SERIES_17, b0_.url AS URL_18, b0_.volume AS VOLUME_19, b0_.title AS TITLE_20, b0_.journal AS JOURNAL_21, b0_.year AS YEAR_22, b0_.doi AS DOI_23, b0_.publi_number AS PUBLI_NUMBER_24, b0_.pages AS PAGES_25, b0_.month AS MONTH_26, b0_.note AS NOTE_27, b0_.bibkey AS BIBKEY_28, b0_.issn AS ISSN_29 FROM bib_publication b0_ WHERE b0_.year >= ? AND b0_.year <= ?
Parameters: 
[
  0
  10000000
]
View formatted query    View runnable query    Explain query
3 2.90 ms 
SELECT t0.id AS ID_1, t0.type AS TYPE_2, t0.address AS ADDRESS_3, t0.abstract AS ABSTRACT_4, t0.annote AS ANNOTE_5, t0.author AS AUTHOR_6, t0.booktitle AS BOOKTITLE_7, t0.chapter AS CHAPTER_8, t0.crossref AS CROSSREF_9, t0.edition AS EDITION_10, t0.editor AS EDITOR_11, t0.eprint AS EPRINT_12, t0.howpublished AS HOWPUBLISHED_13, t0.institution AS INSTITUTION_14, t0.organization AS ORGANIZATION_15, t0.publisher AS PUBLISHER_16, t0.school AS SCHOOL_17, t0.series AS SERIES_18, t0.url AS URL_19, t0.volume AS VOLUME_20, t0.title AS TITLE_21, t0.journal AS JOURNAL_22, t0.year AS YEAR_23, t0.doi AS DOI_24, t0.publi_number AS PUBLI_NUMBER_25, t0.pages AS PAGES_26, t0.month AS MONTH_27, t0.note AS NOTE_28, t0.bibkey AS BIBKEY_29, t0.issn AS ISSN_30 FROM bib_publication t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.86 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
5 0.43 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
6 0.56 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
7 0.21 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
8 0.42 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
9 0.17 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
10 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.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\BibPublication 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.