0.00024 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1468762" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468762" LIMIT 1 |
0.00050 |
SELECT * FROM posts_comments WHERE post_id="1468801" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1468874" ORDER BY id ASC |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1469180" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144023" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144011" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144009" LIMIT 1 |
0.00046 |
SELECT * FROM posts_comments WHERE post_id="1469202" ORDER BY id ASC |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144222" LIMIT 1 |
0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144219" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1469292" ORDER BY id ASC |
0.00028 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144338" LIMIT 1 |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1469364" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469364" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_mentioned WHERE post_id="1469364" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146068" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146055" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146042" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146032" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146031" LIMIT 1 |
0.00042 |
SELECT * FROM posts_comments WHERE post_id="1470241" ORDER BY id ASC |
0.00025 |
SELECT * FROM users_details WHERE user_id="5011" LIMIT 1 |
0.00027 |
SELECT * FROM users WHERE id="5011" LIMIT 1 |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1470745" ORDER BY id ASC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147062" LIMIT 1 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147058" LIMIT 1 |
0.00039 |
SELECT * FROM posts_comments WHERE post_id="1470812" ORDER BY id ASC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471127" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471127" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1471142" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1471216" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471216" LIMIT 1 |
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.00537 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%html%" OR id IN(1284871, 1292204, 1292693, 1293903, 1294821, 1294821, 1296085, 1296158, 1296303, 1308015, 1316183, 1315817, 1319256, 1319256, 1319256, 1319810, 1320677, 1321786, 1322152, 1322343, 1324492, 1324665, 1325972, 1360589, 1453530, 1336680, 1338551, 1339587, 1339675, 1339997, 1342409, 1344216, 1344514, 1348203, 1349198, 1349263, 1353555, 1361890, 1324755, 1364562, 1467889, 1368502, 1370071, 1373657, 1389095, 1376252, 1389133, 1379974, 1381161, 1381826, 1381844, 1382959, 1383443, 1383443, 1383199, 1383835, 1383835, 1383835, 1384352, 1386567, 1387230, 1388503, 1389734, 1390371, 1390954, 1391912, 1471742, 1394779, 1395023, 1395165, 1397466, 1397828, 1397864, 1397864, 1398745, 1400077, 1400247, 1425949, 1406334, 1409904, 1411496, 1411547, 1413343, 1413906, 1413915, 1444218, 1444247, 1416386, 1417384, 1417451, 1417451, 1417623, 1419073, 1419265, 1421246, 1421902, 1421902, 1421902, 1422987, 1422365, 1423744, 1423744, 1423744, 1457316, 1424008, 1471216, 1424755, 1424846, 1424846, 1424755, 1424755, 1424755, 1425076, 1426155, 1470241, 1426698, 1426816, 1427904, 1427904, 1428208, 1428208, 1428541, 1428664, 1428665, 1429034, 1429298, 1429298, 1429509, 1429609, 1429713, 1429713, 1430779, 1431056, 1431412, 1431953, 1470241, 1433915, 1471142, 1436673, 1437487, 1438348, 1438501, 1436567, 1438633, 1470812, 1440298, 1440482, 1470745, 1440802, 1441145, 1443013, 1443292, 1443830, 1444613, 1445731, 1457378, 1446768, 1446810, 1447097, 1447383, 1449528, 1457900, 1450814, 1452467, 1454383, 1471127, 1454908, 1455727, 1455769, 1458907, 1458971, 1459228, 1459956, 1460734, 1461192, 1461889, 1462593, 1463240, 1463431, 1463480, 1463597, 1463903, 1467373, 1464099, 1464237, 1464611, 1464656, 1464985, 1465023, 1466110, 1466132, 1466301, 1465607, 1465432, 1466739, 1466989, 1466989, 1469202, 1469180, 1468609, 1468762, 1468801, 1469292, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.49897 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%html%" OR id IN(1284871, 1292204, 1292693, 1293903, 1294821, 1294821, 1296085, 1296158, 1296303, 1308015, 1316183, 1315817, 1319256, 1319256, 1319256, 1319810, 1320677, 1321786, 1322152, 1322343, 1324492, 1324665, 1325972, 1360589, 1453530, 1336680, 1338551, 1339587, 1339675, 1339997, 1342409, 1344216, 1344514, 1348203, 1349198, 1349263, 1353555, 1361890, 1324755, 1364562, 1467889, 1368502, 1370071, 1373657, 1389095, 1376252, 1389133, 1379974, 1381161, 1381826, 1381844, 1382959, 1383443, 1383443, 1383199, 1383835, 1383835, 1383835, 1384352, 1386567, 1387230, 1388503, 1389734, 1390371, 1390954, 1391912, 1471742, 1394779, 1395023, 1395165, 1397466, 1397828, 1397864, 1397864, 1398745, 1400077, 1400247, 1425949, 1406334, 1409904, 1411496, 1411547, 1413343, 1413906, 1413915, 1444218, 1444247, 1416386, 1417384, 1417451, 1417451, 1417623, 1419073, 1419265, 1421246, 1421902, 1421902, 1421902, 1422987, 1422365, 1423744, 1423744, 1423744, 1457316, 1424008, 1471216, 1424755, 1424846, 1424846, 1424755, 1424755, 1424755, 1425076, 1426155, 1470241, 1426698, 1426816, 1427904, 1427904, 1428208, 1428208, 1428541, 1428664, 1428665, 1429034, 1429298, 1429298, 1429509, 1429609, 1429713, 1429713, 1430779, 1431056, 1431412, 1431953, 1470241, 1433915, 1471142, 1436673, 1437487, 1438348, 1438501, 1436567, 1438633, 1470812, 1440298, 1440482, 1470745, 1440802, 1441145, 1443013, 1443292, 1443830, 1444613, 1445731, 1457378, 1446768, 1446810, 1447097, 1447383, 1449528, 1457900, 1450814, 1452467, 1454383, 1471127, 1454908, 1455727, 1455769, 1458907, 1458971, 1459228, 1459956, 1460734, 1461192, 1461889, 1462593, 1463240, 1463431, 1463480, 1463597, 1463903, 1467373, 1464099, 1464237, 1464611, 1464656, 1464985, 1465023, 1466110, 1466132, 1466301, 1465607, 1465432, 1466739, 1466989, 1466989, 1469202, 1469180, 1468609, 1468762, 1468801, 1469292, 1469364)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00040 |
SELECT id FROM groups WHERE is_public=0 |
0.07915 |
SELECT post_id FROM posts_comments WHERE message LIKE "%html%" |
0.00028 |
SELECT id FROM searches WHERE user_id="" AND search_key="8e6465f35f6919360eb6bcd30394d373" LIMIT 1 |
0.00027 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00023 |
SELECT * FROM settings |
0.00101 |
CONNECT 49.12.223.183:9906 |
изпълнява нещо някъде по някое време и ти вече можеш да видиш чак в резултатите какво се е случило. За да бъде по-сложно има и няколко различни типа 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