McPringle/komunumo

Too many equal SQL after admin page load

Opened this issue · 0 comments

At a page reload in the admin area, the member is requested six times (6x!) from the database using the same SQL. When navigating to another view, the member is requested two times (2x) from the database using the same SQL. Where does this SQL come from? Maybe Spring Security?

select `member`.`id`, `member`.`first_name`, `member`.`last_name`, `member`.`company`, `member`.`email`, `member`.`address`, `member`.`zip_code`, `member`.`city`, `member`.`state`, `member`.`country`, `member`.`registration_date`, `member`.`membership_begin`, `member`.`membership_end`, `member`.`membership_id`, `member`.`theme`, `member`.`admin`, `member`.`password_hash`, `member`.`password_change`, `member`.`activation_code`, `member`.`account_active`, `member`.`account_blocked`, `member`.`account_blocked_reason`, `member`.`account_deleted`, `member`.`comment` from `member` where (`member`.`email` = ? and `member`.`account_deleted` = false) order by `member`.`registration_date` desc