Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#198
    +count: 1
    -severity: E_USER_NOTICE
    trace: {
      /var/www/ai-analytics-tool/releases/20260917063632_dd5c1ee9/vendor/symfony/http-client/HttpClient.php:64 {
        Symfony\Component\HttpClient\HttpClient::create(array $defaultOptions = [], int $maxHostConnections = 6, int $maxPendingPushes = 50): HttpClientInterface …
        › 
        › @trigger_error((\extension_loaded('curl') ? 'Upgrade' : 'Install').' the curl extension or run "composer require amphp/http-client:^5" to perform async HTTP operations, including full HTTP/2 support', \E_USER_NOTICE);
        › 
      }
      /var/www/ai-analytics-tool/releases/20260917063632_dd5c1ee9/var/cache/dev/ContainerNDOeXNH/App_KernelDevDebugContainer.php:1736 {
        › {
        ›     $container->privates['http_client.transport'] = $instance = \Symfony\Component\HttpClient\HttpClient::create([], 6);
        › 
      }
    }
  }
]

{
  /var/www/ai-analytics-tool/releases/20260917063632_dd5c1ee9/vendor/symfony/http-client/HttpClient.php:64 {
    Symfony\Component\HttpClient\HttpClient::create(array $defaultOptions = [], int $maxHostConnections = 6, int $maxPendingPushes = 50): HttpClientInterface …
    › 
    › @trigger_error((\extension_loaded('curl') ? 'Upgrade' : 'Install').' the curl extension or run "composer require amphp/http-client:^5" to perform async HTTP operations, including full HTTP/2 support', \E_USER_NOTICE);
    › 
  }
  /var/www/ai-analytics-tool/releases/20260917063632_dd5c1ee9/var/cache/dev/ContainerNDOeXNH/App_KernelDevDebugContainer.php:1736 {
    › {
    ›     $container->privates['http_client.transport'] = $instance = \Symfony\Component\HttpClient\HttpClient::create([], 6);
    › 
  }
}

"app_statistics"

[
  "route" => "app_statistics"
  "route_parameters" => [
    "_route" => "app_statistics"
    "_controller" => "App\Controller\StatisticsController::index"
  ]
  "request_uri" => "https://ai-analytics-tool.staging.webwerk.at/statistiken"
  "method" => "GET"
]

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

[
  "driver" => "pdo_sqlsrv"
  "idle_connection_ttl" => 600
  "host" => "194.177.133.148"
  "port" => 1433
  "user" => "ai_analytics_tool_user"
  "password" => "<redacted>"
  "driverOptions" => [
    "TrustServerCertificate" => "1"
  ]
  "serverVersion" => "2022"
  "defaultTableOptions" => []
  "dbname" => "KI_Management"
  "Encrypt" => "yes"
  "TrustServerCertificate" => "yes"
  "charset" => "utf8"
]

[
  "params" => [
    "driver" => "pdo_sqlsrv"
    "idle_connection_ttl" => 600
    "host" => "194.177.133.148"
    "port" => 1433
    "user" => "ai_analytics_tool_user"
    "password" => "<redacted>"
    "driverOptions" => [
      "TrustServerCertificate" => "1"
    ]
    "serverVersion" => "2022"
    "defaultTableOptions" => []
    "dbname" => "KI_Management"
    "Encrypt" => "yes"
    "TrustServerCertificate" => "yes"
    "charset" => "utf8"
  ]
]

"""
\n
            SELECT\n
                (SELECT COUNT(*)\n
                 FROM dbo.Messages\n
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                   AND Role NOT IN ('system')\n
                   AND [TimeStamp] IS NOT NULL\n
                ) AS total_messages,\n
\n
                (SELECT COUNT(*)\n
                 FROM dbo.Sessions\n
                 WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                ) AS total_sessions,\n
\n
                (SELECT ISNULL(SUM(Tokens), 0)\n
                 FROM dbo.Messages\n
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                   AND Role NOT IN ('system')\n
                   AND [TimeStamp] IS NOT NULL\n
                ) AS total_tokens,\n
\n
                (SELECT ISNULL(AVG(CAST(msg_count AS FLOAT)), 0)\n
                 FROM (\n
                     SELECT SessionId, COUNT(*) AS msg_count\n
                     FROM dbo.Messages\n
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                       AND Role NOT IN ('system')\n
                       AND SessionId IS NOT NULL\n
                     GROUP BY SessionId\n
                 ) t\n
                ) AS avg_msgs_per_session,\n
\n
                (SELECT ISNULL(AVG(CAST(tok_sum AS FLOAT)), 0)\n
                 FROM (\n
                     SELECT SessionId, SUM(Tokens) AS tok_sum\n
                     FROM dbo.Messages\n
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                       AND Role NOT IN ('system')\n
                       AND SessionId IS NOT NULL\n
                     GROUP BY SessionId\n
                 ) t\n
                ) AS avg_tokens_per_session\n
        
"""

[
  "sql" => """
    \n
                SELECT\n
                    (SELECT COUNT(*)\n
                     FROM dbo.Messages\n
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                       AND Role NOT IN ('system')\n
                       AND [TimeStamp] IS NOT NULL\n
                    ) AS total_messages,\n
    \n
                    (SELECT COUNT(*)\n
                     FROM dbo.Sessions\n
                     WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                    ) AS total_sessions,\n
    \n
                    (SELECT ISNULL(SUM(Tokens), 0)\n
                     FROM dbo.Messages\n
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                       AND Role NOT IN ('system')\n
                       AND [TimeStamp] IS NOT NULL\n
                    ) AS total_tokens,\n
    \n
                    (SELECT ISNULL(AVG(CAST(msg_count AS FLOAT)), 0)\n
                     FROM (\n
                         SELECT SessionId, COUNT(*) AS msg_count\n
                         FROM dbo.Messages\n
                         WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                           AND Role NOT IN ('system')\n
                           AND SessionId IS NOT NULL\n
                         GROUP BY SessionId\n
                     ) t\n
                    ) AS avg_msgs_per_session,\n
    \n
                    (SELECT ISNULL(AVG(CAST(tok_sum AS FLOAT)), 0)\n
                     FROM (\n
                         SELECT SessionId, SUM(Tokens) AS tok_sum\n
                         FROM dbo.Messages\n
                         WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                           AND Role NOT IN ('system')\n
                           AND SessionId IS NOT NULL\n
                         GROUP BY SessionId\n
                     ) t\n
                    ) AS avg_tokens_per_session\n
            
    """
]

"""
\n
            SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, COUNT(*) AS period_value\n
            FROM dbo.Messages\n
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL\n
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)\n
            ORDER BY period ASC\n
        
"""

[
  "sql" => """
    \n
                SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, COUNT(*) AS period_value\n
                FROM dbo.Messages\n
                WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL\n
                GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)\n
                ORDER BY period ASC\n
            
    """
]

"""
\n
            SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS period, COUNT(*) AS period_value\n
            FROM dbo.Sessions\n
            WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND 1=1\n
            GROUP BY DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1)\n
            ORDER BY period ASC\n
        
"""

[
  "sql" => """
    \n
                SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS period, COUNT(*) AS period_value\n
                FROM dbo.Sessions\n
                WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND 1=1\n
                GROUP BY DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1)\n
                ORDER BY period ASC\n
            
    """
]

"""
\n
            SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, ISNULL(SUM(Tokens), 0) AS period_value\n
            FROM dbo.Messages\n
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL\n
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)\n
            ORDER BY period ASC\n
        
"""

[
  "sql" => """
    \n
                SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, ISNULL(SUM(Tokens), 0) AS period_value\n
                FROM dbo.Messages\n
                WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL\n
                GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)\n
                ORDER BY period ASC\n
            
    """
]

"""
\n
            SELECT DATEPART(HOUR, [TimeStamp]) AS hour_of_day, COUNT(*) AS msg_count\n
            FROM dbo.Messages\n
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
              AND Role NOT IN ('system')\n
              AND [TimeStamp] IS NOT NULL\n
            GROUP BY DATEPART(HOUR, [TimeStamp])\n
            ORDER BY hour_of_day ASC\n
        
"""

[
  "sql" => """
    \n
                SELECT DATEPART(HOUR, [TimeStamp]) AS hour_of_day, COUNT(*) AS msg_count\n
                FROM dbo.Messages\n
                WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))\n
                  AND Role NOT IN ('system')\n
                  AND [TimeStamp] IS NOT NULL\n
                GROUP BY DATEPART(HOUR, [TimeStamp])\n
                ORDER BY hour_of_day ASC\n
            
    """
]