Query Metrics
2
Database Queries
2
Different statements
3.51 ms
Query time
0
Invalid entities
40
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.94 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.56 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. |