Query Metrics
47
Database Queries
8
Different statements
238.68 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.03 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?
Parameters:
[
33
]
|
| 2 | 7.34 ms |
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edital e0_ WHERE e0_.cod_etapa_atual = ? AND e0_.status IN ('N', 'A', 'C', 'F') AND e0_.ativo = 1
Parameters:
[
"CON"
]
|
| 3 | 2.69 ms |
SELECT DISTINCT e0_.id AS id_0 FROM edital e0_ WHERE e0_.cod_etapa_atual = ? AND e0_.status IN ('N', 'A', 'C', 'F') AND e0_.ativo = 1 LIMIT 10
Parameters:
[
"CON"
]
|
| 4 | 40.76 ms |
SELECT e0_.id AS id_0, e0_.descricao AS descricao_1, e0_.pdf_edital AS pdf_edital_2, e0_.pdf_termo_referencia AS pdf_termo_referencia_3, e0_.data_publicacao AS data_publicacao_4, e0_.data_cadastro AS data_cadastro_5, e0_.data_etapa_acolhimento AS data_etapa_acolhimento_6, e0_.data_etapa_disputa AS data_etapa_disputa_7, e0_.datat_etapa_habilitacao AS datat_etapa_habilitacao_8, e0_.registro_preco AS registro_preco_9, e0_.data_etapa_contrato AS data_etapa_contrato_10, e0_.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_11, e0_.data_etapa_entrega_produto AS data_etapa_entrega_produto_12, e0_.data_etapa_emissao_nf AS data_etapa_emissao_nf_13, e0_.data_etapa_faturamento AS data_etapa_faturamento_14, e0_.data_etapa_att AS data_etapa_att_15, e0_.status AS status_16, e0_.cod_etapa_atual AS cod_etapa_atual_17, e0_.numero AS numero_18, e0_.id_plataforma AS id_plataforma_19, e0_.updated_at AS updated_at_20, e0_.motivo_finalizacao AS motivo_finalizacao_21, e0_.obs_finalizacao AS obs_finalizacao_22, e0_.arquivo_finalizacao AS arquivo_finalizacao_23, e0_.created_at AS created_at_24, e0_.ativo AS ativo_25, e0_.numero_ata AS numero_ata_26, e0_.nome_do_cliente AS nome_do_cliente_27, e0_.modelo_disputa AS modelo_disputa_28, e0_.observacoes AS observacoes_29, e0_.comissao_empresa AS comissao_empresa_30, e0_.tipo_proposta AS tipo_proposta_31, e0_.registrado_compras AS registrado_compras_32, e0_.uasg_orgao AS uasg_orgao_33, e0_.cliente_id AS cliente_id_34, e0_.responsavel_id AS responsavel_id_35, e0_.responsavel_comissionado_id AS responsavel_comissionado_id_36, e0_.empresa_id AS empresa_id_37, e0_.etapa_atual_id AS etapa_atual_id_38, e0_.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_39, e0_.etapa_disputa_id AS etapa_disputa_id_40, e0_.etapa_habilitacao_id AS etapa_habilitacao_id_41, e0_.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_42, e0_.etapa_entrega_produto_id AS etapa_entrega_produto_id_43, e0_.etapa_emissao_nf_id AS etapa_emissao_nf_id_44, e0_.etapa_faturamento_id AS etapa_faturamento_id_45, e0_.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_46, e0_.plataforma_id AS plataforma_id_47, e0_.estado_id AS estado_id_48 FROM edital e0_ WHERE e0_.cod_etapa_atual = ? AND e0_.status IN ('N', 'A', 'C', 'F') AND e0_.ativo = 1 AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "CON" 12 17 53 227 240 270 326 421 572 574 ] |
| 5 | 82.02 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
46
]
|
| 6 | 2.06 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
12
]
|
| 7 | 1.76 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
12
]
|
| 8 | 4.29 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
67
]
|
| 9 | 2.12 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
17
]
|
| 10 | 1.74 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
17
]
|
| 11 | 3.20 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
135
]
|
| 12 | 1.70 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
53
]
|
| 13 | 1.57 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
53
]
|
| 14 | 3.34 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
345
]
|
| 15 | 3.26 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
227
]
|
| 16 | 1.67 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
227
]
|
| 17 | 3.76 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
378
]
|
| 18 | 1.81 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
240
]
|
| 19 | 2.36 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
240
]
|
| 20 | 7.67 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
431
]
|
| 21 | 1.82 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
270
]
|
| 22 | 2.01 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
270
]
|
| 23 | 3.50 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
1345
]
|
| 24 | 2.48 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
326
]
|
| 25 | 2.02 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
326
]
|
| 26 | 3.67 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
645
]
|
| 27 | 2.23 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
421
]
|
| 28 | 1.95 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
421
]
|
| 29 | 2.47 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
823
]
|
| 30 | 1.76 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
572
]
|
| 31 | 1.81 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
572
]
|
| 32 | 2.27 ms |
SELECT t0.id AS id_12, t0.created_at AS created_at_13, t0.tipo_etapa, t1.validade AS validade_14, t1.condicoes_entrega AS condicoes_entrega_15, t1.prazo_entrega AS prazo_entrega_16, t1.local_entrega AS local_entrega_17, t1.garantia AS garantia_18, t1.informacoes_gerais AS informacoes_gerais_19, t1.status AS status_20, t1.data AS data_21, t1.prazo_pagamento AS prazo_pagamento_22, t1.conta_bancaria_id AS conta_bancaria_id_23, t2.dt_disputa AS dt_disputa_24, t2.dt_fechamento AS dt_fechamento_25, t2.status AS status_26, t2.vlr_fechado AS vlr_fechado_27, t2.observacoes AS observacoes_28, t2.em_espera AS em_espera_29, t5.tipo_contratacao AS tipo_contratacao_30, t5.contrato AS contrato_31, t5.vigencia AS vigencia_32, t5.data_assinatura AS data_assinatura_33, t5.numero_contrato AS numero_contrato_34, t5.prazo_inicial AS prazo_inicial_35, t5.prazo_final AS prazo_final_36, t5.valor_inicial AS valor_inicial_37, t5.valor_final AS valor_final_38, t5.status AS status_39, t5.obs_finalizacao AS obs_finalizacao_40, t5.motivo_finalizacao AS motivo_finalizacao_41, t5.arquivo_finalizacao AS arquivo_finalizacao_42, t5.data_finalizacao AS data_finalizacao_43, t5.tipo_contrato AS tipo_contrato_44, t5.edital_id AS edital_id_45, t5.responsavel_id AS responsavel_id_46, t5.ata_registro_id AS ata_registro_id_47, t5.contratada_id AS contratada_id_48, t5.ata_contrato_id AS ata_contrato_id_49, t11.validade AS validade_50, t11.condicoes_entrega AS condicoes_entrega_51, t11.prazo_entrega AS prazo_entrega_52, t11.local_entrega AS local_entrega_53, t11.garantia AS garantia_54, t11.informacoes_gerais AS informacoes_gerais_55, t11.status AS status_56, t11.data AS data_57, t11.prazo_pagamento AS prazo_pagamento_58, t11.situacao AS situacao_59, t11.edital_id AS edital_id_60, t11.conta_bancaria_id AS conta_bancaria_id_61 FROM etapa_processo t0 LEFT JOIN etapa_acolhimento_propostas t1 ON t0.id = t1.id LEFT JOIN etapa_disputa t2 ON t0.id = t2.id LEFT JOIN etapa_habilitacao t3 ON t0.id = t3.id LEFT JOIN etapa_registro_preco t4 ON t0.id = t4.id LEFT JOIN etapa_contrato t5 ON t0.id = t5.id LEFT JOIN etapa_autorizacao_fornecimento t6 ON t0.id = t6.id LEFT JOIN etapa_entrega_produto t7 ON t0.id = t7.id LEFT JOIN etapa_emissao_nf t8 ON t0.id = t8.id LEFT JOIN etapa_faturamento t9 ON t0.id = t9.id LEFT JOIN etapa_atestado_tecnico t10 ON t0.id = t10.id LEFT JOIN proposta_final t11 ON t0.id = t11.id WHERE t0.id = ?
Parameters:
[
831
]
|
| 33 | 1.80 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.tipo_contratacao AS tipo_contratacao_4, t0.contrato AS contrato_5, t0.vigencia AS vigencia_6, t0.data_assinatura AS data_assinatura_7, t0.numero_contrato AS numero_contrato_8, t0.prazo_inicial AS prazo_inicial_9, t0.prazo_final AS prazo_final_10, t0.valor_inicial AS valor_inicial_11, t0.valor_final AS valor_final_12, t0.status AS status_13, t0.obs_finalizacao AS obs_finalizacao_14, t0.motivo_finalizacao AS motivo_finalizacao_15, t0.arquivo_finalizacao AS arquivo_finalizacao_16, t0.data_finalizacao AS data_finalizacao_17, t0.tipo_contrato AS tipo_contrato_18, t0.edital_id AS edital_id_19, t0.responsavel_id AS responsavel_id_20, t0.ata_registro_id AS ata_registro_id_21, t0.contratada_id AS contratada_id_22, t0.ata_contrato_id AS ata_contrato_id_23, t1.tipo_etapa FROM etapa_contrato t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
574
]
|
| 34 | 1.85 ms |
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t0.validade AS validade_4, t0.condicoes_entrega AS condicoes_entrega_5, t0.prazo_entrega AS prazo_entrega_6, t0.local_entrega AS local_entrega_7, t0.garantia AS garantia_8, t0.informacoes_gerais AS informacoes_gerais_9, t0.status AS status_10, t0.data AS data_11, t0.prazo_pagamento AS prazo_pagamento_12, t0.situacao AS situacao_13, t0.edital_id AS edital_id_14, t0.conta_bancaria_id AS conta_bancaria_id_15, t1.tipo_etapa FROM proposta_final t0 INNER JOIN etapa_processo t1 ON t0.id = t1.id WHERE t0.edital_id = ?
Parameters:
[
574
]
|
| 35 | 2.12 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 36 | 2.37 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
136
]
|
| 37 | 2.00 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
202
]
|
| 38 | 1.98 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
149
]
|
| 39 | 2.02 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?
Parameters:
[
30
]
|
| 40 | 2.08 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
199
]
|
| 41 | 1.79 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
167
]
|
| 42 | 3.21 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
311
]
|
| 43 | 1.94 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
206
]
|
| 44 | 2.82 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 45 | 2.20 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
343
]
|
| 46 | 3.13 ms |
SELECT t1.id AS id_2, t1.razao_social AS razao_social_3, t1.nome_fantasia AS nome_fantasia_4, t1.cnpj AS cnpj_5, t1.inscricao_estadual AS inscricao_estadual_6, t1.ie_isento AS ie_isento_7, t1.telefone AS telefone_8, t1.celular AS celular_9, t1.nome_contato AS nome_contato_10, t1.site AS site_11, t1.email AS email_12, t1.cargo_contato AS cargo_contato_13, t1.created_at AS created_at_14, t1.ativo AS ativo_15, t0.inscricao_municipal AS inscricao_municipal_16, t1.endereco_id AS endereco_id_17, t1.tipo_cadastro FROM cliente t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
378
]
|
| 47 | 2.25 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.cpf AS cpf_3, t0.rg AS rg_4, t0.telefone AS telefone_5, t0.celular AS celular_6, t0.email AS email_7, t0.created_at AS created_at_8, t0.data_admissao AS data_admissao_9, t0.data_demissao AS data_demissao_10, t0.ativo AS ativo_11, t0.situacao AS situacao_12, t0.password AS password_13, t0.role AS role_14, t0.endereco_id AS endereco_id_15, t0.cargo_id AS cargo_id_16, t0.empresa_registro_id AS empresa_registro_id_17, t0.tipo_cadastro FROM colaborador t0 WHERE t0.id = ?
Parameters:
[
40
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.