{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "35.44"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "8.20"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_profile_field_values",
"access_type": "ALL",
"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",
"position"
],
"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"
]
}
}
]
}
}
}
value_id | description |
---|---|
44 | Vegetarian |
43 | Vegan |
42 | Coffee & Hot Drinks |
41 | Traditional Food |
40 | Fish & Seafood |
39 | Sushi |
38 | Family Style |
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 |
32 | Apartments |
33 | Room |
34 | Bar |
31 | Fine Dining |
35 | Fast Food |
36 | Pizza |
37 | Buffet |
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 |