Query Metrics

7 Database Queries
5 Different statements
5.01 ms Query time
1 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.04 ms
(40.72%)
3
SELECT MAX(s0_.price) AS sclr_0, MIN(s0_.price) AS sclr_1 FROM service s0_ WHERE s0_.status = ? AND s0_.is_active = ? AND s0_.type = ?
Parameters:
[
  "accepted"
  1
  "medical"
]
1.18 ms
(23.57%)
1
SELECT c0_.id AS id_0, c1_.title AS title_1, c0_.slug AS slug_2 FROM category c0_ LEFT JOIN category_translations c1_ ON (c0_.id = c1_.translatable_id AND c1_.locale = ?) INNER JOIN expert_category e3_ ON c0_.id = e3_.category_id INNER JOIN expert e2_ ON e2_.id = e3_.expert_id AND (e2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) WHERE c0_.status = ? AND c0_.purpose = ? GROUP BY c0_.id ORDER BY c1_.title ASC
Parameters:
[
  "ru"
  543
  557
  559
  579
  581
  583
  584
  591
  596
  597
  598
  621
  717
  721
  745
  746
  748
  755
  758
  1
  "expert"
]
0.96 ms
(19.19%)
1
SELECT e0_.id AS id_0, e0_.status AS status_1, e0_.role AS role_2, e0_.reason AS reason_3, e0_.license_date AS license_date_4, e0_.views AS views_5, e0_.receiving_city AS receiving_city_6, e0_.receiving_location AS receiving_location_7, e0_.receiving_latitude AS receiving_latitude_8, e0_.receiving_longitude AS receiving_longitude_9, e0_.likes AS likes_10, e0_.dislikes AS dislikes_11, e0_.rating AS rating_12, e0_.ordered_services_count AS ordered_services_count_13, e0_.reviews_count AS reviews_count_14, e0_.experience AS experience_15, e0_.expert_status AS expert_status_16, e0_.communication_user_id AS communication_user_id_17, e0_.communicator_status AS communicator_status_18, e0_.communicator_response AS communicator_response_19, e0_.license_expired_notify AS license_expired_notify_20 FROM expert e0_ WHERE e0_.status = ? AND e0_.license_date > ? AND e0_.role IN (?, ?, ?)
Parameters:
[
  "accepted"
  "2026-10-11 03:14:34"
  "ROLE_EXPERT"
  "ROLE_MANAGER"
  "ROLE_CONSULTANT"
]
0.43 ms
(8.62%)
1
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3 FROM seo_pattern t0 WHERE t0.purpose = ? AND t0.status = ?
Parameters:
[
  "allExperts"
  1
]
0.40 ms
(7.90%)
1
SELECT t0.id AS id_1, t0.place AS place_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.author_id AS author_id_5 FROM tooltip t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Tooltip 20

Entities Mapping

Class Mapping errors
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Category No errors.
App\Entity\Expert No errors.
App\Entity\CategoryTranslations No errors.
App\Entity\SeoPattern No errors.
App\Entity\Service No errors.
App\Entity\Tooltip No errors.
App\Entity\User
  • The mappings App\Entity\User#expertRequestTo and App\Entity\CompanyUser#user are inconsistent with each other.
  • The mappings App\Entity\User#companyUsers and App\Entity\CompanyUser#user are inconsistent with each other.
  • The mappings App\Entity\User#experts and App\Entity\Clients#expert are inconsistent with each other.
  • The mappings App\Entity\User#clients and App\Entity\Clients#client are inconsistent with each other.
App\Entity\TooltipTranslations No errors.