GET https://izbatbs.stbsns.pl/zespol

Query Metrics

2 Database Queries
2 Different statements
3.14 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM users u0_ INNER JOIN user_czlonkowie u2_ ON u0_.id = u2_.user_id INNER JOIN czlonkowie_izby c1_ ON c1_.id = u2_.czlonek_id
Parameters:
[]
2 2.19 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.name AS name_2, u0_.surname AS surname_3, u0_.password AS password_4, u0_.status AS status_5, u0_.is_active AS is_active_6, u0_.is_verified AS is_verified_7, u0_.settings AS settings_8, u0_.created_at AS created_at_9, u0_.updated_at AS updated_at_10, u0_.last_login_at AS last_login_at_11, u1_.id AS id_12, u1_.phone AS phone_13, u1_.o_mnie AS o_mnie_14, u1_.stanowisko AS stanowisko_15, u1_.motto AS motto_16, i2_.id AS id_17, i2_.nazwa AS nazwa_18, i2_.mime_type AS mime_type_19, i2_.file_path AS file_path_20, i2_.title AS title_21, i2_.description AS description_22, i2_.created_at AS created_at_23, i2_.updated_at AS updated_at_24, i2_.file_size AS file_size_25, i2_.height AS height_26, i2_.width AS width_27, s3_.id AS id_28, s3_.skill AS skill_29, s3_.icon AS icon_30, c4_.id AS id_31, c4_.nazwa AS nazwa_32, c4_.miasto AS miasto_33, c4_.kod_pocztowy AS kod_pocztowy_34, c4_.ulica AS ulica_35, c4_.email AS email_36, c4_.www AS www_37, c4_.tel AS tel_38, c4_.opis AS opis_39, c4_.ilosc_mieszkan AS ilosc_mieszkan_40, c4_.ilosc_budynkow AS ilosc_budynkow_41, c4_.ilosc_pum AS ilosc_pum_42, c4_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_43, c4_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_44, c4_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_45, c4_.kapital_zakladowy AS kapital_zakladowy_46, c4_.nip AS nip_47, c4_.krs AS krs_48, c4_.data_przystapienia AS data_przystapienia_49, c4_.data_utworzenia AS data_utworzenia_50, c4_.status AS status_51, c4_.slug AS slug_52, c4_.lat AS lat_53, c4_.lon AS lon_54, u0_.role_id AS role_id_55, u0_.group_id AS group_id_56, u1_.user_id AS user_id_57, u1_.image_id AS image_id_58, i2_.user_id AS user_id_59, c4_.image_id AS image_id_60 FROM users u0_ LEFT JOIN user_profiles u1_ ON u0_.id = u1_.user_id LEFT JOIN images i2_ ON u1_.image_id = i2_.id LEFT JOIN user_skills u5_ ON u0_.id = u5_.user_id LEFT JOIN skills s3_ ON s3_.id = u5_.skill_id LEFT JOIN user_czlonkowie u6_ ON u0_.id = u6_.user_id LEFT JOIN czlonkowie_izby c4_ ON c4_.id = u6_.czlonek_id INNER JOIN user_czlonkowie u8_ ON u0_.id = u8_.user_id INNER JOIN czlonkowie_izby c7_ ON c7_.id = u8_.czlonek_id GROUP BY u0_.id ORDER BY u0_.id ASC LIMIT 15
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\Image 12
App\Entity\User 9
App\Entity\UserProfile 7
App\Entity\CzlonekIzby 5
App\Entity\Role 3
App\Entity\Group 2
App\Entity\Skill 2

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\CzlonekIzby No errors.
App\Entity\UserProfile No errors.
App\Entity\Image No errors.
App\Entity\Skill No errors.
App\Entity\Role No errors.
App\Entity\Group No errors.
App\Entity\Category No errors.
App\Entity\WebAuthnCredential No errors.