Query Metrics
35
Database Queries
23
Different statements
70.66 ms
Query time
1
Invalid entities
106
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.78 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.username_canonical AS username_canonical_7, t0.status AS status_8, t0.points AS points_9, t0.points_approved AS points_approved_10, t0.points_waiting AS points_waiting_11, t0.points_paid AS points_paid_12, t0.points_available AS points_available_13, t0.all_extra_points AS all_extra_points_14, t0.czwartaedycja AS czwartaedycja_15, t0.piataedycja AS piataedycja_16, t0.szostaedycja AS szostaedycja_17, t0.siodmaedycja AS siodmaedycja_18, t0.osmaedycja AS osmaedycja_19, t0.enabled AS enabled_20, t0.salt AS salt_21, t0.last_login AS last_login_22, t0.is_allowed AS is_allowed_23, t0.statements AS statements_24, t0.statements2 AS statements2_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.profile_id AS profile_id_29, t30.id AS id_31, t30.title AS title_32, t30.name AS name_33, t30.lastname AS lastname_34, t30.company AS company_35, t30.street AS street_36, t30.phone AS phone_37, t30.description AS description_38, t30.zip_code AS zip_code_39, t30.city AS city_40, t30.province AS province_41, t30.employess AS employess_42, t30.regulations AS regulations_43, t30.regulations41 AS regulations41_44, t30.regulations42 AS regulations42_45, t30.commercial_info AS commercial_info_46, t30.house_number AS house_number_47, t30.apartment_number AS apartment_number_48, t30.tax_office AS tax_office_49, t30.phone_approval AS phone_approval_50, t30.postal_street AS postal_street_51, t30.postal_zip_code AS postal_zip_code_52, t30.postal_city AS postal_city_53, t30.postal_house_number AS postal_house_number_54, t30.postal_apartment_number AS postal_apartment_number_55, t30.regions AS regions_56, t30.activity AS activity_57, t30.vip AS vip_58, t30.wykonawca AS wykonawca_59, t30.del AS del_60, t30.invoice_street AS invoice_street_61, t30.invoice_house_number AS invoice_house_number_62, t30.invoice_apartment_number AS invoice_apartment_number_63, t30.invoice_zip_code AS invoice_zip_code_64, t30.invoice_city AS invoice_city_65, t30.invoice_nip AS invoice_nip_66, t30.invoice_company AS invoice_company_67, t30.distributor_id AS distributor_id_68, t30.sap_number AS sap_number_69, t0.adviser_id AS adviser_id_70 FROM user t0 LEFT JOIN profile t30 ON t0.profile_id = t30.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
5583
]
|
2 | 1.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3 FROM user_groups t0 INNER JOIN user_group ON t0.id = user_group.group_id WHERE user_group.user_id = ?
Parameters:
[
5583
]
|
3 | 1.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.points AS points_4, t0.description AS description_5, t0.promo AS promo_6, t0.type AS type_7, t0.add_extra_point AS add_extra_point_8, t0.platform AS platform_9, t0.edycja AS edycja_10, t0.emptyinvoice AS emptyinvoice_11, t0.reason AS reason_12, t0.custom_reason AS custom_reason_13, t0.kind AS kind_14, t0.document_date AS document_date_15, t0.seller AS seller_16, t0.accepted_at AS accepted_at_17, t0.accepted_by AS accepted_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.author_id AS author_id_22, t0.creator_id AS creator_id_23 FROM i_invoice t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"160211"
]
|
4 | 1.66 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.username_canonical AS username_canonical_7, t0.status AS status_8, t0.points AS points_9, t0.points_approved AS points_approved_10, t0.points_waiting AS points_waiting_11, t0.points_paid AS points_paid_12, t0.points_available AS points_available_13, t0.all_extra_points AS all_extra_points_14, t0.czwartaedycja AS czwartaedycja_15, t0.piataedycja AS piataedycja_16, t0.szostaedycja AS szostaedycja_17, t0.siodmaedycja AS siodmaedycja_18, t0.osmaedycja AS osmaedycja_19, t0.enabled AS enabled_20, t0.salt AS salt_21, t0.last_login AS last_login_22, t0.is_allowed AS is_allowed_23, t0.statements AS statements_24, t0.statements2 AS statements2_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.deleted_at AS deleted_at_28, t0.profile_id AS profile_id_29, t30.id AS id_31, t30.title AS title_32, t30.name AS name_33, t30.lastname AS lastname_34, t30.company AS company_35, t30.street AS street_36, t30.phone AS phone_37, t30.description AS description_38, t30.zip_code AS zip_code_39, t30.city AS city_40, t30.province AS province_41, t30.employess AS employess_42, t30.regulations AS regulations_43, t30.regulations41 AS regulations41_44, t30.regulations42 AS regulations42_45, t30.commercial_info AS commercial_info_46, t30.house_number AS house_number_47, t30.apartment_number AS apartment_number_48, t30.tax_office AS tax_office_49, t30.phone_approval AS phone_approval_50, t30.postal_street AS postal_street_51, t30.postal_zip_code AS postal_zip_code_52, t30.postal_city AS postal_city_53, t30.postal_house_number AS postal_house_number_54, t30.postal_apartment_number AS postal_apartment_number_55, t30.regions AS regions_56, t30.activity AS activity_57, t30.vip AS vip_58, t30.wykonawca AS wykonawca_59, t30.del AS del_60, t30.invoice_street AS invoice_street_61, t30.invoice_house_number AS invoice_house_number_62, t30.invoice_apartment_number AS invoice_apartment_number_63, t30.invoice_zip_code AS invoice_zip_code_64, t30.invoice_city AS invoice_city_65, t30.invoice_nip AS invoice_nip_66, t30.invoice_company AS invoice_company_67, t30.distributor_id AS distributor_id_68, t30.sap_number AS sap_number_69, t0.adviser_id AS adviser_id_70 FROM user t0 LEFT JOIN profile t30 ON t0.profile_id = t30.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
4136
]
|
5 | 1.49 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.points AS points_3, t0.title AS title_4, t0.sum AS sum_5, t0.deleted_at AS deleted_at_6, t0.invoice_id AS invoice_id_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.subtitle AS subtitle_12, t9.status AS status_13, t9.edycja7 AS edycja7_14, t9.base_price AS base_price_15, t9.description AS description_16, t9.options AS options_17, t9.points AS points_18, t9.netto AS netto_19, t9.promo_points AS promo_points_20, t9.promo_start AS promo_start_21, t9.promo_end AS promo_end_22, t9.number AS number_23, t9.manufacturer AS manufacturer_24, t9.packing AS packing_25, t9.packing2 AS packing2_26, t9.orderable AS orderable_27, t9.position AS position_28, t9.vip AS vip_29, t9.only_vip AS only_vip_30, t9.knauf AS knauf_31, t9.label AS label_32, t9.info AS info_33, t9.slug AS slug_34, t9.image_name AS image_name_35, t9.created_at AS created_at_36, t9.updated_at AS updated_at_37, t9.deleted_at AS deleted_at_38 FROM i_invoice_product t0 INNER JOIN p_product t9 ON t0.product_id = t9.id WHERE t0.invoice_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
160211
]
|
6 | 1.04 ms |
SELECT t0.id AS id_1, t0.image AS image_2, t0.main AS main_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.invoice_id AS invoice_id_7 FROM i_invoice_photo t0 WHERE t0.invoice_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
160211
]
|
7 | 1.64 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.email AS email_4, u0_.is_verified AS is_verified_5, u0_.username_canonical AS username_canonical_6, u0_.status AS status_7, u0_.points AS points_8, u0_.points_approved AS points_approved_9, u0_.points_waiting AS points_waiting_10, u0_.points_paid AS points_paid_11, u0_.points_available AS points_available_12, u0_.all_extra_points AS all_extra_points_13, u0_.czwartaedycja AS czwartaedycja_14, u0_.piataedycja AS piataedycja_15, u0_.szostaedycja AS szostaedycja_16, u0_.siodmaedycja AS siodmaedycja_17, u0_.osmaedycja AS osmaedycja_18, u0_.enabled AS enabled_19, u0_.salt AS salt_20, u0_.last_login AS last_login_21, u0_.is_allowed AS is_allowed_22, u0_.statements AS statements_23, u0_.statements2 AS statements2_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.deleted_at AS deleted_at_27, u0_.profile_id AS profile_id_28, u0_.adviser_id AS adviser_id_29 FROM user u0_ WHERE (u0_.id IN (?)) AND (u0_.deleted_at IS NULL)
Parameters:
[
"4136"
]
|
8 | 1.17 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.subtitle AS subtitle_2, p0_.status AS status_3, p0_.edycja7 AS edycja7_4, p0_.base_price AS base_price_5, p0_.description AS description_6, p0_.options AS options_7, p0_.points AS points_8, p0_.netto AS netto_9, p0_.promo_points AS promo_points_10, p0_.promo_start AS promo_start_11, p0_.promo_end AS promo_end_12, p0_.number AS number_13, p0_.manufacturer AS manufacturer_14, p0_.packing AS packing_15, p0_.packing2 AS packing2_16, p0_.orderable AS orderable_17, p0_.position AS position_18, p0_.vip AS vip_19, p0_.only_vip AS only_vip_20, p0_.knauf AS knauf_21, p0_.label AS label_22, p0_.info AS info_23, p0_.slug AS slug_24, p0_.image_name AS image_name_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.deleted_at AS deleted_at_28 FROM p_product p0_ LEFT JOIN product_product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN p_category p1_ ON p1_.id = p2_.product_category_id WHERE p0_.status = ? AND p1_.id = 1 AND p0_.deleted_at IS NULL AND p0_.id IN (?) ORDER BY p0_.id ASC
Parameters:
[ 1 "165" ] |
9 | 0.99 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.subtitle AS subtitle_2, p0_.status AS status_3, p0_.edycja7 AS edycja7_4, p0_.base_price AS base_price_5, p0_.description AS description_6, p0_.options AS options_7, p0_.points AS points_8, p0_.netto AS netto_9, p0_.promo_points AS promo_points_10, p0_.promo_start AS promo_start_11, p0_.promo_end AS promo_end_12, p0_.number AS number_13, p0_.manufacturer AS manufacturer_14, p0_.packing AS packing_15, p0_.packing2 AS packing2_16, p0_.orderable AS orderable_17, p0_.position AS position_18, p0_.vip AS vip_19, p0_.only_vip AS only_vip_20, p0_.knauf AS knauf_21, p0_.label AS label_22, p0_.info AS info_23, p0_.slug AS slug_24, p0_.image_name AS image_name_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.deleted_at AS deleted_at_28 FROM p_product p0_ LEFT JOIN product_product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN p_category p1_ ON p1_.id = p2_.product_category_id WHERE p0_.status = ? AND p1_.id = 1 AND p0_.deleted_at IS NULL AND p0_.id IN (?) ORDER BY p0_.id ASC
Parameters:
[ 1 "182" ] |
10 | 1.69 ms |
SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = ? AND e0_.object_class = ?
Parameters:
[ "160211" "App\Entity\Invoice" ] |
11 | 1.27 ms |
"START TRANSACTION"
Parameters:
[] |
12 | 1.18 ms |
INSERT INTO ext_log_entries (action, logged_at, object_id, object_class, version, data, username) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "update" "2025-07-22 06:38:01" "160211" "App\Entity\Invoice" 2 "a:1:{s:6:"status";i:2;}" "knauf.profit@mantis.net.pl" ] |
13 | 1.04 ms |
UPDATE i_invoice SET status = ?, accepted_at = ?, accepted_by = ?, updated_at = ? WHERE id = ?
Parameters:
[ 2 "2025-07-22 06:38:01" "knauf.profit@mantis.net.pl" "2025-07-22 06:38:01" 160211 ] |
14 | 0.84 ms |
UPDATE i_invoice_product SET quantity = ? WHERE id = ?
Parameters:
[ "2100" 460638 ] |
15 | 7.42 ms |
"COMMIT"
Parameters:
[] |
16 | 2.53 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.comment AS comment_4, t0.item_id AS item_id_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.invoice_id AS invoice_id_9, t0.user_id AS user_id_10 FROM points t0 WHERE t0.item_id = ? AND t0.type = ? LIMIT 1
Parameters:
[ 160211 "2" ] |
17 | 0.98 ms |
"START TRANSACTION"
Parameters:
[] |
18 | 0.90 ms |
INSERT INTO points (type, amount, comment, item_id, status, created_at, updated_at, invoice_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2 "2" "FVS/108/06/2025 - 2 punkty za aktualną fakturę" 160211 0 "2025-07-22 06:38:01" null 160211 4136 ] |
19 | 0.82 ms |
UPDATE i_invoice SET points = ?, updated_at = ? WHERE id = ?
Parameters:
[ "174" "2025-07-22 06:38:01" 160211 ] |
20 | 1.80 ms |
UPDATE i_invoice_product SET points = ? WHERE id = ?
Parameters:
[ "0.60" 460637 ] |
21 | 0.82 ms |
UPDATE i_invoice_product SET points = ? WHERE id = ?
Parameters:
[ "0.04" 460638 ] |
22 | 8.04 ms |
"COMMIT"
Parameters:
[] |
23 | 0.99 ms |
"START TRANSACTION"
Parameters:
[] |
24 | 0.95 ms |
INSERT INTO i_logs (item_id, operation_id, item_type, platform, created_at, updated_at, author_id, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 160211 7 1 2 "2025-07-22 06:38:01" "2025-07-22 06:38:01" 5583 160211 ] |
25 | 0.83 ms |
UPDATE i_invoice SET updated_at = ? WHERE id = ?
Parameters:
[ "2025-07-22 06:38:01" 160211 ] |
26 | 9.54 ms |
"COMMIT"
Parameters:
[] |
27 | 1.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.points AS points_4, t0.description AS description_5, t0.promo AS promo_6, t0.type AS type_7, t0.add_extra_point AS add_extra_point_8, t0.platform AS platform_9, t0.edycja AS edycja_10, t0.emptyinvoice AS emptyinvoice_11, t0.reason AS reason_12, t0.custom_reason AS custom_reason_13, t0.kind AS kind_14, t0.document_date AS document_date_15, t0.seller AS seller_16, t0.accepted_at AS accepted_at_17, t0.accepted_by AS accepted_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.author_id AS author_id_22, t0.creator_id AS creator_id_23 FROM i_invoice t0 WHERE t0.author_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
4136
]
|
28 | 1.31 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.amount AS amount_3, t0.comment AS comment_4, t0.item_id AS item_id_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.invoice_id AS invoice_id_9, t0.user_id AS user_id_10 FROM points t0 WHERE t0.user_id = ?
Parameters:
[
4136
]
|
29 | 1.20 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.points AS points_3, t0.description AS description_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.street AS street_7, t0.house_number AS house_number_8, t0.apartment_number AS apartment_number_9, t0.zip_code AS zip_code_10, t0.city AS city_11, t0.user_comment AS user_comment_12, t0.tracking_url AS tracking_url_13, t0.another_invoice_data AS another_invoice_data_14, t0.invoice_street AS invoice_street_15, t0.invoice_house_number AS invoice_house_number_16, t0.invoice_apartment_number AS invoice_apartment_number_17, t0.invoice_zip_code AS invoice_zip_code_18, t0.invoice_city AS invoice_city_19, t0.invoice_nip AS invoice_nip_20, t0.invoice_pesel AS invoice_pesel_21, t0.invoice_company AS invoice_company_22, t0.invoice_name AS invoice_name_23, t0.invoice_last_name AS invoice_last_name_24, t0.phone AS phone_25, t0.accepted_date AS accepted_date_26, t0.rejected_date AS rejected_date_27, t0.implementation_date AS implementation_date_28, t0.realized_date AS realized_date_29, t0.user_canceled_date AS user_canceled_date_30, t0.admin_canceled_date AS admin_canceled_date_31, t0.token AS token_32, t0.hash AS hash_33, t0.ext_order_id AS ext_order_id_34, t0.order_id AS order_id_35, t0.platnosc_id AS platnosc_id_36, t0.ident AS ident_37, t0.product_id AS product_id_38, t0.card_id AS card_id_39, t0.gifts AS gifts_40, t0.knauf AS knauf_41, t0.email AS email_42, t0.payunotify AS payunotify_43, t0.paid AS paid_44, t0.type AS type_45, t0.payment_status AS payment_status_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.deleted_at AS deleted_at_49, t0.author_id AS author_id_50, t0.distributor_id AS distributor_id_51, t0.delivery_address_id AS delivery_address_id_52 FROM `o_order` t0 WHERE t0.author_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
4136
]
|
30 | 1.24 ms |
SELECT MAX(e0_.version) AS sclr_0 FROM ext_log_entries e0_ WHERE e0_.object_id = ? AND e0_.object_class = ?
Parameters:
[ "4136" "App\Entity\User" ] |
31 | 0.75 ms |
"START TRANSACTION"
Parameters:
[] |
32 | 0.92 ms |
INSERT INTO ext_log_entries (action, logged_at, object_id, object_class, version, data, username) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "update" "2025-07-22 06:38:01" "4136" "App\Entity\User" 33 "a:6:{s:6:"points";s:7:"7620.65";s:14:"pointsApproved";s:6:"2152.1";s:13:"pointsWaiting";s:7:"5468.55";s:10:"pointsPaid";s:3:"700";s:15:"pointsAvailable";s:6:"1480.1";s:14:"allExtraPoints";s:2:"28";}" "knauf.profit@mantis.net.pl" ] |
33 | 0.92 ms |
UPDATE user SET points = ?, points_approved = ?, points_waiting = ?, points_paid = ?, points_available = ?, all_extra_points = ?, updated_at = ? WHERE id = ?
Parameters:
[ "7620.65" "2152.1" "5468.55" "700" "1480.1" "28" "2025-07-22 06:38:01" 4136 ] |
34 | 0.78 ms |
UPDATE i_invoice SET updated_at = ? WHERE id = ?
Parameters:
[ "2025-07-22 06:38:01" 160211 ] |
35 | 8.00 ms |
"COMMIT"
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\Invoice | 63 |
App\Entity\Point | 27 |
App\Entity\User | 3 |
App\Entity\Profile | 2 |
App\Entity\InvoiceProduct | 2 |
App\Entity\Product | 2 |
Gedmo\Loggable\Entity\LogEntry | 2 |
App\Entity\Group | 1 |
App\Entity\InvoicePhoto | 1 |
App\Entity\InvoiceLog | 1 |
App\Entity\Order | 1 |
App\Entity\DeliveryAddress | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\Profile | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Article | No errors. |
App\Entity\Invoice |
|
App\Entity\Group | No errors. |
App\Entity\Order | No errors. |
App\Entity\Point | No errors. |
App\Entity\DeliveryAddress | No errors. |
App\Entity\InvoicePhoto | No errors. |
App\Entity\InvoiceProduct | No errors. |
App\Entity\InvoiceLog | No errors. |
App\Entity\Product | No errors. |
App\Entity\ProductCategory | No errors. |
App\Entity\ProductPhoto | No errors. |
App\Entity\OrderProduct | No errors. |
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry | No errors. |
Gedmo\Loggable\Entity\LogEntry | No errors. |
App\Entity\Distributor | No errors. |
App\Entity\OrderLog | No errors. |