Query Metrics

9 Database Queries
9 Different statements
9.24 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:
[]

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.