1.75 ms (25.89%)
|
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_preset AS is_preset_4 FROM balade_tag t0 INNER JOIN balade_balade_tag ON t0.id = balade_balade_tag.balade_tag_id WHERE balade_balade_tag.balade_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_preset AS is_preset_4 FROM balade_tag t0 INNER JOIN balade_balade_tag ON t0.id = balade_balade_tag.balade_tag_id WHERE balade_balade_tag.balade_id = 16;
|
1.34 ms (19.89%)
|
4 |
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 = 16 ORDER BY t0.position ASC;
|
1.18 ms (17.49%)
|
4 |
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 = 16;
|
1.04 ms (15.43%)
|
4 |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.balade_id AS balade_id_5 FROM balade_rating t0 WHERE t0.balade_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.balade_id AS balade_id_5 FROM balade_rating t0 WHERE t0.balade_id = 16;
|
0.94 ms (13.85%)
|
2 |
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 = 4;
|
0.50 ms (7.46%)
|
1 |
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 ORDER BY t0.id DESC LIMIT 4
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 ORDER BY t0.id DESC LIMIT 4;
|