4.96 ms (17.01%)
|
1 |
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
Parameters: [
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
]
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;
|