0.00026 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="125643" LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1460555" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1460577" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1460930" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1460930" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_reshares WHERE post_id="1462004" ORDER BY id DESC LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1462004" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1462004" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="129598" LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1462307" ORDER BY id ASC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1464068" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464068" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="133605" LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1464344" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1465299" ORDER BY id ASC |
0.00039 |
SELECT * FROM posts_comments WHERE post_id="1466005" ORDER BY id ASC |
0.00019 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1466005" LIMIT 1 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1469220" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1469818" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469818" LIMIT 1 |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1470416" ORDER BY id ASC |
0.00022 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470416" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146927" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146922" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1470727" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470727" LIMIT 2 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1471297" ORDER BY id ASC |
0.00037 |
SELECT * FROM posts_comments WHERE post_id="1471742" ORDER BY id ASC |
0.00024 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471742" LIMIT 2 |
0.02091 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%ахахахахахаха%" OR id IN(1271387, 1291694, 1291866, 1291937, 1294489, 1320449, 1320303, 1324101, 1329531, 1344556, 1349338, 1351143, 1352267, 1449736, 1352396, 1352423, 1356794, 1358424, 1367901, 1370070, 1374244, 1378780, 1381410, 1385626, 1386297, 1386522, 1391222, 1391394, 1393453, 1471742, 1396348, 1396350, 1397929, 1400276, 1442432, 1409761, 1411645, 1416294, 1417391, 1417509, 1417906, 1418336, 1418667, 1422965, 1423585, 1464344, 1425616, 1427637, 1429306, 1429392, 1431359, 1437725, 1438197, 1438873, 1439682, 1470727, 1444483, 1471297, 1457165, 1446962, 1447332, 1452250, 1452428, 1452659, 1455860, 1456771, 1458223, 1459358, 1460555, 1460577, 1462004, 1462307, 1464068, 1465299, 1470416, 1469220, 1469818)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.68401 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%ахахахахахаха%" OR id IN(1271387, 1291694, 1291866, 1291937, 1294489, 1320449, 1320303, 1324101, 1329531, 1344556, 1349338, 1351143, 1352267, 1449736, 1352396, 1352423, 1356794, 1358424, 1367901, 1370070, 1374244, 1378780, 1381410, 1385626, 1386297, 1386522, 1391222, 1391394, 1393453, 1471742, 1396348, 1396350, 1397929, 1400276, 1442432, 1409761, 1411645, 1416294, 1417391, 1417509, 1417906, 1418336, 1418667, 1422965, 1423585, 1464344, 1425616, 1427637, 1429306, 1429392, 1431359, 1437725, 1438197, 1438873, 1439682, 1470727, 1444483, 1471297, 1457165, 1446962, 1447332, 1452250, 1452428, 1452659, 1455860, 1456771, 1458223, 1459358, 1460555, 1460577, 1462004, 1462307, 1464068, 1465299, 1470416, 1469220, 1469818)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00037 |
SELECT id FROM groups WHERE is_public=0 |
0.12097 |
SELECT post_id FROM posts_comments WHERE message LIKE "%ахахахахахаха%" |
0.00023 |
SELECT id FROM searches WHERE user_id="" AND search_key="4387897e0222342e36609f13863b7089" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00025 |
SELECT * FROM settings |
0.00129 |
CONNECT 49.12.223.183:9906 |
0.00023 |
GET |
f5dad|1000|n:1,userid:153 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2408 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:13677 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:16614 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:765 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6404 |
object |
0.00007 |
GET |
f5dad|1000|n:1,userid:18022 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:14704 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:15530 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2043 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6580 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:15883 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:16279 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:1828 |
object |
0.00008 |
GET |
f5dad|1000|n:1,userid:16907 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:936 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6354 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:3430 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:3930 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:16440 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:805 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:269 |
object |
0.00017 |
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.00028 |
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