{
"query_block": {
"select_id": 1,
"cost": 0.149339865,
"nested_loop": [
{
"table": {
"table_name": "b",
"access_type": "index",
"possible_keys": ["PRIMARY", "c_status"],
"key": "c_status",
"key_length": "6",
"used_key_parts": ["destination_id", "status"],
"loops": 1,
"rows": 3,
"cost": 0.006205352,
"filtered": 100,
"attached_condition": "b.`status` = 'A'",
"using_index": true
}
},
{
"block-nl-join": {
"table": {
"table_name": "a",
"access_type": "ALL",
"possible_keys": ["c_status"],
"loops": 3,
"rows": 305,
"cost": 0.143134513,
"filtered": 33.44262314
},
"buffer_type": "flat",
"buffer_size": "86",
"join_type": "BNL",
"attached_condition": "a.destination_id = b.destination_id"
}
}
]
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
679 | 7 | DE | C |
678 | 7 | 184 | S |
677 | 7 | 183 | S |
676 | 7 | 182 | S |
675 | 7 | 181 | S |
674 | 7 | 180 | S |
673 | 7 | 179 | S |
672 | 7 | 178 | S |
671 | 7 | 177 | S |
670 | 7 | 176 | S |
669 | 7 | 175 | S |
668 | 7 | 174 | S |
667 | 7 | 173 | S |
666 | 7 | 172 | S |
665 | 7 | 171 | S |
664 | 7 | 170 | S |
663 | 7 | 169 | S |
613 | 1 | 668 | S |
612 | 1 | 667 | S |
611 | 1 | 666 | S |
610 | 1 | 665 | S |
609 | 1 | 664 | S |
608 | 1 | 663 | S |
607 | 1 | 662 | S |
606 | 1 | 661 | S |
605 | 1 | 660 | S |
604 | 1 | 659 | S |
603 | 1 | 658 | S |
602 | 1 | 657 | S |
601 | 1 | 656 | S |
600 | 1 | 655 | S |
599 | 1 | 654 | S |
598 | 1 | 653 | S |
597 | 1 | 652 | S |
596 | 1 | 651 | S |
595 | 1 | 650 | S |
594 | 1 | 649 | S |
593 | 1 | 648 | S |
592 | 1 | 647 | S |
591 | 1 | 646 | S |
590 | 1 | 645 | S |
589 | 1 | 644 | S |
588 | 1 | 643 | S |
587 | 1 | 642 | S |
586 | 1 | 641 | S |
585 | 1 | 640 | S |
584 | 1 | 639 | S |
583 | 1 | 638 | S |
582 | 1 | 637 | S |
581 | 1 | 636 | S |
580 | 1 | 168 | S |
579 | 1 | 167 | S |
578 | 1 | 166 | S |
577 | 1 | 165 | S |
576 | 1 | 164 | S |
575 | 1 | 163 | S |
574 | 1 | 162 | S |
573 | 1 | 161 | S |
572 | 1 | 160 | S |
571 | 1 | 159 | S |
570 | 1 | 158 | S |
569 | 1 | 157 | S |
568 | 1 | 399 | S |
567 | 1 | 398 | S |
566 | 1 | 397 | S |
565 | 1 | 403 | S |
564 | 1 | 402 | S |
563 | 1 | 401 | S |
562 | 1 | 395 | S |
561 | 1 | 394 | S |
560 | 1 | 393 | S |
559 | 1 | 392 | S |
558 | 1 | 391 | S |
557 | 1 | 390 | S |
556 | 1 | 400 | S |
555 | 1 | 389 | S |
554 | 1 | 388 | S |
553 | 1 | 387 | S |
552 | 1 | 386 | S |
551 | 1 | 396 | S |
550 | 1 | 404 | S |
549 | 1 | 385 | S |
548 | 1 | 845 | S |
547 | 1 | 844 | S |
546 | 1 | 843 | S |
545 | 1 | 842 | S |
544 | 1 | 841 | S |
543 | 1 | 840 | S |
542 | 1 | 839 | S |
541 | 1 | 838 | S |
540 | 1 | 837 | S |
539 | 1 | 836 | S |
538 | 1 | 835 | S |
537 | 1 | 834 | S |
536 | 1 | 833 | S |
535 | 1 | 832 | S |
534 | 1 | 831 | S |
533 | 1 | 830 | S |
532 | 1 | 829 | S |
531 | 1 | 828 | S |
530 | 1 | 827 | S |
529 | 1 | 826 | S |
528 | 1 | 825 | S |
527 | 1 | 824 | S |
526 | 1 | 823 | S |
525 | 1 | 822 | S |
524 | 1 | 821 | S |
523 | 1 | 820 | S |
522 | 1 | 715 | S |
521 | 1 | 738 | S |
520 | 1 | 746 | S |
519 | 1 | 720 | S |
518 | 1 | 719 | S |
517 | 1 | 745 | S |
516 | 1 | 744 | S |
515 | 1 | 743 | S |
514 | 1 | 742 | S |
513 | 1 | 741 | S |
512 | 1 | 740 | S |
511 | 1 | 747 | S |
510 | 1 | 749 | S |
509 | 1 | 739 | S |
508 | 1 | 737 | S |
507 | 1 | 736 | S |
506 | 1 | 734 | S |
505 | 1 | 735 | S |
504 | 1 | 733 | S |
503 | 1 | 732 | S |
502 | 1 | 731 | S |
501 | 1 | 728 | S |
500 | 1 | 727 | S |
499 | 1 | 722 | S |
498 | 1 | 724 | S |
497 | 1 | 723 | S |
496 | 1 | 721 | S |
495 | 1 | 717 | S |
494 | 1 | 718 | S |
493 | 1 | 709 | S |
492 | 1 | 748 | S |
491 | 1 | 714 | S |
490 | 1 | 712 | S |
489 | 1 | 713 | S |
488 | 1 | 716 | S |
487 | 1 | 710 | S |
486 | 1 | 711 | S |
485 | 1 | 730 | S |
484 | 1 | 729 | S |
483 | 1 | 725 | S |
482 | 1 | 752 | S |
481 | 1 | 751 | S |
480 | 1 | 750 | S |
479 | 1 | 726 | S |
478 | 1 | 708 | S |
477 | 1 | 707 | S |
476 | 1 | 705 | S |
475 | 1 | 703 | S |
474 | 1 | 704 | S |
473 | 1 | 702 | S |
472 | 1 | 706 | S |
471 | 1 | 634 | S |
470 | 1 | 135 | S |
469 | 1 | 134 | S |
468 | 1 | 133 | S |
467 | 1 | 132 | S |
466 | 1 | 131 | S |
465 | 1 | 130 | S |
464 | 1 | 129 | S |
463 | 1 | 128 | S |
462 | 1 | 127 | S |
461 | 1 | 126 | S |
460 | 1 | 125 | S |
459 | 1 | 124 | S |
458 | 1 | 123 | S |
457 | 1 | 632 | S |
456 | 1 | 633 | S |
455 | 1 | 630 | S |
454 | 1 | 629 | S |
453 | 1 | 628 | S |
452 | 1 | 626 | S |
451 | 1 | 623 | S |
450 | 1 | 621 | S |
449 | 1 | 620 | S |
448 | 1 | 619 | S |
447 | 1 | 122 | S |
446 | 1 | 618 | S |
445 | 1 | 617 | S |
444 | 1 | 616 | S |
443 | 1 | 615 | S |
442 | 1 | 614 | S |
441 | 1 | 613 | S |
440 | 1 | 612 | S |
439 | 1 | 611 | S |
438 | 1 | 610 | S |
437 | 1 | 121 | S |
436 | 1 | 120 | S |
435 | 1 | 119 | S |
434 | 1 | 118 | S |
433 | 1 | 117 | S |
432 | 1 | 116 | S |
431 | 1 | 115 | S |
430 | 1 | 114 | S |
429 | 1 | 113 | S |
428 | 1 | 112 | S |
427 | 1 | 111 | S |
426 | 1 | 110 | S |
425 | 1 | 109 | S |
424 | 1 | 108 | S |
423 | 1 | 107 | S |
422 | 1 | 106 | S |
421 | 1 | 105 | S |
420 | 1 | 104 | S |
419 | 1 | 622 | S |
418 | 1 | 103 | S |
417 | 1 | 102 | S |
416 | 1 | 631 | S |
415 | 1 | 627 | S |
414 | 1 | 101 | S |
413 | 1 | 100 | S |
412 | 1 | 99 | S |
411 | 1 | 98 | S |
410 | 1 | 625 | S |
409 | 1 | 97 | S |
408 | 1 | 96 | S |
407 | 1 | 95 | S |
406 | 1 | 94 | S |
405 | 1 | 93 | S |
404 | 1 | 92 | S |
403 | 1 | 91 | S |
402 | 1 | 90 | S |
401 | 1 | 89 | S |
400 | 1 | 88 | S |
399 | 1 | 635 | S |
398 | 1 | 87 | S |
397 | 1 | 86 | S |
396 | 1 | 85 | S |
395 | 1 | 84 | S |
394 | 1 | 83 | S |
393 | 1 | 82 | S |
392 | 1 | 81 | S |
391 | 1 | 80 | S |
390 | 1 | 79 | S |
389 | 1 | 78 | S |
388 | 1 | 77 | S |
387 | 1 | 624 | S |
386 | 1 | 76 | S |
385 | 1 | 75 | S |
384 | 1 | 73 | S |
383 | 1 | 72 | S |
382 | 1 | 71 | S |
381 | 1 | 70 | S |
380 | 1 | 69 | S |
379 | 1 | 68 | S |
378 | 1 | 67 | S |
653 | 8 | 857 | S |
377 | 1 | 66 | S |
376 | 1 | 74 | S |
375 | 1 | 688 | S |
614 | 1 | 669 | S |
615 | 1 | 670 | S |
616 | 1 | 671 | S |
617 | 1 | 672 | S |
618 | 1 | 673 | S |
619 | 1 | 674 | S |
620 | 1 | 675 | S |
621 | 1 | 676 | S |
622 | 1 | 677 | S |
623 | 1 | 678 | S |
624 | 1 | 679 | S |
625 | 1 | 680 | S |
626 | 1 | 681 | S |
627 | 1 | 682 | S |
628 | 1 | 683 | S |
629 | 1 | 684 | S |
630 | 1 | 685 | S |
631 | 1 | 686 | S |
632 | 1 | 687 | S |
633 | 1 | FR | C |
634 | 1 | FI | C |
635 | 1 | GR | C |
636 | 1 | GL | C |
637 | 1 | HU | C |
638 | 1 | LU | C |
639 | 1 | LT | C |
640 | 1 | LI | C |
641 | 1 | IT | C |
642 | 1 | MC | C |
643 | 1 | NZ | C |
644 | 1 | NO | C |
645 | 1 | SE | C |
646 | 1 | ES | C |
647 | 1 | SI | C |
648 | 1 | SK | C |
649 | 1 | RO | C |
650 | 1 | PT | C |
651 | 1 | PL | C |
652 | 1 | BE | C |
654 | 8 | 860 | S |
655 | 8 | 861 | S |
656 | 8 | 862 | S |
657 | 8 | 858 | S |
658 | 8 | 859 | S |
659 | 8 | 864 | S |
660 | 8 | 865 | S |
661 | 8 | 863 | S |
662 | 8 | AT | C |