https://dev.cbrc.maximeboekhorst.ovh/article/1

Query Metrics

7 Database Queries
5 Different statements
30.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.86 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.creationdate AS creationdate_4, t0.updateddate AS updateddate_5, t0.publisheddate AS publisheddate_6, t0.archiveddate AS archiveddate_7, t0.author_id AS author_id_8, t0.content_id AS content_id_9, t0.category_id AS category_id_10 FROM cbrcarticle t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 3.14 ms
SELECT c0_.id AS id_0, c0_.text AS text_1, c0_.isvisible AS isvisible_2, c0_.creationdate AS creationdate_3, c0_.updatedate AS updatedate_4, c0_.article_id AS article_id_5, c0_.user_id AS user_id_6 FROM cbrcarticle_comment c0_ WHERE c0_.article_id = ? AND c0_.isvisible = ? ORDER BY c0_.updatedate ASC, c0_.creationdate ASC
Parameters:
[
  1
  1
]
3 2.73 ms
SELECT t0.id AS id_1, t0.shortresume AS shortresume_2, t0.text AS text_3, t0.signature AS signature_4, t0.image1 AS image1_5, t0.document1 AS document1_6, t0.updated_at AS updated_at_7, t0.contentblob AS contentblob_8, t0.documentname AS documentname_9, t10.id AS id_11, t10.title AS title_12, t10.status AS status_13, t10.creationdate AS creationdate_14, t10.updateddate AS updateddate_15, t10.publisheddate AS publisheddate_16, t10.archiveddate AS archiveddate_17, t10.author_id AS author_id_18, t10.content_id AS content_id_19, t10.category_id AS category_id_20 FROM cbrcarticle_content t0 LEFT JOIN cbrcarticle t10 ON t10.content_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
4 11.19 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.creationdate AS creationdate_5, t0.description_id AS description_id_6, t7.id AS id_8, t7.token AS token_9, t7.validitydate AS validitydate_10, t7.user_id AS user_id_11 FROM cbrcuser t0 LEFT JOIN cbrcreset_password t7 ON t7.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
5 5.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.forname AS forname_3, t0.biography AS biography_4, t0.phonenumber AS phonenumber_5, t0.image1 AS image1_6, t0.updated_at AS updated_at_7 FROM cbrcuser_description t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 1.42 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.creationdate AS creationdate_5, t0.description_id AS description_id_6, t7.id AS id_8, t7.token AS token_9, t7.validitydate AS validitydate_10, t7.user_id AS user_id_11 FROM cbrcuser t0 LEFT JOIN cbrcreset_password t7 ON t7.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
7 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.forname AS forname_3, t0.biography AS biography_4, t0.phonenumber AS phonenumber_5, t0.image1 AS image1_6, t0.updated_at AS updated_at_7 FROM cbrcuser_description t0 WHERE t0.id = ?
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.