Query time 0.00128
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "23.77"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "v",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"variant_id",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id",
"fl"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 13,
"rows_produced_per_join": 6,
"filtered": "50.00",
"index_condition": "((`cscart_db`.`v`.`lang_code` = 'en') and (`cscart_db`.`v`.`feature_id` is not null))",
"cost_info": {
"read_cost": "10.58",
"eval_cost": "0.65",
"prefix_cost": "11.88",
"data_read_per_join": "259"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"value",
"value_int",
"lang_code"
]
}
},
{
"table": {
"table_name": "f",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscart_db.v.feature_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "86.54",
"cost_info": {
"read_cost": "1.62",
"eval_cost": "0.56",
"prefix_cost": "14.15",
"data_read_per_join": "2K"
},
"used_columns": [
"feature_id",
"feature_code",
"purpose",
"feature_style",
"feature_type",
"categories_path",
"parent_id",
"display_on_product",
"display_on_catalog",
"display_on_header",
"status",
"position"
],
"attached_condition": "((`cscart_db`.`f`.`status` = 'A') and ((`cscart_db`.`f`.`categories_path` = '') or (0 <> find_in_set(1677,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2289,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2327,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2685,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2705,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2811,`cscart_db`.`f`.`categories_path`))) and (if(`cscart_db`.`f`.`parent_id`,(/* select#2 */ select `cscart_db`.`df`.`status` from `cscart_db`.`cscart_product_features` `df` where (`cscart_db`.`df`.`feature_id` = `cscart_db`.`f`.`parent_id`)),'A') = 'A') and ((`cscart_db`.`v`.`variant_id` <> 0) or ((`cscart_db`.`f`.`feature_type` <> 'C') and (`cscart_db`.`v`.`value` <> '')) or (`cscart_db`.`f`.`feature_type` = 'C') or (`cscart_db`.`v`.`value_int` <> 0)))",
"attached_subqueries": [
{
"dependent": true,
"cacheable": false,
"query_block": {
"select_id": 2,
"cost_info": {
"query_cost": "0.35"
},
"table": {
"table_name": "df",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscart_db.f.parent_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "448"
},
"used_columns": [
"feature_id",
"status"
]
}
}
}
]
}
},
{
"table": {
"table_name": "fd",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart_db.v.feature_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.41",
"eval_cost": "0.56",
"prefix_cost": "16.12",
"data_read_per_join": "12K"
},
"used_columns": [
"feature_id",
"description",
"prefix",
"suffix",
"lang_code",
"internal_name"
]
}
},
{
"table": {
"table_name": "fv",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"variant_feature_idx",
"idx_var_feat_pos"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"cscart_db.v.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.91",
"eval_cost": "0.56",
"prefix_cost": "18.59",
"data_read_per_join": "6K"
},
"used_columns": [
"variant_id",
"position"
]
}
},
{
"table": {
"table_name": "vd",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart_db.fv.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.65",
"eval_cost": "0.56",
"prefix_cost": "21.80",
"data_read_per_join": "42K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
},
{
"table": {
"table_name": "gf",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscart_db.f.parent_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.41",
"eval_cost": "0.56",
"prefix_cost": "23.77",
"data_read_per_join": "2K"
},
"used_columns": [
"feature_id",
"feature_type",
"position"
],
"attached_condition": "<if>(is_not_null_compl(gf), (`cscart_db`.`gf`.`feature_type` = 'G'), true)"
}
}
]
}
}
}
Result
| feature_id |
value |
value_int |
variant_id |
feature_type |
internal_name |
description |
prefix |
suffix |
variant |
parent_id |
position |
gposition |
feature_style |
display_on_header |
display_on_catalog |
display_on_product |
feature_code |
purpose |
| 175 |
Water, Glycerin, Butylene Glycol, Dicaprylyl Ether, Niacinamide, 1,2?Hexanediol, Dicaprylyl Carbonate, Hydrogenated Polydecene, Hydroxyethyl Acrylate/Sodium Acryloyldimethyl Taurate Copolymer, Polyglyceryl?3 Methylglucose Distearate, Cetearyl Alcohol, Isohexadecane, Glyceryl Stearate, PEG?100 Stearate, Cetyl Alcohol, Vinyldimethicone, Panthenol, Saccharomyces Ferment, Allium Sativum (Garlic) Bulb Extract, Caprylyl Methicone, Acrylates/C10?30 Alkyl Acrylate Crosspolymer, Tromethamine, Glyceryl Acrylate/Acrylic Acid Copolymer, Dimethiconol, Biosaccharide Gum?1, Dipotassium Glycyrrhizate, Lauroyl Lysine, Allantoin, Xanthan Gum, Adenosine, Sorbitan Isostearate, Hydroxypropyl Guar, Disodium EDTA, Hydroxyethylcellulose, Melia Azadirachta Leaf Extract, Melia Azadirachta Flower Extract, Curcuma Longa (Turmeric) Root Extract, Tocopherol, Ethylhexylglycerin, Ocimum Sanctum Leaf Extract, |
|
0 |
T |
All Ingredients |
All Ingredients |
|
|
|
66 |
40 |
0 |
text |
N |
N |
Y |
|
describe_product |
| 143 |
N |
|
0 |
C |
BBB |
BBB |
|
|
|
0 |
0 |
|
checkbox |
N |
N |
N |
|
find_products |
| 62 |
|
|
53750 |
E |
Brand |
Brand |
|
|
VT Cosmetics |
0 |
1 |
|
brand |
Y |
N |
Y |
|
organize_catalog |
| 63 |
|
|
10351 |
S |
Country of Origin |
Country of Origin |
|
|
South Korea |
66 |
100 |
0 |
text |
N |
N |
Y |
|
find_products |
| 149 |
N |
|
0 |
C |
Dishwasher Safe |
Dishwasher Safe |
|
|
|
0 |
0 |
|
checkbox |
N |
N |
N |
|
find_products |
| 168 |
8803463012106 |
|
0 |
T |
EAN |
EAN |
|
|
|
0 |
0 |
|
text |
N |
N |
N |
EAN |
describe_product |
| 161 |
N |
|
0 |
C |
Exclude in kc commission |
Exclude in kc commission |
|
|
|
0 |
0 |
|
checkbox |
N |
N |
N |
|
find_products |
| 148 |
N |
|
0 |
C |
Microwave Safe |
Microwave Safe |
|
|
|
0 |
0 |
|
checkbox |
N |
N |
N |
|
find_products |
| 163 |
|
|
54763 |
M |
Tags |
Tags |
|
|
k-beauty tag |
0 |
0 |
|
multiple_checkbox |
N |
N |
N |
|
find_products |