{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "20.43"
},
"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": 6,
"rows_produced_per_join": 1,
"filtered": "16.67",
"using_index": true,
"cost_info": {
"read_cost": "3.03",
"eval_cost": "0.20",
"prefix_cost": "3.23",
"data_read_per_join": "776"
},
"used_columns": [
"destination_id",
"status"
],
"attached_condition": "((`ea201_francemaqu`.`b`.`status` = 'A') and (`ea201_francemaqu`.`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": "3",
"ref": [
"ea201_francemaqu.b.destination_id"
],
"rows_examined_per_scan": 41,
"rows_produced_per_join": 41,
"filtered": "100.00",
"cost_info": {
"read_cost": "9.00",
"eval_cost": "8.20",
"prefix_cost": "20.43",
"data_read_per_join": "31K"
},
"used_columns": [
"element_id",
"destination_id",
"element",
"element_type"
]
}
}
]
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
5326 | 1 | FR | C |
5325 | 1 | FX | C |
3807 | 7 | US | C |
3808 | 7 | CA | C |
3806 | 7 | CN | C |
3805 | 7 | RU | C |
597 | 10 | AU | C |
598 | 10 | JP | C |
599 | 10 | BR | C |
2054 | 11 | DE | C |
2053 | 11 | GB | C |
2052 | 11 | LU | C |
2051 | 11 | NL | C |
2050 | 11 | BE | C |
5323 | 12 | MC | C |
5322 | 12 | AD | C |
5321 | 12 | LI | C |
5320 | 12 | CH | C |
5319 | 12 | ES | C |
5318 | 12 | IT | C |
5317 | 12 | AT | C |
5316 | 13 | AF | C |
5315 | 13 | ZA | C |
5314 | 13 | AL | C |
5313 | 13 | DZ | C |
5312 | 13 | AO | C |
5311 | 13 | AI | C |
5310 | 13 | AQ | C |
5309 | 13 | AG | C |
5308 | 13 | CW | C |
5307 | 13 | SA | C |
5306 | 13 | AR | C |
5305 | 13 | AM | C |
5304 | 13 | AW | C |
5303 | 13 | AP | C |
5302 | 13 | AT | C |
5301 | 13 | AZ | C |
5300 | 13 | BS | C |
5299 | 13 | BH | C |
5298 | 13 | BD | C |
5297 | 13 | BB | C |
5296 | 13 | BZ | C |
5295 | 13 | BJ | C |
5294 | 13 | BM | C |
5293 | 13 | BT | C |
5292 | 13 | BY | C |
5291 | 13 | MM | C |
5290 | 13 | BO | C |
5289 | 13 | BA | C |
5288 | 13 | BW | C |
5287 | 13 | BN | C |
5286 | 13 | BG | C |
5285 | 13 | BF | C |
5284 | 13 | BI | C |
5283 | 13 | KH | C |
5282 | 13 | KY | C |
5281 | 13 | CV | C |
5280 | 13 | CM | C |
5279 | 13 | TD | C |
5278 | 13 | CL | C |
5277 | 13 | CO | C |
5276 | 13 | CY | C |
5275 | 13 | CN | C |
5274 | 13 | KM | C |
5273 | 13 | CI | C |
5272 | 13 | CR | C |
5271 | 13 | CG | C |
5270 | 13 | HR | C |
5269 | 13 | CU | C |
5268 | 13 | DK | C |
5267 | 13 | DJ | C |
5266 | 13 | DM | C |
5265 | 13 | EG | C |
5264 | 13 | AE | C |
5263 | 13 | EC | C |
5262 | 13 | ER | C |
5261 | 13 | EE | C |
5260 | 13 | ET | C |
5259 | 13 | FJ | C |
5258 | 13 | FI | C |
5257 | 13 | LT | C |
5256 | 13 | MO | C |
5255 | 13 | MK | C |
5254 | 13 | MG | C |
5253 | 13 | MY | C |
5252 | 13 | MW | C |
5251 | 13 | MV | C |
5250 | 13 | ML | C |
5249 | 13 | MT | C |
5248 | 13 | MA | C |
5247 | 13 | MQ | C |
5246 | 13 | MU | C |
5245 | 13 | MR | C |
5244 | 13 | YT | C |
5243 | 13 | MX | C |
5242 | 13 | FM | C |
5241 | 13 | MD | C |
5240 | 13 | MN | C |
5239 | 13 | ME | C |
5238 | 13 | MS | C |
5237 | 13 | MZ | C |
5236 | 13 | NA | C |
5235 | 13 | NR | C |
5234 | 13 | NP | C |
5233 | 13 | NI | C |
5232 | 13 | NE | C |
5231 | 13 | NG | C |
5230 | 13 | NU | C |
5229 | 13 | NO | C |
5228 | 13 | NC | C |
5227 | 13 | NZ | C |
5226 | 13 | OM | C |
5225 | 13 | UG | C |
5224 | 13 | UZ | C |
5223 | 13 | PK | C |
5222 | 13 | PW | C |
5221 | 13 | PS | C |
5220 | 13 | PA | C |
5219 | 13 | PG | C |
5218 | 13 | PY | C |
5217 | 13 | NL | C |
5216 | 13 | PE | C |
5215 | 13 | PH | C |
5214 | 13 | PL | C |
5213 | 13 | PF | C |
5212 | 13 | PR | C |
5211 | 13 | PT | C |
5210 | 13 | QA | C |
5209 | 13 | CF | C |
5208 | 13 | DO | C |
5207 | 13 | IR | C |
5206 | 13 | CZ | C |
5205 | 13 | RO | C |
5204 | 13 | RW | C |
5203 | 13 | EH | C |
5202 | 13 | SM | C |
5201 | 13 | PM | C |
5200 | 13 | VC | C |
5199 | 13 | SH | C |
5198 | 13 | LC | C |
5197 | 13 | SV | C |
5196 | 13 | WS | C |
5195 | 13 | AS | C |
5194 | 13 | ST | C |
5193 | 13 | SN | C |
5192 | 13 | CS | C |
5191 | 13 | RS | C |
5190 | 13 | SC | C |
5189 | 13 | SL | C |
5188 | 13 | SG | C |
5187 | 13 | SK | C |
5186 | 13 | SI | C |
5185 | 13 | SO | C |
5184 | 13 | SD | C |
5183 | 13 | LK | C |
5182 | 13 | KN | C |
5181 | 13 | SE | C |
5180 | 13 | SR | C |
5179 | 13 | SJ | C |
5178 | 13 | SZ | C |
5177 | 13 | SY | C |
5176 | 13 | TJ | C |
5175 | 13 | TW | C |
5174 | 13 | TZ | C |
5173 | 13 | TF | C |
5172 | 13 | IO | C |
5171 | 13 | TH | C |
5170 | 13 | TG | C |
5169 | 13 | TK | C |
5168 | 13 | TO | C |
5167 | 13 | TT | C |
5166 | 13 | TN | C |
5165 | 13 | TM | C |
5164 | 13 | TR | C |
5163 | 13 | TV | C |
5162 | 13 | UA | C |
5161 | 13 | UY | C |
5160 | 13 | VU | C |
5159 | 13 | VA | C |
5158 | 13 | VE | C |
5157 | 13 | VN | C |
5156 | 13 | WF | C |
5155 | 13 | YE | C |
5154 | 13 | ZR | C |
5153 | 13 | ZM | C |
5152 | 13 | ZW | C |
5151 | 13 | LR | C |
5150 | 13 | LY | C |
5149 | 13 | LI | C |
5148 | 13 | FX | C |
5147 | 13 | GA | C |
5146 | 13 | GH | C |
5145 | 13 | GE | C |
5144 | 13 | GM | C |
5143 | 13 | GI | C |
5142 | 13 | GR | C |
5141 | 13 | GD | C |
5140 | 13 | GU | C |
5139 | 13 | GP | C |
5138 | 13 | GL | C |
5137 | 13 | GT | C |
5136 | 13 | GN | C |
5135 | 13 | GQ | C |
5134 | 13 | GW | C |
5133 | 13 | GF | C |
5132 | 13 | GY | C |
5131 | 13 | HT | C |
5130 | 13 | HN | C |
5129 | 13 | HK | C |
5128 | 13 | HU | C |
5127 | 13 | BV | C |
5126 | 13 | CX | C |
5125 | 13 | HM | C |
5124 | 13 | NF | C |
5123 | 13 | AX | C |
5122 | 13 | CC | C |
5121 | 13 | CK | C |
5120 | 13 | FO | C |
5119 | 13 | FK | C |
5118 | 13 | MP | C |
5117 | 13 | MH | C |
5116 | 13 | PN | C |
5115 | 13 | SB | C |
5114 | 13 | TC | C |
5113 | 13 | VI | C |
5112 | 13 | VG | C |
5111 | 13 | IN | C |
5110 | 13 | ID | C |
5109 | 13 | IQ | C |
5108 | 13 | IE | C |
5107 | 13 | IS | C |
5106 | 13 | IL | C |
5105 | 13 | JM | C |
5104 | 13 | JO | C |
5103 | 13 | KZ | C |
5102 | 13 | KE | C |
5101 | 13 | KG | C |
5100 | 13 | KI | C |
5099 | 13 | KP | C |
5098 | 13 | KR | C |
5097 | 13 | KW | C |
5096 | 13 | RE | C |
5095 | 13 | LA | C |
5094 | 13 | LS | C |
5093 | 13 | LV | C |
5092 | 13 | LB | C |