GET https://rifu.iridian.co/en/suscribirse/406f8461-1935-4b8a-bfaf-ea0dbd50d02f

Query Metrics

5 Database Queries
5 Different statements
103.91 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
28.31 ms
(27.25%)
1
SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1
Parameters:
[
  "rifu.iridian.co"
]
18.91 ms
(18.20%)
1
SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;
Parameters:
[]
18.77 ms
(18.06%)
1
SELECT valor from main_setting where llave = 'validate_integrity';
Parameters:
[]

tenant connection

Time Count Info
19.05 ms
(18.33%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.nombre AS nombre_3, t0.documento AS documento_4, t0.email AS email_5, t0.telefono AS telefono_6, t0.red_social AS red_social_7, t0.aprueba_tyc AS aprueba_tyc_8, t0.destacado AS destacado_9, t0.numero_rifas AS numero_rifas_10, t0.password AS password_11, t0.roles AS roles_12, t0.apellidos AS apellidos_13, t0.activar_boletin AS activar_boletin_14, t0.perfil_red_social AS perfil_red_social_15, t0.calificacion AS calificacion_16, t0.imagen_perfil AS imagen_perfil_17, t0.nombre_gestor AS nombre_gestor_18, t0.apodo AS apodo_19, t0.fecha_nacimiento AS fecha_nacimiento_20, t0.fecha_expedicion AS fecha_expedicion_21, t0.editable AS editable_22, t0.imagen_banner AS imagen_banner_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.fecha_ultimo_login AS fecha_ultimo_login_26, t0.ultima_direccion_ip AS ultima_direccion_ip_27, t0.fecha_ultimo_cambio_clave AS fecha_ultimo_cambio_clave_28, t0.fecha_activacion AS fecha_activacion_29, t0.fecha_desactivacion AS fecha_desactivacion_30, t0.activo AS activo_31, t0.envio_comentario AS envio_comentario_32, t0.saldo_retirable AS saldo_retirable_33, t0.saldo_no_retirable AS saldo_no_retirable_34, t0.descripcion_perfil AS descripcion_perfil_35, t0.intentos_login AS intentos_login_36, t0.acepta_cookies AS acepta_cookies_37, t0.metodo_registro AS metodo_registro_38, t0.direccion AS direccion_39, t0.acepta_correos AS acepta_correos_40, t0.token AS token_41, t0.acepta_monitoreo_cta AS acepta_monitoreo_cta_42, t0.email_contacto AS email_contacto_43, t0.correo_verificado AS correo_verificado_44, t0.tipo_persona_id AS tipo_persona_id_45, t0.certificado_existencia_id AS certificado_existencia_id_46, t0.documento_representante_id AS documento_representante_id_47, t0.imagen_perfil_principal_id AS imagen_perfil_principal_id_48, t0.imagen_banner_principal_id AS imagen_banner_principal_id_49, t0.estado_gestor_id AS estado_gestor_id_50, t0.ciudad_id AS ciudad_id_51, t0.imagen_destacada_id AS imagen_destacada_id_52, t53.id AS id_54, t53.updated_at AS updated_at_55, t53.created_at AS created_at_56, t53.usuario_id AS usuario_id_57, t53.estado_id AS estado_id_58, t53.acceso_rifas_id AS acceso_rifas_id_59, t0.tipo_documento_id AS tipo_documento_id_60 FROM usuario t0 LEFT JOIN acceso t53 ON t53.usuario_id = t0.id WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "406f8461-1935-4b8a-bfaf-ea0dbd50d02f"
]
18.88 ms
(18.17%)
1
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
tenant doctrine.dbal.tenant_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
tenant doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
MultiTenancyBundle\Entity\Hostname No errors.
MultiTenancyBundle\Entity\Tenant No errors.

tenant entity manager

Class Mapping errors
App\Entity\General\Setting No errors.
App\Entity\Usuario\Usuario No errors.
App\Entity\General\TipoPersona No errors.
App\Entity\General\Archivo No errors.
App\Entity\General\Imagen No errors.
App\Entity\Solicitud\EstadoSolicitud No errors.
App\Entity\General\Ciudad No errors.
App\Entity\Blacklist\Acceso No errors.
App\Entity\Blacklist\EstadoAcceso No errors.
App\Entity\Usuario\TipoDocumento No errors.
App\Entity\Rifa\Rifa No errors.
App\Entity\Cart\Compra No errors.
App\Entity\Catalogue\Subcategoria No errors.
App\Entity\General\ImagenCliente No errors.
App\Entity\General\RedesSocialesUsuario No errors.
App\Entity\Usuario\UsuarioDescripcion No errors.
App\Entity\General\SolicitudEdicion No errors.
App\Entity\Rifa\Boleta No errors.
App\Entity\Usuario\DatosBancarios No errors.
App\Entity\Catalogue\Producto
  • The mappings App\Entity\Catalogue\Producto#currencies and App\Entity\Catalogue\ProductoCurrency#objeto are inconsistent with each other.
App\Entity\Solicitud\SolicitudPago No errors.
App\Entity\Movimiento\RetiroGestor No errors.
App\Entity\Usuario\UsuarioEdicion No errors.
App\Entity\Usuario\UsuarioComentarios No errors.
App\Entity\Usuario\GrupoUsuario No errors.
App\Entity\Blacklist\AccesoRifa No errors.
App\Entity\Blacklist\AccesoGestor No errors.
App\Entity\Usuario\Funcion No errors.
App\Entity\Usuario\UsuarioEventoLog No errors.
App\Entity\General\EventoSignificativo No errors.
App\Entity\Cart\Retencion No errors.
App\Entity\Suscripcion\Suscripcion
  • The association App\Entity\Suscripcion\Suscripcion#plan refers to the inverse side field App\Entity\Suscripcion\Plan#subscriptions which does not exist.
App\Entity\Suscripcion\Plan
  • The mappings App\Entity\Suscripcion\Plan#suscripciones and App\Entity\Suscripcion\Suscripcion#plan are inconsistent with each other.
App\Entity\General\MetodoPago No errors.
App\Entity\Afiliacion\LinkAfiliacion No errors.
App\Entity\Usuario\UsuarioOtp No errors.
App\Entity\Usuario\ApiToken No errors.