GET https://myheal.com.ua/en/news/korist-ta-shkoda-zaminnikiv-tsukru

Query Metrics

26 Database Queries
14 Different statements
18.80 ms Query time
10 Invalid entities
44 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.27 ms
UPDATE material SET views = views + 1 WHERE id = ?
Parameters:
[
  60
]
2 1.04 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.slug AS slug_3, t0.purpose AS purpose_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.views AS views_7, t0.author AS author_8, t0.is_main AS is_main_9, t0.main_image_name AS main_image_name_10, t0.main_image_original_name AS main_image_original_name_11, t0.main_image_mime_type AS main_image_mime_type_12, t0.main_image_size AS main_image_size_13, t0.main_image_dimensions AS main_image_dimensions_14, t0.category_id AS category_id_15, t0.user_id AS user_id_16 FROM material t0 WHERE t0.id = ?
Parameters:
[
  60
]
3 0.84 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.active = ? AND c0_.material_id IN (?)
Parameters:
[
  1
  60
]
4 0.56 ms
SELECT m0_.id AS id_0, m0_.locale AS locale_1, m0_.title AS title_2, m0_.sub_title AS sub_title_3, m0_.description AS description_4, m0_.content AS content_5, m0_.seo_title AS seo_title_6, m0_.seo_description AS seo_description_7, m0_.seo_keywords AS seo_keywords_8, m0_.translatable_id AS translatable_id_9 FROM material_translations m0_ WHERE m0_.translatable_id IN (?)
Parameters:
[
  60
]
5 0.63 ms
SELECT c0_.id AS id_0, c0_.slug AS slug_1, m1_.id AS id_2, c2_.title AS title_3, c2_.locale AS locale_4 FROM category c0_ LEFT JOIN material m1_ ON (m1_.category_id = c0_.id) INNER JOIN category_translations c2_ ON (c2_.translatable_id = c0_.id) WHERE c0_.purpose = ? AND m1_.id IN (?)
Parameters:
[
  "news"
  60
]
6 0.94 ms
SELECT m0_.id AS id_0, c1_.id AS id_1, c1_.slug AS slug_2, c2_.title AS title_3, c2_.locale AS locale_4 FROM material m0_ INNER JOIN material_category m3_ ON m0_.id = m3_.material_id INNER JOIN category c1_ ON c1_.id = m3_.category_id INNER JOIN category_translations c2_ ON (c2_.translatable_id = c1_.id)
Parameters:
[]
7 0.65 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.short_description AS short_description_2, p0_.url AS url_3, p0_.image AS image_4, p0_.created_at AS created_at_5, p0_.parent_id AS parent_id_6 FROM parsed_material p0_ ORDER BY p0_.id DESC LIMIT 5
Parameters:
[]
8 0.65 ms
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 = ?
Parameters:
[
  1
  "accepted"
]
9 0.56 ms
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 = ?
Parameters:
[
  2
  "accepted"
]
10 0.41 ms
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 = ?
Parameters:
[
  6
  "accepted"
]
11 0.47 ms
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 = ?
Parameters:
[
  5
  "accepted"
]
12 0.60 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.material_id = ? AND c0_.active = ?
Parameters:
[
  60
  1
]
13 0.62 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.active AS active_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.ip AS ip_5, c0_.user_id AS user_id_6, c0_.material_id AS material_id_7 FROM comment c0_ WHERE c0_.material_id = ? AND c0_.active = ? ORDER BY c0_.id DESC LIMIT 3
Parameters:
[
  60
  1
]
14 0.86 ms
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
]
15 0.84 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:
[
  "news"
  1
]
16 0.46 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:
[
  "news"
  1
]
17 0.45 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:
[
  "news"
  1
]
18 0.67 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:
[
  "news"
  1
]
19 0.84 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:
[]
20 0.78 ms
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"
]
21 0.50 ms
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:
[
  2
  "uk"
]
22 0.47 ms
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:
[
  3
  "uk"
]
23 0.40 ms
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:
[
  87
  "uk"
]
24 0.36 ms
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:
[
  88
  "uk"
]
25 0.49 ms
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:
[
  89
  "uk"
]
26 0.43 ms
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:
[
  90
  "uk"
]

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
App\Entity\Banner\Banner 5
App\Entity\MaterialTranslations 3
App\Entity\Material 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\SeoPattern No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Material No errors.
App\Entity\Category 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\Comment No errors.
App\Entity\MaterialFiles No errors.
App\Entity\MaterialTranslations No errors.
App\Entity\CategoryTranslations No errors.
App\Entity\ParsedMaterial No errors.
App\Entity\ParseNews No errors.
App\Entity\Banner\Banner 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\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\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\MaterialFilesTranslations 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\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\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\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.