Query Metrics
7
Database Queries
3
Different statements
1.24 ms
Query time
0
Invalid entities
19
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.73 ms (58.64%) |
5 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.first_name AS first_name_4, t0.join_date AS join_date_5, t0.image AS image_6, t0.cover AS cover_7, t0.roles AS roles_8, t0.password AS password_9, t0.status AS status_10, t0.type AS type_11, t0.token AS token_12, t0.cv AS cv_13, t0.vcode AS vcode_14, t0.package AS package_15, t0.activation_date AS activation_date_16, t0.country_id AS country_id_17, t0.category_id AS category_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
20
]
|
|
0.26 ms (20.68%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.first_name AS first_name_4, t0.join_date AS join_date_5, t0.image AS image_6, t0.cover AS cover_7, t0.roles AS roles_8, t0.password AS password_9, t0.status AS status_10, t0.type AS type_11, t0.token AS token_12, t0.cv AS cv_13, t0.vcode AS vcode_14, t0.package AS package_15, t0.activation_date AS activation_date_16, t0.country_id AS country_id_17, t0.category_id AS category_id_18 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
12
]
|
|
0.26 ms (20.68%) |
1 |
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.send_date AS send_date_2, c0_.accept_date AS accept_date_3, c0_.cancel_date AS cancel_date_4, c0_.sender_id AS sender_id_5, c0_.receiver_id AS receiver_id_6 FROM collaboration c0_ WHERE c0_.status = 2 AND (c0_.sender_id = ? OR c0_.receiver_id = ?) ORDER BY c0_.accept_date DESC
Parameters:
[ 12 12 ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 6 |
| App\Entity\Collaboration | 5 |
| App\Entity\Country | 4 |
| App\Entity\Category | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Collaboration | No errors. |