Symfony Profiler

SELECT
  m0_.alias AS alias_0,
  m0_.lft AS lft_1,
  m0_.rgt AS rgt_2,
  m0_.lvl AS lvl_3,
  m0_.root AS root_4,
  m0_.id AS id_5,
  c1_.main_template AS main_template_6,
  c1_.product_template AS product_template_7,
  c1_.filterable AS filterable_8,
  c1_.id AS id_9,
  c1_.created_at AS created_at_10,
  c1_.updated_at AS updated_at_11,
  c2_.slug AS slug_12,
  c2_.title AS title_13,
  c2_.h1 AS h1_14,
  c2_.perex AS perex_15,
  c2_.description AS description_16,
  c2_.meta_title AS meta_title_17,
  c2_.meta_description AS meta_description_18,
  c2_.meta_keywords AS meta_keywords_19,
  c2_.locale AS locale_20,
  c2_.id AS id_21,
  i3_.name AS name_22,
  i3_.original_name AS original_name_23,
  i3_.mime_type AS mime_type_24,
  i3_.size AS size_25,
  i3_.width AS width_26,
  i3_.height AS height_27,
  i3_.id AS id_28,
  i3_.created_at AS created_at_29,
  i3_.updated_at AS updated_at_30,
  i4_.title AS title_31,
  i4_.keywords AS keywords_32,
  i4_.locale AS locale_33,
  i4_.id AS id_34,
  m0_.category_id AS category_id_35,
  m0_.parent_id AS parent_id_36,
  c1_.principal_image_id AS principal_image_id_37,
  c2_.translatable_id AS translatable_id_38,
  i4_.translatable_id AS translatable_id_39
FROM
  menu_sk m0_
  LEFT JOIN category c1_ ON m0_.category_id = c1_.id
  LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id
  AND (
    c2_.locale IN (?)
  )
  LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id
  LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id
  AND (
    i4_.locale IN (?)
  )
ORDER BY
  m0_.lft ASC

SELECT m0_.alias AS alias_0, m0_.lft AS lft_1, m0_.rgt AS rgt_2, m0_.lvl AS lvl_3, m0_.root AS root_4, m0_.id AS id_5, c1_.main_template AS main_template_6, c1_.product_template AS product_template_7, c1_.filterable AS filterable_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.slug AS slug_12, c2_.title AS title_13, c2_.h1 AS h1_14, c2_.perex AS perex_15, c2_.description AS description_16, c2_.meta_title AS meta_title_17, c2_.meta_description AS meta_description_18, c2_.meta_keywords AS meta_keywords_19, c2_.locale AS locale_20, c2_.id AS id_21, i3_.name AS name_22, i3_.original_name AS original_name_23, i3_.mime_type AS mime_type_24, i3_.size AS size_25, i3_.width AS width_26, i3_.height AS height_27, i3_.id AS id_28, i3_.created_at AS created_at_29, i3_.updated_at AS updated_at_30, i4_.title AS title_31, i4_.keywords AS keywords_32, i4_.locale AS locale_33, i4_.id AS id_34, m0_.category_id AS category_id_35, m0_.parent_id AS parent_id_36, c1_.principal_image_id AS principal_image_id_37, c2_.translatable_id AS translatable_id_38, i4_.translatable_id AS translatable_id_39 FROM menu_sk m0_ LEFT JOIN category c1_ ON m0_.category_id = c1_.id LEFT JOIN category_translation c2_ ON c1_.id = c2_.translatable_id AND (c2_.locale IN ('sk')) LEFT JOIN image i3_ ON c1_.principal_image_id = i3_.id LEFT JOIN image_translation i4_ ON i3_.id = i4_.translatable_id AND (i4_.locale IN ('sk')) ORDER BY m0_.lft ASC;

SELECT
  s0_.id AS id_0,
  s0_.content_id AS content_id_1,
  s0_.locale AS locale_2,
  s0_.slug AS slug_3,
  s0_.type AS type_4,
  s0_.previous_slug AS previous_slug_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7
FROM
  slug s0_
WHERE
  s0_.slug = ?
  AND s0_.locale IN (?)

SELECT s0_.id AS id_0, s0_.content_id AS content_id_1, s0_.locale AS locale_2, s0_.slug AS slug_3, s0_.type AS type_4, s0_.previous_slug AS previous_slug_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7 FROM slug s0_ WHERE s0_.slug = 'zdravotnictvo' AND s0_.locale IN ('sk');

SELECT
  s0_.name AS name_0,
  s0_.email AS email_1,
  s0_.url AS url_2,
  s0_.country AS country_3,
  s0_.locale AS locale_4,
  s0_.currency AS currency_5,
  s0_.order_base_number AS order_base_number_6,
  s0_.order_email AS order_email_7,
  s0_.id AS id_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10
FROM
  store s0_
ORDER BY
  s0_.id ASC

SELECT s0_.name AS name_0, s0_.email AS email_1, s0_.url AS url_2, s0_.country AS country_3, s0_.locale AS locale_4, s0_.currency AS currency_5, s0_.order_base_number AS order_base_number_6, s0_.order_email AS order_email_7, s0_.id AS id_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM store s0_ ORDER BY s0_.id ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          r0_.url AS url_0,
          r0_.id AS id_1,
          r0_.position AS position_2,
          r0_.created_at AS created_at_3,
          r0_.updated_at AS updated_at_4,
          r1_.slug AS slug_5,
          r1_.title AS title_6,
          r1_.h1 AS h1_7,
          r1_.perex AS perex_8,
          r1_.description AS description_9,
          r1_.meta_title AS meta_title_10,
          r1_.meta_description AS meta_description_11,
          r1_.meta_keywords AS meta_keywords_12,
          r1_.locale AS locale_13,
          r1_.id AS id_14
        FROM
          reference r0_
          LEFT JOIN reference_translation r1_ ON r0_.id = r1_.translatable_id
          AND (
            r1_.locale IN (?)
          )
        WHERE
          r0_.principal_category_id = ?
        ORDER BY
          r0_.principal_category_id ASC,
          r0_.position ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT r0_.url AS url_0, r0_.id AS id_1, r0_.position AS position_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r1_.slug AS slug_5, r1_.title AS title_6, r1_.h1 AS h1_7, r1_.perex AS perex_8, r1_.description AS description_9, r1_.meta_title AS meta_title_10, r1_.meta_description AS meta_description_11, r1_.meta_keywords AS meta_keywords_12, r1_.locale AS locale_13, r1_.id AS id_14 FROM reference r0_ LEFT JOIN reference_translation r1_ ON r0_.id = r1_.translatable_id AND (r1_.locale IN ('sk')) WHERE r0_.principal_category_id = 236 ORDER BY r0_.principal_category_id ASC, r0_.position ASC) dctrn_result) dctrn_table;

SELECT
  r0_.url AS url_0,
  r0_.id AS id_1,
  r0_.position AS position_2,
  r0_.created_at AS created_at_3,
  r0_.updated_at AS updated_at_4,
  r1_.slug AS slug_5,
  r1_.title AS title_6,
  r1_.h1 AS h1_7,
  r1_.perex AS perex_8,
  r1_.description AS description_9,
  r1_.meta_title AS meta_title_10,
  r1_.meta_description AS meta_description_11,
  r1_.meta_keywords AS meta_keywords_12,
  r1_.locale AS locale_13,
  r1_.id AS id_14,
  r0_.principal_category_id AS principal_category_id_15,
  r0_.principal_image_id AS principal_image_id_16,
  r1_.translatable_id AS translatable_id_17
FROM
  reference r0_
  LEFT JOIN reference_translation r1_ ON r0_.id = r1_.translatable_id
  AND (
    r1_.locale IN (?)
  )
WHERE
  r0_.principal_category_id = ?
ORDER BY
  r0_.principal_category_id ASC,
  r0_.position ASC
LIMIT
  25

SELECT r0_.url AS url_0, r0_.id AS id_1, r0_.position AS position_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r1_.slug AS slug_5, r1_.title AS title_6, r1_.h1 AS h1_7, r1_.perex AS perex_8, r1_.description AS description_9, r1_.meta_title AS meta_title_10, r1_.meta_description AS meta_description_11, r1_.meta_keywords AS meta_keywords_12, r1_.locale AS locale_13, r1_.id AS id_14, r0_.principal_category_id AS principal_category_id_15, r0_.principal_image_id AS principal_image_id_16, r1_.translatable_id AS translatable_id_17 FROM reference r0_ LEFT JOIN reference_translation r1_ ON r0_.id = r1_.translatable_id AND (r1_.locale IN ('sk')) WHERE r0_.principal_category_id = 236 ORDER BY r0_.principal_category_id ASC, r0_.position ASC LIMIT 25;

SELECT
  t0.main_template AS main_template_1,
  t0.product_template AS product_template_2,
  t0.filterable AS filterable_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.principal_image_id AS principal_image_id_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.main_template AS main_template_1, t0.product_template AS product_template_2, t0.filterable AS filterable_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.principal_image_id AS principal_image_id_7 FROM category t0 WHERE t0.id = 236;

SELECT
  t0.position AS position_1,
  t0.category_id AS category_id_2,
  t0.image_id AS image_id_3
FROM
  category_image t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.position AS position_1, t0.category_id AS category_id_2, t0.image_id AS image_id_3 FROM category_image t0 WHERE t0.category_id = 236 ORDER BY t0.position ASC;

SELECT
  t0.title AS title_1,
  t0.keywords AS keywords_2,
  t0.locale AS locale_3,
  t0.id AS id_4,
  t0.translatable_id AS translatable_id_5
FROM
  image_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.keywords AS keywords_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM image_translation t0 WHERE t0.translatable_id = 171;

SELECT
  t0.name AS name_1,
  t0.original_name AS original_name_2,
  t0.mime_type AS mime_type_3,
  t0.size AS size_4,
  t0.width AS width_5,
  t0.height AS height_6,
  t0.id AS id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.size AS size_4, t0.width AS width_5, t0.height AS height_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM image t0 WHERE t0.id = 171;