Symfony Profiler

[
  "route" => "dash.match.launch_slot"
  "route_parameters" => [
    "_route" => "dash.match.launch_slot"
    "_controller" => "App\Controller\Dashboard\MatchController::launchSlot"
    "format" => "individuel"
    "id" => "361"
  ]
  "request_uri" => "https://dev.odarts.blue.bzh/dashboard/match/individuel/361/launch-slot"
  "method" => "POST"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/var/www/html/odarts-dev/var/data_dev.db"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_seen_at AS last_seen_at_5 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin"
]

[
  "sql" => "UPDATE user SET last_seen_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:13:47"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.id = ?"
  "params" => [
    1 => "361"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.format AS format_3, t0.start_at AS start_at_4, t0.finish_at AS finish_at_5, t0.is_locked AS is_locked_6, t0.nb_targets AS nb_targets_7, t0.nb_poule AS nb_poule_8, t0.players_per_poule AS players_per_poule_9, t0.min_players AS min_players_10, t0.max_players AS max_players_11, t0.is_full AS is_full_12, t0.slot_duration AS slot_duration_13, t0.break_duration AS break_duration_14, t0.max_manches_poule AS max_manches_poule_15, t0.max_manches_finale AS max_manches_finale_16, t0.current_step AS current_step_17, t0.organizer_name AS organizer_name_18 FROM tournament t0 WHERE t0.format = ? ORDER BY t0.start_at DESC LIMIT 1"
  "params" => [
    1 => "individuel"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.slot_start AS slot_start_1, m0_.slot_end AS slot_end_2, m0_.status AS status_3, m0_.score_a AS score_a_4, m0_.score_b AS score_b_5, m0_.round_index AS round_index_6, m0_.display_order AS display_order_7, m0_.target AS target_8, p1_.id AS id_9, p1_.name AS name_10, p1_.is_locked AS is_locked_11, p2_.id AS id_12, p2_.name AS name_13, p2_.rating AS rating_14, p2_.level AS level_15, p2_.is_paid AS is_paid_16, p2_.is_coming AS is_coming_17, p3_.id AS id_18, p3_.name AS name_19, p3_.rating AS rating_20, p3_.level AS level_21, p3_.is_paid AS is_paid_22, p3_.is_coming AS is_coming_23, m0_.tournament_id AS tournament_id_24, m0_.poule_id AS poule_id_25, m0_.participant_a_id AS participant_a_id_26, m0_.participant_b_id AS participant_b_id_27, p1_.tournament_id AS tournament_id_28, p2_.tournament_id AS tournament_id_29, p2_.poule_id AS poule_id_30, p3_.tournament_id AS tournament_id_31, p3_.poule_id AS poule_id_32 FROM match_game m0_ LEFT JOIN poule p1_ ON m0_.poule_id = p1_.id LEFT JOIN participant p2_ ON m0_.participant_a_id = p2_.id LEFT JOIN participant p3_ ON m0_.participant_b_id = p3_.id WHERE m0_.tournament_id = ? ORDER BY m0_.slot_start ASC, m0_.display_order ASC, m0_.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:13:00"
    2 => "2026-03-11 17:43:00"
    3 => 361
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:13:00"
    2 => "2026-03-11 17:43:00"
    3 => 367
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:13:00"
    2 => "2026-03-11 17:43:00"
    3 => 373
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:13:00"
    2 => "2026-03-11 17:43:00"
    3 => 379
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:48:00"
    2 => "2026-03-11 18:18:00"
    3 => 362
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:48:00"
    2 => "2026-03-11 18:18:00"
    3 => 368
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:48:00"
    2 => "2026-03-11 18:18:00"
    3 => 374
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 17:48:00"
    2 => "2026-03-11 18:18:00"
    3 => 380
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:23:00"
    2 => "2026-03-11 18:53:00"
    3 => 363
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:23:00"
    2 => "2026-03-11 18:53:00"
    3 => 369
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:23:00"
    2 => "2026-03-11 18:53:00"
    3 => 375
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:23:00"
    2 => "2026-03-11 18:53:00"
    3 => 381
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:58:00"
    2 => "2026-03-11 19:28:00"
    3 => 364
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:58:00"
    2 => "2026-03-11 19:28:00"
    3 => 370
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:58:00"
    2 => "2026-03-11 19:28:00"
    3 => 376
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 18:58:00"
    2 => "2026-03-11 19:28:00"
    3 => 382
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 19:33:00"
    2 => "2026-03-11 20:03:00"
    3 => 365
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 19:33:00"
    2 => "2026-03-11 20:03:00"
    3 => 371
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 19:33:00"
    2 => "2026-03-11 20:03:00"
    3 => 377
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 19:33:00"
    2 => "2026-03-11 20:03:00"
    3 => 383
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 20:08:00"
    2 => "2026-03-11 20:38:00"
    3 => 366
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 20:08:00"
    2 => "2026-03-11 20:38:00"
    3 => 372
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 20:08:00"
    2 => "2026-03-11 20:38:00"
    3 => 378
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE match_game SET slot_start = ?, slot_end = ? WHERE id = ?"
  "params" => [
    1 => "2026-03-11 20:08:00"
    2 => "2026-03-11 20:38:00"
    3 => 384
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#742
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#742}
    3 => Doctrine\DBAL\ParameterType {#696
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]