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.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))

[
  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.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 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 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
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 ORDER BY c0_.tree_root ASC, c0_.lft ASC;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL)

[]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product_variant p0_
WHERE
  (p0_.is_active = 1)
  AND (p0_.deleted_at IS NULL)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL);

SELECT DISTINCT p0_.id AS id_0, p0_.final_price AS final_price_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC LIMIT 21 OFFSET 21

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.final_price AS final_price_1
FROM
  product_variant p0_
WHERE
  (p0_.is_active = 1)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.final_price DESC
LIMIT
  21 OFFSET 21

SELECT DISTINCT p0_.id AS id_0, p0_.final_price AS final_price_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC LIMIT 21 OFFSET 21;

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_ WHERE (p0_.is_active = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC

[
  203
  289
  290
  204
  96
  284
  381
  26
  385
  470
  356
  275
  440
  434
  359
  476
  478
  350
  360
  477
  313
]

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_
WHERE
  (
    p0_.is_active = 1
    AND p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.final_price DESC

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_ WHERE (p0_.is_active = 1 AND p0_.id IN (203, 289, 290, 204, 96, 284, 381, 26, 385, 470, 356, 275, 440, 434, 359, 476, 478, 350, 360, 477, 313)) AND (p0_.deleted_at IS NULL) ORDER BY p0_.final_price DESC;

SELECT MIN(p0_.final_price) AS sclr_0, MAX(p0_.final_price) AS sclr_1 FROM product_variant p0_ WHERE (p0_.is_active = 1) 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_
WHERE
  (p0_.is_active = 1)
  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_ WHERE (p0_.is_active = 1) AND (p0_.deleted_at IS NULL);