SELECT 
  parent_option_id, 
  child_option_id, 
  parent_variant_id, 
  child_variant_id 
FROM 
  cscart_nested_option_rules 
WHERE 
  product_id = 12802 
ORDER BY 
  parent_option_id, 
  child_option_id, 
  position, 
  nested_rule_id

Query time 0.00715

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "13.30"
    },
    "ordering_operation": {
      "using_filesort": true,
      "table": {
        "table_name": "cscart_nested_option_rules",
        "access_type": "ref",
        "possible_keys": [
          "idx_product",
          "idx_product_parent"
        ],
        "key": "idx_product",
        "used_key_parts": [
          "product_id"
        ],
        "key_length": "4",
        "ref": [
          "const"
        ],
        "rows_examined_per_scan": 73,
        "rows_produced_per_join": 73,
        "filtered": "100.00",
        "cost_info": {
          "read_cost": "6.00",
          "eval_cost": "7.30",
          "prefix_cost": "13.30",
          "data_read_per_join": "2K"
        },
        "used_columns": [
          "nested_rule_id",
          "product_id",
          "parent_option_id",
          "child_option_id",
          "parent_variant_id",
          "child_variant_id",
          "position"
        ]
      }
    }
  }
}

Result

parent_option_id child_option_id parent_variant_id child_variant_id
90 64 814 820
90 64 814 821
90 64 814 822
90 64 814 823
90 64 814 824
90 64 814 825
90 64 814 826
90 64 814 827
90 64 814 828
90 64 814 829
90 64 814 830
90 64 814 831
90 64 814 832
90 64 814 833
90 64 814 834
90 64 814 835
90 64 814 836
90 64 814 837
90 64 814 838
90 64 814 839
90 64 814 840
90 64 814 841
90 64 814 842
90 64 814 843
90 64 815 857
90 64 815 858
90 64 815 861
90 64 815 862
90 64 815 863
90 64 815 864
90 64 815 865
90 64 815 866
90 64 815 867
90 64 815 868
90 64 815 869
90 64 815 870
90 64 815 871
90 64 816 844
90 64 816 845
90 64 816 846
90 64 816 847
90 64 816 848
90 64 816 849
90 64 816 850
90 64 816 851
90 64 816 852
90 64 816 853
90 64 816 854
90 64 816 855
90 64 816 856
90 64 817 872
90 64 817 873
90 64 817 874
90 64 817 875
90 64 817 876
90 64 817 877
90 64 818 878
90 64 818 879
90 64 818 880
90 64 819 881
90 64 819 882
90 64 819 883
90 64 819 884
91 65 885 890
91 65 885 891
91 65 887 904
91 65 887 905
91 65 887 906
91 65 887 908
91 65 887 910
91 65 887 912
91 65 887 909
91 65 887 911