Symfony Profiler

Query Metrics

90 Database Queries

38 Different statements

136.09 ms Query time

19 Invalid entities

Queries


SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.default_language AS default_language_7, t0.scan_sound AS scan_sound_8, t0.is_deleted AS is_deleted_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.main_role AS main_role_12, t0.is_allowed_continuous_po AS is_allowed_continuous_po_13, t0.current_average90 AS current_average90_14, t0.current_group_average90 AS current_group_average90_15, t0.average90_at AS average90_at_16, t0.current_scan_average AS current_scan_average_17, t0.default_module_id AS default_module_id_18, t0.warehouse_id AS warehouse_id_19, t0.user_group_id AS user_group_id_20, t0.scan_category_group_id AS scan_category_group_id_21 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_msrp_source = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_name_source = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.nb_pallet AS nb_pallet_4, t0.nb_unit AS nb_unit_5, t0.eta AS eta_6, t0.received_at AS received_at_7, t0.manifest_import AS manifest_import_8, t0.note AS note_9, t0.cost_po AS cost_po_10, t0.cost_transport AS cost_transport_11, t0.cost_customs AS cost_customs_12, t0.msrp_value AS msrp_value_13, t0.finances_selling_estimated AS finances_selling_estimated_14, t0.seal_number_provided AS seal_number_provided_15, t0.seal_number_received AS seal_number_received_16, t0.nb_unit_received AS nb_unit_received_17, t0.nb_pallet_received AS nb_pallet_received_18, t0.seal_number_na AS seal_number_na_19, t0.note_reception AS note_reception_20, t0.location AS location_21, t0.progress_step_reception AS progress_step_reception_22, t0.progress_step_scan_manifest AS progress_step_scan_manifest_23, t0.progress_step_import_manifest AS progress_step_import_manifest_24, t0.progress_step_analysis AS progress_step_analysis_25, t0.progress_step_preparation AS progress_step_preparation_26, t0.progress_step_triage AS progress_step_triage_27, t0.progress_step_photobooth AS progress_step_photobooth_28, t0.progress_step_listing AS progress_step_listing_29, t0.progress_step_conciliation AS progress_step_conciliation_30, t0.preparation_total_units AS preparation_total_units_31, t0.preparation_total_extended AS preparation_total_extended_32, t0.preparation_total_selling_extended AS preparation_total_selling_extended_33, t0.preparation_total_cps AS preparation_total_cps_34, t0.preparation_total_lots AS preparation_total_lots_35, t0.import_product_quantity AS import_product_quantity_36, t0.import_unit_quantity AS import_unit_quantity_37, t0.is_truckload AS is_truckload_38, t0.progress_step_truckload AS progress_step_truckload_39, t0.is_autoanalysis_running AS is_autoanalysis_running_40, t0.is_autoanalysis_done AS is_autoanalysis_done_41, t0.bol_supplier AS bol_supplier_42, t0.customs_description AS customs_description_43, t0.customs_country_of_origin AS customs_country_of_origin_44, t0.customs_hs_code AS customs_hs_code_45, t0.cost_production AS cost_production_46, t0.next_cp_number AS next_cp_number_47, t0.is_auto_triage AS is_auto_triage_48, t0.is_lot_import_allowed AS is_lot_import_allowed_49, t0.has_premade_lots AS has_premade_lots_50, t0.is_auto_triage_truckload AS is_auto_triage_truckload_51, t0.auto_triage_category_name AS auto_triage_category_name_52, t0.auto_triage_category_discount AS auto_triage_category_discount_53, t0.archived_at AS archived_at_54, t0.is_final AS is_final_55, t0.final_total_manifest_items AS final_total_manifest_items_56, t0.final_total_analyzed_items AS final_total_analyzed_items_57, t0.final_total_different_items AS final_total_different_items_58, t0.final_total_triage_items AS final_total_triage_items_59, t0.final_import_unit_quantity AS final_import_unit_quantity_60, t0.final_total_hours AS final_total_hours_61, t0.final_total_scans_per_hour AS final_total_scans_per_hour_62, t0.final_msrp AS final_msrp_63, t0.final_estimated_sales_listing AS final_estimated_sales_listing_64, t0.final_selling_po AS final_selling_po_65, t0.final_cog_real AS final_cog_real_66, t0.final_nb_lots AS final_nb_lots_67, t0.is_new_mappings_required AS is_new_mappings_required_68, t0.auto_analysis_start_at AS auto_analysis_start_at_69, t0.auto_analysis_end_at AS auto_analysis_end_at_70, t0.current_synccentric_campaign AS current_synccentric_campaign_71, t0.analysis_queue_priority AS analysis_queue_priority_72, t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74, t0.synccentric_export_current_page AS synccentric_export_current_page_75, t0.synccentric_export_last_page AS synccentric_export_last_page_76, t0.is_synccentric_search_required AS is_synccentric_search_required_77, t0.is_synccentric_import_running AS is_synccentric_import_running_78, t0.is_synccentric_import_done AS is_synccentric_import_done_79, t0.is_synccentric_search_running AS is_synccentric_search_running_80, t0.is_synccentric_search_done AS is_synccentric_search_done_81, t0.is_synccentric_export_running AS is_synccentric_export_running_82, t0.is_synccentric_export_done AS is_synccentric_export_done_83, t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84, t0.is_synccentric_import_started AS is_synccentric_import_started_85, t0.is_synccentric_export_started AS is_synccentric_export_started_86, t0.is_autoanalysis_started AS is_autoanalysis_started_87, t0.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 = ?
SELECT t0.id AS id_1, t0.active AS active_2, t0.last_scan_at AS last_scan_at_3, t0.po_id AS po_id_4, t0.user_id AS user_id_5 FROM triage_user t0 WHERE t0.po_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM manifest_style t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.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.batch_id_code AS batch_id_code_25, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_26, t0.is_high_value AS is_high_value_27, t0.user_id AS user_id_28, t0.po_id AS po_id_29, t0.manifest_item_id AS manifest_item_id_30, t0.lot_id AS lot_id_31, t0.action_id AS action_id_32, t0.triage_question_id AS triage_question_id_33, t0.lot_item_id AS lot_item_id_34, t0.scan_category_group_id AS scan_category_group_id_35, t0.category_id AS category_id_36 FROM triage_scan t0 WHERE t0.id = ?
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.cost AS cost_32, t0.is_imported AS is_imported_33, t0.supplier_pallet_number AS supplier_pallet_number_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
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.supplier_pallet_number AS supplier_pallet_number_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.po_id AS po_id_48, t0.product_id AS product_id_49, t0.scanned_by_id AS scanned_by_id_50, t0.imported_by_id AS imported_by_id_51, t0.analyzed_by_id AS analyzed_by_id_52, t0.supplier_id AS supplier_id_53, t0.original_preparation_lot_id AS original_preparation_lot_id_54, t0.restock_category_id AS restock_category_id_55, t0.preparation_lot_id AS preparation_lot_id_56, t0.triage_category_id AS triage_category_id_57 FROM manifest_item t0 WHERE t0.id = ?
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
"START TRANSACTION"
UPDATE manifest_style SET is_active = ? WHERE id = ?
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_user SET active = ? WHERE id = ?
UPDATE triage_scan SET is_confirmed = ?, lot_id = ? WHERE id = ?
UPDATE lot SET units = ?, estimated_sales = ?, msrp_current = ?, is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
UPDATE lot_item SET extended = ? WHERE id = ?
UPDATE lot_item SET extended = ? WHERE id = ?
UPDATE lot_item SET extended = ? WHERE id = ?
UPDATE lot_item SET quantity = ?, extended = ? WHERE id = ?
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
"COMMIT"
"START TRANSACTION"
UPDATE triage_scan SET confirm_request = ?, is_confirmed_lot = ?, lot_item_id = ? WHERE id = ?
UPDATE manifest_item SET quantity = ?, updated_at = ? WHERE id = ?
"COMMIT"
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.google_id AS google_id_14, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_15, t0.parent_id AS parent_id_16, t0.scan_category_group_id AS scan_category_group_id_17 FROM category t0 WHERE t0.id = ?
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
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 = ?
"START TRANSACTION"
INSERT INTO scan_session (nb_scans, module, is_closed, created_at, updated_at, nb_scans_per_minute, nb_minutes, user_id, po_id, scan_category_group_id, user_group_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE supplier SET has_actions = ?, has_validation = ?, has_high_value = ?, is_active = ?, is_deleted = ? WHERE id = ?
UPDATE triage_scan SET scan_category_group_id = ? WHERE id = ?
UPDATE category SET is_updated = ?, is_active = ? WHERE id = ?
UPDATE scan_session SET is_closed = ?, nb_scans_per_minute = ? WHERE id = ?
"COMMIT"
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.batch_id_code AS batch_id_code_25, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_26, t0.is_high_value AS is_high_value_27, t0.user_id AS user_id_28, t0.po_id AS po_id_29, t0.manifest_item_id AS manifest_item_id_30, t0.lot_id AS lot_id_31, t0.action_id AS action_id_32, t0.triage_question_id AS triage_question_id_33, t0.lot_item_id AS lot_item_id_34, t0.scan_category_group_id AS scan_category_group_id_35, t0.category_id AS category_id_36 FROM triage_scan t0 WHERE t0.po_id = ? AND t0.session_number = ? AND t0.user_id = ? ORDER BY t0.id DESC LIMIT 5
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 = ?
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
SELECT t0.id AS id_1, t0.date AS date_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.nb_employees AS nb_employees_5, t0.employees_rate AS employees_rate_6, t0.nb_hours AS nb_hours_7, t0.weighted_daily_performance AS weighted_daily_performance_8, t0.weighted_daily_performance_per_employee_per_hour AS weighted_daily_performance_per_employee_per_hour_9, t0.weighted_daily_performance_per_employee_per_hour_average AS weighted_daily_performance_per_employee_per_hour_average_10, t0.objective AS objective_11, t0.calculated_employees_rate AS calculated_employees_rate_12, t0.scans_per_hour90average AS scans_per_hour90average_13, t0.total_scans AS total_scans_14, t0.current_nb_hours AS current_nb_hours_15, t0.supplier_id AS supplier_id_16, t0.user_group_id AS user_group_id_17 FROM report_performance t0 WHERE t0.user_group_id IS NULL ORDER BY t0.date DESC LIMIT 1
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 = ?
"START TRANSACTION"
UPDATE user SET scan_category_group_id = ? WHERE id = ?
UPDATE `product_condition` SET is_active = ? WHERE id = ?
"COMMIT"
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
"START TRANSACTION"
UPDATE user SET current_scan_average = ? WHERE id = ?
"COMMIT"

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\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\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\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.

Symfony Profiler

GET https://www.rsystproject.com/triage/production/individual/performance

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping