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
  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 = 'main_banner_rifas' 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 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.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
  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 = 'rifas' AND l3_.locale = 'en';

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
  DISTINCT r0_.id AS id_0,
  r0_.fecha_fin AS fecha_fin_1,
  r0_.fecha_inicio AS fecha_inicio_2,
  i1_.image AS image_3,
  u2_.nombre AS nombre_4,
  u2_.apellidos AS apellidos_5,
  u2_.uuid AS uuid_6,
  u2_.id AS id_7,
  i3_.image AS image_8,
  l4_.locale AS locale_9,
  r5_.nombre AS nombre_10,
  r0_.fecha_sorteo AS fecha_sorteo_11,
  COALESCE(r0_.numero_boletas_vendidas, 0) AS sclr_12,
  (
    r0_.numero_fin - r0_.numero_inicio
  ) AS sclr_13,
  r6_.valor AS valor_14,
  c7_.symbol AS symbol_15,
  c7_.iso AS iso_16,
  DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_17
FROM
  rifa r0_
  INNER JOIN usuario u2_ ON (u2_.id = r0_.gestor_id)
  INNER JOIN rifa_currency r6_ ON (r0_.id = r6_.objeto_id)
  INNER JOIN rifa_translation r5_ ON (r0_.id = r5_.objeto_id)
  INNER JOIN locale l4_ ON r5_.locale_id = l4_.id
  INNER JOIN currency c7_ ON r6_.currency_id = c7_.id
  LEFT JOIN rifa_subcategoria r9_ ON r0_.id = r9_.rifa_id
  LEFT JOIN subcategoria s8_ ON s8_.id = r9_.subcategoria_id
  LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id)
  LEFT JOIN imagen i3_ ON (
    u2_.imagen_perfil_principal_id = i3_.id
  )
  INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id)
WHERE
  COALESCE(r0_.es_suscripcion, 0) = 0
  AND r0_.fecha_fin >= CURRENT_DATE
  AND e10_.ref = ?
  AND c7_.iso = ?
  AND r0_.id IN (?, ?, ?)
ORDER BY
  r0_.created_at DESC

SELECT DISTINCT r0_.id AS id_0, r0_.fecha_fin AS fecha_fin_1, r0_.fecha_inicio AS fecha_inicio_2, i1_.image AS image_3, u2_.nombre AS nombre_4, u2_.apellidos AS apellidos_5, u2_.uuid AS uuid_6, u2_.id AS id_7, i3_.image AS image_8, l4_.locale AS locale_9, r5_.nombre AS nombre_10, r0_.fecha_sorteo AS fecha_sorteo_11, COALESCE(r0_.numero_boletas_vendidas, 0) AS sclr_12, (r0_.numero_fin - r0_.numero_inicio) AS sclr_13, r6_.valor AS valor_14, c7_.symbol AS symbol_15, c7_.iso AS iso_16, DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_17 FROM rifa r0_ INNER JOIN usuario u2_ ON (u2_.id = r0_.gestor_id) INNER JOIN rifa_currency r6_ ON (r0_.id = r6_.objeto_id) INNER JOIN rifa_translation r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN locale l4_ ON r5_.locale_id = l4_.id INNER JOIN currency c7_ ON r6_.currency_id = c7_.id LEFT JOIN rifa_subcategoria r9_ ON r0_.id = r9_.rifa_id LEFT JOIN subcategoria s8_ ON s8_.id = r9_.subcategoria_id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) LEFT JOIN imagen i3_ ON (u2_.imagen_perfil_principal_id = i3_.id) INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id) WHERE COALESCE(r0_.es_suscripcion, 0) = 0 AND r0_.fecha_fin >= CURRENT_DATE AND e10_.ref = 'APROBADA' AND c7_.iso = 'COP' AND r0_.id IN (310, 288, 280) ORDER BY r0_.created_at DESC;

SELECT
  subcategoria.id AS id,
  subcategoria.orden,
  subcategoria_translation.nombre as subcategoria,
  locale.locale AS idioma,
  ct.nombre as nombre_categoria,
  (
    SELECT
      COUNT(
        rifa_subcategoria.subcategoria_id
      )
    FROM
      rifa_subcategoria
      INNER JOIN rifa ON rifa.id = rifa_subcategoria.rifa_id
      INNER JOIN estado_rifa ON estado_rifa.id = rifa.estado_id
    WHERE
      rifa_subcategoria.subcategoria_id = subcategoria.id
      and estado_rifa.ref = 'APROBADA'
      and rifa.fecha_fin >= NOW()
  ) as conteo_rifas
FROM
  subcategoria
  INNER JOIN subcategoria_categoria ON subcategoria.id = subcategoria_categoria.subcategoria_id
  INNER JOIN categoria c ON subcategoria_categoria.categoria_id = c.id
  INNER JOIN categoria_translation ct on c.id = ct.objeto_id
  INNER JOIN subcategoria_translation ON subcategoria.id = subcategoria_translation.objeto_id
  INNER JOIN locale ON subcategoria_translation.locale_id = locale.id
  AND locale.id = ct.locale_id
WHERE
  locale.locale = :idioma
  AND c.visible = true
  AND subcategoria.visible = true
ORDER BY
  c.orden ASC,
  subcategoria.orden ASC

SELECT
                    subcategoria.id AS id,
                    subcategoria.orden,
                    subcategoria_translation.nombre as subcategoria,
                    locale.locale AS idioma,
                    ct.nombre as nombre_categoria,
                    (SELECT COUNT(rifa_subcategoria.subcategoria_id)
                     FROM rifa_subcategoria
                     INNER JOIN rifa ON rifa.id = rifa_subcategoria.rifa_id
                     INNER JOIN estado_rifa ON estado_rifa.id = rifa.estado_id
                     WHERE rifa_subcategoria.subcategoria_id = subcategoria.id and estado_rifa.ref = 'APROBADA' and rifa.fecha_fin >= NOW()) as conteo_rifas
                
                FROM
                    subcategoria
                    INNER JOIN subcategoria_categoria ON subcategoria.id = subcategoria_categoria.subcategoria_id
                    INNER JOIN categoria c ON subcategoria_categoria.categoria_id = c.id
                    INNER JOIN categoria_translation ct on c.id = ct.objeto_id
                    INNER JOIN subcategoria_translation ON subcategoria.id = subcategoria_translation.objeto_id
                    INNER JOIN locale ON subcategoria_translation.locale_id = locale.id AND locale.id = ct.locale_id
                WHERE locale.locale = 'en'
                AND c.visible = true
                AND subcategoria.visible =  true 
                
                ORDER BY c.orden ASC, subcategoria.orden ASC;

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.created_at AS created_at_1
FROM
  rifa r0_
  INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id)
  INNER JOIN rifa_currency r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN rifa_translation r3_ ON (r0_.id = r3_.objeto_id)
  INNER JOIN locale l4_ ON r3_.locale_id = l4_.id
  INNER JOIN currency c5_ ON r2_.currency_id = c5_.id
  LEFT JOIN rifa_subcategoria r7_ ON r0_.id = r7_.rifa_id
  LEFT JOIN subcategoria s6_ ON s6_.id = r7_.subcategoria_id
  LEFT JOIN imagen i8_ ON (r0_.imagen_base_id = i8_.id)
  LEFT JOIN imagen i9_ ON (
    u1_.imagen_perfil_principal_id = i9_.id
  )
  INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id)
WHERE
  COALESCE(r0_.es_suscripcion, 0) = 0
  AND r0_.fecha_fin >= CURRENT_DATE
  AND e10_.ref = ?
  AND c5_.iso = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  10

SELECT DISTINCT r0_.id AS id_0, r0_.created_at AS created_at_1 FROM rifa r0_ INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id) INNER JOIN rifa_currency r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN rifa_translation r3_ ON (r0_.id = r3_.objeto_id) INNER JOIN locale l4_ ON r3_.locale_id = l4_.id INNER JOIN currency c5_ ON r2_.currency_id = c5_.id LEFT JOIN rifa_subcategoria r7_ ON r0_.id = r7_.rifa_id LEFT JOIN subcategoria s6_ ON s6_.id = r7_.subcategoria_id LEFT JOIN imagen i8_ ON (r0_.imagen_base_id = i8_.id) LEFT JOIN imagen i9_ ON (u1_.imagen_perfil_principal_id = i9_.id) INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id) WHERE COALESCE(r0_.es_suscripcion, 0) = 0 AND r0_.fecha_fin >= CURRENT_DATE AND e10_.ref = 'APROBADA' AND c5_.iso = 'COP' ORDER BY r0_.created_at DESC LIMIT 10;

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_currency r2_ ON (r0_.id = r2_.objeto_id)
  INNER JOIN rifa_translation r3_ ON (r0_.id = r3_.objeto_id)
  INNER JOIN locale l4_ ON r3_.locale_id = l4_.id
  INNER JOIN currency c5_ ON r2_.currency_id = c5_.id
  LEFT JOIN rifa_subcategoria r7_ ON r0_.id = r7_.rifa_id
  LEFT JOIN subcategoria s6_ ON s6_.id = r7_.subcategoria_id
  LEFT JOIN imagen i8_ ON (r0_.imagen_base_id = i8_.id)
  LEFT JOIN imagen i9_ ON (
    u1_.imagen_perfil_principal_id = i9_.id
  )
  INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id)
WHERE
  COALESCE(r0_.es_suscripcion, 0) = 0
  AND r0_.fecha_fin >= CURRENT_DATE
  AND e10_.ref = ?
  AND c5_.iso = ?

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_currency r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN rifa_translation r3_ ON (r0_.id = r3_.objeto_id) INNER JOIN locale l4_ ON r3_.locale_id = l4_.id INNER JOIN currency c5_ ON r2_.currency_id = c5_.id LEFT JOIN rifa_subcategoria r7_ ON r0_.id = r7_.rifa_id LEFT JOIN subcategoria s6_ ON s6_.id = r7_.subcategoria_id LEFT JOIN imagen i8_ ON (r0_.imagen_base_id = i8_.id) LEFT JOIN imagen i9_ ON (u1_.imagen_perfil_principal_id = i9_.id) INNER JOIN estado_rifa e10_ ON (e10_.id = r0_.estado_id) WHERE COALESCE(r0_.es_suscripcion, 0) = 0 AND r0_.fecha_fin >= CURRENT_DATE AND e10_.ref = 'APROBADA' AND c5_.iso = 'COP';

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
  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
  s0_.id AS id_0,
  s1_.nombre AS nombre_1
FROM
  subcategoria s0_
  INNER JOIN subcategoria_translation s1_ ON s0_.id = s1_.objeto_id
  AND (s1_.objeto_id = s0_.id)
  INNER JOIN locale l2_ ON s1_.locale_id = l2_.id
  AND (s1_.locale_id = l2_.id)
WHERE
  s0_.id IN (?)
  AND l2_.locale = ?

SELECT s0_.id AS id_0, s1_.nombre AS nombre_1 FROM subcategoria s0_ INNER JOIN subcategoria_translation s1_ ON s0_.id = s1_.objeto_id AND (s1_.objeto_id = s0_.id) INNER JOIN locale l2_ ON s1_.locale_id = l2_.id AND (s1_.locale_id = l2_.id) WHERE s0_.id IN (NULL) AND l2_.locale = 'en';

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;