Query Execution using applicable_bans

sql> EXPLAIN PLAN FOR select "libertybans_applicable_bans"."id", "libertybans_applicable_bans"."victim_type", "libertybans_applicable_bans"."victim_uuid", "libertybans_applicable_bans"."victim_address", "libertybans_applicable_bans"."operator", "libertybans_applicable_bans"."reason", "libertybans_applicable_bans"."scope", "libertybans_applicable_bans"."start", "libertybans_applicable_bans"."end" from "libertybans_applicable_bans" where ("libertybans_applicable_bans"."type" = 0 and "libertybans_applicable_bans"."uuid" = '98e90094-d8c8-4149-a3fd-ff39b83f98c1' and ("libertybans_applicable_bans"."end" = 0 or "libertybans_applicable_bans"."end" > 1621440000)) limit 1;
isDistinctSelect=[false]
isGrouped=[false]
isAggregated=[false]
columns=[  COLUMN: PUBLIC."libertybans_applicable_bans"."id" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."victim_type" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."victim_uuid" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."victim_address" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."operator" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."reason" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."scope" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."start" nullable
  COLUMN: PUBLIC."libertybans_applicable_bans"."end" nullable

]
[range variable 1
  join type=INNER
  table=libertybans_applicable_bans
  cardinality=0
  access=INDEX PRED
  join condition = [index=SYS_IDX_T_10314
    start conditions=[
    EQUAL arg_left=[     COLUMN: PUBLIC."libertybans_applicable_bans"."type"
] arg_right=[
     VALUE = 0, TYPE = INTEGER]
    EQUAL arg_left=[     COLUMN: PUBLIC."libertybans_applicable_bans"."uuid"
] arg_right=[
     VALUE = 98e90094-d8c8-4149-a3fd-ff39b83f98c1, TYPE = UUID]]
    other condition=[
    OR arg_left=[
     EQUAL arg_left=[      COLUMN: PUBLIC."libertybans_applicable_bans"."end"
] arg_right=[
      VALUE = 0, TYPE = INTEGER]] arg_right=[
     GREATER arg_left=[      COLUMN: PUBLIC."libertybans_applicable_bans"."end"
] arg_right=[
      VALUE = 1621440000, TYPE = INTEGER]]]
  ]
  ]]
offset=[
VALUE = 0, TYPE = INTEGER]
limit=[
VALUE = 1, TYPE = INTEGER]
PARAMETERS=[]
SUBQUERIES[
[level=1
  isDistinctSelect=[false]
  isGrouped=[false]
  isAggregated=[false]
  columns=[    COLUMN: PUBLIC."libertybans_punishments"."id" not nullable
    COLUMN: PUBLIC."libertybans_punishments"."type" not nullable
    COLUMN: PUBLIC."libertybans_victims"."type" AS victim_type not nullable
    COLUMN: PUBLIC."libertybans_victims"."uuid" AS victim_uuid not nullable
    COLUMN: PUBLIC."libertybans_victims"."address" AS victim_address not nullable
    COLUMN: PUBLIC."libertybans_punishments"."operator" not nullable
    COLUMN: PUBLIC."libertybans_punishments"."reason" not nullable
    COLUMN: PUBLIC."libertybans_punishments"."scope" not nullable
    COLUMN: PUBLIC."libertybans_punishments"."start" not nullable
    COLUMN: PUBLIC."libertybans_punishments"."end" not nullable

  ]
  [range variable 1
    join type=INNER
    table=libertybans_bans
    alias=thetype
    cardinality=17
    access=FULL SCAN
    join condition = [index=SYS_IDX_10165
    ]
      ]  [range variable 2
    join type=INNER
    table=libertybans_punishments
    alias=puns
    cardinality=254
    access=INDEX PRED
    join condition = [index=libertybans_punishment_id_uniqueness
      start conditions=[
      EQUAL arg_left=[       COLUMN: PUBLIC."libertybans_punishments"."id"
] arg_right=[       COLUMN: PUBLIC."libertybans_bans"."id"
]]
      other condition=[
      AND arg_left=[
       EQUAL arg_left=[        COLUMN: PUBLIC."libertybans_punishments"."type"
] arg_right=[
        VALUE = 0, TYPE = INTEGER]] arg_right=[
       OR arg_left=[
        EQUAL arg_left=[         COLUMN: PUBLIC."libertybans_punishments"."end"
] arg_right=[
         VALUE = 0, TYPE = INTEGER]] arg_right=[
        GREATER arg_left=[         COLUMN: PUBLIC."libertybans_punishments"."end"
] arg_right=[
         VALUE = 1621440000, TYPE = INTEGER]]]]
    ]
      ]  [range variable 3
    join type=INNER
    table=libertybans_victims
    alias=victims
    cardinality=100
    access=INDEX PRED
    join condition = [index=libertybans_victim_id_uniqueness
      start conditions=[
      EQUAL arg_left=[       COLUMN: PUBLIC."libertybans_victims"."id"
] arg_right=[       COLUMN: PUBLIC."libertybans_bans"."victim"
]]
    ]
      ]  ]
]
[level=1
  isDistinctSelect=[false]
  isGrouped=[false]
  isAggregated=[false]
  columns=[    COLUMN: PUBLIC."libertybans_simple_bans"."id" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."type" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."victim_type" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."victim_address" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."operator" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."reason" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."scope" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."start" nullable
    COLUMN: PUBLIC."libertybans_simple_bans"."end" nullable
    COLUMN: PUBLIC."libertybans_addresses"."uuid" not nullable
    COLUMN: PUBLIC."libertybans_addresses"."address" not nullable

  ]
  [range variable 1
    join type=INNER
    table=libertybans_addresses
    alias=addrs
    cardinality=8959
    access=INDEX PRED
    join condition = [index=libertybans_uuid_address_uniqueness
      start conditions=[
      EQUAL arg_left=[       COLUMN: PUBLIC."libertybans_addresses"."uuid"
] arg_right=[
       VALUE = 98e90094-d8c8-4149-a3fd-ff39b83f98c1, TYPE = UUID]]
    ]
      ]  [range variable 2
    join type=INNER
    table=libertybans_simple_bans
    alias=puns
    cardinality=0
    access=INDEX PRED
    join condition = [index=SYS_IDX_T_10315
      start conditions=[
      EQUAL arg_left=[       COLUMN: PUBLIC."libertybans_simple_bans"."type"
] arg_right=[
       VALUE = 0, TYPE = INTEGER]]
      other condition=[
      AND arg_left=[
       OR arg_left=[
        EQUAL arg_left=[         COLUMN: PUBLIC."libertybans_simple_bans"."end"
] arg_right=[
         VALUE = 0, TYPE = INTEGER]] arg_right=[
        GREATER arg_left=[         COLUMN: PUBLIC."libertybans_simple_bans"."end"
] arg_right=[
         VALUE = 1621440000, TYPE = INTEGER]]] arg_right=[
       OR arg_left=[
        OR arg_left=[
         AND arg_left=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
] arg_right=[
           VALUE = 0, TYPE = INTEGER]] arg_right=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid"
] arg_right=[           COLUMN: PUBLIC."libertybans_addresses"."uuid"
]]] arg_right=[
         AND arg_left=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
] arg_right=[
           VALUE = 1, TYPE = INTEGER]] arg_right=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_address"
] arg_right=[           COLUMN: PUBLIC."libertybans_addresses"."address"
]]]] arg_right=[
        AND arg_left=[
         EQUAL arg_left=[          COLUMN: PUBLIC."libertybans_simple_bans"."victim_type"
] arg_right=[
          VALUE = 2, TYPE = INTEGER]] arg_right=[
         OR arg_left=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_uuid"
] arg_right=[           COLUMN: PUBLIC."libertybans_addresses"."uuid"
]] arg_right=[
          EQUAL arg_left=[           COLUMN: PUBLIC."libertybans_simple_bans"."victim_address"
] arg_right=[           COLUMN: PUBLIC."libertybans_addresses"."address"
]]]]]]
    ]
      ]  ]
]]

Fetched 185 rows.