Hi,

i installed some updates last days for plugins including the banner plug in version 2.4.0.

In the admin area, the query in the banner plugin is very slow.
Frontuser-Interface loading time is also very slow when running this plugin.

Specifically, admin panel - Banners - List of banners

List will be empty.

after some time you can click on listboxes, entries are shown.
I click again on List of Banner, the plugin shows the entries immediately.

I click again on List of Banners, everything starts all over again, very long wait.

See also slow-log of MySQL.

# Time: 130926 18:23:23
# User@Host: *******[******] @ localhost []
# Query_time: 162.232385 Lock_time: 0.000140 Rows_sent: 20 Rows_examined: 40959132
SET timestamp=1380205403;
SELECT SQL_CALC_FOUND_ROWS DISTINCT `T1`.`ID`, `T1`.`Account_ID`, `T1`.`Html`, `T1`.`Image` AS `thumbnail`, `T1`.`Type`, `T1`.`Date_release`, `T1`.`Status`, `T1`.`Last_show`, `T1`.`Shows`, `T1`.`Pay_date`, `T2`.`Value` AS `name`, `T3`.`Username`, `T4`.`Key` AS `Plan_key`, `T4`.`Price`, `T4`.`Period`, `T4`.`Plan_Type`, `T5`.`Banners` FROM `fl_banners` AS `T1` LEFT JOIN `fl_lang_keys` AS `T2` ON CONCAT('banners+name+',`T1`.`ID`) = `T2`.`Key` AND `T2`.`Code` = 'en' LEFT JOIN `fl_accounts` AS `T3` ON `T1`.`Account_ID` = `T3`.`ID` LEFT JOIN `fl_banner_plans` AS `T4` ON `T1`.`Plan_ID` = `T4`.`ID` LEFT JOIN `fl_blocks` AS `T5` ON `T1`.`Box` = `T5`.`Key` AND `T1`.`Type` = 'flash' WHERE `T1`.`Status` <> 'trash' LIMIT 40, 20;


Please Help.

Thanks !!!

Best regards.
Sakis