Symfony Profiler

SELECT
  fine_legal_id AS "fineLegalId",
  "type",
  auth_id AS "authId",
  original_fps_json :: json -> 'agent' AS "agent",
  city_id AS "cityId",
  terminal_id AS "terminalId",
  jsonb_build_object(
    'plate', plate, 'plateCountry', plate_country
  ) AS "licensePlate",
  original_fps_json :: json ->> 'vehicle' AS "vehicle",
  zone_id AS "zoneId",
  parc_id AS "parkId",
  original_fps_json :: json ->> 'statementDatetime' AS "statementDatetime",
  original_fps_json :: json ->> 'statementAddress' AS "statementAddress",
  original_fps_json :: json ->> 'statementLocation' AS "statementLocation",
  original_fps_json :: json ->> 'significantRights' AS "significantRights",
  notification_authority AS "notificationAuthority",
  fine_price AS "finePrice",
  original_fps_json :: json ->> 'validityDatetime' AS "validityDatetime",
  reduced_fine_price AS "reducedFinePrice",
  original_fps_json :: json ->> 'reducedDatetime' AS "reducedDatetime",
  payment_status AS "paymentStatus",
  original_fps_json :: json ->> 'recourseOrganization' AS "recourseOrganization",
  fps.offset_create AS "offsetCreate",
  fps.agg_greatest(fps.fine_id) AS "offsetLastUpdate",
  fps.agg_json_payment(fps.fine_id) AS "payments",
  fps.agg_json_claim(fps.fine_id) AS "claims",
  fps.agg_json_comment(fps.fine_id) AS "comments",
  CAST(fps.fine_id AS varchar) AS "fineId",
  fine_short_id AS "fineShortId",
  fps.parent AS "parent",
  fps.root_fine_legal_id AS "rootFineLegalId",
  to_char(
    fps.date_modified :: timestamp at time zone 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ) AS "dateModified",
  to_char(
    fps.auth_transfert_datetime :: timestamp at time zone 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ) AS "authTransfertDatetime",
  to_char(
    fps.notification_datetime :: timestamp at time zone 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ) AS "notificationDatetime",
  to_char(
    fps.debt_collection_datetime :: timestamp at time zone 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ) AS "debtCollectionDatetime",
  to_char(
    fps.cancel_datetime :: timestamp at time zone 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ) AS "cancelDatetime",
  fps.offender,
  surcharge,
  terminal_type AS "terminalType"
FROM
  fps.fps
WHERE
  fps.fine_legal_id = :fineLegalId
  AND fps.plate = :plate
  AND fps.plate_country = :plateCountry
  AND fps.statement_datetime >= :startDatetime
  AND fps.statement_datetime <= :endDatetime
ORDER BY
  fps.statement_datetime ASC OFFSET :_offset
LIMIT
  :_limit

SELECT 
                    fine_legal_id AS "fineLegalId",
                    "type" ,
                    auth_id AS "authId",
                    original_fps_json::json->'agent' AS "agent",
                    city_id AS "cityId",
                    terminal_id AS "terminalId",
                    jsonb_build_object('plate',plate,'plateCountry',plate_country) AS "licensePlate",
                    original_fps_json::json->>'vehicle' AS "vehicle",
                    zone_id AS "zoneId",
                    parc_id AS "parkId",
                    original_fps_json::json->>'statementDatetime' AS "statementDatetime",
                    original_fps_json::json->>'statementAddress' AS "statementAddress", 
                    original_fps_json::json->>'statementLocation' AS "statementLocation",
                    original_fps_json::json->>'significantRights' AS "significantRights",
                    notification_authority AS "notificationAuthority",
                    fine_price AS "finePrice",
                    original_fps_json::json->>'validityDatetime' AS "validityDatetime",
                    reduced_fine_price AS "reducedFinePrice",
                    original_fps_json::json->>'reducedDatetime' AS "reducedDatetime",
                    payment_status AS "paymentStatus",
                    original_fps_json::json->>'recourseOrganization' AS "recourseOrganization",
                    fps.offset_create AS "offsetCreate",
                    fps.agg_greatest(fps.fine_id) AS "offsetLastUpdate",
                    fps.agg_json_payment(fps.fine_id) AS "payments",
                    fps.agg_json_claim(fps.fine_id) AS "claims",
                    fps.agg_json_comment(fps.fine_id) AS "comments",
                    CAST(fps.fine_id AS varchar) AS "fineId",
                    fine_short_id AS "fineShortId",
                    fps.parent AS "parent",
                    fps.root_fine_legal_id AS "rootFineLegalId",
                    to_char(fps.date_modified::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS "dateModified", 
                    to_char(fps.auth_transfert_datetime::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS "authTransfertDatetime",
                    to_char(fps.notification_datetime::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS "notificationDatetime",
                    to_char(fps.debt_collection_datetime::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS "debtCollectionDatetime",
                    to_char(fps.cancel_datetime::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS "cancelDatetime",
                    fps.offender,
                    surcharge,
                    terminal_type AS "terminalType" FROM fps.fps  WHERE fps.fine_legal_id = '22222222222227241236643001' AND fps.plate = 'UB-126-AP' AND fps.plate_country = 'FR' AND fps.statement_datetime  >=  '2024-08-23T00:00:00.000000Z' AND fps.statement_datetime  <=  '2024-08-23T23:59:59.000000Z' ORDER BY fps.statement_datetime ASC OFFSET 0 LIMIT 25;

SELECT
  COUNT(*) AS count
FROM
  fps.fps
WHERE
  fps.fine_legal_id = :fineLegalId
  AND fps.plate = :plate
  AND fps.plate_country = :plateCountry
  AND fps.statement_datetime >= :startDatetime
  AND fps.statement_datetime <= :endDatetime

SELECT COUNT(*) AS count FROM fps.fps  WHERE fps.fine_legal_id = '22222222222227241236643001' AND fps.plate = 'UB-126-AP' AND fps.plate_country = 'FR' AND fps.statement_datetime  >=  '2024-08-23T00:00:00.000000Z' AND fps.statement_datetime  <=  '2024-08-23T23:59:59.000000Z';