// // //
//

Інформатика для студентів І курсу

Опубліковано: 424 дні тому (21 вересня 2016)
Рубрика: Без рубрики
Редагувалося: 8 раз — останній 22 вересня 2017
0
Голосів: 0
Розділ 1. Основні поняття інформатики та програмне забезпечення персональних комп’ютерів
Тема 1.1. Інформатика та інформація, обчислювальна техніка
Тема 1.2. Інформаційна система та її структура
Тема 1.3. Програмне забезпечення
Тема 1.4. Операційна система

Практична робота №1
Нарисна геометрія та креслення
Коментарі (0)

Коментарі відсутні. Ваш буде першим!

Час генерації сторінки: 0.9945 сек.
Запити до бази: 35
SET NAMES cp1251

SELECT * FROM cms_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM cms_components

SELECT p.id, p.plugin, p.config, e.event FROM cms_plugins p, cms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id

SELECT id FROM cms_user_groups WHERE alias = 'guest'

DELETE FROM cms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)

SELECT id as getfield FROM cms_online WHERE sess_id = '40b193j1gaoda7mfb2l0006b05' AND ip = '54.196.47.128' LIMIT 1

INSERT INTO cms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.196.47.128', '40b193j1gaoda7mfb2l0006b05', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/blogs/organ-zac-ja-ta-ekonom-ka-vydavnycho-spravy/-nformatyka-dlja-student-v-kursu.html')

SELECT id FROM cms_stats WHERE (ip = '54.196.47.128' AND page = '/blogs/organ-zac-ja-ta-ekonom-ka-vydavnycho-spravy/-nformatyka-dlja-student-v-kursu.html')

INSERT INTO cms_stats (ip, logdate, page, agent, refer) VALUES ('54.196.47.128', NOW(), '/blogs/organ-zac-ja-ta-ekonom-ka-vydavnycho-spravy/-nformatyka-dlja-student-v-kursu.html', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '')

SELECT NSLeft, NSRight FROM cms_menu WHERE id = '17'

SELECT id, title, link, linktype
                           FROM cms_menu
                           WHERE NSLeft <= 42 AND NSRight >= 43 AND parent_id > 0
                           ORDER BY NSLeft

SELECT *
				FROM cms_blogs
				WHERE seolink = 'organ-zac-ja-ta-ekonom-ka-vydavnycho-spravy'
				LIMIT 1

SELECT nickname as getfield FROM cms_users WHERE id=142 LIMIT 1

SELECT p.*,
                   u.nickname as author,
                   u.id as author_id, 
                   up.imageurl as author_image,
                   u.is_deleted as author_deleted
			FROM cms_blog_posts p
			LEFT JOIN cms_users u ON u.id = p.user_id
            LEFT JOIN cms_user_profiles up ON up.user_id = p.user_id
			LEFT JOIN cms_blogs b ON b.id = p.blog_id AND b.seolink = 'organ-zac-ja-ta-ekonom-ka-vydavnycho-spravy'
			WHERE p.seolink = '-nformatyka-dlja-student-v-kursu'
            LIMIT 1

SELECT gender as getfield FROM cms_user_profiles WHERE user_id = '142' LIMIT 1

SELECT nickname, login FROM cms_users WHERE id = '142' ORDER BY id ASC LIMIT 1

SELECT total_rating, total_votes FROM cms_ratings_total WHERE item_id = '4667' AND target='blogpost' ORDER BY id ASC LIMIT 1

SELECT seolink, title FROM cms_blog_posts WHERE pubdate < '2016-09-21 22:56:01' AND blog_id = 37 ORDER BY pubdate DESC LIMIT 1

SELECT seolink, title FROM cms_blog_posts WHERE pubdate > '2016-09-21 22:56:01' AND blog_id = 37 ORDER BY pubdate ASC LIMIT 1

SELECT tag
			FROM cms_tags 
			WHERE target='blogpost' AND item_id='4667'
			ORDER BY tag DESC

SELECT id
                FROM cms_comments
                WHERE target='blog' AND target_id=4667 AND published=1

SELECT access FROM cms_user_groups WHERE id = 8 LIMIT 1

SELECT access FROM cms_user_groups WHERE id = 8 LIMIT 1

SELECT c.*,
                       IFNULL(v.total_rating, 0) as votes,
					   IFNULL(u.nickname, 0) as nickname,
					   IFNULL(u.login, 0) as login,
					   IFNULL(u.is_deleted, 0) as is_deleted,
					   IFNULL(p.imageurl, 0) as imageurl,
                       (NOW() < DATE_ADD(c.pubdate, INTERVAL 0 MINUTE)) as is_editable
                FROM cms_comments c
                LEFT JOIN cms_ratings_total v ON v.item_id = c.id AND v.target = 'comment'
				LEFT JOIN cms_users u ON u.id = c.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                WHERE c.target='blog' AND c.target_id=4667 AND c.published=1
                ORDER BY c.pubdate ASC

SELECT 1 FROM cms_subscribe WHERE user_id = 0 AND target = 'blog' AND target_id = 4667

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '17' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT m.access_list
            FROM cms_modules m, cms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '17' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '17' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM cms_menu WHERE id = '17' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM cms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM cms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM cms_menu WHERE NSLeft > 1 AND NSRight < 64 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '17' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM cms_modules m, cms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '17' OR mb.menu_id = 0)
                  AND (m.is_strict_bind = 0)
            ORDER BY m.ordering ASC