Query time 0.00137
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "14.56"
},
"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(2711,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(2731,`cscart_db`.`pf`.`categories_path`)) or (0 <> find_in_set(3018,`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.17",
"eval_cost": "0.09",
"prefix_cost": "13.94",
"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.25",
"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.57",
"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 |
|
|
53644 |
|
N |
| 74 |
13 |
S |
0 |
Y |
N |
N |
Net Content |
Net Content |
en |
|
|
|
|
A |
N |
2 |
find_products |
text |
checkbox |
|
1638728784 |
1776406544 |
|
|
34106 |
|
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 |
|
|
62059 |
|
Y |
| 65 |
13 |
M |
0 |
Y |
N |
N |
Key Ingredients |
Key Ingredients |
en |
|
|
|
|
A |
N |
30 |
find_products |
multiple_checkbox |
checkbox |
|
1638728784 |
1772177438 |
|
|
59305 |
|
N |
| 61 |
13 |
M |
0 |
Y |
N |
N |
Formulation |
Formulation |
en |
|
|
|
|
A |
N |
113 |
find_products |
multiple_checkbox |
checkbox |
|
1638728784 |
1754481614 |
|
|
35785 |
|
N |
| 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 |
|
62061 |
|
Y |
| 69 |
13 |
T |
66 |
Y |
N |
N |
Expiry Date |
Expiry Date |
en |
|
|
|
|
A |
N |
5 |
describe_product |
text |
|
|
1638728784 |
1763027604 |
0 |
36 Months |
0 |
|
N |
| 175 |
0 |
T |
66 |
Y |
N |
N |
All Ingredients |
All Ingredients |
en |
|
|
|
|
A |
N |
40 |
describe_product |
text |
|
|
1762327287 |
1762330185 |
0 |
Hydrogenated Polyisobutene, Bis-Diglyceryl Polyacyladipate-2, Synthetic wax, Isononyl Isononanoate, Hydrogenated Polycyclopentadiene (and) Polyethylene (and) Copernicia Cerifera (Carnauba) Wax (and) Tocopherol, Hydrogenated Castor Oil, Dimethicone, Euphorbia Cerifera Cera, Microcrystalline Wax, Paraffin, Fragaria Ananassa (Strawberry) Seed Oil, Mangifera Indica (Mango) Seed Oil, Prunus Persica (Peach) Kernel Oil, Punica Granatum (Pomegranate) Seed Oil, Rubus Idaeus (Raspberry) Seed Oil, Vaccinium Corymbosum (Blueberry) Seed Oil, Vaccinium Macrocarpon (Cranberry) Seed Oil. May Contain : Titanium dioxide (CI 77891), Red iron oxide (CI 77491), Yellow iron oxide (CI 77492), Black iron oxide (CI 77499), Red-7 (CI 15850), Lake of red-27 (CI 45410), Yellow-5 (CI 19140). |
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 |
|
10348 |
|
N |
| 131 |
13 |
T |
129 |
Y |
N |
N |
Breadth |
Breadth |
en |
|
cm |
|
|
A |
N |
0 |
describe_product |
text |
|
|
1668421449 |
1668661737 |
0 |
8.5 |
0 |
|
N |
| 132 |
0 |
T |
129 |
Y |
N |
N |
Height |
Height |
en |
|
cm |
|
|
A |
N |
0 |
describe_product |
text |
|
|
1668421469 |
1668661754 |
0 |
1.7 |
0 |
|
N |
| 130 |
13 |
T |
129 |
Y |
N |
N |
Length |
Length |
en |
|
cm |
|
|
A |
N |
0 |
describe_product |
text |
|
|
1668421426 |
1668661773 |
0 |
12.5 |
0 |
|
N |