0.00024 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00019 |
SELECT user_id FROM posts_reshares WHERE post_id="1393089" ORDER BY id DESC LIMIT 3 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="52495" LIMIT 1 |
0.00020 |
SELECT * FROM users_details WHERE user_id="17045" LIMIT 1 |
0.00023 |
SELECT * FROM users WHERE id="17045" LIMIT 1 |
0.00017 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="42629" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="42536" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="42535" LIMIT 2 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="42534" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="42532" LIMIT 1 |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1393089" ORDER BY id ASC |
0.00020 |
SELECT * FROM users_details WHERE user_id="356" LIMIT 1 |
0.00021 |
SELECT * FROM users WHERE id="356" LIMIT 1 |
0.00021 |
SELECT * FROM users_details WHERE user_id="710" LIMIT 1 |
0.00022 |
SELECT * FROM users WHERE id="710" LIMIT 1 |
0.00024 |
SELECT * FROM posts_comments WHERE post_id="1410187" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1411508" ORDER BY id ASC |
0.00017 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="61490" LIMIT 1 |
0.00017 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="61474" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="61469" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1415806" ORDER BY id ASC |
0.00023 |
SELECT * FROM posts_comments WHERE post_id="1419304" ORDER BY id ASC |
0.00023 |
SELECT * FROM posts_comments WHERE post_id="1419471" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="65338" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1419494" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1419494" LIMIT 1 |
0.00024 |
SELECT * FROM posts_comments WHERE post_id="1420985" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1428243" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="133963" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1464493" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464493" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_mentioned WHERE post_id="1464493" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138453" LIMIT 1 |
0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138447" LIMIT 1 |
0.00043 |
SELECT * FROM posts_comments WHERE post_id="1466379" ORDER BY id ASC |
0.10365 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%c++%" OR id IN(1393089, 1410187, 1411508, 1411508, 1411508, 1415806, 1415806, 1415806, 1415806, 1419494, 1464493, 1466379)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.49820 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%c++%" OR id IN(1393089, 1410187, 1411508, 1411508, 1411508, 1415806, 1415806, 1415806, 1415806, 1419494, 1464493, 1466379)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00032 |
SELECT id FROM groups WHERE is_public=0 |
0.08294 |
SELECT post_id FROM posts_comments WHERE message LIKE "%c++%" |
0.00028 |
SELECT id FROM searches WHERE user_id="" AND search_key="bda71bf29951949ebd788afacbff8245" LIMIT 1 |
0.00025 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00025 |
SELECT * FROM settings |
0.00101 |
CONNECT 49.12.223.183:9906 |
0.00012 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2355 |
object |
0.00012 |
SET |
f5dad|1000|n:1,userid:17045 |
TRUE |
0.00009 |
GET |
f5dad|1000|n:1,userid:17045 |
FALSE |
0.00010 |
GET |
f5dad|1000|n:1,userid:6039 |
object |
0.00011 |
SET |
f5dad|1000|n:1,userid:356 |
TRUE |
0.00004 |
GET |
f5dad|1000|n:1,userid:356 |
FALSE |
0.00006 |
GET |
f5dad|1000|n:1,groupid:22 |
object |
0.00011 |
SET |
f5dad|1000|n:1,userid:710 |
TRUE |
0.00008 |
GET |
f5dad|1000|n:1,userid:710 |
FALSE |
0.00007 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:4094 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:218 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:585 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:6135 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:360 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:12512 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:9542 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:1828 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00007 |
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.00011 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00029 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
Aug 03 2015, 14:50Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
по 1-2К пъти (пример http://go.shr.lc/1gDTuMq ). Ще има и текст процесинг, но в случая мисля, че не е толкова важен и няма да е толкова много.
@aviatrix нямам идея.. Ако в базата имам 100 записа - изчисленията ще са минимум 2, а могат да достигнат и до 100^2 макс за 1 цикъл.
Aug 03 2015, 15:03Btw, може да си изтеглиш vs code и да пишеш на c# на мак/линукс/уиндоус
Aug 03 2015, 18:34 през mobiСвалих си Xamarin + Mono за Mac-a и работи идеално.
Aug 03 2015, 18:39също става
Aug 03 2015, 20:07