Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_color AS title_color_3,
  t0.title_animation AS title_animation_4,
  t0.button_text AS button_text_5,
  t0.button_text_color AS button_text_color_6,
  t0.button_link AS button_link_7,
  t0.button_color AS button_color_8,
  t0.button_animation AS button_animation_9,
  t0.description AS description_10,
  t0.description_color AS description_color_11,
  t0.description_animation AS description_animation_12,
  t0.image_path AS image_path_13,
  t0.type AS type_14,
  t0.is_active AS is_active_15,
  t0.justify_content AS justify_content_16,
  t0.align_items AS align_items_17,
  t0.image_link AS image_link_18,
  t0.page AS page_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.deleted_at AS deleted_at_22,
  t0.brand_id AS brand_id_23
FROM
  carousel t0
WHERE
  t0.page = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_color AS title_color_3, t0.title_animation AS title_animation_4, t0.button_text AS button_text_5, t0.button_text_color AS button_text_color_6, t0.button_link AS button_link_7, t0.button_color AS button_color_8, t0.button_animation AS button_animation_9, t0.description AS description_10, t0.description_color AS description_color_11, t0.description_animation AS description_animation_12, t0.image_path AS image_path_13, t0.type AS type_14, t0.is_active AS is_active_15, t0.justify_content AS justify_content_16, t0.align_items AS align_items_17, t0.image_link AS image_link_18, t0.page AS page_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.brand_id AS brand_id_23 FROM carousel t0 WHERE t0.page = 'home' AND t0.is_active = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_color AS title_color_3,
  t0.title_animation AS title_animation_4,
  t0.button_text AS button_text_5,
  t0.button_text_color AS button_text_color_6,
  t0.button_link AS button_link_7,
  t0.button_color AS button_color_8,
  t0.button_animation AS button_animation_9,
  t0.description AS description_10,
  t0.description_color AS description_color_11,
  t0.description_animation AS description_animation_12,
  t0.image_path AS image_path_13,
  t0.is_active AS is_active_14,
  t0.image_link AS image_link_15,
  t0.position AS position_16,
  t0.page AS page_17,
  t0.column_grid AS column_grid_18,
  t0.justify_content AS justify_content_19,
  t0.align_items AS align_items_20,
  t0.border AS border_21,
  t0.margin AS margin_22,
  t0.padding AS padding_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.deleted_at AS deleted_at_26,
  t0.brand_id AS brand_id_27
FROM
  banner t0
WHERE
  t0.page = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_color AS title_color_3, t0.title_animation AS title_animation_4, t0.button_text AS button_text_5, t0.button_text_color AS button_text_color_6, t0.button_link AS button_link_7, t0.button_color AS button_color_8, t0.button_animation AS button_animation_9, t0.description AS description_10, t0.description_color AS description_color_11, t0.description_animation AS description_animation_12, t0.image_path AS image_path_13, t0.is_active AS is_active_14, t0.image_link AS image_link_15, t0.position AS position_16, t0.page AS page_17, t0.column_grid AS column_grid_18, t0.justify_content AS justify_content_19, t0.align_items AS align_items_20, t0.border AS border_21, t0.margin AS margin_22, t0.padding AS padding_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26, t0.brand_id AS brand_id_27 FROM banner t0 WHERE t0.page = 'home' AND t0.is_active = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id DESC;

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.image_path AS image_path_6,
  t0.banner_image_path AS banner_image_path_7,
  t0.is_visible AS is_visible_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11
FROM
  brand t0
WHERE
  t0.is_visible = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id DESC

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.image_path AS image_path_6, t0.banner_image_path AS banner_image_path_7, t0.is_visible AS is_visible_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11 FROM brand t0 WHERE t0.is_visible = 1 AND t0.is_active = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.image_path AS image_path_8,
  t0.banner_image_path AS banner_image_path_9,
  t0.is_active AS is_active_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.tree_root AS tree_root_17,
  t0.parent_id AS parent_id_18
FROM
  category t0
WHERE
  t0.lvl = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.image_path AS image_path_8, t0.banner_image_path AS banner_image_path_9, t0.is_active AS is_active_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.tree_root AS tree_root_17, t0.parent_id AS parent_id_18 FROM category t0 WHERE t0.lvl = 0 AND t0.is_active = 1 AND ((t0.deleted_at IS NULL));

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.sku AS sku_3,
  p0_.is_new_arrival AS is_new_arrival_4,
  p0_.is_special_offer AS is_special_offer_5,
  p0_.is_choice_of_month AS is_choice_of_month_6,
  p0_.sale_price AS sale_price_7,
  p0_.solde_price AS solde_price_8,
  p0_.discount AS discount_9,
  p0_.final_price AS final_price_10,
  p0_.stock_quantity AS stock_quantity_11,
  p0_.more_description AS more_description_12,
  p0_.is_active AS is_active_13,
  p0_.short_description AS short_description_14,
  p0_.is_main AS is_main_15,
  p0_.meta_title AS meta_title_16,
  p0_.meta_description AS meta_description_17,
  p0_.meta_keywords AS meta_keywords_18,
  p0_.main_image_path AS main_image_path_19,
  p0_.created_at AS created_at_20,
  p0_.updated_at AS updated_at_21,
  p0_.deleted_at AS deleted_at_22,
  p0_.product_id AS product_id_23
FROM
  product_variant p0_
WHERE
  (
    p0_.is_active = 1
    AND p0_.is_special_offer = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC
LIMIT
  8

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sku AS sku_3, p0_.is_new_arrival AS is_new_arrival_4, p0_.is_special_offer AS is_special_offer_5, p0_.is_choice_of_month AS is_choice_of_month_6, p0_.sale_price AS sale_price_7, p0_.solde_price AS solde_price_8, p0_.discount AS discount_9, p0_.final_price AS final_price_10, p0_.stock_quantity AS stock_quantity_11, p0_.more_description AS more_description_12, p0_.is_active AS is_active_13, p0_.short_description AS short_description_14, p0_.is_main AS is_main_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.meta_keywords AS meta_keywords_18, p0_.main_image_path AS main_image_path_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.deleted_at AS deleted_at_22, p0_.product_id AS product_id_23 FROM product_variant p0_ WHERE (p0_.is_active = 1 AND p0_.is_special_offer = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC LIMIT 8;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.image_path AS image_path_7,
  c0_.banner_image_path AS banner_image_path_8,
  c0_.is_active AS is_active_9,
  c0_.meta_title AS meta_title_10,
  c0_.meta_description AS meta_description_11,
  c0_.meta_keywords AS meta_keywords_12,
  c0_.created_at AS created_at_13,
  c0_.updated_at AS updated_at_14,
  c0_.deleted_at AS deleted_at_15,
  c0_.tree_root AS tree_root_16,
  c0_.parent_id AS parent_id_17
FROM
  category c0_
WHERE
  (c0_.is_active = 1)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.image_path AS image_path_7, c0_.banner_image_path AS banner_image_path_8, c0_.is_active AS is_active_9, c0_.meta_title AS meta_title_10, c0_.meta_description AS meta_description_11, c0_.meta_keywords AS meta_keywords_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.deleted_at AS deleted_at_15, c0_.tree_root AS tree_root_16, c0_.parent_id AS parent_id_17 FROM category c0_ WHERE (c0_.is_active = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.sku AS sku_3,
  p0_.is_new_arrival AS is_new_arrival_4,
  p0_.is_special_offer AS is_special_offer_5,
  p0_.is_choice_of_month AS is_choice_of_month_6,
  p0_.sale_price AS sale_price_7,
  p0_.solde_price AS solde_price_8,
  p0_.discount AS discount_9,
  p0_.final_price AS final_price_10,
  p0_.stock_quantity AS stock_quantity_11,
  p0_.more_description AS more_description_12,
  p0_.is_active AS is_active_13,
  p0_.short_description AS short_description_14,
  p0_.is_main AS is_main_15,
  p0_.meta_title AS meta_title_16,
  p0_.meta_description AS meta_description_17,
  p0_.meta_keywords AS meta_keywords_18,
  p0_.main_image_path AS main_image_path_19,
  p0_.created_at AS created_at_20,
  p0_.updated_at AS updated_at_21,
  p0_.deleted_at AS deleted_at_22,
  p1_.id AS id_23,
  p1_.name AS name_24,
  p1_.slug AS slug_25,
  p1_.description AS description_26,
  p1_.is_active AS is_active_27,
  p1_.type AS type_28,
  p1_.created_at AS created_at_29,
  p1_.updated_at AS updated_at_30,
  p1_.deleted_at AS deleted_at_31,
  c2_.id AS id_32,
  c2_.name AS name_33,
  c2_.slug AS slug_34,
  c2_.description AS description_35,
  c2_.lft AS lft_36,
  c2_.lvl AS lvl_37,
  c2_.rgt AS rgt_38,
  c2_.image_path AS image_path_39,
  c2_.banner_image_path AS banner_image_path_40,
  c2_.is_active AS is_active_41,
  c2_.meta_title AS meta_title_42,
  c2_.meta_description AS meta_description_43,
  c2_.meta_keywords AS meta_keywords_44,
  c2_.created_at AS created_at_45,
  c2_.updated_at AS updated_at_46,
  c2_.deleted_at AS deleted_at_47,
  p0_.product_id AS product_id_48,
  p1_.brand_id AS brand_id_49,
  p1_.category_id AS category_id_50,
  c2_.tree_root AS tree_root_51,
  c2_.parent_id AS parent_id_52
FROM
  product_variant p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  AND (p1_.is_active = 1)
  INNER JOIN category c2_ ON p1_.category_id = c2_.id
  AND (c2_.deleted_at IS NULL)
  AND (c2_.is_active = 1)
WHERE
  (
    p0_.is_active = 1
    AND p0_.is_main = 1
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sku AS sku_3, p0_.is_new_arrival AS is_new_arrival_4, p0_.is_special_offer AS is_special_offer_5, p0_.is_choice_of_month AS is_choice_of_month_6, p0_.sale_price AS sale_price_7, p0_.solde_price AS solde_price_8, p0_.discount AS discount_9, p0_.final_price AS final_price_10, p0_.stock_quantity AS stock_quantity_11, p0_.more_description AS more_description_12, p0_.is_active AS is_active_13, p0_.short_description AS short_description_14, p0_.is_main AS is_main_15, p0_.meta_title AS meta_title_16, p0_.meta_description AS meta_description_17, p0_.meta_keywords AS meta_keywords_18, p0_.main_image_path AS main_image_path_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.deleted_at AS deleted_at_22, p1_.id AS id_23, p1_.name AS name_24, p1_.slug AS slug_25, p1_.description AS description_26, p1_.is_active AS is_active_27, p1_.type AS type_28, p1_.created_at AS created_at_29, p1_.updated_at AS updated_at_30, p1_.deleted_at AS deleted_at_31, c2_.id AS id_32, c2_.name AS name_33, c2_.slug AS slug_34, c2_.description AS description_35, c2_.lft AS lft_36, c2_.lvl AS lvl_37, c2_.rgt AS rgt_38, c2_.image_path AS image_path_39, c2_.banner_image_path AS banner_image_path_40, c2_.is_active AS is_active_41, c2_.meta_title AS meta_title_42, c2_.meta_description AS meta_description_43, c2_.meta_keywords AS meta_keywords_44, c2_.created_at AS created_at_45, c2_.updated_at AS updated_at_46, c2_.deleted_at AS deleted_at_47, p0_.product_id AS product_id_48, p1_.brand_id AS brand_id_49, p1_.category_id AS category_id_50, c2_.tree_root AS tree_root_51, c2_.parent_id AS parent_id_52 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id AND (p1_.deleted_at IS NULL) AND (p1_.is_active = 1) INNER JOIN category c2_ ON p1_.category_id = c2_.id AND (c2_.deleted_at IS NULL) AND (c2_.is_active = 1) WHERE (p0_.is_active = 1 AND p0_.is_main = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC;