Query Metrics
17
Database Queries
11
Different statements
9.10 ms
Query time
0
Invalid entities
43
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.41 ms |
SELECT VERSION() as version, DATABASE() as database_name
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.62 ms |
SELECT i0_.id AS id_0 FROM inwestycje i0_ WHERE i0_.status <> -1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 1.15 ms |
SELECT i0_.id AS id_0, i0_.nazwa AS nazwa_1, i0_.miasto AS miasto_2, i0_.kod_pocztowy AS kod_pocztowy_3, i0_.ulica AS ulica_4, i0_.opis_lead AS opis_lead_5, i0_.opis AS opis_6, i0_.ilosc_mieszkan AS ilosc_mieszkan_7, i0_.ilosc_pum AS ilosc_pum_8, i0_.ilosc_lokali_uslugowych AS ilosc_lokali_uslugowych_9, i0_.ilosc_pul AS ilosc_pul_10, i0_.ilosc_budynkow AS ilosc_budynkow_11, i0_.ilosc_parkingow AS ilosc_parkingow_12, i0_.termin_ukonczenia AS termin_ukonczenia_13, i0_.planowany_termin AS planowany_termin_14, i0_.status AS status_15, i0_.slug AS slug_16, i0_.lat AS lat_17, i0_.lon AS lon_18, c1_.id AS id_19, c1_.nazwa AS nazwa_20, c1_.miasto AS miasto_21, c1_.kod_pocztowy AS kod_pocztowy_22, c1_.ulica AS ulica_23, c1_.email AS email_24, c1_.www AS www_25, c1_.tel AS tel_26, c1_.opis AS opis_27, c1_.ilosc_mieszkan AS ilosc_mieszkan_28, c1_.ilosc_budynkow AS ilosc_budynkow_29, c1_.ilosc_pum AS ilosc_pum_30, c1_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_31, c1_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_32, c1_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_33, c1_.kapital_zakladowy AS kapital_zakladowy_34, c1_.nip AS nip_35, c1_.krs AS krs_36, c1_.data_przystapienia AS data_przystapienia_37, c1_.data_utworzenia AS data_utworzenia_38, c1_.status AS status_39, c1_.slug AS slug_40, c1_.lat AS lat_41, c1_.lon AS lon_42, i2_.id AS id_43, i2_.nazwa AS nazwa_44, i2_.mime_type AS mime_type_45, i2_.file_path AS file_path_46, i2_.title AS title_47, i2_.description AS description_48, i2_.created_at AS created_at_49, i2_.updated_at AS updated_at_50, i2_.file_size AS file_size_51, i2_.height AS height_52, i2_.width AS width_53, i0_.czlonek_id AS czlonek_id_54, i0_.zdjecie_id AS zdjecie_id_55, c1_.image_id AS image_id_56, i2_.user_id AS user_id_57 FROM inwestycje i0_ LEFT JOIN czlonkowie_izby c1_ ON i0_.czlonek_id = c1_.id LEFT JOIN images i2_ ON i0_.zdjecie_id = i2_.id WHERE i0_.id IN (?, ?, ?, ?)
Parameters:
[ 1 2 3 5 ]
|
||||||||||||||||||||||||||||
| 4 | 0.47 ms |
SELECT c0_.id AS id_0 FROM czlonkowie_izby c0_ WHERE c0_.status > 0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 0.51 ms |
SELECT c0_.id AS id_0, c0_.nazwa AS nazwa_1, c0_.miasto AS miasto_2, c0_.kod_pocztowy AS kod_pocztowy_3, c0_.ulica AS ulica_4, c0_.email AS email_5, c0_.www AS www_6, c0_.tel AS tel_7, c0_.opis AS opis_8, c0_.ilosc_mieszkan AS ilosc_mieszkan_9, c0_.ilosc_budynkow AS ilosc_budynkow_10, c0_.ilosc_pum AS ilosc_pum_11, c0_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_12, c0_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_13, c0_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_14, c0_.kapital_zakladowy AS kapital_zakladowy_15, c0_.nip AS nip_16, c0_.krs AS krs_17, c0_.data_przystapienia AS data_przystapienia_18, c0_.data_utworzenia AS data_utworzenia_19, c0_.status AS status_20, c0_.slug AS slug_21, c0_.lat AS lat_22, c0_.lon AS lon_23, i1_.id AS id_24, i1_.nazwa AS nazwa_25, i1_.mime_type AS mime_type_26, i1_.file_path AS file_path_27, i1_.title AS title_28, i1_.description AS description_29, i1_.created_at AS created_at_30, i1_.updated_at AS updated_at_31, i1_.file_size AS file_size_32, i1_.height AS height_33, i1_.width AS width_34, c0_.image_id AS image_id_35, i1_.user_id AS user_id_36 FROM czlonkowie_izby c0_ LEFT JOIN images i1_ ON c0_.image_id = i1_.id WHERE c0_.id IN (?, ?, ?) ORDER BY c0_.id ASC
Parameters:
[ 5 19 80 ]
|
||||||||||||||||||||||||||||
| 6 | 0.44 ms |
SELECT u0_.id AS id_0 FROM user_profiles u0_ WHERE u0_.motto IS NOT NULL AND u0_.motto <> '' AND CHAR_LENGTH(u0_.motto) > 30
Parameters:
[]
|
||||||||||||||||||||||||||||
| 7 | 0.68 ms |
SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.o_mnie AS o_mnie_2, u0_.stanowisko AS stanowisko_3, u0_.motto AS motto_4, u1_.id AS id_5, u1_.email AS email_6, u1_.name AS name_7, u1_.surname AS surname_8, u1_.password AS password_9, u1_.status AS status_10, u1_.is_active AS is_active_11, u1_.is_verified AS is_verified_12, u1_.settings AS settings_13, u1_.created_at AS created_at_14, u1_.updated_at AS updated_at_15, u1_.last_login_at AS last_login_at_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, c3_.id AS id_28, c3_.nazwa AS nazwa_29, c3_.miasto AS miasto_30, c3_.kod_pocztowy AS kod_pocztowy_31, c3_.ulica AS ulica_32, c3_.email AS email_33, c3_.www AS www_34, c3_.tel AS tel_35, c3_.opis AS opis_36, c3_.ilosc_mieszkan AS ilosc_mieszkan_37, c3_.ilosc_budynkow AS ilosc_budynkow_38, c3_.ilosc_pum AS ilosc_pum_39, c3_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_40, c3_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_41, c3_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_42, c3_.kapital_zakladowy AS kapital_zakladowy_43, c3_.nip AS nip_44, c3_.krs AS krs_45, c3_.data_przystapienia AS data_przystapienia_46, c3_.data_utworzenia AS data_utworzenia_47, c3_.status AS status_48, c3_.slug AS slug_49, c3_.lat AS lat_50, c3_.lon AS lon_51, u0_.user_id AS user_id_52, u0_.image_id AS image_id_53, u1_.role_id AS role_id_54, u1_.group_id AS group_id_55, i2_.user_id AS user_id_56, c3_.image_id AS image_id_57 FROM user_profiles u0_ LEFT JOIN users u1_ ON u0_.user_id = u1_.id LEFT JOIN images i2_ ON u0_.image_id = i2_.id LEFT JOIN user_czlonkowie u4_ ON u1_.id = u4_.user_id LEFT JOIN czlonkowie_izby c3_ ON c3_.id = u4_.czlonek_id WHERE u0_.id IN (?, ?)
Parameters:
[ 6 7 ]
|
||||||||||||||||||||||||||||
| 8 | 1.10 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 WHERE c7_.id = ? GROUP BY u0_.id ORDER BY u0_.id ASC LIMIT 3
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
| 9 | 0.59 ms |
SELECT a0_.id AS id_0, a0_.tytul AS tytul_1, a0_.slug AS slug_2, a0_.naglowek AS naglowek_3, a0_.tresc AS tresc_4, a0_.http_header AS http_header_5, a0_.tagi AS tagi_6, a0_.data_utworzenia AS data_utworzenia_7, a0_.data_publikacji AS data_publikacji_8, a0_.wazny_do AS wazny_do_9, a0_.widoczna AS widoczna_10, a0_.kategoria_id AS kategoria_id_11, a0_.czlonek_id AS czlonek_id_12, a0_.user_id AS user_id_13, a0_.image_id AS image_id_14 FROM aktualnosci a0_ LEFT JOIN categories c1_ ON a0_.kategoria_id = c1_.id WHERE c1_.id = ? AND a0_.widoczna = ? AND a0_.image_id IS NOT NULL ORDER BY a0_.data_publikacji DESC LIMIT 1
Parameters:
[ 1 3 ]
|
||||||||||||||||||||||||||||
| 10 | 0.50 ms |
SELECT a0_.id AS id_0, a0_.tytul AS tytul_1, a0_.slug AS slug_2, a0_.naglowek AS naglowek_3, a0_.tresc AS tresc_4, a0_.http_header AS http_header_5, a0_.tagi AS tagi_6, a0_.data_utworzenia AS data_utworzenia_7, a0_.data_publikacji AS data_publikacji_8, a0_.wazny_do AS wazny_do_9, a0_.widoczna AS widoczna_10, a0_.kategoria_id AS kategoria_id_11, a0_.czlonek_id AS czlonek_id_12, a0_.user_id AS user_id_13, a0_.image_id AS image_id_14 FROM aktualnosci a0_ LEFT JOIN categories c1_ ON a0_.kategoria_id = c1_.id WHERE c1_.id = ? AND a0_.widoczna = ? AND a0_.image_id IS NOT NULL ORDER BY a0_.data_publikacji DESC LIMIT 1
Parameters:
[ 11 3 ]
|
||||||||||||||||||||||||||||
| 11 | 0.39 ms |
SELECT a0_.id AS id_0, a0_.tytul AS tytul_1, a0_.slug AS slug_2, a0_.naglowek AS naglowek_3, a0_.tresc AS tresc_4, a0_.http_header AS http_header_5, a0_.tagi AS tagi_6, a0_.data_utworzenia AS data_utworzenia_7, a0_.data_publikacji AS data_publikacji_8, a0_.wazny_do AS wazny_do_9, a0_.widoczna AS widoczna_10, a0_.kategoria_id AS kategoria_id_11, a0_.czlonek_id AS czlonek_id_12, a0_.user_id AS user_id_13, a0_.image_id AS image_id_14 FROM aktualnosci a0_ LEFT JOIN categories c1_ ON a0_.kategoria_id = c1_.id WHERE c1_.id = ? AND a0_.widoczna = ? AND a0_.image_id IS NOT NULL ORDER BY a0_.data_publikacji DESC LIMIT 1
Parameters:
[ 12 3 ]
|
||||||||||||||||||||||||||||
| 12 | 0.48 ms |
SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.mime_type AS mime_type_3, t0.file_path AS file_path_4, t0.title AS title_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.file_size AS file_size_9, t0.height AS height_10, t0.width AS width_11, t0.user_id AS user_id_12 FROM images t0 WHERE t0.id = ?
Parameters:
[
40
]
|
||||||||||||||||||||||||||||
| 13 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_active AS is_active_5, t0.settings AS settings_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.type_id AS type_id_9 FROM categories t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 14 | 0.37 ms |
SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.mime_type AS mime_type_3, t0.file_path AS file_path_4, t0.title AS title_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.file_size AS file_size_9, t0.height AS height_10, t0.width AS width_11, t0.user_id AS user_id_12 FROM images t0 WHERE t0.id = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||
| 15 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_active AS is_active_5, t0.settings AS settings_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.type_id AS type_id_9 FROM categories t0 WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||
| 16 | 0.38 ms |
SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.mime_type AS mime_type_3, t0.file_path AS file_path_4, t0.title AS title_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.file_size AS file_size_9, t0.height AS height_10, t0.width AS width_11, t0.user_id AS user_id_12 FROM images t0 WHERE t0.id = ?
Parameters:
[
42
]
|
||||||||||||||||||||||||||||
| 17 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_active AS is_active_5, t0.settings AS settings_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.type_id AS type_id_9 FROM categories t0 WHERE t0.id = ?
Parameters:
[
12
]
|
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 | 15 |
| App\Entity\CzlonekIzby | 6 |
| App\Entity\Inwestycje | 4 |
| App\Entity\User | 3 |
| App\Entity\UserProfile | 3 |
| App\Entity\Aktualnosc | 3 |
| App\Entity\Category | 3 |
| App\Entity\Role | 2 |
| App\Entity\Skill | 2 |
| App\Entity\Group | 1 |
| App\Entity\CategoryType | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Inwestycje | No errors. |
| App\Entity\CzlonekIzby | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserProfile | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Skill | No errors. |
| App\Entity\WebAuthnCredential | No errors. |
| App\Entity\Aktualnosc | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\CategoryType | No errors. |