Query Metrics
5
Database Queries
5
Different statements
4.50 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.28 ms (28.50%) |
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_.aktualnosci_id AS aktualnosci_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_aktualnosci 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_.aktualnosci_id = ? ORDER BY g2_.kolejnosc ASC
Parameters:
[
3
]
|
||||||||||||||||||||||||||
|
0.95 ms (21.03%) |
1 |
SELECT t0.id AS id_1, t0.tytul AS tytul_2, t0.slug AS slug_3, t0.naglowek AS naglowek_4, t0.tresc AS tresc_5, t0.http_header AS http_header_6, t0.tagi AS tagi_7, t0.data_utworzenia AS data_utworzenia_8, t0.data_publikacji AS data_publikacji_9, t0.wazny_do AS wazny_do_10, t0.widoczna AS widoczna_11, t0.kategoria_id AS kategoria_id_12, t0.czlonek_id AS czlonek_id_13, t0.user_id AS user_id_14, t0.image_id AS image_id_15 FROM aktualnosci t0 WHERE t0.slug = ? AND t0.kategoria_id = ? LIMIT 1
Parameters:
[ "3_kuznia-raciborska-nabor-trwa" 1 ]
|
||||||||||||||||||||||||||
|
0.84 ms (18.63%) |
1 |
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_ WHERE a0_.kategoria_id = ? AND a0_.widoczna = ? ORDER BY a0_.data_publikacji DESC LIMIT 15
Parameters:
[ 1 3 ]
|
||||||||||||||||||||||||||
|
0.72 ms (15.96%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"aktualnosci"
]
|
||||||||||||||||||||||||||
|
0.72 ms (15.89%) |
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:
[
43
]
|
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\Aktualnosc | 2 |
| App\Entity\Image | 2 |
| App\Entity\Category | 1 |
| App\Entity\CategoryType | 1 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\CategoryType | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Aktualnosc | No errors. |
| App\Entity\CzlonekIzby | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\GaleriaAktualnosci | No errors. |
| App\Entity\Galerie | No errors. |
| App\Entity\GaleriaImage | No errors. |