Symfony Profiler

[
  "route" => "api_get_home_data"
  "route_parameters" => [
    "_route" => "api_get_home_data"
    "_controller" => "App\Controller\UserApiController::getHomeData"
  ]
  "request_uri" => "https://mouve-app.com/api/user"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "mouvedb.c3pks18gzcyy.eu-west-3.rds.amazonaws.com"
    "port" => null
    "user" => "MouveAdmin"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "mouvedb"
    "charset" => "utf8mb4"
  ]
]

[
  "firewall_name" => "api"
  "authenticators" => 3
]

[
  "firewall_name" => "api"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\JsonLoginAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator"
]

[
  "firewall_name" => "api"
  "authenticator" => "Gesdinet\JWTRefreshTokenBundle\Security\Http\Authenticator\RefreshTokenAuthenticator"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.total_completed_days AS total_completed_days_5, t0.creation_date AS creation_date_6, t0.starting_date AS starting_date_7, t0.week_completed_percents AS week_completed_percents_8, t0.notes AS notes_9, t0.max_completed_days AS max_completed_days_10 FROM user t0 WHERE t0.username = ? LIMIT 1"
  "params" => [
    1 => "Nanou.1430"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#642
    -user: App\Entity\User {#553 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzYzMTYwODAsImV4cCI6MTczNjQwMjQ4MCwicm9sZXMiOlsiUk9MRV9VU0VSIl0sInVzZXJuYW1lIjoiTmFub3UuMTQzMCJ9.n4ojC_DLR7krURJvO5HuWUvdKe40PZeJkSqMIjiMAN7VCq6gLH2PJH6qh7zSK14NRkXdDDDuCFDhW78gQOTx7U_JYjnpqbfIyaDqrEzTw_ZOTEI7uCl4ry4cSVlZ9EcmhZUdWWUPehLYlLrGwd3U1cwmeKg7s41MQrsQznznnccDbitjLykDivhcYzxgEbnRbjjJIsaAVt9jF__DXgk6ykqXZpJJzmmP3CITGN-Rx54AObGNC_YwIkb-3Km4zICPdnTyes9J90FsAtrRguZqoqmH1xCZFvQmnpqjlcxatu4IN2FjBlDBtO2DXbix0WFhTFPx5X43_RGl5013ANI62w"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "SymfonyBundles\JsonRequestBundle\EventListener\RequestTransformerListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Nzo\UrlEncryptorBundle\Annotations\AnnotationResolver::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container1yE1IAx\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ? AND t0.is_weekly = ? AND t0.completed = ? LIMIT 1"
  "params" => [
    1 => 133
    2 => 1
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.avatar_id AS avatar_id_6 FROM user_avatar t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.level AS level_5, t0.avatar_type_id AS avatar_type_id_6, t0.badge_id AS badge_id_7 FROM avatar t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.accessory_id AS accessory_id_5, t0.user_id AS user_id_6 FROM user_accessory t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.title AS title_3, t0.unlock_how AS unlock_how_4, t0.avatar_id AS avatar_id_5, t0.badge_id AS badge_id_6 FROM accessory t0 WHERE t0.avatar_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT sum(e0_.to_do_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = ? AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1)"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT sum(e0_.daily_completed_count) AS sclr_0 FROM exercise e0_ WHERE e0_.user_id = ? AND e0_.completed = 0 AND (e0_.is_weekly = 1 OR e0_.is_permanent = 1)"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent AS is_permanent_13, t0.is_weekly AS is_weekly_14, t0.completed_count AS completed_count_15, t0.last_completed_date AS last_completed_date_16, t0.completed AS completed_17, t0.total_elapsed_seconds AS total_elapsed_seconds_18, t0.to_do_count AS to_do_count_19, t0.daily_completed_count AS daily_completed_count_20, t0.position AS position_21, t0.template_id AS template_id_22, t0.user_id AS user_id_23 FROM exercise t0 WHERE t0.user_id = ? AND t0.completed = ?"
  "params" => [
    1 => 133
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.seen AS seen_2, t0.earned AS earned_3, t0.earned_date AS earned_date_4, t0.user_id AS user_id_5, t0.badge_id AS badge_id_6 FROM user_badge t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.raw_value AS raw_value_3 FROM avatar_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 18
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.unlock_how AS unlock_how_4, t0.unlocked AS unlocked_5, t0.level AS level_6, t0.step_value AS step_value_7, t0.position AS position_8, t0.type_id AS type_id_9 FROM badge t0 WHERE t0.id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.images AS images_2, t0.video AS video_3, t0.html AS html_4, t0.theme AS theme_5, t0.to_do AS to_do_6, t0.how_to AS how_to_7, t0.when_to AS when_to_8, t0.attention_to AS attention_to_9, t0.success_how AS success_how_10, t0.duration AS duration_11, t0.subtitle AS subtitle_12, t0.is_permanent_by_default AS is_permanent_by_default_13, t0.is_weekly_by_default AS is_weekly_by_default_14, t0.to_do_count AS to_do_count_15, t0.added_value AS added_value_16, t0.position AS position_17, t0.type_id AS type_id_18, t0.badge_type_id AS badge_type_id_19, t0.linked_badge_id AS linked_badge_id_20 FROM exercise_template t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3 FROM exercise_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]