Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

8.53 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

cities connection

No database queries were performed.

city_11111111111114 connection

No database queries were performed.

city_11111111111115 connection

No database queries were performed.

city_11111111111116 connection

Time▼	Count	Info
7.98 ms (93.54%)	1	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 Parameters: [`"fineLegalId" => "11111111111116251051296001" "plate" => "UH-729-KB" "plateCountry" => "FR" "startDatetime" => "2025-02-20T00:00:00.000000Z" "endDatetime" => "2025-02-20T23:59:59.000000Z" "_offset" => 0 "_limit" => 25`] View formatted query View runnable query Explain query 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 = '11111111111116251051296001' AND fps.plate = 'UH-729-KB' AND fps.plate_country = 'FR' AND fps.statement_datetime >= '2025-02-20T00:00:00.000000Z' AND fps.statement_datetime <= '2025-02-20T23:59:59.000000Z' ORDER BY fps.statement_datetime ASC OFFSET 0 LIMIT 25;
0.55 ms (6.46%)	1	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 Parameters: [`"fineLegalId" => "11111111111116251051296001" "plate" => "UH-729-KB" "plateCountry" => "FR" "startDatetime" => "2025-02-20T00:00:00.000000Z" "endDatetime" => "2025-02-20T23:59:59.000000Z"`] View formatted query View runnable query Explain query 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 = '11111111111116251051296001' AND fps.plate = 'UH-729-KB' AND fps.plate_country = 'FR' AND fps.statement_datetime >= '2025-02-20T00:00:00.000000Z' AND fps.statement_datetime <= '2025-02-20T23:59:59.000000Z';

Time▼

Count

Info

7.98 ms
(93.54%)

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

Parameters:

[
  "fineLegalId" => "11111111111116251051296001"
  "plate" => "UH-729-KB"
  "plateCountry" => "FR"
  "startDatetime" => "2025-02-20T00:00:00.000000Z"
  "endDatetime" => "2025-02-20T23:59:59.000000Z"
  "_offset" => 0
  "_limit" => 25
]

View formatted query View runnable query Explain query

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 = '11111111111116251051296001' AND fps.plate = 'UH-729-KB' AND fps.plate_country = 'FR' AND fps.statement_datetime  >=  '2025-02-20T00:00:00.000000Z' AND fps.statement_datetime  <=  '2025-02-20T23:59:59.000000Z' ORDER BY fps.statement_datetime ASC OFFSET 0 LIMIT 25;

0.55 ms
(6.46%)

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

Parameters:

[
  "fineLegalId" => "11111111111116251051296001"
  "plate" => "UH-729-KB"
  "plateCountry" => "FR"
  "startDatetime" => "2025-02-20T00:00:00.000000Z"
  "endDatetime" => "2025-02-20T23:59:59.000000Z"
]

View formatted query View runnable query Explain query

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 = '11111111111116251051296001' AND fps.plate = 'UH-729-KB' AND fps.plate_country = 'FR' AND fps.statement_datetime  >=  '2025-02-20T00:00:00.000000Z' AND fps.statement_datetime  <=  '2025-02-20T23:59:59.000000Z';

city_11111111111117 connection

No database queries were performed.

city_11111111111126 connection

No database queries were performed.

city_22222222222222 connection

No database queries were performed.

city_22222222222223 connection

No database queries were performed.

city_22222222222226 connection

No database queries were performed.

city_22222222222227 connection

No database queries were performed.

city_99999999999998 connection

No database queries were performed.

city_yyy020berlinde connection

No database queries were performed.

Database Connections

Name	Service
cities	doctrine.dbal.cities_connection
city_11111111111114	doctrine.dbal.city_11111111111114_connection
city_11111111111115	doctrine.dbal.city_11111111111115_connection
city_11111111111116	doctrine.dbal.city_11111111111116_connection
city_11111111111117	doctrine.dbal.city_11111111111117_connection
city_11111111111126	doctrine.dbal.city_11111111111126_connection
city_22222222222222	doctrine.dbal.city_22222222222222_connection
city_22222222222223	doctrine.dbal.city_22222222222223_connection
city_22222222222226	doctrine.dbal.city_22222222222226_connection
city_22222222222227	doctrine.dbal.city_22222222222227_connection
city_99999999999998	doctrine.dbal.city_99999999999998_connection
city_yyy020berlinde	doctrine.dbal.city_yyy020berlinde_connection

Entity Managers

Name	Service
em_cities	doctrine.orm.em_cities_entity_manager
em_11111111111114	doctrine.orm.em_11111111111114_entity_manager
em_11111111111115	doctrine.orm.em_11111111111115_entity_manager
em_11111111111116	doctrine.orm.em_11111111111116_entity_manager
em_11111111111117	doctrine.orm.em_11111111111117_entity_manager
em_11111111111126	doctrine.orm.em_11111111111126_entity_manager
em_22222222222222	doctrine.orm.em_22222222222222_entity_manager
em_22222222222223	doctrine.orm.em_22222222222223_entity_manager
em_22222222222226	doctrine.orm.em_22222222222226_entity_manager
em_22222222222227	doctrine.orm.em_22222222222227_entity_manager
em_99999999999998	doctrine.orm.em_99999999999998_entity_manager
em_yyy020berlinde	doctrine.orm.em_yyy020berlinde_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

em_cities entity manager

No loaded entities.

em_11111111111114 entity manager

No loaded entities.

em_11111111111115 entity manager

No loaded entities.

em_11111111111116 entity manager

Class	Mapping errors
App\Entity\Fps	No errors.

em_11111111111117 entity manager

No loaded entities.

em_11111111111126 entity manager

No loaded entities.

em_22222222222222 entity manager

No loaded entities.

em_22222222222223 entity manager

No loaded entities.

em_22222222222226 entity manager

No loaded entities.

em_22222222222227 entity manager

No loaded entities.

em_99999999999998 entity manager

No loaded entities.

em_yyy020berlinde entity manager

No loaded entities.

Symfony Profiler

http://fps-v2-preprod.stade.exyzt.dev/api/11111111111116/fines-search/v1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

cities connection

city_11111111111114 connection

city_11111111111115 connection

city_11111111111116 connection

city_11111111111117 connection

city_11111111111126 connection

city_22222222222222 connection

city_22222222222223 connection

city_22222222222226 connection

city_22222222222227 connection

city_99999999999998 connection

city_yyy020berlinde connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

em_cities entity manager

em_11111111111114 entity manager

em_11111111111115 entity manager

em_11111111111116 entity manager

em_11111111111117 entity manager

em_11111111111126 entity manager

em_22222222222222 entity manager

em_22222222222223 entity manager

em_22222222222226 entity manager

em_22222222222227 entity manager

em_99999999999998 entity manager

em_yyy020berlinde entity manager