Facebook

slow query safest cryptocurrency exchange

From nobody, 3 Years ago, written in Plain Text.
URL https://pastebin.pl/view/569aaa48
Embed
Download Paste or View Raw
Hits: 92
  1. SPARQL query after parsing, optimization, and converting back into SPARQL
  2. SELECT  ?catAtt
  3.  ?caDataType
  4.  ?showInview
  5.  ?valFormatKey
  6.  ?multiple
  7.  ?position
  8.  ?link
  9.  ?catAttName
  10.  ?setting
  11.  ?flag
  12.  ?caUnit
  13.  ?catId
  14.  WHERE {
  15.      GRAPH <http://localhost:8890/graph> { QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/caDataType> ?caDataType }
  16.                  QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/showInView> ?showInview }
  17.                          QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/valFormat> ?valFormatKey }
  18.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/multiple> ?multiple }
  19.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/position> ?position }
  20.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/link> ?link }
  21.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/catAttName> ?catAttName }
  22.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/setting> ?setting }
  23.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/flag> ?flag }
  24.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/unit> ?caUnit }
  25.                                QUAD MAP <http://www.openlinksw.com/schemas/virtrdf#DefaultQuadMap> { ?catAtt <https://graph.com/rdf/qq/catId> ?catId } }
  26.                                FILTER (?catId =   1)
  27.                               FILTER ( <http://www.w3.org/2001/XMLSchema#integer> =  datatype( ?catId) ) }
  28.                               LIMIT  20
  29. SPARQL query translated to SQL
  30. For security reasons, code responsible for graph-level security is not generated and some account-specific data are intentionally made wrong.
  31. SELECT TOP 20 __id2in ( "s_24_11_t10"."S") AS "catAtt",
  32.   __ro2sq ( "s_24_11_t0"."O") AS "caDataType",
  33.   __ro2sq ( "s_24_11_t1"."O") AS "showInview",
  34.   __ro2sq ( "s_24_11_t2"."O") AS "valFormatKey",
  35.   __ro2sq ( "s_24_11_t3"."O") AS "multiple",
  36.   __ro2sq ( "s_24_11_t4"."O") AS "position",
  37.   __ro2sq ( "s_24_11_t5"."O") AS "link",
  38.   __ro2sq ( "s_24_11_t6"."O") AS "catAttName",
  39.   __ro2sq ( "s_24_11_t7"."O") AS "setting",
  40.   __ro2sq ( "s_24_11_t8"."O") AS "flag",
  41.   __ro2sq ( "s_24_11_t9"."O") AS "caUnit",
  42.   1 AS "catId"
  43. FROM DB.DBA.RDF_QUAD AS "s_24_11_t0"
  44.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t1"
  45.   ON (
  46.     "s_24_11_t1"."S" = "s_24_11_t0"."S")
  47.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t2"
  48.   ON (
  49.     "s_24_11_t2"."S" = "s_24_11_t1"."S"
  50.     AND
  51.     "s_24_11_t2"."S" = "s_24_11_t0"."S")
  52.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t3"
  53.   ON (
  54.     "s_24_11_t3"."S" = "s_24_11_t2"."S"
  55.     AND
  56.     "s_24_11_t3"."S" = "s_24_11_t1"."S"
  57.     AND
  58.     "s_24_11_t3"."S" = "s_24_11_t0"."S")
  59.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t4"
  60.   ON (
  61.     "s_24_11_t4"."S" = "s_24_11_t3"."S"
  62.     AND
  63.     "s_24_11_t4"."S" = "s_24_11_t2"."S"
  64.     AND
  65.     "s_24_11_t4"."S" = "s_24_11_t1"."S"
  66.     AND
  67.     "s_24_11_t4"."S" = "s_24_11_t0"."S")
  68.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t5"
  69.   ON (
  70.     "s_24_11_t5"."S" = "s_24_11_t4"."S"
  71.     AND
  72.     "s_24_11_t5"."S" = "s_24_11_t3"."S"
  73.     AND
  74.     "s_24_11_t5"."S" = "s_24_11_t2"."S"
  75.     AND
  76.     "s_24_11_t5"."S" = "s_24_11_t1"."S"
  77.     AND
  78.     "s_24_11_t5"."S" = "s_24_11_t0"."S")
  79.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t6"
  80.   ON (
  81.     "s_24_11_t6"."S" = "s_24_11_t5"."S"
  82.     AND
  83.     "s_24_11_t6"."S" = "s_24_11_t4"."S"
  84.     AND
  85.     "s_24_11_t6"."S" = "s_24_11_t3"."S"
  86.     AND
  87.     "s_24_11_t6"."S" = "s_24_11_t2"."S"
  88.     AND
  89.     "s_24_11_t6"."S" = "s_24_11_t1"."S"
  90.     AND
  91.     "s_24_11_t6"."S" = "s_24_11_t0"."S")
  92.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t7"
  93.   ON (
  94.     "s_24_11_t7"."S" = "s_24_11_t6"."S"
  95.     AND
  96.     "s_24_11_t7"."S" = "s_24_11_t5"."S"
  97.     AND
  98.     "s_24_11_t7"."S" = "s_24_11_t4"."S"
  99.     AND
  100.     "s_24_11_t7"."S" = "s_24_11_t3"."S"
  101.     AND
  102.     "s_24_11_t7"."S" = "s_24_11_t2"."S"
  103.     AND
  104.     "s_24_11_t7"."S" = "s_24_11_t1"."S"
  105.     AND
  106.     "s_24_11_t7"."S" = "s_24_11_t0"."S")
  107.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t8"
  108.   ON (
  109.     "s_24_11_t8"."S" = "s_24_11_t7"."S"
  110.     AND
  111.     "s_24_11_t8"."S" = "s_24_11_t6"."S"
  112.     AND
  113.     "s_24_11_t8"."S" = "s_24_11_t5"."S"
  114.     AND
  115.     "s_24_11_t8"."S" = "s_24_11_t4"."S"
  116.     AND
  117.     "s_24_11_t8"."S" = "s_24_11_t3"."S"
  118.     AND
  119.     "s_24_11_t8"."S" = "s_24_11_t2"."S"
  120.     AND
  121.     "s_24_11_t8"."S" = "s_24_11_t1"."S"
  122.     AND
  123.     "s_24_11_t8"."S" = "s_24_11_t0"."S")
  124.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t9"
  125.   ON (
  126.     "s_24_11_t9"."S" = "s_24_11_t8"."S"
  127.     AND
  128.     "s_24_11_t9"."S" = "s_24_11_t7"."S"
  129.     AND
  130.     "s_24_11_t9"."S" = "s_24_11_t6"."S"
  131.     AND
  132.     "s_24_11_t9"."S" = "s_24_11_t5"."S"
  133.     AND
  134.     "s_24_11_t9"."S" = "s_24_11_t4"."S"
  135.     AND
  136.     "s_24_11_t9"."S" = "s_24_11_t3"."S"
  137.     AND
  138.     "s_24_11_t9"."S" = "s_24_11_t2"."S"
  139.     AND
  140.     "s_24_11_t9"."S" = "s_24_11_t1"."S"
  141.     AND
  142.     "s_24_11_t9"."S" = "s_24_11_t0"."S")
  143.   INNER JOIN DB.DBA.RDF_QUAD AS "s_24_11_t10"
  144.   ON (
  145.     "s_24_11_t10"."S" = "s_24_11_t9"."S"
  146.     AND
  147.     "s_24_11_t10"."S" = "s_24_11_t8"."S"
  148.     AND
  149.     "s_24_11_t10"."S" = "s_24_11_t7"."S"
  150.     AND
  151.     "s_24_11_t10"."S" = "s_24_11_t6"."S"
  152.     AND
  153.     "s_24_11_t10"."S" = "s_24_11_t5"."S"
  154.     AND
  155.     "s_24_11_t10"."S" = "s_24_11_t4"."S"
  156.     AND
  157.     "s_24_11_t10"."S" = "s_24_11_t3"."S"
  158.     AND
  159.     "s_24_11_t10"."S" = "s_24_11_t2"."S"
  160.     AND
  161.     "s_24_11_t10"."S" = "s_24_11_t1"."S"
  162.     AND
  163.     "s_24_11_t10"."S" = "s_24_11_t0"."S")
  164. WHERE
  165.   "s_24_11_t0"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  166.   AND
  167.   "s_24_11_t0"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/caDataType' , 1))
  168.   AND
  169.   "s_24_11_t1"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  170.   AND
  171.   "s_24_11_t1"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/showInView' , 1))
  172.   AND
  173.   "s_24_11_t2"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  174.   AND
  175.   "s_24_11_t2"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/valFormat' , 1))
  176.   AND
  177.   "s_24_11_t3"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  178.   AND
  179.   "s_24_11_t3"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/multiple' , 1))
  180.   AND
  181.   "s_24_11_t4"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  182.   AND
  183.   "s_24_11_t4"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/position' , 1))
  184.   AND
  185.   "s_24_11_t5"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  186.   AND
  187.   "s_24_11_t5"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/link' , 1))
  188.   AND
  189.   "s_24_11_t6"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  190.   AND
  191.   "s_24_11_t6"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/catAttName' , 1))
  192.   AND
  193.   "s_24_11_t7"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  194.   AND
  195.   "s_24_11_t7"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/setting' , 1))
  196.   AND
  197.   "s_24_11_t8"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  198.   AND
  199.   "s_24_11_t8"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/flag' , 1))
  200.   AND
  201.   "s_24_11_t9"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  202.   AND
  203.   "s_24_11_t9"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/unit' , 1))
  204.   AND
  205.   "s_24_11_t10"."G" = __i2idn ( __bft( 'http://localhost:8890/graph' , 1))
  206.   AND
  207.   "s_24_11_t10"."P" = __i2idn ( __bft( 'https://graph.com/rdf/qq/catId' , 1))
  208.   AND
  209.   "s_24_11_t10"."O" = 1
  210.   AND
  211.  ( __bft( 'http://www.w3.org/2001/XMLSchema#integer' , 1) =  __xsd_type ( 1))
  212. OPTION (QUIETCAST)
  213. SQL execution plan
  214.   {
  215.     END Node
  216.     After test:
  217.     0: __xsd_type$28 := Call __xsd_type ( 1 )
  218.     5: if (<tag 182 flag 1 c http://www.w3.org/2001/XMLSchema#integer> = __xsd_type$28) then 9 else 10 unkn 10
  219.     9: BReturn 1
  220.     10: BReturn 0
  221.     Precode:
  222.       0: __xsd_type$30 := Call __xsd_type ( 1 )
  223.       5: BReturn 0
  224.     RDF_QUAD_POGS        11 rows(s_24_11_t10.S$33)
  225.      P =  IRI_ID"...catId"  ,  O =  1  G =  IRI_ID"...graph"
  226.     END Node
  227.     After test:
  228.     0: if (<tag 182 flag 1 c http://www.w3.org/2001/XMLSchema#integer> = __xsd_type$30) then 4 else 5 unkn 5
  229.     4: BReturn 1
  230.     5: BReturn 0
  231.     RDF_QUAD         1 rows(s_24_11_t9.S$37, s_24_11_t9.O$36)
  232.      inlined  P =  IRI_ID"...unit"  ,  S = k_s_24_11_t10.S$132 G =  IRI_ID"...graph"
  233.     RDF_QUAD         1 rows(s_24_11_t8.S$41, s_24_11_t8.O$40)
  234.      inlined  P =  IRI_ID"...flag"  ,  S = k_s_24_11_t9.S$143 G =  IRI_ID"...graph"
  235.     RDF_QUAD         1 rows(s_24_11_t7.S$45, s_24_11_t7.O$44)
  236.      inlined  P =  IRI_ID"...setting"  ,  S = k_s_24_11_t8.S$154 G =  IRI_ID"...graph"
  237.     RDF_QUAD         1 rows(s_24_11_t6.S$49, s_24_11_t6.O$48)
  238.      inlined  P =  IRI_ID"...catAttName"  ,  S = k_s_24_11_t7.S$165 G =  IRI_ID"...graph"
  239.     RDF_QUAD         1 rows(s_24_11_t0.S$53, s_24_11_t0.O$52)
  240.      inlined  P =  IRI_ID"...caDataType"  ,  S = k_s_24_11_t6.S$176 G =  IRI_ID"...graph"
  241.     RDF_QUAD         1 rows(s_24_11_t1.S$57, s_24_11_t1.O$56)
  242.      inlined  P =  IRI_ID"...showInView"  ,  S = k_s_24_11_t0.S$187 G =  IRI_ID"...graph"
  243.     RDF_QUAD         1 rows(s_24_11_t2.S$61, s_24_11_t2.O$60)
  244.      inlined  P =  IRI_ID"...valFormat"  ,  S = k_s_24_11_t1.S$198 G =  IRI_ID"...graph"
  245.     RDF_QUAD         1 rows(s_24_11_t3.S$65, s_24_11_t3.O$64)
  246.      inlined  P =  IRI_ID"...multiple"  ,  S = k_s_24_11_t2.S$209 G =  IRI_ID"...graph"
  247.     RDF_QUAD         1 rows(s_24_11_t4.S$69, s_24_11_t4.O$68)
  248.      inlined  P =  IRI_ID"...position"  ,  S = k_s_24_11_t3.S$220 G =  IRI_ID"...graph"
  249.     RDF_QUAD         1 rows(s_24_11_t5.O$72)
  250.      inlined  P =  IRI_ID"...link"  ,  S = k_s_24_11_t4.S$231 G =  IRI_ID"...graph"
  251.     skip node  20  <none> set_ctr$102
  252.    
  253.     After code:
  254.     0: caUnit$74 := Call __ro2sq (s_24_11_t9.O$36)
  255.     5: flag$76 := Call __ro2sq (s_24_11_t8.O$40)
  256.     10: setting$78 := Call __ro2sq (s_24_11_t7.O$44)
  257.     15: catAttName$80 := Call __ro2sq (s_24_11_t6.O$48)
  258.     20: position$82 := Call __ro2sq (s_24_11_t4.O$68)
  259.     25: multiple$84 := Call __ro2sq (s_24_11_t3.O$64)
  260.     30: valFormatKey$86 := Call __ro2sq (s_24_11_t2.O$60)
  261.     35: showInview$88 := Call __ro2sq (s_24_11_t1.O$56)
  262.     40: caDataType$90 := Call __ro2sq (s_24_11_t0.O$52)
  263.     45: catAtt$92 := Call __id2in (s_24_11_t10.S$33)
  264.     50: link$94 := Call __ro2sq (s_24_11_t5.O$72)
  265.     55: BReturn 0
  266.     Select (catAtt$92, caDataType$90, showInview$88, valFormatKey$86, multiple$84, position$82, link$94, catAttName$80, setting$78, flag$76, caUnit$74,  1 )
  267.   }
  268. Internal optimizer data
  269. These data are primarily for OpenLink support, to get additional details about the query processing.
  270.         QUERY: (line 28) REQUEST TOP NODE (SELECT result-mode):
  271.   RETVALS: ARRAY OF NODES with 12 children: {
  272.     (line 28) VARIABLE: notNULL reference exported
  273.       NAME: UNAME `catAtt'      SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 12
  274.     (line 28) VARIABLE: notNULL exported
  275.       NAME: UNAME `caDataType'  SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 13
  276.     (line 28) VARIABLE: notNULL exported
  277.       NAME: UNAME `showInview'  SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 14
  278.     (line 28) VARIABLE: notNULL exported
  279.       NAME: UNAME `valFormatKey'        SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 15
  280.     (line 28) VARIABLE: notNULL exported
  281.       NAME: UNAME `multiple'    SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 16
  282.     (line 28) VARIABLE: notNULL exported
  283.       NAME: UNAME `position'    SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 17
  284.     (line 28) VARIABLE: notNULL exported
  285.       NAME: UNAME `link'        SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 18
  286.     (line 28) VARIABLE: notNULL exported
  287.       NAME: UNAME `catAttName'  SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 19
  288.     (line 28) VARIABLE: notNULL exported
  289.       NAME: UNAME `setting'     SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 20
  290.     (line 28) VARIABLE: notNULL exported
  291.       NAME: UNAME `flag'        SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 21
  292.     (line 28) VARIABLE: notNULL exported
  293.       NAME: UNAME `caUnit'      SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 22
  294.     (line 28) VARIABLE: notNULL fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1
  295.       NAME: UNAME `catId'       SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 23
  296.    }
  297.   RETVALS SELECT ID: STRING `s_28_12'
  298.   SOURCES: EMPTY ARRAY
  299.   PATTERN: (line 28) GRAPH PATTERN:WHERE gp
  300.     MEMBERS: ARRAY OF NODES with 11 children: {
  301.       (line 8) TRIPLE:
  302.         GRAPH: (line 6) QNAME:
  303.           IRI: UNAME `http://localhost:8890/graph'
  304.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  305.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t0'   EQUIV: LONG 12
  306.         PREDICATE: (line 8) QNAME:
  307.           IRI: UNAME `https://graph.com/rdf/qq/caDataType'
  308.         OBJECT: (line 8) VARIABLE: notNULL+ exported (object)
  309.           NAME: UNAME `caDataType'      SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t0'   EQUIV: LONG 13
  310.         SELECT ID: STRING `s_28_12'
  311.         TABLE ID: STRING `s_24_11_t0'
  312.       (line 9) TRIPLE:
  313.         GRAPH: (line 6) QNAME:
  314.           IRI: UNAME `http://localhost:8890/graph'
  315.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  316.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t1'   EQUIV: LONG 12
  317.         PREDICATE: (line 9) QNAME:
  318.           IRI: UNAME `https://graph.com/rdf/qq/showInView'
  319.         OBJECT: (line 9) VARIABLE: notNULL+ exported (object)
  320.           NAME: UNAME `showInview'      SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t1'   EQUIV: LONG 14
  321.         SELECT ID: STRING `s_28_12'
  322.         TABLE ID: STRING `s_24_11_t1'
  323.       (line 10) TRIPLE:
  324.         GRAPH: (line 6) QNAME:
  325.           IRI: UNAME `http://localhost:8890/graph'
  326.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  327.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t2'   EQUIV: LONG 12
  328.         PREDICATE: (line 10) QNAME:
  329.           IRI: UNAME `https://graph.com/rdf/qq/valFormat'
  330.         OBJECT: (line 10) VARIABLE: notNULL+ exported (object)
  331.           NAME: UNAME `valFormatKey'    SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t2'   EQUIV: LONG 15
  332.         SELECT ID: STRING `s_28_12'
  333.         TABLE ID: STRING `s_24_11_t2'
  334.       (line 11) TRIPLE:
  335.         GRAPH: (line 6) QNAME:
  336.           IRI: UNAME `http://localhost:8890/graph'
  337.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  338.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t3'   EQUIV: LONG 12
  339.         PREDICATE: (line 11) QNAME:
  340.           IRI: UNAME `https://graph.com/rdf/qq/multiple'
  341.         OBJECT: (line 11) VARIABLE: notNULL+ exported (object)
  342.           NAME: UNAME `multiple'        SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t3'   EQUIV: LONG 16
  343.         SELECT ID: STRING `s_28_12'
  344.         TABLE ID: STRING `s_24_11_t3'
  345.       (line 12) TRIPLE:
  346.         GRAPH: (line 6) QNAME:
  347.           IRI: UNAME `http://localhost:8890/graph'
  348.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  349.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t4'   EQUIV: LONG 12
  350.         PREDICATE: (line 12) QNAME:
  351.           IRI: UNAME `https://graph.com/rdf/qq/position'
  352.         OBJECT: (line 12) VARIABLE: notNULL+ exported (object)
  353.           NAME: UNAME `position'        SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t4'   EQUIV: LONG 17
  354.         SELECT ID: STRING `s_28_12'
  355.         TABLE ID: STRING `s_24_11_t4'
  356.       (line 13) TRIPLE:
  357.         GRAPH: (line 6) QNAME:
  358.           IRI: UNAME `http://localhost:8890/graph'
  359.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  360.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t5'   EQUIV: LONG 12
  361.         PREDICATE: (line 13) QNAME:
  362.           IRI: UNAME `https://graph.com/rdf/qq/link'
  363.         OBJECT: (line 13) VARIABLE: notNULL+ exported (object)
  364.           NAME: UNAME `link'    SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t5'   EQUIV: LONG 18
  365.         SELECT ID: STRING `s_28_12'
  366.         TABLE ID: STRING `s_24_11_t5'
  367.       (line 14) TRIPLE:
  368.         GRAPH: (line 6) QNAME:
  369.           IRI: UNAME `http://localhost:8890/graph'
  370.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  371.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t6'   EQUIV: LONG 12
  372.         PREDICATE: (line 14) QNAME:
  373.           IRI: UNAME `https://graph.com/rdf/qq/catAttName'
  374.         OBJECT: (line 14) VARIABLE: notNULL+ exported (object)
  375.           NAME: UNAME `catAttName'      SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t6'   EQUIV: LONG 19
  376.         SELECT ID: STRING `s_28_12'
  377.         TABLE ID: STRING `s_24_11_t6'
  378.       (line 15) TRIPLE:
  379.         GRAPH: (line 6) QNAME:
  380.           IRI: UNAME `http://localhost:8890/graph'
  381.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  382.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t7'   EQUIV: LONG 12
  383.         PREDICATE: (line 15) QNAME:
  384.           IRI: UNAME `https://graph.com/rdf/qq/setting'
  385.         OBJECT: (line 15) VARIABLE: notNULL+ exported (object)
  386.           NAME: UNAME `setting' SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t7'   EQUIV: LONG 20
  387.         SELECT ID: STRING `s_28_12'
  388.         TABLE ID: STRING `s_24_11_t7'
  389.       (line 16) TRIPLE:
  390.         GRAPH: (line 6) QNAME:
  391.           IRI: UNAME `http://localhost:8890/graph'
  392.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  393.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t8'   EQUIV: LONG 12
  394.         PREDICATE: (line 16) QNAME:
  395.           IRI: UNAME `https://graph.com/rdf/qq/flag'
  396.         OBJECT: (line 16) VARIABLE: notNULL+ exported (object)
  397.           NAME: UNAME `flag'    SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t8'   EQUIV: LONG 21
  398.         SELECT ID: STRING `s_28_12'
  399.         TABLE ID: STRING `s_24_11_t8'
  400.       (line 17) TRIPLE:
  401.         GRAPH: (line 6) QNAME:
  402.           IRI: UNAME `http://localhost:8890/graph'
  403.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  404.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t9'   EQUIV: LONG 12
  405.         PREDICATE: (line 17) QNAME:
  406.           IRI: UNAME `https://graph.com/rdf/qq/unit'
  407.         OBJECT: (line 17) VARIABLE: notNULL+ exported (object)
  408.           NAME: UNAME `caUnit'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t9'   EQUIV: LONG 22
  409.         SELECT ID: STRING `s_28_12'
  410.         TABLE ID: STRING `s_24_11_t9'
  411.       (line 18) TRIPLE:
  412.         GRAPH: (line 6) QNAME:
  413.           IRI: UNAME `http://localhost:8890/graph'
  414.         SUBJECT: (line 8) VARIABLE: notNULL+ reference+ exported (subject)
  415.           NAME: UNAME `catAtt'  SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t10'  EQUIV: LONG 12
  416.         PREDICATE: (line 18) QNAME:
  417.           IRI: UNAME `https://graph.com/rdf/qq/catId'
  418.         OBJECT: (line 18) VARIABLE: notNULL+ fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1 (object)
  419.           NAME: UNAME `catId'   SELECT ID: STRING `s_28_12'     TABLE ID: STRING `s_24_11_t10'  EQUIV: LONG 23
  420.         SELECT ID: STRING `s_28_12'
  421.         TABLE ID: STRING `s_24_11_t10'
  422.      }
  423.     FILTERS: ARRAY OF NODES with 1 children: {
  424.       (line 28) OPERATOR EXPRESSION (boolean operation '='):
  425.         LEFT: UNAME `http://www.w3.org/2001/XMLSchema#integer'
  426.         RIGHT: (line 28) BUILT-IN CALL:datatype
  427.           ARGUMENT: ARRAY OF NODES with 1 children: {
  428.             (line 28) VARIABLE: notNULL fixed typed lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1
  429.               NAME: UNAME `catId'       SELECT ID: STRING `s_28_12'     TABLE ID: LONG 0        EQUIV: LONG 23
  430.            }
  431.      }
  432.     SELECT ID: STRING `s_28_12'
  433.     EQUIVS: 12 13 14 15 16 17 18 19 20 21 22 23
  434.   LIMIT: LONG 20
  435.  
  436. EQUIVS:
  437. #0: merged and destroyed
  438. #1: merged and destroyed
  439. #2: merged and destroyed
  440. #3: merged and destroyed
  441. #4: merged and destroyed
  442. #5: merged and destroyed
  443. #6: merged and destroyed
  444. #7: merged and destroyed
  445. #8: merged and destroyed
  446. #9: merged and destroyed
  447. #10: merged and destroyed
  448. #11: merged and destroyed
  449. #12: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 11 gspo, 1 const, 0 opt, 0 subq: catAtt in s_28_12 s_24_11_t10 s_24_11_t9 s_24_11_t8 s_24_11_t7 s_24_11_t6 s_24_11_t5 s_24_11_t4 s_24_11_t3 s_24_11_t2 s_24_11_t1 s_24_11_t0; notNULL reference exported)
  450. #13: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: caDataType in s_28_12 s_24_11_t0; notNULL exported)
  451. #14: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: showInview in s_28_12 s_24_11_t1; notNULL exported)
  452. #15: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: valFormatKey in s_28_12 s_24_11_t2; notNULL exported)
  453. #16: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: multiple in s_28_12 s_24_11_t3; notNULL exported)
  454. #17: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: position in s_28_12 s_24_11_t4; notNULL exported)
  455. #18: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: link in s_28_12 s_24_11_t5; notNULL exported)
  456. #19: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: catAttName in s_28_12 s_24_11_t6; notNULL exported)
  457. #20: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: setting in s_28_12 s_24_11_t7; notNULL exported)
  458. #21: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: flag in s_28_12 s_24_11_t8; notNULL exported)
  459. #22: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 1 const, 0 opt, 0 subq: caUnit in s_28_12 s_24_11_t9; notNULL exported)
  460. #23: ( 0 subv (0 bindings, 0 nest.opt.), 0 recv, 1 gspo, 2 const, 0 opt, 0 subq: catId in s_28_12 s_24_11_t10 s_28_12; notNULL! fixed! typed! lit exported; dt=http://www.w3.org/2001/XMLSchema#integer; fixed INTEGER 1)

Reply to "slow query"

captcha