Query Metrics
162
Database Queries
18
Different statements
106.36 ms
Query time
10
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
41.58 ms (39.09%) |
54 |
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:
[
"4078"
]
|
|
20.84 ms (19.59%) |
34 |
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:
[
"1886"
]
|
|
15.66 ms (14.73%) |
29 |
SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.alias AS alias_3, t0.identificacion_tipo AS identificacion_tipo_4, t0.identificacion AS identificacion_5, t0.direccion AS direccion_6, t0.cp AS cp_7, t0.region AS region_8, t0.ciudad AS ciudad_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.identificacion_frontal AS identificacion_frontal_12, t0.identificacion_trasera AS identificacion_trasera_13, t0.idioma AS idioma_14, t0.entidad_bancaria AS entidad_bancaria_15, t0.iban AS iban_16, t0.swift AS swift_17, t0.observaciones AS observaciones_18, t0.deleted_at AS deleted_at_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.pais AS pais_22, t23.id AS id_24, t23.username AS username_25, t23.email AS email_26, t23.roles AS roles_27, t23.password AS password_28, t23.nombre AS nombre_29, t23.primer_apellido AS primer_apellido_30, t23.segundo_apellido AS segundo_apellido_31, t23.tipo_genero_id AS tipo_genero_id_32, t23.direccion AS direccion_33, t23.cp AS cp_34, t23.region AS region_35, t23.ciudad AS ciudad_36, t23.telefono AS telefono_37, t23.deleted_at AS deleted_at_38, t23.updated_at AS updated_at_39, t23.created_at AS created_at_40, t23.pais AS pais_41, t23.ccaa_id AS ccaa_id_42, t23.provincia_id AS provincia_id_43, t23.cliente_id AS cliente_id_44, t23.usuario_id AS usuario_id_45, t0.ccaa_id AS ccaa_id_46, t0.provincia_id AS provincia_id_47 FROM cliente t0 LEFT JOIN user t23 ON t23.cliente_id = t0.id AND ((t23.deleted_at IS NULL)) WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"1128"
]
|
|
6.56 ms (6.17%) |
21 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.logo AS logo_3, t0.deleted_at AS deleted_at_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6 FROM marca t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"169"
]
|
|
5.48 ms (5.15%) |
2 |
SELECT DISTINCT v0_.id AS id_0, GREATEST(COALESCE(v1_.fecha_rechazo, '1981-05-16'), COALESCE(v1_.fecha_tramitada, '1981-05-16'), COALESCE(v1_.fecha_tramitacion, '1981-05-16'), COALESCE(v1_.fecha_aceptacion, '1981-05-16'), COALESCE(v1_.fecha_enviada, '1981-05-16')) AS sclr_1, v0_.id AS id_2 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN (?) AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL))) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock') ORDER BY sclr_1 DESC, v0_.id ASC LIMIT 50
Parameters:
[
"sinstock"
]
|
|
5.23 ms (4.92%) |
2 |
SELECT v0_.id AS id_0, v0_.id_perseo AS id_perseo_1, v0_.info_valoracion_compra AS info_valoracion_compra_2, v0_.is_precio_chrono24 AS is_precio_chrono24_3, v0_.deleted_at AS deleted_at_4, v0_.updated_at AS updated_at_5, v0_.created_at AS created_at_6, v0_.precio_promocion AS precio_promocion_7, v0_.descuento AS descuento_8, v0_.reloj_idperseo AS reloj_idperseo_9, v0_.reloj_foto AS reloj_foto_10, v0_.reloj_modelo1 AS reloj_modelo1_11, v0_.reloj_ref1 AS reloj_ref1_12, v0_.reloj_fecha AS reloj_fecha_13, v0_.reloj_caja AS reloj_caja_14, v0_.reloj_papeles AS reloj_papeles_15, v0_.itp AS itp_16, v0_.comision AS comision_17, v0_.precio_coste AS precio_coste_18, v0_.precio_coste_total AS precio_coste_total_19, v0_.precio_min_venta AS precio_min_venta_20, v0_.precio_promocion AS precio_promocion_21, v0_.precio_oferta AS precio_oferta_22, v0_.precio_referencia AS precio_referencia_23, v0_.precio_pagar AS precio_pagar_24, v0_.margen_minimo AS margen_minimo_25, v0_.margen_deseado AS margen_deseado_26, v0_.margen_promocion AS margen_promocion_27, v0_.costes_total AS costes_total_28, GREATEST(COALESCE(v1_.fecha_rechazo, '1981-05-16'), COALESCE(v1_.fecha_tramitada, '1981-05-16'), COALESCE(v1_.fecha_tramitacion, '1981-05-16'), COALESCE(v1_.fecha_aceptacion, '1981-05-16'), COALESCE(v1_.fecha_enviada, '1981-05-16')) AS sclr_29, v0_.type AS type_30, v0_.valoracion_id AS valoracion_id_31, v0_.reloj_id AS reloj_id_32, v0_.clone_id AS clone_id_33, v0_.plataforma_promocion_id AS plataforma_promocion_id_34, v0_.reloj_inventario_id AS reloj_inventario_id_35, v0_.reloj_marca_id AS reloj_marca_id_36, v0_.reloj_aspecto_id AS reloj_aspecto_id_37, v0_.reloj_base_id AS reloj_base_id_38 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN (?) AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL)) AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock') ORDER BY sclr_29 DESC, v0_.id ASC
Parameters:
[ "sinstock" "4078" "4071" "4072" "4073" "4074" "4025" "2194" "1429" "1415" "1398" "1394" "1395" "1382" "1323" "1328" "1329" "2217" "1311" "1318" "1207" "1171" "1166" "1172" "1153" "1143" "1135" "1136" "1137" "1138" "1139" "1140" "1141" "1142" "1131" "1078" "1068" "1072" "1073" "1098" "1059" "1060" "1025" "1028" "1021" "1015" "1016" "1017" "1012" "985" "955" ] |
|
2.09 ms (1.97%) |
1 |
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM valoraciones_relojes v0_ INNER JOIN valoracion v1_ ON v0_.valoracion_id = v1_.id AND (v1_.deleted_at IS NULL) LEFT JOIN valoraciones_relojes v2_ ON (v0_.id = v2_.id) AND v2_.type IN ('sinstock') AND (v2_.deleted_at IS NULL) WHERE ((v0_.type IN (?) AND ((v1_.fecha_enviada IS NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_tramitada IS NULL) OR (v1_.fecha_enviada IS NOT NULL AND v1_.fecha_aceptacion IS NULL AND v1_.fecha_rechazo IS NULL) OR (v1_.fecha_aceptacion IS NOT NULL AND v1_.fecha_tramitacion IS NULL AND v1_.fecha_rechazo IS NULL))) AND (v0_.deleted_at IS NULL)) AND v0_.type IN ('stock', 'sinstock')
Parameters:
[
"sinstock"
]
|
|
1.90 ms (1.78%) |
4 |
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.valoracion_id AS valoracion_id_8, t0.reloj_id AS reloj_id_9, t0.clone_id AS clone_id_10, t0.type, t0.precio_promocion AS precio_promocion_11, t0.descuento AS descuento_12, t0.plataforma_promocion_id AS plataforma_promocion_id_13, t0.reloj_idperseo AS reloj_idperseo_14, t0.reloj_foto AS reloj_foto_15, t0.reloj_modelo1 AS reloj_modelo1_16, t0.reloj_ref1 AS reloj_ref1_17, t0.reloj_fecha AS reloj_fecha_18, t0.reloj_caja AS reloj_caja_19, t0.reloj_papeles AS reloj_papeles_20, t0.itp AS itp_21, t0.comision AS comision_22, t0.precio_coste AS precio_coste_23, t0.precio_coste_total AS precio_coste_total_24, t0.precio_min_venta AS precio_min_venta_25, t0.precio_promocion AS precio_promocion_26, t0.precio_oferta AS precio_oferta_27, t0.precio_referencia AS precio_referencia_28, t0.precio_pagar AS precio_pagar_29, t0.margen_minimo AS margen_minimo_30, t0.margen_deseado AS margen_deseado_31, t0.margen_promocion AS margen_promocion_32, t0.costes_total AS costes_total_33, t0.reloj_inventario_id AS reloj_inventario_id_34, t0.reloj_marca_id AS reloj_marca_id_35, t0.reloj_aspecto_id AS reloj_aspecto_id_36, t0.reloj_base_id AS reloj_base_id_37 FROM valoraciones_relojes t0 WHERE t0.id = ? AND t0.type IN ('stock', 'sinstock') AND ((t0.deleted_at IS NULL))
Parameters:
[
"8"
]
|
|
1.58 ms (1.49%) |
5 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comision AS comision_3, t0.descripcion AS descripcion_4, t0.deleted_at AS deleted_at_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7 FROM canal t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"4"
]
|
|
0.93 ms (0.87%) |
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:
[
"3"
]
|
|
0.90 ms (0.84%) |
2 |
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 ('valoracion') AND ((t0.deleted_at IS NULL))
Parameters:
[
"12"
]
|
|
0.70 ms (0.66%) |
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:
[ "ivan" "["ROLE_ADMIN","ROLE_USER"]" "admin_app_valoracion_list" null "GET" "{"cookie":["sf_redirect=%7B%22token%22%3A%228be73d%22%2C%22route%22%3A%22admin_app_valoracion_edit%22%2C%22method%22%3A%22POST%22%2C%22controller%22%3A%7B%22class%22%3A%22App%5C%5CController%5C%5CAdmin%5C%5CValoracionAdminController%22%2C%22method%22%3A%22editAction%22%2C%22file%22%3A%22%5C%2Fvar%5C%2Fwww%5C%2Fvhosts%5C%2Fperseo.comerziawatches.com%5C%2Fhttpdocs%5C%2Fperseo%5C%2Fhttpdocs%5C%2Fsrc%5C%2FController%5C%2FAdmin%5C%2FValoracionAdminController.php%22%2C%22line%22%3A125%7D%2C%22status_code%22%3A302%2C%22status_text%22%3A%22Found%22%7D; 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"],"referer":["https:\/\/perseo.comerziawatches.com\/es\/admin\/app\/valoracion\/1887\/edit?uniqid=s69d37d45ce749"],"sec-fetch-dest":["document"],"accept-language":["es-ES,es;q=0.9"],"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"],"priority":["u=0, i"],"sec-fetch-site":["same-origin"],"accept":["text\/html,application\/xhtml+xml,application\/xml;q=0.9,*\/*;q=0.8"],"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"]}" "[]" "{"filter":{"_page":"1","_per_page":"50","usuario":{"type":"1","value":"0"},"estado":{"type":"1","value":["ABIERTA","EN_ESPERA","ACEPTADA"]}}}" "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" ] |
|
0.70 ms (0.66%) |
1 |
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_.unidad_negocio_id = ?) AND (u0_.deleted_at IS NULL)
Parameters:
[
"1"
]
|
|
0.67 ms (0.63%) |
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"2"
]
|
|
0.59 ms (0.55%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.40 ms (0.38%) |
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.usuario_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"1"
]
|
|
0.28 ms (0.26%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.27 ms (0.26%) |
1 |
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.responsable_usuario_id = ? AND ((t0.deleted_at IS NULL))
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 |
|---|---|
| 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 |
|
| App\Entity\ValoracionesRelojes | No errors. |
| App\Entity\UnidadNegocio | No errors. |
| App\Entity\Empresa | No errors. |
| App\Entity\ActividadAbstract | No errors. |
| App\Entity\Operacion | No errors. |
| App\Entity\ValoracionesRelojesSinStock |
|
| App\Entity\ValoracionesRelojesStock | No errors. |
| App\Entity\Reloj |
|
| App\Entity\Canal | No errors. |
| App\Entity\Marca |
|
| App\Entity\EstadoAbstract | No errors. |
| App\Entity\EstadoAspecto |
|
| App\Entity\DetalleOperacion |
|
| App\Entity\DetalleCompra |
|
| App\Entity\Compra | No errors. |
| App\Entity\Referencia |
|
| App\Entity\Coste |
|
| App\Entity\Venta |
|
| App\Entity\EstadoOperacion | No errors. |
| App\Entity\Banco | No errors. |
| App\Entity\Firmante | No errors. |
| App\Entity\Intercambio | No errors. |
| App\Entity\EstadoValoracion | No errors. |
| App\Entity\AccionAbstract | No errors. |
| App\Entity\AccionCompetencia | No errors. |
| App\Entity\AccionAnuncio | No errors. |