0.00029 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="131109" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="131103" LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1463111" ORDER BY id ASC |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="131201" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1463134" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1463504" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1464266" ORDER BY id ASC |
0.00024 |
SELECT * FROM posts_comments WHERE post_id="1464610" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1464656" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464656" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1464701" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="134347" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="134337" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="134331" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="134328" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1464720" ORDER BY id ASC |
0.00024 |
SELECT * FROM posts_comments WHERE post_id="1464783" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464898" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_reshares WHERE post_id="1465026" ORDER BY id DESC LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135038" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1465026" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1465026" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1465036" ORDER BY id ASC |
0.00028 |
SELECT user_id FROM posts_reshares WHERE post_id="1465327" ORDER BY id DESC LIMIT 1 |
0.00037 |
SELECT * FROM posts_comments WHERE post_id="1465327" ORDER BY id ASC |
0.01349 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%world%" OR id IN(1304480, 1309700, 1316430, 1316335, 1318154, 1467925, 1326710, 1328520, 1329747, 1453539, 1332256, 1334279, 1366207, 1340095, 1342041, 1345649, 1346177, 1347366, 1347434, 1353897, 1360771, 1360288, 1363185, 1370980, 1377372, 1447613, 1447613, 1385164, 1385438, 1385375, 1387142, 1387774, 1442451, 1444218, 1400509, 1397339, 1406217, 1408298, 1412665, 1413906, 1414742, 1414771, 1415497, 1416809, 1417455, 1418935, 1421675, 1380746, 1422365, 1424111, 1424566, 1425388, 1426697, 1426884, 1427904, 1428836, 1429747, 1430997, 1431832, 1431977, 1457016, 1432079, 1435091, 1435552, 1437940, 1438984, 1470784, 1440440, 1440877, 1441299, 1457099, 1442858, 1443237, 1446523, 1446523, 1446033, 1448701, 1448900, 1449779, 1450174, 1451649, 1452038, 1452700, 1452700, 1453426, 1454048, 1454311, 1454383, 1467389, 1458432, 1458639, 1458721, 1460085, 1460107, 1460174, 1460580, 1460875, 1461162, 1461297, 1462169, 1463109, 1463111, 1463134, 1464266, 1464610, 1464656, 1464701, 1464720, 1464783, 1465036, 1465036, 1465036, 1465973, 1465839, 1470526, 1467091, 1468795, 1468829, 1469259, 1469290, 1469290, 1469326, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 30, 15 |
0.48553 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%world%" OR id IN(1304480, 1309700, 1316430, 1316335, 1318154, 1467925, 1326710, 1328520, 1329747, 1453539, 1332256, 1334279, 1366207, 1340095, 1342041, 1345649, 1346177, 1347366, 1347434, 1353897, 1360771, 1360288, 1363185, 1370980, 1377372, 1447613, 1447613, 1385164, 1385438, 1385375, 1387142, 1387774, 1442451, 1444218, 1400509, 1397339, 1406217, 1408298, 1412665, 1413906, 1414742, 1414771, 1415497, 1416809, 1417455, 1418935, 1421675, 1380746, 1422365, 1424111, 1424566, 1425388, 1426697, 1426884, 1427904, 1428836, 1429747, 1430997, 1431832, 1431977, 1457016, 1432079, 1435091, 1435552, 1437940, 1438984, 1470784, 1440440, 1440877, 1441299, 1457099, 1442858, 1443237, 1446523, 1446523, 1446033, 1448701, 1448900, 1449779, 1450174, 1451649, 1452038, 1452700, 1452700, 1453426, 1454048, 1454311, 1454383, 1467389, 1458432, 1458639, 1458721, 1460085, 1460107, 1460174, 1460580, 1460875, 1461162, 1461297, 1462169, 1463109, 1463111, 1463134, 1464266, 1464610, 1464656, 1464701, 1464720, 1464783, 1465036, 1465036, 1465036, 1465973, 1465839, 1470526, 1467091, 1468795, 1468829, 1469259, 1469290, 1469290, 1469326, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00030 |
SELECT id FROM groups WHERE is_public=0 |
0.07502 |
SELECT post_id FROM posts_comments WHERE message LIKE "%world%" |
0.00029 |
SELECT id FROM searches WHERE user_id="" AND search_key="a74cf078e834c2ffbaaf774232eaecfe" LIMIT 1 |
0.00031 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00025 |
SELECT * FROM settings |
0.00110 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00007 |
GET |
f5dad|1000|n:1,userid:14704 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:17810 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:12512 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:242 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:16440 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:3430 |
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.00008 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00026 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00001 |
CONNECT |
172.20.0.6:11211 |
TRUE |
цялата поредица са много добри
May 30 2015, 00:22