
Finalizado

Finalizado

Finalizado

Finalizado

Finalizado

Finalizado

Finalizado

Finalizado
Finalizado

Finalizado
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
1.32msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select count(*) as aggregate from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4'
3.2msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select distinct "courses".*, case WHEN (current_timestamp BETWEEN start_date_inscription and end_date_inscription) AND (inscribed < quota) THEN 999998 ELSE 999999 END ordenamiento from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' order by ordenamiento asc, "courses"."id" desc, "start_date_inscription" asc limit 12 offset 228
4.3msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('71', '79', '74', '47', '46', '52', '61')
840μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "duration_types" where "duration_types"."deleted_at" is null and "duration_types"."id" in ('1', '4', '2')
530μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select "areas_tematicas".*, "model_course_area"."model_course_id" as "pivot_model_course_id", "model_course_area"."area_tematica_id" as "pivot_area_tematica_id", "model_course_area"."created_at" as "pivot_created_at", "model_course_area"."updated_at" as "pivot_updated_at" from "areas_tematicas" inner join "model_course_area" on "areas_tematicas"."id" = "model_course_area"."area_tematica_id" where "areas_tematicas"."deleted_at" is null and "model_course_area"."model_course_id" in ('46', '47', '52', '61', '71', '74', '79')
870μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "categorias".*, "model_course_categoria"."model_course_id" as "pivot_model_course_id", "model_course_categoria"."categoria_id" as "pivot_categoria_id", "model_course_categoria"."created_at" as "pivot_created_at", "model_course_categoria"."updated_at" as "pivot_updated_at" from "categorias" inner join "model_course_categoria" on "categorias"."id" = "model_course_categoria"."categoria_id" where "categorias"."deleted_at" is null and "model_course_categoria"."model_course_id" in ('46', '47', '52', '61', '71', '74', '79')
780μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
350μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "education_levels"."id" as "id", "education_levels"."description" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_education_level" on "course_education_level"."course_id" = "courses"."id" inner join "education_levels" on "education_levels"."id" = "course_education_level"."education_level_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "education_levels"."id", "education_levels"."description"
5.14msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
350μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
330μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "modalities"."id" as "id", "modalities"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_modality" on "course_modality"."course_id" = "courses"."id" inner join "modalities" on "modalities"."id" = "course_modality"."modality_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "modalities"."id", "modalities"."description"
3.46msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
350μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
280μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "dynamic_types"."id" as "id", "dynamic_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "dynamic_types" on "model_courses"."dynamic_type_id" = "dynamic_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "dynamic_types"."id", "dynamic_types"."description"
2.45msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
350μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
280μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "areas_tematicas"."id" as "id", "areas_tematicas"."titulo" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "model_course_area" on "model_course_area"."model_course_id" = "model_courses"."id" inner join "areas_tematicas" on "areas_tematicas"."id" = "model_course_area"."area_tematica_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "areas_tematicas"."id", "areas_tematicas"."titulo"
3.04msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
420μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
280μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "categorias"."id" as "id", "categorias"."titulo" as "description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_categoria" on "course_categoria"."course_id" = "courses"."id" inner join "categorias" on "categorias"."id" = "course_categoria"."categoria_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "categorias"."id", "categorias"."titulo"
2.8msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
430μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
270μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "evaluation_types"."id" as "id", "evaluation_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "evaluation_types" on "model_courses"."evaluation_type_id" = "evaluation_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "evaluation_types"."id", "evaluation_types"."description"
2.57msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
450μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
350μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "certification_types"."id" as "id", "certification_types"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "certification_types" on "model_courses"."certification_type_id" = "certification_types"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' and "courses"."certifiable" = '1' group by "certification_types"."id", "certification_types"."description"
2.51msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
400μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
320μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "provinces"."id" as "id", "provinces"."description", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "course_province" on "course_province"."course_id" = "courses"."id" inner join "provinces" on "provinces"."id" = "course_province"."province_id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "provinces"."id", "provinces"."description" order by "provinces"."description" asc
8.68msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
570μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "receivers" where "receivers"."deleted_at" is null and "receivers"."id" = '4' limit 1
480μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select distinct "providers"."id" as "id", "providers"."name", COUNT(*) AS total from "courses" inner join "model_courses" on "courses"."model_course_id" = "model_courses"."id" left join "course_receiver" on "course_receiver"."course_id" = "courses"."id" inner join "providers" on "model_courses"."provider_id" = "providers"."id" where "courses"."deleted_at" is null and "visible" = '1' and ("courses"."autogestionado" = '0' and "courses"."course_state_id" = '2' or ("courses"."course_state_id" = '6' and "courses"."autogestionado" = '1' and "courses"."deleted_at" is null) or ("courses"."course_state_id" = '2' and "courses"."autogestionado" = '1' and "courses"."certifiable" = '0')) and "model_courses"."provider_id" not in ('1') and "course_receiver"."receiver_id" = '4' group by "providers"."id", "providers"."name"
2.55msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select * from "model_courses" where "model_courses"."deleted_at" is null and "model_courses"."id" in ('0')
370μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from "providers" where "providers"."deleted_at" is null and "providers"."id" is null limit 1
460μsjuanamanso_sgiMetadata | |
---|---|
Hints |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '71'
1.71msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '79'
1.44msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '74'
1.47msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '47'
1.45msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '46'
1.44msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '52'
1.33msjuanamanso_sgiMetadata | |
---|---|
Bindings |
|
select "thematic_contents".*, "model_course_thematic_content"."model_course_id" as "pivot_model_course_id", "model_course_thematic_content"."thematic_content_id" as "pivot_thematic_content_id", "model_course_thematic_content"."created_at" as "pivot_created_at", "model_course_thematic_content"."updated_at" as "pivot_updated_at" from "thematic_contents" inner join "model_course_thematic_content" on "thematic_contents"."id" = "model_course_thematic_content"."thematic_content_id" where "thematic_contents"."deleted_at" is null and "model_course_thematic_content"."model_course_id" = '61'
610μsjuanamanso_sgiMetadata | |
---|---|
Bindings |
|