Log excerpts for 14 sysbench OLTP queries

layer.log

SELECT c FROM sbtest1 WHERE id=501119
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 501119)

SELECT c FROM sbtest1 WHERE id=496896
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 496896)

SELECT c FROM sbtest1 WHERE id=502187
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 502187)

SELECT c FROM sbtest1 WHERE id=502367
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 502367)

SELECT c FROM sbtest1 WHERE id=420519
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 420519)

SELECT c FROM sbtest1 WHERE id=503463
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 503463)

SELECT c FROM sbtest1 WHERE id=475981
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 475981)

SELECT c FROM sbtest1 WHERE id=501482
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 501482)

SELECT c FROM sbtest1 WHERE id=498975
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 498975)

SELECT c FROM sbtest1 WHERE id=537207
  Project_Default(Field(2))
    GroupLookup_Default(sbtest.sbtest1 -> sbtest.sbtest1)
      HKeyRow_Default(sbtest.sbtest1, 537207)

SELECT c FROM sbtest1 WHERE id BETWEEN 496725 AND 496725+99
  Project_Default(Field(2))
    GroupLookup_Default(Index(sbtest.sbtest1.id) -> sbtest.sbtest1)
      IndexScan_Default(Index(sbtest.sbtest1.id), id BETWEEN 496725 AND 496824 ASC)

SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 473661 AND 473661+99;
  Project_Default(Field(0))
    Aggregate_Partial(SUM)
      Project_Default(Field(1))
        GroupLookup_Default(Index(sbtest.sbtest1.id) -> sbtest.sbtest1)
          IndexScan_Default(Index(sbtest.sbtest1.id), id BETWEEN 473661 AND 473760 ASC)

SELECT c FROM sbtest1 WHERE id BETWEEN 502996 AND 502996+99 ORDER BY c
  Project_Default(Field(2))
    Sort_General(Field(2) ASC)
      GroupLookup_Default(Index(sbtest.sbtest1.id) -> sbtest.sbtest1)
        IndexScan_Default(Index(sbtest.sbtest1.id), id BETWEEN 502996 AND 503095 ASC)

SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 509624 AND 509624+99 ORDER BY c
  Sort_General(Field(0) ASC, SUPPRESS DUPLICATES)
    Project_Default(Field(2))
      GroupLookup_Default(Index(sbtest.sbtest1.id) -> sbtest.sbtest1)
        IndexScan_Default(Index(sbtest.sbtest1.id), id BETWEEN 509624 AND 509723 ASC)