| 0.00031 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
| 0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139311" LIMIT 1 |
| 0.00031 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139310" LIMIT 2 |
| 0.00028 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139309" LIMIT 2 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139305" LIMIT 1 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139300" LIMIT 1 |
| 0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139299" LIMIT 1 |
| 0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139298" LIMIT 1 |
| 0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139297" LIMIT 1 |
| 0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139295" LIMIT 1 |
| 0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139291" LIMIT 1 |
| 0.00042 |
SELECT * FROM posts_comments WHERE post_id="1466739" ORDER BY id ASC |
| 0.00032 |
SELECT * FROM posts_comments WHERE post_id="1466809" ORDER BY id ASC |
| 0.00041 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1466809" LIMIT 1 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139603" LIMIT 1 |
| 0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139599" LIMIT 2 |
| 0.00034 |
SELECT * FROM posts_comments WHERE post_id="1466870" ORDER BY id ASC |
| 0.00031 |
SELECT * FROM posts_comments WHERE post_id="1466874" ORDER BY id ASC |
| 0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139788" LIMIT 1 |
| 0.00035 |
SELECT * FROM posts_comments WHERE post_id="1466934" ORDER BY id ASC |
| 0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1466950" LIMIT 1 |
| 0.00039 |
SELECT * FROM posts_comments WHERE post_id="1466976" ORDER BY id ASC |
| 0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139947" LIMIT 1 |
| 0.00032 |
SELECT * FROM posts_comments WHERE post_id="1467002" ORDER BY id ASC |
| 0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467002" LIMIT 1 |
| 0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467077" LIMIT 1 |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1467079" ORDER BY id ASC |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1467228" ORDER BY id ASC |
| 0.00035 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467228" LIMIT 1 |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1467264" ORDER BY id ASC |
| 0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467264" LIMIT 1 |
| 0.00022 |
SELECT user_id FROM posts_mentioned WHERE post_id="1467264" LIMIT 1 |
| 0.00034 |
SELECT * FROM posts_comments WHERE post_id="1467288" ORDER BY id ASC |
| 0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467288" LIMIT 1 |
| 0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="140617" LIMIT 1 |
| 0.00038 |
SELECT * FROM posts_comments WHERE post_id="1467356" ORDER BY id ASC |
| 0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467356" LIMIT 1 |
| 0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467494" LIMIT 1 |
| 0.01036 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%12%" OR id IN(1280930, 1227326, 1286927, 1453426, 1292174, 1292411, 1292527, 1292540, 1292686, 1292802, 1292854, 1293009, 1292672, 1293296, 1293982, 1294475, 1294702, 1294879, 1294965, 1295796, 1295991, 1295471, 1296015, 1296358, 1296959, 1306229, 1309768, 1316135, 1317054, 1317477, 1317562, 1319072, 1320458, 1320557, 1320644, 1321058, 1321306, 1291942, 1322902, 1389352, 1324348, 1324336, 1324614, 1324659, 1324851, 1325010, 1326119, 1326117, 1327129, 1327262, 1327734, 1317761, 1328491, 1328823, 1329438, 1329747, 1331033, 1389803, 1332686, 1334338, 1334546, 1334546, 1334546, 1334878, 1336803, 1447481, 1453510, 1338747, 1339587, 1339669, 1339675, 1339675, 1340154, 1341285, 1341693, 1342043, 1343505, 1345515, 1366153, 1346077, 1346077, 1332687, 1346527, 1346980, 1348203, 1346527, 1348879, 1349263, 1349664, 1470382, 1350411, 1350443, 1429104, 1471741, 1351859, 1389436, 1389436, 1351606, 1351606, 1360494, 1355084, 1359902, 1357435, 1357440, 1447557, 1358790, 1358790, 1360589, 1361648, 1361874, 1453534, 1447557, 1364017, 1364614, 1365211, 1359902, 1447557, 1365885, 1367019, 1369198, 1369198, 1369555, 1369868, 1447595, 1370684, 1371269, 1397828, 1371820, 1373847, 1377318, 1378180, 1378196, 1378382, 1413104, 1378721, 1379503, 1470266, 1391054, 1381010, 1381919, 1381919, 1381894, 1382616, 1382970, 1382968, 1467594, 1383010, 1384181, 1384611, 1384731, 1409632, 1385228, 1385416, 1386181, 1387017, 1387646, 1387646, 1387643, 1388105, 1388269, 1390208, 1390208, 1390232, 1390619, 1390634, 1390879, 1390927, 1390945, 1391222, 1391425, 1391795, 1392035, 1392322, 1392903, 1394429, 1394649, 1396167, 1396733, 1471670, 1396944, 1442230, 1397142, 1397142, 1397545, 1397770, 1397864, 1397884, 1397894, 1469739, 1398447, 1398452, 1398708, 1398606, 1398964, 1398982, 1398870, 1398870, 1398870, 1442264, 1399262, 1442333, 1467579, 1400068, 1400582, 1400559, 1401123, 1425949, 1401489, 1401588, 1402831, 1403026, 1403757, 1403757, 1412980, 1404494, 1404647, 1447708, 1407266, 1412896, 1408713, 1409068, 1409289, 1443976, 1410221, 1409904, 1410445, 1410380, 1410658, 1410898, 1412745, 1411458, 1411547, 1411709, 1411709, 1411745, 1411923, 1412562, 1413193, 1413264, 1413424, 1413635, 1413649, 1413948, 1413963, 1444218, 1414439, 1414444, 1415053, 1415150, 1414873, 1415835, 1416020, 1413441, 1416132, 1416148, 1416196, 1401662, 1416386, 1416446, 1416472, 1416496, 1416697, 1416797, 1416938, 1432432, 1416977, 1416977, 1417099, 1417099, 1417451, 1417493, 1417580, 1417701, 1418157, 1418315, 1418608, 1432385, 1418833, 1418868, 1419166, 1419626, 1420237, 1421106, 1421106, 1420992, 1421400, 1421314, 1432479, 1457777, 1420992, 1421916, 1422393, 1422563, 1422707, 1423114, 1423114, 1423128, 1422960, 1423503, 1423314, 1423746, 1423762, 1423762, 1443905, 1423991, 1447820, 1456980, 1456982, 1424326, 1424402, 1424442, 1424497, 1424525, 1424566, 1424152, 1424765, 1424898, 1425540, 1425552, 1425552, 1425583, 1425601, 1425339, 1425339, 1425720, 1425745, 1426155, 1426155, 1467715, 1426305, 1426328, 1468639, 1426386, 1426386, 1470245, 1470241, 1426531, 1426777, 1470241, 1426817, 1426983, 1427006, 1426150, 1468014, 1427396, 1471469, 1468043, 1427895, 1427904, 1447539, 1447523, 1432141, 1428084, 1428225, 1428271, 1428492, 1428534, 1428550, 1428652, 1428541, 1428664, 1428733, 1428762, 1428768, 1429058, 1429058, 1429080, 1429205, 1429267, 1429408, 1429505, 1429564, 1429609, 1429609, 1429609, 1429609, 1429637, 1429667, 1430025, 1430190, 1430073, 1430073, 1430394, 1430500, 1430579, 1430589, 1430575, 1430642, 1457014, 1420521, 1471820, 1431442, 1431510, 1431526, 1431541, 1431585, 1431585, 1431766, 1431785, 1431982, 1432003, 1432189, 1440970, 1432337, 1432667, 1432673, 1432690, 1432716, 1433053, 1433053, 1433117, 1433790, 1433353, 1433391, 1457717, 1433672, 1433913, 1433915, 1433988, 1434083, 1434086, 1434531, 1434556, 1434883, 1434879, 1434880, 1435481, 1437164, 1435037, 1435338, 1457817, 1435554, 1447517, 1435913, 1436087, 1440980, 1440806, 1436250, 1436673, 1436725, 1436775, 1437072, 1437341, 1437487, 1437650, 1438069, 1470731, 1438313, 1438311, 1438312, 1438443, 1438456, 1451178, 1438692, 1438692, 1438862, 1438923, 1441742, 1439089, 1439116, 1467288, 1439559, 1439498, 1439665, 1439765, 1470752, 1440382, 1440341, 1440484, 1440784, 1440781, 1470741, 1441637, 1442022, 1442022, 1441736, 1442090, 1442010, 1442635, 1442714, 1442813, 1443215, 1443215, 1443302, 1444000, 1444000, 1444313, 1444080, 1444448, 1444777, 1444928, 1444985, 1445234, 1445276, 1470716, 1457138, 1446134, 1446269, 1446269, 1446251, 1446251, 1446251, 1446472, 1446584, 1457168, 1446639, 1446736, 1446920, 1447374, 1448263, 1448417, 1448650, 1448696, 1448696, 1448777, 1448774, 1449229, 1449127, 1449508, 1449645, 1450142, 1450143, 1450621, 1450692, 1450814, 1450842, 1450859, 1457907, 1451515, 1451601, 1457155, 1451920, 1470003, 1452142, 1452168, 1452172, 1452590, 1468706, 1453273, 1471255, 1453370, 1453369, 1453756, 1453963, 1454026, 1454064, 1454116, 1454122, 1454262, 1454383, 1454405, 1454439, 1454913, 1454965, 1455047, 1455228, 1455165, 1455378, 1455470, 1455515, 1455515, 1455780, 1455780, 1455780, 1455838, 1455838, 1456182, 1456212, 1456271, 1456282, 1458086, 1470630, 1456352, 1456888, 1456271, 1456381, 1456271, 1456585, 1456639, 1456628, 1456888, 1456842, 1456811, 1458175, 1458317, 1458317, 1458364, 1458424, 1458548, 1458786, 1458987, 1459012, 1459060, 1459232, 1459254, 1459256, 1459505, 1459505, 1459583, 1459585, 1459603, 1459678, 1459716, 1459735, 1460041, 1460064, 1460100, 1460258, 1460433, 1460489, 1460539, 1460562, 1460590, 1460637, 1461198, 1460741, 1460775, 1460861, 1461130, 1461219, 1461287, 1461313, 1461528, 1461585, 1461689, 1461696, 1461748, 1461816, 1461896, 1461920, 1461947, 1462000, 1462046, 1462069, 1462118, 1462237, 1462275, 1462616, 1462616, 1462616, 1462399, 1462439, 1462586, 1462586, 1462586, 1462607, 1462616, 1462616, 1462618, 1462616, 1462725, 1462808, 1462854, 1462860, 1462853, 1462853, 1462860, 1463015, 1463015, 1463015, 1463069, 1463135, 1463348, 1463348, 1463348, 1463516, 1463572, 1463585, 1463620, 1463712, 1464434, 1463769, 1464080, 1464099, 1464103, 1464210, 1464523, 1464546, 1464592, 1464592, 1464631, 1464634, 1464634, 1464656, 1464664, 1464668, 1464747, 1464747, 1464747, 1464718, 1464752, 1464792, 1464835, 1464908, 1464908, 1465023, 1465068, 1465140, 1465182, 1465228, 1466027, 1466047, 1466077, 1466119, 1467636, 1466171, 1466187, 1466232, 1466268, 1466301, 1466409, 1465883, 1466017, 1465810, 1465822, 1465595, 1465770, 1467356, 1467356, 1465391, 1465393, 1465461, 1466501, 1466662, 1466689, 1470523, 1466739, 1466739, 1466809, 1466870, 1470508, 1466934, 1466976, 1466976, 1467079, 1470430, 1467264, 1469215, 1468243, 1468325, 1468370, 1468378, 1468521, 1468757, 1468953, 1469073, 1469260, 1469963, 1469499, 1469552, 1469566, 1469701, 1469763, 1469763, 1469848, 1469848, 1469848, 1469927, 1471979)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 60, 15 |
| 0.46369 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%12%" OR id IN(1280930, 1227326, 1286927, 1453426, 1292174, 1292411, 1292527, 1292540, 1292686, 1292802, 1292854, 1293009, 1292672, 1293296, 1293982, 1294475, 1294702, 1294879, 1294965, 1295796, 1295991, 1295471, 1296015, 1296358, 1296959, 1306229, 1309768, 1316135, 1317054, 1317477, 1317562, 1319072, 1320458, 1320557, 1320644, 1321058, 1321306, 1291942, 1322902, 1389352, 1324348, 1324336, 1324614, 1324659, 1324851, 1325010, 1326119, 1326117, 1327129, 1327262, 1327734, 1317761, 1328491, 1328823, 1329438, 1329747, 1331033, 1389803, 1332686, 1334338, 1334546, 1334546, 1334546, 1334878, 1336803, 1447481, 1453510, 1338747, 1339587, 1339669, 1339675, 1339675, 1340154, 1341285, 1341693, 1342043, 1343505, 1345515, 1366153, 1346077, 1346077, 1332687, 1346527, 1346980, 1348203, 1346527, 1348879, 1349263, 1349664, 1470382, 1350411, 1350443, 1429104, 1471741, 1351859, 1389436, 1389436, 1351606, 1351606, 1360494, 1355084, 1359902, 1357435, 1357440, 1447557, 1358790, 1358790, 1360589, 1361648, 1361874, 1453534, 1447557, 1364017, 1364614, 1365211, 1359902, 1447557, 1365885, 1367019, 1369198, 1369198, 1369555, 1369868, 1447595, 1370684, 1371269, 1397828, 1371820, 1373847, 1377318, 1378180, 1378196, 1378382, 1413104, 1378721, 1379503, 1470266, 1391054, 1381010, 1381919, 1381919, 1381894, 1382616, 1382970, 1382968, 1467594, 1383010, 1384181, 1384611, 1384731, 1409632, 1385228, 1385416, 1386181, 1387017, 1387646, 1387646, 1387643, 1388105, 1388269, 1390208, 1390208, 1390232, 1390619, 1390634, 1390879, 1390927, 1390945, 1391222, 1391425, 1391795, 1392035, 1392322, 1392903, 1394429, 1394649, 1396167, 1396733, 1471670, 1396944, 1442230, 1397142, 1397142, 1397545, 1397770, 1397864, 1397884, 1397894, 1469739, 1398447, 1398452, 1398708, 1398606, 1398964, 1398982, 1398870, 1398870, 1398870, 1442264, 1399262, 1442333, 1467579, 1400068, 1400582, 1400559, 1401123, 1425949, 1401489, 1401588, 1402831, 1403026, 1403757, 1403757, 1412980, 1404494, 1404647, 1447708, 1407266, 1412896, 1408713, 1409068, 1409289, 1443976, 1410221, 1409904, 1410445, 1410380, 1410658, 1410898, 1412745, 1411458, 1411547, 1411709, 1411709, 1411745, 1411923, 1412562, 1413193, 1413264, 1413424, 1413635, 1413649, 1413948, 1413963, 1444218, 1414439, 1414444, 1415053, 1415150, 1414873, 1415835, 1416020, 1413441, 1416132, 1416148, 1416196, 1401662, 1416386, 1416446, 1416472, 1416496, 1416697, 1416797, 1416938, 1432432, 1416977, 1416977, 1417099, 1417099, 1417451, 1417493, 1417580, 1417701, 1418157, 1418315, 1418608, 1432385, 1418833, 1418868, 1419166, 1419626, 1420237, 1421106, 1421106, 1420992, 1421400, 1421314, 1432479, 1457777, 1420992, 1421916, 1422393, 1422563, 1422707, 1423114, 1423114, 1423128, 1422960, 1423503, 1423314, 1423746, 1423762, 1423762, 1443905, 1423991, 1447820, 1456980, 1456982, 1424326, 1424402, 1424442, 1424497, 1424525, 1424566, 1424152, 1424765, 1424898, 1425540, 1425552, 1425552, 1425583, 1425601, 1425339, 1425339, 1425720, 1425745, 1426155, 1426155, 1467715, 1426305, 1426328, 1468639, 1426386, 1426386, 1470245, 1470241, 1426531, 1426777, 1470241, 1426817, 1426983, 1427006, 1426150, 1468014, 1427396, 1471469, 1468043, 1427895, 1427904, 1447539, 1447523, 1432141, 1428084, 1428225, 1428271, 1428492, 1428534, 1428550, 1428652, 1428541, 1428664, 1428733, 1428762, 1428768, 1429058, 1429058, 1429080, 1429205, 1429267, 1429408, 1429505, 1429564, 1429609, 1429609, 1429609, 1429609, 1429637, 1429667, 1430025, 1430190, 1430073, 1430073, 1430394, 1430500, 1430579, 1430589, 1430575, 1430642, 1457014, 1420521, 1471820, 1431442, 1431510, 1431526, 1431541, 1431585, 1431585, 1431766, 1431785, 1431982, 1432003, 1432189, 1440970, 1432337, 1432667, 1432673, 1432690, 1432716, 1433053, 1433053, 1433117, 1433790, 1433353, 1433391, 1457717, 1433672, 1433913, 1433915, 1433988, 1434083, 1434086, 1434531, 1434556, 1434883, 1434879, 1434880, 1435481, 1437164, 1435037, 1435338, 1457817, 1435554, 1447517, 1435913, 1436087, 1440980, 1440806, 1436250, 1436673, 1436725, 1436775, 1437072, 1437341, 1437487, 1437650, 1438069, 1470731, 1438313, 1438311, 1438312, 1438443, 1438456, 1451178, 1438692, 1438692, 1438862, 1438923, 1441742, 1439089, 1439116, 1467288, 1439559, 1439498, 1439665, 1439765, 1470752, 1440382, 1440341, 1440484, 1440784, 1440781, 1470741, 1441637, 1442022, 1442022, 1441736, 1442090, 1442010, 1442635, 1442714, 1442813, 1443215, 1443215, 1443302, 1444000, 1444000, 1444313, 1444080, 1444448, 1444777, 1444928, 1444985, 1445234, 1445276, 1470716, 1457138, 1446134, 1446269, 1446269, 1446251, 1446251, 1446251, 1446472, 1446584, 1457168, 1446639, 1446736, 1446920, 1447374, 1448263, 1448417, 1448650, 1448696, 1448696, 1448777, 1448774, 1449229, 1449127, 1449508, 1449645, 1450142, 1450143, 1450621, 1450692, 1450814, 1450842, 1450859, 1457907, 1451515, 1451601, 1457155, 1451920, 1470003, 1452142, 1452168, 1452172, 1452590, 1468706, 1453273, 1471255, 1453370, 1453369, 1453756, 1453963, 1454026, 1454064, 1454116, 1454122, 1454262, 1454383, 1454405, 1454439, 1454913, 1454965, 1455047, 1455228, 1455165, 1455378, 1455470, 1455515, 1455515, 1455780, 1455780, 1455780, 1455838, 1455838, 1456182, 1456212, 1456271, 1456282, 1458086, 1470630, 1456352, 1456888, 1456271, 1456381, 1456271, 1456585, 1456639, 1456628, 1456888, 1456842, 1456811, 1458175, 1458317, 1458317, 1458364, 1458424, 1458548, 1458786, 1458987, 1459012, 1459060, 1459232, 1459254, 1459256, 1459505, 1459505, 1459583, 1459585, 1459603, 1459678, 1459716, 1459735, 1460041, 1460064, 1460100, 1460258, 1460433, 1460489, 1460539, 1460562, 1460590, 1460637, 1461198, 1460741, 1460775, 1460861, 1461130, 1461219, 1461287, 1461313, 1461528, 1461585, 1461689, 1461696, 1461748, 1461816, 1461896, 1461920, 1461947, 1462000, 1462046, 1462069, 1462118, 1462237, 1462275, 1462616, 1462616, 1462616, 1462399, 1462439, 1462586, 1462586, 1462586, 1462607, 1462616, 1462616, 1462618, 1462616, 1462725, 1462808, 1462854, 1462860, 1462853, 1462853, 1462860, 1463015, 1463015, 1463015, 1463069, 1463135, 1463348, 1463348, 1463348, 1463516, 1463572, 1463585, 1463620, 1463712, 1464434, 1463769, 1464080, 1464099, 1464103, 1464210, 1464523, 1464546, 1464592, 1464592, 1464631, 1464634, 1464634, 1464656, 1464664, 1464668, 1464747, 1464747, 1464747, 1464718, 1464752, 1464792, 1464835, 1464908, 1464908, 1465023, 1465068, 1465140, 1465182, 1465228, 1466027, 1466047, 1466077, 1466119, 1467636, 1466171, 1466187, 1466232, 1466268, 1466301, 1466409, 1465883, 1466017, 1465810, 1465822, 1465595, 1465770, 1467356, 1467356, 1465391, 1465393, 1465461, 1466501, 1466662, 1466689, 1470523, 1466739, 1466739, 1466809, 1466870, 1470508, 1466934, 1466976, 1466976, 1467079, 1470430, 1467264, 1469215, 1468243, 1468325, 1468370, 1468378, 1468521, 1468757, 1468953, 1469073, 1469260, 1469963, 1469499, 1469552, 1469566, 1469701, 1469763, 1469763, 1469848, 1469848, 1469848, 1469927, 1471979)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
| 0.00033 |
SELECT id FROM groups WHERE is_public=0 |
| 0.08112 |
SELECT post_id FROM posts_comments WHERE message LIKE "%12%" |
| 0.00031 |
SELECT id FROM searches WHERE user_id="" AND search_key="854d4c405a60d4c607d793686f1dd0b1" LIMIT 1 |
| 0.00029 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
| 0.00032 |
SELECT * FROM settings |
| 0.00123 |
CONNECT 49.12.223.183:9906 |
също е важно и как си направиш индексите
