class io.ebeaninternal.server.query.CQueryBuilder$BuildReq
  minor version: 0
  major version: 59
  flags: flags: (0x0020) ACC_SUPER
  this_class: io.ebeaninternal.server.query.CQueryBuilder$BuildReq
  super_class: java.lang.Object
{
  private final java.lang.StringBuilder sb;
    descriptor: Ljava/lang/StringBuilder;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final java.lang.String selectClause;
    descriptor: Ljava/lang/String;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final io.ebeaninternal.server.core.OrmQueryRequest<?> request;
    descriptor: Lio/ebeaninternal/server/core/OrmQueryRequest;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL
    Signature: Lio/ebeaninternal/server/core/OrmQueryRequest<*>;

  private final io.ebeaninternal.api.SpiQuery<?> query;
    descriptor: Lio/ebeaninternal/api/SpiQuery;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL
    Signature: Lio/ebeaninternal/api/SpiQuery<*>;

  private final io.ebeaninternal.server.query.CQueryPredicates predicates;
    descriptor: Lio/ebeaninternal/server/query/CQueryPredicates;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final io.ebeaninternal.server.query.SqlTree select;
    descriptor: Lio/ebeaninternal/server/query/SqlTree;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final boolean updateStatement;
    descriptor: Z
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final boolean distinct;
    descriptor: Z
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final java.lang.String dbOrderBy;
    descriptor: Ljava/lang/String;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private boolean useSqlLimiter;
    descriptor: Z
    flags: (0x0002) ACC_PRIVATE

  private boolean hasWhere;
    descriptor: Z
    flags: (0x0002) ACC_PRIVATE

  final io.ebeaninternal.server.query.CQueryBuilder this$0;
    descriptor: Lio/ebeaninternal/server/query/CQueryBuilder;
    flags: (0x1010) ACC_FINAL, ACC_SYNTHETIC

  private static volatile int[] $SWITCH_TABLE$io$ebean$CountDistinctOrder;
    descriptor: [I
    flags: (0x104a) ACC_PRIVATE, ACC_STATIC, ACC_VOLATILE, ACC_SYNTHETIC

  private void <init>(java.lang.String, io.ebeaninternal.server.core.OrmQueryRequest<?>, io.ebeaninternal.server.query.CQueryPredicates, io.ebeaninternal.server.query.SqlTree);
    descriptor: (Lio/ebeaninternal/server/query/CQueryBuilder;Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/query/SqlTree;)V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=7, locals=6, args_size=6
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
        start local 2 // java.lang.String selectClause
        start local 3 // io.ebeaninternal.server.core.OrmQueryRequest request
        start local 4 // io.ebeaninternal.server.query.CQueryPredicates predicates
        start local 5 // io.ebeaninternal.server.query.SqlTree select
         0: .line 581
            aload 0 /* this */
            aload 1
            aload 2 /* selectClause */
            aload 3 /* request */
            aload 4 /* predicates */
            aload 5 /* select */
            iconst_0
            invokespecial io.ebeaninternal.server.query.CQueryBuilder$BuildReq.<init>:(Lio/ebeaninternal/server/query/CQueryBuilder;Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/query/SqlTree;Z)V
         1: .line 582
            return
        end local 5 // io.ebeaninternal.server.query.SqlTree select
        end local 4 // io.ebeaninternal.server.query.CQueryPredicates predicates
        end local 3 // io.ebeaninternal.server.core.OrmQueryRequest request
        end local 2 // java.lang.String selectClause
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot          Name  Signature
            0    2     0          this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            0    2     2  selectClause  Ljava/lang/String;
            0    2     3       request  Lio/ebeaninternal/server/core/OrmQueryRequest<*>;
            0    2     4    predicates  Lio/ebeaninternal/server/query/CQueryPredicates;
            0    2     5        select  Lio/ebeaninternal/server/query/SqlTree;
    Signature: (Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest<*>;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/query/SqlTree;)V
    MethodParameters:
              Name  Flags
      this$0        final
      selectClause  
      request       
      predicates    
      select        

  private void <init>(java.lang.String, io.ebeaninternal.server.core.OrmQueryRequest<?>, io.ebeaninternal.server.query.CQueryPredicates, io.ebeaninternal.server.query.SqlTree, );
    descriptor: (Lio/ebeaninternal/server/query/CQueryBuilder;Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/query/SqlTree;Z)V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=4, locals=7, args_size=7
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
        start local 2 // java.lang.String selectClause
        start local 3 // io.ebeaninternal.server.core.OrmQueryRequest request
        start local 4 // io.ebeaninternal.server.query.CQueryPredicates predicates
        start local 5 // io.ebeaninternal.server.query.SqlTree select
        start local 6 // boolean updateStatement
         0: .line 584
            aload 0 /* this */
            aload 1
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 567
            aload 0 /* this */
            new java.lang.StringBuilder
            dup
            sipush 500
            invokespecial java.lang.StringBuilder.<init>:(I)V
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
         2: .line 585
            aload 0 /* this */
            aload 2 /* selectClause */
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.selectClause:Ljava/lang/String;
         3: .line 586
            aload 0 /* this */
            aload 3 /* request */
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
         4: .line 587
            aload 0 /* this */
            aload 3 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getQuery:()Lio/ebeaninternal/api/SpiQuery;
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
         5: .line 588
            aload 0 /* this */
            aload 4 /* predicates */
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.predicates:Lio/ebeaninternal/server/query/CQueryPredicates;
         6: .line 589
            aload 0 /* this */
            aload 5 /* select */
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
         7: .line 590
            aload 0 /* this */
            iload 6 /* updateStatement */
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.updateStatement:Z
         8: .line 591
            aload 0 /* this */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isDistinct:()Z
            ifne 9
            aload 5 /* select */
            invokevirtual io.ebeaninternal.server.query.SqlTree.isSqlDistinct:()Z
            ifne 9
            iconst_0
            goto 10
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilder$BuildReq io.ebeaninternal.server.query.CQueryBuilder java.lang.String io.ebeaninternal.server.core.OrmQueryRequest io.ebeaninternal.server.query.CQueryPredicates io.ebeaninternal.server.query.SqlTree int
      StackMap stack: io.ebeaninternal.server.query.CQueryBuilder$BuildReq
         9: iconst_1
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilder$BuildReq io.ebeaninternal.server.query.CQueryBuilder java.lang.String io.ebeaninternal.server.core.OrmQueryRequest io.ebeaninternal.server.query.CQueryPredicates io.ebeaninternal.server.query.SqlTree int
      StackMap stack: io.ebeaninternal.server.query.CQueryBuilder$BuildReq int
        10: putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.distinct:Z
        11: .line 592
            aload 0 /* this */
            aload 4 /* predicates */
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbOrderBy:()Ljava/lang/String;
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
        12: .line 593
            return
        end local 6 // boolean updateStatement
        end local 5 // io.ebeaninternal.server.query.SqlTree select
        end local 4 // io.ebeaninternal.server.query.CQueryPredicates predicates
        end local 3 // io.ebeaninternal.server.core.OrmQueryRequest request
        end local 2 // java.lang.String selectClause
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot             Name  Signature
            0   13     0             this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            0   13     2     selectClause  Ljava/lang/String;
            0   13     3          request  Lio/ebeaninternal/server/core/OrmQueryRequest<*>;
            0   13     4       predicates  Lio/ebeaninternal/server/query/CQueryPredicates;
            0   13     5           select  Lio/ebeaninternal/server/query/SqlTree;
            0   13     6  updateStatement  Z
    Signature: (Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest<*>;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/query/SqlTree;Z)V
    MethodParameters:
                 Name  Flags
      this$0           final
      selectClause     
      request          
      predicates       
      select           
      updateStatement  

  private void appendSelect();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=2, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 596
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.selectClause:Ljava/lang/String;
            ifnull 3
         1: .line 597
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.selectClause:Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 599
            goto 18
         3: .line 600
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.hasMaxRowsOrFirstRow:()Z
            ifeq 4
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getManyProperty:()Lio/ebeaninternal/server/query/STreePropertyAssocMany;
            ifnonnull 4
            iconst_1
            goto 5
      StackMap locals:
      StackMap stack: io.ebeaninternal.server.query.CQueryBuilder$BuildReq
         4: iconst_0
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilder$BuildReq
      StackMap stack: io.ebeaninternal.server.query.CQueryBuilder$BuildReq int
         5: putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.useSqlLimiter:Z
         6: .line 601
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.useSqlLimiter:Z
            ifne 8
         7: .line 602
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendSelectDistinct:()V
         8: .line 604
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isCountDistinct:()Z
            ifeq 11
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isSingleAttribute:()Z
            ifeq 11
         9: .line 605
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc "r1.attribute_, count(*) from (select "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getSelectSql:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            ldc " as attribute_"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        10: .line 606
            goto 12
        11: .line 607
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getSelectSql:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        12: .line 609
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.isInlineCountDistinct:()Z
            ifeq 14
        13: .line 610
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc ")"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        14: .line 612
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.distinct:Z
            ifeq 18
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
            ifnull 18
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isSingleAttribute:()Z
            ifne 18
        15: .line 614
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getOrderBy:()Lio/ebean/OrderBy;
            astore 1 /* orderBy */
        start local 1 // io.ebean.OrderBy orderBy
        16: .line 615
            aload 1 /* orderBy */
            ifnull 18
            aload 1 /* orderBy */
            invokevirtual io.ebean.OrderBy.supportsSelect:()Z
            ifeq 18
        17: .line 616
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc ", "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
            invokestatic io.ebeaninternal.server.query.DbOrderByTrim.trim:(Ljava/lang/String;)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        end local 1 // io.ebean.OrderBy orderBy
        18: .line 620
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot     Name  Signature
            0   19     0     this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
           16   18     1  orderBy  Lio/ebean/OrderBy<*>;

  private void appendSelectDistinct();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=2, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 623
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc "select "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         1: .line 624
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.distinct:Z
            ifeq 8
         2: .line 625
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.isInlineCountDistinct:()Z
            ifeq 4
         3: .line 626
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc "count("
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         4: .line 628
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc "distinct "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         5: .line 629
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getDistinctOn:()Ljava/lang/String;
            astore 1 /* distinctOn */
        start local 1 // java.lang.String distinctOn
         6: .line 630
            aload 1 /* distinctOn */
            ifnull 8
         7: .line 631
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc "on ("
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 1 /* distinctOn */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            ldc ") "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        end local 1 // java.lang.String distinctOn
         8: .line 634
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot        Name  Signature
            0    9     0        this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            6    8     1  distinctOn  Ljava/lang/String;

  private void appendFrom();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=1, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 637
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.selectClause:Ljava/lang/String;
            ifnull 1
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.selectClause:Ljava/lang/String;
            ldc "update"
            invokevirtual java.lang.String.startsWith:(Ljava/lang/String;)Z
            ifne 3
         1: .line 638
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " from "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 639
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getFromSql:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 641
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    4     0  this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;

  private void appendAndOrWhere();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=1, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 644
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasWhere:Z
            ifeq 3
         1: .line 645
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " and "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 646
            goto 5
         3: .line 647
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " where "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         4: .line 648
            aload 0 /* this */
            iconst_1
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasWhere:Z
         5: .line 650
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    6     0  this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;

  private void appendInheritanceWhere();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=2, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 653
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getInheritanceWhereSql:()Ljava/lang/String;
            astore 1 /* inheritanceWhere */
        start local 1 // java.lang.String inheritanceWhere
         1: .line 654
            aload 1 /* inheritanceWhere */
            invokevirtual java.lang.String.isEmpty:()Z
            ifne 5
         2: .line 655
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " where"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 656
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 1 /* inheritanceWhere */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         4: .line 657
            aload 0 /* this */
            iconst_1
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasWhere:Z
         5: .line 659
      StackMap locals: java.lang.String
      StackMap stack:
            return
        end local 1 // java.lang.String inheritanceWhere
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot              Name  Signature
            0    6     0              this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            1    6     1  inheritanceWhere  Ljava/lang/String;

  private void appendHistoryAsOfPredicate();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=3, locals=1, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 662
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isAsOfBaseTable:()Z
            ifeq 3
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            getfield io.ebeaninternal.server.query.CQueryBuilder.historySupport:Lio/ebeaninternal/server/query/CQueryHistorySupport;
            invokevirtual io.ebeaninternal.server.query.CQueryHistorySupport.isStandardsBased:()Z
            ifne 3
         1: .line 663
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendAndOrWhere:()V
         2: .line 664
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            getfield io.ebeaninternal.server.query.CQueryBuilder.historySupport:Lio/ebeaninternal/server/query/CQueryHistorySupport;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getBaseTableAlias:()Ljava/lang/String;
            invokevirtual io.ebeaninternal.server.query.CQueryHistorySupport.getAsOfPredicate:(Ljava/lang/String;)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 666
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    4     0  this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;

  private void appendFindId();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=3, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 669
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.isFindById:()Z
            ifne 1
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getId:()Ljava/lang/Object;
            ifnull 12
         1: .line 670
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendAndOrWhere:()V
         2: .line 672
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.request:Lio/ebeaninternal/server/core/OrmQueryRequest;
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getBeanDescriptor:()Lio/ebeaninternal/server/deploy/BeanDescriptor;
            astore 1 /* desc */
        start local 1 // io.ebeaninternal.server.deploy.BeanDescriptor desc
         3: .line 673
            aload 1 /* desc */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getAlias:()Ljava/lang/String;
            invokevirtual io.ebeaninternal.server.deploy.BeanDescriptor.getIdBinderIdSql:(Ljava/lang/String;)Ljava/lang/String;
            astore 2 /* idSql */
        start local 2 // java.lang.String idSql
         4: .line 674
            aload 2 /* idSql */
            invokevirtual java.lang.String.isEmpty:()Z
            ifeq 8
         5: .line 675
            new java.lang.IllegalStateException
            dup
            new java.lang.StringBuilder
            dup
            ldc "Executing FindById query on entity bean "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* desc */
            invokevirtual io.ebeaninternal.server.deploy.BeanDescriptor.getName:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
         6: .line 676
            ldc " that doesn't have an @Id property??"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         7: .line 675
            invokespecial java.lang.IllegalStateException.<init>:(Ljava/lang/String;)V
            athrow
         8: .line 678
      StackMap locals: io.ebeaninternal.server.deploy.BeanDescriptor java.lang.String
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.updateStatement:Z
            ifeq 10
         9: .line 680
            aload 2 /* idSql */
            ldc "t0."
            ldc ""
            invokevirtual java.lang.String.replace:(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;
            astore 2 /* idSql */
        10: .line 682
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 2 /* idSql */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        11: .line 683
            aload 0 /* this */
            iconst_1
            putfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasWhere:Z
        end local 2 // java.lang.String idSql
        end local 1 // io.ebeaninternal.server.deploy.BeanDescriptor desc
        12: .line 685
      StackMap locals:
      StackMap stack:
            return
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot   Name  Signature
            0   13     0   this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            3   12     1   desc  Lio/ebeaninternal/server/deploy/BeanDescriptor<*>;
            4   12     2  idSql  Ljava/lang/String;

  private void appendToWhere(java.lang.String);
    descriptor: (Ljava/lang/String;)V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=2, locals=2, args_size=2
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
        start local 1 // java.lang.String predicate
         0: .line 688
            aload 0 /* this */
            aload 1 /* predicate */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasValue:(Ljava/lang/String;)Z
            ifeq 3
         1: .line 689
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendAndOrWhere:()V
         2: .line 690
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 1 /* predicate */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 692
      StackMap locals:
      StackMap stack:
            return
        end local 1 // java.lang.String predicate
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot       Name  Signature
            0    4     0       this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            0    4     1  predicate  Ljava/lang/String;
    MethodParameters:
           Name  Flags
      predicate  

  private void appendSoftDelete();
    descriptor: ()V
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=3, locals=3, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 695
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getSoftDeletePredicates:()Ljava/util/List;
            astore 1 /* softDeletePredicates */
        start local 1 // java.util.List softDeletePredicates
         1: .line 696
            aload 1 /* softDeletePredicates */
            ifnull 10
         2: .line 697
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendAndOrWhere:()V
         3: .line 698
            iconst_0
            istore 2 /* i */
        start local 2 // int i
         4: goto 9
         5: .line 699
      StackMap locals: java.util.List int
      StackMap stack:
            iload 2 /* i */
            ifle 7
         6: .line 700
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " and "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         7: .line 702
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 1 /* softDeletePredicates */
            iload 2 /* i */
            invokeinterface java.util.List.get:(I)Ljava/lang/Object;
            checkcast java.lang.String
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         8: .line 698
            iinc 2 /* i */ 1
      StackMap locals:
      StackMap stack:
         9: iload 2 /* i */
            aload 1 /* softDeletePredicates */
            invokeinterface java.util.List.size:()I
            if_icmplt 5
        end local 2 // int i
        10: .line 705
      StackMap locals:
      StackMap stack:
            return
        end local 1 // java.util.List softDeletePredicates
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot                  Name  Signature
            0   11     0                  this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            1   11     1  softDeletePredicates  Ljava/util/List<Ljava/lang/String;>;
            4   10     2                     i  I

  private io.ebean.config.dbplatform.SqlLimitResponse buildSql();
    descriptor: ()Lio/ebean/config/dbplatform/SqlLimitResponse;
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=7, locals=4, args_size=1
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
         0: .line 708
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendSelect:()V
         1: .line 709
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendFrom:()V
         2: .line 710
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendInheritanceWhere:()V
         3: .line 711
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendHistoryAsOfPredicate:()V
         4: .line 712
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendFindId:()V
         5: .line 713
            aload 0 /* this */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.predicates:Lio/ebeaninternal/server/query/CQueryPredicates;
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbWhere:()Ljava/lang/String;
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendToWhere:(Ljava/lang/String;)V
         6: .line 714
            aload 0 /* this */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.predicates:Lio/ebeaninternal/server/query/CQueryPredicates;
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbFilterMany:()Ljava/lang/String;
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendToWhere:(Ljava/lang/String;)V
         7: .line 715
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isIncludeSoftDeletes:()Z
            ifne 9
         8: .line 716
            aload 0 /* this */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.appendSoftDelete:()V
         9: .line 719
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.select:Lio/ebeaninternal/server/query/SqlTree;
            invokevirtual io.ebeaninternal.server.query.SqlTree.getGroupBy:()Ljava/lang/String;
            astore 1 /* groupBy */
        start local 1 // java.lang.String groupBy
        10: .line 720
            aload 1 /* groupBy */
            ifnull 12
        11: .line 721
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " group by "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 1 /* groupBy */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        12: .line 724
      StackMap locals: java.lang.String
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.predicates:Lio/ebeaninternal/server/query/CQueryPredicates;
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbHaving:()Ljava/lang/String;
            astore 2 /* dbHaving */
        start local 2 // java.lang.String dbHaving
        13: .line 725
            aload 0 /* this */
            aload 2 /* dbHaving */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.hasValue:(Ljava/lang/String;)Z
            ifeq 15
        14: .line 726
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " having "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 2 /* dbHaving */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        15: .line 729
      StackMap locals: java.lang.String
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
            ifnull 17
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isCountDistinct:()Z
            ifne 17
        16: .line 730
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " order by "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        17: .line 733
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isCountDistinct:()Z
            ifeq 20
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.isSingleAttribute:()Z
            ifeq 20
        18: .line 734
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc ") r1 group by r1.attribute_"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        19: .line 735
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            aload 0 /* this */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getCountDistinctOrder:()Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebeaninternal.server.query.CQueryBuilder$BuildReq.toSql:(Lio/ebean/CountDistinctOrder;)Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        20: .line 738
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.useSqlLimiter:Z
            ifeq 23
        21: .line 740
            new io.ebeaninternal.server.querydefn.OrmQueryLimitRequest
            dup
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.dbOrderBy:Ljava/lang/String;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            getfield io.ebeaninternal.server.query.CQueryBuilder.dbPlatform:Lio/ebean/config/dbplatform/DatabasePlatform;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.distinct:Z
            invokespecial io.ebeaninternal.server.querydefn.OrmQueryLimitRequest.<init>:(Ljava/lang/String;Ljava/lang/String;Lio/ebeaninternal/api/SpiQuery;Lio/ebean/config/dbplatform/DatabasePlatform;Z)V
            astore 3 /* r */
        start local 3 // io.ebean.config.dbplatform.SqlLimitRequest r
        22: .line 741
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            getfield io.ebeaninternal.server.query.CQueryBuilder.sqlLimiter:Lio/ebean/config/dbplatform/SqlLimiter;
            aload 3 /* r */
            invokeinterface io.ebean.config.dbplatform.SqlLimiter.limit:(Lio/ebean/config/dbplatform/SqlLimitRequest;)Lio/ebean/config/dbplatform/SqlLimitResponse;
            areturn
        end local 3 // io.ebean.config.dbplatform.SqlLimitRequest r
        23: .line 743
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.updateStatement:Z
            ifeq 27
        24: .line 744
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getMaxRows:()I
            istore 3 /* maxRows */
        start local 3 // int maxRows
        25: .line 745
            iload 3 /* maxRows */
            ifle 27
        26: .line 747
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            ldc " limit "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            iload 3 /* maxRows */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            pop
        end local 3 // int maxRows
        27: .line 750
      StackMap locals:
      StackMap stack:
            new io.ebean.config.dbplatform.SqlLimitResponse
            dup
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.this$0:Lio/ebeaninternal/server/query/CQueryBuilder;
            getfield io.ebeaninternal.server.query.CQueryBuilder.dbPlatform:Lio/ebean/config/dbplatform/DatabasePlatform;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.sb:Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilder$BuildReq.query:Lio/ebeaninternal/api/SpiQuery;
            invokevirtual io.ebean.config.dbplatform.DatabasePlatform.completeSql:(Ljava/lang/String;Lio/ebean/Query;)Ljava/lang/String;
            invokespecial io.ebean.config.dbplatform.SqlLimitResponse.<init>:(Ljava/lang/String;)V
            areturn
        end local 2 // java.lang.String dbHaving
        end local 1 // java.lang.String groupBy
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot      Name  Signature
            0   28     0      this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
           10   28     1   groupBy  Ljava/lang/String;
           13   28     2  dbHaving  Ljava/lang/String;
           22   23     3         r  Lio/ebean/config/dbplatform/SqlLimitRequest;
           25   27     3   maxRows  I

  private java.lang.String toSql(io.ebean.CountDistinctOrder);
    descriptor: (Lio/ebean/CountDistinctOrder;)Ljava/lang/String;
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=5, locals=2, args_size=2
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
        start local 1 // io.ebean.CountDistinctOrder orderBy
         0: .line 755
            invokestatic io.ebeaninternal.server.query.CQueryBuilder$BuildReq.$SWITCH_TABLE$io$ebean$CountDistinctOrder:()[I
            aload 1 /* orderBy */
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iaload
            tableswitch { // 2 - 7
                    2: 1
                    3: 2
                    4: 3
                    5: 4
                    6: 5
                    7: 6
              default: 7
          }
         1: .line 757
      StackMap locals:
      StackMap stack:
            ldc " order by r1.attribute_"
            areturn
         2: .line 759
      StackMap locals:
      StackMap stack:
            ldc " order by r1.attribute_ desc"
            areturn
         3: .line 761
      StackMap locals:
      StackMap stack:
            ldc " order by count(*), r1.attribute_"
            areturn
         4: .line 763
      StackMap locals:
      StackMap stack:
            ldc " order by count(*), r1.attribute_ desc"
            areturn
         5: .line 765
      StackMap locals:
      StackMap stack:
            ldc " order by count(*) desc, r1.attribute_"
            areturn
         6: .line 767
      StackMap locals:
      StackMap stack:
            ldc " order by count(*) desc, r1.attribute_ desc"
            areturn
         7: .line 769
      StackMap locals:
      StackMap stack:
            new java.lang.IllegalArgumentException
            dup
            new java.lang.StringBuilder
            dup
            ldc "Illegal enum: "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 1 /* orderBy */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/Object;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokespecial java.lang.IllegalArgumentException.<init>:(Ljava/lang/String;)V
            athrow
        end local 1 // io.ebean.CountDistinctOrder orderBy
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot     Name  Signature
            0    8     0     this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            0    8     1  orderBy  Lio/ebean/CountDistinctOrder;
    MethodParameters:
         Name  Flags
      orderBy  

  private boolean hasValue(java.lang.String);
    descriptor: (Ljava/lang/String;)Z
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=1, locals=2, args_size=2
        start local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
        start local 1 // java.lang.String s
         0: .line 774
            aload 1 /* s */
            ifnull 1
            aload 1 /* s */
            invokevirtual java.lang.String.isEmpty:()Z
            ifne 1
            iconst_1
            ireturn
      StackMap locals:
      StackMap stack:
         1: iconst_0
            ireturn
        end local 1 // java.lang.String s
        end local 0 // io.ebeaninternal.server.query.CQueryBuilder$BuildReq this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    2     0  this  Lio/ebeaninternal/server/query/CQueryBuilder$BuildReq;
            0    2     1     s  Ljava/lang/String;
    MethodParameters:
      Name  Flags
      s     

  static int[] $SWITCH_TABLE$io$ebean$CountDistinctOrder();
    descriptor: ()[I
    flags: (0x1008) ACC_STATIC, ACC_SYNTHETIC
    Code:
      stack=3, locals=1, args_size=0
         0: .line 566
            getstatic io.ebeaninternal.server.query.CQueryBuilder$BuildReq.$SWITCH_TABLE$io$ebean$CountDistinctOrder:[I
            dup
            ifnull 1
            areturn
      StackMap locals:
      StackMap stack: int[]
         1: pop
            invokestatic io.ebean.CountDistinctOrder.values:()[Lio/ebean/CountDistinctOrder;
            arraylength
            newarray 10
            astore 0
         2: aload 0
            getstatic io.ebean.CountDistinctOrder.ATTR_ASC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iconst_2
            iastore
         3: goto 5
      StackMap locals: int[]
      StackMap stack: java.lang.NoSuchFieldError
         4: pop
      StackMap locals:
      StackMap stack:
         5: aload 0
            getstatic io.ebean.CountDistinctOrder.ATTR_DESC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iconst_3
            iastore
         6: goto 8
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
         7: pop
      StackMap locals:
      StackMap stack:
         8: aload 0
            getstatic io.ebean.CountDistinctOrder.COUNT_ASC_ATTR_ASC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iconst_4
            iastore
         9: goto 11
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
        10: pop
      StackMap locals:
      StackMap stack:
        11: aload 0
            getstatic io.ebean.CountDistinctOrder.COUNT_ASC_ATTR_DESC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iconst_5
            iastore
        12: goto 14
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
        13: pop
      StackMap locals:
      StackMap stack:
        14: aload 0
            getstatic io.ebean.CountDistinctOrder.COUNT_DESC_ATTR_ASC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            bipush 6
            iastore
        15: goto 17
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
        16: pop
      StackMap locals:
      StackMap stack:
        17: aload 0
            getstatic io.ebean.CountDistinctOrder.COUNT_DESC_ATTR_DESC:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            bipush 7
            iastore
        18: goto 20
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
        19: pop
      StackMap locals:
      StackMap stack:
        20: aload 0
            getstatic io.ebean.CountDistinctOrder.NO_ORDERING:Lio/ebean/CountDistinctOrder;
            invokevirtual io.ebean.CountDistinctOrder.ordinal:()I
            iconst_1
            iastore
        21: goto 23
      StackMap locals:
      StackMap stack: java.lang.NoSuchFieldError
        22: pop
      StackMap locals:
      StackMap stack:
        23: aload 0
            dup
            putstatic io.ebeaninternal.server.query.CQueryBuilder$BuildReq.$SWITCH_TABLE$io$ebean$CountDistinctOrder:[I
            areturn
      LocalVariableTable:
        Start  End  Slot  Name  Signature
      Exception table:
        from    to  target  type
           2     3       4  Class java.lang.NoSuchFieldError
           5     6       7  Class java.lang.NoSuchFieldError
           8     9      10  Class java.lang.NoSuchFieldError
          11    12      13  Class java.lang.NoSuchFieldError
          14    15      16  Class java.lang.NoSuchFieldError
          17    18      19  Class java.lang.NoSuchFieldError
          20    21      22  Class java.lang.NoSuchFieldError
}
SourceFile: "CQueryBuilder.java"
NestHost: io.ebeaninternal.server.query.CQueryBuilder
InnerClasses:
  private BuildReq = io.ebeaninternal.server.query.CQueryBuilder$BuildReq of io.ebeaninternal.server.query.CQueryBuilder