Symfony Profiler

[
  "route" => "dashboard_start"
  "route_parameters" => [
    "_route" => "dashboard_start"
    "_controller" => "App\Controller\Admin\DashboardController::start"
  ]
  "request_uri" => "https://login.ebibliotheken-hessen.de/dashboard/start"
  "method" => "GET"
]

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

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "lizenzmanager2025"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "lizenzmanager2025"
    "serverVersion" => "mariadb-10.4.11"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.library_id AS library_id_5, t0.name AS name_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.created_at AS created_at_9 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "App\Security\UserProvider"
  "username" => "admin"
]

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

[
  "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" => "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_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" => "ContainerEWJgxSi\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

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

[
  "sql" => "SELECT COUNT(*) FROM libraries WHERE active = 1"
]

[
  "sql" => "SELECT COUNT(*) FROM offers WHERE active = 1"
]

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

[
  "sql" => """
    \n
                    SELECT COUNT(*) FROM license_pools \n
                    WHERE active = 1 AND valid_from <= CURDATE() AND valid_until >= CURDATE()\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT COUNT(*) FROM license_grants\n
                    WHERE DATE(granted_at) = ? AND action_type = "license_granted"\n
                
    """
  "params" => [
    1 => "2025-12-08"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT COUNT(*) FROM license_grants\n
                    WHERE DATE_FORMAT(granted_at, "%Y-%m") = ? AND action_type = "license_granted"\n
                
    """
  "params" => [
    1 => "2025-12"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT COUNT(*) FROM license_grants\n
                    WHERE YEAR(granted_at) = ? AND action_type = "license_granted"\n
                
    """
  "params" => [
    1 => "2025"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT lp.*, \n
                           o.name as offer_name, \n
                           o.active as offer_active,\n
                           (SELECT COUNT(DISTINCT id) FROM license_grants \n
                            WHERE pool_id = lp.id AND DATE(granted_at) = ? AND action_type = "license_granted") as total_used_today,\n
                           (SELECT COUNT(DISTINCT id) FROM license_grants \n
                            WHERE pool_id = lp.id AND DATE_FORMAT(granted_at, "%Y-%m") = ? AND action_type = "license_granted") as total_used_month,\n
                           (SELECT COUNT(DISTINCT library_id) FROM license_pool_allocations \n
                            WHERE pool_id = lp.id AND allocation_value > 0) as total_allocated_libraries,\n
                           (lp.valid_from <= ? AND lp.valid_until >= ?) as is_currently_active\n
                    FROM license_pools lp\n
                    JOIN offers o ON lp.offer_id = o.id\n
                    WHERE lp.active = 1\n
                    ORDER BY lp.priority DESC, lp.name ASC\n
                
    """
  "params" => [
    1 => "2025-12-08"
    2 => "2025-12"
    3 => "2025-12-08"
    4 => "2025-12-08"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
  ]
]

[
  "sql" => """
    \n
                    SELECT b.*, \n
                           (SELECT COUNT(DISTINCT pool_id) FROM license_pool_allocations \n
                            WHERE library_id = b.id AND allocation_value > 0) as assigned_pools,\n
                           (SELECT COUNT(DISTINCT id) FROM license_grants \n
                            WHERE library_id = b.id) as total_licenses_used\n
                    FROM libraries b\n
                    WHERE b.active = 1\n
                    ORDER BY b.city, b.name\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT o.*, \n
                           (SELECT COUNT(DISTINCT id) FROM license_pools WHERE offer_id = o.id) as total_pools,\n
                           (SELECT COUNT(DISTINCT id) FROM license_pools \n
                            WHERE offer_id = o.id AND active = 1 \n
                              AND valid_from <= CURDATE() AND valid_until >= CURDATE()) as active_pools,\n
                           (SELECT COUNT(DISTINCT lg.id) FROM license_grants lg\n
                            JOIN license_pools lp ON lg.pool_id = lp.id\n
                            WHERE lp.offer_id = o.id) as total_licenses_granted\n
                    FROM offers o\n
                    WHERE o.active = 1\n
                    ORDER BY o.name\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT \n
                        license_model,\n
                        COUNT(*) as pool_count,\n
                        COUNT(CASE WHEN valid_from <= CURDATE() AND valid_until >= CURDATE() THEN 1 END) as active_count,\n
                        SUM(CASE WHEN license_model = "absolut" THEN total_licenses ELSE 0 END) as total_absolute_licenses\n
                    FROM license_pools \n
                    WHERE active = 1\n
                    GROUP BY license_model\n
                
    """
]

[
  "sql" => """
    \n
                            SELECT la.*, \n
                                   b.name as library_name,\n
                                   o.name as offer_name,\n
                                   lp.name as pool_name,\n
                                   la.attempt_at, la.success, la.action_type, la.license_code,\n
                                   la.error_message, la.ip_address, la.user_agent\n
                            FROM login_attempts la\n
                            JOIN libraries b ON la.library_id = b.id\n
                            LEFT JOIN offers o ON la.offer_id = o.id\n
                            LEFT JOIN license_pools lp ON la.pool_id = lp.id\n
                            WHERE la.attempt_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)\n
                            ORDER BY la.attempt_at DESC\n
                            LIMIT 1000\n
                        
    """
]

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

[
  "sql" => """
    \n
                            SELECT \n
                                b.id as library_id,\n
                                b.name as library_name,\n
                                b.city as city,\n
                                COUNT(DISTINCT CASE WHEN la.action_type = "library_login" THEN la.id END) as total_logins,\n
                                COUNT(DISTINCT CASE WHEN la.action_type = "library_login" AND la.success = 1 THEN la.id END) as successful_logins,\n
                                COUNT(DISTINCT CASE WHEN la.action_type = "license_granted" THEN la.id END) as licenses_granted,\n
                                COUNT(DISTINCT CASE WHEN la.action_type = "login" THEN la.id END) as license_logins,\n
                                COUNT(DISTINCT CASE WHEN DATE(la.attempt_at) = CURDATE() THEN la.id END) as activity_today,\n
                                COUNT(DISTINCT CASE WHEN DATE(la.attempt_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) THEN la.id END) as activity_week,\n
                                COUNT(DISTINCT CASE WHEN DATE(la.attempt_at) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) THEN la.id END) as activity_month,\n
                                COUNT(DISTINCT lpa.pool_id) as assigned_pools,\n
                                MAX(la.attempt_at) as last_activity\n
                            FROM libraries b\n
                            LEFT JOIN login_attempts la ON b.id = la.library_id\n
                            LEFT JOIN license_pool_allocations lpa ON b.id = lpa.library_id AND lpa.allocation_value > 0\n
                            WHERE b.active = 1 AND (1=1)\n
                            GROUP BY b.id, b.name, b.city\n
                            ORDER BY activity_month DESC, b.name\n
                        
    """
]

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

[
  "sql" => """
    \n
                            SELECT \n
                                lp.id as pool_id,\n
                                lp.name as pool_name,\n
                                lp.license_model,\n
                                lp.total_licenses,\n
                                lp.valid_from,\n
                                lp.valid_until,\n
                                o.name as offer_name,\n
                                (SELECT COUNT(DISTINCT id) FROM login_attempts \n
                                 WHERE pool_id = lp.id AND action_type = "license_granted") as licenses_granted,\n
                                (SELECT COUNT(DISTINCT id) FROM login_attempts \n
                                 WHERE pool_id = lp.id AND action_type = "login") as license_logins,\n
                                (SELECT COUNT(DISTINCT id) FROM login_attempts \n
                                 WHERE pool_id = lp.id AND DATE(attempt_at) = CURDATE()) as activity_today,\n
                                (SELECT COUNT(DISTINCT id) FROM login_attempts \n
                                 WHERE pool_id = lp.id AND DATE(attempt_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)) as activity_week,\n
                                (SELECT COUNT(DISTINCT id) FROM login_attempts \n
                                 WHERE pool_id = lp.id AND DATE(attempt_at) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)) as activity_month,\n
                                (SELECT COUNT(DISTINCT library_id) FROM license_pool_allocations \n
                                 WHERE pool_id = lp.id AND allocation_value > 0) as assigned_libraries,\n
                                (SELECT MAX(attempt_at) FROM login_attempts WHERE pool_id = lp.id) as last_activity\n
                            FROM license_pools lp\n
                            JOIN offers o ON lp.offer_id = o.id\n
                            WHERE lp.active = 1 AND (1=1)\n
                            ORDER BY activity_month DESC, lp.name\n
                        
    """
]

[
  "sql" => """
    \n
                            SELECT\n
                                date,\n
                                SUM(library_logins) as library_logins,\n
                                SUM(licenses_granted) as licenses_granted,\n
                                SUM(license_logins) as license_logins,\n
                                SUM(failed_attempts) as failed_attempts,\n
                                SUM(total_activity) as total_activity\n
                            FROM (\n
                                -- Daten aus login_attempts (Bib-Logins, Lizenzvergaben, Fehler)\n
                                SELECT\n
                                    DATE(attempt_at) as date,\n
                                    COUNT(CASE WHEN action_type = "library_login" AND success = 1 THEN 1 END) as library_logins,\n
                                    COUNT(CASE WHEN action_type = "license_granted" THEN 1 END) as licenses_granted,\n
                                    0 as license_logins,\n
                                    COUNT(CASE WHEN success = 0 THEN 1 END) as failed_attempts,\n
                                    COUNT(*) as total_activity\n
                                FROM login_attempts\n
                                WHERE attempt_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)\n
                                GROUP BY DATE(attempt_at)\n
    \n
                                UNION ALL\n
    \n
                                -- Daten aus license_grants (Lizenz-Logins = wiederholte Logins)\n
                                SELECT\n
                                    DATE(granted_at) as date,\n
                                    0 as library_logins,\n
                                    0 as licenses_granted,\n
                                    COUNT(CASE WHEN action_type = "license_login" THEN 1 END) as license_logins,\n
                                    0 as failed_attempts,\n
                                    COUNT(*) as total_activity\n
                                FROM license_grants\n
                                WHERE granted_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)\n
                                GROUP BY DATE(granted_at)\n
                            ) combined\n
                            GROUP BY date\n
                            ORDER BY date ASC\n
                        
    """
]

[
  "sql" => """
    \n
                            SELECT\n
                                month,\n
                                SUM(library_logins) as library_logins,\n
                                SUM(licenses_granted) as licenses_granted,\n
                                SUM(license_logins) as license_logins,\n
                                SUM(total_activity) as total_activity\n
                            FROM (\n
                                -- Daten aus login_attempts\n
                                SELECT\n
                                    DATE_FORMAT(attempt_at, "%Y-%m") as month,\n
                                    COUNT(CASE WHEN action_type = "library_login" AND success = 1 THEN 1 END) as library_logins,\n
                                    COUNT(CASE WHEN action_type = "license_granted" THEN 1 END) as licenses_granted,\n
                                    0 as license_logins,\n
                                    COUNT(*) as total_activity\n
                                FROM login_attempts\n
                                WHERE attempt_at >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH)\n
                                GROUP BY DATE_FORMAT(attempt_at, "%Y-%m")\n
    \n
                                UNION ALL\n
    \n
                                -- Daten aus license_grants (Lizenz-Logins)\n
                                SELECT\n
                                    DATE_FORMAT(granted_at, "%Y-%m") as month,\n
                                    0 as library_logins,\n
                                    0 as licenses_granted,\n
                                    COUNT(CASE WHEN action_type = "license_login" THEN 1 END) as license_logins,\n
                                    COUNT(*) as total_activity\n
                                FROM license_grants\n
                                WHERE granted_at >= DATE_SUB(CURDATE(), INTERVAL 12 MONTH)\n
                                GROUP BY DATE_FORMAT(granted_at, "%Y-%m")\n
                            ) combined\n
                            GROUP BY month\n
                            ORDER BY month ASC\n
                        
    """
]

[
  "sql" => """
    \n
                            SELECT \n
                                b.name as library_name,\n
                                COUNT(*) as total_activity,\n
                                COUNT(CASE WHEN la.action_type = "license_granted" THEN 1 END) as licenses_granted\n
                            FROM login_attempts la\n
                            JOIN libraries b ON la.library_id = b.id\n
                            WHERE la.attempt_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND (1=1)\n
                            GROUP BY b.id, b.name\n
                            ORDER BY total_activity DESC\n
                            LIMIT 10\n
                        
    """
]

[
  "sql" => """
    \n
                            SELECT \n
                                lp.name as pool_name,\n
                                o.name as offer_name,\n
                                COUNT(*) as total_activity,\n
                                COUNT(CASE WHEN la.action_type = "license_granted" THEN 1 END) as licenses_granted\n
                            FROM login_attempts la\n
                            JOIN license_pools lp ON la.pool_id = lp.id\n
                            JOIN offers o ON lp.offer_id = o.id\n
                            WHERE la.attempt_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND (1=1)\n
                            GROUP BY lp.id, lp.name, o.name\n
                            ORDER BY total_activity DESC\n
                            LIMIT 10\n
                        
    """
]

[
  "sql" => """
    \n
                    SELECT\n
                        lp.id as pool_id,\n
                        lp.name as pool_name,\n
                        lp.distribution_mode,\n
                        lp.valid_from,\n
                        lp.valid_until,\n
                        o.name as offer_name,\n
                        o.auth_method,\n
                        lp.license_model,\n
                        lp.total_licenses,\n
                        lp.licenses_per_day,\n
                        lp.licenses_per_month,\n
                        lp.licenses_per_year,\n
                        lp.license_factor\n
                    FROM license_pools lp\n
                    JOIN offers o ON lp.offer_id = o.id\n
                    WHERE lp.active = 1\n
                    ORDER BY lp.name\n
                
    """
]

[
  "sql" => """
    \n
                        SELECT\n
                            lpa.pool_id,\n
                            lpa.library_id,\n
                            lpa.allocation_value,\n
                            lpa.allocation_type,\n
                            l.name as library_name\n
                        FROM license_pool_allocations lpa\n
                        JOIN libraries l ON lpa.library_id = l.id\n
                        WHERE lpa.allocation_value > 0\n
                        ORDER BY lpa.pool_id\n
                    
    """
]

[
  "sql" => """
    \n
                    SELECT pool_id, COUNT(DISTINCT license_code) as today_granted\n
                    FROM login_attempts\n
                    WHERE action_type = "license_granted" AND success = 1 \n
                      AND DATE(attempt_at) = CURDATE()\n
                    GROUP BY pool_id\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT pool_id, COUNT(DISTINCT license_code) as total_granted\n
                    FROM login_attempts\n
                    WHERE action_type = "license_granted" AND success = 1\n
                    GROUP BY pool_id\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT pool_id, COUNT(DISTINCT license_code) as valid_licenses\n
                    FROM login_attempts\n
                    WHERE action_type = "license_granted" AND success = 1\n
                      AND attempt_at >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)\n
                    GROUP BY pool_id\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT pool_id, library_id, COUNT(*) as used_today\n
                    FROM login_attempts\n
                    WHERE action_type = "license_granted" AND success = 1 AND DATE(attempt_at) = CURDATE()\n
                    GROUP BY pool_id, library_id\n
                
    """
]

[
  "sql" => """
    \n
                    SELECT pool_id, library_id, COUNT(DISTINCT license_code) as total_granted\n
                    FROM login_attempts\n
                    WHERE action_type = "license_granted" AND success = 1\n
                    GROUP BY pool_id, library_id\n
                
    """
]

[
  "sql" => """
    SELECT COUNT(DISTINCT user_identifier) FROM login_attempts\n
                        WHERE action_type = "library_login" AND success = 1 AND DATE(attempt_at) = CURDATE()
    """
]

[
  "sql" => """
    SELECT COUNT(DISTINCT user_identifier) FROM login_attempts\n
                        WHERE action_type = "library_login" AND success = 1 AND YEARWEEK(attempt_at, 1) = YEARWEEK(CURDATE(), 1)
    """
]

[
  "sql" => """
    SELECT COUNT(DISTINCT user_identifier) FROM login_attempts\n
                        WHERE action_type = "library_login" AND success = 1 AND YEAR(attempt_at) = YEAR(CURDATE()) AND MONTH(attempt_at) = MONTH(CURDATE())
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM license_grants\n
                        WHERE action_type = "license_login" AND DATE(granted_at) = CURDATE()
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM login_attempts\n
                        WHERE action_type = "library_login" AND success = 1 AND DATE(attempt_at) = CURDATE()
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM license_grants\n
                        WHERE expires_at > NOW() AND action_type = "license_granted"
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM login_attempts\n
                        WHERE action_type = "license_granted" AND success = 1
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM login_attempts\n
                        WHERE action_type = "license_granted" AND success = 1\n
                        AND YEAR(attempt_at) = YEAR(CURDATE()) AND MONTH(attempt_at) = MONTH(CURDATE())
    """
]

[
  "sql" => """
    SELECT COUNT(*) FROM login_attempts\n
                        WHERE success = 0 AND DATE(attempt_at) = CURDATE()
    """
]

[
  "sql" => """
    SELECT COUNT(DISTINCT user_identifier) FROM login_attempts\n
                        WHERE success = 1 AND DATE(attempt_at) = CURDATE()
    """
]

[
  "sql" => """
    \n
                    SELECT \n
                        la.attempt_at as granted_at,\n
                        lp.name as pool_name,\n
                        l.name as library_name,\n
                        o.name as offer_name,\n
                        o.image_url as offer_image,\n
                        la.license_code,\n
                        la.ip_address\n
                    FROM login_attempts la\n
                    JOIN libraries l ON la.library_id = l.id\n
                    LEFT JOIN license_pools lp ON la.pool_id = lp.id\n
                    LEFT JOIN offers o ON la.offer_id = o.id\n
                    WHERE la.action_type = "license_granted" AND la.success = 1 \n
                    ORDER BY la.attempt_at DESC\n
                    LIMIT 10\n
                
    """
]

[
  "sql" => """
    \n
                        SELECT\n
                            lr.*,\n
                            l.name as library_name,\n
                            o.name as offer_name,\n
                            lp.name as pool_name\n
                        FROM license_reminders lr\n
                        JOIN libraries l ON lr.library_id = l.id\n
                        JOIN offers o ON lr.offer_id = o.id\n
                        LEFT JOIN license_pools lp ON lr.pool_id = lp.id\n
                        \n
                        ORDER BY lr.created_at DESC\n
                        LIMIT 10\n
                    
    """
]

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

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "lizenzmanager2025"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT setting_value FROM system_settings WHERE setting_key = ?"
  "params" => [
    1 => "app_name"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

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

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

[
  "key" => "_security_main"
]

[
  "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" => "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" => "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"
]