Query Metrics
72
Database Queries
11
Different statements
19.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.59 ms (33.32%) |
27 |
SELECT t0.id AS id_1, t0.source AS source_2, t0.translation AS translation_3, t0.locale AS locale_4 FROM translations t0 WHERE t0.source = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "Nové Apartmány na prodej" "cs" ] |
|
3.70 ms (18.70%) |
13 |
SELECT t0.id AS id_1, t0.width AS width_2, t0.height AS height_3, t0.crop AS crop_4, t0.cropx AS cropx_5, t0.cropy AS cropy_6, t0.cropz AS cropz_7, t0.type AS type_8, t0.col AS col_9, t0.lastmod AS lastmod_10 FROM thumb t0 WHERE t0.type = ? AND t0.col = ? AND t0.width = ? AND t0.height = ? AND t0.crop = ? LIMIT 1
Parameters:
[ "slider" "image" 1920 1138 1 ] |
|
1.89 ms (9.59%) |
7 |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.folder AS folder_3, t0.is_image AS is_image_4 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
111
]
|
|
1.89 ms (9.57%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.floor AS floor_3, t0.type AS type_4, t0.area AS area_5, t0.price AS price_6, t0.state AS state_7, t0.text AS text_8, t0.lang AS lang_9, t0.slug AS slug_10, t0.apartment_id AS apartment_id_11 FROM apartment_lang t0 WHERE t0.apartment_id = ?
Parameters:
[
1
]
|
|
1.60 ms (8.11%) |
3 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.ord AS ord_3 FROM menu t0 WHERE ((t0.deleted_at IS NULL)) ORDER BY t0.ord ASC
Parameters:
[] |
|
1.33 ms (6.71%) |
5 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.text AS text_4, t0.lang AS lang_5, t0.slug AS slug_6, t0.home_id AS home_id_7 FROM home_lang t0 WHERE t0.home_id = ?
Parameters:
[
1
]
|
|
1.02 ms (5.17%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.lang AS lang_4, t0.slug AS slug_5, t0.menu_id AS menu_id_6 FROM menu_lang t0 WHERE t0.menu_id = ?
Parameters:
[
1
]
|
|
0.77 ms (3.89%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.title2 AS title2_3, t0.text AS text_4, t0.lang AS lang_5, t0.slug AS slug_6, t0.slider_id AS slider_id_7 FROM slider_lang t0 WHERE t0.slider_id = ?
Parameters:
[
1
]
|
|
0.40 ms (2.02%) |
1 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.ord AS ord_3, t0.image_id AS image_id_4 FROM slider t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
|
0.33 ms (1.69%) |
1 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.ord AS ord_3, t0.last_mod AS last_mod_4, t0.icon_id AS icon_id_5, t0.image_id AS image_id_6, t0.image2_id AS image2_id_7 FROM home t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
|
0.24 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.ord AS ord_3, t0.last_mod AS last_mod_4, t0.image_id AS image_id_5, t0.image2_id AS image2_id_6, t0.image3_id AS image3_id_7, t0.image4_id AS image4_id_8, t0.image5_id AS image5_id_9 FROM apartment t0 WHERE ((t0.deleted_at IS NULL))
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Slider | No errors. |
| App\Entity\MediaObject | No errors. |
| App\Entity\SliderLang | No errors. |
| App\Entity\Home | No errors. |
| App\Entity\HomeLang | No errors. |
| App\Entity\Apartment | No errors. |
| App\Entity\ApartmentLang | No errors. |
| App\Entity\Translations | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuLang | No errors. |
| App\Entity\Thumb | No errors. |