Symfony Profiler

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

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 = 'rifu.iridian.co' LIMIT 1;

SELECT
  valor
from
  main_setting
where
  llave = 'validate_integrity';

SELECT valor from main_setting where llave = 'validate_integrity';
            ;

SELECT
  if(
    @@global.time_zone = 'SYSTEM', @@system_time_zone,
    @@global.time_zone
  ) AS timezone;

SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;;

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

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;

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 = ?

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 = 781;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.habilitado AS habilitado_3
FROM
  locale t0
WHERE
  t0.habilitado = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.habilitado AS habilitado_3 FROM locale t0 WHERE t0.habilitado = 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

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;

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

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;

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

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 = 'social_media' GROUP BY i0_.id ORDER BY i0_.orden ASC;

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 = ?

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 = 'gestor/inner/ae499560-72df-4b70-ab32-7c37202d2d1a' AND l3_.locale = 'es';

SELECT
  s0_.valor AS valor_0,
  s0_.llave AS llave_1
FROM
  setting s0_
ORDER BY
  s0_.id ASC

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rifa r0_
  INNER JOIN estado_rifa e1_ ON r0_.estado_id = e1_.id
WHERE
  r0_.gestor_id = ?
  AND r0_.fecha_fin >= CURRENT_TIMESTAMP
  AND e1_.ref = ?
  AND COALESCE(r0_.es_suscripcion, 0) = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN estado_rifa e1_ ON r0_.estado_id = e1_.id WHERE r0_.gestor_id = 114 AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND e1_.ref = 'APROBADA' AND COALESCE(r0_.es_suscripcion, 0) = 0;

SELECT
  DISTINCT r0_.id AS id_0,
  i1_.image AS image_1,
  r2_.nombre AS nombre_2,
  u3_.nombre AS nombre_3,
  u3_.apellidos AS apellidos_4,
  l4_.locale AS locale_5,
  r0_.fecha_sorteo AS fecha_sorteo_6,
  r5_.valor AS valor_7,
  DATEDIFF(r0_.fecha_sorteo, CURRENT_DATE) AS sclr_8,
  (
    r0_.numero_fin - r0_.numero_inicio
  ) AS sclr_9,
  u6_.nombre AS nombre_10,
  u6_.apellidos AS apellidos_11,
  p7_.es_ganador AS es_ganador_12,
  p7_.folio AS folio_13
FROM
  rifa r0_
  INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id)
  INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN locale l4_ ON r2_.locale_id = l4_.id
  INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id)
  INNER JOIN currency c8_ ON r5_.currency_id = c8_.id
  LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id)
  INNER JOIN estado_rifa e9_ ON (e9_.id = r0_.estado_id)
  INNER JOIN producto p7_ ON (p7_.rifa_id = r0_.id)
  INNER JOIN usuario u6_ ON (p7_.comprador_id = u6_.id)
WHERE
  u3_.id = ?
  AND c8_.iso = ?
  AND e9_.ref = ?
  AND r0_.fecha_sorteo < CURRENT_DATE
  AND p7_.es_ganador = 1

SELECT DISTINCT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, u3_.apellidos AS apellidos_4, l4_.locale AS locale_5, r0_.fecha_sorteo AS fecha_sorteo_6, r5_.valor AS valor_7, DATEDIFF(r0_.fecha_sorteo, CURRENT_DATE) AS sclr_8, (r0_.numero_fin - r0_.numero_inicio) AS sclr_9, u6_.nombre AS nombre_10, u6_.apellidos AS apellidos_11, p7_.es_ganador AS es_ganador_12, p7_.folio AS folio_13 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c8_ ON r5_.currency_id = c8_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN estado_rifa e9_ ON (e9_.id = r0_.estado_id) INNER JOIN producto p7_ ON (p7_.rifa_id = r0_.id) INNER JOIN usuario u6_ ON (p7_.comprador_id = u6_.id) WHERE u3_.id = 114 AND c8_.iso = 'COP' AND e9_.ref = 'APROBADA' AND r0_.fecha_sorteo < CURRENT_DATE AND p7_.es_ganador = 1;

SELECT
  DISTINCT count(DISTINCT r0_.id) AS sclr_0
FROM
  rifa r0_
  INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id)
  INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN locale l3_ ON r2_.locale_id = l3_.id
  INNER JOIN rifa_currency r4_ ON (r0_.id = r4_.objeto_id)
  INNER JOIN currency c5_ ON r4_.currency_id = c5_.id
  LEFT JOIN imagen i6_ ON (r0_.imagen_base_id = i6_.id)
  INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id)
  INNER JOIN producto p8_ ON (p8_.rifa_id = r0_.id)
  INNER JOIN usuario u9_ ON (p8_.comprador_id = u9_.id)
WHERE
  u1_.id = ?
  AND c5_.iso = ?
  AND e7_.ref = ?
  AND r0_.fecha_sorteo < CURRENT_DATE
  AND p8_.es_ganador = 1

SELECT DISTINCT count(DISTINCT r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l3_ ON r2_.locale_id = l3_.id INNER JOIN rifa_currency r4_ ON (r0_.id = r4_.objeto_id) INNER JOIN currency c5_ ON r4_.currency_id = c5_.id LEFT JOIN imagen i6_ ON (r0_.imagen_base_id = i6_.id) INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN producto p8_ ON (p8_.rifa_id = r0_.id) INNER JOIN usuario u9_ ON (p8_.comprador_id = u9_.id) WHERE u1_.id = 114 AND c5_.iso = 'COP' AND e7_.ref = 'APROBADA' AND r0_.fecha_sorteo < CURRENT_DATE AND p8_.es_ganador = 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

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 = 'ae499560-72df-4b70-ab32-7c37202d2d1a' LIMIT 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

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;

SELECT
  r0_.id AS id_0,
  i1_.image AS image_1,
  r2_.nombre AS nombre_2,
  u3_.nombre AS nombre_3,
  l4_.locale AS locale_4,
  r0_.fecha_sorteo AS fecha_sorteo_5,
  r5_.valor AS valor_6,
  DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7,
  (
    r0_.numero_fin - r0_.numero_inicio
  ) AS sclr_8
FROM
  rifa r0_
  INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id)
  INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN locale l4_ ON r2_.locale_id = l4_.id
  LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id)
  INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id)
  INNER JOIN currency c6_ ON r5_.currency_id = c6_.id
  INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id)
  INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id)
WHERE
  e7_.ref = ?
  AND u3_.activo = 1
  AND e8_.nombre = ?
  AND r0_.fecha_fin >= CURRENT_TIMESTAMP
  AND u3_.id = ?
  AND c6_.iso = ?
  AND COALESCE(r0_.es_suscripcion, 0) = 0
ORDER BY
  r0_.fecha_sorteo ASC
LIMIT
  1

SELECT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, l4_.locale AS locale_4, r0_.fecha_sorteo AS fecha_sorteo_5, r5_.valor AS valor_6, DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7, (r0_.numero_fin - r0_.numero_inicio) AS sclr_8 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c6_ ON r5_.currency_id = c6_.id INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id) WHERE e7_.ref = 'APROBADA' AND u3_.activo = 1 AND e8_.nombre = 'Aprobado' AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND u3_.id = 114 AND c6_.iso = 'COP' AND COALESCE(r0_.es_suscripcion, 0) = 0 ORDER BY r0_.fecha_sorteo ASC LIMIT 1;

SELECT
  r0_.id AS id_0,
  i1_.image AS image_1,
  r2_.nombre AS nombre_2,
  u3_.nombre AS nombre_3,
  l4_.locale AS locale_4,
  r0_.fecha_sorteo AS fecha_sorteo_5,
  r5_.valor AS valor_6,
  DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7,
  (
    r0_.numero_fin - r0_.numero_inicio
  ) AS sclr_8
FROM
  rifa r0_
  INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id)
  INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN locale l4_ ON r2_.locale_id = l4_.id
  LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id)
  INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id)
  INNER JOIN currency c6_ ON r5_.currency_id = c6_.id
  INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id)
  INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id)
WHERE
  e7_.ref = ?
  AND u3_.activo = 1
  AND e8_.nombre = ?
  AND r0_.fecha_fin >= CURRENT_TIMESTAMP
  AND u3_.id = ?
  AND c6_.iso = ?
  AND r0_.es_suscripcion = 1
ORDER BY
  r0_.fecha_sorteo ASC
LIMIT
  1

SELECT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, l4_.locale AS locale_4, r0_.fecha_sorteo AS fecha_sorteo_5, r5_.valor AS valor_6, DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7, (r0_.numero_fin - r0_.numero_inicio) AS sclr_8 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c6_ ON r5_.currency_id = c6_.id INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id) WHERE e7_.ref = 'APROBADA' AND u3_.activo = 1 AND e8_.nombre = 'Aprobado' AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND u3_.id = 114 AND c6_.iso = 'COP' AND r0_.es_suscripcion = 1 ORDER BY r0_.fecha_sorteo ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.precio AS precio_1,
  p0_.frecuencia AS frecuencia_2,
  p0_.enabled AS enabled_3,
  p0_.fecha_creacion AS fecha_creacion_4,
  p0_.bono_descuento AS bono_descuento_5,
  p0_.gestor_id AS gestor_id_6,
  p0_.estado_id AS estado_id_7
FROM
  plan p0_
  INNER JOIN usuario u1_ ON p0_.gestor_id = u1_.id
  INNER JOIN estado_suscripcion e2_ ON p0_.estado_id = e2_.id
WHERE
  u1_.id = ?
  AND e2_.nombre IN (?, ?)

SELECT p0_.id AS id_0, p0_.precio AS precio_1, p0_.frecuencia AS frecuencia_2, p0_.enabled AS enabled_3, p0_.fecha_creacion AS fecha_creacion_4, p0_.bono_descuento AS bono_descuento_5, p0_.gestor_id AS gestor_id_6, p0_.estado_id AS estado_id_7 FROM plan p0_ INNER JOIN usuario u1_ ON p0_.gestor_id = u1_.id INNER JOIN estado_suscripcion e2_ ON p0_.estado_id = e2_.id WHERE u1_.id = 114 AND e2_.nombre IN ('APROBADO', 'PENDIENTE');

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

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;

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 = ?

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 = 2;

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 = ?

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 = 114;

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

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;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rifa r0_
  INNER JOIN estado_rifa e1_ ON (e1_.id = r0_.estado_id)
WHERE
  r0_.gestor_id = ?
  AND e1_.ref = ?
  AND r0_.fecha_fin < CURRENT_DATE