Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.fees AS fees_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.church_id AS church_id_6,
  t0.mass_category_id AS mass_category_id_7
FROM
  mass_price t0
WHERE
  t0.church_id = ?
  AND t0.mass_category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.fees AS fees_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.church_id AS church_id_6, t0.mass_category_id AS mass_category_id_7 FROM mass_price t0 WHERE t0.church_id = 1 AND t0.mass_category_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.longitude AS longitude_8,
  t0.latitude AS latitude_9,
  t0.map_short_url AS map_short_url_10,
  t0.logo AS logo_11,
  t0.banner AS banner_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.root_id AS root_id_15,
  t0.parent_id AS parent_id_16,
  t0.category_id AS category_id_17,
  t18.id AS id_19,
  t18.name AS name_20,
  t18.type AS type_21,
  t18.is_enabled AS is_enabled_22,
  t18.config AS config_23,
  t18.created_at AS created_at_24,
  t18.updated_at AS updated_at_25,
  t18.church_id AS church_id_26
FROM
  church t0
  LEFT JOIN institution t18 ON t18.church_id = t0.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.map_short_url AS map_short_url_10, t0.logo AS logo_11, t0.banner AS banner_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.root_id AS root_id_15, t0.parent_id AS parent_id_16, t0.category_id AS category_id_17, t18.id AS id_19, t18.name AS name_20, t18.type AS type_21, t18.is_enabled AS is_enabled_22, t18.config AS config_23, t18.created_at AS created_at_24, t18.updated_at AS updated_at_25, t18.church_id AS church_id_26 FROM church t0 LEFT JOIN institution t18 ON t18.church_id = t0.id WHERE t0.parent_id = 1 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.intention AS intention_2,
  t0.requester AS requester_3,
  t0.is_payed AS is_payed_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.owner_id AS owner_id_7,
  t0.church_id AS church_id_8,
  t0.category_id AS category_id_9,
  t10.id AS id_11,
  t10.reference AS reference_12,
  t10.status AS status_13,
  t10.type AS type_14,
  t10.mode AS mode_15,
  t10.amount AS amount_16,
  t10.gateway_response AS gateway_response_17,
  t10.transaction_token AS transaction_token_18,
  t10.external_id AS external_id_19,
  t10.currency AS currency_20,
  t10.payment_fees AS payment_fees_21,
  t10.base_amount AS base_amount_22,
  t10.payment_source AS payment_source_23,
  t10.customer_number AS customer_number_24,
  t10.contry_origin AS contry_origin_25,
  t10.payment_source_transaction_id AS payment_source_transaction_id_26,
  t10.payment_intent_id AS payment_intent_id_27,
  t10.is_compensated AS is_compensated_28,
  t10.compensated_at AS compensated_at_29,
  t10.receiver_balance_before AS receiver_balance_before_30,
  t10.receiver_balance_after AS receiver_balance_after_31,
  t10.receiver_fees_balance_before AS receiver_fees_balance_before_32,
  t10.receiver_fees_balance_after AS receiver_fees_balance_after_33,
  t10.created_at AS created_at_34,
  t10.updated_at AS updated_at_35,
  t10.mass_id AS mass_id_36,
  t10.institution_id AS institution_id_37
FROM
  mass t0
  LEFT JOIN payment t10 ON t10.mass_id = t0.id
WHERE
  t0.church_id = ?

SELECT t0.id AS id_1, t0.intention AS intention_2, t0.requester AS requester_3, t0.is_payed AS is_payed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_id AS owner_id_7, t0.church_id AS church_id_8, t0.category_id AS category_id_9, t10.id AS id_11, t10.reference AS reference_12, t10.status AS status_13, t10.type AS type_14, t10.mode AS mode_15, t10.amount AS amount_16, t10.gateway_response AS gateway_response_17, t10.transaction_token AS transaction_token_18, t10.external_id AS external_id_19, t10.currency AS currency_20, t10.payment_fees AS payment_fees_21, t10.base_amount AS base_amount_22, t10.payment_source AS payment_source_23, t10.customer_number AS customer_number_24, t10.contry_origin AS contry_origin_25, t10.payment_source_transaction_id AS payment_source_transaction_id_26, t10.payment_intent_id AS payment_intent_id_27, t10.is_compensated AS is_compensated_28, t10.compensated_at AS compensated_at_29, t10.receiver_balance_before AS receiver_balance_before_30, t10.receiver_balance_after AS receiver_balance_after_31, t10.receiver_fees_balance_before AS receiver_fees_balance_before_32, t10.receiver_fees_balance_after AS receiver_fees_balance_after_33, t10.created_at AS created_at_34, t10.updated_at AS updated_at_35, t10.mass_id AS mass_id_36, t10.institution_id AS institution_id_37 FROM mass t0 LEFT JOIN payment t10 ON t10.mass_id = t0.id WHERE t0.church_id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.wording AS wording_3,
  t0.icon AS icon_4,
  t0.color AS color_5,
  t0.nb_churches AS nb_churches_6,
  t0.level AS level_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  church_category t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.icon AS icon_4, t0.color AS color_5, t0.nb_churches AS nb_churches_6, t0.level AS level_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM church_category t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.is_enabled AS is_enabled_4,
  t0.config AS config_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.church_id AS church_id_8
FROM
  institution t0
WHERE
  t0.church_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.is_enabled AS is_enabled_4, t0.config AS config_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.church_id AS church_id_8 FROM institution t0 WHERE t0.church_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.longitude AS longitude_7,
  c0_.latitude AS latitude_8,
  c0_.map_short_url AS map_short_url_9,
  c0_.logo AS logo_10,
  c0_.banner AS banner_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c0_.root_id AS root_id_14,
  c0_.parent_id AS parent_id_15,
  c0_.category_id AS category_id_16
FROM
  church c0_
  INNER JOIN church_category c1_ ON c0_.category_id = c1_.id
WHERE
  c1_.code = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.longitude AS longitude_7, c0_.latitude AS latitude_8, c0_.map_short_url AS map_short_url_9, c0_.logo AS logo_10, c0_.banner AS banner_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.root_id AS root_id_14, c0_.parent_id AS parent_id_15, c0_.category_id AS category_id_16 FROM church c0_ INNER JOIN church_category c1_ ON c0_.category_id = c1_.id WHERE c1_.code = 'DIOCESE';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.wording AS wording_3,
  t0.color AS color_4,
  t0.icon AS icon_5,
  t0.color_hex AS color_hex_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  mass_category t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.color AS color_4, t0.icon AS icon_5, t0.color_hex AS color_hex_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mass_category t0;