Query time 0.00121
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "357.19"
},
"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": 123,
"rows_produced_per_join": 123,
"filtered": "100.00",
"index_condition": "(`ea201_diorama`.`cscart_products_categories`.`product_id` in (40652,38641,32098,35420,36320,36972,36974,36981,36984,36985,36989,36990,36992,37020,37028,37048,37057,37058,37059,37090,37091,37093,37094,37104,37115,37140,37170,37696,37729,34751))",
"cost_info": {
"read_cost": "177.61",
"eval_cost": "24.60",
"prefix_cost": "202.21",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
]
}
},
{
"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": 6,
"filtered": "5.00",
"cost_info": {
"read_cost": "123.00",
"eval_cost": "1.23",
"prefix_cost": "349.81",
"data_read_per_join": "16K"
},
"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')))"
}
},
{
"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": 6,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.15",
"eval_cost": "1.23",
"prefix_cost": "357.19",
"data_read_per_join": "98"
},
"used_columns": [
"product_id",
"category_id",
"position"
]
}
}
]
}
}
}
Result
product_id |
category_ids |
position |
32098 |
185,494M |
0 |
34751 |
193,190,168,185,191,165,494M |
0 |
35420 |
185,227,494M |
0 |
36320 |
667,660,661,634M |
|
36972 |
185,677,640M |
0 |
36974 |
185,677,640M |
0 |
36981 |
185,634,677,640M |
0 |
36984 |
677,185,640M |
0 |
36985 |
677,185,640M |
0 |
36989 |
677,185,640M |
0 |
36990 |
185,677,640M |
0 |
36992 |
677,185,640M |
0 |
37020 |
185,394,543,643M |
0 |
37028 |
185,643,543,394M |
0 |
37048 |
643,543,706,394M |
|
37057 |
185,643,543,394M |
0 |
37058 |
643,543,185,706,394M |
0 |
37059 |
185,643,543,394M |
0 |
37090 |
643,543,185,706,394M |
0 |
37091 |
185,643,543,394M |
0 |
37093 |
643,543,185,394M |
0 |
37094 |
643,543,185,706,394M |
0 |
37104 |
185,643,543,394M |
0 |
37115 |
185,643,543,394M |
0 |
37140 |
543,394,185,706,643M |
0 |
37170 |
644,185,706,496M |
0 |
37696 |
185,494M |
0 |
37729 |
185,495M |
0 |
38641 |
495,706,185M |
0 |
40652 |
227,494,212M |
|