GET https://www.apartmany-hodnov.cz/apartmany/apartman-3

Query Metrics

42 Database Queries
8 Different statements
15.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 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.56 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-3"
]
3 0.56 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.38 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.36 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 0.43 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.37 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.33 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.31 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.38 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.36 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.39 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.37 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.31 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.37 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:
[
  3
]
16 0.31 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:
[
  48
]
17 0.40 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.48 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:
[
  71
]
19 0.35 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.34 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:
[
  72
]
21 0.38 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.35 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:
[
  73
]
23 0.37 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"
  "image3"
  550
  410
  1
]
24 0.38 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:
[
  74
]
25 0.39 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
]
26 0.41 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:
[]
27 0.34 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"
]
28 0.34 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"
]
29 0.30 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"
]
30 0.29 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"
]
31 0.31 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"
]
32 0.30 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"
]
33 0.30 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"
]
34 0.41 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"
]
35 0.31 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"
]
36 0.28 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"
]
37 0.36 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"
]
38 0.33 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"
]
39 0.33 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"
]
40 0.31 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"
]
41 0.33 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"
]
42 0.35 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.