Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.28 ms Query time

0 Invalid entities

12 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.53 ms

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:

[
  "1_sadeckie-towarzystwo-budownictwa-spolecznego"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '1_sadeckie-towarzystwo-budownictwa-spolecznego' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\InwestycjeController->view (line 86)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 61)

0.45 ms

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:

[
  "9_inwestycja-testowa"
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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 = '9_inwestycja-testowa' AND t0.czlonek_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\InwestycjeController->view (line 92)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 61)

0.65 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, 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:

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 AND i0_.id <> 9 LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\InwestycjeController->view (line 109)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 61)

0.65 ms

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:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 9 ORDER BY g2_.kolejnosc ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Controller\InwestycjeController->view (line 125)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 61)

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\Inwestycje	6
App\Entity\Image	5
App\Entity\CzlonekIzby	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.

Symfony Profiler

GET https://www.izbatbs.stbsns.pl/inwestycje/1_sadeckie-towarzystwo-budownictwa-spolecznego/9_inwestycja-testowa.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping