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 = 'rifutest.com' 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.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 = ?

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

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

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_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
  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
  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

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

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

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 = 'rifu/rifa-0/310' 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
  t0.id AS id_1,
  t0.locale AS locale_2
FROM
  locale t0
WHERE
  t0.id = ?

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

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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