GET https://www.primigenagroup.com/admin/utenti/?page=5

Query Metrics

64 Database Queries
14 Different statements
14.75 ms Query time
0 Invalid entities
14 Managed entities

Queries

Group similar statements

# Time Info
1 0.68 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_user p0_ WHERE 1 = 1
Parameters:
[]
2 0.68 ms
SELECT DISTINCT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.name AS name_2 FROM prim_user p0_ WHERE 1 = 1 ORDER BY p0_.is_active DESC, p0_.name ASC LIMIT 30 OFFSET 120
Parameters:
[]
3 0.50 ms
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.email AS email_2, p0_.password AS password_3, p0_.role AS role_4, p0_.name AS name_5, p0_.surname AS surname_6, p0_.phone AS phone_7, p0_.address AS address_8, p0_.city AS city_9, p0_.zip AS zip_10, p0_.country AS country_11, p0_.activation_code AS activation_code_12, p0_.one_time_code AS one_time_code_13, p0_.directory_path AS directory_path_14, p0_.primigena_points AS primigena_points_15, p0_.subscription_datetime AS subscription_datetime_16, p0_.expiration_one_time_code AS expiration_one_time_code_17 FROM prim_user p0_ WHERE 1 = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.is_active DESC, p0_.name ASC
Parameters:
[
  "104"
  "107"
  "34"
  "59"
  "114"
  "67"
  "80"
  "149"
]
4 0.29 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "104"
]
5 0.29 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
6 0.23 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
7 0.22 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "59"
]
8 0.19 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "114"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
10 0.15 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
11 0.17 ms
SELECT t0.id AS id_1, t0.update_date_time AS update_date_time_2, t0.user_id AS user_id_3 FROM prim_cart t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
12 0.48 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "104"
]
13 0.32 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
14 0.25 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
15 0.20 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_for_admin AS is_for_admin_3, t0.msg AS msg_4, t0.priority AS priority_5, t0.datetime AS datetime_6, t0.user_id AS user_id_7 FROM prim_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
16 0.20 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.delivery_address AS delivery_address_3, t0.invoice_address AS invoice_address_4, t0.datetime AS datetime_5, t0.user_id AS user_id_6, t0.status_id AS status_id_7 FROM prim_order t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
17 0.41 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
18 0.29 ms
SELECT t0.id AS id_1, t0.points AS points_2, t0.user_id AS user_id_3, t0.campaign_id AS campaign_id_4 FROM prim_campaign_join_table_user_campaign t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
19 0.24 ms
SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
20 0.24 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.datetime AS datetime_3, t0.msg_sender AS msg_sender_4, t0.msg_response AS msg_response_5, t0.is_hidden_user AS is_hidden_user_6, t0.user_id AS user_id_7, t0.maintenance_id AS maintenance_id_8, t0.notification_type_id AS notification_type_id_9, t0.status_id AS status_id_10 FROM prim_maintenance_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
21 0.24 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.user_id = ?
Parameters:
[
  "107"
]
22 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM prim_shopping_storage t0 INNER JOIN prim_shopping_join_table_user_storage ON t0.id = prim_shopping_join_table_user_storage.storage_id WHERE prim_shopping_join_table_user_storage.user_id = ?
Parameters:
[
  "107"
]
23 0.18 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
24 0.16 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
25 0.18 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_for_admin AS is_for_admin_3, t0.msg AS msg_4, t0.priority AS priority_5, t0.datetime AS datetime_6, t0.user_id AS user_id_7 FROM prim_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
26 0.19 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.delivery_address AS delivery_address_3, t0.invoice_address AS invoice_address_4, t0.datetime AS datetime_5, t0.user_id AS user_id_6, t0.status_id AS status_id_7 FROM prim_order t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
27 0.31 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
28 0.18 ms
SELECT t0.id AS id_1, t0.points AS points_2, t0.user_id AS user_id_3, t0.campaign_id AS campaign_id_4 FROM prim_campaign_join_table_user_campaign t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
29 0.15 ms
SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
30 0.15 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.datetime AS datetime_3, t0.msg_sender AS msg_sender_4, t0.msg_response AS msg_response_5, t0.is_hidden_user AS is_hidden_user_6, t0.user_id AS user_id_7, t0.maintenance_id AS maintenance_id_8, t0.notification_type_id AS notification_type_id_9, t0.status_id AS status_id_10 FROM prim_maintenance_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
31 0.23 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.user_id = ?
Parameters:
[
  "34"
]
32 0.26 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM prim_shopping_storage t0 INNER JOIN prim_shopping_join_table_user_storage ON t0.id = prim_shopping_join_table_user_storage.storage_id WHERE prim_shopping_join_table_user_storage.user_id = ?
Parameters:
[
  "34"
]
33 0.18 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "59"
]
34 0.22 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "114"
]
35 0.19 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
36 0.17 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
37 0.20 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_for_admin AS is_for_admin_3, t0.msg AS msg_4, t0.priority AS priority_5, t0.datetime AS datetime_6, t0.user_id AS user_id_7 FROM prim_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
38 0.21 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.delivery_address AS delivery_address_3, t0.invoice_address AS invoice_address_4, t0.datetime AS datetime_5, t0.user_id AS user_id_6, t0.status_id AS status_id_7 FROM prim_order t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
39 0.24 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
40 0.15 ms
SELECT t0.id AS id_1, t0.points AS points_2, t0.user_id AS user_id_3, t0.campaign_id AS campaign_id_4 FROM prim_campaign_join_table_user_campaign t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
41 0.18 ms
SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
42 0.19 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.datetime AS datetime_3, t0.msg_sender AS msg_sender_4, t0.msg_response AS msg_response_5, t0.is_hidden_user AS is_hidden_user_6, t0.user_id AS user_id_7, t0.maintenance_id AS maintenance_id_8, t0.notification_type_id AS notification_type_id_9, t0.status_id AS status_id_10 FROM prim_maintenance_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
43 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.user_id = ?
Parameters:
[
  "67"
]
44 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM prim_shopping_storage t0 INNER JOIN prim_shopping_join_table_user_storage ON t0.id = prim_shopping_join_table_user_storage.storage_id WHERE prim_shopping_join_table_user_storage.user_id = ?
Parameters:
[
  "67"
]
45 0.17 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
46 0.19 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
47 0.19 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_for_admin AS is_for_admin_3, t0.msg AS msg_4, t0.priority AS priority_5, t0.datetime AS datetime_6, t0.user_id AS user_id_7 FROM prim_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
48 0.14 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.delivery_address AS delivery_address_3, t0.invoice_address AS invoice_address_4, t0.datetime AS datetime_5, t0.user_id AS user_id_6, t0.status_id AS status_id_7 FROM prim_order t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
49 0.23 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
50 0.21 ms
SELECT t0.id AS id_1, t0.points AS points_2, t0.user_id AS user_id_3, t0.campaign_id AS campaign_id_4 FROM prim_campaign_join_table_user_campaign t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
51 0.21 ms
SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
52 0.17 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.datetime AS datetime_3, t0.msg_sender AS msg_sender_4, t0.msg_response AS msg_response_5, t0.is_hidden_user AS is_hidden_user_6, t0.user_id AS user_id_7, t0.maintenance_id AS maintenance_id_8, t0.notification_type_id AS notification_type_id_9, t0.status_id AS status_id_10 FROM prim_maintenance_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
53 0.19 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.user_id = ?
Parameters:
[
  "80"
]
54 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM prim_shopping_storage t0 INNER JOIN prim_shopping_join_table_user_storage ON t0.id = prim_shopping_join_table_user_storage.storage_id WHERE prim_shopping_join_table_user_storage.user_id = ?
Parameters:
[
  "80"
]
55 0.17 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.brand_id AS brand_id_5 FROM prim_join_table_user_brand t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
56 0.18 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.role AS role_3, t0.user_id AS user_id_4, t0.point_of_sale_id AS point_of_sale_id_5 FROM prim_join_table_user_pos t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
57 0.19 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_for_admin AS is_for_admin_3, t0.msg AS msg_4, t0.priority AS priority_5, t0.datetime AS datetime_6, t0.user_id AS user_id_7 FROM prim_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
58 0.21 ms
SELECT t0.id AS id_1, t0.number AS number_2, t0.delivery_address AS delivery_address_3, t0.invoice_address AS invoice_address_4, t0.datetime AS datetime_5, t0.user_id AS user_id_6, t0.status_id AS status_id_7 FROM prim_order t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
59 0.25 ms
SELECT t0.id AS id_1, t0.datetime AS datetime_2, t0.device AS device_3, t0.device_id AS device_id_4, t0.service AS service_5, t0.os AS os_6, t0.geocoords AS geocoords_7, t0.application AS application_8, t0.version AS version_9, t0.area_1 AS area_1_10, t0.area_2 AS area_2_11, t0.area_3 AS area_3_12, t0.area_4 AS area_4_13, t0.country AS country_14, t0.zip AS zip_15, t0.lang AS lang_16, t0.user_id AS user_id_17, t0.watermark_id AS watermark_id_18, t0.ean_code_id AS ean_code_id_19, t0.iqp_code_id AS iqp_code_id_20, t0.iqb_code_id AS iqb_code_id_21, t0.iqc_code_id AS iqc_code_id_22, t0.iqe_code_id AS iqe_code_id_23, t0.iqs_code_id AS iqs_code_id_24, t0.format_type_id AS format_type_id_25, t0.code_type_id AS code_type_id_26, t0.read_type_id AS read_type_id_27 FROM prim_read t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
60 0.14 ms
SELECT t0.id AS id_1, t0.points AS points_2, t0.user_id AS user_id_3, t0.campaign_id AS campaign_id_4 FROM prim_campaign_join_table_user_campaign t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
61 0.16 ms
SELECT t0.id AS id_1, t0.receipt_path AS receipt_path_2, t0.is_closed AS is_closed_3, t0.assign_date AS assign_date_4, t0.withdraw_date AS withdraw_date_5, t0.iqp_code_id AS iqp_code_id_6, t0.prize_id AS prize_id_7, t0.campaign_id AS campaign_id_8, t0.user_id AS user_id_9, t0.point_of_sale_id AS point_of_sale_id_10 FROM prim_campaign_ticket t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
62 0.16 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.datetime AS datetime_3, t0.msg_sender AS msg_sender_4, t0.msg_response AS msg_response_5, t0.is_hidden_user AS is_hidden_user_6, t0.user_id AS user_id_7, t0.maintenance_id AS maintenance_id_8, t0.notification_type_id AS notification_type_id_9, t0.status_id AS status_id_10 FROM prim_maintenance_notification t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
63 0.16 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.duration_month AS duration_month_4, t0.receipt_path AS receipt_path_5, t0.extension_path AS extension_path_6, t0.purchase_date AS purchase_date_7, t0.is_extension_active AS is_extension_active_8, t0.ean_code_id AS ean_code_id_9, t0.iqb_code_id AS iqb_code_id_10, t0.iqp_code_id AS iqp_code_id_11, t0.user_id AS user_id_12 FROM prim_warranty t0 WHERE t0.user_id = ?
Parameters:
[
  "149"
]
64 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM prim_shopping_storage t0 INNER JOIN prim_shopping_join_table_user_storage ON t0.id = prim_shopping_join_table_user_storage.storage_id WHERE prim_shopping_join_table_user_storage.user_id = ?
Parameters:
[
  "149"
]

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\User 8
App\Entity\JoinTableUserBrand 3
App\Entity\Brand 3