{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2.86"
},
"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",
"fl",
"lang_code",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 6,
"rows_produced_per_join": 1,
"filtered": "32.25",
"index_condition": "(`aomnia_com`.`cscart_product_features_values`.`lang_code` = 'en')",
"cost_info": {
"read_cost": "1.50",
"eval_cost": "0.19",
"prefix_cost": "2.10",
"data_read_per_join": "1K"
},
"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": [
"aomnia_com.cscart_product_features_values.feature_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.73",
"cost_info": {
"read_cost": "0.48",
"eval_cost": "0.02",
"prefix_cost": "2.78",
"data_read_per_join": "74"
},
"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",
"status",
"position",
"comparison",
"timestamp",
"updated_timestamp"
],
"attached_condition": "((`aomnia_com`.`pf`.`feature_type` <> 'G') and (`aomnia_com`.`pf`.`status` = 'A') and (`aomnia_com`.`pf`.`company_id` in (0,3)) and (`aomnia_com`.`pf`.`display_on_product` = 'Y') and ((`aomnia_com`.`pf`.`categories_path` = '') or (`aomnia_com`.`pf`.`categories_path` is null) or (0 <> find_in_set(267,`aomnia_com`.`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": [
"aomnia_com.pf.parent_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "19.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.00",
"prefix_cost": "2.84",
"data_read_per_join": "14"
},
"used_columns": [
"feature_id",
"status",
"position"
],
"attached_condition": "<if>(found_match(pf_groups), ((`aomnia_com`.`pf_groups`.`status` = 'A') or (`aomnia_com`.`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": [
"aomnia_com.pf.parent_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.01",
"eval_cost": "0.00",
"prefix_cost": "2.85",
"data_read_per_join": "74"
},
"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": [
"aomnia_com.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.01",
"eval_cost": "0.00",
"prefix_cost": "2.86",
"data_read_per_join": "74"
},
"used_columns": [
"feature_id",
"description",
"internal_name",
"full_description",
"prefix",
"suffix",
"lang_code"
]
}
}
]
}
}
}
}| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 559 | 3 | S | 0 | Y | Y | N | Baby Clothing Sizes | Baby Clothing Sizes | en | 267 | A | N | 0 | group_variation_catalog_item | dropdown | checkbox | 1672676594 | 1677436387 | 1254 | |||||||
| 549 | 0 | S | 0 | Y | Y | N | Color | Color | en | 165,166,167,168,169,170,174,190,191,193,196,197,198,199,203,204,209,215,216,223,224,234,250,267,270,271,275,276,277,280,281,292,297,298,299,301,302,304,305,309,310,315,316,317,318,320,321,322,323,324,325,326,328,333,334,337,331,338,339,340,341,343,350,351,353,356,358,360,361,362,363,364,359,365,366,367,368,369,370,371,472,473,474,475,476,477,478,479,480,481,373,469,470,471,228,374,460,461,462,463,464,465,466,467,468,241,442,443,278,413,414,415,416,408,409,410,411,412,375,376,377,380,381,382,384,385,394,395,396,397,399,400,401,402,403,404,405,406,407,484,485,486,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,266,428,429,430,431,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,718,719,720,721,722,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,804,805,806,807,808,896,897,898,899,900,909,910,911,921,922,923,924,925,926,927,928,929,930,931,932,933,935,941,942,943,944,945,946,947,949,950,951,952,953,954,955,957,958,1065,1066,1067,1068,1069,1070,1071,1072,1073,1127,1128,1129,1130,1131,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050 | A | Y | 10 | group_catalog_item | dropdown_images | checkbox | 0 | 1765400243 | 1199 |