и беше грешка според мен че махнаха постовете на 1ва страница защото с тях цялата работа напомняше за добрите стари времена и mIRC и за това се харесваше...
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00023
SELECT * FROM users_details WHERE user_id="355" LIMIT 1
0.00027
SELECT * FROM users WHERE id="355" LIMIT 1
0.00029
SELECT * FROM users_details WHERE user_id="221" LIMIT 1
0.00025
SELECT * FROM users WHERE id="221" LIMIT 1
0.00022
SELECT * FROM users_details WHERE user_id="276" LIMIT 1
0.00036
SELECT * FROM users WHERE id="276" LIMIT 1
1.00927
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%mirc%" OR id IN(1304281, 1304283, 1304281, 1347213, 1351334, 1379906, 1379906, 1379906, 1403515, 1410993, 1416053)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 45, 15
0.46039
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%mirc%" OR id IN(1304281, 1304283, 1304281, 1347213, 1351334, 1379906, 1379906, 1379906, 1403515, 1410993, 1416053)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00033
SELECT id FROM groups WHERE is_public=0
0.08238
SELECT post_id FROM posts_comments WHERE message LIKE "%mirc%"
0.00035
SELECT id FROM searches WHERE user_id="" AND search_key="5992f265a0f785c21cbb396ae2c454a6" LIMIT 1
0.00032
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1
