We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

[SOLVED]Will the following code cause bad table scan?

mia0x75 Feb '14

Created Feb '14	Last Reply None	Replies 0	Views 555	Votes 0

mia0x75 29.1k

Feb '14

$id = $_GET['id'];
$where  = 'id = :id:';
$types  = ['id' => Column::BIND_PARAM_INT];
$params = ['id' => $id];

$member = Members::findFirst([$where, 'bind' => $params, 'bindTypes' => $types]);

it will use pk seek, thanks.