Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.iso_code AS iso_code_2,
  c0_.b2b AS b2b_3
FROM
  country c0_
WHERE
  c0_.iso_code = ?
  AND c0_.b2b = ?

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.iso_code AS iso_code_2, c0_.b2b AS b2b_3 FROM country c0_ WHERE c0_.iso_code = 'FR' AND c0_.b2b = 0;

SELECT
  t0.id AS id_1,
  t0.iso_lang AS iso_lang_2,
  t0.default_lang AS default_lang_3,
  t0.country_id AS country_id_4
FROM
  lang t0
WHERE
  t0.country_id = ?

SELECT t0.id AS id_1, t0.iso_lang AS iso_lang_2, t0.default_lang AS default_lang_3, t0.country_id AS country_id_4 FROM lang t0 WHERE t0.country_id = 1;

SELECT
  t0.id AS id_1,
  t0.gencode AS gencode_2,
  t0.nom_cms AS nom_cms_3,
  t0.nom AS nom_4,
  t0.sub_title AS sub_title_5,
  t0.publish AS publish_6,
  t0.alias AS alias_7,
  t0.stock AS stock_8,
  t0.gabarit_path AS gabarit_path_9,
  t0.title AS title_10,
  t0.metadata AS metadata_11,
  t0.video AS video_12,
  t0.date_update AS date_update_13,
  t0.click_to_store AS click_to_store_14,
  t0.user_manual AS user_manual_15,
  t0.advertising AS advertising_16,
  t0.lang_id AS lang_id_17,
  t0.compiere_data_id AS compiere_data_id_18,
  t19.id AS id_20,
  t19.title AS title_21,
  t19.recap_title AS recap_title_22,
  t19.description AS description_23,
  t19.payment_title AS payment_title_24,
  t19.device_id AS device_id_25,
  t19.subscription_id AS subscription_id_26,
  t19.accessory_id AS accessory_id_27,
  t19.option_id AS option_id_28,
  t0.update_by_id AS update_by_id_29
FROM
  device t0
  LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id
WHERE
  t0.alias = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.nom_cms AS nom_cms_3, t0.nom AS nom_4, t0.sub_title AS sub_title_5, t0.publish AS publish_6, t0.alias AS alias_7, t0.stock AS stock_8, t0.gabarit_path AS gabarit_path_9, t0.title AS title_10, t0.metadata AS metadata_11, t0.video AS video_12, t0.date_update AS date_update_13, t0.click_to_store AS click_to_store_14, t0.user_manual AS user_manual_15, t0.advertising AS advertising_16, t0.lang_id AS lang_id_17, t0.compiere_data_id AS compiere_data_id_18, t19.id AS id_20, t19.title AS title_21, t19.recap_title AS recap_title_22, t19.description AS description_23, t19.payment_title AS payment_title_24, t19.device_id AS device_id_25, t19.subscription_id AS subscription_id_26, t19.accessory_id AS accessory_id_27, t19.option_id AS option_id_28, t0.update_by_id AS update_by_id_29 FROM device t0 LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id WHERE t0.alias = 'coyote-secure' AND t0.lang_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  content_tag t0
  INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id
WHERE
  device_content_tag.device_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = 10;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.title AS title_3,
  t0.is_main AS is_main_4,
  t0.device_id AS device_id_5,
  t0.accessory_id AS accessory_id_6
FROM
  image_data t0
WHERE
  t0.device_id IN (?)

SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (10);

SELECT
  t0.id AS id_1,
  t0.gencode AS gencode_2,
  t0.category_id AS category_id_3,
  t0.category_web AS category_web_4,
  t0.nom AS nom_5,
  t0.description AS description_6,
  t0.description_en AS description_en_7,
  t0.product_id AS product_id_8,
  t0.type_embarque_id AS type_embarque_id_9,
  t0.duration AS duration_10,
  t0.ecotax_no_tax AS ecotax_no_tax_11,
  t0.price_no_tax AS price_no_tax_12,
  t0.price_with_tax AS price_with_tax_13,
  t0.guarantee_days AS guarantee_days_14,
  t0.periodicity AS periodicity_15,
  t0.renewal AS renewal_16,
  t0.tax_rate AS tax_rate_17,
  t0.tax_rate_id AS tax_rate_id_18,
  t0.tax_value AS tax_value_19,
  t0.transferrable AS transferrable_20,
  t0.weight AS weight_21,
  t0.actif AS actif_22,
  t0.stock AS stock_23,
  t0.document_note AS document_note_24,
  t0.linked_brand AS linked_brand_25,
  t0.country_id AS country_id_26,
  t0.service_package_id AS service_package_id_27,
  t0.yearly AS yearly_28,
  t0.partenaire_id AS partenaire_id_29,
  t0.update_date AS update_date_30,
  t0.products_linked AS products_linked_31,
  t0.lang_id AS lang_id_32,
  t33.id AS id_34,
  t33.gencode AS gencode_35,
  t33.nom_cms AS nom_cms_36,
  t33.nom AS nom_37,
  t33.sub_title AS sub_title_38,
  t33.publish AS publish_39,
  t33.alias AS alias_40,
  t33.stock AS stock_41,
  t33.gabarit_path AS gabarit_path_42,
  t33.title AS title_43,
  t33.metadata AS metadata_44,
  t33.video AS video_45,
  t33.date_update AS date_update_46,
  t33.click_to_store AS click_to_store_47,
  t33.user_manual AS user_manual_48,
  t33.advertising AS advertising_49,
  t33.lang_id AS lang_id_50,
  t33.compiere_data_id AS compiere_data_id_51,
  t33.update_by_id AS update_by_id_52,
  t53.id AS id_54,
  t53.nom_cms AS nom_cms_55,
  t53.nom AS nom_56,
  t53.title AS title_57,
  t53.sub_title AS sub_title_58,
  t53.accroche_commerciale AS accroche_commerciale_59,
  t53.publish AS publish_60,
  t53.alias AS alias_61,
  t53.stock AS stock_62,
  t53.gencode AS gencode_63,
  t53.gabarit_path AS gabarit_path_64,
  t53.metadata AS metadata_65,
  t53.date_update AS date_update_66,
  t53.ordering AS ordering_67,
  t53.lang_id AS lang_id_68,
  t53.compiere_data_id AS compiere_data_id_69,
  t53.category_id AS category_id_70,
  t53.update_by_id AS update_by_id_71,
  t72.id AS id_73,
  t72.nom AS nom_74,
  t72.nom_cms AS nom_cms_75,
  t72.title AS title_76,
  t72.description AS description_77,
  t72.gencode AS gencode_78,
  t72.date_update AS date_update_79,
  t72.publish AS publish_80,
  t72.sub_title AS sub_title_81,
  t72.compiere_data_id AS compiere_data_id_82,
  t72.lang_id AS lang_id_83,
  t72.update_by_id AS update_by_id_84,
  t85.id AS id_86,
  t85.nom AS nom_87,
  t85.nom_cms AS nom_cms_88,
  t85.gencode AS gencode_89,
  t85.date_update AS date_update_90,
  t85.publish AS publish_91,
  t85.lang_id AS lang_id_92,
  t85.compiere_data_id AS compiere_data_id_93,
  t85.update_by_id AS update_by_id_94
FROM
  compiere_data t0
  LEFT JOIN device t33 ON t33.compiere_data_id = t0.id
  LEFT JOIN accessory t53 ON t53.compiere_data_id = t0.id
  LEFT JOIN `option` t72 ON t72.compiere_data_id = t0.id
  LEFT JOIN subscription t85 ON t85.compiere_data_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.category_id AS category_id_3, t0.category_web AS category_web_4, t0.nom AS nom_5, t0.description AS description_6, t0.description_en AS description_en_7, t0.product_id AS product_id_8, t0.type_embarque_id AS type_embarque_id_9, t0.duration AS duration_10, t0.ecotax_no_tax AS ecotax_no_tax_11, t0.price_no_tax AS price_no_tax_12, t0.price_with_tax AS price_with_tax_13, t0.guarantee_days AS guarantee_days_14, t0.periodicity AS periodicity_15, t0.renewal AS renewal_16, t0.tax_rate AS tax_rate_17, t0.tax_rate_id AS tax_rate_id_18, t0.tax_value AS tax_value_19, t0.transferrable AS transferrable_20, t0.weight AS weight_21, t0.actif AS actif_22, t0.stock AS stock_23, t0.document_note AS document_note_24, t0.linked_brand AS linked_brand_25, t0.country_id AS country_id_26, t0.service_package_id AS service_package_id_27, t0.yearly AS yearly_28, t0.partenaire_id AS partenaire_id_29, t0.update_date AS update_date_30, t0.products_linked AS products_linked_31, t0.lang_id AS lang_id_32, t33.id AS id_34, t33.gencode AS gencode_35, t33.nom_cms AS nom_cms_36, t33.nom AS nom_37, t33.sub_title AS sub_title_38, t33.publish AS publish_39, t33.alias AS alias_40, t33.stock AS stock_41, t33.gabarit_path AS gabarit_path_42, t33.title AS title_43, t33.metadata AS metadata_44, t33.video AS video_45, t33.date_update AS date_update_46, t33.click_to_store AS click_to_store_47, t33.user_manual AS user_manual_48, t33.advertising AS advertising_49, t33.lang_id AS lang_id_50, t33.compiere_data_id AS compiere_data_id_51, t33.update_by_id AS update_by_id_52, t53.id AS id_54, t53.nom_cms AS nom_cms_55, t53.nom AS nom_56, t53.title AS title_57, t53.sub_title AS sub_title_58, t53.accroche_commerciale AS accroche_commerciale_59, t53.publish AS publish_60, t53.alias AS alias_61, t53.stock AS stock_62, t53.gencode AS gencode_63, t53.gabarit_path AS gabarit_path_64, t53.metadata AS metadata_65, t53.date_update AS date_update_66, t53.ordering AS ordering_67, t53.lang_id AS lang_id_68, t53.compiere_data_id AS compiere_data_id_69, t53.category_id AS category_id_70, t53.update_by_id AS update_by_id_71, t72.id AS id_73, t72.nom AS nom_74, t72.nom_cms AS nom_cms_75, t72.title AS title_76, t72.description AS description_77, t72.gencode AS gencode_78, t72.date_update AS date_update_79, t72.publish AS publish_80, t72.sub_title AS sub_title_81, t72.compiere_data_id AS compiere_data_id_82, t72.lang_id AS lang_id_83, t72.update_by_id AS update_by_id_84, t85.id AS id_86, t85.nom AS nom_87, t85.nom_cms AS nom_cms_88, t85.gencode AS gencode_89, t85.date_update AS date_update_90, t85.publish AS publish_91, t85.lang_id AS lang_id_92, t85.compiere_data_id AS compiere_data_id_93, t85.update_by_id AS update_by_id_94 FROM compiere_data t0 LEFT JOIN device t33 ON t33.compiere_data_id = t0.id LEFT JOIN accessory t53 ON t53.compiere_data_id = t0.id LEFT JOIN `option` t72 ON t72.compiere_data_id = t0.id LEFT JOIN subscription t85 ON t85.compiere_data_id = t0.id WHERE t0.id = 'FR_fr3760173207190';

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.name AS name_3,
  t0.alias AS alias_4,
  t0.id_ticket AS id_ticket_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.legalnotice AS legalnotice_8,
  t0.additional_html AS additional_html_9,
  t0.content_card_nav AS content_card_nav_10,
  t0.content_banner AS content_banner_11,
  t0.display_slide AS display_slide_12,
  t0.lang_id AS lang_id_13
FROM
  promotion_automation t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.alias AS alias_4, t0.id_ticket AS id_ticket_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.legalnotice AS legalnotice_8, t0.additional_html AS additional_html_9, t0.content_card_nav AS content_card_nav_10, t0.content_banner AS content_banner_11, t0.display_slide AS display_slide_12, t0.lang_id AS lang_id_13 FROM promotion_automation t0 WHERE t0.active = 1;

SELECT
  c0_.id AS id_0,
  c0_.gencode AS gencode_1,
  c0_.category_id AS category_id_2,
  c0_.category_web AS category_web_3,
  c0_.nom AS nom_4,
  c0_.description AS description_5,
  c0_.description_en AS description_en_6,
  c0_.product_id AS product_id_7,
  c0_.type_embarque_id AS type_embarque_id_8,
  c0_.duration AS duration_9,
  c0_.ecotax_no_tax AS ecotax_no_tax_10,
  c0_.price_no_tax AS price_no_tax_11,
  c0_.price_with_tax AS price_with_tax_12,
  c0_.guarantee_days AS guarantee_days_13,
  c0_.periodicity AS periodicity_14,
  c0_.renewal AS renewal_15,
  c0_.tax_rate AS tax_rate_16,
  c0_.tax_rate_id AS tax_rate_id_17,
  c0_.tax_value AS tax_value_18,
  c0_.transferrable AS transferrable_19,
  c0_.weight AS weight_20,
  c0_.actif AS actif_21,
  c0_.stock AS stock_22,
  c0_.document_note AS document_note_23,
  c0_.linked_brand AS linked_brand_24,
  c0_.country_id AS country_id_25,
  c0_.service_package_id AS service_package_id_26,
  c0_.yearly AS yearly_27,
  c0_.partenaire_id AS partenaire_id_28,
  c0_.update_date AS update_date_29,
  c0_.products_linked AS products_linked_30,
  l1_.id AS id_31,
  l1_.iso_lang AS iso_lang_32,
  l1_.default_lang AS default_lang_33,
  d2_.id AS id_34,
  d2_.gencode AS gencode_35,
  d2_.nom_cms AS nom_cms_36,
  d2_.nom AS nom_37,
  d2_.sub_title AS sub_title_38,
  d2_.publish AS publish_39,
  d2_.alias AS alias_40,
  d2_.stock AS stock_41,
  d2_.gabarit_path AS gabarit_path_42,
  d2_.title AS title_43,
  d2_.metadata AS metadata_44,
  d2_.video AS video_45,
  d2_.date_update AS date_update_46,
  d2_.click_to_store AS click_to_store_47,
  d2_.user_manual AS user_manual_48,
  d2_.advertising AS advertising_49,
  a3_.id AS id_50,
  a3_.nom_cms AS nom_cms_51,
  a3_.nom AS nom_52,
  a3_.title AS title_53,
  a3_.sub_title AS sub_title_54,
  a3_.accroche_commerciale AS accroche_commerciale_55,
  a3_.publish AS publish_56,
  a3_.alias AS alias_57,
  a3_.stock AS stock_58,
  a3_.gencode AS gencode_59,
  a3_.gabarit_path AS gabarit_path_60,
  a3_.metadata AS metadata_61,
  a3_.date_update AS date_update_62,
  a3_.ordering AS ordering_63,
  o4_.id AS id_64,
  o4_.nom AS nom_65,
  o4_.nom_cms AS nom_cms_66,
  o4_.title AS title_67,
  o4_.description AS description_68,
  o4_.gencode AS gencode_69,
  o4_.date_update AS date_update_70,
  o4_.publish AS publish_71,
  o4_.sub_title AS sub_title_72,
  s5_.id AS id_73,
  s5_.nom AS nom_74,
  s5_.nom_cms AS nom_cms_75,
  s5_.gencode AS gencode_76,
  s5_.date_update AS date_update_77,
  s5_.publish AS publish_78,
  c0_.lang_id AS lang_id_79,
  l1_.country_id AS country_id_80,
  d2_.lang_id AS lang_id_81,
  d2_.compiere_data_id AS compiere_data_id_82,
  d2_.update_by_id AS update_by_id_83,
  a3_.lang_id AS lang_id_84,
  a3_.compiere_data_id AS compiere_data_id_85,
  a3_.category_id AS category_id_86,
  a3_.update_by_id AS update_by_id_87,
  o4_.compiere_data_id AS compiere_data_id_88,
  o4_.lang_id AS lang_id_89,
  o4_.update_by_id AS update_by_id_90,
  s5_.lang_id AS lang_id_91,
  s5_.compiere_data_id AS compiere_data_id_92,
  s5_.update_by_id AS update_by_id_93
FROM
  compiere_data c0_
  LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id
  LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id
  LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id
  LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id
  LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id
WHERE
  c0_.gencode = ?
  AND c0_.lang_id = ?

SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = '2990000000780' AND c0_.lang_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.gencode AS gencode_1,
  c0_.category_id AS category_id_2,
  c0_.category_web AS category_web_3,
  c0_.nom AS nom_4,
  c0_.description AS description_5,
  c0_.description_en AS description_en_6,
  c0_.product_id AS product_id_7,
  c0_.type_embarque_id AS type_embarque_id_8,
  c0_.duration AS duration_9,
  c0_.ecotax_no_tax AS ecotax_no_tax_10,
  c0_.price_no_tax AS price_no_tax_11,
  c0_.price_with_tax AS price_with_tax_12,
  c0_.guarantee_days AS guarantee_days_13,
  c0_.periodicity AS periodicity_14,
  c0_.renewal AS renewal_15,
  c0_.tax_rate AS tax_rate_16,
  c0_.tax_rate_id AS tax_rate_id_17,
  c0_.tax_value AS tax_value_18,
  c0_.transferrable AS transferrable_19,
  c0_.weight AS weight_20,
  c0_.actif AS actif_21,
  c0_.stock AS stock_22,
  c0_.document_note AS document_note_23,
  c0_.linked_brand AS linked_brand_24,
  c0_.country_id AS country_id_25,
  c0_.service_package_id AS service_package_id_26,
  c0_.yearly AS yearly_27,
  c0_.partenaire_id AS partenaire_id_28,
  c0_.update_date AS update_date_29,
  c0_.products_linked AS products_linked_30,
  l1_.id AS id_31,
  l1_.iso_lang AS iso_lang_32,
  l1_.default_lang AS default_lang_33,
  d2_.id AS id_34,
  d2_.gencode AS gencode_35,
  d2_.nom_cms AS nom_cms_36,
  d2_.nom AS nom_37,
  d2_.sub_title AS sub_title_38,
  d2_.publish AS publish_39,
  d2_.alias AS alias_40,
  d2_.stock AS stock_41,
  d2_.gabarit_path AS gabarit_path_42,
  d2_.title AS title_43,
  d2_.metadata AS metadata_44,
  d2_.video AS video_45,
  d2_.date_update AS date_update_46,
  d2_.click_to_store AS click_to_store_47,
  d2_.user_manual AS user_manual_48,
  d2_.advertising AS advertising_49,
  a3_.id AS id_50,
  a3_.nom_cms AS nom_cms_51,
  a3_.nom AS nom_52,
  a3_.title AS title_53,
  a3_.sub_title AS sub_title_54,
  a3_.accroche_commerciale AS accroche_commerciale_55,
  a3_.publish AS publish_56,
  a3_.alias AS alias_57,
  a3_.stock AS stock_58,
  a3_.gencode AS gencode_59,
  a3_.gabarit_path AS gabarit_path_60,
  a3_.metadata AS metadata_61,
  a3_.date_update AS date_update_62,
  a3_.ordering AS ordering_63,
  o4_.id AS id_64,
  o4_.nom AS nom_65,
  o4_.nom_cms AS nom_cms_66,
  o4_.title AS title_67,
  o4_.description AS description_68,
  o4_.gencode AS gencode_69,
  o4_.date_update AS date_update_70,
  o4_.publish AS publish_71,
  o4_.sub_title AS sub_title_72,
  s5_.id AS id_73,
  s5_.nom AS nom_74,
  s5_.nom_cms AS nom_cms_75,
  s5_.gencode AS gencode_76,
  s5_.date_update AS date_update_77,
  s5_.publish AS publish_78,
  c0_.lang_id AS lang_id_79,
  l1_.country_id AS country_id_80,
  d2_.lang_id AS lang_id_81,
  d2_.compiere_data_id AS compiere_data_id_82,
  d2_.update_by_id AS update_by_id_83,
  a3_.lang_id AS lang_id_84,
  a3_.compiere_data_id AS compiere_data_id_85,
  a3_.category_id AS category_id_86,
  a3_.update_by_id AS update_by_id_87,
  o4_.compiere_data_id AS compiere_data_id_88,
  o4_.lang_id AS lang_id_89,
  o4_.update_by_id AS update_by_id_90,
  s5_.lang_id AS lang_id_91,
  s5_.compiere_data_id AS compiere_data_id_92,
  s5_.update_by_id AS update_by_id_93
FROM
  compiere_data c0_
  LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id
  LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id
  LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id
  LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id
  LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id
WHERE
  c0_.gencode = ?
  AND c0_.lang_id = ?

SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = '2990000000782' AND c0_.lang_id = 1;