GET https://hotpeppers.e-online.cz/cs/rezervace?eventCategory=3&selectedBundles=10

Query Metrics

33 Database Queries
8 Different statements
19.19 ms Query time
1 Invalid entities
38 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
7.55 ms
(39.36%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_homepage AS is_homepage_4, t0.blocks AS blocks_5, t0.redirect AS redirect_6, t0.layout AS layout_7, t0.language_group_id AS language_group_id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.is_current AS is_current_12, t0.project_id AS project_id_13, t0.language_id AS language_id_14, t0.page_excerpt_id AS page_excerpt_id_15, t0.page_seo_id AS page_seo_id_16, t0.created_by_id AS created_by_id_17, t0.page_state_id AS page_state_id_18 FROM page t0 WHERE t0.language_id = ? AND t0.language_group_id = ? LIMIT 1
Parameters:
[
  1
  "9148b3e2-07d0-dfee-9067-869c0eba8df4"
]
6.99 ms
(36.45%)
19
SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = ?
Parameters:
[
  126
]
1.41 ms
(7.33%)
2
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2 FROM language l0_ WHERE l0_.code = ?
Parameters:
[
  "cs"
]
0.96 ms
(5.02%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = ? AND t0.is_main = ? LIMIT 1
Parameters:
[
  1
  1
]
0.83 ms
(4.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 INNER JOIN language_project ON t0.id = language_project.language_id WHERE language_project.project_id = ?
Parameters:
[
  1
]
0.58 ms
(3.01%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.url AS url_3, t0.target AS target_4, t0.item_order AS item_order_5, t0.navigation_id AS navigation_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.navigation_id = ?
Parameters:
[
  1
]
0.44 ms
(2.30%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.domains AS domains_3, t0.template AS template_4 FROM project t0 LIMIT 1
Parameters:
[]
0.43 ms
(2.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.language_id AS language_id_4 FROM navigation t0 WHERE t0.language_id = ? AND t0.name = ? LIMIT 1
Parameters:
[
  1
  "footer"
]

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
Kiwi\WebBundle\Entity\NavigationItem 19
Kiwi\WebBundle\Entity\Page 4
Kiwi\WebBundle\Entity\PageExcerpt 4
Kiwi\WebBundle\Entity\PageSEO 4
Kiwi\AdminBundle\Entity\Language 3
Kiwi\AdminBundle\Entity\Project 1
Kiwi\WebBundle\Entity\Navigation 1
Kiwi\AdminBundle\Entity\KiwiUser 1
Kiwi\WebBundle\Entity\PageState 1

Entities Mapping

Class Mapping errors
Kiwi\AdminBundle\Entity\Language No errors.
Kiwi\AdminBundle\Entity\Project No errors.
Kiwi\AdminBundle\Entity\KiwiUser No errors.
Kiwi\AdminBundle\Entity\Module No errors.
Kiwi\AdminBundle\Entity\Invite No errors.
Kiwi\AdminBundle\Entity\ProjectInformation No errors.
Kiwi\WebBundle\Entity\Navigation No errors.
Kiwi\WebBundle\Entity\NavigationItem
  • The field Kiwi\WebBundle\Entity\NavigationItem#childrens is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Kiwi\WebBundle\Entity\NavigationItem#parent does not contain the required 'inversedBy="childrens"' attribute.
Kiwi\WebBundle\Entity\Page No errors.
Kiwi\WebBundle\Entity\PageExcerpt No errors.
Kiwi\WebBundle\Entity\PageSEO No errors.
Kiwi\WebBundle\Entity\PageState No errors.