Query Metrics
5
Database Queries
5
Different statements
3.89 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.37 ms (35.31%) |
1 |
SELECT m0_.pietro AS pietro_0, COUNT(w1_.id) AS sclr_1 FROM wnioski w1_ INNER JOIN mieszkania m0_ ON w1_.mieszkanie_id = m0_.id GROUP BY m0_.pietro ORDER BY sclr_1 DESC
Parameters:
[] |
|
1.32 ms (33.92%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.tytul AS tytul_4, t0.lead AS lead_5, t0.page_body AS page_body_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM static_pages t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"/"
]
|
|
0.67 ms (17.24%) |
1 |
SELECT b0_.segment AS segment_0, COUNT(w1_.id) AS sclr_1 FROM wnioski w1_ INNER JOIN mieszkania m2_ ON w1_.mieszkanie_id = m2_.id INNER JOIN bloki b0_ ON m2_.segment_id = b0_.id GROUP BY b0_.segment ORDER BY sclr_1 DESC
Parameters:
[] |
|
0.30 ms (7.60%) |
1 |
SELECT m0_.liczba_pokoi AS liczba_pokoi_0, COUNT(w1_.id) AS sclr_1 FROM wnioski w1_ INNER JOIN mieszkania m0_ ON w1_.mieszkanie_id = m0_.id GROUP BY m0_.liczba_pokoi ORDER BY m0_.liczba_pokoi ASC
Parameters:
[] |
|
0.23 ms (5.91%) |
1 |
SELECT COUNT(*) FROM wnioski t0
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\StaticPage | No errors. |
| App\Entity\Wniosek | No errors. |
| App\Entity\Mieszkanie | No errors. |
| App\Entity\Blok | No errors. |