Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

18 Database Queries

16 Different statements

9.86 ms Query time

10 Invalid entities

Queries

Group similar statements


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))
"START TRANSACTION"
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.tipo_cliente AS tipo_cliente_3, t0.fecha AS fecha_4, t0.exportacion AS exportacion_5, t0.idioma AS idioma_6, t0.comentario AS comentario_7, t0.fecha_enviada AS fecha_enviada_8, t0.fecha_aceptacion AS fecha_aceptacion_9, t0.fecha_rechazo AS fecha_rechazo_10, t0.fecha_tramitacion AS fecha_tramitacion_11, t0.fecha_tramitada AS fecha_tramitada_12, t0.duplicados AS duplicados_13, t0.precio_pagar AS precio_pagar_14, t0.info_tramitacion AS info_tramitacion_15, t0.info_valoracion AS info_valoracion_16, t0.tipo_operacion AS tipo_operacion_17, t0.deleted_at AS deleted_at_18, t0.updated_at AS updated_at_19, t0.created_at AS created_at_20, t21.id AS id_22, t21.tipo AS tipo_23, t21.id_perseo AS id_perseo_24, t21.fecha AS fecha_25, t21.tipo_cliente AS tipo_cliente_26, t21.exportacion AS exportacion_27, t21.idioma AS idioma_28, t21.fecha_tramitacion AS fecha_tramitacion_29, t21.fecha_tramitada AS fecha_tramitada_30, t21.fecha_confirmada AS fecha_confirmada_31, t21.fecha_asentada AS fecha_asentada_32, t21.fecha_finalizada AS fecha_finalizada_33, t21.fecha_cancelada AS fecha_cancelada_34, t21.forma_pago AS forma_pago_35, t21.precio_pagar AS precio_pagar_36, t21.comentario_contrato AS comentario_contrato_37, t21.comentario AS comentario_38, t21.contract_signed AS contract_signed_39, t21.can_deleted AS can_deleted_40, t21.deleted_at AS deleted_at_41, t21.updated_at AS updated_at_42, t21.created_at AS created_at_43, t21.compra_id AS compra_id_44, t21.venta_id AS venta_id_45, t21.valoracion_id AS valoracion_id_46, t21.canal_id AS canal_id_47, t21.cliente_id AS cliente_id_48, t21.estado_id AS estado_id_49, t21.banco_id AS banco_id_50, t21.firmante_id AS firmante_id_51, t21.intercambio_id AS intercambio_id_52, t21.unidad_negocio_id AS unidad_negocio_id_53, t21.usuario_id AS usuario_id_54, t0.canal_id AS canal_id_55, t0.estado_id AS estado_id_56, t0.unidad_negocio_id AS unidad_negocio_id_57, t0.usuario_id AS usuario_id_58, t0.cliente_id AS cliente_id_59, t0.clone_id AS clone_id_60 FROM valoracion t0 LEFT JOIN operacion t21 ON t21.valoracion_id = t0.id AND ((t21.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
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.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.empresa_id AS empresa_id_9, t0.responsable_usuario_id AS responsable_usuario_id_10 FROM unidad_negocio t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = ? AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.descripcion AS descripcion_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.tipo_cargo_id AS tipo_cargo_id_7, t0.valoraciones_relojes_id AS valoraciones_relojes_id_8 FROM coste t0 WHERE t0.valoraciones_relojes_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.caja AS caja_2, t0.papeles AS papeles_3, t0.precio AS precio_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.canal_id AS canal_id_8, t0.valoraciones_relojes_id AS valoraciones_relojes_id_9 FROM referencia t0 WHERE t0.valoraciones_relojes_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('aspecto') AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL))
SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.descripcion AS descripcion_2, u0_.color AS color_3, u0_.active AS active_4, u0_.deleted_at AS deleted_at_5, u0_.updated_at AS updated_at_6, u0_.created_at AS created_at_7, u0_.empresa_id AS empresa_id_8, u0_.responsable_usuario_id AS responsable_usuario_id_9 FROM unidad_negocio u0_ WHERE (u0_.id IN (?)) AND (u0_.deleted_at IS NULL)
SELECT u0_.id AS id_0, u0_.id_perseo AS id_perseo_1, u0_.avatar AS avatar_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.unidad_negocio_id AS unidad_negocio_id_6 FROM usuario u0_ WHERE (u0_.id IN (?)) AND (u0_.deleted_at IS NULL)
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL))
SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.id IN (?)) AND (e0_.deleted_at IS NULL)) AND e0_.type IN ('aspecto') ORDER BY e0_.orden DESC
SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL))

#▲	Time	Info
1	0.95 ms	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: [`"3"`] View formatted query View runnable query Explain query 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) ) 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 = '3' AND ((t0.deleted_at IS NULL));
2	0.24 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.69 ms	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: ["ivan" "["ROLE_ADMIN","ROLE_USER"]" "admin_app_valoracion_edit" null "POST" "{"cookie":["PHPSESSID=v31phe1ap0pighbchs8qj60ma5; _ga_9WW1MLN4N6=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga_QMD3ZTG7ZP=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga=GA1.1.417558243.1759838203; sbjs_current=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_udata=vst%3D44%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28Macintosh%3B%20Intel%20Mac%20OS%20X%2010_15_7%29%20AppleWebKit%2F605.1.15%20%28KHTML%2C%20like%20Gecko%29%20Version%2F26.3.1%20Safari%2F605.1.15; sbjs_current_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; 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_first_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; sbjs_migrations=1418474375998%3D1"],"accept-encoding":["gzip, deflate, br, zstd"],"priority":["u=0, i"],"accept-language":["es-ES,es;q=0.9"],"sec-fetch-dest":["document"],"referer":["https:\/\/perseo.comerziawatches.com\/es\/admin\/app\/valoracion\/1887\/edit?uniqid=s69d37d45ce749"],"user-agent":["Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/26.3.1 Safari\/605.1.15"],"sec-fetch-mode":["navigate"],"sec-fetch-site":["same-origin"],"origin":["https:\/\/perseo.comerziawatches.com"],"content-type":["multipart\/form-data; boundary=----WebKitFormBoundaryXI6TzXAyb1kfIsdA"],"accept":["text\/html,application\/xhtml+xml,application\/xml;q=0.9,\/;q=0.8"],"content-length":["5132"],"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"]}" "{"s69d37d45ce749":{"fecha":"06-04-2026 11:18","unidadNegocio":"1","usuario":"2","canal":"4","cliente":"1208","tipoCliente":"1","infoValoracion":"","idioma":"es","valoracionesRelojesSinStocks":[{"relojFoto":"69d37b3994377823935693.jpg","relojMarca":"53","relojModelo1":"GMT Master II","relojRef1":"126710BLRO","relojCaja":"1","relojPapeles":"1","relojFecha":"2026","relojAspecto":"8","infoValoracion":"","precioOferta":"17888.06","precioPromocion":"21995","precioMinVenta":"21000","comision":"5","costesTotal":"0","margenDeseado":"7","margenPromocion":"10.14","margenMinimo":"5.88","ITP":"4","precioReferencia":"21950","precioPagar":"18000"}],"fechaEnviada":"","fechaAceptacion":"","fechaRechazo":"","infoTramitacion":"","precioPagar":"-18000","_token":"eb4bb6e7bf6.isYhjoC5bitgdaALCtHs9RCyI0Ux_KKUNsglgB7CYCg.8r9X78L7Ck0nDfVzQZOlgFfeFBB6iJX4fJdVsWe1I1HcgXbrsPU5ZlYz1w"},"btn_update_and_list":"1"}" "{"uniqid":"s69d37d45ce749"}" "https://perseo.comerziawatches.com/es/admin/app/valoracion/1887/edit?uniqid=s69d37d45ce749" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3.1 Safari/605.1.15" "perseo.comerziawatches.com" "82.223.107.15" "148.3.201.36" null "2026-04-06 13:08:09" "2026-04-06 13:08:09"] View formatted query View runnable query Explain query 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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 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 ('ivan', '[\"ROLE_ADMIN\",\"ROLE_USER\"]', 'admin_app_valoracion_edit', NULL, 'POST', '{\"cookie\":[\"PHPSESSID=v31phe1ap0pighbchs8qj60ma5; _ga_9WW1MLN4N6=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga_QMD3ZTG7ZP=GS2.1.s1774896854$o66$g0$t1774896854$j60$l0$h0; _ga=GA1.1.417558243.1759838203; sbjs_current=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_udata=vst%3D44%7C%7C%7Cuip%3D%28none%29%7C%7C%7Cuag%3DMozilla%2F5.0%20%28Macintosh%3B%20Intel%20Mac%20OS%20X%2010_15_7%29%20AppleWebKit%2F605.1.15%20%28KHTML%2C%20like%20Gecko%29%20Version%2F26.3.1%20Safari%2F605.1.15; sbjs_current_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; 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_first_add=fd%3D2025-09-30%2016%3A35%3A07%7C%7C%7Cep%3Dhttps%3A%2F%2Fwww.comerziawatches.com%2F%7C%7C%7Crf%3D%28none%29; sbjs_migrations=1418474375998%3D1\"],\"accept-encoding\":[\"gzip, deflate, br, zstd\"],\"priority\":[\"u=0, i\"],\"accept-language\":[\"es-ES,es;q=0.9\"],\"sec-fetch-dest\":[\"document\"],\"referer\":[\"https:\\/\\/perseo.comerziawatches.com\\/es\\/admin\\/app\\/valoracion\\/1887\\/edit?uniqid=s69d37d45ce749\"],\"user-agent\":[\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\\/605.1.15 (KHTML, like Gecko) Version\\/26.3.1 Safari\\/605.1.15\"],\"sec-fetch-mode\":[\"navigate\"],\"sec-fetch-site\":[\"same-origin\"],\"origin\":[\"https:\\/\\/perseo.comerziawatches.com\"],\"content-type\":[\"multipart\\/form-data; boundary=----WebKitFormBoundaryXI6TzXAyb1kfIsdA\"],\"accept\":[\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,\\/;q=0.8\"],\"content-length\":[\"5132\"],\"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\"]}', '{\"s69d37d45ce749\":{\"fecha\":\"06-04-2026 11:18\",\"unidadNegocio\":\"1\",\"usuario\":\"2\",\"canal\":\"4\",\"cliente\":\"1208\",\"tipoCliente\":\"1\",\"infoValoracion\":\"\",\"idioma\":\"es\",\"valoracionesRelojesSinStocks\":[{\"relojFoto\":\"69d37b3994377823935693.jpg\",\"relojMarca\":\"53\",\"relojModelo1\":\"GMT Master II\",\"relojRef1\":\"126710BLRO\",\"relojCaja\":\"1\",\"relojPapeles\":\"1\",\"relojFecha\":\"2026\",\"relojAspecto\":\"8\",\"infoValoracion\":\"\",\"precioOferta\":\"17888.06\",\"precioPromocion\":\"21995\",\"precioMinVenta\":\"21000\",\"comision\":\"5\",\"costesTotal\":\"0\",\"margenDeseado\":\"7\",\"margenPromocion\":\"10.14\",\"margenMinimo\":\"5.88\",\"ITP\":\"4\",\"precioReferencia\":\"21950\",\"precioPagar\":\"18000\"}],\"fechaEnviada\":\"\",\"fechaAceptacion\":\"\",\"fechaRechazo\":\"\",\"infoTramitacion\":\"\",\"precioPagar\":\"-18000\",\"_token\":\"eb4bb6e7bf6.isYhjoC5bitgdaALCtHs9RCyI0Ux_KKUNsglgB7CYCg.8r9X78L7Ck0nDfVzQZOlgFfeFBB6iJX4fJdVsWe1I1HcgXbrsPU5ZlYz1w\"},\"btn_update_and_list\":\"1\"}', '{\"uniqid\":\"s69d37d45ce749\"}', 'https://perseo.comerziawatches.com/es/admin/app/valoracion/1887/edit?uniqid=s69d37d45ce749', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3.1 Safari/605.1.15', 'perseo.comerziawatches.com', '82.223.107.15', '148.3.201.36', NULL, '2026-04-06 13:08:09', '2026-04-06 13:08:09');
4	0.55 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	0.82 ms	SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.tipo_cliente AS tipo_cliente_3, t0.fecha AS fecha_4, t0.exportacion AS exportacion_5, t0.idioma AS idioma_6, t0.comentario AS comentario_7, t0.fecha_enviada AS fecha_enviada_8, t0.fecha_aceptacion AS fecha_aceptacion_9, t0.fecha_rechazo AS fecha_rechazo_10, t0.fecha_tramitacion AS fecha_tramitacion_11, t0.fecha_tramitada AS fecha_tramitada_12, t0.duplicados AS duplicados_13, t0.precio_pagar AS precio_pagar_14, t0.info_tramitacion AS info_tramitacion_15, t0.info_valoracion AS info_valoracion_16, t0.tipo_operacion AS tipo_operacion_17, t0.deleted_at AS deleted_at_18, t0.updated_at AS updated_at_19, t0.created_at AS created_at_20, t21.id AS id_22, t21.tipo AS tipo_23, t21.id_perseo AS id_perseo_24, t21.fecha AS fecha_25, t21.tipo_cliente AS tipo_cliente_26, t21.exportacion AS exportacion_27, t21.idioma AS idioma_28, t21.fecha_tramitacion AS fecha_tramitacion_29, t21.fecha_tramitada AS fecha_tramitada_30, t21.fecha_confirmada AS fecha_confirmada_31, t21.fecha_asentada AS fecha_asentada_32, t21.fecha_finalizada AS fecha_finalizada_33, t21.fecha_cancelada AS fecha_cancelada_34, t21.forma_pago AS forma_pago_35, t21.precio_pagar AS precio_pagar_36, t21.comentario_contrato AS comentario_contrato_37, t21.comentario AS comentario_38, t21.contract_signed AS contract_signed_39, t21.can_deleted AS can_deleted_40, t21.deleted_at AS deleted_at_41, t21.updated_at AS updated_at_42, t21.created_at AS created_at_43, t21.compra_id AS compra_id_44, t21.venta_id AS venta_id_45, t21.valoracion_id AS valoracion_id_46, t21.canal_id AS canal_id_47, t21.cliente_id AS cliente_id_48, t21.estado_id AS estado_id_49, t21.banco_id AS banco_id_50, t21.firmante_id AS firmante_id_51, t21.intercambio_id AS intercambio_id_52, t21.unidad_negocio_id AS unidad_negocio_id_53, t21.usuario_id AS usuario_id_54, t0.canal_id AS canal_id_55, t0.estado_id AS estado_id_56, t0.unidad_negocio_id AS unidad_negocio_id_57, t0.usuario_id AS usuario_id_58, t0.cliente_id AS cliente_id_59, t0.clone_id AS clone_id_60 FROM valoracion t0 LEFT JOIN operacion t21 ON t21.valoracion_id = t0.id AND ((t21.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"1887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.tipo_cliente AS tipo_cliente_3, t0.fecha AS fecha_4, t0.exportacion AS exportacion_5, t0.idioma AS idioma_6, t0.comentario AS comentario_7, t0.fecha_enviada AS fecha_enviada_8, t0.fecha_aceptacion AS fecha_aceptacion_9, t0.fecha_rechazo AS fecha_rechazo_10, t0.fecha_tramitacion AS fecha_tramitacion_11, t0.fecha_tramitada AS fecha_tramitada_12, t0.duplicados AS duplicados_13, t0.precio_pagar AS precio_pagar_14, t0.info_tramitacion AS info_tramitacion_15, t0.info_valoracion AS info_valoracion_16, t0.tipo_operacion AS tipo_operacion_17, t0.deleted_at AS deleted_at_18, t0.updated_at AS updated_at_19, t0.created_at AS created_at_20, t21.id AS id_22, t21.tipo AS tipo_23, t21.id_perseo AS id_perseo_24, t21.fecha AS fecha_25, t21.tipo_cliente AS tipo_cliente_26, t21.exportacion AS exportacion_27, t21.idioma AS idioma_28, t21.fecha_tramitacion AS fecha_tramitacion_29, t21.fecha_tramitada AS fecha_tramitada_30, t21.fecha_confirmada AS fecha_confirmada_31, t21.fecha_asentada AS fecha_asentada_32, t21.fecha_finalizada AS fecha_finalizada_33, t21.fecha_cancelada AS fecha_cancelada_34, t21.forma_pago AS forma_pago_35, t21.precio_pagar AS precio_pagar_36, t21.comentario_contrato AS comentario_contrato_37, t21.comentario AS comentario_38, t21.contract_signed AS contract_signed_39, t21.can_deleted AS can_deleted_40, t21.deleted_at AS deleted_at_41, t21.updated_at AS updated_at_42, t21.created_at AS created_at_43, t21.compra_id AS compra_id_44, t21.venta_id AS venta_id_45, t21.valoracion_id AS valoracion_id_46, t21.canal_id AS canal_id_47, t21.cliente_id AS cliente_id_48, t21.estado_id AS estado_id_49, t21.banco_id AS banco_id_50, t21.firmante_id AS firmante_id_51, t21.intercambio_id AS intercambio_id_52, t21.unidad_negocio_id AS unidad_negocio_id_53, t21.usuario_id AS usuario_id_54, t0.canal_id AS canal_id_55, t0.estado_id AS estado_id_56, t0.unidad_negocio_id AS unidad_negocio_id_57, t0.usuario_id AS usuario_id_58, t0.cliente_id AS cliente_id_59, t0.clone_id AS clone_id_60 FROM valoracion t0 LEFT JOIN operacion t21 ON t21.valoracion_id = t0.id AND ( (t21.deleted_at IS NULL) ) WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.tipo_cliente AS tipo_cliente_3, t0.fecha AS fecha_4, t0.exportacion AS exportacion_5, t0.idioma AS idioma_6, t0.comentario AS comentario_7, t0.fecha_enviada AS fecha_enviada_8, t0.fecha_aceptacion AS fecha_aceptacion_9, t0.fecha_rechazo AS fecha_rechazo_10, t0.fecha_tramitacion AS fecha_tramitacion_11, t0.fecha_tramitada AS fecha_tramitada_12, t0.duplicados AS duplicados_13, t0.precio_pagar AS precio_pagar_14, t0.info_tramitacion AS info_tramitacion_15, t0.info_valoracion AS info_valoracion_16, t0.tipo_operacion AS tipo_operacion_17, t0.deleted_at AS deleted_at_18, t0.updated_at AS updated_at_19, t0.created_at AS created_at_20, t21.id AS id_22, t21.tipo AS tipo_23, t21.id_perseo AS id_perseo_24, t21.fecha AS fecha_25, t21.tipo_cliente AS tipo_cliente_26, t21.exportacion AS exportacion_27, t21.idioma AS idioma_28, t21.fecha_tramitacion AS fecha_tramitacion_29, t21.fecha_tramitada AS fecha_tramitada_30, t21.fecha_confirmada AS fecha_confirmada_31, t21.fecha_asentada AS fecha_asentada_32, t21.fecha_finalizada AS fecha_finalizada_33, t21.fecha_cancelada AS fecha_cancelada_34, t21.forma_pago AS forma_pago_35, t21.precio_pagar AS precio_pagar_36, t21.comentario_contrato AS comentario_contrato_37, t21.comentario AS comentario_38, t21.contract_signed AS contract_signed_39, t21.can_deleted AS can_deleted_40, t21.deleted_at AS deleted_at_41, t21.updated_at AS updated_at_42, t21.created_at AS created_at_43, t21.compra_id AS compra_id_44, t21.venta_id AS venta_id_45, t21.valoracion_id AS valoracion_id_46, t21.canal_id AS canal_id_47, t21.cliente_id AS cliente_id_48, t21.estado_id AS estado_id_49, t21.banco_id AS banco_id_50, t21.firmante_id AS firmante_id_51, t21.intercambio_id AS intercambio_id_52, t21.unidad_negocio_id AS unidad_negocio_id_53, t21.usuario_id AS usuario_id_54, t0.canal_id AS canal_id_55, t0.estado_id AS estado_id_56, t0.unidad_negocio_id AS unidad_negocio_id_57, t0.usuario_id AS usuario_id_58, t0.cliente_id AS cliente_id_59, t0.clone_id AS clone_id_60 FROM valoracion t0 LEFT JOIN operacion t21 ON t21.valoracion_id = t0.id AND ((t21.deleted_at IS NULL)) WHERE t0.id = '1887' AND ((t0.deleted_at IS NULL));
6	0.75 ms	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.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"2"`] View formatted query View runnable query Explain query 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.id = ? AND ( (t0.deleted_at IS NULL) ) 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.id = '2' AND ((t0.deleted_at IS NULL));
7	0.63 ms	SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.empresa_id AS empresa_id_9, t0.responsable_usuario_id AS responsable_usuario_id_10 FROM unidad_negocio t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.empresa_id AS empresa_id_9, t0.responsable_usuario_id AS responsable_usuario_id_10 FROM unidad_negocio t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4, t0.active AS active_5, t0.deleted_at AS deleted_at_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.empresa_id AS empresa_id_9, t0.responsable_usuario_id AS responsable_usuario_id_10 FROM unidad_negocio t0 WHERE t0.id = '1' AND ((t0.deleted_at IS NULL));
8	0.76 ms	SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL)) Parameters: [`"1887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = '1887' AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL));
9	0.49 ms	SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = ? AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL)) Parameters: [`"4079"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = ? AND t0.type IN ('compra') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.precio_coste AS precio_coste_2, t0.precio_promocion AS precio_promocion_3, t0.reloj_foto AS reloj_foto_4, t0.reloj_modelo1 AS reloj_modelo1_5, t0.reloj_modelo2 AS reloj_modelo2_6, t0.reloj_ref1 AS reloj_ref1_7, t0.reloj_ref2 AS reloj_ref2_8, t0.reloj_serie AS reloj_serie_9, t0.reloj_fecha AS reloj_fecha_10, t0.reloj_caja AS reloj_caja_11, t0.reloj_papeles AS reloj_papeles_12, t0.reloj_regimen AS reloj_regimen_13, t0.comentario AS comentario_14, t0.deleted_at AS deleted_at_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.precio_pagar AS precio_pagar_18, t0.coste_importacion_iva AS coste_importacion_iva_19, t0.coste_importacion_otros AS coste_importacion_otros_20, t0.fecha_verificacion AS fecha_verificacion_21, t0.fecha_cancelacion AS fecha_cancelacion_22, t0.reloj_aspecto_id AS reloj_aspecto_id_23, t0.reloj_marca_id AS reloj_marca_id_24, t0.compra_id AS compra_id_25, t0.reloj_compra_id AS reloj_compra_id_26, t0.reloj_base_id AS reloj_base_id_27, t0.valoracion_reloj_id AS valoracion_reloj_id_28, t0.type FROM detalle_operacion t0 WHERE t0.valoracion_reloj_id = '4079' AND t0.type IN ('compra') AND ((t0.deleted_at IS NULL));
10	0.59 ms	SELECT t0.id AS id_1, t0.precio AS precio_2, t0.descripcion AS descripcion_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.tipo_cargo_id AS tipo_cargo_id_7, t0.valoraciones_relojes_id AS valoraciones_relojes_id_8 FROM coste t0 WHERE t0.valoraciones_relojes_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"4079"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.precio AS precio_2, t0.descripcion AS descripcion_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.tipo_cargo_id AS tipo_cargo_id_7, t0.valoraciones_relojes_id AS valoraciones_relojes_id_8 FROM coste t0 WHERE t0.valoraciones_relojes_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.precio AS precio_2, t0.descripcion AS descripcion_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.tipo_cargo_id AS tipo_cargo_id_7, t0.valoraciones_relojes_id AS valoraciones_relojes_id_8 FROM coste t0 WHERE t0.valoraciones_relojes_id = '4079' AND ((t0.deleted_at IS NULL));
11	0.32 ms	SELECT t0.id AS id_1, t0.caja AS caja_2, t0.papeles AS papeles_3, t0.precio AS precio_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.canal_id AS canal_id_8, t0.valoraciones_relojes_id AS valoraciones_relojes_id_9 FROM referencia t0 WHERE t0.valoraciones_relojes_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`"4079"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caja AS caja_2, t0.papeles AS papeles_3, t0.precio AS precio_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.canal_id AS canal_id_8, t0.valoraciones_relojes_id AS valoraciones_relojes_id_9 FROM referencia t0 WHERE t0.valoraciones_relojes_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.caja AS caja_2, t0.papeles AS papeles_3, t0.precio AS precio_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.canal_id AS canal_id_8, t0.valoraciones_relojes_id AS valoraciones_relojes_id_9 FROM referencia t0 WHERE t0.valoraciones_relojes_id = '4079' AND ((t0.deleted_at IS NULL));
12	0.67 ms	SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('aspecto') AND ((t0.deleted_at IS NULL)) Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = ? AND t0.type IN ('aspecto') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.key_estado AS key_estado_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.color AS color_5, t0.orden AS orden_6, t0.deleted_at AS deleted_at_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.type FROM estado t0 WHERE t0.id = '8' AND t0.type IN ('aspecto') AND ((t0.deleted_at IS NULL));
13	0.55 ms	SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL)) Parameters: [`"1887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = '1887' AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL));
14	0.37 ms	SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.descripcion AS descripcion_2, u0_.color AS color_3, u0_.active AS active_4, u0_.deleted_at AS deleted_at_5, u0_.updated_at AS updated_at_6, u0_.created_at AS created_at_7, u0_.empresa_id AS empresa_id_8, u0_.responsable_usuario_id AS responsable_usuario_id_9 FROM unidad_negocio u0_ WHERE (u0_.id IN (?)) AND (u0_.deleted_at IS NULL) Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.descripcion AS descripcion_2, u0_.color AS color_3, u0_.active AS active_4, u0_.deleted_at AS deleted_at_5, u0_.updated_at AS updated_at_6, u0_.created_at AS created_at_7, u0_.empresa_id AS empresa_id_8, u0_.responsable_usuario_id AS responsable_usuario_id_9 FROM unidad_negocio u0_ WHERE ( u0_.id IN (?) ) AND (u0_.deleted_at IS NULL) SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.descripcion AS descripcion_2, u0_.color AS color_3, u0_.active AS active_4, u0_.deleted_at AS deleted_at_5, u0_.updated_at AS updated_at_6, u0_.created_at AS created_at_7, u0_.empresa_id AS empresa_id_8, u0_.responsable_usuario_id AS responsable_usuario_id_9 FROM unidad_negocio u0_ WHERE (u0_.id IN ('1')) AND (u0_.deleted_at IS NULL);
15	0.24 ms	SELECT u0_.id AS id_0, u0_.id_perseo AS id_perseo_1, u0_.avatar AS avatar_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.unidad_negocio_id AS unidad_negocio_id_6 FROM usuario u0_ WHERE (u0_.id IN (?)) AND (u0_.deleted_at IS NULL) Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.id_perseo AS id_perseo_1, u0_.avatar AS avatar_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.unidad_negocio_id AS unidad_negocio_id_6 FROM usuario u0_ WHERE ( u0_.id IN (?) ) AND (u0_.deleted_at IS NULL) SELECT u0_.id AS id_0, u0_.id_perseo AS id_perseo_1, u0_.avatar AS avatar_2, u0_.deleted_at AS deleted_at_3, u0_.updated_at AS updated_at_4, u0_.created_at AS created_at_5, u0_.unidad_negocio_id AS unidad_negocio_id_6 FROM usuario u0_ WHERE (u0_.id IN ('2')) AND (u0_.deleted_at IS NULL);
16	0.46 ms	SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL)) Parameters: [`"1887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('sinstock') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.reloj_idperseo AS reloj_idperseo_8, t0.reloj_foto AS reloj_foto_9, t0.reloj_modelo1 AS reloj_modelo1_10, t0.reloj_ref1 AS reloj_ref1_11, t0.reloj_fecha AS reloj_fecha_12, t0.reloj_caja AS reloj_caja_13, t0.reloj_papeles AS reloj_papeles_14, t0.itp AS itp_15, t0.comision AS comision_16, t0.precio_coste AS precio_coste_17, t0.precio_coste_total AS precio_coste_total_18, t0.precio_min_venta AS precio_min_venta_19, t0.precio_promocion AS precio_promocion_20, t0.precio_oferta AS precio_oferta_21, t0.precio_referencia AS precio_referencia_22, t0.precio_pagar AS precio_pagar_23, t0.margen_minimo AS margen_minimo_24, t0.margen_deseado AS margen_deseado_25, t0.margen_promocion AS margen_promocion_26, t0.costes_total AS costes_total_27, t0.valoracion_id AS valoracion_id_28, t0.reloj_id AS reloj_id_29, t0.clone_id AS clone_id_30, t0.reloj_inventario_id AS reloj_inventario_id_31, t0.reloj_marca_id AS reloj_marca_id_32, t0.reloj_aspecto_id AS reloj_aspecto_id_33, t0.reloj_base_id AS reloj_base_id_34, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = '1887' AND t0.type IN ('sinstock') AND ((t0.deleted_at IS NULL));
17	0.39 ms	SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.id IN (?)) AND (e0_.deleted_at IS NULL)) AND e0_.type IN ('aspecto') ORDER BY e0_.orden DESC Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ( ( e0_.id IN (?) ) AND (e0_.deleted_at IS NULL) ) AND e0_.type IN ('aspecto') ORDER BY e0_.orden DESC SELECT e0_.id AS id_0, e0_.key_estado AS key_estado_1, e0_.nombre AS nombre_2, e0_.icono AS icono_3, e0_.color AS color_4, e0_.orden AS orden_5, e0_.deleted_at AS deleted_at_6, e0_.updated_at AS updated_at_7, e0_.created_at AS created_at_8, e0_.type AS type_9 FROM estado e0_ WHERE ((e0_.id IN ('8')) AND (e0_.deleted_at IS NULL)) AND e0_.type IN ('aspecto') ORDER BY e0_.orden DESC;
18	0.38 ms	SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL)) Parameters: [`"1887"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = ? AND t0.type IN ('stock') AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.id_perseo AS id_perseo_2, t0.info_valoracion_compra AS info_valoracion_compra_3, t0.is_precio_chrono24 AS is_precio_chrono24_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.precio_promocion AS precio_promocion_8, t0.descuento AS descuento_9, t0.valoracion_id AS valoracion_id_10, t0.reloj_id AS reloj_id_11, t0.clone_id AS clone_id_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.type FROM valoraciones_relojes t0 WHERE t0.valoracion_id = '1887' AND t0.type IN ('stock') AND ((t0.deleted_at IS NULL));

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\Valoracion	The mappings App\Entity\Valoracion#valoracionesRelojesStocks and App\Entity\ValoracionesRelojesStock#valoracion are inconsistent with each other. The mappings App\Entity\Valoracion#valoracionesRelojesSinStocks and App\Entity\ValoracionesRelojesSinStock#valoracion are inconsistent with each other.
App\Entity\Operacion	No errors.
App\Entity\Compra	No errors.
App\Entity\Venta	The mappings App\Entity\Venta#detalle and App\Entity\DetalleVenta#venta are inconsistent with each other.
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\EstadoValoracion	No errors.
App\Entity\ValoracionesRelojes	No errors.
App\Entity\ValoracionesRelojesStock	No errors.
App\Entity\ValoracionesRelojesSinStock	The association App\Entity\ValoracionesRelojesSinStock#relojBase refers to the inverse side field App\Entity\Reloj#relojesDerivadosValoracion which does not exist.
App\Entity\Reloj	The mappings App\Entity\Reloj#relojesDerivadosValoracionSinStock and App\Entity\ValoracionesRelojesSinStock#relojBase are inconsistent with each other.
App\Entity\Empresa	No errors.
App\Entity\ActividadAbstract	No errors.
App\Entity\DetalleOperacion	The association App\Entity\DetalleOperacion#relojAspecto refers to the inverse side field App\Entity\EstadoAspecto#detalleCompras which does not exist. The association App\Entity\DetalleOperacion#relojMarca refers to the inverse side field App\Entity\Marca#detalleCompras which does not exist.
App\Entity\DetalleCompra	The association App\Entity\DetalleCompra#relojAspecto refers to the inverse side field App\Entity\EstadoAspecto#detalleCompras which does not exist. The association App\Entity\DetalleCompra#relojMarca refers to the inverse side field App\Entity\Marca#detalleCompras which does not exist.
App\Entity\Marca	The association App\Entity\Marca#valoracionesRelojes refers to the owning side field App\Entity\ValoracionesRelojes#relojMarca which does not exist. The association App\Entity\Marca#detalleOperaciones refers to the owning side field App\Entity\DetalleOperacion#marca which does not exist.
App\Entity\EstadoAspecto	The mappings App\Entity\EstadoAspecto#detalleOperaciones and App\Entity\DetalleOperacion#relojAspecto are inconsistent with each other. The association App\Entity\EstadoAspecto#valoracionesRelojes refers to the owning side field App\Entity\ValoracionesRelojes#relojAspecto which does not exist.
App\Entity\Referencia	The association App\Entity\Referencia#valoracionReloj refers to the inverse side field App\Entity\ValoracionesRelojes#referencias which does not exist.
App\Entity\Coste	The association App\Entity\Coste#valoracionesRelojes refers to the inverse side field App\Entity\ValoracionesRelojes#costes which does not exist.
App\Entity\TipoCargoAbstract	No errors.

Symfony Profiler

https://perseo.comerziawatches.com/es/admin/app/valoracion/1887/edit?uniqid=s69d37d45ce749 Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping