| 1 |
0.34 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.32 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.28 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.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 ORDER BY t0.id ASC;
|
| 5 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM category t0 ORDER BY t0.id ASC;
|
| 6 |
0.28 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 = 1;
|
| 7 |
0.20 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 = 2;
|
| 8 |
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 = 3;
|
| 9 |
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 = 4;
|
| 10 |
0.19 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;
|