Symfony Profiler

[
  "route" => "api_ip_get_info"
  "route_parameters" => [
    "_route" => "api_ip_get_info"
    "_controller" => "App\Controller\ApiController::ipGetInfo"
  ]
  "request_uri" => "https://iplocator.yeebill.net/api/ip/get-info"
  "method" => "POST"
]

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "iplocator_db"
    "port" => 3306
    "user" => "iplocator"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "iplocator"
    "serverVersion" => "11.8.5-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uname AS uname_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_stamp AS created_stamp_6, t0.deleted_stamp AS deleted_stamp_7, t0.lastlogin_stamp AS lastlogin_stamp_8, t0.lastlogin_agent AS lastlogin_agent_9 FROM `user` t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "as@iplocator.yeebill.net"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#468
      +name: "STRING"
    }
  ]
]

[
  "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\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" => Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken {#560
    -user: App\Entity\User {#464 …}
    -roleNames: [
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "api"
  }
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\HttpBasicAuthenticator"
]

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

[
  "sql" => "UPDATE `user` SET lastlogin_stamp = ? WHERE id = ?"
  "params" => [
    1 => 1780004011
    2 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#470
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#470}
  ]
]

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

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

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

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

[
  "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" => "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.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

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

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

[
  "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" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.created_stamp AS created_stamp_1, r0_.ip_address AS ip_address_2, r0_.as_number AS as_number_3, r0_.as_country AS as_country_4, r0_.as_description AS as_description_5, r0_.vpn AS vpn_6, r0_.consumer AS consumer_7, r0_.caller_id AS caller_id_8, r0_.config_id AS config_id_9 FROM request r0_ WHERE r0_.ip_address = ? AND r0_.config_id IS NOT NULL ORDER BY r0_.created_stamp DESC LIMIT 1"
  "params" => [
    1 => "2607:fb90:cb2e:4376:9166:7641:bddb:3927"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#468
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.as_number AS as_number_1, c0_.as_desc_regexp AS as_desc_regexp_2, c0_.ip_range AS ip_range_3, c0_.vpn AS vpn_4, c0_.consumer AS consumer_5, c0_.note AS note_6, c0_.created_stamp AS created_stamp_7, c0_.created_by_id AS created_by_id_8 FROM config c0_ WHERE c0_.as_number = ? ORDER BY c0_.created_stamp DESC LIMIT 1"
  "params" => [
    1 => 21928
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#470
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO request (created_stamp, ip_address, as_number, as_country, as_description, vpn, consumer, caller_id, config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1780004011
    2 => "2607:fb90:cb2e:4376:9166:7641:bddb:3927"
    3 => 21928
    4 => "US"
    5 => "T-MOBILE-AS21928"
    6 => 0
    7 => 1
    8 => 2
    9 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#470
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#468
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#470}
    4 => Doctrine\DBAL\ParameterType {#468}
    5 => Doctrine\DBAL\ParameterType {#468}
    6 => Doctrine\DBAL\ParameterType {#840
      +name: "BOOLEAN"
    }
    7 => Doctrine\DBAL\ParameterType {#840}
    8 => Doctrine\DBAL\ParameterType {#470}
    9 => Doctrine\DBAL\ParameterType {#470}
  ]
]

[
  "key" => "_security_api"
]

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

[
  "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\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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

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