Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.start AS start_1,
  o0_.end AS end_2,
  o0_.test_end AS test_end_3,
  o0_.comment AS comment_4,
  o0_.price AS price_5,
  o0_.agent_price AS agent_price_6,
  o0_.statut AS statut_7,
  o0_.payement AS payement_8,
  o0_.token AS token_9,
  o0_.created_at AS created_at_10,
  o0_.updated_at AS updated_at_11,
  o0_.user_id AS user_id_12,
  o0_.period_id AS period_id_13,
  o0_.discount_id AS discount_id_14,
  o0_.agency_id AS agency_id_15,
  o0_.responsible_id AS responsible_id_16,
  o0_.event_id AS event_id_17,
  o0_.circuit_id AS circuit_id_18,
  o0_.dealer_id AS dealer_id_19
FROM
  `order` o0_
  INNER JOIN order_participant_bike o1_ ON o0_.id = o1_.book_id
  INNER JOIN bike b2_ ON o1_.bike_id = b2_.id
WHERE
  b2_.id = ?
  AND (
    ? BETWEEN o0_.start
    AND o0_.end
  )
LIMIT
  1

SELECT o0_.id AS id_0, o0_.start AS start_1, o0_.end AS end_2, o0_.test_end AS test_end_3, o0_.comment AS comment_4, o0_.price AS price_5, o0_.agent_price AS agent_price_6, o0_.statut AS statut_7, o0_.payement AS payement_8, o0_.token AS token_9, o0_.created_at AS created_at_10, o0_.updated_at AS updated_at_11, o0_.user_id AS user_id_12, o0_.period_id AS period_id_13, o0_.discount_id AS discount_id_14, o0_.agency_id AS agency_id_15, o0_.responsible_id AS responsible_id_16, o0_.event_id AS event_id_17, o0_.circuit_id AS circuit_id_18, o0_.dealer_id AS dealer_id_19 FROM `order` o0_ INNER JOIN order_participant_bike o1_ ON o0_.id = o1_.book_id INNER JOIN bike b2_ ON o1_.bike_id = b2_.id WHERE b2_.id = 10 AND ('2025-05-02 23:08:44' BETWEEN o0_.start AND o0_.end) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.statut AS statut_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.agency_id AS agency_id_6,
  t0.bike_id AS bike_id_7,
  t0.accessory_id AS accessory_id_8,
  t0.book_id AS book_id_9
FROM
  history t0
WHERE
  t0.bike_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.agency_id AS agency_id_6, t0.bike_id AS bike_id_7, t0.accessory_id AS accessory_id_8, t0.book_id AS book_id_9 FROM history t0 WHERE t0.bike_id = 10;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.icon AS icon_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM brand t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  size t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM size t0 WHERE t0.id = 1;

SELECT
  b0_.id AS id_0
FROM
  `order` o1_
  INNER JOIN order_participant_bike o2_ ON o1_.id = o2_.book_id
  INNER JOIN bike b0_ ON o2_.bike_id = b0_.id
WHERE
  (
    (
      o1_.user_id = ?
      AND (
        o1_.start BETWEEN ?
        AND ?
      )
    )
    OR (
      o1_.end BETWEEN ?
      AND ?
    )
  )
  AND (
    o1_.statut <> 2
    OR o1_.statut <> 0
  )

SELECT b0_.id AS id_0 FROM `order` o1_ INNER JOIN order_participant_bike o2_ ON o1_.id = o2_.book_id INNER JOIN bike b0_ ON o2_.bike_id = b0_.id WHERE ((o1_.user_id = 2 AND (o1_.start BETWEEN '2025-05-03 00:00:00' AND '2025-05-03 23:59:59')) OR (o1_.end BETWEEN '2025-05-03 00:00:00' AND '2025-05-03 23:59:59')) AND (o1_.statut <> 2 OR o1_.statut <> 0);

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.description AS description_3,
  t0.statut AS statut_4,
  t0.principal_image AS principal_image_5,
  t0.multiple_image AS multiple_image_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.agency_id AS agency_id_9,
  t0.category_id AS category_id_10,
  t0.kind_id AS kind_id_11,
  t0.size_id AS size_id_12,
  t0.brand_id AS brand_id_13
FROM
  bike t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.description AS description_3, t0.statut AS statut_4, t0.principal_image AS principal_image_5, t0.multiple_image AS multiple_image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.agency_id AS agency_id_9, t0.category_id AS category_id_10, t0.kind_id AS kind_id_11, t0.size_id AS size_id_12, t0.brand_id AS brand_id_13 FROM bike t0 WHERE t0.agency_id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.percentage AS percentage_3,
  t0.icon AS icon_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.percentage AS percentage_3, t0.icon AS icon_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM category t0 WHERE t0.id = 2;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.first_name AS first_name_4,
  t1.last_name AS last_name_5,
  t1.roles AS roles_6,
  t1.password AS password_7,
  t1.logo AS logo_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.title AS title_11,
  t0.address AS address_12,
  t0.phone AS phone_13,
  t0.statut AS statut_14,
  t1.type
FROM
  agency t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.icon AS icon_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  kind t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM kind t0 WHERE t0.id = 3;