0.87 ms (11.86%)
|
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.hiboutik_reference AS hiboutik_reference_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14, p0_.is_featured AS is_featured_15, p0_.long_distance_delivery AS long_distance_delivery_16, p0_.brand_id AS brand_id_17, p0_.category_id AS category_id_18, p0_.subcategory_id AS subcategory_id_19 FROM product p0_ INNER JOIN promotion p1_ ON p0_.id = p1_.product_id WHERE p1_.status = ? AND p1_.end_date > ? ORDER BY p1_.end_date ASC
Parameters: [
"active"
"2026-07-03 04:49:00"
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.extra AS extra_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.origin AS origin_5, p0_.price AS price_6, p0_.stock AS stock_7, p0_.hiboutik_reference AS hiboutik_reference_8, p0_.weight AS weight_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.reference AS reference_12, p0_.status AS status_13, p0_.is_mts_product AS is_mts_product_14, p0_.is_featured AS is_featured_15, p0_.long_distance_delivery AS long_distance_delivery_16, p0_.brand_id AS brand_id_17, p0_.category_id AS category_id_18, p0_.subcategory_id AS subcategory_id_19 FROM product p0_ INNER JOIN promotion p1_ ON p0_.id = p1_.product_id WHERE p1_.status = 'active' AND p1_.end_date > '2026-07-03 04:49:00' ORDER BY p1_.end_date ASC;
|
0.85 ms (11.57%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.is_active AS is_active_5, t0.image AS image_6 FROM category t0 WHERE t0.slug = 'promos' LIMIT 1;
|