https://my-technima.com/product/316/edit?step=product-combination

Query Metrics

243 Database Queries
28 Different statements
137.30 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
78.82 ms
(57.41%)
163
SELECT t0.id AS id_1, t0.value AS value_2, t0.attribute_value_id AS attribute_value_id_3, t0.lang_id AS lang_id_4 FROM attribute_value_lang t0 WHERE t0.attribute_value_id = ?
Parameters:
[
  36
]
7.43 ms
(5.41%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_title AS sub_title_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.progression AS progression_8, t0.regulations AS regulations_9, t0.advices AS advices_10, t0.lang_id AS lang_id_11, t0.product_id AS product_id_12 FROM product_lang t0 WHERE t0.lang_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[
  1
  316
]
6.59 ms
(4.80%)
11
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang_id AS lang_id_3, t0.attribute_id AS attribute_id_4 FROM attribute_lang t0 WHERE t0.attribute_id = ?
Parameters:
[
  6
]
5.39 ms
(3.93%)
11
SELECT t0.id AS id_1, t0.color AS color_2, t0.position AS position_3, t0.attribute_id AS attribute_id_4, t0.texture_id AS texture_id_5 FROM attribute_value t0 WHERE t0.attribute_id = ?
Parameters:
[
  6
]
4.47 ms
(3.26%)
6
SELECT t0.id AS id_1, t0.color AS color_2, t0.position AS position_3, t0.attribute_id AS attribute_id_4, t0.texture_id AS texture_id_5 FROM attribute_value t0 INNER JOIN product_attribute_attribute_value ON t0.id = product_attribute_attribute_value.attribute_value_id WHERE product_attribute_attribute_value.product_attribute_id = ?
Parameters:
[
  2325
]
3.64 ms
(2.65%)
9
SELECT t0.id AS id_1, t0.name AS name_2, t0.lang_id AS lang_id_3, t0.feature_id AS feature_id_4 FROM feature_lang t0 WHERE t0.feature_id = ?
Parameters:
[
  8
]
3.30 ms
(2.40%)
6
SELECT t0.id AS id_1, t0.description AS description_2, t0.image_id AS image_id_3, t0.lang_id AS lang_id_4 FROM image_lang t0 WHERE t0.image_id = ?
Parameters:
[
  3399
]
2.97 ms
(2.16%)
9
SELECT t0.id AS id_1, t0.feature_id AS feature_id_2 FROM feature_value t0 WHERE t0.feature_id = ?
Parameters:
[
  8
]
2.88 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.type AS type_3 FROM attribute t0
Parameters:
[]
2.24 ms
(1.63%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.icu AS icu_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.main AS main_6, t0.is_interface AS is_interface_7 FROM lang t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.19 ms
(1.59%)
1
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:
[
  "316"
]
2.06 ms
(1.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4 FROM site t0
Parameters:
[]
2.01 ms
(1.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.icu AS icu_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.main AS main_6, t0.is_interface AS is_interface_7 FROM lang t0
Parameters:
[]
1.87 ms
(1.36%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.advantage_id AS advantage_id_3, t0.lang_id AS lang_id_4 FROM advantage_lang t0 WHERE t0.advantage_id = ?
Parameters:
[
  2
]
1.43 ms
(1.04%)
1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.supplier_reference AS supplier_reference_3, t0.location AS location_4, t0.ean13 AS ean13_5, t0.isbn AS isbn_6, t0.upc AS upc_7, t0.mpn AS mpn_8, t0.weight AS weight_9, t0.default_on AS default_on_10, t0.product_id AS product_id_11, t12.id AS id_13, t12.manufacturer AS manufacturer_14, t12.brand AS brand_15, t12.product_range AS product_range_16, t12.commercial_reference AS commercial_reference_17, t12.product_reference AS product_reference_18, t12.info_reference AS info_reference_19, t12.gtin13 AS gtin13_20, t12.date_tarif AS date_tarif_21, t12.price_without_tax AS price_without_tax_22, t12.distributor_price_without_tax AS distributor_price_without_tax_23, t12.currency AS currency_24, t12.vat AS vat_25, t12.quantity AS quantity_26, t12.base_reference_unit AS base_reference_unit_27, t12.minimal_order_quantity AS minimal_order_quantity_28, t12.multiple_per_order AS multiple_per_order_29, t12.packaging_qty_min AS packaging_qty_min_30, t12.manufacturer_stored_product AS manufacturer_stored_product_31, t12.delivery_delay AS delivery_delay_32, t12.electronic_data_interchange AS electronic_data_interchange_33, t12.warranty_duration AS warranty_duration_34, t12.reference_status AS reference_status_35, t12.taric AS taric_36, t12.product_height AS product_height_37, t12.product_height_unity AS product_height_unity_38, t12.product_width AS product_width_39, t12.product_width_unity AS product_width_unity_40, t12.product_depth AS product_depth_41, t12.product_depth_unity AS product_depth_unity_42, t12.product_weight AS product_weight_43, t12.product_weight_unity AS product_weight_unity_44, t12.product_diameter AS product_diameter_45, t12.product_diameter_unity AS product_diameter_unity_46, t12.recommended_storage_limit_duration AS recommended_storage_limit_duration_47, t12.made_in AS made_in_48, t12.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_49, t12.product_id AS product_id_50, t12.product_attribute_id AS product_attribute_id_51, t52.id AS id_53, t52.wording30 AS wording30_54, t52.wording80 AS wording80_55, t52.wording240 AS wording240_56, t52.erpcommercial_data_id AS erpcommercial_data_id_57, t52.product_id AS product_id_58, t52.lang_id AS lang_id_59, t52.product_attribute_id AS product_attribute_id_60, t61.id AS id_62, t61.brand AS brand_63, t61.commercial_reference AS commercial_reference_64, t61.quantity AS quantity_65, t61.gtin14 AS gtin14_66, t61.product_height AS product_height_67, t61.product_height_unity AS product_height_unity_68, t61.product_width AS product_width_69, t61.product_width_unity AS product_width_unity_70, t61.product_depth AS product_depth_71, t61.product_depth_unity AS product_depth_unity_72, t61.product_weight AS product_weight_73, t61.product_weight_unity AS product_weight_unity_74, t61.product_diameter AS product_diameter_75, t61.product_diameter_unity AS product_diameter_unity_76, t61.product_volume AS product_volume_77, t61.product_volume_unity AS product_volume_unity_78, t61.deposit AS deposit_79, t61.stacking_limit_count AS stacking_limit_count_80, t61.qc_type AS qc_type_81, t61.product_id AS product_id_82, t61.product_attribute_id AS product_attribute_id_83 FROM product_attribute t0 LEFT JOIN erpcommercial_data t12 ON t12.product_attribute_id = t0.id LEFT JOIN erpcommercial_data_lang t52 ON t52.product_attribute_id = t0.id LEFT JOIN erplogistic_data t61 ON t61.product_attribute_id = t0.id WHERE t0.product_id = ?
Parameters:
[
  316
]
1.34 ms
(0.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.lang_id AS lang_id_5 FROM file t0 INNER JOIN file_product ON t0.id = file_product.file_id WHERE file_product.product_id = ?
Parameters:
[
  316
]
1.08 ms
(0.79%)
1
SELECT t0.id AS id_1, t0.manufacturer AS manufacturer_2, t0.brand AS brand_3, t0.product_range AS product_range_4, t0.commercial_reference AS commercial_reference_5, t0.product_reference AS product_reference_6, t0.info_reference AS info_reference_7, t0.gtin13 AS gtin13_8, t0.date_tarif AS date_tarif_9, t0.price_without_tax AS price_without_tax_10, t0.distributor_price_without_tax AS distributor_price_without_tax_11, t0.currency AS currency_12, t0.vat AS vat_13, t0.quantity AS quantity_14, t0.base_reference_unit AS base_reference_unit_15, t0.minimal_order_quantity AS minimal_order_quantity_16, t0.multiple_per_order AS multiple_per_order_17, t0.packaging_qty_min AS packaging_qty_min_18, t0.manufacturer_stored_product AS manufacturer_stored_product_19, t0.delivery_delay AS delivery_delay_20, t0.electronic_data_interchange AS electronic_data_interchange_21, t0.warranty_duration AS warranty_duration_22, t0.reference_status AS reference_status_23, t0.taric AS taric_24, t0.product_height AS product_height_25, t0.product_height_unity AS product_height_unity_26, t0.product_width AS product_width_27, t0.product_width_unity AS product_width_unity_28, t0.product_depth AS product_depth_29, t0.product_depth_unity AS product_depth_unity_30, t0.product_weight AS product_weight_31, t0.product_weight_unity AS product_weight_unity_32, t0.product_diameter AS product_diameter_33, t0.product_diameter_unity AS product_diameter_unity_34, t0.recommended_storage_limit_duration AS recommended_storage_limit_duration_35, t0.made_in AS made_in_36, t0.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_37, t0.product_id AS product_id_38, t0.product_attribute_id AS product_attribute_id_39 FROM erpcommercial_data t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  316
]
1.08 ms
(0.79%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.lang_id AS lang_id_5 FROM file t0
Parameters:
[]
1.01 ms
(0.74%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.image_id AS image_id_3 FROM advantage t0 INNER JOIN advantage_product ON t0.id = advantage_product.advantage_id WHERE advantage_product.product_id = ?
Parameters:
[
  316
]
0.97 ms
(0.71%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.cover AS cover_4, t0.position AS position_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.product_id = ?
Parameters:
[
  316
]
0.93 ms
(0.68%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.date_add AS date_add_5, t0.date_upd AS date_upd_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.color AS color_9, t0.available_to AS available_to_10, t0.interface_lang_id AS interface_lang_id_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  12
]
0.73 ms
(0.53%)
1
SELECT t0.id AS id_1, t0.position AS position_2 FROM feature t0
Parameters:
[]
0.64 ms
(0.47%)
1
SELECT t0.id AS id_1, t0.feature_id AS feature_id_2 FROM feature_value t0 INNER JOIN product_feature_value ON t0.id = product_feature_value.feature_value_id WHERE product_feature_value.product_id = ?
Parameters:
[
  316
]
0.58 ms
(0.42%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_title AS sub_title_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.progression AS progression_8, t0.regulations AS regulations_9, t0.advices AS advices_10, t0.lang_id AS lang_id_11, t0.product_id AS product_id_12 FROM product_lang t0 WHERE t0.product_id = ?
Parameters:
[
  316
]
0.51 ms
(0.37%)
1
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.commercial_reference AS commercial_reference_3, t0.quantity AS quantity_4, t0.gtin14 AS gtin14_5, t0.product_height AS product_height_6, t0.product_height_unity AS product_height_unity_7, t0.product_width AS product_width_8, t0.product_width_unity AS product_width_unity_9, t0.product_depth AS product_depth_10, t0.product_depth_unity AS product_depth_unity_11, t0.product_weight AS product_weight_12, t0.product_weight_unity AS product_weight_unity_13, t0.product_diameter AS product_diameter_14, t0.product_diameter_unity AS product_diameter_unity_15, t0.product_volume AS product_volume_16, t0.product_volume_unity AS product_volume_unity_17, t0.deposit AS deposit_18, t0.stacking_limit_count AS stacking_limit_count_19, t0.qc_type AS qc_type_20, t0.product_id AS product_id_21, t0.product_attribute_id AS product_attribute_id_22 FROM erplogistic_data t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
  316
]
0.42 ms
(0.30%)
1
SELECT a0_.id AS id_0, a0_.position AS position_1, a0_.image_id AS image_id_2 FROM advantage a0_
Parameters:
[]
0.38 ms
(0.28%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1 FROM brand b0_
Parameters:
[]
0.37 ms
(0.27%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Lang
  • The association App\Entity\Lang#featureValues refers to the owning side field App\Entity\FeatureValue#lang which does not exist.
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\Attribute
  • The mappings App\Entity\Attribute#attributeLang and App\Entity\AttributeLang#attribute are inconsistent with each other.
App\Entity\Feature No errors.
App\Entity\AttributeLang
  • The association App\Entity\AttributeLang#attribute refers to the inverse side field App\Entity\Attribute#attributeLangs which does not exist.
App\Entity\AttributeValue No errors.
App\Entity\AttributeValueLang No errors.
App\Entity\AdvantageLang No errors.
App\Entity\FeatureLang No errors.
App\Entity\FeatureValueLang No errors.
App\Entity\ImageLang No errors.