Query Metrics
7
Database Queries
5
Different statements
30.78 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.61 ms (40.98%) |
2 |
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
]
|
6.43 ms (20.90%) |
2 |
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
]
|
5.86 ms (19.03%) |
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:
[
1
]
|
3.14 ms (10.21%) |
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:
[ 1 1 ] |
2.73 ms (8.89%) |
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:
[
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\CBRCArticle | No errors. |
App\Entity\CBRCUser | No errors. |
App\Entity\CBRCArticleContent | No errors. |
App\Entity\CBRCArticleCategory | No errors. |
App\Entity\CBRCArticleComment | No errors. |
App\Entity\CBRCUserDescription | No errors. |
App\Entity\CBRCResetPassword | No errors. |
App\Entity\CBRCPageContentUpdate | No errors. |