Query Metrics
64
Database Queries
14
Different statements
14.75 ms
Query time
0
Invalid entities
14
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.91 ms (12.94%) |
8 |
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"
]
|
|
1.69 ms (11.48%) |
8 |
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"
]
|
|
1.44 ms (9.75%) |
5 |
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"
]
|
|
1.10 ms (7.45%) |
5 |
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"
]
|
|
1.04 ms (7.08%) |
5 |
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"
]
|
|
0.97 ms (6.61%) |
5 |
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"
]
|
|
0.96 ms (6.50%) |
5 |
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"
]
|
|
0.96 ms (6.48%) |
5 |
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"
]
|
|
0.95 ms (6.45%) |
5 |
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"
]
|
|
0.95 ms (6.41%) |
5 |
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"
]
|
|
0.91 ms (6.15%) |
5 |
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"
]
|
|
0.68 ms (4.64%) |
1 |
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:
[] |
|
0.68 ms (4.64%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_user p0_ WHERE 1 = 1
Parameters:
[] |
|
0.50 ms (3.42%) |
1 |
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" ] |
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 |