Query Metrics

2 Database Queries
2 Different statements
12.37 ms Query time
1 Invalid entities
83 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.73 ms
(78.68%)
1
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_ LEFT JOIN profile p1_ ON u0_.profile_id = p1_.id LEFT JOIN user_group u3_ ON u0_.id = u3_.user_id LEFT JOIN user_groups u2_ ON u2_.id = u3_.group_id WHERE (u0_.status = ? AND u2_.roles LIKE ? AND u0_.id <> ?) AND (u0_.deleted_at IS NULL) ORDER BY p1_.lastname ASC
Parameters:
[
  1
  "%ROLE_DORADCA%"
  "2002"
]
2.64 ms
(21.32%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.lastname AS lastname_4, t0.company AS company_5, t0.street AS street_6, t0.phone AS phone_7, t0.description AS description_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t0.province AS province_11, t0.employess AS employess_12, t0.regulations AS regulations_13, t0.regulations41 AS regulations41_14, t0.regulations42 AS regulations42_15, t0.commercial_info AS commercial_info_16, t0.house_number AS house_number_17, t0.apartment_number AS apartment_number_18, t0.tax_office AS tax_office_19, t0.phone_approval AS phone_approval_20, t0.postal_street AS postal_street_21, t0.postal_zip_code AS postal_zip_code_22, t0.postal_city AS postal_city_23, t0.postal_house_number AS postal_house_number_24, t0.postal_apartment_number AS postal_apartment_number_25, t0.regions AS regions_26, t0.activity AS activity_27, t0.vip AS vip_28, t0.wykonawca AS wykonawca_29, t0.del AS del_30, t0.invoice_street AS invoice_street_31, t0.invoice_house_number AS invoice_house_number_32, t0.invoice_apartment_number AS invoice_apartment_number_33, t0.invoice_zip_code AS invoice_zip_code_34, t0.invoice_city AS invoice_city_35, t0.invoice_nip AS invoice_nip_36, t0.invoice_company AS invoice_company_37, t0.distributor_id AS distributor_id_38, t0.sap_number AS sap_number_39, t40.id AS id_41, t40.username AS username_42, t40.roles AS roles_43, t40.password AS password_44, t40.email AS email_45, t40.is_verified AS is_verified_46, t40.username_canonical AS username_canonical_47, t40.status AS status_48, t40.points AS points_49, t40.points_approved AS points_approved_50, t40.points_waiting AS points_waiting_51, t40.points_paid AS points_paid_52, t40.points_available AS points_available_53, t40.all_extra_points AS all_extra_points_54, t40.czwartaedycja AS czwartaedycja_55, t40.piataedycja AS piataedycja_56, t40.szostaedycja AS szostaedycja_57, t40.siodmaedycja AS siodmaedycja_58, t40.osmaedycja AS osmaedycja_59, t40.enabled AS enabled_60, t40.salt AS salt_61, t40.last_login AS last_login_62, t40.is_allowed AS is_allowed_63, t40.statements AS statements_64, t40.statements2 AS statements2_65, t40.created_at AS created_at_66, t40.updated_at AS updated_at_67, t40.deleted_at AS deleted_at_68, t40.profile_id AS profile_id_69, t40.adviser_id AS adviser_id_70 FROM profile t0 LEFT JOIN user t40 ON t40.profile_id = t0.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  3160
  308
  293
  3013
  2704
  302
  636
  291
  2498
  313
  2005
  311
  5522
  1656
  4946
  2844
  4292
  296
  5263
  315
  836
  4998
  307
  306
  297
  6769
  5521
  5887
  1456
  305
  6630
  316
  298
  309
  1655
  300
  299
  295
  304
  2556
  312
]

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 42
App\Entity\Profile 41

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Profile No errors.
App\Entity\Group 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\Order No errors.
App\Entity\Point No errors.
App\Entity\DeliveryAddress No errors.