Результат настоящего запуска PHP с PDO_SQLITE. Собственный учебный файл базы после наблюдений удалён; полезная выгрузка сохранена.
Полученные строки и наблюдения
{
"selected_orders": [
{
"id": 101,
"title": "Кабель",
"created_at": "2026-11-02",
"total_cents": 1500
},
{
"id": 103,
"title": "Хомут",
"created_at": "2026-11-08",
"total_cents": 800
},
{
"id": 106,
"title": "Коробка",
"created_at": "2026-11-09",
"total_cents": 2000
}
],
"before_plan": [
{
"id": 4,
"parent": 0,
"notused": 216,
"detail": "SCAN orders"
},
{
"id": 24,
"parent": 0,
"notused": 0,
"detail": "USE TEMP B-TREE FOR ORDER BY"
}
],
"after_plan": [
{
"id": 5,
"parent": 0,
"notused": 50,
"detail": "SEARCH orders USING INDEX order_window (status=? AND created_at>? AND created_at<?)"
}
],
"artifact": {
"selection": {
"status": "OPEN",
"from": "2026-11-01",
"until": "2026-12-01",
"limit": 3
},
"orders": [
{
"id": 101,
"title": "Кабель",
"created_at": "2026-11-02",
"total_cents": 1500
},
{
"id": 103,
"title": "Хомут",
"created_at": "2026-11-08",
"total_cents": 800
},
{
"id": 106,
"title": "Коробка",
"created_at": "2026-11-09",
"total_cents": 2000
}
],
"total_cents": 4300,
"plan_comparison": {
"before_uses_owned_index": false,
"after_uses_owned_index": true
},
"statement": {
"busy_prepared": false,
"busy_after_first_fetch": true,
"busy_after_close": false,
"select_readonly": true,
"update_readonly": false
}
},
"plan_scope": "Observed on the stated SQLite version; no timing or cross-version plan-text promise"
}
result.json содержит те же данные.