Query Metrics

9 Database Queries
8 Different statements
2.98 ms Query time
0 Invalid entities
19 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.75 ms
(25.02%)
2
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.slug AS slug_3, p0_.type AS type_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.seo_meta_title AS seo_meta_title_7, p0_.seo_meta_description AS seo_meta_description_8, p0_.language_id AS language_id_9 FROM page p0_ LEFT JOIN language l1_ ON p0_.language_id = l1_.id WHERE p0_.type = ? AND l1_.shortcut = ? LIMIT 1
Parameters:
[
  "privacy_policy"
  "cs"
]
0.63 ms
(20.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortcut AS shortcut_3 FROM language t0 WHERE t0.shortcut = ? LIMIT 1
Parameters:
[
  "cs"
]
0.36 ms
(11.94%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.link AS link_2, n0_.link_type AS link_type_3, n0_.position AS position_4, n0_.section AS section_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.page_id AS page_id_8, n0_.language_id AS language_id_9 FROM navigation n0_ LEFT JOIN language l1_ ON n0_.language_id = l1_.id WHERE (n0_.section = ? OR n0_.section = ?) AND l1_.shortcut = ? ORDER BY n0_.id ASC
Parameters:
[
  "top"
  "both"
  "cs"
]
0.34 ms
(11.40%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.linked_in_url AS linked_in_url_3, t0.position AS position_4 FROM doctor t0 ORDER BY t0.position ASC
Parameters:
[]
0.27 ms
(9.05%)
1
SELECT b0_.id AS id_0, b0_.posted_at AS posted_at_1, b0_.featured_image AS featured_image_2, b1_.id AS id_3, b1_.title AS title_4, b1_.content AS content_5, b1_.slug AS slug_6, b1_.locale AS locale_7, b1_.translatable_id AS translatable_id_8 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ? ORDER BY b0_.posted_at DESC LIMIT 4
Parameters:
[
  "cs"
]
0.24 ms
(8.04%)
1
SELECT t0.id AS id_1, t0.position AS position_2 FROM frequently_asked_question t0 ORDER BY t0.position ASC
Parameters:
[]
0.21 ms
(7.15%)
1
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.position AS position_3, t0.content AS content_4, t0.image AS image_5 FROM reference t0 ORDER BY t0.id DESC
Parameters:
[]
0.19 ms
(6.44%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.image AS image_4, t0.logo AS logo_5, t0.date AS date_6, t0.url AS url_7 FROM article t0 ORDER BY t0.id DESC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
umanit_seo doctrine.orm.umanit_seo_entity_manager
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

umanit_seo entity manager

Class Amount of managed objects

default entity manager

Class Amount of managed objects
App\Entity\Doctor 5
App\Entity\FrequentlyAskedQuestion 4
App\Entity\Navigation 4
App\Entity\Reference 3
App\Entity\Language 1
App\Entity\Page 1
App\Entity\Article 1

Entities Mapping

umanit_seo entity manager

No loaded entities.

default entity manager

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Doctor No errors.
App\Entity\DoctorTranslation No errors.
App\Entity\FrequentlyAskedQuestion No errors.
App\Entity\FrequentlyAskedQuestionTranslation No errors.
Umanit\SeoBundle\Entity\SeoMetadata No errors.
App\Entity\Page No errors.
App\Entity\Navigation No errors.
App\Entity\Reference No errors.
App\Entity\Article No errors.
App\Entity\Blog No errors.
App\Entity\BlogTranslation No errors.