Query Metrics
47
Database Queries
11
Different statements
381.92 ms
Query time
8
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
103.27 ms (27.04%) |
9 |
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.id = ? AND ((t0.franquia_id = '1'))
Parameters:
[
1743
]
|
|
83.92 ms (21.97%) |
9 |
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 = '1'))
Parameters:
[
4786
]
|
|
56.69 ms (14.84%) |
10 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.aprovado_em AS aprovado_em_4, t0.numero AS numero_5, t0.status AS status_6, t0.cobrar_art AS cobrar_art_7, t0.percentual_relatorio_tecnico AS percentual_relatorio_tecnico_8, t0.is_cobra_relatorio_tecnico AS is_cobra_relatorio_tecnico_9, t0.notas AS notas_10, t0.endereco_obra AS endereco_obra_11, t0.destinatario_email AS destinatario_email_12, t0.valor_desconto AS valor_desconto_13, t0.label_valor_adicional_desconto AS label_valor_adicional_desconto_14, t0.os_id AS os_id_15, t0.cadastrado_por_id AS cadastrado_por_id_16, t0.user_ultima_alteracao_id AS user_ultima_alteracao_id_17, t0.franquia_id AS franquia_id_18 FROM boletim_medicao t0 WHERE t0.id = ? AND ((t0.franquia_id = '1'))
Parameters:
[
3827
]
|
|
55.64 ms (14.57%) |
12 |
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:
[
2057
]
|
|
44.58 ms (11.67%) |
1 |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM conta_receber c0_ WHERE (c0_.vencimento >= ? AND c0_.vencimento <= ?) AND (c0_.franquia_id = '1')
Parameters:
[ "2026-03-01 00:00:00" "2026-03-31 00:00:00" ] |
|
11.40 ms (2.98%) |
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:
[
68
]
|
|
6.78 ms (1.77%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.vencimento AS vencimento_1, c0_.id AS id_2 FROM conta_receber c0_ WHERE (c0_.vencimento >= ? AND c0_.vencimento <= ?) AND (c0_.franquia_id = '1') ORDER BY c0_.vencimento DESC, c0_.id DESC LIMIT 32
Parameters:
[ "2026-03-01 00:00:00" "2026-03-31 00:00:00" ] |
|
6.23 ms (1.63%) |
1 |
SELECT c0_.id AS id_0, c0_.vencimento AS vencimento_1, c0_.valor_bruto AS valor_bruto_2, c0_.valor_liquido AS valor_liquido_3, c0_.pago_em AS pago_em_4, c0_.data_emissao_nota AS data_emissao_nota_5, c0_.numero_nota AS numero_nota_6, c0_.nota_fiscal AS nota_fiscal_7, c0_.nota_fiscal_original AS nota_fiscal_original_8, c0_.comprovante_pagamento AS comprovante_pagamento_9, c0_.comprovante_pagamento_original AS comprovante_pagamento_original_10, c0_.descricao AS descricao_11, c0_.conta_bancaria AS conta_bancaria_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c0_.cliente_id AS cliente_id_15, c0_.cadastrado_por_id AS cadastrado_por_id_16, c0_.user_ultima_alteracao_id AS user_ultima_alteracao_id_17, c0_.classificacao_id AS classificacao_id_18, c0_.boletim_medicao_id AS boletim_medicao_id_19, c0_.fluxo_caixa_id AS fluxo_caixa_id_20, c0_.franquia_id AS franquia_id_21 FROM conta_receber c0_ WHERE (c0_.vencimento >= ? AND c0_.vencimento <= ? AND c0_.id IN (?)) AND (c0_.franquia_id = '1') ORDER BY c0_.vencimento DESC, c0_.id DESC
Parameters:
[ "2026-03-01 00:00:00" "2026-03-31 00:00:00" [ 5410 5409 5400 5397 5411 5396 5381 5380 5379 5372 5377 5360 5359 5358 5357 5356 5355 5334 5354 5333 ] ] |
|
5.82 ms (1.52%) |
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:
[
68
]
|
|
4.59 ms (1.20%) |
1 |
SELECT c0_.id AS id_0, c0_.titulo AS titulo_1, c0_.classificacao AS classificacao_2, c0_.descricao AS descricao_3, c0_.is_receita AS is_receita_4, c0_.meta_percentual_sobre_faturamento AS meta_percentual_sobre_faturamento_5 FROM centro_custo c0_ WHERE c0_.is_receita = ? ORDER BY c0_.titulo ASC
Parameters:
[
1
]
|
|
2.99 ms (0.78%) |
1 |
SELECT c0_.id AS id_0, c0_.titulo AS titulo_1, c0_.classificacao AS classificacao_2, c0_.descricao AS descricao_3, c0_.is_receita AS is_receita_4, c0_.meta_percentual_sobre_faturamento AS meta_percentual_sobre_faturamento_5 FROM centro_custo c0_
Parameters:
[] |
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 |
|
| FOS\UserBundle\Model\Group | No errors. |
| Sonata\UserBundle\Entity\BaseGroup | No errors. |
| App\Application\Sonata\UserBundle\Entity\Group | No errors. |
| App\Entity\ContaReceber |
|
| App\Entity\BoletimMedicao |
|
| App\Entity\OrdemDeServico |
|
| App\Entity\PropostaComercial |
|
| App\Entity\CentroCusto | No errors. |
| App\Entity\Cliente |
|
| App\Entity\DiretorCliente | No errors. |
| App\Entity\ContratoCliente |
|
| App\Entity\ClienteContato | No errors. |
| App\Entity\ServicoBoletimMedicao | No errors. |
| App\Entity\AcessoCliente | No errors. |
| App\Entity\DiarioObra |
|
| App\Entity\Concretagem | No errors. |
| App\Entity\StatusProposta | No errors. |
| App\Entity\ServicoPropostaComercial | No errors. |