Too many equal SQL after admin page load
Opened this issue · 0 comments
McPringle commented
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