Query time 0.00094
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.92"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"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": "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`.`cscart_product_features_values`.`lang_code` = 'en')",
"cost_info": {
"read_cost": "10.10",
"eval_cost": "0.65",
"prefix_cost": "11.40",
"data_read_per_join": "259"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"value",
"value_int",
"lang_code"
]
}
},
{
"table": {
"table_name": "pf",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"company_id"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id"
],
"key_length": "3",
"ref": [
"cscart_db.cscart_product_features_values.feature_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "7.79",
"cost_info": {
"read_cost": "1.62",
"eval_cost": "0.05",
"prefix_cost": "13.68",
"data_read_per_join": "226"
},
"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`.`status` = 'A') 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(2327,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2685,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2705,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2811,`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": 0,
"filtered": "19.00",
"cost_info": {
"read_cost": "0.13",
"eval_cost": "0.01",
"prefix_cost": "13.86",
"data_read_per_join": "43"
},
"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": "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.02",
"eval_cost": "0.01",
"prefix_cost": "13.89",
"data_read_per_join": "223"
},
"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.cscart_product_features_values.feature_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.02",
"eval_cost": "0.01",
"prefix_cost": "13.92",
"data_read_per_join": "223"
},
"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 |
| 175 |
0 |
T |
66 |
Y |
N |
N |
All Ingredients |
All Ingredients |
en |
|
|
|
|
A |
N |
40 |
describe_product |
text |
|
|
1762327287 |
1762330185 |
0 |
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 |
|
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 |