Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5,
  t0.created_at AS created_at_6
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.created_at AS created_at_6 FROM "user" t0 WHERE t0.id = 2;

SELECT
  COUNT(*)
FROM
  family t0

SELECT COUNT(*) FROM family t0;

SELECT
  COUNT(*)
FROM
  guardian t0

SELECT COUNT(*) FROM guardian t0;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  orphan o0_
WHERE
  o0_.status = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM orphan o0_ WHERE o0_.status = 'ACTIVE';

SELECT
  COUNT(*)
FROM
  orphan t0

SELECT COUNT(*) FROM orphan t0;

SELECT
  AVG(f0_.socioeconomic_score) AS sclr_0
FROM
  family f0_

SELECT AVG(f0_.socioeconomic_score) AS sclr_0 FROM family f0_;

SELECT
  COUNT(*)
FROM
  sponsor t0

SELECT COUNT(*) FROM sponsor t0;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sponsorship s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sponsorship s0_ WHERE s0_.status = 'active';

SELECT
  SUM(s0_.monthly_amount) AS sclr_0
FROM
  sponsorship s0_
WHERE
  s0_.status = ?

SELECT SUM(s0_.monthly_amount) AS sclr_0 FROM sponsorship s0_ WHERE s0_.status = 'active';

SELECT
  COUNT(*)
FROM
  member t0

SELECT COUNT(*) FROM member t0;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  member m0_
WHERE
  m0_.status = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM member m0_ WHERE m0_.status = 'active';

SELECT
  SUM(m0_.amount) AS sclr_0
FROM
  membership_fee m0_
WHERE
  m0_.year = ?

SELECT SUM(m0_.amount) AS sclr_0 FROM membership_fee m0_ WHERE m0_.year = 2026;

SELECT
  SUM(s0_.amount) AS sclr_0
FROM
  sponsorship_payment s0_
WHERE
  s0_.payment_date >= ?
  AND s0_.payment_date <= ?

SELECT SUM(s0_.amount) AS sclr_0 FROM sponsorship_payment s0_ WHERE s0_.payment_date >= '2026-01-01 00:00:00' AND s0_.payment_date <= '2026-12-31 23:59:59';

SELECT
  SUM(e0_.amount) AS sclr_0
FROM
  expense e0_
WHERE
  e0_.expense_date >= ?
  AND e0_.expense_date <= ?

SELECT SUM(e0_.amount) AS sclr_0 FROM expense e0_ WHERE e0_.expense_date >= '2026-01-01 00:00:00' AND e0_.expense_date <= '2026-12-31 23:59:59';

SELECT
  e0_.category AS category_0,
  SUM(e0_.amount) AS sclr_1,
  COUNT(e0_.id) AS sclr_2
FROM
  expense e0_
WHERE
  e0_.expense_date >= ?
  AND e0_.expense_date <= ?
GROUP BY
  e0_.category
ORDER BY
  sclr_1 DESC

SELECT e0_.category AS category_0, SUM(e0_.amount) AS sclr_1, COUNT(e0_.id) AS sclr_2 FROM expense e0_ WHERE e0_.expense_date >= '2026-01-01 00:00:00' AND e0_.expense_date <= '2026-12-31 23:59:59' GROUP BY e0_.category ORDER BY sclr_1 DESC;

SELECT
  COUNT(*)
FROM
  orphan t0
WHERE
  t0.gender = ?

SELECT COUNT(*) FROM orphan t0 WHERE t0.gender = 'M';

SELECT
  COUNT(*)
FROM
  orphan t0
WHERE
  t0.gender = ?

SELECT COUNT(*) FROM orphan t0 WHERE t0.gender = 'F';

SELECT
  o0_.id AS id_0,
  o0_.first_name AS first_name_1,
  o0_.last_name AS last_name_2,
  o0_.gender AS gender_3,
  o0_.birth_date AS birth_date_4,
  o0_.school_level AS school_level_5,
  o0_.health_status AS health_status_6,
  o0_.photo_path AS photo_path_7,
  o0_.photo_size AS photo_size_8,
  o0_.status AS status_9,
  o0_.created_at AS created_at_10,
  o0_.updated_at AS updated_at_11,
  f1_.id AS id_12,
  f1_.address AS address_13,
  f1_.city AS city_14,
  f1_.district AS district_15,
  f1_.housing_status AS housing_status_16,
  f1_.socioeconomic_score AS socioeconomic_score_17,
  f1_.notes AS notes_18,
  f1_.created_at AS created_at_19,
  o0_.family_id AS family_id_20
FROM
  orphan o0_
  LEFT JOIN family f1_ ON o0_.family_id = f1_.id
ORDER BY
  o0_.created_at DESC
LIMIT
  5

SELECT o0_.id AS id_0, o0_.first_name AS first_name_1, o0_.last_name AS last_name_2, o0_.gender AS gender_3, o0_.birth_date AS birth_date_4, o0_.school_level AS school_level_5, o0_.health_status AS health_status_6, o0_.photo_path AS photo_path_7, o0_.photo_size AS photo_size_8, o0_.status AS status_9, o0_.created_at AS created_at_10, o0_.updated_at AS updated_at_11, f1_.id AS id_12, f1_.address AS address_13, f1_.city AS city_14, f1_.district AS district_15, f1_.housing_status AS housing_status_16, f1_.socioeconomic_score AS socioeconomic_score_17, f1_.notes AS notes_18, f1_.created_at AS created_at_19, o0_.family_id AS family_id_20 FROM orphan o0_ LEFT JOIN family f1_ ON o0_.family_id = f1_.id ORDER BY o0_.created_at DESC LIMIT 5;

SELECT
  f0_.id AS id_0,
  f0_.address AS address_1,
  f0_.city AS city_2,
  f0_.district AS district_3,
  f0_.housing_status AS housing_status_4,
  f0_.socioeconomic_score AS socioeconomic_score_5,
  f0_.notes AS notes_6,
  f0_.created_at AS created_at_7
FROM
  family f0_
ORDER BY
  f0_.socioeconomic_score ASC
LIMIT
  5

SELECT f0_.id AS id_0, f0_.address AS address_1, f0_.city AS city_2, f0_.district AS district_3, f0_.housing_status AS housing_status_4, f0_.socioeconomic_score AS socioeconomic_score_5, f0_.notes AS notes_6, f0_.created_at AS created_at_7 FROM family f0_ ORDER BY f0_.socioeconomic_score ASC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.gender AS gender_4,
  t0.birth_date AS birth_date_5,
  t0.school_level AS school_level_6,
  t0.health_status AS health_status_7,
  t0.photo_path AS photo_path_8,
  t0.photo_size AS photo_size_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.family_id AS family_id_13
FROM
  orphan t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.birth_date AS birth_date_5, t0.school_level AS school_level_6, t0.health_status AS health_status_7, t0.photo_path AS photo_path_8, t0.photo_size AS photo_size_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.family_id AS family_id_13 FROM orphan t0 WHERE t0.family_id = 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.cin_number AS cin_number_4,
  t0.phone AS phone_5,
  t0.relationship_to_children AS relationship_to_children_6,
  t0.bank_account_iban AS bank_account_iban_7,
  t0.family_id AS family_id_8
FROM
  guardian t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.cin_number AS cin_number_4, t0.phone AS phone_5, t0.relationship_to_children AS relationship_to_children_6, t0.bank_account_iban AS bank_account_iban_7, t0.family_id AS family_id_8 FROM guardian t0 WHERE t0.family_id = 1;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.gender AS gender_4,
  t0.birth_date AS birth_date_5,
  t0.school_level AS school_level_6,
  t0.health_status AS health_status_7,
  t0.photo_path AS photo_path_8,
  t0.photo_size AS photo_size_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.family_id AS family_id_13
FROM
  orphan t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.birth_date AS birth_date_5, t0.school_level AS school_level_6, t0.health_status AS health_status_7, t0.photo_path AS photo_path_8, t0.photo_size AS photo_size_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.family_id AS family_id_13 FROM orphan t0 WHERE t0.family_id = 2;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.cin_number AS cin_number_4,
  t0.phone AS phone_5,
  t0.relationship_to_children AS relationship_to_children_6,
  t0.bank_account_iban AS bank_account_iban_7,
  t0.family_id AS family_id_8
FROM
  guardian t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.cin_number AS cin_number_4, t0.phone AS phone_5, t0.relationship_to_children AS relationship_to_children_6, t0.bank_account_iban AS bank_account_iban_7, t0.family_id AS family_id_8 FROM guardian t0 WHERE t0.family_id = 2;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.gender AS gender_4,
  t0.birth_date AS birth_date_5,
  t0.school_level AS school_level_6,
  t0.health_status AS health_status_7,
  t0.photo_path AS photo_path_8,
  t0.photo_size AS photo_size_9,
  t0.status AS status_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.family_id AS family_id_13
FROM
  orphan t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.birth_date AS birth_date_5, t0.school_level AS school_level_6, t0.health_status AS health_status_7, t0.photo_path AS photo_path_8, t0.photo_size AS photo_size_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.family_id AS family_id_13 FROM orphan t0 WHERE t0.family_id = 3;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.cin_number AS cin_number_4,
  t0.phone AS phone_5,
  t0.relationship_to_children AS relationship_to_children_6,
  t0.bank_account_iban AS bank_account_iban_7,
  t0.family_id AS family_id_8
FROM
  guardian t0
WHERE
  t0.family_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.cin_number AS cin_number_4, t0.phone AS phone_5, t0.relationship_to_children AS relationship_to_children_6, t0.bank_account_iban AS bank_account_iban_7, t0.family_id AS family_id_8 FROM guardian t0 WHERE t0.family_id = 3;