ahehehе тая история е мнооооого култова... имаше я постната някъде в редит преди време и мноооого се накефих, сега пак се накефих като си я припомних. Тенкс!
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00034
SELECT * FROM posts_comments WHERE post_id="1467814" ORDER BY id ASC
0.00027
SELECT id, type, data FROM posts_attachments WHERE post_id="1467814" LIMIT 1
0.00031
SELECT user_id FROM posts_mentioned WHERE post_id="1467814" LIMIT 1
0.00048
SELECT id, type, data FROM posts_attachments WHERE post_id="1468275" LIMIT 1
1.05404
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%trolllvl99%") AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
0.46635
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%trolllvl99%") AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00037
SELECT id FROM groups WHERE is_public=0
0.08216
SELECT post_id FROM posts_comments WHERE message LIKE "%trolllvl99%"
0.00032
SELECT id FROM searches WHERE user_id="" AND search_key="9e5471bf63977565378bd524060b946a" LIMIT 1
0.00030
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1