CTE / Window query for efficient current, prev, next id row retrieval

curr_prev_next.sql

WITH linked AS (
  SELECT id,
         lead(id) OVER(ORDER BY id DESC) AS next_id,
         lag(id)  OVER(ORDER BY id ASC)  AS prev_id
  FROM snippets
  WHERE snippets.mission_id = $1
)
SELECT snippets.* FROM snippets, linked WHERE linked.id = $2 AND snippets.id = linked.next_id;