Бос жұмыс орындары

Бизнес/жүйелік талдаушы

Бос орын жабылды

Жариялану күні:

15.03.2023

Толығырақ

Frontend-әзірлеуші

Бос орын жабылды

Жариялану күні:

15.03.2023

Толығырақ

Backend әзірлеушісі

Бос орын жабылды

Жариялану күні:

15.03.2023

Толығырақ

UI/UX дизайнері

Бос орын жабылды

Жариялану күні:

15.03.2023

Толығырақ

ID	(3,6)	Class	SQL
0	0,31	DB	SELECT * FROM kz_rubrics WHERE 1=1 AND (kz_rubrics.furl='vacancy') AND active = :active AND activ SELECT * FROM kz_rubrics WHERE 1 = 1 AND (kz_rubrics.furl = 'vacancy') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,25	DB	SELECT * FROM kz_vacancies WHERE 1=1 AND (kz_vacancies.active=1) AND active = :active AND active SELECT * FROM kz_vacancies WHERE 1 = 1 AND (kz_vacancies.active = 1) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 4	1
2	0,13	DB	SELECT COUNT(id) FROM kz_vacancies WHERE 1=1 AND (kz_vacancies.active=1) SELECT COUNT(id) FROM kz_vacancies WHERE 1 = 1 AND (kz_vacancies.active = 1)	1
3	0,38	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
4	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
5	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
6	0,11	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,12	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,11	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,1	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,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
11	0,12	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,11	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,11	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,12	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,11	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,1	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,1	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,13	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,12	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,12	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,11	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,13	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,11	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,1	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

(3,6)

Class

SQL

0,31

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

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

0,25

SELECT * FROM kz_vacancies WHERE 1=1 AND (kz_vacancies.active=1) AND active = :active AND active

SELECT 
  * 
FROM 
  kz_vacancies 
WHERE 
  1 = 1 
  AND (kz_vacancies.active = 1) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  4

0,13

SELECT COUNT(id) FROM kz_vacancies WHERE 1=1 AND (kz_vacancies.active=1)

SELECT 
  COUNT(id) 
FROM 
  kz_vacancies 
WHERE 
  1 = 1 
  AND (kz_vacancies.active = 1)

0,38

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,18