GET https://izbatbs.stbsns.pl/

Query Metrics

17 Database Queries
11 Different statements
17.42 ms Query time
0 Invalid entities
43 Managed entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT VERSION() as version, DATABASE() as database_name
Parameters:
[]
2 1.52 ms
SELECT i0_.id AS id_0 FROM inwestycje i0_ WHERE i0_.status <> -1
Parameters:
[]
3 3.00 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.59 ms
SELECT c0_.id AS id_0 FROM czlonkowie_izby c0_ WHERE c0_.status > 0
Parameters:
[]
5 0.80 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:
[
  2
  19
  86
]
6 0.57 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 1.50 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 2.51 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 1.97 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.71 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.67 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.54 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.47 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.57 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.52 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.50 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.47 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.