Symfony Profiler

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'test.neofollics.com.ua' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 1;

SELECT
  m0_.enabled AS enabled_0,
  m0_.position AS position_1,
  m0_.created_at AS created_at_2,
  m0_.updated_at AS updated_at_3,
  m0_.id AS id_4,
  m1_.name AS name_5,
  m1_.slug AS slug_6,
  m1_.created_at AS created_at_7,
  m1_.updated_at AS updated_at_8,
  m1_.id AS id_9,
  m1_.locale AS locale_10,
  m1_.translatable_id AS translatable_id_11
FROM
  monsieurbiz_blog_tag m0_
  LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id
  AND (m1_.locale = ?)
WHERE
  m1_.slug = ?
ORDER BY
  m0_.id ASC

SELECT m0_.enabled AS enabled_0, m0_.position AS position_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3, m0_.id AS id_4, m1_.name AS name_5, m1_.slug AS slug_6, m1_.created_at AS created_at_7, m1_.updated_at AS updated_at_8, m1_.id AS id_9, m1_.locale AS locale_10, m1_.translatable_id AS translatable_id_11 FROM monsieurbiz_blog_tag m0_ LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') WHERE m1_.slug = 'some-tag' ORDER BY m0_.id ASC;

SELECT
  m0_.enabled AS enabled_0,
  m0_.position AS position_1,
  m0_.created_at AS created_at_2,
  m0_.updated_at AS updated_at_3,
  m0_.id AS id_4,
  m1_.name AS name_5,
  m1_.slug AS slug_6,
  m1_.created_at AS created_at_7,
  m1_.updated_at AS updated_at_8,
  m1_.id AS id_9,
  m1_.locale AS locale_10,
  m1_.translatable_id AS translatable_id_11
FROM
  monsieurbiz_blog_tag m0_
  LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id
  AND (m1_.locale = ?)
WHERE
  m1_.slug = ?
ORDER BY
  m0_.id ASC

SELECT m0_.enabled AS enabled_0, m0_.position AS position_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3, m0_.id AS id_4, m1_.name AS name_5, m1_.slug AS slug_6, m1_.created_at AS created_at_7, m1_.updated_at AS updated_at_8, m1_.id AS id_9, m1_.locale AS locale_10, m1_.translatable_id AS translatable_id_11 FROM monsieurbiz_blog_tag m0_ LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') WHERE m1_.slug = 'some-tag' ORDER BY m0_.id ASC;

SELECT
  DISTINCT id_9
FROM
  (
    SELECT
      DISTINCT id_9,
      published_at_6
    FROM
      (
        SELECT
          m0_.enabled AS enabled_0,
          m0_.image AS image_1,
          m0_.video AS video_2,
          m0_.thumbnail_image AS thumbnail_image_3,
          m0_.type AS type_4,
          m0_.state AS state_5,
          m0_.published_at AS published_at_6,
          m0_.created_at AS created_at_7,
          m0_.updated_at AS updated_at_8,
          m0_.id AS id_9,
          m1_.title AS title_10,
          m1_.slug AS slug_11,
          m1_.description AS description_12,
          m1_.content AS content_13,
          m1_.meta_title AS meta_title_14,
          m1_.meta_description AS meta_description_15,
          m1_.meta_keywords AS meta_keywords_16,
          m1_.meta_image AS meta_image_17,
          m1_.created_at AS created_at_18,
          m1_.updated_at AS updated_at_19,
          m1_.id AS id_20,
          m1_.locale AS locale_21
        FROM
          monsieurbiz_blog_article m0_
          LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id
          AND (m1_.locale = ?)
        WHERE
          m0_.type = ?
          AND EXISTS (
            SELECT
              1
            FROM
              monsieurbiz_blog_article_channels m2_
            WHERE
              m2_.article_id = m0_.id
              AND m2_.channel_id IN (?)
          )
          AND m0_.enabled = 1
          AND m0_.state = ?
          AND EXISTS (
            SELECT
              1
            FROM
              monsieurbiz_blog_article_tags m3_
            WHERE
              m3_.article_id = m0_.id
              AND m3_.tag_id IN (?)
          )
      ) dctrn_result_inner
    ORDER BY
      published_at_6 DESC,
      id_9 ASC
  ) dctrn_result
LIMIT
  9

SELECT DISTINCT id_9 FROM (SELECT DISTINCT id_9, published_at_6 FROM (SELECT m0_.enabled AS enabled_0, m0_.image AS image_1, m0_.video AS video_2, m0_.thumbnail_image AS thumbnail_image_3, m0_.type AS type_4, m0_.state AS state_5, m0_.published_at AS published_at_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.id AS id_9, m1_.title AS title_10, m1_.slug AS slug_11, m1_.description AS description_12, m1_.content AS content_13, m1_.meta_title AS meta_title_14, m1_.meta_description AS meta_description_15, m1_.meta_keywords AS meta_keywords_16, m1_.meta_image AS meta_image_17, m1_.created_at AS created_at_18, m1_.updated_at AS updated_at_19, m1_.id AS id_20, m1_.locale AS locale_21 FROM monsieurbiz_blog_article m0_ LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') WHERE m0_.type = 'blog' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_channels m2_ WHERE m2_.article_id = m0_.id AND m2_.channel_id IN (1)) AND m0_.enabled = 1 AND m0_.state = 'published' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_tags m3_ WHERE m3_.article_id = m0_.id AND m3_.tag_id IN (2))) dctrn_result_inner ORDER BY published_at_6 DESC, id_9 ASC) dctrn_result LIMIT 9;

SELECT
  m0_.enabled AS enabled_0,
  m0_.image AS image_1,
  m0_.video AS video_2,
  m0_.thumbnail_image AS thumbnail_image_3,
  m0_.type AS type_4,
  m0_.state AS state_5,
  m0_.published_at AS published_at_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.id AS id_9,
  m1_.title AS title_10,
  m1_.slug AS slug_11,
  m1_.description AS description_12,
  m1_.content AS content_13,
  m1_.meta_title AS meta_title_14,
  m1_.meta_description AS meta_description_15,
  m1_.meta_keywords AS meta_keywords_16,
  m1_.meta_image AS meta_image_17,
  m1_.created_at AS created_at_18,
  m1_.updated_at AS updated_at_19,
  m1_.id AS id_20,
  m1_.locale AS locale_21,
  m1_.translatable_id AS translatable_id_22
FROM
  monsieurbiz_blog_article m0_
  LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id
  AND (m1_.locale = ?)
WHERE
  m0_.type = ?
  AND EXISTS (
    SELECT
      1
    FROM
      monsieurbiz_blog_article_channels m2_
    WHERE
      m2_.article_id = m0_.id
      AND m2_.channel_id IN (?)
  )
  AND m0_.enabled = 1
  AND m0_.state = ?
  AND EXISTS (
    SELECT
      1
    FROM
      monsieurbiz_blog_article_tags m3_
    WHERE
      m3_.article_id = m0_.id
      AND m3_.tag_id IN (?)
  )
  AND m0_.id IN (?)
ORDER BY
  m0_.published_at DESC,
  m0_.id ASC

SELECT m0_.enabled AS enabled_0, m0_.image AS image_1, m0_.video AS video_2, m0_.thumbnail_image AS thumbnail_image_3, m0_.type AS type_4, m0_.state AS state_5, m0_.published_at AS published_at_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.id AS id_9, m1_.title AS title_10, m1_.slug AS slug_11, m1_.description AS description_12, m1_.content AS content_13, m1_.meta_title AS meta_title_14, m1_.meta_description AS meta_description_15, m1_.meta_keywords AS meta_keywords_16, m1_.meta_image AS meta_image_17, m1_.created_at AS created_at_18, m1_.updated_at AS updated_at_19, m1_.id AS id_20, m1_.locale AS locale_21, m1_.translatable_id AS translatable_id_22 FROM monsieurbiz_blog_article m0_ LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') WHERE m0_.type = 'blog' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_channels m2_ WHERE m2_.article_id = m0_.id AND m2_.channel_id IN (1)) AND m0_.enabled = 1 AND m0_.state = 'published' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_tags m3_ WHERE m3_.article_id = m0_.id AND m3_.tag_id IN (2)) AND m0_.id IN (1) ORDER BY m0_.published_at DESC, m0_.id ASC;

SELECT
  s0_.code AS code_0,
  s0_.name AS name_1,
  s0_.template AS template_2,
  s0_.enabled AS enabled_3,
  s0_.id AS id_4,
  s0_.content AS content_5
FROM
  sylius_cms_block s0_
  LEFT JOIN sylius_cms_block_channels s2_ ON s0_.id = s2_.block_id
  LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id
WHERE
  s0_.code = ?
  AND s0_.enabled = 1
  AND s1_.code = ?
ORDER BY
  s0_.id ASC

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.template AS template_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.content AS content_5 FROM sylius_cms_block s0_ LEFT JOIN sylius_cms_block_channels s2_ ON s0_.id = s2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id WHERE s0_.code = 'top_panel' AND s0_.enabled = 1 AND s1_.code = 'default' ORDER BY s0_.id ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.code AS code_2,
  m0_.is_system AS is_system_3,
  m0_.id AS id_4,
  m1_.created_at AS created_at_5,
  m1_.updated_at AS updated_at_6,
  m1_.position AS position_7,
  m1_.target_blank AS target_blank_8,
  m1_.noreferrer AS noreferrer_9,
  m1_.noopener AS noopener_10,
  m1_.nofollow AS nofollow_11,
  m1_.enabled AS enabled_12,
  m1_.id AS id_13,
  m2_.locale AS locale_14,
  m2_.url AS url_15,
  m2_.label AS label_16,
  m2_.id AS id_17,
  m1_.menu_id AS menu_id_18,
  m1_.parent_id AS parent_id_19,
  m2_.translatable_id AS translatable_id_20
FROM
  monsieurbiz_menu m0_
  INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id
  INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id
  AND (m2_.locale = ?)
WHERE
  m0_.code = ?
  AND m1_.enabled = ?
ORDER BY
  m0_.id ASC,
  m1_.position ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.enabled AS enabled_12, m1_.id AS id_13, m2_.locale AS locale_14, m2_.url AS url_15, m2_.label AS label_16, m2_.id AS id_17, m1_.menu_id AS menu_id_18, m1_.parent_id AS parent_id_19, m2_.translatable_id AS translatable_id_20 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = 'uk') WHERE m0_.code = 'main_menu' AND m1_.enabled = 1 ORDER BY m0_.id ASC, m1_.position ASC;

SELECT
  s0_.code AS code_0,
  s0_.name AS name_1,
  s0_.template AS template_2,
  s0_.enabled AS enabled_3,
  s0_.id AS id_4,
  s0_.content AS content_5
FROM
  sylius_cms_block s0_
  LEFT JOIN sylius_cms_block_channels s2_ ON s0_.id = s2_.block_id
  LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id
WHERE
  s0_.code = ?
  AND s0_.enabled = 1
  AND s1_.code = ?
ORDER BY
  s0_.id ASC

SELECT s0_.code AS code_0, s0_.name AS name_1, s0_.template AS template_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.content AS content_5 FROM sylius_cms_block s0_ LEFT JOIN sylius_cms_block_channels s2_ ON s0_.id = s2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = s2_.channel_id WHERE s0_.code = 'announcement_bar' AND s0_.enabled = 1 AND s1_.code = 'default' ORDER BY s0_.id ASC;

SELECT
  m0_.enabled AS enabled_0,
  m0_.position AS position_1,
  m0_.created_at AS created_at_2,
  m0_.updated_at AS updated_at_3,
  m0_.id AS id_4,
  m1_.name AS name_5,
  m1_.slug AS slug_6,
  m1_.created_at AS created_at_7,
  m1_.updated_at AS updated_at_8,
  m1_.id AS id_9,
  m1_.locale AS locale_10,
  m1_.translatable_id AS translatable_id_11
FROM
  monsieurbiz_blog_tag m0_
  LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id
  AND (m1_.locale = ?)
  INNER JOIN monsieurbiz_blog_article_tags m3_ ON m0_.id = m3_.tag_id
  INNER JOIN monsieurbiz_blog_article m2_ ON m2_.id = m3_.article_id
WHERE
  m0_.enabled = 1
  AND m2_.enabled = 1
  AND m2_.state = ?
  AND m2_.type = ?
ORDER BY
  m0_.id ASC

SELECT m0_.enabled AS enabled_0, m0_.position AS position_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3, m0_.id AS id_4, m1_.name AS name_5, m1_.slug AS slug_6, m1_.created_at AS created_at_7, m1_.updated_at AS updated_at_8, m1_.id AS id_9, m1_.locale AS locale_10, m1_.translatable_id AS translatable_id_11 FROM monsieurbiz_blog_tag m0_ LEFT JOIN monsieurbiz_blog_tag_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') INNER JOIN monsieurbiz_blog_article_tags m3_ ON m0_.id = m3_.tag_id INNER JOIN monsieurbiz_blog_article m2_ ON m2_.id = m3_.article_id WHERE m0_.enabled = 1 AND m2_.enabled = 1 AND m2_.state = 'published' AND m2_.type = 'blog' ORDER BY m0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_9
    FROM
      (
        SELECT
          m0_.enabled AS enabled_0,
          m0_.image AS image_1,
          m0_.video AS video_2,
          m0_.thumbnail_image AS thumbnail_image_3,
          m0_.type AS type_4,
          m0_.state AS state_5,
          m0_.published_at AS published_at_6,
          m0_.created_at AS created_at_7,
          m0_.updated_at AS updated_at_8,
          m0_.id AS id_9,
          m1_.title AS title_10,
          m1_.slug AS slug_11,
          m1_.description AS description_12,
          m1_.content AS content_13,
          m1_.meta_title AS meta_title_14,
          m1_.meta_description AS meta_description_15,
          m1_.meta_keywords AS meta_keywords_16,
          m1_.meta_image AS meta_image_17,
          m1_.created_at AS created_at_18,
          m1_.updated_at AS updated_at_19,
          m1_.id AS id_20,
          m1_.locale AS locale_21
        FROM
          monsieurbiz_blog_article m0_
          LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id
          AND (m1_.locale = ?)
        WHERE
          m0_.type = ?
          AND EXISTS (
            SELECT
              1
            FROM
              monsieurbiz_blog_article_channels m2_
            WHERE
              m2_.article_id = m0_.id
              AND m2_.channel_id IN (?)
          )
          AND m0_.enabled = 1
          AND m0_.state = ?
          AND EXISTS (
            SELECT
              1
            FROM
              monsieurbiz_blog_article_tags m3_
            WHERE
              m3_.article_id = m0_.id
              AND m3_.tag_id IN (?)
          )
        ORDER BY
          m0_.published_at DESC,
          m0_.id ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT m0_.enabled AS enabled_0, m0_.image AS image_1, m0_.video AS video_2, m0_.thumbnail_image AS thumbnail_image_3, m0_.type AS type_4, m0_.state AS state_5, m0_.published_at AS published_at_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.id AS id_9, m1_.title AS title_10, m1_.slug AS slug_11, m1_.description AS description_12, m1_.content AS content_13, m1_.meta_title AS meta_title_14, m1_.meta_description AS meta_description_15, m1_.meta_keywords AS meta_keywords_16, m1_.meta_image AS meta_image_17, m1_.created_at AS created_at_18, m1_.updated_at AS updated_at_19, m1_.id AS id_20, m1_.locale AS locale_21 FROM monsieurbiz_blog_article m0_ LEFT JOIN monsieurbiz_blog_article_translation m1_ ON m0_.id = m1_.translatable_id AND (m1_.locale = 'uk') WHERE m0_.type = 'blog' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_channels m2_ WHERE m2_.article_id = m0_.id AND m2_.channel_id IN (1)) AND m0_.enabled = 1 AND m0_.state = 'published' AND EXISTS (SELECT 1 FROM monsieurbiz_blog_article_tags m3_ WHERE m3_.article_id = m0_.id AND m3_.tag_id IN (2)) ORDER BY m0_.published_at DESC, m0_.id ASC) dctrn_result) dctrn_table;

SELECT
  t0.enabled AS enabled_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5
FROM
  monsieurbiz_blog_tag t0
  INNER JOIN monsieurbiz_blog_article_tags ON t0.id = monsieurbiz_blog_article_tags.tag_id
WHERE
  monsieurbiz_blog_article_tags.article_id = ?

SELECT t0.enabled AS enabled_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5 FROM monsieurbiz_blog_tag t0 INNER JOIN monsieurbiz_blog_article_tags ON t0.id = monsieurbiz_blog_article_tags.tag_id WHERE monsieurbiz_blog_article_tags.article_id = 1;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.code AS code_2,
  m0_.is_system AS is_system_3,
  m0_.id AS id_4,
  m1_.created_at AS created_at_5,
  m1_.updated_at AS updated_at_6,
  m1_.position AS position_7,
  m1_.target_blank AS target_blank_8,
  m1_.noreferrer AS noreferrer_9,
  m1_.noopener AS noopener_10,
  m1_.nofollow AS nofollow_11,
  m1_.enabled AS enabled_12,
  m1_.id AS id_13,
  m2_.locale AS locale_14,
  m2_.url AS url_15,
  m2_.label AS label_16,
  m2_.id AS id_17,
  m1_.menu_id AS menu_id_18,
  m1_.parent_id AS parent_id_19,
  m2_.translatable_id AS translatable_id_20
FROM
  monsieurbiz_menu m0_
  INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id
  INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id
  AND (m2_.locale = ?)
WHERE
  m0_.code = ?
  AND m1_.enabled = ?
ORDER BY
  m0_.id ASC,
  m1_.position ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.enabled AS enabled_12, m1_.id AS id_13, m2_.locale AS locale_14, m2_.url AS url_15, m2_.label AS label_16, m2_.id AS id_17, m1_.menu_id AS menu_id_18, m1_.parent_id AS parent_id_19, m2_.translatable_id AS translatable_id_20 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = 'uk') WHERE m0_.code = 'footer_our_solutions' AND m1_.enabled = 1 ORDER BY m0_.id ASC, m1_.position ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.code AS code_2,
  m0_.is_system AS is_system_3,
  m0_.id AS id_4,
  m1_.created_at AS created_at_5,
  m1_.updated_at AS updated_at_6,
  m1_.position AS position_7,
  m1_.target_blank AS target_blank_8,
  m1_.noreferrer AS noreferrer_9,
  m1_.noopener AS noopener_10,
  m1_.nofollow AS nofollow_11,
  m1_.enabled AS enabled_12,
  m1_.id AS id_13,
  m2_.locale AS locale_14,
  m2_.url AS url_15,
  m2_.label AS label_16,
  m2_.id AS id_17,
  m1_.menu_id AS menu_id_18,
  m1_.parent_id AS parent_id_19,
  m2_.translatable_id AS translatable_id_20
FROM
  monsieurbiz_menu m0_
  INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id
  INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id
  AND (m2_.locale = ?)
WHERE
  m0_.code = ?
  AND m1_.enabled = ?
ORDER BY
  m0_.id ASC,
  m1_.position ASC

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.code AS code_2, m0_.is_system AS is_system_3, m0_.id AS id_4, m1_.created_at AS created_at_5, m1_.updated_at AS updated_at_6, m1_.position AS position_7, m1_.target_blank AS target_blank_8, m1_.noreferrer AS noreferrer_9, m1_.noopener AS noopener_10, m1_.nofollow AS nofollow_11, m1_.enabled AS enabled_12, m1_.id AS id_13, m2_.locale AS locale_14, m2_.url AS url_15, m2_.label AS label_16, m2_.id AS id_17, m1_.menu_id AS menu_id_18, m1_.parent_id AS parent_id_19, m2_.translatable_id AS translatable_id_20 FROM monsieurbiz_menu m0_ INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id AND (m2_.locale = 'uk') WHERE m0_.code = 'footer_scientific_approach' AND m1_.enabled = 1 ORDER BY m0_.id ASC, m1_.position ASC;

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.code AS code_2,
  m0_.is_system AS is_system_3,
  m0_.id AS id_4,
  m1_.created_at AS created_at_5,
  m1_.updated_at AS updated_at_6,
  m1_.position AS position_7,
  m1_.target_blank AS target_blank_8,
  m1_.noreferrer AS noreferrer_9,
  m1_.noopener AS noopener_10,
  m1_.nofollow AS nofollow_11,
  m1_.enabled AS enabled_12,
  m1_.id AS id_13,
  m2_.locale AS locale_14,
  m2_.url AS url_15,
  m2_.label AS label_16,
  m2_.id AS id_17,
  m1_.menu_id AS menu_id_18,
  m1_.parent_id AS parent_id_19,
  m2_.translatable_id AS translatable_id_20
FROM
  monsieurbiz_menu m0_
  INNER JOIN monsieurbiz_menu_item m1_ ON m0_.id = m1_.menu_id
  INNER JOIN monsieurbiz_menu_item_translation m2_ ON m1_.id = m2_.translatable_id
  AND (m2_.locale = ?)
WHERE
  m0_.code = ?
  AND m1_.enabled = ?
ORDER BY
  m0_.id ASC,
  m1_.position ASC