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 = 36 
  AND object_type = 'S'

Query time 0.01007

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2.10"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "profile_fields_data",
          "access_type": "ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "object_id",
            "object_type"
          ],
          "key_length": "6",
          "ref": [
            "const",
            "const"
          ],
          "rows_examined_per_scan": 3,
          "rows_produced_per_join": 3,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.75",
            "eval_cost": "0.30",
            "prefix_cost": "1.05",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "object_id",
            "object_type",
            "field_id",
            "value"
          ]
        }
      },
      {
        "table": {
          "table_name": "profile_fields",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "field_id"
          ],
          "key_length": "3",
          "ref": [
            "wearethehelpful_scalesta_net.profile_fields_data.field_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 3,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.75",
            "eval_cost": "0.30",
            "prefix_cost": "2.10",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "field_id",
            "field_type"
          ]
        }
      }
    ]
  }
}

Result

field_id value field_type
53 I’m a holistic, intuitive therapist and wellness collaborator, offering a variety of sensory-led products and experiences — including bespoke scent compositions for individuals, brands, and special events. My work is shaped by my life experiences and a pa I
54 Thoughtfully curated self-care bundles, bespoke aromatherapy blends, and holistic treatments. I’d also love to offer workshops and experiences that support emotional wellbeing and sensory connection — including custom scent creation, rituals, and self-car I
55 Our customers are intuitive and thoughtful, often navigating transitions, seeking calm, or craving deeper relaxation and connection. They’re drawn to ritual, nature-based practices, and products made with intention. Many value the bespoke, personal nature T
56 We are rooted in Scotland, with regular workshops and treatments in Edinburgh and private events held across the UK. We also collaborate on retreats both locally and abroad, and send our ritual-led products to customers around the world. Our signature ran I