ИСТОРИЯ УСПЕХА

Дата публикации: 29 Июль 2021.

Ассаламу алейкум ва рахматуллахи ва баракаатух!

Я, Кубанычбеков Нурсултан, учусь на втором курсе Исламского института имени «Кутайба ибн Муслим». Я был участником проекта D-STAR «Повышение квалификации молодежи медресе по использованию цифровых технологий», финансируемый посольством США в Кыргызстане и реализуемый общественным фондом AVEP. В рамках этого проекта я освоил навыки компьютерной грамотности и получил сертификат. Я ещё раньше интересовался компьютерами, и навыки, которую я получил, была для меня очень полезной. Есть такая поговорка «Ремесло к лицу всякому молодцу», в медресе я получаю религиозное образование, теперь у меня есть шанс устроится на работу.

Курс был очень интересным. Учитель доступно и легко объяснял. На курсе мы сначала познакомились с компьютером, а потом ознакомились с необходимыми для современной жизни офисными программами. В настоящее время студенты этого курса выполняют компьютерные работы для института.

Этот проект помогает многим студентам медресе научиться рабочим навыкам. За эту активную, неустанную работу мы хотели бы поблагодарить всех организаторов, финансистов, лидеров, участников и преподавателей этого проекта, включая учителей, которые работали в Учебно-образовательном центре Secom, особенно за их опыт, терпение и заботу. Я хотел бы поблагодарить Эржан агай за знания, заботу, поддержку и за стимул.

Желаю этому проекту успехов и еще больших успехов!

Нурсултан Кубанычбеков, студент института

Д-СТАР.jpg

Фото_38.jpeg

«Этот проект был профинансирован Посольством США в Кыргызской Республике. Мнения, выводы и заключения или рекомендации, выраженные здесь, представляют мнения авторов и не обязательно отображают точку зрения Государственного Департамента США»

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

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

SELECT `data` FROM `iafco_session` WHERE `session_id` = '173iqgtsfv4j19lhdlq61ppve6'
DELETE FROM `iafco_session` WHERE `time` < '1715895957'
SELECT `session_id` FROM `iafco_session` WHERE `session_id` = '173iqgtsfv4j19lhdlq61ppve6' LIMIT 0, 1
INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('173iqgtsfv4j19lhdlq61ppve6', 0, '1715896857')
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=475 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 = 475
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 = 475 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-16 22:00:57') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-16 22:00:57') 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 = 475
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
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM iafco_modules AS m LEFT JOIN iafco_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN iafco_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-16 22:00:57') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-16 22:00:57') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 241 OR mm.menuid <= 0) AND m.language IN ('ru-RU','*') ORDER BY m.position, m.ordering
UPDATE `iafco_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715896857;s:18:\"session.timer.last\";i:1715896857;s:17:\"session.timer.now\";i:1715896857;s:24:\"session.client.forwarded\";s:11:\"3.145.89.60\";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:\"a23fb6dada57ffb976cf6d1213064ae3\";}' , `time` = '1715896857' WHERE `session_id` = '173iqgtsfv4j19lhdlq61ppve6'

18 типов 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 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 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 params FROM iafco_extensions AS e
1 × SELECT id,template FROM iafco_template_styles
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM iafco_modules AS m LEFT JOIN iafco_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN iafco_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT a.rules FROM iafco_assets AS a
1 × SELECT alias, catid FROM iafco_content
1 × SELECT id, rules FROM `iafco_viewlevels
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 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 `data` FROM `iafco_session`
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:1715896857;s:18:\"session.timer.last\";i:1715896857;s:17:\"session.timer.now\";i:1715896857;s:24:\"session.client.forwarded\";s:11:\"3.145.89.60\";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:\"a23fb6dada57ffb976cf6d1213064ae3\";}' , `time` = '1715896857'
1 × UPDATE iafco_content SET hits = hits + 1
1 × INSERT INTO `iafco_session` (`session_id`, `client_id`, `time`) VALUES ('173iqgtsfv4j19lhdlq61ppve6', 0, '1715896857'
1 × DELETE FROM `iafco_session`

ИСТОРИЯ УСПЕХА

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

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

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

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

Сессия

__default

user

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

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

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

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

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

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

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