| 0.00025 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
| 0.00027 |
SELECT * FROM posts_comments WHERE post_id="1469865" ORDER BY id ASC |
| 0.00019 |
SELECT user_id FROM posts_reshares WHERE post_id="1469903" ORDER BY id DESC LIMIT 1 |
| 0.00026 |
SELECT * FROM posts_comments WHERE post_id="1469903" ORDER BY id ASC |
| 0.00029 |
SELECT * FROM posts_comments WHERE post_id="1469931" ORDER BY id ASC |
| 0.00023 |
SELECT user_id FROM posts_reshares WHERE post_id="1469973" ORDER BY id DESC LIMIT 2 |
| 0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470177" LIMIT 1 |
| 0.00029 |
SELECT * FROM posts_comments WHERE post_id="1470182" ORDER BY id ASC |
| 0.00051 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470182" LIMIT 1 |
| 0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470730" ORDER BY id ASC |
| 0.00031 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470730" LIMIT 1 |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1470784" ORDER BY id ASC |
| 0.00034 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470784" LIMIT 1 |
| 0.00039 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470877" LIMIT 1 |
| 0.00056 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147244" LIMIT 1 |
| 0.00048 |
SELECT * FROM posts_comments WHERE post_id="1471009" ORDER BY id ASC |
| 0.00037 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471009" LIMIT 1 |
| 0.00031 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471082" LIMIT 1 |
| 0.00053 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471120" LIMIT 1 |
| 0.00115 |
SELECT * FROM posts_comments WHERE post_id="1471357" ORDER BY id ASC |
| 0.00034 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471357" LIMIT 1 |
| 0.00048 |
SELECT * FROM posts_comments WHERE post_id="1471505" ORDER BY id ASC |
| 0.00042 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471505" LIMIT 1 |
| 0.00033 |
SELECT * FROM posts_comments WHERE post_id="1471802" ORDER BY id ASC |
| 0.00030 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471802" LIMIT 1 |
| 0.00034 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471802" LIMIT 2 |
| 0.00384 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%ass%" OR id IN(1453442, 1467637, 1389284, 1296046, 1442983, 1319198, 1319198, 1322074, 1323561, 1327879, 1330657, 1334281, 1334281, 1336803, 1341415, 1342129, 1345986, 1350411, 1350994, 1389436, 1389436, 1413581, 1361491, 1362479, 1363626, 1365257, 1366718, 1367906, 1370880, 1376243, 1378835, 1379888, 1388624, 1382475, 1467596, 1382985, 1387375, 1387594, 1387675, 1387698, 1390224, 1390649, 1391346, 1457696, 1392859, 1392859, 1393895, 1394020, 1393937, 1394869, 1395358, 1395642, 1396348, 1396841, 1397092, 1442230, 1397770, 1400386, 1463900, 1463878, 1401237, 1401341, 1401034, 1401341, 1401719, 1402013, 1402512, 1402779, 1403016, 1404594, 1405468, 1408631, 1410289, 1410290, 1411003, 1411496, 1414113, 1414179, 1444246, 1430113, 1415806, 1415806, 1416692, 1416692, 1417376, 1418358, 1418623, 1419428, 1419598, 1419708, 1419781, 1420640, 1420964, 1422685, 1422990, 1423142, 1457316, 1423864, 1437208, 1424707, 1424755, 1424957, 1425745, 1471802, 1468043, 1429137, 1429664, 1429659, 1431361, 1431832, 1467461, 1440970, 1432308, 1432878, 1432952, 1433262, 1457045, 1433882, 1433947, 1433915, 1434219, 1435412, 1457817, 1436125, 1436087, 1436125, 1436224, 1471009, 1441613, 1441613, 1441613, 1441613, 1441613, 1470730, 1457375, 1437474, 1438102, 1438501, 1438529, 1438529, 1438804, 1438884, 1439644, 1439829, 1439903, 1470784, 1440058, 1440058, 1440058, 1440199, 1440361, 1440511, 1440545, 1441613, 1441328, 1441613, 1441613, 1441613, 1441613, 1441613, 1441613, 1461819, 1442594, 1442635, 1442721, 1442721, 1442790, 1443433, 1443452, 1444273, 1444894, 1444897, 1444939, 1445487, 1457124, 1445770, 1446075, 1446186, 1457155, 1446251, 1447110, 1447374, 1447383, 1457667, 1448669, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449454, 1449528, 1449637, 1450158, 1450259, 1450336, 1450443, 1450686, 1451034, 1451850, 1452503, 1452700, 1453319, 1453888, 1454644, 1455592, 1456764, 1458316, 1458623, 1458666, 1459327, 1459666, 1459857, 1460268, 1460325, 1460439, 1460457, 1460641, 1460738, 1461019, 1461388, 1461582, 1461635, 1461843, 1461852, 1461869, 1461937, 1462147, 1462257, 1462434, 1462499, 1462499, 1462569, 1463419, 1463532, 1463585, 1463878, 1463878, 1464004, 1464452, 1464452, 1464810, 1464810, 1465251, 1470182, 1466138, 1466429, 1465782, 1465779, 1465779, 1465833, 1465587, 1465587, 1465622, 1465622, 1466794, 1466962, 1467280, 1468181, 1469225, 1468319, 1468329, 1468345, 1468778, 1468929, 1469106, 1469402, 1469566, 1469654, 1469761, 1469843, 1469865, 1469903)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
| 0.51011 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%ass%" OR id IN(1453442, 1467637, 1389284, 1296046, 1442983, 1319198, 1319198, 1322074, 1323561, 1327879, 1330657, 1334281, 1334281, 1336803, 1341415, 1342129, 1345986, 1350411, 1350994, 1389436, 1389436, 1413581, 1361491, 1362479, 1363626, 1365257, 1366718, 1367906, 1370880, 1376243, 1378835, 1379888, 1388624, 1382475, 1467596, 1382985, 1387375, 1387594, 1387675, 1387698, 1390224, 1390649, 1391346, 1457696, 1392859, 1392859, 1393895, 1394020, 1393937, 1394869, 1395358, 1395642, 1396348, 1396841, 1397092, 1442230, 1397770, 1400386, 1463900, 1463878, 1401237, 1401341, 1401034, 1401341, 1401719, 1402013, 1402512, 1402779, 1403016, 1404594, 1405468, 1408631, 1410289, 1410290, 1411003, 1411496, 1414113, 1414179, 1444246, 1430113, 1415806, 1415806, 1416692, 1416692, 1417376, 1418358, 1418623, 1419428, 1419598, 1419708, 1419781, 1420640, 1420964, 1422685, 1422990, 1423142, 1457316, 1423864, 1437208, 1424707, 1424755, 1424957, 1425745, 1471802, 1468043, 1429137, 1429664, 1429659, 1431361, 1431832, 1467461, 1440970, 1432308, 1432878, 1432952, 1433262, 1457045, 1433882, 1433947, 1433915, 1434219, 1435412, 1457817, 1436125, 1436087, 1436125, 1436224, 1471009, 1441613, 1441613, 1441613, 1441613, 1441613, 1470730, 1457375, 1437474, 1438102, 1438501, 1438529, 1438529, 1438804, 1438884, 1439644, 1439829, 1439903, 1470784, 1440058, 1440058, 1440058, 1440199, 1440361, 1440511, 1440545, 1441613, 1441328, 1441613, 1441613, 1441613, 1441613, 1441613, 1441613, 1461819, 1442594, 1442635, 1442721, 1442721, 1442790, 1443433, 1443452, 1444273, 1444894, 1444897, 1444939, 1445487, 1457124, 1445770, 1446075, 1446186, 1457155, 1446251, 1447110, 1447374, 1447383, 1457667, 1448669, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449235, 1449454, 1449528, 1449637, 1450158, 1450259, 1450336, 1450443, 1450686, 1451034, 1451850, 1452503, 1452700, 1453319, 1453888, 1454644, 1455592, 1456764, 1458316, 1458623, 1458666, 1459327, 1459666, 1459857, 1460268, 1460325, 1460439, 1460457, 1460641, 1460738, 1461019, 1461388, 1461582, 1461635, 1461843, 1461852, 1461869, 1461937, 1462147, 1462257, 1462434, 1462499, 1462499, 1462569, 1463419, 1463532, 1463585, 1463878, 1463878, 1464004, 1464452, 1464452, 1464810, 1464810, 1465251, 1470182, 1466138, 1466429, 1465782, 1465779, 1465779, 1465833, 1465587, 1465587, 1465622, 1465622, 1466794, 1466962, 1467280, 1468181, 1469225, 1468319, 1468329, 1468345, 1468778, 1468929, 1469106, 1469402, 1469566, 1469654, 1469761, 1469843, 1469865, 1469903)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
| 0.00039 |
SELECT id FROM groups WHERE is_public=0 |
| 0.10140 |
SELECT post_id FROM posts_comments WHERE message LIKE "%ass%" |
| 0.00059 |
SELECT id FROM searches WHERE user_id="" AND search_key="a4a5c64a4d2e2b8f9ec858c25d92fbce" LIMIT 1 |
| 0.00045 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
| 0.00052 |
SELECT * FROM settings |
| 0.00235 |
CONNECT 49.12.223.183:9906 |
)) 
i can feel the pain
Aug 10 2020, 11:21Ah, the classic interview questions
Aug 15 2020, 11:45