Query Metrics
3
Database Queries
3
Different statements
3.85 ms
Query time
0
Invalid entities
15
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.71 ms (44.49%) |
1 |
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, i1_.id AS id_19, i1_.nazwa AS nazwa_20, i1_.mime_type AS mime_type_21, i1_.file_path AS file_path_22, i1_.title AS title_23, i1_.description AS description_24, i1_.created_at AS created_at_25, i1_.updated_at AS updated_at_26, i1_.file_size AS file_size_27, i1_.height AS height_28, i1_.width AS width_29, c2_.id AS id_30, c2_.nazwa AS nazwa_31, c2_.miasto AS miasto_32, c2_.kod_pocztowy AS kod_pocztowy_33, c2_.ulica AS ulica_34, c2_.email AS email_35, c2_.www AS www_36, c2_.tel AS tel_37, c2_.opis AS opis_38, c2_.ilosc_mieszkan AS ilosc_mieszkan_39, c2_.ilosc_budynkow AS ilosc_budynkow_40, c2_.ilosc_pum AS ilosc_pum_41, c2_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_42, c2_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_43, c2_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_44, c2_.kapital_zakladowy AS kapital_zakladowy_45, c2_.nip AS nip_46, c2_.krs AS krs_47, c2_.data_przystapienia AS data_przystapienia_48, c2_.data_utworzenia AS data_utworzenia_49, c2_.status AS status_50, c2_.slug AS slug_51, c2_.lat AS lat_52, c2_.lon AS lon_53, i0_.czlonek_id AS czlonek_id_54, i0_.zdjecie_id AS zdjecie_id_55, i1_.user_id AS user_id_56, c2_.image_id AS image_id_57 FROM inwestycje i0_ LEFT JOIN images i1_ ON i0_.zdjecie_id = i1_.id LEFT JOIN czlonkowie_izby c2_ ON i0_.czlonek_id = c2_.id WHERE i0_.status <> -1 ORDER BY i0_.id DESC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.42 ms (36.77%) |
1 |
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, i1_.id AS id_19, i1_.nazwa AS nazwa_20, i1_.mime_type AS mime_type_21, i1_.file_path AS file_path_22, i1_.title AS title_23, i1_.description AS description_24, i1_.created_at AS created_at_25, i1_.updated_at AS updated_at_26, i1_.file_size AS file_size_27, i1_.height AS height_28, i1_.width AS width_29, c2_.id AS id_30, c2_.nazwa AS nazwa_31, c2_.miasto AS miasto_32, c2_.kod_pocztowy AS kod_pocztowy_33, c2_.ulica AS ulica_34, c2_.email AS email_35, c2_.www AS www_36, c2_.tel AS tel_37, c2_.opis AS opis_38, c2_.ilosc_mieszkan AS ilosc_mieszkan_39, c2_.ilosc_budynkow AS ilosc_budynkow_40, c2_.ilosc_pum AS ilosc_pum_41, c2_.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_42, c2_.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_43, c2_.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_44, c2_.kapital_zakladowy AS kapital_zakladowy_45, c2_.nip AS nip_46, c2_.krs AS krs_47, c2_.data_przystapienia AS data_przystapienia_48, c2_.data_utworzenia AS data_utworzenia_49, c2_.status AS status_50, c2_.slug AS slug_51, c2_.lat AS lat_52, c2_.lon AS lon_53, i0_.czlonek_id AS czlonek_id_54, i0_.zdjecie_id AS zdjecie_id_55, i1_.user_id AS user_id_56, c2_.image_id AS image_id_57 FROM inwestycje i0_ LEFT JOIN images i1_ ON i0_.zdjecie_id = i1_.id LEFT JOIN czlonkowie_izby c2_ ON i0_.czlonek_id = c2_.id WHERE i0_.miasto IS NOT NULL AND i0_.status <> -1 ORDER BY i0_.id DESC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.72 ms (18.74%) |
1 |
SELECT COUNT(i0_.id) AS sclr_0 FROM inwestycje i0_ LEFT JOIN images i1_ ON i0_.zdjecie_id = i1_.id LEFT JOIN czlonkowie_izby c2_ ON i0_.czlonek_id = c2_.id WHERE i0_.status <> -1 ORDER BY i0_.id DESC
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 | 7 |
| App\Entity\Inwestycje | 5 |
| App\Entity\CzlonekIzby | 2 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Inwestycje | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\CzlonekIzby | No errors. |
| App\Entity\User | No errors. |