Symfony Profiler

SELECT
  t0.id_usuario AS id_usuario_1,
  t0.nome AS nome_2,
  t0.email AS email_3,
  t0.login AS login_4,
  t0.id_avaliado AS id_avaliado_5,
  t0.senha AS senha_6,
  t0.ativo AS ativo_7,
  t0.data_add AS data_add_8,
  t0.data_upd AS data_upd_9,
  t0.force_update AS force_update_10,
  t0.senha_update AS senha_update_11,
  t0.data_limite_acesso AS data_limite_acesso_12,
  t0.onboard AS onboard_13,
  t0.foto AS foto_14,
  t0.googleAuthenticatorSecret AS googleauthenticatorsecret_15,
  t0.passwordless_token AS passwordless_token_16,
  t0.id_perfil AS id_perfil_17
FROM
  analytics.usuario t0
WHERE
  t0.id_usuario = ?

SELECT t0.id_usuario AS id_usuario_1, t0.nome AS nome_2, t0.email AS email_3, t0.login AS login_4, t0.id_avaliado AS id_avaliado_5, t0.senha AS senha_6, t0.ativo AS ativo_7, t0.data_add AS data_add_8, t0.data_upd AS data_upd_9, t0.force_update AS force_update_10, t0.senha_update AS senha_update_11, t0.data_limite_acesso AS data_limite_acesso_12, t0.onboard AS onboard_13, t0.foto AS foto_14, t0.googleAuthenticatorSecret AS googleauthenticatorsecret_15, t0.passwordless_token AS passwordless_token_16, t0.id_perfil AS id_perfil_17 FROM analytics.usuario t0 WHERE t0.id_usuario = 7707;

SELECT
  t0.id_perfil AS id_perfil_1,
  t0.titulo AS titulo_2,
  t0.data_add AS data_add_3,
  t0.data_upd AS data_upd_4,
  t0.rota_default AS rota_default_5,
  t0.role AS role_6,
  t0.permissao AS permissao_7
FROM
  analytics.perfil t0
WHERE
  t0.id_perfil = ?

SELECT t0.id_perfil AS id_perfil_1, t0.titulo AS titulo_2, t0.data_add AS data_add_3, t0.data_upd AS data_upd_4, t0.rota_default AS rota_default_5, t0.role AS role_6, t0.permissao AS permissao_7 FROM analytics.perfil t0 WHERE t0.id_perfil = 2;

SELECT
  t0.id_visao AS id_visao_1,
  t0.titulo AS titulo_2,
  t0.rota_default AS rota_default_3,
  t0.slug AS slug_4,
  t0.icone AS icone_5
FROM
  analytics.visao t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id_visao AS id_visao_1, t0.titulo AS titulo_2, t0.rota_default AS rota_default_3, t0.slug AS slug_4, t0.icone AS icone_5 FROM analytics.visao t0 WHERE t0.slug = 'avaliado' LIMIT 1;

SELECT
  t0.id_usuario_cliente AS id_usuario_cliente_1,
  t0.id_cliente AS id_cliente_2,
  t0.id_usuario AS id_usuario_3,
  t0.nome AS nome_4,
  t0.permissao AS permissao_5,
  t0.data_add AS data_add_6,
  t0.data_aceite_termo AS data_aceite_termo_7
FROM
  analytics.usuario_cliente t0
WHERE
  t0.id_usuario = ?
  AND t0.id_cliente = ?
LIMIT
  1

SELECT t0.id_usuario_cliente AS id_usuario_cliente_1, t0.id_cliente AS id_cliente_2, t0.id_usuario AS id_usuario_3, t0.nome AS nome_4, t0.permissao AS permissao_5, t0.data_add AS data_add_6, t0.data_aceite_termo AS data_aceite_termo_7 FROM analytics.usuario_cliente t0 WHERE t0.id_usuario = 7707 AND t0.id_cliente = 228 LIMIT 1;

SELECT
  id_dominio,
  nome_dominio,
  peso : :float,
  COALESCE(
    AVG(score),
    0
  ): :float valor,
  jsonb_agg(
    jsonb_build_object(
      'periodo', periodo, 'performance',
      performance
    )
    ORDER BY
      periodo ASC
  ) performances
FROM
  (
    SELECT
      id_modelagem,
      nome_modelagem,
      id_dominio,
      nome_dominio,
      periodo,
      peso,
      ROUND(
        AVG(score) FILTER(
          WHERE
            score IS NOT NULL
        ),
        2
      ) score,
      ROUND(
        AVG(performance) FILTER(
          WHERE
            score IS NOT NULL
        ),
        2
      ) performance
    FROM
      (
        SELECT
          a.*,
          p.peso,
          COALESCE(
            SUM(score),
            0
          ) score,
          CASE WHEN SUM(score) IS NOT NULL THEN (
            SUM(score)/ p.peso
          )* 100 ELSE null END performance
        FROM
          (
            SELECT
              DISTINCT id_modelagem,
              nome_modelagem,
              id_grupo,
              id_avaliado,
              periodo,
              id_dominio,
              nome_dominio
            FROM
              modelagem.scorecard_avaliados
              JOIN LATERAL (
                SELECT
                  generate_periodo periodo
                FROM
                  generate_periodo(202601, 202601)
              ) p ON periodo BETWEEN avaliacao_inicio
              AND avaliacao_fim
            WHERE
              TRUE
              AND avaliacao_inicio <= 202601
              AND avaliacao_fim >= 202601
              AND scorecard_inicio <= 202601
              AND scorecard_fim >= 202601
              AND id_programa = 1
              AND id_modelagem = 1
              AND id_avaliado = 1009922
              AND id_grupo = 301
            ORDER BY
              1,
              3,
              4,
              5,
              6
          ) a
          LEFT JOIN (
            SELECT
              id_modelagem,
              id_grupo,
              id_dominio,
              SUM(peso) peso
            FROM
              (
                SELECT
                  DISTINCT id_modelagem,
                  id_dominio,
                  id_grupo,
                  id_indicador,
                  ROUND(
                    AVG(peso),
                    2
                  ) peso
                FROM
                  modelagem.scorecard_avaliados
                WHERE
                  TRUE
                  AND avaliacao_inicio <= 202601
                  AND avaliacao_fim >= 202601
                  AND scorecard_inicio <= 202601
                  AND scorecard_fim >= 202601
                GROUP BY
                  1,
                  2,
                  3,
                  4
              ) a
            GROUP BY
              1,
              2,
              3
          ) p USING (
            id_modelagem, id_dominio, id_grupo
          )
          LEFT JOIN dados.calculo c ON (
            a.id_modelagem = c.id_modelagem
            AND a.id_grupo = c.id_grupo
            AND a.id_avaliado = c.id_avaliado
            AND a.periodo = CONCAT(
              c.periodo ->> 'ano',
              LPAD(c.periodo ->> 'periodo', 2, '0')
            ): :int
            AND a.id_dominio = c.id_dominio
          )
        GROUP BY
          1,
          2,
          3,
          4,
          5,
          6,
          7,
          8
      ) b
    GROUP BY
      1,
      2,
      3,
      4,
      5,
      6
  ) c
GROUP BY
  1,
  2,
  3

SELECT
                    id_dominio,
                    nome_dominio,
                    peso::float,
                    COALESCE(AVG(score), 0)::float valor,
                    jsonb_agg(
                        jsonb_build_object(
                            'periodo', periodo,
                            'performance', performance
                        ) ORDER BY periodo ASC
                    ) performances
                FROM (
                    SELECT
                        id_modelagem,
                        nome_modelagem,
                        id_dominio,
                        nome_dominio,
                        periodo,
                        peso,
                        ROUND(AVG(score) FILTER(WHERE score IS NOT NULL), 2) score,
                        ROUND(AVG(performance) FILTER(WHERE score IS NOT NULL), 2) performance
                    FROM (
                        SELECT
                            a.*,
                            p.peso,
                            COALESCE(SUM(score), 0) score,
                            CASE
                                WHEN SUM(score) IS NOT NULL THEN (SUM(score)/p.peso)*100
							    ELSE null
                            END performance
                        FROM (
                            SELECT DISTINCT
                                id_modelagem,
                                nome_modelagem,
                                id_grupo,
                                id_avaliado,
                                periodo,
                                id_dominio,
                                nome_dominio
                            FROM modelagem.scorecard_avaliados
                            JOIN LATERAL (
                                SELECT generate_periodo periodo FROM generate_periodo(202601,202601)
                            ) p ON periodo BETWEEN avaliacao_inicio AND avaliacao_fim
                            WHERE TRUE
                                 AND avaliacao_inicio  <= 202601 AND avaliacao_fim >= 202601 AND scorecard_inicio  <= 202601 AND scorecard_fim >= 202601
                                AND id_programa = 1 AND id_modelagem = 1
                                 AND id_avaliado = 1009922
                                 AND id_grupo = 301
                                
                            ORDER BY 1,3,4,5,6
                        ) a
                        LEFT JOIN (
                            SELECT
                                id_modelagem,
                                id_grupo,
                                id_dominio,
                                SUM(peso) peso
                            FROM (
                                SELECT DISTINCT
                                    id_modelagem,
                                    id_dominio,
                                    id_grupo,
                                    id_indicador,
                                    ROUND(AVG(peso), 2) peso
                                FROM modelagem.scorecard_avaliados
                                WHERE TRUE  AND avaliacao_inicio  <= 202601 AND avaliacao_fim >= 202601 AND scorecard_inicio  <= 202601 AND scorecard_fim >= 202601
                                GROUP BY 1,2,3,4
                            ) a
                            GROUP BY 1,2,3
                        ) p USING (id_modelagem, id_dominio, id_grupo)
                        LEFT JOIN dados.calculo c ON (
                            a.id_modelagem = c.id_modelagem
                            AND a.id_grupo = c.id_grupo
                            AND a.id_avaliado = c.id_avaliado
                            AND a.periodo = CONCAT(c.periodo->>'ano', LPAD(c.periodo->>'periodo', 2, '0'))::int
                            AND a.id_dominio = c.id_dominio
                        )
                        GROUP BY 1,2,3,4,5,6,7,8
                    ) b
                    GROUP BY 1,2,3,4,5,6
                ) c
                GROUP BY 1,2,3;

SELECT
  Array_To_String(
    Array_Agg(
      Concat(
        periodo ->> 'ano', periodo ->> 'periodo'
      ): :integer
      ORDER BY
        periodo ->> 'periodo'
    ),
    ','
  ) periodos
FROM
  dados.gps
WHERE
  id_avaliado = :id_avaliado
  AND id_grupo = :id_grupo
  AND id_programa = :id_programa
  AND id_modelagem = :id_modelagem
  AND periodo ->> 'tipo' = 'mes'
  AND (periodo ->> 'ano'): :int = 2026
  AND (periodo ->> 'periodo'): :int = 01

SELECT
                    Array_To_String(Array_Agg(Concat(periodo->>'ano',periodo->>'periodo')::integer ORDER BY periodo->>'periodo'),',') periodos
                FROM
                    dados.gps
                WHERE
                    id_avaliado = :id_avaliado
                    AND id_grupo = :id_grupo
                    AND id_programa = :id_programa
                    AND id_modelagem = :id_modelagem
                     AND periodo->>'tipo' = 'mes' AND (periodo->>'ano')::int = 2026 AND (periodo->>'periodo')::int = 01;

SELECT
  id_solicitacao,
  id_usuario,
  nome_usuario,
  nome_documento,
  pasta_slug,
  extensao,
  especialidade,
  aprovacao,
  envios_permitidos,
  data_add
FROM
  fornecidos.solicitacao
WHERE
  especialidade ->> '301' IS NOT NULL
  OR especialidade = '[]'
GROUP BY
  1,
  2,
  3,
  4,
  5,
  8,
  9,
  10

SELECT
                    id_solicitacao,
                    id_usuario,
                    nome_usuario,
                    nome_documento,
                    pasta_slug,
                    extensao,
                    especialidade,
                    aprovacao,
                    envios_permitidos,
                    data_add
                FROM fornecidos.solicitacao
                WHERE especialidade->>'301' IS NOT NULL OR especialidade = '[]'
                GROUP BY 1,2,3,4,5,8,9,10;

SELECT
  *
FROM
  fornecidos.arquivos a
WHERE
  a.id_avaliado = 1009922

SELECT
                    *
                FROM fornecidos.arquivos a
                WHERE a.id_avaliado = 1009922;