Query Metrics

14 Database Queries
8 Different statements
8.94 ms Query time
10 Invalid entities
34 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.07 ms
(34.39%)
7
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_keywords AS seo_keywords_8, t0.translatable_id AS translatable_id_9 FROM category_translations t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  1
  "uk"
]
1.70 ms
(19.00%)
1
SELECT COUNT(DISTINCT (m0_.id)) AS sclr_0 FROM material m0_ WHERE m0_.purpose = ? AND m0_.status = ? ORDER BY m0_.id DESC
Parameters:
[
  "company"
  1
]
1.48 ms
(16.53%)
1
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.slug AS slug_2, m0_.purpose AS purpose_3, m0_.updated_at AS updated_at_4, m0_.status AS status_5, m0_.views AS views_6, m0_.author AS author_7, m0_.is_main AS is_main_8, m0_.main_image_name AS main_image_name_9, m0_.main_image_original_name AS main_image_original_name_10, m0_.main_image_mime_type AS main_image_mime_type_11, m0_.main_image_size AS main_image_size_12, m0_.main_image_dimensions AS main_image_dimensions_13, m0_.category_id AS category_id_14, m0_.user_id AS user_id_15 FROM material m0_ WHERE m0_.purpose = ? AND m0_.status = ? ORDER BY m0_.id DESC LIMIT 3
Parameters:
[
  "company"
  1
]
0.69 ms
(7.77%)
1
SELECT b0_.id AS id_0, b0_.place AS place_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.url AS url_4, b0_.target_is_blank AS target_is_blank_5, b0_.status AS status_6, b0_.custom_attributes AS custom_attributes_7, b0_.rule_to_show AS rule_to_show_8, b0_.action AS action_9, b0_.main_image_name AS main_image_name_10, b0_.main_image_original_name AS main_image_original_name_11, b0_.main_image_mime_type AS main_image_mime_type_12, b0_.main_image_size AS main_image_size_13, b0_.main_image_dimensions AS main_image_dimensions_14, b0_.author_id AS author_id_15 FROM banner b0_ WHERE b0_.place = ? AND b0_.status = ? LIMIT 1
Parameters:
[
  7
  "accepted"
]
0.65 ms
(7.32%)
1
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.image_mime_type AS image_mime_type_8, t0.image_size AS image_size_9, t0.image_dimensions AS image_dimensions_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
0.51 ms
(5.66%)
1
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.status AS status_3, t0.slug AS slug_4, t0.updated_at AS updated_at_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.image_mime_type AS image_mime_type_8, t0.image_size AS image_size_9, t0.image_dimensions AS image_dimensions_10, t0.parent_id AS parent_id_11 FROM category t0 WHERE t0.purpose = ? AND t0.status = ?
Parameters:
[
  "news"
  1
]
0.43 ms
(4.80%)
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:
[
  "allNews"
  1
]
0.41 ms
(4.53%)
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
App\Entity\Category 7
App\Entity\CategoryTranslations 7

Entities Mapping

Class Mapping errors
App\Entity\SeoPattern No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Category No errors.
App\Entity\Banner\Banner 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\Material No errors.
App\Entity\Measure No errors.
App\Entity\Screaning No errors.
App\Entity\Service No errors.
App\Entity\Expert No errors.
App\Entity\DictionarySearch No errors.
App\Entity\DictionarySearchForPage No errors.
App\Entity\FAQ No errors.
App\Entity\CategoryTranslations No errors.
App\Entity\Tooltip No errors.
App\Entity\TooltipTranslations No errors.
App\Entity\SeoPatternTranslations No errors.
App\Entity\Schedule
  • The mappings App\Entity\Schedule#company and App\Entity\Company#schedules are inconsistent with each other.
App\Entity\ProtectedFile No errors.
App\Entity\UserSettings No errors.
App\Entity\StudySystem No errors.
App\Entity\Card No errors.
App\Entity\Comment 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\Record 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\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\Complaints 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\CompanyService 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\MaterialFiles No errors.
App\Entity\MaterialTranslations No errors.
App\Entity\MeasureUnit No errors.
App\Entity\MeasureValue No errors.
App\Entity\MeasureParseProposition No errors.
App\Entity\MeasureTranslations No errors.
App\Entity\Age No errors.
App\Entity\UserScreaning No errors.
App\Entity\Warning No errors.
App\Entity\ScreaningTranslations No errors.
App\Entity\Phones No errors.
App\Entity\FAQTranslations 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\ArchiveHistory No errors.
App\Entity\ExpertReviews No errors.
App\Entity\CompanyGallery 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\Analyse No errors.
App\Entity\ComplaintFiles 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\MaterialFilesTranslations No errors.
App\Entity\MeasureUnitTranslations No errors.
App\Entity\AgeTranslations No errors.
App\Entity\WarningTranslations 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\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\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\HomePageActions 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\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\EhealthEquipment No errors.
App\Entity\EhealthDocumentsPerson No errors.
App\Entity\EmailMailingTemplate No errors.
App\Entity\EhealthComposition No errors.