Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

254.94 ms Query time

13 Invalid entities

Queries


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.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.activo = ? ORDER BY t0.nombre ASC
SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.cuenta_id AS cuenta_id_3 FROM color_cuenta t0 WHERE t0.cuenta_id = ?
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 = ?
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.activo = ? AND t0.cuenta_id = ? ORDER BY t0.nombre ASC
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.activo = ? AND t0.cuenta_shared_id = ? ORDER BY t0.nombre ASC

#▲	Time	Info
1	1.27 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: [`450`] 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 = 450 LIMIT 1;
2	205.35 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.activo = ? ORDER BY t0.nombre ASC Parameters: [`1`] View formatted query View runnable query Explain query 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.activo = ? ORDER BY t0.nombre ASC 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.activo = 1 ORDER BY t0.nombre ASC;
3	0.51 ms	SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.cuenta_id AS cuenta_id_3 FROM color_cuenta t0 WHERE t0.cuenta_id = ? Parameters: [`450`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.cuenta_id AS cuenta_id_3 FROM color_cuenta t0 WHERE t0.cuenta_id = ? SELECT t0.id AS id_1, t0.color_id AS color_id_2, t0.cuenta_id AS cuenta_id_3 FROM color_cuenta t0 WHERE t0.cuenta_id = 450;
4	0.44 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 = ? Parameters: [`269`] 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 = ? 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 = 269;
5	0.48 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.activo = ? AND t0.cuenta_id = ? ORDER BY t0.nombre ASC Parameters: [`1 450`] View formatted query View runnable query Explain query 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.activo = ? AND t0.cuenta_id = ? ORDER BY t0.nombre ASC 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.activo = 1 AND t0.cuenta_id = 450 ORDER BY t0.nombre ASC;
6	46.89 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.activo = ? AND t0.cuenta_shared_id = ? ORDER BY t0.nombre ASC Parameters: [`1 450`] View formatted query View runnable query Explain query 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.activo = ? AND t0.cuenta_shared_id = ? ORDER BY t0.nombre ASC 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.activo = 1 AND t0.cuenta_shared_id = 450 ORDER BY t0.nombre ASC;

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\Color	No errors.
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\FormulaPrueba	No errors.
App\Entity\Convertidor	No errors.
App\Entity\Pasta	No errors.
App\Entity\Grupo	No errors.
App\Entity\Envase	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\FormulaComponente	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\HistoricoComponente	No errors.
App\Entity\FormulaComponentePersonal	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\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\EspectroPersonal	The association App\Entity\EspectroPersonal#cuenta refers to the inverse side field App\Entity\Cuenta#espectros which does not exist.

Symfony Profiler

http://52.178.182.160/api/obtenerColores

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping