Гиперион

Страница сгенерирована за 0.1507 сек.
 # # # # # # # # # # QUERYES_LIST CL # # # # # # # # # # 

0.00024 - (SELECT) * FROM libavtor WHERE BookId='411061' ORDER BY RAND();
0.00025 - (SELECT) * FROM libbook WHERE BookId='411061';
0.00012 - (SELECT) cover FROM libcache WHERE BookId='411061';
0.00014 - (SELECT) AvtorId FROM libavtor WHERE BookId='411061';
0.00016 - (SELECT) * FROM libseq WHERE BookId='411061' AND level < 100;
0.00014 - (SELECT) PubId,PubName FROM libpub LEFT JOIN libpubname USING(PubId) WHERE BookId='411061' LIMIT 1;
0.00016 - (SELECT) CityId,CityName FROM libcity LEFT JOIN libcityname USING(CityId) WHERE BookId='411061' LIMIT 1;
0.00010 - (SELECT) * FROM libseq WHERE BookId='411061' AND level > 100;
0.00048 - (SELECT) BookId FROM libavtor LEFT JOIN libbook USING(BookId) WHERE AvtorId='99907' AND Deleted!=1 AND Lang IN('ru','uk','be');
0.00033 - (SELECT) BookId FROM libbook WHERE MATCH (Title) AGAINST ('гиперион') AND Deleted!=1 AND Lang IN('ru','uk','be');
0.00016 - (SELECT) Title FROM libbook WHERE BookId='25902';
0.00016 - (SELECT) cover FROM libcache WHERE BookId='25902';
0.00017 - (SELECT) AvtorId FROM libavtor WHERE BookId='25902' LIMIT 1;
0.00017 - (SELECT) * FROM libavtorname WHERE AvtorId='21436';
0.00031 - (SELECT) AvtorId FROM libavtor WHERE BookId='25902' ORDER BY RAND() LIMIT 1;
0.00024 - (SELECT) * FROM libgenre LEFT JOIN libgenrelist USING(GenreId) WHERE BookId='25902';
0.00016 - (SELECT) Title FROM libbook WHERE BookId='35390';
0.00015 - (SELECT) cover FROM libcache WHERE BookId='35390';
0.00017 - (SELECT) AvtorId FROM libavtor WHERE BookId='35390' ORDER BY RAND() LIMIT 1;
0.00021 - (SELECT) * FROM libgenre LEFT JOIN libgenrelist USING(GenreId) WHERE BookId='35390';
0.00016 - (SELECT) Title FROM libbook WHERE BookId='35420';
0.00024 - (SELECT) cover FROM libcache WHERE BookId='35420';
0.00030 - (SELECT) AvtorId FROM libavtor WHERE BookId='35420' ORDER BY RAND() LIMIT 1;
0.00039 - (SELECT) * FROM libgenre LEFT JOIN libgenrelist USING(GenreId) WHERE BookId='35420';
0.00022 - (SELECT) SeqNumb,SeqId,Title,Time FROM libbook LEFT JOIN libseq USING(BookId) WHERE BookId = '411061' LIMIT 1;
0.00015 - (SELECT) LastName FROM libavtor JOIN libavtorname USING(AvtorId) WHERE BookId = '411061' LIMIT 1;
0.00017 - (SELECT) nid FROM libbnode WHERE BookId = '411061' LIMIT 1;
0.00023 - (SELECT) nid FROM node force KEY(node_title_type) WHERE title = '411061' AND type = 'bdesc' LIMIT 1;
0.00040 - (SELECT) * FROM libquote WHERE BookID = 411061 ORDER BY RAND() LIMIT 1;
Запросов: 29. Время: 0.00628 - время всех запросов

 # # # # # # # # # # QUERYES_LIST # # # # # # # # # # 

0.00027 - (SELECT) INSERT INTO `lit_bookstat` (BookId,ip) VALUES('411061',INET_ATON('127.0.0.1')) ON DUPLICATE KEY UPDATE Time=CURRENT_TIMESTAMP();
0.00039 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='411061' AND Time > (NOW() - INTERVAL 1 DAY);
0.00026 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='411061' AND Time > (NOW() - INTERVAL 30 DAY);
0.00022 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='411061' AND Time > (NOW() - INTERVAL 365 DAY);
0.00016 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='411061';
0.00025 - (SELECT) * FROM `lit_book_comments` WHERE BookId='411061' AND deleted!=1 AND reply=0 ORDER BY id;
Запросов: 6. Время: 0.00155 - время всех запросов

 # # # # # # # # # # SESSION # # # # # # # # # # 


 # # # # # # # # # # SERVER # # # # # # # # # #