Symfony Profiler

[
  "route" => "_api_/{_locale}/rooms_get"
  "route_parameters" => [
    "_route" => "_api_/{_locale}/rooms_get"
    "_controller" => "App\Controller\Api\RoomController"
    "_stateless" => true
    "_api_resource_class" => "App\Entity\Room"
    "_api_operation_name" => "_api_/{_locale}/rooms_get"
    "_format" => null
    "_locale" => "fr"
  ]
  "request_uri" => "https://api-ongi.nathandierickx.com/fr/rooms"
  "method" => "GET"
]

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

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "ongi-ettori"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ongi-ettori"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.size AS size_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.disabled_at AS disabled_at_5, t0.active AS active_6, t0.bed_id AS bed_id_7, t0.tax_rule_id AS tax_rule_id_8 FROM room t0 WHERE t0.active = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1058
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = ?"
  "params" => [
    1 => b"\x13BÁ"¨\x07L\x03"\eœóËm6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bed_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"\x13BÁ"¨\x07L\x03"\eœóËm6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b".\t2|\x07 DC˜iŽ­Z¬¼í"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"NóyÔ\x0E°J¡‰\x7F«"\x02\x18™\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"c\x0F/Iç&HÁ¢ È,gYy§"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"w\x1E\x16»×ÅO\x15´Sæ€\x19Ø.b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM equipment_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"պѠMcFúŽKÖíi>\eí"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"'f\x7F¿¾‚F;·ëXŠØXW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.active AS active_2 FROM bed t0 WHERE t0.id = ?"
  "params" => [
    1 => b"ì\f¤zèò@­áõA3q\x1CS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bed_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"ì\f¤zèò@­áõA3q\x1CS"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"m3(N\x1E„M¶µÝÔ玟«\x1D"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.icon AS icon_2, t0.active AS active_3 FROM equipment t0 INNER JOIN room_equipment ON t0.id = room_equipment.equipment_id WHERE room_equipment.room_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.filename AS filename_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.disabled_at AS disabled_at_6, t0.active AS active_7, t0.room_id AS room_id_8 FROM room_gallery t0 WHERE t0.room_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.type AS type_5, t0.active AS active_6 FROM availability t0 INNER JOIN availability_room ON t0.id = availability_room.availability_id WHERE availability_room.room_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.minimum_nights AS minimum_nights_2, t0.maximum_nights AS maximum_nights_3, t0.active AS active_4 FROM stay_duration t0 INNER JOIN stay_duration_room ON t0.id = stay_duration_room.stay_duration_id WHERE stay_duration_room.room_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.week_day AS week_day_3, t0.active AS active_4 FROM stay_day t0 INNER JOIN stay_day_room ON t0.id = stay_day_room.stay_day_id WHERE stay_day_room.room_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.view AS view_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9 FROM room_translation t0 WHERE t0.translatable_id = ?"
  "params" => [
    1 => b"Ï3ý¿\x18ºO¥¦w<Î\x04‚þ\x10"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1061
      +name: "STRING"
    }
  ]
]