{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "70.71"
},
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"rows_examined_per_scan": 101,
"rows_produced_per_join": 101,
"filtered": "100.00",
"index_condition": "((`cscartdb`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`cscartdb`.`cscart_product_review_prepared_data`.`product_id` in (36394,36411,36396,36462,36398,36410,36405,36490,36477,36434,36460,36403,36399,36422,36397,36419,36487,36491,36471,36409,36404,36423,36414,36408,36412,36439,36406,36469,36415,36413,36428,36402,36443,36417,36427,36416,36448,36426,36453,36467,36457,36437,36421,36461,36463,36407,36436,36420,36401,36447,36430,36438,36485,36435,36459,36451,36492,36449,36458,36486,36441,36472,36446,36424,36425,36454,36481,36483,36464,36475,36482,36473,36493,36444,36479,36445,36431,36456,36470,36466,36474,36478,36440,36452,36465,36442,36450,36433,36484,36418,36429,36432,36400,36476,36395,36488,36494,36455,36480,36489,36468)))",
"cost_info": {
"read_cost": "60.61",
"eval_cost": "10.10",
"prefix_cost": "70.71",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
}
product_id | average_rating | reviews_count |
---|---|---|
36394 | 0 | |
36396 | 0 | |
36397 | 0 | |
36398 | 0 | |
36399 | 0 | |
36400 | 0 | |
36401 | 0 | |
36402 | 0 | |
36403 | 0 | |
36404 | 0 | |
36405 | 0 | |
36406 | 0 | |
36408 | 0 | |
36409 | 0 | |
36410 | 0 | |
36411 | 0 | |
36412 | 0 | |
36413 | 0 | |
36414 | 0 | |
36415 | 0 | |
36416 | 0 | |
36417 | 0 | |
36418 | 0 | |
36419 | 0 | |
36420 | 0 | |
36421 | 0 | |
36422 | 0 | |
36423 | 0 | |
36425 | 0 | |
36426 | 0 | |
36427 | 0 | |
36428 | 0 | |
36429 | 0 | |
36430 | 0 | |
36431 | 0 | |
36434 | 0 | |
36435 | 0 | |
36436 | 0 | |
36437 | 0 | |
36438 | 0 | |
36439 | 0 | |
36440 | 0 | |
36441 | 0 | |
36443 | 0 | |
36446 | 0 | |
36447 | 0 | |
36448 | 0 | |
36449 | 0 | |
36450 | 0 | |
36451 | 0 | |
36453 | 0 | |
36454 | 0 | |
36455 | 0 | |
36457 | 0 | |
36458 | 0 | |
36459 | 0 | |
36460 | 0 | |
36461 | 0 | |
36462 | 0 | |
36463 | 0 | |
36464 | 0 | |
36465 | 0 | |
36466 | 0 | |
36467 | 0 | |
36469 | 0 | |
36471 | 0 | |
36472 | 0 | |
36473 | 0 | |
36474 | 0 | |
36475 | 0 | |
36476 | 0 | |
36478 | 0 | |
36482 | 0 | |
36483 | 0 | |
36485 | 0 | |
36486 | 0 | |
36487 | 0 | |
36488 | 0 | |
36490 | 0 | |
36491 | 0 | |
36492 | 0 |