@pesho Не мисля, че може да се изнесе точна статистика освен ако не използваш web-bugs в spoiler <div>, който се зарежда ако някой наистина отвори спойлера.
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00072
SELECT user_id FROM posts_mentioned WHERE post_id="232986" LIMIT 1
0.00030
SELECT user_id FROM posts_mentioned WHERE post_id="242439" LIMIT 1
1.08691
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%спойлер%" OR id IN(1388850, 1415185, 1430093, 1439175, 1455499, 1467184)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15
0.53401
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%спойлер%" OR id IN(1388850, 1415185, 1430093, 1439175, 1455499, 1467184)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00034
SELECT id FROM groups WHERE is_public=0
0.09701
SELECT post_id FROM posts_comments WHERE message LIKE "%спойлер%"
0.00027
SELECT id FROM searches WHERE user_id="" AND search_key="2651c798e480ff93269ebec8a8e6444f" LIMIT 1
0.00025
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1