I’ve got an old site that was taking over a minute to load the edit/new entries page, and been working through updating all the add-ons to try and resolve.

Originally there were 1831 queries with hundreds of SQL calls relating to developer logs (mostly SELECT). I’ve managed to eliminate most of these (down to 229 queries now) and it looks like Blueprints is the only culprit left.

Edit: Ticket doesn’t seem to want to save the version numbers - Blueprints v2.0.6 and EE v2.6.1

The developer log issues (shown in SQL output in Control Panel when access New Entry) start with this one…

SELECT *
FROM (`exp_developer_log`)
WHERE `function` =  'remove_double_slashes()'
AND `line` =  185
AND `file` =  '/home/stgecare/eecms-addons/blueprints/helper.blueprints.php'
AND `deprecated_since` =  '2.6'
AND `use_instead` =  'reduce_double_slashes()'
ORDER BY `log_id` desc

Then…

SELECT *
FROM (`exp_developer_log`)
WHERE `function` =  'generate_json()'
AND `line` =  537
AND `file` =  '/home/stgecare/eecms-addons/blueprints/ext.blueprints.php'
AND `deprecated_since` =  '2.6'
AND `use_instead` =  'the native JSON extension (json_encode())'
ORDER BY `log_id` desc

Then probably over 100 SQL calls immediately afterwards looking identical…

SELECT *
FROM (`exp_developer_log`)
WHERE `function` =  ‘generate_json()’
AND `line` =  801
AND `file` =  ‘/home/stgecare/eecms/codeigniter/system/libraries/Javascript.php’
AND `deprecated_since` =  ‘2.6’
AND `use_instead` =  ‘the native JSON extension (json_encode())’
ORDER BY `log_id` desc