Query Metrics
15
Database Queries
11
Different statements
5.73 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.17 ms |
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
]
|
2 | 0.09 ms |
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
]
|
3 | 0.10 ms |
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 = ? LIMIT 1
Parameters:
[
86
]
|
4 | 0.11 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
5 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 0.27 ms |
INSERT INTO mc_precarga (dominio1, dominio2, estado, chofer, aduana_nombre, tramite, tipo_pago, total, registro, tras, rg, tlmd, mani, aduana, archivo_reverso, origen, facturado, plazo, leido, notificacion, tipo_operacion, pais_origen, mercaderia, exp_imp, mercaderia_1, fecha_pago, fecha_creacion, fecha_actualizacion, cliente_id, moneda_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "BEA3D73" 2 => "AOV4D23" 3 => 3 4 => "ADOLPHO AUGUSTO DE SOUZA" 5 => "031 - JUJUY" 6 => "Salida" 7 => "Contado/Efectivo" 8 => "20000" 9 => null 10 => null 11 => null 12 => null 13 => null 14 => "0" 15 => null 16 => null 17 => null 18 => "0" 19 => "Leido" 20 => null 21 => null 22 => null 23 => null 24 => null 25 => "" 26 => null 27 => "2025-07-25 09:37:07" 28 => null 29 => 86 30 => 1 31 => 32 ] |
7 | 2.00 ms |
"COMMIT"
Parameters:
[] |
8 | 0.14 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
9 | 0.12 ms |
SELECT t0.id AS id_1, t0.cerrado AS cerrado_2, t0.tipo AS tipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.fecha_actualizacion AS fecha_actualizacion_5, t0.usuario_id_open AS usuario_id_open_6, t0.usuario_id_close AS usuario_id_close_7 FROM mc_cajas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
13
]
|
10 | 0.13 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
11 | 0.48 ms |
SELECT t0.id AS id_1, t0.monto AS monto_2, t0.modalidad AS modalidad_3, t0.detalle AS detalle_4, t0.tipo AS tipo_5, t0.tipo_detalle AS tipo_detalle_6, t0.devolucion AS devolucion_7, t0.monto_devolucion AS monto_devolucion_8, t0.facturado AS facturado_9, t0.fecha_creacion AS fecha_creacion_10, t0.fecha_actualizacion AS fecha_actualizacion_11, t0.caja_id AS caja_id_12, t0.cliente_id AS cliente_id_13, t0.chofer_id AS chofer_id_14, t0.usuario_id AS usuario_id_15, t0.moneda_id AS moneda_id_16, t0.precarga_id AS precarga_id_17 FROM mc_movimientos t0 WHERE t0.precarga_id = ? LIMIT 1
Parameters:
[
263
]
|
12 | 0.07 ms |
"START TRANSACTION"
Parameters:
[] |
13 | 0.19 ms |
INSERT INTO mc_movimientos (monto, modalidad, detalle, tipo, tipo_detalle, devolucion, monto_devolucion, facturado, fecha_creacion, fecha_actualizacion, caja_id, cliente_id, chofer_id, usuario_id, moneda_id, precarga_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 20000.0 2 => "Contado/Efectivo" 3 => "Movimiento generado por la atención de una precarga." 4 => "Ingreso" 5 => "Atención trámite" 6 => null 7 => null 8 => null 9 => "2025-07-25 09:37:07" 10 => null 11 => "13" 12 => null 13 => null 14 => 32 15 => 1 16 => 263 ] |
14 | 1.65 ms |
"COMMIT"
Parameters:
[] |
15 | 0.15 ms |
SELECT m0_.id AS id_0, m0_.monto_inicial AS monto_inicial_1, m0_.monto_final AS monto_final_2, m0_.fecha_creacion AS fecha_creacion_3, m0_.fecha_actualizacion AS fecha_actualizacion_4, m0_.caja_id AS caja_id_5, m0_.moneda_id AS moneda_id_6 FROM mc_caja_monedas m0_ WHERE m0_.caja_id = ? AND m0_.moneda_id = ?
Parameters:
[ "13" 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\McChofer | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McMoneda | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McMovimiento | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McCaja | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McCajaMoneda | No errors. |