Query Metrics
7
Database Queries
5
Different statements
5.01 ms
Query time
1
Invalid entities
20
Managed entities
Grouped Statements
| 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 |
|
| App\Entity\TooltipTranslations | No errors. |