Тва да издаваш книга си е жива мъка. Но ще се справя. А и от издателството са готини. А че редакторите са гадове, гадове са. Но няма да се съобразявам с тях
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
2.14918
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%жива книга%" OR MATCH(message) AGAINST("+жива +книга" IN BOOLEAN MODE)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
1.44788
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%жива книга%" OR MATCH(message) AGAINST("+жива +книга" IN BOOLEAN MODE)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00058
SELECT id FROM groups WHERE is_public=0
0.24555
SELECT post_id FROM posts_comments WHERE message LIKE "%жива книга%" OR MATCH(message) AGAINST("+жива +книга" IN BOOLEAN MODE)
0.00036
SELECT id FROM searches WHERE user_id="" AND search_key="b78034f87a774dbb9a4507a5c73bfc14" LIMIT 1
0.00044
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1
