[OJS-3.4.0.8] High SQL Query Load

[shantanusingh]

OJS-3.4.0-8

At times, the application runs noticeably slow. Upon checking the SQL processes on the server during these instances, we observed that the following query was creating a high load, with around 200 queued processes:

select count(*) as aggregate from submissions as s left join publications as po on s.current_publication_id = po.publication_id where s.context_id in (44) and s.status in (3) and (exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘mann’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘mann’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘mann’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘ki’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘ki’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘ki’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘baat’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘baat’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘baat’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘agri’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘agri’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘agri’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘startups’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘startups’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘startups’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘agricultural’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘agricultural’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘agricultural’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘innovations’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘innovations’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘innovations’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘agribusiness’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘agribusiness’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘agribusiness’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘incubation’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘incubation’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘incubation’), ‘%’)) or exists (select * from submission_search_objects as sso inner join submission_search_object_keywords as ssok on sso.object_id = ssok.object_id inner join submission_search_keyword_list as sskl on sskl.keyword_id = ssok.keyword_id where sskl.keyword_text = LOWER(‘india’) and s.submission_id = sso.submission_id) or s.submission_id in (select p.submission_id from publications as p inner join publication_settings as ps on p.publication_id = ps.publication_id where ps.setting_name = ‘title’ and LOWER(ps.setting_value) LIKE CONCAT(‘%’, LOWER(‘india’), ‘%’)) or s.submission_id in (select p.submission_id from publications as p inner join authors as au on au.publication_id = p.publication_id inner join author_settings as aus on aus.author_id = au.author_id where aus.setting_name in (‘givenName’, ‘familyName’, ‘orcid’) and LOWER(aus.setting_value) LIKE CONCAT(‘%’, LOWER(‘india’), ‘%’))) and s.submission_id not in (158627) |

This issue significantly impacts the responsiveness of the application, and we are seeking guidance on how to address it effectively.

[abadan]

It must be the similar articles plugin. Disabling it should solve the problem. If you have a lot of accumulated queries, restarting MySQL after disabling it may allow you to see the result more quickly.

[shantanusingh]

Hi @abadan

Thank you for your reply.

We have disabled the plugin from the journals for now. Let’s observe and monitor the effects to see if there’s any improvement.

[mohammed.kadhim]

I had the exact issue and your suggestion worked like a charm! we’ve been working on this for two days. The odd thing is that restoring a backup didn’t resolve this for some reason.

Thank you so much!

[radjr]

We did an upgrade from 3.3.0-14 to 3.3.0-20 and ran into the same issue.

Questions please:

1. When we did the upgrade, there was no message or option to rebuild the database. Is this correct for this upgrade?
2. The similar papers still displays at the bottom of the article. We never used it before but it seems that this has been turned on for the upgrade. Could someone confirm this please? And please explain how we remove this from the article page? Turning off the similar article plugin does not remove it from that page. Thank you!

[asmecher]

Hi @radjr,

1. When we did the upgrade, there was no message or option to rebuild the database. Is this correct for this upgrade?

The database upgrade process is where it’s always been; either turn off installed in config.inc.php and open the web page in your browser, or use tools/upgrade.php. This hasn’t changed with 3.3.0-20. However, 3.3.0-20 is database-compatible with 3.3.0-14, so you don’t necessarily need to run this. If you don’t, OJS will self-report 3.3.0-14 rather than -20, but otherwise it’ll work fine.

2. The similar papers still displays at the bottom of the article. We never used it before but it seems that this has been turned on for the upgrade. Could someone confirm this please? And please explain how we remove this from the article page? Turning off the similar article plugin does not remove it from that page. Thank you!

If you’ve disabled the plugin but it still appears to be enabled, then it’s likely that you have a file permission problem in cache/ that’s preventing OJS from updating the plugin status to “disabled”. Double-check that you’re disabling the right plugin, and that the file permissions are OK. This plugin isn’t enabled on upgrade, so I wonder if it wasn’t removed from the filesystem in your previous installation, rather than disabled. The upgrade would’ve re-introduced that code causing the plugin to start running.

Regards,
Alec Smecher
Public Knowledge Project Team

[radjr]

I used the web based upgrade. It complete very quickly and did not update the database. Admin page report 3.3.0-20.

The permissions for the cache folder match all the other permissions in OJS. I chown -R user:user where the user is the user running OJS. I did look inside the php config file for what I though was the suggestedbysimilar plugin and it says enabled even though it is turn off in the plugin menu. So, it looks like something else. And, it is only on one publication! Weird. Bottom line is that when it was on, it was hammering the submissions table in the database. When I turned it off, it went away. That is worth looking into..but above my skill level.

[asmecher]

Hi @radjr,

How do you know that it didn’t update the database? It sounds to me like it worked.

Thanks,
Alec Smecher
Public Knowledge Project Team

[radjr]

WE have seen the following actively that has brought the 3.3.0-20 install to its knees.

| 2559 | da_admin | localhost | ojs2023 | Execute | 1129 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2754 | da_admin | localhost | ojs2023 | Execute | 794 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2770 | da_admin | localhost | ojs2023 | Execute | 725 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2772 | da_admin | localhost | ojs2023 | Execute | 573 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2788 | da_admin | localhost | ojs2023 | Execute | 642 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2805 | da_admin | localhost | ojs2023 | Execute | 586 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2822 | da_admin | localhost | ojs2023 | Execute | 534 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2835 | da_admin | localhost | ojs2023 | Execute | 1323 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 2838 | da_admin | localhost | ojs2023 | Execute | 317 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2870 | da_admin | localhost | ojs2023 | Execute | 573 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2872 | da_admin | localhost | ojs2023 | Execute | 394 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2885 | da_admin | localhost | ojs2023 | Execute | 374 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2892 | da_admin | localhost | ojs2023 | Execute | 515 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2901 | da_admin | localhost | ojs2023 | Execute | 488 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2912 | da_admin | localhost | ojs2023 | Execute | 458 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2929 | da_admin | localhost | ojs2023 | Execute | 450 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2949 | da_admin | localhost | ojs2023 | Execute | 0 | statistics | SELECT cve.* FROM controlled_vocab_entries cve WHERE cve.controlled_vocab_id = ? ORDER BY seq | 0.000 || 2956 | da_admin | localhost | ojs2023 | Execute | 1025 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 2959 | da_admin | localhost | ojs2023 | Execute | 487 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2963 | da_admin | localhost | ojs2023 | Execute | 352 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2969 | da_admin | localhost | ojs2023 | Execute | 234 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2978 | da_admin | localhost | ojs2023 | Execute | 39 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2986 | da_admin | localhost | ojs2023 | Execute | 28 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2995 | da_admin | localhost | ojs2023 | Execute | 14 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 2996 | da_admin | localhost | ojs2023 | Execute | 943 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3002 | da_admin | localhost | ojs2023 | Execute | 355 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3007 | da_admin | localhost | ojs2023 | Execute | 281 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3008 | da_admin | localhost | ojs2023 | Execute | 230 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3009 | da_admin | localhost | ojs2023 | Execute | 343 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3010 | da_admin | localhost | ojs2023 | Execute | 226 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3014 | da_admin | localhost | ojs2023 | Execute | 910 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3019 | da_admin | localhost | ojs2023 | Execute | 159 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3020 | da_admin | localhost | ojs2023 | Execute | 297 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3031 | da_admin | localhost | ojs2023 | Execute | 263 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3043 | da_admin | localhost | ojs2023 | Execute | 245 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3044 | da_admin | localhost | ojs2023 | Execute | 798 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3047 | da_admin | localhost | ojs2023 | Execute | 269 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3049 | da_admin | localhost | ojs2023 | Execute | 221 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3050 | da_admin | localhost | ojs2023 | Execute | 187 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3059 | da_admin | localhost | ojs2023 | Execute | 120 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3065 | da_admin | localhost | ojs2023 | Execute | 44 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3072 | da_admin | localhost | ojs2023 | Execute | 98 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3079 | da_admin | localhost | ojs2023 | Execute | 660 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3086 | da_admin | localhost | ojs2023 | Execute | 54 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3100 | da_admin | localhost | ojs2023 | Execute | 612 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3102 | da_admin | localhost | ojs2023 | Execute | 5 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3103 | da_admin | localhost | ojs2023 | Execute | 266 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3132 | da_admin | localhost | ojs2023 | Execute | 264 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3134 | da_admin | localhost | ojs2023 | Execute | 187 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3137 | da_admin | localhost | ojs2023 | Execute | 516 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3138 | da_admin | localhost | ojs2023 | Execute | 234 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3152 | da_admin | localhost | ojs2023 | Execute | 443 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3155 | da_admin | localhost | ojs2023 | Execute | 402 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3157 | da_admin | localhost | ojs2023 | Execute | 393 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3165 | da_admin | localhost | ojs2023 | Execute | 50 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3169 | da_admin | localhost | ojs2023 | Execute | 303 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3172 | da_admin | localhost | ojs2023 | Execute | 285 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3173 | da_admin | localhost | ojs2023 | Execute | 281 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3176 | da_admin | localhost | ojs2023 | Execute | 5 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3177 | da_admin | localhost | ojs2023 | Execute | 262 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3178 | da_admin | localhost | ojs2023 | Execute | 3 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3181 | da_admin | localhost | ojs2023 | Execute | 75 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3186 | da_admin | localhost | ojs2023 | Execute | 43 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3187 | da_admin | localhost | ojs2023 | Execute | 234 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3189 | da_admin | localhost | ojs2023 | Execute | 229 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3192 | da_admin | localhost | ojs2023 | Execute | 70 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3193 | da_admin | localhost | ojs2023 | Execute | 20 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3197 | da_admin | localhost | ojs2023 | Execute | 5 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3198 | da_admin | localhost | ojs2023 | Execute | 91 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3199 | da_admin | localhost | ojs2023 | Execute | 59 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3200 | da_admin | localhost | ojs2023 | Execute | 168 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3201 | da_admin | localhost | ojs2023 | Execute | 76 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3202 | da_admin | localhost | ojs2023 | Execute | 162 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3204 | da_admin | localhost | ojs2023 | Execute | 150 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3210 | da_admin | localhost | ojs2023 | Execute | 127 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3212 | da_admin | localhost | ojs2023 | Execute | 19 | Sending data | select s.* from submissionsas swhere s. context_id= ? and s. statusin (?) and (exist | 0.000 || 3214 | da_admin | localhost | ojs2023 | Execute | 125 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3216 | da_admin | localhost | ojs2023 | Execute | 110 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3217 | da_admin | localhost | ojs2023 | Execute | 107 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3218 | da_admin | localhost | ojs2023 | Execute | 105 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3223 | da_admin | localhost | ojs2023 | Execute | 80 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3227 | da_admin | localhost | ojs2023 | Execute | 74 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3229 | da_admin | localhost | ojs2023 | Execute | 66 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3231 | da_admin | localhost | ojs2023 | Execute | 59 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3234 | da_admin | localhost | ojs2023 | Execute | 50 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3237 | da_admin | localhost | ojs2023 | Sleep | 49 | | | 0.000 || 3241 | da_admin | localhost | ojs2023 | Execute | 0 | statistics | SELECT * FROM author_settings WHERE author_id = ? | 0.000 || 3245 | da_admin | localhost | ojs2023 | Execute | 40 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3249 | da_admin | localhost | ojs2023 | Execute | 35 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3250 | da_admin | localhost | ojs2023 | Execute | 34 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3253 | da_admin | localhost | ojs2023 | Execute | 30 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3254 | da_admin | localhost | ojs2023 | Execute | 30 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3255 | da_admin | localhost | ojs2023 | Execute | 28 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3258 | da_admin | localhost | ojs2023 | Execute | 28 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3260 | da_admin | localhost | ojs2023 | Execute | 22 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3265 | da_admin | localhost | ojs2023 | Execute | 10 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3266 | da_admin | localhost | ojs2023 | Execute | 9 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3268 | da_admin | localhost | ojs2023 | Execute | 8 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas swhere s. context_id= ? | 0.000 || 3269 | da_admin | localhost | ojs2023 | Execute | 5 | Sending data | SELECT COUNT(*) AS row_count FROM (select s.* from submissionsas s``

So I have used /usr/local/directadmin/data/templates/custom/cust_httpd.CUSTOM.2.pre and added
RewriteEngine on
RewriteCond %{HTTP_USER_AGENT} (Bytespider|claudebot|SemrushBot|GPTBot) [NC]
RewriteRule .* - [F,L]

to block the bots hitting the site. The file may need to be adjusted as other ai scrapers are seen.