0.00031 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1470621" ORDER BY id ASC |
0.00024 |
SELECT * FROM users_details WHERE user_id="18099" LIMIT 1 |
0.00035 |
SELECT * FROM users WHERE id="18099" LIMIT 1 |
0.00028 |
SELECT user_id FROM posts_reshares WHERE post_id="1470703" ORDER BY id DESC LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470703" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470703" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146927" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146922" LIMIT 1 |
0.00045 |
SELECT * FROM posts_comments WHERE post_id="1470727" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470727" LIMIT 2 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470797" ORDER BY id ASC |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470797" LIMIT 2 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471005" ORDER BY id ASC |
0.00030 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471005" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1471037" ORDER BY id ASC |
0.00021 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471037" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1471076" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471076" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471093" ORDER BY id ASC |
0.00041 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471093" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1471306" ORDER BY id ASC |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147696" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1471321" ORDER BY id ASC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471357" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471357" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147852" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147851" LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1471469" ORDER BY id ASC |
0.00044 |
SELECT * FROM posts_comments WHERE post_id="1471801" ORDER BY id ASC |
0.00272 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%shit%" OR id IN(1470409, 1444354, 1467637, 1291859, 1292380, 1470409, 1293925, 1293964, 1304390, 1316977, 1317752, 1319817, 1318837, 1467620, 1324649, 1329739, 1330438, 1333099, 1334878, 1335077, 1388647, 1340006, 1348857, 1467907, 1352919, 1356917, 1437080, 1362945, 1364672, 1374162, 1376736, 1376893, 1379157, 1379560, 1380746, 1467596, 1382709, 1383984, 1384422, 1385252, 1386900, 1387043, 1387157, 1387397, 1388196, 1388499, 1388499, 1390837, 1392022, 1444147, 1394582, 1394582, 1453555, 1396361, 1397217, 1397232, 1397597, 1398059, 1399143, 1400607, 1401907, 1402491, 1403016, 1403253, 1404932, 1405567, 1407083, 1407897, 1408077, 1409095, 1409664, 1410206, 1411712, 1414917, 1444254, 1416993, 1417172, 1417880, 1418498, 1418611, 1418586, 1471005, 1419926, 1420521, 1421859, 1421848, 1422938, 1423224, 1423639, 1423744, 1424116, 1424339, 1424747, 1424877, 1425379, 1426047, 1470245, 1471801, 1426639, 1426973, 1427359, 1471469, 1427651, 1427651, 1427651, 1427650, 1427904, 1428290, 1469202, 1467801, 1467465, 1429507, 1442989, 1431071, 1471357, 1431541, 1431541, 1431954, 1432736, 1433065, 1449110, 1433290, 1468279, 1433554, 1433554, 1433591, 1467440, 1434531, 1435232, 1435383, 1435503, 1435688, 1436087, 1436408, 1437164, 1437164, 1437457, 1438138, 1439004, 1471037, 1442281, 1470797, 1439903, 1442549, 1440050, 1440186, 1440342, 1451267, 1440507, 1440553, 1440589, 1470727, 1440827, 1441192, 1442702, 1457099, 1443188, 1443276, 1443799, 1444538, 1444777, 1444882, 1444894, 1445403, 1445828, 1446151, 1446872, 1457569, 1447980, 1448426, 1448555, 1448764, 1449246, 1471076, 1471076, 1450938, 1451404, 1469512, 1452143, 1452188, 1452188, 1452708, 1471093, 1457968, 1453347, 1453911, 1454103, 1454680, 1455257, 1455551, 1455580, 1455784, 1455804, 1456150, 1456218, 1456470, 1456470, 1456876, 1458412, 1458515, 1458865, 1459734, 1459806, 1459963, 1460178, 1460178, 1460178, 1460228, 1460793, 1461036, 1461047, 1461348, 1461437, 1461488, 1461822, 1461925, 1462607, 1462853, 1463055, 1463111, 1463124, 1463145, 1463439, 1463684, 1463769, 1463800, 1463838, 1465146, 1466138, 1466155, 1465774, 1466935, 1466935, 1469220, 1468325, 1468823, 1468829, 1469159, 1469332, 1469332, 1469445, 1469481, 1469512, 1469554, 1469671, 1469803)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.50720 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%shit%" OR id IN(1470409, 1444354, 1467637, 1291859, 1292380, 1470409, 1293925, 1293964, 1304390, 1316977, 1317752, 1319817, 1318837, 1467620, 1324649, 1329739, 1330438, 1333099, 1334878, 1335077, 1388647, 1340006, 1348857, 1467907, 1352919, 1356917, 1437080, 1362945, 1364672, 1374162, 1376736, 1376893, 1379157, 1379560, 1380746, 1467596, 1382709, 1383984, 1384422, 1385252, 1386900, 1387043, 1387157, 1387397, 1388196, 1388499, 1388499, 1390837, 1392022, 1444147, 1394582, 1394582, 1453555, 1396361, 1397217, 1397232, 1397597, 1398059, 1399143, 1400607, 1401907, 1402491, 1403016, 1403253, 1404932, 1405567, 1407083, 1407897, 1408077, 1409095, 1409664, 1410206, 1411712, 1414917, 1444254, 1416993, 1417172, 1417880, 1418498, 1418611, 1418586, 1471005, 1419926, 1420521, 1421859, 1421848, 1422938, 1423224, 1423639, 1423744, 1424116, 1424339, 1424747, 1424877, 1425379, 1426047, 1470245, 1471801, 1426639, 1426973, 1427359, 1471469, 1427651, 1427651, 1427651, 1427650, 1427904, 1428290, 1469202, 1467801, 1467465, 1429507, 1442989, 1431071, 1471357, 1431541, 1431541, 1431954, 1432736, 1433065, 1449110, 1433290, 1468279, 1433554, 1433554, 1433591, 1467440, 1434531, 1435232, 1435383, 1435503, 1435688, 1436087, 1436408, 1437164, 1437164, 1437457, 1438138, 1439004, 1471037, 1442281, 1470797, 1439903, 1442549, 1440050, 1440186, 1440342, 1451267, 1440507, 1440553, 1440589, 1470727, 1440827, 1441192, 1442702, 1457099, 1443188, 1443276, 1443799, 1444538, 1444777, 1444882, 1444894, 1445403, 1445828, 1446151, 1446872, 1457569, 1447980, 1448426, 1448555, 1448764, 1449246, 1471076, 1471076, 1450938, 1451404, 1469512, 1452143, 1452188, 1452188, 1452708, 1471093, 1457968, 1453347, 1453911, 1454103, 1454680, 1455257, 1455551, 1455580, 1455784, 1455804, 1456150, 1456218, 1456470, 1456470, 1456876, 1458412, 1458515, 1458865, 1459734, 1459806, 1459963, 1460178, 1460178, 1460178, 1460228, 1460793, 1461036, 1461047, 1461348, 1461437, 1461488, 1461822, 1461925, 1462607, 1462853, 1463055, 1463111, 1463124, 1463145, 1463439, 1463684, 1463769, 1463800, 1463838, 1465146, 1466138, 1466155, 1465774, 1466935, 1466935, 1469220, 1468325, 1468823, 1468829, 1469159, 1469332, 1469332, 1469445, 1469481, 1469512, 1469554, 1469671, 1469803)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00033 |
SELECT id FROM groups WHERE is_public=0 |
0.07424 |
SELECT post_id FROM posts_comments WHERE message LIKE "%shit%" |
0.00024 |
SELECT id FROM searches WHERE user_id="" AND search_key="5e82810cab95828f50923f6c07da3f92" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00026 |
SELECT * FROM settings |
0.00115 |
CONNECT 49.12.223.183:9906 |
всъщност е хубаво... ако можеш да направиш алгоритъм можеш да го напишеш на какъвто-и-да-е език.
Aug 09 2020, 22:04последната задача която имах е : от даден масив 1,3,4,90,9, конструирайте най голямото възможно число, примерен резултат: 990431
Aug 10 2020, 11:21и имах 20 мин да го направя. fuck this shit.
Aug 10 2020, 11:21е - това се прави действително за минутки. не е голяма беда.
Aug 12 2020, 01:36teach me master
Aug 13 2020, 12:18