Query Metrics
106
Database Queries
17
Different statements
1987.01 ms
Query time
12
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
266.59 ms (13.42%) |
7 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart4 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829532524"
]
|
||||||||||||||||||||||||||||
|
250.64 ms (12.61%) |
6 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart3 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829534443"
]
|
||||||||||||||||||||||||||||
|
229.84 ms (11.57%) |
7 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart5 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829532035"
]
|
||||||||||||||||||||||||||||
|
221.96 ms (11.17%) |
7 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart2 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829534442"
]
|
||||||||||||||||||||||||||||
|
202.10 ms (10.17%) |
5 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart1 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829532481"
]
|
||||||||||||||||||||||||||||
|
200.76 ms (10.10%) |
5 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart9 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829511889"
]
|
||||||||||||||||||||||||||||
|
190.45 ms (9.58%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart6 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829552126"
]
|
||||||||||||||||||||||||||||
|
170.14 ms (8.56%) |
5 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart7 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829533437"
]
|
||||||||||||||||||||||||||||
|
127.31 ms (6.41%) |
3 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart0 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829532660"
]
|
||||||||||||||||||||||||||||
|
116.23 ms (5.85%) |
3 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.merchant_sku AS merchant_sku_3, t0.category AS category_4, t0.name AS name_5, t0.msrp AS msrp_6, t0.is_converted AS is_converted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM scraper_walmart8 t0 WHERE t0.merchant_sku = ? LIMIT 1
Parameters:
[
"0002829533438"
]
|
||||||||||||||||||||||||||||
|
4.83 ms (0.24%) |
50 |
DELETE FROM data_import WHERE id = ?
Parameters:
[
5724061
]
|
||||||||||||||||||||||||||||
|
3.67 ms (0.18%) |
1 |
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" ]
|
||||||||||||||||||||||||||||
|
1.47 ms (0.07%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.45 ms (0.02%) |
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.29 ms (0.01%) |
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:
[
26
]
|
||||||||||||||||||||||||||||
|
0.17 ms (0.01%) |
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.12 ms (0.01%) |
1 |
"START TRANSACTION"
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\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. |
| App\Entity\InternalSku |
|
| App\Entity\ImportData | No errors. |
| App\Entity\Scraper\ScraperWalmart7 | No errors. |
| App\Entity\Scraper\ScraperWalmart5 | No errors. |
| App\Entity\Scraper\ScraperWalmart2 | No errors. |
| App\Entity\Scraper\ScraperWalmart8 | No errors. |
| App\Entity\Scraper\ScraperWalmart3 | No errors. |
| App\Entity\Scraper\ScraperWalmart4 | No errors. |
| App\Entity\Scraper\ScraperWalmart1 | No errors. |
| App\Entity\Scraper\ScraperWalmart9 | No errors. |
| App\Entity\Scraper\ScraperWalmart6 | No errors. |
| App\Entity\Scraper\ScraperWalmart0 | No errors. |