Query Metrics
139
Database Queries
9
Different statements
31.82 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
24.00 ms (75.42%) |
95 |
SELECT t0.id AS id_1, t0.importe AS importe_2, t0.fecha_creacion AS fecha_creacion_3, t0.fecha_actualizacion AS fecha_actualizacion_4, t0.precarga_id AS precarga_id_5, t0.tipo_tramite_id AS tipo_tramite_id_6 FROM mc_precarga_tipo_tramites t0 WHERE t0.precarga_id = ?
Parameters:
[
95
]
|
4.34 ms (13.63%) |
23 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.razon_social AS razon_social_3, t0.cuit AS cuit_4, t0.celular AS celular_5, t0.condicion_iva AS condicion_iva_6, t0.mail AS mail_7, t0.mail_alternativo AS mail_alternativo_8, t0.celular2 AS celular2_9, t0.direccion AS direccion_10, t0.representante_legal AS representante_legal_11, t0.archivo_poder AS archivo_poder_12, t0.archivo_presentacion AS archivo_presentacion_13, t0.fecha_alta AS fecha_alta_14, t0.fecha_creacion AS fecha_creacion_15, t0.fecha_actualizacion AS fecha_actualizacion_16 FROM mc_clientes t0 WHERE t0.id = ?
Parameters:
[
135
]
|
1.57 ms (4.94%) |
13 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.precio_aduana AS precio_aduana_5, t0.tipo_salida AS tipo_salida_6, t0.tipo_tarifa AS tipo_tarifa_7, t0.habilitacion AS habilitacion_8, t0.tipo AS tipo_9, t0.fecha_creacion AS fecha_creacion_10, t0.fecha_actualizacion AS fecha_actualizacion_11 FROM mc_tipos_tramite t0 WHERE t0.id = ?
Parameters:
[
15
]
|
0.61 ms (1.92%) |
1 |
SELECT m0_.id AS id_0, m0_.dominio1 AS dominio1_1, m0_.dominio2 AS dominio2_2, m0_.estado AS estado_3, m0_.chofer AS chofer_4, m0_.aduana_nombre AS aduana_nombre_5, m0_.tramite AS tramite_6, m0_.tipo_pago AS tipo_pago_7, m0_.total AS total_8, m0_.registro AS registro_9, m0_.tras AS tras_10, m0_.rg AS rg_11, m0_.tlmd AS tlmd_12, m0_.mani AS mani_13, m0_.aduana AS aduana_14, m0_.archivo_reverso AS archivo_reverso_15, m0_.origen AS origen_16, m0_.facturado AS facturado_17, m0_.plazo AS plazo_18, m0_.leido AS leido_19, m0_.notificacion AS notificacion_20, m0_.tipo_operacion AS tipo_operacion_21, m0_.pais_origen AS pais_origen_22, m0_.mercaderia AS mercaderia_23, m0_.exp_imp AS exp_imp_24, m0_.mercaderia_1 AS mercaderia_1_25, m0_.fecha_pago AS fecha_pago_26, m0_.fecha_creacion AS fecha_creacion_27, m0_.fecha_actualizacion AS fecha_actualizacion_28, m0_.cliente_id AS cliente_id_29, m0_.moneda_id AS moneda_id_30, m0_.user_id AS user_id_31 FROM mc_precarga m0_ WHERE m0_.estado = 3 ORDER BY m0_.fecha_creacion DESC LIMIT 100
Parameters:
[] |
0.41 ms (1.28%) |
3 |
SELECT t0.id AS id_1, t0.usuario AS usuario_2, t0.password AS password_3, t0.salt AS salt_4, t0.estado AS estado_5, t0.fecha_creacion AS fecha_creacion_6, t0.fecha_actualizacion AS fecha_actualizacion_7, t0.id_persona AS id_persona_8, t0.cliente_id AS cliente_id_9 FROM mc_usuarios t0 WHERE t0.id = ?
Parameters:
[
32
]
|
0.35 ms (1.10%) |
1 |
SELECT SUM(CASE WHEN m0_.moneda_id = 1 THEN m0_.aduana ELSE 0 END) AS sclr_0, SUM(CASE WHEN m0_.moneda_id = 2 THEN m0_.aduana ELSE 0 END) AS sclr_1, SUM(CASE WHEN m0_.moneda_id = 3 THEN m0_.aduana ELSE 0 END) AS sclr_2, SUM(CASE WHEN m0_.moneda_id = 4 THEN m0_.aduana ELSE 0 END) AS sclr_3, SUM(CASE WHEN m0_.moneda_id = 5 THEN m0_.aduana ELSE 0 END) AS sclr_4, SUM(CASE WHEN m0_.moneda_id = 6 THEN m0_.aduana ELSE 0 END) AS sclr_5, SUM(CASE WHEN m0_.moneda_id = 7 THEN m0_.aduana ELSE 0 END) AS sclr_6 FROM mc_precarga m0_ WHERE m0_.estado = 3
Parameters:
[] |
0.33 ms (1.02%) |
1 |
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_precarga m0_ WHERE m0_.estado = 3 ORDER BY m0_.fecha_creacion DESC
Parameters:
[] |
0.12 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM mc_roles t0 INNER JOIN mc_usuarios_roles ON t0.id = mc_usuarios_roles.rol_id WHERE mc_usuarios_roles.usuario_id = ?
Parameters:
[
32
]
|
0.10 ms (0.32%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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 |
---|---|
Noahtech\Sistemas\InterjamaBundle\Entity\McUsuario | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McPersona | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McCliente | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McRol | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McPrecarga | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McMoneda | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McChofer | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McPrecargaTipoTramites | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McTiposTramite | No errors. |