| 1 |
0.65 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 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;
|
| 2 |
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
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;
|
| 3 |
0.26 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 = 4;
|
| 4 |
0.54 ms |
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;
|
| 5 |
0.46 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 = 16;
|
| 6 |
0.53 ms |
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;
|
| 7 |
0.43 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 = 14 ORDER BY t0.position ASC;
|
| 8 |
0.35 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;
|
| 9 |
0.32 ms |
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 = 14;
|
| 10 |
0.46 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 = 14;
|
| 11 |
0.31 ms |
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 = 14;
|
| 12 |
0.31 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 = 13 ORDER BY t0.position ASC;
|
| 13 |
0.38 ms |
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 = 13;
|
| 14 |
0.20 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 = 13;
|
| 15 |
0.18 ms |
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 = 13;
|
| 16 |
0.21 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 = 11 ORDER BY t0.position ASC;
|
| 17 |
0.25 ms |
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 = 11;
|
| 18 |
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 = ?
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 = 11;
|
| 19 |
0.17 ms |
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 = 11;
|