GET https://hotpeppers.e-online.cz/cs/client/login

Query Metrics

19 Database Queries
8 Different statements
11.63 ms Query time
1 Invalid entities
23 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.03 ms
(51.83%)
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"
]
1.51 ms
(12.99%)
4
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:
[
  21
]
1.36 ms
(11.71%)
3
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.82 ms
(7.06%)
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.65 ms
(5.59%)
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.43 ms
(3.69%)
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.42 ms
(3.62%)
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"
]
0.41 ms
(3.52%)
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:
[]

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 4
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.