| 1 |
0.15 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.id = 31;
|
| 2 |
0.16 ms |
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = ? ORDER BY t0.date_envoi DESC
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = 31 ORDER BY t0.date_envoi DESC;
|
| 3 |
0.14 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.point AS point_4, t0.economie_co2 AS economie_co2_5, t0.created_at AS created_at_6, t0.categorie_id AS categorie_id_7, t0.difficulte_id AS difficulte_id_8 FROM defi t0
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.point AS point_4, t0.economie_co2 AS economie_co2_5, t0.created_at AS created_at_6, t0.categorie_id AS categorie_id_7, t0.difficulte_id AS difficulte_id_8 FROM defi t0;
|
| 4 |
0.12 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.score_equipe AS score_equipe_3, t0.code_invitation AS code_invitation_4, t0.created_at AS created_at_5 FROM equipe t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.score_equipe AS score_equipe_3, t0.code_invitation AS code_invitation_4, t0.created_at AS created_at_5 FROM equipe t0 WHERE t0.id = 3;
|
| 5 |
0.20 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.equipe_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.equipe_id = 3;
|
| 6 |
0.18 ms |
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = ? AND t0.status = ? ORDER BY t0.date_envoi DESC LIMIT 5
Parameters: [
31
"VALIDE"
]
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = 31 AND t0.status = 'VALIDE' ORDER BY t0.date_envoi DESC LIMIT 5;
|