Особенности OPDS???

/usr/syno/mysql/libexec/mysqld, Version: 5.1.49-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                 Id Command    Argument
# Time: 140316 13:19:11
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 13.523530  Lock_time: 0.027124 Rows_sent: 23  Rows_examined: 281148
use sopds;
SET timestamp=1394965151;
select UPPER(substring(trim(title),1,2)) as letters, count(*) as cnt from books where substring(trim(title),1,1)='Ж' and avail!=0  and doublicat=0  group by 1 order by 1;
# Time: 140316 13:19:31
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 12.218007  Lock_time: 0.000700 Rows_sent: 15  Rows_examined: 281132
SET timestamp=1394965171;
select UPPER(substring(trim(title),1,3)) as letters, count(*) as cnt from books where substring(trim(title),1,2)='ЖЕ' and avail!=0  and doublicat=0  group by 1 order by 1;
# Time: 140316 13:24:30
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 218.909301  Lock_time: 0.027344 Rows_sent: 4  Rows_examined: 1906052
SET timestamp=1394965470;
select 1 s, count(avail) from books where avail!=0 and doublicat=0 and registerdate>now()-INTERVAL 7 DAY union all select 2 s, count(*) from (select b.author_id from bauthors b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.author_id) a1 union all select 3 s, count(*) from (select b.genre_id from bgenres b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.genre_id) a2 union all select 4 s, count(*) from (select b.ser_id from bseries b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.ser_id) a3 order by s;
# Time: 140316 13:25:33
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 217.250989  Lock_time: 0.003937 Rows_sent: 4  Rows_examined: 1906052
SET timestamp=1394965533;
select 1 s, count(avail) from books where avail!=0 and doublicat=0 and registerdate>now()-INTERVAL 7 DAY union all select 2 s, count(*) from (select b.author_id from bauthors b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.author_id) a1 union all select 3 s, count(*) from (select b.genre_id from bgenres b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.genre_id) a2 union all select 4 s, count(*) from (select b.ser_id from bseries b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.ser_id) a3 order by s;
# Time: 140316 13:31:07
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 235.392630  Lock_time: 0.026101 Rows_sent: 4  Rows_examined: 1906052
SET timestamp=1394965867;
select 1 s, count(avail) from books where avail!=0 and doublicat=0 and registerdate>now()-INTERVAL 7 DAY union all select 2 s, count(*) from (select b.author_id from bauthors b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.author_id) a1 union all select 3 s, count(*) from (select b.genre_id from bgenres b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.genre_id) a2 union all select 4 s, count(*) from (select b.ser_id from bseries b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.ser_id) a3 order by s;
# Time: 140316 13:32:18
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 241.788583  Lock_time: 0.001822 Rows_sent: 4  Rows_examined: 1906052
SET timestamp=1394965938;
select 1 s, count(avail) from books where avail!=0 and doublicat=0 and registerdate>now()-INTERVAL 7 DAY union all select 2 s, count(*) from (select b.author_id from bauthors b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.author_id) a1 union all select 3 s, count(*) from (select b.genre_id from bgenres b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.genre_id) a2 union all select 4 s, count(*) from (select b.ser_id from bseries b left join books c on b.book_id=c.book_id where c.avail!=0 and registerdate>now()-INTERVAL 7 DAY group by b.ser_id) a3 order by s;
# Time: 140316 13:34:32
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 9.076760  Lock_time: 0.000758 Rows_sent: 45  Rows_examined: 166085
SET timestamp=1394966072;
select SQL_CALC_FOUND_ROWS a.ser_id, a.ser, count(*) as cnt from series a, bseries b, books c where a.ser_id=b.ser_id and b.book_id=c.book_id and TRIM(a.ser) like 'ГЕ%' and c.avail!=0  and c.doublicat=0  group by 1,2 order by 2 limit 0,60;
# Time: 140316 13:35:19
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 8.423904  Lock_time: 0.000701 Rows_sent: 60  Rows_examined: 166517
SET timestamp=1394966119;
select SQL_CALC_FOUND_ROWS a.ser_id, a.ser, count(*) as cnt from series a, bseries b, books c where a.ser_id=b.ser_id and b.book_id=c.book_id and TRIM(a.ser) like 'ГА%' and c.avail!=0  and c.doublicat=0  group by 1,2 order by 2 limit 0,60;
# Time: 140316 13:36:33
# User@Host: sopds[sopds] @ localhost [127.0.0.1]
# Query_time: 7.683306  Lock_time: 0.000884 Rows_sent: 5  Rows_examined: 281112
SET timestamp=1394966193;
select 1 s, count(avail) from books where avail!=0 and doublicat=0 union all select 2 s, count(author_id) from authors union all select 3 s, count(cat_id) from catalogs union all select 4 s, count(genre_id) from genres union all select 5 s, count(ser_id) from series order by s;