Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.subdomain AS subdomain_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.slogan AS slogan_6,
  t0.logo AS logo_7,
  t0.banner AS banner_8,
  t0.primary_color AS primary_color_9,
  t0.secondary_color AS secondary_color_10,
  t0.email AS email_11,
  t0.phone AS phone_12,
  t0.address AS address_13,
  t0.city AS city_14,
  t0.country AS country_15,
  t0.financial_goal AS financial_goal_16,
  t0.default_currency AS default_currency_17,
  t0.enabled_payment_methods AS enabled_payment_methods_18,
  t0.smtp_config AS smtp_config_19,
  t0.sms_credits AS sms_credits_20,
  t0.is_active AS is_active_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.deleted_at AS deleted_at_24
FROM
  parishes t0
WHERE
  t0.subdomain = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.subdomain AS subdomain_3, t0.slug AS slug_4, t0.description AS description_5, t0.slogan AS slogan_6, t0.logo AS logo_7, t0.banner AS banner_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.email AS email_11, t0.phone AS phone_12, t0.address AS address_13, t0.city AS city_14, t0.country AS country_15, t0.financial_goal AS financial_goal_16, t0.default_currency AS default_currency_17, t0.enabled_payment_methods AS enabled_payment_methods_18, t0.smtp_config AS smtp_config_19, t0.sms_credits AS sms_credits_20, t0.is_active AS is_active_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM parishes t0 WHERE t0.subdomain = 'biyem-assi' AND t0.is_active = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.web_description AS web_description_3,
  c0_.slug AS slug_4,
  c0_.target_amount AS target_amount_5,
  c0_.start_date AS start_date_6,
  c0_.end_date AS end_date_7,
  c0_.closed_at AS closed_at_8,
  c0_.is_active AS is_active_9,
  c0_.is_closed AS is_closed_10,
  c0_.status AS status_11,
  c0_.color AS color_12,
  c0_.banner AS banner_13,
  c0_.thumbnail AS thumbnail_14,
  c0_.settings AS settings_15,
  c0_.created_at AS created_at_16,
  c0_.updated_at AS updated_at_17,
  c0_.parish_id AS parish_id_18
FROM
  campaign c0_
WHERE
  c0_.parish_id = ?
  AND c0_.is_active = ?
ORDER BY
  c0_.start_date DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.web_description AS web_description_3, c0_.slug AS slug_4, c0_.target_amount AS target_amount_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.closed_at AS closed_at_8, c0_.is_active AS is_active_9, c0_.is_closed AS is_closed_10, c0_.status AS status_11, c0_.color AS color_12, c0_.banner AS banner_13, c0_.thumbnail AS thumbnail_14, c0_.settings AS settings_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, c0_.parish_id AS parish_id_18 FROM campaign c0_ WHERE c0_.parish_id = 2 AND c0_.is_active = 1 ORDER BY c0_.start_date DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.subdomain AS subdomain_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.slogan AS slogan_6,
  t0.logo AS logo_7,
  t0.banner AS banner_8,
  t0.primary_color AS primary_color_9,
  t0.secondary_color AS secondary_color_10,
  t0.email AS email_11,
  t0.phone AS phone_12,
  t0.address AS address_13,
  t0.city AS city_14,
  t0.country AS country_15,
  t0.financial_goal AS financial_goal_16,
  t0.default_currency AS default_currency_17,
  t0.enabled_payment_methods AS enabled_payment_methods_18,
  t0.smtp_config AS smtp_config_19,
  t0.sms_credits AS sms_credits_20,
  t0.is_active AS is_active_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.deleted_at AS deleted_at_24
FROM
  parishes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.subdomain AS subdomain_3, t0.slug AS slug_4, t0.description AS description_5, t0.slogan AS slogan_6, t0.logo AS logo_7, t0.banner AS banner_8, t0.primary_color AS primary_color_9, t0.secondary_color AS secondary_color_10, t0.email AS email_11, t0.phone AS phone_12, t0.address AS address_13, t0.city AS city_14, t0.country AS country_15, t0.financial_goal AS financial_goal_16, t0.default_currency AS default_currency_17, t0.enabled_payment_methods AS enabled_payment_methods_18, t0.smtp_config AS smtp_config_19, t0.sms_credits AS sms_credits_20, t0.is_active AS is_active_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM parishes t0 WHERE t0.slug = 'biyem-assi' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.transaction_number AS transaction_number_1,
  c0_.type AS type_2,
  c0_.amount AS amount_3,
  c0_.currency AS currency_4,
  c0_.amount_xaf AS amount_xaf_5,
  c0_.designation AS designation_6,
  c0_.estimated_value AS estimated_value_7,
  c0_.proof_document AS proof_document_8,
  c0_.contributor_first_name AS contributor_first_name_9,
  c0_.contributor_last_name AS contributor_last_name_10,
  c0_.contributor_email AS contributor_email_11,
  c0_.contributor_phone AS contributor_phone_12,
  c0_.contributor_country AS contributor_country_13,
  c0_.contributor_city AS contributor_city_14,
  c0_.contributor_photo AS contributor_photo_15,
  c0_.status AS status_16,
  c0_.payment_method AS payment_method_17,
  c0_.payment_reference AS payment_reference_18,
  c0_.notes AS notes_19,
  c0_.created_at AS created_at_20,
  c0_.updated_at AS updated_at_21,
  c0_.paid_at AS paid_at_22,
  c0_.deleted_at AS deleted_at_23,
  c0_.parish_id AS parish_id_24,
  c0_.member_id AS member_id_25,
  c0_.campaign_id AS campaign_id_26
FROM
  contributions c0_
WHERE
  c0_.campaign_id = ?
  AND c0_.status = ?
ORDER BY
  c0_.paid_at DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.transaction_number AS transaction_number_1, c0_.type AS type_2, c0_.amount AS amount_3, c0_.currency AS currency_4, c0_.amount_xaf AS amount_xaf_5, c0_.designation AS designation_6, c0_.estimated_value AS estimated_value_7, c0_.proof_document AS proof_document_8, c0_.contributor_first_name AS contributor_first_name_9, c0_.contributor_last_name AS contributor_last_name_10, c0_.contributor_email AS contributor_email_11, c0_.contributor_phone AS contributor_phone_12, c0_.contributor_country AS contributor_country_13, c0_.contributor_city AS contributor_city_14, c0_.contributor_photo AS contributor_photo_15, c0_.status AS status_16, c0_.payment_method AS payment_method_17, c0_.payment_reference AS payment_reference_18, c0_.notes AS notes_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, c0_.paid_at AS paid_at_22, c0_.deleted_at AS deleted_at_23, c0_.parish_id AS parish_id_24, c0_.member_id AS member_id_25, c0_.campaign_id AS campaign_id_26 FROM contributions c0_ WHERE c0_.campaign_id = 7 AND c0_.status = 'validated' ORDER BY c0_.paid_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.transaction_number AS transaction_number_2,
  t0.type AS type_3,
  t0.amount AS amount_4,
  t0.currency AS currency_5,
  t0.amount_xaf AS amount_xaf_6,
  t0.designation AS designation_7,
  t0.estimated_value AS estimated_value_8,
  t0.proof_document AS proof_document_9,
  t0.contributor_first_name AS contributor_first_name_10,
  t0.contributor_last_name AS contributor_last_name_11,
  t0.contributor_email AS contributor_email_12,
  t0.contributor_phone AS contributor_phone_13,
  t0.contributor_country AS contributor_country_14,
  t0.contributor_city AS contributor_city_15,
  t0.contributor_photo AS contributor_photo_16,
  t0.status AS status_17,
  t0.payment_method AS payment_method_18,
  t0.payment_reference AS payment_reference_19,
  t0.notes AS notes_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.paid_at AS paid_at_23,
  t0.deleted_at AS deleted_at_24,
  t0.parish_id AS parish_id_25,
  t0.member_id AS member_id_26,
  t0.campaign_id AS campaign_id_27
FROM
  contributions t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.transaction_number AS transaction_number_2, t0.type AS type_3, t0.amount AS amount_4, t0.currency AS currency_5, t0.amount_xaf AS amount_xaf_6, t0.designation AS designation_7, t0.estimated_value AS estimated_value_8, t0.proof_document AS proof_document_9, t0.contributor_first_name AS contributor_first_name_10, t0.contributor_last_name AS contributor_last_name_11, t0.contributor_email AS contributor_email_12, t0.contributor_phone AS contributor_phone_13, t0.contributor_country AS contributor_country_14, t0.contributor_city AS contributor_city_15, t0.contributor_photo AS contributor_photo_16, t0.status AS status_17, t0.payment_method AS payment_method_18, t0.payment_reference AS payment_reference_19, t0.notes AS notes_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.paid_at AS paid_at_23, t0.deleted_at AS deleted_at_24, t0.parish_id AS parish_id_25, t0.member_id AS member_id_26, t0.campaign_id AS campaign_id_27 FROM contributions t0 WHERE t0.campaign_id = 7;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.web_description AS web_description_3,
  c0_.slug AS slug_4,
  c0_.target_amount AS target_amount_5,
  c0_.start_date AS start_date_6,
  c0_.end_date AS end_date_7,
  c0_.closed_at AS closed_at_8,
  c0_.is_active AS is_active_9,
  c0_.is_closed AS is_closed_10,
  c0_.status AS status_11,
  c0_.color AS color_12,
  c0_.banner AS banner_13,
  c0_.thumbnail AS thumbnail_14,
  c0_.settings AS settings_15,
  c0_.created_at AS created_at_16,
  c0_.updated_at AS updated_at_17,
  c0_.parish_id AS parish_id_18
FROM
  campaign c0_
WHERE
  c0_.parish_id = ?
  AND c0_.is_closed = ?
ORDER BY
  c0_.closed_at DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.web_description AS web_description_3, c0_.slug AS slug_4, c0_.target_amount AS target_amount_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.closed_at AS closed_at_8, c0_.is_active AS is_active_9, c0_.is_closed AS is_closed_10, c0_.status AS status_11, c0_.color AS color_12, c0_.banner AS banner_13, c0_.thumbnail AS thumbnail_14, c0_.settings AS settings_15, c0_.created_at AS created_at_16, c0_.updated_at AS updated_at_17, c0_.parish_id AS parish_id_18 FROM campaign c0_ WHERE c0_.parish_id = 2 AND c0_.is_closed = 1 ORDER BY c0_.closed_at DESC LIMIT 6;