임시 테이블에 저장

CREATE TABLE cache_results (

    key_hash VARCHAR(255) PRIMARY KEY,

    result_data TEXT,

    created_at DATETIME DEFAULT NOW()

);

SELECT result_data

FROM cache_results

WHERE key_hash = 'some_hash_value'

  AND created_at > NOW() - INTERVAL 5 MINUTE;

-- Run your expensive query

-- Then cache it

INSERT INTO cache_results (key_hash, result_data)

VALUES ('some_hash_value', '...result...')

ON DUPLICATE KEY UPDATE result_data = VALUES(result_data), created_at = NOW();