Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.alt AS alt_2,
  b0_.modified AS modified_3,
  b0_.created AS created_4,
  b0_.is_published AS is_published_5,
  b0_.is_default AS is_default_6,
  b0_.order_by AS order_by_7,
  b0_.caption AS caption_8,
  b0_.page_id AS page_id_9
FROM
  banners b0_
WHERE
  b0_.is_published = 1
  AND b0_.page_id = 1
ORDER BY
  b0_.is_default DESC,
  b0_.order_by ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.alt AS alt_2, b0_.modified AS modified_3, b0_.created AS created_4, b0_.is_published AS is_published_5, b0_.is_default AS is_default_6, b0_.order_by AS order_by_7, b0_.caption AS caption_8, b0_.page_id AS page_id_9 FROM banners b0_ WHERE b0_.is_published = 1 AND b0_.page_id = 1 ORDER BY b0_.is_default DESC, b0_.order_by ASC;

SELECT
  RAND() AS sclr_0,
  p0_.id AS id_1,
  p0_.is_published AS is_published_2,
  p0_.name AS name_3,
  p0_.active_ingredient AS active_ingredient_4,
  p0_.image AS image_5,
  p0_.description AS description_6,
  p0_.dosage AS dosage_7,
  p0_.size AS size_8,
  p0_.form AS form_9,
  p0_.unit AS unit_10,
  p0_.unit_price AS unit_price_11,
  p0_.stock_count AS stock_count_12,
  p0_.modified AS modified_13,
  p0_.created AS created_14,
  p0_.sku AS sku_15,
  p0_.expiry_date_required AS expiry_date_required_16,
  p0_.tags AS tags_17,
  p0_.slug AS slug_18,
  p0_.is_active AS is_active_19,
  p0_.price_from AS price_from_20,
  p0_.dosage_unit AS dosage_unit_21,
  p0_.manufacturer_ids AS manufacturer_ids_22,
  p0_.is_controlled AS is_controlled_23,
  d1_.id AS id_24,
  d1_.sku AS sku_25,
  d1_.unit_price AS unit_price_26,
  d1_.stock_count AS stock_count_27,
  d1_.expiry_date AS expiry_date_28,
  d1_.tax_exempt AS tax_exempt_29,
  d1_.modified AS modified_30,
  d1_.created AS created_31,
  d1_.is_active AS is_active_32,
  d1_.item_id AS item_id_33,
  d2_.id AS id_34,
  d2_.distributor_name AS distributor_name_35,
  d2_.logo AS logo_36,
  d2_.telephone AS telephone_37,
  d2_.email AS email_38,
  d2_.website AS website_39,
  d2_.about AS about_40,
  d2_.operating_hours AS operating_hours_41,
  d2_.refund_policy AS refund_policy_42,
  d2_.sales_tax_policy AS sales_tax_policy_43,
  d2_.is_manufaturer AS is_manufaturer_44,
  d2_.theme_id AS theme_id_45,
  d2_.modified AS modified_46,
  d2_.created AS created_47,
  d2_.po_number_prefix AS po_number_prefix_48,
  d2_.address_street AS address_street_49,
  d2_.address_city AS address_city_50,
  d2_.address_postal_code AS address_postal_code_51,
  d2_.address_state AS address_state_52,
  d2_.shipping_policy AS shipping_policy_53,
  d2_.iso_code AS iso_code_54,
  d2_.intl_code AS intl_code_55,
  d2_.hashed_email AS hashed_email_56,
  d2_.domain_name AS domain_name_57,
  d2_.is_approved AS is_approved_58,
  d2_.manager_first_name AS manager_first_name_59,
  d2_.manager_last_name AS manager_last_name_60,
  d2_.trade_license AS trade_license_61,
  d2_.trade_license_no AS trade_license_no_62,
  d2_.trade_license_exp_date AS trade_license_exp_date_63,
  d2_.manager_id_no AS manager_id_no_64,
  d2_.manager_id_exp_date AS manager_id_exp_date_65,
  c3_.id AS id_66,
  c3_.name AS name_67,
  c3_.tags AS tags_68,
  c3_.modified AS modified_69,
  c3_.created AS created_70,
  c3_.slug AS slug_71,
  c3_.product_count AS product_count_72,
  p4_.id AS id_73,
  p5_.id AS id_74,
  p5_.image AS image_75,
  p5_.modified AS modified_76,
  p5_.created AS created_77,
  p5_.is_default AS is_default_78,
  p5_.file_type AS file_type_79,
  p0_.sub_category_id AS sub_category_id_80,
  p0_.category2_id AS category2_id_81,
  p0_.category3_id AS category3_id_82,
  p0_.category_id AS category_id_83,
  d1_.distributor_id AS distributor_id_84,
  d1_.product_id AS product_id_85,
  d2_.address_country_id AS address_country_id_86,
  d2_.tracking_id AS tracking_id_87,
  p4_.products_id AS products_id_88,
  p4_.manufacturers_id AS manufacturers_id_89,
  p5_.product_id AS product_id_90
FROM
  products p0_
  INNER JOIN distributor_products d1_ ON p0_.id = d1_.product_id
  INNER JOIN distributors d2_ ON d1_.distributor_id = d2_.id
  LEFT JOIN categories1 c3_ ON p0_.category_id = c3_.id
  LEFT JOIN product_manufacturers p4_ ON p0_.id = p4_.products_id
  LEFT JOIN product_favourites p6_ ON p0_.id = p6_.product_id
  LEFT JOIN product_images p5_ ON p0_.id = p5_.product_id
WHERE
  p5_.is_default = 1
  AND p0_.is_active = 1
  AND p0_.is_published = 1
  AND d1_.unit_price > 0
  AND p0_.price_from > 0
ORDER BY
  sclr_0 ASC
LIMIT
  10

SELECT RAND() AS sclr_0, p0_.id AS id_1, p0_.is_published AS is_published_2, p0_.name AS name_3, p0_.active_ingredient AS active_ingredient_4, p0_.image AS image_5, p0_.description AS description_6, p0_.dosage AS dosage_7, p0_.size AS size_8, p0_.form AS form_9, p0_.unit AS unit_10, p0_.unit_price AS unit_price_11, p0_.stock_count AS stock_count_12, p0_.modified AS modified_13, p0_.created AS created_14, p0_.sku AS sku_15, p0_.expiry_date_required AS expiry_date_required_16, p0_.tags AS tags_17, p0_.slug AS slug_18, p0_.is_active AS is_active_19, p0_.price_from AS price_from_20, p0_.dosage_unit AS dosage_unit_21, p0_.manufacturer_ids AS manufacturer_ids_22, p0_.is_controlled AS is_controlled_23, d1_.id AS id_24, d1_.sku AS sku_25, d1_.unit_price AS unit_price_26, d1_.stock_count AS stock_count_27, d1_.expiry_date AS expiry_date_28, d1_.tax_exempt AS tax_exempt_29, d1_.modified AS modified_30, d1_.created AS created_31, d1_.is_active AS is_active_32, d1_.item_id AS item_id_33, d2_.id AS id_34, d2_.distributor_name AS distributor_name_35, d2_.logo AS logo_36, d2_.telephone AS telephone_37, d2_.email AS email_38, d2_.website AS website_39, d2_.about AS about_40, d2_.operating_hours AS operating_hours_41, d2_.refund_policy AS refund_policy_42, d2_.sales_tax_policy AS sales_tax_policy_43, d2_.is_manufaturer AS is_manufaturer_44, d2_.theme_id AS theme_id_45, d2_.modified AS modified_46, d2_.created AS created_47, d2_.po_number_prefix AS po_number_prefix_48, d2_.address_street AS address_street_49, d2_.address_city AS address_city_50, d2_.address_postal_code AS address_postal_code_51, d2_.address_state AS address_state_52, d2_.shipping_policy AS shipping_policy_53, d2_.iso_code AS iso_code_54, d2_.intl_code AS intl_code_55, d2_.hashed_email AS hashed_email_56, d2_.domain_name AS domain_name_57, d2_.is_approved AS is_approved_58, d2_.manager_first_name AS manager_first_name_59, d2_.manager_last_name AS manager_last_name_60, d2_.trade_license AS trade_license_61, d2_.trade_license_no AS trade_license_no_62, d2_.trade_license_exp_date AS trade_license_exp_date_63, d2_.manager_id_no AS manager_id_no_64, d2_.manager_id_exp_date AS manager_id_exp_date_65, c3_.id AS id_66, c3_.name AS name_67, c3_.tags AS tags_68, c3_.modified AS modified_69, c3_.created AS created_70, c3_.slug AS slug_71, c3_.product_count AS product_count_72, p4_.id AS id_73, p5_.id AS id_74, p5_.image AS image_75, p5_.modified AS modified_76, p5_.created AS created_77, p5_.is_default AS is_default_78, p5_.file_type AS file_type_79, p0_.sub_category_id AS sub_category_id_80, p0_.category2_id AS category2_id_81, p0_.category3_id AS category3_id_82, p0_.category_id AS category_id_83, d1_.distributor_id AS distributor_id_84, d1_.product_id AS product_id_85, d2_.address_country_id AS address_country_id_86, d2_.tracking_id AS tracking_id_87, p4_.products_id AS products_id_88, p4_.manufacturers_id AS manufacturers_id_89, p5_.product_id AS product_id_90 FROM products p0_ INNER JOIN distributor_products d1_ ON p0_.id = d1_.product_id INNER JOIN distributors d2_ ON d1_.distributor_id = d2_.id LEFT JOIN categories1 c3_ ON p0_.category_id = c3_.id LEFT JOIN product_manufacturers p4_ ON p0_.id = p4_.products_id LEFT JOIN product_favourites p6_ ON p0_.id = p6_.product_id LEFT JOIN product_images p5_ ON p0_.id = p5_.product_id WHERE p5_.is_default = 1 AND p0_.is_active = 1 AND p0_.is_published = 1 AND d1_.unit_price > 0 AND p0_.price_from > 0 ORDER BY sclr_0 ASC LIMIT 10;