Query Metrics
2
Database Queries
2
Different statements
1.02 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.67 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.updated_at AS updated_at_3, t0_.slug AS slug_4, t0_.created_at AS created_at_5, i1_.id AS id_6, i1_.path AS path_7, i1_.created_at AS created_at_8, v2_.id AS id_9, v2_.path AS path_10, v2_.created_at AS created_at_11, m3_.id AS id_12, m3_.content AS content_13, m3_.updated_at AS updated_at_14, m3_.created_at AS created_at_15, u4_.id AS id_16, u4_.email AS email_17, u4_.roles AS roles_18, u4_.password AS password_19, u4_.lastname AS lastname_20, u4_.firstname AS firstname_21, u4_.updated_at AS updated_at_22, u4_.avatar AS avatar_23, u4_.is_verified AS is_verified_24, u4_.registration_token AS registration_token_25, u4_.password_recovery_token AS password_recovery_token_26, u4_.account_deletion_token AS account_deletion_token_27, u4_.created_at AS created_at_28, t0_.id_user AS id_user_29, t0_.id_category AS id_category_30, i1_.id_trick AS id_trick_31, v2_.id_trick AS id_trick_32, m3_.id_trick AS id_trick_33, m3_.id_user AS id_user_34 FROM trick t0_ LEFT JOIN image i1_ ON t0_.id = i1_.id_trick LEFT JOIN video v2_ ON t0_.id = v2_.id_trick LEFT JOIN message m3_ ON t0_.id = m3_.id_trick LEFT JOIN user u4_ ON m3_.id_user = u4_.id WHERE t0_.slug = ? ORDER BY m3_.created_at DESC
Parameters:
[
"trick14"
]
|
2 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.updated_at AS updated_at_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.id_user AS id_user_7 FROM category t0 WHERE t0.id = ?
Parameters:
[
25
]
|
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\Trick | No errors. |
App\Entity\Image | No errors. |
App\Entity\Video | No errors. |
App\Entity\Message | No errors. |
App\Entity\User | No errors. |
App\Entity\Category | No errors. |