Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.hash AS hash_5,
  t0.email AS email_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.no_carnet AS no_carnet_9,
  t0.phone AS phone_10,
  t0.identification_hash AS identification_hash_11,
  t0.active AS active_12,
  t0.show_notification AS show_notification_13,
  t0.locale AS locale_14,
  t0.domain_id AS domain_id_15,
  t16.id AS id_17,
  t16.carnet_name AS carnet_name_18,
  t16.iban AS iban_19,
  t16.identification AS identification_20,
  t16.email AS email_21,
  t16.logo AS logo_22,
  t16.company_name AS company_name_23,
  t16.company_representative AS company_representative_24,
  t16.address AS address_25,
  t16.postal_code AS postal_code_26,
  t16.city AS city_27,
  t16.phone_number AS phone_number_28,
  t16.payment_recipient AS payment_recipient_29,
  t16.payment_address AS payment_address_30,
  t16.payment_postal_code AS payment_postal_code_31,
  t16.payment_city AS payment_city_32,
  t16.min_amount AS min_amount_33,
  t16.max_amount AS max_amount_34,
  t16.use_twint_jm AS use_twint_jm_35,
  t16.twint_fees AS twint_fees_36,
  t16.twint_iban_for_payments AS twint_iban_for_payments_37,
  t16.min_twint_jmamount AS min_twint_jmamount_38,
  t16.twint_merchant_uuid AS twint_merchant_uuid_39,
  t16.twint_enable AS twint_enable_40,
  t16.twint_passphrase AS twint_passphrase_41,
  t16.twint_certificat_path AS twint_certificat_path_42,
  t16.prefix AS prefix_43,
  t16.closing_date AS closing_date_44,
  t16.catalog_image_wide AS catalog_image_wide_45,
  t16.catalog_image_narrow AS catalog_image_narrow_46,
  t16.allow_anonymous AS allow_anonymous_47,
  t16.send_receipt_email AS send_receipt_email_48,
  t16.invoice_min_amount AS invoice_min_amount_49,
  t16.user_creation_hash AS user_creation_hash_50,
  t16.sponsor_banner AS sponsor_banner_51,
  t16.show_sponsor_on_invoice AS show_sponsor_on_invoice_52,
  t16.cotisation AS cotisation_53,
  t16.display_phone_number_field AS display_phone_number_field_54,
  t16.vat_identification_number AS vat_identification_number_55,
  t16.user_instruction AS user_instruction_56,
  t16.objectif AS objectif_57,
  t16.locale AS locale_58,
  t16.print_locale_is_user_locale AS print_locale_is_user_locale_59
FROM
  fosuser t0
  INNER JOIN domain t16 ON t0.domain_id = t16.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.hash AS hash_5, t0.email AS email_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.no_carnet AS no_carnet_9, t0.phone AS phone_10, t0.identification_hash AS identification_hash_11, t0.active AS active_12, t0.show_notification AS show_notification_13, t0.locale AS locale_14, t0.domain_id AS domain_id_15, t16.id AS id_17, t16.carnet_name AS carnet_name_18, t16.iban AS iban_19, t16.identification AS identification_20, t16.email AS email_21, t16.logo AS logo_22, t16.company_name AS company_name_23, t16.company_representative AS company_representative_24, t16.address AS address_25, t16.postal_code AS postal_code_26, t16.city AS city_27, t16.phone_number AS phone_number_28, t16.payment_recipient AS payment_recipient_29, t16.payment_address AS payment_address_30, t16.payment_postal_code AS payment_postal_code_31, t16.payment_city AS payment_city_32, t16.min_amount AS min_amount_33, t16.max_amount AS max_amount_34, t16.use_twint_jm AS use_twint_jm_35, t16.twint_fees AS twint_fees_36, t16.twint_iban_for_payments AS twint_iban_for_payments_37, t16.min_twint_jmamount AS min_twint_jmamount_38, t16.twint_merchant_uuid AS twint_merchant_uuid_39, t16.twint_enable AS twint_enable_40, t16.twint_passphrase AS twint_passphrase_41, t16.twint_certificat_path AS twint_certificat_path_42, t16.prefix AS prefix_43, t16.closing_date AS closing_date_44, t16.catalog_image_wide AS catalog_image_wide_45, t16.catalog_image_narrow AS catalog_image_narrow_46, t16.allow_anonymous AS allow_anonymous_47, t16.send_receipt_email AS send_receipt_email_48, t16.invoice_min_amount AS invoice_min_amount_49, t16.user_creation_hash AS user_creation_hash_50, t16.sponsor_banner AS sponsor_banner_51, t16.show_sponsor_on_invoice AS show_sponsor_on_invoice_52, t16.cotisation AS cotisation_53, t16.display_phone_number_field AS display_phone_number_field_54, t16.vat_identification_number AS vat_identification_number_55, t16.user_instruction AS user_instruction_56, t16.objectif AS objectif_57, t16.locale AS locale_58, t16.print_locale_is_user_locale AS print_locale_is_user_locale_59 FROM fosuser t0 INNER JOIN domain t16 ON t0.domain_id = t16.id WHERE t0.id = 'dee9975d-6f52-4bde-af14-bfa2cae7ef11';

SELECT
  a.*,
  aip.amount
FROM
  (
    SELECT
      s.id AS id,
      s.firstname AS firstname,
      s.lastname AS lastname,
      s.date AS date,
      s.email AS email,
      s.signature AS signature,
      s.npa AS npa,
      s.address AS address,
      s.address2 AS address2,
      s.locality AS locality,
      s.updated_at AS updated_at,
      s.anonymous AS anonymous,
      s.company AS company,
      s.validated_at AS validated_at,
      s.hash AS hash,
      s.text AS text,
      s.note AS note,
      s.invoiced_at AS invoiced_at,
      s.printed_at AS printed_at,
      s.reminder_at AS reminder_at,
      s.reference AS reference,
      s.reminder_printed_at AS reminder_printed_at,
      s.completed_by_donor AS completed_by_donor,
      s.ip_address AS ip_address,
      s.phone_number AS phone_number,
      s.demand_sent_at AS demand_sent_at,
      s.use_twint_jm AS use_twint_jm,
      s.created_by_id AS created_by_id,
      s.updated_by_id AS updated_by_id,
      s.payment_mode_id AS payment_mode_id,
      s.printed_by_id AS printed_by_id,
      s.reminder_printed_by_id AS reminder_printed_by_id
    from
      annonceur s
  ) AS a
  inner join fosuser u ON u.id = a.created_by_id
  inner join payment_mode pm on pm.id = a.payment_mode_id
  LEFT JOIN (
    SELECT
      annonceur_id,
      SUM(total_price) AS amount
    FROM
      annonceur_item_purchase
    GROUP BY
      annonceur_id
  ) aip ON aip.annonceur_id = a.id
WHERE
  1 = 1
  AND u.domain_id = ?
  AND a.hash IS NULL
  AND a.created_by_id = ?
ORDER BY
  date desc
LIMIT
  25
OFFSET
  0

SELECT a.*, aip.amount
FROM (
	SELECT s.id AS id, s.firstname AS firstname, s.lastname AS lastname, s.date AS date, s.email AS email, s.signature AS signature, s.npa AS npa, s.address AS address, s.address2 AS address2, s.locality AS locality, s.updated_at AS updated_at, s.anonymous AS anonymous, s.company AS company, s.validated_at AS validated_at, s.hash AS hash, s.text AS text, s.note AS note, s.invoiced_at AS invoiced_at, s.printed_at AS printed_at, s.reminder_at AS reminder_at, s.reference AS reference, s.reminder_printed_at AS reminder_printed_at, s.completed_by_donor AS completed_by_donor, s.ip_address AS ip_address, s.phone_number AS phone_number, s.demand_sent_at AS demand_sent_at, s.use_twint_jm AS use_twint_jm, s.created_by_id AS created_by_id, s.updated_by_id AS updated_by_id, s.payment_mode_id AS payment_mode_id, s.printed_by_id AS printed_by_id, s.reminder_printed_by_id AS reminder_printed_by_id
	from annonceur s
) AS a
inner join fosuser u
ON u.id = a.created_by_id
inner join payment_mode pm
on pm.id = a.payment_mode_id
LEFT JOIN (
    SELECT annonceur_id, SUM(total_price) AS amount
    FROM annonceur_item_purchase
    GROUP BY annonceur_id
) aip
ON aip.annonceur_id = a.id
WHERE 1 = 1 AND u.domain_id = '6bc462fc-08ee-473f-8b8a-f44aa8a655ab' AND a.hash IS NULL AND a.created_by_id = 'dee9975d-6f52-4bde-af14-bfa2cae7ef11'  ORDER BY date desc LIMIT 25 OFFSET 0;

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = '1b62e531-5552-4981-8443-22621d1335a4';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  payment_mode t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM payment_mode t0 WHERE t0.id IN (2);

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = '1b62e531-5552-4981-8443-22621d1335a4';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = 'ce088edb-88b3-4f0f-b5c5-a2706215a851';

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = 'ce088edb-88b3-4f0f-b5c5-a2706215a851';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = 'a65d5987-762a-4b3d-88aa-29e728710920';

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = 'a65d5987-762a-4b3d-88aa-29e728710920';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = 'fe4ca440-ad5b-4c49-89de-2477f5def478';

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = 'fe4ca440-ad5b-4c49-89de-2477f5def478';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = '1937812f-5a90-4d2b-a38a-2403e7791d49';

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = '1937812f-5a90-4d2b-a38a-2403e7791d49';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = '951a069b-0f22-439f-b4a7-6394f38634b6';

SELECT
  t0.values AS values_1,
  t0.annonceur_id AS annonceur_id_2
FROM
  annonceur_extra_value t0
WHERE
  t0.annonceur_id = ?

SELECT t0.values AS values_1, t0.annonceur_id AS annonceur_id_2 FROM annonceur_extra_value t0 WHERE t0.annonceur_id = '951a069b-0f22-439f-b4a7-6394f38634b6';

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.pairing_uuid AS pairing_uuid_3,
  t0.order_uuid AS order_uuid_4,
  t0.timestamp AS timestamp_5,
  t0.paid AS paid_6,
  t0.merchant_transaction_reference AS merchant_transaction_reference_7,
  t0.order_pending AS order_pending_8,
  t0.annonceur_id AS annonceur_id_9,
  t10.id AS id_11,
  t10.date AS date_12,
  t10.auto AS auto_13,
  t10.debtor_name AS debtor_name_14,
  t10.debtor_address AS debtor_address_15,
  t10.debtor_iban AS debtor_iban_16,
  t10.amount AS amount_17,
  t10.description AS description_18,
  t10.payment_group_id AS payment_group_id_19,
  t10.annonceur_id AS annonceur_id_20,
  t10.user_payment_id AS user_payment_id_21,
  t10.twint_payment_id AS twint_payment_id_22
FROM
  twint_payment t0
  LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id
WHERE
  t0.annonceur_id = ?

SELECT t0.id AS id_1, t0.token AS token_2, t0.pairing_uuid AS pairing_uuid_3, t0.order_uuid AS order_uuid_4, t0.timestamp AS timestamp_5, t0.paid AS paid_6, t0.merchant_transaction_reference AS merchant_transaction_reference_7, t0.order_pending AS order_pending_8, t0.annonceur_id AS annonceur_id_9, t10.id AS id_11, t10.date AS date_12, t10.auto AS auto_13, t10.debtor_name AS debtor_name_14, t10.debtor_address AS debtor_address_15, t10.debtor_iban AS debtor_iban_16, t10.amount AS amount_17, t10.description AS description_18, t10.payment_group_id AS payment_group_id_19, t10.annonceur_id AS annonceur_id_20, t10.user_payment_id AS user_payment_id_21, t10.twint_payment_id AS twint_payment_id_22 FROM twint_payment t0 LEFT JOIN payment t10 ON t10.twint_payment_id = t0.id WHERE t0.annonceur_id = '5446a8e9-c0e3-4e77-a3b3-2393cfdc2229';