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

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

Пан В. М.
Мануальный терапевт
Мануальный терапевт Подробнее
Ерохин А. В.
Мануальный терапевт
Мануальный терапевт Подробнее
Бобырь М. А.
Мануальный терапевт, Остеопат
Мануальный терапевт Подробнее
Горуля А. Г.
Мануальный терапевт, Ортопед
Остеопат Подробнее
Кузьмин Н. Г.
Мануальный терапевт
Мануальный терапевт Подробнее
Скоритченко А. А.
Мануальный терапевт
Мануальный терапевт Подробнее
Бобырь М. А.
Мануальный терапевт, Остеопат
Мануальный терапевт Подробнее
Гаврилин В. К.
Мануальный терапевт, Невролог, Остеопат
Невролог Подробнее
Онофрийчук В. Ф.
Мануальный терапевт, Ортопед
Мануальный терапевт Подробнее
Балабанова Ж. Н.
Мануальный терапевт, Невролог, Остеопат
Мануальный терапевт Подробнее
Ким В. В.
Мануальный терапевт, Невролог, Остеопат
Мануальный терапевт Подробнее
debug sql count: 9, sql time: 0,021
time: 0.000
        

SET SQL_AUTO_IS_NULL = 0

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.016
        

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`, T4.`id` AS Col15, T4.`slug`,
T4.`name`, T4.`name_mn`, T4.`name_rod`,
T4.`name_im2`, T4.`description` AS Col21
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T4 ON ( `medic_medic`.`specialization_id` = T4.`id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_specializations`.`specialization_id` = 20) GROUP BY `medic_medic`.`id` ORDER BY NULL) subquery

time: 0.002
        

SELECT `medic_medic`.`id`
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` )
WHERE (`medic_medic`.`active` = 1 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 11

time: 0.001
        

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 (22, 23,
118, 120, 121,
122, 123, 124,
125, 126, 134) 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.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` ORDER BY `core_specialization`.`name` ASC

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`, COUNT(`clinic_clinic_specializations`.`clinic_id`) AS `specialization_clinics__count`
FROM `core_specialization` LEFT OUTER JOIN `clinic_clinic_specializations` ON ( `core_specialization`.`id` = `clinic_clinic_specializations`.`specialization_id` ) GROUP BY `core_specialization`.`id` HAVING COUNT(`clinic_clinic_specializations`.`clinic_id`) > 0 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`,
COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__count`, T4.`id`, T4.`slug`,
T4.`name`, T4.`name_mn`, T4.`name_rod`,
T4.`name_im2`, T4.`description`
FROM `medic_medic` INNER JOIN `medic_medic_specializations` ON ( `medic_medic`.`id` = `medic_medic_specializations`.`medic_id` ) INNER JOIN `core_specialization` T4 ON ( `medic_medic`.`specialization_id` = T4.`id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` )
WHERE (`medic_medic`.`active` = 1 AND `medic_medic_specializations`.`specialization_id` = 20) GROUP BY `medic_medic`.`id` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 11