0.00025 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00023 |
SELECT user_id FROM posts_reshares WHERE post_id="1462071" ORDER BY id DESC LIMIT 2 |
0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="129052" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1462071" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462071" LIMIT 1 |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462650" LIMIT 1 |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462746" LIMIT 1 |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462862" LIMIT 1 |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462919" LIMIT 1 |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1463424" LIMIT 1 |
0.00057 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1463633" LIMIT 1 |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464028" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1464374" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464374" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_mentioned WHERE post_id="1464374" LIMIT 1 |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464489" LIMIT 1 |
0.00025 |
SELECT user_id FROM posts_reshares WHERE post_id="1464666" ORDER BY id DESC LIMIT 1 |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464666" LIMIT 1 |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464739" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_reshares WHERE post_id="1464885" ORDER BY id DESC LIMIT 1 |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464885" LIMIT 1 |
0.00023 |
SELECT * FROM users_details WHERE user_id="269" LIMIT 1 |
0.00027 |
SELECT * FROM users WHERE id="269" LIMIT 1 |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464898" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_reshares WHERE post_id="1465026" ORDER BY id DESC LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135038" LIMIT 1 |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1465026" ORDER BY id ASC |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1465026" LIMIT 1 |
0.01566 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%seo%" OR id IN(1304535, 1304535, 1470325, 1376207, 1383149, 1383149, 1383149, 1383149, 1470259, 1470259, 1396053, 1411139, 1432457, 1418708, 1418708, 1418708, 1418708, 1470246, 1430576, 1431361, 1431442, 1432119, 1470246, 1443428, 1444045, 1446768, 1446768, 1456238, 1459035, 1459280, 1461029, 1465531, 1464374)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 45, 15 |
0.47176 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%seo%" OR id IN(1304535, 1304535, 1470325, 1376207, 1383149, 1383149, 1383149, 1383149, 1470259, 1470259, 1396053, 1411139, 1432457, 1418708, 1418708, 1418708, 1418708, 1470246, 1430576, 1431361, 1431442, 1432119, 1470246, 1443428, 1444045, 1446768, 1446768, 1456238, 1459035, 1459280, 1461029, 1465531, 1464374)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00028 |
SELECT id FROM groups WHERE is_public=0 |
0.07128 |
SELECT post_id FROM posts_comments WHERE message LIKE "%seo%" |
0.00025 |
SELECT id FROM searches WHERE user_id="" AND search_key="f83aa5e6720e99c01fc7a1ecd05f93f0" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00022 |
SELECT * FROM settings |
0.00093 |
CONNECT 49.12.223.183:9906 |
0.00013 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00013 |
SET |
f5dad|1000|n:1,userid:269 |
TRUE |
0.00006 |
GET |
f5dad|1000|n:1,userid:269 |
FALSE |
0.00009 |
GET |
f5dad|1000|n:1,groupid:5 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00005 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00005 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00005 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00027 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
May 12 2015, 00:37Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
И още един вариант... http://en.wikipedia.org/wiki/XML_external_entity_attack
ДНС-ите е напълно възможна атака - виж на единия слайд как от 200 ms скача на 400-500 ms. Ако направиш DDoS на ДНС и сайта все едно ще го няма.
May 12 2015, 00:38Хах, не съм QA, но интересни неща научих за XML-ите туко-що
May 13 2015, 00:12Technical Support Team Leader... ам не врат ам шия... шибваш им на девовете един такъв XML и гледаш как сървърите падат като круши.
May 13 2015, 01:41Е, те са ми аверчета, няма да ги тормозя
May 13 2015, 21:26