my $sth = $dbh->prepare_cached( "SELECT bar2 FROM foo WHERE bar1 = ?" );

$sth->execute( 2 );