@X7r3M1s7a, @aftercollabz, най-лошото е, че брат ми има регистрация във всичките и като седна на писито, тряа рестартирам модзилата, за да не умра от грозотия.
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00022
SELECT user_id FROM posts_mentioned WHERE post_id="20805" LIMIT 1
0.00022
SELECT user_id FROM posts_mentioned WHERE post_id="25903" LIMIT 2
0.00030
SELECT user_id FROM posts_mentioned WHERE post_id="63600" LIMIT 1
1.01040
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%грозотия%" OR id IN(1357521, 1398473, 1469243, 1469243)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15
0.48413
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%грозотия%" OR id IN(1357521, 1398473, 1469243, 1469243)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00049
SELECT id FROM groups WHERE is_public=0
0.08204
SELECT post_id FROM posts_comments WHERE message LIKE "%грозотия%"
0.00026
SELECT id FROM searches WHERE user_id="" AND search_key="e7497d0e41fc979ab647229d85f8117e" LIMIT 1
0.00025
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1