Query time 0.00181
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "562.01"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 140,
"rows_produced_per_join": 140,
"filtered": "100.00",
"index_condition": "(`ea201_diorama`.`cscart_products_categories`.`product_id` in (34835,37789,39361,34820,40466,40398,40351,38316,39325,40308,39613,38314,37788,36045,39878,39611,39354,39353,39299,39300,39268,38317,39137,39138,39139,39058,38994,39313,37790,38179))",
"cost_info": {
"read_cost": "198.01",
"eval_cost": "28.00",
"prefix_cost": "226.01",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
]
}
},
{
"table": {
"table_name": "product_position_source",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"ea201_diorama.cscart_products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 140,
"filtered": "100.00",
"cost_info": {
"read_cost": "140.00",
"eval_cost": "28.00",
"prefix_cost": "394.01",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"category_id",
"position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"ea201_diorama.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 7,
"filtered": "5.00",
"cost_info": {
"read_cost": "140.00",
"eval_cost": "1.40",
"prefix_cost": "562.01",
"data_read_per_join": "18K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`ea201_diorama`.`cscart_categories`.`storefront_id` in (0,1)) and ((`ea201_diorama`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`ea201_diorama`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`ea201_diorama`.`cscart_categories`.`usergroup_ids`)) and (`ea201_diorama`.`cscart_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
Result
product_id |
category_ids |
position |
34820 |
347,226,177,390M |
0 |
34835 |
226M |
3 |
36045 |
310,226M |
0 |
37788 |
347,226,177,390M |
0 |
37789 |
347,226,177,390M |
0 |
37790 |
347,226,177,390M |
0 |
38179 |
347,226,177,390M |
0 |
38314 |
228,226M |
0 |
38316 |
311,226,203M |
0 |
38317 |
311,226,203M |
0 |
38994 |
307,226,203M |
0 |
39058 |
687,226,264,269,311,203M |
0 |
39137 |
311,226,203M |
0 |
39138 |
311,226,203M |
0 |
39139 |
311,226,203M |
0 |
39268 |
203,311,226,214M |
0 |
39299 |
226M |
0 |
39300 |
226M |
0 |
39313 |
311,226,203M |
0 |
39325 |
264,269,228,226,390M |
0 |
39353 |
184,226,403,390,394,228M |
0 |
39354 |
184,226,403,390,394,228M |
0 |
39361 |
203,311,228,226M |
0 |
39611 |
556,555,554,390,264,214,209,199,196,194,706,226M |
0 |
39613 |
228,199,194,177,226M |
0 |
39878 |
269,226,404,177M |
0 |
40308 |
216,228,199,226M |
0 |
40351 |
203,226M |
0 |
40398 |
310,226,203M |
0 |
40466 |
226,228,269M |
0 |