Symfony Profiler

[
  "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\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.exception"
  "listener" => "App\System\Listener\Response\ResponseExceptionListener::onKernelException"
]

[
  "event" => "kernel.exception"
  "listener" => "App\System\Listener\Response\ResponseExceptionListener::onKernelException"
]

[
  "event" => "kernel.exception"
  "listener" => "ApiPlatform\Core\Bridge\Symfony\Validator\EventListener\ValidationExceptionListener::onKernelException"
]

[
  "event" => "kernel.exception"
  "listener" => "App\System\Exception\Listener\ExceptionListener::onKernelException"
]

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

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

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

[
  "event" => "kernel.exception"
  "listener" => "ApiPlatform\Core\EventListener\ExceptionListener::onKernelException"
]

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_pgsql"
    "host" => "postgres"
    "port" => 5432
    "user" => "insfin"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "db"
    "serverVersion" => "14"
    "charset" => "utf8"
  ]
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
                           table_schema AS schema_name\n
                    FROM   information_schema.tables\n
                    WHERE  table_schema NOT LIKE 'pg\_%'\n
                    AND    table_schema != 'information_schema'\n
                    AND    table_name != 'geometry_columns'\n
                    AND    table_name != 'spatial_ref_sys'\n
                    AND    table_type != 'VIEW'
    """
]

[
  "sql" => """
    SELECT schema_name\n
    FROM   information_schema.schemata\n
    WHERE  schema_name NOT LIKE 'pg\_%'\n
    AND    schema_name != 'information_schema'
    """
]

[
  "sql" => "SHOW search_path"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
                           table_schema AS schema_name\n
                    FROM   information_schema.tables\n
                    WHERE  table_schema NOT LIKE 'pg\_%'\n
                    AND    table_schema != 'information_schema'\n
                    AND    table_name != 'geometry_columns'\n
                    AND    table_name != 'spatial_ref_sys'\n
                    AND    table_type != 'VIEW'
    """
]

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

[
  "sql" => """
    SELECT\n
                        a.attnum,\n
                        quote_ident(a.attname) AS field,\n
                        t.typname AS type,\n
                        format_type(a.atttypid, a.atttypmod) AS complete_type,\n
                        (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,\n
                        (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,\n
                        (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM\n
                          pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,\n
                        a.attnotnull AS isnotnull,\n
                        (SELECT 't'\n
                         FROM pg_index\n
                         WHERE c.oid = pg_index.indrelid\n
                            AND pg_index.indkey[0] = a.attnum\n
                            AND pg_index.indisprimary = 't'\n
                        ) AS pri,\n
                        (SELECT pg_get_expr(adbin, adrelid)\n
                         FROM pg_attrdef\n
                         WHERE c.oid = pg_attrdef.adrelid\n
                            AND pg_attrdef.adnum=a.attnum\n
                        ) AS default,\n
                        (SELECT pg_description.description\n
                            FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid\n
                        ) AS comment\n
                        FROM pg_attribute a, pg_class c, pg_type t, pg_namespace n\n
                        WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false))\n
                            AND a.attnum > 0\n
                            AND a.attrelid = c.oid\n
                            AND a.atttypid = t.oid\n
                            AND n.oid = c.relnamespace\n
                        ORDER BY a.attnum
    """
]

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

[
  "sql" => """
    SELECT quote_ident(r.conname) as conname, pg_catalog.pg_get_constraintdef(r.oid, true) as condef\n
                      FROM pg_catalog.pg_constraint r\n
                      WHERE r.conrelid =\n
                      (\n
                          SELECT c.oid\n
                          FROM pg_catalog.pg_class c, pg_catalog.pg_namespace n\n
                          WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false)) AND n.oid = c.relnamespace\n
                      )\n
                      AND r.contype = 'f'
    """
]

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

[
  "sql" => """
    SELECT quote_ident(relname) as relname, pg_index.indisunique, pg_index.indisprimary,\n
                           pg_index.indkey, pg_index.indrelid,\n
                           pg_get_expr(indpred, indrelid) AS where\n
                     FROM pg_class, pg_index\n
                     WHERE oid IN (\n
                        SELECT indexrelid\n
                        FROM pg_index si, pg_class sc, pg_namespace sn\n
                        WHERE sn.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND sc.relname = 'doctrine_migration_versions' AND sn.nspname = ANY(current_schemas(false))\n
                        AND sc.oid=si.indrelid AND sc.relnamespace = sn.oid\n
                     ) AND pg_index.indexrelid = oid
    """
]

[
  "sql" => "SELECT attnum, attname FROM pg_attribute WHERE attrelid=33264 AND attnum IN (1) ORDER BY attnum ASC"
]

[
  "sql" => "SELECT obj_description('doctrine_migration_versions'::regclass) AS table_comment;"
]

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

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

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

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

[
  "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" => "ApiPlatform\Core\HttpCache\EventListener\AddHeadersListener::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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

[
  "message" => App\System\Infrastructure\Implementation\Logger\Request\RequestAndResponseMessageLog {#1917
    +type: "request"
    +requester: []
    +requestBody: []
    +endpoint: "/robots.txt"
    +method: "GET"
    +responseBody: [
      "title" => "Bad Request"
      "status" => 400
      "detail" => "No route found for "GET http://212.224.118.122:8082/robots.txt""
      "codes" => 0
      "violations" => []
    ]
    +httpCode: 400
    +requestId: Ramsey\Uuid\Lazy\LazyUuidFromString {#1930 …}
  }
  "class" => "App\System\Infrastructure\Implementation\Logger\Request\RequestAndResponseMessageLog"
  "alias" => "logstash"
  "sender" => "Symfony\Component\Messenger\Bridge\Amqp\Transport\AmqpTransport"
]