Mining Day 2.0 енді Алматыда!

29 наурызда Mining Day 2.0 өтеді! Біздің Smart Industry Management Platform (SIMP) платформамызда ірі жер қойнауын пайдаланушының қатты пайдалы қазбаларды өндіру және өңдеу саласындағы жалпы 2 тапсырмасы жарияланды!

Өткізілу күні:

29 Наурыз

Қазақстан, Алматы қаласы

Мақсаты мен міндеттері

Тапсырмалармен танысу

Тапсырмалармен сілтеме бойынша танысуға болады: https://simp.gov.kz/ru/store/tasks

Қатысу

Mining Day 2.0 қатысуға өтінімді сілтеме бойынша қалдыруға болады: https://simp.gov.kz/ru/store/marathon/23

Қатысуға өтінім

ID	(5,71)	Class	SQL
0	0,45	DB	SELECT * FROM kz_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT SELECT * FROM kz_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,39	DB	SELECT * FROM kz_rubrics WHERE 1=1 AND (kz_rubrics.furl='event') AND active = :active AND active SELECT * FROM kz_rubrics WHERE 1 = 1 AND (kz_rubrics.furl = 'event') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,51	DB	SELECT * FROM kz_gallery_items WHERE 1=1 AND (kz_gallery_items.type='eventorganizers_photo') AND SELECT * FROM kz_gallery_items WHERE 1 = 1 AND ( kz_gallery_items.type = 'eventorganizers_photo' ) AND (kz_gallery_items.gallery_id = 39) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,19	DB	SELECT * FROM kz_event_programs WHERE 1=1 AND (kz_event_programs.event_id=39) AND active = :activ SELECT * FROM kz_event_programs WHERE 1 = 1 AND (kz_event_programs.event_id = 39) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
4	0,46	DB	SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
5	0,23	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,24	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,2	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,18	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,19	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,18	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,16	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,16	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,15	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,15	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,17	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,19	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,18	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,17	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,18	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,21	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,17	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
24	0,14	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
25	0,19	DB	SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM kz_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(5,71)

Class

SQL

0,45

SELECT * FROM kz_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT

SELECT 
  * 
FROM 
  kz_events 
WHERE 
  id = :id 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,39

SELECT * FROM kz_rubrics WHERE 1=1 AND (kz_rubrics.furl='event') AND active = :active AND active

SELECT 
  * 
FROM 
  kz_rubrics 
WHERE 
  1 = 1 
  AND (kz_rubrics.furl = 'event') 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,51

SELECT * FROM kz_gallery_items WHERE 1=1 AND (kz_gallery_items.type='eventorganizers_photo') AND

SELECT 
  * 
FROM 
  kz_gallery_items 
WHERE 
  1 = 1 
  AND (
    kz_gallery_items.type = 'eventorganizers_photo'
  ) 
  AND (kz_gallery_items.gallery_id = 39) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,19

SELECT * FROM kz_event_programs WHERE 1=1 AND (kz_event_programs.event_id=39) AND active = :activ

SELECT 
  * 
FROM 
  kz_event_programs 
WHERE 
  1 = 1 
  AND (kz_event_programs.event_id = 39) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,46

SELECT * FROM kz_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1

SELECT 
  * 
FROM 
  kz_rubrics 
WHERE 
  1 = 1 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,23