0.00034 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00025 |
SELECT * FROM posts_comments WHERE post_id="1468609" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468609" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1468762" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1468762" LIMIT 1 |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1468801" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1468874" ORDER BY id ASC |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1469180" ORDER BY id ASC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144023" LIMIT 1 |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144011" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144009" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1469202" ORDER BY id ASC |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144222" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="144219" LIMIT 1 |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1469292" ORDER BY id ASC |
0.00018 |
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.00021 |
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.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146068" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146055" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146042" LIMIT 1 |
0.00017 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146032" LIMIT 1 |
0.00018 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="146031" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1470241" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1470745" ORDER BY id ASC |
0.00019 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147062" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147058" LIMIT 1 |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1470812" ORDER BY id ASC |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1471127" ORDER BY id ASC |
0.00021 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471127" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471142" ORDER BY id ASC |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1471216" ORDER BY id ASC |
0.00020 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471216" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1471742" ORDER BY id ASC |
0.00022 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471742" LIMIT 2 |
0.00928 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%PSD to HTML%" OR MATCH(message) AGAINST("+PSD +to +HTML" IN BOOLEAN MODE) OR id IN(1284871, 1292204, 1292693, 1294821, 1294821, 1296085, 1296158, 1296303, 1308015, 1316183, 1315817, 1319256, 1319256, 1319256, 1319810, 1320677, 1321786, 1322152, 1322343, 1324492, 1324665, 1325972, 1360589, 1336680, 1338551, 1339587, 1339675, 1339997, 1342409, 1344216, 1344514, 1348203, 1349198, 1349263, 1353555, 1324755, 1364562, 1467889, 1368502, 1370071, 1373657, 1389095, 1376252, 1379974, 1381161, 1381826, 1381844, 1382959, 1383835, 1383835, 1383835, 1386567, 1387230, 1388503, 1389734, 1390371, 1390954, 1391912, 1471742, 1394779, 1395023, 1395165, 1397828, 1397864, 1397864, 1398745, 1400077, 1400247, 1425949, 1406334, 1409904, 1411496, 1411547, 1413343, 1413906, 1413915, 1444218, 1444247, 1416386, 1417384, 1417451, 1417451, 1417623, 1419073, 1421246, 1422987, 1422365, 1457316, 1471216, 1424755, 1424755, 1424755, 1424755, 1425076, 1426155, 1470241, 1426816, 1427904, 1427904, 1428208, 1428208, 1428541, 1428664, 1428665, 1429034, 1429298, 1429509, 1429713, 1429713, 1431056, 1431953, 1470241, 1433915, 1471142, 1436673, 1437487, 1438348, 1438501, 1436567, 1438633, 1470812, 1440298, 1470745, 1440802, 1441145, 1443013, 1443830, 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, 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 |
1.38185 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%PSD to HTML%" OR MATCH(message) AGAINST("+PSD +to +HTML" IN BOOLEAN MODE) OR id IN(1284871, 1292204, 1292693, 1294821, 1294821, 1296085, 1296158, 1296303, 1308015, 1316183, 1315817, 1319256, 1319256, 1319256, 1319810, 1320677, 1321786, 1322152, 1322343, 1324492, 1324665, 1325972, 1360589, 1336680, 1338551, 1339587, 1339675, 1339997, 1342409, 1344216, 1344514, 1348203, 1349198, 1349263, 1353555, 1324755, 1364562, 1467889, 1368502, 1370071, 1373657, 1389095, 1376252, 1379974, 1381161, 1381826, 1381844, 1382959, 1383835, 1383835, 1383835, 1386567, 1387230, 1388503, 1389734, 1390371, 1390954, 1391912, 1471742, 1394779, 1395023, 1395165, 1397828, 1397864, 1397864, 1398745, 1400077, 1400247, 1425949, 1406334, 1409904, 1411496, 1411547, 1413343, 1413906, 1413915, 1444218, 1444247, 1416386, 1417384, 1417451, 1417451, 1417623, 1419073, 1421246, 1422987, 1422365, 1457316, 1471216, 1424755, 1424755, 1424755, 1424755, 1425076, 1426155, 1470241, 1426816, 1427904, 1427904, 1428208, 1428208, 1428541, 1428664, 1428665, 1429034, 1429298, 1429509, 1429713, 1429713, 1431056, 1431953, 1470241, 1433915, 1471142, 1436673, 1437487, 1438348, 1438501, 1436567, 1438633, 1470812, 1440298, 1470745, 1440802, 1441145, 1443013, 1443830, 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, 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.00025 |
SELECT id FROM groups WHERE is_public=0 |
0.22403 |
SELECT post_id FROM posts_comments WHERE message LIKE "%PSD to HTML%" OR MATCH(message) AGAINST("+PSD +to +HTML" IN BOOLEAN MODE) |
0.00025 |
SELECT id FROM searches WHERE user_id="" AND search_key="4f6b42ba7bf2bd356287c0b5cda976e7" LIMIT 1 |
0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00025 |
SELECT * FROM settings |
0.00106 |
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