Symfony Profiler

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 = ?

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 = 23;

SELECT
  t0.id AS id_1,
  t0.descricao AS descricao_2,
  t0.pdf_edital AS pdf_edital_3,
  t0.pdf_termo_referencia AS pdf_termo_referencia_4,
  t0.data_publicacao AS data_publicacao_5,
  t0.data_cadastro AS data_cadastro_6,
  t0.data_etapa_acolhimento AS data_etapa_acolhimento_7,
  t0.data_etapa_disputa AS data_etapa_disputa_8,
  t0.datat_etapa_habilitacao AS datat_etapa_habilitacao_9,
  t0.registro_preco AS registro_preco_10,
  t0.data_etapa_contrato AS data_etapa_contrato_11,
  t0.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_12,
  t0.data_etapa_entrega_produto AS data_etapa_entrega_produto_13,
  t0.data_etapa_emissao_nf AS data_etapa_emissao_nf_14,
  t0.data_etapa_faturamento AS data_etapa_faturamento_15,
  t0.data_etapa_att AS data_etapa_att_16,
  t0.status AS status_17,
  t0.cod_etapa_atual AS cod_etapa_atual_18,
  t0.numero AS numero_19,
  t0.id_plataforma AS id_plataforma_20,
  t0.updated_at AS updated_at_21,
  t0.motivo_finalizacao AS motivo_finalizacao_22,
  t0.obs_finalizacao AS obs_finalizacao_23,
  t0.arquivo_finalizacao AS arquivo_finalizacao_24,
  t0.created_at AS created_at_25,
  t0.ativo AS ativo_26,
  t0.numero_ata AS numero_ata_27,
  t0.nome_do_cliente AS nome_do_cliente_28,
  t0.modelo_disputa AS modelo_disputa_29,
  t0.observacoes AS observacoes_30,
  t0.comissao_empresa AS comissao_empresa_31,
  t0.tipo_proposta AS tipo_proposta_32,
  t0.registrado_compras AS registrado_compras_33,
  t0.uasg_orgao AS uasg_orgao_34,
  t0.cliente_id AS cliente_id_35,
  t0.responsavel_id AS responsavel_id_36,
  t0.responsavel_comissionado_id AS responsavel_comissionado_id_37,
  t0.empresa_id AS empresa_id_38,
  t0.etapa_atual_id AS etapa_atual_id_39,
  t0.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_40,
  t0.etapa_disputa_id AS etapa_disputa_id_41,
  t0.etapa_habilitacao_id AS etapa_habilitacao_id_42,
  t0.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_43,
  t0.etapa_entrega_produto_id AS etapa_entrega_produto_id_44,
  t0.etapa_emissao_nf_id AS etapa_emissao_nf_id_45,
  t0.etapa_faturamento_id AS etapa_faturamento_id_46,
  t0.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_47,
  t0.plataforma_id AS plataforma_id_48,
  t0.estado_id AS estado_id_49
FROM
  edital t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.pdf_edital AS pdf_edital_3, t0.pdf_termo_referencia AS pdf_termo_referencia_4, t0.data_publicacao AS data_publicacao_5, t0.data_cadastro AS data_cadastro_6, t0.data_etapa_acolhimento AS data_etapa_acolhimento_7, t0.data_etapa_disputa AS data_etapa_disputa_8, t0.datat_etapa_habilitacao AS datat_etapa_habilitacao_9, t0.registro_preco AS registro_preco_10, t0.data_etapa_contrato AS data_etapa_contrato_11, t0.data_etapa_autorizacao_fornecimento AS data_etapa_autorizacao_fornecimento_12, t0.data_etapa_entrega_produto AS data_etapa_entrega_produto_13, t0.data_etapa_emissao_nf AS data_etapa_emissao_nf_14, t0.data_etapa_faturamento AS data_etapa_faturamento_15, t0.data_etapa_att AS data_etapa_att_16, t0.status AS status_17, t0.cod_etapa_atual AS cod_etapa_atual_18, t0.numero AS numero_19, t0.id_plataforma AS id_plataforma_20, t0.updated_at AS updated_at_21, t0.motivo_finalizacao AS motivo_finalizacao_22, t0.obs_finalizacao AS obs_finalizacao_23, t0.arquivo_finalizacao AS arquivo_finalizacao_24, t0.created_at AS created_at_25, t0.ativo AS ativo_26, t0.numero_ata AS numero_ata_27, t0.nome_do_cliente AS nome_do_cliente_28, t0.modelo_disputa AS modelo_disputa_29, t0.observacoes AS observacoes_30, t0.comissao_empresa AS comissao_empresa_31, t0.tipo_proposta AS tipo_proposta_32, t0.registrado_compras AS registrado_compras_33, t0.uasg_orgao AS uasg_orgao_34, t0.cliente_id AS cliente_id_35, t0.responsavel_id AS responsavel_id_36, t0.responsavel_comissionado_id AS responsavel_comissionado_id_37, t0.empresa_id AS empresa_id_38, t0.etapa_atual_id AS etapa_atual_id_39, t0.etapa_acolhimento_proposta_id AS etapa_acolhimento_proposta_id_40, t0.etapa_disputa_id AS etapa_disputa_id_41, t0.etapa_habilitacao_id AS etapa_habilitacao_id_42, t0.etapa_autorizacao_fornecimento_id AS etapa_autorizacao_fornecimento_id_43, t0.etapa_entrega_produto_id AS etapa_entrega_produto_id_44, t0.etapa_emissao_nf_id AS etapa_emissao_nf_id_45, t0.etapa_faturamento_id AS etapa_faturamento_id_46, t0.etapa_atestado_tecnico_id AS etapa_atestado_tecnico_id_47, t0.plataforma_id AS plataforma_id_48, t0.estado_id AS estado_id_49 FROM edital t0 WHERE t0.id = '1500';

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 = ?

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 = 1888;

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 = ?

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 = 1500;

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 = ?

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 = 1500;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pedido (
  data_pedido, prazo, status, numero_pedido,
  data_entrega, local_entrega, observacoes,
  arquivo, created_at, ativo, fatura_gerada,
  valor_frete, modalidade_frete, dados_pagamento,
  status_faturamento, numero_empenho,
  data_empenho, anexo_empenho, bloqueado_edicao,
  cobranca_id, solicitado_por_id,
  edital_id, responsavel_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO pedido (data_pedido, prazo, status, numero_pedido, data_entrega, local_entrega, observacoes, arquivo, created_at, ativo, fatura_gerada, valor_frete, modalidade_frete, dados_pagamento, status_faturamento, numero_empenho, data_empenho, anexo_empenho, bloqueado_edicao, cobranca_id, solicitado_por_id, edital_id, responsavel_id) VALUES ('2025-11-13', '2025-11-23', 'A', NULL, NULL, 'ENTREGA: Av. Argemiro Barbosa da Silva, 870, Bonfinópolis de Minas - MG, 38650-000', NULL, NULL, '2026-02-09 16:56:45', 1, 0, 0, 'CIF', NULL, 'N', '5062/2025', '2025-11-13', 'https://prime-comercial-storage.s3.sa-east-1.amazonaws.com/pedido/0b1eeae33d6c88e26c21fa16a636048cNAF%205062%20-%20VALLE%20MEDICA-698a3bfde546a.pdf', 0, 406, NULL, 1500, 23);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  quando, acao, componente, referencia,
  informacao_extra, quem_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO log (quando, acao, componente, referencia, informacao_extra, quem_id) VALUES ('2026-02-09 16:56:46', 'Novo registro', 'App\\Entity\\Operacional\\Compras\\Pedido', 332, NULL, 23);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.ativo AS ativo_2,
  t0.pedido_id AS pedido_id_3
FROM
  historico_status_pedido t0
WHERE
  t0.pedido_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ativo AS ativo_2, t0.pedido_id AS pedido_id_3 FROM historico_status_pedido t0 WHERE t0.pedido_id = 332 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO historico_status_pedido (ativo, pedido_id)
VALUES
  (?, ?)

INSERT INTO historico_status_pedido (ativo, pedido_id) VALUES (1, 332);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  quando, acao, componente, referencia,
  informacao_extra, quem_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO log (quando, acao, componente, referencia, informacao_extra, quem_id) VALUES ('2026-02-09 16:56:46', 'Novo registro', 'App\\Entity\\Operacional\\Compras\\HistoricoStatusPedido', 332, NULL, 23);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO movimentacao_historico (
  status_anterior, novo_status, data,
  observacoes, ativo, movimentacao_id,
  usuario_id, tipo
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO movimentacao_historico (status_anterior, novo_status, data, observacoes, ativo, movimentacao_id, usuario_id, tipo) VALUES (NULL, 'A', '2026-02-09 16:56:46', 'Pedido Aberto', 1, 332, 23, 'historico');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO log (
  quando, acao, componente, referencia,
  informacao_extra, quem_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO log (quando, acao, componente, referencia, informacao_extra, quem_id) VALUES ('2026-02-09 16:56:46', 'Novo registro', 'App\\Entity\\Operacional\\Compras\\MovimentacaoHistorico', 365, NULL, 23);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.tipo AS tipo_3,
  t0.lido AS lido_4,
  t0.link AS link_5,
  t0.created_at AS created_at_6,
  t0.notificar_em AS notificar_em_7,
  t0.lida_em AS lida_em_8,
  t0.entidade_relacionada AS entidade_relacionada_9,
  t0.id_relacionado AS id_relacionado_10,
  t0.pertence_a_id AS pertence_a_id_11,
  t12.id AS id_13,
  t12.titulo AS titulo_14,
  t12.descricao AS descricao_15,
  t12.dia AS dia_16,
  t12.hora AS hora_17,
  t12.created_at AS created_at_18,
  t12.updated_at AS updated_at_19,
  t12.ativo AS ativo_20,
  t12.situacao AS situacao_21,
  t12.tipo AS tipo_22,
  t12.entidade_vinculada AS entidade_vinculada_23,
  t12.id_vinculado AS id_vinculado_24,
  t12.gerado_automaticamente AS gerado_automaticamente_25,
  t12.criado_por_id AS criado_por_id_26,
  t12.empresa_id AS empresa_id_27,
  t12.responsavel_id AS responsavel_id_28,
  t12.notificacao_id AS notificacao_id_29
FROM
  notificacao_sistema t0
  LEFT JOIN tarefa t12 ON t12.notificacao_id = t0.id
WHERE
  t0.entidade_relacionada = ?
  AND t0.id_relacionado = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.tipo AS tipo_3, t0.lido AS lido_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.notificar_em AS notificar_em_7, t0.lida_em AS lida_em_8, t0.entidade_relacionada AS entidade_relacionada_9, t0.id_relacionado AS id_relacionado_10, t0.pertence_a_id AS pertence_a_id_11, t12.id AS id_13, t12.titulo AS titulo_14, t12.descricao AS descricao_15, t12.dia AS dia_16, t12.hora AS hora_17, t12.created_at AS created_at_18, t12.updated_at AS updated_at_19, t12.ativo AS ativo_20, t12.situacao AS situacao_21, t12.tipo AS tipo_22, t12.entidade_vinculada AS entidade_vinculada_23, t12.id_vinculado AS id_vinculado_24, t12.gerado_automaticamente AS gerado_automaticamente_25, t12.criado_por_id AS criado_por_id_26, t12.empresa_id AS empresa_id_27, t12.responsavel_id AS responsavel_id_28, t12.notificacao_id AS notificacao_id_29 FROM notificacao_sistema t0 LEFT JOIN tarefa t12 ON t12.notificacao_id = t0.id WHERE t0.entidade_relacionada = 'Pedido' AND t0.id_relacionado = 332;