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

Query Metrics

61 Database Queries
8 Different statements
15.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.56 ms
(43.23%)
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:
[
  "Apartmány"
  "cs"
]
2.19 ms
(14.41%)
9
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.94 ms
(12.76%)
8
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"
  300
  330
  1
]
1.79 ms
(11.80%)
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.16 ms
(7.63%)
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.74 ms
(4.87%)
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:
[]
0.43 ms
(2.83%)
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)) ORDER BY t0.ord ASC LIMIT 1
Parameters:
[]
0.38 ms
(2.47%)
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\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.