Symfony Profiler

[
  "route" => "app_dashboard"
  "route_parameters" => [
    "_route" => "app_dashboard"
    "_controller" => "App\Controller\DashboardController::index"
  ]
  "request_uri" => "https://dev.nestido.com/tableau-de-bord"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "nestidodev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "nestidodev_db"
    "serverVersion" => "18"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "019fb532-f584-74b2-9306-c6da112a6f5b"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "demo@nestido.com"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#764
      #uid: "019fb532-f584-74b2-9306-c6da112a6f5b"
      toBase58: "1CdZ3wUp7kHU8RGJLrv2re"
      toBase32: "01KYTK5XC4EJS961P6V88JMVTV"
      time: "2026-07-30 22:44:03.588300 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
    2 => "CONFIRMED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
    2 => "2026-07-28 23:17:30"
    3 => Symfony\Component\Uid\UuidV7 {#950
      #uid: "019fb532-f6d3-7a78-b064-0455c205020c"
      toBase58: "1CdZ3wWFCDwo14MwgdXoN3"
      toBase32: "01KYTK5XPKF9WB0S04AQ10A0GC"
      time: "2026-07-30 22:44:03.923670 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
    3 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
    2 => "2026-07-28 23:17:30"
    3 => Symfony\Component\Uid\UuidV7 {#950
      #uid: "019fb532-f6d3-7a78-b064-0455c205020c"
      toBase58: "1CdZ3wWFCDwo14MwgdXoN3"
      toBase32: "01KYTK5XPKF9WB0S04AQ10A0GC"
      time: "2026-07-30 22:44:03.923670 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
    3 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => Symfony\Component\Uid\UuidV7 {#931
      #uid: "019fb532-f6d3-7a00-b064-0455c123f772"
      toBase58: "1CdZ3wWFCCRCgaSPqZpaR7"
      toBase32: "01KYTK5XPKF80B0S04AQ0J7XVJ"
      time: "2026-07-30 22:44:03.923640 UTC"
    }
    2 => "PLANNED"
    3 => "2026-07-30 23:17:30"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
    3 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "key" => "_security_main"
]