Symfony Profiler

[
  "route" => "_api_/reservations{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/reservations{._format}_get_collection"
    "_controller" => "api_platform.action.placeholder"
    "_format" => null
    "_stateless" => true
    "_api_resource_class" => "App\Entity\Reservation"
    "_api_operation_name" => "_api_/reservations{._format}_get_collection"
  ]
  "request_uri" => "http://new-api.tra-diction.fr/api/reservations?itemsPerPage=10&page=1&professionalCustomer.id=1&reservedDate%5Bafter%5D=2025-12-17&reservedDate%5Bbefore%5D=2025-12-17&state=VALIDATED"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "tradiction-database"
    "port" => 5432
    "user" => "tradiction_db_usr_10082024"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "tradictiondb"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ema@sprene.fr"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1678
    -user: App\Entity\User {#1595 …}
    -roleNames: [
      "ROLE_CUSTOMER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjU5NTk5NTIsImV4cCI6MTc2NTk2MzU1Miwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6ImVtYUBzcHJlbmUuZnIifQ.TjmRSTkrOk4rdm-s1vWOJimCO2bcR89z3ILNgvWRQ3PeWB-FzGCWVdBd4jJ85amwMR4R32rwO6Pxf3tEVSVQkpzkxV1FrUVDKauJrASjburnyb4wlF5BkLvILkkevtfVaSJZg_mG70XamvJqkeH9zBTvJDTBAlkD4s_l7Pn4V2MXoWglAjo2M15NTtjVt_zTnZ1Pt9nOL4pZi8v2iGBUaK0KWjHS8vhd5VDHmbbb-0xI65xMOCUmsF3Z3_XVd0jeHEUa0WTDiryoUVDZP8oKeTN946AkEY2c0CoQ7bIKjqhEvW4Aa6JxC-529xJxoi6egXvoqwHdmdDKnUOGtcfQQg"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerGZEXSjl\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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 >= ?)"
  "params" => [
    1 => "1"
    2 => "VALIDATED"
    3 => "2025-12-17"
    4 => "2025-12-17"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "1"
    2 => "VALIDATED"
    3 => "2025-12-17"
    4 => "2025-12-17"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.quotation_reference AS quotation_reference_1, r0_.state AS state_2, r0_.address_label AS address_label_3, r0_.address_complement AS address_complement_4, r0_.address_zip_code AS address_zip_code_5, r0_.reservation_date AS reservation_date_6, r0_.ip_client AS ip_client_7, r0_.visio_link AS visio_link_8, r0_.reserved_date AS reserved_date_9, r0_.reserved_hour AS reserved_hour_10, r0_.end_date AS end_date_11, r0_.billing_date AS billing_date_12, r0_.end_hour AS end_hour_13, r0_.comments AS comments_14, r0_.booked_by_full_name AS booked_by_full_name_15, r0_.no_subject_to_translate AS no_subject_to_translate_16, r0_.no_interpreter AS no_interpreter_17, r0_.price AS price_18, r0_.price_ttc AS price_ttc_19, r0_.interpreter_price AS interpreter_price_20, r0_.interpreter_package AS interpreter_package_21, r0_.payment_mode AS payment_mode_22, r0_.ended_date AS ended_date_23, r0_.created_from_front AS created_from_front_24, r0_.closed_from_front AS closed_from_front_25, r0_.nb_pages AS nb_pages_26, r0_.nb_words AS nb_words_27, r0_.minute_number AS minute_number_28, r0_.message AS message_29, r0_.phone_package AS phone_package_30, r0_.training_package AS training_package_31, r0_.transcription_package AS transcription_package_32, r0_.translation_package AS translation_package_33, r0_.tva AS tva_34, r0_.is_tva AS is_tva_35, r0_.kilometric_cost AS kilometric_cost_36, r0_.parking_cost AS parking_cost_37, r0_.food_cost AS food_cost_38, r0_.housing_cost AS housing_cost_39, r0_.discount_amount_percentage AS discount_amount_percentage_40, r0_.send_invoice_by_mail AS send_invoice_by_mail_41, r0_.apply_additional_fees AS apply_additional_fees_42, r0_.apply_discount AS apply_discount_43, p1_.id AS id_44, p1_.name AS name_45, p1_.is_approved AS is_approved_46, p1_.is_filled AS is_filled_47, p1_.siren AS siren_48, p1_.customer_email AS customer_email_49, p1_.referent_function AS referent_function_50, p1_.accounting_email AS accounting_email_51, p1_.accounting_phone AS accounting_phone_52, i2_.id AS id_53, i2_.is_approved AS is_approved_54, i2_.is_filled AS is_filled_55, a3_.id AS id_56, a3_.address_label AS address_label_57, a3_.town AS town_58, a3_.address_complement AS address_complement_59, a3_.postal_code AS postal_code_60, a3_.country AS country_61, p4_.id AS id_62, p4_.label AS label_63, p4_.description AS description_64, a5_.id AS id_65, a5_.address_label AS address_label_66, a5_.town AS town_67, a5_.address_complement AS address_complement_68, a5_.postal_code AS postal_code_69, a5_.country AS country_70, i6_.id AS id_71, i6_.birthdate AS birthdate_72, i6_.hire_date AS hire_date_73, i6_.birth_place AS birth_place_74, i6_.gender AS gender_75, i6_.is_conveyed AS is_conveyed_76, i6_.hourly_rate AS hourly_rate_77, i6_.is_approved AS is_approved_78, i6_.rate_by_word AS rate_by_word_79, i6_.rate_by_page AS rate_by_page_80, i6_.is_self_employed AS is_self_employed_81, i6_.siren_number AS siren_number_82, i6_.is_filled AS is_filled_83, i6_.is_sworn_in AS is_sworn_in_84, i6_.comments AS comments_85, i6_.languages AS languages_86, u7_.username AS username_87, u7_.username_canonical AS username_canonical_88, u7_.email AS email_89, u7_.email_canonical AS email_canonical_90, u7_.enabled AS enabled_91, u7_.salt AS salt_92, u7_.password AS password_93, u7_.last_login AS last_login_94, u7_.confirmation_token AS confirmation_token_95, u7_.password_requested_at AS password_requested_at_96, u7_.roles AS roles_97, u7_.id AS id_98, u7_.firstname AS firstname_99, u7_.lastname AS lastname_100, u7_.phone_number AS phone_number_101, a8_.id AS id_102, a8_.address_label AS address_label_103, a8_.town AS town_104, a8_.address_complement AS address_complement_105, a8_.postal_code AS postal_code_106, a8_.country AS country_107, i9_.id AS id_108, i9_.file_name AS file_name_109, i9_.file_size AS file_size_110, i9_.updated_at AS updated_at_111, i10_.id AS id_112, i10_.label AS label_113, r11_.id AS id_114, r11_.label AS label_115, r11_.description AS description_116, r11_.is_reservable_for_many_days AS is_reservable_for_many_days_117, l12_.id AS id_118, l12_.label AS label_119, l12_.country AS country_120, l13_.id AS id_121, l13_.label AS label_122, l13_.delay_in_days AS delay_in_days_123, l14_.id AS id_124, l14_.label AS label_125, l14_.country AS country_126, l15_.id AS id_127, l15_.label AS label_128, l15_.delay_in_days AS delay_in_days_129, p16_.id AS id_130, p16_.pricing_mode AS pricing_mode_131, p16_.price_in_euros AS price_in_euros_132, p17_.id AS id_133, p17_.label AS label_134, p17_.icon AS icon_135, r18_.id AS id_136, r18_.file_name AS file_name_137, r18_.file_size AS file_size_138, r18_.updated_at AS updated_at_139, u19_.username AS username_140, u19_.username_canonical AS username_canonical_141, u19_.email AS email_142, u19_.email_canonical AS email_canonical_143, u19_.enabled AS enabled_144, u19_.salt AS salt_145, u19_.password AS password_146, u19_.last_login AS last_login_147, u19_.confirmation_token AS confirmation_token_148, u19_.password_requested_at AS password_requested_at_149, u19_.roles AS roles_150, u19_.id AS id_151, u19_.firstname AS firstname_152, u19_.lastname AS lastname_153, u19_.phone_number AS phone_number_154, u20_.username AS username_155, u20_.username_canonical AS username_canonical_156, u20_.email AS email_157, u20_.email_canonical AS email_canonical_158, u20_.enabled AS enabled_159, u20_.salt AS salt_160, u20_.password AS password_161, u20_.last_login AS last_login_162, u20_.confirmation_token AS confirmation_token_163, u20_.password_requested_at AS password_requested_at_164, u20_.roles AS roles_165, u20_.id AS id_166, u20_.firstname AS firstname_167, u20_.lastname AS lastname_168, u20_.phone_number AS phone_number_169, u21_.username AS username_170, u21_.username_canonical AS username_canonical_171, u21_.email AS email_172, u21_.email_canonical AS email_canonical_173, u21_.enabled AS enabled_174, u21_.salt AS salt_175, u21_.password AS password_176, u21_.last_login AS last_login_177, u21_.confirmation_token AS confirmation_token_178, u21_.password_requested_at AS password_requested_at_179, u21_.roles AS roles_180, u21_.id AS id_181, u21_.firstname AS firstname_182, u21_.lastname AS lastname_183, u21_.phone_number AS phone_number_184, r0_.individual_customer_id AS individual_customer_id_185, r0_.professional_customer_id AS professional_customer_id_186, r0_.interpreter_id AS interpreter_id_187, r0_.reservation_type_id AS reservation_type_id_188, r0_.language_to_translate AS language_to_translate_189, r0_.target_language AS target_language_190, r0_.pricing_id AS pricing_id_191, r0_.created_by AS created_by_192, r0_.ended_by_id AS ended_by_id_193, r0_.validated_by_id AS validated_by_id_194, p1_.client_type AS client_type_195, p1_.address_id AS address_id_196, p1_.user_id AS user_id_197, i2_.address_id AS address_id_198, i2_.user_id AS user_id_199, i6_.user_id AS user_id_200, i6_.address_id AS address_id_201, i9_.file_type_id AS file_type_id_202, i9_.interpreter_id AS interpreter_id_203, l12_.frequency_id AS frequency_id_204, l14_.frequency_id AS frequency_id_205, p16_.pricing_type_id AS pricing_type_id_206, r18_.reservation_id AS reservation_id_207 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 >= ?) AND r0_.id IN (?) ORDER BY r0_.id ASC"
  "params" => [
    1 => "1"
    2 => "VALIDATED"
    3 => "2025-12-17"
    4 => "2025-12-17"
    5 => 2
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_approved AS is_approved_2, t0.is_filled AS is_filled_3, t0.address_id AS address_id_4, t0.user_id AS user_id_5 FROM individual_customer t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.birthdate AS birthdate_2, t0.hire_date AS hire_date_3, t0.birth_place AS birth_place_4, t0.gender AS gender_5, t0.is_conveyed AS is_conveyed_6, t0.hourly_rate AS hourly_rate_7, t0.is_approved AS is_approved_8, t0.rate_by_word AS rate_by_word_9, t0.rate_by_page AS rate_by_page_10, t0.is_self_employed AS is_self_employed_11, t0.siren_number AS siren_number_12, t0.is_filled AS is_filled_13, t0.is_sworn_in AS is_sworn_in_14, t0.comments AS comments_15, t0.languages AS languages_16, t0.user_id AS user_id_17, t0.address_id AS address_id_18 FROM interpreter t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_approved AS is_approved_2, t0.is_filled AS is_filled_3, t0.address_id AS address_id_4, t0.user_id AS user_id_5 FROM individual_customer t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.is_approved AS is_approved_3, t0.is_filled AS is_filled_4, t0.siren AS siren_5, t0.customer_email AS customer_email_6, t0.referent_function AS referent_function_7, t0.accounting_email AS accounting_email_8, t0.accounting_phone AS accounting_phone_9, t0.client_type AS client_type_10, t0.address_id AS address_id_11, t0.user_id AS user_id_12 FROM professional_customer t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\ValidateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\WriteListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\SerializeListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Symfony\Bridge\Twig\EventListener\TemplateAttributeListener::onKernelView"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]