https://sk-dev.azdoucovani.cz/sledovaci-pes/vytvorit/hra-na-gitaru/zoradenie/najstarsie

Query Metrics

12 Database Queries
11 Different statements
10.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.18 ms
(21.40%)
1
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:
[
  "hra-na-gitaru"
]
1.05 ms
(10.29%)
2
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:
[]
1.01 ms
(9.88%)
1
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:
[]
1.00 ms
(9.82%)
1
SELECT a0_.order_number AS order_number_0, a0_.id AS id_1, a0_.name AS name_2, a0_.slug AS slug_3 FROM advert_level a0_ ORDER BY a0_.order_number DESC
Parameters:
[]
0.83 ms
(8.18%)
1
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:
[
  "hra-na-gitaru"
]
0.79 ms
(7.77%)
1
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:
[
  "advert_watch_dog_create"
  "sk"
]
0.79 ms
(7.75%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_preferred_time_attribute a0_ ORDER BY a0_.id DESC
Parameters:
[]
0.74 ms
(7.31%)
1
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:
[]
0.73 ms
(7.17%)
1
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:
[]
0.64 ms
(6.30%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_place_attribute a0_ ORDER BY a0_.id DESC
Parameters:
[]
0.42 ms
(4.13%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_other_attribute a0_ ORDER BY a0_.id DESC
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\ContentBundle\Entity\ContentItem No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertOffer No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertWatchDog No errors.
App\Tutorka\Bundle\ContentBundle\Entity\Level No errors.
App\Tutorka\Bundle\ContentBundle\Entity\PreferredTimeAttribute No errors.
App\Tutorka\Bundle\ContentBundle\Entity\OtherAttribute 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\ContentBundle\Entity\AdvertDemandUnlock No errors.