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

Врачи Хирурги

Центр семейной медицины "София"

Прием специалистов:
Аллерголог, Андролог, Сексолог, Гинеколог, Уролог, Дерматолог, Хирург, Эндокринолог, Кардиолог, Флеболог, Лор (отоларинголог), Маммолог, УЗИ-специалист, Невролог, Окулист (офтальмолог), Ортопед, Педиатр
Все специалисты
Метро:
Митино
Адрес:
г. Москва, м. Митино, улица Митинская дом 17 корпус 4.
Рейтинг:
Никифоров Д. Л.
Маммолог, Онколог, Хирург

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

Центр семейной медицины "София"
Записаться на прием
тел. (495) 646 71 97
или оставить заявку

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

На карте

Лучшие врачи

Шапиевский Б. М.
Гинеколог

Антясова Т. В.
Акушер-гинеколог

Маркович Т. Н.
Дерматолог

debug sql count: 11, sql time: 0,015
time: 0.000
        

SET SQL_AUTO_IS_NULL = 0

time: 0.000
        

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` = 27 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` = 'hirurg' LIMIT 21

time: 0.001
        

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` = 27 AND `medic_medic_specializations`.`specialization_id` = 44) GROUP BY `medic_medic`.`id` ORDER BY NULL) subquery

time: 0.001
        

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` = 27 AND `medic_medic_specializations`.`specialization_id` = 44) 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 1

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 (141) ORDER BY `core_specialization`.`name` ASC

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

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` = 27 ORDER BY `core_metro`.`position` ASC

time: 0.000
        

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

time: 0.010
        

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` = 27 AND `medic_medic_specializations`.`specialization_id` = 44) GROUP BY `medic_medic`.`id` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 1

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