GET https://www.rsystproject.com/photobooth/format/49497

Query Metrics

3 Database Queries
3 Different statements
0.74 ms Query time
16 Invalid entities

Queries

Group similar statements

# Time Info
1 0.26 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:
[
  87
]
2 0.30 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.id = ?
Parameters:
[
  "49497"
]
3 0.18 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
]

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\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\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\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\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\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\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\LotPhoto No errors.
App\Entity\CombinedManifestLot No errors.
App\Entity\Information\PoStatus No errors.
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\ItemForAnalysis No errors.
App\Entity\PurchaseInvoice No errors.
App\Entity\InvoiceCustomsData No errors.
App\Entity\Newsletter No errors.
App\Entity\LotItemOrigin No errors.