Symfony Profiler

[
  "route" => "booking_room_fr"
  "route_parameters" => [
    "_route" => "booking_room_fr"
    "_controller" => "App\Controller\Front\BookingController::room"
    "_locale" => "fr"
    "establishmentslug" => "boa-karaoke-ixelles"
  ]
  "request_uri" => "https://www.boa.hb-preprod.com/reserver/boa-karaoke-ixelles"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "dx9765.myd.infomaniak.com"
    "port" => 3306
    "user" => "dx9765_boa_karao"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "dx9765_boa_karaoke"
    "serverVersion" => "8.0.37"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, e1_.translatable_id AS translatable_id_30 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) ORDER BY e0_.sort ASC"
  "params" => [
    1 => "fr"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "boa-karaoke-ixelles"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "boa-karaoke-ixelles"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.short_title AS short_title_4, t0.sub_title AS sub_title_5, t0.address AS address_6, t0.city AS city_7, t0.country AS country_8, t0.schedule AS schedule_9, t0.additional_information AS additional_information_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_image AS seo_image_13, t0.locale AS locale_14, t0.translatable_id AS translatable_id_15 FROM establishment_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "nl"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.post_code AS post_code_1, e0_.facebook_link AS facebook_link_2, e0_.instagram_link AS instagram_link_3, e0_.pinterest_link AS pinterest_link_4, e0_.linkedin_link AS linkedin_link_5, e0_.tiktok_link AS tiktok_link_6, e0_.youtube_link AS youtube_link_7, e0_.vimeo_link AS vimeo_link_8, e0_.email_link AS email_link_9, e0_.phone_link AS phone_link_10, e0_.email_order AS email_order_11, e0_.mollie_api_key AS mollie_api_key_12, e0_.image AS image_13, e0_.is_active AS is_active_14, e0_.sort AS sort_15, e1_.id AS id_16, e1_.title AS title_17, e1_.slug AS slug_18, e1_.short_title AS short_title_19, e1_.sub_title AS sub_title_20, e1_.address AS address_21, e1_.city AS city_22, e1_.country AS country_23, e1_.schedule AS schedule_24, e1_.additional_information AS additional_information_25, e1_.seo_title AS seo_title_26, e1_.seo_description AS seo_description_27, e1_.seo_image AS seo_image_28, e1_.locale AS locale_29, r2_.id AS id_30, r2_.minimum_number_of_people AS minimum_number_of_people_31, r2_.maximum_number_of_people AS maximum_number_of_people_32, r2_.percentage_of_deposit AS percentage_of_deposit_33, r2_.minimum_price_with_tax AS minimum_price_with_tax_34, r2_.sort AS sort_35, r2_.background_color_checkout AS background_color_checkout_36, r3_.id AS id_37, r3_.title AS title_38, r3_.slug AS slug_39, r3_.seo_title AS seo_title_40, r3_.seo_description AS seo_description_41, r3_.seo_image AS seo_image_42, r3_.locale AS locale_43, r4_.id AS id_44, r4_.day_of_week AS day_of_week_45, r4_.hour_begin AS hour_begin_46, r4_.hour_end AS hour_end_47, r4_.date_begin AS date_begin_48, r4_.date_end AS date_end_49, r4_.price_with_tax AS price_with_tax_50, r4_.sort AS sort_51, r5_.id AS id_52, r5_.image AS image_53, r5_.sort AS sort_54, a6_.id AS id_55, a6_.duration AS duration_56, a6_.days_of_week AS days_of_week_57, a6_.is_price_depend_number_of_people AS is_price_depend_number_of_people_58, a6_.price_per_person AS price_per_person_59, a6_.is_price_supplement AS is_price_supplement_60, a6_.price_supplement_type AS price_supplement_type_61, a6_.price_supplement_value AS price_supplement_value_62, a6_.duration_between_booking AS duration_between_booking_63, a6_.sort AS sort_64, a7_.id AS id_65, a7_.title AS title_66, a7_.description AS description_67, a7_.message_error AS message_error_68, a7_.locale AS locale_69, e1_.translatable_id AS translatable_id_70, r2_.establishment_id AS establishment_id_71, r3_.translatable_id AS translatable_id_72, r4_.room_id AS room_id_73, r5_.room_id AS room_id_74, a7_.translatable_id AS translatable_id_75 FROM establishment e0_ LEFT JOIN establishment_translation e1_ ON e0_.id = e1_.translatable_id AND (e1_.locale = ?) LEFT JOIN room r2_ ON e0_.id = r2_.establishment_id LEFT JOIN room_translation r3_ ON r2_.id = r3_.translatable_id AND (r3_.locale = ?) LEFT JOIN room_price r4_ ON r2_.id = r4_.room_id LEFT JOIN room_image r5_ ON r2_.id = r5_.room_id LEFT JOIN activity_room a8_ ON r2_.id = a8_.room_id LEFT JOIN activity a6_ ON a6_.id = a8_.activity_id LEFT JOIN activity_translation a7_ ON a6_.id = a7_.translatable_id AND (a7_.locale = ?) WHERE e0_.is_active = ? AND e1_.slug = ? ORDER BY e0_.sort ASC, r2_.sort ASC, r4_.sort ASC, r5_.sort ASC"
  "params" => [
    1 => "fr"
    2 => "fr"
    3 => "fr"
    4 => 1
    5 => "boa-karaoke-ixelles"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#931}
    3 => Doctrine\DBAL\ParameterType {#931}
    4 => Doctrine\DBAL\ParameterType {#2998
      +name: "BOOLEAN"
    }
    5 => Doctrine\DBAL\ParameterType {#931}
  ]
]