Symfony Profiler

[
  "route" => "_api_/admin/regions_get_collection"
  "route_parameters" => [
    "_route" => "_api_/admin/regions_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => false
    "_api_resource_class" => "App\Entity\Region"
    "_api_operation_name" => "_api_/admin/regions_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://nutrizaza.com/api/admin/regions?itemsPerPage=30&order%5Bdesignation%5D=asc"
  "method" => "GET"
]

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "ua6fa9.myd.infomaniak.com"
    "port" => null
    "user" => "ua6fa9_anim"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ua6fa9_anim"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.nom_prenom AS nom_prenom_7, t0.ebp_client_code AS ebp_client_code_8, t0.is_enabled AS is_enabled_9, t0.last_activity_at AS last_activity_at_10, t0.last_visite_at AS last_visite_at_11, t0.last_update_at AS last_update_at_12, t0.last_login_at AS last_login_at_13, t0.utilisateur_role_id AS utilisateur_role_id_14, t0.region_id AS region_id_15 FROM utilisateur t0 WHERE t0.id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "toavinaralambosoa@gmail.com"
]

[
  "sql" => "SELECT count(*) AS sclr_0 FROM region r0_"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.designation AS designation_2, r0_.numero AS numero_3, r0_.surface AS surface_4, ST_AsBinary(r0_.center) AS center_5, r0_.spatial_data_id AS spatial_data_id_6 FROM region r0_ ORDER BY r0_.designation ASC LIMIT 30"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.numero AS numero_4, t0.surface AS surface_5, ST_AsBinary(t0.center) AS center_6, t0.region_id AS region_id_7, t0.spatial_data_id AS spatial_data_id_8 FROM district t0 WHERE t0.region_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#45
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]