Query Metrics

7 Database Queries
5 Different statements
5.01 ms Query time
10 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.
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
  • The field App\Entity\Company#user is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#company does not contain the required 'inversedBy: "user"' attribute.
  • The association App\Entity\Company#reviews refers to the owning side field App\Entity\ExpertReviews#company which does not exist.
App\Entity\ProtectedFile No errors.
App\Entity\Phones No errors.
App\Entity\SeoPatternTranslations No errors.
App\Entity\BookService
  • The field App\Entity\BookService#record is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Record#bookService does not contain the required 'mappedBy: "record"' attribute.
  • If association App\Entity\BookService#record is one-to-one, then the inversed side App\Entity\Record#bookService has to be one-to-one as well.
  • The association App\Entity\BookService#insurer refers to the inverse side field App\Entity\User#insurerBookServices which does not exist.
App\Entity\Complaints No errors.
App\Entity\CompanyService No errors.
App\Entity\Schedule
  • The mappings App\Entity\Schedule#company and App\Entity\Company#schedules are inconsistent with each other.
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
  • The association App\Entity\CompanyUser#user refers to the inverse side field App\Entity\User#companyUser which does not exist.
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
  • The field App\Entity\Message#message is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Message#message does not contain the required 'mappedBy: "message"' attribute.
  • If association App\Entity\Message#message is many-to-one, then the inversed side App\Entity\Message#message has to be one-to-many.
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
  • The association App\Entity\Clients#expert refers to the inverse side field App\Entity\User#expert which does not exist.
  • The association App\Entity\Clients#client refers to the inverse side field App\Entity\User#client which does not exist.
  • The mappings App\Entity\Clients#tags and App\Entity\ClientTag#client are inconsistent with each other.
  • The field App\Entity\Clients#category is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ClientCategory#category does not contain the required 'inversedBy: "category"' attribute.
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
  • The association App\Entity\Contract#performer refers to the inverse side field App\Entity\User#performerContracts which does not exist.
  • The association App\Entity\Contract#customer refers to the inverse side field App\Entity\User#customerContracts which does not exist.
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
  • The field App\Entity\FinanceTransactions#parent is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\FinanceTransactions#parent does not contain the required 'mappedBy: "parent"' attribute.
  • If association App\Entity\FinanceTransactions#parent is many-to-one, then the inversed side App\Entity\FinanceTransactions#parent has to be one-to-many.
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
  • The association App\Entity\PhoneCountryCodes#users refers to the owning side field App\Entity\User#phoneCode which does not exist.
  • The association App\Entity\PhoneCountryCodes#phones refers to the owning side field App\Entity\Phones#countryCode which does not exist.
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.