GET https://dev.e-recepta.net/kontakt

Query Metrics

19 Database Queries
6 Different statements
4.97 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.email AS email_4, t0.email_title AS email_title_5, t0.email_title_sick_leave AS email_title_sick_leave_6, t0.logo_url AS logo_url_7, t0.faq_url AS faq_url_8, t0.contact_url AS contact_url_9, t0.rule_url AS rule_url_10, t0.privacy_policy_url AS privacy_policy_url_11, t0.sms_sender AS sms_sender_12, t0.sms_content AS sms_content_13, t0.url AS url_14, t0.has_refund AS has_refund_15, t0.slug AS slug_16, t0.iframe_head_text AS iframe_head_text_17, t0.iframe_top_text AS iframe_top_text_18, t0.hash AS hash_19, t0.virtual_ AS virtual__20, t0.redirect AS redirect_21, t0.default_api_state AS default_api_state_22, t0.show_top_bar AS show_top_bar_23, t0.top_bar_message AS top_bar_message_24, t0.top_bar_bg_color AS top_bar_bg_color_25, t0.top_bar_text_color AS top_bar_text_color_26, t0.api AS api_27, t0.logo_id AS logo_id_28 FROM site t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
2 0.55 ms
SELECT i0_.text AS text_0, i0_.url AS url_1 FROM internal_linking i0_
Parameters:
[]
3 0.27 ms
SELECT p0_.slug AS slug_0, p1_.name AS name_1 FROM product_text p0_ LEFT JOIN product p1_ ON p0_.id = p1_.text_id GROUP BY p0_.id
Parameters:
[]
4 0.18 ms
SELECT s0_.slug AS slug_0, s0_.name AS name_1 FROM specialization s1_ INNER JOIN specialization_translation s0_ ON s1_.id = s0_.translatable_id AND (s0_.locale = ?) GROUP BY s1_.id
Parameters:
[
  "pl"
]
5 0.42 ms
SELECT s0_.id AS id_0, s0_.external_id AS external_id_1, s0_.age_requirement AS age_requirement_2, s0_.at_id AS at_id_3, s0_.default_ AS default__4, s0_.show_on_page AS show_on_page_5, s0_.price AS price_6 FROM specialization s0_ INNER JOIN specialization_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.show_on_page = ? ORDER BY s0_.default_ DESC, s1_.name ASC
Parameters:
[
  "pl"
  1
]
6 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
7 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
8 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
9 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
10 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  16
]
11 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
12 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]
13 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  14
]
14 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
15 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  22
]
16 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
17 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  21
]
18 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  15
]
19 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM specialization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  18
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Site No errors.
App\Entity\File No errors.
App\Entity\Service No errors.
App\Entity\PriceRate No errors.
App\Entity\Discount No errors.
App\Entity\Chat No errors.
App\Entity\Opinion No errors.
App\Entity\Embeddable\RegLegal No errors.
App\Entity\User No errors.
App\Entity\Order No errors.
App\Entity\BaseMedicalHistory No errors.
App\Entity\Embeddable\InvoiceAddress No errors.
App\Entity\MedicalHistory No errors.
App\Entity\OrderMessage No errors.
App\Entity\Patient No errors.
App\Entity\Doctor No errors.
App\Entity\Email No errors.
App\Entity\ChatMessage No errors.
App\Entity\FormEntry No errors.
App\Entity\Institution No errors.
App\Entity\DoctorService No errors.
App\Entity\Faq No errors.
App\Entity\Reflink No errors.
App\Entity\OrderMessageTemplate No errors.
App\Entity\UserGroup No errors.
App\Entity\UserSetting No errors.
App\Entity\ContentTemplate No errors.
App\Entity\Prescription No errors.
App\Entity\Note No errors.
App\Entity\BlogPostComment No errors.
App\Entity\BlogPost No errors.
App\Entity\MedicinesComment No errors.
App\Entity\UserSubscription No errors.
App\Entity\Log No errors.
App\Entity\LogEntry No errors.
App\Entity\OrderDownloadLog No errors.
App\Entity\OrderItem No errors.
App\Entity\Payment No errors.
App\Entity\Invoice
  • The field 'App\Entity\Invoice#invoiceNumber' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\OrderState No errors.
App\Entity\SickLeave No errors.
App\Entity\MedicalReferral No errors.
App\Entity\OrderReminder No errors.
App\Entity\OrderTag No errors.
App\Entity\NotificationHistory No errors.
App\Entity\AwinTransaction No errors.
App\Entity\MedicalEvent No errors.
App\Entity\EmailThread No errors.
App\Entity\Disease No errors.
App\Entity\DoctorSpecialization No errors.
App\Entity\Procedure No errors.
App\Entity\Specialization No errors.
App\Entity\Declaration No errors.
App\Entity\Pesel No errors.
App\Entity\OccupationGroup No errors.
App\Entity\DoctorWorkingHour No errors.
App\Entity\EmailAccount No errors.
App\Entity\InstitutionWorkingHour No errors.
App\Entity\Cell No errors.
App\Entity\SubPackageInstitutionPrice No errors.
App\Entity\ProductText No errors.
App\Entity\Affliction No errors.
App\Entity\Translation\FaqTranslation No errors.
App\Entity\ReflinkData No errors.
App\Entity\BlogCategory No errors.
App\Entity\BlogTag No errors.
App\Entity\BlogCustomLink No errors.
App\Entity\Product No errors.
App\Entity\NewsletterPatient No errors.
App\Entity\ProductSearchLog No errors.
App\Entity\Newsletter No errors.
App\Entity\UserPackage No errors.
App\Entity\InternalLinking No errors.
App\Entity\Form No errors.
App\Entity\Setting No errors.
App\Entity\Translation\SettingTranslation No errors.
App\Entity\TextPart No errors.
App\Entity\Translation\TextPartTranslation No errors.
App\Entity\SearchCondition No errors.
App\Entity\Translation\SearchConditionTranslation No errors.
App\Entity\Translation\AfflictionTranslation No errors.
App\Entity\Translation\ProductTextTranslation No errors.
App\Entity\Translation\SpecializationTranslation No errors.
App\Entity\PackageTextPart No errors.
App\Entity\ChatHour No errors.
App\Entity\Task No errors.
App\Entity\PostalCode No errors.
App\Entity\Package No errors.
App\Entity\DoctorSpecializationReminder No errors.
App\Entity\SubPackage No errors.
App\Entity\ActiveSubstanceWarning No errors.
App\Entity\NotificationTemplate No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\LabExaminationGroup No errors.
App\Entity\FormField No errors.
App\Entity\Banner No errors.
App\Entity\LabExaminationItem No errors.
App\Entity\LabExaminationTextPart No errors.
App\Entity\Category
  • The association App\Entity\Category#products refers to the owning side field App\Entity\Product#category which does not exist.
App\Entity\LabExamination No errors.
App\Entity\Kohort No errors.
App\Entity\PlaceSpecialization No errors.
Vich\UploaderBundle\Entity\File No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit No errors.
Lexik\Bundle\TranslationBundle\Model\File No errors.
Lexik\Bundle\TranslationBundle\Entity\File No errors.
Lexik\Bundle\TranslationBundle\Model\Translation No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation No errors.