Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.date AS date_4,
  t0.email AS email_5,
  t0.signature AS signature_6,
  t0.npa AS npa_7,
  t0.address AS address_8,
  t0.address2 AS address2_9,
  t0.locality AS locality_10,
  t0.updated_at AS updated_at_11,
  t0.anonymous AS anonymous_12,
  t0.company AS company_13,
  t0.validated_at AS validated_at_14,
  t0.hash AS hash_15,
  t0.text AS text_16,
  t0.note AS note_17,
  t0.invoiced_at AS invoiced_at_18,
  t0.printed_at AS printed_at_19,
  t0.reminder_at AS reminder_at_20,
  t0.reference AS reference_21,
  t0.reminder_printed_at AS reminder_printed_at_22,
  t0.completed_by_donor AS completed_by_donor_23,
  t0.ip_address AS ip_address_24,
  t0.phone_number AS phone_number_25,
  t0.demand_sent_at AS demand_sent_at_26,
  t0.use_twint_jm AS use_twint_jm_27,
  t0.created_by_id AS created_by_id_28,
  t29.id AS id_30,
  t29.username AS username_31,
  t29.roles AS roles_32,
  t29.password AS password_33,
  t29.hash AS hash_34,
  t29.email AS email_35,
  t29.firstname AS firstname_36,
  t29.lastname AS lastname_37,
  t29.no_carnet AS no_carnet_38,
  t29.phone AS phone_39,
  t29.identification_hash AS identification_hash_40,
  t29.active AS active_41,
  t29.show_notification AS show_notification_42,
  t29.locale AS locale_43,
  t29.domain_id AS domain_id_44,
  t0.updated_by_id AS updated_by_id_45,
  t0.payment_mode_id AS payment_mode_id_46,
  t47.id AS id_48,
  t47.name AS name_49,
  t47.description AS description_50,
  t0.printed_by_id AS printed_by_id_51,
  t0.reminder_printed_by_id AS reminder_printed_by_id_52,
  t53.id AS id_54,
  t53.token AS token_55,
  t53.pairing_uuid AS pairing_uuid_56,
  t53.order_uuid AS order_uuid_57,
  t53.timestamp AS timestamp_58,
  t53.paid AS paid_59,
  t53.merchant_transaction_reference AS merchant_transaction_reference_60,
  t53.order_pending AS order_pending_61,
  t53.annonceur_id AS annonceur_id_62,
  t63.values AS values_64,
  t63.annonceur_id AS annonceur_id_65
FROM
  annonceur t0
  INNER JOIN fosuser t29 ON t0.created_by_id = t29.id
  INNER JOIN payment_mode t47 ON t0.payment_mode_id = t47.id
  LEFT JOIN twint_payment t53 ON t53.annonceur_id = t0.id
  LEFT JOIN annonceur_extra_value t63 ON t63.annonceur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date AS date_4, t0.email AS email_5, t0.signature AS signature_6, t0.npa AS npa_7, t0.address AS address_8, t0.address2 AS address2_9, t0.locality AS locality_10, t0.updated_at AS updated_at_11, t0.anonymous AS anonymous_12, t0.company AS company_13, t0.validated_at AS validated_at_14, t0.hash AS hash_15, t0.text AS text_16, t0.note AS note_17, t0.invoiced_at AS invoiced_at_18, t0.printed_at AS printed_at_19, t0.reminder_at AS reminder_at_20, t0.reference AS reference_21, t0.reminder_printed_at AS reminder_printed_at_22, t0.completed_by_donor AS completed_by_donor_23, t0.ip_address AS ip_address_24, t0.phone_number AS phone_number_25, t0.demand_sent_at AS demand_sent_at_26, t0.use_twint_jm AS use_twint_jm_27, t0.created_by_id AS created_by_id_28, t29.id AS id_30, t29.username AS username_31, t29.roles AS roles_32, t29.password AS password_33, t29.hash AS hash_34, t29.email AS email_35, t29.firstname AS firstname_36, t29.lastname AS lastname_37, t29.no_carnet AS no_carnet_38, t29.phone AS phone_39, t29.identification_hash AS identification_hash_40, t29.active AS active_41, t29.show_notification AS show_notification_42, t29.locale AS locale_43, t29.domain_id AS domain_id_44, t0.updated_by_id AS updated_by_id_45, t0.payment_mode_id AS payment_mode_id_46, t47.id AS id_48, t47.name AS name_49, t47.description AS description_50, t0.printed_by_id AS printed_by_id_51, t0.reminder_printed_by_id AS reminder_printed_by_id_52, t53.id AS id_54, t53.token AS token_55, t53.pairing_uuid AS pairing_uuid_56, t53.order_uuid AS order_uuid_57, t53.timestamp AS timestamp_58, t53.paid AS paid_59, t53.merchant_transaction_reference AS merchant_transaction_reference_60, t53.order_pending AS order_pending_61, t53.annonceur_id AS annonceur_id_62, t63.values AS values_64, t63.annonceur_id AS annonceur_id_65 FROM annonceur t0 INNER JOIN fosuser t29 ON t0.created_by_id = t29.id INNER JOIN payment_mode t47 ON t0.payment_mode_id = t47.id LEFT JOIN twint_payment t53 ON t53.annonceur_id = t0.id LEFT JOIN annonceur_extra_value t63 ON t63.annonceur_id = t0.id WHERE t0.id = 'e71d5af6-5d1c-42ad-a564-6569309a8183';

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.auto AS auto_3,
  t0.debtor_name AS debtor_name_4,
  t0.debtor_address AS debtor_address_5,
  t0.debtor_iban AS debtor_iban_6,
  t0.amount AS amount_7,
  t0.description AS description_8,
  t0.payment_group_id AS payment_group_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.msg_id AS msg_id_13,
  t10.ebanking_date_creation AS ebanking_date_creation_14,
  t10.imported_by_id AS imported_by_id_15,
  t0.annonceur_id AS annonceur_id_16,
  t17.id AS id_18,
  t17.firstname AS firstname_19,
  t17.lastname AS lastname_20,
  t17.date AS date_21,
  t17.email AS email_22,
  t17.signature AS signature_23,
  t17.npa AS npa_24,
  t17.address AS address_25,
  t17.address2 AS address2_26,
  t17.locality AS locality_27,
  t17.updated_at AS updated_at_28,
  t17.anonymous AS anonymous_29,
  t17.company AS company_30,
  t17.validated_at AS validated_at_31,
  t17.hash AS hash_32,
  t17.text AS text_33,
  t17.note AS note_34,
  t17.invoiced_at AS invoiced_at_35,
  t17.printed_at AS printed_at_36,
  t17.reminder_at AS reminder_at_37,
  t17.reference AS reference_38,
  t17.reminder_printed_at AS reminder_printed_at_39,
  t17.completed_by_donor AS completed_by_donor_40,
  t17.ip_address AS ip_address_41,
  t17.phone_number AS phone_number_42,
  t17.demand_sent_at AS demand_sent_at_43,
  t17.use_twint_jm AS use_twint_jm_44,
  t17.created_by_id AS created_by_id_45,
  t17.updated_by_id AS updated_by_id_46,
  t17.payment_mode_id AS payment_mode_id_47,
  t17.printed_by_id AS printed_by_id_48,
  t17.reminder_printed_by_id AS reminder_printed_by_id_49,
  t0.user_payment_id AS user_payment_id_50,
  t0.twint_payment_id AS twint_payment_id_51,
  t52.id AS id_53,
  t52.token AS token_54,
  t52.pairing_uuid AS pairing_uuid_55,
  t52.order_uuid AS order_uuid_56,
  t52.timestamp AS timestamp_57,
  t52.paid AS paid_58,
  t52.merchant_transaction_reference AS merchant_transaction_reference_59,
  t52.order_pending AS order_pending_60,
  t52.annonceur_id AS annonceur_id_61
FROM
  payment t0
  INNER JOIN payment_group t10 ON t0.payment_group_id = t10.id
  LEFT JOIN annonceur t17 ON t0.annonceur_id = t17.id
  LEFT JOIN twint_payment t52 ON t0.twint_payment_id = t52.id
WHERE
  t0.twint_payment_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.auto AS auto_3, t0.debtor_name AS debtor_name_4, t0.debtor_address AS debtor_address_5, t0.debtor_iban AS debtor_iban_6, t0.amount AS amount_7, t0.description AS description_8, t0.payment_group_id AS payment_group_id_9, t10.id AS id_11, t10.date AS date_12, t10.msg_id AS msg_id_13, t10.ebanking_date_creation AS ebanking_date_creation_14, t10.imported_by_id AS imported_by_id_15, t0.annonceur_id AS annonceur_id_16, t17.id AS id_18, t17.firstname AS firstname_19, t17.lastname AS lastname_20, t17.date AS date_21, t17.email AS email_22, t17.signature AS signature_23, t17.npa AS npa_24, t17.address AS address_25, t17.address2 AS address2_26, t17.locality AS locality_27, t17.updated_at AS updated_at_28, t17.anonymous AS anonymous_29, t17.company AS company_30, t17.validated_at AS validated_at_31, t17.hash AS hash_32, t17.text AS text_33, t17.note AS note_34, t17.invoiced_at AS invoiced_at_35, t17.printed_at AS printed_at_36, t17.reminder_at AS reminder_at_37, t17.reference AS reference_38, t17.reminder_printed_at AS reminder_printed_at_39, t17.completed_by_donor AS completed_by_donor_40, t17.ip_address AS ip_address_41, t17.phone_number AS phone_number_42, t17.demand_sent_at AS demand_sent_at_43, t17.use_twint_jm AS use_twint_jm_44, t17.created_by_id AS created_by_id_45, t17.updated_by_id AS updated_by_id_46, t17.payment_mode_id AS payment_mode_id_47, t17.printed_by_id AS printed_by_id_48, t17.reminder_printed_by_id AS reminder_printed_by_id_49, t0.user_payment_id AS user_payment_id_50, t0.twint_payment_id AS twint_payment_id_51, t52.id AS id_53, t52.token AS token_54, t52.pairing_uuid AS pairing_uuid_55, t52.order_uuid AS order_uuid_56, t52.timestamp AS timestamp_57, t52.paid AS paid_58, t52.merchant_transaction_reference AS merchant_transaction_reference_59, t52.order_pending AS order_pending_60, t52.annonceur_id AS annonceur_id_61 FROM payment t0 INNER JOIN payment_group t10 ON t0.payment_group_id = t10.id LEFT JOIN annonceur t17 ON t0.annonceur_id = t17.id LEFT JOIN twint_payment t52 ON t0.twint_payment_id = t52.id WHERE t0.twint_payment_id = 8958;

SELECT
  t0.id AS id_1,
  t0.carnet_name AS carnet_name_2,
  t0.iban AS iban_3,
  t0.identification AS identification_4,
  t0.email AS email_5,
  t0.logo AS logo_6,
  t0.company_name AS company_name_7,
  t0.company_representative AS company_representative_8,
  t0.address AS address_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.phone_number AS phone_number_12,
  t0.payment_recipient AS payment_recipient_13,
  t0.payment_address AS payment_address_14,
  t0.payment_postal_code AS payment_postal_code_15,
  t0.payment_city AS payment_city_16,
  t0.min_amount AS min_amount_17,
  t0.max_amount AS max_amount_18,
  t0.use_twint_jm AS use_twint_jm_19,
  t0.twint_fees AS twint_fees_20,
  t0.twint_iban_for_payments AS twint_iban_for_payments_21,
  t0.min_twint_jmamount AS min_twint_jmamount_22,
  t0.twint_merchant_uuid AS twint_merchant_uuid_23,
  t0.twint_enable AS twint_enable_24,
  t0.twint_passphrase AS twint_passphrase_25,
  t0.twint_certificat_path AS twint_certificat_path_26,
  t0.prefix AS prefix_27,
  t0.closing_date AS closing_date_28,
  t0.catalog_image_wide AS catalog_image_wide_29,
  t0.catalog_image_narrow AS catalog_image_narrow_30,
  t0.allow_anonymous AS allow_anonymous_31,
  t0.send_receipt_email AS send_receipt_email_32,
  t0.invoice_min_amount AS invoice_min_amount_33,
  t0.user_creation_hash AS user_creation_hash_34,
  t0.sponsor_banner AS sponsor_banner_35,
  t0.show_sponsor_on_invoice AS show_sponsor_on_invoice_36,
  t0.cotisation AS cotisation_37,
  t0.display_phone_number_field AS display_phone_number_field_38,
  t0.vat_identification_number AS vat_identification_number_39,
  t0.user_instruction AS user_instruction_40,
  t0.objectif AS objectif_41,
  t0.locale AS locale_42,
  t0.print_locale_is_user_locale AS print_locale_is_user_locale_43
FROM
  domain t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.carnet_name AS carnet_name_2, t0.iban AS iban_3, t0.identification AS identification_4, t0.email AS email_5, t0.logo AS logo_6, t0.company_name AS company_name_7, t0.company_representative AS company_representative_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.phone_number AS phone_number_12, t0.payment_recipient AS payment_recipient_13, t0.payment_address AS payment_address_14, t0.payment_postal_code AS payment_postal_code_15, t0.payment_city AS payment_city_16, t0.min_amount AS min_amount_17, t0.max_amount AS max_amount_18, t0.use_twint_jm AS use_twint_jm_19, t0.twint_fees AS twint_fees_20, t0.twint_iban_for_payments AS twint_iban_for_payments_21, t0.min_twint_jmamount AS min_twint_jmamount_22, t0.twint_merchant_uuid AS twint_merchant_uuid_23, t0.twint_enable AS twint_enable_24, t0.twint_passphrase AS twint_passphrase_25, t0.twint_certificat_path AS twint_certificat_path_26, t0.prefix AS prefix_27, t0.closing_date AS closing_date_28, t0.catalog_image_wide AS catalog_image_wide_29, t0.catalog_image_narrow AS catalog_image_narrow_30, t0.allow_anonymous AS allow_anonymous_31, t0.send_receipt_email AS send_receipt_email_32, t0.invoice_min_amount AS invoice_min_amount_33, t0.user_creation_hash AS user_creation_hash_34, t0.sponsor_banner AS sponsor_banner_35, t0.show_sponsor_on_invoice AS show_sponsor_on_invoice_36, t0.cotisation AS cotisation_37, t0.display_phone_number_field AS display_phone_number_field_38, t0.vat_identification_number AS vat_identification_number_39, t0.user_instruction AS user_instruction_40, t0.objectif AS objectif_41, t0.locale AS locale_42, t0.print_locale_is_user_locale AS print_locale_is_user_locale_43 FROM domain t0 WHERE t0.id IN ('75654e6b-eb75-43af-ac4d-4a1d175b9c2c');

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  annonceur
SET
  date = ?,
  hash = ?
WHERE
  id = ?

UPDATE annonceur SET date = '2026-01-20 16:47:19', hash = NULL WHERE id = 'e71d5af6-5d1c-42ad-a564-6569309a8183';

UPDATE
  twint_payment
SET
  paid = ?,
  order_pending = ?
WHERE
  id = ?

UPDATE twint_payment SET paid = 1, order_pending = 0 WHERE id = 8958;

"COMMIT"

"COMMIT";

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'signature'
            AND tt.id = 7
        ;

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'title_receipt_paid'
            AND tt.id = 15
        ;

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'title_receipt_not_paid'
            AND tt.id = 15
        ;

SELECT
  t0.id AS id_1,
  t0.unit_price AS unit_price_2,
  t0.quantity AS quantity_3,
  t0.total_price AS total_price_4,
  t0.vat_included AS vat_included_5,
  t0.annonceur_id AS annonceur_id_6,
  t0.item_id AS item_id_7
FROM
  annonceur_item_purchase t0
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.unit_price AS unit_price_2, t0.quantity AS quantity_3, t0.total_price AS total_price_4, t0.vat_included AS vat_included_5, t0.annonceur_id AS annonceur_id_6, t0.item_id AS item_id_7 FROM annonceur_item_purchase t0 WHERE t0.annonceur_id = 'e71d5af6-5d1c-42ad-a564-6569309a8183';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.fixed_price AS fixed_price_4,
  t0.max_price AS max_price_5,
  t0.priority AS priority_6,
  t0.min_quantity AS min_quantity_7,
  t0.max_quantity AS max_quantity_8,
  t0.hidden AS hidden_9,
  t0.vat_included AS vat_included_10,
  t0.domain_id AS domain_id_11
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.fixed_price AS fixed_price_4, t0.max_price AS max_price_5, t0.priority AS priority_6, t0.min_quantity AS min_quantity_7, t0.max_quantity AS max_quantity_8, t0.hidden AS hidden_9, t0.vat_included AS vat_included_10, t0.domain_id AS domain_id_11 FROM item t0 WHERE t0.id = '7bdf57fc-d905-43c3-9ebb-779cff2764ad';

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.domain_id AS domain_id_3,
  t0.template_type_id AS template_type_id_4
FROM
  template t0
WHERE
  t0.template_type_id = ?
  AND t0.domain_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.domain_id AS domain_id_3, t0.template_type_id AS template_type_id_4 FROM template t0 WHERE t0.template_type_id = 11 AND t0.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c' LIMIT 1;

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'company_info'
            AND tt.id = 7
        ;

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'title_receipt_paid'
            AND tt.id = 15
        ;

SELECT
  COALESCE(tv.value, c.default_value, '') as value
FROM
  component as c
  INNER JOIN template_type as tt ON tt.id = c.template_type_id
  LEFT JOIN template as t ON t.template_type_id = tt.id
  AND t.domain_id = :domain
  LEFT JOIN template_value as tv ON tv.template_id = t.id
  AND tv.component_id = c.id
WHERE
  c.key = :component_key
  AND tt.id = :template_type_id

SELECT COALESCE(tv.value, c.default_value, '') as value
            FROM component as c
            INNER JOIN template_type as tt
            ON tt.id = c.template_type_id
            LEFT JOIN template as t
            ON t.template_type_id = tt.id AND t.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c'
            LEFT JOIN template_value as tv
            ON tv.template_id = t.id AND tv.component_id = c.id
            WHERE c.key = 'title_receipt_not_paid'
            AND tt.id = 15
        ;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.domain_id AS domain_id_3,
  t0.template_type_id AS template_type_id_4
FROM
  template t0
WHERE
  t0.template_type_id = ?
  AND t0.domain_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.domain_id AS domain_id_3, t0.template_type_id AS template_type_id_4 FROM template t0 WHERE t0.template_type_id = 11 AND t0.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c' LIMIT 1;