Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos.
A continuación, copio la query que genera el problema (ver captura para más información):
SELECT SQL_CALC_FOUND_ROWS
Vsnucam_posts.id from vsnucam_posts left join vsnucam_term_relationships on (
vsnucam_posts.ID = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on (
vsnucam_posts.Id = tt1.object_id) left join vsnucam_term_relationships as tt2 on (
vsnucam_posts.Id = tt2.object_id) left join vsnucam_term_relationships as tt3 on (
vsnucam_posts.Id = tt3.object_id) left join vsnucam_term_relationships as tt4 on (
vsnucam_posts.Id = tt4.object_id) where 1=1 and ( vsnucam_term_relationships.Term_taxonomy_id in (55,1263,1265,1266,1268,1282,1284,1285,1289,1296,1297,1308,1317,1330,1331,1333,1345,1353,1354,1355,1359,1360,1369,1383,1384,1517,1518,1519,1533,1537,1542,1547,1556,1559,1583,1595,1596,1597,1598,1599,1601,1605,1622,1641,1670,1675,1682,1696,1697,1700,1702) and tt1.Term_taxonomy_id in (75,1271,1278,1303,1323,1324,1332,1337,1338,1341,1346,1382,1386,1499,1500,1520,1540,1544,1546,1552,1554,1555,1560,1562,1586,1588,1589,1592,1619,1644,1651,1653,1678,1688,1694,1695) and tt2.Term_taxonomy_id in (62,1279,1295,1307,1310,1315,1321,1322,1328,1329,1377,1504,1505,1506,1507,1526,1534,1539,1563,1564,1570,1584,1587,1590,1606,1652,1656,1674,1687,1692,1701,1704,1711,1718) and tt3.Term_taxonomy_id in (91,661,1140,1277,1293,1327,1343,1358,1378,1379,1380,1381,1388,1512,1513,1514,1515,1516,1521,1522,1524,1525,1529,1535,1536,1538,1541,1558,1582,1604,1608,1611,1621,1626,1630,1632,1634,1635,1637,1645,1654,1669,1672,1673,1676,1684,1686,1690,1703,1705,1706,1712,1714,1715,1716) and tt4.Term_taxonomy_id in (49,1272,1273,1274,1275,1276,1283,1286,1287,1288,1290,1291,1294,1298,1301,1302,1309,1311,1316,1318,1319,1325,1326,1334,1335,1344,1347,1348,1349,1351,1356,1357,1370,1371,1372,1373,1374,1375,1376,1387,1501,1508,1530,1549,1561,1565,1579,1631,1650,1679) ) and ((vsnucam_posts.post_type = 'post' AND (Vsnucam_posts.post_status = 'publish'))) group by
vsnucam_posts.Id order by vsnucam_posts.post_date DESC LIMIT 0, 10
Contexto general del proyecto
Somos un proyecto que ya está en funcionamiento y este problema nos dificulta el día a día, haciéndonos perder visitas.
Plazo de Entrega: No definido