{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "175.98"
},
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "17.07"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 115,
"rows_produced_per_join": 2,
"filtered": "2.00",
"cost_info": {
"read_cost": "27.56",
"eval_cost": "0.46",
"prefix_cost": "28.02",
"data_read_per_join": "6K"
},
"used_columns": [
"category_id",
"company_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`eshopuga_upgr_4122`.`cscart_categories`.`company_id` = 1) and ((`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`eshopuga_upgr_4122`.`cscart_categories`.`usergroup_ids`)) and (`eshopuga_upgr_4122`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"eshopuga_upgr_4122.cscart_categories.category_id"
],
"rows_examined_per_scan": 40,
"rows_produced_per_join": 17,
"filtered": "18.55",
"index_condition": "(`eshopuga_upgr_4122`.`cscart_products_categories`.`product_id` in (421,427,408,382,418,1930,400,424,1931,381,1529,1465,428,415,391,406,329,439,390,393,394,396,397,398))",
"cost_info": {
"read_cost": "92.00",
"eval_cost": "3.41",
"prefix_cost": "138.42",
"data_read_per_join": "273"
},
"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",
"eshopuga_upgr_4122.cscart_products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 17,
"filtered": "100.00",
"cost_info": {
"read_cost": "17.07",
"eval_cost": "3.41",
"prefix_cost": "158.91",
"data_read_per_join": "273"
},
"used_columns": [
"product_id",
"category_id",
"position"
]
}
}
]
}
}
}
product_id | category_ids | position |
---|---|---|
329 | 369,338,377,372,371,375,370,374,352,378,373,355,357,349M,353,342,351,339,354,358,350,356,376 | 0 |
381 | 341,380,356,376,361,345,343,338,372,383,371,381,375,370,379,374,352,378,373,344,340,360,355,386,357,384,349,363,353,342,351,347,337M,339,362,354,385,358,350,359,382 | 0 |
382 | 354,385,358,350,382,341,369,356,377,376,345,343,338,372,383,371,381,375,370,379,374,352,378,373,344,340,355,386,357,384,349,353,342,351,347,337M,339 | 0 |
390 | 362,351,347,368,337M,339,359,354,358,392,350,361,341,393,356,390,394,345,343,338,395,360,352,344,363,340,355,357,391,349,388,353,342,396 | 0 |
391 | 349,353,342,351,347,337M,339,354,358,350,341,356,345,343,338,352,344,340,355,357 | 0 |
393 | 344,340,355,357,349,380,385,353,342,382,351,369,347,377,337M,376,339,354,358,372,383,350,371,381,375,370,379,341,374,356,378,373,345,343,386,384,338,352 | 0 |
394 | 352,344,340,355,357,349,380,385,353,342,382,351,369,347,377,337M,376,339,354,358,372,383,350,371,381,375,370,379,341,374,356,378,373,345,343,386,384,338 | 0 |
396 | 345,343,338,352,344,340,355,357,349,353,342,351,369,347,377,337M,376,339,354,358,372,350,371,375,370,341,374,356,378,373 | 0 |
397 | 358,350,341,356,345,343,338,352,344,340,355,357,349,353,342,351,347,337M,339,354 | 0 |
398 | 388,337M,339,396,354,362,358,350,368,341,389,359,356,345,343,392,361,338,393,390,394,352,344,340,395,355,360,357,349,353,342,363,351,347,391 | 0 |
400 | 353,342,351,347,337M,339,354,358,350,341,356,345,343,338,352,344,340,355,357,349 | 0 |
406 | 355,363,357,349,391,353,342,388,396,351,347,362,337M,368,339,354,359,358,350,392,341,361,356,393,345,343,390,394,338,395,360,352,344,340 | 0 |
408 | 372,371,352,375,370,386,344,374,384,340,378,373,355,357,349,353,342,351,347,380,337M,385,339,354,382,358,350,341,356,369,345,343,377,383,376,381,338,379 | 0 |
415 | 345,343,338,352,344,340,355,357,349,353,342,351,337M,339,354,358,350,341,356 | 0 |
418 | 377,341,376,356,345,343,372,363,371,338,375,370,374,378,373,352,344,340,355,357,349,353,342,351,337M,339,354,358,369,350 | 0 |
421 | 339,360,354,358,350,341,356,391,345,343,388,363,338,396,362,368,352,344,340,359,355,357,392,349,361,353,342,393,351,390,394,337M,395 | 0 |
424 | 351,337M,339,354,358,350,341,356,345,343,338,347,352,344,340,355,357,349,353,342 | 0 |
427 | 383,349,381,379,353,342,369,377,351,376,386,384,337M,339,372,354,371,375,370,358,374,350,378,373,341,356,345,343,380,385,338,347,382,352,344,340,355,357 | 0 |
428 | 352,344,390,394,340,355,357,395,349,360,353,342,351,337M,391,339,388,363,354,396,358,350,362,341,368,356,359,345,343,338,392,361,347,393 | 0 |
439 | 338,361,352,383,344,381,340,379,355,369,357,377,349,360,376,386,353,342,384,372,351,371,375,370,374,337M,378,373,339,363,354,358,350,362,341,368,385,359,382,345,343 | 0 |
1465 | 392,347,359,382,345,343,393,338,390,394,361M,395,352,383,344,381,340,379,355,369,357,377,349,360,376,386,353,342,384,391,372,388,351,371,375,370,396,374,337,378,373,339,380,363,354,356,358,350,362,341,368,385 | 0 |
1529 | 356,358,350,362,341,368,385,392,347,359,345,343,393,338,390,394,361,395,352,344,381,340,379,355,369,357,377,349M,360,376,386,353,342,384,391,372,388,351,371,375,370,396,374,337,378,373,339,380,363,354 | 0 |
1930 | 375,337,339,363,354,356,350,362,341,359,345,338,390,361M,395,352,381,340,379,355,369,377,349,376,353,391,388,351 | 0 |
1931 | 396,353,374,391,380,388,337,339,363,385,350,362,359,345,338,390,361M,395,360,381,340,379,342,369,372,349,376,371 | 0 |