Symfony Profiler

[
  "route" => "app_user_app_user_find"
  "route_parameters" => [
    "_route" => "app_user_app_user_find"
    "_controller" => "App\Controller\UserController::find"
  ]
  "request_uri" => "https://kms-rdc.net/api/user/find"
  "method" => "POST"
]

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

[
  "firewall_name" => "api"
  "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" => "kmsrd2762657"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "kmsrd2762657"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = ? LIMIT 1"
  "params" => [
    1 => "0899843151"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1035
    -user: App\Entity\User {#837 …}
    -roleNames: [
      "ROLE_SECRETAIRE"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODQwNDQ3MDUsImV4cCI6MTc4NDA0ODMwNSwicm9sZXMiOlsiUk9MRV9TRUNSRVRBSVJFIiwiUk9MRV9VU0VSIl0sInVzZXJuYW1lIjoiMDg5OTg0MzE1MSJ9.pbM2R0KbMMJVCIQfWfbRSz8sXZ4hXrdXjJkk4NTmehHk1JRRx0qe2nwvJrCQ02HAyZeAqgG9I4pZbr9OBxWYO9Zq8UR_3DppLu9KEVXf5okp0C1HqGMNbFZZaccd6JAF10jdPn3uwzJKbtvK_VEULGrB_rAtXiF9QdVzjY2KrnHq5_ZE0EVg2_xUMfcd9HGcXOvUGYIjPp8jfhIq3FTYm7XmWyGBIiqEE7llhIzLstsMAecPvGjK3P3AZavGcAgnNTQ14cgqqA6GI6OC8qg1TS4sqG46D8KrMfskZWUoyKv74fOGKMMiczuLy4HKlIBTDsI9Rg69h7XgD0dJufkv7cjzri-haT-cEwJwTboZ516XqXRjCoUp4gE-_a-DjJ3aSbjxJFz-PnqdcaTB_OfULTUlurgGTgC0Tyk76Wi9ajOYtICZu2B06pW5HmOxInuyGrMLcvLWgH518jZHyY0_n-TDzmSpUrS4g9MDZRbCMoTsI94ed8Qph6sUNoOZkkv13y2YhOPyHp8eqFDMUsJSz9_-KZ8a4QkNTjXEqpF0Q5sSRZJCeAx5VJPW-VapnTC2z6m0rJ9tJVd8cGjWQGYGj3yY7_vyghq6C_x_BPVdluilHFmmi4PtM1CwqwwIbh1rbA5p4cErR95Ugr2O0RAGV9qS6HAb1XL_lX88ywCNRgE"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = ?) LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id ORDER BY u0_.last_name ASC) dctrn_result) dctrn_table"
  "params" => [
    1 => "ACTIVE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, last_name_3 FROM (SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, f1_.id AS id_12, f1_.debut_at AS debut_at_13, f1_.end_at AS end_at_14, f1_.status AS status_15, f1_.created_at AS created_at_16 FROM user u0_ LEFT JOIN city c2_ ON u0_.city_id = c2_.id LEFT JOIN province p3_ ON c2_.province_id = p3_.id LEFT JOIN fonction_history f1_ ON u0_.id = f1_.user_id AND (f1_.status = ?) LEFT JOIN fonction f4_ ON f1_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id) dctrn_result_inner ORDER BY last_name_3 ASC) dctrn_result LIMIT 25"
  "params" => [
    1 => "ACTIVE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.middle_name AS middle_name_2, u0_.last_name AS last_name_3, u0_.gender AS gender_4, u0_.location AS location_5, u0_.phone AS phone_6, u0_.login AS login_7, u0_.password AS password_8, u0_.roles AS roles_9, u0_.created_at AS created_at_10, u0_.status AS status_11, u0_.city_id AS city_id_12, u0_.parking_id AS parking_id_13 FROM user u0_ LEFT JOIN city c1_ ON u0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN fonction_history f3_ ON u0_.id = f3_.user_id AND (f3_.status = ?) LEFT JOIN fonction f4_ ON f3_.fonction_id = f4_.id LEFT JOIN service s5_ ON f4_.service_id = s5_.id LEFT JOIN organization o6_ ON s5_.organization_id = o6_.id WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.last_name ASC"
  "params" => [
    1 => "ACTIVE"
    2 => 19
    3 => 23
    4 => 14
    5 => 16
    6 => 10
    7 => 20
    8 => 22
    9 => 11
    10 => 9
    11 => 25
    12 => 17
    13 => 1
    14 => 12
    15 => 21
    16 => 18
    17 => 24
    18 => 13
    19 => 26
    20 => 27
    21 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
    3 => Doctrine\DBAL\ParameterType {#841}
    4 => Doctrine\DBAL\ParameterType {#841}
    5 => Doctrine\DBAL\ParameterType {#841}
    6 => Doctrine\DBAL\ParameterType {#841}
    7 => Doctrine\DBAL\ParameterType {#841}
    8 => Doctrine\DBAL\ParameterType {#841}
    9 => Doctrine\DBAL\ParameterType {#841}
    10 => Doctrine\DBAL\ParameterType {#841}
    11 => Doctrine\DBAL\ParameterType {#841}
    12 => Doctrine\DBAL\ParameterType {#841}
    13 => Doctrine\DBAL\ParameterType {#841}
    14 => Doctrine\DBAL\ParameterType {#841}
    15 => Doctrine\DBAL\ParameterType {#841}
    16 => Doctrine\DBAL\ParameterType {#841}
    17 => Doctrine\DBAL\ParameterType {#841}
    18 => Doctrine\DBAL\ParameterType {#841}
    19 => Doctrine\DBAL\ParameterType {#841}
    20 => Doctrine\DBAL\ParameterType {#841}
    21 => Doctrine\DBAL\ParameterType {#841}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.province_id AS province_id_5 FROM city t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.debut_at AS debut_at_2, t0.end_at AS end_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.fonction_id AS fonction_id_6, t0.user_id AS user_id_7 FROM fonction_history t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]