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

Врачи

Горбаков В. В.
Гастроэнтеролог, Гепатолог
Гастроэнтеролог Подробнее
Рахимов Р. Т.
Лор (отоларинголог), Пластический хирург
Лор (отоларинголог) Подробнее
Брега М. Г.
Акушер-гинеколог, Гинеколог, Эндокринолог
Гинеколог Подробнее
debug sql count: 8, sql time: 0,016
time: 0.000
        

SET SQL_AUTO_IS_NULL = 0

time: 0.000
        

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

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 12 OFFSET 72

time: 0.003
        

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 (89, 83,
82, 80, 81,
79, 69, 70,
71, 72, 73,
74) 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.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_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.005
        

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 12 OFFSET 72