0.00027 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1467373" ORDER BY id ASC |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1467914" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467914" LIMIT 2 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1468077" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468077" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_mentioned WHERE post_id="1468077" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1468336" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468336" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142523" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142520" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142500" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142499" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="142496" LIMIT 1 |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1468345" ORDER BY id ASC |
0.00029 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468345" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="143796" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="143794" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1469103" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144679" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1469512" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469512" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144690" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1469521" ORDER BY id ASC |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145068" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145064" LIMIT 2 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145061" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145056" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145034" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145031" LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1469665" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469665" LIMIT 1 |
0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="145870" LIMIT 1 |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1470107" ORDER BY id ASC |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1470333" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470622" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470622" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147199" LIMIT 1 |
0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147186" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1470964" ORDER BY id ASC |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1471742" ORDER BY id ASC |
0.00034 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471742" LIMIT 2 |
0.00778 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%vic%" OR id IN(1291424, 1304480, 1329747, 1331010, 1343975, 1349622, 1355026, 1467914, 1364605, 1366960, 1470333, 1470333, 1371456, 1385355, 1471742, 1396392, 1397033, 1442240, 1398574, 1399944, 1425950, 1401642, 1403207, 1403349, 1426672, 1404673, 1414301, 1415329, 1416046, 1460922, 1419310, 1422964, 1422964, 1423432, 1425745, 1427384, 1428551, 1430579, 1430579, 1431361, 1432957, 1433466, 1432825, 1436563, 1470964, 1440902, 1440980, 1441094, 1470964, 1446140, 1448798, 1450882, 1469512, 1452782, 1455051, 1470622, 1456226, 1459020, 1459755, 1459814, 1460781, 1460823, 1460970, 1461842, 1461872, 1461940, 1462447, 1463816, 1467373, 1470107, 1466131, 1466411, 1465432, 1465432, 1468077, 1468336, 1468345, 1469103, 1469665)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.48587 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%vic%" OR id IN(1291424, 1304480, 1329747, 1331010, 1343975, 1349622, 1355026, 1467914, 1364605, 1366960, 1470333, 1470333, 1371456, 1385355, 1471742, 1396392, 1397033, 1442240, 1398574, 1399944, 1425950, 1401642, 1403207, 1403349, 1426672, 1404673, 1414301, 1415329, 1416046, 1460922, 1419310, 1422964, 1422964, 1423432, 1425745, 1427384, 1428551, 1430579, 1430579, 1431361, 1432957, 1433466, 1432825, 1436563, 1470964, 1440902, 1440980, 1441094, 1470964, 1446140, 1448798, 1450882, 1469512, 1452782, 1455051, 1470622, 1456226, 1459020, 1459755, 1459814, 1460781, 1460823, 1460970, 1461842, 1461872, 1461940, 1462447, 1463816, 1467373, 1470107, 1466131, 1466411, 1465432, 1465432, 1468077, 1468336, 1468345, 1469103, 1469665)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00036 |
SELECT id FROM groups WHERE is_public=0 |
0.08132 |
SELECT post_id FROM posts_comments WHERE message LIKE "%vic%" |
0.00027 |
SELECT id FROM searches WHERE user_id="" AND search_key="462a38989558350ada1ec06d00988943" LIMIT 1 |
0.00030 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00034 |
SELECT * FROM settings |
0.00130 |
CONNECT 49.12.223.183:9906 |
0.00013 |
GET |
f5dad|1000|n:1,userid:1828 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:242 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:2043 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:3268 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00015 |
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:6354 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:6796 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:16440 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:269 |
object |
0.00019 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00013 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00035 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00002 |
CONNECT |
172.20.0.6:11211 |
TRUE |
изпълнява нещо някъде по някое време и ти вече можеш да видиш чак в резултатите какво се е случило. За да бъде по-сложно има и няколко различни типа SSR
Apr 15 2020, 00:42
Apr 15 2020, 00:42Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
https://developers.google.com/web/updates/201...on-the-web
и нещата стават комплексни. Аз лично си харесвам "Static SSR", но както виждаш и той има някой минуси. Отделно имаш и разни ограничения от инструментите или кода
Apr 15 2020, 00:44И няма нещо което да е като "silver bullet" или "one-size-fit-all".
Apr 15 2020, 00:44да, тези разлики ги знам, въпроса ми беше дали SPA-то ранква "по-нагоре" / е с преференции в днешно време пред ssr
Apr 16 2020, 22:55