Query Metrics
97
Database Queries
3
Different statements
2071.93 ms
Query time
19
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2066.03 ms (99.72%) |
1 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.sku AS sku_2, f0_.price AS price_3, f0_.images AS images_4, f0_.msrp AS msrp_5, f0_.discount AS discount_6, f0_.total_units AS total_units_7, f0_.package_units AS package_units_8, f0_.package_format AS package_format_9, f0_.is_cp AS is_cp_10, f0_.manifest AS manifest_11, f0_.weight AS weight_12, f0_.description AS description_13, f0_.sale_price AS sale_price_14, f0_.cost_price AS cost_price_15, f0_.calculated_price AS calculated_price_16, f0_.quantity_on_hand AS quantity_on_hand_17, f0_.quantity_pending AS quantity_pending_18, f0_.quantity_available AS quantity_available_19, f0_.track_inventory AS track_inventory_20, f0_.sort_order AS sort_order_21, f0_.is_visible AS is_visible_22, f0_.is_allow_purchase AS is_allow_purchase_23, f0_.product_availability AS product_availability_24, f0_.minimum_purchase_quantity AS minimum_purchase_quantity_25, f0_.maximum_purchase_quantity AS maximum_purchase_quantity_26, f0_.has_free_shipping AS has_free_shipping_27, f0_.fixed_shipping_price AS fixed_shipping_price_28, f0_.width AS width_29, f0_.height AS height_30, f0_.depth AS depth_31, f0_.brand AS brand_32, f0_.warranty AS warranty_33, f0_.show_product_condition AS show_product_condition_34, f0_.code AS code_35, f0_.tax_group AS tax_group_36, f0_.tax_provider_code AS tax_provider_code_37, f0_.search_keywords AS search_keywords_38, f0_.page_title AS page_title_39, f0_.meta_keywords AS meta_keywords_40, f0_.meta_description AS meta_description_41, f0_.slug AS slug_42, f0_.cost_per_unit AS cost_per_unit_43, f0_.is_overstock_lot AS is_overstock_lot_44, f0_.is_add_on_lot AS is_add_on_lot_45, f0_.is_price_drop AS is_price_drop_46, f0_.price_dropped_at AS price_dropped_at_47, f0_.published_at AS published_at_48, f0_.note AS note_49, f0_.is_listing_done AS is_listing_done_50, f0_.package_sizes AS package_sizes_51, f0_.is_truckload AS is_truckload_52, f0_.search_terms AS search_terms_53, f0_.created_at AS created_at_54, f0_.updated_at AS updated_at_55, f0_.supplier_id AS supplier_id_56, f0_.warehouse_id AS warehouse_id_57, f0_.product_condition_id AS product_condition_id_58, f0_.category_id AS category_id_59, f0_.created_by_id AS created_by_id_60, f0_.published_by_id AS published_by_id_61, f0_.created_by_customer_id AS created_by_customer_id_62, f0_.original_lot_id AS original_lot_id_63 FROM front_product f0_ WHERE f0_.is_visible = 1 AND f0_.is_allow_purchase = 1 AND f0_.quantity_available > 0 ORDER BY f0_.id DESC LIMIT 48
Parameters:
[]
|
||||||||||||||||||||||||||||
3.13 ms (0.15%) |
48 |
SELECT t0.id AS id_1, t0.msrp AS msrp_2, t0.price AS price_3, t0.nb_pallets AS nb_pallets_4, t0.nb_gaylords AS nb_gaylords_5, t0.nb_boxes AS nb_boxes_6, t0.number AS number_7, t0.manifest AS manifest_8, t0.manifest_html AS manifest_html_9, t0.is_listing_done AS is_listing_done_10, t0.is_deleted AS is_deleted_11, t0.created_by_id AS created_by_id_12, t0.related_front_product_id AS related_front_product_id_13 FROM truckload t0 WHERE t0.related_front_product_id = ?
Parameters:
[
50315
]
|
||||||||||||||||||||||||||||
2.77 ms (0.13%) |
48 |
SELECT t0.id AS id_1, t0.is_basic_step_done AS is_basic_step_done_2, t0.is_image_step_done AS is_image_step_done_3, t0.is_shipping_step_done AS is_shipping_step_done_4, t0.is_marketing_step_done AS is_marketing_step_done_5, t0.front_product_id AS front_product_id_6 FROM front_product_listing_progress t0 WHERE t0.front_product_id = ?
Parameters:
[
50315
]
|
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\Front\FrontProduct | No errors. |
App\Entity\Supplier |
|
App\Entity\Warehouse |
|
App\Entity\Information\ProductCondition |
|
App\Entity\Category |
|
App\Entity\User |
|
App\Entity\Front\Customer |
|
App\Entity\Lot |
|
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\StockUpdate | No errors. |
App\Entity\StockLocation | No errors. |
App\Entity\TruckloadIncludedFrontProduct | 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\UserGroup | 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\Information\ProductConditionLang | No errors. |
App\Entity\PreparationLot |
|
App\Entity\Product |
|
App\Entity\ScanCategoryGroup |
|
App\Entity\CategoryLang | No errors. |
App\Entity\Front\OrderCategoryDiscount | No errors. |
App\Entity\Module | No errors. |
App\Entity\ScanManifestUser |
|
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\ReportScanGroup | No errors. |
App\Entity\Front\OrderHistory | No errors. |
App\Entity\Front\Address |
|
App\Entity\Front\CustomerGroup | No errors. |
App\Entity\Front\Cart | No errors. |
App\Entity\Language | No errors. |
App\Entity\Front\OrderRefund | No errors. |
App\Entity\LotItem | No errors. |
App\Entity\TruckloadLot |
|
App\Entity\LotPhoto | No errors. |
App\Entity\CombinedManifestLot | No errors. |
App\Entity\UploadedPhoto | No errors. |
App\Entity\Front\OrderFrontProductTax | No errors. |