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

Клиника профессора Горбакова

Клиника профессора Горбакова

Прием специалистов:
Аллерголог, Гастроэнтеролог, Гепатолог, Гинеколог, Дерматолог, Инфекционист, Кардиолог, Косметолог, Массажист, Невролог, Ортопед, Проктолог, Психотерапевт, Ревматолог, Терапевт, УЗИ-специалист, Уролог, Флеболог, Хирург, Эндокринолог, Дерматовенеролог, Эндоскопист
Все специалисты
Город:
Красногорск
Адрес:
г.Красногорск, ул.Павшинская, д.2
Рейтинг:

Фотогалерея клиники


Для записи на прием обращайтесь по тел: +7 (495) 739-73-72

Клиника профессора Горбакова это многопрофильный лечебно-диагностический центр, который использует в своей деятельности только лучшие достижения медицины.

В центре представлен большой спектр услуг, включающий в себя:

  • стационар,
  • кабинеты консультативного приёма (отделение терапии),
  • кабинеты лечебного приёма (кардиолог, гинеколог, уролог, отоларинголог, эндокринолог, невролог),
  • кабинеты диагностики;

Режим работы:

ПН-ПТ с 09:00 до 20:00

СБ с 09:00 до 20:00

ВС с 09:00 до 14:00

Лицензии:
Прейскуранты:
Прайс лист

Отзывы

Птн, 03 января 2014 Михаил (Красногорск)
Посещал кабинет массажа в этой клинике. очень понравилось,приду еще,спасибо!
Чтв, 12 декабря 2013 Анна (Красногорск)
Хорошая клиника, делала узи. Все понравилось

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

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

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

На карте

Лучшие врачи

Горбаков В. В.
Гастроэнтеролог

Колышкин В. Ф.
Эндоскопист

Гуляев М. В.
Психотерапевт

debug sql count: 38, sql time: 0,051
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` = 15 LIMIT 21

time: 0.006
        

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` = 15 ORDER BY `core_specialization`.`name` ASC

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` = 15 AND `medic_medic_specializations`.`specialization_id` = 2) ORDER BY `medic_medic`.`date` DESC

time: 0.003
        

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` = 15 AND `medic_medic_specializations`.`specialization_id` = 6) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 8) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 9) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 50) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 11) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 14) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 15) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 16) 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` = 15 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 23) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 27) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 30) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 33) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 35) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 39) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 41) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 42) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 43) ORDER BY `medic_medic`.`date` DESC

time: 0.009
        

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` = 15 AND `medic_medic_specializations`.`specialization_id` = 44) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 45) 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` = 15 AND `medic_medic_specializations`.`specialization_id` = 51) ORDER BY `medic_medic`.`date` DESC

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` = 15 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` = 15 ORDER BY `core_city`.`position` ASC

time: 0.000
        

SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model`
FROM `django_content_type`
WHERE (`django_content_type`.`model` = 'clinic' AND `django_content_type`.`app_label` = 'clinic') LIMIT 21

time: 0.001
        

SELECT `file_image`.`id`, `file_image`.`position`, `file_image`.`content_type_id`,
`file_image`.`object_id`, `file_image`.`relation_field`, `file_image`.`title`,
`file_image`.`image`, `file_image`.`exturl`
FROM `file_image`
WHERE (`file_image`.`object_id` = 15 AND `file_image`.`content_type_id` = 28 AND `file_image`.`relation_field` = 'photos') ORDER BY `file_image`.`position` ASC

time: 0.000
        

SELECT `file_image`.`id`, `file_image`.`position`, `file_image`.`content_type_id`,
`file_image`.`object_id`, `file_image`.`relation_field`, `file_image`.`title`,
`file_image`.`image`, `file_image`.`exturl`
FROM `file_image`
WHERE (`file_image`.`object_id` = 15 AND `file_image`.`content_type_id` = 28 AND `file_image`.`relation_field` = 'photos') ORDER BY `file_image`.`position` ASC

time: 0.001
        

SELECT `file_image`.`id`, `file_image`.`position`, `file_image`.`content_type_id`,
`file_image`.`object_id`, `file_image`.`relation_field`, `file_image`.`title`,
`file_image`.`image`, `file_image`.`exturl`
FROM `file_image`
WHERE (`file_image`.`object_id` = 15 AND `file_image`.`content_type_id` = 28 AND `file_image`.`relation_field` = 'licenses') ORDER BY `file_image`.`position` ASC

time: 0.001
        

SELECT `file_image`.`id`, `file_image`.`position`, `file_image`.`content_type_id`,
`file_image`.`object_id`, `file_image`.`relation_field`, `file_image`.`title`,
`file_image`.`image`, `file_image`.`exturl`
FROM `file_image`
WHERE (`file_image`.`object_id` = 15 AND `file_image`.`content_type_id` = 28 AND `file_image`.`relation_field` = 'licenses') ORDER BY `file_image`.`position` ASC

time: 0.001
        

SELECT `file_file`.`id`, `file_file`.`position`, `file_file`.`active`,
`file_file`.`content_type_id`, `file_file`.`object_id`, `file_file`.`title`,
`file_file`.`file`
FROM `file_file`
WHERE (`file_file`.`object_id` = 15 AND `file_file`.`content_type_id` = 28 AND `file_file`.`active` = 1) ORDER BY `file_file`.`position` ASC

time: 0.000
        

SELECT `file_file`.`id`, `file_file`.`position`, `file_file`.`active`,
`file_file`.`content_type_id`, `file_file`.`object_id`, `file_file`.`title`,
`file_file`.`file`
FROM `file_file`
WHERE (`file_file`.`object_id` = 15 AND `file_file`.`content_type_id` = 28 AND `file_file`.`active` = 1) ORDER BY `file_file`.`position` ASC

time: 0.001
        

SELECT `testimonial_testimonial`.`id`, `testimonial_testimonial`.`content_type_id`, `testimonial_testimonial`.`object_id`,
`testimonial_testimonial`.`date`, `testimonial_testimonial`.`name`, `testimonial_testimonial`.`city`,
`testimonial_testimonial`.`description`, `testimonial_testimonial`.`published`, `testimonial_testimonial`.`rating`
FROM `testimonial_testimonial`
WHERE (`testimonial_testimonial`.`object_id` = 15 AND `testimonial_testimonial`.`content_type_id` = 28 AND `testimonial_testimonial`.`published` = 1) ORDER BY `testimonial_testimonial`.`date` DESC LIMIT 3

time: 0.002
        

SELECT `testimonial_testimonial`.`id`, `testimonial_testimonial`.`content_type_id`, `testimonial_testimonial`.`object_id`,
`testimonial_testimonial`.`date`, `testimonial_testimonial`.`name`, `testimonial_testimonial`.`city`,
`testimonial_testimonial`.`description`, `testimonial_testimonial`.`published`, `testimonial_testimonial`.`rating`
FROM `testimonial_testimonial`
WHERE (`testimonial_testimonial`.`object_id` = 15 AND `testimonial_testimonial`.`content_type_id` = 28 AND `testimonial_testimonial`.`published` = 1) ORDER BY `testimonial_testimonial`.`date` DESC LIMIT 3

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` = 15 ORDER BY `medic_medic`.`rating_avg` DESC, `medic_medic`.`date` DESC LIMIT 3