Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.menu_order AS menu_order_3,
  t0.is_enabled AS is_enabled_4
FROM
  application t0
WHERE
  t0.is_enabled = ?
ORDER BY
  t0.menu_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_order AS menu_order_3, t0.is_enabled AS is_enabled_4 FROM application t0 WHERE t0.is_enabled = 1 ORDER BY t0.menu_order ASC;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  front_theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM front_theme t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.description AS description_4,
  t0.store_type AS store_type_5,
  t0.city_id AS city_id_6,
  t0.user_id AS user_id_7,
  t0.city_region_id AS city_region_id_8
FROM
  store t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.description AS description_4, t0.store_type AS store_type_5, t0.city_id AS city_id_6, t0.user_id AS user_id_7, t0.city_region_id AS city_region_id_8 FROM store t0 WHERE t0.id = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.description AS description_4,
  t0.store_type AS store_type_5,
  t0.city_id AS city_id_6,
  t0.user_id AS user_id_7,
  t0.city_region_id AS city_region_id_8
FROM
  store t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.description AS description_4, t0.store_type AS store_type_5, t0.city_id AS city_id_6, t0.user_id AS user_id_7, t0.city_region_id AS city_region_id_8 FROM store t0;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  YEAR(o0_.created_at) AS sclr_0,
  MONTH(o0_.created_at) AS sclr_1
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    (
      o0_.store_id = ?
      OR ? IS NULL
    )
  )
  AND (o0_.deleted_at IS NULL)
ORDER BY
  sclr_0 DESC,
  sclr_1 ASC

SELECT YEAR(o0_.created_at) AS sclr_0, MONTH(o0_.created_at) AS sclr_1 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE ((o0_.store_id = NULL OR NULL IS NULL)) AND (o0_.deleted_at IS NULL) ORDER BY sclr_0 DESC, sclr_1 ASC;

SELECT
  YEAR(o0_.created_at) AS sclr_0,
  MONTH(o0_.created_at) AS sclr_1
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    (
      o0_.store_id = ?
      OR ? IS NULL
    )
  )
  AND (o0_.deleted_at IS NULL)
ORDER BY
  sclr_0 DESC,
  sclr_1 ASC

SELECT YEAR(o0_.created_at) AS sclr_0, MONTH(o0_.created_at) AS sclr_1 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE ((o0_.store_id = NULL OR NULL IS NULL)) AND (o0_.deleted_at IS NULL) ORDER BY sclr_0 DESC, sclr_1 ASC;

SELECT
  SUM(p0_.amount) AS sclr_0,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_2,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_3,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_4,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_5
FROM
  `order` o2_
  LEFT JOIN document d3_ ON o2_.id = d3_.id
  INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id
  INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id
WHERE
  (
    (
      o2_.store_id = ?
      OR ? IS NULL
    )
    AND c1_.id IS NOT NULL
    AND (
      YEAR(c1_.start_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c1_.start_at) = ?
      OR ? IS NULL
    )
  )
  AND (o2_.deleted_at IS NULL)

SELECT SUM(p0_.amount) AS sclr_0, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-18 18:17:21' AND '2025-08-30 18:17:21' THEN p0_.amount ELSE 0 END) AS sclr_1, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 18:17:21' AND '2025-08-30 18:17:21' THEN p0_.amount ELSE 0 END) AS sclr_2, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-30 00:00:00' AND '2025-08-31 00:00:00' THEN p0_.amount ELSE 0 END) AS sclr_3, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-29 00:00:00' AND '2025-08-29 23:59:59' THEN p0_.amount ELSE 0 END) AS sclr_4, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 00:00:00' AND '2025-08-30 18:17:21' THEN p0_.amount ELSE 0 END) AS sclr_5 FROM `order` o2_ LEFT JOIN document d3_ ON o2_.id = d3_.id INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id WHERE ((o2_.store_id = NULL OR NULL IS NULL) AND c1_.id IS NOT NULL AND (YEAR(c1_.start_at) = NULL OR NULL IS NULL) AND (MONTH(c1_.start_at) = NULL OR NULL IS NULL)) AND (o2_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  SUM(p0_.amount) AS sclr_0,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_2,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_3,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_4,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_5
FROM
  `order` o2_
  LEFT JOIN document d3_ ON o2_.id = d3_.id
  INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id
  INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id
WHERE
  (
    (
      o2_.store_id = ?
      OR ? IS NULL
    )
    AND c1_.id IS NOT NULL
    AND (
      YEAR(c1_.start_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c1_.start_at) = ?
      OR ? IS NULL
    )
  )
  AND (o2_.deleted_at IS NULL)

SELECT SUM(p0_.amount) AS sclr_0, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-18 18:17:22' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_1, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 18:17:22' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_2, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-30 00:00:00' AND '2025-08-31 00:00:00' THEN p0_.amount ELSE 0 END) AS sclr_3, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-29 00:00:00' AND '2025-08-29 23:59:59' THEN p0_.amount ELSE 0 END) AS sclr_4, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 00:00:00' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_5 FROM `order` o2_ LEFT JOIN document d3_ ON o2_.id = d3_.id INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id WHERE ((o2_.store_id = NULL OR NULL IS NULL) AND c1_.id IS NOT NULL AND (YEAR(c1_.start_at) = NULL OR NULL IS NULL) AND (MONTH(c1_.start_at) = NULL OR NULL IS NULL)) AND (o2_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  SUM(p0_.amount) AS sclr_0,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_2,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_3,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_4,
  SUM(
    CASE WHEN c1_.start_at BETWEEN ?
    AND ? THEN p0_.amount ELSE 0 END
  ) AS sclr_5
FROM
  `order` o2_
  LEFT JOIN document d3_ ON o2_.id = d3_.id
  INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id
  INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id
WHERE
  (
    (
      o2_.store_id = ?
      OR ? IS NULL
    )
    AND c1_.id IS NOT NULL
    AND (
      YEAR(c1_.start_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c1_.start_at) = ?
      OR ? IS NULL
    )
  )
  AND (o2_.deleted_at IS NULL)

SELECT SUM(p0_.amount) AS sclr_0, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-18 18:17:22' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_1, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 18:17:22' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_2, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-30 00:00:00' AND '2025-08-31 00:00:00' THEN p0_.amount ELSE 0 END) AS sclr_3, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-29 00:00:00' AND '2025-08-29 23:59:59' THEN p0_.amount ELSE 0 END) AS sclr_4, SUM(CASE WHEN c1_.start_at BETWEEN '2025-08-01 00:00:00' AND '2025-08-30 18:17:22' THEN p0_.amount ELSE 0 END) AS sclr_5 FROM `order` o2_ LEFT JOIN document d3_ ON o2_.id = d3_.id INNER JOIN payment p0_ ON o2_.id = p0_.related_order_id INNER JOIN cash_box_order c1_ ON o2_.cash_box_order_id = c1_.id WHERE ((o2_.store_id = NULL OR NULL IS NULL) AND c1_.id IS NOT NULL AND (YEAR(c1_.start_at) = NULL OR NULL IS NULL) AND (MONTH(c1_.start_at) = NULL OR NULL IS NULL)) AND (o2_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  DATE(o0_.created_at) AS sclr_0,
  AVG(o1_.price * o1_.quantity) AS sclr_1
FROM
  order_item o1_
  LEFT JOIN stock s2_ ON o1_.id = s2_.id
  INNER JOIN `order` o0_ ON o1_.parent_order_id = o0_.id
  AND (o0_.deleted_at IS NULL)
  LEFT JOIN document d3_ ON o0_.id = d3_.id
GROUP BY
  sclr_0

SELECT DATE(o0_.created_at) AS sclr_0, AVG(o1_.price * o1_.quantity) AS sclr_1 FROM order_item o1_ LEFT JOIN stock s2_ ON o1_.id = s2_.id INNER JOIN `order` o0_ ON o1_.parent_order_id = o0_.id AND (o0_.deleted_at IS NULL) LEFT JOIN document d3_ ON o0_.id = d3_.id GROUP BY sclr_0;