fix(indexer): speed up startup times avoiding inner joins

Merge pull request #8320 from ethereum-optimism/dependabot/npm_and_yarn/typescript-eslint/parser-6.13.1

build(deps-dev): bump @typescript-eslint/parser from 6.11.0 to 6.13.1

Bumps [@typescript-eslint/parser](https://github.com/typescript-eslint/typescript-eslint/tree/HEAD/packages/parser) from 6.11.0 to 6.13.1.
- [Release notes](https://github.com/typescript-eslint/typescript-eslint/releases)
- [Changelog](https://github.com/typescript-eslint/typescript-eslint/blob/main/packages/parser/CHANGELOG.md)
- [Commits](https://github.com/typescript-eslint/typescript-eslint/commits/v6.13.1/packages/parser)

---
updated-dependencies:
- dependency-name: "@typescript-eslint/parser"
  dependency-type: direct:development
  update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>

build(deps-dev): bump tsx from 4.5.0 to 4.6.0

Bumps [tsx](https://github.com/privatenumber/tsx) from 4.5.0 to 4.6.0.
- [Release notes](https://github.com/privatenumber/tsx/releases)
- [Changelog](https://github.com/privatenumber/tsx/blob/develop/release.config.cjs)
- [Commits](https://github.com/privatenumber/tsx/compare/v4.5.0...v4.6.0)

---
updated-dependencies:
- dependency-name: tsx
  dependency-type: direct:development
  update-type: version-update:semver-minor
...
Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #8328 from ethereum-optimism/dependabot/npm_and_yarn/typescript-eslint/eslint-plugin-6.13.1

build(deps-dev): bump @typescript-eslint/eslint-plugin from 6.13.0 to 6.13.1

Revert #8324 and #8242

This reverts commit c12a946e, reversing
changes made to caa9d27e.

This reverts commit 99cc9a70, reversing
changes made to a68993e1.

Bumps [@typescript-eslint/eslint-plugin](https://github.com/typescript-eslint/typescript-eslint/tree/HEAD/packages/eslint-plugin) from 6.13.0 to 6.13.1.
- [Release notes](https://github.com/typescript-eslint/typescript-eslint/releases)
- [Changelog](https://github.com/typescript-eslint/typescript-eslint/blob/main/packages/eslint-plugin/CHANGELOG.md)
- [Commits](https://github.com/typescript-eslint/typescript-eslint/commits/v6.13.1/packages/eslint-plugin)

---
updated-dependencies:
- dependency-name: "@typescript-eslint/eslint-plugin"
  dependency-type: direct:development
  update-type: version-update:semver-patch
...
Signed-off-by: dependabot[bot] <support@github.com>

ci: Fix multi-client builds

build(deps-dev): bump typedoc from 0.25.3 to 0.25.4

build(deps): bump golang.org/x/crypto from 0.15.0 to 0.16.0

Portal reads pause status from SuperchainConfig

op-proposer: Fix err check location in test

ci: use base_image constant

Rename span batch hard fork to delta hard fork

ctb: Fix data race in generate-l2-genesis

Previously the ubuntu base image used for the `machine` field in
ci was hardcoded. It was not standardized and sometimes different.
Updating it would require a multiline diff and was prone to missing
a spot. This commit updates the value to be a param that is used
across all of the places instead of the value being inlined.
This removes a decision to be made when adding a new job and also
allows for a 1 line diff when updating the version of the image used.

feat(ctb): StateDiff JSON Generation

Bumps [typedoc](https://github.com/TypeStrong/TypeDoc) from 0.25.3 to 0.25.4.
- [Release notes](https://github.com/TypeStrong/TypeDoc/releases)
- [Changelog](https://github.com/TypeStrong/typedoc/blob/master/CHANGELOG.md)
- [Commits](https://github.com/TypeStrong/TypeDoc/compare/v0.25.3...v0.25.4)

---
updated-dependencies:
- dependency-name: typedoc
  dependency-type: direct:development
  update-type: version-update:semver-patch
...
Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #8315 from ethereum-optimism/dependabot/go_modules/github.com/btcsuite/btcd/chaincfg/chainhash-1.0.3

build(deps): bump github.com/btcsuite/btcd/chaincfg/chainhash from 1.0.1 to 1.0.3