Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.is_verified AS is_verified_7,
  t0.username AS username_8
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.username AS username_8 FROM user t0 WHERE t0.email = 'b.pereira@lightbulb.lu' LIMIT 1;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bank_statement b0_
  LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id
  LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id
  LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id
  LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id
  LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id
  LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id
  LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id
  LEFT JOIN campaign_bank_statement c9_ ON b0_.id = c9_.bank_statement_id
  LEFT JOIN campaign c8_ ON c8_.id = c9_.campaign_id
  LEFT JOIN user u10_ ON b0_.user_id = u10_.id

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bank_statement b0_ LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id LEFT JOIN campaign_bank_statement c9_ ON b0_.id = c9_.bank_statement_id LEFT JOIN campaign c8_ ON c8_.id = c9_.campaign_id LEFT JOIN user u10_ ON b0_.user_id = u10_.id;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
FROM
  bank_statement b0_
  LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id
  LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id
  LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id
  LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id
  LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id
  LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id
  LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id
  LEFT JOIN campaign_bank_statement c9_ ON b0_.id = c9_.bank_statement_id
  LEFT JOIN campaign c8_ ON c8_.id = c9_.campaign_id
  LEFT JOIN user u10_ ON b0_.user_id = u10_.id
ORDER BY
  b0_.id ASC
LIMIT
  30

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM bank_statement b0_ LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id LEFT JOIN campaign_bank_statement c9_ ON b0_.id = c9_.bank_statement_id LEFT JOIN campaign c8_ ON c8_.id = c9_.campaign_id LEFT JOIN user u10_ ON b0_.user_id = u10_.id ORDER BY b0_.id ASC LIMIT 30;

SELECT
  b0_.id AS id_0,
  b0_.file_path AS file_path_1,
  b0_.updated_at AS updated_at_2,
  b0_.processed AS processed_3,
  b0_.is_controlled AS is_controlled_4,
  d1_.id AS id_5,
  d1_.amount AS amount_6,
  d1_.bank_transaction_id AS bank_transaction_id_7,
  d1_.communication AS communication_8,
  d1_.donation_date AS donation_date_9,
  d1_.auto AS auto_10,
  d2_.id AS id_11,
  d2_.new AS new_12,
  d2_.firstname AS firstname_13,
  d2_.lastname AS lastname_14,
  d2_.bank_account_name AS bank_account_name_15,
  d2_.address AS address_16,
  d2_.post_code AS post_code_17,
  d2_.city AS city_18,
  d2_.phone AS phone_19,
  d2_.email AS email_20,
  d2_.permanent AS permanent_21,
  d2_.donor_rank AS donor_rank_22,
  b3_.id AS id_23,
  c4_.id AS id_24,
  c4_.name AS name_25,
  c4_.start_date AS start_date_26,
  c4_.end_date AS end_date_27,
  c4_.objective AS objective_28,
  c4_.concerned_person AS concerned_person_29,
  c4_.accounting_account AS accounting_account_30,
  t5_.id AS id_31,
  t5_.amount AS amount_32,
  t5_.bank_transaction_id AS bank_transaction_id_33,
  t5_.communication AS communication_34,
  t5_.transaction_date AS transaction_date_35,
  t5_.auto AS auto_36,
  t5_.is_donation AS is_donation_37,
  d6_.id AS id_38,
  d6_.new AS new_39,
  d6_.firstname AS firstname_40,
  d6_.lastname AS lastname_41,
  d6_.bank_account_name AS bank_account_name_42,
  d6_.address AS address_43,
  d6_.post_code AS post_code_44,
  d6_.city AS city_45,
  d6_.phone AS phone_46,
  d6_.email AS email_47,
  d6_.permanent AS permanent_48,
  d6_.donor_rank AS donor_rank_49,
  c7_.id AS id_50,
  c7_.name AS name_51,
  c7_.start_date AS start_date_52,
  c7_.end_date AS end_date_53,
  c7_.objective AS objective_54,
  c7_.concerned_person AS concerned_person_55,
  c7_.accounting_account AS accounting_account_56,
  c8_.id AS id_57,
  c8_.name AS name_58,
  c8_.start_date AS start_date_59,
  c8_.end_date AS end_date_60,
  c8_.objective AS objective_61,
  c8_.concerned_person AS concerned_person_62,
  c8_.accounting_account AS accounting_account_63,
  u9_.id AS id_64,
  u9_.email AS email_65,
  u9_.username AS username_66,
  b0_.user_id AS user_id_67,
  d1_.donor_id AS donor_id_68,
  d1_.bank_account_id AS bank_account_id_69,
  d1_.bank_statement_id AS bank_statement_id_70,
  d1_.campaign_id AS campaign_id_71,
  d1_.transaction_id AS transaction_id_72,
  d2_.source_id AS source_id_73,
  d2_.title_id AS title_id_74,
  d2_.migrated_to_id AS migrated_to_id_75,
  b3_.donor_id AS donor_id_76,
  c4_.type_id AS type_id_77,
  c4_.contact_person_id AS contact_person_id_78,
  t5_.donor_id AS donor_id_79,
  t5_.bank_account_id AS bank_account_id_80,
  t5_.bank_statement_id AS bank_statement_id_81,
  t5_.campaign_id AS campaign_id_82,
  d6_.source_id AS source_id_83,
  d6_.title_id AS title_id_84,
  d6_.migrated_to_id AS migrated_to_id_85,
  c7_.type_id AS type_id_86,
  c7_.contact_person_id AS contact_person_id_87,
  c8_.type_id AS type_id_88,
  c8_.contact_person_id AS contact_person_id_89
FROM
  bank_statement b0_
  LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id
  LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id
  LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id
  LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id
  LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id
  LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id
  LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id
  LEFT JOIN campaign_bank_statement c10_ ON b0_.id = c10_.bank_statement_id
  LEFT JOIN campaign c8_ ON c8_.id = c10_.campaign_id
  LEFT JOIN user u9_ ON b0_.user_id = u9_.id
WHERE
  b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.id ASC

SELECT b0_.id AS id_0, b0_.file_path AS file_path_1, b0_.updated_at AS updated_at_2, b0_.processed AS processed_3, b0_.is_controlled AS is_controlled_4, d1_.id AS id_5, d1_.amount AS amount_6, d1_.bank_transaction_id AS bank_transaction_id_7, d1_.communication AS communication_8, d1_.donation_date AS donation_date_9, d1_.auto AS auto_10, d2_.id AS id_11, d2_.new AS new_12, d2_.firstname AS firstname_13, d2_.lastname AS lastname_14, d2_.bank_account_name AS bank_account_name_15, d2_.address AS address_16, d2_.post_code AS post_code_17, d2_.city AS city_18, d2_.phone AS phone_19, d2_.email AS email_20, d2_.permanent AS permanent_21, d2_.donor_rank AS donor_rank_22, b3_.id AS id_23, c4_.id AS id_24, c4_.name AS name_25, c4_.start_date AS start_date_26, c4_.end_date AS end_date_27, c4_.objective AS objective_28, c4_.concerned_person AS concerned_person_29, c4_.accounting_account AS accounting_account_30, t5_.id AS id_31, t5_.amount AS amount_32, t5_.bank_transaction_id AS bank_transaction_id_33, t5_.communication AS communication_34, t5_.transaction_date AS transaction_date_35, t5_.auto AS auto_36, t5_.is_donation AS is_donation_37, d6_.id AS id_38, d6_.new AS new_39, d6_.firstname AS firstname_40, d6_.lastname AS lastname_41, d6_.bank_account_name AS bank_account_name_42, d6_.address AS address_43, d6_.post_code AS post_code_44, d6_.city AS city_45, d6_.phone AS phone_46, d6_.email AS email_47, d6_.permanent AS permanent_48, d6_.donor_rank AS donor_rank_49, c7_.id AS id_50, c7_.name AS name_51, c7_.start_date AS start_date_52, c7_.end_date AS end_date_53, c7_.objective AS objective_54, c7_.concerned_person AS concerned_person_55, c7_.accounting_account AS accounting_account_56, c8_.id AS id_57, c8_.name AS name_58, c8_.start_date AS start_date_59, c8_.end_date AS end_date_60, c8_.objective AS objective_61, c8_.concerned_person AS concerned_person_62, c8_.accounting_account AS accounting_account_63, u9_.id AS id_64, u9_.email AS email_65, u9_.username AS username_66, b0_.user_id AS user_id_67, d1_.donor_id AS donor_id_68, d1_.bank_account_id AS bank_account_id_69, d1_.bank_statement_id AS bank_statement_id_70, d1_.campaign_id AS campaign_id_71, d1_.transaction_id AS transaction_id_72, d2_.source_id AS source_id_73, d2_.title_id AS title_id_74, d2_.migrated_to_id AS migrated_to_id_75, b3_.donor_id AS donor_id_76, c4_.type_id AS type_id_77, c4_.contact_person_id AS contact_person_id_78, t5_.donor_id AS donor_id_79, t5_.bank_account_id AS bank_account_id_80, t5_.bank_statement_id AS bank_statement_id_81, t5_.campaign_id AS campaign_id_82, d6_.source_id AS source_id_83, d6_.title_id AS title_id_84, d6_.migrated_to_id AS migrated_to_id_85, c7_.type_id AS type_id_86, c7_.contact_person_id AS contact_person_id_87, c8_.type_id AS type_id_88, c8_.contact_person_id AS contact_person_id_89 FROM bank_statement b0_ LEFT JOIN donation d1_ ON b0_.id = d1_.bank_statement_id LEFT JOIN donor d2_ ON d1_.donor_id = d2_.id LEFT JOIN bank_account b3_ ON d1_.bank_account_id = b3_.id LEFT JOIN campaign c4_ ON d1_.campaign_id = c4_.id LEFT JOIN transaction t5_ ON b0_.id = t5_.bank_statement_id LEFT JOIN donor d6_ ON t5_.donor_id = d6_.id LEFT JOIN campaign c7_ ON t5_.campaign_id = c7_.id LEFT JOIN campaign_bank_statement c10_ ON b0_.id = c10_.bank_statement_id LEFT JOIN campaign c8_ ON c8_.id = c10_.campaign_id LEFT JOIN user u9_ ON b0_.user_id = u9_.id WHERE b0_.id IN (7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36) ORDER BY b0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 109;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 105;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 107;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 108;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 103;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 106;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 116;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.bank_transaction_id AS bank_transaction_id_3,
  t0.communication AS communication_4,
  t0.donation_date AS donation_date_5,
  t0.auto AS auto_6,
  t0.search AS search_7,
  t0.donor_id AS donor_id_8,
  t0.bank_account_id AS bank_account_id_9,
  t0.bank_statement_id AS bank_statement_id_10,
  t0.campaign_id AS campaign_id_11,
  t0.transaction_id AS transaction_id_12
FROM
  donation t0
WHERE
  t0.transaction_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.bank_transaction_id AS bank_transaction_id_3, t0.communication AS communication_4, t0.donation_date AS donation_date_5, t0.auto AS auto_6, t0.search AS search_7, t0.donor_id AS donor_id_8, t0.bank_account_id AS bank_account_id_9, t0.bank_statement_id AS bank_statement_id_10, t0.campaign_id AS campaign_id_11, t0.transaction_id AS transaction_id_12 FROM donation t0 WHERE t0.transaction_id = 119;