Форум пользователей MySQL

Добрый день! Помогите пожалуйста понять и исправить проблему со временем выполнения запроса, есть следующие две таблицы:

CREATE TABLE `financial` (
  `financial_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `site_id` int(11) unsigned NOT NULL,
  `initial_count` smallint(128) NOT NULL DEFAULT '0',
  `initial_money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `recurring_count` smallint(128) NOT NULL DEFAULT '0',
  `recurring_money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `refund_count` smallint(128) NOT NULL DEFAULT '0',
  `refund_money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `chargeback_count` smallint(128) NOT NULL DEFAULT '0',
  `chargeback_money` decimal(8,2) NOT NULL DEFAULT '0.00',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`financial_id`),
  KEY `financial-created` (`created`),
  KEY `fk-financial-site` (`site_id`),
  KEY `created_site_id` (`created`,`site_id`),
  CONSTRAINT `fk-financial-site` FOREIGN KEY (`site_id`) REFERENCES `site` (`site_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_has_site` (
  `project_has_site_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) unsigned DEFAULT NULL,
  `site_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`project_has_site_id`),
  KEY `fk-project_has_site-site` (`site_id`),
  KEY `fk-project_has_site-project` (`project_id`),
  CONSTRAINT `fk-project_has_site-project` FOREIGN KEY (`project_id`) REFERENCES `project` (`project_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk-project_has_site-site` FOREIGN KEY (`site_id`) REFERENCES `site` (`site_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

В таблице financial порядка 45к записей.

Есть запрос:

Отредактированно owner.coder (10.01.2018 18:34:53)