Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.firstname AS firstname_13,
  t0.lastname AS lastname_14,
  t0.phone_number AS phone_number_15,
  t16.id AS id_17,
  t16.birthdate AS birthdate_18,
  t16.hire_date AS hire_date_19,
  t16.birth_place AS birth_place_20,
  t16.gender AS gender_21,
  t16.is_conveyed AS is_conveyed_22,
  t16.hourly_rate AS hourly_rate_23,
  t16.is_approved AS is_approved_24,
  t16.rate_by_word AS rate_by_word_25,
  t16.rate_by_page AS rate_by_page_26,
  t16.is_self_employed AS is_self_employed_27,
  t16.siren_number AS siren_number_28,
  t16.is_filled AS is_filled_29,
  t16.is_sworn_in AS is_sworn_in_30,
  t16.comments AS comments_31,
  t16.languages AS languages_32,
  t16.user_id AS user_id_33,
  t16.address_id AS address_id_34,
  t35.id AS id_36,
  t35.is_approved AS is_approved_37,
  t35.is_filled AS is_filled_38,
  t35.address_id AS address_id_39,
  t35.user_id AS user_id_40,
  t41.id AS id_42,
  t41.name AS name_43,
  t41.is_approved AS is_approved_44,
  t41.is_filled AS is_filled_45,
  t41.siren AS siren_46,
  t41.customer_email AS customer_email_47,
  t41.referent_function AS referent_function_48,
  t41.accounting_email AS accounting_email_49,
  t41.accounting_phone AS accounting_phone_50,
  t41.client_type AS client_type_51,
  t41.address_id AS address_id_52,
  t41.user_id AS user_id_53
FROM
  users t0
  LEFT JOIN interpreter t16 ON t16.user_id = t0.id
  LEFT JOIN individual_customer t35 ON t35.user_id = t0.id
  LEFT JOIN professional_customer t41 ON t41.user_id = t0.id
WHERE
  t0.username_canonical = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.phone_number AS phone_number_15, t16.id AS id_17, t16.birthdate AS birthdate_18, t16.hire_date AS hire_date_19, t16.birth_place AS birth_place_20, t16.gender AS gender_21, t16.is_conveyed AS is_conveyed_22, t16.hourly_rate AS hourly_rate_23, t16.is_approved AS is_approved_24, t16.rate_by_word AS rate_by_word_25, t16.rate_by_page AS rate_by_page_26, t16.is_self_employed AS is_self_employed_27, t16.siren_number AS siren_number_28, t16.is_filled AS is_filled_29, t16.is_sworn_in AS is_sworn_in_30, t16.comments AS comments_31, t16.languages AS languages_32, t16.user_id AS user_id_33, t16.address_id AS address_id_34, t35.id AS id_36, t35.is_approved AS is_approved_37, t35.is_filled AS is_filled_38, t35.address_id AS address_id_39, t35.user_id AS user_id_40, t41.id AS id_42, t41.name AS name_43, t41.is_approved AS is_approved_44, t41.is_filled AS is_filled_45, t41.siren AS siren_46, t41.customer_email AS customer_email_47, t41.referent_function AS referent_function_48, t41.accounting_email AS accounting_email_49, t41.accounting_phone AS accounting_phone_50, t41.client_type AS client_type_51, t41.address_id AS address_id_52, t41.user_id AS user_id_53 FROM users t0 LEFT JOIN interpreter t16 ON t16.user_id = t0.id LEFT JOIN individual_customer t35 ON t35.user_id = t0.id LEFT JOIN professional_customer t41 ON t41.user_id = t0.id WHERE t0.username_canonical = 'ema@sprene.fr' LIMIT 1;

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  reservation r0_
  INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id
  LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id
  LEFT JOIN address a3_ ON i2_.address_id = a3_.id
  LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id
  LEFT JOIN address a5_ ON p1_.address_id = a5_.id
  LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id
  LEFT JOIN users u7_ ON i6_.user_id = u7_.id
  LEFT JOIN address a8_ ON i6_.address_id = a8_.id
  LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id
  LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id
  LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id
  LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id
  LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id
  LEFT JOIN language l14_ ON r0_.target_language = l14_.id
  LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id
  LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id
  LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id
  LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id
  INNER JOIN users u19_ ON r0_.created_by = u19_.id
  LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id
  LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id
WHERE
  r0_.id IN (
    SELECT
      r22_.id
    FROM
      reservation r22_
      INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id
    WHERE
      p23_.id = ?
      AND r22_.state = ?
      AND r22_.reserved_date <= ?
      AND r22_.reserved_date >= ?
  )

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM reservation r0_ INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id LEFT JOIN address a3_ ON i2_.address_id = a3_.id LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id LEFT JOIN address a5_ ON p1_.address_id = a5_.id LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id LEFT JOIN users u7_ ON i6_.user_id = u7_.id LEFT JOIN address a8_ ON i6_.address_id = a8_.id LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id LEFT JOIN language l14_ ON r0_.target_language = l14_.id LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id INNER JOIN users u19_ ON r0_.created_by = u19_.id LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id WHERE r0_.id IN (SELECT r22_.id FROM reservation r22_ INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id WHERE p23_.id = '1' AND r22_.state = 'VALIDATED' AND r22_.reserved_date <= '2025-12-17' AND r22_.reserved_date >= '2025-12-16');

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.id AS id_1
FROM
  reservation r0_
  INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id
  LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id
  LEFT JOIN address a3_ ON i2_.address_id = a3_.id
  LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id
  LEFT JOIN address a5_ ON p1_.address_id = a5_.id
  LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id
  LEFT JOIN users u7_ ON i6_.user_id = u7_.id
  LEFT JOIN address a8_ ON i6_.address_id = a8_.id
  LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id
  LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id
  LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id
  LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id
  LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id
  LEFT JOIN language l14_ ON r0_.target_language = l14_.id
  LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id
  LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id
  LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id
  LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id
  INNER JOIN users u19_ ON r0_.created_by = u19_.id
  LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id
  LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id
WHERE
  r0_.id IN (
    SELECT
      r22_.id
    FROM
      reservation r22_
      INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id
    WHERE
      p23_.id = ?
      AND r22_.state = ?
      AND r22_.reserved_date <= ?
      AND r22_.reserved_date >= ?
  )
ORDER BY
  r0_.id ASC
LIMIT
  30

SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM reservation r0_ INNER JOIN professional_customer p1_ ON r0_.professional_customer_id = p1_.id LEFT JOIN individual_customer i2_ ON r0_.individual_customer_id = i2_.id LEFT JOIN address a3_ ON i2_.address_id = a3_.id LEFT JOIN professional_customer_type p4_ ON p1_.client_type = p4_.id LEFT JOIN address a5_ ON p1_.address_id = a5_.id LEFT JOIN interpreter i6_ ON r0_.interpreter_id = i6_.id LEFT JOIN users u7_ ON i6_.user_id = u7_.id LEFT JOIN address a8_ ON i6_.address_id = a8_.id LEFT JOIN interpreter_file i9_ ON i6_.id = i9_.interpreter_id LEFT JOIN interpreter_file_type i10_ ON i9_.file_type_id = i10_.id LEFT JOIN reservation_type r11_ ON r0_.reservation_type_id = r11_.id LEFT JOIN language l12_ ON r0_.language_to_translate = l12_.id LEFT JOIN language_frequency l13_ ON l12_.frequency_id = l13_.id LEFT JOIN language l14_ ON r0_.target_language = l14_.id LEFT JOIN language_frequency l15_ ON l14_.frequency_id = l15_.id LEFT JOIN pricing p16_ ON r0_.pricing_id = p16_.id LEFT JOIN pricing_type p17_ ON p16_.pricing_type_id = p17_.id LEFT JOIN reservation_file r18_ ON r0_.id = r18_.reservation_id INNER JOIN users u19_ ON r0_.created_by = u19_.id LEFT JOIN users u20_ ON r0_.ended_by_id = u20_.id LEFT JOIN users u21_ ON r0_.validated_by_id = u21_.id WHERE r0_.id IN (SELECT r22_.id FROM reservation r22_ INNER JOIN professional_customer p23_ ON r22_.professional_customer_id = p23_.id WHERE p23_.id = '1' AND r22_.state = 'VALIDATED' AND r22_.reserved_date <= '2025-12-17' AND r22_.reserved_date >= '2025-12-16') ORDER BY r0_.id ASC LIMIT 30;