| 1 |
8.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.is_featured = ? AND t0.is_active = ? ORDER BY t0.id DESC LIMIT 8
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.is_featured = 1 AND t0.is_active = 1 ORDER BY t0.id DESC LIMIT 8;
|
| 2 |
7.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = 1;
|
| 3 |
1.17 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.image AS image_3, b0_.button_text AS button_text_4, b0_.button_link AS button_link_5, b0_.position AS position_6, b0_.is_active AS is_active_7, b0_.overlay_color AS overlay_color_8 FROM banner b0_ WHERE b0_.is_active = 1 ORDER BY b0_.position ASC
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.image AS image_3, b0_.button_text AS button_text_4, b0_.button_link AS button_link_5, b0_.position AS position_6, b0_.is_active AS is_active_7, b0_.overlay_color AS overlay_color_8 FROM banner b0_ WHERE b0_.is_active = 1 ORDER BY b0_.position ASC;
|
| 4 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.name ASC;
|
| 5 |
1.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = 11;
|
| 6 |
1.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.category_id = 12;
|
| 7 |
11.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.category_id = 11;
|
| 8 |
13.01 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price AS price_5, t0.stock AS stock_6, t0.main_image AS main_image_7, t0.images AS images_8, t0.is_active AS is_active_9, t0.is_featured AS is_featured_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.weight AS weight_13, t0.category_id AS category_id_14, t0.sub_category_id AS sub_category_id_15 FROM product t0 WHERE t0.category_id = 12;
|