Query Metrics
3
Database Queries
3
Different statements
0.72 ms
Query time
11
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 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:
[
26
]
|
||||||||||||||||||||||||||
| 2 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.has_actions AS has_actions_3, t0.has_validation AS has_validation_4, t0.has_high_value AS has_high_value_5, t0.is_active AS is_active_6, t0.has_scrapper AS has_scrapper_7, t0.sources_upc AS sources_upc_8, t0.sources_merchant_sku AS sources_merchant_sku_9, t0.sources_category AS sources_category_10, t0.sources_name AS sources_name_11, t0.sources_msrp AS sources_msrp_12, t0.sources_photo AS sources_photo_13, t0.sources_action AS sources_action_14, t0.is_required_upc AS is_required_upc_15, t0.is_required_merchant_sku AS is_required_merchant_sku_16, t0.is_required_category AS is_required_category_17, t0.is_required_name AS is_required_name_18, t0.is_required_msrp AS is_required_msrp_19, t0.is_required_photo AS is_required_photo_20, t0.is_required_action AS is_required_action_21, t0.public_name AS public_name_22, t0.is_deleted AS is_deleted_23, t0.product_generic_link AS product_generic_link_24, t0.billing_name AS billing_name_25, t0.billing_address AS billing_address_26, t0.tax_name1 AS tax_name1_27, t0.tax_rate1 AS tax_rate1_28, t0.tax_name2 AS tax_name2_29, t0.tax_rate2 AS tax_rate2_30, t0.tax_number1 AS tax_number1_31, t0.tax_number2 AS tax_number2_32, t0.tax_currency AS tax_currency_33, t0.weight_per_pallet_feet AS weight_per_pallet_feet_34, t0.has_continuous_po AS has_continuous_po_35, t0.newsletter_default_subject AS newsletter_default_subject_36, t0.newsletter_default_preview_text AS newsletter_default_preview_text_37, t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38, t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39, t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40, t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41, t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42, t0.scraper_class AS scraper_class_43, t0.has_splited_scraper AS has_splited_scraper_44, t0.has_synccentric_data AS has_synccentric_data_45, t0.has_upcitemdb_data AS has_upcitemdb_data_46, t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47, t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48, t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49, t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50, t0.user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||
| 3 | 0.16 ms |
SELECT t0.id AS id_1, t0.is_processed AS is_processed_2, t0.processor AS processor_3, t0.flag AS flag_4, t0.field1 AS field1_5, t0.field2 AS field2_6, t0.field3 AS field3_7, t0.field4 AS field4_8, t0.field5 AS field5_9, t0.field6 AS field6_10, t0.field7 AS field7_11, t0.field8 AS field8_12, t0.field9 AS field9_13, t0.field0 AS field0_14, t0.supplier_id AS supplier_id_15 FROM data_import t0 WHERE t0.supplier_id = ? AND t0.flag = ? LIMIT 50
Parameters:
[ 28 "wm" ]
|
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\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\InvoiceCustomsData | No errors. |
| App\Entity\SpecialUpc | No errors. |
| App\Entity\SpecialName | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\ReportPerformance | No errors. |
| App\Entity\ReportStockRotationEntry | No errors. |
| App\Entity\SupplierLang | No errors. |
| App\Entity\DataImport | No errors. |