0.00035 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1448700" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1449037" ORDER BY id ASC |
0.00040 |
SELECT * FROM posts_comments WHERE post_id="1449430" ORDER BY id ASC |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1450053" ORDER BY id ASC |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1450053" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1450481" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1451195" ORDER BY id ASC |
0.00027 |
SELECT user_id FROM posts_reshares WHERE post_id="1451612" ORDER BY id DESC LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="108788" LIMIT 1 |
0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="108783" LIMIT 1 |
0.00028 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="108757" LIMIT 1 |
0.00028 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="108754" LIMIT 1 |
0.00032 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="108752" LIMIT 1 |
0.00042 |
SELECT * FROM posts_comments WHERE post_id="1451612" ORDER BY id ASC |
0.00027 |
SELECT user_id FROM posts_mentioned WHERE post_id="1451612" LIMIT 8 |
0.00029 |
SELECT user_id FROM posts_reshares WHERE post_id="1452018" ORDER BY id DESC LIMIT 1 |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1452018" ORDER BY id ASC |
0.00056 |
SELECT * FROM posts_comments WHERE post_id="1452644" ORDER BY id ASC |
0.00030 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1452644" LIMIT 1 |
0.00026 |
SELECT user_id FROM posts_reshares WHERE post_id="1452705" ORDER BY id DESC LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1452705" ORDER BY id ASC |
0.00055 |
SELECT * FROM posts_comments WHERE post_id="1452842" ORDER BY id ASC |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1452861" ORDER BY id ASC |
0.04530 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Алкохол%" OR id IN(1291342, 1291682, 1291810, 1314922, 1315817, 1308719, 1318236, 1322215, 1328579, 1330239, 1331437, 1331437, 1331437, 1331437, 1336267, 1342165, 1344213, 1344286, 1344286, 1345611, 1348093, 1351331, 1351331, 1354350, 1359888, 1362589, 1363929, 1368868, 1373994, 1374347, 1378747, 1378747, 1382258, 1386727, 1387648, 1387648, 1387774, 1388285, 1388285, 1388450, 1388622, 1388622, 1425997, 1390485, 1390653, 1391075, 1391264, 1392202, 1392634, 1393456, 1394654, 1395036, 1395763, 1396963, 1400614, 1398485, 1398907, 1398981, 1399183, 1400614, 1400614, 1400769, 1401323, 1401584, 1401987, 1402394, 1404168, 1404682, 1410166, 1410289, 1412309, 1412363, 1412363, 1413998, 1414917, 1416472, 1416865, 1417044, 1418337, 1420384, 1422248, 1423302, 1424050, 1424780, 1424780, 1425239, 1425239, 1425239, 1426523, 1427310, 1427397, 1427397, 1427613, 1427795, 1427822, 1428024, 1428024, 1428024, 1428492, 1428492, 1428592, 1428877, 1429021, 1429021, 1429021, 1429021, 1429021, 1429625, 1429876, 1429876, 1430666, 1447374, 1436854, 1436854, 1436854, 1436854, 1441604, 1437346, 1437697, 1438566, 1451195, 1440783, 1441398, 1441793, 1441793, 1442832, 1443237, 1443237, 1443326, 1445365, 1446349, 1446546, 1447374, 1447374, 1457677, 1449037, 1449430, 1449430, 1450053, 1450481, 1451612, 1452018, 1452018, 1452705, 1454770, 1454939, 1468723, 1456218, 1456280, 1456280, 1456352, 1458929, 1458929, 1459700, 1459862, 1459862, 1459862, 1459911, 1460115, 1460115, 1460217, 1460837, 1461790, 1461790, 1462294, 1462298, 1462519, 1462544, 1462544, 1462593, 1462593, 1463332, 1464031, 1464434, 1465056, 1466169, 1465829, 1468388, 1468426, 1468426, 1468426, 1468426)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 45, 15 |
0.68727 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Алкохол%" OR id IN(1291342, 1291682, 1291810, 1314922, 1315817, 1308719, 1318236, 1322215, 1328579, 1330239, 1331437, 1331437, 1331437, 1331437, 1336267, 1342165, 1344213, 1344286, 1344286, 1345611, 1348093, 1351331, 1351331, 1354350, 1359888, 1362589, 1363929, 1368868, 1373994, 1374347, 1378747, 1378747, 1382258, 1386727, 1387648, 1387648, 1387774, 1388285, 1388285, 1388450, 1388622, 1388622, 1425997, 1390485, 1390653, 1391075, 1391264, 1392202, 1392634, 1393456, 1394654, 1395036, 1395763, 1396963, 1400614, 1398485, 1398907, 1398981, 1399183, 1400614, 1400614, 1400769, 1401323, 1401584, 1401987, 1402394, 1404168, 1404682, 1410166, 1410289, 1412309, 1412363, 1412363, 1413998, 1414917, 1416472, 1416865, 1417044, 1418337, 1420384, 1422248, 1423302, 1424050, 1424780, 1424780, 1425239, 1425239, 1425239, 1426523, 1427310, 1427397, 1427397, 1427613, 1427795, 1427822, 1428024, 1428024, 1428024, 1428492, 1428492, 1428592, 1428877, 1429021, 1429021, 1429021, 1429021, 1429021, 1429625, 1429876, 1429876, 1430666, 1447374, 1436854, 1436854, 1436854, 1436854, 1441604, 1437346, 1437697, 1438566, 1451195, 1440783, 1441398, 1441793, 1441793, 1442832, 1443237, 1443237, 1443326, 1445365, 1446349, 1446546, 1447374, 1447374, 1457677, 1449037, 1449430, 1449430, 1450053, 1450481, 1451612, 1452018, 1452018, 1452705, 1454770, 1454939, 1468723, 1456218, 1456280, 1456280, 1456352, 1458929, 1458929, 1459700, 1459862, 1459862, 1459862, 1459911, 1460115, 1460115, 1460217, 1460837, 1461790, 1461790, 1462294, 1462298, 1462519, 1462544, 1462544, 1462593, 1462593, 1463332, 1464031, 1464434, 1465056, 1466169, 1465829, 1468388, 1468426, 1468426, 1468426, 1468426)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00035 |
SELECT id FROM groups WHERE is_public=0 |
0.11644 |
SELECT post_id FROM posts_comments WHERE message LIKE "%Алкохол%" |
0.00030 |
SELECT id FROM searches WHERE user_id="" AND search_key="e87c578817c8b5426e15ee4237db84bc" LIMIT 1 |
0.00031 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00032 |
SELECT * FROM settings |
0.00125 |
CONNECT 49.12.223.183:9906 |
0.00015 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:765 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:17996 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00017 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:14704 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:17632 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6135 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00017 |
GET |
f5dad|1000|n:1,userid:3268 |
object |
0.00018 |
GET |
f5dad|1000|n:1,userid:9259 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:17810 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:9542 |
object |
0.00045 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00017 |
GET |
f5dad|1000|n:1,userid:12512 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00011 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00028 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00001 |
CONNECT |
172.20.0.6:11211 |
TRUE |
Oct 12 2013, 23:23Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
this might explain it : http://xkcd.com/323/
аз като кодирах за проекта, заради което отидох на национално по ИТ, бях на градус през повечето време
Oct 12 2013, 23:30Well that explains everything!
Oct 13 2013, 12:27