CREATE TABLE tb_announcement (
  id int( 12 ) NOT NULL auto_increment,
  marka_id int( 4 ) NOT NULL default '0',
  model_id int( 4 ) NOT NULL default '0',
  year int( 4 ) NOT NULL default '0',
  category_id int( 4 ) NOT NULL default '0',
  korobka_id int( 4 ) NOT NULL default '0',
  kuzov_id int( 4 ) NOT NULL default '0',
  fuel_id int( 4 ) NOT NULL default '0',
  color_id int( 4 ) NOT NULL default '0',
  power int( 8 ) NOT NULL default '0',
  race int( 8 ) NOT NULL default '0',
  price int( 8 ) NOT NULL default '0',
  price_diler int( 8 ) NOT NULL default '0',
  visible tinyint( 1 ) NOT NULL default '0',
  par_01 tinyint( 1 ) NOT NULL default '0',
  par_02 tinyint( 1 ) NOT NULL default '0',
  par_03 tinyint( 1 ) NOT NULL default '0',
  par_04 tinyint( 1 ) NOT NULL default '0',
  par_05 tinyint( 1 ) NOT NULL default '0',
  par_06 tinyint( 1 ) NOT NULL default '0',
  par_07 tinyint( 1 ) NOT NULL default '0',
  par_08 tinyint( 1 ) NOT NULL default '0',
  par_09 tinyint( 1 ) NOT NULL default '0',
  par_10 tinyint( 1 ) NOT NULL default '0',
  par_11 tinyint( 1 ) NOT NULL default '0',
  par_12 tinyint( 1 ) NOT NULL default '0',
  par_13 tinyint( 1 ) NOT NULL default '0',
  par_14 tinyint( 1 ) NOT NULL default '0',
  par_15 tinyint( 1 ) NOT NULL default '0',
  par_16 tinyint( 1 ) NOT NULL default '0',
  par_17 tinyint( 1 ) NOT NULL default '0',
  par_18 tinyint( 1 ) NOT NULL default '0',
  par_19 tinyint( 1 ) NOT NULL default '0',
  par_20 tinyint( 1 ) NOT NULL default '0',
  par_21 tinyint( 1 ) NOT NULL default '0',
  par_22 tinyint( 1 ) NOT NULL default '0',
  par_23 tinyint( 1 ) NOT NULL default '0',
  par_24 tinyint( 1 ) NOT NULL default '0',
  par_25 tinyint( 1 ) NOT NULL default '0',
  par_26 tinyint( 1 ) NOT NULL default '0',
  par_27 tinyint( 1 ) NOT NULL default '0',
  par_28 tinyint( 1 ) NOT NULL default '0',
  par_29 tinyint( 1 ) NOT NULL default '0',
  par_30 tinyint( 1 ) NOT NULL default '0',
  date_build int( 10 ) NOT NULL default '0',
  expire int( 10 ) NOT NULL default '0',
  user_id int( 8 ) NOT NULL default '0',
  handler tinyint( 1 ) NOT NULL default '0',
  first tinyint( 1 ) NOT NULL default '0',
  zip int( 5 ) NOT NULL default '0',
  country int( 3 ) NOT NULL default '0',
  statistic int( 8 ) NOT NULL default '0',
  PRIMARY KEY  (id)
  ) TYPE=MyISAM;



CREATE TABLE tb_marka (
  id_marka int( 10 ) unsigned NOT NULL auto_increment,
  marka varchar( 16 ) NOT NULL default ''
  PRIMARY KEY  (id_marka)
) TYPE=MyISAM;

 97  штук марок


CREATE TABLE tb_model (
  id_model int( 10 ) unsigned NOT NULL auto_increment,
  id_marka tinyint( 4 ) NOT NULL default '0',
  model varchar( 16 ) NOT NULL default ''
  PRIMARY KEY  (id_model)
) TYPE=MyISAM;

 1500  штук моделей

<?

function get_microtime()
	{
	$mtime = microtime();
	$mtime = explode( " " ,$mtime);
	$mtime = doubleval($mtime[ 1 ] + doubleval($mtime[ 0 ]));
	return ($mtime);
	}

$old_max_execution_time = ini_set( "max_execution_time" ,  17200 );

$marka = array(
 "1 " =>  1 ,
 "2 " =>  2 ,
 "3 " =>  8 ,
 "4 " =>  45 ,
 "5 " =>  4 ,
 "6 " =>  5 ,
 "7 " =>  6 ,
 "8 " =>  40 ,
 "9 " =>  15 ,
 "10 " =>  2 ,
 "11 " =>  5 ,
 "12 " =>  6 ,
 "13 " =>  3 ,
 "14 " =>  1 ,
 "15 " =>  12 ,
 "16 " =>  16 ,
 "17 " =>  21 ,
 "18 " =>  3 ,
 "19 " =>  18 ,
 "20 " =>  25 ,
 "21 " =>  10 ,
 "22 " =>  2 ,
 "23 " =>  2 ,
 "24 " =>  13 ,
 "25 " =>  1 ,
 "26 " =>  1 ,
 "27 " =>  28 ,
 "28 " =>  30 ,
 "29 " =>  10 ,
 "30 " =>  5 ,
 "31 " =>  24 ,
 "32 " =>  2 ,
 "33 " =>  17 ,
 "34 " =>  2 ,
 "35 " =>  10 ,
 "36 " =>  20 ,
 "37 " =>  1 ,
 "38 " =>  4 ,
 "39 " =>  15 ,
 "40 " =>  9 ,
 "41 " =>  1 ,
 "42 " =>  4 ,
 "43 " =>  6 ,
 "44 " =>  2 ,
 "45 " =>  8 ,
 "46 " =>  3 ,
 "47 " =>  2 ,
 "48 " =>  2 ,
 "49 " =>  1 ,
 "50 " =>  22 ,
 "51 " =>  48 ,
 "52 " =>  4 ,
 "53 " =>  12 ,
 "54 " =>  6 ,
 "55 " =>  18 ,
 "56 " =>  2 ,
 "57 " =>  1 ,
 "58 " =>  15 ,
 "59 " =>  6 ,
 "60 " =>  3 ,
 "61 " =>  38 ,
 "62 " =>  2 ,
 "63 " =>  1 ,
 "64 " =>  2 ,
 "65 " =>  25 ,
 "66 " =>  3 ,
 "67 " =>  5 ,
 "68 " =>  12 ,
 "69 " =>  10 ,
 "70 " =>  3 ,
 "71 " =>  5 ,
 "72 " =>  29 ,
 "73 " =>  7 ,
 "74 " =>  9 ,
 "75 " =>  12 ,
 "76 " =>  20 ,
 "77 " =>  16 ,
 "78 " =>  9 ,
 "79 " =>  1 ,
 "80 " =>  14 ,
 "81 " =>  16 ,
 "82 " =>  2 ,
 "83 " =>  3 ,
 "84 " =>  24 ,
 "85 " =>  8 ,
 "86 " =>  2 ,
 "87 " =>  4 ,
 "88 " =>  4 ,
 "89 " =>  4 ,
 "90 " =>  5 ,
 "91 " =>  40 ,
 "92 " =>  18 ,
 "93 " =>  3 ,
 "94 " =>  1 
);
$marka_j =  0 ;
foreach ($marka as $id => $weight)
{
for ($i= 0 ; $i < $weight; $i++)
	{
	$marka_array[$marka_j++] = $id;
	}
}


$time_query2_1 = get_microtime();

$max =  1000 ;
echo  "$max<br><br>" ;

for ($i= 0 ; $i<$max; $i++)
{
mt_srand((double)microtime() *  1000000 );
$marka_rand_num = mt_rand( 0 , $marka_j -  1 );
shuffle($marka_array);
$marka_o = $marka_array[$marka_rand_num];

$query_ =  " SELECT * FROM tb_model WHERE `id_marka`='$marka_o' " ;
$result_ = mysql_query($query_);
echo mysql_error();

$len=mysql_num_rows($result_)- 1 ;
for ($iii= 0 ; $iii<$len; $iii++)
	{
	$row_=mysql_fetch_array($result_);
	$mass[$iii]=stripslashes($row_[ "id_model" ]);
	}

mt_srand((double)microtime() *  1000000 );
$x=mt_rand( 0 , $len);
$model_o=$mass[$x];

$query= "SELECT `id`,`year`,`race`,`price`,`kuzov_id`,`fuel_id`,`korobka_id`,`power`,`color_id`,`par_10`,`handler`,`date_build`
 FROM tb_announcement WHERE marka_id='$marka_o' AND `model_id`='$model_o'" ;
$result = mysql_query($query);

}
$time_query2_2 = get_microtime();
$diff_query2 = abs ($time_query2_2 - $time_query2_1);
$diff_query2 = sprintf( "%.6f" , $diff_query2);
echo  "<br>$diff_query2 - sec." ;
$S_ps = $max / $diff_query2;
echo  "<br>$S_ps - Serch.per.sec." ;

$max_execution_time = ini_get( "max_execution_time" );
?>