Query Metrics
63
Database Queries
11
Different statements
8.01 ms
Query time
0
Invalid entities
224
Managed entities
Queries
#▲ | 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 |