SELECT 
  cscart_profile_field_values.value_id, 
  cscart_profile_field_descriptions.description 
FROM 
  cscart_profile_field_values 
  LEFT JOIN cscart_profile_field_descriptions ON cscart_profile_field_values.value_id = cscart_profile_field_descriptions.object_id 
WHERE 
  cscart_profile_field_descriptions.lang_code = 'en' 
  AND cscart_profile_field_descriptions.object_type = 'V' 
  AND cscart_profile_field_values.field_id = 62

Query time 0.00054

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "27.24"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_profile_field_values",
          "access_type": "ALL",
          "possible_keys": [
            "PRIMARY"
          ],
          "rows_examined_per_scan": 82,
          "rows_produced_per_join": 8,
          "filtered": "10.00",
          "cost_info": {
            "read_cost": "15.76",
            "eval_cost": "1.64",
            "prefix_cost": "17.40",
            "data_read_per_join": "131"
          },
          "used_columns": [
            "value_id",
            "field_id"
          ],
          "attached_condition": "(`webmarco`.`cscart_profile_field_values`.`field_id` = 62)"
        }
      },
      {
        "table": {
          "table_name": "cscart_profile_field_descriptions",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "object_id",
            "object_type",
            "lang_code"
          ],
          "key_length": "12",
          "ref": [
            "webmarco.cscart_profile_field_values.value_id",
            "const",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 8,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "8.20",
            "eval_cost": "1.64",
            "prefix_cost": "27.24",
            "data_read_per_join": "6K"
          },
          "used_columns": [
            "object_id",
            "description",
            "object_type",
            "lang_code"
          ]
        }
      }
    ]
  }
}

Result

value_id description
5 Apparel & Accessories
6 Health and Beauty
7 Baby and Toddler
8 Food
10 Home & Garden
11 Furniture
12 Arts & Entertainment
13 Luggage & Bags
14 Sporting Goods
15 Toys & Games
16 Media
17 Electronics
18 Vehicles & Parts
19 Hardware
20 Software
21 Cameras & Optics
22 Business & Industrial
23 Animals & Pet Supplies
24 Religious & Ceremonial
25 Mature
26 All Categories
28 Travel Tickets
29 Hotel Booking
30 Tours
31 Fine Dining
32 Apartments
33 Room
34 Bar
35 Fast Food
36 Pizza
37 Buffet
38 Family Style
39 Sushi
40 Fish & Seafood
41 Traditional Food
42 Coffee & Hot Drinks
43 Vegan
44 Vegetarian
45 Home & Office
46 Intelligent Electronic Devices & Security
47 Plumbing & Electrical Services
48 Car Services
49 Food Delivery
50 Construction
51 Economy & Finance Services
52 Beauty & Wellness
53 Art & Photography
54 Personalized Products
55 Engineering & Transportation
56 Sanitizing
57 Rental
58 Gifts & Events
59 After-Sale Services
60 Health Care Services
61 Jobs & Education
62 Consulting and Various Offers
63 Pet Care
64 Holidays and Travel
65 Security and Protection
66 Mobile Phones and Smartphones
67 Music and Sounds
68 Programming and Tech
69 Electric Energy and Natural Gas
70 Training In The Place Of Advice And Various Offers
71 Legal Services
72 Boutique Hotels
73 Resorts
74 Motels
75 INNS
76 Conference/convention Center Hotels
77 Extended Stay Hotels
78 Food, Beverages & Tobacco
79 Engineering & Transportation
80 Office Supplies
81 Tattoo
82 Venue Booking
83 Photography