Hey Guys, bit of a strange on a site using JFilters - the host has reported MySQL abuse - i.e. high resource usage and i think its related to JFilters. See below.
When reviewing the logs on the server we're seeing lots of queries such as this running:
SELECT `main`.`id` AS `value`,`main`.`title` AS `label`,`main`.`alias` AS `alias`,`main`.`metadesc` AS `metadescription`,`main`.`metakey` AS `metakeywords`,`main`.`parent_id` AS `parent_id`,count(DISTINCT(items.`id`)) AS `count` FROM i1aen_tags AS main LEFT JOIN `i1aen_tags` AS tree ON (`main`.`lft` <= `tree`.`lft` AND `tree`. `lft` < `main`.`rgt`) OR (`tree`.`lft` < `main`.`lft` AND `main`.`rgt` < `tree`.`rgt`) LEFT JOIN `i1aen_contentitem_tag_map` AS itemValueRef ON main.id=itemValueRef.tag_id LEFT JOIN `i1aen_content` AS items ON itemValueRef.content_item_id=items.id LEFT JOIN `i1aen_content` AS filter1 ON itemValueRef.content_item_id=filter1.id LEFT JOIN `i1aen_fields_values` AS filter3 ON itemValueRef.content_item_id=filter3.item_id LEFT JOIN `i1aen_fields_values` AS filter6 ON itemValueRef.content_item_id=filter6.item_id LEFT JOIN `i1aen_fields_values` AS filter7 ON itemValueRef.content_item_id=filter7.item_id LEFT JOIN `i1aen_fields_values` AS filter8 ON itemValueRef.content_item_id=filter8.item_id LEFT JOIN `i1aen_fields_values` AS filter10 ON itemValueRef.content_item_id=filter10.item_id WHERE (`main`.`published` = 1 AND `tree`.`id` = 1 AND `itemValueRef`.`type_id` = 1 AND `items`.`state` = '1' AND `items`.`access` IN (1,5) AND `filter3`.`field_id` = 15 AND `filter6`.`field_id` = 18 AND `filter7`.`field_id` = 19 AND `filter8`.`field_id` = 20 AND `filter10`.`field_id` = 23) AND (items.publish_up IS NULL OR `items`.`publish_up` <= '2025-04-23 10:03:00') AND (items.publish_down IS NULL OR `items`.`publish_down` >= '2025-04-23 10:03:00') AND (`filter1`.`catid` IN (21)) AND (`filter3`.`value` IN ('Venture Capital')) AND (`filter6`.`value` IN ('1 – 10 M')) AND (`filter7`.`value` IN ('Germany')) AND (`filter8`.`value` IN ('Funds')) AND (`filter10`.`value` IN ('Social Enterprise ')) GROUP BY main.`id` ORDER BY `main`.`lft` ASC
Any suggestions?