addrbookFor publishers
← The evidence ledger

Evidence row 120197

Observed , by baseline/1.

Kind
listing
About
source_record x402_bazaar:https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis
Recorded
Previous row
None: the first of its kind about this subject
Body SHA-256
7d1129f061bb62fbf169f7b61ff7f82f1ab085ac27041ea0180809b892ac53a0
Leaf
0x8b80e2af288bcf0900a90419ad5e027bb609e0f8c79c4f106e7609c5a12b4fa7

What was observed

{
  "endpoints": [
    [
      "x402",
      "https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis"
    ]
  ],
  "name": "Saylor Innovations Guide Library",
  "owner_address": "0xa2a8df0f7caabea4e120a2568118f141569fc8aa",
  "raw": {
    "accepts": [
      {
        "amount": "10000",
        "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
        "extra": {
          "assetTransferMethod": "eip3009",
          "facilitatorOnly": true,
          "memo": "saylor:mysql-slow-query-index-di",
          "name": "USD Coin",
          "note": "Base settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.",
          "version": "2"
        },
        "maxTimeoutSeconds": 120,
        "network": "eip155:8453",
        "payTo": "0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa",
        "scheme": "exact"
      },
      {
        "amount": "10000",
        "asset": "0x3c499c542cEF5E3811e1192ce70d8cC03d5c3359",
        "extra": {
          "assetTransferMethod": "eip3009",
          "facilitatorOnly": true,
          "memo": "saylor:mysql-slow-query-index-di",
          "name": "USD Coin",
          "note": "Polygon settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.",
          "version": "2"
        },
        "maxTimeoutSeconds": 120,
        "network": "eip155:137",
        "payTo": "0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa",
        "scheme": "exact"
      },
      {
        "amount": "10000",
        "asset": "0xaf88d065e77c8cC2239327C5EDb3A432268e5831",
        "extra": {
          "assetTransferMethod": "eip3009",
          "facilitatorOnly": true,
          "memo": "saylor:mysql-slow-query-index-di",
          "name": "USD Coin",
          "note": "Arbitrum settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.",
          "version": "2"
        },
        "maxTimeoutSeconds": 120,
        "network": "eip155:42161",
        "payTo": "0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa",
        "scheme": "exact"
      },
      {
        "amount": "10000",
        "asset": "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v",
        "extra": {
          "feePayer": "BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F",
          "memo": "saylor:mysql-slow-query-index-di",
          "reference": "Dw37urLjRHbV259uStxo8NKmkQEGhptmGkpwAutwFfJv",
          "session": "eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IkR3Mzd1ckxqUkhiVjI1OXVTdHhvOE5LbWtRRUdocHRtR2twd0F1dHdGZkp2IiwicmVjaXBpZW50IjoiN0xTamZySmY4Zk5zQjhWQTl1N04zV0VuMjVzbVFMcG9iM1N2eVV2WGFjeTciLCJtaW50IjoiRVBqRldkZDVBdWZxU1NxZU0ycU4xeHp5YmFwQzhHNHdFR0drWnd5VER0MXYiLCJtaW5BbW91bnQiOjEwMDAwLCJleHAiOjE3OTI4NDEzOTE3NTB9.DRMN1hNHGp7vGtGMgbmqm7-dGs64HopCDc7R7uFhKFA"
        },
        "maxTimeoutSeconds": 120,
        "network": "solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp",
        "payTo": "7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7",
        "scheme": "exact"
      },
      {
        "amount": "10000",
        "asset": "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB",
        "extra": {
          "feePayer": "BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F",
          "memo": "saylor:mysql-slow-query-index-di",
          "reference": "7N5YXifYUKnkwaztT8YVtV3WEezt7MNRij4u2NvQgT9",
          "session": "eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IjdONVlYaWZZVUtua3dhenRUOFlWdFYzV0VlenQ3TU5SaWo0dTJOdlFnVDkiLCJyZWNpcGllbnQiOiI3TFNqZnJKZjhmTnNCOFZBOXU3TjNXRW4yNXNtUUxwb2IzU3Z5VXZYYWN5NyIsIm1pbnQiOiJFczl2TUZyemFDRVJtSmZyRjRIMkZZRDRLQ29Oa1kxMU1jQ2U4QmVud05ZQiIsIm1pbkFtb3VudCI6MTAwMDAsImV4cCI6MTc5Mjg0MTM5MTc1MH0.L6S8VD1PdGYQmfxLPxG6osv1GzMsGeBx7qY--uJSRFE"
        },
        "maxTimeoutSeconds": 120,
        "network": "solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp",
        "payTo": "7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7",
        "scheme": "exact"
      },
      {
        "amount": "95650",
        "asset": "So11111111111111111111111111111111111111112",
        "extra": {
          "memo": "saylor:mysql-slow-query-index-di",
          "native": true,
          "note": "Native SOL: send lamports with a system transfer, not an SPL transfer. Price is quoted live and this quote expires in 120s.",
          "quotedLamports": "98609",
          "reference": "CabksffFv3tQrzNX83fJfR6W4To1vB7JNdG6wLmfvMSw",
          "session": "eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IkNhYmtzZmZGdjN0UXJ6Tlg4M2ZKZlI2VzRUbzF2QjdKTmRHNndMbWZ2TVN3IiwicmVjaXBpZW50IjoiN0xTamZySmY4Zk5zQjhWQTl1N04zV0VuMjVzbVFMcG9iM1N2eVV2WGFjeTciLCJtaW50IjpudWxsLCJtaW5BbW91bnQiOjk1NjUwLCJleHAiOjE3OTI4NDEzOTE3NTB9.je106aihjGHas4FHG3wHg2-1A_uv5WP2_DE4OUaD0Qc",
          "solUsdPrice": 101.41
        },
        "maxTimeoutSeconds": 120,
        "network": "solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp",
        "payTo": "7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7",
        "scheme": "exact"
      }
    ],
    "description": "Diagnose slow MySQL queries - slow log, EXPLAIN types and Extra flags, composite index order, covering indexes and index-killing patterns",
    "extensions": {
      "bazaar": {
        "info": {
          "input": {
            "method": "GET",
            "type": "http"
          },
          "output": {
            "example": {
              "body": "Practical MySQL and MariaDB query tuning: enabling the slow query log, EXPLAIN and EXPLAIN ANALYZE, access types, composite index column order, covering indexes, functions on indexed columns, implicit conversions, OFFSET pagination and connection limits.",
              "c": "Self-Hosting & Infra",
              "id": "mysql-slow-query-index-diagnosis",
              "t": "Diagnose Slow MySQL Queries with EXPLAIN, Indexes and the Slow Log"
            },
            "type": "json"
          }
        },
        "schema": {
          "$schema": "https://json-schema.org/draft/2020-12/schema",
          "properties": {
            "input": {
              "additionalProperties": false,
              "properties": {
                "method": {
                  "enum": [
                    "GET"
                  ],
                  "type": "string"
                },
                "type": {
                  "const": "http",
                  "type": "string"
                }
              },
              "required": [
                "type",
                "method"
              ],
              "type": "object"
            },
            "output": {
              "properties": {
                "example": {
                  "properties": {
                    "body": {
                      "description": "Main body text",
                      "type": "string"
                    },
                    "c": {
                      "description": "Category of the guide",
                      "type": "string"
                    },
                    "id": {
                      "description": "Identifier of the record",
                      "type": "string"
                    },
                    "license": {
                      "description": "License identifier",
                      "type": "string"
                    },
                    "price": {
                      "description": "Price",
                      "type": [
                        "number",
                        "null"
                      ]
                    },
                    "t": {
                      "description": "Title of the guide",
                      "type": "string"
                    }
                  },
                  "required": [
                    "id",
                    "t",
                    "c",
                    "body"
                  ],
                  "type": "object"
                },
                "type": {
                  "const": "json",
                  "type": "string"
                }
              },
              "required": [
                "type"
              ],
              "type": "object"
            }
          },
          "required": [
            "input"
          ],
          "type": "object"
        }
      }
    },
    "iconUrl": "https://res.cloudinary.com/bdb-prod/image/upload/c_fill,ar_1:1,w_256,h_256,f_auto,q_auto/v1791811517/bazaar-icons/bc5e2b3d111ebbef.jpg",
    "lastUpdated": "2026-10-24T11:27:51.792Z",
    "quality": {
      "l30DaysTotalCalls": 2,
      "l30DaysUniquePayers": 2,
      "lastCalledAt": "2026-10-24T11:27:51.448Z"
    },
    "resource": "https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis",
    "serviceName": "Saylor Innovations Guide Library",
    "tags": [
      "mysql",
      "mariadb",
      "indexes",
      "explain",
      "performance"
    ],
    "type": "http",
    "x402Version": 2
  },
  "source": "x402_bazaar",
  "summary": "Diagnose slow MySQL queries - slow log, EXPLAIN types and Extra flags, composite index order, covering indexes and index-killing patterns"
}

What the leaf hashes

{"body":"7d1129f061bb62fbf169f7b61ff7f82f1ab085ac27041ea0180809b892ac53a0","id":120197,"kind":"listing","method":"baseline/1","observed_us":1793025617477025,"prev":null,"subject":"x402_bazaar:https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis","subject_kind":"source_record"}

Proof

Fold these into the leaf in order, hashing each sorted pair with keccak256, to reach the root of (296695 rows).

  1. 0x8b80c3515451d640f3470794ef427eefd5dc28afc93be58b788d6cfc4f7859a3
  2. 0x1a17171f6c57953bb881f7921884f901acdd16535edba8a44954d64082cf43c8
  3. 0xec8edeaed1c0336e8218bff60087f03235cf89cc929820a0e137e544a68657af
  4. 0x244a679ccff5119f1f6390dc069f1d916e38758afe54d2c660b99de9b7ed903d
  5. 0xbcabde1858dbb258e4bd79a20a42ad7656c41639ff612dd81a1279932ef32ecb
  6. 0x65b7fdae8823ad6ce04780d3a1b5254e3dab5cbddaceb853feec02443baeee8a
  7. 0xc41e3b39fdd4c1358f8469ba58d6e65ecdc28394ebadab490994cdd900343d6d
  8. 0x14d577f090368c55a0c99d41253938a351b2fd832da71fe61924e090eb72976c
  9. 0xf397b73d6779220312418da03886029f39151eedd06f9e9535153fee34e876e7
  10. 0x06e192564a33f8e5303c5b3f24c4a64be258d0a0274ef3cfee7f4221b7582bc5
  11. 0x7d887da17795602ff54a7a2d145692904e47f8d3ab035b8db85d274d00bc9bfe
  12. 0x8cb11bf3bc7d3a6f859c170a167821024ffc4758cdfd2cc96f61a3291aefb637
  13. 0xd5ec7ffaecac790d8adfa0620b0a5494758f862e3090b49e556a6ecbad2f0782
  14. 0x78ac2b34737774659a6a411f4d10b8ba570d40699d9f277321c3a32ff03d1dc9
  15. 0x7eb603d37f0f22dae1ea013e391889906ffc0139ff26e25b044bee38eec8f9b2
  16. 0x2b6e23e3624a1b66e1d2298cfbce99a93ce6b13d24a58112a71802d79c5f7a76
  17. 0xd21942ae3214eff88e08ab04884fd4b11958b51af9a0741b7668e2d07a2c56c9
  18. 0x9a9024edb5069d88a324facb310a5ce8e495214bbaa968f077bede437390194f
  19. 0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a
Day root
0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8
Chained
0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a
Published
On Arc Testnet, block 69251483: 0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae

How to check it · This row as JSON