Скачать из Windows Phone Store
a a a a a a a
Концерты

New Wave Fest

Мероприятие в этом городе уже прошло

Жанр Альтернатива

New Wave 4!

Играют:


    * ЛИНИЯ, Москва. lineband.ru
    * ICONAUTS (ex. – Ikona). Могилев. Презентация Нового EP.
    * My Ocean. Минск. В рамках большого тура "MITES 'N' SPIDERS TOUR" по странам СНГ и Прибалтики
    * Weesp. Минск. www.weespband.com

Билеты: 20 000 руб. - первые 50, 25 000 руб. - предварительно, 30 000 руб. - в день концерта, 35 000 руб. - за столиком.

Все события твоего города в мобильном приложении relax.by. Найди «relax.by» в своем маркете: App Store, Google Play!   
ОСТАВЬТЕ ОТЗЫВ
Отправить комментарий
Нажимая кнопку «Отправить», Вы принимаете Правила размещения комментариев. Отзыв не будет опубликован, если он содержит ненормативную лексику, оскорбления и угрозы
Время: 0.3 с. Память: 5,075Кб, Запросы к БД: 38. Запросы к КЭШу: 111.
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)

SELECT *
FROM `re_redirect` `t`
WHERE (t.from_url = 'https://afisha.relax.by/conserts/237307-237307/minsk/' OR t.from_url = 'https://afisha.relax.by/conserts/237307-237307/minsk') AND (type = 'for_all')
LIMIT 1
1 0.00649 0.00649 0.00649 0.00649

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`color` AS `t0_c4`, `t`.`title_in_api` AS `t0_c5`, `t`.`api_template` AS `t0_c6`, `t`.`schema_type` AS `t0_c7`, `afishaFilterOptions`.`value` AS `t1_c2`, `afishaFilterOptions`.`id` AS `t1_c0`
FROM `re_afisha_filter` `t`
LEFT OUTER JOIN `re_afisha_filter_option` `afishaFilterOptions` ON (`afishaFilterOptions`.`filter_id`=`t`.`id`)
LEFT OUTER JOIN `re_afisha_filter_options_events` `afishaFilterOptionsEvents` ON (`afishaFilterOptionsEvents`.`option_id`=`afishaFilterOptions`.`id`)
WHERE (t.id = '305') AND (afishaFilterOptionsEvents.event_id = 237307)
ORDER BY afishaFilterOptions.value, afishaFilterOptions.id
10 0.00496 0.00050 0.00034 0.00106

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`title` AS `t0_c3`, `t`.`color` AS `t0_c4`, `t`.`title_in_api` AS `t0_c5`, `t`.`api_template` AS `t0_c6`, `t`.`schema_type` AS `t0_c7`, `afishaFilterOptions`.`value` AS `t1_c2`, `afishaFilterOptions`.`id` AS `t1_c0`, `afishaFilterOptionsEvents`.`custom_value` AS `t2_c3`, `afishaFilterOptionsEvents`.`id` AS `t2_c0`
FROM `re_afisha_filter` `t`
LEFT OUTER JOIN `re_afisha_filter_option` `afishaFilterOptions` ON (`afishaFilterOptions`.`filter_id`=`t`.`id`)
LEFT OUTER JOIN `re_afisha_filter_options_events` `afishaFilterOptionsEvents` ON (`afishaFilterOptionsEvents`.`option_id`=`afishaFilterOptions`.`id`)
WHERE (t.id = '122') AND (afishaFilterOptionsEvents.event_id = 237307)
ORDER BY afishaFilterOptions.value, afishaFilterOptionsEvents.custom_value, afishaFilterOptions.id
4 0.00204 0.00051 0.00034 0.00070

SELECT `t`.`place_id` AS `t0_c2`, `t`.`date_start` AS `t0_c3`, `t`.`date_end` AS `t0_c4`, `t`.`id` AS `t0_c0`, `place`.`id` AS `t1_c0`, `info`.`title` AS `t2_c3`, `info`.`short_title` AS `t2_c4`, `info`.`id` AS `t2_c0`, `address`.`address` AS `t3_c4`, `address`.`building` AS `t3_c5`, `address`.`city_id` AS `t3_c2`, `address`.`id` AS `t3_c0`, `city`.`title` AS `t4_c1`, `city`.`id` AS `t4_c0`, `placePhones`.`phone_code` AS `t5_c3`, `placePhones`.`phone` AS `t5_c4`, `placePhones`.`id` AS `t5_c0`, `country`.`phone_code` AS `t6_c2`, `country`.`id` AS `t6_c0`, `worktimes`.`id` AS `t7_c0`, `worktimes`.`place_id` AS `t7_c1`, `worktimes`.`start_day` AS `t7_c2`, `worktimes`.`end_day` AS `t7_c3`, `worktimes`.`start_time` AS `t7_c4`, `worktimes`.`end_time` AS `t7_c5`, `worktimes`.`fulltime` AS `t7_c6`, `worktimes`.`weekend` AS `t7_c7`, `worktimes`.`description` AS `t7_c8`, `afishaEventSchedules`.`id` AS `t8_c0`, `afishaEventSchedules`.`period_id` AS `t8_c1`, `afishaEventSchedules`.`time` AS `t8_c2`, `afishaEventSchedules`.`min_price` AS `t8_c3`, `afishaEventSchedules`.`max_price` AS `t8_c4`, `afishaEventSchedules`.`discounted_price` AS `t8_c5`
FROM `re_afisha_event_period` `t`
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_place_phone` `placePhones` ON (`placePhones`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_country` `country` ON (`placePhones`.`country_id`=`country`.`id`)
LEFT OUTER JOIN `re_worktime` `worktimes` ON (`worktimes`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_afisha_event_schedule` `afishaEventSchedules` ON (`afishaEventSchedules`.`period_id`=`t`.`id`)
WHERE (t.event_id = 237307 AND t.status = '1')
ORDER BY t.place_id, afishaEventSchedules.time, placePhones.sort_order, worktimes.start_day ASC, time
1 0.00161 0.00161 0.00161 0.00161

SELECT `t`.`id` AS `t0_c0`, `t`.`event_id` AS `t0_c1`, `t`.`place_id` AS `t0_c2`, `t`.`date_start` AS `t0_c3`, `t`.`date_end` AS `t0_c4`, `t`.`status` AS `t0_c5`, `t`.`is_3d` AS `t0_c6`, `afishaEventSchedules`.`time` AS `t1_c2`, `afishaEventSchedules`.`min_price` AS `t1_c3`, `afishaEventSchedules`.`max_price` AS `t1_c4`, `afishaEventSchedules`.`discounted_price` AS `t1_c5`, `afishaEventSchedules`.`id` AS `t1_c0`, `place`.`id` AS `t2_c0`, `info`.`title` AS `t3_c3`, `info`.`short_title` AS `t3_c4`, `info`.`url` AS `t3_c10`, `info`.`logo_filename` AS `t3_c13`, `info`.`text_type` AS `t3_c17`, `info`.`id` AS `t3_c0`, `address`.`city_id` AS `t5_c2`, `address`.`building` AS `t5_c5`, `address`.`address` AS `t5_c4`, `address`.`hide_city` AS `t5_c8`, `address`.`id` AS `t5_c0`, `city`.`title` AS `t6_c1`, `city`.`type` AS `t6_c11`, `city`.`id` AS `t6_c0`, `driveway`.`type` AS `t7_c2`, `driveway`.`show_map` AS `t7_c10`, `driveway`.`map_image` AS `t7_c11`, `driveway`.`id` AS `t7_c0`
FROM `re_afisha_event_period` `t`
LEFT OUTER JOIN `re_afisha_event_schedule` `afishaEventSchedules` ON (`afishaEventSchedules`.`period_id`=`t`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_city` `city` ON (`address`.`city_id`=`city`.`id`)
LEFT OUTER JOIN `re_driveway` `driveway` ON (`driveway`.`address_id`=`address`.`id`)
WHERE (t.event_id = '237307' AND t.status = '1' AND t.date_end >= 1503435600) AND (placesCities.city_id = '1')
ORDER BY info.title ASC, afishaEventSchedules.time ASC, t.id ASC, time
1 0.00105 0.00105 0.00105 0.00105

SELECT COUNT(DISTINCT `t`.`id`)
FROM `re_afisha_event` `t`
LEFT OUTER JOIN `re_afisha_event_period` `afishaEventPeriods` ON (`afishaEventPeriods`.`event_id`=`t`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`afishaEventPeriods`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
WHERE (afishaEventPeriods.event_id = '237307' AND afishaEventPeriods.status = '1') AND (afishaEventPeriods.date_end >= 1503435600) AND (place.status = '1' AND place.is_deleted = '0') AND (placesCities.city_id = '1')
1 0.00101 0.00101 0.00101 0.00101

SELECT *
FROM `re_afisha_event_seo_template` `t`
WHERE `t`.`rubric_id`='340'
LIMIT 1
1 0.00095 0.00095 0.00095 0.00095

SELECT COUNT(DISTINCT `t`.`id`)
FROM `re_afisha_event_period` `t`
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`place`.`id`)
WHERE (t.status = '1' AND t.event_id = '237307') AND (address.city_id = '1')
1 0.00089 0.00089 0.00089 0.00089

SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`type` AS `t0_c4`, `t`.`image` AS `t0_c5`, `t`.`image_align` AS `t0_c6`, `t`.`html` AS `t0_c7`, `t`.`noindex` AS `t0_c8`
FROM `re_afisha_branding_search` `t`
LEFT OUTER JOIN `re_afisha_branding_search_date` `brandingDates` ON (`brandingDates`.`branding_id`=`t`.`id`)
WHERE (status = '1' AND date_start <= 1503471900 AND date_end >= 1503471900) AND ((rubric_id = '340' OR rubric_id IS NULL) AND (city_id = '1' OR city_id IS NULL))
ORDER BY rubric_id DESC, city_id DESC
1 0.00089 0.00089 0.00089 0.00089

SELECT `t`.`id` AS `t0_c0`, `t`.`status` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`original_title` AS `t0_c3`, `t`.`logo_filename` AS `t0_c4`, `t`.`description` AS `t0_c5`, `t`.`url` AS `t0_c6`, `t`.`date_created` AS `t0_c7`, `t`.`is_premiere` AS `t0_c8`, `t`.`priority` AS `t0_c9`, `t`.`show_on_afisha_main_page` AS `t0_c10`, `t`.`afisha_main_page_priority` AS `t0_c11`, `t`.`photo_type` AS `t0_c12`, `t`.`is_favorite` AS `t0_c13`, `t`.`date_modified` AS `t0_c14`, `t`.`is_sended` AS `t0_c15`, `t`.`short_title` AS `t0_c16`, `t`.`short_description` AS `t0_c17`, `t`.`show_mobile_label` AS `t0_c18`, `t`.`need_parsing` AS `t0_c19`, `afishaEventsRubrics`.`rubric_id` AS `t1_c2`, `afishaEventsRubrics`.`is_main` AS `t1_c3`, `afishaEventsRubrics`.`id` AS `t1_c0`, `rubric`.`url` AS `t2_c3`, `rubric`.`id` AS `t2_c0`, `rubric`.`video_title` AS `t2_c5`, `rubric`.`photo_title` AS `t2_c6`, `rubric`.`event_type` AS `t2_c4`, `rubric`.`schema_type` AS `t2_c7`, `rubric`.`schedule_display_type` AS `t2_c8`, `afishaEventServiceRelation`.`id` AS `t3_c0`, `afishaEventServiceRelation`.`service_id` AS `t3_c1`, `afishaEventServiceRelation`.`event_id` AS `t3_c2`, `afishaEventServiceRelation`.`relation` AS `t3_c3`
FROM `re_afisha_event` `t`
LEFT OUTER JOIN `re_afisha_events_rubrics` `afishaEventsRubrics` ON (`afishaEventsRubrics`.`event_id`=`t`.`id`)
LEFT OUTER JOIN `re_afisha_rubric` `rubric` ON (`afishaEventsRubrics`.`rubric_id`=`rubric`.`id`)
LEFT OUTER JOIN `re_afisha_event_service_relation` `afishaEventServiceRelation` ON (`afishaEventServiceRelation`.`event_id`=`t`.`id`)
WHERE (t.id = '237307' AND t.status = '1' AND t.url = '237307') AND (afishaEventsRubrics.is_main = '1') AND (rubric.status = '1' AND rubric.url = 'conserts')
GROUP BY t.id
ORDER BY afishaEventsRubrics.is_main DESC
1 0.00080 0.00080 0.00080 0.00080

SELECT `t`.`id` AS `t0_c0`, `t`.`event_id` AS `t0_c1`, `t`.`sort_order` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`filename` AS `t0_c4`, `event`.`id` AS `t1_c0`, `event`.`title` AS `t1_c2`
FROM `re_afisha_event_photo` `t`
LEFT OUTER JOIN `re_afisha_event` `event` ON (`t`.`event_id`=`event`.`id`)
WHERE (t.event_id = '237307' AND t.status = '1')
ORDER BY sort_order
1 0.00072 0.00072 0.00072 0.00072

SELECT `t`.`id` AS `t0_c0`, `t`.`title` AS `t0_c2`, `t`.`original_title` AS `t0_c3`, `afishaEventPeriods`.`id` AS `t1_c0`, `place`.`id` AS `t2_c0`, `info`.`title` AS `t3_c3`, `info`.`id` AS `t3_c0`
FROM `re_afisha_event` `t`
LEFT OUTER JOIN `re_afisha_event_period` `afishaEventPeriods` ON (`afishaEventPeriods`.`event_id`=`t`.`id`)
LEFT OUTER JOIN `re_place` `place` ON (`afishaEventPeriods`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_place_info` `info` ON (`info`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_places_cities` `placesCities` ON (`placesCities`.`place_id`=`place`.`id`)
WHERE (afishaEventPeriods.event_id = '237307' AND afishaEventPeriods.status = '1') AND (place.status = '1' AND place.is_deleted = '0') AND (placesCities.city_id = '1')
1 0.00067 0.00067 0.00067 0.00067

SELECT MAX(t.date_end) as date_end, `t`.`id` AS `t0_c0`, `place`.`id` AS `t1_c0`, `address`.`city_id` AS `t2_c2`, `address`.`id` AS `t2_c0`
FROM `re_afisha_event_period` `t`
LEFT OUTER JOIN `re_place` `place` ON (`t`.`place_id`=`place`.`id`)
LEFT OUTER JOIN `re_address` `address` ON (`address`.`place_id`=`place`.`id`)
WHERE (t.event_id = '237307' AND t.status = '1')
GROUP BY address.city_id
1 0.00061 0.00061 0.00061 0.00061

SELECT *
FROM `re_afisha_event_video` `t`
WHERE event_id = '237307' AND status = '1'
ORDER BY sort_order
1 0.00056 0.00056 0.00056 0.00056

SELECT 1
FROM `re_afisha_event_review` `t`
WHERE t.status = '1' AND t.is_deleted = '0' AND t.event_id = 237307
LIMIT 1
1 0.00049 0.00049 0.00049 0.00049

SELECT *
FROM `re_afisha_events_rubrics` `t`
WHERE event_id = '237307' AND is_main = '1'
LIMIT 1
1 0.00048 0.00048 0.00048 0.00048

SELECT `t`.`date_created` AS `t0_c3`, `t`.`text` AS `t0_c5`, `t`.`author` AS `t0_c4`, `t`.`id` AS `t0_c0`, `user`.`first_name` AS `t1_c3`, `user`.`last_name` AS `t1_c4`, `user`.`avatar` AS `t1_c9`, `user`.`organization_name` AS `t1_c5`, `user`.`type` AS `t1_c1`, `user`.`id` AS `t1_c0`
FROM `re_afisha_event_review` `t`
LEFT OUTER JOIN `re_account_user` `user` ON (`t`.`user_id`=`user`.`id`)
WHERE (t.status = '1' AND t.is_deleted = '0' AND t.event_id = 237307)
ORDER BY t.date_created ASC
LIMIT 31
1 0.00041 0.00041 0.00041 0.00041

SELECT *
FROM `re_afisha_events_rubrics` `t`
WHERE `t`.`event_id`=237307
1 0.00036 0.00036 0.00036 0.00036

SELECT *
FROM `re_afisha_event_critique` `t`
WHERE `t`.`event_id`='237307' AND `t`.`status`='1'
LIMIT 1
1 0.00034 0.00034 0.00034 0.00034

SELECT `t`.`id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`url` AS `t0_c2`, `t`.`status` AS `t0_c3`, `t`.`image_top` AS `t0_c4`, `t`.`image_bottom` AS `t0_c5`, `t`.`image_background` AS `t0_c6`, `t`.`padding_top` AS `t0_c7`, `t`.`padding_bottom` AS `t0_c8`
FROM `re_afisha_branding_background` `t`
LEFT OUTER JOIN `re_afisha_branding_background_date` `brandingDates` ON (`brandingDates`.`branding_id`=`t`.`id`)
WHERE (status = '1' AND date_start <= 1503471900 AND date_end >= 1503471900) AND ((rubric_id = '340' OR rubric_id IS NULL) AND (city_id = '1' OR city_id IS NULL))
ORDER BY rubric_id DESC, city_id DESC
1 0.00033 0.00033 0.00033 0.00033

SELECT `event`.`id` AS `t1_c0`, `event`.`status` AS `t1_c1`, `event`.`title` AS `t1_c2`, `event`.`original_title` AS `t1_c3`, `event`.`logo_filename` AS `t1_c4`, `event`.`description` AS `t1_c5`, `event`.`url` AS `t1_c6`, `event`.`date_created` AS `t1_c7`, `event`.`is_premiere` AS `t1_c8`, `event`.`priority` AS `t1_c9`, `event`.`show_on_afisha_main_page` AS `t1_c10`, `event`.`afisha_main_page_priority` AS `t1_c11`, `event`.`photo_type` AS `t1_c12`, `event`.`is_favorite` AS `t1_c13`, `event`.`date_modified` AS `t1_c14`, `event`.`is_sended` AS `t1_c15`, `event`.`short_title` AS `t1_c16`, `event`.`short_description` AS `t1_c17`, `event`.`show_mobile_label` AS `t1_c18`, `event`.`need_parsing` AS `t1_c19`
FROM `re_afisha_event` `event`
WHERE (`event`.`id`='237307')
1 0.00032 0.00032 0.00032 0.00032

SELECT `afishaEventsRubrics`.`id` AS `t1_c0`, `afishaEventsRubrics`.`event_id` AS `t1_c1`, `afishaEventsRubrics`.`rubric_id` AS `t1_c2`, `afishaEventsRubrics`.`is_main` AS `t1_c3`
FROM `re_afisha_events_rubrics` `afishaEventsRubrics`
WHERE (`afishaEventsRubrics`.`event_id`='237307')
ORDER BY afishaEventsRubrics.is_main DESC
1 0.00030 0.00030 0.00030 0.00030

SELECT t.relation, t.service_id
FROM `re_afisha_event_service_relation` `t`
WHERE t.event_id = '237307'
1 0.00028 0.00028 0.00028 0.00028

SELECT *
FROM `re_afisha_event_seo` `t`
WHERE `t`.`event_id`='237307' AND `t`.`city_id`='1'
LIMIT 1
1 0.00024 0.00024 0.00024 0.00024

SELECT url
FROM `re_afisha_rubric` `t`
WHERE `t`.`id`=340
LIMIT 1
1 0.00021 0.00021 0.00021 0.00021

SELECT *
FROM `re_afisha_rubric` `t`
WHERE `t`.`id`=340
LIMIT 1
1 0.00019 0.00019 0.00019 0.00019