Symfony Profiler

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 = ?

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 = 36;

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

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 = 1 AND t0.product_id = 9 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.feature_value_id AS feature_value_id_3,
  t0.lang_id AS lang_id_4
FROM
  feature_value_lang t0
WHERE
  t0.feature_value_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.feature_value_id AS feature_value_id_3, t0.lang_id AS lang_id_4 FROM feature_value_lang t0 WHERE t0.feature_value_id = 49;

SELECT
  t0.id AS id_1,
  t0.feature_id AS feature_id_2
FROM
  feature_value t0
WHERE
  t0.feature_id = ?

SELECT t0.id AS id_1, t0.feature_id AS feature_id_2 FROM feature_value t0 WHERE t0.feature_id = 8;

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.is_nc AS is_nc_13,
  t0.brand_id AS brand_id_14,
  t15.id AS id_16,
  t15.manufacturer AS manufacturer_17,
  t15.brand AS brand_18,
  t15.product_range AS product_range_19,
  t15.commercial_reference AS commercial_reference_20,
  t15.product_reference AS product_reference_21,
  t15.info_reference AS info_reference_22,
  t15.gtin13 AS gtin13_23,
  t15.date_tarif AS date_tarif_24,
  t15.price_without_tax AS price_without_tax_25,
  t15.distributor_price_without_tax AS distributor_price_without_tax_26,
  t15.currency AS currency_27,
  t15.vat AS vat_28,
  t15.quantity AS quantity_29,
  t15.base_reference_unit AS base_reference_unit_30,
  t15.minimal_order_quantity AS minimal_order_quantity_31,
  t15.multiple_per_order AS multiple_per_order_32,
  t15.packaging_qty_min AS packaging_qty_min_33,
  t15.manufacturer_stored_product AS manufacturer_stored_product_34,
  t15.delivery_delay AS delivery_delay_35,
  t15.electronic_data_interchange AS electronic_data_interchange_36,
  t15.warranty_duration AS warranty_duration_37,
  t15.reference_status AS reference_status_38,
  t15.taric AS taric_39,
  t15.product_height AS product_height_40,
  t15.product_height_unity AS product_height_unity_41,
  t15.product_width AS product_width_42,
  t15.product_width_unity AS product_width_unity_43,
  t15.product_depth AS product_depth_44,
  t15.product_depth_unity AS product_depth_unity_45,
  t15.product_weight AS product_weight_46,
  t15.product_weight_unity AS product_weight_unity_47,
  t15.product_diameter AS product_diameter_48,
  t15.product_diameter_unity AS product_diameter_unity_49,
  t15.recommended_storage_limit_duration AS recommended_storage_limit_duration_50,
  t15.made_in AS made_in_51,
  t15.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_52,
  t15.product_id AS product_id_53,
  t15.product_attribute_id AS product_attribute_id_54,
  t55.id AS id_56,
  t55.brand AS brand_57,
  t55.commercial_reference AS commercial_reference_58,
  t55.quantity AS quantity_59,
  t55.gtin14 AS gtin14_60,
  t55.product_height AS product_height_61,
  t55.product_height_unity AS product_height_unity_62,
  t55.product_width AS product_width_63,
  t55.product_width_unity AS product_width_unity_64,
  t55.product_depth AS product_depth_65,
  t55.product_depth_unity AS product_depth_unity_66,
  t55.product_weight AS product_weight_67,
  t55.product_weight_unity AS product_weight_unity_68,
  t55.product_diameter AS product_diameter_69,
  t55.product_diameter_unity AS product_diameter_unity_70,
  t55.product_volume AS product_volume_71,
  t55.product_volume_unity AS product_volume_unity_72,
  t55.deposit AS deposit_73,
  t55.stacking_limit_count AS stacking_limit_count_74,
  t55.qc_type AS qc_type_75,
  t55.product_id AS product_id_76,
  t55.product_attribute_id AS product_attribute_id_77
FROM
  product t0
  LEFT JOIN erpcommercial_data t15 ON t15.product_id = t0.id
  LEFT JOIN erplogistic_data t55 ON t55.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.is_nc AS is_nc_13, t0.brand_id AS brand_id_14, t15.id AS id_16, t15.manufacturer AS manufacturer_17, t15.brand AS brand_18, t15.product_range AS product_range_19, t15.commercial_reference AS commercial_reference_20, t15.product_reference AS product_reference_21, t15.info_reference AS info_reference_22, t15.gtin13 AS gtin13_23, t15.date_tarif AS date_tarif_24, t15.price_without_tax AS price_without_tax_25, t15.distributor_price_without_tax AS distributor_price_without_tax_26, t15.currency AS currency_27, t15.vat AS vat_28, t15.quantity AS quantity_29, t15.base_reference_unit AS base_reference_unit_30, t15.minimal_order_quantity AS minimal_order_quantity_31, t15.multiple_per_order AS multiple_per_order_32, t15.packaging_qty_min AS packaging_qty_min_33, t15.manufacturer_stored_product AS manufacturer_stored_product_34, t15.delivery_delay AS delivery_delay_35, t15.electronic_data_interchange AS electronic_data_interchange_36, t15.warranty_duration AS warranty_duration_37, t15.reference_status AS reference_status_38, t15.taric AS taric_39, t15.product_height AS product_height_40, t15.product_height_unity AS product_height_unity_41, t15.product_width AS product_width_42, t15.product_width_unity AS product_width_unity_43, t15.product_depth AS product_depth_44, t15.product_depth_unity AS product_depth_unity_45, t15.product_weight AS product_weight_46, t15.product_weight_unity AS product_weight_unity_47, t15.product_diameter AS product_diameter_48, t15.product_diameter_unity AS product_diameter_unity_49, t15.recommended_storage_limit_duration AS recommended_storage_limit_duration_50, t15.made_in AS made_in_51, t15.packaging_min_sales_dist_to_client AS packaging_min_sales_dist_to_client_52, t15.product_id AS product_id_53, t15.product_attribute_id AS product_attribute_id_54, t55.id AS id_56, t55.brand AS brand_57, t55.commercial_reference AS commercial_reference_58, t55.quantity AS quantity_59, t55.gtin14 AS gtin14_60, t55.product_height AS product_height_61, t55.product_height_unity AS product_height_unity_62, t55.product_width AS product_width_63, t55.product_width_unity AS product_width_unity_64, t55.product_depth AS product_depth_65, t55.product_depth_unity AS product_depth_unity_66, t55.product_weight AS product_weight_67, t55.product_weight_unity AS product_weight_unity_68, t55.product_diameter AS product_diameter_69, t55.product_diameter_unity AS product_diameter_unity_70, t55.product_volume AS product_volume_71, t55.product_volume_unity AS product_volume_unity_72, t55.deposit AS deposit_73, t55.stacking_limit_count AS stacking_limit_count_74, t55.qc_type AS qc_type_75, t55.product_id AS product_id_76, t55.product_attribute_id AS product_attribute_id_77 FROM product t0 LEFT JOIN erpcommercial_data t15 ON t15.product_id = t0.id LEFT JOIN erplogistic_data t55 ON t55.product_id = t0.id WHERE t0.id = '9';

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 = ?

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 = 415;

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 = ?

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 = 756;

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 = ?

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 = 9;

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 = ?

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 = 9;

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 = ?

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 = 6;

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 = ?

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 = 9;

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 = ?

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 = 6;

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 = ?

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 = 8;

SELECT
  t0.id AS id_1,
  t0.position AS position_2
FROM
  feature t0

SELECT t0.id AS id_1, t0.position AS position_2 FROM feature t0;

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,
  t8.id AS id_9,
  t8.email AS email_10,
  t8.roles AS roles_11,
  t8.password AS password_12,
  t8.date_add AS date_add_13,
  t8.date_upd AS date_upd_14,
  t8.firstname AS firstname_15,
  t8.lastname AS lastname_16,
  t8.color AS color_17,
  t8.available_to AS available_to_18,
  t8.auth_code AS auth_code_19,
  t8.interface_lang_id AS interface_lang_id_20,
  t8.lang_in_charge_id AS lang_in_charge_id_21
FROM
  lang t0
  LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id
WHERE
  t0.id = ?

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, t8.id AS id_9, t8.email AS email_10, t8.roles AS roles_11, t8.password AS password_12, t8.date_add AS date_add_13, t8.date_upd AS date_upd_14, t8.firstname AS firstname_15, t8.lastname AS lastname_16, t8.color AS color_17, t8.available_to AS available_to_18, t8.auth_code AS auth_code_19, t8.interface_lang_id AS interface_lang_id_20, t8.lang_in_charge_id AS lang_in_charge_id_21 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.url AS url_6,
  t0.api_key AS api_key_7,
  t0.is_web_to_print_address AS is_web_to_print_address_8
FROM
  site t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.email AS email_5, t0.url AS url_6, t0.api_key AS api_key_7, t0.is_web_to_print_address AS is_web_to_print_address_8 FROM site t0;

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 = ?

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 = 9;

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

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;

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 = ?

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 = 9;

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 = ?

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 = 2;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.type AS type_3
FROM
  attribute t0

SELECT t0.id AS id_1, t0.position AS position_2, t0.type AS type_3 FROM attribute t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.friendly_url AS friendly_url_3,
  t0.technima_brand AS technima_brand_4,
  t0.logo AS logo_5
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.friendly_url AS friendly_url_3, t0.technima_brand AS technima_brand_4, t0.logo AS logo_5 FROM brand t0 WHERE t0.id = 2;

SELECT
  a0_.id AS id_0,
  a0_.position AS position_1,
  a0_.image_id AS image_id_2
FROM
  advantage a0_

SELECT a0_.id AS id_0, a0_.position AS position_1, a0_.image_id AS image_id_2 FROM advantage a0_;

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 = ?

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 = 9;

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

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 = 9 LIMIT 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,
  t8.id AS id_9,
  t8.email AS email_10,
  t8.roles AS roles_11,
  t8.password AS password_12,
  t8.date_add AS date_add_13,
  t8.date_upd AS date_upd_14,
  t8.firstname AS firstname_15,
  t8.lastname AS lastname_16,
  t8.color AS color_17,
  t8.available_to AS available_to_18,
  t8.auth_code AS auth_code_19,
  t8.interface_lang_id AS interface_lang_id_20,
  t8.lang_in_charge_id AS lang_in_charge_id_21
FROM
  lang t0
  LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id

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, t8.id AS id_9, t8.email AS email_10, t8.roles AS roles_11, t8.password AS password_12, t8.date_add AS date_add_13, t8.date_upd AS date_upd_14, t8.firstname AS firstname_15, t8.lastname AS lastname_16, t8.color AS color_17, t8.available_to AS available_to_18, t8.auth_code AS auth_code_19, t8.interface_lang_id AS interface_lang_id_20, t8.lang_in_charge_id AS lang_in_charge_id_21 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id;