@gape Съвет: праснете един thttpd на порт 8080 например, после с апаче модула mod_proxy го метнете на media.gape.bg. tux не го харесвам, не ви го препоръчвам
@gape Сайта ви ми се струва бавен за сървъра си. Защо не пробвате друго освен apache и ubuntu, lighttpd (fastcgi) например? Ще има ефект, 101% с медиа-та
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00021
SELECT user_id FROM posts_mentioned WHERE post_id="241264" LIMIT 1
0.00036
SELECT user_id FROM posts_mentioned WHERE post_id="254199" LIMIT 1
0.00029
SELECT id, type, data FROM posts_attachments WHERE post_id="357024" LIMIT 1
0.00020
SELECT user_id FROM posts_mentioned WHERE post_id="357024" LIMIT 1
0.00024
SELECT * FROM users_details WHERE user_id="7776" LIMIT 1
0.00039
SELECT * FROM users WHERE id="7776" LIMIT 1
0.00034
SELECT user_id FROM posts_mentioned WHERE post_id="357030" LIMIT 1
1.06574
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%httpd%") AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15
0.45130
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%httpd%") AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00030
SELECT id FROM groups WHERE is_public=0
0.08465
SELECT post_id FROM posts_comments WHERE message LIKE "%httpd%"
0.00030
SELECT id FROM searches WHERE user_id="" AND search_key="71c8325dd8b359ef3faeb6b1db86df7a" LIMIT 1
0.00035
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1