«МЕДРЕСЕ ЖАШТАРЫНЫН САНАРИПТИК ТЕХНОЛОГИЯЛАРДЫ КОЛДОНУУ ШЫКТАРЫН ӨРКҮНДӨТҮҮ» ДОЛБООРУ 2022-ЖЫЛЫ УЛАНТЫЛАТ

Дата публикации: 15 Февраль 2022.

“АВЕП” коомдук фонду Америка Кошмо Штатынын Кыргызстандагы элчилигинин каржылык колдоосу менен ишке ашырылып келген «Медресе жаштарынын санариптик технологияларды колдонуу шыктарын өркүндөтүү» долбоорун 2022-жылга карата улантуу максатында Кыргызстан мусулмандарынын дин башкармалыгы менен бирдикте медреселерди тандоо боюнча жарыя берген. Натыйжада Ош облусунан Өзгөн районундагы Мырзааке айылында жайгашкан “Абдраим кары” медресеси, Баткен шаарындагы “Муаз Ибн Жабаль” медресеси жана Ош облусунун Кара-Суу районундагы “Абдыжапар” ислам институту , Чүй облусунан Аламүдүн районунун Кой-Таш айылынан “Аль Фарух” медресеси, Сокулук районунун Жаңы-Жер айылынан “Равза” медресеси жана Талас шаарынан “Чет тилдер кыздар медресеси” компьютердик сабаттуулукту өркүндөтүү жана англис тилин өздөштүрүү боюнча долбоорго катышууга кызыгуусун билдиришип, мындан ары иштешүүгө тандалды. Эми бул медреселер долбоор алкагында өздөрүнүн окуучуларын акысыз компьютердик сабаттуулукту өркүндөтүү жана англис тилин өздөштүрүү боюнча курстардан өтө алышат.

русс.jpg

«Бул долбоор Кыргыз Республикасындагы АКШ Элчилиги тарабынан каржыланган. Бул жерде келтирилген сунуштар, корутундуулар жана пикирлер, авторлордун оюн гана билдирет. АКШ мамлекеттик департаментинин коз карашына дал келбеши мүмкүн»

#АВЕПКоомдукфонду

#Медресежаштарынынсанариптехнологияларынколдонуубоюнчаквалификациясынжогорулатуудолбоору

#ПовышениеквалификациивобластицифровыхтехнологийдлямолодежимедресефинансируемогоПосольствомСШАвКыргызстане

#usembassybishkek

#AVEPpublicfund

Консоль отладки Joomla!

18 SQL-запросов зафиксировано

SELECT `data` FROM `iafco_session` WHERE `session_id` = 'dgp4dcqmpl6e2md7f6vs7dpkh1'
DELETE FROM `iafco_session` WHERE `time` < '1714398807'
SELECT `session_id` FROM `iafco_session` WHERE `session_id` = 'dgp4dcqmpl6e2md7f6vs7dpkh1' LIMIT 0, 1
INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('dgp4dcqmpl6e2md7f6vs7dpkh1', 0, '1714399707')
SELECT b.id FROM iafco_usergroups AS a LEFT JOIN iafco_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `iafco_viewlevels`
SELECT COUNT(*) FROM `iafco_menu` WHERE home = 1 AND published = 1 AND client_id = 0
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM iafco_menu AS m LEFT JOIN iafco_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM iafco_categories as c LEFT JOIN iafco_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('ru-RU','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN (SELECT cat.id as id FROM iafco_categories AS cat JOIN iafco_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=508 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
SELECT alias, catid FROM iafco_content WHERE id = 508
SELECT a.rules FROM iafco_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SELECT b.rules FROM iafco_assets AS a LEFT JOIN iafco_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM iafco_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('ru-RU','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM iafco_content AS a LEFT JOIN iafco_categories AS c on c.id = a.catid LEFT JOIN iafco_users AS u on u.id = a.created_by LEFT JOIN iafco_categories as parent ON parent.id = c.parent_id LEFT JOIN iafco_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM iafco_categories AS cat JOIN iafco_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('ru-RU','*') AND a.id = 508 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-29 14:08:27') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-29 14:08:27') AND (a.state = 1 OR a.state =2)
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM iafco_categories as c LEFT JOIN iafco_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('ru-RU','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN (SELECT cat.id as id FROM iafco_categories AS cat JOIN iafco_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=13 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
UPDATE iafco_content SET hits = hits + 1 WHERE id = 508
SELECT params FROM iafco_extensions AS e WHERE e.element='com_widgetkit'
SELECT id,template FROM iafco_template_styles WHERE client_id=0 AND home=1
UPDATE `iafco_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714399707;s:18:\"session.timer.last\";i:1714399707;s:17:\"session.timer.now\";i:1714399707;s:24:\"session.client.forwarded\";s:10:\"3.15.202.4\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"cd17acccc90a36b26f8708518d579cee\";}' , `time` = '1714399707' WHERE `session_id` = 'dgp4dcqmpl6e2md7f6vs7dpkh1'

17 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

2 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM iafco_categories as c LEFT JOIN iafco_categories AS s ON (s.lft < c.lft AND s.rgt > c.rgt AND c.language in ('ru-RU','*')) OR (s.lft >= c.lft AND s.rgt <= c.rgt) LEFT JOIN (SELECT cat.id as id FROM iafco_categories AS cat JOIN iafco_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT b.rules FROM iafco_assets AS a LEFT JOIN iafco_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT a.rules FROM iafco_assets AS a
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM iafco_contact_details AS contact
1 × SELECT params FROM iafco_extensions AS e
1 × SELECT id,template FROM iafco_template_styles
1 × SELECT alias, catid FROM iafco_content
1 × SELECT `data` FROM `iafco_session`
1 × SELECT b.id FROM iafco_usergroups AS a LEFT JOIN iafco_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `iafco_viewlevels
1 × SELECT COUNT(*) FROM `iafco_menu`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM iafco_menu AS m LEFT JOIN iafco_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `session_id` FROM `iafco_session`

Прочие SQL-запросы:

1 × UPDATE `iafco_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714399707;s:18:\"session.timer.last\";i:1714399707;s:17:\"session.timer.now\";i:1714399707;s:24:\"session.client.forwarded\";s:10:\"3.15.202.4\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"cd17acccc90a36b26f8708518d579cee\";}' , `time` = '1714399707'
1 × UPDATE iafco_content SET hits = hits + 1
1 × INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('dgp4dcqmpl6e2md7f6vs7dpkh1', 0, '1714399707'
1 × DELETE FROM `iafco_session`

«МЕДРЕСЕ ЖАШТАРЫНЫН САНАРИПТИК ТЕХНОЛОГИЯЛАРДЫ КОЛДОНУУ ШЫКТАРЫН ӨРКҮНДӨТҮҮ» ДОЛБООРУ 2022-ЖЫЛЫ УЛАНТЫЛАТ

Программный офис в Бишкеке:

Программный офис в Балыкчы:

Программный офис в Оше:

Консоль отладки Joomla!

Сессия

__default

user

Результаты профилирования

Использование памяти

Запросы к базе данных

18 SQL-запросов зафиксировано

17 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

Прочие SQL-запросы: