Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

14.20 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	14.20 ms	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id WHERE t0.id = ? Parameters: [`"301"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id WHERE t0.id = '301';

#▲

Time

Info

14.20 ms

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id WHERE t0.id = ?

Parameters:

[
  "301"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.ean13 AS ean13_3,
  t0.isbn AS isbn_4,
  t0.mpn AS mpn_5,
  t0.price AS price_6,
  t0.width AS width_7,
  t0.height AS height_8,
  t0.depth AS depth_9,
  t0.weight AS weight_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.brand_id AS brand_id_13,
  t14.id AS id_15,
  t14.manufacturer AS manufacturer_16,
  t14.brand AS brand_17,
  t14.product_range AS product_range_18,
  t14.commercial_reference AS commercial_reference_19,
  t14.product_reference AS product_reference_20,
  t14.info_reference AS info_reference_21,
  t14.gtin13 AS gtin13_22,
  t14.date_tarif AS date_tarif_23,
  t14.price_without_tax AS price_without_tax_24,
  t14.distributor_price_without_tax AS distributor_price_without_tax_25,
  t14.currency AS currency_26,
  t14.vat AS vat_27,
  t14.quantity AS quantity_28,
  t14.base_reference_unit AS base_reference_unit_29,
  t14.minimal_order_quantity AS minimal_order_quantity_30,
  t14.multiple_per_order AS multiple_per_order_31,
  t14.packaging_qty_min AS packaging_qty_min_32,
  t14.manufacturer_stored_product AS manufacturer_stored_product_33,
  t14.delivery_delay AS delivery_delay_34,
  t14.electronic_data_interchange AS electronic_data_interchange_35,
  t14.warranty_duration AS warranty_duration_36,
  t14.reference_status AS reference_status_37,
  t14.taric AS taric_38,
  t14.product_height AS product_height_39,
  t14.product_height_unity AS product_height_unity_40,
  t14.product_width AS product_width_41,
  t14.product_width_unity AS product_width_unity_42,
  t14.product_depth AS product_depth_43,
  t14.product_depth_unity AS product_depth_unity_44,
  t14.product_weight AS product_weight_45,
  t14.product_weight_unity AS product_weight_unity_46,
  t14.product_diameter AS product_diameter_47,
  t14.product_diameter_unity AS product_diameter_unity_48,
  t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49,
  t14.made_in AS made_in_50,
  t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51,
  t14.product_id AS product_id_52,
  t14.product_attribute_id AS product_attribute_id_53,
  t54.id AS id_55,
  t54.brand AS brand_56,
  t54.commercial_reference AS commercial_reference_57,
  t54.quantity AS quantity_58,
  t54.gtin14 AS gtin14_59,
  t54.product_height AS product_height_60,
  t54.product_height_unity AS product_height_unity_61,
  t54.product_width AS product_width_62,
  t54.product_width_unity AS product_width_unity_63,
  t54.product_depth AS product_depth_64,
  t54.product_depth_unity AS product_depth_unity_65,
  t54.product_weight AS product_weight_66,
  t54.product_weight_unity AS product_weight_unity_67,
  t54.product_diameter AS product_diameter_68,
  t54.product_diameter_unity AS product_diameter_unity_69,
  t54.product_volume AS product_volume_70,
  t54.product_volume_unity AS product_volume_unity_71,
  t54.deposit AS deposit_72,
  t54.stacking_limit_count AS stacking_limit_count_73,
  t54.qc_type AS qc_type_74,
  t54.product_id AS product_id_75,
  t54.product_attribute_id AS product_attribute_id_76
FROM
  product t0
  LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id
  LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.ean13 AS ean13_3, t0.isbn AS isbn_4, t0.mpn AS mpn_5, t0.price AS price_6, t0.width AS width_7, t0.height AS height_8, t0.depth AS depth_9, t0.weight AS weight_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.brand_id AS brand_id_13, t14.id AS id_15, t14.manufacturer AS manufacturer_16, t14.brand AS brand_17, t14.product_range AS product_range_18, t14.commercial_reference AS commercial_reference_19, t14.product_reference AS product_reference_20, t14.info_reference AS info_reference_21, t14.gtin13 AS gtin13_22, t14.date_tarif AS date_tarif_23, t14.price_without_tax AS price_without_tax_24, t14.distributor_price_without_tax AS distributor_price_without_tax_25, t14.currency AS currency_26, t14.vat AS vat_27, t14.quantity AS quantity_28, t14.base_reference_unit AS base_reference_unit_29, t14.minimal_order_quantity AS minimal_order_quantity_30, t14.multiple_per_order AS multiple_per_order_31, t14.packaging_qty_min AS packaging_qty_min_32, t14.manufacturer_stored_product AS manufacturer_stored_product_33, t14.delivery_delay AS delivery_delay_34, t14.electronic_data_interchange AS electronic_data_interchange_35, t14.warranty_duration AS warranty_duration_36, t14.reference_status AS reference_status_37, t14.taric AS taric_38, t14.product_height AS product_height_39, t14.product_height_unity AS product_height_unity_40, t14.product_width AS product_width_41, t14.product_width_unity AS product_width_unity_42, t14.product_depth AS product_depth_43, t14.product_depth_unity AS product_depth_unity_44, t14.product_weight AS product_weight_45, t14.product_weight_unity AS product_weight_unity_46, t14.product_diameter AS product_diameter_47, t14.product_diameter_unity AS product_diameter_unity_48, t14.recommended_storage_limit_duration AS recommended_storage_limit_duration_49, t14.made_in AS made_in_50, t14.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_51, t14.product_id AS product_id_52, t14.product_attribute_id AS product_attribute_id_53, t54.id AS id_55, t54.brand AS brand_56, t54.commercial_reference AS commercial_reference_57, t54.quantity AS quantity_58, t54.gtin14 AS gtin14_59, t54.product_height AS product_height_60, t54.product_height_unity AS product_height_unity_61, t54.product_width AS product_width_62, t54.product_width_unity AS product_width_unity_63, t54.product_depth AS product_depth_64, t54.product_depth_unity AS product_depth_unity_65, t54.product_weight AS product_weight_66, t54.product_weight_unity AS product_weight_unity_67, t54.product_diameter AS product_diameter_68, t54.product_diameter_unity AS product_diameter_unity_69, t54.product_volume AS product_volume_70, t54.product_volume_unity AS product_volume_unity_71, t54.deposit AS deposit_72, t54.stacking_limit_count AS stacking_limit_count_73, t54.qc_type AS qc_type_74, t54.product_id AS product_id_75, t54.product_attribute_id AS product_attribute_id_76 FROM product t0 LEFT JOIN erpcommercial_data t14 ON t14.product_id = t0.id LEFT JOIN erplogistic_data t54 ON t54.product_id = t0.id WHERE t0.id = '301';

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\Product	No errors.
App\Entity\Brand	No errors.
App\Entity\ERPCommercialData	If association App\Entity\ERPCommercialData#product is many-to-one, then the inversed side App\Entity\Product#ERPCommercialData has to be one-to-many.
App\Entity\ProductAttribute	No errors.
App\Entity\ERPLogisticData	If association App\Entity\ERPLogisticData#product is many-to-one, then the inversed side App\Entity\Product#ERPLogisticData has to be one-to-many.
App\Entity\ProductLang	No errors.
App\Entity\Image	No errors.
App\Entity\FeatureValue	No errors.
App\Entity\Advantage	No errors.
App\Entity\File	No errors.
App\Entity\ERPCommercialDataLang	If association App\Entity\ERPCommercialDataLang#productAttribute is many-to-one, then the inversed side App\Entity\ProductAttribute#ERPCommercialDataLang has to be one-to-many.
App\Entity\Site	No errors.
App\Entity\Lang	The association App\Entity\Lang#featureValues refers to the owning side field App\Entity\FeatureValue#lang which does not exist.
App\Entity\Attribute	The mappings App\Entity\Attribute#attributeLang and App\Entity\AttributeLang#attribute are inconsistent with each other.
App\Entity\Feature	No errors.

Symfony Profiler

http://my-technima.com/product/301/edit?step=product-feature

Configuration Settings

Theme