Query Metrics

1 Database Queries
1 Different statements
1.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.30 ms
SELECT t0.id AS id_1, t0.orig_name AS orig_name_2, t0.orig_brand_name AS orig_brand_name_3, t0.qty_left AS qty_left_4, t0.unit_amount AS unit_amount_5, t0.unit AS unit_6, t0.available AS available_7, t0.orig_description AS orig_description_8, t0.origin AS origin_9, t0.best_before AS best_before_10, t0.creation_date AS creation_date_11, t0.nutrition_fact AS nutrition_fact_12, t0.new_product AS new_product_13, t0.taxable AS taxable_14, t0.maturin_upc AS maturin_upc_15, t0.code_upc AS code_upc_16, t0.code1 AS code1_17, t0.code2 AS code2_18, t0.code3 AS code3_19, t0.code_box AS code_box_20, t0.aliments_du_quebec AS aliments_du_quebec_21, t0.minimum_in_storage AS minimum_in_storage_22, t0.limited_quantity AS limited_quantity_23, t0.aliments_du_quebec_certification AS aliments_du_quebec_certification_24, t0.delivery_type AS delivery_type_25, t0.delivery_pickup AS delivery_pickup_26, t0.draft AS draft_27, t0.delivery_mail AS delivery_mail_28, t0.advices AS advices_29, t0.recipes AS recipes_30, t0.solex_id AS solex_id_31, t0.list_of_ingredients AS list_of_ingredients_32, t0.qty_ready_to_ship AS qty_ready_to_ship_33, t0.expiration_date AS expiration_date_34, t0.is_consigned AS is_consigned_35, t0.consigned_cost AS consigned_cost_36, t0.is_fragile AS is_fragile_37, t0.qty_per_unit AS qty_per_unit_38, t0.validated_by_distributor AS validated_by_distributor_39, t0.delivery_note AS delivery_note_40, t0.is_just_in_time AS is_just_in_time_41, t0.reminder_low_quantity_sent AS reminder_low_quantity_sent_42, t0.has_multiple_products AS has_multiple_products_43, t0.has_free_maturin_shipping AS has_free_maturin_shipping_44, t0.action_when_expired AS action_when_expired_45, t0.is_subscribable AS is_subscribable_46, t0.is_box_of_products AS is_box_of_products_47, t0.is_only_subscribable AS is_only_subscribable_48, t0.just_in_time_delivery_date AS just_in_time_delivery_date_49, t0.free_maturin_shipping_if_lower_then AS free_maturin_shipping_if_lower_then_50, t0.is_only_subscribable_to_type AS is_only_subscribable_to_type_51, t0.quantity_warehouse AS quantity_warehouse_52, t0.quantity_warehouse_reserved AS quantity_warehouse_reserved_53, t0.quantity_on_hold AS quantity_on_hold_54, t0.parent_product_id AS parent_product_id_55, t0.fee_warehouse_packing_per_unit AS fee_warehouse_packing_per_unit_56, t0.fee_warehouse_handling_per_unit AS fee_warehouse_handling_per_unit_57, t0.is_displayed_in_association_only AS is_displayed_in_association_only_58, t0.is_hri AS is_hri_59, t0.puro_exclusion AS puro_exclusion_60, t0.contains_alcohol AS contains_alcohol_61, t0.is_consumer AS is_consumer_62, t0.product_colabor_price AS product_colabor_price_63, t0.is_prix_laureat AS is_prix_laureat_64, t0.cant_use_coupon AS cant_use_coupon_65, t0.seasonality AS seasonality_66, t0.seasonality_start AS seasonality_start_67, t0.seasonality_end AS seasonality_end_68, t0.quantity_max_prod AS quantity_max_prod_69, t0.product_delete AS product_delete_70, t0.order_frequency AS order_frequency_71, t0.portion_for_meal AS portion_for_meal_72, t0.categories_id AS categories_id_73, t0.conservation_id AS conservation_id_74, t0.main_image_id AS main_image_id_75, t0.company_id AS company_id_76, t0.region_id AS region_id_77, t0.nutrition_fact_image_id AS nutrition_fact_image_id_78, t79.id AS id_80, t79.price_to_company AS price_to_company_81, t79.quantity AS quantity_82, t79.product_id AS product_id_83, t0.sub_category_id AS sub_category_id_84, t0.corporative_id AS corporative_id_85 FROM product t0 LEFT JOIN product_deal t79 ON t79.product_id = t0.id WHERE t0.id = ?
Parameters:
[
  "5314"
]

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 No errors.
App\Entity\Product No errors.
App\Entity\Image No errors.
App\Entity\Notification No errors.
App\Entity\Message No errors.
App\Entity\Cart No errors.
App\Entity\Category No errors.
App\Entity\Conservation No errors.
App\Entity\Company No errors.
App\Entity\Region No errors.
App\Entity\ProductDeal No errors.
App\Entity\Corporative No errors.
App\Entity\Tag No errors.
App\Entity\Ingredient No errors.
App\Entity\Storage No errors.
App\Entity\Pricing No errors.
App\Entity\Certification No errors.
App\Entity\DeliveryLocation No errors.
App\Entity\DeliveryMethod No errors.
App\Entity\CompanyLocation No errors.
App\Entity\UserViewedProduct No errors.
App\Entity\CartProduct No errors.
App\Entity\ProductReplenishmentItem No errors.
App\Entity\UserFavorite No errors.
App\Entity\Badge No errors.
App\Entity\Diet No errors.
App\Entity\SuggestedGroup No errors.
App\Entity\Subscription No errors.
App\Entity\ProductInBox No errors.
App\Entity\ProductReplacementScript No errors.