{
"request_duration_ms": 29.16486098547466,
"sum_trace_duration_ms": 16.81075693340972,
"num_traces": 38,
"traces": [
{
"type": "sql",
"start": 209600.114688223,
"end": 209600.114986353,
"duration_ms": 0.2981300058308989,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 482, in _refresh_schemas\n for row in await internal_db.execute(\n"
],
"database": "__INTERNAL__",
"sql": "select database_name, schema_version from catalog_databases",
"params": null
},
{
"type": "sql",
"start": 209600.115182593,
"end": 209600.115467493,
"duration_ms": 0.2848999865818769,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 209600.115619247,
"end": 209600.115774727,
"duration_ms": 0.15547999646514654,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 209600.115897319,
"end": 209600.116044141,
"duration_ms": 0.14682201435789466,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 209600.116310731,
"end": 209600.11662937,
"duration_ms": 0.31863898038864136,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, 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": 209600.116807876,
"end": 209600.117007073,
"duration_ms": 0.19919697660952806,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
],
"database": "counters",
"sql": "PRAGMA schema_version",
"params": null
},
{
"type": "sql",
"start": 209600.11715166,
"end": 209600.117346838,
"duration_ms": 0.19517799955792725,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
],
"database": "ephemeral",
"sql": "PRAGMA schema_version",
"params": null
},
{
"type": "sql",
"start": 209600.117566299,
"end": 209600.117884765,
"duration_ms": 0.31846598722040653,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 776, in table_view_traced\n resolved = await datasette.resolve_table(request)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1564, in resolve_table\n table_exists = await db.table_exists(table_name)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 405, in table_exists\n results = await self.execute(\n"
],
"database": "fixtures",
"sql": "select 1 from sqlite_master where type='table' and name=?",
"params": [
"searchable"
]
},
{
"type": "sql",
"start": 209600.118106254,
"end": 209600.118278119,
"duration_ms": 0.1718649873510003,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.118480518,
"end": 209600.118689779,
"duration_ms": 0.2092609938699752,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.118949134,
"end": 209600.119318792,
"duration_ms": 0.369658024283126,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.119539519,
"end": 209600.119734722,
"duration_ms": 0.19520299974828959,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.12003091,
"end": 209600.120227106,
"duration_ms": 0.19619599333964288,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.120421815,
"end": 209600.120605682,
"duration_ms": 0.1838669995777309,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.122517177,
"end": 209600.122877606,
"duration_ms": 0.36042899591848254,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 747, in table_view\n response = await table_view_traced(datasette, request)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 800, in table_view_traced\n view_data = await table_view_data(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1185, in table_view_data\n results = await db.execute(sql, params, truncate=True, **extra_args)\n"
],
"database": "fixtures",
"sql": "select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) order by pk limit 101",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.124945231,
"end": 209600.125825699,
"duration_ms": 0.8804680255707353,
"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/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1298, in extra_count\n count_rows = list(await db.execute(count_sql, from_sql_params))\n"
],
"database": "fixtures",
"sql": "select count(*) from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search))",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.124979796,
"end": 209600.126002357,
"duration_ms": 1.0225609876215458,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, 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": "searchable",
"t": "table"
}
},
{
"type": "sql",
"start": 209600.12613933,
"end": 209600.127345671,
"duration_ms": 1.2063409958500415,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 540, 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": "searchable"
}
},
{
"type": "sql",
"start": 209600.125190324,
"end": 209600.128083818,
"duration_ms": 2.8934940055478364,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1532, in extra_view_definition\n return await db.get_view_definition(table_name)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 550, 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 530, 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": "searchable",
"t": "view"
}
},
{
"type": "sql",
"start": 209600.126694443,
"end": 209600.128555683,
"duration_ms": 1.861240016296506,
"traceback": [
" File \"plugins/my_plugin.py\", line 167, 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 138, in get_columns\n await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select * from (select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.128720882,
"end": 209600.129122517,
"duration_ms": 0.4016350139863789,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 160, 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 138, in get_columns\n await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select * from (select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.129381963,
"end": 209600.129731852,
"duration_ms": 0.349889014614746,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, 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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.129908545,
"end": 209600.13036734,
"duration_ms": 0.4587949952110648,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select text1 as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.130559306,
"end": 209600.130981083,
"duration_ms": 0.421776989242062,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select text2 as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.131159507,
"end": 209600.131545356,
"duration_ms": 0.3858490090351552,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select [name with . and spaces] as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.131701503,
"end": 209600.131881204,
"duration_ms": 0.17970098997466266,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 459, 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 138, in get_columns\n await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select * from (select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.132033016,
"end": 209600.132375905,
"duration_ms": 0.34288899041712284,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select date(pk) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where pk glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.132533027,
"end": 209600.132860247,
"duration_ms": 0.3272199828643352,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select date(text1) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where text1 glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.13303091,
"end": 209600.133357612,
"duration_ms": 0.3267020219936967,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select date(text2) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where text2 glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.133542775,
"end": 209600.13388037,
"duration_ms": 0.337595003657043,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select date([name with . and spaces]) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where [name with . and spaces] glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.134047306,
"end": 209600.134219442,
"duration_ms": 0.1721360022202134,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 303, 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 138, in get_columns\n await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select * from (select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.134389219,
"end": 209600.134743554,
"duration_ms": 0.354335003066808,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n"
],
"database": "fixtures",
"sql": "select distinct json_type(pk)\n from (select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) )\n where pk is not null and pk != ''",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 209600.136832701,
"end": 209600.137030253,
"duration_ms": 0.19755199900828302,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.137274984,
"end": 209600.137487714,
"duration_ms": 0.21272999583743513,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1280, 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 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin.py\", line 90, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n"
],
"database": "_memory",
"sql": "select 3 * 5",
"params": null
},
{
"type": "sql",
"start": 209600.137785777,
"end": 209600.137958623,
"duration_ms": 0.17284599016420543,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1367, in _asset_urls\n hook = await await_me_maybe(hook)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin.py\", line 47, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n"
],
"database": "_memory",
"sql": "select 3 * 5",
"params": null
},
{
"type": "sql",
"start": 209600.138761373,
"end": 209600.138970668,
"duration_ms": 0.20929498714394867,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.139181909,
"end": 209600.139483587,
"duration_ms": 0.3016779955942184,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
},
{
"type": "sql",
"start": 209600.139884697,
"end": 209600.140075435,
"duration_ms": 0.19073797739110887,
"traceback": [
" File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n",
" File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n",
" File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n"
],
"database": "__INTERNAL__",
"sql": "select 1 + 1",
"params": null
}
]
}