https://dev.cbrc51.fr/article/5

Query Metrics

4 Database Queries
4 Different statements
11.68 ms Query time
0 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
3.35 ms
(28.67%)
1
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:
0 of 0
[ 5 ]
3.07 ms
(26.31%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.bgcolor AS bgcolor_3, t0.textcolor AS textcolor_4 FROM cbrcarticle_category t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 3 ]
2.65 ms
(22.70%)
1
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:
0 of 0
[ 5 1 ]
2.61 ms
(22.32%)
1
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:
0 of 0
[ 5 ]