Repeated SQL queries

Not reprod on 4.4.x yet. If the issue is still there, it may offer some performance gain by reducing several hundred queries into (hopefully) a couple of lookups.

When sending email to a single contact and being returned to their contact view page, the CiviCRM log recorded ~9K of CivICRM SQL queries. Seems that ~6K of the queries are these two, repeated hundreds of times each (~300 for the first, and ~500 for the second). One is querying the menu callbacks it seems, the other is repeated based on number of custom fields on the site. (I wonder if the first indicates that the site is in a debug mode where it rebuilds the menu for every query? But debug is disabled in UI.)

https://gist.github.com/xurizaemon/7699085

– this query is similarly repeated hundreds of times, with parent_id = [NULL..285]

SELECT id, label, url, permission, permission_operator, has_separator, parent_id, is_active, name
FROM civicrm_navigation
WHERE parent_id IS NULL
AND domain_id = 1
ORDER BY parent_id, weight

– this query is repeated several hundreds of times, with f = [3..437]

SELECT f.id, f.name AS field_name, f.label AS field_label, g.name AS group_name, g.title AS group_title
FROM civicrm_custom_field f
INNER JOIN civicrm_custom_group g ON f.custom_group_id = g.id
WHERE f.id IN (3)