Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.reference AS reference_3,
  p0_.weight AS weight_4,
  p0_.is_promoted AS is_promoted_5,
  p0_.promoted_price_htva AS promoted_price_htva_6,
  p0_.max_qtty_allowed AS max_qtty_allowed_7,
  p0_.is_used AS is_used_8,
  p0_.is_visible AS is_visible_9,
  p0_.is_best_seller AS is_best_seller_10,
  p0_.image AS image_11,
  p0_.gallery AS gallery_12,
  p0_.price_htva AS price_htva_13,
  p0_.slug AS slug_14,
  p0_.stock AS stock_15,
  p0_.is_koi AS is_koi_16,
  p0_.youtube_link AS youtube_link_17,
  p0_.is_pre_order AS is_pre_order_18,
  p0_.pre_order_date AS pre_order_date_19,
  p0_.pre_order_disable_by_cron AS pre_order_disable_by_cron_20,
  p0_.created_by AS created_by_21,
  p0_.updated_by AS updated_by_22,
  p0_.deleted_at AS deleted_at_23,
  p0_.created_at AS created_at_24,
  p0_.updated_at AS updated_at_25,
  p0_.category_id AS category_id_26,
  p0_.brand_id AS brand_id_27
FROM
  product p0_
WHERE
  (
    p0_.id IN (?)
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  8

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.reference AS reference_3, p0_.weight AS weight_4, p0_.is_promoted AS is_promoted_5, p0_.promoted_price_htva AS promoted_price_htva_6, p0_.max_qtty_allowed AS max_qtty_allowed_7, p0_.is_used AS is_used_8, p0_.is_visible AS is_visible_9, p0_.is_best_seller AS is_best_seller_10, p0_.image AS image_11, p0_.gallery AS gallery_12, p0_.price_htva AS price_htva_13, p0_.slug AS slug_14, p0_.stock AS stock_15, p0_.is_koi AS is_koi_16, p0_.youtube_link AS youtube_link_17, p0_.is_pre_order AS is_pre_order_18, p0_.pre_order_date AS pre_order_date_19, p0_.pre_order_disable_by_cron AS pre_order_disable_by_cron_20, p0_.created_by AS created_by_21, p0_.updated_by AS updated_by_22, p0_.deleted_at AS deleted_at_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p0_.category_id AS category_id_26, p0_.brand_id AS brand_id_27 FROM product p0_ WHERE (p0_.id IN (9, 15, 17, 22, 25, 33, 46, 52)) AND (p0_.deleted_at IS NULL) LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.logo AS logo_4,
  t0.is_visible AS is_visible_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  brand t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.is_visible AS is_visible_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM brand t0 WHERE t0.id = 4 AND ((t0.deleted_at IS NULL));

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  (
    p0_.is_visible = 1
    AND p0_.is_best_seller = 1
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  8

SELECT p0_.id AS id_0 FROM product p0_ WHERE (p0_.is_visible = 1 AND p0_.is_best_seller = 1) AND (p0_.deleted_at IS NULL) LIMIT 8;

SELECT
  p0_.id AS id_0,
  p0_.promo_type AS promo_type_1,
  p0_.promo_nb_usage AS promo_nb_usage_2,
  p0_.promo_end_date AS promo_end_date_3,
  p0_.promo_amount AS promo_amount_4,
  p0_.promo_rate AS promo_rate_5,
  p0_.enabled AS enabled_6,
  p0_.current_nb_usage AS current_nb_usage_7,
  p0_.promo_end_type AS promo_end_type_8,
  p0_.code AS code_9,
  p0_.from_big_order AS from_big_order_10,
  p0_.created_by AS created_by_11,
  p0_.updated_by AS updated_by_12,
  p0_.deleted_at AS deleted_at_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15
FROM
  promo p0_
WHERE
  (
    (
      p0_.from_big_order = 0
      OR p0_.from_big_order IS NULL
    )
    AND p0_.enabled = 1
    AND (
      p0_.promo_end_type LIKE ?
      AND p0_.promo_end_date > ?
    )
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.promo_type AS promo_type_1, p0_.promo_nb_usage AS promo_nb_usage_2, p0_.promo_end_date AS promo_end_date_3, p0_.promo_amount AS promo_amount_4, p0_.promo_rate AS promo_rate_5, p0_.enabled AS enabled_6, p0_.current_nb_usage AS current_nb_usage_7, p0_.promo_end_type AS promo_end_type_8, p0_.code AS code_9, p0_.from_big_order AS from_big_order_10, p0_.created_by AS created_by_11, p0_.updated_by AS updated_by_12, p0_.deleted_at AS deleted_at_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15 FROM promo p0_ WHERE ((p0_.from_big_order = 0 OR p0_.from_big_order IS NULL) AND p0_.enabled = 1 AND (p0_.promo_end_type LIKE '%date%' AND p0_.promo_end_date > '2026-01-13 02:31:17')) AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.reference AS reference_3,
  p0_.weight AS weight_4,
  p0_.is_promoted AS is_promoted_5,
  p0_.promoted_price_htva AS promoted_price_htva_6,
  p0_.max_qtty_allowed AS max_qtty_allowed_7,
  p0_.is_used AS is_used_8,
  p0_.is_visible AS is_visible_9,
  p0_.is_best_seller AS is_best_seller_10,
  p0_.image AS image_11,
  p0_.gallery AS gallery_12,
  p0_.price_htva AS price_htva_13,
  p0_.slug AS slug_14,
  p0_.stock AS stock_15,
  p0_.is_koi AS is_koi_16,
  p0_.youtube_link AS youtube_link_17,
  p0_.is_pre_order AS is_pre_order_18,
  p0_.pre_order_date AS pre_order_date_19,
  p0_.pre_order_disable_by_cron AS pre_order_disable_by_cron_20,
  p0_.created_by AS created_by_21,
  p0_.updated_by AS updated_by_22,
  p0_.deleted_at AS deleted_at_23,
  p0_.created_at AS created_at_24,
  p0_.updated_at AS updated_at_25,
  p0_.category_id AS category_id_26,
  p0_.brand_id AS brand_id_27
FROM
  product p0_
WHERE
  (
    p0_.id IN (?)
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.reference AS reference_3, p0_.weight AS weight_4, p0_.is_promoted AS is_promoted_5, p0_.promoted_price_htva AS promoted_price_htva_6, p0_.max_qtty_allowed AS max_qtty_allowed_7, p0_.is_used AS is_used_8, p0_.is_visible AS is_visible_9, p0_.is_best_seller AS is_best_seller_10, p0_.image AS image_11, p0_.gallery AS gallery_12, p0_.price_htva AS price_htva_13, p0_.slug AS slug_14, p0_.stock AS stock_15, p0_.is_koi AS is_koi_16, p0_.youtube_link AS youtube_link_17, p0_.is_pre_order AS is_pre_order_18, p0_.pre_order_date AS pre_order_date_19, p0_.pre_order_disable_by_cron AS pre_order_disable_by_cron_20, p0_.created_by AS created_by_21, p0_.updated_by AS updated_by_22, p0_.deleted_at AS deleted_at_23, p0_.created_at AS created_at_24, p0_.updated_at AS updated_at_25, p0_.category_id AS category_id_26, p0_.brand_id AS brand_id_27 FROM product p0_ WHERE (p0_.id IN (12, 13, 17, 36, 37, 96, 119, 137)) AND (p0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0
FROM
  product p0_
WHERE
  (
    p0_.is_visible = 1
    AND (
      (
        p0_.is_promoted = 1
        OR p0_.is_used = 1
      )
    )
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  8

SELECT p0_.id AS id_0 FROM product p0_ WHERE (p0_.is_visible = 1 AND ((p0_.is_promoted = 1 OR p0_.is_used = 1))) AND (p0_.deleted_at IS NULL) LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.gallery AS gallery_5,
  t0.slug AS slug_6,
  t0.is_visible AS is_visible_7,
  t0.youtube_link AS youtube_link_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_at AS deleted_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  showcase t0
WHERE
  t0.is_visible = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.gallery AS gallery_5, t0.slug AS slug_6, t0.is_visible AS is_visible_7, t0.youtube_link AS youtube_link_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM showcase t0 WHERE t0.is_visible = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.created_at DESC LIMIT 3;