GET https://www.primigenagroup.com/admin/letture/

Query Metrics

12 Database Queries
6 Different statements
11.84 ms Query time
0 Invalid entities
46 Managed entities

Queries

Group similar statements

# Time Info
1 3.85 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_read p0_ WHERE p0_.datetime >= ? AND p0_.datetime <= ?
Parameters:
[
  "2026-05-25"
  "2026-06-25 11:19:52"
]
2 4.37 ms
SELECT DISTINCT p0_.id AS id_0, p0_.datetime AS datetime_1 FROM prim_read p0_ WHERE p0_.datetime >= ? AND p0_.datetime <= ? ORDER BY p0_.datetime DESC LIMIT 100
Parameters:
[
  "2026-05-25"
  "2026-06-25 11:19:52"
]
3 0.91 ms
SELECT p0_.id AS id_0, p0_.datetime AS datetime_1, p0_.device AS device_2, p0_.device_id AS device_id_3, p0_.service AS service_4, p0_.os AS os_5, p0_.geocoords AS geocoords_6, p0_.application AS application_7, p0_.version AS version_8, p0_.area_1 AS area_1_9, p0_.area_2 AS area_2_10, p0_.area_3 AS area_3_11, p0_.area_4 AS area_4_12, p0_.country AS country_13, p0_.zip AS zip_14, p0_.lang AS lang_15, p0_.user_id AS user_id_16, p0_.watermark_id AS watermark_id_17, p0_.ean_code_id AS ean_code_id_18, p0_.iqp_code_id AS iqp_code_id_19, p0_.iqb_code_id AS iqb_code_id_20, p0_.iqc_code_id AS iqc_code_id_21, p0_.iqe_code_id AS iqe_code_id_22, p0_.iqs_code_id AS iqs_code_id_23, p0_.format_type_id AS format_type_id_24, p0_.code_type_id AS code_type_id_25, p0_.read_type_id AS read_type_id_26 FROM prim_read p0_ WHERE p0_.datetime >= ? AND p0_.datetime <= ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.datetime DESC
Parameters:
[
  "2026-05-25"
  "2026-06-25 11:19:52"
  "17949"
  "17948"
  "17947"
  "17946"
  "17945"
  "17944"
  "17943"
  "17942"
  "17940"
  "17941"
  "17939"
  "17938"
  "17937"
  "17936"
  "17935"
  "17934"
  "17933"
  "17932"
  "17931"
  "17930"
  "17929"
  "17928"
  "17927"
  "17926"
  "17925"
  "17924"
  "17923"
  "17922"
  "17921"
  "17920"
]
4 0.76 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.email AS email_3, t0.password AS password_4, t0.role AS role_5, t0.name AS name_6, t0.surname AS surname_7, t0.phone AS phone_8, t0.address AS address_9, t0.city AS city_10, t0.zip AS zip_11, t0.country AS country_12, t0.activation_code AS activation_code_13, t0.one_time_code AS one_time_code_14, t0.directory_path AS directory_path_15, t0.primigena_points AS primigena_points_16, t0.subscription_datetime AS subscription_datetime_17, t0.expiration_one_time_code AS expiration_one_time_code_18, t19.id AS id_20, t19.update_date_time AS update_date_time_21, t19.user_id AS user_id_22 FROM prim_user t0 LEFT JOIN prim_cart t19 ON t19.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "97"
]
5 0.43 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_code_type t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
6 0.18 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_read_type t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
7 0.31 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.email AS email_3, t0.password AS password_4, t0.role AS role_5, t0.name AS name_6, t0.surname AS surname_7, t0.phone AS phone_8, t0.address AS address_9, t0.city AS city_10, t0.zip AS zip_11, t0.country AS country_12, t0.activation_code AS activation_code_13, t0.one_time_code AS one_time_code_14, t0.directory_path AS directory_path_15, t0.primigena_points AS primigena_points_16, t0.subscription_datetime AS subscription_datetime_17, t0.expiration_one_time_code AS expiration_one_time_code_18, t19.id AS id_20, t19.update_date_time AS update_date_time_21, t19.user_id AS user_id_22 FROM prim_user t0 LEFT JOIN prim_cart t19 ON t19.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "56"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_code_type t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
9 0.23 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_code_type t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
10 0.28 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_code_type t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
11 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_read_type t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
12 0.16 ms
SELECT t0.id AS id_1, t0.slug AS slug_2 FROM prim_read_type t0 WHERE t0.id = ?
Parameters:
[
  "14"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Read 30
App\Entity\CodeType 4
App\Entity\FormatType 3
App\Entity\ReadType 3
App\Entity\User 2
App\Entity\EanCode 2
App\Entity\IqpCode 1
App\Entity\IqbCode 1