Во славу империи!… (СИ)

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

0.00044 - (SELECT) * FROM libavtor WHERE BookId='375401' ORDER BY RAND();
0.00038 - (SELECT) * FROM libbook WHERE BookId='375401';
0.00017 - (SELECT) cover FROM libcache WHERE BookId='375401';
0.00026 - (SELECT) AvtorId FROM libavtor WHERE BookId='375401';
0.00029 - (SELECT) * FROM libseq WHERE BookId='375401' AND level < 100;
0.00024 - (SELECT) PubId,PubName FROM libpub LEFT JOIN libpubname USING(PubId) WHERE BookId='375401' LIMIT 1;
0.00020 - (SELECT) CityId,CityName FROM libcity LEFT JOIN libcityname USING(CityId) WHERE BookId='375401' LIMIT 1;
0.00017 - (SELECT) * FROM libseq WHERE BookId='375401' AND level > 100;
0.00061 - (SELECT) BookId FROM libavtor LEFT JOIN libbook USING(BookId) WHERE AvtorId='149778' AND Deleted!=1 AND Lang IN('ru','uk','be');
0.00625 - (SELECT) BookId FROM libbook WHERE MATCH (Title) AGAINST ('во славу империи') AND Deleted!=1 AND Lang IN('ru','uk','be');
0.00025 - (SELECT) Title FROM libbook WHERE BookId='275365';
0.00026 - (SELECT) cover FROM libcache WHERE BookId='275365';
0.00035 - (SELECT) AvtorId FROM libavtor WHERE BookId='275365' ORDER BY RAND() LIMIT 1;
0.00039 - (SELECT) * FROM libgenre LEFT JOIN libgenrelist USING(GenreId) WHERE BookId='275365';
0.00024 - (SELECT) Title FROM libbook WHERE BookId='275847';
0.00022 - (SELECT) cover FROM libcache WHERE BookId='275847';
0.00026 - (SELECT) AvtorId FROM libavtor WHERE BookId='275847' ORDER BY RAND() LIMIT 1;
0.00026 - (SELECT) * FROM libavtorname WHERE AvtorId='88414';
0.00037 - (SELECT) * FROM libgenre LEFT JOIN libgenrelist USING(GenreId) WHERE BookId='275847';
0.00023 - (SELECT) cover FROM libcache WHERE BookId='290165';
0.00026 - (SELECT) AvtorId FROM libavtor WHERE BookId='290165' ORDER BY RAND() LIMIT 1;
0.00036 - (SELECT) SeqNumb,SeqId,Title,Time FROM libbook LEFT JOIN libseq USING(BookId) WHERE BookId = '375401' LIMIT 1;
0.00024 - (SELECT) LastName FROM libavtor JOIN libavtorname USING(AvtorId) WHERE BookId = '375401' LIMIT 1;
0.00029 - (SELECT) body FROM node_revisions WHERE nid = '289159' ORDER BY vid DESC LIMIT 1;
0.00053 - (SELECT) * FROM libquote WHERE BookID = 375401 ORDER BY RAND() LIMIT 1;
Запросов: 25. Время: 0.01352 - время всех запросов

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

0.00034 - (SELECT) INSERT INTO `lit_bookstat` (BookId,ip) VALUES('375401',INET_ATON('127.0.0.1')) ON DUPLICATE KEY UPDATE Time=CURRENT_TIMESTAMP();
0.00079 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='375401' AND Time > (NOW() - INTERVAL 1 DAY);
0.00067 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='375401' AND Time > (NOW() - INTERVAL 30 DAY);
0.00063 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='375401' AND Time > (NOW() - INTERVAL 365 DAY);
0.00023 - (SELECT) count(*) FROM lit_bookstat WHERE BookId='375401';
0.00039 - (SELECT) * FROM `lit_book_comments` WHERE BookId='375401' AND deleted!=1 AND reply=0 ORDER BY id;
0.00038 - (SELECT) count(*) FROM `lit_book_comments` WHERE mail='vpvgivan@yandex.ru';
0.00022 - (SELECT) * FROM `lit_book_comments` WHERE reply='78' ORDER BY id;
Запросов: 8. Время: 0.00365 - время всех запросов

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


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