0.00026 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1466317" ORDER BY id ASC |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1466317" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1466717" ORDER BY id ASC |
0.00021 |
SELECT user_id FROM posts_mentioned WHERE post_id="1466717" LIMIT 1 |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1467637" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467637" LIMIT 1 |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468283" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1468396" ORDER BY id ASC |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1468403" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468403" LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1469169" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1469253" ORDER BY id ASC |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1469335" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469335" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144611" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144600" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144585" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144579" LIMIT 1 |
0.00045 |
SELECT * FROM posts_comments WHERE post_id="1469481" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469481" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1469579" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469975" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1470702" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470702" LIMIT 1 |
0.00054 |
SELECT * FROM posts_comments WHERE post_id="1470965" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470965" LIMIT 1 |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1471801" ORDER BY id ASC |
0.00939 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%мото%" OR id IN(1291589, 1292417, 1296035, 1298036, 1304480, 1305938, 1316540, 1318208, 1318289, 1318289, 1319115, 1323153, 1324090, 1331375, 1335626, 1336089, 1337476, 1337321, 1338872, 1344045, 1389837, 1351633, 1353250, 1353425, 1354119, 1357935, 1364853, 1364853, 1368500, 1369357, 1369357, 1369775, 1369883, 1378721, 1379687, 1382147, 1382147, 1382670, 1382709, 1385046, 1384332, 1385115, 1385807, 1386717, 1387248, 1388476, 1390485, 1391241, 1391241, 1392678, 1392788, 1393426, 1395436, 1421142, 1396483, 1397471, 1397925, 1398118, 1398291, 1399423, 1399493, 1400748, 1401389, 1401984, 1403871, 1404796, 1405235, 1405235, 1407619, 1408013, 1410671, 1410896, 1411023, 1413403, 1414301, 1414896, 1415034, 1416128, 1416472, 1418196, 1425905, 1418344, 1420936, 1420952, 1423378, 1423822, 1425183, 1425196, 1426079, 1471801, 1428269, 1429641, 1429625, 1430390, 1432216, 1433591, 1433659, 1434733, 1434880, 1435981, 1470965, 1437933, 1438308, 1439135, 1439209, 1442855, 1442850, 1443325, 1445731, 1444689, 1470702, 1446581, 1447469, 1448858, 1449516, 1450828, 1458010, 1455184, 1455228, 1455757, 1455543, 1455855, 1456218, 1456839, 1456907, 1458572, 1458572, 1458586, 1458756, 1459146, 1459146, 1459146, 1459146, 1459146, 1459590, 1459857, 1460225, 1461111, 1461746, 1461746, 1461842, 1462433, 1462744, 1462807, 1462798, 1463039, 1463409, 1463630, 1464505, 1464403, 1464720, 1469169, 1465183, 1465186, 1466236, 1466317, 1465883, 1465992, 1465616, 1465430, 1466717, 1468403, 1468403, 1469253, 1469335, 1469481, 1469579)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.55728 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%мото%" OR id IN(1291589, 1292417, 1296035, 1298036, 1304480, 1305938, 1316540, 1318208, 1318289, 1318289, 1319115, 1323153, 1324090, 1331375, 1335626, 1336089, 1337476, 1337321, 1338872, 1344045, 1389837, 1351633, 1353250, 1353425, 1354119, 1357935, 1364853, 1364853, 1368500, 1369357, 1369357, 1369775, 1369883, 1378721, 1379687, 1382147, 1382147, 1382670, 1382709, 1385046, 1384332, 1385115, 1385807, 1386717, 1387248, 1388476, 1390485, 1391241, 1391241, 1392678, 1392788, 1393426, 1395436, 1421142, 1396483, 1397471, 1397925, 1398118, 1398291, 1399423, 1399493, 1400748, 1401389, 1401984, 1403871, 1404796, 1405235, 1405235, 1407619, 1408013, 1410671, 1410896, 1411023, 1413403, 1414301, 1414896, 1415034, 1416128, 1416472, 1418196, 1425905, 1418344, 1420936, 1420952, 1423378, 1423822, 1425183, 1425196, 1426079, 1471801, 1428269, 1429641, 1429625, 1430390, 1432216, 1433591, 1433659, 1434733, 1434880, 1435981, 1470965, 1437933, 1438308, 1439135, 1439209, 1442855, 1442850, 1443325, 1445731, 1444689, 1470702, 1446581, 1447469, 1448858, 1449516, 1450828, 1458010, 1455184, 1455228, 1455757, 1455543, 1455855, 1456218, 1456839, 1456907, 1458572, 1458572, 1458586, 1458756, 1459146, 1459146, 1459146, 1459146, 1459146, 1459590, 1459857, 1460225, 1461111, 1461746, 1461746, 1461842, 1462433, 1462744, 1462807, 1462798, 1463039, 1463409, 1463630, 1464505, 1464403, 1464720, 1469169, 1465183, 1465186, 1466236, 1466317, 1465883, 1465992, 1465616, 1465430, 1466717, 1468403, 1468403, 1469253, 1469335, 1469481, 1469579)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00046 |
SELECT id FROM groups WHERE is_public=0 |
0.09880 |
SELECT post_id FROM posts_comments WHERE message LIKE "%мото%" |
0.00023 |
SELECT id FROM searches WHERE user_id="" AND search_key="72e03113ff4bf53243dde41359c5f3cb" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00032 |
SELECT * FROM settings |
0.00146 |
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