Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.is_primary AS is_primary_3,
  t0.verified_at AS verified_at_4,
  t0.tenant_id AS tenant_id_5
FROM
  tenant_domain t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_primary AS is_primary_3, t0.verified_at AS verified_at_4, t0.tenant_id AS tenant_id_5 FROM tenant_domain t0 WHERE t0.domain = 'dev.cat.greensign.de' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.logo_url AS logo_url_4,
  t0.favicon_url AS favicon_url_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.tertiary_color AS tertiary_color_8,
  t0.email_from_address AS email_from_address_9,
  t0.email_from_name AS email_from_name_10,
  t0.email_notificationddress AS email_notificationddress_11,
  t0.features AS features_12,
  t0.gsid_prefix AS gsid_prefix_13,
  t0.is_active AS is_active_14,
  t0.created_at AS created_at_15
FROM
  tenant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_url AS logo_url_4, t0.favicon_url AS favicon_url_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.tertiary_color AS tertiary_color_8, t0.email_from_address AS email_from_address_9, t0.email_from_name AS email_from_name_10, t0.email_notificationddress AS email_notificationddress_11, t0.features AS features_12, t0.gsid_prefix AS gsid_prefix_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15 FROM tenant t0 WHERE t0.id = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO request (
  request_path, request_time, request_payload,
  request_result, request_success,
  api_version, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO request (request_path, request_time, request_payload, request_result, request_success, api_version, user_id) VALUES ('GET /api/v3/certifications?lang=en&mine=1&withDetails=1', '2026-08-21 16:30:03', NULL, '{
    \"error\": {
        \"code\": \"INTERNAL_SERVER_ERROR\",
        \"message\": \"Access Denied. The user doesn\\u0027t have ROLE_API_USER.\",
        \"exception\": \"Symfony\\\\Component\\\\Security\\\\Core\\\\Exception\\\\AccessDeniedException\",
        \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/security-http\\/Firewall\\/AccessListener.php\",
        \"line\": 79,
        \"trace\": [
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/security-http\\/Firewall\\/AccessListener.php\",
                \"line\": 79,
                \"class\": null,
                \"type\": null,
                \"function\": null
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/security-bundle\\/Debug\\/WrappedLazyListener.php\",
                \"line\": 46,
                \"class\": \"Symfony\\\\Component\\\\Security\\\\Http\\\\Firewall\\\\AccessListener\",
                \"type\": \"-\\u003E\",
                \"function\": \"authenticate\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/security-bundle\\/Debug\\/TraceableFirewallListener.php\",
                \"line\": 94,
                \"class\": \"Symfony\\\\Bundle\\\\SecurityBundle\\\\Debug\\\\WrappedLazyListener\",
                \"type\": \"-\\u003E\",
                \"function\": \"authenticate\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/security-http\\/Firewall.php\",
                \"line\": 93,
                \"class\": \"Symfony\\\\Bundle\\\\SecurityBundle\\\\Debug\\\\TraceableFirewallListener\",
                \"type\": \"-\\u003E\",
                \"function\": \"callListeners\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/event-dispatcher\\/Debug\\/WrappedListener.php\",
                \"line\": 115,
                \"class\": \"Symfony\\\\Component\\\\Security\\\\Http\\\\Firewall\",
                \"type\": \"-\\u003E\",
                \"function\": \"onKernelRequest\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/event-dispatcher\\/EventDispatcher.php\",
                \"line\": 206,
                \"class\": \"Symfony\\\\Component\\\\EventDispatcher\\\\Debug\\\\WrappedListener\",
                \"type\": \"-\\u003E\",
                \"function\": \"__invoke\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/event-dispatcher\\/EventDispatcher.php\",
                \"line\": 56,
                \"class\": \"Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher\",
                \"type\": \"-\\u003E\",
                \"function\": \"callListeners\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/event-dispatcher\\/Debug\\/TraceableEventDispatcher.php\",
                \"line\": 129,
                \"class\": \"Symfony\\\\Component\\\\EventDispatcher\\\\EventDispatcher\",
                \"type\": \"-\\u003E\",
                \"function\": \"dispatch\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",
                \"line\": 159,
                \"class\": \"Symfony\\\\Component\\\\EventDispatcher\\\\Debug\\\\TraceableEventDispatcher\",
                \"type\": \"-\\u003E\",
                \"function\": \"dispatch\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/http-kernel\\/HttpKernel.php\",
                \"line\": 76,
                \"class\": \"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",
                \"type\": \"-\\u003E\",
                \"function\": \"handleRaw\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/http-kernel\\/Kernel.php\",
                \"line\": 193,
                \"class\": \"Symfony\\\\Component\\\\HttpKernel\\\\HttpKernel\",
                \"type\": \"-\\u003E\",
                \"function\": \"handle\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/symfony\\/runtime\\/Runner\\/Symfony\\/HttpKernelRunner.php\",
                \"line\": 34,
                \"class\": \"Symfony\\\\Component\\\\HttpKernel\\\\Kernel\",
                \"type\": \"-\\u003E\",
                \"function\": \"handle\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/vendor\\/autoload_runtime.php\",
                \"line\": 32,
                \"class\": \"Symfony\\\\Component\\\\Runtime\\\\Runner\\\\Symfony\\\\HttpKernelRunner\",
                \"type\": \"-\\u003E\",
                \"function\": \"run\"
            },
            {
                \"file\": \"\\/var\\/www\\/vhosts\\/cat.greensign.de\\/dev.cat.greensign.de\\/public\\/index.php\",
                \"line\": 5,
                \"class\": null,
                \"type\": null,
                \"function\": \"require_once\"
            }
        ]
    }
}', 0, 'v3', NULL);

"COMMIT"

"COMMIT";