0.00047 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00038 |
SELECT * FROM posts_comments WHERE post_id="1469988" ORDER BY id ASC |
0.00028 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1469988" LIMIT 2 |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1470086" ORDER BY id ASC |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470086" LIMIT 2 |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1470276" ORDER BY id ASC |
0.00033 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470276" LIMIT 1 |
0.00035 |
SELECT * FROM posts_comments WHERE post_id="1470465" ORDER BY id ASC |
0.00041 |
SELECT * FROM posts_comments WHERE post_id="1470580" ORDER BY id ASC |
0.00043 |
SELECT * FROM posts_comments WHERE post_id="1470619" ORDER BY id ASC |
0.00029 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470619" LIMIT 1 |
0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147062" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="147058" LIMIT 1 |
0.00044 |
SELECT * FROM posts_comments WHERE post_id="1470812" ORDER BY id ASC |
0.00030 |
SELECT * FROM posts_comments WHERE post_id="1470966" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1470966" LIMIT 2 |
0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471091" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1471314" ORDER BY id ASC |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1471522" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471522" LIMIT 1 |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1471594" LIMIT 1 |
0.00044 |
SELECT * FROM posts_comments WHERE post_id="1471742" ORDER BY id ASC |
0.00044 |
SELECT user_id FROM posts_mentioned WHERE post_id="1471742" LIMIT 2 |
0.00417 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%cs%" OR id IN(1291523, 1291523, 1308483, 1292746, 1293939, 1294369, 1294927, 1294879, 1294476, 1295035, 1306859, 1316513, 1316976, 1316976, 1318472, 1321786, 1327985, 1329078, 1330776, 1330833, 1332400, 1334878, 1336293, 1336680, 1336680, 1336680, 1336803, 1337321, 1389826, 1337321, 1341476, 1334969, 1341818, 1342041, 1342041, 1342409, 1346145, 1346145, 1346172, 1348203, 1362617, 1357088, 1357088, 1361212, 1324755, 1364239, 1364239, 1366972, 1366972, 1367264, 1367264, 1367264, 1367695, 1368794, 1369066, 1370071, 1370684, 1370684, 1368507, 1388947, 1376329, 1377275, 1377318, 1447620, 1379699, 1379699, 1379728, 1380746, 1381392, 1383393, 1383469, 1383469, 1383997, 1383997, 1386567, 1390371, 1391091, 1392291, 1393323, 1393649, 1393649, 1393649, 1471742, 1394775, 1395454, 1396619, 1396640, 1396862, 1421238, 1399633, 1400247, 1400264, 1402061, 1444218, 1404539, 1404856, 1405934, 1406581, 1407424, 1408564, 1410758, 1410898, 1410898, 1410898, 1411642, 1411973, 1413896, 1447788, 1467292, 1401662, 1413441, 1416883, 1416938, 1417216, 1417910, 1418639, 1418157, 1419514, 1419679, 1420813, 1421031, 1421031, 1421204, 1421550, 1423097, 1423080, 1423372, 1423798, 1424008, 1457320, 1424152, 1424152, 1424247, 1424247, 1424247, 1432558, 1424755, 1424902, 1424902, 1471522, 1467505, 1424980, 1424902, 1432601, 1468017, 1426145, 1470619, 1427047, 1427871, 1427904, 1428207, 1429017, 1429137, 1429246, 1429347, 1429347, 1429321, 1429646, 1430328, 1430381, 1430381, 1430701, 1430975, 1431472, 1431656, 1457950, 1432983, 1432983, 1432983, 1433117, 1433698, 1433831, 1433913, 1434236, 1441930, 1436318, 1436673, 1436854, 1457055, 1438138, 1438138, 1438308, 1438456, 1470966, 1438553, 1438969, 1438984, 1470812, 1439333, 1457052, 1439638, 1439739, 1439814, 1470580, 1470580, 1441509, 1441915, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1442021, 1442553, 1442825, 1443286, 1443452, 1443604, 1443657, 1443837, 1471314, 1444777, 1445472, 1445820, 1446081, 1446251, 1446251, 1446476, 1446650, 1448100, 1448285, 1449490, 1457917, 1457950, 1451874, 1452128, 1452440, 1452910, 1453049, 1453265, 1453277, 1453370, 1454912, 1454908, 1455449, 1455680, 1455813, 1456134, 1456271, 1456414, 1458301, 1458833, 1458855, 1459560, 1459961, 1460540, 1460985, 1461295, 1461437, 1461508, 1461535, 1461637, 1461822, 1461972, 1462538, 1463118, 1463240, 1463419, 1463437, 1463431, 1463988, 1464456, 1464314, 1464546, 1464839, 1464891, 1465169, 1467645, 1466379, 1465432, 1466928, 1466969, 1470465, 1467208, 1467217, 1468181, 1469228, 1469220, 1469220, 1468216, 1468561, 1469715, 1469810, 1469810)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.49160 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%cs%" OR id IN(1291523, 1291523, 1308483, 1292746, 1293939, 1294369, 1294927, 1294879, 1294476, 1295035, 1306859, 1316513, 1316976, 1316976, 1318472, 1321786, 1327985, 1329078, 1330776, 1330833, 1332400, 1334878, 1336293, 1336680, 1336680, 1336680, 1336803, 1337321, 1389826, 1337321, 1341476, 1334969, 1341818, 1342041, 1342041, 1342409, 1346145, 1346145, 1346172, 1348203, 1362617, 1357088, 1357088, 1361212, 1324755, 1364239, 1364239, 1366972, 1366972, 1367264, 1367264, 1367264, 1367695, 1368794, 1369066, 1370071, 1370684, 1370684, 1368507, 1388947, 1376329, 1377275, 1377318, 1447620, 1379699, 1379699, 1379728, 1380746, 1381392, 1383393, 1383469, 1383469, 1383997, 1383997, 1386567, 1390371, 1391091, 1392291, 1393323, 1393649, 1393649, 1393649, 1471742, 1394775, 1395454, 1396619, 1396640, 1396862, 1421238, 1399633, 1400247, 1400264, 1402061, 1444218, 1404539, 1404856, 1405934, 1406581, 1407424, 1408564, 1410758, 1410898, 1410898, 1410898, 1411642, 1411973, 1413896, 1447788, 1467292, 1401662, 1413441, 1416883, 1416938, 1417216, 1417910, 1418639, 1418157, 1419514, 1419679, 1420813, 1421031, 1421031, 1421204, 1421550, 1423097, 1423080, 1423372, 1423798, 1424008, 1457320, 1424152, 1424152, 1424247, 1424247, 1424247, 1432558, 1424755, 1424902, 1424902, 1471522, 1467505, 1424980, 1424902, 1432601, 1468017, 1426145, 1470619, 1427047, 1427871, 1427904, 1428207, 1429017, 1429137, 1429246, 1429347, 1429347, 1429321, 1429646, 1430328, 1430381, 1430381, 1430701, 1430975, 1431472, 1431656, 1457950, 1432983, 1432983, 1432983, 1433117, 1433698, 1433831, 1433913, 1434236, 1441930, 1436318, 1436673, 1436854, 1457055, 1438138, 1438138, 1438308, 1438456, 1470966, 1438553, 1438969, 1438984, 1470812, 1439333, 1457052, 1439638, 1439739, 1439814, 1470580, 1470580, 1441509, 1441915, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1442021, 1442553, 1442825, 1443286, 1443452, 1443604, 1443657, 1443837, 1471314, 1444777, 1445472, 1445820, 1446081, 1446251, 1446251, 1446476, 1446650, 1448100, 1448285, 1449490, 1457917, 1457950, 1451874, 1452128, 1452440, 1452910, 1453049, 1453265, 1453277, 1453370, 1454912, 1454908, 1455449, 1455680, 1455813, 1456134, 1456271, 1456414, 1458301, 1458833, 1458855, 1459560, 1459961, 1460540, 1460985, 1461295, 1461437, 1461508, 1461535, 1461637, 1461822, 1461972, 1462538, 1463118, 1463240, 1463419, 1463437, 1463431, 1463988, 1464456, 1464314, 1464546, 1464839, 1464891, 1465169, 1467645, 1466379, 1465432, 1466928, 1466969, 1470465, 1467208, 1467217, 1468181, 1469228, 1469220, 1469220, 1468216, 1468561, 1469715, 1469810, 1469810)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00033 |
SELECT id FROM groups WHERE is_public=0 |
0.07820 |
SELECT post_id FROM posts_comments WHERE message LIKE "%cs%" |
0.00027 |
SELECT id FROM searches WHERE user_id="" AND search_key="858c5c893d0c42439d9742716bd7e598" LIMIT 1 |
0.00025 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00033 |
SELECT * FROM settings |
0.00118 |
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