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,
  b3_.id AS id_48,
  b3_.name AS name_49,
  b3_.slug AS slug_50,
  b3_.description AS description_51,
  b3_.is_active AS is_active_52,
  b3_.image_path AS image_path_53,
  b3_.banner_image_path AS banner_image_path_54,
  b3_.is_visible AS is_visible_55,
  b3_.created_at AS created_at_56,
  b3_.updated_at AS updated_at_57,
  b3_.deleted_at AS deleted_at_58,
  p0_.product_id AS product_id_59,
  p1_.brand_id AS brand_id_60,
  p1_.category_id AS category_id_61,
  c2_.tree_root AS tree_root_62,
  c2_.parent_id AS parent_id_63
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)
  LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id
  AND (b3_.deleted_at IS NULL)
  AND (b3_.is_active = 1)
WHERE
  (
    p0_.is_active = 1
    AND p0_.slug = ?
  )
  AND (p0_.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, 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, b3_.id AS id_48, b3_.name AS name_49, b3_.slug AS slug_50, b3_.description AS description_51, b3_.is_active AS is_active_52, b3_.image_path AS image_path_53, b3_.banner_image_path AS banner_image_path_54, b3_.is_visible AS is_visible_55, b3_.created_at AS created_at_56, b3_.updated_at AS updated_at_57, b3_.deleted_at AS deleted_at_58, p0_.product_id AS product_id_59, p1_.brand_id AS brand_id_60, p1_.category_id AS category_id_61, c2_.tree_root AS tree_root_62, c2_.parent_id AS parent_id_63 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) LEFT JOIN brand b3_ ON p1_.brand_id = b3_.id AND (b3_.deleted_at IS NULL) AND (b3_.is_active = 1) WHERE (p0_.is_active = 1 AND p0_.slug = 'samsung-a14-128gb') AND (p0_.deleted_at IS NULL);

SELECT
  c0_.id AS id_0
FROM
  category c0_
WHERE
  (
    c0_.tree_root = ?
    AND (
      (
        c0_.lft <= ?
        AND c0_.rgt >= ?
      )
      OR (
        c0_.lft >= ?
        AND c0_.rgt <= ?
      )
    )
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0 FROM category c0_ WHERE (c0_.tree_root = 5 AND ((c0_.lft <= 2 AND c0_.rgt >= 3) OR (c0_.lft >= 2 AND c0_.rgt <= 3))) 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,
  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 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 c2_.id IN (?, ?)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC
LIMIT
  5

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 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 c2_.id IN (5, 40)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC LIMIT 5;

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_.lft <= 2
    AND c0_.rgt >= 3
    AND c0_.tree_root = ?
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  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_.lft <= 2 AND c0_.rgt >= 3 AND c0_.tree_root = 5) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.type AS type_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.product_variant_id AS product_variant_id_7
FROM
  product_variant_image t0
WHERE
  t0.product_variant_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_image t0 WHERE t0.product_variant_id = 102 AND ((t0.deleted_at IS NULL));