{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "19.44"
},
"nested_loop": [
{
"table": {
"table_name": "b",
"access_type": "index",
"possible_keys": [
"PRIMARY",
"c_status"
],
"key": "c_status",
"used_key_parts": [
"destination_id",
"status"
],
"key_length": "6",
"rows_examined_per_scan": 9,
"rows_produced_per_join": 1,
"filtered": "11.11",
"using_index": true,
"cost_info": {
"read_cost": "3.64",
"eval_cost": "0.20",
"prefix_cost": "3.84",
"data_read_per_join": "776"
},
"used_columns": [
"destination_id",
"status"
],
"attached_condition": "((`ea201_diorama`.`b`.`status` = 'A') and (`ea201_diorama`.`b`.`destination_id` is not null))"
}
},
{
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": [
"c_status"
],
"key": "c_status",
"used_key_parts": [
"destination_id"
],
"key_length": "4",
"ref": [
"ea201_diorama.b.destination_id"
],
"rows_examined_per_scan": 33,
"rows_produced_per_join": 33,
"filtered": "100.00",
"index_condition": "(`ea201_diorama`.`b`.`destination_id` = `ea201_diorama`.`a`.`destination_id`)",
"cost_info": {
"read_cost": "9.00",
"eval_cost": "6.60",
"prefix_cost": "19.44",
"data_read_per_join": "25K"
},
"used_columns": [
"element_id",
"destination_id",
"element",
"element_type"
]
}
}
]
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
1212 | 1 | ZW | C |
1211 | 1 | ZM | C |
1210 | 1 | ZR | C |
1209 | 1 | YU | C |
1208 | 1 | YE | C |
1207 | 1 | EH | C |
1206 | 1 | WF | C |
1205 | 1 | VN | C |
1204 | 1 | VE | C |
1203 | 1 | VA | C |
1202 | 1 | VU | C |
1201 | 1 | UZ | C |
1200 | 1 | UY | C |
1199 | 1 | VI | C |
1198 | 1 | US | C |
1197 | 1 | GB | C |
1196 | 1 | AE | C |
1195 | 1 | UA | C |
1194 | 1 | UG | C |
1193 | 1 | TV | C |
1192 | 1 | TC | C |
1191 | 1 | TM | C |
1190 | 1 | TR | C |
1189 | 1 | TN | C |
1188 | 1 | TT | C |
1187 | 1 | TO | C |
1186 | 1 | TK | C |
1185 | 1 | TG | C |
1184 | 1 | TH | C |
1183 | 1 | TZ | C |
1182 | 1 | TJ | C |
1181 | 1 | TW | C |
1180 | 1 | SY | C |
1179 | 1 | CH | C |
1178 | 1 | SE | C |
1177 | 1 | SZ | C |
1176 | 1 | SJ | C |
1175 | 1 | SR | C |
1174 | 1 | SD | C |
1173 | 1 | VC | C |
1172 | 1 | PM | C |
1171 | 1 | KN | C |
1170 | 1 | SH | C |
1169 | 1 | LK | C |
1168 | 1 | ES | C |
1167 | 1 | ZA | C |
1166 | 1 | SO | C |
1165 | 1 | SB | C |
1164 | 1 | SI | C |
1163 | 1 | SK | C |
1162 | 1 | SG | C |
1161 | 1 | SL | C |
1160 | 1 | SC | C |
1159 | 1 | SN | C |
1158 | 1 | SA | C |
1157 | 1 | ST | C |
1156 | 1 | SM | C |
1155 | 1 | WS | C |
1154 | 1 | LC | C |
1153 | 1 | RW | C |
1152 | 1 | RU | C |
1151 | 1 | RO | C |
1150 | 1 | RE | C |
1149 | 1 | QA | C |
1148 | 1 | PR | C |
1147 | 1 | PT | C |
1146 | 1 | PL | C |
1145 | 1 | PN | C |
1144 | 1 | PH | C |
1143 | 1 | PE | C |
1142 | 1 | PY | C |
1141 | 1 | PG | C |
1140 | 1 | PA | C |
1139 | 1 | PW | C |
1138 | 1 | PK | C |
1137 | 1 | OM | C |
1136 | 1 | NO | C |
1135 | 1 | MP | C |
1134 | 1 | NF | C |
1133 | 1 | NU | C |
1132 | 1 | NG | C |
1131 | 1 | NE | C |
1130 | 1 | NI | C |
1129 | 1 | NZ | C |
1128 | 1 | CW | C |
1127 | 1 | NL | C |
1126 | 1 | NP | C |
1125 | 1 | NR | C |
1124 | 1 | NA | C |
1123 | 1 | MM | C |
1122 | 1 | MZ | C |
1121 | 1 | MA | C |
1120 | 1 | MS | C |
1119 | 1 | MN | C |
1118 | 1 | MC | C |
1117 | 1 | MD | C |
1116 | 1 | FM | C |
1115 | 1 | MX | C |
1114 | 1 | YT | C |
1113 | 1 | MU | C |
1112 | 1 | MR | C |
1111 | 1 | MQ | C |
1110 | 1 | MH | C |
1109 | 1 | MT | C |
1108 | 1 | ML | C |
1107 | 1 | MV | C |
1106 | 1 | MY | C |
1105 | 1 | MW | C |
1104 | 1 | MG | C |
1103 | 1 | MK | C |
1102 | 1 | MO | C |
1101 | 1 | LU | C |
1100 | 1 | LT | C |
1099 | 1 | LI | C |
1098 | 1 | LY | C |
1097 | 1 | LR | C |
1096 | 1 | LS | C |
1095 | 1 | LB | C |
1094 | 1 | LV | C |
1093 | 1 | LA | C |
1092 | 1 | KG | C |
1091 | 1 | KW | C |
1090 | 1 | KR | C |
1089 | 1 | KP | C |
1088 | 1 | KI | C |
1087 | 1 | KE | C |
1086 | 1 | KZ | C |
1085 | 1 | JO | C |
1084 | 1 | JP | C |
1083 | 1 | JM | C |
1082 | 1 | IT | C |
1081 | 1 | IL | C |
1080 | 1 | IR | C |
1079 | 1 | IE | C |
1078 | 1 | IQ | C |
1077 | 1 | ID | C |
1076 | 1 | IN | C |
1075 | 1 | IS | C |
1074 | 1 | HU | C |
1073 | 1 | HK | C |
1072 | 1 | HN | C |
1071 | 1 | HM | C |
1070 | 1 | HT | C |
1069 | 1 | GY | C |
1068 | 1 | GW | C |
1067 | 1 | GN | C |
1066 | 1 | GT | C |
1065 | 1 | GU | C |
1064 | 1 | GP | C |
1063 | 1 | GD | C |
1062 | 1 | GL | C |
1061 | 1 | GR | C |
1060 | 1 | GI | C |
1059 | 1 | GH | C |
1058 | 1 | DE | C |
1057 | 1 | GE | C |
1056 | 1 | GM | C |
1055 | 1 | GA | C |
1054 | 1 | TF | C |
1053 | 1 | PF | C |
1052 | 1 | GF | C |
1051 | 1 | FX | C |
1050 | 1 | FR | C |
1049 | 1 | FI | C |
1048 | 1 | FJ | C |
1047 | 1 | FO | C |
1046 | 1 | FK | C |
1045 | 1 | ET | C |
1044 | 1 | EE | C |
1043 | 1 | ER | C |
1042 | 1 | GQ | C |
1041 | 1 | SV | C |
1040 | 1 | EG | C |
1039 | 1 | EC | C |
1038 | 1 | DO | C |
1037 | 1 | DM | C |
1036 | 1 | DJ | C |
1035 | 1 | DK | C |
1034 | 1 | CZ | C |
1033 | 1 | CY | C |
1032 | 1 | CU | C |
1031 | 1 | HR | C |
1030 | 1 | CI | C |
1029 | 1 | CR | C |
1028 | 1 | CK | C |
1027 | 1 | CG | C |
1026 | 1 | KM | C |
1025 | 1 | CO | C |
1024 | 1 | CC | C |
1023 | 1 | CX | C |
1022 | 1 | CN | C |
1021 | 1 | CL | C |
1020 | 1 | TD | C |
1019 | 1 | CF | C |
1018 | 1 | KY | C |
1017 | 1 | CV | C |
1016 | 1 | CA | C |
1015 | 1 | CM | C |
1014 | 1 | KH | C |
1013 | 1 | BI | C |
1012 | 1 | BF | C |
1011 | 1 | BG | C |
1010 | 1 | BN | C |
1009 | 1 | VG | C |
1008 | 1 | IO | C |
1007 | 1 | BR | C |
1006 | 1 | BV | C |
1005 | 1 | BW | C |
1004 | 1 | BA | C |
1003 | 1 | BO | C |
1002 | 1 | BT | C |
1001 | 1 | BM | C |
1000 | 1 | BJ | C |
999 | 1 | BZ | C |
998 | 1 | BE | C |
997 | 1 | BY | C |
996 | 1 | BB | C |
995 | 1 | BD | C |
994 | 1 | BH | C |
993 | 1 | BS | C |
992 | 1 | AZ | C |
991 | 1 | AT | C |
990 | 1 | AU | C |
989 | 1 | AW | C |
988 | 1 | AM | C |
987 | 1 | AR | C |
986 | 1 | AG | C |
985 | 1 | AQ | C |
984 | 1 | AI | C |
983 | 1 | AO | C |
982 | 1 | AD | C |
981 | 1 | AS | C |
980 | 1 | DZ | C |
979 | 1 | AL | C |
978 | 1 | AF | C |
1447 | 1 | SX | C |
1445 | 9 | ES | C |
1444 | 9 | LI | C |
1443 | 9 | IT | C |
1442 | 9 | AT | C |
1441 | 9 | VA | C |
1446 | 9 | PT | C |
1423 | 10 | LU | C |
1422 | 10 | DE | C |
1421 | 10 | NL | C |
780 | 11 | DK | C |
1489 | 13 | NC | C |
1488 | 13 | MA | C |
1487 | 13 | AL | C |
1486 | 13 | DZ | C |
1485 | 13 | AR | C |
1484 | 13 | GE | C |
1483 | 13 | HK | C |
1482 | 13 | HU | C |
1481 | 13 | IN | C |
1480 | 13 | IL | C |
1479 | 13 | MG | C |
1478 | 13 | MH | C |
1477 | 13 | MX | C |
1476 | 13 | NO | C |
1475 | 13 | TR | C |
1474 | 13 | TN | C |
1473 | 13 | ZA | C |
1472 | 13 | SI | C |
1471 | 13 | SK | C |
1470 | 13 | SG | C |
1469 | 13 | NZ | C |
1468 | 13 | RU | C |
1467 | 13 | CA | C |
1466 | 13 | HR | C |
1465 | 13 | CU | C |
1464 | 13 | CZ | C |
1463 | 13 | JP | C |
1462 | 13 | AU | C |
1461 | 13 | US | C |
1460 | 13 | BR | C |
1459 | 13 | RO | C |
1458 | 13 | PL | C |
1457 | 13 | DK | C |
648 | 15 | BE | C |
656 | 16 | GB | C |
655 | 16 | CH | C |
1440 | 17 | FX | C |
1439 | 17 | FR | C |
1448 | 18 | FR | C |
1449 | 18 | EN | C |
1450 | 18 | BE | C |
1451 | 18 | DE | C |
1452 | 18 | NL | C |
1453 | 18 | LU | C |
1454 | 18 | ES | C |
1455 | 18 | PO | C |
1456 | 18 | IT | C |