0.20 ms (21.34%)
|
1 |
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;
|
0.18 ms (19.01%)
|
1 |
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;
|
0.16 ms (16.65%)
|
1 |
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;
|
0.15 ms (15.92%)
|
1 |
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;
|
0.14 ms (14.65%)
|
1 |
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;
|
0.12 ms (12.43%)
|
1 |
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;
|