Symfony Profiler

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 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 = 1 AND p0_.bazyl IS NULL AND p0_.rm_id IS NOT NULL AND p0_.hide_in_search = 0 AND p0_.substancje_czynne LIKE '%Levofloxacinum%' AND p0_.slug <> 'levoxa' GROUP BY p0_.slug ORDER BY p0_.popularity DESC, p0_.name ASC LIMIT 4;

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 = 'levoxa' OR p0_.slug = 'levoxa' OR p0_.slug = 'levoxa' OR p0_.slug = 'levoxa') 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 = 'levoxa';

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
  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 (138532, 138533, 138534, 138535, 138536, 138537, 138538, 138539, 138540, 138541, 138542, 138543, 138544, 138545, 138546, 138547, 138548, 138549, 162693, 162694, 162695, 162696, 269565, 269566, 269567, 269568, 269569, 269570, 269571, 269572, 269573, 269574, 269575, 269576, 269577, 269578, 269579, 269580, 269581, 269582, 275124, 275125, 275126, 275127, 449543, 449544, 449545, 449546, 449547, 449548, 449549, 449550, 449551, 449552, 449553, 449554, 449555, 449556, 449557, 449558, 449559, 449560, 454951, 454952, 454953, 454954) 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 = 130;

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