=== DIAGNOSTIK SEARCH ===

DB Connected: OK

[1] Jumlah produk di tabel menus: 18

[2] Tabel ai_search_logs: ADA ✓
    - id (int(11)) NOT NULL
    - query (varchar(255)) NOT NULL
    - results_count (int(11)) NULL
    - customer_user_id (int(11)) NULL
    - created_at (datetime) NULL

[3] Query search 'pupuk': 5 hasil
    -> [1] Pupuk Urea 50 Kilo Gram (Pupuk)
    -> [4] Pupuk NPK 50 Kilo Gram (Pupuk)
    -> [5] Electric Sprayer 13.8L HLP 3013 (Alat Semprot)
    -> [9] Hand Sprayer CBA (Alat Semprot)
    -> [12] Pupuk Kalsium Malika 1 Kilo Gram (Pupuk)

[4] Kolom tabel menus:
    - id (int(11))
    - name (varchar(100))
    - category (varchar(100))
    - description (text)
    - stock (int(11))
    - price (int(11))
    - image (varchar(255))

[5] Full query search_ai.php 'pupuk': 7 hasil
    -> Pupuk Kalsium Malika 1 Kilo Gram (relevance=3)
    -> Pupuk MKP Cair MKP GOLD 1 Liter (relevance=3)
    -> Pupuk NPK 50 Kilo Gram (relevance=3)
    -> pupuk padi (relevance=3)
    -> Pupuk Urea 50 Kilo Gram (relevance=3)
    -> Electric Sprayer 13.8L HLP 3013 (relevance=1)
    -> Hand Sprayer CBA (relevance=1)

[6] Simulasi JSON output search_ai.php:
[
    {
        "id": 12,
        "name": "Pupuk Kalsium Malika 1 Kilo Gram",
        "category": "Pupuk",
        "price": 35000,
        "image": "Gambar WhatsApp 2025-05-17 pukul 15.10.55_b0134aa6.jpg"
    },
    {
        "id": 14,
        "name": "Pupuk MKP Cair MKP GOLD 1 Liter",
        "category": "Pupuk",
        "price": 85000,
        "image": "Gambar WhatsApp 2025-05-17 pukul 15.10.56_0dd2c136.jpg"
    },
    {
        "id": 4,
        "name": "Pupuk NPK 50 Kilo Gram",
        "category": "Pupuk",
        "price": 140000,
        "image": "npk plus.jpg"
    },
    {
        "id": 19,
        "name": "pupuk padi",
        "category": "pupuk",
        "price": 111111,
        "image": "default.jpg"
    },
    {
        "id": 1,
        "name": "Pupuk Urea 50 Kilo Gram",
        "category": "Pupuk",
        "price": 120000,
        "image": "1539575734-932-583504.jpg"
    },
    {
        "id": 5,
        "name": "Electric Sprayer 13.8L HLP 3013",
        "category": "Alat Semprot",
        "price": 573500,
        "image": "41881ebcc1804ea73d36de73c7e3de24.jpeg"
    },
    {
        "id": 9,
        "name": "Hand Sprayer CBA",
        "category": "Alat Semprot",
        "price": 290000,
        "image": "Gambar WhatsApp 2025-05-17 pukul 15.10.54_d78f68c8.jpg"
    }
]

=== SELESAI ===