https://gestor.ltec.eng.br/app/acessocliente/228/edit

Query Metrics

10 Database Queries
6 Different statements
65.78 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
25.21 ms
(38.33%)
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
Parameters:
[]
12.85 ms
(19.53%)
5
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 = ? AND ((t0.franquia_id = '4'))
Parameters:
[
  4752
]
12.09 ms
(18.37%)
1
SELECT t0.name AS name_1, t0.roles AS roles_2, t0.id AS id_3 FROM fos_user_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = ?
Parameters:
[
  13
]
7.10 ms
(10.79%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.date_of_birth AS date_of_birth_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.website AS website_17, t0.biography AS biography_18, t0.gender AS gender_19, t0.locale AS locale_20, t0.timezone AS timezone_21, t0.phone AS phone_22, t0.facebook_uid AS facebook_uid_23, t0.facebook_name AS facebook_name_24, t0.facebook_data AS facebook_data_25, t0.twitter_uid AS twitter_uid_26, t0.twitter_name AS twitter_name_27, t0.twitter_data AS twitter_data_28, t0.gplus_uid AS gplus_uid_29, t0.gplus_name AS gplus_name_30, t0.gplus_data AS gplus_data_31, t0.token AS token_32, t0.two_step_code AS two_step_code_33, t0.cpf_cnpj AS cpf_cnpj_34, t0.avatar_original AS avatar_original_35, t0.avatar AS avatar_36, t0.uf AS uf_37, t0.id AS id_38, t0.franquia_id AS franquia_id_39 FROM fos_user_user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  13
]
5.37 ms
(8.16%)
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.id = ?
Parameters:
[
  "228"
]
3.17 ms
(4.81%)
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 = ? AND ((t0.franquia_id = '4'))
Parameters:
[
  228
]

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.
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.
FOS\UserBundle\Model\Group No errors.
Sonata\UserBundle\Entity\BaseGroup No errors.
App\Application\Sonata\UserBundle\Entity\Group 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\DiretorCliente No errors.
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.
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.
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\StatusProposta No errors.
App\Entity\ServicoPropostaComercial No errors.