https://urkisystem.besa.es/api/obtenerHistorico

Query Metrics

27 Database Queries
11 Different statements
398.49 ms Query time
13 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.default_config AS default_config_3, t0.descuento AS descuento_4, t0.visualizar_descuento AS visualizar_descuento_5, t0.contacto AS contacto_6, t0.password AS password_7, t0.id_erpbesa AS id_erpbesa_8, t0.aceptacion_disclaimer AS aceptacion_disclaimer_9, t0.email AS email_10, t0.empresa AS empresa_11, t0.telefono AS telefono_12, t0.fecha_creacion AS fecha_creacion_13, t0.fecha_modificacion AS fecha_modificacion_14, t0.fecha_login AS fecha_login_15, t0.version_app AS version_app_16, t0.laboratorio AS laboratorio_17, t0.compartir_tarifa AS compartir_tarifa_18, t0.token AS token_19, t0.tipo_cuenta_id AS tipo_cuenta_id_20, t0.tarifa_id AS tarifa_id_21, t22.id AS id_23, t22.valor AS valor_24, t22.pasta_disponible AS pasta_disponible_25, t22.datos_convertidores AS datos_convertidores_26, t22.cuenta_id AS cuenta_id_27, t0.parent_id AS parent_id_28 FROM cuenta t0 LEFT JOIN configuracion t22 ON t22.cuenta_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  173
]
2 141.47 ms
SELECT h0_.id AS id_0, h0_.observaciones AS observaciones_1, h0_.fecha_creacion AS fecha_creacion_2, h0_.peso_teorico AS peso_teorico_3, h0_.peso_real AS peso_real_4, h0_.precio AS precio_5, h0_.volumen_teorico AS volumen_teorico_6, h0_.volumen_real AS volumen_real_7, h0_.delta_peso AS delta_peso_8, h0_.delta_volumen AS delta_volumen_9, h0_.metros AS metros_10, h0_.numero_envases AS numero_envases_11, h0_.desidad_teorica AS desidad_teorica_12, h0_.densidad_real AS densidad_real_13, h0_.pbt AS pbt_14, h0_.tipo_dosificacion AS tipo_dosificacion_15, h0_.maquina AS maquina_16, h0_.index_conversion AS index_conversion_17, h0_.activo AS activo_18, h0_.ignorar AS ignorar_19, h0_.recalcular AS recalcular_20, h0_.quickmix AS quickmix_21, h0_.convertidor_principal AS convertidor_principal_22, h0_.cantidad AS cantidad_23, h0_.unit AS unit_24, h0_.predosificado AS predosificado_25, h0_.moneda AS moneda_26, h0_.origen AS origen_27, h0_.orden_id AS orden_id_28, h0_.usuario_id AS usuario_id_29, h0_.color_id AS color_id_30, h0_.color_personal_id AS color_personal_id_31, h0_.formula_id AS formula_id_32, h0_.formula_personal_id AS formula_personal_id_33, h0_.envase_id AS envase_id_34 FROM historico h0_ INNER JOIN usuario u1_ ON (u1_.id = h0_.usuario_id) WHERE (h0_.fecha_creacion BETWEEN ? AND ?) AND u1_.cuenta_id = ? LIMIT 1000
Parameters:
[
  "2026-09-19 23:59:59"
  "2026-09-21 23:59:59"
  173
]
3 0.36 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.identificador AS identificador_3, t0.password AS password_4, t0.tipo AS tipo_5, t0.activo AS activo_6, t0.fechacreacion AS fechacreacion_7, t0.cuenta_id AS cuenta_id_8 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
  276
]
4 0.20 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  212
]
5 0.46 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  212
]
6 0.19 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  2307
]
7 0.41 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  2307
]
8 0.38 ms
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.cantidad_real AS cantidad_real_3, t0.activo AS activo_4, t0.variablebg AS variablebg_5, t0.unidad_id AS unidad_id_6 FROM envase t0 WHERE t0.id = ?
Parameters:
[
  8
]
9 0.21 ms
SELECT t0.id AS id_1, t0.unidad AS unidad_2, t0.nombre AS nombre_3 FROM unidades t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.19 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  19662
]
11 0.45 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  19662
]
12 0.21 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.activo AS activo_4, t0.nombre AS nombre_5, t0.visto AS visto_6, t0.cuenta_id AS cuenta_id_7, t0.espectro_id AS espectro_id_8, t0.cliente_final_id AS cliente_final_id_9, t0.cuenta_shared_id AS cuenta_shared_id_10 FROM color_personal t0 WHERE t0.id = ?
Parameters:
[
  148926
]
13 248.37 ms
SELECT c0_.content AS content_0, c0_.field AS field_1 FROM color_idioma c0_ WHERE c0_.foreign_key = ? AND c0_.locale = ? AND c0_.object_class = ?
Parameters:
[
  "148926"
  "en_US"
  "App\Entity\ColorPersonal"
]
14 0.51 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.fecha_creacion AS fecha_creacion_3, t0.activo AS activo_4, t0.peso_total_teorico AS peso_total_teorico_5, t0.peso_total_real AS peso_total_real_6, t0.observaciones_internas AS observaciones_internas_7, t0.convertidor_principal AS convertidor_principal_8, t0.cuenta_id AS cuenta_id_9, t0.usuario_creador_id AS usuario_creador_id_10 FROM formula_personal t0 INNER JOIN color_formula_personal ON t0.id = color_formula_personal.formula_id WHERE color_formula_personal.color_id = ?
Parameters:
[
  148926
]
15 0.45 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "148475"
  "en_US"
  "App\Entity\FormulaPersonal"
]
16 0.36 ms
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.cantidad_real AS cantidad_real_3, t0.activo AS activo_4, t0.variablebg AS variablebg_5, t0.unidad_id AS unidad_id_6 FROM envase t0 WHERE t0.id = ?
Parameters:
[
  7
]
17 0.21 ms
SELECT t0.id AS id_1, t0.unidad AS unidad_2, t0.nombre AS nombre_3 FROM unidades t0 WHERE t0.id = ?
Parameters:
[
  2
]
18 0.21 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  2035
]
19 0.63 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  2035
]
20 0.25 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  14224
]
21 0.31 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  14224
]
22 0.20 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  2663
]
23 0.31 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  2663
]
24 0.20 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  4274
]
25 0.33 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  4274
]
26 0.19 ms
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.tipo AS tipo_3, t0.posicionCT AS posicionCT_4, t0.activo AS activo_5, t0.nombre AS nombre_6 FROM color t0 WHERE t0.id = ?
Parameters:
[
  2248
]
27 0.43 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.subtipo AS subtipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.activo AS activo_5, t0.peso_total_teorico AS peso_total_teorico_6, t0.observaciones_internas AS observaciones_internas_7, t0.observaciones_externas AS observaciones_externas_8, t0.codigo_formula AS codigo_formula_9, t0.oficial AS oficial_10, t0.group_id AS group_id_11, t12.id AS id_13, t12.convertidor_id AS convertidor_id_14, t12.formula_id AS formula_id_15 FROM formula t0 LEFT JOIN convertidor_principal t12 ON t12.formula_id = t0.id INNER JOIN color_formula ON t0.id = color_formula.formula_id WHERE color_formula.color_id = ?
Parameters:
[
  2248
]

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\Cuenta
  • The association App\Entity\Cuenta#tipoCuenta refers to the inverse side field App\Entity\TipoCuenta#id which is not defined as association.
  • The association App\Entity\Cuenta#tipoCuenta refers to the inverse side field App\Entity\TipoCuenta#id which does not exist.
  • The field App\Entity\Cuenta#estadistica is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Estadistica#cuenta does not contain the required 'inversedBy="estadistica"' attribute.
App\Entity\TipoCuenta No errors.
App\Entity\Tarifa
  • The mappings App\Entity\Tarifa#pastas and App\Entity\TarifasBesaPasta#tarifa are inconsistent with each other.
  • The mappings App\Entity\Tarifa#convertidores and App\Entity\TarifasBesaConvertidores#tarifa are inconsistent with each other.
App\Entity\Configuracion No errors.
App\Entity\Usuario
  • The association App\Entity\Usuario#formulasPersonales refers to the owning side field App\Entity\FormulaPersonal#UsuarioCreador which does not exist.
App\Entity\TarifasPersonalesPastas
  • The association App\Entity\TarifasPersonalesPastas#tarifa refers to the inverse side field App\Entity\Tarifa#tarifasBesa which does not exist.
App\Entity\TarifasPersonalesConvertidores
  • The association App\Entity\TarifasPersonalesConvertidores#tarifa refers to the inverse side field App\Entity\Tarifa#conertidores which does not exist.
App\Entity\ColorPersonal No errors.
App\Entity\FormulaPersonal
  • The mappings App\Entity\FormulaPersonal#usuarioCreador and App\Entity\Usuario#formulasPersonales are inconsistent with each other.
App\Entity\Estadistica No errors.
App\Entity\Componente No errors.
App\Entity\ComponentePersonal No errors.
App\Entity\ClienteFinal No errors.
App\Entity\Proyecto No errors.
App\Entity\ColorCuenta No errors.
App\Entity\FormulaCuenta No errors.
App\Entity\Historico
  • The association App\Entity\Historico#orden refers to the inverse side field App\Entity\Orden#historico which does not exist.
App\Entity\Formula
  • The field App\Entity\Formula#espectro is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Espectro#formula does not contain the required 'inversedBy="espectro"' attribute.
App\Entity\Color No errors.
App\Entity\Envase No errors.
App\Entity\HistoricoComponente No errors.
App\Entity\FormulaComponente No errors.
App\Entity\FormulaComponentePersonal No errors.
App\Entity\Convertidor No errors.
App\Entity\Pasta No errors.
App\Entity\Orden
  • The mappings App\Entity\Orden#proyecto and App\Entity\Proyecto#ordens are inconsistent with each other.
  • The association App\Entity\Orden#cuenta refers to the inverse side field App\Entity\Cuenta#ordens which does not exist.
  • The association App\Entity\Orden#usuario refers to the inverse side field App\Entity\Usuario#ordens which does not exist.
  • The mappings App\Entity\Orden#historicos and App\Entity\Historico#orden are inconsistent with each other.
App\Entity\FormulaPrueba No errors.
App\Entity\Grupo No errors.
App\Entity\TarifasBesaConvertidores
  • The association App\Entity\TarifasBesaConvertidores#tarifa refers to the inverse side field App\Entity\Tarifa#conertidores which does not exist.
App\Entity\ConvertidorGrupo No errors.
App\Entity\CuentaGrupo
  • If association App\Entity\CuentaGrupo#cuenta is many-to-one, then the inversed side App\Entity\Cuenta#configuracion has to be one-to-many.
App\Entity\CuentaGrupoColor
  • The association App\Entity\CuentaGrupoColor#color refers to the inverse side field App\Entity\Color#id which is not defined as association.
  • The association App\Entity\CuentaGrupoColor#color refers to the inverse side field App\Entity\Color#id which does not exist.
  • The association App\Entity\CuentaGrupoColor#colorPersonal refers to the inverse side field App\Entity\ColorPersonal#id which is not defined as association.
  • The association App\Entity\CuentaGrupoColor#colorPersonal refers to the inverse side field App\Entity\ColorPersonal#id which does not exist.
App\Entity\ConvertidorPrincipal No errors.
App\Entity\Espectro No errors.
App\Entity\Unidades No errors.
App\Entity\ConvertidorEnvase No errors.
App\Entity\EspectroPersonal
  • The association App\Entity\EspectroPersonal#cuenta refers to the inverse side field App\Entity\Cuenta#espectros which does not exist.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
App\Entity\Traducciones\ColorIdioma No errors.
Gedmo\Translatable\Entity\Translation No errors.