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

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.lft AS lft_3,
  c0_.lvl AS lvl_4,
  c0_.rgt AS rgt_5,
  c0_.is_active AS is_active_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.tree_root AS tree_root_8
FROM
  category c0_
WHERE
  c0_.is_active = 1
  AND c0_.deleted_at IS NULL
  AND (
    (
      c0_.rgt < ?
      AND c0_.lft > ?
      AND c0_.tree_root = ?
    )
    OR c0_.id = ?
  )
ORDER BY
  c0_.tree_root ASC,
  c0_.lft ASC

SELECT DISTINCT
                c0_.id AS id_0,
                c0_.name AS name_1,
                c0_.slug AS slug_2,
                c0_.lft AS lft_3,
                c0_.lvl AS lvl_4,
                c0_.rgt AS rgt_5,
                c0_.is_active AS is_active_6,
                c0_.deleted_at AS deleted_at_7,
                c0_.tree_root AS tree_root_8
            FROM category c0_  WHERE c0_.is_active = 1 AND c0_.deleted_at IS NULL AND (
                        (c0_.rgt < 88 AND c0_.lft > 1 AND c0_.tree_root = 4)
                        OR c0_.id = 4
                    ) ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
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)
WHERE
  (
    p0_.is_active = 1
    AND p1_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 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) WHERE (p0_.is_active = 1 AND p1_.category_id IN (4, 6, 12, 13, 57, 7, 8, 9, 10, 11, 58, 59, 14, 19, 21, 15, 18, 22, 23, 24, 25, 16, 26, 27, 28, 29, 60, 61, 17, 30, 79, 80, 31, 32, 34, 35, 73)) AND (p0_.deleted_at IS NULL);

SELECT
  DISTINCT p0_.id AS id_0
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)
WHERE
  (
    p0_.is_active = 1
    AND p1_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  21 OFFSET 42

SELECT DISTINCT p0_.id AS id_0 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) WHERE (p0_.is_active = 1 AND p1_.category_id IN (4, 6, 12, 13, 57, 7, 8, 9, 10, 11, 58, 59, 14, 19, 21, 15, 18, 22, 23, 24, 25, 16, 26, 27, 28, 29, 60, 61, 17, 30, 79, 80, 31, 32, 34, 35, 73)) AND (p0_.deleted_at IS NULL) LIMIT 21 OFFSET 42;

SELECT
  p0_.id AS sclr_0,
  p0_.name AS sclr_1,
  p0_.slug AS sclr_2,
  p0_.sale_price AS sclr_3,
  p0_.solde_price AS sclr_4,
  p0_.discount AS sclr_5,
  p0_.final_price AS sclr_6,
  p0_.is_new_arrival AS sclr_7,
  p0_.is_special_offer AS sclr_8,
  p0_.main_image_path AS sclr_9
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)
WHERE
  (
    p0_.is_active = 1
    AND p1_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?
    )
    AND p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS sclr_0, p0_.name AS sclr_1, p0_.slug AS sclr_2, p0_.sale_price AS sclr_3, p0_.solde_price AS sclr_4, p0_.discount AS sclr_5, p0_.final_price AS sclr_6, p0_.is_new_arrival AS sclr_7, p0_.is_special_offer AS sclr_8, p0_.main_image_path AS sclr_9 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) WHERE (p0_.is_active = 1 AND p1_.category_id IN (4, 6, 12, 13, 57, 7, 8, 9, 10, 11, 58, 59, 14, 19, 21, 15, 18, 22, 23, 24, 25, 16, 26, 27, 28, 29, 60, 61, 17, 30, 79, 80, 31, 32, 34, 35, 73) AND p0_.id IN (73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 91, 92, 94, 123)) AND (p0_.deleted_at IS NULL);

SELECT
  MIN(p0_.final_price) AS sclr_0,
  MAX(p0_.final_price) AS sclr_1
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)
WHERE
  (
    p0_.is_active = 1
    AND p1_.category_id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)

SELECT MIN(p0_.final_price) AS sclr_0, MAX(p0_.final_price) AS sclr_1 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) WHERE (p0_.is_active = 1 AND p1_.category_id IN (4, 6, 12, 13, 57, 7, 8, 9, 10, 11, 58, 59, 14, 19, 21, 15, 18, 22, 23, 24, 25, 16, 26, 27, 28, 29, 60, 61, 17, 30, 79, 80, 31, 32, 34, 35, 73)) AND (p0_.deleted_at IS NULL);

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 <= 1
    AND c0_.rgt >= 88
    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 <= 1 AND c0_.rgt >= 88 AND c0_.tree_root = 4) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC;