Symfony Profiler

SELECT
  SUM(
    CASE WHEN v0_.manual = 0
    OR v0_.manual IS NULL THEN 1 ELSE 0 END
  ) AS sclr_0,
  SUM(
    CASE WHEN v0_.manual = 1 THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN v0_.manual = 0
    OR v0_.manual IS NULL
    AND c1_.gender = 'female' THEN 1 ELSE 0 END
  ) AS sclr_2,
  SUM(
    CASE WHEN v0_.manual = 1
    AND c1_.gender = 'female' THEN 1 ELSE 0 END
  ) AS sclr_3,
  SUM(
    CASE WHEN v0_.manual = 0
    OR v0_.manual IS NULL
    AND c1_.gender = 'male' THEN 1 ELSE 0 END
  ) AS sclr_4,
  SUM(
    CASE WHEN v0_.manual = 1
    AND c1_.gender = 'male' THEN 1 ELSE 0 END
  ) AS sclr_5
FROM
  visit v0_
  LEFT JOIN customer c1_ ON (v0_.customer_id = c1_.id)
  AND (c1_.deleted_at IS NULL)
WHERE
  v0_.created_at >= ?
  AND v0_.created_at < ?
LIMIT
  12

SELECT SUM(CASE WHEN v0_.manual = 0 OR v0_.manual IS NULL THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN v0_.manual = 1 THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN v0_.manual = 0 OR v0_.manual IS NULL AND c1_.gender = 'female' THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN v0_.manual = 1 AND c1_.gender = 'female' THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN v0_.manual = 0 OR v0_.manual IS NULL AND c1_.gender = 'male' THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN v0_.manual = 1 AND c1_.gender = 'male' THEN 1 ELSE 0 END) AS sclr_5 FROM visit v0_ LEFT JOIN customer c1_ ON (v0_.customer_id = c1_.id) AND (c1_.deleted_at IS NULL) WHERE v0_.created_at >= '2025-08-29 00:00' AND v0_.created_at < '2025-08-30 00:00' LIMIT 12;

SELECT
  SUM(
    CASE WHEN v0_.manual = 0
    OR v0_.manual IS NULL THEN 1 ELSE 0 END
  ) AS sclr_0,
  SUM(
    CASE WHEN v0_.manual = 1 THEN 1 ELSE 0 END
  ) AS sclr_1,
  DATE_FORMAT(v0_.created_at, '%M') AS sclr_2,
  YEAR(CURRENT_DATE) AS sclr_3
FROM
  visit v0_
WHERE
  YEAR(v0_.created_at) = YEAR(CURRENT_DATE)
GROUP BY
  sclr_2
LIMIT
  12

SELECT SUM(CASE WHEN v0_.manual = 0 OR v0_.manual IS NULL THEN 1 ELSE 0 END) AS sclr_0, SUM(CASE WHEN v0_.manual = 1 THEN 1 ELSE 0 END) AS sclr_1, DATE_FORMAT(v0_.created_at, '%M') AS sclr_2, YEAR(CURRENT_DATE) AS sclr_3 FROM visit v0_ WHERE YEAR(v0_.created_at) = YEAR(CURRENT_DATE) GROUP BY sclr_2 LIMIT 12;

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
  COUNT(c0_.id) AS sclr_0
FROM
  customer c0_
WHERE
  (
    (
      YEAR(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      SELECT
        COUNT(o1_.id) AS sclr_1
      FROM
        `order` o1_
        LEFT JOIN document d2_ ON o1_.id = d2_.id
      WHERE
        (
          o1_.customer_id = c0_.id
          AND NOT EXISTS (
            SELECT
              o1_.id
            FROM
              order_item o3_
              LEFT JOIN stock s4_ ON o3_.id = s4_.id
              INNER JOIN product p5_ ON o3_.product_id = p5_.id
              AND (p5_.deleted_at IS NULL)
              LEFT JOIN article a6_ ON p5_.id = a6_.id
              LEFT JOIN shop_product s7_ ON p5_.id = s7_.id
            WHERE
              o3_.parent_order_id = o1_.id
              AND p5_.name IN (?, ?)
          )
        )
        AND (o1_.deleted_at IS NULL)
    ) > 1
  )
  AND (c0_.deleted_at IS NULL)

SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_ WHERE ((YEAR(c0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(c0_.created_at) = NULL OR NULL IS NULL) AND (SELECT COUNT(o1_.id) AS sclr_1 FROM `order` o1_ LEFT JOIN document d2_ ON o1_.id = d2_.id WHERE (o1_.customer_id = c0_.id AND NOT EXISTS (SELECT o1_.id FROM order_item o3_ LEFT JOIN stock s4_ ON o3_.id = s4_.id INNER JOIN product p5_ ON o3_.product_id = p5_.id AND (p5_.deleted_at IS NULL) LEFT JOIN article a6_ ON p5_.id = a6_.id LEFT JOIN shop_product s7_ ON p5_.id = s7_.id WHERE o3_.parent_order_id = o1_.id AND p5_.name IN ('Réedition Carte', 'Entre journalier'))) AND (o1_.deleted_at IS NULL)) > 1) AND (c0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  SUM(o1_.quantity * o1_.price) AS sclr_2,
  COUNT(o1_.id) AS sclr_3
FROM
  order_item o1_
  LEFT JOIN stock s2_ ON o1_.id = s2_.id
  LEFT JOIN (
    product p0_
    LEFT JOIN article a3_ ON p0_.id = a3_.id
    LEFT JOIN shop_product s4_ ON p0_.id = s4_.id
  ) ON (p0_.id = o1_.product_id)
  AND (p0_.deleted_at IS NULL)
  LEFT JOIN `order` o5_ ON o1_.parent_order_id = o5_.id
  AND (o5_.deleted_at IS NULL)
  LEFT JOIN document d6_ ON o5_.id = d6_.id
WHERE
  (
    YEAR(o1_.created_at) = ?
    OR ? IS NULL
  )
  AND (
    o5_.store_id = ?
    OR ? IS NULL
  )
  AND (
    MONTH(o1_.created_at) = ?
    OR ? IS NULL
  )
  AND p0_.name IS NOT NULL
GROUP BY
  p0_.id,
  p0_.name
HAVING
  sclr_2 > 0
ORDER BY
  sclr_2 DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.name AS name_1, SUM(o1_.quantity * o1_.price) AS sclr_2, COUNT(o1_.id) AS sclr_3 FROM order_item o1_ LEFT JOIN stock s2_ ON o1_.id = s2_.id LEFT JOIN (product p0_ LEFT JOIN article a3_ ON p0_.id = a3_.id LEFT JOIN shop_product s4_ ON p0_.id = s4_.id) ON (p0_.id = o1_.product_id) AND (p0_.deleted_at IS NULL) LEFT JOIN `order` o5_ ON o1_.parent_order_id = o5_.id AND (o5_.deleted_at IS NULL) LEFT JOIN document d6_ ON o5_.id = d6_.id WHERE (YEAR(o1_.created_at) = NULL OR NULL IS NULL) AND (o5_.store_id = NULL OR NULL IS NULL) AND (MONTH(o1_.created_at) = NULL OR NULL IS NULL) AND p0_.name IS NOT NULL GROUP BY p0_.id, p0_.name HAVING sclr_2 > 0 ORDER BY sclr_2 DESC LIMIT 12;

SELECT
  a0_.first_name AS first_name_0,
  a0_.last_name AS last_name_1,
  (
    SELECT
      SUM(p1_.amount) AS sclr_3
    FROM
      payment p1_
      INNER JOIN `order` o2_ ON p1_.related_order_id = o2_.id
      AND (o2_.deleted_at IS NULL)
      LEFT JOIN document d3_ ON o2_.id = d3_.id
    WHERE
      o2_.agent_id = a0_.id
      AND (
        YEAR(o2_.created_at) = ?
        OR ? IS NULL
      )
      AND (
        MONTH(o2_.created_at) = ?
        OR ? IS NULL
      )
      AND (
        o2_.store_id = ?
        OR ? IS NULL
      )
  ) AS sclr_2
FROM
  agent a0_
WHERE
  (a0_.deleted_at IS NULL)
GROUP BY
  a0_.id,
  a0_.first_name
HAVING
  sclr_2 > 0
ORDER BY
  sclr_2 DESC
LIMIT
  12

SELECT a0_.first_name AS first_name_0, a0_.last_name AS last_name_1, (SELECT SUM(p1_.amount) AS sclr_3 FROM payment p1_ INNER JOIN `order` o2_ ON p1_.related_order_id = o2_.id AND (o2_.deleted_at IS NULL) LEFT JOIN document d3_ ON o2_.id = d3_.id WHERE o2_.agent_id = a0_.id AND (YEAR(o2_.created_at) = NULL OR NULL IS NULL) AND (MONTH(o2_.created_at) = NULL OR NULL IS NULL) AND (o2_.store_id = NULL OR NULL IS NULL)) AS sclr_2 FROM agent a0_ WHERE (a0_.deleted_at IS NULL) GROUP BY a0_.id, a0_.first_name HAVING sclr_2 > 0 ORDER BY sclr_2 DESC LIMIT 12;

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;

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  customer c0_
  LEFT JOIN (
    `order` o1_
    LEFT JOIN document d2_ ON o1_.id = d2_.id
  ) ON (o1_.customer_id = c0_.id)
  AND (o1_.deleted_at IS NULL)
  LEFT JOIN (
    order_item o3_
    LEFT JOIN stock s4_ ON o3_.id = s4_.id
  ) ON (o3_.parent_order_id = o1_.id)
WHERE
  (
    (
      c0_.store_id = ?
      OR ? IS NULL
    )
    AND (
      YEAR(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND o3_.parent_order_id IS NULL
  )
  AND (c0_.deleted_at IS NULL)

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM customer c0_ LEFT JOIN (`order` o1_ LEFT JOIN document d2_ ON o1_.id = d2_.id) ON (o1_.customer_id = c0_.id) AND (o1_.deleted_at IS NULL) LEFT JOIN (order_item o3_ LEFT JOIN stock s4_ ON o3_.id = s4_.id) ON (o3_.parent_order_id = o1_.id) WHERE ((c0_.store_id = NULL OR NULL IS NULL) AND (YEAR(c0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(c0_.created_at) = NULL OR NULL IS NULL) AND o3_.parent_order_id IS NULL) AND (c0_.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
  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
  COUNT(o0_.id) AS sclr_0,
  SUM(
    CASE WHEN o0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN o0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  `order` o0_
  LEFT JOIN document d1_ ON o0_.id = d1_.id
WHERE
  (
    o0_.status = ?
    AND (
      o0_.store_id = ?
      OR ? IS NULL
    )
    AND (
      YEAR(o0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(o0_.created_at) = ?
      OR ? IS NULL
    )
  )
  AND (o0_.deleted_at IS NULL)

SELECT COUNT(o0_.id) AS sclr_0, SUM(CASE WHEN o0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN o0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM `order` o0_ LEFT JOIN document d1_ ON o0_.id = d1_.id WHERE (o0_.status = 'canceled' AND (o0_.store_id = NULL OR NULL IS NULL) AND (YEAR(o0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(o0_.created_at) = NULL OR NULL IS NULL)) AND (o0_.deleted_at IS NULL);

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  customer c0_
WHERE
  (
    (
      YEAR(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND c0_.date_of_birth <= ?
    AND c0_.gender = ?
  )
  AND (c0_.deleted_at IS NULL)

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM customer c0_ WHERE ((YEAR(c0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(c0_.created_at) = NULL OR NULL IS NULL) AND c0_.date_of_birth <= '2008-01-01 00:00:00' AND c0_.gender = 'male') AND (c0_.deleted_at IS NULL);

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  customer c0_
WHERE
  (
    (
      c0_.store_id = ?
      OR ? IS NULL
    )
    AND (
      YEAR(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND c0_.gender IS NOT NULL
    AND c0_.date_of_birth IS NOT NULL
    AND (
      MONTH(c0_.created_at) = ?
      OR ? IS NULL
    )
  )
  AND (c0_.deleted_at IS NULL)

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM customer c0_ WHERE ((c0_.store_id = NULL OR NULL IS NULL) AND (YEAR(c0_.created_at) = NULL OR NULL IS NULL) AND c0_.gender IS NOT NULL AND c0_.date_of_birth IS NOT NULL AND (MONTH(c0_.created_at) = NULL OR NULL IS NULL)) AND (c0_.deleted_at IS NULL);

SELECT
  COUNT(p0_.id) AS sclr_0,
  SUM(
    CASE WHEN p0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN p0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  product_subscription p0_
WHERE
  (
    YEAR(p0_.created_at) = ?
    OR ? IS NULL
  )
  AND (
    MONTH(p0_.created_at) = ?
    OR ? IS NULL
  )

SELECT COUNT(p0_.id) AS sclr_0, SUM(CASE WHEN p0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN p0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM product_subscription p0_ WHERE (YEAR(p0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(p0_.created_at) = NULL OR NULL IS NULL);

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_1,
  SUM(
    CASE WHEN c0_.created_at >= ? THEN 1 ELSE 0 END
  ) AS sclr_2
FROM
  customer c0_
WHERE
  (
    (
      YEAR(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND (
      MONTH(c0_.created_at) = ?
      OR ? IS NULL
    )
    AND c0_.date_of_birth >= ?
    AND c0_.gender IN (?, ?)
  )
  AND (c0_.deleted_at IS NULL)

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.created_at >= '2025-08-18 18:17:22' THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN c0_.created_at >= '2025-08-01 18:17:22' THEN 1 ELSE 0 END) AS sclr_2 FROM customer c0_ WHERE ((YEAR(c0_.created_at) = NULL OR NULL IS NULL) AND (MONTH(c0_.created_at) = NULL OR NULL IS NULL) AND c0_.date_of_birth >= '2008-01-01 00:00:00' AND c0_.gender IN ('male', 'female')) AND (c0_.deleted_at IS NULL);

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

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;