Symfony Profiler

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
  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.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
  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 = 12;

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;

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.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.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 = 2 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 = ?
  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 = 3 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 = 7 ORDER BY t0.lft ASC;

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 = 7 AND t0.mass_category_id = 1 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 = ?
  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.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 = 7 AND t0.mass_category_id = 2 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 = ?
  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 = 2 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 = ?
  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 = 7 AND t0.mass_category_id = 3 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 = ?
  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 = 3 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 = 8 ORDER BY t0.lft ASC;

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 = 8 AND t0.mass_category_id = 1 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 = ?
  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.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 = 8 AND t0.mass_category_id = 2 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 = ?
  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 = 2 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 = ?
  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 = 8 AND t0.mass_category_id = 3 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 = ?
  AND t0.mass_category_id = ?
LIMIT
  1