Symfony Profiler

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 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 = '3';

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 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 = 1 AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = 0 AND (p0_.slug = 'triquilar' OR p0_.slug = 'triquilar' OR p0_.slug = 'triquilar' OR p0_.slug = 'triquilar') 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.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 = 'triquilar';

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 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 (9277, 9284, 9285, 15924, 134473, 144770, 146168, 146169, 157916, 157976, 184323, 185919, 187702, 188499, 192057, 192826, 193171, 193172, 194730, 201463, 204235, 219305, 219306, 220208, 220209, 228855, 228856, 255254, 255255, 261264, 261265, 279571, 279572, 282507, 282508, 438109, 438110, 438998, 438999, 459248, 459249, 462028, 462029, 489761, 489762, 495976, 495977) AND t0.accepted = 1;

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.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 = 148;

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 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 = 148;

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_.parent_id AS parent_id_11
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_.parent_id AS parent_id_11 FROM service s0_ WHERE s0_.type = 'prescription' AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (3));

SELECT
  i0_.text AS text_0,
  i0_.url AS url_1
FROM
  internal_linking i0_

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 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_.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 = 'pl') 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_.parent_id AS parent_id_11
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_.parent_id AS parent_id_11 FROM service s0_ WHERE s0_.type = 'prescription' AND EXISTS (SELECT 1 FROM site_service s1_ WHERE s1_.service_id = s0_.id AND s1_.site_id IN (3));

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_.parent_id AS parent_id_11
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 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_.parent_id AS parent_id_11 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 = 3 AND s0_.type = 'prescription' 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 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 = 1 OR p0_.service_id IS NULL) AND (p0_.site_id = 3 OR p0_.site_id IS NULL) AND p0_.date = '2025-01-08' 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_.parent_id AS parent_id_11
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 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_.parent_id AS parent_id_11 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 = 3 AND s0_.type = 'consultation' 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 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 = 3 OR p0_.service_id IS NULL) AND (p0_.site_id = 3 OR p0_.site_id IS NULL) AND p0_.date = '2025-01-08' ORDER BY p0_.updated_at DESC LIMIT 1;