Symfony Profiler

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

Log Messages

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1513
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:208 {
        Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
        › 
        ›     @trigger_error($message, E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:108 {
        › 
        ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
        › }
      }
    }
  }
]

{
  /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:208 {
    Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
    › 
    ›     @trigger_error($message, E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:108 {
    › 
    ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
    › }
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1499
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:208 {
        Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
        › 
        ›     @trigger_error($message, E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:108 {
        › 
        ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
        › }
      }
    }
  }
]

{
  /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:208 {
    Doctrine\Deprecations\Deprecation::delegateTriggerToBackend(string $message, array $backtrace, string $link, string $package): void …
    › 
    ›     @trigger_error($message, E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/doctrine/deprecations/src/Deprecation.php:108 {
    › 
    ›     self::delegateTriggerToBackend($message, $backtrace, $link, $package);
    › }
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1497
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/dependency-injection/Attribute/TaggedIterator.php:38 {
        Symfony\Component\DependencyInjection\Attribute\TaggedIterator->__construct(string $tag, ?string $indexAttribute = null, ?string $defaultIndexMethod = null, ?string $defaultPriorityMethod = null, array|string $exclude = [], bool $excludeSelf = true) …
        › ) {
        ›     trigger_deprecation('symfony/dependency-injection', '7.1', 'The "%s" attribute is deprecated, use "%s" instead.', self::class, AutowireIterator::class);
        › 
      }
      /var/www/dnd/src/Import/ImportDispatcher.php:16 {
        › private JsonFileLoader $loader,
        › #[TaggedIterator('app.dnd_import_handler')]
        › private iterable $handlers,
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/dependency-injection/Attribute/TaggedIterator.php:38 {
    Symfony\Component\DependencyInjection\Attribute\TaggedIterator->__construct(string $tag, ?string $indexAttribute = null, ?string $defaultIndexMethod = null, ?string $defaultPriorityMethod = null, array|string $exclude = [], bool $excludeSelf = true) …
    › ) {
    ›     trigger_deprecation('symfony/dependency-injection', '7.1', 'The "%s" attribute is deprecated, use "%s" instead.', self::class, AutowireIterator::class);
    › 
  }
  /var/www/dnd/src/Import/ImportDispatcher.php:16 {
    › private JsonFileLoader $loader,
    › #[TaggedIterator('app.dnd_import_handler')]
    › private iterable $handlers,
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1498
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1496
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1495
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1509
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1510
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1511
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1512
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

[
  "exception" => Symfony\Component\ErrorHandler\Exception\SilencedErrorContext {#1547
    +count: 1
    -severity: E_USER_DEPRECATED
    trace: {
      /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
        trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
        › {
        ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
        › }
      }
      /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
        › } else {
        ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
        ›     $result .= $nextChar;
      }
    }
  }
]

{
  /var/www/dnd/vendor/symfony/deprecation-contracts/function.php:25 {
    trigger_deprecation(string $package, string $version, string $message, mixed ...$args): void …
    › {
    ›     @trigger_error(($package || $version ? "Since $package $version: " : '').($args ? vsprintf($message, $args) : $message), \E_USER_DEPRECATED);
    › }
  }
  /var/www/dnd/vendor/twig/twig/src/Lexer.php:431 {
    › } else {
    ›     trigger_deprecation('twig/twig', '3.12', 'Character "%s" should not be escaped; the "\" character is ignored in Twig 3 but will not be in Twig 4. Please remove the extra "\" character at position %d in "%s" at line %d.', $nextChar, $i + 1, $this->source->getName(), $this->lineno);
    ›     $result .= $nextChar;
  }
}

"app_compendium_show"

[
  "route" => "app_compendium_show"
  "route_parameters" => [
    "_route" => "app_compendium_show"
    "_controller" => "App\Controller\Compendium\CompendiumController::show"
    "family" => "spells"
    "slug" => "create-food-and-water"
  ]
  "request_uri" => "https://www.arrowscauldron.com/compendium/spells/create-food-and-water"
  "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"
]

[
  "use_savepoints" => true
  "driver" => "pdo_mysql"
  "idle_connection_ttl" => 600
  "host" => "127.0.0.1"
  "port" => 3306
  "user" => "dnd_user"
  "password" => "<redacted>"
  "driverOptions" => []
  "defaultTableOptions" => []
  "dbname" => "dnd"
  "serverVersion" => "10.11.13-MariaDB"
  "charset" => "utf8mb4"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "dnd_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dnd"
    "serverVersion" => "10.11.13-MariaDB"
    "charset" => "utf8mb4"
  ]
]

"SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1"

[
  1 => "create-food-and-water"
]

[
  1 => Doctrine\DBAL\ParameterType {#889
    +name: "STRING"
  }
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? ORDER BY CASE WHEN d0_.edition = 'one' THEN 0 ELSE 1 END ASC, d0_.source ASC, d0_.id ASC LIMIT 1"
  "params" => [
    1 => "create-food-and-water"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

"SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC"

[
  1 => "create-food-and-water"
]

[
  1 => Doctrine\DBAL\ParameterType {#889
    +name: "STRING"
  }
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.source_key AS source_key_1, d0_.name AS name_2, d0_.slug AS slug_3, d0_.source AS source_4, d0_.page AS page_5, d0_.edition AS edition_6, d0_.level AS level_7, d0_.school AS school_8, d0_.is_ritual AS is_ritual_9, d0_.is_concentration AS is_concentration_10, d0_.range_summary AS range_summary_11, d0_.components_summary AS components_summary_12, d0_.duration_summary AS duration_summary_13, d0_.srd AS srd_14, d0_.basic_rules AS basic_rules_15, d0_.srd52 AS srd52_16, d0_.basic_rules_2024 AS basic_rules_2024_17, d0_.has_fluff AS has_fluff_18, d0_.has_fluff_images AS has_fluff_images_19 FROM dnd_spell d0_ WHERE d0_.slug = ? ORDER BY d0_.source ASC, d0_.page ASC"
  "params" => [
    1 => "create-food-and-water"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

"SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_spell d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1"

[
  1 => "Create Food and Water"
]

[
  1 => Doctrine\DBAL\ParameterType {#889
    +name: "STRING"
  }
]

[
  "sql" => "SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_spell d0_ WHERE LOWER(d0_.name) < LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name DESC LIMIT 1"
  "params" => [
    1 => "Create Food and Water"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

"SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_spell d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1"

[
  1 => "Create Food and Water"
]

[
  1 => Doctrine\DBAL\ParameterType {#889
    +name: "STRING"
  }
]

[
  "sql" => "SELECT MIN(d0_.id) AS sclr_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM dnd_spell d0_ WHERE LOWER(d0_.name) > LOWER(?) GROUP BY d0_.name, d0_.slug ORDER BY d0_.name ASC LIMIT 1"
  "params" => [
    1 => "Create Food and Water"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

"SELECT t0.id AS id_1, t0.number AS number_2, t0.unit AS unit_3, t0.raw_text AS raw_text_4, t0.sort_order AS sort_order_5, t0.spell_id AS spell_id_6 FROM dnd_spell_casting_time t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"

[
  1 => 455
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.number AS number_2, t0.unit AS unit_3, t0.raw_text AS raw_text_4, t0.sort_order AS sort_order_5, t0.spell_id AS spell_id_6 FROM dnd_spell_casting_time t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 455
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.has_verbal AS has_verbal_2, t0.has_somatic AS has_somatic_3, t0.has_material AS has_material_4, t0.material_text AS material_text_5, t0.spell_id AS spell_id_6 FROM dnd_spell_component t0 WHERE t0.spell_id = ? ORDER BY t0.id ASC"

[
  1 => 455
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.has_verbal AS has_verbal_2, t0.has_somatic AS has_somatic_3, t0.has_material AS has_material_4, t0.material_text AS material_text_5, t0.spell_id AS spell_id_6 FROM dnd_spell_component t0 WHERE t0.spell_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 455
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"

[
  1 => 455
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 455
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"

[
  1 => 4619
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.block_type AS block_type_2, t0.source_field AS source_field_3, t0.path AS path_4, t0.sort_order AS sort_order_5, t0.title AS title_6, t0.text_content AS text_content_7, t0.caption AS caption_8, t0.json_payload AS json_payload_9, t0.spell_id AS spell_id_10, t0.parent_id AS parent_id_11 FROM dnd_spell_entry_block t0 WHERE t0.parent_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 4619
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.scaling_type AS scaling_type_2, t0.label AS label_3, t0.level AS level_4, t0.value_text AS value_text_5, t0.sort_order AS sort_order_6, t0.spell_id AS spell_id_7 FROM dnd_spell_scaling t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"

[
  1 => 455
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.scaling_type AS scaling_type_2, t0.label AS label_3, t0.level AS level_4, t0.value_text AS value_text_5, t0.sort_order AS sort_order_6, t0.spell_id AS spell_id_7 FROM dnd_spell_scaling t0 WHERE t0.spell_id = ? ORDER BY t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 455
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]

"SELECT t0.id AS id_1, t0.tag_group AS tag_group_2, t0.tag_value AS tag_value_3, t0.sort_order AS sort_order_4, t0.spell_id AS spell_id_5 FROM dnd_spell_tag t0 WHERE t0.spell_id = ? ORDER BY t0.tag_group ASC, t0.sort_order ASC, t0.id ASC"

[
  1 => 455
]

[
  1 => Doctrine\DBAL\ParameterType {#1018
    +name: "INTEGER"
  }
]

[
  "sql" => "SELECT t0.id AS id_1, t0.tag_group AS tag_group_2, t0.tag_value AS tag_value_3, t0.sort_order AS sort_order_4, t0.spell_id AS spell_id_5 FROM dnd_spell_tag t0 WHERE t0.spell_id = ? ORDER BY t0.tag_group ASC, t0.sort_order ASC, t0.id ASC"
  "params" => [
    1 => 455
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1018
      +name: "INTEGER"
    }
  ]
]