Symfony Profiler

[
  "route" => "establishment_index_fr"
  "route_parameters" => [
    "_route" => "establishment_index_fr"
    "_controller" => "App\Controller\Front\EstablishmentController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://www.boa.hb-preprod.com/etablissements"
  "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"
    }
  ]
]

[
  "key" => "establishment_index_fr"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.field AS field_2, c0_.controller AS controller_3, c0_.action AS action_4, c0_.is_sitemap AS is_sitemap_5, c0_.is_contain_default_content_generator AS is_contain_default_content_generator_6, c0_.sort AS sort_7, c1_.id AS id_8, c1_.path AS path_9, c1_.seo_title AS seo_title_10, c1_.seo_description AS seo_description_11, c1_.seo_image AS seo_image_12, c1_.locale AS locale_13, c2_.id AS id_14, c2_.is_deletable AS is_deletable_15, c2_.sort AS sort_16, c3_.id AS id_17, c3_.name AS name_18, c3_.field AS field_19, c3_.type AS type_20, c4_.id AS id_21, c4_.name AS name_22, c4_.field AS field_23, c4_.type AS type_24, c4_.description AS description_25, c4_.options AS options_26, c4_.is_translation AS is_translation_27, c4_.is_required AS is_required_28, c4_.sort AS sort_29, c5_.id AS id_30, c5_.value AS value_31, c6_.id AS id_32, c6_.translation AS translation_33, c6_.locale AS locale_34, c7_.id AS id_35, c7_.name AS name_36, c7_.field AS field_37, c7_.type AS type_38, c7_.description AS description_39, c7_.options AS options_40, c7_.is_translation AS is_translation_41, c7_.is_required AS is_required_42, c7_.sort AS sort_43, c1_.translatable_id AS translatable_id_44, c2_.cms_generator_id AS cms_generator_id_45, c2_.cms_page_id AS cms_page_id_46, c4_.cms_generator_id AS cms_generator_id_47, c5_.cms_generator_page_id AS cms_generator_page_id_48, c5_.cms_generator_content_id AS cms_generator_content_id_49, c6_.translatable_id AS translatable_id_50, c7_.cms_generator_id AS cms_generator_id_51 FROM cms_page c0_ LEFT JOIN cms_page_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = ?) LEFT JOIN cms_generator_page c2_ ON c0_.id = c2_.cms_page_id LEFT JOIN cms_generator c3_ ON c2_.cms_generator_id = c3_.id LEFT JOIN cms_generator_content c4_ ON c3_.id = c4_.cms_generator_id LEFT JOIN cms_page_content c5_ ON c2_.id = c5_.cms_generator_page_id LEFT JOIN cms_page_content_translation c6_ ON c5_.id = c6_.translatable_id AND (c6_.locale = ?) LEFT JOIN cms_generator_content c7_ ON c5_.cms_generator_content_id = c7_.id WHERE c0_.field = ? ORDER BY c2_.sort ASC, c4_.sort ASC"
  "params" => [
    1 => "fr"
    2 => "fr"
    3 => "establishment_index"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#931
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#931}
    3 => Doctrine\DBAL\ParameterType {#931}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?, ?, ?) ORDER BY t0.sort ASC"
  "params" => [
    1 => 20
    2 => 2
    3 => 19
    4 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 44
    2 => 33
    3 => 43
    4 => 42
    5 => 41
    6 => 40
    7 => 39
    8 => 38
    9 => 34
    10 => 26
    11 => 27
    12 => 56
    13 => 28
    14 => 13
    15 => 58
    16 => 59
    17 => 15
    18 => 62
    19 => 52
    20 => 54
    21 => 17
    22 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
    5 => Doctrine\DBAL\ParameterType {#1068}
    6 => Doctrine\DBAL\ParameterType {#1068}
    7 => Doctrine\DBAL\ParameterType {#1068}
    8 => Doctrine\DBAL\ParameterType {#1068}
    9 => Doctrine\DBAL\ParameterType {#1068}
    10 => Doctrine\DBAL\ParameterType {#1068}
    11 => Doctrine\DBAL\ParameterType {#1068}
    12 => Doctrine\DBAL\ParameterType {#1068}
    13 => Doctrine\DBAL\ParameterType {#1068}
    14 => Doctrine\DBAL\ParameterType {#1068}
    15 => Doctrine\DBAL\ParameterType {#1068}
    16 => Doctrine\DBAL\ParameterType {#1068}
    17 => Doctrine\DBAL\ParameterType {#1068}
    18 => Doctrine\DBAL\ParameterType {#1068}
    19 => Doctrine\DBAL\ParameterType {#1068}
    20 => Doctrine\DBAL\ParameterType {#1068}
    21 => Doctrine\DBAL\ParameterType {#1068}
    22 => Doctrine\DBAL\ParameterType {#1068}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC"
  "params" => [
    1 => 17
    2 => 10
    3 => 16
    4 => 15
    5 => 14
    6 => 13
    7 => 12
    8 => 6
    9 => 7
    10 => 9
    11 => 1
    12 => 18
    13 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
    5 => Doctrine\DBAL\ParameterType {#1068}
    6 => Doctrine\DBAL\ParameterType {#1068}
    7 => Doctrine\DBAL\ParameterType {#1068}
    8 => Doctrine\DBAL\ParameterType {#1068}
    9 => Doctrine\DBAL\ParameterType {#1068}
    10 => Doctrine\DBAL\ParameterType {#1068}
    11 => Doctrine\DBAL\ParameterType {#1068}
    12 => Doctrine\DBAL\ParameterType {#1068}
    13 => Doctrine\DBAL\ParameterType {#1068}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.cms_generator_page_id AS cms_generator_page_id_3, t0.cms_generator_content_id AS cms_generator_content_id_4 FROM cms_page_content t0 WHERE t0.cms_generator_page_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 51
    2 => 1
    3 => 46
    4 => 36
    5 => 37
    6 => 57
    7 => 48
    8 => 60
    9 => 49
    10 => 29
    11 => 50
    12 => 30
    13 => 14
    14 => 61
    15 => 16
    16 => 18
    17 => 45
    18 => 25
    19 => 55
    20 => 53
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
    5 => Doctrine\DBAL\ParameterType {#1068}
    6 => Doctrine\DBAL\ParameterType {#1068}
    7 => Doctrine\DBAL\ParameterType {#1068}
    8 => Doctrine\DBAL\ParameterType {#1068}
    9 => Doctrine\DBAL\ParameterType {#1068}
    10 => Doctrine\DBAL\ParameterType {#1068}
    11 => Doctrine\DBAL\ParameterType {#1068}
    12 => Doctrine\DBAL\ParameterType {#1068}
    13 => Doctrine\DBAL\ParameterType {#1068}
    14 => Doctrine\DBAL\ParameterType {#1068}
    15 => Doctrine\DBAL\ParameterType {#1068}
    16 => Doctrine\DBAL\ParameterType {#1068}
    17 => Doctrine\DBAL\ParameterType {#1068}
    18 => Doctrine\DBAL\ParameterType {#1068}
    19 => Doctrine\DBAL\ParameterType {#1068}
    20 => Doctrine\DBAL\ParameterType {#1068}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.field AS field_3, t0.type AS type_4, t0.description AS description_5, t0.options AS options_6, t0.is_translation AS is_translation_7, t0.is_required AS is_required_8, t0.sort AS sort_9, t0.cms_generator_id AS cms_generator_id_10 FROM cms_generator_content t0 WHERE t0.cms_generator_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC"
  "params" => [
    1 => 25
    2 => 3
    3 => 24
    4 => 22
    5 => 23
    6 => 11
    7 => 6
    8 => 21
    9 => 17
    10 => 4
    11 => 7
    12 => 15
    13 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
    5 => Doctrine\DBAL\ParameterType {#1068}
    6 => Doctrine\DBAL\ParameterType {#1068}
    7 => Doctrine\DBAL\ParameterType {#1068}
    8 => Doctrine\DBAL\ParameterType {#1068}
    9 => Doctrine\DBAL\ParameterType {#1068}
    10 => Doctrine\DBAL\ParameterType {#1068}
    11 => Doctrine\DBAL\ParameterType {#1068}
    12 => Doctrine\DBAL\ParameterType {#1068}
    13 => Doctrine\DBAL\ParameterType {#1068}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.is_deletable AS is_deletable_2, t0.sort AS sort_3, t0.cms_generator_id AS cms_generator_id_4, t5.id AS id_6, t5.name AS name_7, t5.field AS field_8, t5.type AS type_9, t0.cms_page_id AS cms_page_id_10, t11.id AS id_12, t11.name AS name_13, t11.field AS field_14, t11.controller AS controller_15, t11.action AS action_16, t11.is_sitemap AS is_sitemap_17, t11.is_contain_default_content_generator AS is_contain_default_content_generator_18, t11.sort AS sort_19 FROM cms_generator_page t0 INNER JOIN cms_generator t5 ON t0.cms_generator_id = t5.id INNER JOIN cms_page t11 ON t0.cms_page_id = t11.id WHERE t0.cms_generator_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sort ASC"
  "params" => [
    1 => 25
    2 => 3
    3 => 24
    4 => 22
    5 => 23
    6 => 11
    7 => 6
    8 => 21
    9 => 17
    10 => 4
    11 => 7
    12 => 15
    13 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1068
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1068}
    3 => Doctrine\DBAL\ParameterType {#1068}
    4 => Doctrine\DBAL\ParameterType {#1068}
    5 => Doctrine\DBAL\ParameterType {#1068}
    6 => Doctrine\DBAL\ParameterType {#1068}
    7 => Doctrine\DBAL\ParameterType {#1068}
    8 => Doctrine\DBAL\ParameterType {#1068}
    9 => Doctrine\DBAL\ParameterType {#1068}
    10 => Doctrine\DBAL\ParameterType {#1068}
    11 => Doctrine\DBAL\ParameterType {#1068}
    12 => Doctrine\DBAL\ParameterType {#1068}
    13 => Doctrine\DBAL\ParameterType {#1068}
  ]
]