Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\LoginController::login"
  ]
  "request_uri" => "https://dls.scannerbox.de/"
  "method" => "GET"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::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\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "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" => "App\EventListener\ApiSecurityListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\AuthenticationListener::__invoke"
]

[
  "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\EventListener\WebSecurityListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\ApiLoggingListener::onKernelRequest"
]

[
  "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\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "admin"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "10.11.8-MariaDB"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collate" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "downloadServer"
  ]
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS users (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                username VARCHAR(180) UNIQUE NOT NULL,\n
                password VARCHAR(255) NOT NULL,\n
                role VARCHAR(50) NOT NULL DEFAULT 'user',\n
                is_active BOOLEAN NOT NULL DEFAULT TRUE,\n
                failed_login_attempts INT NOT NULL DEFAULT 0,\n
                last_login DATETIME NULL,\n
                locked_until DATETIME NULL,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n
                INDEX idx_username (username),\n
                INDEX idx_is_active (is_active),\n
                INDEX idx_security (failed_login_attempts, locked_until)\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS s3_configurations (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                name VARCHAR(255) NOT NULL,\n
                endpoint VARCHAR(500) NOT NULL,\n
                bucket_name VARCHAR(255) NOT NULL,\n
                access_key VARCHAR(255) NOT NULL,\n
                secret_key VARCHAR(255) NOT NULL,\n
                is_active BOOLEAN NOT NULL DEFAULT TRUE,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,\n
                INDEX idx_is_active (is_active)\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS v_folders (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                name VARCHAR(255) NOT NULL,\n
                slug VARCHAR(255) NOT NULL,\n
                s3_config_id INT NULL,\n
                s3_path VARCHAR(500) NULL,\n
                parent_id INT NULL,\n
                description TEXT NULL,\n
                is_public BOOLEAN NOT NULL DEFAULT TRUE,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,\n
                UNIQUE KEY unique_slug_parent (slug, parent_id),\n
                INDEX idx_slug (slug),\n
                INDEX idx_parent_id (parent_id),\n
                INDEX idx_s3_config_id (s3_config_id),\n
                FOREIGN KEY (parent_id) REFERENCES v_folders(id) ON DELETE CASCADE,\n
                FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE SET NULL\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS tags (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                v_folder_id INT NOT NULL,\n
                name VARCHAR(255) NOT NULL,\n
                slug VARCHAR(255) NOT NULL,\n
                s3_file_key VARCHAR(1000) NOT NULL,\n
                file_name VARCHAR(500) NOT NULL,\n
                file_size BIGINT NOT NULL DEFAULT 0,\n
                download_token VARCHAR(255) UNIQUE NULL,\n
                description TEXT NULL,\n
                is_public BOOLEAN NOT NULL DEFAULT TRUE,\n
                is_folder BOOLEAN NOT NULL DEFAULT FALSE,\n
                is_stream BOOLEAN NOT NULL DEFAULT FALSE,\n
                download_count INT NOT NULL DEFAULT 0 COMMENT 'Anzahl der Downloads',\n
                last_downloaded_at DATETIME NULL COMMENT 'Zeitstempel des letzten Downloads',\n
                is_api_public BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Ob Tag über API öffentlich verfügbar ist',\n
                api_access_count INT NOT NULL DEFAULT 0 COMMENT 'Anzahl der API-Zugriffe',\n
                last_api_access_at DATETIME NULL COMMENT 'Zeitstempel des letzten API-Zugriffs',\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,\n
                UNIQUE KEY unique_slug_v_folder (slug, v_folder_id),\n
                INDEX idx_v_folder_id (v_folder_id),\n
                INDEX idx_slug (slug),\n
                INDEX idx_download_token (download_token),\n
                INDEX idx_tags_download_stats (download_count DESC, last_downloaded_at DESC),\n
                INDEX idx_tags_api_stats (is_api_public, api_access_count DESC, last_api_access_at DESC),\n
                FOREIGN KEY (v_folder_id) REFERENCES v_folders(id) ON DELETE CASCADE\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS storage_tokens (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                s3_config_id INT NOT NULL,\n
                s3_file_key VARCHAR(1000) NOT NULL,\n
                file_name VARCHAR(500) NOT NULL,\n
                file_size BIGINT NOT NULL DEFAULT 0,\n
                download_token VARCHAR(64) NOT NULL,\n
                s3_path VARCHAR(1000) NULL,\n
                uploaded_by_api_user VARCHAR(255) NULL,\n
                created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                last_accessed TIMESTAMP NULL,\n
                UNIQUE KEY download_token (download_token),\n
                INDEX idx_storage_tokens_s3_config_id (s3_config_id),\n
                INDEX idx_storage_tokens_token (download_token),\n
                INDEX idx_storage_tokens_key (s3_file_key(255)),\n
                INDEX idx_storage_tokens_created (created_at),\n
                FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE CASCADE\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS api_users (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                name VARCHAR(255) NOT NULL,\n
                api_key VARCHAR(255) UNIQUE NOT NULL,\n
                secret_key VARCHAR(255) NOT NULL,\n
                is_active BOOLEAN DEFAULT TRUE,\n
                permissions JSON,\n
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n
                last_used TIMESTAMP NULL,\n
                request_count INT DEFAULT 0,\n
                \n
                INDEX idx_api_key (api_key),\n
                INDEX idx_is_active (is_active),\n
                INDEX idx_created_at (created_at)\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS download_logs (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                tag_id INT NOT NULL,\n
                s3_config_id INT NOT NULL,\n
                s3_file_key VARCHAR(500) NOT NULL,\n
                download_type ENUM('direct', 'api', 'token') NOT NULL,\n
                user_agent TEXT NULL,\n
                ip_address VARCHAR(45) NULL,\n
                file_size BIGINT NULL,\n
                download_duration_ms INT NULL,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                INDEX idx_download_logs_tag_id (tag_id),\n
                INDEX idx_download_logs_created_at (created_at),\n
                INDEX idx_download_logs_type (download_type),\n
                FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE,\n
                FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE CASCADE\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS api_access_logs (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                tag_id INT NULL,\n
                api_user_id INT NULL,\n
                endpoint VARCHAR(255) NOT NULL,\n
                method VARCHAR(10) NOT NULL,\n
                response_code INT NOT NULL,\n
                user_agent TEXT NULL,\n
                ip_address VARCHAR(45) NULL,\n
                request_data JSON NULL,\n
                response_data JSON NULL,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                INDEX idx_api_access_logs_tag_id (tag_id),\n
                INDEX idx_api_access_logs_created_at (created_at),\n
                INDEX idx_api_access_logs_api_user (api_user_id),\n
                INDEX idx_api_access_logs_endpoint (endpoint),\n
                INDEX idx_api_access_logs_method (method),\n
                FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE SET NULL,\n
                FOREIGN KEY (api_user_id) REFERENCES api_users(id) ON DELETE SET NULL\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS general_api_logs (\n
                id INT AUTO_INCREMENT PRIMARY KEY,\n
                api_user_id INT NULL,\n
                endpoint VARCHAR(255) NOT NULL,\n
                method VARCHAR(10) NOT NULL,\n
                action_type ENUM('upload', 'download', 'delete', 'list', 'create', 'update', 'other') NOT NULL DEFAULT 'other',\n
                response_code INT NOT NULL,\n
                user_agent TEXT NULL,\n
                ip_address VARCHAR(45) NULL,\n
                request_data JSON NULL,\n
                response_data JSON NULL,\n
                execution_time_ms INT NULL,\n
                created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                INDEX idx_general_api_logs_api_user (api_user_id),\n
                INDEX idx_general_api_logs_created_at (created_at),\n
                INDEX idx_general_api_logs_endpoint (endpoint),\n
                INDEX idx_general_api_logs_method (method),\n
                INDEX idx_general_api_logs_action_type (action_type),\n
                INDEX idx_general_api_logs_response_code (response_code),\n
                FOREIGN KEY (api_user_id) REFERENCES api_users(id) ON DELETE SET NULL\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS `portal_categories` (\n
                `id` int(11) NOT NULL AUTO_INCREMENT,\n
                `name` varchar(255) NOT NULL,\n
                `slug` varchar(255) NOT NULL,\n
                `description` text DEFAULT NULL,\n
                `image_url` varchar(500) DEFAULT NULL,\n
                `sort_order` int(11) NOT NULL DEFAULT 0,\n
                `is_active` tinyint(1) NOT NULL DEFAULT 1,\n
                `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n
                PRIMARY KEY (`id`),\n
                UNIQUE KEY `slug` (`slug`),\n
                KEY `idx_portal_categories_active` (`is_active`),\n
                KEY `idx_portal_categories_sort` (`sort_order`)\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS `portal_category_tags` (\n
                `id` int(11) NOT NULL AUTO_INCREMENT,\n
                `category_id` int(11) NOT NULL,\n
                `tag_id` int(11) NOT NULL,\n
                `sort_order` int(11) NOT NULL DEFAULT 0,\n
                `custom_name` varchar(255) DEFAULT NULL,\n
                `custom_description` text DEFAULT NULL,\n
                `custom_image_url` varchar(500) DEFAULT NULL,\n
                `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                PRIMARY KEY (`id`),\n
                UNIQUE KEY `category_tag` (`category_id`, `tag_id`),\n
                KEY `idx_portal_category_tags_category` (`category_id`),\n
                KEY `idx_portal_category_tags_tag` (`tag_id`),\n
                KEY `idx_portal_category_tags_sort` (`sort_order`),\n
                CONSTRAINT `fk_portal_category_tags_category` FOREIGN KEY (`category_id`) REFERENCES `portal_categories` (`id`) ON DELETE CASCADE,\n
                CONSTRAINT `fk_portal_category_tags_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS `portal_statistics` (\n
                `id` int(11) NOT NULL AUTO_INCREMENT,\n
                `category_id` int(11) DEFAULT NULL,\n
                `tag_id` int(11) DEFAULT NULL,\n
                `view_count` int(11) NOT NULL DEFAULT 0,\n
                `download_count` int(11) NOT NULL DEFAULT 0,\n
                `last_accessed` timestamp NULL DEFAULT NULL,\n
                `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n
                PRIMARY KEY (`id`),\n
                KEY `idx_portal_stats_category` (`category_id`),\n
                KEY `idx_portal_stats_tag` (`tag_id`),\n
                CONSTRAINT `fk_portal_stats_category` FOREIGN KEY (`category_id`) REFERENCES `portal_categories` (`id`) ON DELETE CASCADE,\n
                CONSTRAINT `fk_portal_stats_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE\n
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
    """
]

[
  "sql" => "SELECT COUNT(*) FROM portal_categories"
]

[
  "sql" => "SELECT COUNT(*) FROM users"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "App\EventListener\ApiLoggingListener::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" => "App\EventListener\SecurityHeadersListener::__invoke"
]

[
  "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\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]