Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.price AS price_5,
  p0_.special_price AS special_price_6,
  p0_.max_discount AS max_discount_7,
  p0_.sku AS sku_8,
  p0_.featured_image AS featured_image_9,
  p0_.image_gallery AS image_gallery_10,
  p0_.tabs AS tabs_11,
  p0_.seo_meta AS seo_meta_12,
  p0_.is_publish AS is_publish_13,
  p0_.is_archived AS is_archived_14,
  p0_.is_featured AS is_featured_15,
  p0_.is_homepage_slider AS is_homepage_slider_16,
  p0_.homepage_slider_order AS homepage_slider_order_17,
  p0_.show_in_category AS show_in_category_18,
  p0_.is_highlighted AS is_highlighted_19,
  p0_.is_b2_c AS is_b2_c_20,
  p0_.created_at AS created_at_21,
  p0_.updated_at AS updated_at_22,
  p0_.documents AS documents_23,
  p0_.related_products AS related_products_24,
  p0_.stock_quantity AS stock_quantity_25,
  p1_.id AS id_26,
  p1_.title AS title_27,
  p1_.slug AS slug_28,
  p1_.subtitle AS subtitle_29,
  p1_.description AS description_30,
  p1_.position AS position_31,
  p1_.lft AS lft_32,
  p1_.lvl AS lvl_33,
  p1_.rgt AS rgt_34,
  p1_.is_publish AS is_publish_35,
  p1_.is_archived AS is_archived_36,
  p2_.id AS id_37,
  p2_.title AS title_38,
  p2_.slug AS slug_39,
  p2_.subtitle AS subtitle_40,
  p2_.description AS description_41,
  p2_.position AS position_42,
  p2_.lft AS lft_43,
  p2_.lvl AS lvl_44,
  p2_.rgt AS rgt_45,
  p2_.is_publish AS is_publish_46,
  p2_.is_archived AS is_archived_47,
  b3_.id AS id_48,
  b3_.name AS name_49,
  b3_.slug AS slug_50,
  b3_.description AS description_51,
  b3_.featured_image AS featured_image_52,
  b3_.created_at AS created_at_53,
  b3_.updated_at AS updated_at_54,
  b3_.web_url AS web_url_55,
  b3_.color AS color_56,
  b3_.is_featured AS is_featured_57,
  b3_.featured_order AS featured_order_58,
  p0_.category_id AS category_id_59,
  p0_.brand_id AS brand_id_60,
  p1_.tree_root AS tree_root_61,
  p1_.parent_id AS parent_id_62,
  p2_.tree_root AS tree_root_63,
  p2_.parent_id AS parent_id_64
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN product_category p2_ ON p1_.tree_root = p2_.id
  LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id
WHERE
  p0_.is_homepage_slider = ?
  AND p0_.is_publish = ?
  AND p0_.is_archived = ?
ORDER BY
  p0_.homepage_slider_order ASC,
  p0_.created_at DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.homepage_slider_order AS homepage_slider_order_17, p0_.show_in_category AS show_in_category_18, p0_.is_highlighted AS is_highlighted_19, p0_.is_b2_c AS is_b2_c_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, p0_.documents AS documents_23, p0_.related_products AS related_products_24, p0_.stock_quantity AS stock_quantity_25, p1_.id AS id_26, p1_.title AS title_27, p1_.slug AS slug_28, p1_.subtitle AS subtitle_29, p1_.description AS description_30, p1_.position AS position_31, p1_.lft AS lft_32, p1_.lvl AS lvl_33, p1_.rgt AS rgt_34, p1_.is_publish AS is_publish_35, p1_.is_archived AS is_archived_36, p2_.id AS id_37, p2_.title AS title_38, p2_.slug AS slug_39, p2_.subtitle AS subtitle_40, p2_.description AS description_41, p2_.position AS position_42, p2_.lft AS lft_43, p2_.lvl AS lvl_44, p2_.rgt AS rgt_45, p2_.is_publish AS is_publish_46, p2_.is_archived AS is_archived_47, b3_.id AS id_48, b3_.name AS name_49, b3_.slug AS slug_50, b3_.description AS description_51, b3_.featured_image AS featured_image_52, b3_.created_at AS created_at_53, b3_.updated_at AS updated_at_54, b3_.web_url AS web_url_55, b3_.color AS color_56, b3_.is_featured AS is_featured_57, b3_.featured_order AS featured_order_58, p0_.category_id AS category_id_59, p0_.brand_id AS brand_id_60, p1_.tree_root AS tree_root_61, p1_.parent_id AS parent_id_62, p2_.tree_root AS tree_root_63, p2_.parent_id AS parent_id_64 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id LEFT JOIN product_category p2_ ON p1_.tree_root = p2_.id LEFT JOIN brand b3_ ON p0_.brand_id = b3_.id WHERE p0_.is_homepage_slider = 1 AND p0_.is_publish = 1 AND p0_.is_archived = 0 ORDER BY p0_.homepage_slider_order ASC, p0_.created_at DESC LIMIT 5;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.description AS description_4,
  p0_.price AS price_5,
  p0_.special_price AS special_price_6,
  p0_.max_discount AS max_discount_7,
  p0_.sku AS sku_8,
  p0_.featured_image AS featured_image_9,
  p0_.image_gallery AS image_gallery_10,
  p0_.tabs AS tabs_11,
  p0_.seo_meta AS seo_meta_12,
  p0_.is_publish AS is_publish_13,
  p0_.is_archived AS is_archived_14,
  p0_.is_featured AS is_featured_15,
  p0_.is_homepage_slider AS is_homepage_slider_16,
  p0_.homepage_slider_order AS homepage_slider_order_17,
  p0_.show_in_category AS show_in_category_18,
  p0_.is_highlighted AS is_highlighted_19,
  p0_.is_b2_c AS is_b2_c_20,
  p0_.created_at AS created_at_21,
  p0_.updated_at AS updated_at_22,
  p0_.documents AS documents_23,
  p0_.related_products AS related_products_24,
  p0_.stock_quantity AS stock_quantity_25,
  p1_.id AS id_26,
  p1_.title AS title_27,
  p1_.slug AS slug_28,
  p1_.subtitle AS subtitle_29,
  p1_.description AS description_30,
  p1_.position AS position_31,
  p1_.lft AS lft_32,
  p1_.lvl AS lvl_33,
  p1_.rgt AS rgt_34,
  p1_.is_publish AS is_publish_35,
  p1_.is_archived AS is_archived_36,
  b2_.id AS id_37,
  b2_.name AS name_38,
  b2_.slug AS slug_39,
  b2_.description AS description_40,
  b2_.featured_image AS featured_image_41,
  b2_.created_at AS created_at_42,
  b2_.updated_at AS updated_at_43,
  b2_.web_url AS web_url_44,
  b2_.color AS color_45,
  b2_.is_featured AS is_featured_46,
  b2_.featured_order AS featured_order_47,
  p0_.category_id AS category_id_48,
  p0_.brand_id AS brand_id_49,
  p1_.tree_root AS tree_root_50,
  p1_.parent_id AS parent_id_51
FROM
  product p0_
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN brand b2_ ON p0_.brand_id = b2_.id
WHERE
  p0_.is_featured = ?
  AND p0_.is_publish = ?
  AND p0_.is_archived = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.homepage_slider_order AS homepage_slider_order_17, p0_.show_in_category AS show_in_category_18, p0_.is_highlighted AS is_highlighted_19, p0_.is_b2_c AS is_b2_c_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, p0_.documents AS documents_23, p0_.related_products AS related_products_24, p0_.stock_quantity AS stock_quantity_25, p1_.id AS id_26, p1_.title AS title_27, p1_.slug AS slug_28, p1_.subtitle AS subtitle_29, p1_.description AS description_30, p1_.position AS position_31, p1_.lft AS lft_32, p1_.lvl AS lvl_33, p1_.rgt AS rgt_34, p1_.is_publish AS is_publish_35, p1_.is_archived AS is_archived_36, b2_.id AS id_37, b2_.name AS name_38, b2_.slug AS slug_39, b2_.description AS description_40, b2_.featured_image AS featured_image_41, b2_.created_at AS created_at_42, b2_.updated_at AS updated_at_43, b2_.web_url AS web_url_44, b2_.color AS color_45, b2_.is_featured AS is_featured_46, b2_.featured_order AS featured_order_47, p0_.category_id AS category_id_48, p0_.brand_id AS brand_id_49, p1_.tree_root AS tree_root_50, p1_.parent_id AS parent_id_51 FROM product p0_ LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id LEFT JOIN brand b2_ ON p0_.brand_id = b2_.id WHERE p0_.is_featured = 1 AND p0_.is_publish = 1 AND p0_.is_archived = 0 ORDER BY p0_.created_at DESC LIMIT 10;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.subtitle AS subtitle_3,
  p0_.description AS description_4,
  p0_.position AS position_5,
  p0_.lft AS lft_6,
  p0_.lvl AS lvl_7,
  p0_.rgt AS rgt_8,
  p0_.is_publish AS is_publish_9,
  p0_.is_archived AS is_archived_10,
  p1_.id AS id_11,
  p1_.title AS title_12,
  p1_.slug AS slug_13,
  p1_.subtitle AS subtitle_14,
  p1_.description AS description_15,
  p1_.position AS position_16,
  p1_.lft AS lft_17,
  p1_.lvl AS lvl_18,
  p1_.rgt AS rgt_19,
  p1_.is_publish AS is_publish_20,
  p1_.is_archived AS is_archived_21,
  p0_.tree_root AS tree_root_22,
  p0_.parent_id AS parent_id_23,
  p1_.tree_root AS tree_root_24,
  p1_.parent_id AS parent_id_25
FROM
  product_category p0_
  LEFT JOIN product_category p1_ ON p0_.id = p1_.parent_id
WHERE
  p0_.parent_id IS NULL
  AND p0_.is_archived = ?
ORDER BY
  p0_.position ASC,
  p1_.position ASC,
  p1_.lft ASC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.description AS description_4, p0_.position AS position_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.is_publish AS is_publish_9, p0_.is_archived AS is_archived_10, p1_.id AS id_11, p1_.title AS title_12, p1_.slug AS slug_13, p1_.subtitle AS subtitle_14, p1_.description AS description_15, p1_.position AS position_16, p1_.lft AS lft_17, p1_.lvl AS lvl_18, p1_.rgt AS rgt_19, p1_.is_publish AS is_publish_20, p1_.is_archived AS is_archived_21, p0_.tree_root AS tree_root_22, p0_.parent_id AS parent_id_23, p1_.tree_root AS tree_root_24, p1_.parent_id AS parent_id_25 FROM product_category p0_ LEFT JOIN product_category p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.is_archived = 0 ORDER BY p0_.position ASC, p1_.position ASC, p1_.lft ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.featured_image AS featured_image_4,
  b0_.created_at AS created_at_5,
  b0_.updated_at AS updated_at_6,
  b0_.web_url AS web_url_7,
  b0_.color AS color_8,
  b0_.is_featured AS is_featured_9,
  b0_.featured_order AS featured_order_10
FROM
  brand b0_
WHERE
  b0_.is_featured = ?
ORDER BY
  b0_.featured_order ASC,
  b0_.name ASC
LIMIT
  12

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.featured_image AS featured_image_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6, b0_.web_url AS web_url_7, b0_.color AS color_8, b0_.is_featured AS is_featured_9, b0_.featured_order AS featured_order_10 FROM brand b0_ WHERE b0_.is_featured = 1 ORDER BY b0_.featured_order ASC, b0_.name ASC LIMIT 12;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.subtitle AS subtitle_3,
  p0_.short_description AS short_description_4,
  p0_.content AS content_5,
  p0_.featured_image AS featured_image_6,
  p0_.image_gallery AS image_gallery_7,
  p0_.seo_meta AS seo_meta_8,
  p0_.is_publish AS is_publish_9,
  p0_.is_featured AS is_featured_10,
  p0_.created_at AS created_at_11,
  p0_.updated_at AS updated_at_12
FROM
  post p0_
WHERE
  p0_.is_publish = ?
ORDER BY
  p0_.created_at DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.short_description AS short_description_4, p0_.content AS content_5, p0_.featured_image AS featured_image_6, p0_.image_gallery AS image_gallery_7, p0_.seo_meta AS seo_meta_8, p0_.is_publish AS is_publish_9, p0_.is_featured AS is_featured_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12 FROM post p0_ WHERE p0_.is_publish = 1 ORDER BY p0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.delivery AS delivery_6,
  t0.delivery_price AS delivery_price_7,
  t0.customer_note AS customer_note_8,
  t0.company_id AS company_id_9,
  t0.user_id AS user_id_10
FROM
  `order` t0
WHERE
  t0.id IS NULL
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery AS delivery_6, t0.delivery_price AS delivery_price_7, t0.customer_note AS customer_note_8, t0.company_id AS company_id_9, t0.user_id AS user_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = 'cart' LIMIT 1;