Query Metrics
8
Database Queries
8
Different statements
42.12 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.67 ms (49.08%) |
1 |
SELECT count(o0_.id) AS sclr_0 FROM operacion_detalle o0_ WHERE o0_.id IS NOT NULL AND o0_.deleted_at IS NULL AND (LOWER(o0_.IDperseo) LIKE ? OR LOWER(o0_.tipo) LIKE ? OR LOWER(o0_.valoracion_IDperseo) LIKE ? OR LOWER(o0_.estado_key) LIKE ? OR LOWER(o0_.estado_nombre) LIKE ? OR LOWER(o0_.cliente_razon_social) LIKE ? OR LOWER(o0_.canal_nombre) LIKE ? OR LOWER(o0_.fecha_tramitacion) LIKE ? OR LOWER(o0_.fecha_tramitada) LIKE ? OR LOWER(o0_.fecha_confirmada) LIKE ? OR LOWER(o0_.detalle_reloj_IDperseo) LIKE ? OR LOWER(o0_.detalle_reloj_codigo) LIKE ? OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE ? OR LOWER(o0_.detalle_reloj_modelo1) LIKE ? OR LOWER(o0_.detalle_reloj_modelo2) LIKE ? OR LOWER(o0_.detalle_reloj_ref1) LIKE ? OR LOWER(o0_.detalle_reloj_ref2) LIKE ? OR LOWER(o0_.detalle_reloj_serie) LIKE ? OR LOWER(o0_.detalle_precio_coste) LIKE ? OR LOWER(o0_.detalle_precio_venta) LIKE ? OR LOWER(o0_.usuario_IDperseo) LIKE ? OR LOWER(o0_.user_username) LIKE ? OR LOWER(o0_.user_email) LIKE ? OR LOWER(o0_.user_nombre) LIKE ? OR LOWER(o0_.user_primer_apellido) LIKE ? OR LOWER(o0_.user_segundo_apellido) LIKE ?) AND (o0_.estado_key = ? OR o0_.estado_key = ? OR o0_.estado_key = ?)
Parameters:
[ "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "EN_TRAMITACION" "TRAMITADA" "CONFIRMADA" ] |
|
17.23 ms (40.92%) |
1 |
SELECT o0_.id AS id_0, o0_.operacion_id AS operacion_id_1, o0_.tipo AS tipo_2, o0_.IDperseo AS IDperseo_3, o0_.fecha AS fecha_4, o0_.valoracion_id AS valoracion_id_5, o0_.valoracion_IDperseo AS valoracion_IDperseo_6, o0_.estado_id AS estado_id_7, o0_.estado_key AS estado_key_8, o0_.estado_nombre AS estado_nombre_9, o0_.estado_fecha AS estado_fecha_10, o0_.cliente_id AS cliente_id_11, o0_.cliente_razon_social AS cliente_razon_social_12, o0_.canal_id AS canal_id_13, o0_.canal_nombre AS canal_nombre_14, o0_.usuario_id AS usuario_id_15, o0_.usuario_IDperseo AS usuario_IDperseo_16, o0_.user_id AS user_id_17, o0_.user_username AS user_username_18, o0_.user_email AS user_email_19, o0_.user_nombre AS user_nombre_20, o0_.user_primer_apellido AS user_primer_apellido_21, o0_.user_segundo_apellido AS user_segundo_apellido_22, o0_.fecha_tramitacion AS fecha_tramitacion_23, o0_.fecha_tramitada AS fecha_tramitada_24, o0_.fecha_confirmada AS fecha_confirmada_25, o0_.fecha_cancelada AS fecha_cancelada_26, o0_.fecha_asentada AS fecha_asentada_27, o0_.fecha_finalizada AS fecha_finalizada_28, o0_.detalle_id AS detalle_id_29, o0_.detalle_reloj_id AS detalle_reloj_id_30, o0_.detalle_reloj_IDperseo AS detalle_reloj_IDperseo_31, o0_.detalle_reloj_codigo AS detalle_reloj_codigo_32, o0_.detalle_reloj_marca_id AS detalle_reloj_marca_id_33, o0_.detalle_reloj_marca_nombre AS detalle_reloj_marca_nombre_34, o0_.detalle_reloj_modelo1 AS detalle_reloj_modelo1_35, o0_.detalle_reloj_modelo2 AS detalle_reloj_modelo2_36, o0_.detalle_reloj_ref1 AS detalle_reloj_ref1_37, o0_.detalle_reloj_ref2 AS detalle_reloj_ref2_38, o0_.detalle_reloj_serie AS detalle_reloj_serie_39, o0_.detalle_precio_coste AS detalle_precio_coste_40, o0_.detalle_precio_venta AS detalle_precio_venta_41, o0_.deleted_at AS deleted_at_42 FROM operacion_detalle o0_ WHERE o0_.id IS NOT NULL AND o0_.deleted_at IS NULL AND (LOWER(o0_.IDperseo) LIKE ? OR LOWER(o0_.tipo) LIKE ? OR LOWER(o0_.valoracion_IDperseo) LIKE ? OR LOWER(o0_.estado_key) LIKE ? OR LOWER(o0_.estado_nombre) LIKE ? OR LOWER(o0_.cliente_razon_social) LIKE ? OR LOWER(o0_.canal_nombre) LIKE ? OR LOWER(o0_.fecha_tramitacion) LIKE ? OR LOWER(o0_.fecha_tramitada) LIKE ? OR LOWER(o0_.fecha_confirmada) LIKE ? OR LOWER(o0_.detalle_reloj_IDperseo) LIKE ? OR LOWER(o0_.detalle_reloj_codigo) LIKE ? OR LOWER(o0_.detalle_reloj_marca_nombre) LIKE ? OR LOWER(o0_.detalle_reloj_modelo1) LIKE ? OR LOWER(o0_.detalle_reloj_modelo2) LIKE ? OR LOWER(o0_.detalle_reloj_ref1) LIKE ? OR LOWER(o0_.detalle_reloj_ref2) LIKE ? OR LOWER(o0_.detalle_reloj_serie) LIKE ? OR LOWER(o0_.detalle_precio_coste) LIKE ? OR LOWER(o0_.detalle_precio_venta) LIKE ? OR LOWER(o0_.usuario_IDperseo) LIKE ? OR LOWER(o0_.user_username) LIKE ? OR LOWER(o0_.user_email) LIKE ? OR LOWER(o0_.user_nombre) LIKE ? OR LOWER(o0_.user_primer_apellido) LIKE ? OR LOWER(o0_.user_segundo_apellido) LIKE ?) AND (o0_.estado_key = ? OR o0_.estado_key = ? OR o0_.estado_key = ?) ORDER BY o0_.estado_fecha DESC, o0_.id ASC LIMIT 50
Parameters:
[ "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "%78357976%" "EN_TRAMITACION" "TRAMITADA" "CONFIRMADA" ] |
|
0.99 ms (2.36%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.primer_apellido AS primer_apellido_7, t0.segundo_apellido AS segundo_apellido_8, t0.tipo_genero_id AS tipo_genero_id_9, t0.direccion AS direccion_10, t0.cp AS cp_11, t0.region AS region_12, t0.ciudad AS ciudad_13, t0.telefono AS telefono_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.pais AS pais_18, t0.ccaa_id AS ccaa_id_19, t0.provincia_id AS provincia_id_20, t0.cliente_id AS cliente_id_21, t0.usuario_id AS usuario_id_22 FROM user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"2"
]
|
|
0.78 ms (1.85%) |
1 |
INSERT INTO perseo.log (user, roles, webservice, uri, method, headers, request, query, referer, user_agent, server_name, server_addr, remote_addr, deleted_at, updated_at, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "moises" "["ROLE_SUPER_ADMIN","ROLE_USER"]" "admin_app_operacion_list" null "GET" "{"cookie":["sbjs_migrations=1418474375998%3D1; sbjs_first_add=fd%3D2025-06-20%2014%3A56%3A16%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2F%7C%7C%7Crf%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2Fpage%2F3%2F; sbjs_first=typ%3Dtypein%7C%7C%7Csrc%3D%28direct%29%7C%7C%7Cmdm%3D%28none%29%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%28none%29%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29%7C%7C%7Cplt%3D%28none%29%7C%7C%7Cfmt%3D%28none%29%7C%7C%7Ctct%3D%28none%29; sbjs_current_add=fd%3D2025-11-27%2009%3A06%3A20%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2Frelojes%2F%7C%7C%7Crf%3Dhttps%3A%2F%2Fwww.google.com%2F; sbjs_current=typ%3Dorganic%7C%7C%7Csrc%3Dgoogle%7C%7C%7Cmdm%3Dorganic%7C%7C%7Ccmp%3D%28none%29%7C%7C%7Ccnt%3D%28none%29%7C%7C%7Ctrm%3D%28none%29%7C%7C%7Cid%3D%28none%29%7C%7C%7Cplt%3D%28none%29%7C%7C%7Cfmt%3D%28none%29%7C%7C%7Ctct%3D%28none%29; sbjs_udata=vst%3D22%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28Windows%20NT%2010.0%3B%20Win64%3B%20x64%29%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%29%20Chrome%2F147.0.0.0%20Safari%2F537.36; _ga=GA1.1.90127083.1769782445; _ga_QMD3ZTG7ZP=GS2.1.s1776369527$o26$g1$t1776369535$j52$l0$h0; _ga_9WW1MLN4N6=GS2.1.s1776369527$o26$g1$t1776369535$j52$l0$h0; PHPSESSID=9pjoovla5rsou5m2oa3slnichc"],"priority":["u=0, i"],"accept-language":["es-ES,es;q=0.9"],"accept-encoding":["gzip, deflate, br, zstd"],"referer":["https:\/\/perseo.comerziawatches.com\/es\/admin\/app\/operacion\/662\/edit"],"sec-fetch-dest":["document"],"sec-fetch-user":["?1"],"sec-fetch-mode":["navigate"],"sec-fetch-site":["same-origin"],"accept":["text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,image\/apng,*\/*;q=0.8,application\/signed-exchange;v=b3;q=0.7"],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Safari\/537.36"],"upgrade-insecure-requests":["1"],"sec-ch-ua-platform":["\"Windows\""],"sec-ch-ua-mobile":["?0"],"sec-ch-ua":["\"Google Chrome\";v=\"147\", \"Not.A\/Brand\";v=\"8\", \"Chromium\";v=\"147\""],"connection":["close"],"x-accel-internal":["\/internal-nginx-static-location"],"x-real-ip":["148.3.201.36"],"host":["perseo.comerziawatches.com"],"x-php-ob-level":["1"]}" "[]" "{"id":"662"}" "https://perseo.comerziawatches.com/es/admin/app/operacion/662/edit" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36" "perseo.comerziawatches.com" "82.223.107.15" "148.3.201.36" null "2026-04-19 11:40:15" "2026-04-19 11:40:15" ] |
|
0.73 ms (1.74%) |
1 |
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.avatar AS avatar_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t7.id AS id_8, t7.username AS username_9, t7.email AS email_10, t7.roles AS roles_11, t7.password AS password_12, t7.nombre AS nombre_13, t7.primer_apellido AS primer_apellido_14, t7.segundo_apellido AS segundo_apellido_15, t7.tipo_genero_id AS tipo_genero_id_16, t7.direccion AS direccion_17, t7.cp AS cp_18, t7.region AS region_19, t7.ciudad AS ciudad_20, t7.telefono AS telefono_21, t7.deleted_at AS deleted_at_22, t7.updated_at AS updated_at_23, t7.created_at AS created_at_24, t7.pais AS pais_25, t7.ccaa_id AS ccaa_id_26, t7.provincia_id AS provincia_id_27, t7.cliente_id AS cliente_id_28, t7.usuario_id AS usuario_id_29, t30.id AS id_31, t30.nombre AS nombre_32, t30.descripcion AS descripcion_33, t30.color AS color_34, t30.active AS active_35, t30.deleted_at AS deleted_at_36, t30.updated_at AS updated_at_37, t30.created_at AS created_at_38, t30.empresa_id AS empresa_id_39, t30.responsable_usuario_id AS responsable_usuario_id_40, t0.unidad_negocio_id AS unidad_negocio_id_41 FROM usuario t0 LEFT JOIN user t7 ON t7.usuario_id = t0.id AND ((t7.deleted_at IS NULL)) LEFT JOIN unidad_negocio t30 ON t30.responsable_usuario_id = t0.id AND ((t30.deleted_at IS NULL)) WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
|
0.73 ms (1.74%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.69 ms (1.64%) |
1 |
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.id_perseo AS id_perseo_3, t0.fecha AS fecha_4, t0.tipo_cliente AS tipo_cliente_5, t0.exportacion AS exportacion_6, t0.idioma AS idioma_7, t0.fecha_tramitacion AS fecha_tramitacion_8, t0.fecha_tramitada AS fecha_tramitada_9, t0.fecha_confirmada AS fecha_confirmada_10, t0.fecha_asentada AS fecha_asentada_11, t0.fecha_finalizada AS fecha_finalizada_12, t0.fecha_cancelada AS fecha_cancelada_13, t0.forma_pago AS forma_pago_14, t0.precio_pagar AS precio_pagar_15, t0.comentario_contrato AS comentario_contrato_16, t0.comentario AS comentario_17, t0.contract_signed AS contract_signed_18, t0.can_deleted AS can_deleted_19, t0.deleted_at AS deleted_at_20, t0.updated_at AS updated_at_21, t0.created_at AS created_at_22, t0.compra_id AS compra_id_23, t0.venta_id AS venta_id_24, t0.valoracion_id AS valoracion_id_25, t0.canal_id AS canal_id_26, t0.cliente_id AS cliente_id_27, t0.estado_id AS estado_id_28, t0.banco_id AS banco_id_29, t0.firmante_id AS firmante_id_30, t0.intercambio_id AS intercambio_id_31, t0.unidad_negocio_id AS unidad_negocio_id_32, t0.usuario_id AS usuario_id_33 FROM operacion t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"662"
]
|
|
0.29 ms (0.68%) |
1 |
"START TRANSACTION"
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\User | No errors. |
| App\Entity\CCAA | No errors. |
| App\Entity\Provincia | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Usuario | No errors. |
| App\Entity\Log | No errors. |
| App\Entity\Operacion | No errors. |
| App\Entity\Compra | No errors. |
| App\Entity\Venta |
|
| App\Entity\Valoracion |
|
| App\Entity\Canal | No errors. |
| App\Entity\EstadoAbstract | No errors. |
| App\Entity\EstadoOperacion | No errors. |
| App\Entity\Banco | No errors. |
| App\Entity\Firmante | No errors. |
| App\Entity\Intercambio | No errors. |
| App\Entity\UnidadNegocio | No errors. |
| App\Entity\Reloj |
|
| App\Entity\Empresa | No errors. |
| App\Entity\ActividadAbstract | No errors. |
| App\Entity\OperacionDetalle | No errors. |