Query Metrics
6
Database Queries
6
Different statements
19.06 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.71 ms |
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:
[
11
]
|
| 2 | 3.31 ms |
SELECT t0.id AS id_1, t0.quantidade AS quantidade_2, t0.proposta_id AS proposta_id_3, t0.boletim_id AS boletim_id_4, t0.servico_id AS servico_id_5 FROM servico_boletim_medicao t0 WHERE t0.id = ?
Parameters:
[
"15705"
]
|
| 3 | 3.07 ms |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.quantidade AS quantidade_3, t0.percentual_entregue AS percentual_entregue_4, t0.unidade AS unidade_5, t0.servico_id AS servico_id_6, t0.proposta_id AS proposta_id_7 FROM servico_proposta_comercial t0 WHERE t0.id = ?
Parameters:
[
18564
]
|
| 4 | 0.75 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 2.69 ms |
UPDATE servico_boletim_medicao SET quantidade = ? WHERE id = ?
Parameters:
[ 0 15705 ] |
| 6 | 3.54 ms |
"COMMIT"
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\ServicoBoletimMedicao | No errors. |
| App\Entity\PropostaComercial |
|
| App\Entity\BoletimMedicao |
|
| App\Entity\ServicoPropostaComercial | No errors. |
| App\Entity\Servico |
|
| App\Entity\OrdemDeServico |
|
| App\Entity\AcessoCliente | No errors. |
| App\Entity\Cliente |
|
| App\Entity\StatusProposta | No errors. |