Query Metrics
14
Database Queries
8
Different statements
8.54 ms
Query time
10
Invalid entities
34
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.71 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.slug IS NULL LIMIT 1
Parameters:
[] |
| 2 | 0.88 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 = ? LIMIT 1
Parameters:
[ 7 "accepted" ] |
| 3 | 1.13 ms |
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 ] |
| 4 | 1.64 ms |
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 ] |
| 5 | 0.53 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 ] |
| 6 | 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:
[ "allNews" 1 ] |
| 7 | 0.36 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:
[] |
| 8 | 0.74 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" ] |
| 9 | 0.46 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" ] |
| 10 | 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:
[ 3 "uk" ] |
| 11 | 0.34 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" ] |
| 12 | 0.31 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" ] |
| 13 | 0.31 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" ] |
| 14 | 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 |
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 |
|
| 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 |
|
| 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 |
|
| 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\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 |
|
| 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\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 |
|
| 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. |