SELECT * FROM time WHERE `event_id` = '102042' ORDER BY `time` ASC;
# User@Host: afisha[afisha] @ localhost []
# Thread_id: 418565  Schema: afisha  QC_hit: No
# Query_time: 3.294003  Lock_time: 0.000056  Rows_sent: 24032  Rows_examined: 48064
# Rows_affected: 0
# Full_scan: No  Full_join: No  Tmp_table: No  Tmp_table_on_disk: No
# Filesort: Yes  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: No

+----+-------------+----------+------+---------------+--------+---------+-------+-------+-----------------------------+
| id | select_type | table    | type | possible_keys | key    | key_len | ref   | rows  | extra                       |
+----+-------------+----------+------+---------------+--------+---------+-------+-------+-----------------------------+
|  1 | SIMPLE      | time | ref  | event_id        | event_id | 4       | const | 37918 | Using where; Using filesort |
+----+-------------+----------+------+---------------+--------+---------+-------+-------+-----------------------------+

CREATE TABLE `time` (
  `id` int(14) NOT NULL,
  `event_id` int(14) NOT NULL DEFAULT '0',
  `time` int(14) DEFAULT NULL,
  `place` int(11) NOT NULL,
  `month` varchar(8) NOT NULL,
  `city_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) NOT NULL,
  `ticket` varchar(255) NOT NULL,
  `uniques` varchar(32) NOT NULL,
  `price min` int(7) NOT NULL,
  `price max` int(7) NOT NULL
) ENGINE=Aria DEFAULT CHARSET=cp1251;

SET timestamp=1482399577;
SELECT time.time FROM event, time WHERE time.time >= '1482354000' AND time.time < '1483695572' AND time.city_id = '59' AND event.info > '2' AND event.id = time.event_id;
# User@Host: afisha[afisha] @ localhost []
# Thread_id: 567398  Schema: afisha  QC_hit: No
# Query_time: 4.896139  Lock_time: 0.000081  Rows_sent: 522  Rows_examined: 60875

+----+-------------+----------+-------+------------------+----------+---------+------------+------+------------------------------------+
| id | select_type | table    | type  | possible_keys    | key      | key_len | ref        | rows | extra                              |
+----+-------------+----------+-------+------------------+----------+---------+------------+------+------------------------------------+
|  1 | SIMPLE      | event  | range | PRIMARY,info | info | 4       | NULL       | 1393 | Using index condition              |
|  1 | SIMPLE      | time | ref   | event_id_2         | event_id_2 | 4       | event.id | 249  | Using index condition; Using where |
+----+-------------+----------+-------+------------------+----------+---------+------------+------+------------------------------------+