Symfony Profiler

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.sku AS sku_2,
  f0_.price AS price_3,
  f0_.images AS images_4,
  f0_.msrp AS msrp_5,
  f0_.discount AS discount_6,
  f0_.total_units AS total_units_7,
  f0_.package_units AS package_units_8,
  f0_.package_format AS package_format_9,
  f0_.is_cp AS is_cp_10,
  f0_.manifest AS manifest_11,
  f0_.weight AS weight_12,
  f0_.description AS description_13,
  f0_.sale_price AS sale_price_14,
  f0_.cost_price AS cost_price_15,
  f0_.calculated_price AS calculated_price_16,
  f0_.quantity_on_hand AS quantity_on_hand_17,
  f0_.quantity_pending AS quantity_pending_18,
  f0_.quantity_available AS quantity_available_19,
  f0_.track_inventory AS track_inventory_20,
  f0_.sort_order AS sort_order_21,
  f0_.is_visible AS is_visible_22,
  f0_.is_allow_purchase AS is_allow_purchase_23,
  f0_.product_availability AS product_availability_24,
  f0_.minimum_purchase_quantity AS minimum_purchase_quantity_25,
  f0_.maximum_purchase_quantity AS maximum_purchase_quantity_26,
  f0_.has_free_shipping AS has_free_shipping_27,
  f0_.fixed_shipping_price AS fixed_shipping_price_28,
  f0_.width AS width_29,
  f0_.height AS height_30,
  f0_.depth AS depth_31,
  f0_.brand AS brand_32,
  f0_.warranty AS warranty_33,
  f0_.show_product_condition AS show_product_condition_34,
  f0_.code AS code_35,
  f0_.tax_group AS tax_group_36,
  f0_.tax_provider_code AS tax_provider_code_37,
  f0_.search_keywords AS search_keywords_38,
  f0_.page_title AS page_title_39,
  f0_.meta_keywords AS meta_keywords_40,
  f0_.meta_description AS meta_description_41,
  f0_.slug AS slug_42,
  f0_.cost_per_unit AS cost_per_unit_43,
  f0_.is_overstock_lot AS is_overstock_lot_44,
  f0_.is_add_on_lot AS is_add_on_lot_45,
  f0_.is_price_drop AS is_price_drop_46,
  f0_.price_dropped_at AS price_dropped_at_47,
  f0_.published_at AS published_at_48,
  f0_.note AS note_49,
  f0_.is_listing_done AS is_listing_done_50,
  f0_.package_sizes AS package_sizes_51,
  f0_.is_truckload AS is_truckload_52,
  f0_.search_terms AS search_terms_53,
  f0_.created_at AS created_at_54,
  f0_.updated_at AS updated_at_55,
  f0_.supplier_id AS supplier_id_56,
  f0_.warehouse_id AS warehouse_id_57,
  f0_.product_condition_id AS product_condition_id_58,
  f0_.category_id AS category_id_59,
  f0_.created_by_id AS created_by_id_60,
  f0_.published_by_id AS published_by_id_61,
  f0_.created_by_customer_id AS created_by_customer_id_62,
  f0_.original_lot_id AS original_lot_id_63
FROM
  front_product f0_
WHERE
  f0_.is_visible = 1
  AND f0_.is_allow_purchase = 1
  AND f0_.quantity_available > 0
ORDER BY
  f0_.id DESC
LIMIT
  48

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.sku AS sku_2, f0_.price AS price_3, f0_.images AS images_4, f0_.msrp AS msrp_5, f0_.discount AS discount_6, f0_.total_units AS total_units_7, f0_.package_units AS package_units_8, f0_.package_format AS package_format_9, f0_.is_cp AS is_cp_10, f0_.manifest AS manifest_11, f0_.weight AS weight_12, f0_.description AS description_13, f0_.sale_price AS sale_price_14, f0_.cost_price AS cost_price_15, f0_.calculated_price AS calculated_price_16, f0_.quantity_on_hand AS quantity_on_hand_17, f0_.quantity_pending AS quantity_pending_18, f0_.quantity_available AS quantity_available_19, f0_.track_inventory AS track_inventory_20, f0_.sort_order AS sort_order_21, f0_.is_visible AS is_visible_22, f0_.is_allow_purchase AS is_allow_purchase_23, f0_.product_availability AS product_availability_24, f0_.minimum_purchase_quantity AS minimum_purchase_quantity_25, f0_.maximum_purchase_quantity AS maximum_purchase_quantity_26, f0_.has_free_shipping AS has_free_shipping_27, f0_.fixed_shipping_price AS fixed_shipping_price_28, f0_.width AS width_29, f0_.height AS height_30, f0_.depth AS depth_31, f0_.brand AS brand_32, f0_.warranty AS warranty_33, f0_.show_product_condition AS show_product_condition_34, f0_.code AS code_35, f0_.tax_group AS tax_group_36, f0_.tax_provider_code AS tax_provider_code_37, f0_.search_keywords AS search_keywords_38, f0_.page_title AS page_title_39, f0_.meta_keywords AS meta_keywords_40, f0_.meta_description AS meta_description_41, f0_.slug AS slug_42, f0_.cost_per_unit AS cost_per_unit_43, f0_.is_overstock_lot AS is_overstock_lot_44, f0_.is_add_on_lot AS is_add_on_lot_45, f0_.is_price_drop AS is_price_drop_46, f0_.price_dropped_at AS price_dropped_at_47, f0_.published_at AS published_at_48, f0_.note AS note_49, f0_.is_listing_done AS is_listing_done_50, f0_.package_sizes AS package_sizes_51, f0_.is_truckload AS is_truckload_52, f0_.search_terms AS search_terms_53, f0_.created_at AS created_at_54, f0_.updated_at AS updated_at_55, f0_.supplier_id AS supplier_id_56, f0_.warehouse_id AS warehouse_id_57, f0_.product_condition_id AS product_condition_id_58, f0_.category_id AS category_id_59, f0_.created_by_id AS created_by_id_60, f0_.published_by_id AS published_by_id_61, f0_.created_by_customer_id AS created_by_customer_id_62, f0_.original_lot_id AS original_lot_id_63 FROM front_product f0_ WHERE f0_.is_visible = 1 AND f0_.is_allow_purchase = 1 AND f0_.quantity_available > 0 ORDER BY f0_.id DESC LIMIT 48;

SELECT
  t0.id AS id_1,
  t0.msrp AS msrp_2,
  t0.price AS price_3,
  t0.nb_pallets AS nb_pallets_4,
  t0.nb_gaylords AS nb_gaylords_5,
  t0.nb_boxes AS nb_boxes_6,
  t0.number AS number_7,
  t0.manifest AS manifest_8,
  t0.manifest_html AS manifest_html_9,
  t0.is_listing_done AS is_listing_done_10,
  t0.is_deleted AS is_deleted_11,
  t0.created_by_id AS created_by_id_12,
  t0.related_front_product_id AS related_front_product_id_13
FROM
  truckload t0
WHERE
  t0.related_front_product_id = ?

SELECT t0.id AS id_1, t0.msrp AS msrp_2, t0.price AS price_3, t0.nb_pallets AS nb_pallets_4, t0.nb_gaylords AS nb_gaylords_5, t0.nb_boxes AS nb_boxes_6, t0.number AS number_7, t0.manifest AS manifest_8, t0.manifest_html AS manifest_html_9, t0.is_listing_done AS is_listing_done_10, t0.is_deleted AS is_deleted_11, t0.created_by_id AS created_by_id_12, t0.related_front_product_id AS related_front_product_id_13 FROM truckload t0 WHERE t0.related_front_product_id = 50315;

SELECT
  t0.id AS id_1,
  t0.is_basic_step_done AS is_basic_step_done_2,
  t0.is_image_step_done AS is_image_step_done_3,
  t0.is_shipping_step_done AS is_shipping_step_done_4,
  t0.is_marketing_step_done AS is_marketing_step_done_5,
  t0.front_product_id AS front_product_id_6
FROM
  front_product_listing_progress t0
WHERE
  t0.front_product_id = ?

SELECT t0.id AS id_1, t0.is_basic_step_done AS is_basic_step_done_2, t0.is_image_step_done AS is_image_step_done_3, t0.is_shipping_step_done AS is_shipping_step_done_4, t0.is_marketing_step_done AS is_marketing_step_done_5, t0.front_product_id AS front_product_id_6 FROM front_product_listing_progress t0 WHERE t0.front_product_id = 50315;