update AWS_SEARCH_SESSION,AWS_SEARCH_TERM,AWS_SEARCH_TERM_COUNTER
set
AWS_SEARCH_TERM_COUNTER.counter=AWS_SEARCH_TERM_COUNTER.counter+:inc,
AWS_SEARCH_SESSION.end=now()
where AWS_SEARCH_TERM_COUNTER.searchTermId=AWS_SEARCH_TERM.id and
AWS_SEARCH_TERM.term=:term and AWS_SEARCH_SESSION.id=:sessionId
and
AWS_SEARCH_TERM_COUNTER.userId=:uid and
AWS_SEARCH_SESSION.id=AWS_SEARCH_TERM_COUNTER.sessionId and
AWS_SEARCH_TERM_COUNTER.refinementType=:refinementType