Query Metrics
3
Database Queries
3
Different statements
7.15 ms
Query time
1
Invalid entities
5
Managed entities
Queries
#▲ | 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 |
|
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. |