Query Metrics
260
Database Queries
14
Different statements
52.07 ms
Query time
0
Invalid entities
289
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.44 ms (14.30%) |
27 |
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:
[
"68"
]
|
|
6.70 ms (12.87%) |
30 |
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:
[
"97"
]
|
|
5.41 ms (10.39%) |
29 |
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:
[
"14"
]
|
|
5.21 ms (10.01%) |
29 |
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:
[
"14"
]
|
|
4.95 ms (9.52%) |
27 |
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:
[
"68"
]
|
|
4.26 ms (8.17%) |
30 |
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:
[
"97"
]
|
|
3.49 ms (6.70%) |
17 |
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:
[
"68"
]
|
|
3.44 ms (6.61%) |
17 |
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:
[
"68"
]
|
|
3.38 ms (6.49%) |
17 |
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:
[
"68"
]
|
|
3.23 ms (6.20%) |
17 |
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:
[
"68"
]
|
|
3.15 ms (6.05%) |
17 |
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:
[
"68"
]
|
|
0.56 ms (1.08%) |
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:
[ "97" "14" "68" "69" "124" "24" "146" "79" "127" "118" "44" "112" "109" "15" "28" "40" "71" "72" "147" "100" "81" "94" "103" "21" "125" "17" "26" "65" "83" "137" ] |
|
0.43 ms (0.82%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM prim_user p0_ WHERE 1 = 1
Parameters:
[] |
|
0.40 ms (0.77%) |
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
Parameters:
[] |
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 | 178 |
| App\Entity\User | 30 |
| App\Entity\IqbCode | 15 |
| App\Entity\EanCode | 12 |
| App\Entity\Watermark | 10 |
| App\Entity\ReadType | 9 |
| App\Entity\Notification | 8 |
| App\Entity\JoinTableUserBrand | 7 |
| App\Entity\Brand | 7 |
| App\Entity\CodeType | 5 |
| App\Entity\FormatType | 4 |
| App\Entity\IqpCode | 4 |