Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.is_active AS is_active_3,
  t0.roles AS roles_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.default_language AS default_language_7,
  t0.scan_sound AS scan_sound_8,
  t0.is_deleted AS is_deleted_9,
  t0.firstname AS firstname_10,
  t0.lastname AS lastname_11,
  t0.main_role AS main_role_12,
  t0.is_allowed_continuous_po AS is_allowed_continuous_po_13,
  t0.current_average90 AS current_average90_14,
  t0.current_group_average90 AS current_group_average90_15,
  t0.average90_at AS average90_at_16,
  t0.current_scan_average AS current_scan_average_17,
  t0.default_module_id AS default_module_id_18,
  t0.warehouse_id AS warehouse_id_19,
  t0.user_group_id AS user_group_id_20,
  t0.scan_category_group_id AS scan_category_group_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.default_language AS default_language_7, t0.scan_sound AS scan_sound_8, t0.is_deleted AS is_deleted_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.main_role AS main_role_12, t0.is_allowed_continuous_po AS is_allowed_continuous_po_13, t0.current_average90 AS current_average90_14, t0.current_group_average90 AS current_group_average90_15, t0.average90_at AS average90_at_16, t0.current_scan_average AS current_scan_average_17, t0.default_module_id AS default_module_id_18, t0.warehouse_id AS warehouse_id_19, t0.user_group_id AS user_group_id_20, t0.scan_category_group_id AS scan_category_group_id_21 FROM user t0 WHERE t0.id = 90;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_msrp_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_msrp_source = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_name_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_name_source = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.nb_pallet AS nb_pallet_4,
  t0.nb_unit AS nb_unit_5,
  t0.eta AS eta_6,
  t0.received_at AS received_at_7,
  t0.manifest_import AS manifest_import_8,
  t0.note AS note_9,
  t0.cost_po AS cost_po_10,
  t0.cost_transport AS cost_transport_11,
  t0.cost_customs AS cost_customs_12,
  t0.msrp_value AS msrp_value_13,
  t0.finances_selling_estimated AS finances_selling_estimated_14,
  t0.seal_number_provided AS seal_number_provided_15,
  t0.seal_number_received AS seal_number_received_16,
  t0.nb_unit_received AS nb_unit_received_17,
  t0.nb_pallet_received AS nb_pallet_received_18,
  t0.seal_number_na AS seal_number_na_19,
  t0.note_reception AS note_reception_20,
  t0.location AS location_21,
  t0.progress_step_reception AS progress_step_reception_22,
  t0.progress_step_scan_manifest AS progress_step_scan_manifest_23,
  t0.progress_step_import_manifest AS progress_step_import_manifest_24,
  t0.progress_step_analysis AS progress_step_analysis_25,
  t0.progress_step_preparation AS progress_step_preparation_26,
  t0.progress_step_triage AS progress_step_triage_27,
  t0.progress_step_photobooth AS progress_step_photobooth_28,
  t0.progress_step_listing AS progress_step_listing_29,
  t0.progress_step_conciliation AS progress_step_conciliation_30,
  t0.preparation_total_units AS preparation_total_units_31,
  t0.preparation_total_extended AS preparation_total_extended_32,
  t0.preparation_total_selling_extended AS preparation_total_selling_extended_33,
  t0.preparation_total_cps AS preparation_total_cps_34,
  t0.preparation_total_lots AS preparation_total_lots_35,
  t0.import_product_quantity AS import_product_quantity_36,
  t0.import_unit_quantity AS import_unit_quantity_37,
  t0.is_truckload AS is_truckload_38,
  t0.progress_step_truckload AS progress_step_truckload_39,
  t0.is_autoanalysis_running AS is_autoanalysis_running_40,
  t0.is_autoanalysis_done AS is_autoanalysis_done_41,
  t0.bol_supplier AS bol_supplier_42,
  t0.customs_description AS customs_description_43,
  t0.customs_country_of_origin AS customs_country_of_origin_44,
  t0.customs_hs_code AS customs_hs_code_45,
  t0.cost_production AS cost_production_46,
  t0.next_cp_number AS next_cp_number_47,
  t0.is_auto_triage AS is_auto_triage_48,
  t0.is_lot_import_allowed AS is_lot_import_allowed_49,
  t0.has_premade_lots AS has_premade_lots_50,
  t0.is_auto_triage_truckload AS is_auto_triage_truckload_51,
  t0.auto_triage_category_name AS auto_triage_category_name_52,
  t0.auto_triage_category_discount AS auto_triage_category_discount_53,
  t0.archived_at AS archived_at_54,
  t0.is_final AS is_final_55,
  t0.final_total_manifest_items AS final_total_manifest_items_56,
  t0.final_total_analyzed_items AS final_total_analyzed_items_57,
  t0.final_total_different_items AS final_total_different_items_58,
  t0.final_total_triage_items AS final_total_triage_items_59,
  t0.final_import_unit_quantity AS final_import_unit_quantity_60,
  t0.final_total_hours AS final_total_hours_61,
  t0.final_total_scans_per_hour AS final_total_scans_per_hour_62,
  t0.final_msrp AS final_msrp_63,
  t0.final_estimated_sales_listing AS final_estimated_sales_listing_64,
  t0.final_selling_po AS final_selling_po_65,
  t0.final_cog_real AS final_cog_real_66,
  t0.final_nb_lots AS final_nb_lots_67,
  t0.is_new_mappings_required AS is_new_mappings_required_68,
  t0.auto_analysis_start_at AS auto_analysis_start_at_69,
  t0.auto_analysis_end_at AS auto_analysis_end_at_70,
  t0.current_synccentric_campaign AS current_synccentric_campaign_71,
  t0.analysis_queue_priority AS analysis_queue_priority_72,
  t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74,
  t0.synccentric_export_current_page AS synccentric_export_current_page_75,
  t0.synccentric_export_last_page AS synccentric_export_last_page_76,
  t0.is_synccentric_search_required AS is_synccentric_search_required_77,
  t0.is_synccentric_import_running AS is_synccentric_import_running_78,
  t0.is_synccentric_import_done AS is_synccentric_import_done_79,
  t0.is_synccentric_search_running AS is_synccentric_search_running_80,
  t0.is_synccentric_search_done AS is_synccentric_search_done_81,
  t0.is_synccentric_export_running AS is_synccentric_export_running_82,
  t0.is_synccentric_export_done AS is_synccentric_export_done_83,
  t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84,
  t0.is_synccentric_import_started AS is_synccentric_import_started_85,
  t0.is_synccentric_export_started AS is_synccentric_export_started_86,
  t0.is_autoanalysis_started AS is_autoanalysis_started_87,
  t0.status_id AS status_id_88,
  t0.supplier_id AS supplier_id_89,
  t0.product_condition_id AS product_condition_id_90,
  t0.manifest_style_id AS manifest_style_id_91,
  t0.invoice_style_id AS invoice_style_id_92,
  t0.supplier_invoice_state_id AS supplier_invoice_state_id_93,
  t0.warehouse_id AS warehouse_id_94,
  t0.auto_triage_category_id AS auto_triage_category_id_95
FROM
  po t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.nb_pallet AS nb_pallet_4, t0.nb_unit AS nb_unit_5, t0.eta AS eta_6, t0.received_at AS received_at_7, t0.manifest_import AS manifest_import_8, t0.note AS note_9, t0.cost_po AS cost_po_10, t0.cost_transport AS cost_transport_11, t0.cost_customs AS cost_customs_12, t0.msrp_value AS msrp_value_13, t0.finances_selling_estimated AS finances_selling_estimated_14, t0.seal_number_provided AS seal_number_provided_15, t0.seal_number_received AS seal_number_received_16, t0.nb_unit_received AS nb_unit_received_17, t0.nb_pallet_received AS nb_pallet_received_18, t0.seal_number_na AS seal_number_na_19, t0.note_reception AS note_reception_20, t0.location AS location_21, t0.progress_step_reception AS progress_step_reception_22, t0.progress_step_scan_manifest AS progress_step_scan_manifest_23, t0.progress_step_import_manifest AS progress_step_import_manifest_24, t0.progress_step_analysis AS progress_step_analysis_25, t0.progress_step_preparation AS progress_step_preparation_26, t0.progress_step_triage AS progress_step_triage_27, t0.progress_step_photobooth AS progress_step_photobooth_28, t0.progress_step_listing AS progress_step_listing_29, t0.progress_step_conciliation AS progress_step_conciliation_30, t0.preparation_total_units AS preparation_total_units_31, t0.preparation_total_extended AS preparation_total_extended_32, t0.preparation_total_selling_extended AS preparation_total_selling_extended_33, t0.preparation_total_cps AS preparation_total_cps_34, t0.preparation_total_lots AS preparation_total_lots_35, t0.import_product_quantity AS import_product_quantity_36, t0.import_unit_quantity AS import_unit_quantity_37, t0.is_truckload AS is_truckload_38, t0.progress_step_truckload AS progress_step_truckload_39, t0.is_autoanalysis_running AS is_autoanalysis_running_40, t0.is_autoanalysis_done AS is_autoanalysis_done_41, t0.bol_supplier AS bol_supplier_42, t0.customs_description AS customs_description_43, t0.customs_country_of_origin AS customs_country_of_origin_44, t0.customs_hs_code AS customs_hs_code_45, t0.cost_production AS cost_production_46, t0.next_cp_number AS next_cp_number_47, t0.is_auto_triage AS is_auto_triage_48, t0.is_lot_import_allowed AS is_lot_import_allowed_49, t0.has_premade_lots AS has_premade_lots_50, t0.is_auto_triage_truckload AS is_auto_triage_truckload_51, t0.auto_triage_category_name AS auto_triage_category_name_52, t0.auto_triage_category_discount AS auto_triage_category_discount_53, t0.archived_at AS archived_at_54, t0.is_final AS is_final_55, t0.final_total_manifest_items AS final_total_manifest_items_56, t0.final_total_analyzed_items AS final_total_analyzed_items_57, t0.final_total_different_items AS final_total_different_items_58, t0.final_total_triage_items AS final_total_triage_items_59, t0.final_import_unit_quantity AS final_import_unit_quantity_60, t0.final_total_hours AS final_total_hours_61, t0.final_total_scans_per_hour AS final_total_scans_per_hour_62, t0.final_msrp AS final_msrp_63, t0.final_estimated_sales_listing AS final_estimated_sales_listing_64, t0.final_selling_po AS final_selling_po_65, t0.final_cog_real AS final_cog_real_66, t0.final_nb_lots AS final_nb_lots_67, t0.is_new_mappings_required AS is_new_mappings_required_68, t0.auto_analysis_start_at AS auto_analysis_start_at_69, t0.auto_analysis_end_at AS auto_analysis_end_at_70, t0.current_synccentric_campaign AS current_synccentric_campaign_71, t0.analysis_queue_priority AS analysis_queue_priority_72, t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74, t0.synccentric_export_current_page AS synccentric_export_current_page_75, t0.synccentric_export_last_page AS synccentric_export_last_page_76, t0.is_synccentric_search_required AS is_synccentric_search_required_77, t0.is_synccentric_import_running AS is_synccentric_import_running_78, t0.is_synccentric_import_done AS is_synccentric_import_done_79, t0.is_synccentric_search_running AS is_synccentric_search_running_80, t0.is_synccentric_search_done AS is_synccentric_search_done_81, t0.is_synccentric_export_running AS is_synccentric_export_running_82, t0.is_synccentric_export_done AS is_synccentric_export_done_83, t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84, t0.is_synccentric_import_started AS is_synccentric_import_started_85, t0.is_synccentric_export_started AS is_synccentric_export_started_86, t0.is_autoanalysis_started AS is_autoanalysis_started_87, t0.status_id AS status_id_88, t0.supplier_id AS supplier_id_89, t0.product_condition_id AS product_condition_id_90, t0.manifest_style_id AS manifest_style_id_91, t0.invoice_style_id AS invoice_style_id_92, t0.supplier_invoice_state_id AS supplier_invoice_state_id_93, t0.warehouse_id AS warehouse_id_94, t0.auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0.id = '2653';

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.last_scan_at AS last_scan_at_3,
  t0.po_id AS po_id_4,
  t0.user_id AS user_id_5
FROM
  triage_user t0
WHERE
  t0.po_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.last_scan_at AS last_scan_at_3, t0.po_id AS po_id_4, t0.user_id AS user_id_5 FROM triage_user t0 WHERE t0.po_id = 2653;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  manifest_style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM manifest_style t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.action AS action_3,
  t0.supplier_id AS supplier_id_4
FROM
  special_merchant_sku t0
WHERE
  t0.sku = ?
  AND t0.supplier_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.action AS action_3, t0.supplier_id AS supplier_id_4 FROM special_merchant_sku t0 WHERE t0.sku = '685872163666' AND t0.supplier_id = 28 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.quantity AS quantity_2,
  m0_.method AS method_3,
  m0_.msrp AS msrp_4,
  m0_.name AS name_5,
  m0_.category AS category_6,
  m0_.merchant_sku AS merchant_sku_7,
  m0_.is_analyzed AS is_analyzed_8,
  m0_.analyzed_at AS analyzed_at_9,
  m0_.is_auto_analyzed AS is_auto_analyzed_10,
  m0_.converted AS converted_11,
  m0_.is_generic AS is_generic_12,
  m0_.position AS position_13,
  m0_.is_cp AS is_cp_14,
  m0_.is_high_value AS is_high_value_15,
  m0_.is_prepared AS is_prepared_16,
  m0_.preparation_cp_quantity AS preparation_cp_quantity_17,
  m0_.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_18,
  m0_.preparation_cp_total_units AS preparation_cp_total_units_19,
  m0_.preparation_cp_extended AS preparation_cp_extended_20,
  m0_.preparation_cp_discount AS preparation_cp_discount_21,
  m0_.cp_name AS cp_name_22,
  m0_.cp_display_name AS cp_display_name_23,
  m0_.preparation_cp_selling_extended AS preparation_cp_selling_extended_24,
  m0_.preparation_lot_units AS preparation_lot_units_25,
  m0_.preparation_lot_discount AS preparation_lot_discount_26,
  m0_.preparation_lot_extended AS preparation_lot_extended_27,
  m0_.preparation_lot_selling_extended AS preparation_lot_selling_extended_28,
  m0_.is_upcitemdb_error AS is_upcitemdb_error_29,
  m0_.is_already_in_database AS is_already_in_database_30,
  m0_.photo AS photo_31,
  m0_.quantity_imported AS quantity_imported_32,
  m0_.quantity_scanned AS quantity_scanned_33,
  m0_.quantity_triage AS quantity_triage_34,
  m0_.is_flag_preparation_done AS is_flag_preparation_done_35,
  m0_.premade_lot_number AS premade_lot_number_36,
  m0_.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_37,
  m0_.is_synccentric_search_required AS is_synccentric_search_required_38,
  m0_.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_39,
  m0_.is_sent_to_synccentric AS is_sent_to_synccentric_40,
  m0_.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_41,
  m0_.is_validation AS is_validation_42,
  m0_.is_skipped_for_analysis AS is_skipped_for_analysis_43,
  m0_.created_at AS created_at_44,
  m0_.updated_at AS updated_at_45,
  u1_.id AS id_46,
  u1_.code AS code_47,
  u1_.is_doublon_checked AS is_doublon_checked_48,
  m0_.po_id AS po_id_49,
  m0_.product_id AS product_id_50,
  m0_.scanned_by_id AS scanned_by_id_51,
  m0_.imported_by_id AS imported_by_id_52,
  m0_.analyzed_by_id AS analyzed_by_id_53,
  m0_.supplier_id AS supplier_id_54,
  m0_.original_preparation_lot_id AS original_preparation_lot_id_55,
  m0_.restock_category_id AS restock_category_id_56,
  m0_.preparation_lot_id AS preparation_lot_id_57,
  m0_.triage_category_id AS triage_category_id_58,
  u1_.po_id AS po_id_59,
  u1_.manifest_item_id AS manifest_item_id_60,
  u1_.product_id AS product_id_61
FROM
  manifest_item m0_
  INNER JOIN unique_id u1_ ON m0_.id = u1_.manifest_item_id
WHERE
  m0_.po_id = ?
  AND (
    m0_.code LIKE ?
    OR m0_.merchant_sku LIKE ?
    OR u1_.code LIKE ?
  )
LIMIT
  1

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.quantity AS quantity_2, m0_.method AS method_3, m0_.msrp AS msrp_4, m0_.name AS name_5, m0_.category AS category_6, m0_.merchant_sku AS merchant_sku_7, m0_.is_analyzed AS is_analyzed_8, m0_.analyzed_at AS analyzed_at_9, m0_.is_auto_analyzed AS is_auto_analyzed_10, m0_.converted AS converted_11, m0_.is_generic AS is_generic_12, m0_.position AS position_13, m0_.is_cp AS is_cp_14, m0_.is_high_value AS is_high_value_15, m0_.is_prepared AS is_prepared_16, m0_.preparation_cp_quantity AS preparation_cp_quantity_17, m0_.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_18, m0_.preparation_cp_total_units AS preparation_cp_total_units_19, m0_.preparation_cp_extended AS preparation_cp_extended_20, m0_.preparation_cp_discount AS preparation_cp_discount_21, m0_.cp_name AS cp_name_22, m0_.cp_display_name AS cp_display_name_23, m0_.preparation_cp_selling_extended AS preparation_cp_selling_extended_24, m0_.preparation_lot_units AS preparation_lot_units_25, m0_.preparation_lot_discount AS preparation_lot_discount_26, m0_.preparation_lot_extended AS preparation_lot_extended_27, m0_.preparation_lot_selling_extended AS preparation_lot_selling_extended_28, m0_.is_upcitemdb_error AS is_upcitemdb_error_29, m0_.is_already_in_database AS is_already_in_database_30, m0_.photo AS photo_31, m0_.quantity_imported AS quantity_imported_32, m0_.quantity_scanned AS quantity_scanned_33, m0_.quantity_triage AS quantity_triage_34, m0_.is_flag_preparation_done AS is_flag_preparation_done_35, m0_.premade_lot_number AS premade_lot_number_36, m0_.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_37, m0_.is_synccentric_search_required AS is_synccentric_search_required_38, m0_.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_39, m0_.is_sent_to_synccentric AS is_sent_to_synccentric_40, m0_.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_41, m0_.is_validation AS is_validation_42, m0_.is_skipped_for_analysis AS is_skipped_for_analysis_43, m0_.created_at AS created_at_44, m0_.updated_at AS updated_at_45, u1_.id AS id_46, u1_.code AS code_47, u1_.is_doublon_checked AS is_doublon_checked_48, m0_.po_id AS po_id_49, m0_.product_id AS product_id_50, m0_.scanned_by_id AS scanned_by_id_51, m0_.imported_by_id AS imported_by_id_52, m0_.analyzed_by_id AS analyzed_by_id_53, m0_.supplier_id AS supplier_id_54, m0_.original_preparation_lot_id AS original_preparation_lot_id_55, m0_.restock_category_id AS restock_category_id_56, m0_.preparation_lot_id AS preparation_lot_id_57, m0_.triage_category_id AS triage_category_id_58, u1_.po_id AS po_id_59, u1_.manifest_item_id AS manifest_item_id_60, u1_.product_id AS product_id_61 FROM manifest_item m0_ INNER JOIN unique_id u1_ ON m0_.id = u1_.manifest_item_id WHERE m0_.po_id = 2653 AND (m0_.code LIKE '685872163666' OR m0_.merchant_sku LIKE '685872163666' OR u1_.code LIKE '685872163666') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.has_actions AS has_actions_3,
  t0.has_validation AS has_validation_4,
  t0.has_high_value AS has_high_value_5,
  t0.is_active AS is_active_6,
  t0.has_scrapper AS has_scrapper_7,
  t0.sources_upc AS sources_upc_8,
  t0.sources_merchant_sku AS sources_merchant_sku_9,
  t0.sources_category AS sources_category_10,
  t0.sources_name AS sources_name_11,
  t0.sources_msrp AS sources_msrp_12,
  t0.sources_photo AS sources_photo_13,
  t0.sources_action AS sources_action_14,
  t0.is_required_upc AS is_required_upc_15,
  t0.is_required_merchant_sku AS is_required_merchant_sku_16,
  t0.is_required_category AS is_required_category_17,
  t0.is_required_name AS is_required_name_18,
  t0.is_required_msrp AS is_required_msrp_19,
  t0.is_required_photo AS is_required_photo_20,
  t0.is_required_action AS is_required_action_21,
  t0.public_name AS public_name_22,
  t0.is_deleted AS is_deleted_23,
  t0.product_generic_link AS product_generic_link_24,
  t0.billing_name AS billing_name_25,
  t0.billing_address AS billing_address_26,
  t0.tax_name1 AS tax_name1_27,
  t0.tax_rate1 AS tax_rate1_28,
  t0.tax_name2 AS tax_name2_29,
  t0.tax_rate2 AS tax_rate2_30,
  t0.tax_number1 AS tax_number1_31,
  t0.tax_number2 AS tax_number2_32,
  t0.tax_currency AS tax_currency_33,
  t0.weight_per_pallet_feet AS weight_per_pallet_feet_34,
  t0.has_continuous_po AS has_continuous_po_35,
  t0.newsletter_default_subject AS newsletter_default_subject_36,
  t0.newsletter_default_preview_text AS newsletter_default_preview_text_37,
  t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38,
  t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39,
  t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40,
  t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41,
  t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42,
  t0.scraper_class AS scraper_class_43,
  t0.has_splited_scraper AS has_splited_scraper_44,
  t0.has_synccentric_data AS has_synccentric_data_45,
  t0.has_upcitemdb_data AS has_upcitemdb_data_46,
  t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47,
  t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48,
  t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49,
  t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50,
  t0.user_group_id AS user_group_id_51
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_actions AS has_actions_3, t0.has_validation AS has_validation_4, t0.has_high_value AS has_high_value_5, t0.is_active AS is_active_6, t0.has_scrapper AS has_scrapper_7, t0.sources_upc AS sources_upc_8, t0.sources_merchant_sku AS sources_merchant_sku_9, t0.sources_category AS sources_category_10, t0.sources_name AS sources_name_11, t0.sources_msrp AS sources_msrp_12, t0.sources_photo AS sources_photo_13, t0.sources_action AS sources_action_14, t0.is_required_upc AS is_required_upc_15, t0.is_required_merchant_sku AS is_required_merchant_sku_16, t0.is_required_category AS is_required_category_17, t0.is_required_name AS is_required_name_18, t0.is_required_msrp AS is_required_msrp_19, t0.is_required_photo AS is_required_photo_20, t0.is_required_action AS is_required_action_21, t0.public_name AS public_name_22, t0.is_deleted AS is_deleted_23, t0.product_generic_link AS product_generic_link_24, t0.billing_name AS billing_name_25, t0.billing_address AS billing_address_26, t0.tax_name1 AS tax_name1_27, t0.tax_rate1 AS tax_rate1_28, t0.tax_name2 AS tax_name2_29, t0.tax_rate2 AS tax_rate2_30, t0.tax_number1 AS tax_number1_31, t0.tax_number2 AS tax_number2_32, t0.tax_currency AS tax_currency_33, t0.weight_per_pallet_feet AS weight_per_pallet_feet_34, t0.has_continuous_po AS has_continuous_po_35, t0.newsletter_default_subject AS newsletter_default_subject_36, t0.newsletter_default_preview_text AS newsletter_default_preview_text_37, t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38, t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39, t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40, t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41, t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42, t0.scraper_class AS scraper_class_43, t0.has_splited_scraper AS has_splited_scraper_44, t0.has_synccentric_data AS has_synccentric_data_45, t0.has_upcitemdb_data AS has_upcitemdb_data_46, t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47, t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48, t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49, t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50, t0.user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0.id = 28;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.name AS name_2,
  p0_.msrp AS msrp_3,
  p0_.analyzed_at AS analyzed_at_4,
  p0_.photo AS photo_5,
  p0_.cp_quantity AS cp_quantity_6,
  p0_.cp_number AS cp_number_7,
  p0_.cp_name AS cp_name_8,
  p0_.cp_discount AS cp_discount_9,
  p0_.has_expiration_date AS has_expiration_date_10,
  p0_.cp_format AS cp_format_11,
  p0_.cp_packaged_units AS cp_packaged_units_12,
  p0_.cp_photos AS cp_photos_13,
  p0_.cp_weight AS cp_weight_14,
  p0_.cp_package AS cp_package_15,
  p0_.old_cp_number AS old_cp_number_16,
  p0_.is_flag_preparation_done AS is_flag_preparation_done_17,
  p0_.has_marketing_photo_request AS has_marketing_photo_request_18,
  p0_.is_oversize AS is_oversize_19,
  p0_.old_name AS old_name_20,
  p0_.is_updated AS is_updated_21,
  p0_.scraper_class AS scraper_class_22,
  p0_.scraper_id AS scraper_id_23,
  p0_.is_upc_checked AS is_upc_checked_24,
  p0_.is_upc_valid AS is_upc_valid_25,
  p0_.is_ean_checked AS is_ean_checked_26,
  p0_.is_ean_valid AS is_ean_valid_27,
  p0_.is_validation AS is_validation_28,
  p0_.is_category_validation AS is_category_validation_29,
  p0_.previous_category_id AS previous_category_id_30,
  p0_.last_category_change_at AS last_category_change_at_31,
  p0_.restock_category_id AS restock_category_id_32,
  p0_.analyzed_by_id AS analyzed_by_id_33,
  p0_.upcitemdb_id AS upcitemdb_id_34,
  p0_.synccentric_id AS synccentric_id_35
FROM
  product p0_
WHERE
  p0_.code = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.msrp AS msrp_3, p0_.analyzed_at AS analyzed_at_4, p0_.photo AS photo_5, p0_.cp_quantity AS cp_quantity_6, p0_.cp_number AS cp_number_7, p0_.cp_name AS cp_name_8, p0_.cp_discount AS cp_discount_9, p0_.has_expiration_date AS has_expiration_date_10, p0_.cp_format AS cp_format_11, p0_.cp_packaged_units AS cp_packaged_units_12, p0_.cp_photos AS cp_photos_13, p0_.cp_weight AS cp_weight_14, p0_.cp_package AS cp_package_15, p0_.old_cp_number AS old_cp_number_16, p0_.is_flag_preparation_done AS is_flag_preparation_done_17, p0_.has_marketing_photo_request AS has_marketing_photo_request_18, p0_.is_oversize AS is_oversize_19, p0_.old_name AS old_name_20, p0_.is_updated AS is_updated_21, p0_.scraper_class AS scraper_class_22, p0_.scraper_id AS scraper_id_23, p0_.is_upc_checked AS is_upc_checked_24, p0_.is_upc_valid AS is_upc_valid_25, p0_.is_ean_checked AS is_ean_checked_26, p0_.is_ean_valid AS is_ean_valid_27, p0_.is_validation AS is_validation_28, p0_.is_category_validation AS is_category_validation_29, p0_.previous_category_id AS previous_category_id_30, p0_.last_category_change_at AS last_category_change_at_31, p0_.restock_category_id AS restock_category_id_32, p0_.analyzed_by_id AS analyzed_by_id_33, p0_.upcitemdb_id AS upcitemdb_id_34, p0_.synccentric_id AS synccentric_id_35 FROM product p0_ WHERE p0_.code = '685872163666' ORDER BY p0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.supplier_id AS supplier_id_2,
  t0.restock_category_id AS restock_category_id_3,
  t0.triage_category_id AS triage_category_id_4
FROM
  triage_category t0
WHERE
  t0.supplier_id = ?
  AND t0.restock_category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.supplier_id AS supplier_id_2, t0.restock_category_id AS restock_category_id_3, t0.triage_category_id AS triage_category_id_4 FROM triage_category t0 WHERE t0.supplier_id = 28 AND t0.restock_category_id = 155 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'CP_MIN_QUANTITY' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = 'CP_MIN_MSRP' LIMIT 1;