EXPLAIN
id? select_type?    TABLE?  partitions? TYPE?   possible_keys?  KEY?    key_len?    REF?    ROWS?   Extra?
1   SIMPLE  ude NULL    REF PRIMARY,userdomain_id,expression_id userdomain_id   4   const   1202    USING INDEX; USING TEMPORARY; USING filesort
1   SIMPLE  r   NULL    REF PRIMARY,expression_id   expression_id   4   hugemetrics_test.ude.expression_id  1   USING INDEX
1   SIMPLE  p   NULL    REF request_id_domain_id_date,domain_id,date_domain_id_position request_id_domain_id_date   4   hugemetrics_test.r.id   589 USING WHERE; USING INDEX

CREATE TABLE SCRIPTS

-- Adminer 4.1.0 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `position`;
CREATE TABLE `position` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `date` DATE DEFAULT NULL,
  `position` INT(11) DEFAULT NULL,
  `oneboxPosition` INT(11) DEFAULT NULL,
  `page` INT(11) DEFAULT NULL,
  `request_id` INT(11) NOT NULL,
  `serp_id` INT(11) DEFAULT NULL,
  `serp_type` VARCHAR(50) DEFAULT NULL,
  `domain_id` INT(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `request_id_domain_id_date` (`request_id`,`domain_id`,`date`),
  KEY `domain_id` (`domain_id`),
  KEY `serp_type` (`serp_type`),
  KEY `serp_id` (`serp_id`),
  KEY `oneboxPosition` (`oneboxPosition`),
  KEY `position` (`position`),
  KEY `date_domain_id_position` (`date`,`domain_id`,`position`),
  CONSTRAINT `position_ibfk_1` FOREIGN KEY (`request_id`) REFERENCES `request` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `request`;
CREATE TABLE `request` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `engine` VARCHAR(255) DEFAULT NULL,
  `region` VARCHAR(255) DEFAULT NULL,
  `language` VARCHAR(255) DEFAULT NULL,
  `datacenter` VARCHAR(255) DEFAULT NULL,
  `expression_id` INT(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `engine_region_language_expression_id` (`engine`,`region`,`language`,`expression_id`),
  KEY `expression_id` (`expression_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `userdomainexpression`;
CREATE TABLE `userdomainexpression` (
  `id` INT(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `userdomain_id` INT(11) NOT NULL DEFAULT '0',
  `expression_id` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userdomain_id`,`expression_id`),
  KEY `userdomain_id` (`userdomain_id`),
  KEY `expression_id` (`expression_id`),
  CONSTRAINT `userdomainexpression_ibfk_1` FOREIGN KEY (`expression_id`) REFERENCES `request` (`expression_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2015-03-25 11:24:16