User Deprecated: Class "Doctrine\ORM\Proxy\Autoloader" is deprecated. Use native lazy objects instead. (Autoloader.php:74 called by DoctrineBundle.php:136, https://github.com/doctrine/orm/pull/12005, package doctrine/orm)
User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal)
"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"
doctrine
[
"sql" => "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"
]
debug
Executing query:
"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_.slug AS slug_50, c2_.lat AS lat_51, c2_.lon AS lon_52, i0_.czlonek_id AS czlonek_id_53, i0_.zdjecie_id AS zdjecie_id_54, i1_.user_id AS user_id_55, c2_.image_id AS image_id_56, c2_.status_id AS status_id_57, c2_.typ_id AS typ_id_58 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"
doctrine
[
"sql" => "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_.slug AS slug_50, c2_.lat AS lat_51, c2_.lon AS lon_52, i0_.czlonek_id AS czlonek_id_53, i0_.zdjecie_id AS zdjecie_id_54, i1_.user_id AS user_id_55, c2_.image_id AS image_id_56, c2_.status_id AS status_id_57, c2_.typ_id AS typ_id_58 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"
]
deprecation
User Deprecated: Since symfony/var-exporter 7.3: Using ProxyHelper::generateLazyGhost() is deprecated, use native lazy objects instead.
User Deprecated: Since symfony/var-exporter 7.3: The "Symfony\Component\VarExporter\LazyGhostTrait" trait is deprecated, use native lazy objects instead.
"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_.slug AS slug_50, c2_.lat AS lat_51, c2_.lon AS lon_52, i0_.czlonek_id AS czlonek_id_53, i0_.zdjecie_id AS zdjecie_id_54, i1_.user_id AS user_id_55, c2_.image_id AS image_id_56, c2_.status_id AS status_id_57, c2_.typ_id AS typ_id_58 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"
doctrine
[
"sql" => "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_.slug AS slug_50, c2_.lat AS lat_51, c2_.lon AS lon_52, i0_.czlonek_id AS czlonek_id_53, i0_.zdjecie_id AS zdjecie_id_54, i1_.user_id AS user_id_55, c2_.image_id AS image_id_56, c2_.status_id AS status_id_57, c2_.typ_id AS typ_id_58 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"
]
deprecation
User Deprecated: Providing the property $uniqueConstraints on Doctrine\ORM\Mapping\Table does not have any effect and will be removed in Doctrine ORM 4.0. Please use the Doctrine\ORM\Mapping\UniqueConstraint attribute instead. (Table.php:36 called by UserProfile.php:10, https://github.com/doctrine/orm/pull/11357, package doctrine/orm)