Query Metrics
98
Database Queries
8
Different statements
558.73 ms
Query time
7
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
185.63 ms (33.22%) |
32 |
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:
[
2784
]
|
|
164.22 ms (29.39%) |
32 |
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 = '4'))
Parameters:
[
1142
]
|
|
161.36 ms (28.88%) |
29 |
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:
[
1713
]
|
|
16.77 ms (3.00%) |
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_ WHERE (r0_.id IN (?)) AND (r0_.franquia_id = '4') ORDER BY r0_.id ASC
Parameters:
[
[
86
87
91
92
93
95
96
97
98
99
102
103
104
105
106
107
108
109
110
111
112
115
117
120
121
123
125
127
128
130
132
134
]
]
|
|
12.13 ms (2.17%) |
1 |
SELECT count(DISTINCT r0_.id) AS sclr_0 FROM relatorio_tecnico_massa r0_ WHERE (r0_.franquia_id = '4')
Parameters:
[] |
|
8.83 ms (1.58%) |
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
]
|
|
6.13 ms (1.10%) |
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
]
|
|
3.67 ms (0.66%) |
1 |
SELECT DISTINCT r0_.id AS id_0, r0_.id AS id_1 FROM relatorio_tecnico_massa r0_ WHERE (r0_.franquia_id = '4') ORDER BY r0_.id ASC LIMIT 32
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\RelatorioTecnicoMassa |
|
| App\Entity\OrdemDeServico |
|
| App\Entity\PropostaComercial |
|
| App\Entity\Cliente |
|
| App\Entity\AcessoCliente | No errors. |
| App\Entity\DiarioObra |
|
| App\Entity\Concretagem | No errors. |
| App\Entity\StatusProposta | No errors. |
| App\Entity\ServicoPropostaComercial | No errors. |
| App\Entity\DiretorCliente | No errors. |
| App\Entity\ContratoCliente |
|
| App\Entity\ClienteContato | No errors. |