| 1 |
0.48 ms |
SELECT t0.id AS id_1, t0.main_image AS main_image_2, t0.name AS name_3, t0.origin AS origin_4, t0.description AS description_5, t0.ingredients AS ingredients_6, t0.price AS price_7, t0.purchase_url AS purchase_url_8, t0.is_published AS is_published_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_sold_out AS is_sold_out_13 FROM jam t0 WHERE t0.is_published = ? ORDER BY t0.is_featured DESC, t0.id DESC
SELECT t0.id AS id_1, t0.main_image AS main_image_2, t0.name AS name_3, t0.origin AS origin_4, t0.description AS description_5, t0.ingredients AS ingredients_6, t0.price AS price_7, t0.purchase_url AS purchase_url_8, t0.is_published AS is_published_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_sold_out AS is_sold_out_13 FROM jam t0 WHERE t0.is_published = 1 ORDER BY t0.is_featured DESC, t0.id DESC;
|
| 2 |
0.37 ms |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = 5;
|
| 3 |
0.32 ms |
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = 5;
|
| 4 |
0.30 ms |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = 4;
|
| 5 |
0.29 ms |
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = 4;
|
| 6 |
0.28 ms |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = 3;
|
| 7 |
0.27 ms |
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = 3;
|
| 8 |
0.26 ms |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = 2;
|
| 9 |
0.29 ms |
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = 2;
|
| 10 |
0.27 ms |
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.display_order AS display_order_3, t0.jam_id AS jam_id_4 FROM jam_image t0 WHERE t0.jam_id = 1;
|
| 11 |
0.27 ms |
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = ?
SELECT t0.id AS id_1, t0.body AS body_2, t0.attribute AS attribute_3, t0.display_order AS display_order_4, t0.jam_id AS jam_id_5 FROM jam_review t0 WHERE t0.jam_id = 1;
|