POST http://profit.knauf.pl/admin?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CInvoiceCrudController&entityId=160211&filters%5Btype%5D%5Bcomparison%…

Query Metrics

35 Database Queries
23 Different statements
70.66 ms Query time
1 Invalid entities
106 Managed entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\Invoice#invoiceLogs and App\Entity\InvoiceLog#invoice are inconsistent with each other.
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.