Symfony Profiler

[
  "route" => "legal_note"
  "route_parameters" => [
    "_route" => "legal_note"
    "_controller" => "App\Controller\LegalController::legalNote"
    "_locale" => "ca"
  ]
  "request_uri" => "https://www.hotelpeninsulargirona.com/ca/avis-legal"
  "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" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "u461891110_nvr_hpen_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u461891110_nvr_hpen_datum"
    "serverVersion" => "11.8.3-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.updated_at AS updated_at_4, t0.is_published AS is_published_5, t0.video AS video_6, t0.main_image_id AS main_image_id_7 FROM page t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "legal_note"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#995
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.slug AS slug_4, t0.introduction AS introduction_5, t0.page_id AS page_id_6, t0.language_id AS language_id_7, t0.seo_id AS seo_id_8 FROM page_content t0 WHERE t0.page_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5, t0.listing_image_id AS listing_image_id_6 FROM room t0 WHERE t0.is_published = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2245
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 7
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 8
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 9
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 10
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 11
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 ORDER BY t0.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.is_published AS is_published_3, t0.position AS position_4, t0.main_image_id AS main_image_id_5, t0.listing_image_id AS listing_image_id_6 FROM room t0 WHERE t0.is_published = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2245
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 7
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 8
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 9
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 10
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.intro AS intro_5, t0.body AS body_6, t0.room_id AS room_id_7, t0.language_id AS language_id_8, t0.seo_id AS seo_id_9 FROM room_content t0 WHERE t0.room_id = ? AND t0.language_id = ? LIMIT 1"
  "params" => [
    1 => 11
    2 => "ca"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#997
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#997}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4 FROM language t0 ORDER BY t0.position ASC"
]