Query Metrics
26
Database Queries
14
Different statements
15.40 ms
Query time
10
Invalid entities
43
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.31 ms |
UPDATE material SET views = views + 1 WHERE id = ?
Parameters:
[
623
]
|
| 2 | 0.75 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:
[
623
]
|
| 3 | 0.65 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 623 ] |
| 4 | 0.53 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:
[
623
]
|
| 5 | 0.62 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" 623 ] |
| 6 | 0.63 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.51 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.52 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.49 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.32 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.38 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.50 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:
[ 623 1 ] |
| 13 | 0.50 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:
[ 623 1 ] |
| 14 | 0.70 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.54 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.32 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.29 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.62 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.70 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.37 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.30 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.30 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.30 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.27 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.30 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 | 2 |
| 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 |
|
| 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 |
|
| App\Entity\ProtectedFile | No errors. |
| App\Entity\UserSettings | No errors. |
| App\Entity\StudySystem | No errors. |
| App\Entity\Card | No errors. |
| App\Entity\Company |
|
| App\Entity\Record | No errors. |
| App\Entity\BookService |
|
| 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 |
|
| 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\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 |
|
| 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 |
|
| 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 |
|
| 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. |