Query Metrics
13
Database Queries
13
Different statements
4.02 ms
Query time
19
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.97 ms (49.01%) |
1 |
SELECT p0_.number AS number_0 FROM po p0_
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.49 ms (12.15%) |
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.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88, t0.has_batch_ids AS has_batch_ids_89, t0.status_id AS status_id_90, t0.supplier_id AS supplier_id_91, t0.product_condition_id AS product_condition_id_92, t0.manifest_style_id AS manifest_style_id_93, t0.invoice_style_id AS invoice_style_id_94, t0.supplier_invoice_state_id AS supplier_invoice_state_id_95, t0.warehouse_id AS warehouse_id_96, t0.auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0.id = ?
Parameters:
[
"3919"
]
|
||||||||||||||||||||||||||||||
|
0.30 ms (7.38%) |
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:
[
102
]
|
||||||||||||||||||||||||||||||
|
0.17 ms (4.35%) |
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:
[
24
]
|
||||||||||||||||||||||||||||||
|
0.15 ms (3.70%) |
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.14 ms (3.40%) |
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:
[
2
]
|
||||||||||||||||||||||||||||||
|
0.13 ms (3.18%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.has_actions AS has_actions_2, s0_.has_validation AS has_validation_3, s0_.has_high_value AS has_high_value_4, s0_.is_active AS is_active_5, s0_.has_scrapper AS has_scrapper_6, s0_.sources_upc AS sources_upc_7, s0_.sources_merchant_sku AS sources_merchant_sku_8, s0_.sources_category AS sources_category_9, s0_.sources_name AS sources_name_10, s0_.sources_msrp AS sources_msrp_11, s0_.sources_photo AS sources_photo_12, s0_.sources_action AS sources_action_13, s0_.is_required_upc AS is_required_upc_14, s0_.is_required_merchant_sku AS is_required_merchant_sku_15, s0_.is_required_category AS is_required_category_16, s0_.is_required_name AS is_required_name_17, s0_.is_required_msrp AS is_required_msrp_18, s0_.is_required_photo AS is_required_photo_19, s0_.is_required_action AS is_required_action_20, s0_.public_name AS public_name_21, s0_.is_deleted AS is_deleted_22, s0_.product_generic_link AS product_generic_link_23, s0_.billing_name AS billing_name_24, s0_.billing_address AS billing_address_25, s0_.tax_name1 AS tax_name1_26, s0_.tax_rate1 AS tax_rate1_27, s0_.tax_name2 AS tax_name2_28, s0_.tax_rate2 AS tax_rate2_29, s0_.tax_number1 AS tax_number1_30, s0_.tax_number2 AS tax_number2_31, s0_.tax_currency AS tax_currency_32, s0_.weight_per_pallet_feet AS weight_per_pallet_feet_33, s0_.has_continuous_po AS has_continuous_po_34, s0_.newsletter_default_subject AS newsletter_default_subject_35, s0_.newsletter_default_preview_text AS newsletter_default_preview_text_36, s0_.newsletter_default_header_line1 AS newsletter_default_header_line1_37, s0_.newsletter_default_header_line2 AS newsletter_default_header_line2_38, s0_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_39, s0_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_40, s0_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_41, s0_.scraper_class AS scraper_class_42, s0_.has_splited_scraper AS has_splited_scraper_43, s0_.has_synccentric_data AS has_synccentric_data_44, s0_.has_upcitemdb_data AS has_upcitemdb_data_45, s0_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_46, s0_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_47, s0_.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_48, s0_.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_49, s0_.user_group_id AS user_group_id_50 FROM supplier s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.13 ms (3.13%) |
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:
[
4
]
|
||||||||||||||||||||||||||||||
|
0.13 ms (3.13%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1 FROM invoice_style i0_
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.12 ms (3.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM invoice_style t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.11 ms (2.78%) |
1 |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.number AS number_2, w0_.contact_main_name AS contact_main_name_3, w0_.contact_main_phone AS contact_main_phone_4, w0_.contact_main_extension AS contact_main_extension_5, w0_.contact_main_email AS contact_main_email_6, w0_.contact_director_name AS contact_director_name_7, w0_.contact_director_phone AS contact_director_phone_8, w0_.contact_director_extension AS contact_director_extension_9, w0_.contact_director_email AS contact_director_email_10, w0_.contact_supervisor_name AS contact_supervisor_name_11, w0_.contact_supervisor_phone AS contact_supervisor_phone_12, w0_.contact_supervisor_extension AS contact_supervisor_extension_13, w0_.contact_supervisor_email AS contact_supervisor_email_14, w0_.contact_shipping_name AS contact_shipping_name_15, w0_.contact_shipping_phone AS contact_shipping_phone_16, w0_.contact_shipping_extension AS contact_shipping_extension_17, w0_.contact_shipping_email AS contact_shipping_email_18, w0_.contact_billing_name AS contact_billing_name_19, w0_.contact_billing_phone AS contact_billing_phone_20, w0_.contact_billing_extension AS contact_billing_extension_21, w0_.contact_billing_email AS contact_billing_email_22, w0_.email AS email_23, w0_.is_active AS is_active_24, w0_.shipping_state AS shipping_state_25, w0_.shipping_country AS shipping_country_26, w0_.shipping_postcode AS shipping_postcode_27, w0_.is_deleted AS is_deleted_28 FROM warehouse w0_ WHERE w0_.is_active = 1 ORDER BY w0_.number ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.10 ms (2.49%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_active AS is_active_2, p0_.position AS position_3, p0_.gtm_value AS gtm_value_4, p0_.facebook_value AS facebook_value_5 FROM `product_condition` p0_ WHERE p0_.is_active = 1 ORDER BY p0_.name ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.09 ms (2.26%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_active AS is_active_2 FROM manifest_style m0_ WHERE m0_.is_active = 1 ORDER BY m0_.name ASC
Parameters:
[] |
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\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\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\BatchId | No errors. |
| App\Entity\ImportData | No errors. |
| App\Entity\MerchantSku | No errors. |
| App\Entity\MappingCategory |
|
| App\Entity\ProductAction | No errors. |
| App\Entity\CategoryAction | No errors. |
| App\Entity\SpecialMerchantSku | No errors. |
| App\Entity\SupplierProductConditionDiscount | No errors. |
| App\Entity\SupplierCategoryValue | No errors. |
| App\Entity\SpecialMsrp | No errors. |
| App\Entity\SpecialUpc | No errors. |
| App\Entity\SpecialName | No errors. |
| App\Entity\ReportPerformance | No errors. |
| App\Entity\ReportStockRotationEntry | No errors. |
| App\Entity\SupplierLang | No errors. |
| App\Entity\DataImport | No errors. |
| App\Entity\InternalSku |
|
| App\Entity\ProductConditionDiscount | No errors. |
| App\Entity\Information\ProductConditionLang | No errors. |
| App\Entity\Front\WarehouseShippingMode | No errors. |
| App\Entity\Front\CartShippingMode | No errors. |
| App\Entity\Front\Order |
|
| App\Entity\Location | No errors. |