Symfony Profiler

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;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.title_color AS title_color_2,
  b0_.title_animation AS title_animation_3,
  b0_.button_text AS button_text_4,
  b0_.button_text_color AS button_text_color_5,
  b0_.button_link AS button_link_6,
  b0_.button_color AS button_color_7,
  b0_.button_animation AS button_animation_8,
  b0_.description AS description_9,
  b0_.description_color AS description_color_10,
  b0_.description_animation AS description_animation_11,
  b0_.image_path AS image_path_12,
  b0_.is_active AS is_active_13,
  b0_.image_link AS image_link_14,
  b0_.position AS position_15,
  b0_.page AS page_16,
  b0_.column_grid AS column_grid_17,
  b0_.justify_content AS justify_content_18,
  b0_.align_items AS align_items_19,
  b0_.border AS border_20,
  b0_.margin AS margin_21,
  b0_.padding AS padding_22,
  b0_.created_at AS created_at_23,
  b0_.updated_at AS updated_at_24,
  b0_.deleted_at AS deleted_at_25,
  b0_.brand_id AS brand_id_26
FROM
  banner b0_
WHERE
  (
    b0_.is_active = 1
    AND b0_.page = ?
  )
  AND (b0_.deleted_at IS NULL)
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.title_color AS title_color_2, b0_.title_animation AS title_animation_3, b0_.button_text AS button_text_4, b0_.button_text_color AS button_text_color_5, b0_.button_link AS button_link_6, b0_.button_color AS button_color_7, b0_.button_animation AS button_animation_8, b0_.description AS description_9, b0_.description_color AS description_color_10, b0_.description_animation AS description_animation_11, b0_.image_path AS image_path_12, b0_.is_active AS is_active_13, b0_.image_link AS image_link_14, b0_.position AS position_15, b0_.page AS page_16, b0_.column_grid AS column_grid_17, b0_.justify_content AS justify_content_18, b0_.align_items AS align_items_19, b0_.border AS border_20, b0_.margin AS margin_21, b0_.padding AS padding_22, b0_.created_at AS created_at_23, b0_.updated_at AS updated_at_24, b0_.deleted_at AS deleted_at_25, b0_.brand_id AS brand_id_26 FROM banner b0_ WHERE (b0_.is_active = 1 AND b0_.page = 'home') AND (b0_.deleted_at IS NULL) ORDER BY b0_.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,
  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
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.title_color AS title_color_2,
  c0_.title_animation AS title_animation_3,
  c0_.button_text AS button_text_4,
  c0_.button_text_color AS button_text_color_5,
  c0_.button_link AS button_link_6,
  c0_.button_color AS button_color_7,
  c0_.button_animation AS button_animation_8,
  c0_.description AS description_9,
  c0_.description_color AS description_color_10,
  c0_.description_animation AS description_animation_11,
  c0_.image_path AS image_path_12,
  c0_.type AS type_13,
  c0_.is_active AS is_active_14,
  c0_.justify_content AS justify_content_15,
  c0_.align_items AS align_items_16,
  c0_.image_link AS image_link_17,
  c0_.page AS page_18,
  c0_.created_at AS created_at_19,
  c0_.updated_at AS updated_at_20,
  c0_.deleted_at AS deleted_at_21,
  c0_.brand_id AS brand_id_22
FROM
  carousel c0_
WHERE
  (
    c0_.is_active = 1
    AND c0_.page = ?
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.title_color AS title_color_2, c0_.title_animation AS title_animation_3, c0_.button_text AS button_text_4, c0_.button_text_color AS button_text_color_5, c0_.button_link AS button_link_6, c0_.button_color AS button_color_7, c0_.button_animation AS button_animation_8, c0_.description AS description_9, c0_.description_color AS description_color_10, c0_.description_animation AS description_animation_11, c0_.image_path AS image_path_12, c0_.type AS type_13, c0_.is_active AS is_active_14, c0_.justify_content AS justify_content_15, c0_.align_items AS align_items_16, c0_.image_link AS image_link_17, c0_.page AS page_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.deleted_at AS deleted_at_21, c0_.brand_id AS brand_id_22 FROM carousel c0_ WHERE (c0_.is_active = 1 AND c0_.page = 'home') AND (c0_.deleted_at IS NULL) ORDER BY c0_.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.is_active = ?
  AND t0.lvl = ?
  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.is_active = 1 AND t0.lvl = 0 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.is_active AS is_active_5,
  t0.image_path AS image_path_6,
  t0.is_visible AS is_visible_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  brand t0
WHERE
  t0.is_active = ?
  AND t0.is_visible = ?
  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.is_visible AS is_visible_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM brand t0 WHERE t0.is_active = 1 AND t0.is_visible = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id DESC;