Исккусство

  function getmicrotime()
    { list($usec, $sec) = explode(" ",microtime()); return ((float)$usec + (float)$sec); }

  $time_start = getmicrotime();
  mysql_connect("localhost:/var/lib/mysql/mysql.sock", "root", "");
  echo getmicrotime()-$time_start."<br>";
  $time_start = getmicrotime();
  mysql_close();
  echo getmicrotime()-$time_start;

SELECT SQL_CALC_FOUND_ROWS 
k.id as id,
concat(DATE_FORMAT(k.AGREEMENT_CONCLUSION_DATE, '%y' ) , '.', f.num, '.') as AGREEMENT_PRENUM,
concat(DATE_FORMAT(k.AGREEMENT_CONCLUSION_DATE, '%y' ) , '.', f.num, '.',k.AGREEMENT_NUM) as AGREEMENT_NUM_REAL,
AGREEMENT_NUM as AGREEMENT_NUM,
dkt.name as dktname,
AGREEMENT_CONCLUSION_DATE as AGREEMENT_CONCLUSION_DATE,
AGREEMENT_INDATE as AGREEMENT_INDATE,
concat(cust.surname,' ',cust.firname,' ',cust.patname) as customer,
concat(stud.surname,' ',stud.firname,' ',stud.patname) as student,
f.name as fname,
qualif.name as qname,
PRICE as PRICE,
sum(pay.payment)/(count(*)/count(distinct pay.id)) as s,
convert(sum(pay.payment)/(count(*)/count(distinct pay.id))/price*100,unsigned) as ss,
PRICE2 as PRICE2,
sum(pay2.payment)/(count(*)/count(distinct pay2.id)) as s2,
convert(sum(pay2.payment)/(count(*)/count(distinct pay2.id))/price2*100,unsigned) as ss2,
PRICE3 as PRICE3,
sum(pay3.payment)/(count(*)/count(distinct pay3.id)) as s3,
convert(sum(pay3.payment)/(count(*)/count(distinct pay3.id))/price3*100,unsigned) as ss3,
PRICE4 as PRICE4,
sum(pay4.payment)/(count(*)/count(distinct pay4.id)) as s4,
convert(sum(pay4.payment)/(count(*)/count(distinct pay4.id))/price4*100,unsigned) as ss4,
PRICE5 as PRICE5,
sum(pay5.payment)/(count(*)/count(distinct pay5.id)) as s5,
convert(sum(pay5.payment)/(count(*)/count(distinct pay5.id))/price5*100,unsigned) as ss5 

    FROM 
 dtpeople cust,
 dicorgunit f,
 dtpeople stud,
 dicqualif qualif,
 dickontracttype dkt,
 kontracts k
 left join
 payments pay
 on pay.tokontract=k.id and pay.kontractYear=1
 left join
 payments pay2
 on pay2.tokontract=k.id and pay2.kontractYear=2
 left join
 payments pay3
 on pay3.tokontract=k.id and pay3.kontractYear=3
 left join
 payments pay4
 on pay4.tokontract=k.id and pay4.kontractYear=4
 left join
 payments pay5
 on pay5.tokontract=k.id and pay5.kontractYear=5
 
      WHERE 
cust.id=toPeopleCust and
 stud.id=toPeopleStud and toDicQualif=qualif.id and qualif.toorgunit=f.id
 and AGREEMENT_TYPE=dkt.id
 and ((concat(stud.surname,' ',stud.firname,' ',stud.patname)) like "с%") 
      GROUP BY k.id 
ORDER BY AGREEMENT_PRENUM ASC, AGREEMENT_NUM ASC