Sandbox

SELECT 
  profile_fields_data.field_id, 
  profile_fields_data.value, 
  profile_fields.field_type 
FROM 
  cscart_profile_fields_data AS profile_fields_data 
  LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id 
WHERE 
  object_id = 4 
  AND object_type = 'S'

Query time 0.00096

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	profile_fields_data	ref	PRIMARY	PRIMARY	6	const,const	1	Using index condition
1	SIMPLE	profile_fields	eq_ref	PRIMARY	PRIMARY	3	hobilifedt.profile_fields_data.field_id	1