Бесплатный подбор
клиники или врача
+7 (495) 646 71 97
Запись на прием
(единая регистратура)
Профессиональная медицина для Вас

Врачи Мануальные терапевты

Клиника Бобыря - Митино

Прием специалистов:
УЗИ-специалист, Ортопед, Мануальный терапевт, Массажист, Остеопат
Все специалисты
Метро:
Митино
Адрес:
г. Москва, м. Митино, Пятницкое шоссе д.37
Рейтинг:
Бобырь М. А.
Мануальный терапевт, Остеопат
Мануальный терапевт Подробнее
Гаврилин В. К.
Мануальный терапевт, Невролог, Остеопат
Невролог Подробнее
Балабанова Ж. Н.
Мануальный терапевт, Невролог, Остеопат
Мануальный терапевт Подробнее
Ким В. В.
Мануальный терапевт, Невролог, Остеопат
Мануальный терапевт Подробнее

Запись на прием в клинику

Клиника Бобыря - Митино
Записаться на прием
тел. (495) 646 71 97
или оставить заявку

Поля, отмеченные знаком (*) обязательны для заполнения

На карте

Лучшие врачи

Бобырь М. А.
Мануальный терапевт

Гаврилин В. К.
Невролог

Балабанова Ж. Н.
Мануальный терапевт

debug sql count: 19, sql time: 0,026
time: 0.000
        

SET SQL_AUTO_IS_NULL = 0

time: 0.001
        

SELECT `clinic_clinic`.`id`, `clinic_clinic`.`meta_title`, `clinic_clinic`.`meta_keywords`,
`clinic_clinic`.`meta_description`, `clinic_clinic`.`active`, `clinic_clinic`.`date`,
`clinic_clinic`.`name`, `clinic_clinic`.`address`, `clinic_clinic`.`description`,
`clinic_clinic`.`image`, `clinic_clinic`.`rating_avg`, `clinic_clinic`.`testimonial_count`,
`clinic_clinic`.`latitude`, `clinic_clinic`.`longitude`
FROM `clinic_clinic`
WHERE `clinic_clinic`.`id` = 24 LIMIT 21

time: 0.000
        

SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `core_specialization`
WHERE `core_specialization`.`slug` = 'manualnyij-terapevt' LIMIT 21

time: 0.003
        

SELECT COUNT(*)
FROM (SELECT `medic_medic`.`id` AS `id`, `medic_medic`.`meta_title` AS `meta_title`, `medic_medic`.`meta_keywords` AS `meta_keywords`,
`medic_medic`.`meta_description` AS `meta_description`, `medic_medic`.`active` AS `active`, `medic_medic`.`date` AS `date`,
`medic_medic`.`lastname` AS `lastname`, `medic_medic`.`firstname` AS `firstname`, `medic_medic`.`middlename` AS `middlename`,
`medic_medic`.`image` AS `image`, `medic_medic`.`description` AS `description`, `medic_medic`.`stage` AS `stage`,
`medic_medic`.`rating_avg` AS `rating_avg`, `medic_medic`.`specialization_id` AS `specialization_id`, `medic_medic`.`testimonial_count` AS `testimonial_count`,
COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__count`, T6.`id` AS Col15, T6.`slug`,
T6.`name`, T6.`name_mn`, T6.`name_rod`,
T6.`name_im2`, T6.`description` AS Col21
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 20) GROUP BY `medic_medic`.`id` ORDER BY NULL) subquery

time: 0.003
        

SELECT `medic_medic`.`id`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 20) GROUP BY `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 4

time: 0.002
        

SELECT `medic_medic_specializations`.`medic_id`, `core_specialization`.`name`
FROM `core_specialization` INNER JOIN `medic_medic_specializations` ON ( `core_specialization`.`id` = `medic_medic_specializations`.`specialization_id` )
WHERE `medic_medic_specializations`.`medic_id` IN (123, 124,
125, 126) ORDER BY `core_specialization`.`name` ASC

time: 0.000
        

SELECT `core_setting`.`id`, `core_setting`.`meta_title`, `core_setting`.`meta_keywords`,
`core_setting`.`meta_description`, `core_setting`.`name`, `core_setting`.`from_email`,
`core_setting`.`notification_emails`, `core_setting`.`description`, `core_setting`.`static_block_id`,
`core_setting`.`phone_code`, `core_setting`.`phone_number`, `core_setting`.`worktime`,
`core_setting`.`address`, `core_setting`.`footer`, `core_setting`.`soc_facebook`,
`core_setting`.`soc_twitter`, `core_setting`.`soc_vkontakte`, `core_setting`.`soc_gplus`
FROM `core_setting`
WHERE `core_setting`.`id` = 1 LIMIT 21

time: 0.002
        

SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `core_specialization` INNER JOIN `clinic_clinic_specializations` ON ( `core_specialization`.`id` = `clinic_clinic_specializations`.`specialization_id` )
WHERE `clinic_clinic_specializations`.`clinic_id` = 24 ORDER BY `core_specialization`.`name` ASC

time: 0.002
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
T6.`id`, T6.`slug`, T6.`name`,
T6.`name_mn`, T6.`name_rod`, T6.`name_im2`,
T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 20) ORDER BY `medic_medic`.`date` DESC

time: 0.001
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
T6.`id`, T6.`slug`, T6.`name`,
T6.`name_mn`, T6.`name_rod`, T6.`name_im2`,
T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 21) ORDER BY `medic_medic`.`date` DESC

time: 0.001
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
T6.`id`, T6.`slug`, T6.`name`,
T6.`name_mn`, T6.`name_rod`, T6.`name_im2`,
T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 27) ORDER BY `medic_medic`.`date` DESC

time: 0.002
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
T6.`id`, T6.`slug`, T6.`name`,
T6.`name_mn`, T6.`name_rod`, T6.`name_im2`,
T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 53) ORDER BY `medic_medic`.`date` DESC

time: 0.001
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
T6.`id`, T6.`slug`, T6.`name`,
T6.`name_mn`, T6.`name_rod`, T6.`name_im2`,
T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 41) ORDER BY `medic_medic`.`date` DESC

time: 0.000
        

SELECT `core_setting`.`id`, `core_setting`.`meta_title`, `core_setting`.`meta_keywords`,
`core_setting`.`meta_description`, `core_setting`.`name`, `core_setting`.`from_email`,
`core_setting`.`notification_emails`, `core_setting`.`description`, `core_setting`.`static_block_id`,
`core_setting`.`phone_code`, `core_setting`.`phone_number`, `core_setting`.`worktime`,
`core_setting`.`address`, `core_setting`.`footer`, `core_setting`.`soc_facebook`,
`core_setting`.`soc_twitter`, `core_setting`.`soc_vkontakte`, `core_setting`.`soc_gplus`
FROM `core_setting`
WHERE `core_setting`.`id` = 1 LIMIT 21

time: 0.001
        

SELECT `core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `core_specialization` ORDER BY `core_specialization`.`name` ASC

time: 0.001
        

SELECT `core_metro`.`id`, `core_metro`.`position`, `core_metro`.`slug`,
`core_metro`.`name`, `core_metro`.`code`, `core_metro`.`line`,
`core_metro`.`latitude`, `core_metro`.`longitude`
FROM `core_metro` INNER JOIN `clinic_clinic_metro` ON ( `core_metro`.`id` = `clinic_clinic_metro`.`metro_id` )
WHERE `clinic_clinic_metro`.`clinic_id` = 24 ORDER BY `core_metro`.`position` ASC

time: 0.001
        

SELECT `core_city`.`id`, `core_city`.`position`, `core_city`.`slug`,
`core_city`.`name`, `core_city`.`region`, `core_city`.`latitude`,
`core_city`.`longitude`
FROM `core_city` INNER JOIN `clinic_clinic_cities` ON ( `core_city`.`id` = `clinic_clinic_cities`.`city_id` )
WHERE `clinic_clinic_cities`.`clinic_id` = 24 ORDER BY `core_city`.`position` ASC

time: 0.004
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__count`, T6.`id`, T6.`slug`,
T6.`name`, T6.`name_mn`, T6.`name_rod`,
T6.`name_im2`, T6.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T6 ON ( `medic_medic`.`specialization_id` = T6.`id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_clinics`.`clinic_id` = 24 AND `medic_medic_specializations`.`specialization_id` = 20) GROUP BY `medic_medic`.`id` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 4

time: 0.001
        

SELECT `medic_medic`.`id`, `medic_medic`.`meta_title`, `medic_medic`.`meta_keywords`,
`medic_medic`.`meta_description`, `medic_medic`.`active`, `medic_medic`.`date`,
`medic_medic`.`lastname`, `medic_medic`.`firstname`, `medic_medic`.`middlename`,
`medic_medic`.`image`, `medic_medic`.`description`, `medic_medic`.`stage`,
`medic_medic`.`rating_avg`, `medic_medic`.`specialization_id`, `medic_medic`.`testimonial_count`,
`core_specialization`.`id`, `core_specialization`.`slug`, `core_specialization`.`name`,
`core_specialization`.`name_mn`, `core_specialization`.`name_rod`, `core_specialization`.`name_im2`,
`core_specialization`.`description`
FROM `medic_medic` INNER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` ) INNER JOIN `core_specialization` ON ( `medic_medic`.`specialization_id` = `core_specialization`.`id` )
WHERE `medic_medic_clinics`.`clinic_id` = 24 ORDER BY `medic_medic`.`rating_avg` DESC, `medic_medic`.`date` DESC LIMIT 3