Query Metrics
27
Database Queries
11
Different statements
398.49 ms
Query time
13
Invalid entities
Queries
| #▲ | 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 |
|
| App\Entity\TipoCuenta | No errors. |
| App\Entity\Tarifa |
|
| App\Entity\Configuracion | No errors. |
| App\Entity\Usuario |
|
| App\Entity\TarifasPersonalesPastas |
|
| App\Entity\TarifasPersonalesConvertidores |
|
| App\Entity\ColorPersonal | No errors. |
| App\Entity\FormulaPersonal |
|
| 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 |
|
| App\Entity\Formula |
|
| 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 |
|
| App\Entity\FormulaPrueba | No errors. |
| App\Entity\Grupo | No errors. |
| App\Entity\TarifasBesaConvertidores |
|
| App\Entity\ConvertidorGrupo | No errors. |
| App\Entity\CuentaGrupo |
|
| App\Entity\CuentaGrupoColor |
|
| App\Entity\ConvertidorPrincipal | No errors. |
| App\Entity\Espectro | No errors. |
| App\Entity\Unidades | No errors. |
| App\Entity\ConvertidorEnvase | No errors. |
| App\Entity\EspectroPersonal |
|
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| App\Entity\Traducciones\ColorIdioma | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |