Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.code AS code_1,
  o0_.operation_code AS operation_code_2,
  o0_.title AS title_3,
  o0_.amount AS amount_4,
  o0_.created_at AS created_at_5,
  o0_.updated_at AS updated_at_6,
  o0_.draw_type AS draw_type_7,
  o0_.start_date AS start_date_8,
  o0_.end_date AS end_date_9,
  o0_.draw_date AS draw_date_10,
  o0_.online AS online_11,
  o0_.subtitle AS subtitle_12,
  o0_.text AS text_13,
  o0_.nb_winner AS nb_winner_14,
  o0_.transport_reference AS transport_reference_15,
  o0_.bext_reference AS bext_reference_16,
  o0_.sogec_send AS sogec_send_17,
  o0_.mail_content AS mail_content_18,
  o0_.discr AS discr_19,
  o0_.owner_id AS owner_id_20,
  o0_.state_id AS state_id_21,
  o0_.company_id AS company_id_22
FROM
  operation o0_
  INNER JOIN state s1_ ON o0_.state_id = s1_.id
WHERE
  (
    o0_.id IN (
      SELECT
        o2_.id
      FROM
        operation o2_
        INNER JOIN state s3_ ON o2_.state_id = s3_.id
      WHERE
        (
          o2_.start_date IS NOT NULL
          AND o2_.start_date < ?
          AND o2_.end_date IS NOT NULL
          AND o2_.end_date > ?
          AND o2_.online = ?
          AND s3_.label LIKE CONCAT('%', ?, '%')
        )
        AND o2_.discr IN ('draw')
    )
  )
  AND o0_.discr IN ('draw')
ORDER BY
  o0_.id ASC
LIMIT
  30

SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.operation_code AS operation_code_2, o0_.title AS title_3, o0_.amount AS amount_4, o0_.created_at AS created_at_5, o0_.updated_at AS updated_at_6, o0_.draw_type AS draw_type_7, o0_.start_date AS start_date_8, o0_.end_date AS end_date_9, o0_.draw_date AS draw_date_10, o0_.online AS online_11, o0_.subtitle AS subtitle_12, o0_.text AS text_13, o0_.nb_winner AS nb_winner_14, o0_.transport_reference AS transport_reference_15, o0_.bext_reference AS bext_reference_16, o0_.sogec_send AS sogec_send_17, o0_.mail_content AS mail_content_18, o0_.discr AS discr_19, o0_.owner_id AS owner_id_20, o0_.state_id AS state_id_21, o0_.company_id AS company_id_22 FROM operation o0_ INNER JOIN state s1_ ON o0_.state_id = s1_.id WHERE (o0_.id IN (SELECT o2_.id FROM operation o2_ INNER JOIN state s3_ ON o2_.state_id = s3_.id WHERE (o2_.start_date IS NOT NULL AND o2_.start_date < '2026-04-08 11:51:15' AND o2_.end_date IS NOT NULL AND o2_.end_date > '2026-04-08 11:51:15' AND o2_.online = 1 AND s3_.label LIKE CONCAT('%', 'operation_validated', '%')) AND o2_.discr IN ('draw'))) AND o0_.discr IN ('draw') ORDER BY o0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  operation o0_
  INNER JOIN state s1_ ON o0_.state_id = s1_.id
WHERE
  (
    o0_.id IN (
      SELECT
        o2_.id
      FROM
        operation o2_
        INNER JOIN state s3_ ON o2_.state_id = s3_.id
      WHERE
        (
          o2_.start_date IS NOT NULL
          AND o2_.start_date < ?
          AND o2_.end_date IS NOT NULL
          AND o2_.end_date > ?
          AND o2_.online = ?
          AND s3_.label LIKE CONCAT('%', ?, '%')
        )
        AND o2_.discr IN ('draw')
    )
  )
  AND o0_.discr IN ('draw')

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM operation o0_ INNER JOIN state s1_ ON o0_.state_id = s1_.id WHERE (o0_.id IN (SELECT o2_.id FROM operation o2_ INNER JOIN state s3_ ON o2_.state_id = s3_.id WHERE (o2_.start_date IS NOT NULL AND o2_.start_date < '2026-04-08 11:51:15' AND o2_.end_date IS NOT NULL AND o2_.end_date > '2026-04-08 11:51:15' AND o2_.online = 1 AND s3_.label LIKE CONCAT('%', 'operation_validated', '%')) AND o2_.discr IN ('draw'))) AND o0_.discr IN ('draw');