test/test_149/model.bin

a:1:{i:0;a:10:{i:0;a:3:{s:8:"sphinxql";s:18:"select * from test";s:10:"total_rows";i:7;s:4:"rows";a:7:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:2:"20";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:3;a:2:{s:2:"id";s:1:"4";s:3:"idd";s:2:"40";}i:4;a:2:{s:2:"id";s:1:"5";s:3:"idd";s:2:"50";}i:5;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:6;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:1;a:3:{s:8:"sphinxql";s:40:"select * from test where id IN (1,3,6,7)";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:2;a:3:{s:8:"sphinxql";s:45:"select * from test where id IN (1,1000,3,6,7)";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:3;a:3:{s:8:"sphinxql";s:45:"select * from test where id IN (1000,1,3,6,7)";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:4;a:3:{s:8:"sphinxql";s:45:"select * from test where id IN (1,3,6,1000,7)";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:5;a:3:{s:8:"sphinxql";s:76:"select * from test where idd IN (875,321,60,1010,20,457,20,311,20,750,70,10)";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:2:"20";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:6;a:3:{s:8:"sphinxql";s:72:"select * from test where idd NOT IN (60,1010,20,457,20,311,20,750,70,10)";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:1;a:2:{s:2:"id";s:1:"4";s:3:"idd";s:2:"40";}i:2;a:2:{s:2:"id";s:1:"5";s:3:"idd";s:2:"50";}}}i:7;a:2:{s:8:"sphinxql";s:37:"set global @attr_filter=(10,20,30,70)";s:14:"total_affected";i:0;}i:8;a:3:{s:8:"sphinxql";s:44:"select * from test where idd IN @attr_filter";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"10";}i:1;a:2:{s:2:"id";s:1:"2";s:3:"idd";s:2:"20";}i:2;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"30";}i:3;a:2:{s:2:"id";s:1:"7";s:3:"idd";s:2:"70";}}}i:9;a:3:{s:8:"sphinxql";s:48:"select * from test where idd NOT IN @attr_filter";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:2:"id";s:1:"4";s:3:"idd";s:2:"40";}i:1;a:2:{s:2:"id";s:1:"5";s:3:"idd";s:2:"50";}i:2;a:2:{s:2:"id";s:1:"6";s:3:"idd";s:2:"60";}}}}}