Алматинская область

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Category`.`id`, `Category`.`region_name`, `Category`.`alias`, `Category`.`count_mo`, `Category`.`count_gobmp`, `Category`.`count_mo_accredit`, `Category`.`procent_mo_accredit`, `Category`.`count_no_mo_accredit`, `Category`.`procent_no_mo_accredit`, `Category`.`map_code`, `Category`.`total_mo`, `Category`.`accredited`, `Category`.`no_status`, `Category`.`recalled`, `Category`.`region_exp`, `Category`.`denied`, `Category`.`doc`, `Category`.`created`, `Category`.`modified`, (`I18n__region_name__en`.`content`) AS `Category__i18n_region_name_en`, (`I18n__region_name__kz`.`content`) AS `Category__i18n_region_name_kz`, (`I18n__titleTranslation__en`.`content`) AS `Category__i18n_titleTranslation_en`, (`I18n__titleTranslation__kz`.`content`) AS `Category__i18n_titleTranslation_kz` FROM `acqhkz_new`.`categories` AS `Category` LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__en` ON (`Category`.`id` = `I18n__region_name__en`.`foreign_key` AND `I18n__region_name__en`.`model` = 'Category' AND `I18n__region_name__en`.`field` = 'region_name' AND `I18n__region_name__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__kz` ON (`Category`.`id` = `I18n__region_name__kz`.`foreign_key` AND `I18n__region_name__kz`.`model` = 'Category' AND `I18n__region_name__kz`.`field` = 'region_name' AND `I18n__region_name__kz`.`locale` = 'kz') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__en` ON (`Category`.`id` = `I18n__titleTranslation__en`.`foreign_key` AND `I18n__titleTranslation__en`.`model` = 'Category' AND `I18n__titleTranslation__en`.`field` = 'title' AND `I18n__titleTranslation__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__kz` ON (`Category`.`id` = `I18n__titleTranslation__kz`.`foreign_key` AND `I18n__titleTranslation__kz`.`model` = 'Category' AND `I18n__titleTranslation__kz`.`field` = 'title' AND `I18n__titleTranslation__kz`.`locale` = 'kz') WHERE `Category`.`alias` = 'almaty' LIMIT 1	1	1	2	maybe slow
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'Category' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (3) ORDER BY `id` ASC	1	1	2	maybe slow
SELECT `Map`.`id`, `Map`.`name`, `Map`.`region_id`, `Map`.`ownership`, `Map`.`accreditation_year`, `Map`.`date_beginning_accred`, `Map`.`date_end_accred`, `Map`.`status`, `Map`.`category_type`, `Map`.`quarter`, `Map`.`type_organiztion`, `Map`.`created`, `Map`.`modified`, (`I18n__name`.`content`) AS `Map__i18n_name`, (`I18n__category_type`.`content`) AS `Map__i18n_category_type` FROM `acqhkz_new`.`maps` AS `Map` INNER JOIN `acqhkz_new`.`i18n` AS `I18n__name` ON (`Map`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Map' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'ru') INNER JOIN `acqhkz_new`.`i18n` AS `I18n__category_type` ON (`Map`.`id` = `I18n__category_type`.`foreign_key` AND `I18n__category_type`.`model` = 'Map' AND `I18n__category_type`.`field` = 'category_type' AND `I18n__category_type`.`locale` = 'ru') WHERE `Map`.`region_id` = 3	69	69	64	maybe slow

Message	Memory use
Component initialization	1.49 MB
Controller action start	1.63 MB
Controller render start	2.69 MB
View render complete	3.23 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	142.84
Event: Controller.initialize	0.14
Event: Controller.startup	11.76
Controller action	231.88
Event: Controller.beforeRender	20.39
» Processing toolbar data	20.26
Rendering View	5.51
» Event: View.beforeRender	0.05
» Rendering APP/View/Maps/view.ctp	1.31
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/index.ctp	1.19
Event: View.afterLayout	0.00

View Variables

data(array)
- 0(array)
  - Map(array)
    - id57
    - nameТОО "НЕФРОС АЗИЯ"
    - region_id3
    - ownershipгосударственная
    - accreditation_year2018
    - date_beginning_accred2018-06-21
    - date_end_accred2021-06-22
    - statusАккредитована
    - category_typeПервая категория
    - quarter2
    - type_organiztionфилиал
    - created2020-06-09 00:30:33
    - modified2020-06-09 00:30:33
    - localeru
- 1(array)
  - Map(array)
    - id58
    - nameТОО "Фрезениус Медикал Кейр Казахстан" г. Талгар
    - region_id3
    - ownershipчастная
    - accreditation_year2018
    - date_beginning_accred2018-03-29
    - date_end_accred2021-04-11
    - statusАккредитована
    - category_typeВторая категория
    - quarter1
    - type_organiztionфилиал
    - created2020-06-09 00:31:30
    - modified2020-06-09 00:31:30
    - localeru
- 2(array)
  - Map(array)
    - id59
    - nameТОО "ID SENIM R"
    - region_id3
    - ownershipчастная
    - accreditation_year2018
    - date_beginning_accred2018-06-21
    - date_end_accred2018-06-22
    - statusАккредитована
    - category_typeПервая категория
    - quarter2
    - type_organiztionфилиал
    - created2020-06-09 00:32:15
    - modified2020-06-09 00:32:15
    - localeru
- 3(array)
  - Map(array)
    - id61
    - nameФилиал ТОО "Медицинский центр ХАК" в городе Талдыкорган
    - region_id3
    - ownershipчастная
    - accreditation_year2018
    - date_beginning_accred2018-05-30
    - date_end_accred2021-05-30
    - statusАккредитована
    - category_typeВторая категория
    - quarter2
    - type_organiztionфилиал
    - created2020-06-09 00:33:05
    - modified2020-06-09 00:33:05
    - localeru
- 4(array)
  - Map(array)
    - id62
    - nameТОО "DN MEDICUS PHARM"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 00:33:23
    - modified2020-06-09 00:33:23
    - localeru
- 5(array)
  - Map(array)
    - id114
    - nameГКП на ПХВ «Областная стоматологическая поликлиника»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:10:59
    - modified2020-06-09 01:10:59
    - localeru
- 6(array)
  - Map(array)
    - id117
    - nameГКП на ПХВ «Алматинская многопрофильная клиническая больница»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2017
    - date_beginning_accred2017-07-19
    - date_end_accred2020-07-25
    - statusАккредитована
    - category_typeВторая категория
    - quarter3
    - type_organiztionголовной
    - created2020-06-09 01:11:55
    - modified2020-06-09 01:11:55
    - localeru
- 7(array)
  - Map(array)
    - id120
    - nameГКП на ПХВ «Областная больница города Талдыкорган»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2017
    - date_beginning_accred2017-12-08
    - date_end_accred2020-12-08
    - statusАккредитована
    - category_typeВторая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:13:28
    - modified2020-06-09 01:15:35
    - localeru
- 8(array)
  - Map(array)
    - id121
    - nameГКП на ПХВ «Талдыкорганская городская многопрофильная больница»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2017
    - date_beginning_accred2017-12-08
    - date_end_accred2020-12-08
    - statusАккредитована
    - category_typeПервая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:14:21
    - modified2020-06-09 01:14:21
    - localeru
- 9(array)
  - Map(array)
    - id127
    - nameИП "МЦ Құрақты"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:17:35
    - modified2020-06-09 01:17:35
    - localeru
- 10(array)
  - Map(array)
    - id129
    - nameНУ МЦ "Нур-Авиценум"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:17:48
    - modified2020-06-09 01:17:48
    - localeru
- 11(array)
  - Map(array)
    - id131
    - nameТОО "Диализный центр УР"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:22:02
    - modified2020-06-09 01:22:02
    - localeru
- 12(array)
  - Map(array)
    - id132
    - nameТОО "NEPHRO LIFE PLUS"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:22:26
    - modified2020-06-09 01:22:26
    - localeru
- 13(array)
  - Map(array)
    - id133
    - nameТОО "NEPHRO LIFE QAZ"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:24:11
    - modified2020-06-09 01:24:11
    - localeru
- 14(array)
  - Map(array)
    - id134
    - nameТОО "АР-АБАТ"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:24:29
    - modified2020-06-09 01:24:29
    - localeru
- 15(array)
  - Map(array)
    - id136
    - nameТОО "ЖАРКЕНТ-ДАУА"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:24:41
    - modified2020-06-09 01:24:41
    - localeru
- 16(array)
  - Map(array)
    - id138
    - nameТОО "TABIBMED"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:24:56
    - modified2020-06-09 01:24:56
    - localeru
- 17(array)
  - Map(array)
    - id139
    - nameГКП на ПХВ «Алматинская областная больница паллиативной помощи»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:25:11
    - modified2020-06-09 01:25:11
    - localeru
- 18(array)
  - Map(array)
    - id140
    - nameГКП на ПХВ «Кегенская РБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:25:29
    - modified2020-06-09 01:25:29
    - localeru
- 19(array)
  - Map(array)
    - id144
    - nameГКП на ПХВ «Карасайская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2019
    - date_beginning_accred2019-08-09
    - date_end_accred2022-08-09
    - statusАккредитована
    - category_typeВторая категория
    - quarter3
    - type_organiztionголовной
    - created2020-06-09 01:26:11
    - modified2020-06-09 01:26:11
    - localeru
- 20(array)
  - Map(array)
    - id146
    - nameГКП на ПХВ «Областной кардиологический центр»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2017
    - date_beginning_accred2017-12-08
    - date_end_accred2020-12-08
    - statusАккредитована
    - category_typeПервая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:28:00
    - modified2020-06-09 01:28:00
    - localeru
- 21(array)
  - Map(array)
    - id147
    - nameГКП на ПХВ «РБ» с.Каргалы Жамбылского района
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:28:38
    - modified2020-06-09 01:28:38
    - localeru
- 22(array)
  - Map(array)
    - id148
    - nameГКП на ПХВ «Талдыкорганская городская поликлиника № 2»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:28:55
    - modified2020-06-09 01:28:55
    - localeru
- 23(array)
  - Map(array)
    - id149
    - nameГКП на ПХВ «Уйгурская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:29:11
    - modified2020-06-09 01:29:11
    - localeru
- 24(array)
  - Map(array)
    - id150
    - nameГКП на ПХВ «Аксуская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2018
    - date_beginning_accred2018-12-21
    - date_end_accred2021-12-24
    - statusАккредитована
    - category_typeВторая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:29:52
    - modified2020-06-09 01:29:52
    - localeru
- 25(array)
  - Map(array)
    - id151
    - nameГКП на ПХВ "Балхашская ЦРБ" ГУ "
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:31:45
    - modified2020-06-09 01:31:45
    - localeru
- 26(array)
  - Map(array)
    - id153
    - nameГКП на ПХВ «Текелийская городская больница»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2019
    - date_beginning_accred2019-04-09
    - date_end_accred2022-04-10
    - statusАккредитована
    - category_typeВторая категория
    - quarter2
    - type_organiztionголовной
    - created2020-06-09 01:34:00
    - modified2020-06-09 01:34:00
    - localeru
- 27(array)
  - Map(array)
    - id155
    - nameГКП на ПХВ "Алакольская ЦРБ"
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:34:21
    - modified2020-06-09 01:34:21
    - localeru
- 28(array)
  - Map(array)
    - id158
    - nameГКП на ПХВ "Алматинская региональная детская клиническая больница"
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:37:15
    - modified2020-06-09 01:37:15
    - localeru
- 29(array)
  - Map(array)
    - id161
    - nameГКП на ПХВ "Ескельдинская ЦРБ"
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:39:01
    - modified2020-06-09 01:39:01
    - localeru
- 30(array)
  - Map(array)
    - id162
    - nameГКП на ПХВ «Жамбылская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:39:14
    - modified2020-06-09 01:39:14
    - localeru
- 31(array)
  - Map(array)
    - id163
    - nameГКП на ПХВ «Илийская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2018
    - date_beginning_accred2018-11-09
    - date_end_accred2021-11-13
    - statusАккредитована
    - category_typeВторая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:39:56
    - modified2020-06-09 01:39:56
    - localeru
- 32(array)
  - Map(array)
    - id170
    - nameГКП на ПХВ «Капшагайская городская больница»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2019
    - date_beginning_accred2019-06-25
    - date_end_accred2022-06-26
    - statusАккредитована
    - category_typeВторая категория
    - quarter2
    - type_organiztionголовной
    - created2020-06-09 01:43:02
    - modified2020-06-09 01:43:02
    - localeru
- 33(array)
  - Map(array)
    - id172
    - nameГКП на ПХВ «Каратальская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:43:20
    - modified2020-06-09 01:43:20
    - localeru
- 34(array)
  - Map(array)
    - id174
    - nameГКП на ПХВ «Коксуская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:43:56
    - modified2020-06-09 01:43:56
    - localeru
- 35(array)
  - Map(array)
    - id176
    - nameГКП на ПХВ «Многопрофильная областная детская больница»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:44:27
    - modified2020-06-09 01:44:27
    - localeru
- 36(array)
  - Map(array)
    - id185
    - nameГКП на ПХВ «РБ» с. Боралдай Илийского района
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:47:15
    - modified2020-06-09 01:47:15
    - localeru
- 37(array)
  - Map(array)
    - id187
    - nameГКП на ПХВ «РБ» села Щелек Енбекшиказахского района
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:47:41
    - modified2020-06-09 01:47:41
    - localeru
- 38(array)
  - Map(array)
    - id189
    - nameГКП на ПХВ «Саркандская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:47:54
    - modified2020-06-09 01:47:54
    - localeru
- 39(array)
  - Map(array)
    - id190
    - nameГКП на ПХВ «Талгарская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusОтозвали
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:48:07
    - modified2020-06-09 01:48:07
    - localeru
- 40(array)
  - Map(array)
    - id194
    - nameГКП на ПХВ «Талдыкорганская городская поликлиника»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2019
    - date_beginning_accred2019-12-25
    - date_end_accred2022-12-26
    - statusАккредитована
    - category_typeПервая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:48:50
    - modified2020-06-09 01:48:50
    - localeru
- 41(array)
  - Map(array)
    - id196
    - nameКГП на ПХВ «Енбекшиказахская многопрофильная межРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year2019
    - date_beginning_accred2019-12-25
    - date_end_accred2022-12-28
    - statusАккредитована
    - category_typeПервая категория
    - quarter4
    - type_organiztionголовной
    - created2020-06-09 01:49:37
    - modified2020-06-09 01:49:37
    - localeru
- 42(array)
  - Map(array)
    - id199
    - nameКГП на ПХВ «Детский реабилитационный фтизио-пульмонологический санаторий «Шымбулак»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:49:56
    - modified2020-06-09 01:49:56
    - localeru
- 43(array)
  - Map(array)
    - id200
    - nameКГП на ПХВ «Панфиловская многопрофильная межрайонная больница» (Жаркентский родильный дом)
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:50:14
    - modified2020-06-09 01:50:14
    - localeru
- 44(array)
  - Map(array)
    - id202
    - nameТОО "QAZPOCT (POINT OF CARE)"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 01:50:31
    - modified2020-06-09 01:50:31
    - localeru
- 45(array)
  - Map(array)
    - id246
    - nameТОО "Реабилитационно-санаторный комплекс Аквамед+"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:08:45
    - modified2020-06-09 02:08:45
    - localeru
- 46(array)
  - Map(array)
    - id270
    - nameТОО "Талмед"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:13:05
    - modified2020-06-09 02:13:05
    - localeru
- 47(array)
  - Map(array)
    - id273
    - nameТОО "Даулет-Центр"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusОтозвали
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:13:31
    - modified2020-06-09 02:13:31
    - localeru
- 48(array)
  - Map(array)
    - id310
    - nameТОО "Зире"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:22:21
    - modified2020-06-09 02:22:21
    - localeru
- 49(array)
  - Map(array)
    - id313
    - nameТОО МЦ "НУР" Ортохирургия"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:22:55
    - modified2020-06-09 02:22:55
    - localeru
- 50(array)
  - Map(array)
    - id315
    - nameКГП на ПХВ «Областная многопрофильная клиника»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:23:08
    - modified2020-06-09 02:23:08
    - localeru
- 51(array)
  - Map(array)
    - id339
    - nameГКП на ПХВ «Райымбекская РБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:31:09
    - modified2020-06-09 02:31:09
    - localeru
- 52(array)
  - Map(array)
    - id342
    - nameТОО МЦ "ЖАНҰЯ ЖҰМАБЕК МЕД"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:31:21
    - modified2020-06-09 02:31:21
    - localeru
- 53(array)
  - Map(array)
    - id343
    - nameГКП на ПХВ «Кербулакская ЦРБ»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:31:36
    - modified2020-06-09 02:31:36
    - localeru
- 54(array)
  - Map(array)
    - id346
    - nameГКП на ПХВ «Алматинский областной кожно-венерологический диспансер»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:32:25
    - modified2020-06-09 02:32:25
    - localeru
- 55(array)
  - Map(array)
    - id347
    - nameГКП на ПХВ «Талдыкорганский кожно-венерологический диспансер»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:32:46
    - modified2020-06-09 02:32:46
    - localeru
- 56(array)
  - Map(array)
    - id352
    - nameТОО "Ас-Ди МЕД"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:33:28
    - modified2020-06-09 02:33:28
    - localeru
- 57(array)
  - Map(array)
    - id353
    - nameЧУ «Каскеленский платный медицинский центр»
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:33:43
    - modified2020-06-09 02:33:43
    - localeru
- 58(array)
  - Map(array)
    - id355
    - nameКГП на ПХВ «Региональная инфекционная больница г. Талдыкорган»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:33:59
    - modified2020-06-09 02:33:59
    - localeru
- 59(array)
  - Map(array)
    - id357
    - nameКГП на ПХВ «Областной центр психического здоровья»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:34:09
    - modified2020-06-09 02:34:09
    - localeru
- 60(array)
  - Map(array)
    - id358
    - nameКГП на ПХВ «Областной противотуберкулезный диспансер»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:34:24
    - modified2020-06-09 02:34:24
    - localeru
- 61(array)
  - Map(array)
    - id361
    - nameТОО "Консультант Биотех"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:34:38
    - modified2020-06-09 02:34:38
    - localeru
- 62(array)
  - Map(array)
    - id363
    - nameГКП на ПХВ «Областная станция скорой и неотложной медицинской помощи»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:34:53
    - modified2020-06-09 02:34:53
    - localeru
- 63(array)
  - Map(array)
    - id364
    - nameГКП на ПХВ «Областной перинатальный центр»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:35:03
    - modified2020-06-09 02:35:03
    - localeru
- 64(array)
  - Map(array)
    - id367
    - nameТОО "Коксу Мед"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:35:24
    - modified2020-06-09 02:35:24
    - localeru
- 65(array)
  - Map(array)
    - id368
    - nameГКП на ПХВ «Областная больница города Талдыкорган»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:36:02
    - modified2020-06-09 02:36:02
    - localeru
- 66(array)
  - Map(array)
    - id370
    - nameТОО "Аккорд KZ"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:36:15
    - modified2020-06-09 02:36:15
    - localeru
- 67(array)
  - Map(array)
    - id372
    - nameТОО "Cанаторно-оздоровительный, реабилитационный центр "Акжанель"
    - region_id3
    - ownershipчастная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:36:27
    - modified2020-06-09 02:36:27
    - localeru
- 68(array)
  - Map(array)
    - id373
    - nameГКП на ПХВ «областной центр крови»
    - region_id3
    - ownershipгосударственная
    - accreditation_year(null)
    - date_beginning_accred(null)
    - date_end_accred(null)
    - statusБез статуса
    - category_type
    - quarter(null)
    - type_organiztionголовной
    - created2020-06-09 02:36:43
    - modified2020-06-09 02:36:43
    - localeru
region_id(array)
- Category(array)
  - id3
  - region_nameАлматинская область
  - aliasalmaty
  - count_mo49
  - count_gobmp49
  - count_mo_accredit12
  - procent_mo_accredit25
  - count_no_mo_accredit37
  - procent_no_mo_accredit75
  - map_code<svg width="214" height="170" viewBox="0 0 214 170" fill="none" xmlns="http://www.w3.org/2000/svg"> <path d="M112.766 4.86384L116.837 8.03454L119.868 8.29777L121.044 11.2172L131.747 10.0566L139.295 20.2866L150.741 16.4219L155.876 18.4798L155.777 20.8728L170.997 28.1475L178.47 28.3269L179.819 30.3131L182.306 29.4277L183.791 32.0121L184.868 30.5405L185.573 30.5524L184.67 31.9164L185.474 32.0839L187.157 32.73L188.505 31.3182L188.06 32.4907L186.847 33.3641L188.233 33.5197L187.379 34.6085L195.348 43.642L197.229 50.5218L201.127 54.6257L200.681 61.5414L201.56 62.2832L204.047 61.4218L207.462 63.9583L211.954 65.2745L212.597 67.6435L211.681 71.8671L209.132 75.5044L204.814 72.0226L203.527 71.7116L196.363 74.3199L195.002 72.597L193.096 72.7405L192.366 69.3904L190.003 67.4161L188.481 67.8349L185.09 70.4313L183.902 70.6228L183.383 70.0125L182.232 71.0654L181.217 70.6826L180.487 71.3526L178.817 71.4005L177.394 72.5491L175.983 72.2739L175.253 73.7336L172.283 73.9729L170.823 75.1814L166.938 73.7575L166.158 74.954L163.993 75.8394L160.726 75.6001L158.586 77.9931L156.841 77.2752L154.688 78.4358L151.409 77.8376L151.434 79.1178L150.716 78.9982L145.618 82.9824L148.489 83.4132L149.194 85.4353L150.172 85.9497L156.148 84.6934L156.383 85.5071L157.621 85.3275L158.19 86.4164L161.023 88.1752L161.147 89.0367L158.116 90.6639L159.143 92.1954L157.67 96.3472L159.464 107.714L161.927 117.214L167.346 129.215L165.354 134.096L167.656 134.479L168.646 138.093L168.101 139.074L163.684 139.612L158.771 142.532L159.143 144.219L161.036 145.666L163.09 146.181L163.56 147.222L161.432 147.521L158.994 149.232L155.641 149.196L154.688 153.097L153.463 155.238L154.478 158.038L156.111 159.031L154.49 160.742L154.923 164.176L156.049 164.954L155.765 165.899L156.346 166.677L156.136 167.825L155.344 168.268L154.181 167.945L152.287 168.747L152.325 166.653L151.483 164.906L149.021 163.434L147.994 161.556L146.558 161.46L146.014 162.01L145.655 161.293L141.374 160.252L140.211 161.041L137.662 160.898L134.024 156.734L130.671 154.688L129.681 153.013V150.608L127.812 151.027L127.181 151.984L126.018 150.823L123.704 150.871L118.742 149.124L117.851 149.435L117.171 148.55L114.708 148L113.236 146.827L111.145 147.665L110.378 147.389L109.375 148.347L105.7 147.533L105.205 148.275L104.005 148.071L102.842 148.885L101.939 147.976L100.664 148.526L99.8971 147.724L96.9892 147.401L96.2716 146.612L88.2287 145.81L83.6628 146.516L81.6458 145.056L75.7188 144.314L73.7266 144.338L71.5488 145.487L70.7693 146.779L65.7579 146.348L65.065 147.294L61.7488 148.035L59.8556 146.336L54.2628 146.636L51.6642 145.224L48.9421 145.93L48.5089 144.829L47.2592 145.355L45.9229 144.542L43.5966 144.793L43.3243 144.278L44.7102 143.872L45.3536 142.603L38.4986 140.067L37.9294 137.793L37.0014 137.399L37.3355 136.023L36.4198 135.496L36.692 132.792L39.8845 129.047L39.0183 127.635L35.4175 128.066L35.7764 126.953L33.5986 127.324L29.54 125.948L29.5277 123.89L35.7021 118.638L36.2713 117.142L35.7145 114.833L37.3231 112.26L37.2117 108.264L34.7123 106.613L33.3511 104.83L31.8539 104.627L29.1441 102.533L23.7738 101.971L19.1832 97.7232L18.4036 96.5387L19.5049 92.6142L17.2034 88.7734L9.48218 83.5448L8.07155 81.0322L7.87361 77.0359L1.1299 76.8684L0.696777 70.7543L7.96023 71.2688L6.64854 67.9307L5.60919 55.7265L7.8983 51.9934L11.9322 44.5513L26.3476 30.7558L40.0948 23.1102L45.8238 24.223L53.1739 22.9069L61.3777 24.3067L61.3529 25.2879L62.7387 25.6468L64.3845 23.7683L65.0526 25.7186L65.7951 24.8452L67.9852 25.6109L68.74 23.888L76.1643 26.3288L73.5658 23.7922L75.2363 23.4931L77.7729 24.7495L80.161 24.4264L82.5615 25.6588L83.3534 27.621L85.1599 27.3578L85.1229 25.228L92.411 24.4384L91.3716 6.87395L92.0274 5.70138L98.239 7.04143L101.766 3.21268L104.834 6.33551L108.707 1.56152L112.766 4.86384Z" fill="#226494" stroke="#104E7A" stroke-width="1.16612"/> </svg>
  - total_mo49 (100%)
  - accredited12 (25%)
  - no_status37 (75%)
  - recalled2
  - region_exp5
  - denied1
  - doc(null)
  - created2020-05-27 22:39:56
  - modified2020-12-30 09:18:55
  - localeen
  - title
- titleTranslation(array)
  - 0(array)
    - id55
    - localeru
    - modelCategory
    - foreign_key3
    - fieldtitle
    - content
title_for_layoutАлматинская область
admin(false)
lang
lru
controllermaps
$request->data(empty)
$this->validationErrors(array)
- Map(empty)
- I18nModel(empty)
- Category(empty)
- titleTranslation(empty)
Loaded Helpers(array)
- 0Html
- 1Form
- 2Session
- 3Common
- 4Number
- 5SimpleGraph
- 6DebugTimer
- 7Toolbar
- 8HtmlToolbar

====

Constant	Value
APP	/var/www/vhosts/acqh.kz/new.acqh.kz/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/acqh.kz/new.acqh.kz/app/Lib/
CACHE	/var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/cache/
CAKE	/var/www/vhosts/acqh.kz/new.acqh.kz/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/acqh.kz/new.acqh.kz/lib
CORE_PATH	/var/www/vhosts/acqh.kz/new.acqh.kz/lib/
CAKE_VERSION	2.6.2
CSS	/var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://acqh.kz
IMAGES	/var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/logs/
ROOT	/var/www/vhosts/acqh.kz/new.acqh.kz
TESTS	/var/www/vhosts/acqh.kz/new.acqh.kz/app/Test/
TMP	/var/www/vhosts/acqh.kz/new.acqh.kz/app/tmp/
VENDORS	/var/www/vhosts/acqh.kz/new.acqh.kz/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Pp Custom Php Ini	/var/www/vhosts/system/acqh.kz/etc/php.ini
Pp Custom Php Cgi Index	plesk-php56-fastcgi
Script Name	/app/webroot/index.php
Request Uri	/maps/view/almaty
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/maps/view/almaty
Remote Port	3402
Script Filename	/var/www/vhosts/acqh.kz/new.acqh.kz/app/webroot/index.php
Server Admin	acofqh@yandex.kz
Context Document Root	/var/www/vhosts/acqh.kz/new.acqh.kz
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/acqh.kz/new.acqh.kz
Remote Addr	18.234.247.75
Server Port	443
Server Addr	195.210.46.38
Server Name	acqh.kz
Server Software	Apache
Server Signature
Http Accept Encoding	br,gzip
Http If Modified Since	Fri, 07 Aug 2020 20:27:10 GMT
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Real Ip	18.234.247.75
Http Host	acqh.kz
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	YAx3XXCFdAs5-0NG11QtZAAAAD0
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	YAx3XXCFdAs5-0NG11QtZAAAAD0
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Unique Id	YAx3XXCFdAs5-0NG11QtZAAAAD0
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1611429726.0505
Request Time	1611429726

default

Total Time: 68 ms
Total Queries: 3 queries

Query Explain:

Memory

Timers

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 68 ms Total Queries: 3 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 68 ms
Total Queries: 3 queries