{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "274.41"
},
"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": 392,
"rows_produced_per_join": 392,
"filtered": "100.00",
"index_condition": "((`chocoramo`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`chocoramo`.`cscart_product_review_prepared_data`.`product_id` in (69657,66613,66677,64871,66508,67004,69641,64895,69766,69574,65454,65777,65893,65160,65063,65831,66637,66500,64975,65822,67836,65540,65721,66086,67788,66150,67812,65801,66708,64634,69789,65970,69701,64872,65979,64815,65040,69693,66246,66380,69220,69195,69244,69228,69813,69725,69624,65508,68371,65103,69333,67203,65500,68387,67252,66492,65953,67235,67926,66676,69757,65087,69749,65023,65390,65319,65809,68714,69829,67155,66656,66420,64692,69268,67872,65302,67283,67028,64535,64751,67828,66629,67396,64543,64855,65961,67953,65479,65785,67123,67107,67853,65463,64651,67339,66598,64807,67804,67091,65713,65492,66302,67299,69869,66254,69566,66580,64676,69550,69349,65564,69292,67251,68135,66564,69400,69741,64511,67267,65745,67764,67934,67115,68411,66310,65358,66532,65143,69781,65934,64935,65271,64567,68866,65334,65793,65471,67388,69861,65422,69616,66657,69341,65516,69590,67888,69733,64735,64919,67748,66190,66198,69236,66436,67163,67380,69558,69373,64959,65367,68331,68781,65532,69316,64700,69276,69357,66460,68339,67347,69365,69845,64727,64791,65769,66094,69717,69709,69821,66372,65697,65729,64527,68355,64660,68181,67372,64783,67219,68403,66428,66262,66476,67331,64519,68478,66078,65263,67044,64775,67796,65524,67880,64551,65207,66356,67756,65199,69284,65151,67099,66444,65279,65572,66540,67012,64743,67307,65159,67315,69381,67147,67275,67060,64863,65015,66158,67227,66405,64831,66206,65031,64847,66988,67131,69853,66102,66222,65239,68363,68395,67179,69260,64839,68626,64642,66980,67052,68938,67291,67243,66524,69649,68161,69773,66700,67404,65120,67364,67076,66445,65978,69837,65548,64823,66278,66316,64999,67918,66126,66348,65007,65111,66230,64708,68379,67068,64576,67171,64759,69633,66270,67187,67772,64936,65556,65366,65064,66166,67323,65039,65342,66110,66182,69084,64668,66142,65310,66996,64991,64799,64903,65247,69805,66597,67211,64559,66317,65095,65318,67820,66294,65382,64927,66516,64767,66484,68090,69308,66134,66238,68072,67139,69300,65055,66332,66118,65406,66556,65737,67355,69582,65135,66396,65842,64719,66692,66727,69203,66468,67020,67036,65231,67195,67780,64887,66548,64911,64976,68323,65223,66340,65398,65119,66357,65183,65350,64684,65407,69252,66174,69389,69211,65753,64951,69598,66404,69009,65175,65856,66388,66621,65255,65215,69187,65191,64967,69324,67363,68347,65430,65079,65287,66572,65705,66279,65761,65580,69606,65446,65438,66214)))",
"cost_info": {
"read_cost": "235.21",
"eval_cost": "39.20",
"prefix_cost": "274.41",
"data_read_per_join": "6K"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
}
product_id | average_rating | reviews_count |
---|---|---|
64511 | 0 | |
64519 | 0 | |
64527 | 0 | |
64535 | 0 | |
64543 | 0 | |
64551 | 0 | |
64559 | 0 | |
64567 | 0 | |
64576 | 0 | |
64634 | 0 | |
64642 | 0 | |
64651 | 0 | |
64660 | 0 | |
64668 | 0 | |
64676 | 0 | |
64684 | 0 | |
64692 | 0 | |
64700 | 0 | |
64708 | 0 | |
64719 | 0 | |
64727 | 0 | |
64735 | 0 | |
64743 | 0 | |
64751 | 0 | |
64759 | 0 | |
64767 | 0 | |
64775 | 0 | |
64783 | 0 | |
64791 | 0 | |
64799 | 0 | |
64807 | 0 | |
64815 | 0 | |
64823 | 0 | |
64831 | 0 | |
64839 | 0 | |
64847 | 0 | |
64855 | 0 | |
64863 | 0 | |
64871 | 0 | |
64872 | 0 | |
64887 | 0 | |
64895 | 0 | |
64903 | 0 | |
64911 | 0 | |
64919 | 0 | |
64927 | 0 | |
64935 | 0 | |
64936 | 0 | |
64951 | 0 | |
64959 | 0 | |
64967 | 0 | |
64975 | 0 | |
64976 | 0 | |
64991 | 0 | |
64999 | 0 | |
65007 | 0 | |
65015 | 0 | |
65023 | 0 | |
65031 | 0 | |
65039 | 0 | |
65040 | 0 | |
65055 | 0 | |
65063 | 0 | |
65064 | 0 | |
65079 | 0 | |
65087 | 0 | |
65095 | 0 | |
65103 | 0 | |
65111 | 0 | |
65119 | 0 | |
65120 | 0 | |
65135 | 0 | |
65143 | 0 | |
65151 | 0 | |
65159 | 0 | |
65160 | 0 | |
65175 | 0 | |
65183 | 0 | |
65191 | 0 | |
65199 | 0 | |
65207 | 0 | |
65215 | 0 | |
65223 | 0 | |
65231 | 0 | |
65239 | 0 | |
65247 | 0 | |
65255 | 0 | |
65263 | 0 | |
65271 | 0 | |
65279 | 0 | |
65287 | 0 | |
65302 | 0 | |
65310 | 0 | |
65318 | 0 | |
65319 | 0 | |
65334 | 0 | |
65342 | 0 | |
65350 | 0 | |
65358 | 0 | |
65366 | 0 | |
65367 | 0 | |
65382 | 0 | |
65390 | 0 | |
65398 | 0 | |
65406 | 0 | |
65407 | 0 | |
65422 | 0 | |
65430 | 0 | |
65438 | 0 | |
65446 | 0 | |
65454 | 0 | |
65463 | 0 | |
65471 | 0 | |
65479 | 0 | |
65492 | 0 | |
65500 | 0 | |
65508 | 0 | |
65516 | 0 | |
65524 | 0 | |
65532 | 0 | |
65540 | 0 | |
65548 | 0 | |
65556 | 0 | |
65564 | 0 | |
65572 | 0 | |
65580 | 0 | |
65697 | 0 | |
65705 | 0 | |
65713 | 0 | |
65721 | 0 | |
65729 | 0 | |
65737 | 0 | |
65745 | 0 | |
65753 | 0 | |
65761 | 0 | |
65769 | 0 | |
65777 | 0 | |
65785 | 0 | |
65793 | 0 | |
65801 | 0 | |
65809 | 0 | |
65822 | 0 | |
65831 | 0 | |
65842 | 0 | |
65856 | 0 | |
65893 | 0 | |
65934 | 0 | |
65953 | 0 | |
65961 | 0 | |
65970 | 0 | |
65978 | 0 | |
65979 | 0 | |
66078 | 0 | |
66086 | 0 | |
66094 | 0 | |
66102 | 0 | |
66110 | 0 | |
66118 | 0 | |
66126 | 0 | |
66134 | 0 | |
66142 | 0 | |
66150 | 0 | |
66158 | 0 | |
66166 | 0 | |
66174 | 0 | |
66182 | 0 | |
66190 | 0 | |
66198 | 0 | |
66206 | 0 | |
66214 | 0 | |
66222 | 0 | |
66230 | 0 | |
66238 | 0 | |
66246 | 0 | |
66254 | 0 | |
66262 | 0 | |
66270 | 0 | |
66278 | 0 | |
66279 | 0 | |
66294 | 0 | |
66302 | 0 | |
66310 | 0 | |
66316 | 0 | |
66317 | 0 | |
66332 | 0 | |
66340 | 0 | |
66348 | 0 | |
66356 | 0 | |
66357 | 0 | |
66372 | 0 | |
66380 | 0 | |
66388 | 0 | |
66396 | 0 | |
66404 | 0 | |
66405 | 0 | |
66420 | 0 | |
66428 | 0 | |
66436 | 0 | |
66444 | 0 | |
66445 | 0 | |
66460 | 0 | |
66468 | 0 | |
66476 | 0 | |
66484 | 0 | |
66492 | 0 | |
66500 | 0 | |
66508 | 0 | |
66516 | 0 | |
66524 | 0 | |
66532 | 0 | |
66540 | 0 | |
66548 | 0 | |
66556 | 0 | |
66564 | 0 | |
66572 | 0 | |
66580 | 0 | |
66597 | 0 | |
66598 | 0 | |
66613 | 0 | |
66621 | 0 | |
66629 | 0 | |
66637 | 0 | |
66656 | 0 | |
66657 | 0 | |
66676 | 0 | |
66677 | 0 | |
66692 | 0 | |
66700 | 0 | |
66708 | 0 | |
66727 | 0 | |
66980 | 0 | |
66988 | 0 | |
66996 | 0 | |
67004 | 0 | |
67012 | 0 | |
67020 | 0 | |
67028 | 0 | |
67036 | 0 | |
67044 | 0 | |
67052 | 0 | |
67060 | 0 | |
67068 | 0 | |
67076 | 0 | |
67091 | 0 | |
67099 | 0 | |
67107 | 0 | |
67115 | 0 | |
67123 | 0 | |
67131 | 0 | |
67139 | 0 | |
67147 | 0 | |
67155 | 0 | |
67163 | 0 | |
67171 | 0 | |
67179 | 0 | |
67187 | 0 | |
67195 | 0 | |
67203 | 0 | |
67211 | 0 | |
67219 | 0 | |
67227 | 0 | |
67235 | 0 | |
67243 | 0 | |
67251 | 0 | |
67252 | 0 | |
67267 | 0 | |
67275 | 0 | |
67283 | 0 | |
67291 | 0 | |
67299 | 0 | |
67307 | 0 | |
67315 | 0 | |
67323 | 0 | |
67331 | 0 | |
67339 | 0 | |
67347 | 0 | |
67355 | 0 | |
67364 | 0 | |
67372 | 0 | |
67380 | 0 | |
67388 | 0 | |
67396 | 0 | |
67404 | 0 | |
67748 | 0 | |
67756 | 0 | |
67764 | 0 | |
67772 | 0 | |
67780 | 0 | |
67788 | 0 | |
67796 | 0 | |
67804 | 0 | |
67812 | 0 | |
67820 | 0 | |
67828 | 0 | |
67836 | 0 | |
67853 | 0 | |
67872 | 0 | |
67880 | 0 | |
67888 | 0 | |
67918 | 0 | |
67926 | 0 | |
67934 | 0 | |
67953 | 0 | |
68072 | 0 | |
68090 | 0 | |
68135 | 0 | |
68161 | 0 | |
68181 | 0 | |
68323 | 0 | |
68331 | 0 | |
68339 | 0 | |
68347 | 0 | |
68355 | 0 | |
68363 | 0 | |
68371 | 0 | |
68379 | 0 | |
68387 | 0 | |
68395 | 0 | |
68403 | 0 | |
68411 | 0 | |
68478 | 0 | |
68626 | 0 | |
68714 | 0 | |
68781 | 0 | |
68866 | 0 | |
68938 | 0 | |
69009 | 0 | |
69084 | 0 | |
69187 | 0 | |
69195 | 0 | |
69203 | 0 | |
69211 | 0 | |
69220 | 0 | |
69228 | 0 | |
69236 | 0 | |
69244 | 0 | |
69252 | 0 | |
69260 | 0 | |
69268 | 0 | |
69276 | 0 | |
69284 | 0 | |
69292 | 0 | |
69300 | 0 | |
69308 | 0 | |
69316 | 0 | |
69324 | 0 | |
69333 | 0 | |
69341 | 0 | |
69349 | 0 | |
69357 | 0 | |
69365 | 0 | |
69373 | 0 | |
69381 | 0 | |
69389 | 0 | |
69400 | 0 | |
69550 | 0 | |
69558 | 0 | |
69566 | 0 | |
69574 | 0 | |
69582 | 0 | |
69590 | 0 | |
69598 | 0 | |
69606 | 0 | |
69616 | 0 | |
69624 | 0 | |
69633 | 0 | |
69641 | 0 | |
69649 | 0 | |
69657 | 0 | |
69693 | 0 | |
69701 | 0 | |
69709 | 0 | |
69717 | 0 | |
69725 | 0 | |
69733 | 0 | |
69741 | 0 | |
69749 | 0 | |
69757 | 0 | |
69766 | 0 | |
69773 | 0 | |
69781 | 0 | |
69789 | 0 | |
69805 | 0 | |
69813 | 0 | |
69821 | 0 | |
69829 | 0 | |
69837 | 0 | |
69845 | 0 | |
69853 | 0 | |
69861 | 0 | |
69869 | 0 |