| 1 |
0.35 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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ WHERE p0_.featured = 1 ORDER BY p0_.created_at DESC LIMIT 8
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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ WHERE p0_.featured = 1 ORDER BY p0_.created_at DESC LIMIT 8;
|
| 2 |
0.23 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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ ORDER BY p0_.created_at DESC LIMIT 4
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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ ORDER BY p0_.created_at DESC LIMIT 4;
|
| 3 |
0.21 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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ WHERE p0_.old_price IS NOT NULL AND p0_.old_price > p0_.price ORDER BY p0_.created_at DESC LIMIT 4
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_.old_price AS old_price_5, p0_.stock AS stock_6, p0_.image AS image_7, p0_.volume AS volume_8, p0_.gender AS gender_9, p0_.featured AS featured_10, p0_.created_at AS created_at_11, p0_.category_id AS category_id_12, p0_.brand_id AS brand_id_13 FROM product p0_ WHERE p0_.old_price IS NOT NULL AND p0_.old_price > p0_.price ORDER BY p0_.created_at DESC LIMIT 4;
|
| 4 |
0.21 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, CASE c0_.slug WHEN 'parfums' THEN 10 WHEN 'parfums-de-linge' THEN 20 WHEN 'serums-cheveux' THEN 30 WHEN 'cremes' THEN 40 WHEN 'air-fresh' THEN 50 WHEN 'savons-mains' THEN 60 WHEN 'accessoires' THEN 70 ELSE 100 END AS sclr_4 FROM category c0_ ORDER BY sclr_4 ASC, c0_.id ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, CASE c0_.slug WHEN 'parfums' THEN 10 WHEN 'parfums-de-linge' THEN 20 WHEN 'serums-cheveux' THEN 30 WHEN 'cremes' THEN 40 WHEN 'air-fresh' THEN 50 WHEN 'savons-mains' THEN 60 WHEN 'accessoires' THEN 70 ELSE 100 END AS sclr_4 FROM category c0_ ORDER BY sclr_4 ASC, c0_.id ASC;
|
| 5 |
0.21 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, CASE c0_.slug WHEN 'parfums' THEN 10 WHEN 'parfums-de-linge' THEN 20 WHEN 'serums-cheveux' THEN 30 WHEN 'cremes' THEN 40 WHEN 'air-fresh' THEN 50 WHEN 'savons-mains' THEN 60 WHEN 'accessoires' THEN 70 ELSE 100 END AS sclr_4 FROM category c0_ ORDER BY sclr_4 ASC, c0_.id ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, CASE c0_.slug WHEN 'parfums' THEN 10 WHEN 'parfums-de-linge' THEN 20 WHEN 'serums-cheveux' THEN 30 WHEN 'cremes' THEN 40 WHEN 'air-fresh' THEN 50 WHEN 'savons-mains' THEN 60 WHEN 'accessoires' THEN 70 ELSE 100 END AS sclr_4 FROM category c0_ ORDER BY sclr_4 ASC, c0_.id ASC;
|
| 6 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = 3;
|
| 7 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = 4;
|
| 8 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM brand t0 WHERE t0.id = 5;
|