SELECT 
  a.* 
FROM 
  cscart_destination_elements as a 
  LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id 
WHERE 
  b.status = 'A'

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "15.80"
    },
    "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": 2,
          "rows_produced_per_join": 1,
          "filtered": "50.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "0.35",
            "eval_cost": "0.10",
            "prefix_cost": "0.45",
            "data_read_per_join": "776"
          },
          "used_columns": [
            "destination_id",
            "status"
          ],
          "attached_condition": "((`shoptheindependents_com`.`b`.`status` = 'A') and (`shoptheindependents_com`.`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": [
            "shoptheindependents_com.b.destination_id"
          ],
          "rows_examined_per_scan": 146,
          "rows_produced_per_join": 146,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.75",
            "eval_cost": "14.60",
            "prefix_cost": "15.80",
            "data_read_per_join": "111K"
          },
          "used_columns": [
            "element_id",
            "destination_id",
            "element",
            "element_type"
          ]
        }
      }
    ]
  }
}

Result

element_id destination_id element element_type
2367 11 10 S
2368 11 11 S
2369 11 12 S
2370 11 13 S
2371 11 15 S
2372 11 16 S
2373 11 17 S
2374 11 18 S
2375 11 19 S
2376 11 20 S
2377 11 21 S
2378 11 23 S
2379 11 24 S
2380 11 25 S
2381 11 26 S
2382 11 27 S
2383 11 28 S
2384 11 29 S
2385 11 30 S
2386 11 31 S
2387 11 32 S
2388 11 33 S
2389 11 34 S
2390 11 35 S
2391 11 36 S
2392 11 37 S
2393 11 38 S
2394 11 39 S
2395 11 40 S
2396 11 41 S
2397 11 42 S
2398 11 43 S
2399 11 44 S
2400 11 45 S
2401 11 46 S
2402 11 47 S
2403 11 48 S
2404 11 49 S
2405 11 50 S
2406 11 51 S
2407 11 52 S
2408 11 53 S
2409 11 54 S
2410 11 55 S
2411 11 56 S
2412 11 57 S
2413 11 58 S
2414 11 60 S
2415 11 61 S
2416 11 62 S
2417 11 63 S
2418 11 64 S
2419 11 US C