Automated system for monitoring the discharge of quarry waters for the mining industry

Technological marathon to solve the problem “Automated system for monitoring the discharge of quarry waters” for Komarovsky Mining Enterprise LLP.

Date of the event:

26 september

Coworking “SmArt.Point”

Goals and objectives

Familiarize yourself with the task

https://simp.gov.kz/ru/store/tasks/62

Take a part

https://simp.gov.kz/ru/store/marathon/16

Application for participation

ID	(4,31)	Class	SQL
0	0,3	DB	SELECT * FROM en_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT SELECT * FROM en_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,23	DB	SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='event') AND active = :active AND active SELECT * FROM en_rubrics WHERE 1 = 1 AND (en_rubrics.furl = 'event') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,5	DB	SELECT * FROM en_gallery_items WHERE 1=1 AND (en_gallery_items.type='eventorganizers_photo') AND SELECT * FROM en_gallery_items WHERE 1 = 1 AND ( en_gallery_items.type = 'eventorganizers_photo' ) AND (en_gallery_items.gallery_id = 32) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,19	DB	SELECT * FROM en_event_programs WHERE 1=1 AND (en_event_programs.event_id=32) AND active = :activ SELECT * FROM en_event_programs WHERE 1 = 1 AND (en_event_programs.event_id = 32) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
4	0,38	DB	SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
5	0,17	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
24	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
25	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(4,31)

Class

SQL

0,3

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

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

0,23

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

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

0,5

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

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

0,19

SELECT * FROM en_event_programs WHERE 1=1 AND (en_event_programs.event_id=32) AND active = :activ

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

0,38

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

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

0,17