Query Metrics

5 Database Queries
5 Different statements
4.10 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.60 ms
(39.15%)
1
SELECT g0_.id AS id_0, g1_.id AS id_1, g1_.nazwa AS nazwa_2, g1_.slug AS slug_3, g1_.naglowek AS naglowek_4, g1_.tresc AS tresc_5, g1_.tagi AS tagi_6, g1_.data_utworzenia AS data_utworzenia_7, g1_.data_publikacji AS data_publikacji_8, g1_.wazdy_do AS wazdy_do_9, g2_.id AS id_10, g2_.kolejnosc AS kolejnosc_11, i3_.id AS id_12, i3_.nazwa AS nazwa_13, i3_.mime_type AS mime_type_14, i3_.file_path AS file_path_15, i3_.title AS title_16, i3_.description AS description_17, i3_.created_at AS created_at_18, i3_.updated_at AS updated_at_19, i3_.file_size AS file_size_20, i3_.height AS height_21, i3_.width AS width_22, g0_.galeria_id AS galeria_id_23, g0_.inwestycja_id AS inwestycja_id_24, g1_.category_id AS category_id_25, g1_.user_id AS user_id_26, g2_.image_id AS image_id_27, g2_.galeria_id AS galeria_id_28, i3_.user_id AS user_id_29 FROM galeria_inwestycje g0_ LEFT JOIN galerie g1_ ON g0_.galeria_id = g1_.id LEFT JOIN galeria_images g2_ ON g1_.id = g2_.galeria_id LEFT JOIN images i3_ ON g2_.image_id = i3_.id WHERE g0_.inwestycja_id = ? ORDER BY g2_.kolejnosc ASC
Parameters:
[
  5
]
0.94 ms
(22.83%)
1
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:
[
  48
]
0.52 ms
(12.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, i0_.czlonek_id AS czlonek_id_19, i0_.zdjecie_id AS zdjecie_id_20 FROM inwestycje i0_ WHERE i0_.czlonek_id = ? AND i0_.id <> ? LIMIT 5
Parameters:
[
  2
  5
]
0.52 ms
(12.67%)
1
SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.miasto AS miasto_3, t0.kod_pocztowy AS kod_pocztowy_4, t0.ulica AS ulica_5, t0.opis_lead AS opis_lead_6, t0.opis AS opis_7, t0.ilosc_mieszkan AS ilosc_mieszkan_8, t0.ilosc_pum AS ilosc_pum_9, t0.ilosc_lokali_uslugowych AS ilosc_lokali_uslugowych_10, t0.ilosc_pul AS ilosc_pul_11, t0.ilosc_budynkow AS ilosc_budynkow_12, t0.ilosc_parkingow AS ilosc_parkingow_13, t0.termin_ukonczenia AS termin_ukonczenia_14, t0.planowany_termin AS planowany_termin_15, t0.status AS status_16, t0.slug AS slug_17, t0.lat AS lat_18, t0.lon AS lon_19, t0.czlonek_id AS czlonek_id_20, t0.zdjecie_id AS zdjecie_id_21 FROM inwestycje t0 WHERE t0.slug = ? AND t0.czlonek_id = ? LIMIT 1
Parameters:
[
  "5_budowa-2-budynkow-wielorodzinnych-bez-podpiwniczenia-ul-a-sloniny"
  2
]
0.51 ms
(12.57%)
1
SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.miasto AS miasto_3, t0.kod_pocztowy AS kod_pocztowy_4, t0.ulica AS ulica_5, t0.email AS email_6, t0.www AS www_7, t0.tel AS tel_8, t0.opis AS opis_9, t0.ilosc_mieszkan AS ilosc_mieszkan_10, t0.ilosc_budynkow AS ilosc_budynkow_11, t0.ilosc_pum AS ilosc_pum_12, t0.ilosc_mieszkan_zarzadzanych AS ilosc_mieszkan_zarzadzanych_13, t0.ilosc_budynkow_zarzadzanych AS ilosc_budynkow_zarzadzanych_14, t0.ilosc_pum_zarzadzanych AS ilosc_pum_zarzadzanych_15, t0.kapital_zakladowy AS kapital_zakladowy_16, t0.nip AS nip_17, t0.krs AS krs_18, t0.data_przystapienia AS data_przystapienia_19, t0.data_utworzenia AS data_utworzenia_20, t0.status AS status_21, t0.slug AS slug_22, t0.lat AS lat_23, t0.lon AS lon_24, t0.image_id AS image_id_25 FROM czlonkowie_izby t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "2_sim-slask-poludnie-sp-z-oo"
]

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 2
App\Entity\CzlonekIzby 1
App\Entity\Inwestycje 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\CzlonekIzby No errors.
App\Entity\Image No errors.
App\Entity\User No errors.
App\Entity\Inwestycje No errors.
App\Entity\GaleriaInwestycje No errors.
App\Entity\Galerie No errors.
App\Entity\GaleriaImage No errors.
App\Entity\Category No errors.