Killed queries too long

  • Hi,

    your plugin works no prob, but we get a lot of error logs as this:

    KILLED QUERY (68255 characters long generated in class.yith-wcwl.php:526): SELECT *\n FROM wp_yith_wcwl AS i\n LEFT JOIN wp_yith_wcwl_lists AS l ON l.ID = i.wishlist_id\n INNER JOIN wp_posts AS p ON p.ID = i.prod_id \n WHERE 1 AND p.post_type = ‘product’ AND p.post_status = ‘publish’ AND p.ID NOT IN ( 291, 293, 295, 297, 299, 301, 303, 305, 307, 309, 311, 313, 315, 317, 319, 321, 323, 325, 327, 329, 331, 333, 335, 337, 339, 341, 342, 344, 345, 348, 350, 352, 354, 356, 358, 360, 362, 364, 366, 368, 370, 372, 374, 376, 378, 380, 383, 385, 387, 389, 391, 393, 395, 397, 399, 401, 403, 405, 407, 409, 411, 413, 415, 417, 419, 421, 423, 425, 427, 429, 431, 433, 435, 437, 439, 441, 443, 445, 447, 448, 450, 452, 454, 456, 458, 460, 462, 464, 466, 468, 470, 472, 474, 476, 478, 480, 482, 484, 486, 488, 490, 492, 494, 496, 498, 500, 502, 504, 506, 508, 510, 512, 514, 516, 518, 520, 522, 524, 526, 528, 530, 532, 534, 536, 538, 540, 542, 544, 546, 548, 550, 552, 554, 556, 558, 560, 562, 564, 566, 568, 570, 572, 574, 576, 578, 580, 582, 584, 586, 588, 590, 592, 594, 596, 598, 600, 602, 604, 605, 607, 609, 611, 613, 615, 617, 619, 621, 623, 625, 627, 629, 631, 633, 635, 637, 639, 640, 641, 643, 645, 647, 649, 651, 653, 655, 657, 659, 661, 663, 665, 667, 668, 670, 672, 674, 676, 678, 680, 682, 684, 686, 688, 690, 692, 694, 696, 698, 700, 702, 704, 706, 708, 710, 712, 714, 716, 718, 720, 722, 724, 726, 728, 730, 732, 734, 736, 738, 740, 742, 744, 746, 748, 750, 752, 754, 756, 758, 760, 762, 764, 766, 768, 770, 772, 774, 776, 778, 780, 782, 784, 786, 788, 790, 792, 794, 796, 798, 800, 802, 804, 805, 807, 809, 811, 813, 815, 817, 819, 821, 823, 825, 826, 828, 830, 832, 834, 836, 838, 840, 842, 844, 846, 847, 849, 851, 853, 855, 857, 859, 861, 863, 865, 866, 868, 870, 872, 874, 876, 878, 880, 882, 884, 885, 887, 889, 891, 893, 895, 896, 897, 899, 901, 903, 905, 907, 909, 911, 913, 915, 917, 919, 921, 923, 925, 926, 928, 930, 932, 934, 936, 938, 940, 942, 944, 946, 947, 948, 949, 950, 952, 954, 956, 958, 960, 962, 964, 966, 968, 970, 972, 974, 976, 978, 980, 982, 984, 986, 988, 990, 992, 994, 996, 998, 1000, 1002, 1004, 1006, 1008, 1010, 1012, 1014, 1016, 1018, 1020, 1022, 1024, 1026, 1028, 1030, 1032, 1034, 1036, 1038, 1040, 1044, 1046, 1048, 1050, 1052, 1054, 1056, 1058, 1060, 1062, 1064, 1066, 1068, 1070, 1072, 1074, 1076, 1078, 1080, 1082, 1084, 1086, 1088, 1090, 1092, 1094, 1098, 1100, 1102, 1104, 1106, 1108, 1110, 1112, 1114, 1116, 1118, 1120, 1122, 1124, 1126, 1128, 1130, 1132, 1134, 1136, 1138, 1140, 1142, 1144, 1145, 1147, 1149, 1151, 1153, 1155, 1157, 1159, 1161, 1163, 1165, 1167, 1169, 1171, 1173, 1175, 1177, 1179, 1181, 1183, 1185, 1187, 1189, 1191, 1193, 1195, 1197, 1199, 1201, 1203, 1205, 1207, 1209, 1211, 1213, 1215, 1217, 1219, 1221, 1223, 1225, 1227, 1229, 1231, 1233, 1235, 1237, 1239, 1241, 1243, 1245, 1247, 1249, 1251, 1253, 1255, 1257, 1259, 1261, 1263, 1265, 1267, 1269, 1271, 1273, 1275, 1277, 1279, 1281, 1283, 1285, 1287, 1289, 1291, 1295, 1297, 1299, 1301, 1303, 1305, 1307, 1309, 1311, 1313, 1315, 1317, 1319, 1321, 1323, 1325, 1327, 1329, 1331, 1333, 1335, 1337, 1339, 1341, 1343, 1345, 1347, 1349, 1351, 1353, 1355, 1357, 1359, 1361, 1363, 1365, 1367, 1369, 1371, 1373, 1375, 1377, 1379, 1381, 1383, 1385, 1387, 1389, 1391, 1393, 1395, 1397, 1399, 1401, 1403, 1405, 1406, 1408, 1410, 1412, 1414, 1416, 1418, 1420, 1422, 1424, 1426, 1428, 1430, 1432, 1434, 1436, 1438, 1440, 1442, 1444, 1446, 1448, 1450, 1452, 1454, 1456, 1458, 1460, 1462, 1464, 1466, 1468, 1470, 1472, 1474, 1476, 1478, 1480, 1482, 1484, 1486, 1488, 1490, 1492, 1494, 1496, 1498, 1502, 1504, 1506, 1508, 1510, 1512, 1514, 1516, 1518, 1520, 1522, 1524, 1526, 1528, 1530, 1532, 1534, 1536, 1538, 1540, 1542, 1544, 1546, 1548, 1550, 1552, 1554, 1556, 1558, 1560, 1562, 1564, 1566, 1568, 1570, 1572, 1574, 1576, 1578, 1580, 1582, 1584, 1586, 1588, 1590, 1592, 1594, 1596, 1598, 1600, 1602, 1604, 1606, 1608, 1610, 1612, 1614, 1616, 1618, 1620, 1622, 1624, 1626, 1628, 1630, 1632, 1634, 1636, 1638, 1640, 1642, 1644, 1646, 1648, 1650, 1652, 1654, 1656, 1658, 1660, 1662, 1664, 1666, 1668, 1670, 1672, 1674, 1675, 1677, 1679, 1681, 1683, 1685, 1689, 1691, 1693, 1695, 1697, 1699, 1701, 1703, 1705, 1707, 1708, 1709, 1711, 1713, 1715, 1717, 1719, 1721, 1723, 1725, 1727, 1729, 1731, 1733, 1735, 1737, 1739, 1741, 1743, 1745, 1747, 1749, 1751, 1753, 1755, 1757, 1759, 1761, 1763, 1765, 1767, 1769, 1771, 1773, 1775, 1777, 1779, 1781, 1783, 1785, 1787, 1789, 1791, 1793, 1795, 1797, 1798, 1799, 1801, 1803, 1805, 1807, 1809, 1811, 1813, 1815, 1817, 1819, 1821, 1823, 1825, 1827, 1829, 1831, 1833, 1835, 1837, 1839, 1840, 1842, 1844, 1846, 1848, 1850, 1852, 1854, 1856, 1858, 1860, 1862, 1864, 1866, 1868, 1870, 1872, 1874, 1876, 1878, 1880, 1882, 1884, 1886, 1888, 1890, 1892, 1894, 1896, 1898, 1900, 1902, 1904, 1906, 1908, 1910, 1912, 1914, 1916, 1918, 1920, 1922, 1924, 1926, 1928, 1930, 1932, 1934, 1936, 1938, 1940, 1942, 1944, 1946, 1948, 1950, 1952, 1954, 1956, 1958, 1960, 1962, 1964, 1966, 1968, 1970, 1972, 1974, 1976, 1978, 1980, 1982, 1984, 1986, 1988, 1990, 1992, 1994, 1996, 1998, 2000, 2002, 2004, 2006, 2008, 2009, 2011, 2013, 2015, 2017, 2019, 2021, 2023, 2025, 2027, 2029, 2031, 2033, 2035, 2037, 2039, 2041, 2043, 2045, 2047, 2049, 2051, 2053, 2055, 2057, 2059, 2061, 2063, 2065, 2067, 2069, 2071, 2073, 2075, 2077, 2079, 2081, 2083, 2085, 2087, 2089, 2091, 2093, 2095, 2097, 2099, 2101, 2103, 2105, 2107, 2109, 2111, 2112, 2114, 2116, 2118, 2120, 2122, 2124, 2126, 2128, 2130, 2132, 2134, 2136, 2138, 2140, 2142, 2144, 2146, 2148, 2150, 2152, 2154, 2156, 2158, 2160, 2162, 2164, 2166, 2168, 2170, 2172, 2174, 2176, 2178, 2180, 2182, 2184, 2186, 2188, 2190, 2192, 2194, 2196, 2198, 2200, 2202, 2204, 2206, 2208, 2210, 2212, 2214, 2216, 2218, 2220, 2222, 2224, 2226, 2228, 2230, 2232, 2234, 2236, 2238, 2240, 2242, 2244, 2246, 2248, 2250, 2252, 2254, 2256, 2258, 2260, 2262, 2264, 2266, 2268, 2270, 2272, 2274, 2276, 2278, 2280, 2282, 2284, 2286, 2288, 2290, 2292, 2294, 2296, 2298, 2300, 2302, 2304, 2306, 2308, 2310, 2312, 2314, 2316, 2318, 2320, 2322, 2324, 2326, 2328, 2330, 2332, 2334, 2336, 2338, 2340, 2342, 2344, 2346, 2348, 2350, 2352, 2354, 2356, 2358, 2360, 2362, 2364, 2366, 2368, 2369, 2371, 2373, 2375, 2377, 2379, 2381, 2383, 2385, 2387, 2389, 2391, 2393, 2395, 2397, 2399, 2401, 2403, 2405, 2407, 2409, 2411, 2413, 2415, 2417, 2419, 2421, 2423, 2425, 2427, 2429, 2431, 2433, 2435, 2437, 2439, 2441, 2443, 2445, 2447, 2449, 2451, 2453, 2455, 2457, 2459, 2461, 2463, 2465, 2467, 2468, 2469, 2471, 2473, 2475, 2477, 2478, 2480, 2482, 2483, 2487, 2489, 2491, 2493, 2495, 2497, 2499, 2501, 2503, 2505, 2507, 2509, 2511, 2515, 2517, 2519, 2521, 2523, 2525, 2527, 2529, 2531, 2533, 2535, 2537, 2539, 2541, 2543, 2545, 2547, 2549, 2551, 2552, 2554, 2556, 2559, 2561, 2563, 2565, 2567, 2569, 2571, 2573, 2575, 2577, 2579, 2581, 2582, 2584, 2586, 2588, 2590, 2592, 2594, 2596, 2598, 2600, 2602, 2604, 2606, 2608, 2610, 2612, 2614, 2616, 2618, 2619, 2621, 2623, 2625, 2627, 2629, 2631, 2633, 2635, 2637, 2639, 2641, 2643, 2644, 2646, 2650, 2652, 2654, 2656, 2658, 2660, 2662, 2664, 2666, 2668, 2670, 2672, 2674, 2676, 2678, 2680, 2682, 2684, 2685, 2687, 2689, 2691, 2692, 2694, 2696, 2698, 2700, 2702, 2704, 2706, 2708, 2710, 2712, 2714, 2715, 2716, 2718, 2720, 2722, 2724, 2727, 2729, 2731, 2732, 2734, 2736, 2738, 2740, 2742, 2744, 2746, 2748, 2750, 2752, 2754, 2756, 2758, 2760, 2762, 2764, 2766, 2768, 2770, 2772, 2774, 2776, 2778, 2780, 2782, 2784, 2786, 2788, 2790, 2792, 2794, 2796, 2798, 2800, 2802, 2804, 2806, 2808, 2810, 2812, 2814, 2816, 2820, 2822, 2824, 2826, 2828, 2830, 2832, 2834, 2836, 2838, 2840, 2842, 2844, 2846, 2848, 2850, 2852, 2854, 2856, 2858, 2860, 2862, 2864, 2866, 2868, 2870, 2872, 2874, 2876, 2878, 2880, 2882, 2884, 2886, 2888, 2890, 2892, 2894, 2896, 2898, 2900, 2902, 2904, 2906, 2908, 2910, 2912, 2913, 2915, 2917, 2919, 2921, 2923, 2925, 2927, 2929, 2931, 2933, 2935,

    anything you can fix?

    TY

    M

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author YITHEMES

    (@yithemes)

    Hi Marco

    This seems a query used to retrieve products that should not appear in the wishlist (because they are hidden)

    This result should be calculated once, and then stored in a transient, to be used in future applications

    Anyway, since query is failing each time it is performed, transient cannot be generated and the error keeps appearing

    I will consider to add a filter to skip this execution, for the cases it cause an error; I will also review the code, to see if this code could be replaced with something more efficent

    Thank you for your report

    Hi, I’m getting a similar issue where the query gets killed with the message

    KILLED QUERY (18094 characters long generated

    SELECT ID FROM i3z4aH5_posts AS p WHERE post_type = 'product' AND post_status = 'publish' AND p.ID NOT IN ( 73, 77, 81, 86, 90, 94, 98, 108, 109, 113, 118, 227, 231, 239, 243, 247, 251, 255, 259, 263, 267, 271, 272, 280, 284, 285, 289, 293, 295, 296, 300, 304, 306, 310, 312, 313, 314, 315, 316, 317, 321, 325, 326, 327, 331, 335, 336, 337, 338, 339, 341, 342, 343, 344, 345, 485, 495, 496, 497, 510, 514, 519, 520, 521, 528, 532, 537, 542, 546, 547, 548, 549, 550, 551, 552, 556, 560, 568, 576, 578, 582, 583, 584, 585, 587, 588, 589, 590, 591, 597, 601, 605, 609, 617, 618, 622, 623, 627, 725, 729, 733, 737, 739, 743, 747, 751, 755, 773, 777, 781, 785, 789, 793, 829, 933, 938, 954, 964, 972, 983, 985, 996, 997, 998, 1000, 1004, 1005, 1007, 1008, 1009, 1010, 1012, 1013, 1014, 1015, 1017, 1019, 1021, 1022, 1023, 1024, 1027, 1028, 1029, 1032, 1034, 1036, 1037, 1038, 1039, 1040, 1041, 1216, 1217, 1218, 1219, 1220, 1223, 1233, 1241, 1245, 1249, 1253, 1257, 1261, 1265, 1269, 1273, 1277, 1289, 1293, 1312, 1319, 1343, 1347, 1351, 1365, 1366, 1371, 1376, 1380, 1385, 1390, 1394, 1398, 1402, 1406, 1411, 1415, 1416, 1417, 1420, 1425, 1449, 1451, 1453, 1463, 1464, 1470, 1504, 1531, 1538, 1546, 1550, 1574, 1628, 1647, 1648, 1653, 1656, 1659, 1662, 1665, 1668, 1671, 1674, 1677, 1681, 1684, 1689, 1692, 1695, 1698, 1701, 1704, 1707, 1713, 1714, 1716, 1720, 1723, 1726, 1729, 1732, 1735, 1738, 1741, 1744, 1747, 1752, 1755, 1758, 1761, 1764, 1767, 1770, 1773, 1776, 1779, 1782, 1785, 1788, 1791, 1795, 1800, 1804, 1807, 1810, 1813, 1818, 1821, 1832, 1836, 1840, 1845, 1848, 1851, 1855, 1859, 1862, 1865, 1869, 1873, 1877, 1881, 1885, 1889, 1893, 1896, 1899, 1902, 1905, 1909, 1913, 1916, 1920, 1924, 1928, 1931, 1935, 1939, 1942, 1946, 1947, 1950, 1953, 1959, 1963, 1968, 1972, 1976, 1980, 1984, 1988, 1991, 1994, 1997, 2001, 2005, 2008, 2011, 2015, 2018, 2022, 2025, 2030, 2033, 2036, 2040, 2043, 2046, 2049, 2052, 2056, 2060, 2064, 2067, 2075, 2080, 2084, 2088, 2091, 2095, 2098, 2101, 2104, 2107, 2110, 2114, 2117, 2120, 2122, 2127, 2132, 2138, 2140, 2144, 2148, 2154, 2159, 2162, 2170, 2173, 2178, 2181, 2182, 2188, 2191, 2195, 2198, 2202, 2203, 2210, 2212, 2217, 2220, 2224, 2228, 2232, 2235, 2238, 2242, 2245, 2248, 2251, 2255, 2256, 2263, 2265, 2273, 2286, 2290, 2292, 2297, 2301, 2320, 2326, 2328, 2333, 2337, 2349, 2359, 2363, 2368, 2369, 2370, 2380, 2384, 2392, 2396, 2403, 2404, 2409, 2424, 2425, 2442, 2450, 2451, 2457, 2463, 2478, 2484, 2489, 2495, 2496, 2497, 2503, 2514, 2521, 2523, 2528, 2534, 2543, 2544, 2554, 2563, 2567, 2573, 2577, 2578, 2582, 2586, 2589, 2590, 2591, 2603, 2612, 2614, 2621, 2622, 2623, 2631, 2642, 2643, 2646, 2654, 2657, 2658, 2668, 2669, 2675, 2679, 2684, 2695, 2699, 2704, 2705, 2712, 2716, 2717, 2727, 2734, 2735, 2740, 2745, 2750, 2751, 2755, 2770, 2771, 2777, 2783, 2789, 2801, 2808, 2819, 2823, 2827, 2830, 2833, 2836, 2839, 2842, 2845, 2846, 2849, 2854, 2858, 2859, 2866, 2867, 2869, 2875, 2879, 2880, 2881, 2883, 2890, 2894, 2896, 2901, 2902, 2910, 2915, 2916, 2922, 2928, 2931, 2932, 2933, 2936, 2940, 2944, 2945, 2951, 2956, 2964, 2965, 2971, 2977, 2981, 2985, 2989, 2993, 2996, 2998, 3006, 3011, 3016, 3017, 3024, 3027, 3030, 3031, 3032, 3033, 3034, 3035, 3036, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3049, 3050, 3051, 3052, 3053, 3054, 3055, 3056, 3057, 3058, 3059, 3060, 3062, 3063, 3064, 3065, 3067, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3187, 3192, 3196, 3200, 3207, 3219, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3228, 3229, 3230, 3231, 3232, 3233, 3234, 3235, 3240, 3244, 3249, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3261, 3262, 3263, 3266, 3267, 3268, 3269, 3270, 3271, 3344, 3350, 3356, 3423, 3425, 3430, 3435, 3440, 3445, 3450, 3451, 3460, 3471, 3476, 3481, 3492, 3494, 3545, 3550, 3556, 3561, 3566, 3576, 3577, 3582, 3587, 3592, 3597, 3602, 3607, 3612, 3617, 3622, 3628, 3633, 3638, 3643, 3648, 3653, 3658, 3663, 3668, 3673, 3678, 3683, 3688, 3703, 3708, 3719, 3723, 3724, 3733, 3739, 3740, 3745, 3754, 3761, 3762, 3772, 3777, 3781, 3785, 3790, 3799, 3800, 3805, 3806, 3813, 3817, 3825, 3837, 3842, 3847, 3852, 3857, 3867, 3877, 3878, 3889, 3894, 3900, 3906, 3912, 3916, 3920, 3927, 3928, 3932, 3937, 3941, 3945, 3949, 3953, 3965, 3970, 3980, 3985, 4018, 4024, 4029, 4034, 4054, 4066, 4076, 4085, 4091, 4096, 4101, 4106, 4111, 4116, 4122, 4127, 4141, 4151, 4155, 4161, 4166, 4174, 4177, 4182, 4189, 4198, 4200, 4206, 4221, 4230, 4236, 4243, 4251, 4255, 4263, 4265, 4269, 4277, 4283, 4289, 4297, 4303, 4313, 4318, 4324, 4372, 4381, 4402, 4412, 4420, 4445, 4450, 4454, 4463, 4467, 4471, 4503, 4507, 4572, 4576, 4579, 4582, 4586, 4589, 4592, 4725, 4728, 4737, 4740, 4758, 4762, 4763, 4773, 4788, 4789, 4796, 4800, 4803, 4806, 4813, 4817, 4820, 4821, 4828, 4829, 4832, 4838, 4843, 4844, 4847, 4851, 4857, 4861, 4862, 4868, 4872, 4876, 4883, 4884, 4890, 4891, 4897, 4904, 4907, 4908, 4909, 4915, 4916, 4922, 4923, 4934, 4935, 4938, 4939, 4947, 4948, 4951, 4955, 4959, 4963, 4969, 4972, 4975, 4980, 4985, 4988, 4993, 4994, 4998, 5002, 5010, 5014, 5112, 5115, 5118, 5125, 5128, 5132, 5135, 5140, 5143, 5148, 5156, 5162, 5167, 5171, 5175, 5179, 5193, 5201, 5219, 5227, 5322, 5327, 5334, 5340, 5350, 5356, 5361, 5366, 5391, 5395, 5399, 5403, 5413, 5414, 5423, 5428, 5432, 5437, 5441, 5450, 5453, 5457, 5462, 5475, 5476, 5481, 5483, 5487, 5491, 5494, 5497, 5500, 5503, 5506, 5509, 5512, 5516, 5520, 5525, 5526, 5529, 5533, 5536, 5539, 5540, 5547, 5551, 5555, 5556, 5562, 5565, 5568, 5571, 5577, 5580, 5588, 5592, 5596, 5599, 5602, 5606, 5609, 5612, 5615, 5618, 5621, 5629, 5632, 5636, 5641, 5644, 5647, 5651, 5655, 5658, 5662, 5665, 5668, 5673, 5677, 5682, 5683, 5689, 5692, 5695, 5702, 5703, 5708, 5712, 5715, 5718, 5721, 5725, 5729, 5733, 5737, 5741, 5742, 5746, 5752, 5755, 5756, 5765, 5768, 5771, 5782, 5786, 5793, 5797, 5809, 5817, 5825, 5828, 5833, 5837, 5841, 5845, 5854, 5863, 5868, 5876, 5882, 5890, 5895, 5899, 5903, 5908, 5916, 5917, 5922, 5927, 5929, 5932, 5934, 5936, 5941, 5945, 5954, 5960, 5967, 5973, 5978, 5983, 5985, 5990, 5994, 5998, 6008, 6014, 6026, 6036, 6040, 6044, 6049, 6054, 6059, 6065, 6070, 6076, 6081, 6083, 6089, 6092, 6096, 6097, 6101, 6108, 6112, 6119, 6120, 6124, 6134, 6139, 6144, 6149, 6154, 6159, 6169, 6174, 6178, 6180, 6185, 6190, 6192, 6198, 6204, 6209, 6214, 6217, 6219, 6224, 6226, 6236, 6238, 6243, 6248, 6250, 6252, 6259, 6263, 6265, 6276, 6284, 6301, 6302, 6304, 6308, 6312, 6343, 6346, 6350, 6351, 6354, 6365, 6367, 6374, 6381, 6396, 6397, 6398, 6405, 6411, 6424, 6425, 6433, 6452, 6456, 6465, 6472, 6477, 6501, 6503, 6504, 6528, 6535, 6566, 6568, 6572, 6589, 6611, 6613, 6625, 6648, 6649, 6674, 6678, 6680, 6681, 6682, 6683, 6684, 6686, 6693, 6694, 6696, 6698, 6705, 6755, 6760, 6765, 6797, 6823, 6828, 6835, 6843, 6845, 6850, 6858, 6863, 6872, 6905, 6911, 6915, 6919, 6923, 6936, 6940, 6945, 6949, 6954, 6956, 7045, 7049, 7054, 7059, 7063, 7069, 7070, 7095, 7099, 7100, 7101, 7104, 7116, 7117, 7118, 7122, 7126, 7130, 7135, 7140, 7144, 7152, 7158, 7164, 7165, 7173, 7177, 7186, 7202, 7203, 7204, 7205, 7221, 7282, 7286, 7291, 7295, 7299, 7303, 7342, 7344, 7348, 7350, 7351, 7352, 7353, 7354, 7355, 7356, 7359, 7362, 7363, 7368, 7381, 7382, 7383, 7384, 7385, 7388, 7390, 7391, 7392, 7393, 7394, 7395, 7396, 7397, 7425, 7429, 7511, 7512, 7513, 7514, 7516, 7517, 7518, 7548, 7562, 7563, 7565, 7569, 7585, 7586, 7604, 7609, 7613, 7618, 7630, 7632, 7644, 7684, 7828, 7829, 7830, 7833, 7834, 7835, 7837, 7838, 7839, 7840, 7841, 7855, 7856, 7858, 7859, 7861, 7905, 7906, 7910, 7912, 7913, 7914, 7927, 7928, 7929, 7930, 7932, 7933, 7934, 7935, 7937, 7938, 7940, 7941, 7943, 7944, 7945, 7947, 7949, 7950, 7951, 7953, 7954, 7956, 7957, 7958, 7960, 8025, 8026, 8027, 8028, 8029, 8030, 8031, 8032, 8033, 8034, 8035, 8036, 8037, 8038, 8230, 8231, 8232, 8233, 8234, 8236, 8237, 9093, 9094, 9095, 9096, 9097, 9098, 9101, 9102, 9103, 9104, 9105, 9106, 9107

    Plugin Author YITHEMES

    (@yithemes)

    Hello @marco1970 and @apavlov2,

    Thanks for contacting us and I hope you’re doing well

    YITH Wishlist use a function called yith_wcwl_get_hidden_products
    that retrieves id of all hidden products to exclude them from query and probably
    this should cause the concatenation of ids that you’re experiencing.

    You can use the following workaround and add the line in functions.php file of theme or child.

    add_filter( 'yith_wcwl_hidden_products', '__return_empty_array' );

    This should be fix the problem for your case.

    Please try it and let me know.
    Have a good day,
    YIThemes.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Killed queries too long’ is closed to new replies.