Symfony Profiler

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

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 (31);

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.device_id AS device_id_4,
  t0.accessory_id AS accessory_id_5,
  t0.field_id AS field_id_6
FROM
  content t0
WHERE
  t0.device_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.device_id AS device_id_4, t0.accessory_id AS accessory_id_5, t0.field_id AS field_id_6 FROM content t0 WHERE t0.device_id = 31;

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

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.publish = 1;

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-max' AND t0.lang_id = 1 LIMIT 1;

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_fr3760173208616';

SELECT
  p0_.id AS id_0,
  p0_.active AS active_1,
  p0_.name AS name_2,
  p0_.alias AS alias_3,
  p0_.id_ticket AS id_ticket_4,
  p0_.start_date AS start_date_5,
  p0_.end_date AS end_date_6,
  p0_.legalnotice AS legalnotice_7,
  p0_.additional_html AS additional_html_8,
  p0_.content_card_nav AS content_card_nav_9,
  p0_.content_banner AS content_banner_10,
  p0_.display_slide AS display_slide_11,
  p0_.lang_id AS lang_id_12
FROM
  promotion_automation p0_
WHERE
  p0_.active = ?
  AND p0_.start_date <= ?
  AND p0_.end_date >= ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.name AS name_2, p0_.alias AS alias_3, p0_.id_ticket AS id_ticket_4, p0_.start_date AS start_date_5, p0_.end_date AS end_date_6, p0_.legalnotice AS legalnotice_7, p0_.additional_html AS additional_html_8, p0_.content_card_nav AS content_card_nav_9, p0_.content_banner AS content_banner_10, p0_.display_slide AS display_slide_11, p0_.lang_id AS lang_id_12 FROM promotion_automation p0_ WHERE p0_.active = 1 AND p0_.start_date <= '2026-07-17 14:03:24' AND p0_.end_date >= '2026-07-17 14:03:24' LIMIT 1;

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;