<p>_getAllPets1: 50</p><p>_getAllPets:0</p>object(CSqlDataProvider)#509 (12) {
  ["_e":"CComponent":private]=>
  NULL
  ["_m":"CComponent":private]=>
  NULL
  ["_id":"CDataProvider":private]=>
  NULL
  ["_data":"CDataProvider":private]=>
  NULL
  ["_keys":"CDataProvider":private]=>
  NULL
  ["_totalItemCount":"CDataProvider":private]=>
  int(50)
  ["_sort":"CDataProvider":private]=>
  NULL
  ["_pagination":"CDataProvider":private]=>
  bool(false)
  ["db"]=>
  NULL
  ["sql"]=>
  string(659) "select t.id as uid,t.state as ustate,t.city as ucity,t.type,t.suburb as usuburb,t.verifiedemail,t.verifiedphoto,( 6371 * acos(cos( radians(-25.466592) )
					* cos( radians( t1.latitude ) )
					* cos( radians( t1.longitude ) - radians(122.17701) )
					+ sin( radians(-25.466592) )
					* sin( radians( t1.latitude ) )
					)
				) AS distance,t1.* from tbl_profile t1 left join tbl_user t on t1.userid = t.id WHERE 1=1 AND (find_in_set(3,t1.pettypes) > 0) AND NOT (find_in_set(353,t1.breeds) > 0) AND (find_in_set(11,t1.services) > 0) AND t.active = 1 AND t1.active = 1 and t1.reviewed = 1 ORDER BY distance, t1.paid DESC, t1.regodate DESC, t1.id DESC"
  ["params"]=>
  array(0) {
  }
  ["keyField"]=>
  string(2) "id"
}