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.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "22.91"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "a",
          "access_type": "ALL",
          "possible_keys": [
            "c_status"
          ],
          "rows_examined_per_scan": 49,
          "rows_produced_per_join": 49,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.86",
            "eval_cost": "4.90",
            "prefix_cost": "5.76",
            "data_read_per_join": "37K"
          },
          "used_columns": [
            "element_id",
            "destination_id",
            "element",
            "element_type"
          ]
        }
      },
      {
        "table": {
          "table_name": "b",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY",
            "c_status"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "destination_id"
          ],
          "key_length": "3",
          "ref": [
            "cscartdevel.a.destination_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 4,
          "filtered": "10.00",
          "cost_info": {
            "read_cost": "12.25",
            "eval_cost": "0.49",
            "prefix_cost": "22.91",
            "data_read_per_join": "3K"
          },
          "used_columns": [
            "destination_id",
            "status"
          ],
          "attached_condition": "(`cscartdevel`.`b`.`status` = 'A')"
        }
      }
    ]
  }
}

Result

element_id destination_id element element_type
497 58 LV C
496 57 IT C
495 56 FO C
494 55 AX C
493 54 IM C
492 53 GB C
491 52 HU C
490 51 UA C
489 50 TR C
488 49 SI C
487 48 SK C
486 47 SE C
485 46 CH C
442 45 CS C
441 44 SM C
484 43 RO C
483 42 PT C
482 41 NO C
481 40 DE C
480 39 MD C
479 38 MC C
434 37 MT C
478 36 MK C
477 35 LU C
476 34 LT C
430 33 LI C
475 32 IS C
474 31 IE C
473 30 NL C
472 29 ES C
471 28 GE C
470 27 GR C
423 26 GI C
469 25 FR C
468 24 FI C
420 23 EE C
467 22 DK C
466 21 CZ C
465 20 ME C
464 19 CY C
463 18 HR C
462 17 BG C
461 16 BA C
460 15 BY C
459 14 BE C
410 13 AT C
458 12 AD C
408 11 AL C
457 1 PL C