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.identification_hash = ?
LIMIT
  1

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.identification_hash = '26e5847e-ee24-49ab-b4d5-aedd48791c76' LIMIT 1;

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 IS NULL
LIMIT
  1

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 IS NULL 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 = ?
  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
  pm.id AS id,
  pm.name AS name,
  pm.description AS description
FROM
  payment_mode pm
  LEFT JOIN user_restricted_payment_mode up ON up.user_id = ?
  AND pm.id = up.payment_mode_id
WHERE
  up.user_id IS NULL

SELECT pm.id AS id, pm.name AS name, pm.description AS description
FROM payment_mode pm
LEFT JOIN user_restricted_payment_mode up
ON up.user_id = '5e9c8c22-c40b-4b36-9cf3-34cd6bbdd510' AND pm.id = up.payment_mode_id
WHERE up.user_id IS NULL;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.price AS price_2,
  i0_.fixed_price AS fixed_price_3,
  i0_.max_price AS max_price_4,
  i0_.priority AS priority_5,
  i0_.min_quantity AS min_quantity_6,
  i0_.max_quantity AS max_quantity_7,
  i0_.hidden AS hidden_8,
  i0_.vat_included AS vat_included_9,
  i0_.domain_id AS domain_id_10
FROM
  item i0_
WHERE
  i0_.domain_id = ?
  AND LOWER(i0_.name) LIKE ?
ORDER BY
  i0_.priority DESC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.price AS price_2, i0_.fixed_price AS fixed_price_3, i0_.max_price AS max_price_4, i0_.priority AS priority_5, i0_.min_quantity AS min_quantity_6, i0_.max_quantity AS max_quantity_7, i0_.hidden AS hidden_8, i0_.vat_included AS vat_included_9, i0_.domain_id AS domain_id_10 FROM item i0_ WHERE i0_.domain_id = '75654e6b-eb75-43af-ac4d-4a1d175b9c2c' AND LOWER(i0_.name) LIKE '%%' ORDER BY i0_.priority DESC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2
FROM
  payment_mode p0_
WHERE
  p0_.id IN (?, ?, ?)
  AND p0_.name <> 'cash'
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2 FROM payment_mode p0_ WHERE p0_.id IN (1, 3, 2) AND p0_.name <> 'cash' ORDER BY p0_.name ASC;