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

Врачи

Колачов Ю. А.
Кардиолог, Пульмонолог, Терапевт
Терапевт Подробнее
Онофрийчук В. Ф.
Мануальный терапевт, Ортопед
Мануальный терапевт Подробнее
Кузнецов В. М.
Терапевт, УЗИ-специалист
Трихолог Подробнее
Шапиевский Б. М.
Акушер-гинеколог, Гинеколог
Гинеколог Подробнее
Антясова Т. В.
Акушер-гинеколог, Гинеколог
Акушер-гинеколог Подробнее
Назаренко В. Ф.
Дерматовенеролог, Сексолог
Дерматовенеролог Подробнее
Никифоров Д. Л.
Маммолог, Онколог, Хирург
debug sql count: 7, sql time: 0,015
time: 0.000
        

SET SQL_AUTO_IS_NULL = 0

time: 0.004
        

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

time: 0.004
        

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

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 (131, 132,
133, 134, 135,
136, 137, 138,
139, 140, 141) ORDER BY `core_specialization`.`name` ASC

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` 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`, 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.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`,
COUNT(`medic_medic_clinics`.`clinic_id`) AS `clinics__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 `core_specialization` ON ( `medic_medic`.`specialization_id` = `core_specialization`.`id` ) LEFT OUTER JOIN `medic_medic_clinics` ON ( `medic_medic`.`id` = `medic_medic_clinics`.`medic_id` )
WHERE `medic_medic`.`active` = 1 GROUP BY `medic_medic`.`id` ORDER BY `medic_medic`.`rating_avg` DESC LIMIT 11 OFFSET 120