Symfony Profiler

[
  "route" => "app_daily_report_find"
  "route_parameters" => [
    "_route" => "app_daily_report_find"
    "_controller" => "App\Controller\DailyReportController::find"
  ]
  "request_uri" => "https://kms-rdc.net/api/daily-report/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 {#838
      +name: "STRING"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1034
    -user: App\Entity\User {#836 …}
    -roleNames: [
      "ROLE_SECRETAIRE"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3ODMwMDQ0NzUsImV4cCI6MTc4MzAwODA3NSwicm9sZXMiOlsiUk9MRV9TRUNSRVRBSVJFIiwiUk9MRV9VU0VSIl0sInVzZXJuYW1lIjoiMDg5OTg0MzE1MSJ9.lEK73iT2rx-6ocqATV3NGPXctf_XpxVHEhc99XrwoZfAyYMoyDIoKFrJoims2_NMTORlFUoSk7D-kh9NQFCzRPcqmX8yAe1zS7DN1ZPTIry-BhOhVxRCuJgkLz3K92Zze-IVTbXhh23I8SOBnk4z4qRLywUdkz_QD65IPdocfbMLy6HXTkQ2MMmjumZjThTXbqE9zr-F2M96ph-FB_2O4d5OvXhWBb-c262TKW98JPULyNZ8K2LO6UXiPAOlBvf2x5PBfOU9AUxD0k4FMT1Kt31mmiJaIarOsQh7fY1Uw476TQ22YP7i0O-8byE-lbKFHUWenP3HH4ljerwQFvNEBmIEC77nYCqOiclrgjCgvpf7v_thgb6o1cje_kIGV1_wYt9Qy4_d2SdRPiDRZBSfEy25N5LBGePiwkczgwC534grkQDH6DuESr63meekyLXkK9bk6UumiE1PExqi7IPbxUJoATKQGDEaOa6yfkleYD2OMCunjhFMzUrwXHJGLMiR6HE8W38HyjPzraRA-z6su86toeT07UuRttCcZHRGEjOno4naebVaoJ0jdw1P-NOgFU7Qn-ck5jpuJ_7-gblkGLqXiirRNDuEmQsBDBIXqKMZiv95tt7j9k42riamshPES46b1fu_FnBgPF1Tg0-gv9RAEdINL6qdD3eXlEfEXiE"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

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

[
  "sql" => "SELECT b0_.created_by_id AS sclr_0, COUNT(b0_.id) AS sclr_1, COALESCE(SUM(b0_.amount), 0) AS sclr_2, COALESCE(b0_.parking_id, t1_.parking_id) AS sclr_3, MAX(COALESCE(p2_.name, p3_.name)) AS sclr_4 FROM billet b0_ INNER JOIN user u4_ ON b0_.created_by_id = u4_.id LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= ? AND b0_.created_at < ? GROUP BY u4_.id, p2_.id, p3_.id"
  "params" => [
    1 => "2026-07-02 00:00:00"
    2 => "2026-07-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#838
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#838}
  ]
]

[
  "sql" => "SELECT b0_.created_by_id AS sclr_0, t1_.code AS code_1, t1_.label AS label_2 FROM billet b0_ LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= ? AND b0_.created_at < ? ORDER BY b0_.created_at DESC"
  "params" => [
    1 => "2026-07-02 00:00:00"
    2 => "2026-07-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#838
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#838}
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= ? AND d0_.report_date < ? ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC"
  "params" => [
    1 => "2026-07-02 00:00:00"
    2 => "2026-07-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#838
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#838}
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= ? AND d0_.report_date < ? ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC"
  "params" => [
    1 => "2026-07-02 00:00:00"
    2 => "2026-07-03 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#838
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#838}
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]

[
  "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.id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#840
      +name: "INTEGER"
    }
  ]
]