Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.active AS active_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6
FROM
  delivery_type t0
WHERE
  t0.is_default = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.active AS active_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6 FROM delivery_type t0 WHERE t0.is_default = 1 AND t0.active = 1 LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.url AS url_1,
          p0_.type AS type_2,
          p0_.cover AS cover_3,
          p0_.show_on_home AS show_on_home_4,
          p0_.home_page_sort_order AS home_page_sort_order_5,
          p0_.sort_order AS sort_order_6
        FROM
          product_video p0_
          INNER JOIN product p1_ ON p0_.product_id = p1_.id
        ORDER BY
          p0_.sort_order ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.type AS type_2, p0_.cover AS cover_3, p0_.show_on_home AS show_on_home_4, p0_.home_page_sort_order AS home_page_sort_order_5, p0_.sort_order AS sort_order_6 FROM product_video p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id ORDER BY p0_.sort_order ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_order_6
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.url AS url_1,
          p0_.type AS type_2,
          p0_.cover AS cover_3,
          p0_.show_on_home AS show_on_home_4,
          p0_.home_page_sort_order AS home_page_sort_order_5,
          p0_.sort_order AS sort_order_6
        FROM
          product_video p0_
          INNER JOIN product p1_ ON p0_.product_id = p1_.id
      ) dctrn_result_inner
    ORDER BY
      sort_order_6 ASC
  ) dctrn_result
LIMIT
  30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_order_6 FROM (SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.type AS type_2, p0_.cover AS cover_3, p0_.show_on_home AS show_on_home_4, p0_.home_page_sort_order AS home_page_sort_order_5, p0_.sort_order AS sort_order_6 FROM product_video p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id) dctrn_result_inner ORDER BY sort_order_6 ASC) dctrn_result LIMIT 30;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.navbar_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.navbar_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.visibility AS visibility_2,
  c0_.parent_category_id AS parent_category_id_3,
  c0_.meta_title AS meta_title_4,
  c0_.meta_description AS meta_description_5,
  c0_.meta_keywords AS meta_keywords_6,
  c0_.meta_h1 AS meta_h1_7,
  c0_.description AS description_8,
  c0_.navbar_visibility AS navbar_visibility_9,
  c0_.footer_visibility AS footer_visibility_10,
  c0_.slug AS slug_11,
  c0_.sort_order AS sort_order_12
FROM
  category c0_
WHERE
  c0_.footer_visibility = ?
  AND c0_.visibility = ?
  AND c0_.name IS NOT NULL
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visibility AS visibility_2, c0_.parent_category_id AS parent_category_id_3, c0_.meta_title AS meta_title_4, c0_.meta_description AS meta_description_5, c0_.meta_keywords AS meta_keywords_6, c0_.meta_h1 AS meta_h1_7, c0_.description AS description_8, c0_.navbar_visibility AS navbar_visibility_9, c0_.footer_visibility AS footer_visibility_10, c0_.slug AS slug_11, c0_.sort_order AS sort_order_12 FROM category c0_ WHERE c0_.footer_visibility = 1 AND c0_.visibility = 1 AND c0_.name IS NOT NULL ORDER BY c0_.sort_order ASC, c0_.name ASC;