Query Metrics
7
Database Queries
5
Different statements
6.36 ms
Query time
10
Invalid entities
20
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.94 ms |
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 04:30:36" "ROLE_EXPERT" "ROLE_MANAGER" "ROLE_CONSULTANT" ] |
| 2 | 1.79 ms |
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" ] |
| 3 | 1.28 ms |
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" ] |
| 4 | 0.57 ms |
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" ] |
| 5 | 0.82 ms |
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" ] |
| 6 | 0.53 ms |
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 ] |
| 7 | 0.43 ms |
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. |
| App\Entity\Measure | No errors. |
| App\Entity\Material | No errors. |
| App\Entity\Screaning | No errors. |
| App\Entity\DictionarySearch | No errors. |
| App\Entity\DictionarySearchForPage | No errors. |
| App\Entity\FAQ | No errors. |
| App\Entity\Company |
|
| App\Entity\ProtectedFile | No errors. |
| App\Entity\Phones | No errors. |
| App\Entity\SeoPatternTranslations | No errors. |
| App\Entity\BookService |
|
| App\Entity\Complaints | No errors. |
| App\Entity\CompanyService | No errors. |
| App\Entity\Schedule |
|
| App\Entity\UserSettings | No errors. |
| App\Entity\StudySystem | No errors. |
| App\Entity\Card | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Record | No errors. |
| App\Entity\ArchivePermission | No errors. |
| App\Entity\ScheduleVacation | No errors. |
| App\Entity\Broadcast | No errors. |
| App\Entity\SendToAnalyses | No errors. |
| App\Entity\MedInfo | No errors. |
| App\Entity\CompanyUser |
|
| App\Entity\Concilium | No errors. |
| App\Entity\UserTelegram | No errors. |
| App\Entity\RefreshToken | No errors. |
| App\Entity\Wallet | No errors. |
| App\Entity\ConciliumUserRequest | No errors. |
| App\Entity\UserStoreKey | No errors. |
| App\Entity\UserDeviceToken | No errors. |
| App\Entity\Room | No errors. |
| App\Entity\Message |
|
| App\Entity\UserRoom | No errors. |
| App\Entity\ProgressBarStep | No errors. |
| App\Entity\UserSocial | No errors. |
| App\Entity\EhealthJob | No errors. |
| App\Entity\EhealthPayloadStored | No errors. |
| App\Entity\Clients |
|
| App\Entity\LocalArchiveSession | No errors. |
| App\Entity\EhalthEmployeeAssignRequest | No errors. |
| App\Entity\MessageTemplate | No errors. |
| App\Entity\ChatMailing | No errors. |
| App\Entity\ChangeRequest | No errors. |
| App\Entity\ClientTag | No errors. |
| App\Entity\Reference | No errors. |
| App\Entity\Whereby\WherebyMeeting | No errors. |
| App\Entity\UserEHealthEmployee | No errors. |
| App\Entity\UserEhealthPerson | No errors. |
| App\Entity\UserTranslations | No errors. |
| App\Entity\Contract |
|
| App\Entity\LandingUserRequest | No errors. |
| App\Entity\LegalEntity | No errors. |
| App\Entity\MailingTask | No errors. |
| App\Entity\UserScreaning | No errors. |
| App\Entity\Banner\HomePageActions | No errors. |
| App\Entity\MeasureTranslations | No errors. |
| App\Entity\MeasureUnit | No errors. |
| App\Entity\MeasureValue | No errors. |
| App\Entity\MeasureParseProposition | No errors. |
| App\Entity\MaterialTranslations | No errors. |
| App\Entity\MaterialFiles | No errors. |
| App\Entity\ScreaningTranslations | No errors. |
| App\Entity\Age | No errors. |
| App\Entity\Warning | No errors. |
| App\Entity\FAQTranslations | No errors. |
| App\Entity\ExpertReviews | No errors. |
| App\Entity\CompanyGallery | No errors. |
| App\Entity\ArchiveHistory | No errors. |
| App\Entity\FinanceTransactions |
|
| App\Entity\Meeting | No errors. |
| App\Entity\ComplaintFiles | No errors. |
| App\Entity\Analyse | No errors. |
| App\Entity\MessageHistory | No errors. |
| App\Entity\MessageTranslation | No errors. |
| App\Entity\ClientCategory | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\EhealthPerson | No errors. |
| App\Entity\EhMedicalFile | No errors. |
| App\Entity\EHelthPersonRequest | No errors. |
| App\Entity\EhEpisode | No errors. |
| App\Entity\AnalyseTranslations | No errors. |
| App\Entity\EhealthPersonAddress | No errors. |
| App\Entity\EhealthActionLog | No errors. |
| App\Entity\MaterialFilesTranslations | No errors. |
| App\Entity\EHealthDocument | No errors. |
| App\Entity\ParseNews | No errors. |
| App\Entity\EhealthConfidantPersonRelationship | No errors. |
| App\Entity\MeasureMailInterval | No errors. |
| App\Entity\MailingTaskToUser | No errors. |
| App\Entity\ConsultantRequest | No errors. |
| App\Entity\EhComposition | No errors. |
| App\Entity\LegalEntityOwner | No errors. |
| App\Entity\EhEncounter | No errors. |
| App\Entity\Draft | No errors. |
| App\Entity\ParentConfirmation | No errors. |
| App\Entity\MeasureUnitTranslations | No errors. |
| App\Entity\CertificateTemplate | No errors. |
| App\Entity\HomePage\HomePagePossibilitiesBlock | No errors. |
| App\Entity\HomePage\HomePageAboutBlock | No errors. |
| App\Entity\HomePage\HomePagePreviewBlockTranslations | No errors. |
| App\Entity\HomePage\HomePageAboutBlockTranslations | No errors. |
| App\Entity\HomePage\HomePagePreviewBlock | No errors. |
| App\Entity\HomePage\HomePagePossibilitiesBlockTranslations | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Banner\HomePageActionsTranslations | No errors. |
| App\Entity\Banner\Banner | No errors. |
| App\Entity\EhealthPersonDocument | No errors. |
| App\Entity\EhealthMedicalEvent | No errors. |
| App\Entity\LegalEntityArchive | No errors. |
| App\Entity\IssuedCertificate | No errors. |
| App\Entity\UserRegistration | No errors. |
| App\Entity\EhCondition | No errors. |
| App\Entity\MhPatientInfo | No errors. |
| App\Entity\EmailMailingTask | No errors. |
| App\Entity\EhealthDocumentsRelationship | No errors. |
| App\Entity\MailingTemplateTranslations | No errors. |
| App\Entity\EhealthPreperson | No errors. |
| App\Entity\EHealthSavedDictionary | No errors. |
| App\Entity\ConsultantConfirmation | No errors. |
| App\Entity\EhDiagnosisComment | No errors. |
| App\Entity\PinnedService | No errors. |
| App\Entity\PhoneCountryCodesTranslations | No errors. |
| App\Entity\EhealthConfidantPersonDetails | No errors. |
| App\Entity\EhObservation | No errors. |
| App\Entity\EhObservationTemplate | No errors. |
| App\Entity\EhealthConfidantPerson | No errors. |
| App\Entity\EhealthEmergencyContact | No errors. |
| App\Entity\ParsedMaterial | No errors. |
| App\Entity\Invite | No errors. |
| App\Entity\MailingTemplate | No errors. |
| App\Entity\EhealthSavedDeclaration | No errors. |
| App\Entity\EhealthPersonPhone | No errors. |
| App\Entity\ManagerConfirmation | No errors. |
| App\Entity\WarningTranslations | No errors. |
| App\Entity\InformedConsentTemplate | No errors. |
| App\Entity\EhealthPrepersonEmergencyContact | No errors. |
| App\Entity\PhoneCountryCodes |
|
| App\Entity\Feedback | No errors. |
| App\Entity\AgeTranslations | No errors. |
| App\Entity\EhealthEquipment | No errors. |
| App\Entity\EhealthDocumentsPerson | No errors. |
| App\Entity\EmailMailingTemplate | No errors. |
| App\Entity\EhealthComposition | No errors. |