Symfony Profiler

Query Metrics

14 Database Queries
14 Different statements
3.13 ms Query time
0 Invalid entities
0 Managed entities
Queries


CREATE TABLE IF NOT EXISTS users (
            id INT AUTO_INCREMENT PRIMARY KEY,
            username VARCHAR(180) UNIQUE NOT NULL,
            password VARCHAR(255) NOT NULL,
            role VARCHAR(50) NOT NULL DEFAULT 'user',
            is_active BOOLEAN NOT NULL DEFAULT TRUE,
            failed_login_attempts INT NOT NULL DEFAULT 0,
            last_login DATETIME NULL,
            locked_until DATETIME NULL,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            INDEX idx_username (username),
            INDEX idx_is_active (is_active),
            INDEX idx_security (failed_login_attempts, locked_until)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS s3_configurations (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(255) NOT NULL,
            endpoint VARCHAR(500) NOT NULL,
            bucket_name VARCHAR(255) NOT NULL,
            access_key VARCHAR(255) NOT NULL,
            secret_key VARCHAR(255) NOT NULL,
            is_active BOOLEAN NOT NULL DEFAULT TRUE,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,
            INDEX idx_is_active (is_active)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS v_folders (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(255) NOT NULL,
            slug VARCHAR(255) NOT NULL,
            s3_config_id INT NULL,
            s3_path VARCHAR(500) NULL,
            parent_id INT NULL,
            description TEXT NULL,
            is_public BOOLEAN NOT NULL DEFAULT TRUE,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,
            UNIQUE KEY unique_slug_parent (slug, parent_id),
            INDEX idx_slug (slug),
            INDEX idx_parent_id (parent_id),
            INDEX idx_s3_config_id (s3_config_id),
            FOREIGN KEY (parent_id) REFERENCES v_folders(id) ON DELETE CASCADE,
            FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE SET NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS tags (
            id INT AUTO_INCREMENT PRIMARY KEY,
            v_folder_id INT NOT NULL,
            name VARCHAR(255) NOT NULL,
            slug VARCHAR(255) NOT NULL,
            s3_file_key VARCHAR(1000) NOT NULL,
            file_name VARCHAR(500) NOT NULL,
            file_size BIGINT NOT NULL DEFAULT 0,
            download_token VARCHAR(255) UNIQUE NULL,
            description TEXT NULL,
            is_public BOOLEAN NOT NULL DEFAULT TRUE,
            is_folder BOOLEAN NOT NULL DEFAULT FALSE,
            is_stream BOOLEAN NOT NULL DEFAULT FALSE,
            download_count INT NOT NULL DEFAULT 0 COMMENT 'Anzahl der Downloads',
            last_downloaded_at DATETIME NULL COMMENT 'Zeitstempel des letzten Downloads',
            is_api_public BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Ob Tag über API öffentlich verfügbar ist',
            api_access_count INT NOT NULL DEFAULT 0 COMMENT 'Anzahl der API-Zugriffe',
            last_api_access_at DATETIME NULL COMMENT 'Zeitstempel des letzten API-Zugriffs',
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            updated_at DATETIME NULL ON UPDATE CURRENT_TIMESTAMP,
            UNIQUE KEY unique_slug_v_folder (slug, v_folder_id),
            INDEX idx_v_folder_id (v_folder_id),
            INDEX idx_slug (slug),
            INDEX idx_download_token (download_token),
            INDEX idx_tags_download_stats (download_count DESC, last_downloaded_at DESC),
            INDEX idx_tags_api_stats (is_api_public, api_access_count DESC, last_api_access_at DESC),
            FOREIGN KEY (v_folder_id) REFERENCES v_folders(id) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS storage_tokens (
            id INT AUTO_INCREMENT PRIMARY KEY,
            s3_config_id INT NOT NULL,
            s3_file_key VARCHAR(1000) NOT NULL,
            file_name VARCHAR(500) NOT NULL,
            file_size BIGINT NOT NULL DEFAULT 0,
            download_token VARCHAR(64) NOT NULL,
            s3_path VARCHAR(1000) NULL,
            uploaded_by_api_user VARCHAR(255) NULL,
            created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
            last_accessed TIMESTAMP NULL,
            UNIQUE KEY download_token (download_token),
            INDEX idx_storage_tokens_s3_config_id (s3_config_id),
            INDEX idx_storage_tokens_token (download_token),
            INDEX idx_storage_tokens_key (s3_file_key(255)),
            INDEX idx_storage_tokens_created (created_at),
            FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS api_users (
            id INT AUTO_INCREMENT PRIMARY KEY,
            name VARCHAR(255) NOT NULL,
            api_key VARCHAR(255) UNIQUE NOT NULL,
            secret_key VARCHAR(255) NOT NULL,
            is_active BOOLEAN DEFAULT TRUE,
            permissions JSON,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            last_used TIMESTAMP NULL,
            request_count INT DEFAULT 0,
            
            INDEX idx_api_key (api_key),
            INDEX idx_is_active (is_active),
            INDEX idx_created_at (created_at)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS download_logs (
            id INT AUTO_INCREMENT PRIMARY KEY,
            tag_id INT NOT NULL,
            s3_config_id INT NOT NULL,
            s3_file_key VARCHAR(500) NOT NULL,
            download_type ENUM('direct', 'api', 'token') NOT NULL,
            user_agent TEXT NULL,
            ip_address VARCHAR(45) NULL,
            file_size BIGINT NULL,
            download_duration_ms INT NULL,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            INDEX idx_download_logs_tag_id (tag_id),
            INDEX idx_download_logs_created_at (created_at),
            INDEX idx_download_logs_type (download_type),
            FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE CASCADE,
            FOREIGN KEY (s3_config_id) REFERENCES s3_configurations(id) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS api_access_logs (
            id INT AUTO_INCREMENT PRIMARY KEY,
            tag_id INT NULL,
            api_user_id INT NULL,
            endpoint VARCHAR(255) NOT NULL,
            method VARCHAR(10) NOT NULL,
            response_code INT NOT NULL,
            user_agent TEXT NULL,
            ip_address VARCHAR(45) NULL,
            request_data JSON NULL,
            response_data JSON NULL,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            INDEX idx_api_access_logs_tag_id (tag_id),
            INDEX idx_api_access_logs_created_at (created_at),
            INDEX idx_api_access_logs_api_user (api_user_id),
            INDEX idx_api_access_logs_endpoint (endpoint),
            INDEX idx_api_access_logs_method (method),
            FOREIGN KEY (tag_id) REFERENCES tags(id) ON DELETE SET NULL,
            FOREIGN KEY (api_user_id) REFERENCES api_users(id) ON DELETE SET NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS general_api_logs (
            id INT AUTO_INCREMENT PRIMARY KEY,
            api_user_id INT NULL,
            endpoint VARCHAR(255) NOT NULL,
            method VARCHAR(10) NOT NULL,
            action_type ENUM('upload', 'download', 'delete', 'list', 'create', 'update', 'other') NOT NULL DEFAULT 'other',
            response_code INT NOT NULL,
            user_agent TEXT NULL,
            ip_address VARCHAR(45) NULL,
            request_data JSON NULL,
            response_data JSON NULL,
            execution_time_ms INT NULL,
            created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
            INDEX idx_general_api_logs_api_user (api_user_id),
            INDEX idx_general_api_logs_created_at (created_at),
            INDEX idx_general_api_logs_endpoint (endpoint),
            INDEX idx_general_api_logs_method (method),
            INDEX idx_general_api_logs_action_type (action_type),
            INDEX idx_general_api_logs_response_code (response_code),
            FOREIGN KEY (api_user_id) REFERENCES api_users(id) ON DELETE SET NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS `portal_categories` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `name` varchar(255) NOT NULL,
            `slug` varchar(255) NOT NULL,
            `description` text DEFAULT NULL,
            `image_url` varchar(500) DEFAULT NULL,
            `sort_order` int(11) NOT NULL DEFAULT 0,
            `is_active` tinyint(1) NOT NULL DEFAULT 1,
            `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
            `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            PRIMARY KEY (`id`),
            UNIQUE KEY `slug` (`slug`),
            KEY `idx_portal_categories_active` (`is_active`),
            KEY `idx_portal_categories_sort` (`sort_order`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS `portal_category_tags` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `category_id` int(11) NOT NULL,
            `tag_id` int(11) NOT NULL,
            `sort_order` int(11) NOT NULL DEFAULT 0,
            `custom_name` varchar(255) DEFAULT NULL,
            `custom_description` text DEFAULT NULL,
            `custom_image_url` varchar(500) DEFAULT NULL,
            `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (`id`),
            UNIQUE KEY `category_tag` (`category_id`, `tag_id`),
            KEY `idx_portal_category_tags_category` (`category_id`),
            KEY `idx_portal_category_tags_tag` (`tag_id`),
            KEY `idx_portal_category_tags_sort` (`sort_order`),
            CONSTRAINT `fk_portal_category_tags_category` FOREIGN KEY (`category_id`) REFERENCES `portal_categories` (`id`) ON DELETE CASCADE,
            CONSTRAINT `fk_portal_category_tags_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE IF NOT EXISTS `portal_statistics` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `category_id` int(11) DEFAULT NULL,
            `tag_id` int(11) DEFAULT NULL,
            `view_count` int(11) NOT NULL DEFAULT 0,
            `download_count` int(11) NOT NULL DEFAULT 0,
            `last_accessed` timestamp NULL DEFAULT NULL,
            `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY (`id`),
            KEY `idx_portal_stats_category` (`category_id`),
            KEY `idx_portal_stats_tag` (`tag_id`),
            CONSTRAINT `fk_portal_stats_category` FOREIGN KEY (`category_id`) REFERENCES `portal_categories` (`id`) ON DELETE CASCADE,
            CONSTRAINT `fk_portal_stats_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
SELECT COUNT(*) FROM portal_categories
SELECT COUNT(*) FROM users
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
Entities Mapping

No loaded entities.
Symfony Profiler

GET https://138.201.158.22/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
