0.00024 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1446803" ORDER BY id ASC |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1447374" ORDER BY id ASC |
0.00019 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1447374" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="103424" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1447893" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1447893" LIMIT 1 |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1448186" ORDER BY id ASC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="114905" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1455489" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1455489" LIMIT 2 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1456247" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1456247" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_mentioned WHERE post_id="1456850" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="117875" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1456946" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1457045" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1457045" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1457902" ORDER BY id ASC |
0.00051 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1457902" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="127732" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1461496" ORDER BY id ASC |
0.00021 |
SELECT user_id FROM posts_reshares WHERE post_id="1461972" ORDER BY id DESC LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="128869" LIMIT 1 |
0.00019 |
SELECT * FROM users_details WHERE user_id="18022" LIMIT 1 |
0.00023 |
SELECT * FROM users WHERE id="18022" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="128854" LIMIT 1 |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1461972" ORDER BY id ASC |
0.04005 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%api%" OR id IN(1229133, 1232670, 1232670, 1268595, 1269662, 1291771, 1294431, 1294431, 1296303, 1318761, 1340163, 1349622, 1349112, 1352171, 1364903, 1382765, 1391311, 1393573, 1394429, 1395838, 1399680, 1447374, 1415322, 1423963, 1425506, 1425794, 1426155, 1426735, 1427948, 1431541, 1457045, 1434556, 1436087, 1436087, 1436668, 1436668, 1440325, 1440775, 1441890, 1446803, 1447893, 1448186, 1455489, 1471136, 1456247, 1461972, 1461972, 1462725, 1462773, 1464699, 1464751, 1464751, 1466138, 1466138, 1465427, 1469665, 1469665)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15 |
0.49858 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%api%" OR id IN(1229133, 1232670, 1232670, 1268595, 1269662, 1291771, 1294431, 1294431, 1296303, 1318761, 1340163, 1349622, 1349112, 1352171, 1364903, 1382765, 1391311, 1393573, 1394429, 1395838, 1399680, 1447374, 1415322, 1423963, 1425506, 1425794, 1426155, 1426735, 1427948, 1431541, 1457045, 1434556, 1436087, 1436087, 1436668, 1436668, 1440325, 1440775, 1441890, 1446803, 1447893, 1448186, 1455489, 1471136, 1456247, 1461972, 1461972, 1462725, 1462773, 1464699, 1464751, 1464751, 1466138, 1466138, 1465427, 1469665, 1469665)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00031 |
SELECT id FROM groups WHERE is_public=0 |
0.07461 |
SELECT post_id FROM posts_comments WHERE message LIKE "%api%" |
0.00021 |
SELECT id FROM searches WHERE user_id="" AND search_key="fe214bccf596c5b3f96dbd94845737b2" LIMIT 1 |
0.00025 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00025 |
SELECT * FROM settings |
0.00103 |
CONNECT 49.12.223.183:9906 |
0.00009 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:6135 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:1343 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:12618 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2355 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:7690 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00007 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:7879 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:2043 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:263 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:16440 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00011 |
SET |
f5dad|1000|n:1,userid:18022 |
TRUE |
0.00007 |
GET |
f5dad|1000|n:1,userid:18022 |
FALSE |
0.00014 |
GET |
f5dad|1000|n:1,userid:6039 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00029 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00005 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00024 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
това, което каза @bgdn
Nov 12 2014, 17:10когато се качат големи снимки, сървъра да ги направи по-малки ако потребителят излишно не е поискал
Nov 12 2014, 17:11при разглеждане на снимки, да не показва 8000x6000 смалена на 500x300, а показаната снимка реално да съдържа толкова пиксели
Nov 12 2014, 17:12да споменава отгоре на таб-а дали има нови коментари и съобщения без да трябва да правя сайта активен.
Nov 28 2014, 17:47Twitter emoji?
Nov 29 2014, 23:26 през mobi