{
  "request_duration_ms": 26.390191999780654,
  "sum_trace_duration_ms": 21.215725000729435,
  "num_traces": 44,
  "traces": [
    {
      "type": "sql",
      "start": 4643.543711544,
      "end": 4643.544061959,
      "duration_ms": 0.3504149999571382,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 376, in _refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "_internal",
      "sql": "select database_name, schema_version from databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.544295036,
      "end": 4643.544501551,
      "duration_ms": 0.2065150001726579,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 381, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.544635387,
      "end": 4643.544785059,
      "duration_ms": 0.1496719996794127,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 381, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_internal",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.544922923,
      "end": 4643.545086602,
      "duration_ms": 0.1636790002521593,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 381, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.545202659,
      "end": 4643.545349633,
      "duration_ms": 0.14697400001750793,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 381, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "fixtures2",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.54546128,
      "end": 4643.545602136,
      "duration_ms": 0.14085599923419068,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 89, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 366, in refresh_schemas\n    await self._refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 381, in _refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "extra_database",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.545859751,
      "end": 4643.546079709,
      "duration_ms": 0.21995800034346757,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 551, in get_canned_queries\n    more_queries = await await_me_maybe(more_queries)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 150, in inner\n    await datasette.get_database(database).execute(\"select 1 + 1\")\n"
      ],
      "database": "fixtures",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.546330041,
      "end": 4643.546579483,
      "duration_ms": 0.24944199958554236,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 476, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "roadside_attractions",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 4643.546376806,
      "end": 4643.546718819,
      "duration_ms": 0.3420129996811738,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/base_events.py\", line 1909, in _run_once\n    handle._run()\n",
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 336, in table_exists\n    results = await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "roadside_attractions"
      ]
    },
    {
      "type": "sql",
      "start": 4643.547126127,
      "end": 4643.547318402,
      "duration_ms": 0.19227499979024287,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.547510134,
      "end": 4643.54772569,
      "duration_ms": 0.2155560005121515,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.547958137,
      "end": 4643.548129034,
      "duration_ms": 0.17089700031647226,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.548307737,
      "end": 4643.548460667,
      "duration_ms": 0.152929999785556,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.548625866,
      "end": 4643.548852689,
      "duration_ms": 0.2268230000481708,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.549059865,
      "end": 4643.549232757,
      "duration_ms": 0.17289199968217872,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.550834411,
      "end": 4643.55112281,
      "duration_ms": 0.2883990000555059,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 361, in get\n    response_or_template_contexts = await self.data(request, **data_kwargs)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 158, in data\n    return await self._data_traced(request, default_labels, _next, _size)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 479, in _data_traced\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "fixtures",
      "sql": "select pk, name, address, url, latitude, longitude from roadside_attractions order by latitude limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 4643.551718666,
      "end": 4643.552253079,
      "duration_ms": 0.5344130004232284,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 165, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.551765839,
      "end": 4643.552444877,
      "duration_ms": 0.6790380002712482,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 161, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.551820638,
      "end": 4643.552649983,
      "duration_ms": 0.8293450000564917,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 304, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.551794259,
      "end": 4643.5528059,
      "duration_ms": 1.011640999422525,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 460, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 139, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, url, latitude, longitude from roadside_attractions ) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.552774605,
      "end": 4643.553410676,
      "duration_ms": 0.6360709994623903,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(pk)\n                from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n                where pk is not null and pk != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.55260367,
      "end": 4643.553623586,
      "duration_ms": 1.0199159996773233,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select pk as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.552935968,
      "end": 4643.553779808,
      "duration_ms": 0.8438400000159163,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(pk) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where pk glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.553950945,
      "end": 4643.554274656,
      "duration_ms": 0.32371100041928,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(name) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where name glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.553741778,
      "end": 4643.555039034,
      "duration_ms": 1.2972560007256106,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select name as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.554445809,
      "end": 4643.555228278,
      "duration_ms": 0.7824690001143608,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(address) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where address glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.555347182,
      "end": 4643.556122368,
      "duration_ms": 0.7751859993732069,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(url) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where url glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.5551853,
      "end": 4643.556478833,
      "duration_ms": 1.2935330005348078,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select address as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.55643546,
      "end": 4643.557027465,
      "duration_ms": 0.5920049998167087,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(latitude) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where latitude glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.556659018,
      "end": 4643.557260102,
      "duration_ms": 0.6010840006638318,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select url as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.557221676,
      "end": 4643.557653962,
      "duration_ms": 0.43228599952271907,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 475, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(longitude) from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where longitude glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.55606622,
      "end": 4643.55816229,
      "duration_ms": 2.0960700003342936,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(latitude)\n                from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n                where latitude is not null and latitude != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.557540174,
      "end": 4643.558722891,
      "duration_ms": 1.1827170001197373,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select latitude as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.558537686,
      "end": 4643.559177528,
      "duration_ms": 0.6398420000550686,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 319, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(longitude)\n                from (select pk, name, address, url, latitude, longitude from roadside_attractions )\n                where longitude is not null and longitude != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.558951309,
      "end": 4643.559480589,
      "duration_ms": 0.5292799996823305,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n    self._context.run(self._callback, *self._args)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 179, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 777, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select longitude as value, count(*) as n from (\n                    select pk, name, address, url, latitude, longitude from roadside_attractions \n                ) where value is not null\n                group by value\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 4643.560031677,
      "end": 4643.560176011,
      "duration_ms": 0.14433400065172464,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.56200286,
      "end": 4643.562189909,
      "duration_ms": 0.18704900048760464,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 779, in extra_template\n    \"view_definition\": await db.get_view_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 476, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "roadside_attractions",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 4643.562339534,
      "end": 4643.562551361,
      "duration_ms": 0.21182700038480107,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 463, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 456, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where name = :n and type=:t",
      "params": {
        "n": "roadside_attractions",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 4643.562742556,
      "end": 4643.56294045,
      "duration_ms": 0.1978939999389695,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/base.py\", line 463, in get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 780, in extra_template\n    \"table_definition\": await db.get_table_definition(table_name),\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 466, in get_table_definition\n    await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null",
      "params": {
        "n": "roadside_attractions"
      }
    },
    {
      "type": "sql",
      "start": 4643.56388356,
      "end": 4643.564050162,
      "duration_ms": 0.16660199980833568,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1023, in render_template\n    extra_script = await await_me_maybe(extra_script)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 89, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.564390594,
      "end": 4643.564616194,
      "duration_ms": 0.22560000070370734,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1109, in _asset_urls\n    hook = await await_me_maybe(hook)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 46, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.565466455,
      "end": 4643.565660011,
      "duration_ms": 0.1935559994308278,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.565882328,
      "end": 4643.56609149,
      "duration_ms": 0.20916199991916073,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 4643.566440091,
      "end": 4643.566630793,
      "duration_ms": 0.19070199959969614,
      "traceback": [
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 684, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 111, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 120, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    }
  ]
}