Incorrect MySQL queries in admin panel
I'm confused with the following queries run in Admin Panel:
SELECT `block_id`, `id` FROM `sbr220_blocks_pages` WHERE `page_name` = 'database_manage'; SELECT * FROM `sbr220_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'kcaptcha','yellowpages') ORDER BY `order`; SELECT * FROM `sbr220_actions` WHERE `status` = 'blocks'; SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr220_pages` WHERE `status` = 'active' AND `extras` IN ('', 'kcaptcha','yellowpages');
Correct me if I'm wrong but it seems they are not used in Admin Panel so I suppose there no need to run them actually.
Please analyze MySQL queries and optimize the core system.
Updated by Batyr Mackenov almost 9 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
The script was trying to load the blocks for backend as well since there was no respective check.
The issue is completely resolved.
Changes committed at rev #2612 (additional SQL optimizations also applied).