Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.sort_order AS sort_order_1,
  p1_.id AS id_2,
  p1_.name AS name_3,
  p1_.slug AS slug_4,
  p1_.sort_order AS sort_order_5,
  p1_.effective_price AS effective_price_6,
  p1_.status AS status_7,
  p1_.type AS type_8,
  p1_.quantity AS quantity_9,
  p1_.options_json AS options_json_10,
  p1_.attribute_json AS attribute_json_11,
  p1_.code AS code_12,
  p1_.description AS description_13,
  p1_.similar_group_id AS similar_group_id_14,
  p1_.model3d_url AS model3d_url_15,
  p1_.price AS price_16,
  p1_.sale_price AS sale_price_17,
  p1_.currency AS currency_18,
  p1_.date_added AS date_added_19,
  p1_.date_edited AS date_edited_20,
  p2_.id AS id_21,
  p2_.image_url AS image_url_22,
  p2_.sort_order AS sort_order_23,
  b0_.product_id AS product_id_24,
  p1_.manufacturer_id AS manufacturer_id_25,
  p1_.series_id AS series_id_26,
  p2_.product_id AS product_id_27
FROM
  bestsellers b0_
  INNER JOIN product p1_ ON b0_.product_id = p1_.id
  LEFT JOIN product_image p2_ ON p1_.id = p2_.product_id
WHERE
  p1_.status = ?
ORDER BY
  b0_.sort_order ASC,
  p2_.sort_order ASC

SELECT b0_.id AS id_0, b0_.sort_order AS sort_order_1, p1_.id AS id_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.sort_order AS sort_order_5, p1_.effective_price AS effective_price_6, p1_.status AS status_7, p1_.type AS type_8, p1_.quantity AS quantity_9, p1_.options_json AS options_json_10, p1_.attribute_json AS attribute_json_11, p1_.code AS code_12, p1_.description AS description_13, p1_.similar_group_id AS similar_group_id_14, p1_.model3d_url AS model3d_url_15, p1_.price AS price_16, p1_.sale_price AS sale_price_17, p1_.currency AS currency_18, p1_.date_added AS date_added_19, p1_.date_edited AS date_edited_20, p2_.id AS id_21, p2_.image_url AS image_url_22, p2_.sort_order AS sort_order_23, b0_.product_id AS product_id_24, p1_.manufacturer_id AS manufacturer_id_25, p1_.series_id AS series_id_26, p2_.product_id AS product_id_27 FROM bestsellers b0_ INNER JOIN product p1_ ON b0_.product_id = p1_.id LEFT JOIN product_image p2_ ON p1_.id = p2_.product_id WHERE p1_.status = 1 ORDER BY b0_.sort_order ASC, p2_.sort_order 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
  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_.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
  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
  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;

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