Symfony Profiler

SELECT
  i0_.id AS id_0,
  i0_.item_id AS item_id_1,
  i0_.tax_id AS tax_id_2,
  i0_.name AS name_3,
  i0_.description AS description_4,
  i0_.manufacturer AS manufacturer_5,
  i0_.sku AS sku_6,
  i0_.rate AS rate_7,
  i0_.stock AS stock_8,
  i0_.tax_percentage AS tax_percentage_9,
  i0_.status AS status_10,
  i0_.is_discount AS is_discount_11,
  i0_.modified AS modified_12,
  i0_.created AS created_13,
  i0_.slug AS slug_14,
  i0_.is_controlled AS is_controlled_15,
  i0_.cogs AS cogs_16,
  i0_.short_expiry_discount AS short_expiry_discount_17,
  i0_.short_expiry AS short_expiry_18,
  i0_.target_gp AS target_gp_19,
  i0_.is_otc AS is_otc_20,
  i0_.related_items AS related_items_21,
  i0_.display_name AS display_name_22,
  i0_.otc_rate AS otc_rate_23,
  i0_.is_clearance AS is_clearance_24,
  i0_.total_ordered AS total_ordered_25,
  i0_.product_type AS product_type_26,
  i0_.shop_status AS shop_status_27,
  i0_.discount AS discount_28,
  i0_.base_rate AS base_rate_29,
  i0_.intro AS intro_30,
  i0_.meta_title AS meta_title_31,
  i0_.meta_description AS meta_description_32,
  i0_.url AS url_33,
  i1_.id AS id_34,
  i1_.image AS image_35,
  i1_.is_default AS is_default_36,
  i1_.modified AS modified_37,
  i1_.created AS created_38,
  i1_.order_by AS order_by_39,
  i2_.id AS id_40,
  i3_.id AS id_41,
  i3_.name AS name_42,
  i3_.modified AS modified_43,
  i3_.created AS created_44,
  i0_.special_type_id AS special_type_id_45,
  i0_.discount_type_id AS discount_type_id_46,
  i0_.brand_id AS brand_id_47,
  i1_.item_id AS item_id_48,
  i2_.items_id AS items_id_49,
  i2_.item_categories_id AS item_categories_id_50
FROM
  items i0_
  LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id
  LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id
  LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id
WHERE
  i0_.is_otc = ?
  AND i0_.manufacturer = ?
  AND i0_.status = ?
  AND i0_.shop_status = ?
  AND i0_.name NOT IN (?, ?, ?, ?, ?, ?)
  AND i0_.product_type = ?
ORDER BY
  i0_.display_name ASC

SELECT i0_.id AS id_0, i0_.item_id AS item_id_1, i0_.tax_id AS tax_id_2, i0_.name AS name_3, i0_.description AS description_4, i0_.manufacturer AS manufacturer_5, i0_.sku AS sku_6, i0_.rate AS rate_7, i0_.stock AS stock_8, i0_.tax_percentage AS tax_percentage_9, i0_.status AS status_10, i0_.is_discount AS is_discount_11, i0_.modified AS modified_12, i0_.created AS created_13, i0_.slug AS slug_14, i0_.is_controlled AS is_controlled_15, i0_.cogs AS cogs_16, i0_.short_expiry_discount AS short_expiry_discount_17, i0_.short_expiry AS short_expiry_18, i0_.target_gp AS target_gp_19, i0_.is_otc AS is_otc_20, i0_.related_items AS related_items_21, i0_.display_name AS display_name_22, i0_.otc_rate AS otc_rate_23, i0_.is_clearance AS is_clearance_24, i0_.total_ordered AS total_ordered_25, i0_.product_type AS product_type_26, i0_.shop_status AS shop_status_27, i0_.discount AS discount_28, i0_.base_rate AS base_rate_29, i0_.intro AS intro_30, i0_.meta_title AS meta_title_31, i0_.meta_description AS meta_description_32, i0_.url AS url_33, i1_.id AS id_34, i1_.image AS image_35, i1_.is_default AS is_default_36, i1_.modified AS modified_37, i1_.created AS created_38, i1_.order_by AS order_by_39, i2_.id AS id_40, i3_.id AS id_41, i3_.name AS name_42, i3_.modified AS modified_43, i3_.created AS created_44, i0_.special_type_id AS special_type_id_45, i0_.discount_type_id AS discount_type_id_46, i0_.brand_id AS brand_id_47, i1_.item_id AS item_id_48, i2_.items_id AS items_id_49, i2_.item_categories_id AS item_categories_id_50 FROM items i0_ LEFT JOIN item_images i1_ ON i0_.id = i1_.item_id LEFT JOIN items_categories i2_ ON i0_.id = i2_.items_id LEFT JOIN item_categories i3_ ON i2_.item_categories_id = i3_.id WHERE i0_.is_otc = 1 AND i0_.manufacturer = 'equine america uk' AND i0_.status = 'active' AND i0_.shop_status = 1 AND i0_.name NOT IN ('Delivery Charges - Others', 'Saracen Delivery Charges', 'Documentation Charges', 'Service Charges', 'Shipping Cost', 'Training Support') AND i0_.product_type = 'goods' ORDER BY i0_.display_name ASC;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.modified AS modified_3,
  t0.created AS created_4,
  t0.vat AS vat_5,
  t0.sub_total AS sub_total_6,
  t0.total AS total_7,
  t0.delivery_fee AS delivery_fee_8,
  t0.discount AS discount_9,
  t0.attatchment AS attatchment_10,
  t0.total_items AS total_items_11,
  t0.is_sales_order AS is_sales_order_12,
  t0.is_package AS is_package_13,
  t0.is_shipment AS is_shipment_14,
  t0.is_invoice AS is_invoice_15,
  t0.sales_order_no AS sales_order_no_16,
  t0.invoice_no AS invoice_no_17,
  t0.invoice_id AS invoice_id_18,
  t0.prescription AS prescription_19,
  t0.payment_link AS payment_link_20,
  t0.po_number AS po_number_21,
  t0.is_smart_order AS is_smart_order_22,
  t0.entity_id AS entity_id_23,
  t0.entity_user_id AS entity_user_id_24,
  t0.billing_address_id AS billing_address_id_25,
  t0.shipping_address_id AS shipping_address_id_26,
  t27.id AS id_28,
  t27.sales_order_id AS sales_order_id_29,
  t27.sales_order_number AS sales_order_number_30,
  t27.modified AS modified_31,
  t27.created AS created_32,
  t27.basket_id AS basket_id_33,
  t0.payment_type_id AS payment_type_id_34,
  t35.id AS id_36,
  t35.would_recommend AS would_recommend_37,
  t35.comments AS comments_38,
  t35.modified AS modified_39,
  t35.created AS created_40,
  t35.entity_user_id AS entity_user_id_41,
  t35.basket_id AS basket_id_42
FROM
  baskets t0
  LEFT JOIN sales_orders t27 ON t27.basket_id = t0.id
  LEFT JOIN feedback t35 ON t35.basket_id = t0.id
WHERE
  t0.entity_id = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.vat AS vat_5, t0.sub_total AS sub_total_6, t0.total AS total_7, t0.delivery_fee AS delivery_fee_8, t0.discount AS discount_9, t0.attatchment AS attatchment_10, t0.total_items AS total_items_11, t0.is_sales_order AS is_sales_order_12, t0.is_package AS is_package_13, t0.is_shipment AS is_shipment_14, t0.is_invoice AS is_invoice_15, t0.sales_order_no AS sales_order_no_16, t0.invoice_no AS invoice_no_17, t0.invoice_id AS invoice_id_18, t0.prescription AS prescription_19, t0.payment_link AS payment_link_20, t0.po_number AS po_number_21, t0.is_smart_order AS is_smart_order_22, t0.entity_id AS entity_id_23, t0.entity_user_id AS entity_user_id_24, t0.billing_address_id AS billing_address_id_25, t0.shipping_address_id AS shipping_address_id_26, t27.id AS id_28, t27.sales_order_id AS sales_order_id_29, t27.sales_order_number AS sales_order_number_30, t27.modified AS modified_31, t27.created AS created_32, t27.basket_id AS basket_id_33, t0.payment_type_id AS payment_type_id_34, t35.id AS id_36, t35.would_recommend AS would_recommend_37, t35.comments AS comments_38, t35.modified AS modified_39, t35.created AS created_40, t35.entity_user_id AS entity_user_id_41, t35.basket_id AS basket_id_42 FROM baskets t0 LEFT JOIN sales_orders t27 ON t27.basket_id = t0.id LEFT JOIN feedback t35 ON t35.basket_id = t0.id WHERE t0.entity_id = 0 AND t0.status = 'open' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.modified AS modified_3,
  t0.created AS created_4,
  t0.default_message AS default_message_5,
  t0.custom_message AS custom_message_6,
  t0.use_default_message AS use_default_message_7,
  t0.user_id AS user_id_8
FROM
  maintenance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.modified AS modified_3, t0.created AS created_4, t0.default_message AS default_message_5, t0.custom_message AS custom_message_6, t0.use_default_message AS use_default_message_7, t0.user_id AS user_id_8 FROM maintenance t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.website AS website_4,
  t0.description AS description_5,
  t0.order_by AS order_by_6,
  t0.modified AS modified_7,
  t0.created AS created_8,
  t0.is_active AS is_active_9,
  t0.api_name AS api_name_10,
  t0.is_menu AS is_menu_11,
  t0.has_otc AS has_otc_12,
  t0.has_published AS has_published_13,
  t0.banner_lg AS banner_lg_14,
  t0.banner_sm AS banner_sm_15,
  t0.featured_items AS featured_items_16,
  t0.video AS video_17,
  t0.meta_title_landing AS meta_title_landing_18,
  t0.meta_description_landing AS meta_description_landing_19,
  t0.meta_title_search AS meta_title_search_20,
  t0.meta_description_search AS meta_description_search_21
FROM
  brands t0
WHERE
  t0.api_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.website AS website_4, t0.description AS description_5, t0.order_by AS order_by_6, t0.modified AS modified_7, t0.created AS created_8, t0.is_active AS is_active_9, t0.api_name AS api_name_10, t0.is_menu AS is_menu_11, t0.has_otc AS has_otc_12, t0.has_published AS has_published_13, t0.banner_lg AS banner_lg_14, t0.banner_sm AS banner_sm_15, t0.featured_items AS featured_items_16, t0.video AS video_17, t0.meta_title_landing AS meta_title_landing_18, t0.meta_description_landing AS meta_description_landing_19, t0.meta_title_search AS meta_title_search_20, t0.meta_description_search AS meta_description_search_21 FROM brands t0 WHERE t0.api_name = 'equine america uk' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.copy AS copy_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.publish_date AS publish_date_6,
  t0.is_published AS is_published_7,
  t0.modified AS modified_8,
  t0.created AS created_9,
  t0.is_header AS is_header_10,
  t0.is_footer AS is_footer_11,
  t0.is_meta_data AS is_meta_data_12
FROM
  pages t0
WHERE
  t0.title = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.copy AS copy_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.publish_date AS publish_date_6, t0.is_published AS is_published_7, t0.modified AS modified_8, t0.created AS created_9, t0.is_header AS is_header_10, t0.is_footer AS is_footer_11, t0.is_meta_data AS is_meta_data_12 FROM pages t0 WHERE t0.title = 'Search Results' LIMIT 1;