Symfony Profiler

[
  "route" => "app_ticketsync_offline_ticket"
  "route_parameters" => [
    "_route" => "app_ticketsync_offline_ticket"
    "_controller" => "App\Controller\TicketController::syncOffline_ticket"
  ]
  "request_uri" => "https://kms-rdc.net/api/ticket/sync-offline"
  "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 => "0986351277"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1035
    -user: App\Entity\User {#837 …}
    -roleNames: [
      "ROLE_OPERATEUR"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODQwNDY1OTIsImV4cCI6MTc4NDA1MDE5Miwicm9sZXMiOlsiUk9MRV9PUEVSQVRFVVIiLCJST0xFX1VTRVIiXSwidXNlcm5hbWUiOiIwOTg2MzUxMjc3In0.IDMukqvtphshfJPj63jEuk_VXdft7qbwTdlY_nksYLe6tpVBYSEYHhX0Q-Sg6eBIkK0wWkzlCq37P61Vb6E0yPaJDSY5S-ZKBrlr1sPKCy1NOfdRG8T4XsbQR3Am62YAWWoZ3QKd0InDl79gpaF_hc400ysRkGO5MQXlIVzUzkoXy-WiQdABJ54pW-Lj9FZBt5t4u87crplCl3xoXzGONJbEOpImwoyMqvf0C7ScAZksaQQrL0RTfvc41jTK4hbWP2lQiWooCpw6lreaMI7YAi6gnW0HlS6V22dXKlnzJJFZ7NLhnkuljw5RjosjJ_HAXwT66NIaoy9imGS_AIHlcnX7woM7OdGSqWzulRBUdqUldP-5pXMutdBDhrMV3UKn_F-NoSq1HPGmOXbOorZ6vCnbSZm-3_dQK7LlKzasv9DDNyMy_1i_EuknrVQe2agm420yUZju2lCvRPQ91HwJDW5LcIQAKSZesV-86OZgN6JfjaH7GuCdxjKm0dgHfHKnKCZzHRaMndO3EDwRxCXhxP0qBkjKj9wEcvAaK1fcHZ3p_RQnO8l-LIn5Ryu2n2VTjrciKjdLQ1_QQgnmeINlrau3m3FO8x63aIUzQ6-C5QSyBL2n2g4esslWNK6Mkc9WjR83uZkGOUMjtl--Hh5qqEVwjcrx2G8S9dJXxFsqlus"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

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

[
  "sql" => "SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.created_at AS created_at_2, b0_.validity AS validity_3, b0_.vehicle_type AS vehicle_type_4, b0_.amount AS amount_5, b0_.identifier_mode AS identifier_mode_6, b0_.created_by_id AS created_by_id_7, b0_.motor_id AS motor_id_8, b0_.person_id AS person_id_9, b0_.terminal_id AS terminal_id_10, b0_.parking_id AS parking_id_11, b0_.voiture_id AS voiture_id_12 FROM billet b0_ LEFT JOIN motor m1_ ON b0_.motor_id = m1_.id LEFT JOIN voiture v2_ ON b0_.voiture_id = v2_.id WHERE (b0_.created_at >= ? AND b0_.created_at < ?) AND (m1_.plaque = ? OR v2_.plaque = ?) ORDER BY b0_.created_at DESC LIMIT 1"
  "params" => [
    1 => "2026-07-14 00:00:00"
    2 => "2026-07-15 00:00:00"
    3 => "092BE"
    4 => "092BE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#839}
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#839}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.plaque = ? LIMIT 1"
  "params" => [
    1 => "092BE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.firs_name AS firs_name_2, t0.last_name AS last_name_3, t0.location AS location_4, t0.phone_number AS phone_number_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.details_status AS details_status_8 FROM driver t0 WHERE t0.phone_number = ? LIMIT 1"
  "params" => [
    1 => "0896380266"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.created_at AS created_at_3, t0.validity AS validity_4, t0.vehicle_type AS vehicle_type_5, t0.amount AS amount_6, t0.identifier_mode AS identifier_mode_7, t0.created_by_id AS created_by_id_8, t0.motor_id AS motor_id_9, t0.person_id AS person_id_10, t0.terminal_id AS terminal_id_11, t0.parking_id AS parking_id_12, t0.voiture_id AS voiture_id_13 FROM billet t0 WHERE t0.reference = ? LIMIT 1"
  "params" => [
    1 => "KMS-VILLE2-17-1784021255989-65SS-092BE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.login_at AS login_at_2, t0.user_id AS user_id_3, t0.terminal_id AS terminal_id_4, t0.parking_id AS parking_id_5 FROM session t0 WHERE t0.id = ?"
  "params" => [
    1 => 718
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.model AS model_3, t0.label AS label_4, t0.code AS code_5, t0.imei AS imei_6, t0.os AS os_7, t0.status AS status_8, t0.visible_roles AS visible_roles_9, t0.visible_roles_from AS visible_roles_from_10, t0.created_at AS created_at_11, t0.created_by_id AS created_by_id_12, t0.parking_id AS parking_id_13 FROM terminal t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "PONT VILLE 2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
  ]
]

[
  "sql" => "INSERT INTO billet (reference, created_at, validity, vehicle_type, amount, identifier_mode, created_by_id, motor_id, person_id, terminal_id, parking_id, voiture_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "KMS-VILLE2-17-1784021255989-65SS-092BE"
    2 => "2026-07-14 09:27:36"
    3 => 1
    4 => "moto"
    5 => 1000
    6 => "plaque"
    7 => 17
    8 => 3855
    9 => 1767
    10 => 17
    11 => null
    12 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#839}
    3 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#839}
    5 => Doctrine\DBAL\ParameterType {#841}
    6 => Doctrine\DBAL\ParameterType {#839}
    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}
  ]
]

[
  "sql" => "DELETE FROM ticket_visibility WHERE billet_id = ?"
  "params" => [
    1 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_ADMIN"
    2 => 1
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_MAIRE"
    2 => 1
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_SUPER_ADMIN"
    2 => 0
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_SECRETAIRE"
    2 => 1
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_OPERATEUR"
    2 => 0
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_PERCEPTEUR"
    2 => 0
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "ROLE_USER"
    2 => 0
    3 => "2026-07-14 17:30:46"
    4 => 20544
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#839
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1697
      +name: "BOOLEAN"
    }
    3 => Doctrine\DBAL\ParameterType {#839}
    4 => Doctrine\DBAL\ParameterType {#841
      +name: "INTEGER"
    }
  ]
]