GET https://www.rsystproject.com/triage/edit/3384/scan?actionName=code&actionValue=B0BPXN9GN6&ajax=1

Response
200 OK
Browse referrer URL
IP
142.115.246.214
Profiled on
Token
dbcf91

Query Metrics

101 Database Queries
35 Different statements
158.67 ms Query time
20 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.49 ms 
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 = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.11 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.13 ms 
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
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.16 ms 
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.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88, t0.has_batch_ids AS has_batch_ids_89, t0.status_id AS status_id_90, t0.supplier_id AS supplier_id_91, t0.product_condition_id AS product_condition_id_92, t0.manifest_style_id AS manifest_style_id_93, t0.invoice_style_id AS invoice_style_id_94, t0.supplier_invoice_state_id AS supplier_invoice_state_id_95, t0.warehouse_id AS warehouse_id_96, t0.auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0.id = ?
Parameters: 
[
  "3384"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.10 ms 
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 = ?
Parameters: 
[
  3384
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.10 ms 
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 = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.88 ms 
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
Parameters: 
[
  "B0BPXN9GN6"
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
8 20.34 ms 
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_.supplier_pallet_number AS supplier_pallet_number_44, m0_.created_at AS created_at_45, m0_.updated_at AS updated_at_46, i1_.id AS id_47, i1_.code AS code_48, i1_.is_doublon_checked AS is_doublon_checked_49, i1_.created_at AS created_at_50, i1_.updated_at AS updated_at_51, m0_.po_id AS po_id_52, m0_.product_id AS product_id_53, m0_.scanned_by_id AS scanned_by_id_54, m0_.imported_by_id AS imported_by_id_55, m0_.analyzed_by_id AS analyzed_by_id_56, m0_.supplier_id AS supplier_id_57, m0_.original_preparation_lot_id AS original_preparation_lot_id_58, m0_.restock_category_id AS restock_category_id_59, m0_.preparation_lot_id AS preparation_lot_id_60, m0_.triage_category_id AS triage_category_id_61, i1_.po_id AS po_id_62, i1_.manifest_item_id AS manifest_item_id_63, i1_.product_id AS product_id_64, i1_.supplier_id AS supplier_id_65 FROM manifest_item m0_ LEFT JOIN internal_sku i1_ ON m0_.id = i1_.manifest_item_id WHERE m0_.po_id = ? AND (m0_.code = ? OR m0_.merchant_sku = ? OR i1_.code = ?) LIMIT 1
Parameters: 
[
  3384
  "B0BPXN9GN6"
  "B0BPXN9GN6"
  "B0BPXN9GN6"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.16 ms 
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 = ?
Parameters: 
[
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.14 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.msrp AS msrp_4, t0.analyzed_at AS analyzed_at_5, t0.photo AS photo_6, t0.cp_quantity AS cp_quantity_7, t0.cp_number AS cp_number_8, t0.cp_name AS cp_name_9, t0.cp_discount AS cp_discount_10, t0.has_expiration_date AS has_expiration_date_11, t0.cp_format AS cp_format_12, t0.cp_packaged_units AS cp_packaged_units_13, t0.cp_photos AS cp_photos_14, t0.cp_weight AS cp_weight_15, t0.cp_package AS cp_package_16, t0.old_cp_number AS old_cp_number_17, t0.is_flag_preparation_done AS is_flag_preparation_done_18, t0.has_marketing_photo_request AS has_marketing_photo_request_19, t0.is_oversize AS is_oversize_20, t0.old_name AS old_name_21, t0.is_updated AS is_updated_22, t0.scraper_class AS scraper_class_23, t0.scraper_id AS scraper_id_24, t0.is_upc_checked AS is_upc_checked_25, t0.is_upc_valid AS is_upc_valid_26, t0.is_ean_checked AS is_ean_checked_27, t0.is_ean_valid AS is_ean_valid_28, t0.is_validation AS is_validation_29, t0.is_category_validation AS is_category_validation_30, t0.previous_category_id AS previous_category_id_31, t0.last_category_change_at AS last_category_change_at_32, t0.restock_category_id AS restock_category_id_33, t0.analyzed_by_id AS analyzed_by_id_34, t0.upcitemdb_id AS upcitemdb_id_35, t0.synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0.id = ?
Parameters: 
[
  1271498
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.10 ms 
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
Parameters: 
[
  55
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.generic_value AS generic_value_4, t0.high_value_threshold AS high_value_threshold_5, t0.is_updated AS is_updated_6, t0.is_active AS is_active_7, t0.can_have_cp AS can_have_cp_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.generic_high_value AS generic_high_value_11, t0.newsletter_default_footer_image AS newsletter_default_footer_image_12, t0.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13, t0.has_oversize AS has_oversize_14, t0.google_id AS google_id_15, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_16, t0.parent_id AS parent_id_17, t0.scan_category_group_id AS scan_category_group_id_18 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "CP_MIN_QUANTITY"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "CP_MIN_MSRP"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "CP_ALLOWED_PRODUCT_CONDITIONS"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.09 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.46 ms 
INSERT INTO triage_scan (session_number, code, scan_type, is_confirmed, is_generic, is_validation, is_category_validation, is_action, is_question, has_error, is_deleted, confirm_request, is_error, result_template, msrp, has_cp, cp_name, cp_number, cp_quantity, is_confirmed_lot, is_confirmed_cp, is_rejected, cp_package, show_oversize_button, batch_id_code, user_id, po_id, manifest_item_id, lot_id, action_id, triage_question_id, lot_item_id, scan_category_group_id, oversize_lot_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "ts6904f0f62cbef"
  "B0BPXN9GN6"
  "manifest"
  0
  0
  0
  0
  0
  0
  0
  0
  null
  0
  null
  null
  0
  null
  null
  null
  0
  0
  0
  null
  0
  null
  89
  3384
  null
  null
  null
  null
  null
  null
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.24 ms 
UPDATE supplier SET has_actions = ?, has_validation = ?, has_high_value = ?, is_active = ?, is_deleted = ? WHERE id = ?
Parameters: 
[
  0
  1
  1
  1
  0
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.11 ms 
UPDATE manifest_style SET is_active = ? WHERE id = ?
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.07 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19338
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.07 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19339
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19340
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.10 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19341
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.11 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19342
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.07 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  19343
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.15 ms 
UPDATE category SET is_updated = ?, is_active = ? WHERE id = ?
Parameters: 
[
  1
  1
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
27 2.57 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.14 ms 
SELECT t0.id AS id_1, t0.is_unclassified AS is_unclassified_2, t0.is_cp AS is_cp_3, t0.is_high_value AS is_high_value_4, t0.units AS units_5, t0.msrp_total AS msrp_total_6, t0.nb_lots AS nb_lots_7, t0.name AS name_8, t0.discount AS discount_9, t0.estimated_sales AS estimated_sales_10, t0.cp_quantity AS cp_quantity_11, t0.display_name AS display_name_12, t0.is_empty AS is_empty_13, t0.is_action AS is_action_14, t0.is_flag_preparation_done AS is_flag_preparation_done_15, t0.is_oversize AS is_oversize_16, t0.po_id AS po_id_17, t0.restock_category_id AS restock_category_id_18, t0.merged_with_id AS merged_with_id_19, t0.cp_product_id AS cp_product_id_20, t0.cp_manifest_item_id AS cp_manifest_item_id_21, t0.product_condition_id AS product_condition_id_22 FROM preparation_lot t0 WHERE t0.id = ?
Parameters: 
[
  31811
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.12 ms 
SELECT t0.id AS id_1, t0.value AS value_2, t0.supplier_id AS supplier_id_3, t0.product_condition_id AS product_condition_id_4, t0.category_id AS category_id_5 FROM supplier_product_condition_discount t0 WHERE t0.supplier_id = ? AND t0.product_condition_id = ? AND t0.category_id = ? LIMIT 1
Parameters: 
[
  55
  2
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
30 1.51 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.package_units AS package_units_3, t0.weight AS weight_4, t0.user AS user_5, t0.format AS format_6, t0.photos AS photos_7, t0.name AS name_8, t0.extended AS extended_9, t0.units AS units_10, t0.discount AS discount_11, t0.estimated_sales AS estimated_sales_12, t0.is_initialized AS is_initialized_13, t0.msrp_current AS msrp_current_14, t0.is_closed AS is_closed_15, t0.is_high_value AS is_high_value_16, t0.is_cp AS is_cp_17, t0.estimated_sales_min_target AS estimated_sales_min_target_18, t0.estimated_sales_max_target AS estimated_sales_max_target_19, t0.display_name AS display_name_20, t0.quantity AS quantity_21, t0.cp_quantity AS cp_quantity_22, t0.is_truckload AS is_truckload_23, t0.is_photos_compressed AS is_photos_compressed_24, t0.is_destroy AS is_destroy_25, t0.package_sizes AS package_sizes_26, t0.is_listing_done AS is_listing_done_27, t0.discount_triage AS discount_triage_28, t0.volumetric_weight AS volumetric_weight_29, t0.real_weight AS real_weight_30, t0.previous_number AS previous_number_31, t0.is_oversize AS is_oversize_32, t0.cost AS cost_33, t0.is_imported AS is_imported_34, t0.supplier_pallet_number AS supplier_pallet_number_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.po_id AS po_id_38, t0.category_id AS category_id_39, t0.cp_product_id AS cp_product_id_40, t0.product_condition_id AS product_condition_id_41, t0.merged_with_id AS merged_with_id_42, t0.preparation_lot_id AS preparation_lot_id_43, t0.previous_po_id AS previous_po_id_44, t0.related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0.po_id = ? AND t0.category_id = ? AND t0.is_high_value = ? AND t0.is_cp = ? AND t0.is_oversize = ? AND t0.is_closed = ? AND t0.product_condition_id = ? LIMIT 1
Parameters: 
[
  3384
  62
  0
  0
  0
  0
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.81 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.msrp AS msrp_3, t0.quantity AS quantity_4, t0.extended AS extended_5, t0.is_truckload AS is_truckload_6, t0.is_converted AS is_converted_7, t0.batch_id_code AS batch_id_code_8, t0.lot_id AS lot_id_9, t0.product_id AS product_id_10, t0.po_id AS po_id_11, t0.manifest_item_id AS manifest_item_id_12, t0.original_lot_id AS original_lot_id_13, t0.duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0.lot_id = ? ORDER BY t0.extended DESC
Parameters: 
[
  58722
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.20 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4779879
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4778800
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.19 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4778173
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.55 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4777767
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.19 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4779615
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.19 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4779332
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.18 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4779311
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.15 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4778602
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.12 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.71 ms 
UPDATE preparation_lot SET is_empty = ?, is_action = ? WHERE id = ?
Parameters: 
[
  0
  0
  31811
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.72 ms 
UPDATE triage_scan SET manifest_item_id = ? WHERE id = ?
Parameters: 
[
  6660599
  7193593
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.26 ms 
UPDATE lot SET is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  0
  0
  "2025-10-31 13:25:51"
  58722
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.68 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.package_units AS package_units_3, t0.weight AS weight_4, t0.user AS user_5, t0.format AS format_6, t0.photos AS photos_7, t0.name AS name_8, t0.extended AS extended_9, t0.units AS units_10, t0.discount AS discount_11, t0.estimated_sales AS estimated_sales_12, t0.is_initialized AS is_initialized_13, t0.msrp_current AS msrp_current_14, t0.is_closed AS is_closed_15, t0.is_high_value AS is_high_value_16, t0.is_cp AS is_cp_17, t0.estimated_sales_min_target AS estimated_sales_min_target_18, t0.estimated_sales_max_target AS estimated_sales_max_target_19, t0.display_name AS display_name_20, t0.quantity AS quantity_21, t0.cp_quantity AS cp_quantity_22, t0.is_truckload AS is_truckload_23, t0.is_photos_compressed AS is_photos_compressed_24, t0.is_destroy AS is_destroy_25, t0.package_sizes AS package_sizes_26, t0.is_listing_done AS is_listing_done_27, t0.discount_triage AS discount_triage_28, t0.volumetric_weight AS volumetric_weight_29, t0.real_weight AS real_weight_30, t0.previous_number AS previous_number_31, t0.is_oversize AS is_oversize_32, t0.cost AS cost_33, t0.is_imported AS is_imported_34, t0.supplier_pallet_number AS supplier_pallet_number_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.po_id AS po_id_38, t0.category_id AS category_id_39, t0.cp_product_id AS cp_product_id_40, t0.product_condition_id AS product_condition_id_41, t0.merged_with_id AS merged_with_id_42, t0.preparation_lot_id AS preparation_lot_id_43, t0.previous_po_id AS previous_po_id_44, t0.related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0.po_id = ? AND t0.category_id = ? AND t0.is_closed = ? AND t0.is_oversize = ? LIMIT 1
Parameters: 
[
  3384
  62
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.15 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.contact_main_name AS contact_main_name_4, t0.contact_main_phone AS contact_main_phone_5, t0.contact_main_extension AS contact_main_extension_6, t0.contact_main_email AS contact_main_email_7, t0.contact_director_name AS contact_director_name_8, t0.contact_director_phone AS contact_director_phone_9, t0.contact_director_extension AS contact_director_extension_10, t0.contact_director_email AS contact_director_email_11, t0.contact_supervisor_name AS contact_supervisor_name_12, t0.contact_supervisor_phone AS contact_supervisor_phone_13, t0.contact_supervisor_extension AS contact_supervisor_extension_14, t0.contact_supervisor_email AS contact_supervisor_email_15, t0.contact_shipping_name AS contact_shipping_name_16, t0.contact_shipping_phone AS contact_shipping_phone_17, t0.contact_shipping_extension AS contact_shipping_extension_18, t0.contact_shipping_email AS contact_shipping_email_19, t0.contact_billing_name AS contact_billing_name_20, t0.contact_billing_phone AS contact_billing_phone_21, t0.contact_billing_extension AS contact_billing_extension_22, t0.contact_billing_email AS contact_billing_email_23, t0.email AS email_24, t0.is_active AS is_active_25, t0.shipping_state AS shipping_state_26, t0.shipping_country AS shipping_country_27, t0.shipping_postcode AS shipping_postcode_28, t0.is_deleted AS is_deleted_29 FROM warehouse t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
47 9.17 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.msrp AS msrp_3, t0.quantity AS quantity_4, t0.extended AS extended_5, t0.is_truckload AS is_truckload_6, t0.is_converted AS is_converted_7, t0.batch_id_code AS batch_id_code_8, t0.lot_id AS lot_id_9, t0.product_id AS product_id_10, t0.po_id AS po_id_11, t0.manifest_item_id AS manifest_item_id_12, t0.original_lot_id AS original_lot_id_13, t0.duplicate_of_id AS duplicate_of_id_14 FROM lot_item t0 WHERE t0.lot_id = ? ORDER BY t0.extended DESC
Parameters: 
[
  58427
]
View formatted query    View runnable query    Explain query    View query backtrace
48 1.05 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4765144
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.94 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4756226
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.92 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4765524
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.56 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4768082
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.83 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4767044
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.77 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4771923
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.60 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4757378
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.20 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4757447
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.44 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4772889
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.70 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4775601
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.43 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4770125
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.44 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4758314
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4772785
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.43 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4770670
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.19 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4775853
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.43 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764497
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.42 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4762947
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.45 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4769716
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.19 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4756229
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4773702
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4757498
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.44 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4776040
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.73 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4769069
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.42 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4759944
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4772836
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.30 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4760368
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764408
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4778739
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764511
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.46 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764020
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4758318
]
View formatted query    View runnable query    Explain query    View query backtrace
79 0.10 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764411
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.10 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764023
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.42 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4774385
]
View formatted query    View runnable query    Explain query    View query backtrace
82 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4768678
]
View formatted query    View runnable query    Explain query    View query backtrace
83 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4780028
]
View formatted query    View runnable query    Explain query    View query backtrace
84 0.48 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4760526
]
View formatted query    View runnable query    Explain query    View query backtrace
85 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764070
]
View formatted query    View runnable query    Explain query    View query backtrace
86 0.60 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4761591
]
View formatted query    View runnable query    Explain query    View query backtrace
87 0.17 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4764095
]
View formatted query    View runnable query    Explain query    View query backtrace
88 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4770328
]
View formatted query    View runnable query    Explain query    View query backtrace
89 0.69 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4761031
]
View formatted query    View runnable query    Explain query    View query backtrace
90 0.13 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4759972
]
View formatted query    View runnable query    Explain query    View query backtrace
91 0.16 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4774375
]
View formatted query    View runnable query    Explain query    View query backtrace
92 0.44 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4772195
]
View formatted query    View runnable query    Explain query    View query backtrace
93 0.15 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4772090
]
View formatted query    View runnable query    Explain query    View query backtrace
94 0.42 ms 
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?
Parameters: 
[
  4756953
]
View formatted query    View runnable query    Explain query    View query backtrace
95 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
96 0.93 ms 
UPDATE triage_scan SET confirm_request = ?, msrp = ?, lot_id = ?, oversize_lot_id = ? WHERE id = ?
Parameters: 
[
  "911019 - 909005"
  22.22
  58722
  58427
  7193593
]
View formatted query    View runnable query    Explain query    View query backtrace
97 0.51 ms 
UPDATE lot SET units = ?, estimated_sales = ?, msrp_current = ?, is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  182
  826.36
  3305.45
  0
  0
  "2025-10-31 13:25:51"
  58427
]
View formatted query    View runnable query    Explain query    View query backtrace
98 0.13 ms 
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters: 
[
  30.8
  4777767
]
View formatted query    View runnable query    Explain query    View query backtrace
99 0.47 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
100 93.29 ms 
SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.batch_id_code AS batch_id_code_26, t0.user_id AS user_id_27, t0.po_id AS po_id_28, t0.manifest_item_id AS manifest_item_id_29, t0.lot_id AS lot_id_30, t0.action_id AS action_id_31, t0.triage_question_id AS triage_question_id_32, t0.lot_item_id AS lot_item_id_33, t0.scan_category_group_id AS scan_category_group_id_34, t0.oversize_lot_id AS oversize_lot_id_35 FROM triage_scan t0 WHERE t0.po_id = ? AND t0.session_number = ? AND t0.user_id = ? ORDER BY t0.id DESC LIMIT 5
Parameters: 
[
  3384
  "ts6904f0f62cbef"
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
101 0.14 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.position AS position_4, t0.gtm_value AS gtm_value_5, t0.facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The mappings App\Entity\User#assignedScanManifests and App\Entity\ScanManifestUser#user are inconsistent with each other.
  • The association App\Entity\User#analysedProducts refers to the owning side field App\Entity\Product#analysedBy which does not exist.
  • The association App\Entity\User#analyzedManifestItems refers to the owning side field App\Entity\ManifestItem#analysedBy which does not exist.
  • The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#userss which does not exist.
  • The mappings App\Entity\User#userMainTableSettings and App\Entity\UserMainTableSetting#user are inconsistent with each other.
App\Entity\Module No errors.
App\Entity\Warehouse
  • The mappings App\Entity\Warehouse#users and App\Entity\User#warehouse are inconsistent with each other.
App\Entity\UserGroup No errors.
App\Entity\ScanCategoryGroup
  • The association App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups refers to the owning side field App\Entity\ReportPerformanceEntryGroup#ScanCategoryGroup which does not exist.
App\Entity\ScanManifestUser
  • The association App\Entity\ScanManifestUser#user refers to the inverse side field App\Entity\User#scanManifestUsers which does not exist.
App\Entity\Product
  • The mappings App\Entity\Product#analyzedBy and App\Entity\User#analysedProducts are inconsistent with each other.
  • The mappings App\Entity\Product#internalSkus and App\Entity\InternalSku#product are inconsistent with each other.
App\Entity\ManifestItem
  • The association App\Entity\ManifestItem#po refers to the inverse side field App\Entity\Po#ManifestItems which does not exist.
  • The mappings App\Entity\ManifestItem#analyzedBy and App\Entity\User#analyzedManifestItems are inconsistent with each other.
  • The mappings App\Entity\ManifestItem#internalSkus and App\Entity\InternalSku#manifestItem are inconsistent with each other.
App\Entity\TriageUser
  • The field 'App\Entity\TriageUser#active' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\TriageScan No errors.
App\Entity\ProductUpdateLog No errors.
App\Entity\ScanSession No errors.
App\Entity\UserMainTableSetting
  • The association App\Entity\UserMainTableSetting#user refers to the inverse side field App\Entity\User#userDashboardSettings which does not exist.
App\Entity\Supplier
  • The field 'App\Entity\Supplier#hasActions' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#hasValidation' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#hasHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\ReportScanGroup No errors.
App\Entity\Front\OrderHistory No errors.
App\Entity\StockUpdate No errors.
App\Entity\Front\FrontProduct No errors.
App\Entity\StockLocationUpdate No errors.
App\Entity\UpcitemdbSource No errors.
App\Entity\Po
  • The mappings App\Entity\Po#lots and App\Entity\Lot#po are inconsistent with each other.
  • The mappings App\Entity\Po#manifestItems and App\Entity\ManifestItem#po are inconsistent with each other.
App\Entity\Information\PoStatus No errors.
App\Entity\Information\ProductCondition
  • The field 'App\Entity\Information\ProductCondition#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Information\ManifestStyle
  • The field 'App\Entity\Information\ManifestStyle#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Information\InvoiceStyle No errors.
App\Entity\Information\SupplierInvoiceState No errors.
App\Entity\Category
  • The field 'App\Entity\Category#isUpdated' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Category#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The association App\Entity\Category#mappingCategories refers to the owning side field App\Entity\MappingCategory#mainCategory which does not exist.
  • The mappings App\Entity\Category#lots and App\Entity\Lot#category are inconsistent with each other.
App\Entity\Lot
  • The field 'App\Entity\Lot#isHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Lot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The association App\Entity\Lot#po refers to the inverse side field App\Entity\Po#numbers which does not exist.
  • The association App\Entity\Lot#category refers to the inverse side field App\Entity\Category#isHighValue which does not exist.
  • The field App\Entity\Lot#triageScans is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TriageScan#lot does not contain the required 'inversedBy="triageScans"' attribute.
App\Entity\PreparationLot
  • The field 'App\Entity\PreparationLot#isEmpty' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\PreparationLot#isAction' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\PurchaseInvoice No errors.
App\Entity\LotItem No errors.
App\Entity\TruckloadLot
  • The field 'App\Entity\TruckloadLot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\InvoiceCustomsData No errors.
App\Entity\Newsletter No errors.
App\Entity\LotItemOrigin No errors.
App\Entity\BatchId No errors.
App\Entity\ImportData No errors.
App\Entity\SpecialMerchantSku No errors.
App\Entity\InternalSku
  • The association App\Entity\InternalSku#manifestItem refers to the inverse side field App\Entity\ManifestItem#uniqueIds which does not exist.
  • The association App\Entity\InternalSku#product refers to the inverse side field App\Entity\Product#uniqueIds which does not exist.
App\Entity\MerchantSku No errors.
App\Entity\MappingCategory
  • The field 'App\Entity\MappingCategory#isUnmapped' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\ProductAction No errors.
App\Entity\CategoryAction No errors.
App\Entity\SupplierProductConditionDiscount No errors.
App\Entity\SupplierCategoryValue No errors.
App\Entity\SpecialMsrp No errors.
App\Entity\SpecialUpc No errors.
App\Entity\SpecialName No errors.
App\Entity\ReportPerformance No errors.
App\Entity\ReportStockRotationEntry No errors.
App\Entity\SupplierLang No errors.
App\Entity\DataImport No errors.
App\Entity\Analysis\UpcItemDb No errors.
App\Entity\Analysis\Synccentric No errors.
App\Entity\ProductCpPhoto No errors.
App\Entity\MarketingPhoto No errors.
App\Entity\TriageCategory No errors.
App\Entity\ProductConditionDiscount No errors.
App\Entity\CategoryLang No errors.
App\Entity\Front\OrderCategoryDiscount No errors.
App\Entity\Configuration No errors.
App\Entity\Information\Action
  • The field 'App\Entity\Information\Action#isAvailableAnalysisChoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\TriageQuestion No errors.
App\Entity\LotPhoto No errors.
App\Entity\CombinedManifestLot No errors.
App\Entity\Front\WarehouseShippingMode No errors.
App\Entity\Front\CartShippingMode No errors.
App\Entity\Front\Order
  • The mappings App\Entity\Front\Order#billingAddress and App\Entity\Front\Address#orders are inconsistent with each other.
App\Entity\Location No errors.
App\Entity\Information\ProductConditionLang No errors.