0.00034 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1464751" ORDER BY id ASC |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1465430" ORDER BY id ASC |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1465854" ORDER BY id ASC |
0.00047 |
SELECT * FROM posts_comments WHERE post_id="1466138" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1466138" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1466270" ORDER BY id ASC |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138453" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138447" LIMIT 1 |
0.00040 |
SELECT * FROM posts_comments WHERE post_id="1466379" ORDER BY id ASC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1466807" ORDER BY id ASC |
0.00026 |
SELECT user_id FROM posts_reshares WHERE post_id="1467217" ORDER BY id DESC LIMIT 1 |
0.00037 |
SELECT * FROM posts_comments WHERE post_id="1467217" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1467488" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467488" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144338" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1469364" ORDER BY id ASC |
0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469364" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_mentioned WHERE post_id="1469364" LIMIT 1 |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1470235" ORDER BY id ASC |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147062" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147058" LIMIT 1 |
0.00042 |
SELECT * FROM posts_comments WHERE post_id="1470812" ORDER BY id ASC |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1471136" ORDER BY id ASC |
0.00023 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471136" LIMIT 1 |
0.00037 |
SELECT * FROM posts_comments WHERE post_id="1471629" ORDER BY id ASC |
0.00040 |
SELECT * FROM posts_comments WHERE post_id="1471742" ORDER BY id ASC |
0.00036 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471742" LIMIT 2 |
0.01125 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%JS%" OR id IN(1291880, 1293939, 1296303, 1318851, 1327614, 1331437, 1335763, 1335763, 1335763, 1338918, 1362971, 1363651, 1370662, 1370667, 1375967, 1381282, 1388629, 1390865, 1392980, 1471742, 1397466, 1399261, 1400101, 1400077, 1411991, 1471629, 1418157, 1467488, 1457829, 1430011, 1457829, 1457829, 1457829, 1470812, 1457476, 1447912, 1448167, 1448167, 1453810, 1454873, 1455514, 1471136, 1456271, 1460114, 1461254, 1461772, 1461772, 1461772, 1462961, 1464314, 1464546, 1464668, 1466138, 1466138, 1466270, 1466379, 1466379, 1465430, 1466807, 1467217, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.46335 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%JS%" OR id IN(1291880, 1293939, 1296303, 1318851, 1327614, 1331437, 1335763, 1335763, 1335763, 1338918, 1362971, 1363651, 1370662, 1370667, 1375967, 1381282, 1388629, 1390865, 1392980, 1471742, 1397466, 1399261, 1400101, 1400077, 1411991, 1471629, 1418157, 1467488, 1457829, 1430011, 1457829, 1457829, 1457829, 1470812, 1457476, 1447912, 1448167, 1448167, 1453810, 1454873, 1455514, 1471136, 1456271, 1460114, 1461254, 1461772, 1461772, 1461772, 1462961, 1464314, 1464546, 1464668, 1466138, 1466138, 1466270, 1466379, 1466379, 1465430, 1466807, 1467217, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00032 |
SELECT id FROM groups WHERE is_public=0 |
0.08227 |
SELECT post_id FROM posts_comments WHERE message LIKE "%JS%" |
0.00024 |
SELECT id FROM searches WHERE user_id="" AND search_key="f69f62bb48f5aae0000d8645449f92dc" LIMIT 1 |
0.00023 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00024 |
SELECT * FROM settings |
0.00152 |
CONNECT 49.12.223.183:9906 |
0.00012 |
GET |
f5dad|1000|n:1,post_app:1 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00012 |
GET |
f5dad|1000|n:1,groupid:242 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:8313 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:15903 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6039 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:18277 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:269 |
object |
0.00019 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00030 |
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