Query time 0.00210
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.55"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "pf",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"status",
"company_id"
],
"key": "status",
"used_key_parts": [
"status"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 90,
"rows_produced_per_join": 8,
"filtered": "9.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.81",
"prefix_cost": "9.75",
"data_read_per_join": "3K"
},
"used_columns": [
"feature_id",
"feature_code",
"company_id",
"purpose",
"feature_style",
"filter_style",
"feature_type",
"categories_path",
"parent_id",
"display_on_product",
"display_on_catalog",
"display_on_header",
"display_on_key_product_info",
"status",
"position",
"comparison",
"timestamp",
"updated_timestamp"
],
"attached_condition": "((`cscart_db`.`pf`.`feature_type` <> 'G') and (`cscart_db`.`pf`.`display_on_product` = 'Y') and ((`cscart_db`.`pf`.`categories_path` = '') or (`cscart_db`.`pf`.`categories_path` is null) or (0 <> find_in_set(1677,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2289,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2331,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2685,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2827,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2831,`cscart_db`.`pf`.`categories_path`))))"
}
},
{
"table": {
"table_name": "pf_groups",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscart_db.pf.parent_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "19.00",
"cost_info": {
"read_cost": "2.02",
"eval_cost": "0.15",
"prefix_cost": "12.58",
"data_read_per_join": "689"
},
"used_columns": [
"feature_id",
"status",
"position"
],
"attached_condition": "<if>(found_match(pf_groups), ((`cscart_db`.`pf_groups`.`status` = 'A') or (`cscart_db`.`pf_groups`.`status` is null)), true)"
}
},
{
"table": {
"table_name": "cscart_product_features_values",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id",
"fl"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id"
],
"key_length": "6",
"ref": [
"cscart_db.pf.feature_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "50.00",
"cost_info": {
"read_cost": "1.16",
"eval_cost": "0.09",
"prefix_cost": "13.92",
"data_read_per_join": "35"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"value",
"value_int",
"lang_code"
],
"attached_condition": "(`cscart_db`.`cscart_product_features_values`.`lang_code` = 'en')"
}
},
{
"table": {
"table_name": "pf_groups_description",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart_db.pf.parent_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.22",
"eval_cost": "0.09",
"prefix_cost": "14.23",
"data_read_per_join": "2K"
},
"used_columns": [
"feature_id",
"description",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_product_features_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscart_db.pf.feature_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.22",
"eval_cost": "0.09",
"prefix_cost": "14.55",
"data_read_per_join": "2K"
},
"used_columns": [
"feature_id",
"description",
"full_description",
"prefix",
"suffix",
"lang_code",
"internal_name"
]
}
}
]
}
}
}
}
Result
| feature_id |
company_id |
feature_type |
parent_id |
display_on_product |
display_on_catalog |
display_on_header |
description |
internal_name |
lang_code |
prefix |
suffix |
categories_path |
full_description |
status |
comparison |
position |
purpose |
feature_style |
filter_style |
feature_code |
timestamp |
updated_timestamp |
group_position |
value |
variant_id |
value_int |
display_on_key_product_info |
| 62 |
41 |
E |
0 |
Y |
N |
Y |
Brand |
Brand |
en |
|
|
|
|
A |
N |
1 |
organize_catalog |
brand |
checkbox |
|
1638728784 |
1788777747 |
|
|
53750 |
|
N |
| 65 |
13 |
M |
0 |
Y |
N |
N |
Key Ingredients |
Key Ingredients |
en |
|
|
|
|
A |
N |
30 |
find_products |
multiple_checkbox |
checkbox |
|
1638728784 |
1772177438 |
|
|
54967 |
|
N |
| 178 |
0 |
S |
66 |
Y |
N |
N |
Select |
Select |
en |
|
|
|
|
A |
N |
0 |
group_catalog_item |
dropdown_labels |
checkbox |
|
1770725250 |
1770725713 |
0 |
|
62380 |
|
Y |
| 68 |
13 |
S |
66 |
Y |
N |
N |
Net Volume |
Net Volume |
en |
|
ml |
|
|
A |
N |
2 |
group_variation_catalog_item |
dropdown_labels |
checkbox |
|
1638728784 |
1772188069 |
0 |
|
19614 |
|
Y |
| 175 |
0 |
T |
66 |
Y |
N |
N |
All Ingredients |
All Ingredients |
en |
|
|
|
|
A |
N |
40 |
describe_product |
text |
|
|
1762327287 |
1762330185 |
0 |
Dragon Blood (Tree sap extract),CICAHYALON, CICAHYALON, Water, Butylene Glycol, Glycerin, Methylpropanediol, Tripropylene Glycol, Tuber Melanosporum Extract (Black Truffle Extract), Niacinamide, Octyldodecanol, 1,2-Hexanediol, C9-12 Alkane, Sodium Acrylate/Sodium Acryloyldimethyl Taurate Copolymer, Polyisobutene, Sodium Polyacrylate, Acrylates/C10-30 Alkyl Acrylate Crosspolymer, Polyacrylate Crosspolymer-6, Arginine, Silica, Caprylyl/Capryl Glucoside, Sorbitan Oleate, Dimethiconol, Hydroxyacetophenone, Ethylhexylglycerin, Caprylyl Glycol, Adenosine, Xanthan Gum, Centella Asiatica Extract, Tuber Magnatum Extract (White Truffle Extract), Panthenol, Tocopherol (Vitamin E), Collagen, Hydrogenated Lecithin, Sodium Hyaluronate, Ceramide NP, Glycosphingolipids, Malt Extract, Propolis Extract, Asiatic Acid, Asiaticoside |
0 |
|
N |
| 63 |
13 |
S |
66 |
Y |
N |
N |
Country of Origin |
Country of Origin |
en |
|
|
|
|
A |
N |
100 |
find_products |
text |
checkbox |
|
1638728784 |
1776406716 |
0 |
|
10351 |
|
N |