Query Metrics
2
Database Queries
2
Different statements
5.45 ms
Query time
1
Invalid entities
83
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.00 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_ 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 | 2.46 ms |
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 |