GET https://www.rsystproject.com/triage/edit/2634/scan?actionName=confirm&actionValue=836351&ajax=1&triageScanId=5049860

Response
200 OK
Browse referrer URL
IP
142.120.162.180
Profiled on
Token
0faa63

Query Metrics

69 Database Queries
34 Different statements
168.49 ms Query time
25 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.46 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: 
[
  96
]
View formatted query    View runnable query    Explain query    View query backtrace
2 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_msrp_source = ? ORDER BY t0.position ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.12 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.19 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.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 = ?
Parameters: 
[
  "2634"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.09 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: 
[
  2634
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.11 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: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.25 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.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.id = ?
Parameters: 
[
  "5049860"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.30 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.po_id AS po_id_47, t0.product_id AS product_id_48, t0.scanned_by_id AS scanned_by_id_49, t0.imported_by_id AS imported_by_id_50, t0.analyzed_by_id AS analyzed_by_id_51, t0.supplier_id AS supplier_id_52, t0.original_preparation_lot_id AS original_preparation_lot_id_53, t0.restock_category_id AS restock_category_id_54, t0.preparation_lot_id AS preparation_lot_id_55, t0.triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0.id = ?
Parameters: 
[
  4807002
]
View formatted query    View runnable query    Explain query    View query backtrace
9 2.14 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.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.po_id AS po_id_37, t0.category_id AS category_id_38, t0.cp_product_id AS cp_product_id_39, t0.product_condition_id AS product_condition_id_40, t0.merged_with_id AS merged_with_id_41, t0.preparation_lot_id AS preparation_lot_id_42, t0.previous_po_id AS previous_po_id_43, t0.related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0.number = ? AND t0.is_closed = ? AND t0.po_id = ? LIMIT 1
Parameters: 
[
  "836351"
  0
  2634
]
View formatted query    View runnable query    Explain query    View query backtrace
10 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
11 0.30 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.lot_id AS lot_id_8, t0.product_id AS product_id_9, t0.po_id AS po_id_10, t0.manifest_item_id AS manifest_item_id_11, t0.original_lot_id AS original_lot_id_12, t0.duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0.lot_id = ? ORDER BY t0.extended DESC
Parameters: 
[
  49506
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.22 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: 
[
  4061992
]
View formatted query    View runnable query    Explain query    View query backtrace
13 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: 
[
  4061894
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.23 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: 
[
  4061861
]
View formatted query    View runnable query    Explain query    View query backtrace
15 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: 
[
  4061902
]
View formatted query    View runnable query    Explain query    View query backtrace
16 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: 
[
  4061913
]
View formatted query    View runnable query    Explain query    View query backtrace
17 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: 
[
  4061923
]
View formatted query    View runnable query    Explain query    View query backtrace
18 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: 
[
  4061906
]
View formatted query    View runnable query    Explain query    View query backtrace
19 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: 
[
  4061929
]
View formatted query    View runnable query    Explain query    View query backtrace
20 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: 
[
  4061994
]
View formatted query    View runnable query    Explain query    View query backtrace
21 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: 
[
  4061903
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.14 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: 
[
  4061979
]
View formatted query    View runnable query    Explain query    View query backtrace
23 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: 
[
  4061936
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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: 
[
  4061967
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.11 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: 
[
  4061965
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.11 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: 
[
  4061983
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.09 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: 
[
  4061981
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.05 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.13 ms 
UPDATE manifest_style SET is_active = ? WHERE id = ?
Parameters: 
[
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.12 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15987
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.07 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15988
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.11 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15989
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.10 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15990
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15991
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15992
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.05 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15993
]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15994
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.05 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15995
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15996
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15997
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.06 ms 
UPDATE triage_user SET active = ? WHERE id = ?
Parameters: 
[
  0
  15998
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.31 ms 
UPDATE triage_scan SET is_confirmed = ? WHERE id = ?
Parameters: 
[
  1
  5049860
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.16 ms 
UPDATE lot SET units = ?, estimated_sales = ?, msrp_current = ?, is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
Parameters: 
[
  69
  265.6
  1327.99
  0
  0
  "2024-12-23 14:22:33"
  49506
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.20 ms 
UPDATE lot_item SET quantity = ?, extended = ? WHERE id = ?
Parameters: 
[
  3
  104.91
  4061992
]
View formatted query    View runnable query    Explain query    View query backtrace
45 2.55 ms 
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
Parameters: 
[
  2
  5077735
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.84 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.14 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: 
[
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.23 ms 
SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.user_id = ? AND t0.is_closed = ? ORDER BY t0.id DESC LIMIT 1
Parameters: 
[
  96
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.45 ms 
UPDATE triage_scan SET confirm_request = ?, is_confirmed_lot = ?, lot_item_id = ?, scan_category_group_id = ? WHERE id = ?
Parameters: 
[
  null
  1
  4061992
  8
  5049860
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.16 ms 
UPDATE category SET is_updated = ?, is_active = ? WHERE id = ?
Parameters: 
[
  1
  1
  65
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.27 ms 
UPDATE scan_session SET nb_scans = ?, updated_at = ?, nb_scans_per_minute = ? WHERE id = ?
Parameters: 
[
  95
  "2024-12-23 14:22:33"
  4.13
  315522
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.93 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
54 1.34 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.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.po_id = ? AND t0.session_number = ? AND t0.user_id = ? ORDER BY t0.id DESC LIMIT 5
Parameters: 
[
  2634
  "ts6769b86860280"
  96
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.14 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: 
[
  28
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.12 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
57 0.24 ms 
SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.user_id = ? AND t0.is_closed = ? ORDER BY t0.id DESC LIMIT 1
Parameters: 
[
  96
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
58 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.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 = ?
Parameters: 
[
  2653
]
View formatted query    View runnable query    Explain query    View query backtrace
59 143.09 ms 
SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.is_closed = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.27 ms 
UPDATE supplier SET has_actions = ?, has_validation = ?, has_high_value = ?, is_active = ?, is_deleted = ? WHERE id = ?
Parameters: 
[
  0
  1
  0
  1
  0
  28
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.17 ms 
UPDATE `product_condition` SET is_active = ? WHERE id = ?
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.12 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
64 6.45 ms 
SELECT s0_.id AS id_0, s0_.nb_scans AS nb_scans_1, s0_.module AS module_2, s0_.is_closed AS is_closed_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.nb_scans_per_minute AS nb_scans_per_minute_6, s0_.nb_minutes AS nb_minutes_7, s0_.user_id AS user_id_8, s0_.po_id AS po_id_9, s0_.scan_category_group_id AS scan_category_group_id_10, s0_.user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_.po_id = p1_.id WHERE s0_.nb_scans > 25 AND p1_.supplier_id = ? AND s0_.scan_category_group_id = ? AND s0_.user_id = ? AND s0_.created_at >= ? AND s0_.created_at <= ? ORDER BY s0_.id DESC
Parameters: 
[
  28
  8
  96
  "2024-12-23 00:00:00"
  "2024-12-23 14:22:33"
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.81 ms 
UPDATE user SET current_scan_average = ? WHERE id = ?
Parameters: 
[
  188.52
  96
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.79 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.33 ms 
SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.po_id AS po_id_47, t0.product_id AS product_id_48, t0.scanned_by_id AS scanned_by_id_49, t0.imported_by_id AS imported_by_id_50, t0.analyzed_by_id AS analyzed_by_id_51, t0.supplier_id AS supplier_id_52, t0.original_preparation_lot_id AS original_preparation_lot_id_53, t0.restock_category_id AS restock_category_id_54, t0.preparation_lot_id AS preparation_lot_id_55, t0.triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0.id = ?
Parameters: 
[
  4807001
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.16 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: 
[
  1070735
]
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.
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.
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\ItemForAnalysis No errors.
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\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\UniqueId 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\ProductConditionDiscount 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\CategoryAction No errors.
App\Entity\SupplierProductConditionDiscount No errors.
App\Entity\SupplierCategoryValue No errors.
App\Entity\CategoryLang No errors.
App\Entity\ReportStockRotationEntry No errors.
App\Entity\Front\OrderCategoryDiscount No errors.
App\Entity\MerchantSku No errors.
App\Entity\ProductAction No errors.
App\Entity\SpecialMerchantSku No errors.
App\Entity\SpecialMsrp No errors.
App\Entity\SpecialUpc No errors.
App\Entity\SpecialName No errors.
App\Entity\ReportPerformance No errors.
App\Entity\SupplierLang No errors.
App\Entity\DataImport No errors.
App\Entity\Information\ProductConditionLang No errors.
App\Entity\ReportPerformanceEntryGroup
  • The mappings App\Entity\ReportPerformanceEntryGroup#scanCategoryGroup and App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups are inconsistent with each other.
App\Entity\Analysis\UpcItemDb No errors.
App\Entity\ProductCpPhoto No errors.
App\Entity\MarketingPhoto No errors.
App\Entity\Analysis\Synccentric No errors.
App\Entity\Front\OrderStatus
  • The field 'App\Entity\Front\OrderStatus#invoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#sendEmail' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#isLogable' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\CartProduct No errors.
App\Entity\Front\FrontProductImage No errors.
App\Entity\Front\OrderFrontProduct No errors.
App\Entity\Front\WhishListItem No errors.
App\Entity\TruckloadFrontProduct No errors.
App\Entity\Truckload No errors.
App\Entity\Front\FrontProductListingProgress No errors.
App\Entity\StockLocation No errors.
App\Entity\TruckloadIncludedFrontProduct No errors.
App\Entity\Front\Customer
  • The association App\Entity\Front\Customer#orderHistories refers to the owning side field App\Entity\Front\OrderHistory#customer which does not exist.
App\Entity\InvoiceCustomsDataDetail No errors.
App\Entity\UploadedPhoto No errors.
App\Entity\CombinedManifest No errors.
App\Entity\Front\ShippingMode
  • The association App\Entity\Front\ShippingMode#taxRuleGroup refers to the inverse side field App\Entity\Front\TaxRuleGroup#shippingModes which does not exist.
App\Entity\Front\Cart No errors.
App\Entity\Language No errors.
App\Entity\Front\Address
  • The field App\Entity\Front\Address#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Front\Order#shippingAddress does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Front\Country No errors.
App\Entity\Front\State No errors.
App\Entity\Front\OrderShippingTax No errors.
App\Entity\Front\OrderPaymentIntent No errors.
App\Entity\Front\OrderPayment No errors.
App\Entity\Front\OrderDiscount No errors.
App\Entity\Front\OrderDiscountTax No errors.
App\Entity\Front\TaxRuleGroup
  • The field 'App\Entity\Front\TaxRuleGroup#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\TaxRuleGroup#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderFrontProductTax No errors.
App\Entity\Front\OrderRefund No errors.
App\Entity\ReportStockRotation No errors.