GET https://rifutest.com/en/suscribirse/13

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 20.49 ms
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:
[
  "rifutest.com"
]
2 19.15 ms
SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;
Parameters:
[]
3 19.27 ms
SELECT valor from main_setting where llave = 'validate_integrity';
Parameters:
[]

tenant connection

# Time Info
1 18.71 ms
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]
2 18.97 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.documento AS documento_3, t0.email AS email_4, t0.telefono AS telefono_5, t0.red_social AS red_social_6, t0.aprueba_tyc AS aprueba_tyc_7, t0.destacado AS destacado_8, t0.numero_rifas AS numero_rifas_9, t0.password AS password_10, t0.roles AS roles_11, t0.apellidos AS apellidos_12, t0.activar_boletin AS activar_boletin_13, t0.perfil_red_social AS perfil_red_social_14, t0.calificacion AS calificacion_15, t0.imagen_perfil AS imagen_perfil_16, t0.nombre_gestor AS nombre_gestor_17, t0.apodo AS apodo_18, t0.fecha_nacimiento AS fecha_nacimiento_19, t0.fecha_expedicion AS fecha_expedicion_20, t0.editable AS editable_21, t0.imagen_banner AS imagen_banner_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.fecha_ultimo_login AS fecha_ultimo_login_25, t0.ultima_direccion_ip AS ultima_direccion_ip_26, t0.fecha_ultimo_cambio_clave AS fecha_ultimo_cambio_clave_27, t0.fecha_activacion AS fecha_activacion_28, t0.fecha_desactivacion AS fecha_desactivacion_29, t0.activo AS activo_30, t0.envio_comentario AS envio_comentario_31, t0.saldo_retirable AS saldo_retirable_32, t0.saldo_no_retirable AS saldo_no_retirable_33, t0.descripcion_perfil AS descripcion_perfil_34, t0.intentos_login AS intentos_login_35, t0.acepta_cookies AS acepta_cookies_36, t0.metodo_registro AS metodo_registro_37, t0.direccion AS direccion_38, t0.acepta_correos AS acepta_correos_39, t0.token AS token_40, t0.acepta_monitoreo_cta AS acepta_monitoreo_cta_41, t0.email_contacto AS email_contacto_42, t0.tipo_persona_id AS tipo_persona_id_43, t0.certificado_existencia_id AS certificado_existencia_id_44, t0.documento_representante_id AS documento_representante_id_45, t0.imagen_perfil_principal_id AS imagen_perfil_principal_id_46, t0.imagen_banner_principal_id AS imagen_banner_principal_id_47, t0.estado_gestor_id AS estado_gestor_id_48, t0.ciudad_id AS ciudad_id_49, t0.imagen_destacada_id AS imagen_destacada_id_50, t51.id AS id_52, t51.updated_at AS updated_at_53, t51.created_at AS created_at_54, t51.usuario_id AS usuario_id_55, t51.estado_id AS estado_id_56, t51.acceso_rifas_id AS acceso_rifas_id_57, t0.tipo_documento_id AS tipo_documento_id_58 FROM usuario t0 LEFT JOIN acceso t51 ON t51.usuario_id = t0.id WHERE t0.id = ?
Parameters:
[
  "13"
]

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.