Symfony Profiler

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.name = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

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.name = 'samsung' AND ((t0.deleted_at IS NULL)) LIMIT 1;

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.slug IS NULL
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

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.slug IS NULL AND ((t0.deleted_at IS NULL)) LIMIT 1;

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_.brand_id = ?
    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_.brand_id = 1 AND b0_.page = 'brand') AND (b0_.deleted_at IS NULL) ORDER BY b0_.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 = ?
    AND c0_.brand_id = ?
  )
  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 = 'brand' AND c0_.brand_id = 1) AND (c0_.deleted_at IS NULL) ORDER BY c0_.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_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  AND (p1_.is_active = 1)
  INNER JOIN brand b2_ ON p1_.brand_id = b2_.id
  AND (b2_.deleted_at IS NULL)
  AND (b2_.is_active = 1)
WHERE
  (
    (
      p0_.is_active = 1
      AND p0_.is_choice_of_month = 1
    )
    AND b2_.slug = ?
  )
  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, p0_.product_id AS product_id_23 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 brand b2_ ON p1_.brand_id = b2_.id AND (b2_.deleted_at IS NULL) AND (b2_.is_active = 1) WHERE ((p0_.is_active = 1 AND p0_.is_choice_of_month = 1) AND b2_.slug = 'samsung') AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC;