Symfony Profiler

[
  "route" => "app_choreography"
  "route_parameters" => [
    "_route" => "app_choreography"
    "_controller" => "App\Controller\Choreography\ChoreographyListController::carnet"
  ]
  "request_uri" => "http://dev.coach-dance.lefief-cachan.fr/"
  "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\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/home/ubuntu/projects/coach-dance/var/data/coach_dance_dev.sqlite"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.username AS username_4, t0.created_at AS created_at_5, t0.locale AS locale_6 FROM app_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "florian.gabille@gmail.com"
]

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

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c0_.id IN (?, ?, ?) AND c0_.is_public = 1 ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC"
  "params" => [
    1 => "177491af-6141-4bd4-b418-caf374ea0548"
    2 => "97e30211-93d9-41b6-8429-b4c95c1eddbd"
    3 => "bea49b0b-1f4f-4f14-8ea6-235bd13e2927"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1017
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1017}
    3 => Doctrine\DBAL\ParameterType {#1017}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.created_at AS created_at_2, p0_.revoked_at AS revoked_at_3, p0_.choreography_id AS choreography_id_4 FROM public_choreography_links p0_ WHERE p0_.revoked_at IS NULL AND p0_.choreography_id IN (?) ORDER BY p0_.created_at DESC"
  "params" => [
    1 => "177491af-6141-4bd4-b418-caf374ea0548"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1017
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM license l0_ WHERE l0_.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM choreography c0_ WHERE c0_.owner_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c0_.owner_id = ? ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.dance AS dance_2, c0_.level AS level_3, c0_.metadata AS metadata_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.is_public AS is_public_7, f1_.id AS id_8, f1_.name AS name_9, f1_.created_at AS created_at_10, f1_.updated_at AS updated_at_11, c2_.id AS id_12, c2_.position AS position_13, c2_.repeat_count AS repeat_count_14, c2_.start_at_step AS start_at_step_15, c2_.end_at_step AS end_at_step_16, f3_.id AS id_17, f3_.name AS name_18, f3_.slug AS slug_19, f3_.dance AS dance_20, f3_.duration AS duration_21, f3_.steps AS steps_22, f3_.rythm AS rythm_23, f3_.rhythms AS rhythms_24, f3_.international_level AS international_level_25, f3_.ffd_level AS ffd_level_26, f3_.role AS role_27, f3_.tempo AS tempo_28, f3_.created_at AS created_at_29, f3_.updated_at AS updated_at_30, c4_.id AS id_31, c4_.content AS content_32, c4_.created_at AS created_at_33, c4_.updated_at AS updated_at_34, c0_.owner_id AS owner_id_35, c0_.folder_id AS folder_id_36, f1_.owner_id AS owner_id_37, c2_.choreography_id AS choreography_id_38, c2_.figure_id AS figure_id_39, c4_.step_id AS step_id_40 FROM choreography c0_ INNER JOIN choreography_share c5_ ON c0_.id = c5_.choreography_id LEFT JOIN folder f1_ ON c0_.folder_id = f1_.id LEFT JOIN choreography_step c2_ ON c0_.id = c2_.choreography_id LEFT JOIN figure f3_ ON c2_.figure_id = f3_.id LEFT JOIN choreography_step_note c4_ ON c2_.id = c4_.step_id WHERE c5_.user_id = ? ORDER BY c0_.created_at DESC, c2_.position ASC, c4_.created_at DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f0_.owner_id AS owner_id_4 FROM folder f0_ WHERE f0_.owner_id = ? ORDER BY f0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.folder_id AS sclr_0, COUNT(c0_.id) AS sclr_1 FROM choreography_folder_assignment c0_ WHERE c0_.user_id = ? GROUP BY c0_.folder_id"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(l0_.id) AS sclr_0 FROM license l0_ WHERE l0_.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#725
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]