GET https://rifu.iridian.co/promo/rifa-loteria-huila/280

Query Metrics

47 Database Queries
30 Different statements
1012.49 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
80.44 ms
(7.95%)
4
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"
]
19.61 ms
(1.94%)
1
SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;
Parameters:
[]
19.49 ms
(1.92%)
1
SELECT valor from main_setting where llave = 'validate_integrity';
Parameters:
[]

tenant connection

Time Count Info
112.56 ms
(11.12%)
6
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale_id AS locale_id_6, t0.paquete_boleta_rifa_id AS paquete_boleta_rifa_id_7 FROM paquete_boleta_rifa_translation t0 WHERE t0.paquete_boleta_rifa_id = ?
Parameters:
[
  1
]
82.15 ms
(8.11%)
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:
[]
58.40 ms
(5.77%)
3
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_en AS image_en_5, i0_.image_mobile AS image_mobile_6, i0_.image_mobile_en AS image_mobile_en_7, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_8 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"
]
56.44 ms
(5.57%)
3
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_en AS image_en_3, t0.image_mobile AS image_mobile_4, t0.image_mobile_en AS image_mobile_en_5, t0.path AS path_6, t0.link AS link_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.orden AS orden_11, t0.llave AS llave_12, t0.galeria_id AS galeria_id_13, t0.rifa_id AS rifa_id_14 FROM imagen t0 WHERE t0.id = ?
Parameters:
[
  1258
]
55.62 ms
(5.49%)
3
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = ?
Parameters:
[
  1
]
50.74 ms
(5.01%)
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, i0_.image_en AS image_en_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 FROM imagen i0_ LEFT JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) LEFT JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 GROUP BY i0_.id ORDER BY i0_.orden ASC
Parameters:
[]
43.37 ms
(4.28%)
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:
[]
37.83 ms
(3.74%)
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:
[
  "promo/rifa-loteria-huila/280"
  "es"
]
37.47 ms
(3.70%)
2
SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC
Parameters:
[]
37.38 ms
(3.69%)
2
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.id = ?
Parameters:
[
  1
]
19.31 ms
(1.91%)
1
SELECT a0_.llave AS llave_0, a0_.nombre AS nombre_1, a1_.archivo AS archivo_2 FROM archivo a1_ INNER JOIN archivo_publico a0_ ON a1_.archivo_publico_id = a0_.id
Parameters:
[]
19.30 ms
(1.91%)
1
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
]
19.09 ms
(1.89%)
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:
[
  280
]
19.04 ms
(1.88%)
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.id = ?
Parameters:
[
  232
]
19.03 ms
(1.88%)
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.numero_boletas_vendidas AS numero_boletas_vendidas_21, t0.alto_flujo AS alto_flujo_22, t0.gestor_id AS gestor_id_23, t0.loteria_asociada_id AS loteria_asociada_id_24, t0.imagen_base_id AS imagen_base_id_25, t0.comprobante_propiedad_id AS comprobante_propiedad_id_26, t0.archivo_terminos_condiciones_id AS archivo_terminos_condiciones_id_27, t0.estado_id AS estado_id_28, t0.archivo_declaracion_id AS archivo_declaracion_id_29, t30.id AS id_31, t30.created_at AS created_at_32, t30.updated_at AS updated_at_33, t30.rifa_id AS rifa_id_34 FROM rifa t0 LEFT JOIN acceso_rifa t30 ON t30.rifa_id = t0.id WHERE t0.id = ?
Parameters:
[
  280
]
19.02 ms
(1.88%)
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:
[
  280
]
19.01 ms
(1.88%)
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:
[
  280
]
18.88 ms
(1.86%)
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:
[
  280
]
18.86 ms
(1.86%)
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:
[
  280
]
18.85 ms
(1.86%)
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:
[
  6
]
18.78 ms
(1.86%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.image_en AS image_en_3, t0.image_mobile AS image_mobile_4, t0.image_mobile_en AS image_mobile_en_5, t0.path AS path_6, t0.link AS link_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.orden AS orden_11, t0.llave AS llave_12, t0.galeria_id AS galeria_id_13, t0.rifa_id AS rifa_id_14 FROM imagen t0 WHERE t0.rifa_id = ?
Parameters:
[
  280
]
18.73 ms
(1.85%)
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:
[
  232
]
18.72 ms
(1.85%)
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"
]
18.63 ms
(1.84%)
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:
[
  280
]
18.60 ms
(1.84%)
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:
[]
18.58 ms
(1.84%)
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
]
18.54 ms
(1.83%)
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:
[]

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\Rifa\TipoSeleccionBoletaLocale No errors.
App\Entity\General\Galeria No errors.
App\Entity\General\ImagenTranslation No errors.
App\Entity\General\Seo No errors.
App\Entity\Rifa\PaqueteBoletaRifaTranslation 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\Usuario\UsuarioOtp No errors.
App\Entity\Usuario\ApiToken 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\ArchivoPublico No errors.
App\Entity\General\VersionAplicacion No errors.
App\Entity\General\VersionAplicacionTranslation No errors.