bottleneck with plugin wp-multi-network

Bug report, I don’t have permission to create ticket. When is double-opt-in used with wp-multi-network it upgrade table *f12_cf7_doubleoptin on every click. Mysql log:

2025-04-11T13:59:52.313765Z 49 Query SELECT * FROM wp_blogs WHERE blog_id IN (884)
2025-04-11T13:59:52.314538Z 49 Query SELECT * FROM wp_site WHERE id = 139 LIMIT 1
2025-04-11T13:59:52.319820Z 49 Query SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘site_name’ AND site_id = 139
2025-04-11T13:59:52.325718Z 49 Query SELECT * FROM wp_blogs WHERE blog_id = 1 LIMIT 1
2025-04-11T13:59:52.327423Z 49 Query SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘main_site’ AND site_id = 139
2025-04-11T13:59:52.328599Z 49 Query SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key IN (‘site_name’, ‘siteurl’, ‘active_sitewide_plugins’, ‘_site_transient_timeout_theme_roots’, ‘_site_tra
nsient_theme_roots’, ‘site_admins’, ‘can_compress_scripts’, ‘global_terms_enabled’, ‘ms_files_rewriting’) AND site_id = 139
2025-04-11T13:59:52.330016Z 49 Query SELECT option_name, option_value FROM wp_884_options WHERE autoload = ‘yes’
2025-04-11T13:59:52.449158Z 49 Query SELECT wp_site.id
FROM wp_site ORDER BY wp_site.id ASC LIMIT 2025-04-11T13:59:52.460459Z 49 Query SELECT option_value FROM wp_884_options WHERE option_name = ‘uninstall_plugins’ LIMIT 1
2025-04-11T13:59:52.466639Z 49 Query SELECT option_value FROM wp_884_options WHERE option_name = ‘ReduxFrameworkPlugin’ LIMIT 1
2025-04-11T13:59:52.469024Z 49 Query SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘f12-cf7-doubleoptin_version’ AND site_id = 139
2025-04-11T13:59:52.470646Z 49 Query DESCRIBE wp_884_f12_cf7_doubleoptin_categories
2025-04-11T13:59:52.486939Z 49 Query SHOW INDEX FROM wp_884_f12_cf7_doubleoptin_categories
2025-04-11T13:59:52.542900Z 49 Query DESCRIBE wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:52.548168Z 49 Query SHOW INDEX FROM wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:52.552486Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN content content LONGTEXT
2025-04-11T13:59:52.821648Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN files files LONGTEXT
2025-04-11T13:59:52.959580Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN hash hash VARCHAR(255)
2025-04-11T13:59:52.986922Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN form form LONGTEXT
2025-04-11T13:59:53.173589Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN mail_optin mail_optin LONGTEXT
2025-04-11T13:59:53.303248Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin ADD COLUMN ipaddr_optout varchar(255) NOT NULL DEFAULT ”
2025-04-11T13:59:53.459685Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin ADD COLUMN optouttime varchar(255) DEFAULT ”
2025-04-11T13:59:53.549590Z 49 Query SHOW FULL COLUMNS FROM wp_884_options
2025-04-11T13:59:53.552940Z 49 Query UPDATE wp_884_options SET option_value = ‘1.7’ WHERE option_name = ‘f12-cf7-doubleoptin_version’
2025-04-11T13:59:53.558168Z 49 Query DESCRIBE wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:53.559927Z 49 Query SHOW INDEX FROM wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:53.561382Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN content content LONGTEXT
2025-04-11T13:59:53.584097Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN files files LONGTEXT
2025-04-11T13:59:53.606004Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN hash hash VARCHAR(255)
2025-04-11T13:59:53.629920Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN form form LONGTEXT
2025-04-11T13:59:53.657938Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN mail_optin mail_optin LONGTEXT
2025-04-11T13:59:53.704003Z 49 Query UPDATE wp_884_options SET option_value = ‘2.0’ WHERE option_name = ‘f12-cf7-doubleoptin_version’
2025-04-11T13:59:53.709247Z 49 Query DESCRIBE wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:53.711329Z 49 Query SHOW INDEX FROM wp_884_f12_cf7_doubleoptin
2025-04-11T13:59:53.712807Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN content content LONGTEXT
2025-04-11T13:59:53.730689Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN files files LONGTEXT
2025-04-11T13:59:53.756093Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN hash hash VARCHAR(255)
2025-04-11T13:59:53.793515Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN form form LONGTEXT
2025-04-11T13:59:53.821316Z 49 Query ALTER TABLE wp_884_f12_cf7_doubleoptin CHANGE COLUMN mail_optin mail_optin LONGTEXT
2025-04-11T13:59:53.838674Z 49 Query UPDATE wp_884_options SET option_value = ‘3.0.1’ WHERE option_name = ‘f12-cf7-doubleoptin_version’

Problem is incositency in check “SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘f12-cf7-doubleoptin_version’ AND site_id = 139” which is looking for site_id (139 it’s network) and not blog_id (884 it’s site id) and update into table wp_884_options.