| 1 |
0.34 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 = ?
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 = '7';
|
| 2 |
0.35 ms |
SELECT AVG(b0_.rating) AS sclr_0 FROM balade_rating b0_ WHERE b0_.balade_id = ?
SELECT AVG(b0_.rating) AS sclr_0 FROM balade_rating b0_ WHERE b0_.balade_id = 7;
|
| 3 |
0.26 ms |
SELECT COUNT(*) FROM balade_rating t0 WHERE t0.balade_id = ?
SELECT COUNT(*) FROM balade_rating t0 WHERE t0.balade_id = 7;
|
| 4 |
0.32 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
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 = 7 ORDER BY t0.position ASC;
|
| 5 |
0.28 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 = ?
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 = 2;
|
| 6 |
0.35 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 = ?
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 = 7;
|
| 7 |
0.12 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 = ?
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 = 1;
|