2.77 ms (54.04%)
|
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.descriptif AS descriptif_3, t0.ingredients AS ingredients_4, t0.instructions AS instructions_5, t0.temps_prepa AS temps_prepa_6, t0.temps_cuisson AS temps_cuisson_7, t0.image AS image_8, t0.status AS status_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.difficulty AS difficulty_12, t0.category AS category_13, t0.tags AS tags_14, t0.user_id AS user_id_15 FROM recette t0 WHERE t0.status = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters: [
"completed"
]
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.descriptif AS descriptif_3, t0.ingredients AS ingredients_4, t0.instructions AS instructions_5, t0.temps_prepa AS temps_prepa_6, t0.temps_cuisson AS temps_cuisson_7, t0.image AS image_8, t0.status AS status_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.difficulty AS difficulty_12, t0.category AS category_13, t0.tags AS tags_14, t0.user_id AS user_id_15 FROM recette t0 WHERE t0.status = 'completed' ORDER BY t0.created_at DESC LIMIT 3;
|
2.36 ms (45.96%)
|
1 |
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.descriptif AS descriptif_2, r0_.ingredients AS ingredients_3, r0_.instructions AS instructions_4, r0_.temps_prepa AS temps_prepa_5, r0_.temps_cuisson AS temps_cuisson_6, r0_.image AS image_7, r0_.status AS status_8, r0_.slug AS slug_9, r0_.created_at AS created_at_10, r0_.difficulty AS difficulty_11, r0_.category AS category_12, r0_.tags AS tags_13, r0_.user_id AS user_id_14 FROM recette r0_ WHERE r0_.status = ? AND r0_.category = ? ORDER BY RAND() ASC LIMIT 1
Parameters: [
"completed"
"dessert"
]
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.descriptif AS descriptif_2, r0_.ingredients AS ingredients_3, r0_.instructions AS instructions_4, r0_.temps_prepa AS temps_prepa_5, r0_.temps_cuisson AS temps_cuisson_6, r0_.image AS image_7, r0_.status AS status_8, r0_.slug AS slug_9, r0_.created_at AS created_at_10, r0_.difficulty AS difficulty_11, r0_.category AS category_12, r0_.tags AS tags_13, r0_.user_id AS user_id_14 FROM recette r0_ WHERE r0_.status = 'completed' AND r0_.category = 'dessert' ORDER BY RAND() ASC LIMIT 1;
|