0.00023 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1459292" ORDER BY id ASC |
0.00017 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="123808" LIMIT 1 |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1459768" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1461086" ORDER BY id ASC |
0.00071 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1461086" LIMIT 2 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1461136" ORDER BY id ASC |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="132971" LIMIT 2 |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1463907" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1463907" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1464862" ORDER BY id ASC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135040" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135031" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1465023" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1465023" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1465524" ORDER BY id ASC |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1466429" ORDER BY id ASC |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1467640" ORDER BY id ASC |
0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142944" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142943" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1468612" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468612" LIMIT 1 |
0.00033 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469218" LIMIT 1 |
0.00050 |
SELECT * FROM posts_comments WHERE post_id="1469519" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469519" LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470208" ORDER BY id ASC |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1471802" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471802" LIMIT 1 |
0.00039 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471802" LIMIT 2 |
0.02083 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%pain%" OR id IN(1375857, 1382475, 1387637, 1387855, 1390739, 1394002, 1395626, 1402179, 1417694, 1423424, 1470208, 1471802, 1440633, 1443149, 1444015, 1448123, 1448123, 1451080, 1451524, 1452224, 1453813, 1455069, 1455145, 1455216, 1456886, 1459768, 1461086, 1461136, 1463907, 1464862, 1465023, 1466429, 1465524, 1468612, 1469519)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.49994 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%pain%" OR id IN(1375857, 1382475, 1387637, 1387855, 1390739, 1394002, 1395626, 1402179, 1417694, 1423424, 1470208, 1471802, 1440633, 1443149, 1444015, 1448123, 1448123, 1451080, 1451524, 1452224, 1453813, 1455069, 1455145, 1455216, 1456886, 1459768, 1461086, 1461136, 1463907, 1464862, 1465023, 1466429, 1465524, 1468612, 1469519)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00044 |
SELECT id FROM groups WHERE is_public=0 |
0.08632 |
SELECT post_id FROM posts_comments WHERE message LIKE "%pain%" |
0.00058 |
SELECT id FROM searches WHERE user_id="" AND search_key="c873db3481b4aad61f7b32e0f17217d8" LIMIT 1 |
0.00065 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00035 |
SELECT * FROM settings |
0.00138 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:12618 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:17810 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:224 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:12512 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:6580 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6039 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:242 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00018 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:7879 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:16440 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00020 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00019 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00014 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00036 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
i can feel the pain
Aug 10 2020, 11:21Ah, the classic interview questions
Aug 15 2020, 11:45