1 count方法

In Mongo Shell

db.variant.find({
    $or: [
        {hom_sample: {$in: ['S22', 'S56']}},
        {het_sample: {$in: ['S22', 'S56']}}
    ]
}).count()

In PHP

$filter = [
    '$or' => [
        [
            'hom_sample' => ['$in' => ['S22', 'S56']]
        ],
        [
            'het_sample' => ['$in' => ['S22', 'S56']]
        ],
    ]
];
$command = new MongoDB\Driver\Command([
    'count' => 'variant',
    'query' => $filter
]);
$cursor = $manager->executeCommand($dbname, $command);
var_dump($cursor->toArray()[0]->n);

2 distinct方法

In Mongo Shell

db.variant.distinct(
    'func',
    {
        'genename': 'ABCG1'
    }
).count()

In PHP

$filter = ['genename' => 'ABCG1'];
$command = new MongoDB\Driver\Command([
    'distinct' => 'variant',
    'key' => 'func',
    'query' => $filter
]);
$cursor = $manager->executeCommand($dbname, $command);
var_dump($cursor->toArray()[0]->values);

3 explain