Symfony Profiler

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,
  t0.mdd_brand_id AS mdd_brand_id_15
FROM
  product t0
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, t0.mdd_brand_id AS mdd_brand_id_15 FROM product t0 WHERE t0.id = '14';

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.mdd_brand_requested AS mdd_brand_requested_20,
  t8.interface_lang_id AS interface_lang_id_21,
  t8.lang_in_charge_id AS lang_in_charge_id_22
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.mdd_brand_requested AS mdd_brand_requested_20, t8.interface_lang_id AS interface_lang_id_21, t8.lang_in_charge_id AS lang_in_charge_id_22 FROM lang t0 LEFT JOIN user t8 ON t8.lang_in_charge_id = t0.id WHERE t0.id = '2';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.sub_title AS sub_title_2,
  p0_.advantages AS advantages_3,
  p0_.image AS image_4,
  p0_.qrcode AS qrcode_5,
  p0_.description AS description_6,
  p0_.picto1 AS picto1_7,
  p0_.picto2 AS picto2_8,
  p0_.picto3 AS picto3_9,
  p0_.picto4 AS picto4_10,
  p0_.certif1 AS certif1_11,
  p0_.certif2 AS certif2_12,
  p0_.binder AS binder_13,
  p0_.pigments AS pigments_14,
  p0_.solvents AS solvents_15,
  p0_.voc_content AS voc_content_16,
  p0_.marking_duration AS marking_duration_17,
  p0_.autonomy AS autonomy_18,
  p0_.drying_time AS drying_time_19,
  p0_.storage AS storage_20,
  p0_.technical_warranty AS technical_warranty_21,
  p0_.manufacturer AS manufacturer_22,
  p0_.size AS size_23,
  p0_.diameter AS diameter_24,
  p0_.volume AS volume_25,
  p0_.weight AS weight_26,
  p0_.packaging AS packaging_27,
  p0_.advices AS advices_28,
  p0_.security AS security_29,
  p0_.security_img1 AS security_img1_30,
  p0_.security_img2 AS security_img2_31,
  p0_.security_img3 AS security_img3_32,
  p0_.security_img4 AS security_img4_33,
  p0_.end_of_life AS end_of_life_34,
  p0_.instructions AS instructions_35,
  p0_.instructions_img AS instructions_img_36,
  p0_.version AS version_37,
  p0_.progression AS progression_38,
  p0_.lang_id AS lang_id_39,
  p0_.product_id AS product_id_40
FROM
  product_web_to_print_lang p0_
WHERE
  p0_.product_id = ?
  AND p0_.lang_id = ?

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.sub_title AS sub_title_2, p0_.advantages AS advantages_3, p0_.image AS image_4, p0_.qrcode AS qrcode_5, p0_.description AS description_6, p0_.picto1 AS picto1_7, p0_.picto2 AS picto2_8, p0_.picto3 AS picto3_9, p0_.picto4 AS picto4_10, p0_.certif1 AS certif1_11, p0_.certif2 AS certif2_12, p0_.binder AS binder_13, p0_.pigments AS pigments_14, p0_.solvents AS solvents_15, p0_.voc_content AS voc_content_16, p0_.marking_duration AS marking_duration_17, p0_.autonomy AS autonomy_18, p0_.drying_time AS drying_time_19, p0_.storage AS storage_20, p0_.technical_warranty AS technical_warranty_21, p0_.manufacturer AS manufacturer_22, p0_.size AS size_23, p0_.diameter AS diameter_24, p0_.volume AS volume_25, p0_.weight AS weight_26, p0_.packaging AS packaging_27, p0_.advices AS advices_28, p0_.security AS security_29, p0_.security_img1 AS security_img1_30, p0_.security_img2 AS security_img2_31, p0_.security_img3 AS security_img3_32, p0_.security_img4 AS security_img4_33, p0_.end_of_life AS end_of_life_34, p0_.instructions AS instructions_35, p0_.instructions_img AS instructions_img_36, p0_.version AS version_37, p0_.progression AS progression_38, p0_.lang_id AS lang_id_39, p0_.product_id AS product_id_40 FROM product_web_to_print_lang p0_ WHERE p0_.product_id = 14 AND p0_.lang_id = 2;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.address AS address_2,
  s0_.phone AS phone_3,
  s0_.email AS email_4,
  s0_.url AS url_5,
  s0_.api_key AS api_key_6,
  s0_.is_web_to_print_address AS is_web_to_print_address_7
FROM
  site s0_
WHERE
  s0_.is_web_to_print_address = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.phone AS phone_3, s0_.email AS email_4, s0_.url AS url_5, s0_.api_key AS api_key_6, s0_.is_web_to_print_address AS is_web_to_print_address_7 FROM site s0_ WHERE s0_.is_web_to_print_address = 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.brand AS brand_54,
  t52.commercial_reference AS commercial_reference_55,
  t52.quantity AS quantity_56,
  t52.gtin14 AS gtin14_57,
  t52.product_height AS product_height_58,
  t52.product_height_unity AS product_height_unity_59,
  t52.product_width AS product_width_60,
  t52.product_width_unity AS product_width_unity_61,
  t52.product_depth AS product_depth_62,
  t52.product_depth_unity AS product_depth_unity_63,
  t52.product_weight AS product_weight_64,
  t52.product_weight_unity AS product_weight_unity_65,
  t52.product_diameter AS product_diameter_66,
  t52.product_diameter_unity AS product_diameter_unity_67,
  t52.product_volume AS product_volume_68,
  t52.product_volume_unity AS product_volume_unity_69,
  t52.deposit AS deposit_70,
  t52.stacking_limit_count AS stacking_limit_count_71,
  t52.qc_type AS qc_type_72,
  t52.product_id AS product_id_73,
  t52.product_attribute_id AS product_attribute_id_74
FROM
  product_attribute t0
  LEFT JOIN erpcommercial_data t12 ON t12.product_attribute_id = t0.id
  LEFT JOIN erplogistic_data t52 ON t52.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.brand AS brand_54, t52.commercial_reference AS commercial_reference_55, t52.quantity AS quantity_56, t52.gtin14 AS gtin14_57, t52.product_height AS product_height_58, t52.product_height_unity AS product_height_unity_59, t52.product_width AS product_width_60, t52.product_width_unity AS product_width_unity_61, t52.product_depth AS product_depth_62, t52.product_depth_unity AS product_depth_unity_63, t52.product_weight AS product_weight_64, t52.product_weight_unity AS product_weight_unity_65, t52.product_diameter AS product_diameter_66, t52.product_diameter_unity AS product_diameter_unity_67, t52.product_volume AS product_volume_68, t52.product_volume_unity AS product_volume_unity_69, t52.deposit AS deposit_70, t52.stacking_limit_count AS stacking_limit_count_71, t52.qc_type AS qc_type_72, t52.product_id AS product_id_73, t52.product_attribute_id AS product_attribute_id_74 FROM product_attribute t0 LEFT JOIN erpcommercial_data t12 ON t12.product_attribute_id = t0.id LEFT JOIN erplogistic_data t52 ON t52.product_attribute_id = t0.id WHERE t0.product_id = 14;

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

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 = ?
  AND t0.lang_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 = 45 AND t0.lang_id = 2;

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

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 = ?
  AND t0.lang_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 = 39 AND t0.lang_id = 2;

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

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 = ?
  AND t0.lang_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 = 40 AND t0.lang_id = 2;

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

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 = ?
  AND t0.lang_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 AND t0.lang_id = 2;

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

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 = ?
  AND t0.lang_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 = 44 AND t0.lang_id = 2;

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

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 = ?
  AND t0.lang_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 = 46 AND t0.lang_id = 2;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.address AS address_2,
  s0_.phone AS phone_3,
  s0_.email AS email_4,
  s0_.url AS url_5,
  s0_.api_key AS api_key_6,
  s0_.is_web_to_print_address AS is_web_to_print_address_7
FROM
  site s0_
WHERE
  s0_.is_web_to_print_address = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.phone AS phone_3, s0_.email AS email_4, s0_.url AS url_5, s0_.api_key AS api_key_6, s0_.is_web_to_print_address AS is_web_to_print_address_7 FROM site s0_ WHERE s0_.is_web_to_print_address = 1;

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;