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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.is_active AS is_active_3,
  p0_.location AS location_4,
  p0_.category_id AS category_id_5
FROM
  product_sliders p0_
WHERE
  p0_.location = ?
  AND p0_.is_active = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.is_active AS is_active_3, p0_.location AS location_4, p0_.category_id AS category_id_5 FROM product_sliders p0_ WHERE p0_.location = 'home' AND p0_.is_active = 1 ORDER BY p0_.id ASC;

SELECT
  r0_.id AS id_0,
  r0_.author_name AS author_name_1,
  r0_.rating AS rating_2,
  r0_.comment AS comment_3,
  r0_.pros AS pros_4,
  r0_.cons AS cons_5,
  r0_.status AS status_6,
  r0_.ip_address AS ip_address_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.product_id AS product_id_10,
  r0_.author_id AS author_id_11
FROM
  reviews r0_
WHERE
  r0_.status = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  5

SELECT r0_.id AS id_0, r0_.author_name AS author_name_1, r0_.rating AS rating_2, r0_.comment AS comment_3, r0_.pros AS pros_4, r0_.cons AS cons_5, r0_.status AS status_6, r0_.ip_address AS ip_address_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.product_id AS product_id_10, r0_.author_id AS author_id_11 FROM reviews r0_ WHERE r0_.status = 1 ORDER BY r0_.created_at DESC LIMIT 5;

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,
  p0_.product_id AS product_id_7
FROM
  product_video p0_
  INNER JOIN product p1_ ON p0_.product_id = p1_.id
WHERE
  p0_.show_on_home = ?
ORDER BY
  p0_.home_page_sort_order ASC

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, p0_.product_id AS product_id_7 FROM product_video p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p0_.show_on_home = 1 ORDER BY p0_.home_page_sort_order ASC;

SELECT
  h0_.id AS id_0,
  h0_.image AS image_1,
  h0_.image_mobile AS image_mobile_2,
  h0_.title AS title_3,
  h0_.description AS description_4,
  h0_.link_url AS link_url_5,
  h0_.link_target AS link_target_6,
  h0_.is_active AS is_active_7,
  h0_.created_at AS created_at_8,
  h0_.updated_at AS updated_at_9,
  h0_.sort_order AS sort_order_10
FROM
  home_slider h0_
WHERE
  h0_.is_active = ?
ORDER BY
  h0_.sort_order ASC

SELECT h0_.id AS id_0, h0_.image AS image_1, h0_.image_mobile AS image_mobile_2, h0_.title AS title_3, h0_.description AS description_4, h0_.link_url AS link_url_5, h0_.link_target AS link_target_6, h0_.is_active AS is_active_7, h0_.created_at AS created_at_8, h0_.updated_at AS updated_at_9, h0_.sort_order AS sort_order_10 FROM home_slider h0_ WHERE h0_.is_active = 1 ORDER BY h0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.content AS content_4
FROM
  home_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.content AS content_4 FROM home_page t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.meta_title AS meta_title_2,
  t0.meta_description AS meta_description_3,
  t0.content AS content_4
FROM
  home_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.content AS content_4 FROM home_page t0 LIMIT 1;

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;