Query time 0.00219
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "281.15"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"link_type",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 100,
"rows_produced_per_join": 100,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "21.15",
"eval_cost": "20.00",
"prefix_cost": "41.15",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"category_id",
"link_type"
],
"attached_condition": "(`webmarco`.`cscart_products_categories`.`product_id` in (431129,431338,431423,431439,430656,430947,430993,431051,339782,430722,430723,430778,430816,430856,430984,431074,339718,339675,430688,430702,431005,431165,431247,430627,431007,431027,431184,339604,430720,430742,430805,430839,430878,430933,430994,431022,430991,431177,431357,430917,430990,431019,431108,431264,430826,430889,430918,431275,431297,431426,430690,430791,430840,430872,430940,430652,430790,430835,430897,430977,431342,430674,430804,430828,430886,430979,431220,431358,431501,430958,430960,430968,431138,430871,430931,430952,431006,431345,431428,339597,430780,430786,430969,431288,431467,430715,430770,430894,430953,430972,431336,431451,339846,387050,431037,431262,431395,430666,430692,430726))"
}
},
{
"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",
"webmarco.cscart_products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "100.00",
"eval_cost": "20.00",
"prefix_cost": "161.15",
"data_read_per_join": "1K"
},
"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": [
"webmarco.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "5.00",
"cost_info": {
"read_cost": "100.00",
"eval_cost": "1.00",
"prefix_cost": "281.15",
"data_read_per_join": "29K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`webmarco`.`cscart_categories`.`storefront_id` in (0,1)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')))"
}
}
]
}
}
}
Result
product_id |
category_ids |
position |
339597 |
395M |
|
339604 |
395M |
|
339675 |
395M |
|
339718 |
395M |
|
339782 |
395M |
|
339846 |
395M |
|
387050 |
2578M |
|
430627 |
2601M |
|
430652 |
2601M |
|
430656 |
2601M |
|
430666 |
2601M |
|
430674 |
2601M |
|
430688 |
2601M |
|
430690 |
2601M |
|
430692 |
2601M |
|
430702 |
2601M |
|
430715 |
2601M |
|
430720 |
2601M |
|
430722 |
2601M |
|
430723 |
2601M |
|
430726 |
2601M |
|
430742 |
2601M |
|
430770 |
2601M |
|
430778 |
2601M |
|
430780 |
2601M |
|
430786 |
2601M |
|
430790 |
2601M |
|
430791 |
2601M |
|
430804 |
2601M |
|
430805 |
2601M |
|
430816 |
2601M |
|
430826 |
2601M |
|
430828 |
2601M |
|
430835 |
2601M |
|
430839 |
2601M |
|
430840 |
2601M |
|
430856 |
2601M |
|
430871 |
2601M |
|
430872 |
2601M |
|
430878 |
2601M |
|
430886 |
2601M |
|
430889 |
2601M |
|
430894 |
2601M |
|
430897 |
2601M |
|
430917 |
2601M |
|
430918 |
2601M |
|
430931 |
2601M |
|
430933 |
2601M |
|
430940 |
2601M |
|
430947 |
2601M |
|
430952 |
2601M |
|
430953 |
2601M |
|
430958 |
2601M |
|
430960 |
2601M |
|
430968 |
2601M |
|
430969 |
2601M |
|
430972 |
2601M |
|
430977 |
2601M |
|
430979 |
2601M |
|
430984 |
2601M |
|
430990 |
2601M |
|
430991 |
2601M |
|
430993 |
2601M |
|
430994 |
2601M |
|
431005 |
2601M |
|
431006 |
2601M |
|
431007 |
2601M |
|
431019 |
2601M |
|
431022 |
2601M |
|
431027 |
2601M |
|
431037 |
2601M |
|
431051 |
2601M |
|
431074 |
2601M |
|
431108 |
2601M |
|
431129 |
2601M |
|
431138 |
2601M |
|
431165 |
2601M |
|
431177 |
2601M |
|
431184 |
2601M |
|
431220 |
2601M |
|
431247 |
2601M |
|
431262 |
2601M |
|
431264 |
2601M |
|
431275 |
2601M |
|
431288 |
2601M |
|
431297 |
2601M |
|
431336 |
2601M |
|
431338 |
2601M |
|
431342 |
2601M |
|
431345 |
2601M |
|
431357 |
2601M |
|
431358 |
2601M |
|
431395 |
2601M |
|
431423 |
2601M |
|
431426 |
2601M |
|
431428 |
2601M |
|
431439 |
2601M |
|
431451 |
2601M |
|
431467 |
2601M |
|
431501 |
2601M |
|