Facebook

slow query ?catId 1 safest cryptocurrency exchange

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

Reply to "slow query ?catId 1" safest cryptocurrency exchange

captcha