https://cz-dev.azdoucovani.cz/ochrana-soukromi

Query Metrics

10 Database Queries
9 Different statements
6.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.slug AS slug_4, t0.route AS route_5, t0.is_public AS is_public_6, t0.content AS content_7 FROM page t0 WHERE t0.route = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "privacy_policy"
  "cs"
]
2 0.64 ms
SELECT t0.id AS id_1, t0.route AS route_2, t0.name AS name_3, t0.name_value AS name_value_4, t0.content_value AS content_value_5, t0.locale AS locale_6 FROM meta_tag t0 WHERE t0.route = ? AND t0.locale = ?
Parameters:
[
  "dynamic_privacy_policy"
  "cs"
]
3 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  ""
]
4 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  ""
]
5 0.52 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.genitive_name AS genitive_name_3, s0_.icon AS icon_4, s0_.order_number AS order_number_5, s0_.count AS count_6 FROM subject s0_ ORDER BY s0_.order_number ASC, s0_.name ASC
Parameters:
[]
6 0.60 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.genitive_name AS genitive_name_3, c0_.order_number AS order_number_4, c0_.count AS count_5 FROM city c0_ ORDER BY c0_.order_number ASC, c0_.name ASC
Parameters:
[]
7 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 ORDER BY t0.count DESC LIMIT 5
Parameters:
[]
8 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 ORDER BY t0.count DESC LIMIT 5
Parameters:
[]
9 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM advert_place_attribute t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 ORDER BY t0.count DESC LIMIT 5
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\Tutorka\Bundle\CoreBundle\Entity\MetaTag No errors.
App\Tutorka\Bundle\UserBundle\Entity\User No errors.
App\Tutorka\Bundle\UserBundle\Entity\Verification No errors.
App\Tutorka\Bundle\CoreBundle\Entity\Setting No errors.
App\Tutorka\Bundle\ContentBundle\Entity\Subject No errors.
App\Tutorka\Bundle\ContentBundle\Entity\City No errors.
App\Tutorka\Bundle\ContentBundle\Entity\PlaceAttribute No errors.
App\Tutorka\Bundle\CoreBundle\Entity\QuestionSection No errors.
App\Tutorka\Bundle\CoreBundle\Entity\Page No errors.
App\Tutorka\Bundle\ContentBundle\Entity\ContentItem No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertOffer No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertDemand No errors.
App\Tutorka\Bundle\ContentBundle\Entity\SearchLog No errors.
App\Tutorka\Bundle\UserBundle\Entity\BillingAddress No errors.
App\Tutorka\Bundle\UserBundle\Entity\AboutMe No errors.
App\Tutorka\Bundle\UserBundle\Entity\UserSubscription No errors.
App\Tutorka\Bundle\CoreBundle\Entity\Question No errors.
App\Tutorka\Bundle\ContentBundle\Entity\PreferredTimeAttribute No errors.
App\Tutorka\Bundle\ContentBundle\Entity\OtherAttribute No errors.
App\Tutorka\Bundle\ContentBundle\Entity\Level No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertDemandUnlock No errors.