SELECT 
  object_id 
FROM 
  cscart_settings_objects 
  LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id 
WHERE 
  cscart_settings_objects.name = 'pinta_google_tag_manager_settings'

Query time 0.00021

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_objects ref name name 386 const 1 Using index condition

Result

object_id
6274