{
  "request_duration_ms": 27.861788000336674,
  "sum_trace_duration_ms": 25.818453999818303,
  "num_traces": 44,
  "traces": [
    {
      "type": "sql",
      "start": 3115.091437543,
      "end": 3115.091711362,
      "duration_ms": 0.2738189996307483,
      "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": 3115.091979211,
      "end": 3115.092226874,
      "duration_ms": 0.2476630002092861,
      "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": 3115.092413248,
      "end": 3115.092632896,
      "duration_ms": 0.21964799998386297,
      "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": 3115.092757845,
      "end": 3115.092954484,
      "duration_ms": 0.19663900002342416,
      "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": 3115.093084344,
      "end": 3115.093230473,
      "duration_ms": 0.14612899985877448,
      "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": 3115.093359379,
      "end": 3115.093508103,
      "duration_ms": 0.14872400015519815,
      "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": 3115.093762648,
      "end": 3115.094057394,
      "duration_ms": 0.2947460002360458,
      "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": 3115.094305114,
      "end": 3115.094660279,
      "duration_ms": 0.355165000200941,
      "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": 3115.094352942,
      "end": 3115.09484716,
      "duration_ms": 0.4942179998579377,
      "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": 3115.095049643,
      "end": 3115.095259102,
      "duration_ms": 0.2094589999614982,
      "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": 3115.095452507,
      "end": 3115.095613631,
      "duration_ms": 0.16112399998746696,
      "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": 3115.095791064,
      "end": 3115.095954429,
      "duration_ms": 0.16336499993485631,
      "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": 3115.096140115,
      "end": 3115.096291414,
      "duration_ms": 0.1512990002083825,
      "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": 3115.096468584,
      "end": 3115.096617616,
      "duration_ms": 0.1490320000812062,
      "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": 3115.096798155,
      "end": 3115.096956047,
      "duration_ms": 0.15789199960636324,
      "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": 3115.098715663,
      "end": 3115.099028422,
      "duration_ms": 0.31275900028049364,
      "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 pk desc limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 3115.099720087,
      "end": 3115.100155511,
      "duration_ms": 0.43542399998841574,
      "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": 3115.099688517,
      "end": 3115.100597523,
      "duration_ms": 0.9090060002563405,
      "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": 3115.099745855,
      "end": 3115.10111657,
      "duration_ms": 1.3707150001209811,
      "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": 3115.100470244,
      "end": 3115.10174208,
      "duration_ms": 1.2718359998871165,
      "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": 3115.099637808,
      "end": 3115.102027906,
      "duration_ms": 2.3900979999780247,
      "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": 3115.101004028,
      "end": 3115.102469174,
      "duration_ms": 1.4651460001005034,
      "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": 3115.10138199,
      "end": 3115.102995459,
      "duration_ms": 1.6134689999489638,
      "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": 3115.101939033,
      "end": 3115.103223423,
      "duration_ms": 1.2843900003645103,
      "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": 3115.102645524,
      "end": 3115.103795512,
      "duration_ms": 1.1499880001792917,
      "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": 3115.103353782,
      "end": 3115.104086425,
      "duration_ms": 0.7326429999920947,
      "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": 3115.103954723,
      "end": 3115.104844208,
      "duration_ms": 0.8894850002434396,
      "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": 3115.104209685,
      "end": 3115.105034771,
      "duration_ms": 0.8250860000771354,
      "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": 3115.105001876,
      "end": 3115.105839831,
      "duration_ms": 0.8379549999517621,
      "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": 3115.105149903,
      "end": 3115.106051163,
      "duration_ms": 0.9012599998641235,
      "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": 3115.105515017,
      "end": 3115.106585006,
      "duration_ms": 1.0699889999159495,
      "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": 3115.10617395,
      "end": 3115.106811848,
      "duration_ms": 0.6378979996952694,
      "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": 3115.10675267,
      "end": 3115.107246517,
      "duration_ms": 0.4938470001434325,
      "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": 3115.1060081,
      "end": 3115.10754852,
      "duration_ms": 1.5404199998556578,
      "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": 3115.107724537,
      "end": 3115.108016803,
      "duration_ms": 0.29226599963294575,
      "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": 3115.108605775,
      "end": 3115.108782255,
      "duration_ms": 0.1764799999364186,
      "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": 3115.11101288,
      "end": 3115.111618367,
      "duration_ms": 0.6054870000298251,
      "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": 3115.111785053,
      "end": 3115.111974434,
      "duration_ms": 0.1893809999273799,
      "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": 3115.112112222,
      "end": 3115.112268832,
      "duration_ms": 0.15660999997635372,
      "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": 3115.113172418,
      "end": 3115.113355688,
      "duration_ms": 0.18326999997952953,
      "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": 3115.113647858,
      "end": 3115.113836944,
      "duration_ms": 0.18908599986389163,
      "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": 3115.114642646,
      "end": 3115.11484352,
      "duration_ms": 0.20087399980184273,
      "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": 3115.115072795,
      "end": 3115.11523227,
      "duration_ms": 0.15947500014590332,
      "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": 3115.115513614,
      "end": 3115.115678803,
      "duration_ms": 0.16518899974471424,
      "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
    }
  ]
}