Symfony Profiler

[
  "route" => "app_login"
  "route_parameters" => [
    "_route" => "app_login"
    "_controller" => "App\Controller\SecurityController::index"
    "_locale" => "fr"
  ]
  "request_uri" => "https://beta.client.securovision.com/fr/login"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "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" => "App\EventSubscriber\LocaleSubscriber::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" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_sqlsrv"
    "host" => "68.67.52.246"
    "port" => null
    "user" => "SecuroWeb"
    "password" => "<redacted>"
    "driverOptions" => [
      "TrustServerCertificate" => 1
    ]
    "defaultTableOptions" => []
    "dbname" => "SECUROBETA"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "sql" => """
    SELECT name AS table_name,\n
           SCHEMA_NAME(schema_id) AS schema_name\n
    FROM sys.objects\n
    WHERE type = 'U'\n
      AND name != 'sysdiagrams'\n
    ORDER BY name
    """
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "sql" => """
    SELECT name AS table_name,\n
           SCHEMA_NAME(schema_id) AS schema_name\n
    FROM sys.objects\n
    WHERE type = 'U'\n
      AND name != 'sysdiagrams'\n
    ORDER BY name
    """
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "sql" => """
              SELECT\n
                tbl.name,\n
                p.value AS [table_comment]\n
              FROM\n
                sys.tables AS tbl\n
                INNER JOIN sys.extended_properties AS p ON p.major_id=tbl.object_id AND p.minor_id=0 AND p.class=1 WHERE SCHEMA_NAME(tbl.schema_id) = N'dbo' AND p.name = N'MS_Description' AND tbl.name = N'doctrine_migration_versions'
    """
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "sql" => """
    SELECT                f.name AS ForeignKey,\n
                    SCHEMA_NAME (f.SCHEMA_ID) AS SchemaName,\n
                    OBJECT_NAME (f.parent_object_id) AS TableName,\n
                    COL_NAME (fc.parent_object_id,fc.parent_column_id) AS ColumnName,\n
                    SCHEMA_NAME (o.SCHEMA_ID) ReferenceSchemaName,\n
                    OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,\n
                    COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName,\n
                    f.delete_referential_action_desc,\n
                    f.update_referential_action_desc\n
                    FROM sys.foreign_keys AS f\n
                    INNER JOIN sys.foreign_key_columns AS fc\n
                    INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id\n
                    ON f.OBJECT_ID = fc.constraint_object_id WHERE (OBJECT_NAME(f.parent_object_id) = 'doctrine_migration_versions' AND SCHEMA_NAME(f.schema_id) = SCHEMA_NAME()) ORDER BY fc.constraint_column_id
    """
]

[
  "sql" => """
    SELECT                          col.name,\n
                              type.name AS type,\n
                              col.max_length AS length,\n
                              ~col.is_nullable AS notnull,\n
                              def.definition AS [default],\n
                              col.scale,\n
                              col.precision,\n
                              col.is_identity AS autoincrement,\n
                              col.collation_name AS collation,\n
                              -- CAST avoids driver error for sql_variant type\n
                              CAST(prop.value AS NVARCHAR(MAX)) AS comment\n
                    FROM      sys.columns AS col\n
                    JOIN      sys.types AS type\n
                    ON        col.user_type_id = type.user_type_id\n
                    JOIN      sys.objects AS obj\n
                    ON        col.object_id = obj.object_id\n
                    JOIN      sys.schemas AS scm\n
                    ON        obj.schema_id = scm.schema_id\n
                    LEFT JOIN sys.default_constraints def\n
                    ON        col.default_object_id = def.object_id\n
                    AND       col.object_id = def.parent_object_id\n
                    LEFT JOIN sys.extended_properties AS prop\n
                    ON        obj.object_id = prop.major_id\n
                    AND       col.column_id = prop.minor_id\n
                    AND       prop.name = 'MS_Description' WHERE obj.type = 'U' AND obj.name != 'sysdiagrams' AND (obj.name = 'doctrine_migration_versions' AND scm.name = SCHEMA_NAME())
    """
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "sql" => """
    SELECT                       idx.name AS key_name,\n
                           col.name AS column_name,\n
                           ~idx.is_unique AS non_unique,\n
                           idx.is_primary_key AS [primary],\n
                           CASE idx.type\n
                               WHEN '1' THEN 'clustered'\n
                               WHEN '2' THEN 'nonclustered'\n
                               ELSE NULL\n
                           END AS flags\n
                    FROM sys.tables AS tbl\n
                    JOIN sys.schemas AS scm\n
                      ON tbl.schema_id = scm.schema_id\n
                    JOIN sys.indexes AS idx\n
                      ON tbl.object_id = idx.object_id\n
                    JOIN sys.index_columns AS idxcol\n
                      ON idx.object_id = idxcol.object_id\n
                     AND idx.index_id = idxcol.index_id\n
                    JOIN sys.columns AS col\n
                      ON idxcol.object_id = col.object_id\n
                     AND idxcol.column_id = col.column_id WHERE (tbl.name = 'doctrine_migration_versions' AND scm.name = SCHEMA_NAME()) ORDER BY idx.index_id, idxcol.key_ordinal
    """
]

[
  "sql" => "SELECT collation_name FROM sys.databases WHERE name = DB_NAME()"
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT DB_NAME()"
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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"
]