MariaDB [Tenda]> select tenda_pin8('04:95:E6:50:04:10,,2,');
*************************** 1. row ***************************
tenda_pin8('04:95:E6:50:04:10,,2,'):
|---------------------------------------------------------------------------------------------|
|Опорные точки (ближайшие данные в базе):
|1) 04:95:E6:50:05:88, +376,   625  пар, 110 уникальных дельт (1:5.68), 36 мажорных(вес 88.2%)
|2) 04:95:E6:50:05:C8, +440,   640  пар, 134 уникальных дельт (1:4.78), 53 мажорных(вес 87.3%)
|3) 04:95:E6:50:05:D0, +448,   649  пар, 150 уникальных дельт (1:4.33), 56 мажорных(вес 85.5%)
|4) 04:95:E6:4F:FF:58, -1208,  534  пар, 101 уникальных дельт (1:5.29), 31 мажорных(вес 86.9%)
|5) 04:95:E6:50:0D:70, +2400,  450  пар, 136 уникальных дельт (1:3.31), 43 мажорных(вес 79.3%)
|6) 04:95:E6:50:10:20, +3088,  467  пар, 117 уникальных дельт (1:3.99), 34 мажорных(вес 82.2%)
|7) 04:95:E6:50:10:28, +3096,  450  пар, 124 уникальных дельт (1:3.63), 36 мажорных(вес 80.4%)
|8) 04:95:E6:50:10:30, +3104,  440  пар, 131 уникальных дельт (1:3.36), 31 мажорных(вес 77.3%)
|---------------------------------------------------------------------------------------------|
|После объединения осталось 655 пинов, из них 11 полностью перекрёстных.
|Эффективность халф-оптимизации: 1.38 общая, 1.83 у перекрёстных.
|---------------------------------------------------------------------------------------------|
|ИТОГО: 473 фёст-халфов, 6 полно-перекрёстных (вес 57.9%, 64.4% в ТОП-8).
|---------------------------------------------------------------------------------------------|
1 row in set (0.90 sec)

MariaDB [Tenda]> select * from tmp_TendaHalfs where Half=2400 order by n;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n    | Half | X    | Xh   | m    | m1   | m2   | m3   | m4   | m5   | m6   | m7   | m8   |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
|   70 | 2400 |    0 |    1 |    2 |    1 |    1 |    0 |    0 |    0 |    0 |    0 |    0 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
1 row in set (0.00 sec)

MariaDB [Tenda]> select * from tmp_TendaPins where PIN=24000406 order by n;
Empty set (0.00 sec)

MariaDB [Tenda]> select * from tmp_TendaHalfs where X>2 order by n;
+------+------+------+------+------+------+------+------+------+------+------+------+------+
| n    | Half | X    | Xh   | m    | m1   | m2   | m3   | m4   | m5   | m6   | m7   | m8   |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
|    1 | 9909 |    7 |    7 | 1082 |   82 |  129 |  195 |  291 |  148 |   47 |   94 |   96 |
|    2 | 9975 |    7 |    7 |  882 |  132 |  126 |   65 |   61 |   63 |  128 |  144 |  163 |
|    3 | 8909 |    7 |    7 |  170 |   10 |   30 |   42 |   24 |   28 |   10 |   12 |   14 |
|    4 | 8975 |    7 |    7 |  141 |   17 |   22 |    9 |    6 |   13 |   32 |   20 |   22 |
|    5 | 1909 |    7 |    7 |  105 |    9 |   15 |   23 |   31 |   12 |    5 |    5 |    5 |
|    6 | 1975 |    7 |    7 |   85 |   16 |   22 |    9 |   10 |    4 |    6 |   13 |    5 |
|    7 | 4198 |    5 |    6 |   35 |    2 |   10 |    1 |    0 |    5 |    1 |   10 |    6 |
|    8 | 1040 |    5 |    5 |  242 |   51 |   26 |   11 |    7 |    0 |  105 |   42 |    0 |
|    9 | 3132 |    5 |    5 |  231 |   75 |   57 |   71 |    0 |   26 |    1 |    1 |    0 |
|   10 | 4132 |    5 |    5 |   89 |    0 |   14 |   37 |    0 |   14 |    3 |   10 |   11 |
|   11 | 4197 |    5 |    5 |   49 |    0 |    8 |   12 |    0 |    2 |   13 |    6 |    8 |
|   12 | 3197 |    4 |    5 |  118 |   43 |   24 |   43 |    0 |    1 |    6 |    1 |    0 |
|   13 | 9974 |    4 |    4 |   49 |    4 |    0 |   14 |    2 |    0 |   17 |   12 |    0 |
|   14 | 1960 |    4 |    4 |   11 |    1 |    4 |    3 |    0 |    0 |    2 |    0 |    1 |
|   15 | 9040 |    3 |    5 |   26 |    3 |    3 |    3 |    1 |    0 |   13 |    3 |    0 |
|   16 | 1026 |    3 |    5 |    9 |    2 |    2 |    2 |    0 |    0 |    1 |    1 |    1 |
|   17 | 3198 |    3 |    3 |  141 |   75 |   51 |   10 |    0 |    5 |    0 |    0 |    0 |
|   18 | 6469 |    3 |    3 |    5 |    0 |    0 |    1 |    1 |    0 |    0 |    1 |    2 |
|   19 | 1865 |    3 |    3 |    4 |    0 |    0 |    1 |    0 |    1 |    0 |    1 |    1 |
+------+------+------+------+------+------+------+------+------+------+------+------+------+
19 rows in set (0.00 sec)