Query time 0.00115
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "32.25"
},
"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": 18,
"rows_produced_per_join": 8,
"filtered": "50.00",
"index_condition": "((`cscart_db`.`v`.`lang_code` = 'en') and (`cscart_db`.`v`.`feature_id` is not null))",
"cost_info": {
"read_cost": "15.16",
"eval_cost": "0.90",
"prefix_cost": "16.96",
"data_read_per_join": "359"
},
"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": 7,
"filtered": "86.54",
"cost_info": {
"read_cost": "2.25",
"eval_cost": "0.78",
"prefix_cost": "20.11",
"data_read_per_join": "3K"
},
"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(2291,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2301,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2711,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2726,`cscart_db`.`f`.`categories_path`)) or (0 <> find_in_set(2728,`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": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.95",
"eval_cost": "0.78",
"prefix_cost": "22.84",
"data_read_per_join": "17K"
},
"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": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "2.09",
"eval_cost": "0.78",
"prefix_cost": "25.70",
"data_read_per_join": "8K"
},
"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": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "3.04",
"eval_cost": "0.78",
"prefix_cost": "29.53",
"data_read_per_join": "58K"
},
"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": 7,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.95",
"eval_cost": "0.78",
"prefix_cost": "32.25",
"data_read_per_join": "3K"
},
"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, Cyclo Pentasiloxane, Titanium Dioxide (Ci 77891), Trimethylsiloxysili Cate, Propanediol, Iron Oxides (Ci 77492), Isododecane, Di Phenylsiloxy Phenyl Trimethi Cone, Methyl Trimethicone, Niacinamide, Peg-10 Dimethi Cone, Octyldodecanol, Dimethi Cone, Polyglyceryl-3 Polydime Thylsiloxyethyl Dimethicone, Peg/Ppg-18/18 Dimethicone, 1,2-Hexanediol, Magnesium Sulfate, Disteardimonium Hec Torite, Iron Oxides (Ci 77491), Aluminum Hydroxide, Polygly Ceryl-4 Isostearate, Iron Oxides (Ci 77499), Stearic Acid, Poly Hydroxystearic Acid, Triethoxy Caprylylsilane, Alumina, Potassium Sorbate, Isopropyl Titanium Triisostearate, Fragrance (Parfum), Neopentyl Glycol Diethy Lhexanoate, Adenosine, Trisodium Ethylenediamine Disuccinate, Polymethyl Methacrylate, Haematococcus Pluvialis Oil, Butylene Glycol, Glycerin, Di Propylene Glycol, Sodium Palmitoyl Proline, Cetearyl Dimethicone/Vinyl Dimethicone Cross Polymer, Hibiscus Sabdariffa Flower Extract, Astaxanthin, Rosa Rugosa Flower Extract, Pancratium Maritimum Extract, Nymphaea Alba Flower Extract, Propolis 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 |
|
|
59745 |
E |
Brand |
Brand |
|
|
Tirtir |
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 |
8809928134901 |
|
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 |
| 72 |
Press the puff into the cushion to pick up the foundation, then gently pat it onto your face, starting from the center and blending outward for an even, natural look. Layer as needed for desired coverage, reapply for touch-ups throughout the day to mainta |
|
0 |
T |
How to Use |
How to Use |
|
|
|
0 |
3 |
|
text |
N |
N |
N |
|
describe_product |
| 65 |
|
|
59768 |
M |
Key Ingredients |
Key Ingredients |
|
|
Water, Cyclo Pentasiloxane, Titanium Dioxide (Ci 77891) |
0 |
30 |
|
multiple_checkbox |
N |
N |
Y |
|
find_products |
| 148 |
N |
|
0 |
C |
Microwave Safe |
Microwave Safe |
|
|
|
0 |
0 |
|
checkbox |
N |
N |
N |
|
find_products |
| 67 |
|
|
41509 |
S |
Net Weight |
Net Weight |
|
gm |
18 |
0 |
1 |
|
dropdown_labels |
N |
N |
Y |
|
group_catalog_item |
| 104 |
|
|
62053 |
S |
Shade |
Shade |
|
|
33N Macchiato |
0 |
10 |
|
dropdown_images |
N |
N |
Y |
|
group_catalog_item |
| 163 |
|
|
54763 |
M |
Tags |
Tags |
|
|
k-beauty tag |
0 |
0 |
|
multiple_checkbox |
N |
N |
N |
|
find_products |