Query time 0.00129
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.55"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "system",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "448"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
]
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "index",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"rows_examined_per_scan": 436,
"rows_produced_per_join": 96,
"filtered": "22.02",
"cost_info": {
"read_cost": "34.95",
"eval_cost": "9.60",
"prefix_cost": "44.55",
"data_read_per_join": "2K"
},
"used_columns": [
"thread_id",
"object_id",
"object_type",
"type"
],
"attached_condition": "((`betaatif_store`.`cscart_discussion`.`object_id` in (846,845,844,832,829,828,822,817,816,662,814,806,805,804,803,802,801,800,799,798,797,796,795,792,787,786,782,819,781,765,764,763,762,760,758,752,751,750,749,747,744,743,742,741,732,731,727,725,724,723,809,810,720,718,717,716,715,713,709,708,707,705,701,697,696,695,693,682,676,673,671,670,664,663,658,657,656,651,650,647,645,644,641,639,636,624,622,620,619,618,616,615,608,607,600,377)) and (`betaatif_store`.`cscart_discussion`.`object_type` = 'P'))"
}
}
]
}
}
}
Result
product_id |
average_rating |
discussion_type |
discussion_thread_id |
377 |
|
D |
365 |
600 |
|
D |
419 |
607 |
|
D |
426 |
608 |
|
D |
427 |
615 |
|
D |
434 |
616 |
|
D |
435 |
618 |
|
D |
437 |
619 |
|
D |
438 |
620 |
|
D |
439 |
622 |
|
D |
441 |
624 |
|
D |
443 |
636 |
|
D |
455 |
639 |
|
D |
458 |
641 |
|
D |
460 |
644 |
|
D |
463 |
645 |
|
D |
464 |
647 |
|
D |
466 |
650 |
|
D |
469 |
651 |
|
D |
470 |
656 |
|
D |
475 |
657 |
|
D |
476 |
658 |
|
D |
477 |
662 |
|
D |
481 |
663 |
|
D |
482 |
664 |
|
D |
483 |
670 |
|
D |
489 |
671 |
|
D |
490 |
673 |
|
D |
492 |
676 |
|
D |
495 |
682 |
|
D |
501 |
693 |
|
D |
512 |
695 |
|
D |
514 |
696 |
|
D |
515 |
697 |
|
D |
516 |
701 |
|
D |
520 |
705 |
|
D |
529 |
707 |
|
D |
531 |
708 |
|
D |
532 |
709 |
|
D |
533 |
713 |
|
D |
537 |
715 |
|
D |
539 |
716 |
|
D |
540 |
717 |
|
D |
541 |
718 |
|
D |
542 |
720 |
|
D |
545 |
723 |
|
D |
549 |
724 |
|
D |
550 |
725 |
|
D |
551 |
727 |
|
D |
553 |
731 |
|
D |
557 |
732 |
|
D |
558 |
741 |
|
D |
567 |
742 |
|
D |
568 |
743 |
|
D |
569 |
744 |
|
D |
570 |
747 |
|
D |
573 |
749 |
|
D |
575 |
750 |
|
D |
576 |
751 |
|
D |
577 |
752 |
|
D |
578 |
758 |
|
D |
584 |
760 |
|
D |
586 |
762 |
|
D |
588 |
763 |
|
D |
589 |
764 |
|
D |
590 |
765 |
|
D |
591 |
781 |
|
D |
607 |
782 |
|
D |
608 |
786 |
|
D |
612 |
787 |
|
D |
613 |
792 |
|
D |
618 |
795 |
|
D |
621 |
796 |
|
D |
622 |
797 |
|
D |
623 |
798 |
|
D |
624 |
799 |
|
D |
625 |
800 |
|
D |
626 |
801 |
|
D |
627 |
802 |
|
D |
628 |
803 |
|
D |
629 |
804 |
|
D |
630 |
805 |
|
D |
631 |
806 |
|
D |
632 |
809 |
|
D |
635 |
810 |
|
D |
636 |
814 |
|
D |
640 |
816 |
|
D |
642 |
817 |
|
D |
643 |
819 |
|
D |
645 |
822 |
|
D |
648 |
828 |
|
D |
654 |
829 |
|
D |
655 |
832 |
|
D |
658 |
844 |
|
D |
670 |
845 |
|
D |
671 |
846 |
|
D |
672 |