{
"query_block": {
"select_id": 1,
"table": {
"table_name": "b",
"access_type": "index",
"possible_keys": ["PRIMARY", "c_status"],
"key": "c_status",
"key_length": "6",
"used_key_parts": ["destination_id", "status"],
"rows": 24,
"filtered": 75,
"attached_condition": "b.`status` = 'A'",
"using_index": true
},
"table": {
"table_name": "a",
"access_type": "ref",
"possible_keys": ["c_status"],
"key": "c_status",
"key_length": "3",
"used_key_parts": ["destination_id"],
"ref": ["admin_test.b.destination_id"],
"rows": 14,
"filtered": 100
}
}
}
element_id | destination_id | element | element_type |
---|---|---|---|
548 | 9 | 528 | S |
549 | 9 | 530 | S |
550 | 9 | 548 | S |
551 | 9 | RU | C |
409 | 12 | Moscow* | T |
408 | 12 | Москва* | T |
451 | 13 | saint* | T |
450 | 13 | sankt* | T |
449 | 13 | санкт* | T |
448 | 13 | питер* | T |
447 | 13 | *петер* | T |
446 | 13 | RU | C |
452 | 13 | piter* | T |
523 | 101 | RU | C |
522 | 101 | 557 | S |
529 | 102 | RU | C |
528 | 102 | 544 | S |
535 | 103 | RU | C |
534 | 103 | 577 | S |
521 | 104 | RU | C |
520 | 104 | 583 | S |
533 | 105 | RU | C |
532 | 105 | 576 | S |
545 | 106 | RU | C |
544 | 106 | 594 | S |
543 | 107 | RU | C |
542 | 107 | 584 | S |
539 | 108 | RU | C |
538 | 108 | 546 | S |
540 | 109 | 582 | S |
541 | 109 | RU | C |
527 | 110 | RU | C |
526 | 110 | 561 | S |
547 | 111 | RU | C |
546 | 111 | 595 | S |
530 | 112 | 574 | S |
531 | 112 | RU | C |
525 | 113 | RU | C |
524 | 113 | 587 | S |
536 | 114 | 579 | S |
537 | 114 | RU | C |
552 | 115 | 548 | S |
553 | 115 | RU | C |
557 | 116 | RU | C |
556 | 116 | 528 | S |
558 | 117 | 530 | S |
559 | 117 | RU | C |
569 | 118 | RU | C |
568 | 118 | 548 | S |
567 | 118 | 544 | S |
566 | 118 | 528 | S |
565 | 118 | 530 | S |