Query time 0.00146
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(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.16",
"eval_cost": "0.09",
"prefix_cost": "13.93",
"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.24",
"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 |
|
|
53644 |
|
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 |
|
|
24760 |
|
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 |
|
|
62113 |
|
Y |
| 65 |
13 |
M |
0 |
Y |
N |
N |
Key Ingredients |
Key Ingredients |
en |
|
|
|
|
A |
N |
30 |
find_products |
multiple_checkbox |
checkbox |
|
1638728784 |
1772177438 |
|
|
59051 |
|
N |
| 175 |
0 |
T |
66 |
Y |
N |
N |
All Ingredients |
All Ingredients |
en |
|
|
|
|
A |
N |
40 |
describe_product |
text |
|
|
1762327287 |
1762330185 |
0 |
Olea Europaea (Olive) Fruit Oil, Dimethicone, Butyrospermum Parkii (Shea) Butter, Dimethicone/Vinyl Dimethicone Crosspolymer, Caprylic Capric Triglyceride, Polyhydroxystearic Acid, Mica, Cetyl PEG/PPG-10/1 Dimethicone, Microcrystalline Wax, Simmondsia Chinensis seed oil, Stearic Acid, Theobroma cacao seed butter, Centella asiatica oil, Salvia Hispanica (Chia) Seed Oil, Caprylyl Glycol, Disteardimonium Hectorite, Tocopheryl Acetate, Vanilla Planifolia Fruit Oil, Moringa Oleifera Seed Extract, Phenoxyethanol, Algae (Seaweed) Extract, Camellia Sinensis (Green Tea) Leaf Extract, Palmitoyl Tripeptide-1, May Contain: Titanium Dioxide (CI 77891), Iron Oxides (CI 77491, CI 77492, CI 77499), Lake Pigments (CI 47005:1, CI 15850:1, CI 45410:2, CI 14700:1, CI 15880:1, CI 12085). |
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 |
3.5 |
0 |
|
N |
| 132 |
0 |
T |
129 |
Y |
N |
N |
Height |
Height |
en |
|
cm |
|
|
A |
N |
0 |
describe_product |
text |
|
|
1668421469 |
1668661754 |
0 |
2.5 |
0 |
|
N |
| 130 |
13 |
T |
129 |
Y |
N |
N |
Length |
Length |
en |
|
cm |
|
|
A |
N |
0 |
describe_product |
text |
|
|
1668421426 |
1668661773 |
0 |
3.5 |
0 |
|
N |