Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.58 ms Query time

12 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.01 ms (63.94%)	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: [`860`] View formatted query View runnable query Explain query 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 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 = 860 LIMIT 1;
0.57 ms (36.06%)	1	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.activo = ? AND t0.cuenta_id = ?) Parameters: [`1 860`] View formatted query View runnable query Explain query 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.activo = ? AND t0.cuenta_id = ? ) 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.activo = 1 AND t0.cuenta_id = 860);

Time▼

Count

Info

1.01 ms
(63.94%)

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:

[
  860
]

View formatted query View runnable query Explain query

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

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 = 860 LIMIT 1;

0.57 ms
(36.06%)

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.activo = ? AND t0.cuenta_id = ?)

Parameters:

View formatted query View runnable query Explain query

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.activo = ? 
    AND t0.cuenta_id = ?
  )

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.activo = 1 AND t0.cuenta_id = 860);

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\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\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\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\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.