GET https://test.tillomeditalia.com/utente/listino/prodotti?category=&group=&name=cefa

Query Metrics

63 Database Queries
11 Different statements
8.01 ms Query time
0 Invalid entities
224 Managed entities

Queries

Group similar statements

# Time Info
1 0.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.directory_path AS directory_path_6, t0.one_time_code AS one_time_code_7, t0.role AS role_8, t0.expiration_one_time_code AS expiration_one_time_code_9, t0.office_hours AS office_hours_10, t0.is_active AS is_active_11, t0.is_admin_active AS is_admin_active_12, t0.is_email_notification_active AS is_email_notification_active_13, t0.is_alert_read AS is_alert_read_14, t0.is_gdpr_sent AS is_gdpr_sent_15, t16.id AS id_17, t16.datetime_last_update AS datetime_last_update_18, t16.is_terms_accepted AS is_terms_accepted_19, t16.is_news_accepted AS is_news_accepted_20, t16.user_id AS user_id_21, t22.id AS id_23, t22.country_code AS country_code_24, t22.phone AS phone_25, t22.fax AS fax_26, t22.mobile AS mobile_27, t22.address AS address_28, t22.zip AS zip_29, t22.other_city AS other_city_30, t22.other_province AS other_province_31, t22.avatar AS avatar_32, t22.user_id AS user_id_33, t22.city_id AS city_id_34, t22.user_profession_id AS user_profession_id_35, t36.id AS id_37, t36.residue_rol AS residue_rol_38, t36.residue_holiday AS residue_holiday_39, t36.datetime_start_work AS datetime_start_work_40, t36.datetime_end_work AS datetime_end_work_41, t36.show_in_list AS show_in_list_42, t36.user_id AS user_id_43, t36.supervisor_id AS supervisor_id_44, t0.account_type_id AS account_type_id_45 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "2"
]
2 0.30 ms
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM til_product t0_ LEFT JOIN til_product_category t1_ ON t0_.product_category_id = t1_.id LEFT JOIN til_product_group t2_ ON t0_.product_group_id = t2_.id WHERE 1 = 1 AND t0_.name LIKE ?
Parameters:
[
  "%cefa%"
]
3 0.23 ms
SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1 FROM til_product t0_ LEFT JOIN til_product_category t1_ ON t0_.product_category_id = t1_.id LEFT JOIN til_product_group t2_ ON t0_.product_group_id = t2_.id WHERE 1 = 1 AND t0_.name LIKE ? ORDER BY t0_.name ASC LIMIT 30
Parameters:
[
  "%cefa%"
]
4 0.21 ms
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ LEFT JOIN til_product_category t1_ ON t0_.product_category_id = t1_.id LEFT JOIN til_product_group t2_ ON t0_.product_group_id = t2_.id WHERE 1 = 1 AND t0_.name LIKE ? AND t0_.id IN (?) ORDER BY t0_.name ASC
Parameters:
[
  "%cefa%"
  "37"
]
5 0.17 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.level AS level_4 FROM til_user_account_type t0 WHERE t0.id = ?
Parameters:
[
  "0"
]
6 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM til_join_table_user_permission t0 WHERE t0.user_id = ?
Parameters:
[
  "2"
]
7 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
8 0.18 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
9 0.18 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
10 0.25 ms
SELECT t0.id AS id_1, t0.level AS level_2, t0.content AS content_3, t0.datetime AS datetime_4, t0.is_read AS is_read_5, t0.is_hidden AS is_hidden_6, t0.is_personal AS is_personal_7, t0.is_for_admin AS is_for_admin_8, t0.type_id AS type_id_9, t0.user_id AS user_id_10 FROM til_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "2"
]
11 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
12 0.12 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
13 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
14 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
15 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
16 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
17 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
18 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "11"
]
19 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
20 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
21 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
22 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "15"
]
23 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
24 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
25 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "18"
]
26 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "19"
]
27 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "20"
]
28 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "21"
]
29 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
30 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "23"
]
31 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "24"
]
32 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "25"
]
33 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "26"
]
34 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "27"
]
35 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "28"
]
36 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "29"
]
37 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "30"
]
38 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
39 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "32"
]
40 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "33"
]
41 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "34"
]
42 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "35"
]
43 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "36"
]
44 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "37"
]
45 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "38"
]
46 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "39"
]
47 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "40"
]
48 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "41"
]
49 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = ?
Parameters:
[
  "42"
]
50 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
51 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
52 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
53 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
54 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
55 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
56 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
57 0.09 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
58 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "11"
]
59 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "14"
]
60 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "15"
]
61 0.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "16"
]
62 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.product_category_id AS product_category_id_4 FROM til_product_group t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
63 0.11 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.atc_code AS atc_code_4 FROM til_product_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]

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\Notification 82
App\Entity\JoinTableUserPermission 58
App\Entity\Permission 58
App\Entity\PermissionCategory 13
App\Entity\NotificationType 3
App\Entity\User 1
App\Entity\UserAccountType 1
App\Entity\UserPrivacy 1
App\Entity\UserProfile 1
App\Entity\City 1
App\Entity\UserProfession 1
App\Entity\Employee 1
App\Entity\Product 1
App\Entity\ProductCategory 1
App\Entity\ProductGroup 1