Symfony Profiler

[
  "route" => "client_page_unified"
  "route_parameters" => [
    "_route" => "client_page_unified"
    "_controller" => "App\Controller\HomeController::page"
    "slug" => "mentions-legales"
  ]
  "request_uri" => "https://pepouzin2.devlogiciel.com/mentions-legales"
  "method" => "GET"
]

[
  "firewall_name" => "client_sites"
  "authenticators" => 0
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "app"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "app"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.domaine_id AS domaine_id_6, t0.site_id AS site_id_7, t0.user_id AS user_id_8 FROM sub_domain t0 WHERE t0.name = ? LIMIT 1"
  "params" => [
    1 => "pepouzin2.devlogiciel.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#883
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.domaine_id AS domaine_id_5, s0_.site_id AS site_id_6, s0_.user_id AS user_id_7 FROM sub_domain s0_ INNER JOIN domaine d1_ ON s0_.domaine_id = d1_.id WHERE s0_.name = ? AND (d1_.url = ? OR d1_.url = ?)"
  "params" => [
    1 => "pepouzin2"
    2 => "devlogiciel.com"
    3 => ".devlogiciel.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#883
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#883}
    3 => Doctrine\DBAL\ParameterType {#883}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.home_page AS home_page_4, t0.folder AS folder_5, t0.published AS published_6, t0.protected AS protected_7, t0.type_page AS type_page_8, t0.description AS description_9, t0.title_seo AS title_seo_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.deleted AS deleted_14, t0.site_id AS site_id_15 FROM page t0 WHERE t0.site_id = ? AND t0.slug = ? LIMIT 1"
  "params" => [
    1 => 6
    2 => "mentions-legales"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#883
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.background_color AS background_color_3, t0.is_synced AS is_synced_4, t0.page_id AS page_id_5, t0.bloc_id AS bloc_id_6 FROM page_bloc t0 WHERE t0.page_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?"
  "params" => [
    1 => 114
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC"
  "params" => [
    1 => 114
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?"
  "params" => [
    1 => 69
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC"
  "params" => [
    1 => 69
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.template_path AS template_path_4, t0.block_file_name AS block_file_name_5, t0.created_at AS created_at_6, t0.level AS level_7, t0.published AS published_8 FROM bloc t0 WHERE t0.id = ?"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.placeholder AS placeholder_4, t0.required AS required_5, t0.default_content AS default_content_6, t0.bloc_id AS bloc_id_7 FROM field t0 WHERE t0.bloc_id IN (?) ORDER BY t0.id ASC"
  "params" => [
    1 => 70
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.is_template AS is_template_4, t0.is_in_catalogue AS is_in_catalogue_5, t0.screenshot_path AS screenshot_path_6, t0.background_color AS background_color_7, t0.favicon AS favicon_8, t0.description AS description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.deleted AS deleted_13, t0.owner_id AS owner_id_14, t0.category_id AS category_id_15 FROM site t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.active AS active_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.is_subscription_active AS is_subscription_active_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.pennylane_customer_id AS pennylane_customer_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.subscription_end_date AS subscription_end_date_14, t0.pricing_plan_id AS pricing_plan_id_15 FROM "user" t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.telephone AS telephone_3, t0.objectif_site AS objectif_site_4, t0.secteur_activite AS secteur_activite_5, t0.consentement_rgpd AS consentement_rgpd_6, t0.outils_tiers AS outils_tiers_7, t0.nom_de_rue AS nom_de_rue_8, t0.numero AS numero_9, t0.code_postale AS code_postale_10, t0.ville AS ville_11, t0.pays AS pays_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.deleted AS deleted_16, t0.owner_id AS owner_id_17, t0.dtype, t0.raison_sociale AS raison_sociale_18, t0.forme_juridique AS forme_juridique_19, t0.siret AS siret_20, t0.tva_intracom AS tva_intracom_21, t0.nom_responsable_legal AS nom_responsable_legal_22, t0.type_projet AS type_projet_23 FROM user_information t0 WHERE t0.owner_id = ? AND t0.dtype IN ('user_info', 'entreprise', 'autre')"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 347
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 144
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.json AS json_3, t0.page_bloc_id AS page_bloc_id_4, t0.field_id AS field_id_5 FROM page_bloc_value t0 WHERE t0.page_bloc_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 145
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#885
      +name: "INTEGER"
    }
  ]
]