GET https://izba.stbsns.pl/

Query Metrics

17 Database Queries
11 Different statements
3.82 ms Query time
0 Invalid entities
45 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.65 ms
(16.92%)
3
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
]
0.51 ms
(13.30%)
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, 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_.slug AS slug_39, c1_.lat AS lat_40, c1_.lon AS lon_41, i2_.id AS id_42, i2_.nazwa AS nazwa_43, i2_.mime_type AS mime_type_44, i2_.file_path AS file_path_45, i2_.title AS title_46, i2_.description AS description_47, i2_.created_at AS created_at_48, i2_.updated_at AS updated_at_49, i2_.file_size AS file_size_50, i2_.height AS height_51, i2_.width AS width_52, i0_.czlonek_id AS czlonek_id_53, i0_.zdjecie_id AS zdjecie_id_54, c1_.image_id AS image_id_55, c1_.status_id AS status_id_56, c1_.typ_id AS typ_id_57, i2_.user_id AS user_id_58 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
  4
]
0.50 ms
(13.04%)
1
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_.slug AS slug_51, c4_.lat AS lat_52, c4_.lon AS lon_53, u0_.role_id AS role_id_54, u0_.group_id AS group_id_55, u1_.user_id AS user_id_56, u1_.image_id AS image_id_57, i2_.user_id AS user_id_58, c4_.image_id AS image_id_59, c4_.status_id AS status_id_60, c4_.typ_id AS typ_id_61 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
]
0.45 ms
(11.79%)
3
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
]
0.41 ms
(10.68%)
3
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
]
0.33 ms
(8.59%)
1
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_.slug AS slug_48, c3_.lat AS lat_49, c3_.lon AS lon_50, u0_.user_id AS user_id_51, u0_.image_id AS image_id_52, u1_.role_id AS role_id_53, u1_.group_id AS group_id_54, i2_.user_id AS user_id_55, c3_.image_id AS image_id_56, c3_.status_id AS status_id_57, c3_.typ_id AS typ_id_58 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
]
0.28 ms
(7.38%)
1
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_.slug AS slug_20, c0_.lat AS lat_21, c0_.lon AS lon_22, i1_.id AS id_23, i1_.nazwa AS nazwa_24, i1_.mime_type AS mime_type_25, i1_.file_path AS file_path_26, i1_.title AS title_27, i1_.description AS description_28, i1_.created_at AS created_at_29, i1_.updated_at AS updated_at_30, i1_.file_size AS file_size_31, i1_.height AS height_32, i1_.width AS width_33, c0_.image_id AS image_id_34, c0_.status_id AS status_id_35, c0_.typ_id AS typ_id_36, i1_.user_id AS user_id_37 FROM czlonkowie_izby c0_ LEFT JOIN images i1_ ON c0_.image_id = i1_.id WHERE c0_.id IN (?, ?, ?) ORDER BY c0_.id ASC
Parameters:
[
  3
  7
  81
]
0.20 ms
(5.21%)
1
SELECT c0_.id AS id_0 FROM czlonkowie_izby c0_ INNER JOIN czlonek_izby_status c1_ ON c0_.status_id = c1_.id WHERE c1_.kod = 'aktywny'
Parameters:
[]
0.20 ms
(5.18%)
1
SELECT i0_.id AS id_0 FROM inwestycje i0_ WHERE i0_.status <> -1
Parameters:
[]
0.16 ms
(4.06%)
1
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:
[]
0.15 ms
(3.84%)
1
SELECT VERSION() as version, DATABASE() as database_name
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 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\CzlonekIzbyStatus 1
App\Entity\CzlonekIzbyTyp 1
App\Entity\Group 1
App\Entity\CategoryType 1

Entities Mapping