0.10409 |
SELECT p.*, "public" AS `type` FROM posts p WHERE ((p.user_id="38" AND p.group_id NOT IN(132, 221, 240, 343, 358, 365)) OR p.id IN(1291342, 1444365, 1291490, 1291518, 1294741, 1296959, 1305700, 1317074, 1317815, 1319536, 1319788, 1320258, 1322623, 1322897, 1317120, 1323977, 1324545, 1326121, 1328102, 1328890, 1329014, 1330285, 1331161, 1331453, 1332435, 1333717, 1333787, 1334353, 1334420, 1335524, 1327170, 1336800, 389912, 1337532, 1324157, 1338013, 1338042, 1344144, 1345202, 1343427, 1346699, 1347417, 1347943, 1347942, 1350577, 1351143, 1351362, 1352171, 1353772, 1354784, 1355076, 1359139, 1359906, 1361892, 1367437, 1370071, 1375252, 1377181, 1378282, 1378318, 1378354, 1378397, 1379283, 1379824, 1380835, 1381919, 1382608, 1461123, 1383961, 1384173, 1385417, 1385487, 1470403, 1385519, 1387061, 1400735, 1390256, 1390730, 1443224, 1435328, 1392987, 1393395, 1393520, 1397561, 1394570, 1394759, 1394809, 1394941, 1395106, 1395119, 1395258, 1442825, 1395952, 1396016, 1442610, 1397472, 1398326, 1398582, 1398721, 1398826, 1399085, 1399335, 1399425, 1399740, 1388734, 1400076, 1400070, 1400160, 1400295, 1443024, 1443068, 1401719, 1402180, 1402389, 1402658, 1403053, 1406250, 1405403, 1407598, 1408482, 1471535, 1409219, 1409325, 1410532, 1410829, 1414386, 1415108, 1409890, 1416315, 1416646, 1378545, 1406181, 1418157, 1418372, 1422295, 1422878, 1, 1423121, 1423164, 1423025, 1423302, 1423545, 1412469, 1423666, 1423762, 1470799, 1424075, 1424188, 1424429, 1424449, 1424843, 1424848, 1425549, 1425664, 1425726, 1425860, 1342042, 1426215, 1426244, 1426305, 1426364, 1426428, 1426784, 1400145, 1428037, 1428314, 1427247, 1428817, 1428888, 1429392, 1434077, 1434196, 1434255, 1435876, 1437927, 1438666, 1438892, 1439291, 1439830, 1440108, 1440189, 1366789, 1441009, 1441395, 1441852, 1442055, 1443438, 1443679, 1443802, 1439659, 1444227, 407425, 344891, 1445466, 1446637, 1447441, 1449264, 1457412, 1450602, 1450822, 1451082, 1203104, 1451961, 1452809, 1440712, 1452966, 1454360, 1446645, 1437678, 1455970, 1456097, 1456285, 1456715, 1458811, 1459333, 1459780, 1460824, 1461222, 1462004, 1462550, 1462602, 1462836, 1463042, 1463351, 1463788, 1464061, 1419434, 1464421, 1464640, 1464869, 1465378, 1323397, 1466084, 1466598, 1469662)) AND p.api_id=6 ORDER BY p.id DESC LIMIT 45, 15 |
0.00404 |
SELECT COUNT(p.id) FROM posts p WHERE ((p.user_id="38" AND p.group_id NOT IN(132, 221, 240, 343, 358, 365)) OR p.id IN(1291342, 1444365, 1291490, 1291518, 1294741, 1296959, 1305700, 1317074, 1317815, 1319536, 1319788, 1320258, 1322623, 1322897, 1317120, 1323977, 1324545, 1326121, 1328102, 1328890, 1329014, 1330285, 1331161, 1331453, 1332435, 1333717, 1333787, 1334353, 1334420, 1335524, 1327170, 1336800, 389912, 1337532, 1324157, 1338013, 1338042, 1344144, 1345202, 1343427, 1346699, 1347417, 1347943, 1347942, 1350577, 1351143, 1351362, 1352171, 1353772, 1354784, 1355076, 1359139, 1359906, 1361892, 1367437, 1370071, 1375252, 1377181, 1378282, 1378318, 1378354, 1378397, 1379283, 1379824, 1380835, 1381919, 1382608, 1461123, 1383961, 1384173, 1385417, 1385487, 1470403, 1385519, 1387061, 1400735, 1390256, 1390730, 1443224, 1435328, 1392987, 1393395, 1393520, 1397561, 1394570, 1394759, 1394809, 1394941, 1395106, 1395119, 1395258, 1442825, 1395952, 1396016, 1442610, 1397472, 1398326, 1398582, 1398721, 1398826, 1399085, 1399335, 1399425, 1399740, 1388734, 1400076, 1400070, 1400160, 1400295, 1443024, 1443068, 1401719, 1402180, 1402389, 1402658, 1403053, 1406250, 1405403, 1407598, 1408482, 1471535, 1409219, 1409325, 1410532, 1410829, 1414386, 1415108, 1409890, 1416315, 1416646, 1378545, 1406181, 1418157, 1418372, 1422295, 1422878, 1, 1423121, 1423164, 1423025, 1423302, 1423545, 1412469, 1423666, 1423762, 1470799, 1424075, 1424188, 1424429, 1424449, 1424843, 1424848, 1425549, 1425664, 1425726, 1425860, 1342042, 1426215, 1426244, 1426305, 1426364, 1426428, 1426784, 1400145, 1428037, 1428314, 1427247, 1428817, 1428888, 1429392, 1434077, 1434196, 1434255, 1435876, 1437927, 1438666, 1438892, 1439291, 1439830, 1440108, 1440189, 1366789, 1441009, 1441395, 1441852, 1442055, 1443438, 1443679, 1443802, 1439659, 1444227, 407425, 344891, 1445466, 1446637, 1447441, 1449264, 1457412, 1450602, 1450822, 1451082, 1203104, 1451961, 1452809, 1440712, 1452966, 1454360, 1446645, 1437678, 1455970, 1456097, 1456285, 1456715, 1458811, 1459333, 1459780, 1460824, 1461222, 1462004, 1462550, 1462602, 1462836, 1463042, 1463351, 1463788, 1464061, 1419434, 1464421, 1464640, 1464869, 1465378, 1323397, 1466084, 1466598, 1469662)) AND p.api_id=6 |
0.00066 |
SELECT post_id FROM posts_reshares WHERE user_id="38" |
0.00027 |
SELECT id FROM groups WHERE is_public=0 |
0.00022 |
SELECT * FROM users_details WHERE user_id="5041" LIMIT 1 |
0.00021 |
SELECT * FROM users WHERE id="5041" LIMIT 1 |
0.00019 |
SELECT * FROM users_details WHERE user_id="882" LIMIT 1 |
0.00029 |
SELECT * FROM users WHERE id="882" LIMIT 1 |
0.02254 |
SELECT message, date FROM posts WHERE api_id<>2 AND api_id<>6 AND posttags<>0 AND user_id="38" ORDER BY id DESC LIMIT 1000 |
0.00025 |
SELECT id FROM groups WHERE is_public=0 |
0.00024 |
SELECT website, work_phone, personal_phone, personal_email FROM users_details WHERE user_id="38" LIMIT 1 |
0.00043 |
SELECT id FROM users WHERE username="blacksnoopy" AND active=1 LIMIT 1 |
0.00028 |
SELECT * FROM settings |
0.00116 |
CONNECT 49.12.223.183:9906 |
0.00017 |
GET |
f5dad|1000|n:1,post_app:6 |
object |
0.00005 |
GET |
f5dad|1000|n:1,group_invited_members:365 |
array |
0.00005 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00005 |
GET |
f5dad|1000|n:1,group_invited_members:358 |
array |
0.00005 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00006 |
GET |
f5dad|1000|n:1,group_invited_members:343 |
array |
0.00007 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00008 |
GET |
f5dad|1000|n:1,group_invited_members:240 |
array |
0.00007 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00005 |
GET |
f5dad|1000|n:1,group_invited_members:221 |
array |
0.00007 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00008 |
GET |
f5dad|1000|n:1,group_invited_members:132 |
array |
0.00012 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:16395 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:1163 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:879 |
object |
0.00011 |
SET |
f5dad|1000|n:1,userid:5041 |
TRUE |
0.00008 |
GET |
f5dad|1000|n:1,userid:5041 |
FALSE |
0.00009 |
GET |
f5dad|1000|n:1,userid:5185 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:9353 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:525 |
object |
0.00011 |
SET |
f5dad|1000|n:1,userid:882 |
TRUE |
0.00007 |
GET |
f5dad|1000|n:1,userid:882 |
FALSE |
0.00010 |
GET |
f5dad|1000|n:1,userid:2704 |
object |
0.00026 |
GET |
f5dad|1000|n:1,userfollows:38 |
object |
0.00007 |
DELETE |
f5dad|1000|n:1,active_tags_loading |
TRUE |
0.00014 |
SET |
f5dad|1000|n:1,active_tags:fe8f504893f70c82ecfc7183e3086af1 |
TRUE |
0.00008 |
SET |
f5dad|1000|n:1,active_tags_loading |
TRUE |
0.00008 |
GET |
f5dad|1000|n:1,active_tags_loading |
FALSE |
0.00009 |
GET |
f5dad|1000|n:1,active_tags:fe8f504893f70c82ecfc7183e3086af1 |
FALSE |
0.00014 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00013 |
SET |
f5dad|1000|n:1,username:blacksnoopy |
TRUE |
0.00027 |
GET |
f5dad|1000|n:1,username:blacksnoopy |
FALSE |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |