Symfony Profiler

[
  "route" => "front_search_index"
  "route_parameters" => [
    "_route" => "front_search_index"
    "_controller" => "App\Controller\Front\SearchController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://dev.citizens.fr/recherche/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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\HttpKernel\EventListener\RouterListener::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" => "Stof\DoctrineExtensionsBundle\EventListener\BlameListener::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "website"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "dev"
    "charset" => "utf8mb4"
  ]
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name_id AS name_id_3 FROM cal_property_list t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "districts"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.slug AS slug_1, c1_.id AS id_2, c1_.fr AS fr_3, c1_.en AS en_4, c1_.es AS es_5, c2_.id AS id_6, c2_.position AS position_7, c3_.id AS id_8, c3_.fr AS fr_9, c3_.en AS en_10, c3_.es AS es_11, c0_.name_id AS name_id_12, c2_.label_id AS label_id_13, c2_.description_id AS description_id_14, c2_.image_id AS image_id_15, c2_.list_id AS list_id_16 FROM cal_property_list c0_ LEFT JOIN cal_translation c1_ ON c0_.name_id = c1_.id LEFT JOIN cal_property_list_item c2_ ON c0_.id = c2_.list_id LEFT JOIN cal_translation c3_ ON c2_.label_id = c3_.id WHERE c0_.slug = ? ORDER BY c2_.position ASC"
  "params" => [
    1 => "services"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT CASE WHEN c0_.availability_date IS NULL THEN 1 ELSE 0 END AS sclr_0, c0_.id AS id_1, c0_.name AS name_2, c0_.virtual_tour AS virtual_tour_3, c0_.eco AS eco_4, c0_.pet_friendly AS pet_friendly_5, c0_.girls_only AS girls_only_6, c0_.surface AS surface_7, c0_.type AS type_8, c0_.construction_year AS construction_year_9, c0_.total_bedrooms AS total_bedrooms_10, c0_.total_bathrooms AS total_bathrooms_11, c0_.total_kitchens AS total_kitchens_12, c0_.total_toilets AS total_toilets_13, c0_.garden AS garden_14, c0_.availability_date AS availability_date_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, c0_.disabled AS disabled_18, c0_.deleted AS deleted_19, c0_.owner_type AS owner_type_20, c0_.square_meter_price AS square_meter_price_21, c0_.majored_square_meter_price AS majored_square_meter_price_22, c1_.id AS id_23, c1_.auto_lat_lng AS auto_lat_lng_24, c1_.alias AS alias_25, c1_.name AS name_26, c1_.address AS address_27, c1_.zipcode AS zipcode_28, c1_.city AS city_29, c1_.country AS country_30, c1_.informations AS informations_31, c1_.latitude AS latitude_32, c1_.longitude AS longitude_33, c2_.id AS id_34, c2_.name AS name_35, c2_.private AS private_36, c2_.created_at AS created_at_37, c2_.position AS position_38, c3_.id AS id_39, c3_.fr AS fr_40, c3_.en AS en_41, c3_.es AS es_42, c0_.address_id AS address_id_43, c0_.description_id AS description_id_44, c0_.cover_id AS cover_id_45, c0_.plan_id AS plan_id_46, c0_.access_id AS access_id_47, c0_.address_area_id AS address_area_id_48, c0_.district_id AS district_id_49, c0_.owner_id AS owner_id_50, c0_.owner_info_id AS owner_info_id_51, c0_.info_id AS info_id_52, c0_.cleaning_recurrence_id AS cleaning_recurrence_id_53, c2_.accommodation_id AS accommodation_id_54, c2_.room_id AS room_id_55 FROM cal_accommodation c0_ LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id WHERE (c0_.deleted = 0 OR c0_.deleted IS NULL) AND (c0_.disabled = 0 OR c0_.disabled IS NULL) GROUP BY c0_.id ORDER BY sclr_0 ASC, c0_.availability_date ASC LIMIT 100"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 79
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 76
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 75
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 74
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 73
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 72
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 31
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 69
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 68
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 34
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 67
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 36
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 66
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 78
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 28
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 29
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 58
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 33
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 35
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 37
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 38
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.accommodation_id AS accommodation_id_4 FROM cal_workflow_project t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cal_accommodation c0_ LEFT JOIN cal_address c1_ ON c0_.address_id = c1_.id LEFT JOIN cal_accommodation_image c2_ ON c0_.cover_id = c2_.id LEFT JOIN cal_translation c3_ ON c0_.access_id = c3_.id LEFT JOIN cal_accommodation_room c4_ ON c0_.id = c4_.accommodation_id LEFT JOIN cal_accommodations_equipments c6_ ON c0_.id = c6_.accommodation_id LEFT JOIN cal_property_list_item c5_ ON c5_.id = c6_.property_list_item_id WHERE (c0_.deleted = 0 OR c0_.deleted IS NULL) AND (c0_.disabled = 0 OR c0_.disabled IS NULL)"
]

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cal_accommodation_room c0_ LEFT JOIN cal_accommodation c1_ ON c0_.accommodation_id = c1_.id LEFT JOIN cal_accommodation_occupancy c2_ ON c0_.occupancy_id = c2_.id LEFT JOIN cal_accommodation_room_stats c3_ ON c0_.stats_id = c3_.id WHERE (c1_.disabled = 0 OR c1_.disabled IS NULL) AND (c0_.disabled = 0 OR c0_.disabled IS NULL) AND (c0_.ongoing_booking = 0 OR c0_.ongoing_booking IS NULL) AND (c0_.occupancy_id IS NULL OR c2_.`to` < ?) ORDER BY c3_.free_days DESC"
  "params" => [
    1 => "2025-12-10 14:11:07"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.description AS description_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6 FROM cal_address_area t0"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 WHERE t0.list_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 158
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 159
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 160
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 161
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 206
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 342
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 343
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 509
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 555
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 649
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 650
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 681
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 733
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 768
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 769
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 770
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 771
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 814
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 855
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 856
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 857
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 128
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 129
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 293
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 283
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 99
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 97
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 96
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 281
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 154
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 118
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 115
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 117
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 282
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 65
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 615
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 616
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 169
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 618
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 237
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 631
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 60
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 59
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 344
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 345
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 71
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 333
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 334
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 81
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.booking_id AS booking_id_6, t0.room_id AS room_id_7, t0.user_id AS user_id_8, t0.leaving_inventory_id AS leaving_inventory_id_9, t0.leaving_document_id AS leaving_document_id_10 FROM cal_accommodation_occupancy t0 WHERE t0.id = ?"
  "params" => [
    1 => 78
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fr AS fr_2, t0.en AS en_3, t0.es AS es_4 FROM cal_translation t0 WHERE t0.id = ?"
  "params" => [
    1 => 168
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.created_at AS created_at_4, t0.position AS position_5, t0.accommodation_id AS accommodation_id_6, t0.room_id AS room_id_7 FROM cal_accommodation_image t0 WHERE t0.accommodation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.eco AS eco_2, t0.external_url AS external_url_3, t0.surface AS surface_4, t0.private_bathroom AS private_bathroom_5, t0.private_toilet AS private_toilet_6, t0.private_kitchen AS private_kitchen_7, t0.max_housing_assistance AS max_housing_assistance_8, t0.rent AS rent_9, t0.additional_rent AS additional_rent_10, t0.additional_rent_details AS additional_rent_details_11, t0.entrance_fees AS entrance_fees_12, t0.charges_fees AS charges_fees_13, t0.services_fees AS services_fees_14, t0.cleaning_fees AS cleaning_fees_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.disabled AS disabled_18, t0.booking_disabled AS booking_disabled_19, t0.booking_date_from AS booking_date_from_20, t0.ongoing_booking AS ongoing_booking_21, t0.accommodation_id AS accommodation_id_22, t0.name_id AS name_id_23, t0.description_id AS description_id_24, t0.occupancy_id AS occupancy_id_25, t0.stats_id AS stats_id_26 FROM cal_accommodation_room t0 WHERE t0.accommodation_id = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.label_id AS label_id_3, t0.description_id AS description_id_4, t0.image_id AS image_id_5, t0.list_id AS list_id_6 FROM cal_property_list_item t0 INNER JOIN cal_accommodations_transports ON t0.id = cal_accommodations_transports.property_list_item_id WHERE cal_accommodations_transports.accommodation_id = ?"
  "params" => [
    1 => 80
  ]
  "types" => [
    1 => 1
  ]
]