Symfony Profiler

Query Metrics

86 Database Queries

15 Different statements

162.39 ms Query time

4 Invalid entities

239 Managed entities

Queries


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 = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.bazyl AS bazyl_2, p0_.postac AS postac_3, p0_.dawka AS dawka_4, p0_.active AS active_5, p0_.psychotrop AS psychotrop_6, p0_.prescription_quantity_limit AS prescription_quantity_limit_7, p0_.slug AS slug_8, p0_.ean AS ean_9, p0_.title AS title_10, p0_.description AS description_11, p0_.excerpt AS excerpt_12, p0_.content AS content_13, p0_.substancje_czynne AS substancje_czynne_14, p0_.wielkosc AS wielkosc_15, p0_.jednostka_wielkosci AS jednostka_wielkosci_16, p0_.kod_atc AS kod_atc_17, p0_.kategoria_dostepnosci AS kategoria_dostepnosci_18, p0_.rm_id AS rm_id_19, p0_.hide_in_search AS hide_in_search_20, p0_.popularity AS popularity_21, p0_.addit_info AS addit_info_22, p0_.typ_procedury AS typ_procedury_23, p0_.meta_description AS meta_description_24, p0_.pojemnosc AS pojemnosc_25, p0_.jednostka_pojemnosci AS jednostka_pojemnosci_26, p0_.schema_drug AS schema_drug_27, p0_.only_continued_treatment AS only_continued_treatment_28, p0_.cart_warning AS cart_warning_29, p0_.nurse AS nurse_30, p0_.nurse_so AS nurse_so_31, p0_.created_at AS created_at_32, p0_.updated_at AS updated_at_33, p0_.form_id AS form_id_34, p0_.text_id AS text_id_35 FROM product p0_ WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? AND (p0_.slug = ? OR p0_.slug = ? OR p0_.slug = ? OR p0_.slug = ?) ORDER BY p0_.content DESC, p0_.description DESC, p0_.title DESC LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.bazyl AS bazyl_3, t0.postac AS postac_4, t0.dawka AS dawka_5, t0.active AS active_6, t0.psychotrop AS psychotrop_7, t0.prescription_quantity_limit AS prescription_quantity_limit_8, t0.slug AS slug_9, t0.ean AS ean_10, t0.title AS title_11, t0.description AS description_12, t0.excerpt AS excerpt_13, t0.content AS content_14, t0.substancje_czynne AS substancje_czynne_15, t0.wielkosc AS wielkosc_16, t0.jednostka_wielkosci AS jednostka_wielkosci_17, t0.kod_atc AS kod_atc_18, t0.kategoria_dostepnosci AS kategoria_dostepnosci_19, t0.rm_id AS rm_id_20, t0.hide_in_search AS hide_in_search_21, t0.popularity AS popularity_22, t0.addit_info AS addit_info_23, t0.typ_procedury AS typ_procedury_24, t0.meta_description AS meta_description_25, t0.pojemnosc AS pojemnosc_26, t0.jednostka_pojemnosci AS jednostka_pojemnosci_27, t0.schema_drug AS schema_drug_28, t0.only_continued_treatment AS only_continued_treatment_29, t0.cart_warning AS cart_warning_30, t0.nurse AS nurse_31, t0.nurse_so AS nurse_so_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.form_id AS form_id_35, t0.text_id AS text_id_36 FROM product t0 WHERE t0.slug = ?
SELECT t0.id AS id_1, t0.author AS author_2, t0.content AS content_3, t0.accepted AS accepted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8, t0.product_id AS product_id_9 FROM medicines_comment t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.accepted = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.bazyl AS bazyl_2, p0_.postac AS postac_3, p0_.dawka AS dawka_4, p0_.active AS active_5, p0_.psychotrop AS psychotrop_6, p0_.prescription_quantity_limit AS prescription_quantity_limit_7, p0_.slug AS slug_8, p0_.ean AS ean_9, p0_.title AS title_10, p0_.description AS description_11, p0_.excerpt AS excerpt_12, p0_.content AS content_13, p0_.substancje_czynne AS substancje_czynne_14, p0_.wielkosc AS wielkosc_15, p0_.jednostka_wielkosci AS jednostka_wielkosci_16, p0_.kod_atc AS kod_atc_17, p0_.kategoria_dostepnosci AS kategoria_dostepnosci_18, p0_.rm_id AS rm_id_19, p0_.hide_in_search AS hide_in_search_20, p0_.popularity AS popularity_21, p0_.addit_info AS addit_info_22, p0_.typ_procedury AS typ_procedury_23, p0_.meta_description AS meta_description_24, p0_.pojemnosc AS pojemnosc_25, p0_.jednostka_pojemnosci AS jednostka_pojemnosci_26, p0_.schema_drug AS schema_drug_27, p0_.only_continued_treatment AS only_continued_treatment_28, p0_.cart_warning AS cart_warning_29, p0_.nurse AS nurse_30, p0_.nurse_so AS nurse_so_31, p0_.created_at AS created_at_32, p0_.updated_at AS updated_at_33, CONCAT(COALESCE(p0_.name, ''), COALESCE(p0_.postac, ''), COALESCE(p0_.dawka, ''), COALESCE(p0_.wielkosc, ''), COALESCE(p0_.jednostka_wielkosci, ''), COALESCE(p0_.pojemnosc, ''), COALESCE(p0_.jednostka_pojemnosci, '')) AS sclr_34, p0_.form_id AS form_id_35, p0_.text_id AS text_id_36 FROM product p0_ WHERE p0_.active = ? AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = ? AND p0_.substancje_czynne LIKE ? AND p0_.slug <> ? GROUP BY p0_.slug ORDER BY p0_.popularity DESC, p0_.name ASC LIMIT 4
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.meta_description AS meta_description_7, t0.required_documentation AS required_documentation_8, t0.gender_requirements AS gender_requirements_9 FROM product_text t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.excerpt AS excerpt_4, t0.content AS content_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_text_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT i0_.text AS text_0, i0_.url AS url_1 FROM internal_linking i0_
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
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
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ WHERE s0_.type = ? AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (?))
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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, s0_.nfz AS nfz_7, s0_.o_at_id AS o_at_id_8 FROM specialization s0_ INNER JOIN specialization_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.show_on_page = ? AND s0_.nfz = ? AND ((s0_.external_id <> ? AND s0_.external_id IS NOT NULL) OR (s0_.o_at_id NOT IN (?, ?, ?) AND s0_.o_at_id IS NOT NULL)) ORDER BY s0_.default_ DESC, s1_.name ASC
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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.alt_name AS alt_name_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM specialization_translation t0 WHERE t0.translatable_id = ?
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1
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, s0_.nfz AS nfz_7, s0_.o_at_id AS o_at_id_8 FROM specialization s0_ INNER JOIN specialization_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) WHERE s0_.show_on_page = ? AND s0_.nfz = ? AND ((s0_.external_id <> ? AND s0_.external_id IS NOT NULL) OR (s0_.o_at_id NOT IN (?, ?, ?) AND s0_.o_at_id IS NOT NULL)) ORDER BY s0_.default_ DESC, s1_.name ASC
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.price AS price_3, s0_.description AS description_4, s0_.subtitle AS subtitle_5, s0_.account_required AS account_required_6, s0_.bullets AS bullets_7, s0_.data AS data_8, s0_.has_calendar AS has_calendar_9, s0_.has_phone AS has_phone_10, s0_.title AS title_11, s0_.active AS active_12, s0_.position AS position_13, s0_.default_package AS default_package_14, s0_.parent_id AS parent_id_15, s0_.icon_id AS icon_id_16 FROM service s0_ LEFT JOIN site_service s2_ ON s0_.id = s2_.service_id LEFT JOIN site s1_ ON s1_.id = s2_.site_id WHERE s1_.id = ? AND s0_.type = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.value AS value_2, p0_.type AS type_3, p0_.label AS label_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.service_id AS service_id_7, p0_.site_id AS site_id_8 FROM price_rate p0_ WHERE (p0_.service_id = ? OR p0_.service_id IS NULL) AND (p0_.site_id = ? OR p0_.site_id IS NULL) AND p0_.date = ? ORDER BY p0_.updated_at DESC LIMIT 1

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\Product	189
App\Entity\Translation\SpecializationTranslation	28
App\Entity\Specialization	14
App\Entity\File	3
App\Entity\Service	2
App\Entity\Site	1
App\Entity\ProductText	1
App\Entity\Translation\ProductTextTranslation	1

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\File	No errors.
App\Entity\Service	The association App\Entity\Service#banners refers to the owning side field App\Entity\Banner#service which does not exist.
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\Product	No errors.
App\Entity\Form	No errors.
App\Entity\ProductText	No errors.
App\Entity\OrderItem	No errors.
App\Entity\MedicinesComment	No errors.
App\Entity\Faq	No errors.
App\Entity\Translation\ProductTextTranslation	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	The mappings App\Entity\Institution#logo and App\Entity\File#institution are inconsistent with each other. The mappings App\Entity\Institution#photo2 and App\Entity\File#institution are inconsistent with each other.
App\Entity\LabExaminationResult	No errors.
App\Entity\Package	No errors.
App\Entity\LabExaminationGroup	No errors.
App\Entity\LabExamination	No errors.
App\Entity\DoctorService	No errors.
App\Entity\Banner	No errors.
App\Entity\Reflink	No errors.
App\Entity\SubPackage	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\UserSubscription	No errors.
App\Entity\Log	No errors.
App\Entity\LogEntry	No errors.
App\Entity\OrderDownloadLog	No errors.
App\Entity\NotificationHistory	No errors.
App\Entity\FormField	No errors.
App\Entity\Specialization	No errors.
App\Entity\Affliction	No errors.
App\Entity\Translation\FaqTranslation	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\AwinTransaction	No errors.
App\Entity\MedicalEvent	No errors.
App\Entity\EmailThread	No errors.
App\Entity\DoctorSpecialization	No errors.
App\Entity\UserPackage	No errors.
App\Entity\Disease	No errors.
App\Entity\Procedure	No errors.
App\Entity\Declaration	No errors.
App\Entity\Pesel	No errors.
App\Entity\OccupationGroup	No errors.
App\Entity\DoctorWorkingHour	No errors.
App\Entity\DoctorSlots	No errors.
App\Entity\EmailAccount	No errors.
App\Entity\InstitutionWorkingHour	No errors.
App\Entity\Cell	No errors.
App\Entity\SubPackageInstitutionPrice	No errors.
App\Entity\LabExaminationGroupPrice	No errors.
App\Entity\LabExaminationEvent	No errors.
App\Entity\PackageTextPart	No errors.
App\Entity\LabExaminationItem	No errors.
App\Entity\LabExaminationTextPart	No errors.
App\Entity\LabExaminationCategory	No errors.
App\Entity\ReflinkData	No errors.
App\Entity\SubPackageService	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\BlogTag	No errors.
App\Entity\BlogCustomLink	No errors.
App\Entity\Translation\SpecializationTranslation	No errors.
App\Entity\Translation\AfflictionTranslation	No errors.
App\Entity\NewsletterPatient	No errors.
App\Entity\ProductSearchLog	No errors.
App\Entity\Newsletter	No errors.
App\Entity\InternalLinking	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\ChatHour	No errors.
App\Entity\Task	No errors.
App\Entity\PostalCode	No errors.
App\Entity\DoctorSpecializationReminder	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\Category	The association App\Entity\Category#products refers to the owning side field App\Entity\Product#category which does not exist.
App\Entity\PatientService	No errors.
App\Entity\Kohort	No errors.
App\Entity\PlaceSpecialization	No errors.
App\Entity\NewsletterStats	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.

Symfony Profiler

GET https://dev.e-recepta.net/leki/zinnat

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping