sth1 = prepare select sth1->execute sth2 = prepare select sth2->execute sth3 = prepare insert while () { sth1->fetch sth2->fetch sth3->execute } sth1->finish sth2->finish sth3->finish