GET https://licita360.com.br/erp/comum/nota-fiscal-eletronica/1088/visualizar

Query Metrics

18 Database Queries
16 Different statements
51.20 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.52 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:
[
  1
]
2 2.91 ms
SELECT t0.id AS id_3, t0.natureza_operacao AS natureza_operacao_4, t0.data_emissao AS data_emissao_5, t0.data_entrada_saida AS data_entrada_saida_6, t0.tipo_documento AS tipo_documento_7, t0.finalidade_emissao AS finalidade_emissao_8, t0.valor_frete AS valor_frete_9, t0.valor_seguro AS valor_seguro_10, t0.valor_total AS valor_total_11, t0.valor_produtos AS valor_produtos_12, t0.modalidade_frete AS modalidade_frete_13, t0.cfop AS cfop_14, t0.observacao AS observacao_15, t0.situacao AS situacao_16, t0.consumidor_final AS consumidor_final_17, t0.presenca_comprador AS presenca_comprador_18, t0.local_destino AS local_destino_19, t0.nf_referencia AS nf_referencia_20, t0.nf_status AS nf_status_21, t0.nf_status_sefaz AS nf_status_sefaz_22, t0.nf_mensagem_sefaz AS nf_mensagem_sefaz_23, t0.nf_chave_nfe AS nf_chave_nfe_24, t0.nf_numero AS nf_numero_25, t0.nf_serie AS nf_serie_26, t0.nf_caminho_xml_nota_fiscal AS nf_caminho_xml_nota_fiscal_27, t0.nf_caminho_danfe AS nf_caminho_danfe_28, t0.ativo AS ativo_29, t0.codigo_erro AS codigo_erro_30, t0.mensagem_erro AS mensagem_erro_31, t0.veiculo_placa AS veiculo_placa_32, t0.nf_caminho_danfe_aws AS nf_caminho_danfe_aws_33, t0.referencia AS referencia_34, t0.nf_caminho_xml_cancelada AS nf_caminho_xml_cancelada_35, t0.nf_caminho_danfe_cancelada AS nf_caminho_danfe_cancelada_36, t0.justificativa_cancelamento AS justificativa_cancelamento_37, t0.gerar_conta_receber AS gerar_conta_receber_38, t0.clonado_de AS clonado_de_39, t0.empresa_id AS empresa_id_40, t0.cliente_id AS cliente_id_41, t0.transportadora_id AS transportadora_id_42, t0.criado_por_id AS criado_por_id_43, t0.tipo_fatura, t1.pedido_id AS pedido_id_44 FROM nota_fiscal_eletronica t0 LEFT JOIN nota_fiscal_eletronica_pedido t1 ON t0.id = t1.id LEFT JOIN nota_fiscal_eletronica_pedido_xml t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  "1088"
]
3 2.61 ms
SELECT t0.id AS id_1, t0.correcao AS correcao_2, t0.data_evento AS data_evento_3, t0.status AS status_4, t0.status_sefaz AS status_sefaz_5, t0.mensagem_sefaz AS mensagem_sefaz_6, t0.caminho_xml AS caminho_xml_7, t0.caminho AS caminho_8, t0.numero AS numero_9, t0.caminho_aws AS caminho_aws_10, t0.caminho_xml_aws AS caminho_xml_aws_11, t0.nota_fiscal_eletronica_id AS nota_fiscal_eletronica_id_12 FROM nfe_carta_correcao t0 WHERE t0.nota_fiscal_eletronica_id = ?
Parameters:
[
  1088
]
4 2.58 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, t0.template AS template_17, t0.logitpo_empresa AS logitpo_empresa_18, t0.assinatura_diretor AS assinatura_diretor_19, t0.data_abertura AS data_abertura_20, t0.regime_tributario AS regime_tributario_21, t0.info_adicional_nf AS info_adicional_nf_22, t0.cpf_proprietario AS cpf_proprietario_23, t0.token_focus AS token_focus_24, t0.token_focus_homologacao AS token_focus_homologacao_25, t0.prazo_pagamento_emissao_nf AS prazo_pagamento_emissao_nf_26, t1.endereco_id AS endereco_id_27, t1.tipo_cadastro FROM empresa t0 INNER JOIN dados_juridica t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  115
]
5 2.55 ms
SELECT t0.id AS id_1, t0.saldo AS saldo_2, t0.empresa_id AS empresa_id_3 FROM caixa_empresa t0 WHERE t0.empresa_id = ?
Parameters:
[
  115
]
6 2.54 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:
[
  379
]
7 2.27 ms
SELECT t0.id AS id_1, t0.logradouro AS logradouro_2, t0.numero AS numero_3, t0.complemento AS complemento_4, t0.cep AS cep_5, t0.bairro AS bairro_6, t0.created_at AS created_at_7, t0.ativo AS ativo_8, t0.cidade_id AS cidade_id_9 FROM endereco t0 WHERE t0.id = ?
Parameters:
[
  419
]
8 3.85 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.estado_id AS estado_id_5 FROM cidade t0 WHERE t0.id = ?
Parameters:
[
  1721000
]
9 3.29 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.uf AS uf_3, t0.regiao AS regiao_4, t0.created_at AS created_at_5, t0.ativo AS ativo_6 FROM estado t0 WHERE t0.id = ?
Parameters:
[
  28
]
10 2.53 ms
SELECT t0.id AS id_1, t0.numero_item AS numero_item_2, t0.unidade_comercial AS unidade_comercial_3, t0.quantidade_comercial AS quantidade_comercial_4, t0.icms_origem AS icms_origem_5, t0.unidade_tributavel AS unidade_tributavel_6, t0.quantidade_tributavel AS quantidade_tributavel_7, t0.valor_bruto AS valor_bruto_8, t0.icms_situacao_tributaria AS icms_situacao_tributaria_9, t0.pis_situacao_tributaria AS pis_situacao_tributaria_10, t0.cofins_situacao_tributaria AS cofins_situacao_tributaria_11, t0.ativo AS ativo_12, t0.cfop AS cfop_13, t0.valor_unitario_comercial AS valor_unitario_comercial_14, t0.valor_unitario_tributavel AS valor_unitario_tributavel_15, t0.valor_frete AS valor_frete_16, t0.valor_seguro AS valor_seguro_17, t0.nome_item AS nome_item_18, t0.produto_id AS produto_id_19, t0.nota_fiscal_eletronica_id AS nota_fiscal_eletronica_id_20, t0.volume_produto_id AS volume_produto_id_21 FROM item_nfe t0 WHERE t0.nota_fiscal_eletronica_id = ?
Parameters:
[
  1088
]
11 2.27 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.altura AS altura_3, t0.largura AS largura_4, t0.profundidade AS profundidade_5, t0.peso AS peso_6, t0.cod_interno AS cod_interno_7, t0.produto_id AS produto_id_8 FROM volumes_produto t0 WHERE t0.id = ?
Parameters:
[
  120
]
12 2.05 ms
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4, t0.ncm AS ncm_5, t0.cest AS cest_6, t0.estoque AS estoque_7, t0.preco_medio AS preco_medio_8, t0.unidade_referencia AS unidade_referencia_9, t0.ncm_descricao AS ncm_descricao_10, t0.situacao AS situacao_11, t0.marca_id AS marca_id_12, t0.modelo_id AS modelo_id_13 FROM produto t0 WHERE t0.id = ?
Parameters:
[
  197
]
13 2.87 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.altura AS altura_3, t0.largura AS largura_4, t0.profundidade AS profundidade_5, t0.peso AS peso_6, t0.cod_interno AS cod_interno_7, t0.produto_id AS produto_id_8 FROM volumes_produto t0 WHERE t0.id = ?
Parameters:
[
  121
]
14 2.14 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.altura AS altura_3, t0.largura AS largura_4, t0.profundidade AS profundidade_5, t0.peso AS peso_6, t0.cod_interno AS cod_interno_7, t0.produto_id AS produto_id_8 FROM volumes_produto t0 WHERE t0.id = ?
Parameters:
[
  122
]
15 2.18 ms
SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.especie AS especie_3, t0.numero AS numero_4, t0.peso_liquido AS peso_liquido_5, t0.peso_bruto AS peso_bruto_6, t0.nota_fiscal_eletronica_id AS nota_fiscal_eletronica_id_7, t0.marca_id AS marca_id_8 FROM volume t0 WHERE t0.nota_fiscal_eletronica_id = ?
Parameters:
[
  1088
]
16 2.12 ms
SELECT t0.id AS id_1, t0.descricao AS descricao_2, t0.created_at AS created_at_3, t0.ativo AS ativo_4 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  15
]
17 4.40 ms
SELECT t0.id AS id_1, t0.chave_nfe AS chave_nfe_2, t0.nota_fiscal_eletronica_id AS nota_fiscal_eletronica_id_3 FROM nfe_referenciada t0 WHERE t0.nota_fiscal_eletronica_id = ?
Parameters:
[
  1088
]
18 5.52 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.data_vencimento AS data_vencimento_3, t0.valor AS valor_4, t0.nota_fiscal_eletronica_id AS nota_fiscal_eletronica_id_5, t0.conta_id AS conta_id_6 FROM nfe_duplicata t0 WHERE t0.nota_fiscal_eletronica_id = ?
Parameters:
[
  1088
]

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.

Entities Mapping

Class Mapping errors
App\Entity\RecursosHumanos\Colaborador No errors.
App\Entity\Comum\Endereco No errors.
App\Entity\RecursosHumanos\Cargo No errors.
App\Entity\Empresas\DadosJuridica No errors.
App\Entity\Empresas\Empresa No errors.
App\Entity\Operacional\Vendas\Edital\Edital
  • The association App\Entity\Operacional\Vendas\Edital\Edital#estado refers to the inverse side field App\Entity\Comum\Estado#edital which does not exist.
App\Entity\RecursosHumanos\ContasBancariasColaborador No errors.
App\Entity\Comum\Arquivo No errors.
App\Entity\RecursosHumanos\ArquivoColaborador No errors.
App\Entity\RecursosHumanos\ContaEmail No errors.
App\Entity\Operacional\Compras\Solicitacao No errors.
App\Entity\Financeiro\NFE\NotaFiscalEletronica No errors.
App\Entity\Financeiro\NFE\NotaFiscalEletronicaPedido No errors.
App\Entity\Financeiro\NFE\NotaFiscalEletronicaPedidoXML No errors.
App\Entity\Operacional\Vendas\Cliente No errors.
App\Entity\Operacional\Logistica\Transportadora No errors.
App\Entity\Operacional\Compras\Pedido
  • The mappings App\Entity\Operacional\Compras\Pedido#historicoStatus and App\Entity\Operacional\Compras\HistoricoStatusPedido#pedido are inconsistent with each other.
App\Entity\Financeiro\NFE\ItemNfe No errors.
App\Entity\Financeiro\NFE\VolumeNfe No errors.
App\Entity\Financeiro\NFE\NfeReferenciada No errors.
App\Entity\Financeiro\NFE\NfeDuplicata No errors.
App\Entity\Financeiro\NFE\NfeCartaCorrecao No errors.
App\Entity\Empresas\AtividadeComercial No errors.
App\Entity\Empresas\ArquivoEmpresa No errors.
App\Entity\Empresas\ContaBancaria No errors.
App\Entity\Empresas\Departamento No errors.
App\Entity\Financeiro\ContaPagar No errors.
App\Entity\Financeiro\ContaReceber No errors.
App\Entity\Financeiro\CaixaEmpresa No errors.
App\Entity\Financeiro\SaidaCaixa No errors.
App\Entity\Financeiro\EntradaCaixa No errors.
App\Entity\Operacional\Vendas\Edital\EtapaProcesso No errors.
App\Entity\Operacional\Vendas\Edital\EtapaContrato No errors.
App\Entity\Operacional\Vendas\Edital\PlataformaPregao No errors.
App\Entity\Financeiro\ExtratoBancario No errors.
App\Entity\Comum\Tarefa No errors.
App\Entity\Juridico\Notificacao No errors.
App\Entity\Comum\Cidade No errors.
App\Entity\Comum\Estado No errors.
App\Entity\Operacional\Produtos\Produto No errors.
App\Entity\Operacional\Produtos\Volume No errors.
App\Entity\Operacional\Produtos\Marca No errors.
App\Entity\Operacional\Produtos\Modelo No errors.
App\Entity\Operacional\Vendas\Edital\ItemEdital No errors.
App\Entity\Operacional\Compras\ItemPedido No errors.
App\Entity\Operacional\Vendas\Proposta\ItemPropostaFinal No errors.
App\Entity\Operacional\Vendas\Proposta\ItemProposta No errors.
App\Entity\Operacional\Compras\ItemCotacaoProduto No errors.
App\Entity\Operacional\Compras\ItemCotacaoFrete No errors.
App\Entity\Financeiro\NFE\Lacre No errors.