GET http://profit.knauf.pl/invoice/product-points/191

Query Metrics

3 Database Queries
3 Different statements
7.15 ms Query time
1 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 2.38 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:
[
  1607
]
2 1.63 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:
[
  1607
]
3 3.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.subtitle AS subtitle_3, t0.status AS status_4, t0.edycja7 AS edycja7_5, t0.base_price AS base_price_6, t0.description AS description_7, t0.options AS options_8, t0.points AS points_9, t0.netto AS netto_10, t0.promo_points AS promo_points_11, t0.promo_start AS promo_start_12, t0.promo_end AS promo_end_13, t0.number AS number_14, t0.manufacturer AS manufacturer_15, t0.packing AS packing_16, t0.packing2 AS packing2_17, t0.orderable AS orderable_18, t0.position AS position_19, t0.vip AS vip_20, t0.only_vip AS only_vip_21, t0.knauf AS knauf_22, t0.label AS label_23, t0.info AS info_24, t0.slug AS slug_25, t0.image_name AS image_name_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.deleted_at AS deleted_at_29 FROM p_product t0 WHERE t0.id = ?
Parameters:
[
  "191"
]

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 2
App\Entity\Profile 1
App\Entity\Group 1
App\Entity\Product 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\Product No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductPhoto No errors.
App\Entity\InvoiceProduct No errors.
App\Entity\OrderProduct No errors.