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
  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.category_translation_id AS category_translation_id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.child_categories_title AS child_categories_title_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.meta_keywords AS meta_keywords_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.category_id AS category_id_10,
  t0.language_id AS language_id_11
FROM
  category_translation t0
WHERE
  t0.category_id = ?

SELECT t0.category_translation_id AS category_translation_id_1, t0.title AS title_2, t0.content AS content_3, t0.child_categories_title AS child_categories_title_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10, t0.language_id AS language_id_11 FROM category_translation t0 WHERE t0.category_id = 472;

SELECT
  t0.category_id AS category_id_1,
  t0.image_url AS image_url_2,
  t0.slug AS slug_3,
  t0.show_in_main_nav AS show_in_main_nav_4,
  t0.show_in_bottom_nav AS show_in_bottom_nav_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8
FROM
  category t0
WHERE
  t0.parent_id = ?

SELECT t0.category_id AS category_id_1, t0.image_url AS image_url_2, t0.slug AS slug_3, t0.show_in_main_nav AS show_in_main_nav_4, t0.show_in_bottom_nav AS show_in_bottom_nav_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM category t0 WHERE t0.parent_id = 472;

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

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.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
  t0.product_id AS product_id_1,
  t0.type AS type_2,
  t0.main_image AS main_image_3,
  t0.article AS article_4,
  t0.oem_number AS oem_number_5,
  t0.price AS price_6,
  t0.special_price AS special_price_7,
  t0.stock_status AS stock_status_8,
  t0.quantity AS quantity_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.brand_id AS brand_id_13
FROM
  product t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.product_id AS product_id_1, t0.type AS type_2, t0.main_image AS main_image_3, t0.article AS article_4, t0.oem_number AS oem_number_5, t0.price AS price_6, t0.special_price AS special_price_7, t0.stock_status AS stock_status_8, t0.quantity AS quantity_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.brand_id AS brand_id_13 FROM product t0 WHERE t0.slug = '64471-8948-11714' LIMIT 1;

SELECT
  t0.category_id AS category_id_1,
  t0.image_url AS image_url_2,
  t0.slug AS slug_3,
  t0.show_in_main_nav AS show_in_main_nav_4,
  t0.show_in_bottom_nav AS show_in_bottom_nav_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent_id AS parent_id_8
FROM
  category t0
  INNER JOIN product_category ON t0.category_id = product_category.category_id
WHERE
  product_category.product_id = ?

SELECT t0.category_id AS category_id_1, t0.image_url AS image_url_2, t0.slug AS slug_3, t0.show_in_main_nav AS show_in_main_nav_4, t0.show_in_bottom_nav AS show_in_bottom_nav_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM category t0 INNER JOIN product_category ON t0.category_id = product_category.category_id WHERE product_category.product_id = 5039;

SELECT
  t0.product_translation_id AS product_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.product_id AS product_id_9,
  t0.language_id AS language_id_10
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.product_translation_id AS product_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.product_id AS product_id_9, t0.language_id AS language_id_10 FROM product_translation t0 WHERE t0.product_id = 5039;

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.sticker_id AS sticker_id_1,
  t0.color AS color_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  sticker t0
  INNER JOIN product_sticker ON t0.sticker_id = product_sticker.sticker_id
WHERE
  product_sticker.product_id = ?

SELECT t0.sticker_id AS sticker_id_1, t0.color AS color_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM sticker t0 INNER JOIN product_sticker ON t0.sticker_id = product_sticker.sticker_id WHERE product_sticker.product_id = 5039;

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
  t0.product_image_id AS product_image_id_1,
  t0.image_url AS image_url_2,
  t0.product_id AS product_id_3
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.product_image_id AS product_image_id_1, t0.image_url AS image_url_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = 5039;

SELECT
  t0.brand_id AS brand_id_1,
  t0.name AS name_2,
  t0.image_url AS image_url_3,
  t0.show_in_footer AS show_in_footer_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  brand t0
WHERE
  t0.brand_id = ?

SELECT t0.brand_id AS brand_id_1, t0.name AS name_2, t0.image_url AS image_url_3, t0.show_in_footer AS show_in_footer_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM brand t0 WHERE t0.brand_id = 26;