Symfony Profiler

[
  "route" => "api_bikes_by_role"
  "route_parameters" => [
    "_route" => "api_bikes_by_role"
    "_controller" => "App\Bike\Adapters\Controllers\Http\FindBikes\FindBikesController"
  ]
  "request_uri" => "https://recette.junglebike.fr/api/bikes?limit=10&page=1"
  "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 {#590
    -user: App\Entity\User {#962 …}
    -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 DISTINCT id_0, MIN(sclr_44) AS dctrn_minrownum FROM (SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, ROW_NUMBER() OVER(ORDER BY b0_.created_at DESC) AS sclr_44, j1_.type AS type_45 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = ?) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, j1_.type AS type_44 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC"
  "params" => [
    1 => 1
    2 => "1f0d6b43-9171-6db0-97a9-c7f1284015c3"
    3 => "1f0d6b39-7a41-61e0-9c4d-c50023f1bc04"
    4 => "1f0d69b4-ce0a-63ac-93ea-f914adb90aba"
    5 => "1f0d696d-2e3e-6d9c-b91f-d3222596bc14"
    6 => "1f0d5ee4-cdae-68b6-abf5-cffd4f370ac0"
    7 => "1f0d5edf-1c6e-611e-8d9c-bb716f6753a8"
    8 => "1f0d5c5c-73f9-6a62-a8de-63fbc77587c8"
    9 => "1f0d5c53-d0f1-6fde-b361-83b53778fc1b"
    10 => "1f0d5bd5-4717-6526-b367-83e4dc4bfe1f"
    11 => "1f0d5bd1-975b-6cde-b931-ed66789e1b93"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.last_visit AS last_visit_2, b0_.next_visit AS next_visit_3, b0_.number_of_visits AS number_of_visits_4, b0_.assigned_repair_person AS assigned_repair_person_5, b0_.name AS name_6, b0_.brand AS brand_7, b0_.model AS model_8, b0_.bicycode AS bicycode_9, b0_.is_electric AS is_electric_10, b0_.size AS size_11, b0_.type AS type_12, b0_.collection AS collection_13, b0_.condition AS condition_14, b0_.purchase_date AS purchase_date_15, b0_.technical_data AS technical_data_16, b0_.administrative_data AS administrative_data_17, b0_.created_at AS created_at_18, b0_.updated_at AS updated_at_19, b0_.created_by AS created_by_20, b0_.updated_by AS updated_by_21, b0_.jb_ref AS jb_ref_22, j1_.id AS id_23, j1_.username AS username_24, j1_.password AS password_25, j1_.roles AS roles_26, j1_.firstname AS firstname_27, j1_.lastname AS lastname_28, j1_.email AS email_29, j1_.is_verified AS is_verified_30, j1_.is_active AS is_active_31, j1_.phone_number AS phone_number_32, j1_.dialing_code AS dialing_code_33, j1_.created_at AS created_at_34, j1_.updated_at AS updated_at_35, j1_.created_by AS created_by_36, j1_.updated_by AS updated_by_37, j1_.siret AS siret_38, j1_.company_name AS company_name_39, j1_.addresses AS addresses_40, j1_.avatar_path AS avatar_path_41, f2_.id AS id_42, f2_.fleet_name AS fleet_name_43, j1_.type AS type_44 FROM bike b0_ LEFT JOIN jb_user j1_ ON b0_.owner_id = j1_.id AND j1_.type IN ('customer', 'fleet') LEFT JOIN fleet_company_bike f3_ ON b0_.id = f3_.bike_id LEFT JOIN fleet_company f2_ ON f2_.id = f3_.fleet_company_id WHERE b0_.is_active = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "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.id = ? AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet')"
  "params" => [
    1 => "9865f19a-3280-4867-8389-7de183a9f91f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT b0_.brand AS brand_0 FROM bike b0_ WHERE b0_.brand IS NOT NULL ORDER BY b0_.brand ASC"
]

[
  "sql" => "SELECT DISTINCT b0_.type AS type_0 FROM bike b0_ WHERE b0_.type IS NOT NULL ORDER BY b0_.type ASC"
]

[
  "sql" => "SELECT DISTINCT b0_.model AS model_0 FROM bike b0_ WHERE b0_.model IS NOT NULL ORDER BY b0_.model ASC"
]

[
  "sql" => "SELECT DISTINCT f0_.fleet_name AS fleet_name_0 FROM bike b1_ INNER JOIN fleet_company_bike f2_ ON b1_.id = f2_.bike_id INNER JOIN fleet_company f0_ ON f0_.id = f2_.fleet_company_id ORDER BY f0_.fleet_name ASC"
]

[
  "sql" => "SELECT DISTINCT b0_.jb_ref AS jb_ref_0 FROM bike b0_ ORDER BY b0_.jb_ref ASC"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.name AS name_1, COUNT(a1_.id) AS sclr_2 FROM bike b0_ LEFT JOIN appointment a1_ ON b0_.id = a1_.bike_id GROUP BY b0_.id, b0_.name ORDER BY sclr_2 DESC"
]

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