Symfony Profiler

SELECT
  c0_.category_id AS category_id_0,
  c0_.image_url AS image_url_1,
  c0_.slug AS slug_2,
  c0_.show_in_main_nav AS show_in_main_nav_3,
  c0_.show_in_bottom_nav AS show_in_bottom_nav_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c1_.category_translation_id AS category_translation_id_7,
  c1_.title AS title_8,
  c1_.content AS content_9,
  c1_.child_categories_title AS child_categories_title_10,
  c1_.meta_title AS meta_title_11,
  c1_.meta_description AS meta_description_12,
  c1_.meta_keywords AS meta_keywords_13,
  c1_.created_at AS created_at_14,
  c1_.updated_at AS updated_at_15,
  c2_.category_id AS category_id_16,
  c2_.image_url AS image_url_17,
  c2_.slug AS slug_18,
  c2_.show_in_main_nav AS show_in_main_nav_19,
  c2_.show_in_bottom_nav AS show_in_bottom_nav_20,
  c2_.created_at AS created_at_21,
  c2_.updated_at AS updated_at_22,
  c3_.category_translation_id AS category_translation_id_23,
  c3_.title AS title_24,
  c3_.content AS content_25,
  c3_.child_categories_title AS child_categories_title_26,
  c3_.meta_title AS meta_title_27,
  c3_.meta_description AS meta_description_28,
  c3_.meta_keywords AS meta_keywords_29,
  c3_.created_at AS created_at_30,
  c3_.updated_at AS updated_at_31,
  c4_.category_id AS category_id_32,
  c4_.image_url AS image_url_33,
  c4_.slug AS slug_34,
  c4_.show_in_main_nav AS show_in_main_nav_35,
  c4_.show_in_bottom_nav AS show_in_bottom_nav_36,
  c4_.created_at AS created_at_37,
  c4_.updated_at AS updated_at_38,
  c5_.category_translation_id AS category_translation_id_39,
  c5_.title AS title_40,
  c5_.content AS content_41,
  c5_.child_categories_title AS child_categories_title_42,
  c5_.meta_title AS meta_title_43,
  c5_.meta_description AS meta_description_44,
  c5_.meta_keywords AS meta_keywords_45,
  c5_.created_at AS created_at_46,
  c5_.updated_at AS updated_at_47,
  c6_.category_id AS category_id_48,
  c6_.image_url AS image_url_49,
  c6_.slug AS slug_50,
  c6_.show_in_main_nav AS show_in_main_nav_51,
  c6_.show_in_bottom_nav AS show_in_bottom_nav_52,
  c6_.created_at AS created_at_53,
  c6_.updated_at AS updated_at_54,
  c7_.category_translation_id AS category_translation_id_55,
  c7_.title AS title_56,
  c7_.content AS content_57,
  c7_.child_categories_title AS child_categories_title_58,
  c7_.meta_title AS meta_title_59,
  c7_.meta_description AS meta_description_60,
  c7_.meta_keywords AS meta_keywords_61,
  c7_.created_at AS created_at_62,
  c7_.updated_at AS updated_at_63,
  c0_.parent_id AS parent_id_64,
  c1_.category_id AS category_id_65,
  c1_.language_id AS language_id_66,
  c2_.parent_id AS parent_id_67,
  c3_.category_id AS category_id_68,
  c3_.language_id AS language_id_69,
  c4_.parent_id AS parent_id_70,
  c5_.category_id AS category_id_71,
  c5_.language_id AS language_id_72,
  c6_.parent_id AS parent_id_73,
  c7_.category_id AS category_id_74,
  c7_.language_id AS language_id_75
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.category_id = c1_.category_id
  LEFT JOIN category c2_ ON c0_.category_id = c2_.parent_id
  LEFT JOIN category_translation c3_ ON c2_.category_id = c3_.category_id
  LEFT JOIN category c4_ ON c2_.category_id = c4_.parent_id
  LEFT JOIN category_translation c5_ ON c4_.category_id = c5_.category_id
  LEFT JOIN category c6_ ON c4_.category_id = c6_.parent_id
  LEFT JOIN category_translation c7_ ON c6_.category_id = c7_.category_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.show_in_main_nav = 1

SELECT c0_.category_id AS category_id_0, c0_.image_url AS image_url_1, c0_.slug AS slug_2, c0_.show_in_main_nav AS show_in_main_nav_3, c0_.show_in_bottom_nav AS show_in_bottom_nav_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.category_translation_id AS category_translation_id_7, c1_.title AS title_8, c1_.content AS content_9, c1_.child_categories_title AS child_categories_title_10, c1_.meta_title AS meta_title_11, c1_.meta_description AS meta_description_12, c1_.meta_keywords AS meta_keywords_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c2_.category_id AS category_id_16, c2_.image_url AS image_url_17, c2_.slug AS slug_18, c2_.show_in_main_nav AS show_in_main_nav_19, c2_.show_in_bottom_nav AS show_in_bottom_nav_20, c2_.created_at AS created_at_21, c2_.updated_at AS updated_at_22, c3_.category_translation_id AS category_translation_id_23, c3_.title AS title_24, c3_.content AS content_25, c3_.child_categories_title AS child_categories_title_26, c3_.meta_title AS meta_title_27, c3_.meta_description AS meta_description_28, c3_.meta_keywords AS meta_keywords_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c4_.category_id AS category_id_32, c4_.image_url AS image_url_33, c4_.slug AS slug_34, c4_.show_in_main_nav AS show_in_main_nav_35, c4_.show_in_bottom_nav AS show_in_bottom_nav_36, c4_.created_at AS created_at_37, c4_.updated_at AS updated_at_38, c5_.category_translation_id AS category_translation_id_39, c5_.title AS title_40, c5_.content AS content_41, c5_.child_categories_title AS child_categories_title_42, c5_.meta_title AS meta_title_43, c5_.meta_description AS meta_description_44, c5_.meta_keywords AS meta_keywords_45, c5_.created_at AS created_at_46, c5_.updated_at AS updated_at_47, c6_.category_id AS category_id_48, c6_.image_url AS image_url_49, c6_.slug AS slug_50, c6_.show_in_main_nav AS show_in_main_nav_51, c6_.show_in_bottom_nav AS show_in_bottom_nav_52, c6_.created_at AS created_at_53, c6_.updated_at AS updated_at_54, c7_.category_translation_id AS category_translation_id_55, c7_.title AS title_56, c7_.content AS content_57, c7_.child_categories_title AS child_categories_title_58, c7_.meta_title AS meta_title_59, c7_.meta_description AS meta_description_60, c7_.meta_keywords AS meta_keywords_61, c7_.created_at AS created_at_62, c7_.updated_at AS updated_at_63, c0_.parent_id AS parent_id_64, c1_.category_id AS category_id_65, c1_.language_id AS language_id_66, c2_.parent_id AS parent_id_67, c3_.category_id AS category_id_68, c3_.language_id AS language_id_69, c4_.parent_id AS parent_id_70, c5_.category_id AS category_id_71, c5_.language_id AS language_id_72, c6_.parent_id AS parent_id_73, c7_.category_id AS category_id_74, c7_.language_id AS language_id_75 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.category_id = c1_.category_id LEFT JOIN category c2_ ON c0_.category_id = c2_.parent_id LEFT JOIN category_translation c3_ ON c2_.category_id = c3_.category_id LEFT JOIN category c4_ ON c2_.category_id = c4_.parent_id LEFT JOIN category_translation c5_ ON c4_.category_id = c5_.category_id LEFT JOIN category c6_ ON c4_.category_id = c6_.parent_id LEFT JOIN category_translation c7_ ON c6_.category_id = c7_.category_id WHERE c0_.parent_id IS NULL AND c0_.show_in_main_nav = 1;

SELECT
  c0_.category_id AS category_id_0,
  COUNT(p1_.product_id) AS sclr_1
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.category_id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.product_id = p2_.product_id
GROUP BY
  c0_.category_id

SELECT c0_.category_id AS category_id_0, COUNT(p1_.product_id) AS sclr_1 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.category_id = p2_.category_id LEFT JOIN product p1_ ON p1_.product_id = p2_.product_id GROUP BY c0_.category_id;

SELECT
  i0_.info_page_id AS info_page_id_0,
  i0_.slug AS slug_1,
  i0_.show_in_header AS show_in_header_2,
  i0_.show_in_footer AS show_in_footer_3,
  i0_.type AS type_4,
  i0_.created_at AS created_at_5,
  i0_.updated_at AS updated_at_6,
  i1_.info_page_translation_id AS info_page_translation_id_7,
  i1_.title AS title_8,
  i1_.content AS content_9,
  i1_.meta_title AS meta_title_10,
  i1_.meta_description AS meta_description_11,
  i1_.meta_keywords AS meta_keywords_12,
  i1_.created_at AS created_at_13,
  i1_.updated_at AS updated_at_14,
  i1_.info_page_id AS info_page_id_15,
  i1_.language_id AS language_id_16
FROM
  info_page i0_
  LEFT JOIN info_page_translation i1_ ON i0_.info_page_id = i1_.info_page_id
WHERE
  i0_.type = ?
ORDER BY
  i0_.info_page_id ASC

SELECT i0_.info_page_id AS info_page_id_0, i0_.slug AS slug_1, i0_.show_in_header AS show_in_header_2, i0_.show_in_footer AS show_in_footer_3, i0_.type AS type_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6, i1_.info_page_translation_id AS info_page_translation_id_7, i1_.title AS title_8, i1_.content AS content_9, i1_.meta_title AS meta_title_10, i1_.meta_description AS meta_description_11, i1_.meta_keywords AS meta_keywords_12, i1_.created_at AS created_at_13, i1_.updated_at AS updated_at_14, i1_.info_page_id AS info_page_id_15, i1_.language_id AS language_id_16 FROM info_page i0_ LEFT JOIN info_page_translation i1_ ON i0_.info_page_id = i1_.info_page_id WHERE i0_.type = 'cabinet_page' ORDER BY i0_.info_page_id ASC;

SELECT
  s0_.setting_id AS setting_id_0,
  s0_.name AS name_1,
  s0_.`key` AS key_2,
  s0_.type AS type_3,
  s0_.value AS value_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  setting s0_
WHERE
  s0_.`key` = ?

SELECT s0_.setting_id AS setting_id_0, s0_.name AS name_1, s0_.`key` AS key_2, s0_.type AS type_3, s0_.value AS value_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.`key` = 'default.phone_numbers';

SELECT
  t0.study_id AS study_id_1,
  t0.main_image AS main_image_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  study t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.study_id AS study_id_1, t0.main_image AS main_image_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM study t0 WHERE t0.slug = 'study-6' LIMIT 1;

SELECT
  t0.info_page_translation_id AS info_page_translation_id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.info_page_id AS info_page_id_9,
  t0.language_id AS language_id_10
FROM
  info_page_translation t0
WHERE
  t0.info_page_id = ?

SELECT t0.info_page_translation_id AS info_page_translation_id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.info_page_id AS info_page_id_9, t0.language_id AS language_id_10 FROM info_page_translation t0 WHERE t0.info_page_id = 11;

SELECT
  c0_.category_id AS category_id_0,
  c0_.image_url AS image_url_1,
  c0_.slug AS slug_2,
  c0_.show_in_main_nav AS show_in_main_nav_3,
  c0_.show_in_bottom_nav AS show_in_bottom_nav_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c1_.category_translation_id AS category_translation_id_7,
  c1_.title AS title_8,
  c1_.content AS content_9,
  c1_.child_categories_title AS child_categories_title_10,
  c1_.meta_title AS meta_title_11,
  c1_.meta_description AS meta_description_12,
  c1_.meta_keywords AS meta_keywords_13,
  c1_.created_at AS created_at_14,
  c1_.updated_at AS updated_at_15,
  c0_.parent_id AS parent_id_16,
  c1_.category_id AS category_id_17,
  c1_.language_id AS language_id_18
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.category_id = c1_.category_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.show_in_bottom_nav = 1

SELECT c0_.category_id AS category_id_0, c0_.image_url AS image_url_1, c0_.slug AS slug_2, c0_.show_in_main_nav AS show_in_main_nav_3, c0_.show_in_bottom_nav AS show_in_bottom_nav_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.category_translation_id AS category_translation_id_7, c1_.title AS title_8, c1_.content AS content_9, c1_.child_categories_title AS child_categories_title_10, c1_.meta_title AS meta_title_11, c1_.meta_description AS meta_description_12, c1_.meta_keywords AS meta_keywords_13, c1_.created_at AS created_at_14, c1_.updated_at AS updated_at_15, c0_.parent_id AS parent_id_16, c1_.category_id AS category_id_17, c1_.language_id AS language_id_18 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.category_id = c1_.category_id WHERE c0_.parent_id IS NULL AND c0_.show_in_bottom_nav = 1;

SELECT
  t0.study_translation_id AS study_translation_id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.study_id AS study_id_9,
  t0.language_id AS language_id_10
FROM
  study_translation t0
WHERE
  t0.study_id = ?

SELECT t0.study_translation_id AS study_translation_id_1, t0.title AS title_2, t0.content AS content_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.study_id AS study_id_9, t0.language_id AS language_id_10 FROM study_translation t0 WHERE t0.study_id = 37;

SELECT
  t0.info_page_id AS info_page_id_1,
  t0.slug AS slug_2,
  t0.show_in_header AS show_in_header_3,
  t0.show_in_footer AS show_in_footer_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  info_page t0
WHERE
  t0.show_in_header = ?

SELECT t0.info_page_id AS info_page_id_1, t0.slug AS slug_2, t0.show_in_header AS show_in_header_3, t0.show_in_footer AS show_in_footer_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM info_page t0 WHERE t0.show_in_header = 1;

SELECT
  b0_.brand_id AS brand_id_0,
  b0_.name AS name_1,
  b0_.image_url AS image_url_2,
  b0_.show_in_footer AS show_in_footer_3,
  b0_.slug AS slug_4,
  b0_.created_at AS created_at_5,
  b0_.updated_at AS updated_at_6
FROM
  brand b0_
WHERE
  b0_.show_in_footer = ?
ORDER BY
  b0_.name ASC

SELECT b0_.brand_id AS brand_id_0, b0_.name AS name_1, b0_.image_url AS image_url_2, b0_.show_in_footer AS show_in_footer_3, b0_.slug AS slug_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6 FROM brand b0_ WHERE b0_.show_in_footer = 1 ORDER BY b0_.name ASC;

SELECT
  t0.language_id AS language_id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.language_id AS language_id_1, t0.name AS name_2, t0.code AS code_3 FROM language t0 WHERE t0.code = 'uk' LIMIT 1;