Query Metrics

47 Database Queries
11 Different statements
381.92 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

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
  • 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\ContaReceber
  • The association App\Entity\ContaReceber#cadastradoPor refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#clientes 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\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.
App\Entity\CentroCusto 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\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.
App\Entity\ServicoBoletimMedicao No errors.
App\Entity\AcessoCliente 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.