http://snowtricks.valentin-moreau.com/api/message/trick0?limit=10&page=1

Query Metrics

1 Database Queries
1 Different statements
0.94 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 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, m1_.id AS id_6, m1_.content AS content_7, m1_.updated_at AS updated_at_8, m1_.created_at AS created_at_9, u2_.id AS id_10, u2_.email AS email_11, u2_.roles AS roles_12, u2_.password AS password_13, u2_.lastname AS lastname_14, u2_.firstname AS firstname_15, u2_.updated_at AS updated_at_16, u2_.avatar AS avatar_17, u2_.is_verified AS is_verified_18, u2_.registration_token AS registration_token_19, u2_.password_recovery_token AS password_recovery_token_20, u2_.account_deletion_token AS account_deletion_token_21, u2_.created_at AS created_at_22, t0_.id_user AS id_user_23, t0_.id_category AS id_category_24, m1_.id_trick AS id_trick_25, m1_.id_user AS id_user_26 FROM trick t0_ LEFT JOIN message m1_ ON t0_.id = m1_.id_trick LEFT JOIN user u2_ ON m1_.id_user = u2_.id WHERE t0_.slug = ? ORDER BY m1_.created_at DESC LIMIT 10
Parameters:
[
  "trick0"
]

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\Message No errors.
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\Image No errors.
App\Entity\Video No errors.