$sth = $self->param('dbh_shopping')->prepare(qq{
    SELECT
      ... a somewhat large query ...
    WHERE catalogId = ?
    LIMIT ?, ?
  });
  my $start_item = ($self->query->param('startitem') > 0)
    ? $self->query->param('startitem') - 1 : 0;