query

mysql> SELECT sql_no_cache id, hits FROM wp_wpproads_user_stats WHERE type = 'impression' AND advertiser_id = '17945' AND campaign_id = '18204' AND adzone_id = '17948' AND banner_id = '17947' AND ip_address = '1.1.1.1' AND date = 1442188800 AND hour = "17" LIMIT 1;
Empty set (0.74 sec)

mysql> EXPLAIN SELECT sql_no_cache id, hits FROM wp_wpproads_user_stats WHERE type = 'impression' AND advertiser_id = '17945' AND campaign_id = '18204' AND adzone_id = '17948' AND banner_id = '17947' AND ip_address = '1.1.1.1' AND date = 1442188800 AND hour = "17" LIMIT 1;
+----+-------------+------------------------+-------------+-------------------------------------------------------+----------------------------------------+---------+------+------+----------------------------------------------------------------------+
| id | select_type | table                  | type        | possible_keys                                         | key                                    | key_len | ref  | rows | Extra                                                                |
+----+-------------+------------------------+-------------+-------------------------------------------------------+----------------------------------------+---------+------+------+----------------------------------------------------------------------+
|  1 | SIMPLE      | wp_wpproads_user_stats | index_merge | advertiser_id,banner_id,adzone_id,date,banner_id_date | banner_id_date,adzone_id,advertiser_id | 7,3,3   | NULL | 4923 | Using intersect(banner_id_date,adzone_id,advertiser_id); Using where |
+----+-------------+------------------------+-------------+-------------------------------------------------------+----------------------------------------+---------+------+------+----------------------------------------------------------------------+
1 row in set (0.00 sec)