$products = $this->Product->find('all', array(
  'fields' => array('id'),
  'conditions' => array('title in' => explode(" ", $query))
)->toArray();
 
$ids = array();
foreach ($products as $product) {
  $ids[] = $product['id'];
}
 
$this->paginate = [
  'limit' => 10,
  'conditions' => array(
    'id IN' => array_unique($ids) //to eliminate duplicate ids
  ),
];
 
$products = $this->paginate('Products');
$this->set('products', $products');