GET https://mail.dogsout.org/balade/article/8

Query Metrics

6 Database Queries
6 Different statements
1.90 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.is_public AS is_public_4, t0.created_at AS created_at_5, t0.route_geo_json AS route_geo_json_6, t0.waypoints_json AS waypoints_json_7, t0.distance_meters AS distance_meters_8, t0.duration_seconds AS duration_seconds_9, t0.difficulty AS difficulty_10, t0.user_id AS user_id_11 FROM balade t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
2 0.35 ms
SELECT AVG(b0_.rating) AS sclr_0 FROM balade_rating b0_ WHERE b0_.balade_id = ?
Parameters:
[
  8
]
3 0.37 ms
SELECT COUNT(*) FROM balade_rating t0 WHERE t0.balade_id = ?
Parameters:
[
  8
]
4 0.34 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.position AS position_3, t0.updated_at AS updated_at_4, t0.balade_id AS balade_id_5 FROM balade_image t0 WHERE t0.balade_id = ? ORDER BY t0.position ASC
Parameters:
[
  8
]
5 0.15 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.created_at AS created_at_8, t0.description AS description_9, t0.active AS active_10, t0.first_connexion AS first_connexion_11, t0.image_name AS image_name_12, t0.updated_at AS updated_at_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.26 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.balade_id AS balade_id_5 FROM comment t0 WHERE t0.balade_id = ?
Parameters:
[
  8
]

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\Balade 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Balade No errors.
App\Entity\User No errors.
App\Entity\Comment No errors.
App\Entity\GroupEvent No errors.
App\Entity\BaladeImage No errors.
App\Entity\BaladeTag No errors.
App\Entity\BaladeRating No errors.
App\Entity\Chien No errors.
App\Entity\Participant No errors.
App\Entity\Message No errors.
App\Entity\UserGroup No errors.
App\Entity\GroupMember No errors.
App\Entity\GroupEventResponse No errors.