Query Metrics
200
Database Queries
37
Different statements
126.51 ms
Query time
25
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
93.39 ms (73.82%) |
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 = ?
Parameters:
[
0
]
|
||||||||||||||||||||||||||||||||||
10.10 ms (7.98%) |
1 |
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 6 95 "2024-12-24 00:00:00" "2024-12-24 11:45:16" ] |
||||||||||||||||||||||||||||||||||
7.02 ms (5.55%) |
130 |
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:
[
4063641
]
|
||||||||||||||||||||||||||||||||||
3.10 ms (2.45%) |
4 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
2.69 ms (2.13%) |
1 |
UPDATE lot_item_origin SET quantity = ? WHERE id = ?
Parameters:
[ 41 5081390 ]
|
||||||||||||||||||||||||||||||||||
1.07 ms (0.84%) |
12 |
UPDATE lot_item SET extended = ? WHERE id = ?
Parameters:
[ 147.36 4058295 ]
|
||||||||||||||||||||||||||||||||||
1.06 ms (0.84%) |
5 |
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:
[
4815291
]
|
||||||||||||||||||||||||||||||||||
0.83 ms (0.66%) |
12 |
UPDATE triage_user SET active = ? WHERE id = ?
Parameters:
[ 0 16038 ]
|
||||||||||||||||||||||||||||||||||
0.68 ms (0.54%) |
1 |
UPDATE user SET current_scan_average = ? WHERE id = ?
Parameters:
[ 266.63 95 ] |
||||||||||||||||||||||||||||||||||
0.65 ms (0.51%) |
1 |
UPDATE triage_scan SET is_confirmed = ?, oversize_lot_id = ? WHERE id = ?
Parameters:
[ 1 null 5058156 ]
|
||||||||||||||||||||||||||||||||||
0.52 ms (0.41%) |
1 |
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:
[ 2655 "ts676adcf87f001" 95 ]
|
||||||||||||||||||||||||||||||||||
0.45 ms (0.35%) |
1 |
UPDATE scan_session SET nb_scans = ?, updated_at = ?, nb_scans_per_minute = ? WHERE id = ?
Parameters:
[ 181 "2024-12-24 11:45:16" 5.03 315611 ]
|
||||||||||||||||||||||||||||||||||
0.40 ms (0.31%) |
2 |
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:
[ 95 0 ]
|
||||||||||||||||||||||||||||||||||
0.39 ms (0.31%) |
4 |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
0.36 ms (0.28%) |
1 |
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.id = ?
Parameters:
[
49433
]
|
||||||||||||||||||||||||||||||||||
0.33 ms (0.26%) |
1 |
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:
[ "838416" 0 2655 ]
|
||||||||||||||||||||||||||||||||||
0.31 ms (0.24%) |
1 |
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:
[
"5058156"
]
|
||||||||||||||||||||||||||||||||||
0.30 ms (0.24%) |
1 |
UPDATE triage_scan SET confirm_request = ?, is_confirmed_lot = ?, lot_item_id = ?, scan_category_group_id = ? WHERE id = ?
Parameters:
[ null 1 4063641 6 5058156 ]
|
||||||||||||||||||||||||||||||||||
0.29 ms (0.23%) |
1 |
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:
[
95
]
|
||||||||||||||||||||||||||||||||||
0.28 ms (0.22%) |
1 |
UPDATE supplier SET has_actions = ?, has_validation = ?, has_high_value = ?, is_active = ?, is_deleted = ? WHERE id = ?
Parameters:
[ 0 1 0 1 0 28 ] |
||||||||||||||||||||||||||||||||||
0.22 ms (0.17%) |
1 |
UPDATE lot SET units = ?, estimated_sales = ?, msrp_current = ?, is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1016 640.37 6403.73 0 0 "2024-12-24 11:45:16" 49413 ]
|
||||||||||||||||||||||||||||||||||
0.19 ms (0.15%) |
1 |
UPDATE `product_condition` SET is_active = ? WHERE id = ?
Parameters:
[ 1 2 ] |
||||||||||||||||||||||||||||||||||
0.19 ms (0.15%) |
1 |
UPDATE category SET is_updated = ?, is_active = ? WHERE id = ?
Parameters:
[ 1 1 3 ]
|
||||||||||||||||||||||||||||||||||
0.18 ms (0.14%) |
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 = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||||||||||
0.17 ms (0.13%) |
2 |
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:
[
49413
]
|
||||||||||||||||||||||||||||||||||
0.17 ms (0.13%) |
1 |
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:
[
"2655"
]
|
||||||||||||||||||||||||||||||||||
0.16 ms (0.13%) |
1 |
UPDATE lot_item SET quantity = ?, extended = ? WHERE id = ?
Parameters:
[ 41 141.86 4063641 ]
|
||||||||||||||||||||||||||||||||||
0.13 ms (0.10%) |
1 |
UPDATE manifest_style SET is_active = ? WHERE id = ?
Parameters:
[ 1 4 ]
|
||||||||||||||||||||||||||||||||||
0.12 ms (0.09%) |
1 |
UPDATE lot SET is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?
Parameters:
[ 0 0 "2024-12-24 11:45:16" 49433 ]
|
||||||||||||||||||||||||||||||||||
0.12 ms (0.09%) |
1 |
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:
[
1027747
]
|
||||||||||||||||||||||||||||||||||
0.11 ms (0.09%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
0.11 ms (0.09%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
0.10 ms (0.08%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
0.09 ms (0.07%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
0.09 ms (0.07%) |
1 |
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
]
|
||||||||||||||||||||||||||||||||||
0.08 ms (0.06%) |
1 |
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:
[
3
]
|
||||||||||||||||||||||||||||||||||
0.07 ms (0.06%) |
1 |
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:
[
2655
]
|
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 |
|
App\Entity\Module | No errors. |
App\Entity\Warehouse |
|
App\Entity\UserGroup | No errors. |
App\Entity\ScanCategoryGroup |
|
App\Entity\ScanManifestUser |
|
App\Entity\Product |
|
App\Entity\ManifestItem |
|
App\Entity\TriageUser |
|
App\Entity\TriageScan | No errors. |
App\Entity\ProductUpdateLog | No errors. |
App\Entity\ScanSession | No errors. |
App\Entity\UserMainTableSetting |
|
App\Entity\Supplier |
|
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 |
|
App\Entity\Information\PoStatus | No errors. |
App\Entity\Information\ProductCondition |
|
App\Entity\Information\ManifestStyle |
|
App\Entity\Information\InvoiceStyle | No errors. |
App\Entity\Information\SupplierInvoiceState | No errors. |
App\Entity\Category |
|
App\Entity\Lot |
|
App\Entity\ItemForAnalysis | No errors. |
App\Entity\PreparationLot |
|
App\Entity\PurchaseInvoice | No errors. |
App\Entity\LotItem | No errors. |
App\Entity\TruckloadLot |
|
App\Entity\InvoiceCustomsData | No errors. |
App\Entity\Newsletter | No errors. |
App\Entity\LotItemOrigin | No errors. |
App\Entity\Information\Action |
|
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 |
|
App\Entity\Location | No errors. |
App\Entity\ProductConditionDiscount | No errors. |
App\Entity\MappingCategory |
|
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 |
|
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 |
|
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 |
|
App\Entity\InvoiceCustomsDataDetail | No errors. |
App\Entity\UploadedPhoto | No errors. |
App\Entity\CombinedManifest | No errors. |
App\Entity\Front\ShippingMode |
|
App\Entity\Front\Cart | No errors. |
App\Entity\Language | No errors. |
App\Entity\Front\Address |
|
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 |
|
App\Entity\Front\OrderFrontProductTax | No errors. |
App\Entity\Front\OrderRefund | No errors. |
App\Entity\ReportStockRotation | No errors. |