https://gestor.ltec.eng.br/acesso-cliente/relatorios-disponiveis Return to referer URL

Query Metrics

8 Database Queries
8 Different statements
112.30 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
70.12 ms
(62.44%)
1
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.status AS status_2, r0_.enviado_para_cliente_em AS enviado_para_cliente_em_3, r0_.responsavel AS responsavel_4, r0_.laboratorista AS laboratorista_5, r0_.conclusao AS conclusao_6, r0_.logo AS logo_7, r0_.logo_original AS logo_original_8, r0_.updated_at AS updated_at_9, r0_.is_finalizado AS is_finalizado_10, r0_.finalizado_em AS finalizado_em_11, r0_.relatorio_anexo AS relatorio_anexo_12, r0_.relatorio_anexo_file_orignal AS relatorio_anexo_file_orignal_13, r0_.destinatario_nome AS destinatario_nome_14, r0_.destinatario_email AS destinatario_email_15, r0_.numero_bm AS numero_bm_16, r0_.is_liberado_para_cliente AS is_liberado_para_cliente_17, r0_.ordem_servico_id AS ordem_servico_id_18, r0_.cadastrado_por_id AS cadastrado_por_id_19, r0_.user_ultima_alteracao_id AS user_ultima_alteracao_id_20, r0_.boletim_medicao_id AS boletim_medicao_id_21, r0_.franquia_id AS franquia_id_22 FROM relatorio_tecnico r0_ LEFT JOIN ordem_de_servico o1_ ON r0_.ordem_servico_id = o1_.id LEFT JOIN proposta_comercial p2_ ON o1_.proposta_id = p2_.id WHERE p2_.cliente_id = ? ORDER BY r0_.id DESC
Parameters:
[
  1961
]
11.00 ms
(9.80%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.observacoes AS observacoes_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.previsao_entrega AS previsao_entrega_6, t0.finalizada_em AS finalizada_em_7, t0.dias_interrupcoes AS dias_interrupcoes_8, t0.pergunta_um_satisfacao AS pergunta_um_satisfacao_9, t0.perunta_dois_satisfacao AS perunta_dois_satisfacao_10, t0.pergunta_tres_satisfacao AS pergunta_tres_satisfacao_11, t0.perunta_quatro_satisfacao AS perunta_quatro_satisfacao_12, t0.pergunta_cinco_satisfacao AS pergunta_cinco_satisfacao_13, t0.cno AS cno_14, t0.proposta_id AS proposta_id_15, t0.cadastrado_por_id AS cadastrado_por_id_16, t0.user_ultima_alteracao_id AS user_ultima_alteracao_id_17, t0.acesso_cliente_id AS acesso_cliente_id_18, t0.franquia_id AS franquia_id_19 FROM ordem_de_servico t0 WHERE t0.acesso_cliente_id = ?
Parameters:
[
  288
]
10.68 ms
(9.51%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.senha AS senha_3, t0.token AS token_4, t0.data_inicial AS data_inicial_5, t0.data_final AS data_final_6, t0.cliente_id AS cliente_id_7 FROM acesso_cliente t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "Lt8XWAqcxD64IyvVXoWVYQIEHkl9NdlYEBmwPktr"
]
7.13 ms
(6.35%)
1
SELECT t0.id AS id_1, t0.cnpj AS cnpj_2, t0.razao_social AS razao_social_3, t0.telefone AS telefone_4, t0.email AS email_5, t0.nome_contato_principal AS nome_contato_principal_6, t0.cargo_contato_principal AS cargo_contato_principal_7, t0.inscricao_estadual AS inscricao_estadual_8, t0.inscricao_municipal AS inscricao_municipal_9, t0.is_substituto_tributario AS is_substituto_tributario_10, t0.cep AS cep_11, t0.zoom_mapa AS zoom_mapa_12, t0.logradouro AS logradouro_13, t0.cidade AS cidade_14, t0.bairro AS bairro_15, t0.numero AS numero_16, t0.complemento AS complemento_17, t0.estado AS estado_18, t0.latitude AS latitude_19, t0.longitude AS longitude_20, t0.endereco AS endereco_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.cadastrado_por_id AS cadastrado_por_id_24, t0.user_ultima_alteracao_id AS user_ultima_alteracao_id_25, t0.franquia_id AS franquia_id_26 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
  1961
]
5.77 ms
(5.14%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.senha AS senha_3, t0.token AS token_4, t0.data_inicial AS data_inicial_5, t0.data_final AS data_final_6, t0.cliente_id AS cliente_id_7 FROM acesso_cliente t0 WHERE t0.email = ? AND t0.token = ?
Parameters:
[
  "adiel@maesaconstrucoes.com.br"
  "Lt8XWAqcxD64IyvVXoWVYQIEHkl9NdlYEBmwPktr"
]
2.84 ms
(2.53%)
1
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.os_id AS os_id_2, r0_.cadastrado_por_id AS cadastrado_por_id_3, r0_.user_ultima_alteracao_id AS user_ultima_alteracao_id_4, r0_.franquia_id AS franquia_id_5 FROM relatorio_tecnico_massa r0_ LEFT JOIN ordem_de_servico o1_ ON r0_.os_id = o1_.id LEFT JOIN proposta_comercial p2_ ON o1_.proposta_id = p2_.id WHERE p2_.cliente_id = ? ORDER BY r0_.id DESC
Parameters:
[
  1961
]
2.59 ms
(2.31%)
1
SELECT t0.id AS id_1, t0.data AS data_2, t0.peca_concretada AS peca_concretada_3, t0.numero AS numero_4, t0.path_file AS path_file_5, t0.titulo AS titulo_6, t0.created_at AS created_at_7, t0.os_id AS os_id_8, t0.relatorio_tecnico_massa_id AS relatorio_tecnico_massa_id_9, t0.cadastrado_por_id AS cadastrado_por_id_10, t0.user_ultima_alteracao_id AS user_ultima_alteracao_id_11, t0.franquia_id AS franquia_id_12 FROM relatorio_individual_massa t0 WHERE t0.relatorio_tecnico_massa_id = ? ORDER BY t0.numero ASC, t0.titulo ASC
Parameters:
[
  284
]
2.16 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.destinatario_nome AS destinatario_nome_3, t0.destinatario_email AS destinatario_email_4, t0.destinatario_telefone AS destinatario_telefone_5, t0.destinatario_cargo AS destinatario_cargo_6, t0.numero AS numero_7, t0.tipo AS tipo_8, t0.created_at AS created_at_9, t0.descricao_endereco_obra AS descricao_endereco_obra_10, t0.num_revisao AS num_revisao_11, t0.updated_at AS updated_at_12, t0.ano_proposta AS ano_proposta_13, t0.valor_rt AS valor_rt_14, t0.cobra_art AS cobra_art_15, t0.percentual_relatorio_tecnico AS percentual_relatorio_tecnico_16, t0.percentual_impostos AS percentual_impostos_17, t0.is_cobra_imposto AS is_cobra_imposto_18, t0.is_cobra_relatorio_tecnico AS is_cobra_relatorio_tecnico_19, t0.notas AS notas_20, t0.condicoes_pagamento AS condicoes_pagamento_21, t0.have_new_version AS have_new_version_22, t0.cliente_id AS cliente_id_23, t0.status_id AS status_id_24, t0.cadastrado_por_id AS cadastrado_por_id_25, t0.user_ultima_alteracao_id AS user_ultima_alteracao_id_26, t0.proposta_original_id AS proposta_original_id_27, t0.proposta_base_id AS proposta_base_id_28, t0.franquia_id AS franquia_id_29 FROM proposta_comercial t0 WHERE t0.id = ?
Parameters:
[
  4709
]

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\SaidaItemAlmoxarifado No errors.
App\Entity\DevolucaoItemAlmoxarifado No errors.
App\Entity\AcessoCliente No errors.
App\Entity\Cliente
  • The association App\Entity\Cliente#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#clientes which does not exist.
App\Entity\OrdemDeServico
  • The association App\Entity\OrdemDeServico#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#ordensDeServico which does not exist.
App\Entity\PropostaComercial
  • The association App\Entity\PropostaComercial#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#propostasComerciais which does not exist.
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Application\Sonata\UserBundle\Entity\User No errors.
App\Entity\Empresa
  • The field App\Entity\Empresa#usuarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Application\Sonata\UserBundle\Entity\User#franquia does not contain the required 'inversedBy="usuarios"' attribute.
  • The association App\Entity\Empresa#usuarioAdmin refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#empresasUsuarios which does not exist.
App\Entity\DiarioObra
  • The association App\Entity\DiarioObra#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#propostasComerciais which does not exist.
App\Entity\Concretagem No errors.
App\Entity\RelatorioTecnico
  • The association App\Entity\RelatorioTecnico#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#propostasComerciais which does not exist.
App\Entity\BoletimMedicao
  • The association App\Entity\BoletimMedicao#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#propostasComerciais which does not exist.
App\Entity\RelatorioTecnicoMassa
  • The association App\Entity\RelatorioTecnicoMassa#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#ordensDeServico which does not exist.
App\Entity\RelatorioIndividualMassa
  • The association App\Entity\RelatorioIndividualMassa#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#ordensDeServico which does not exist.
App\Entity\StatusProposta No errors.
App\Entity\ServicoPropostaComercial No errors.
App\Entity\DiretorCliente No errors.
App\Entity\ContratoCliente
  • The association App\Entity\ContratoCliente#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#propostasComerciais which does not exist.
App\Entity\ClienteContato No errors.