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
  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
  valor
from
  main_setting
where
  llave = 'validate_integrity';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = 'COP' LIMIT 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 = ?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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