{
"request_duration_ms": 29.186960018705577,
"sum_trace_duration_ms": 14.132882817648351,
"num_traces": 38,
"traces": [
{
"type": "sql",
"start": 298470.113357648,
"end": 298470.113735671,
"duration_ms": 0.378022959921509,
"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": 298470.113937143,
"end": 298470.114125918,
"duration_ms": 0.18877501133829355,
"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": 298470.114262884,
"end": 298470.114429197,
"duration_ms": 0.16631296603009105,
"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": 298470.11455577,
"end": 298470.114798902,
"duration_ms": 0.24313200265169144,
"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": 298470.11499,
"end": 298470.115217779,
"duration_ms": 0.22777903359383345,
"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": 298470.115359781,
"end": 298470.115623401,
"duration_ms": 0.2636199933476746,
"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": 298470.115758874,
"end": 298470.115986682,
"duration_ms": 0.22780802100896835,
"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": 298470.116211983,
"end": 298470.116437617,
"duration_ms": 0.22563396487385035,
"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": 298470.116684193,
"end": 298470.116925344,
"duration_ms": 0.2411509631201625,
"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": 298470.117170841,
"end": 298470.117356061,
"duration_ms": 0.18521997844800353,
"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": 298470.11755039,
"end": 298470.117739757,
"duration_ms": 0.18936698324978352,
"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": 298470.117941614,
"end": 298470.118122604,
"duration_ms": 0.18098996952176094,
"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": 298470.118300217,
"end": 298470.118458745,
"duration_ms": 0.15852804062888026,
"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": 298470.118667762,
"end": 298470.118844116,
"duration_ms": 0.17635396216064692,
"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": 298470.120606627,
"end": 298470.121041437,
"duration_ms": 0.43481000466272235,
"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 text1 limit 101",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298470.122815335,
"end": 298470.123682155,
"duration_ms": 0.8668199880048633,
"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": 298470.12290534,
"end": 298470.123849347,
"duration_ms": 0.9440070134587586,
"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": 298470.122764718,
"end": 298470.124706442,
"duration_ms": 1.941723981872201,
"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": 298470.12397416,
"end": 298470.124894766,
"duration_ms": 0.920606020372361,
"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": 298470.126237086,
"end": 298470.127016025,
"duration_ms": 0.7789389928802848,
"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": 298470.127231438,
"end": 298470.127533256,
"duration_ms": 0.3018180141225457,
"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": 298470.127804653,
"end": 298470.128161691,
"duration_ms": 0.35703799221664667,
"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": 298470.128322029,
"end": 298470.128686902,
"duration_ms": 0.36487297620624304,
"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": 298470.128839572,
"end": 298470.129153216,
"duration_ms": 0.313644006382674,
"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": 298470.129306789,
"end": 298470.129720591,
"duration_ms": 0.41380198672413826,
"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": 298470.129895619,
"end": 298470.130089364,
"duration_ms": 0.19374501425772905,
"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": 298470.130292739,
"end": 298470.130651909,
"duration_ms": 0.35916996421292424,
"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": 298470.130828716,
"end": 298470.131168524,
"duration_ms": 0.3398080007173121,
"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": 298470.131330046,
"end": 298470.131627627,
"duration_ms": 0.2975810202769935,
"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": 298470.131775481,
"end": 298470.13207938,
"duration_ms": 0.3038989962078631,
"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": 298470.132233773,
"end": 298470.132408171,
"duration_ms": 0.17439801013097167,
"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": 298470.132598476,
"end": 298470.132986116,
"duration_ms": 0.3876399714499712,
"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": 298470.135109057,
"end": 298470.135327979,
"duration_ms": 0.2189219812862575,
"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": 298470.135684749,
"end": 298470.135952474,
"duration_ms": 0.267725030425936,
"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": 298470.136242503,
"end": 298470.136412869,
"duration_ms": 0.17036596545949578,
"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": 298470.137271152,
"end": 298470.137520547,
"duration_ms": 0.2493950305506587,
"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": 298470.137816266,
"end": 298470.138056146,
"duration_ms": 0.23987999884411693,
"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": 298470.138398893,
"end": 298470.138638472,
"duration_ms": 0.2395790070295334,
"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
}
]
}