https://cz-dev.azdoucovani.cz/poptavka/15/

Query Metrics

16 Database Queries
15 Different statements
14.89 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.58 ms
SELECT t1.id AS id_2, t1.uuid AS uuid_3, t1.approve_status AS approve_status_4, t1.visibility_status AS visibility_status_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.expire_at AS expire_at_8, t1.deleted_at AS deleted_at_9, t1.ip_address AS ip_address_10, t1.view_count AS view_count_11, t1.score AS score_12, t0.description AS description_13, t0.student_count AS student_count_14, t0.lection_count AS lection_count_15, t0.preferred_gender AS preferred_gender_16, t0.demand_duration AS demand_duration_17, t1.user_id AS user_id_18, t0.subject_id AS subject_id_19, t0.level_id AS level_id_20, t1.type FROM advert_demand t0 INNER JOIN content_item t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  "15"
]
2 0.93 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:
[
  ""
]
3 0.64 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:
[
  ""
]
4 0.68 ms
"START TRANSACTION"
Parameters:
[]
5 0.87 ms
INSERT INTO `view` (user_token, type, value, created_at, ip_address, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "8eccb8e9-ff9a-40bd-8a7e-59eb3078306f"
  2 => 3
  3 => 15
  4 => "2024-05-12 13:58:44"
  5 => "3.147.103.227"
  6 => null
]
6 0.73 ms
"COMMIT"
Parameters:
[]
7 1.03 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:
[
  "advert_demand_detail"
  "cs"
]
8 0.98 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:
[]
9 0.80 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:
[]
10 1.00 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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = ?
Parameters:
[
  15
]
11 0.80 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  16
]
12 0.83 ms
SELECT t0.order_number AS order_number_1, t0.id AS id_2, t0.name AS name_3, t0.slug AS slug_4 FROM advert_level t0 WHERE t0.id = ?
Parameters:
[
  3
]
13 0.98 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:
[]
14 0.69 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:
[]
15 0.55 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
]
16 0.80 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\View 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\ContentBundle\Entity\Level No errors.
App\Tutorka\Bundle\ContentBundle\Entity\AdvertDemandUnlock No errors.
App\Tutorka\Bundle\CoreBundle\Entity\Activity No errors.
App\Tutorka\Bundle\CoreBundle\Entity\EmailLog No errors.
App\Tutorka\Bundle\CoreBundle\Entity\EmailTemplate 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\PreferredTimeAttribute No errors.
App\Tutorka\Bundle\ContentBundle\Entity\OtherAttribute No errors.
App\Tutorka\Bundle\CoreBundle\Entity\EmailTemplateComponent No errors.