Query time 0.00202
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.66"
},
"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(2291,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2301,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2711,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2726,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2728,`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.26",
"eval_cost": "0.09",
"prefix_cost": "14.03",
"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.34",
"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.66",
"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 |
|
|
59745 |
|
N |
| 67 |
13 |
S |
0 |
Y |
N |
N |
Net Weight |
Net Weight |
en |
|
gm |
|
|
A |
N |
1 |
group_catalog_item |
dropdown_labels |
checkbox |
|
1638728784 |
1771398734 |
|
|
41509 |
|
Y |
| 104 |
0 |
S |
0 |
Y |
N |
N |
Shade |
Shade |
en |
|
|
|
<p>Specified the different Shades the products come in.</p> |
A |
N |
10 |
group_catalog_item |
dropdown_images |
checkbox |
|
1646028915 |
1770899731 |
|
|
62053 |
|
Y |
| 65 |
13 |
M |
0 |
Y |
N |
N |
Key Ingredients |
Key Ingredients |
en |
|
|
|
|
A |
N |
30 |
find_products |
multiple_checkbox |
checkbox |
|
1638728784 |
1772177438 |
|
|
59768 |
|
N |
| 175 |
0 |
T |
66 |
Y |
N |
N |
All Ingredients |
All Ingredients |
en |
|
|
|
|
A |
N |
40 |
describe_product |
text |
|
|
1762327287 |
1762330185 |
0 |
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 |
|
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 |