Query Metrics
8
Database Queries
8
Different statements
112.30 ms
Query time
10
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.68 ms |
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"
]
|
| 2 | 5.77 ms |
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" ] |
| 3 | 11.00 ms |
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
]
|
| 4 | 70.12 ms |
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
]
|
| 5 | 2.84 ms |
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
]
|
| 6 | 2.59 ms |
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
]
|
| 7 | 2.16 ms |
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
]
|
| 8 | 7.13 ms |
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
]
|
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 |
|
| App\Entity\OrdemDeServico |
|
| App\Entity\PropostaComercial |
|
| FOS\UserBundle\Model\User | No errors. |
| Sonata\UserBundle\Entity\BaseUser | No errors. |
| App\Application\Sonata\UserBundle\Entity\User | No errors. |
| App\Entity\Empresa |
|
| App\Entity\DiarioObra |
|
| App\Entity\Concretagem | No errors. |
| App\Entity\RelatorioTecnico |
|
| App\Entity\BoletimMedicao |
|
| App\Entity\RelatorioTecnicoMassa |
|
| App\Entity\RelatorioIndividualMassa |
|
| App\Entity\StatusProposta | No errors. |
| App\Entity\ServicoPropostaComercial | No errors. |
| App\Entity\DiretorCliente | No errors. |
| App\Entity\ContratoCliente |
|
| App\Entity\ClienteContato | No errors. |