Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.display_name AS display_name_4,
  t0.is_active AS is_active_5
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = '2';

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.is_main AS is_main_2,
  c0_.generic_value AS generic_value_3,
  c0_.high_value_threshold AS high_value_threshold_4,
  c0_.is_updated AS is_updated_5,
  c0_.is_active AS is_active_6,
  c0_.can_have_cp AS can_have_cp_7,
  c0_.slug AS slug_8,
  c0_.is_public AS is_public_9,
  c0_.generic_high_value AS generic_high_value_10,
  c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11,
  c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12,
  c0_.has_oversize AS has_oversize_13,
  c0_.google_id AS google_id_14,
  c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_15,
  c0_.parent_id AS parent_id_16,
  c0_.scan_category_group_id AS scan_category_group_id_17
FROM
  category c0_
  INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id
  AND (c1_.language_id = ?)
WHERE
  c1_.slug = ?
  AND c0_.parent_id IS NULL
  AND c0_.is_active = 1
  AND c0_.is_public = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_main AS is_main_2, c0_.generic_value AS generic_value_3, c0_.high_value_threshold AS high_value_threshold_4, c0_.is_updated AS is_updated_5, c0_.is_active AS is_active_6, c0_.can_have_cp AS can_have_cp_7, c0_.slug AS slug_8, c0_.is_public AS is_public_9, c0_.generic_high_value AS generic_high_value_10, c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11, c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12, c0_.has_oversize AS has_oversize_13, c0_.google_id AS google_id_14, c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_15, c0_.parent_id AS parent_id_16, c0_.scan_category_group_id AS scan_category_group_id_17 FROM category c0_ INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = 2) WHERE c1_.slug = '102-LK658608' AND c0_.parent_id IS NULL AND c0_.is_active = 1 AND c0_.is_public = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.price AS price_4,
  t0.images AS images_5,
  t0.msrp AS msrp_6,
  t0.discount AS discount_7,
  t0.total_units AS total_units_8,
  t0.package_units AS package_units_9,
  t0.package_format AS package_format_10,
  t0.is_cp AS is_cp_11,
  t0.manifest AS manifest_12,
  t0.weight AS weight_13,
  t0.description AS description_14,
  t0.sale_price AS sale_price_15,
  t0.cost_price AS cost_price_16,
  t0.calculated_price AS calculated_price_17,
  t0.quantity_on_hand AS quantity_on_hand_18,
  t0.quantity_pending AS quantity_pending_19,
  t0.quantity_available AS quantity_available_20,
  t0.track_inventory AS track_inventory_21,
  t0.sort_order AS sort_order_22,
  t0.is_visible AS is_visible_23,
  t0.is_allow_purchase AS is_allow_purchase_24,
  t0.product_availability AS product_availability_25,
  t0.minimum_purchase_quantity AS minimum_purchase_quantity_26,
  t0.maximum_purchase_quantity AS maximum_purchase_quantity_27,
  t0.has_free_shipping AS has_free_shipping_28,
  t0.fixed_shipping_price AS fixed_shipping_price_29,
  t0.width AS width_30,
  t0.height AS height_31,
  t0.depth AS depth_32,
  t0.brand AS brand_33,
  t0.warranty AS warranty_34,
  t0.show_product_condition AS show_product_condition_35,
  t0.code AS code_36,
  t0.tax_group AS tax_group_37,
  t0.tax_provider_code AS tax_provider_code_38,
  t0.search_keywords AS search_keywords_39,
  t0.page_title AS page_title_40,
  t0.meta_keywords AS meta_keywords_41,
  t0.meta_description AS meta_description_42,
  t0.slug AS slug_43,
  t0.cost_per_unit AS cost_per_unit_44,
  t0.is_overstock_lot AS is_overstock_lot_45,
  t0.is_add_on_lot AS is_add_on_lot_46,
  t0.is_price_drop AS is_price_drop_47,
  t0.price_dropped_at AS price_dropped_at_48,
  t0.published_at AS published_at_49,
  t0.note AS note_50,
  t0.is_listing_done AS is_listing_done_51,
  t0.package_sizes AS package_sizes_52,
  t0.is_truckload AS is_truckload_53,
  t0.search_terms AS search_terms_54,
  t0.created_at AS created_at_55,
  t0.updated_at AS updated_at_56,
  t0.supplier_id AS supplier_id_57,
  t0.warehouse_id AS warehouse_id_58,
  t0.product_condition_id AS product_condition_id_59,
  t0.category_id AS category_id_60,
  t61.id AS id_62,
  t61.msrp AS msrp_63,
  t61.price AS price_64,
  t61.nb_pallets AS nb_pallets_65,
  t61.nb_gaylords AS nb_gaylords_66,
  t61.nb_boxes AS nb_boxes_67,
  t61.number AS number_68,
  t61.manifest AS manifest_69,
  t61.manifest_html AS manifest_html_70,
  t61.is_listing_done AS is_listing_done_71,
  t61.is_deleted AS is_deleted_72,
  t61.created_by_id AS created_by_id_73,
  t61.related_front_product_id AS related_front_product_id_74,
  t75.id AS id_76,
  t75.is_basic_step_done AS is_basic_step_done_77,
  t75.is_image_step_done AS is_image_step_done_78,
  t75.is_shipping_step_done AS is_shipping_step_done_79,
  t75.is_marketing_step_done AS is_marketing_step_done_80,
  t75.front_product_id AS front_product_id_81,
  t0.created_by_id AS created_by_id_82,
  t0.published_by_id AS published_by_id_83,
  t0.created_by_customer_id AS created_by_customer_id_84,
  t0.original_lot_id AS original_lot_id_85
FROM
  front_product t0
  LEFT JOIN truckload t61 ON t61.related_front_product_id = t0.id
  LEFT JOIN front_product_listing_progress t75 ON t75.front_product_id = t0.id
WHERE
  t0.sku = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.price AS price_4, t0.images AS images_5, t0.msrp AS msrp_6, t0.discount AS discount_7, t0.total_units AS total_units_8, t0.package_units AS package_units_9, t0.package_format AS package_format_10, t0.is_cp AS is_cp_11, t0.manifest AS manifest_12, t0.weight AS weight_13, t0.description AS description_14, t0.sale_price AS sale_price_15, t0.cost_price AS cost_price_16, t0.calculated_price AS calculated_price_17, t0.quantity_on_hand AS quantity_on_hand_18, t0.quantity_pending AS quantity_pending_19, t0.quantity_available AS quantity_available_20, t0.track_inventory AS track_inventory_21, t0.sort_order AS sort_order_22, t0.is_visible AS is_visible_23, t0.is_allow_purchase AS is_allow_purchase_24, t0.product_availability AS product_availability_25, t0.minimum_purchase_quantity AS minimum_purchase_quantity_26, t0.maximum_purchase_quantity AS maximum_purchase_quantity_27, t0.has_free_shipping AS has_free_shipping_28, t0.fixed_shipping_price AS fixed_shipping_price_29, t0.width AS width_30, t0.height AS height_31, t0.depth AS depth_32, t0.brand AS brand_33, t0.warranty AS warranty_34, t0.show_product_condition AS show_product_condition_35, t0.code AS code_36, t0.tax_group AS tax_group_37, t0.tax_provider_code AS tax_provider_code_38, t0.search_keywords AS search_keywords_39, t0.page_title AS page_title_40, t0.meta_keywords AS meta_keywords_41, t0.meta_description AS meta_description_42, t0.slug AS slug_43, t0.cost_per_unit AS cost_per_unit_44, t0.is_overstock_lot AS is_overstock_lot_45, t0.is_add_on_lot AS is_add_on_lot_46, t0.is_price_drop AS is_price_drop_47, t0.price_dropped_at AS price_dropped_at_48, t0.published_at AS published_at_49, t0.note AS note_50, t0.is_listing_done AS is_listing_done_51, t0.package_sizes AS package_sizes_52, t0.is_truckload AS is_truckload_53, t0.search_terms AS search_terms_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.supplier_id AS supplier_id_57, t0.warehouse_id AS warehouse_id_58, t0.product_condition_id AS product_condition_id_59, t0.category_id AS category_id_60, t61.id AS id_62, t61.msrp AS msrp_63, t61.price AS price_64, t61.nb_pallets AS nb_pallets_65, t61.nb_gaylords AS nb_gaylords_66, t61.nb_boxes AS nb_boxes_67, t61.number AS number_68, t61.manifest AS manifest_69, t61.manifest_html AS manifest_html_70, t61.is_listing_done AS is_listing_done_71, t61.is_deleted AS is_deleted_72, t61.created_by_id AS created_by_id_73, t61.related_front_product_id AS related_front_product_id_74, t75.id AS id_76, t75.is_basic_step_done AS is_basic_step_done_77, t75.is_image_step_done AS is_image_step_done_78, t75.is_shipping_step_done AS is_shipping_step_done_79, t75.is_marketing_step_done AS is_marketing_step_done_80, t75.front_product_id AS front_product_id_81, t0.created_by_id AS created_by_id_82, t0.published_by_id AS published_by_id_83, t0.created_by_customer_id AS created_by_customer_id_84, t0.original_lot_id AS original_lot_id_85 FROM front_product t0 LEFT JOIN truckload t61 ON t61.related_front_product_id = t0.id LEFT JOIN front_product_listing_progress t75 ON t75.front_product_id = t0.id WHERE t0.sku = '102-LK658608' ORDER BY t0.id DESC LIMIT 1;