Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.slug AS slug_3,
  p0_.image_bkg AS image_bkg_4,
  p0_.header_image AS header_image_5,
  p0_.subtitle AS subtitle_6,
  p0_.is_home AS is_home_7,
  p0_.header_type AS header_type_8,
  p0_.header_detail AS header_detail_9,
  p0_.keywords AS keywords_10,
  p0_.transparent_menu AS transparent_menu_11,
  p0_.content AS content_12,
  p0_.is_deleted AS is_deleted_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15
FROM
  page p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.is_home = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.image_bkg AS image_bkg_4, p0_.header_image AS header_image_5, p0_.subtitle AS subtitle_6, p0_.is_home AS is_home_7, p0_.header_type AS header_type_8, p0_.header_detail AS header_detail_9, p0_.keywords AS keywords_10, p0_.transparent_menu AS transparent_menu_11, p0_.content AS content_12, p0_.is_deleted AS is_deleted_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15 FROM page p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.is_home = 1;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.options AS options_3,
  f0_.price AS price_4,
  f0_.is_subscription_open AS is_subscription_open_5,
  f0_.payment_configuration AS payment_configuration_6,
  f0_.price_ht AS price_ht_7,
  f0_.is_in_top_bar AS is_in_top_bar_8,
  f0_.top_bar_message AS top_bar_message_9,
  f0_.is_deleted AS is_deleted_10,
  f0_.created_at AS created_at_11,
  f0_.updated_at AS updated_at_12,
  f0_.subscription_class_id AS subscription_class_id_13,
  f0_.product_type_id AS product_type_id_14
FROM
  formation f0_
WHERE
  COALESCE(f0_.is_deleted, 0) = 0
  AND f0_.is_in_top_bar = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = 1;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'sliderBanner';

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.title AS title_2,
  b0_.image AS image_3,
  b0_.bkg AS bkg_4,
  b0_.is_visible AS is_visible_5,
  b0_.full_content AS full_content_6,
  b0_.with_text AS with_text_7,
  b0_.type AS type_8,
  b0_.overlay_background AS overlay_background_9,
  b0_.text AS text_10,
  b0_.link_type AS link_type_11,
  b0_.link_text AS link_text_12,
  b0_.bkg_color AS bkg_color_13,
  b0_.bkg_video AS bkg_video_14,
  b0_.link AS link_15,
  b0_.is_deleted AS is_deleted_16,
  b0_.created_at AS created_at_17,
  b0_.updated_at AS updated_at_18
FROM
  banner b0_
WHERE
  COALESCE(b0_.is_deleted, 0) = 0
  AND b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.image AS image_3, b0_.bkg AS bkg_4, b0_.is_visible AS is_visible_5, b0_.full_content AS full_content_6, b0_.with_text AS with_text_7, b0_.type AS type_8, b0_.overlay_background AS overlay_background_9, b0_.text AS text_10, b0_.link_type AS link_type_11, b0_.link_text AS link_text_12, b0_.bkg_color AS bkg_color_13, b0_.bkg_video AS bkg_video_14, b0_.link AS link_15, b0_.is_deleted AS is_deleted_16, b0_.created_at AS created_at_17, b0_.updated_at AS updated_at_18 FROM banner b0_ WHERE COALESCE(b0_.is_deleted, 0) = 0 AND b0_.id IN (1);

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'title';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'text';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'button';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'image';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'title';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'textList';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'title';

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'products';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.thumb AS thumb_2,
  p0_.description AS description_3,
  p0_.slug AS slug_4,
  p0_.principal_image AS principal_image_5,
  p0_.is_sold AS is_sold_6,
  p0_.top_position AS top_position_7,
  p0_.is_enabled AS is_enabled_8,
  p0_.keywords AS keywords_9,
  p0_.price AS price_10,
  p0_.price_ht AS price_ht_11,
  p0_.properties AS properties_12,
  p0_.max_cart_quantity AS max_cart_quantity_13,
  p0_.weight AS weight_14,
  p0_.variations AS variations_15,
  p0_.is_deleted AS is_deleted_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p0_.product_type_id AS product_type_id_19,
  p0_.author_id AS author_id_20
FROM
  product p0_
WHERE
  COALESCE(p0_.is_enabled, 1) = 1
ORDER BY
  RAND() ASC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.thumb AS thumb_2, p0_.description AS description_3, p0_.slug AS slug_4, p0_.principal_image AS principal_image_5, p0_.is_sold AS is_sold_6, p0_.top_position AS top_position_7, p0_.is_enabled AS is_enabled_8, p0_.keywords AS keywords_9, p0_.price AS price_10, p0_.price_ht AS price_ht_11, p0_.properties AS properties_12, p0_.max_cart_quantity AS max_cart_quantity_13, p0_.weight AS weight_14, p0_.variations AS variations_15, p0_.is_deleted AS is_deleted_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.product_type_id AS product_type_id_19, p0_.author_id AS author_id_20 FROM product p0_ WHERE COALESCE(p0_.is_enabled, 1) = 1 ORDER BY RAND() ASC LIMIT 3;

SELECT
  pt.id,
  pt.name,
  pt.data,
  pt.type,
  CASE WHEN pt.type = 'PromotionProduct' THEN
    999
  ELSE
    1
  END AS priority,
  pt.date_end AS dateEnd
FROM
  promotion pt
WHERE
  pt.date_end > ?
  AND (
    (
      pt.type = 'PromotionProduct'
      AND CAST(
        JSON_UNQUOTE(
          JSON_EXTRACT(pt.data, '$.product')
        ) AS UNSIGNED
      ) IN (?, ?)
    )
    OR pt.type IN (
      'PromotionProductType', 'PromotionCategory',
      'PromotionProductGroup'
    )
  )

SELECT pt.id, pt.name, pt.data, pt.type, 
                   CASE WHEN pt.type = 'PromotionProduct' THEN 999 ELSE 1 END AS priority,
                   pt.date_end AS dateEnd
            FROM promotion pt
            WHERE pt.date_end > '2026-06-22'
              AND (
                (
                  pt.type = 'PromotionProduct'
                  AND CAST(JSON_UNQUOTE(JSON_EXTRACT(pt.data, '$.product')) AS UNSIGNED) IN (18,17)
                )
                OR pt.type IN ('PromotionProductType', 'PromotionCategory', 'PromotionProductGroup')
              )
        ;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.data AS data_2,
  p0_.type AS type_3,
  CASE WHEN p0_.type = 'PromotionProduct' THEN
    999
  ELSE
    1
  END AS sclr_4,
  p0_.date_end AS date_end_5
FROM
  promotion p0_
WHERE
  (
    p0_.type = 'PromotionProductType'
    AND p0_.date_end >= ?
  )
  OR (
    p0_.type = 'PromotionProductGroup'
    AND p0_.date_end >= ?
  )
  OR (
    p0_.type = 'PromotionCategory'
    AND p0_.date_end >= ?
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.data AS data_2, p0_.type AS type_3, CASE WHEN p0_.type = 'PromotionProduct' THEN 999 ELSE 1 END AS sclr_4, p0_.date_end AS date_end_5 FROM promotion p0_ WHERE (p0_.type = 'PromotionProductType' AND p0_.date_end >= '2026-06-22 18:23:59') OR (p0_.type = 'PromotionProductGroup' AND p0_.date_end >= '2026-06-22 18:23:59') OR (p0_.type = 'PromotionCategory' AND p0_.date_end >= '2026-06-22 18:23:59');

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone_number AS phone_number_7,
  t0.country AS country_8,
  t0.username AS username_9,
  t0.last_login AS last_login_10,
  t0.properties AS properties_11,
  t0.is_active AS is_active_12,
  t0.verified_token AS verified_token_13,
  t0.is_deleted AS is_deleted_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.country AS country_8, t0.username AS username_9, t0.last_login AS last_login_10, t0.properties AS properties_11, t0.is_active AS is_active_12, t0.verified_token AS verified_token_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM `user` t0 WHERE t0.id = 24;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_deleted AS is_deleted_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.parent_id AS parent_id_9,
  t0.product_link_id AS product_link_id_10
FROM
  category t0
  INNER JOIN product_category ON t0.id = product_category.category_id
WHERE
  product_category.product_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9, t0.product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 18;