0.00023 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="73944" LIMIT 2 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1426568" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1427703" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1428930" ORDER BY id ASC |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1432800" ORDER BY id ASC |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1436538" LIMIT 1 |
0.00037 |
SELECT * FROM posts_comments WHERE post_id="1439402" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1439402" LIMIT 1 |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1445252" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1450143" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1450143" LIMIT 1 |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1459931" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1459931" LIMIT 1 |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1460205" ORDER BY id ASC |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="132904" LIMIT 2 |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1463878" ORDER BY id ASC |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1464891" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1467288" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467288" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147062" LIMIT 1 |
0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147058" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1470812" ORDER BY id ASC |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1471232" ORDER BY id ASC |
0.00043 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471232" LIMIT 1 |
0.07355 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%SQL%" OR id IN(1294885, 1294885, 1294885, 1294885, 1294885, 1323401, 1323401, 1323401, 1324492, 1324626, 1324755, 1333011, 1341395, 1324755, 1378196, 1380752, 1384177, 1384765, 1387851, 1402029, 1407644, 1415315, 1415315, 1415315, 1415315, 1423096, 1426568, 1428930, 1428930, 1467288, 1470812, 1439402, 1450143, 1471232, 1463878, 1464891)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.50909 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%SQL%" OR id IN(1294885, 1294885, 1294885, 1294885, 1294885, 1323401, 1323401, 1323401, 1324492, 1324626, 1324755, 1333011, 1341395, 1324755, 1378196, 1380752, 1384177, 1384765, 1387851, 1402029, 1407644, 1415315, 1415315, 1415315, 1415315, 1423096, 1426568, 1428930, 1428930, 1467288, 1470812, 1439402, 1450143, 1471232, 1463878, 1464891)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00036 |
SELECT id FROM groups WHERE is_public=0 |
0.09367 |
SELECT post_id FROM posts_comments WHERE message LIKE "%SQL%" |
0.00038 |
SELECT id FROM searches WHERE user_id="" AND search_key="0865cdc031bd7bf64d2a8a9f6e6dfa86" LIMIT 1 |
0.00038 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00037 |
SELECT * FROM settings |
0.00282 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:6596 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:218 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6623 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6580 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00019 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00020 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00034 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
oh damn
Sep 05 2018, 11:18Вече 24 часа борим един SQL Server да спасим 1.2Г база... после машината се убива и никога повече RDP навън ей-тъй пуснато
Sep 05 2018, 14:04аз ползвам hardware firewall, който е конфигуриран да позволява само моето IP за RDP, + цялата виртуалак където е сървъра се бекъпва всяка вечер
Sep 05 2018, 17:35Така може. Или ако използваш RDPGuard или софтуер за локване на RDP със local policy
Sep 05 2018, 18:41