https://snowtricks.valentin-moreau.com/trick/displayone/trick19

Query Metrics

2 Database Queries
2 Different statements
0.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 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:
[
  "trick19"
]
2 0.34 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.