Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.verified AS verified_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.verified AS verified_5, t0.created_at AS created_at_6 FROM "user" t0 WHERE t0.id = '019fb532-f584-74b2-9306-c6da112a6f5b';

SELECT
  m0_.id AS id_0,
  m0_.first_name AS first_name_1,
  m0_.role AS role_2,
  m0_.color AS color_3,
  m0_.position AS position_4,
  m0_.created_at AS created_at_5,
  m0_.joined_at AS joined_at_6,
  f1_.id AS id_7,
  f1_.name AS name_8,
  f1_.timezone AS timezone_9,
  f1_.created_at AS created_at_10,
  f1_.onboarded_at AS onboarded_at_11,
  m2_.id AS id_12,
  m2_.first_name AS first_name_13,
  m2_.role AS role_14,
  m2_.color AS color_15,
  m2_.position AS position_16,
  m2_.created_at AS created_at_17,
  m2_.joined_at AS joined_at_18,
  m0_.family_id AS family_id_19,
  m0_.user_id AS user_id_20,
  m2_.family_id AS family_id_21,
  m2_.user_id AS user_id_22
FROM
  membership m0_
  INNER JOIN family f1_ ON m0_.family_id = f1_.id
  LEFT JOIN membership m2_ ON f1_.id = m2_.family_id
WHERE
  m0_.user_id = ?
ORDER BY
  m0_.created_at ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.first_name AS first_name_1, m0_.role AS role_2, m0_.color AS color_3, m0_.position AS position_4, m0_.created_at AS created_at_5, m0_.joined_at AS joined_at_6, f1_.id AS id_7, f1_.name AS name_8, f1_.timezone AS timezone_9, f1_.created_at AS created_at_10, f1_.onboarded_at AS onboarded_at_11, m2_.id AS id_12, m2_.first_name AS first_name_13, m2_.role AS role_14, m2_.color AS color_15, m2_.position AS position_16, m2_.created_at AS created_at_17, m2_.joined_at AS joined_at_18, m0_.family_id AS family_id_19, m0_.user_id AS user_id_20, m2_.family_id AS family_id_21, m2_.user_id AS user_id_22 FROM membership m0_ INNER JOIN family f1_ ON m0_.family_id = f1_.id LEFT JOIN membership m2_ ON f1_.id = m2_.family_id WHERE m0_.user_id = '019fb532-f584-74b2-9306-c6da112a6f5b' ORDER BY m0_.created_at ASC, m2_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.birth_date AS birth_date_2,
  c0_.color AS color_3,
  c0_.position AS position_4,
  c0_.created_at AS created_at_5,
  c0_.archived_at AS archived_at_6,
  c0_.family_id AS family_id_7
FROM
  child c0_
WHERE
  c0_.family_id = ?
  AND c0_.archived_at IS NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.birth_date AS birth_date_2, c0_.color AS color_3, c0_.position AS position_4, c0_.created_at AS created_at_5, c0_.archived_at AS archived_at_6, c0_.family_id AS family_id_7 FROM child c0_ WHERE c0_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND c0_.archived_at IS NULL ORDER BY c0_.position ASC;

SELECT
  s0_.id AS id_0,
  s0_.starts_at AS starts_at_1,
  s0_.ends_at AS ends_at_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  c1_.id AS id_5,
  c1_.first_name AS first_name_6,
  c1_.birth_date AS birth_date_7,
  c1_.color AS color_8,
  c1_.position AS position_9,
  c1_.created_at AS created_at_10,
  c1_.archived_at AS archived_at_11,
  p2_.id AS id_12,
  p2_.name AS name_13,
  p2_.kind AS kind_14,
  p2_.attribution AS attribution_15,
  p2_.color AS color_16,
  p2_.position AS position_17,
  p2_.created_at AS created_at_18,
  p2_.archived_at AS archived_at_19,
  s0_.child_id AS child_id_20,
  s0_.place_id AS place_id_21,
  s0_.recorded_by_id AS recorded_by_id_22,
  s0_.opened_by_id AS opened_by_id_23,
  c1_.family_id AS family_id_24,
  p2_.family_id AS family_id_25,
  p2_.membership_id AS membership_id_26
FROM
  stay s0_
  INNER JOIN child c1_ ON s0_.child_id = c1_.id
  INNER JOIN place p2_ ON s0_.place_id = p2_.id
WHERE
  c1_.family_id = ?
  AND s0_.ends_at IS NULL
  AND s0_.status = ?

SELECT s0_.id AS id_0, s0_.starts_at AS starts_at_1, s0_.ends_at AS ends_at_2, s0_.status AS status_3, s0_.created_at AS created_at_4, c1_.id AS id_5, c1_.first_name AS first_name_6, c1_.birth_date AS birth_date_7, c1_.color AS color_8, c1_.position AS position_9, c1_.created_at AS created_at_10, c1_.archived_at AS archived_at_11, p2_.id AS id_12, p2_.name AS name_13, p2_.kind AS kind_14, p2_.attribution AS attribution_15, p2_.color AS color_16, p2_.position AS position_17, p2_.created_at AS created_at_18, p2_.archived_at AS archived_at_19, s0_.child_id AS child_id_20, s0_.place_id AS place_id_21, s0_.recorded_by_id AS recorded_by_id_22, s0_.opened_by_id AS opened_by_id_23, c1_.family_id AS family_id_24, p2_.family_id AS family_id_25, p2_.membership_id AS membership_id_26 FROM stay s0_ INNER JOIN child c1_ ON s0_.child_id = c1_.id INNER JOIN place p2_ ON s0_.place_id = p2_.id WHERE c1_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND s0_.ends_at IS NULL AND s0_.status = 'CONFIRMED';

SELECT
  c0_.id AS id_0,
  c0_.pattern AS pattern_1,
  c0_.custom_slots AS custom_slots_2,
  c0_.anchor_date AS anchor_date_3,
  c0_.switch_minutes AS switch_minutes_4,
  c0_.starts_on AS starts_on_5,
  c0_.ends_on AS ends_on_6,
  c0_.auto_confirm AS auto_confirm_7,
  c0_.confirmed_until AS confirmed_until_8,
  c0_.generated_until AS generated_until_9,
  c0_.created_at AS created_at_10,
  c0_.archived_at AS archived_at_11,
  c0_.family_id AS family_id_12,
  c0_.place_a_id AS place_a_id_13,
  c0_.place_b_id AS place_b_id_14
FROM
  custody_rule c0_
WHERE
  c0_.family_id = ?
  AND c0_.archived_at IS NULL
ORDER BY
  c0_.created_at ASC

SELECT c0_.id AS id_0, c0_.pattern AS pattern_1, c0_.custom_slots AS custom_slots_2, c0_.anchor_date AS anchor_date_3, c0_.switch_minutes AS switch_minutes_4, c0_.starts_on AS starts_on_5, c0_.ends_on AS ends_on_6, c0_.auto_confirm AS auto_confirm_7, c0_.confirmed_until AS confirmed_until_8, c0_.generated_until AS generated_until_9, c0_.created_at AS created_at_10, c0_.archived_at AS archived_at_11, c0_.family_id AS family_id_12, c0_.place_a_id AS place_a_id_13, c0_.place_b_id AS place_b_id_14 FROM custody_rule c0_ WHERE c0_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND c0_.archived_at IS NULL ORDER BY c0_.created_at ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.kind AS kind_2,
  p0_.attribution AS attribution_3,
  p0_.color AS color_4,
  p0_.position AS position_5,
  p0_.created_at AS created_at_6,
  p0_.archived_at AS archived_at_7,
  p0_.family_id AS family_id_8,
  p0_.membership_id AS membership_id_9
FROM
  place p0_
WHERE
  p0_.family_id = ?
  AND p0_.archived_at IS NULL
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.kind AS kind_2, p0_.attribution AS attribution_3, p0_.color AS color_4, p0_.position AS position_5, p0_.created_at AS created_at_6, p0_.archived_at AS archived_at_7, p0_.family_id AS family_id_8, p0_.membership_id AS membership_id_9 FROM place p0_ WHERE p0_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND p0_.archived_at IS NULL ORDER BY p0_.position ASC;

SELECT
  h0_.id AS id_0,
  h0_.occurred_at AS occurred_at_1,
  h0_.confirmed_at AS confirmed_at_2,
  h0_.disputed_at AS disputed_at_3,
  h0_.created_at AS created_at_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.kind AS kind_7,
  p1_.attribution AS attribution_8,
  p1_.color AS color_9,
  p1_.position AS position_10,
  p1_.created_at AS created_at_11,
  p1_.archived_at AS archived_at_12,
  s2_.id AS id_13,
  s2_.starts_at AS starts_at_14,
  s2_.ends_at AS ends_at_15,
  s2_.status AS status_16,
  s2_.created_at AS created_at_17,
  c3_.id AS id_18,
  c3_.first_name AS first_name_19,
  c3_.birth_date AS birth_date_20,
  c3_.color AS color_21,
  c3_.position AS position_22,
  c3_.created_at AS created_at_23,
  c3_.archived_at AS archived_at_24,
  h0_.family_id AS family_id_25,
  h0_.place_id AS place_id_26,
  h0_.recorded_by_id AS recorded_by_id_27,
  h0_.confirmed_by_id AS confirmed_by_id_28,
  h0_.disputed_by_id AS disputed_by_id_29,
  p1_.family_id AS family_id_30,
  p1_.membership_id AS membership_id_31,
  s2_.child_id AS child_id_32,
  s2_.place_id AS place_id_33,
  s2_.recorded_by_id AS recorded_by_id_34,
  s2_.opened_by_id AS opened_by_id_35,
  c3_.family_id AS family_id_36
FROM
  handover h0_
  INNER JOIN place p1_ ON h0_.place_id = p1_.id
  LEFT JOIN stay s2_ ON h0_.id = s2_.opened_by_id
  LEFT JOIN child c3_ ON s2_.child_id = c3_.id
WHERE
  h0_.family_id = ?
  AND h0_.recorded_by_id IS NOT NULL
  AND h0_.occurred_at >= ?
  AND h0_.recorded_by_id <> ?
  AND h0_.confirmed_at IS NULL
  AND h0_.disputed_at IS NULL
ORDER BY
  h0_.occurred_at DESC,
  s2_.starts_at ASC

SELECT h0_.id AS id_0, h0_.occurred_at AS occurred_at_1, h0_.confirmed_at AS confirmed_at_2, h0_.disputed_at AS disputed_at_3, h0_.created_at AS created_at_4, p1_.id AS id_5, p1_.name AS name_6, p1_.kind AS kind_7, p1_.attribution AS attribution_8, p1_.color AS color_9, p1_.position AS position_10, p1_.created_at AS created_at_11, p1_.archived_at AS archived_at_12, s2_.id AS id_13, s2_.starts_at AS starts_at_14, s2_.ends_at AS ends_at_15, s2_.status AS status_16, s2_.created_at AS created_at_17, c3_.id AS id_18, c3_.first_name AS first_name_19, c3_.birth_date AS birth_date_20, c3_.color AS color_21, c3_.position AS position_22, c3_.created_at AS created_at_23, c3_.archived_at AS archived_at_24, h0_.family_id AS family_id_25, h0_.place_id AS place_id_26, h0_.recorded_by_id AS recorded_by_id_27, h0_.confirmed_by_id AS confirmed_by_id_28, h0_.disputed_by_id AS disputed_by_id_29, p1_.family_id AS family_id_30, p1_.membership_id AS membership_id_31, s2_.child_id AS child_id_32, s2_.place_id AS place_id_33, s2_.recorded_by_id AS recorded_by_id_34, s2_.opened_by_id AS opened_by_id_35, c3_.family_id AS family_id_36 FROM handover h0_ INNER JOIN place p1_ ON h0_.place_id = p1_.id LEFT JOIN stay s2_ ON h0_.id = s2_.opened_by_id LEFT JOIN child c3_ ON s2_.child_id = c3_.id WHERE h0_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND h0_.recorded_by_id IS NOT NULL AND h0_.occurred_at >= '2026-07-28 23:16:40' AND h0_.recorded_by_id <> '019fb532-f6d3-7a78-b064-0455c205020c' AND h0_.confirmed_at IS NULL AND h0_.disputed_at IS NULL ORDER BY h0_.occurred_at DESC, s2_.starts_at ASC;

SELECT
  h0_.id AS id_0,
  h0_.occurred_at AS occurred_at_1,
  h0_.confirmed_at AS confirmed_at_2,
  h0_.disputed_at AS disputed_at_3,
  h0_.created_at AS created_at_4,
  p1_.id AS id_5,
  p1_.name AS name_6,
  p1_.kind AS kind_7,
  p1_.attribution AS attribution_8,
  p1_.color AS color_9,
  p1_.position AS position_10,
  p1_.created_at AS created_at_11,
  p1_.archived_at AS archived_at_12,
  s2_.id AS id_13,
  s2_.starts_at AS starts_at_14,
  s2_.ends_at AS ends_at_15,
  s2_.status AS status_16,
  s2_.created_at AS created_at_17,
  c3_.id AS id_18,
  c3_.first_name AS first_name_19,
  c3_.birth_date AS birth_date_20,
  c3_.color AS color_21,
  c3_.position AS position_22,
  c3_.created_at AS created_at_23,
  c3_.archived_at AS archived_at_24,
  h0_.family_id AS family_id_25,
  h0_.place_id AS place_id_26,
  h0_.recorded_by_id AS recorded_by_id_27,
  h0_.confirmed_by_id AS confirmed_by_id_28,
  h0_.disputed_by_id AS disputed_by_id_29,
  p1_.family_id AS family_id_30,
  p1_.membership_id AS membership_id_31,
  s2_.child_id AS child_id_32,
  s2_.place_id AS place_id_33,
  s2_.recorded_by_id AS recorded_by_id_34,
  s2_.opened_by_id AS opened_by_id_35,
  c3_.family_id AS family_id_36
FROM
  handover h0_
  INNER JOIN place p1_ ON h0_.place_id = p1_.id
  LEFT JOIN stay s2_ ON h0_.id = s2_.opened_by_id
  LEFT JOIN child c3_ ON s2_.child_id = c3_.id
WHERE
  h0_.family_id = ?
  AND h0_.recorded_by_id IS NOT NULL
  AND h0_.occurred_at >= ?
  AND h0_.recorded_by_id = ?
  AND h0_.disputed_at IS NOT NULL
ORDER BY
  h0_.occurred_at DESC,
  s2_.starts_at ASC

SELECT h0_.id AS id_0, h0_.occurred_at AS occurred_at_1, h0_.confirmed_at AS confirmed_at_2, h0_.disputed_at AS disputed_at_3, h0_.created_at AS created_at_4, p1_.id AS id_5, p1_.name AS name_6, p1_.kind AS kind_7, p1_.attribution AS attribution_8, p1_.color AS color_9, p1_.position AS position_10, p1_.created_at AS created_at_11, p1_.archived_at AS archived_at_12, s2_.id AS id_13, s2_.starts_at AS starts_at_14, s2_.ends_at AS ends_at_15, s2_.status AS status_16, s2_.created_at AS created_at_17, c3_.id AS id_18, c3_.first_name AS first_name_19, c3_.birth_date AS birth_date_20, c3_.color AS color_21, c3_.position AS position_22, c3_.created_at AS created_at_23, c3_.archived_at AS archived_at_24, h0_.family_id AS family_id_25, h0_.place_id AS place_id_26, h0_.recorded_by_id AS recorded_by_id_27, h0_.confirmed_by_id AS confirmed_by_id_28, h0_.disputed_by_id AS disputed_by_id_29, p1_.family_id AS family_id_30, p1_.membership_id AS membership_id_31, s2_.child_id AS child_id_32, s2_.place_id AS place_id_33, s2_.recorded_by_id AS recorded_by_id_34, s2_.opened_by_id AS opened_by_id_35, c3_.family_id AS family_id_36 FROM handover h0_ INNER JOIN place p1_ ON h0_.place_id = p1_.id LEFT JOIN stay s2_ ON h0_.id = s2_.opened_by_id LEFT JOIN child c3_ ON s2_.child_id = c3_.id WHERE h0_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND h0_.recorded_by_id IS NOT NULL AND h0_.occurred_at >= '2026-07-28 23:16:40' AND h0_.recorded_by_id = '019fb532-f6d3-7a78-b064-0455c205020c' AND h0_.disputed_at IS NOT NULL ORDER BY h0_.occurred_at DESC, s2_.starts_at ASC;

SELECT
  s0_.id AS id_0,
  s0_.starts_at AS starts_at_1,
  s0_.ends_at AS ends_at_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  c1_.id AS id_5,
  c1_.first_name AS first_name_6,
  c1_.birth_date AS birth_date_7,
  c1_.color AS color_8,
  c1_.position AS position_9,
  c1_.created_at AS created_at_10,
  c1_.archived_at AS archived_at_11,
  p2_.id AS id_12,
  p2_.name AS name_13,
  p2_.kind AS kind_14,
  p2_.attribution AS attribution_15,
  p2_.color AS color_16,
  p2_.position AS position_17,
  p2_.created_at AS created_at_18,
  p2_.archived_at AS archived_at_19,
  s0_.child_id AS child_id_20,
  s0_.place_id AS place_id_21,
  s0_.recorded_by_id AS recorded_by_id_22,
  s0_.opened_by_id AS opened_by_id_23,
  c1_.family_id AS family_id_24,
  p2_.family_id AS family_id_25,
  p2_.membership_id AS membership_id_26
FROM
  stay s0_
  INNER JOIN child c1_ ON s0_.child_id = c1_.id
  INNER JOIN place p2_ ON s0_.place_id = p2_.id
WHERE
  c1_.family_id = ?
  AND s0_.status = ?
  AND s0_.starts_at > ?
ORDER BY
  s0_.starts_at ASC

SELECT s0_.id AS id_0, s0_.starts_at AS starts_at_1, s0_.ends_at AS ends_at_2, s0_.status AS status_3, s0_.created_at AS created_at_4, c1_.id AS id_5, c1_.first_name AS first_name_6, c1_.birth_date AS birth_date_7, c1_.color AS color_8, c1_.position AS position_9, c1_.created_at AS created_at_10, c1_.archived_at AS archived_at_11, p2_.id AS id_12, p2_.name AS name_13, p2_.kind AS kind_14, p2_.attribution AS attribution_15, p2_.color AS color_16, p2_.position AS position_17, p2_.created_at AS created_at_18, p2_.archived_at AS archived_at_19, s0_.child_id AS child_id_20, s0_.place_id AS place_id_21, s0_.recorded_by_id AS recorded_by_id_22, s0_.opened_by_id AS opened_by_id_23, c1_.family_id AS family_id_24, p2_.family_id AS family_id_25, p2_.membership_id AS membership_id_26 FROM stay s0_ INNER JOIN child c1_ ON s0_.child_id = c1_.id INNER JOIN place p2_ ON s0_.place_id = p2_.id WHERE c1_.family_id = '019fb532-f6d3-7a00-b064-0455c123f772' AND s0_.status = 'PLANNED' AND s0_.starts_at > '2026-07-30 23:16:40' ORDER BY s0_.starts_at ASC;