Query Metrics
40
Database Queries
8
Different statements
14.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
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)) ORDER BY t0.ord ASC LIMIT 1
Parameters:
[] |
| 2 | 0.27 ms |
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.slug = ? LIMIT 1
Parameters:
[
"apartman-1"
]
|
| 3 | 0.25 ms |
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:
[ ""Nabízíme kvalitní apartmány a byty v malebné obci Hodňov, nedaleko Šumavy, poblíž Horní Plané a Lipna. Naše prodejní nabídka zahrnuje 2+KK, 2+1 a 3+1 byty o rozloze 54 až 86 m²." "cs" ] |
| 4 | 0.19 ms |
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:
[ "apartmány na prodej, byty na prodej, nemovitosti Hodňov, byty Šumava, prodej apartmánů Horní Planá, realitní nabídka Lipno, moderní byty, parkovací místo, komfortní bydlení, Šumavské apartmány" "cs" ] |
| 5 | 0.21 ms |
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:
[] |
| 6 | 3.59 ms |
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
]
|
| 7 | 0.20 ms |
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:
[
4
]
|
| 8 | 0.17 ms |
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:
[
2
]
|
| 9 | 0.16 ms |
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:
[
3
]
|
| 10 | 0.21 ms |
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:
[] |
| 11 | 0.19 ms |
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
]
|
| 12 | 0.19 ms |
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:
[ "Cena" "cs" ] |
| 13 | 0.17 ms |
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:
[ "Plocha" "cs" ] |
| 14 | 0.19 ms |
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:
[ "Stav" "cs" ] |
| 15 | 0.19 ms |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
| 16 | 0.18 ms |
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:
[
46
]
|
| 17 | 0.24 ms |
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:
[ "apartment" "image5" 550 410 0 ] |
| 18 | 0.21 ms |
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:
[
69
]
|
| 19 | 0.19 ms |
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:
[ "apartment" "image" 550 410 1 ] |
| 20 | 0.21 ms |
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:
[
70
]
|
| 21 | 0.19 ms |
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:
[ "apartment" "image2" 550 410 1 ] |
| 22 | 0.23 ms |
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:
[
64
]
|
| 23 | 0.19 ms |
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:
[ "apartment" "image4" 550 410 1 ] |
| 24 | 0.19 ms |
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:
[] |
| 25 | 0.18 ms |
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:
[ "Používáme cookies !" "cs" ] |
| 26 | 0.21 ms |
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:
[ "Soubory cookie používáme k analýze údajů o našich návštěvnících, ke zlepšení našich webových stránek, zobrazení personalizovaného obsahu a k tomu, abychom vám poskytli skvělý zážitek z webu." "cs" ] |
| 27 | 0.17 ms |
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:
[ "Vyberu si" "cs" ] |
| 28 | 3.48 ms |
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:
[ "Přijmout vše" "cs" ] |
| 29 | 0.19 ms |
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:
[ "Odmítnout vše" "cs" ] |
| 30 | 0.18 ms |
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:
[ "Nastavení cookies" "cs" ] |
| 31 | 0.16 ms |
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:
[ "Uložit nastavení" "cs" ] |
| 32 | 0.16 ms |
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:
[ "Přijmout vše" "cs" ] |
| 33 | 0.17 ms |
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:
[ "Odmítnout vše" "cs" ] |
| 34 | 0.15 ms |
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:
[ "Zavřít" "cs" ] |
| 35 | 0.16 ms |
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:
[ "Používání cookies" "cs" ] |
| 36 | 0.18 ms |
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:
[ "Soubory cookie používáme k analýze údajů o našich návštěvnících, ke zlepšení našich webových stránek a k tomu, abychom vám poskytli skvělý zážitek z webu." "cs" ] |
| 37 | 0.16 ms |
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:
[ "Funkční cookies" "cs" ] |
| 38 | 0.18 ms |
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:
[ "Tyto soubory cookie jsou nezbytné pro fungování webových stránek, není tedy možné je zakázat. Obvykle se nastavují v reakci na akci, kterou na webu sami provedete, jako je nastavení zabezpečení, přihlášení a vyplňování formulářů." "cs" ] |
| 39 | 0.16 ms |
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:
[ "Analytické cookies" "cs" ] |
| 40 | 0.18 ms |
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:
[ "Tyto soubory cookie se používají ke zlepšení fungování webových stránek. Umožňují nám rozpoznat a sledovat počet návštěvníků a sledovat, jak návštěvníci web používají. Pomáhají nám zlepšovat způsob, jakým webové stránky fungují." "cs" ] |
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\ApartmentLang | No errors. |
| App\Entity\Apartment | No errors. |
| App\Entity\Translations | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuLang | No errors. |
| App\Entity\Thumb | No errors. |