| 1 |
3.63 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price AS price_4, p0_.is_visible AS is_visible_5, p0_.cover_image AS cover_image_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.slug AS slug_11, c1_.description AS description_12, c1_.is_visible AS is_visible_13, c1_.sort_order AS sort_order_14, c1_.created_at AS created_at_15, p0_.category_id AS category_id_16 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.slug = ? AND p0_.is_visible = ?
Parameters: [
"etiquettes-cadeau-gravees"
1
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price AS price_4, p0_.is_visible AS is_visible_5, p0_.cover_image AS cover_image_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.slug AS slug_11, c1_.description AS description_12, c1_.is_visible AS is_visible_13, c1_.sort_order AS sort_order_14, c1_.created_at AS created_at_15, p0_.category_id AS category_id_16 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.slug = 'etiquettes-cadeau-gravees' AND p0_.is_visible = 1;
|
| 2 |
0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_option_group t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC, t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_option_group t0 WHERE t0.product_id = 15 ORDER BY t0.sort_order ASC, t0.id ASC;
|
| 3 |
0.45 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.price_adjustment AS price_adjustment_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.group_id AS group_id_6 FROM product_option_value t0 WHERE t0.group_id = ? ORDER BY t0.sort_order ASC, t0.id ASC
SELECT t0.id AS id_1, t0.label AS label_2, t0.price_adjustment AS price_adjustment_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.group_id AS group_id_6 FROM product_option_value t0 WHERE t0.group_id = 1 ORDER BY t0.sort_order ASC, t0.id ASC;
|