Symfony Profiler

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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT product_id_0
    FROM
      (
        SELECT
          p0_.product_id AS product_id_0,
          p0_.type AS type_1,
          p0_.main_image AS main_image_2,
          p0_.article AS article_3,
          p0_.oem_number AS oem_number_4,
          p0_.price AS price_5,
          p0_.special_price AS special_price_6,
          p0_.stock_status AS stock_status_7,
          p0_.quantity AS quantity_8,
          p0_.slug AS slug_9,
          p0_.created_at AS created_at_10,
          p0_.updated_at AS updated_at_11,
          p1_.product_translation_id AS product_translation_id_12,
          p1_.title AS title_13,
          p1_.content AS content_14,
          p1_.meta_title AS meta_title_15,
          p1_.meta_description AS meta_description_16,
          p1_.meta_keywords AS meta_keywords_17,
          p1_.created_at AS created_at_18,
          p1_.updated_at AS updated_at_19
        FROM
          product p0_
          LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id
        WHERE
          p1_.language_id = ?
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT product_id_0 FROM (SELECT p0_.product_id AS product_id_0, p0_.type AS type_1, p0_.main_image AS main_image_2, p0_.article AS article_3, p0_.oem_number AS oem_number_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.stock_status AS stock_status_7, p0_.quantity AS quantity_8, p0_.slug AS slug_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p1_.product_translation_id AS product_translation_id_12, p1_.title AS title_13, p1_.content AS content_14, p1_.meta_title AS meta_title_15, p1_.meta_description AS meta_description_16, p1_.meta_keywords AS meta_keywords_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id WHERE p1_.language_id = 5) dctrn_result) dctrn_table;

SELECT
  DISTINCT product_id_0
FROM
  (
    SELECT
      p0_.product_id AS product_id_0,
      p0_.type AS type_1,
      p0_.main_image AS main_image_2,
      p0_.article AS article_3,
      p0_.oem_number AS oem_number_4,
      p0_.price AS price_5,
      p0_.special_price AS special_price_6,
      p0_.stock_status AS stock_status_7,
      p0_.quantity AS quantity_8,
      p0_.slug AS slug_9,
      p0_.created_at AS created_at_10,
      p0_.updated_at AS updated_at_11,
      p1_.product_translation_id AS product_translation_id_12,
      p1_.title AS title_13,
      p1_.content AS content_14,
      p1_.meta_title AS meta_title_15,
      p1_.meta_description AS meta_description_16,
      p1_.meta_keywords AS meta_keywords_17,
      p1_.created_at AS created_at_18,
      p1_.updated_at AS updated_at_19
    FROM
      product p0_
      LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id
    WHERE
      p1_.language_id = ?
  ) dctrn_result
LIMIT
  10
OFFSET
  3990

SELECT DISTINCT product_id_0 FROM (SELECT p0_.product_id AS product_id_0, p0_.type AS type_1, p0_.main_image AS main_image_2, p0_.article AS article_3, p0_.oem_number AS oem_number_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.stock_status AS stock_status_7, p0_.quantity AS quantity_8, p0_.slug AS slug_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p1_.product_translation_id AS product_translation_id_12, p1_.title AS title_13, p1_.content AS content_14, p1_.meta_title AS meta_title_15, p1_.meta_description AS meta_description_16, p1_.meta_keywords AS meta_keywords_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id WHERE p1_.language_id = 5) dctrn_result LIMIT 10 OFFSET 3990;

SELECT
  p0_.product_id AS product_id_0,
  p0_.type AS type_1,
  p0_.main_image AS main_image_2,
  p0_.article AS article_3,
  p0_.oem_number AS oem_number_4,
  p0_.price AS price_5,
  p0_.special_price AS special_price_6,
  p0_.stock_status AS stock_status_7,
  p0_.quantity AS quantity_8,
  p0_.slug AS slug_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p1_.product_translation_id AS product_translation_id_12,
  p1_.title AS title_13,
  p1_.content AS content_14,
  p1_.meta_title AS meta_title_15,
  p1_.meta_description AS meta_description_16,
  p1_.meta_keywords AS meta_keywords_17,
  p1_.created_at AS created_at_18,
  p1_.updated_at AS updated_at_19,
  p0_.brand_id AS brand_id_20,
  p1_.product_id AS product_id_21,
  p1_.language_id AS language_id_22
FROM
  product p0_
  LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id
WHERE
  p1_.language_id = ?
  AND p0_.product_id IN (?, ?, ?)

SELECT p0_.product_id AS product_id_0, p0_.type AS type_1, p0_.main_image AS main_image_2, p0_.article AS article_3, p0_.oem_number AS oem_number_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.stock_status AS stock_status_7, p0_.quantity AS quantity_8, p0_.slug AS slug_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p1_.product_translation_id AS product_translation_id_12, p1_.title AS title_13, p1_.content AS content_14, p1_.meta_title AS meta_title_15, p1_.meta_description AS meta_description_16, p1_.meta_keywords AS meta_keywords_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, p0_.brand_id AS brand_id_20, p1_.product_id AS product_id_21, p1_.language_id AS language_id_22 FROM product p0_ LEFT JOIN product_translation p1_ ON p0_.product_id = p1_.product_id WHERE p1_.language_id = 5 AND p0_.product_id IN (6686, 6689, 6698);

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

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

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

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

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

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

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

SELECT
  t0.sticker_translation_id AS sticker_translation_id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.sticker_id AS sticker_id_5,
  t0.language_id AS language_id_6
FROM
  sticker_translation t0
WHERE
  t0.sticker_id = ?

SELECT t0.sticker_translation_id AS sticker_translation_id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.sticker_id AS sticker_id_5, t0.language_id AS language_id_6 FROM sticker_translation t0 WHERE t0.sticker_id = 7;

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

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

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

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

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

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

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

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.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.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 = 12;

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
  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.time_of_work';

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.logo';