Symfony Profiler

[
  "route" => "api_list_customers"
  "route_parameters" => [
    "_route" => "api_list_customers"
    "_controller" => "App\User\Adapters\Controller\ListCustomer\ListCustomerController"
  ]
  "request_uri" => "https://recette.junglebike.fr/api/customers"
  "method" => "GET"
]

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

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

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "postgres"
    "port" => 5432
    "user" => "junglebike"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dbjunglebike"
    "serverVersion" => "17"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.email = ? AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') LIMIT 1"
  "params" => [
    1 => "jb@manager.local"
  ]
  "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 {#592
    -user: App\Entity\User {#964 …}
    -roleNames: [
      "ROLE_MANAGER"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjYwNzUwMjcsImV4cCI6MTc2NjA3ODYyNywicm9sZXMiOlsiUk9MRV9NQU5BR0VSIl0sInVzZXJuYW1lIjoiamJAbWFuYWdlci5sb2NhbCIsInV1aWQiOiIxZjA4ZjJiNS1iZTNlLTY1NjAtOWI5MS1hM2UzMzBhMGY4NDciLCJmaXJzdG5hbWUiOiJMw6lvIiwibGFzdG5hbWUiOiJMZXJveSJ9.HOex_SsMUQPev6lt4VRS7CUvdviWvam-QuWalKVXU6v2-cNfEQvW2d2FwnnweC3lsVXHAl5L-Knlaovy1rXBXqQlvCutAN7A63dw--a7KxnOEt1soYYJE78Yof_VEu7pWgXQLh6MDkUGpkU6Q2BrnBkv9GJKCRN_d6iipVzkAxqeu14rZ2o-yhxq892Alxr6g_vP0cBF2vh9MC2L7PqbC-VjYGU7JLNunKiY7FWuubNNteNtdxu-mIaBdvO1w8aOdJ6DIWOjSnMEEwLsIhy4iwWSZ5-jMYPbqv4CbguuXn5pR8SIFlimNLUIOO5qAM9vnBoitBgBKKuxMEe0a6HsYw"
  }
  "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" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::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" => "App\Shared\Adapters\Events\Request::queryToRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Shared\Adapters\Events\Request::localeToRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Shared\Adapters\Events\Images::ImagesManagerRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Shared\Adapters\Events\Request::parametersToRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\Shared\Adapters\Events\Request::jsonDataToRequest"
]

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

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

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

[
  "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" => "ContainerAxpqaXD\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT j0_.id AS id_0, j0_.username AS username_1, j0_.password AS password_2, j0_.roles AS roles_3, j0_.firstname AS firstname_4, j0_.lastname AS lastname_5, j0_.email AS email_6, j0_.is_verified AS is_verified_7, j0_.is_active AS is_active_8, j0_.phone_number AS phone_number_9, j0_.dialing_code AS dialing_code_10, j0_.created_at AS created_at_11, j0_.updated_at AS updated_at_12, j0_.created_by AS created_by_13, j0_.updated_by AS updated_by_14, j0_.siret AS siret_15, j0_.company_name AS company_name_16, j0_.addresses AS addresses_17, j0_.avatar_path AS avatar_path_18, COUNT(DISTINCT b1_.id) AS sclr_19, j0_.type AS type_20 FROM jb_user j0_ LEFT JOIN bike b1_ ON (b1_.owner_id = j0_.id) WHERE (j0_.roles::jsonb @> ?::jsonb = true) AND j0_.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') GROUP BY j0_.id ORDER BY j0_.created_at DESC"
  "params" => [
    1 => "["ROLE_CUSTOMER"]"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT\n
        u.id,\n
        u.firstname,\n
        u.lastname,\n
        COALESCE(COUNT(a.id) FILTER (WHERE a.status IS DISTINCT FROM 'cancelled'), 0) AS visits,\n
        MAX(a.start_date) FILTER (WHERE a.start_date <= NOW()\n
            AND a.status IS DISTINCT FROM 'cancelled')          AS last_visit,\n
        MIN(a.start_date) FILTER (WHERE a.start_date >  NOW()\n
            AND a.status IS DISTINCT FROM 'cancelled')          AS next_visit\n
    FROM jb_user AS u\n
             LEFT JOIN appointment AS a\n
                       ON a.customer_id = u.id\n
    WHERE u.roles @> '["ROLE_CUSTOMER"]'::jsonb\n
    GROUP BY u.id, u.firstname, u.lastname\n
    ORDER BY visits DESC, last_visit DESC NULLS LAST
    """
  "params" => []
  "types" => []
]

[
  "sql" => """
    SELECT DISTINCT addr->>'city' AS city\n
    FROM jb_user u\n
         CROSS JOIN LATERAL jsonb_array_elements(u.addresses::jsonb) AS addr\n
    WHERE COALESCE(addr->>'city','') <> ''   AND u.roles @> '["ROLE_CUSTOMER"]'::jsonb\n
    ORDER BY city ASC
    """
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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"
]