Here is an example where we are issuing several queries to get the id of a custom field by name. This is based on the bug tracker running on this site as of July 19th which is based on the latest from SVN trunk. The queries below were noticed on 0009309.

42 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
43 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'resolution'
44 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'handler_id'
45 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'due_date'
46 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
47 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'resolution'
48 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'due_date'
49 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'handler_id'
50 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
51 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'resolution'
52 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'fixed_in_version'
53 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'due_date'
54 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
55 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'resolution'
56 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'due_date'
57 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
58 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'handler_id'
59 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'status'
60 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'resolution'
61 0.0003 custom_field_api.php:689 custom_field_get_id_from_name()
SELECT id FROM mantis_custom_field_table WHERE name = 'due_date'