GET https://rifutest.com/en/rifu/rifa-moto-premio-b/307

Query Metrics

43 Database Queries
27 Different statements
1195.86 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
74.28 ms
(6.21%)
3
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"
]
25.66 ms
(2.15%)
1
SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;
Parameters:
[]
24.44 ms
(2.04%)
1
SELECT valor from main_setting where llave = 'validate_integrity';
Parameters:
[]

tenant connection

Time Count Info
171.84 ms
(14.37%)
7
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?
Parameters:
[
  1381
]
122.27 ms
(10.22%)
5
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?
Parameters:
[
  1
]
105.06 ms
(8.79%)
1
SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto t0_ LEFT JOIN texto_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC
Parameters:
[]
75.63 ms
(6.32%)
1
SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto_big t0_ LEFT JOIN texto_big_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC
Parameters:
[]
50.35 ms
(4.21%)
2
SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, i0_.image_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 FROM imagen i0_ INNER JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) LEFT JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 AND g1_.llave = ? GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[
  "credit_cards"
]
49.21 ms
(4.12%)
2
SELECT s0_.id AS id_0, s0_.url AS url_1, i1_.image AS image_2, s2_.titulo AS titulo_3, s2_.keywords AS keywords_4, s2_.descripcion AS descripcion_5 FROM seo s0_ LEFT JOIN seo_translation s2_ ON s0_.id = s2_.objeto_id LEFT JOIN locale l3_ ON s2_.locale_id = l3_.id LEFT JOIN imagen i1_ ON s0_.imagen_id = i1_.id WHERE s0_.url = ? AND l3_.locale = ?
Parameters:
[
  "rifu/rifa-moto-premio-b/307"
  "en"
]
49.21 ms
(4.11%)
2
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]
48.86 ms
(4.09%)
2
SELECT t0.id AS id_1, t0.locale AS locale_2 FROM locale t0 WHERE t0.id = ?
Parameters:
[
  1
]
28.48 ms
(2.38%)
1
SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_5 FROM imagen i0_ INNER JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) INNER JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[]
26.17 ms
(2.19%)
1
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
]
25.00 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.rifa_id = ?
Parameters:
[
  307
]
24.94 ms
(2.09%)
1
SELECT t0.id AS id_1, t0.numero_inicio AS numero_inicio_2, t0.numero_fin AS numero_fin_3, t0.pagadero_al_portador AS pagadero_al_portador_4, t0.destacado AS destacado_5, t0.created_at AS created_at_6, t0.fecha_sorteo AS fecha_sorteo_7, t0.visible AS visible_8, t0.imagen_principal AS imagen_principal_9, t0.paht_comprobante_propiedad AS paht_comprobante_propiedad_10, t0.comprobante_terminosy_condiciones AS comprobante_terminosy_condiciones_11, t0.compra_minima AS compra_minima_12, t0.compra_maxima AS compra_maxima_13, t0.fecha_inicio AS fecha_inicio_14, t0.fecha_fin AS fecha_fin_15, t0.fecha_declaracion AS fecha_declaracion_16, t0.envio_comentario AS envio_comentario_17, t0.updated_at AS updated_at_18, t0.contract_id AS contract_id_19, t0.es_suscripcion AS es_suscripcion_20, t0.gestor_id AS gestor_id_21, t0.loteria_asociada_id AS loteria_asociada_id_22, t0.imagen_base_id AS imagen_base_id_23, t0.comprobante_propiedad_id AS comprobante_propiedad_id_24, t0.archivo_terminos_condiciones_id AS archivo_terminos_condiciones_id_25, t0.estado_id AS estado_id_26, t0.archivo_declaracion_id AS archivo_declaracion_id_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.updated_at AS updated_at_31, t28.rifa_id AS rifa_id_32 FROM rifa t0 LEFT JOIN acceso_rifa t28 ON t28.rifa_id = t0.id WHERE t0.id = ?
Parameters:
[
  307
]
24.75 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.numero_boletas AS numero_boletas_3, t0.posicion AS posicion_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM paquete_boleta_rifa t0 INNER JOIN rifa_paquete_boleta_rifa ON t0.id = rifa_paquete_boleta_rifa.paquete_boleta_rifa_id WHERE rifa_paquete_boleta_rifa.rifa_id = ?
Parameters:
[
  307
]
24.74 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.categoria_nombre AS categoria_nombre_5, t0.updated_at AS updated_at_6, t0.llave AS llave_7, t0.padre_id AS padre_id_8 FROM subcategoria t0 INNER JOIN rifa_subcategoria ON t0.id = rifa_subcategoria.subcategoria_id WHERE rifa_subcategoria.rifa_id = ?
Parameters:
[
  307
]
24.71 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.termino_caducidad AS termino_caducidad_3, t0.descripcion_premio AS descripcion_premio_4, t0.texto_publicidad AS texto_publicidad_5, t0.caracteristica_producto AS caracteristica_producto_6, t0.caracteristica_producto2 AS caracteristica_producto2_7, t0.caracteristica_producto3 AS caracteristica_producto3_8, t0.caracteristica_producto4 AS caracteristica_producto4_9, t0.caracteristica_producto5 AS caracteristica_producto5_10, t0.locale_id AS locale_id_11, t0.objeto_id AS objeto_id_12 FROM rifa_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  307
]
24.69 ms
(2.06%)
1
SELECT r0_.numero_fin - r0_.numero_inicio + 1 AS sclr_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM producto p1_ WHERE p1_.rifa_id = r0_.id) AS sclr_1 FROM rifa r0_ WHERE r0_.id = ?
Parameters:
[
  307
]
24.66 ms
(2.06%)
1
SELECT t0.id AS id_1, t0.orden AS orden_2, t0.visible AS visible_3, t0.perfil AS perfil_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.red_social_id AS red_social_id_7, t0.usuario_id AS usuario_id_8 FROM redes_sociales_usuario t0 WHERE t0.usuario_id = ?
Parameters:
[
  13
]
24.54 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.nombre AS nombre_3, t0.orden AS orden_4 FROM estado_rifa t0 WHERE t0.id = ?
Parameters:
[
  4
]
24.54 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.locale_id AS locale_id_4, t0.objeto_id AS objeto_id_5 FROM subcategoria_translation t0 WHERE t0.objeto_id = ?
Parameters:
[
  5
]
24.53 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.es_random AS es_random_5, t0.created_at AS created_at_6 FROM tipo_seleccion_boleta t0 INNER JOIN rifa_tipo_seleccion_boleta ON t0.id = rifa_tipo_seleccion_boleta.tipo_seleccion_boleta_id WHERE rifa_tipo_seleccion_boleta.rifa_id = ?
Parameters:
[
  307
]
24.47 ms
(2.05%)
1
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.currency_id AS currency_id_3, t0.objeto_id AS objeto_id_4 FROM rifa_currency t0 WHERE t0.objeto_id = ?
Parameters:
[
  307
]
24.42 ms
(2.04%)
1
SELECT v0_.id AS id_0, v0_.version AS version_1, v0_.created_at AS created_at_2, v0_.updated_at AS updated_at_3 FROM version_aplicacion v0_ ORDER BY v0_.id DESC LIMIT 1
Parameters:
[]
24.26 ms
(2.03%)
1
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3, t0.symbol AS symbol_4 FROM currency t0 WHERE t0.iso = ? LIMIT 1
Parameters:
[
  "COP"
]
24.16 ms
(2.02%)
1
SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3, t0.symbol AS symbol_4 FROM currency t0
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\Rifa\Rifa No errors.
App\Entity\Usuario\Usuario No errors.
App\Entity\Rifa\LoteriaAsociada No errors.
App\Entity\General\Imagen No errors.
App\Entity\General\Archivo No errors.
App\Entity\Rifa\EstadoRifa No errors.
App\Entity\Blacklist\AccesoRifa No errors.
App\Entity\Rifa\RifaTranslation No errors.
App\Entity\Rifa\RifaCurrency No errors.
App\Entity\Catalogue\Subcategoria No errors.
App\Entity\Rifa\PaqueteBoletaRifa No errors.
App\Entity\Rifa\Boleta No errors.
App\Entity\Rifa\ZonaRifa 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\Rifa\RifaComentarios No errors.
App\Entity\Rifa\TipoSeleccionBoleta No errors.
App\Entity\General\ContractEvent No errors.
App\Entity\General\Locale No errors.
App\Entity\Usuario\TipoDocumentoTraslation No errors.
App\Entity\Rifa\EstadoRifaTranslation No errors.
App\Entity\General\Currency No errors.
App\Entity\General\Galeria No errors.
App\Entity\General\ImagenTranslation No errors.
App\Entity\General\Seo No errors.
App\Entity\Catalogue\Categoria
  • The field App\Entity\Catalogue\Categoria#translations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Catalogue\CategoriaTranslation#objeto does not contain the required 'inversedBy="translations"' attribute.
App\Entity\Catalogue\SubcategoriaTranslation No errors.
App\Entity\General\TipoPersona 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\Cart\Compra 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\Usuario\DatosBancarios No errors.
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\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\General\RedesSociales No errors.
App\Entity\General\SeoTranslation No errors.
App\Entity\General\Texto No errors.
App\Entity\General\TextoTranslation No errors.
App\Entity\General\TextoBig No errors.
App\Entity\General\TextoBigTranslation No errors.
App\Entity\General\VersionAplicacion No errors.
App\Entity\General\VersionAplicacionTranslation No errors.