Here is the second sql query that is very low. If you can optimise this one as you did for the other one my forum will be fast
Code: Select all
# Time: 2021-11-18T18:36:03.986010Z
# User@Host: test[test] @ localhost [] Id: 251
# Query_time: 2.003654 Lock_time: 0.010087 Rows_sent: 0 Rows_examined: 0
SET timestamp=1637260563;
DELETE FROM phpbb_notification_emails
WHERE notification_type_id = 27 AND user_id = '2' AND item_parent_id IN ('43', '45', '13', '41', '62', '71', '88', '18', '64', '105', '101', '17', '103', '58', '33', '121', '123', '87', '28', '26', '40', '57', '139', '131', '24', '93', '146', '149', '150', '134', '141', '156', '160', '151', '152', '59', '22', '171', '192', '203', '189', '95', '222', '223', '228', '230', '229', '235', '247', '248', '252', '239', '27', '265', '50', '255', '277', '292', '287', '299', '312', '326', '316', '311', '236', '339', '355', '360', '338', '356', '372', '395', '217', '399', '401', '420', '438', '442', '458', '385', '462', '453', '486', '493', '478', '490', '511', '524', '532', '535', '503', '547', '558', '551', '560', '556', '386', '590', '592', '250', '595', '605', '599', '184', '92', '642', '650', '655', '659', '671', '683', '373', '690', '693', '701', '703', '722', '67', '712', '717', '674', '742', '746', '759', '774', '771', '31', '809', '826', '526', '841', '850', '857', '895', '883', '871', '874', '879', '906', '922', '925', '927', '913', '939', '948', '942', '969', '1002', '1016', '1063', '60', '1089', '1092', '1087', '1112', '1119', '1134', '1136', '1171', '1142', '1186', '1185', '1077', '1201', '1005', '1223', '1215', '1284', '1203', '1295', '16', '1312', '1327', '1345', '1350', '1309', '1372', '1379', '1383', '1385', '1325', '1402', '1413', '1408', '1424', '1419', '1430', '1432', '1449', '1454', '1448', '1456', '1457', '1458', '1471', '1455', '733', '1495', '1503', '1491', '1524', '1522', '1530', '1453', '1542', '1541', '35', '1446', '1558', '1520', '1568', '1571', '1574', '1584', '1576', '1599', '1505', '1613', '1624', '1476', '1629', '1659', '1665', '1671', '1647', '1638', '1696', '1720', '1716', '1711', '1725', '1743', '1749', '1746', '1761', '1763', '1780', '1724', '1793', '1715', '1804', '1810', '1808', '1817', '1815', '1841', '1837', '1843', '1845', '1849', '1836', '1866', '1862', '1877', '1873', '1892', '1922', '1934', '1947', '1940', '1953', '1960', '1982', '1983', '1988', '1943', '1991', '1939', '1994', '1992', '2008', '2003', '2027', '2038', '2022', '1957', '2047', '2064', '2068', '2073', '2076', '2077', '2097', '2020', '2103', '2108', '2114', '2081', '2116', '2128', '2132', '2124', '2121', '1701', '2144', '2152', '2165', '2207', '2164', '2181', '2155', '2161', '2174', '2217', '2200', '2096', '2247', '2234', '2258', '2222', '2261', '2244', '2277', '2270', '2275', '2287', '2284', '2294', '2271', '2302', '2305', '2310', '2318', '2320', '2326', '2334', '2322', '2333', '2252', '2354', '2370', '2374', '2381', '2394', '1900', '2402', '7', '2242', '2416', '2433', '2437', '2439', '2466', '2440', '2471', '2459', '2473', '1569', '2469', '2481', '2480', '2485', '2493', '2494', '2509', '2528', '2506', '2500', '2530', '2558', '2561', '2520', '2566', '2576', '2583', '2593', '2554', '2598', '2603', '2582', '643', '2649', '2651', '2340', '2656', '2642', '2671', '2669', '2710', '2187', '2748', '2660', '2764', '2765', '.......................