http://52.178.182.160/api/etiquetabyConvertidor?idConvertidor=45&lang=en&peligrosidad=false

Query Metrics

69 Database Queries
12 Different statements
19.93 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.29 ms
(46.61%)
28
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:
[
  "9"
  "en"
  "App\Entity\FrasePeligrosidad"
]
6.44 ms
(32.31%)
28
SELECT t0.id AS id_1, t0.clave AS clave_2, t0.tipo AS tipo_3, t0.codigo AS codigo_4, t0.frase_peligrosidad AS frase_peligrosidad_5 FROM frase_peligrosidad t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.81 ms
(4.06%)
1
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:
[
  358
]
0.79 ms
(3.95%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.imagen64 AS imagen64_3, t0.activo AS activo_4 FROM pictograma t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.45 ms
(2.27%)
2
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:
[
  1
]
0.41 ms
(2.04%)
1
SELECT t0.id AS id_1, t0.prioridad AS prioridad_2, t0.etiqueta_id AS etiqueta_id_3, t0.frase_peligrosidad_id AS frase_peligrosidad_id_4 FROM etiqueta_frase_peligrosidad t0 WHERE t0.etiqueta_id = ?
Parameters:
[
  85
]
0.32 ms
(1.60%)
1
SELECT t0.id AS id_1, t0.peligrosidad AS peligrosidad_2, t0.convertidor_id AS convertidor_id_3 FROM etiqueta t0 WHERE t0.convertidor_id = ?
Parameters:
[
  45
]
0.31 ms
(1.57%)
1
SELECT t0.id AS id_1, t0.peligrosidad AS peligrosidad_2, t0.convertidor_id AS convertidor_id_3 FROM etiqueta t0 WHERE t0.convertidor_id = ? AND t0.peligrosidad = ?
Parameters:
[
  "45"
  0
]
0.31 ms
(1.55%)
1
SELECT t0.id AS id_1, t0.orden AS orden_2, t0.etiqueta_id AS etiqueta_id_3, t0.pictograma_id AS pictograma_id_4 FROM pictograma_etiqueta t0 WHERE t0.etiqueta_id = ?
Parameters:
[
  85
]
0.30 ms
(1.51%)
1
SELECT t1.id AS id_2, t1.codigo AS codigo_3, t1.densidad AS densidad_4, t1.pbt AS pbt_5, t1.rgb AS rgb_6, t1.activo AS activo_7, t1.voc AS voc_8, t1.visualizar AS visualizar_9, t1.nombre AS nombre_10, t1.descripcion AS descripcion_11, t1.tipo_mix AS tipo_mix_12, t1.tipo_metal AS tipo_metal_13, t0.unidad AS unidad_14, t0.proporcion_peso AS proporcion_peso_15, t0.proporcion_volumen AS proporcion_volumen_16, t0.proporcion_metalizada AS proporcion_metalizada_17, t0.ruta_ficha_tecnica AS ruta_ficha_tecnica_18, t0.ruta_ficha_toxica AS ruta_ficha_toxica_19, t0.ruta_ficha_nociva AS ruta_ficha_nociva_20, t1.categoria FROM convertidor t0 INNER JOIN componente t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  45
]
0.27 ms
(1.37%)
1
SELECT t0.id AS id_1, t0.unidad AS unidad_2, t0.nombre AS nombre_3 FROM unidades t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.23 ms
(1.17%)
1
SELECT t0.id AS id_1, t0.convertidor_id AS convertidor_id_2, t0.envase_id AS envase_id_3 FROM convertidor_envase t0 WHERE t0.convertidor_id = ?
Parameters:
[
  45
]

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\FrasePeligrosidad No errors.
App\Entity\PictogramaEtiqueta No errors.
App\Entity\Pictograma No errors.
App\Entity\Idioma No errors.
App\Entity\Etiqueta
  • If association App\Entity\Etiqueta#convertidor is many-to-one, then the inversed side App\Entity\Convertidor#etiqueta has to be one-to-many.
App\Entity\Convertidor No errors.
App\Entity\EtiquetaFrasePeligrosidad No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\ConvertidorGrupo No errors.
App\Entity\ConvertidorEnvase No errors.
App\Entity\Envase No errors.
App\Entity\Unidades 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.