mysql> explain SELECT `businesses_businessmeta`.*
 FROM `businesses_businessmeta` 
INNER JOIN `businesses_businessmeta__categories` 
ON (`businesses_businessmeta`.`id` = `businesses_businessmeta__categories`.`business_id`) 
WHERE (`businesses_businessmeta__categories`.`category_id` IN (1321, 7304, 9189, 4736, 4737, 1322, 8554, 1323, 1324, 9459, 1325, 1326, 4738, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 8031, 8387) 
AND `businesses_businessmeta`.`id` <= 170261 
 AND `businesses_businessmeta`.`id` >= 160262 ) ;
+----+-------------+-------------------------------------+-------+--------------------------+-------------+---------+------+-------+--------------------------+
| id | select_type | table                               | type  | possible_keys            | key         | key_len | ref  | rows  | Extra                    |
+----+-------------+-------------------------------------+-------+--------------------------+-------------+---------+------+-------+--------------------------+
|  1 | SIMPLE      | businesses_businessmeta             | range | PRIMARY                  | PRIMARY     | 4       | NULL | 20492 | Using where              | 
|  1 | SIMPLE      | businesses_businessmeta__categories | range | business_id,idx_category | business_id | 10      | NULL | 20584 | Using where; Using index | 
+----+-------------+-------------------------------------+-------+--------------------------+-------------+---------+------+-------+--------------------------+
2 rows in set (0.00 sec)



| businesses_businessmeta__categories | CREATE TABLE `businesses_businessmeta__categories` (
  `id` int(11) NOT NULL auto_increment,
  `business_id` int(10) unsigned default NULL,
  `category_id` int(10) unsigned default NULL,
  `country_id` char(2) default NULL,
  `state_id` int(10) unsigned default NULL,
  `city_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `business_id` (`business_id`,`category_id`),
  KEY `idx_category2` (`country_id`,`state_id`,`city_id`,`category_id`),
  KEY `idx_category` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13155275 DEFAULT CHARSET=latin1 | 
+-------------------------------------+------------------------------------------------

+-------------------------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table                               | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------------------------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| businesses_businessmeta__categories |          0 | PRIMARY       |            1 | id          | A         |    13154781 |     NULL | NULL   |      | BTREE      |         | 
| businesses_businessmeta__categories |          0 | business_id   |            1 | business_id | A         |    13154781 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          0 | business_id   |            2 | category_id | A         |    13154781 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          1 | idx_category2 |            1 | country_id  | A         |          17 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          1 | idx_category2 |            2 | state_id    | A         |          17 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          1 | idx_category2 |            3 | city_id     | A         |       53913 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          1 | idx_category2 |            4 | category_id | A         |    13154781 |     NULL | NULL   | YES  | BTREE      |         | 
| businesses_businessmeta__categories |          1 | idx_category  |            1 | category_id | A         |       51995 |     NULL | NULL   | YES  | BTREE      |         | 
+-------------------------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+