Query Metrics
12
Database Queries
6
Different statements
11.84 ms
Query time
0
Invalid entities
46
Managed entities
Queries
| #▲ | 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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Read | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Watermark | No errors. |
| App\Entity\EanCode | No errors. |
| App\Entity\IqpCode | No errors. |
| App\Entity\IqbCode | No errors. |
| App\Entity\IqcCode | No errors. |
| App\Entity\IqeCode | No errors. |
| App\Entity\IqsCode | No errors. |
| App\Entity\FormatType | No errors. |
| App\Entity\CodeType | No errors. |
| App\Entity\ReadType | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\JoinTableUserBrand | No errors. |
| App\Entity\JoinTableUserPointOfSale | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Campaign\JoinTableUserCampaign | No errors. |
| App\Entity\Campaign\Ticket | No errors. |
| App\Entity\Maintenance\Notification | No errors. |
| App\Entity\Warranty\Warranty | No errors. |
| App\Entity\Shopping\Storage | No errors. |