0.00030 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00024 |
SELECT user_id FROM posts_mentioned WHERE post_id="1202017" LIMIT 1 |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1330111" LIMIT 1 |
0.00027 |
SELECT * FROM users_details WHERE user_id="16431" LIMIT 1 |
0.00028 |
SELECT * FROM users WHERE id="16431" LIMIT 1 |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1334707" LIMIT 2 |
0.00027 |
SELECT * FROM users_details WHERE user_id="16465" LIMIT 1 |
0.00031 |
SELECT * FROM users WHERE id="16465" LIMIT 1 |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1362383" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_mentioned WHERE post_id="1379172" LIMIT 1 |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1379190" LIMIT 2 |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1407534" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="58159" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="58141" LIMIT 1 |
0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="58074" LIMIT 1 |
0.00048 |
SELECT * FROM posts_comments WHERE post_id="1410898" ORDER BY id ASC |
0.00038 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1410898" LIMIT 1 |
0.38840 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%seo оптимизация%" OR MATCH(message) AGAINST("+seo +оптимизация" IN BOOLEAN MODE) OR id IN(1410898, 1459035, 1465967)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15 |
1.34645 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%seo оптимизация%" OR MATCH(message) AGAINST("+seo +оптимизация" IN BOOLEAN MODE) OR id IN(1410898, 1459035, 1465967)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00029 |
SELECT id FROM groups WHERE is_public=0 |
0.23364 |
SELECT post_id FROM posts_comments WHERE message LIKE "%seo оптимизация%" OR MATCH(message) AGAINST("+seo +оптимизация" IN BOOLEAN MODE) |
0.00030 |
SELECT id FROM searches WHERE user_id="" AND search_key="44d45dcad4cd4854c930cefd5bf88d4c" LIMIT 1 |
0.00023 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00024 |
SELECT * FROM settings |
0.00112 |
CONNECT 49.12.223.183:9906 |
0.00011 |
GET |
f5dad|1000|n:1,userid:13538 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00013 |
SET |
f5dad|1000|n:1,userid:16431 |
TRUE |
0.00012 |
GET |
f5dad|1000|n:1,userid:16431 |
FALSE |
0.00012 |
SET |
f5dad|1000|n:1,userid:16465 |
TRUE |
0.00008 |
GET |
f5dad|1000|n:1,userid:16465 |
FALSE |
0.00013 |
GET |
f5dad|1000|n:1,userid:12587 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:573 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:120 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:585 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:9861 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:17190 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:269 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:9139 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:17213 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:710 |
object |
0.00020 |
GET |
f5dad|1000|n:1,userid:5950 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00031 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00001 |
CONNECT |
172.20.0.6:11211 |
TRUE |
Само един Centaur на Paradox sys. смуче ресурси като за последно, щото му е тромаво конструирана архитектурата и всяко чекиране го пише шест-седем пъти..
Dec 27 2011, 14:26СПЕЦИАЛНИ БЛАГОДАРНОСТИ КЪМ NVESELINOV СТАНА ИЗПЕКАХ ГО ДИСКА МУШНАХ ГО РЕСТАРТНАХ ГО И ГО ЗАСЕЧЕ БЛАГОДАТРЯ
Dec 27 2011, 15:30@eagle , така е , ако нямаш потребители които да товарят не ти трябват 8 гига , не се опитвам да твърддя противоположното
Dec 27 2011, 16:59Не, бе. Те си товарят...просто, когато е добре написано приложението и базата е измислена и направена кадърно, не ти трябват безбожно много ресурси.
Dec 27 2011, 21:22така е
Dec 27 2011, 22:27