Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

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

[
  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.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_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.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_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

[
  "vertical"
]

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

SELECT 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_.image_path AS image_path_6, c0_.banner_image_path AS banner_image_path_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE (c0_.is_active = 1 AND (((c0_.rgt < ? AND c0_.lft > ? AND c0_.tree_root = ?) OR c0_.id = ?))) AND (c0_.deleted_at IS NULL) ORDER BY c0_.tree_root ASC, c0_.lft ASC

[
  6
  5
  4
  12
]

SELECT
  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_.image_path AS image_path_6,
  c0_.banner_image_path AS banner_image_path_7,
  c0_.is_active AS is_active_8
FROM
  category c0_
WHERE
  (
    c0_.is_active = 1
    AND (
      (
        (
          c0_.rgt < ?
          AND c0_.lft > ?
          AND c0_.tree_root = ?
        )
        OR c0_.id = ?
      )
    )
  )
  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_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.image_path AS image_path_6, c0_.banner_image_path AS banner_image_path_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE (c0_.is_active = 1 AND (((c0_.rgt < 6 AND c0_.lft > 5 AND c0_.tree_root = 4) OR c0_.id = 12))) AND (c0_.deleted_at IS NULL) ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT c0_.id AS id_0 FROM product p1_ INNER JOIN category c0_ ON p1_.category_id = c0_.id AND (c0_.deleted_at IS NULL) AND (c0_.is_active = 1) WHERE (p1_.is_active = 1 AND p1_.brand_id = ? AND p1_.category_id IN (?)) AND (p1_.deleted_at IS NULL)

[
  1
  12
]

SELECT
  c0_.id AS id_0
FROM
  product p1_
  INNER JOIN category c0_ ON p1_.category_id = c0_.id
  AND (c0_.deleted_at IS NULL)
  AND (c0_.is_active = 1)
WHERE
  (
    p1_.is_active = 1
    AND p1_.brand_id = ?
    AND p1_.category_id IN (?)
  )
  AND (p1_.deleted_at IS NULL)

SELECT c0_.id AS id_0 FROM product p1_ INNER JOIN category c0_ ON p1_.category_id = c0_.id AND (c0_.deleted_at IS NULL) AND (c0_.is_active = 1) WHERE (p1_.is_active = 1 AND p1_.brand_id = 1 AND p1_.category_id IN (12)) AND (p1_.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 (NULL) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL)

[
  1
]

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 (NULL)
    AND p1_.brand_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 (NULL) AND p1_.brand_id IN (1)) 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 (NULL) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL) LIMIT 21

[
  1
]

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 (NULL)
    AND p1_.brand_id IN (?)
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  21

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 (NULL) AND p1_.brand_id IN (1)) AND (p0_.deleted_at IS NULL) LIMIT 21;

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 (NULL) AND p1_.brand_id IN (?)) AND (p0_.deleted_at IS NULL)

[
  1
]

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 (NULL)
    AND p1_.brand_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 (NULL) AND p1_.brand_id IN (1)) 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 <= 5 AND c0_.rgt >= 6 AND c0_.tree_root = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.lft ASC

[
  4
]

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