require 'benchmark'

Benchmark.bm do |x|
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true)}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).count}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).hint(deleted_at: 1, cloned_by: 1, enabled: 1,updated_at: -1).count}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).hint(deleted_at: 1, cloned_by: 1, enabled: 1,updated_at: -1).count}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).hint(deleted_at: 1,updated_at: 1, catalog_id: 1, cloned_by: 1, enabled: 1).count}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).hint(deleted_at: 1,updated_at: 1, owner_name: 1, cloned_by: 1, enabled: 1).count}
  x.report {Product.or([{"catalog_id"=>{"$in"=>[BSON::ObjectId('59c5d6f72838c35c7debd78a')]}}, {"owner_name"=>"Demo"}, {"verified"=>true, "cloned_root"=>nil}]).where("cloned_by"=>{"$nin"=>["Demo"]}, "enabled"=>true).hint(deleted_at: 1,updated_at: 1, verified: 1, cloned_root: -1, cloned_by: 1, enabled: 1).count}
end