Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.codigo_contable AS codigo_contable_3,
  t0.nombre AS nombre_4,
  t0.fecha AS fecha_5,
  t0.inicio AS inicio_6,
  t0.fin AS fin_7,
  t0.plazas AS plazas_8,
  t0.jugadores AS jugadores_9,
  t0.observaciones AS observaciones_10,
  t0.observaciones_planificacion AS observaciones_planificacion_11,
  t0.aviso AS aviso_12,
  t0.informacion AS informacion_13,
  t0.rfeg_id AS rfeg_id_14,
  t0.cartel AS cartel_15,
  t0.horario AS horario_16,
  t0.fichero_inscritos AS fichero_inscritos_17,
  t0.fichero_clasificaciones AS fichero_clasificaciones_18,
  t0.fichero_localeRulePdf AS fichero_localeRulePdf_19,
  t0.fichero_banner_schedule AS fichero_banner_schedule_20,
  t0.fichero_reglas AS fichero_reglas_21,
  t0.fichero_varios_nombre AS fichero_varios_nombre_22,
  t0.fichero_varios AS fichero_varios_23,
  t0.circular AS circular_24,
  t0.nombre_observaciones AS nombre_observaciones_25,
  t0.hash AS hash_26,
  t0.estado AS estado_27,
  t0.estado_corte AS estado_corte_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.tarifa_reglamento AS tarifa_reglamento_31,
  t0.redireccion AS redireccion_32,
  t0.wagr AS wagr_33,
  t0.subvencion_junta AS subvencion_junta_34,
  t0.galeria AS galeria_35,
  t0.informacion_popup AS informacion_popup_36,
  t0.reglas AS reglas_37,
  t0.num_competiciones AS num_competiciones_38,
  t0.tag_color AS tag_color_39,
  t0.show_live_scoring AS show_live_scoring_40,
  t0.rfc AS rfc_41,
  t0.estricto AS estricto_42,
  t0.hcp_estricto AS hcp_estricto_43,
  t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44,
  t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45,
  t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46,
  t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47,
  t0.hcp_juego_masculino AS hcp_juego_masculino_48,
  t0.hcp_juego_femenino AS hcp_juego_femenino_49,
  t0.hcp_juego_pareja AS hcp_juego_pareja_50,
  t0.hcp_juego_equipo AS hcp_juego_equipo_51,
  t0.premios AS premios_52,
  t0.arbitrable AS arbitrable_53,
  t0.direccion_torneos AS direccion_torneos_54,
  t0.asistencia_presidente AS asistencia_presidente_55,
  t0.institucional AS institucional_56,
  t0.voluntarios AS voluntarios_57,
  t0.flyer AS flyer_58,
  t0.permitir AS permitir_59,
  t0.social AS social_60,
  t0.visible AS visible_61,
  t0.seguimiento AS seguimiento_62,
  t0.popup_inscripcion AS popup_inscripcion_63,
  t0.popup_inscripcion_texto AS popup_inscripcion_texto_64,
  t0.mostrar_sorteo AS mostrar_sorteo_65,
  t0.malaga2020 AS malaga2020_66,
  t0.lista_espera AS lista_espera_67,
  t0.restringir_licencia AS restringir_licencia_68,
  t0.seleccion_tarifas AS seleccion_tarifas_69,
  t0.permitir_extranjeros AS permitir_extranjeros_70,
  t0.plazas_manana AS plazas_manana_71,
  t0.plazas_tarde AS plazas_tarde_72,
  t0.tarjeta_electronica AS tarjeta_electronica_73,
  t0.auto_assign_marker AS auto_assign_marker_74,
  t0.livescoring_comunidad AS livescoring_comunidad_75,
  t0.plazas_lista_espera AS plazas_lista_espera_76,
  t0.deleted_at AS deleted_at_77,
  t0.contacto AS contacto_78,
  t0.benefico AS benefico_79,
  t0.flickr_gallery AS flickr_gallery_80,
  t0.barra_salida AS barra_salida_81,
  t0.observaciones_frontend AS observaciones_frontend_82,
  t0.mostrar_plazas AS mostrar_plazas_83,
  t0.politica_inicio AS politica_inicio_84,
  t0.politica_entrega AS politica_entrega_85,
  t0.short_url AS short_url_86,
  t0.privada AS privada_87,
  t0.camera_url AS camera_url_88,
  t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89,
  t0.liquidation_date AS liquidation_date_90,
  t0.collection_date AS collection_date_91,
  t0.livescoring_policy AS livescoring_policy_92,
  t0.livescoring_formula AS livescoring_formula_93,
  t0.show_events AS show_events_94,
  t0.destacada AS destacada_95,
  t0.Formula_id AS Formula_id_96,
  t0.Modo_id AS Modo_id_97,
  t0.Calculo_id AS Calculo_id_98,
  t0.Club_id AS Club_id_99,
  t0.Organizador_id AS Organizador_id_100,
  t0.Criterio_id AS Criterio_id_101,
  t0.Criterio2_id AS Criterio2_id_102,
  t103.id AS id_104,
  t103.created_at AS created_at_105,
  t103.updated_at AS updated_at_106,
  t103.jugador_id AS jugador_id_107,
  t103.competicion_id AS competicion_id_108
FROM
  Competicion t0
  LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.codigo_contable AS codigo_contable_3, t0.nombre AS nombre_4, t0.fecha AS fecha_5, t0.inicio AS inicio_6, t0.fin AS fin_7, t0.plazas AS plazas_8, t0.jugadores AS jugadores_9, t0.observaciones AS observaciones_10, t0.observaciones_planificacion AS observaciones_planificacion_11, t0.aviso AS aviso_12, t0.informacion AS informacion_13, t0.rfeg_id AS rfeg_id_14, t0.cartel AS cartel_15, t0.horario AS horario_16, t0.fichero_inscritos AS fichero_inscritos_17, t0.fichero_clasificaciones AS fichero_clasificaciones_18, t0.fichero_localeRulePdf AS fichero_localeRulePdf_19, t0.fichero_banner_schedule AS fichero_banner_schedule_20, t0.fichero_reglas AS fichero_reglas_21, t0.fichero_varios_nombre AS fichero_varios_nombre_22, t0.fichero_varios AS fichero_varios_23, t0.circular AS circular_24, t0.nombre_observaciones AS nombre_observaciones_25, t0.hash AS hash_26, t0.estado AS estado_27, t0.estado_corte AS estado_corte_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.tarifa_reglamento AS tarifa_reglamento_31, t0.redireccion AS redireccion_32, t0.wagr AS wagr_33, t0.subvencion_junta AS subvencion_junta_34, t0.galeria AS galeria_35, t0.informacion_popup AS informacion_popup_36, t0.reglas AS reglas_37, t0.num_competiciones AS num_competiciones_38, t0.tag_color AS tag_color_39, t0.show_live_scoring AS show_live_scoring_40, t0.rfc AS rfc_41, t0.estricto AS estricto_42, t0.hcp_estricto AS hcp_estricto_43, t0.hcp_inscrito_masculino AS hcp_inscrito_masculino_44, t0.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_45, t0.hcp_inscrito_femenino AS hcp_inscrito_femenino_46, t0.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_47, t0.hcp_juego_masculino AS hcp_juego_masculino_48, t0.hcp_juego_femenino AS hcp_juego_femenino_49, t0.hcp_juego_pareja AS hcp_juego_pareja_50, t0.hcp_juego_equipo AS hcp_juego_equipo_51, t0.premios AS premios_52, t0.arbitrable AS arbitrable_53, t0.direccion_torneos AS direccion_torneos_54, t0.asistencia_presidente AS asistencia_presidente_55, t0.institucional AS institucional_56, t0.voluntarios AS voluntarios_57, t0.flyer AS flyer_58, t0.permitir AS permitir_59, t0.social AS social_60, t0.visible AS visible_61, t0.seguimiento AS seguimiento_62, t0.popup_inscripcion AS popup_inscripcion_63, t0.popup_inscripcion_texto AS popup_inscripcion_texto_64, t0.mostrar_sorteo AS mostrar_sorteo_65, t0.malaga2020 AS malaga2020_66, t0.lista_espera AS lista_espera_67, t0.restringir_licencia AS restringir_licencia_68, t0.seleccion_tarifas AS seleccion_tarifas_69, t0.permitir_extranjeros AS permitir_extranjeros_70, t0.plazas_manana AS plazas_manana_71, t0.plazas_tarde AS plazas_tarde_72, t0.tarjeta_electronica AS tarjeta_electronica_73, t0.auto_assign_marker AS auto_assign_marker_74, t0.livescoring_comunidad AS livescoring_comunidad_75, t0.plazas_lista_espera AS plazas_lista_espera_76, t0.deleted_at AS deleted_at_77, t0.contacto AS contacto_78, t0.benefico AS benefico_79, t0.flickr_gallery AS flickr_gallery_80, t0.barra_salida AS barra_salida_81, t0.observaciones_frontend AS observaciones_frontend_82, t0.mostrar_plazas AS mostrar_plazas_83, t0.politica_inicio AS politica_inicio_84, t0.politica_entrega AS politica_entrega_85, t0.short_url AS short_url_86, t0.privada AS privada_87, t0.camera_url AS camera_url_88, t0.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_89, t0.liquidation_date AS liquidation_date_90, t0.collection_date AS collection_date_91, t0.livescoring_policy AS livescoring_policy_92, t0.livescoring_formula AS livescoring_formula_93, t0.show_events AS show_events_94, t0.destacada AS destacada_95, t0.Formula_id AS Formula_id_96, t0.Modo_id AS Modo_id_97, t0.Calculo_id AS Calculo_id_98, t0.Club_id AS Club_id_99, t0.Organizador_id AS Organizador_id_100, t0.Criterio_id AS Criterio_id_101, t0.Criterio2_id AS Criterio2_id_102, t103.id AS id_104, t103.created_at AS created_at_105, t103.updated_at AS updated_at_106, t103.jugador_id AS jugador_id_107, t103.competicion_id AS competicion_id_108 FROM Competicion t0 LEFT JOIN marcador_rfc t103 ON t103.competicion_id = t0.id WHERE t0.id = '47170' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.grupos AS grupos_2,
  t0.tercerycuarto AS tercerycuarto_3,
  t0.clasificados_grupo AS clasificados_grupo_4,
  t0.emparejamientos AS emparejamientos_5,
  t0.tipo_emparejamiento AS tipo_emparejamiento_6,
  t0.solo_ganadores_encuentro AS solo_ganadores_encuentro_7,
  t0.Competicion_id AS Competicion_id_8
FROM
  ConfiguracionMatchPlay t0
WHERE
  t0.Competicion_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.grupos AS grupos_2, t0.tercerycuarto AS tercerycuarto_3, t0.clasificados_grupo AS clasificados_grupo_4, t0.emparejamientos AS emparejamientos_5, t0.tipo_emparejamiento AS tipo_emparejamiento_6, t0.solo_ganadores_encuentro AS solo_ganadores_encuentro_7, t0.Competicion_id AS Competicion_id_8 FROM ConfiguracionMatchPlay t0 WHERE t0.Competicion_id = 47170 LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.equipo AS equipo_1,
  i0_.pareja AS pareja_2,
  i0_.participa AS participa_3,
  i0_.estado AS estado_4,
  i0_.hcp AS hcp_5,
  i0_.nombre_equipo AS nombre_equipo_6,
  i0_.observaciones AS observaciones_7,
  i0_.tipo_inscripcion AS tipo_inscripcion_8,
  i0_.created_at AS created_at_9,
  i0_.updated_at AS updated_at_10,
  i0_.hcp_sms AS hcp_sms_11,
  i0_.hcp_juego AS hcp_juego_12,
  i0_.num_competiciones AS num_competiciones_13,
  i0_.turno AS turno_14,
  i0_.agrupacion AS agrupacion_15,
  i0_.valido AS valido_16,
  i0_.invitado AS invitado_17,
  i0_.covid_modif AS covid_modif_18,
  i0_.order_waiting_list AS order_waiting_list_19,
  i0_.token AS token_20,
  i0_.Competicion_id AS Competicion_id_21,
  i0_.Jugador_id AS Jugador_id_22,
  i0_.Nivel_id AS Nivel_id_23,
  i0_.Especial_id AS Especial_id_24,
  i0_.Pedido_id AS Pedido_id_25,
  i0_.Categoria_id AS Categoria_id_26,
  i0_.CatCondicion_id AS CatCondicion_id_27,
  i0_.equipo_entidad AS equipo_entidad_28,
  i0_.tarifa AS tarifa_29
FROM
  Inscrito i0_
WHERE
  i0_.Competicion_id = ?
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC,
  i0_.equipo ASC,
  i0_.pareja ASC,
  i0_.id ASC

SELECT i0_.id AS id_0, i0_.equipo AS equipo_1, i0_.pareja AS pareja_2, i0_.participa AS participa_3, i0_.estado AS estado_4, i0_.hcp AS hcp_5, i0_.nombre_equipo AS nombre_equipo_6, i0_.observaciones AS observaciones_7, i0_.tipo_inscripcion AS tipo_inscripcion_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.hcp_sms AS hcp_sms_11, i0_.hcp_juego AS hcp_juego_12, i0_.num_competiciones AS num_competiciones_13, i0_.turno AS turno_14, i0_.agrupacion AS agrupacion_15, i0_.valido AS valido_16, i0_.invitado AS invitado_17, i0_.covid_modif AS covid_modif_18, i0_.order_waiting_list AS order_waiting_list_19, i0_.token AS token_20, i0_.Competicion_id AS Competicion_id_21, i0_.Jugador_id AS Jugador_id_22, i0_.Nivel_id AS Nivel_id_23, i0_.Especial_id AS Especial_id_24, i0_.Pedido_id AS Pedido_id_25, i0_.Categoria_id AS Categoria_id_26, i0_.CatCondicion_id AS CatCondicion_id_27, i0_.equipo_entidad AS equipo_entidad_28, i0_.tarifa AS tarifa_29 FROM Inscrito i0_ WHERE i0_.Competicion_id = 47170 AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC, i0_.equipo ASC, i0_.pareja ASC, i0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.licencia AS licencia_2,
  t0.nombre AS nombre_3,
  t0.sexo AS sexo_4,
  t0.apellidos AS apellidos_5,
  t0.hcp AS hcp_6,
  t0.tipo_hcp AS tipo_hcp_7,
  t0.estado_hcp AS estado_hcp_8,
  t0.fecha AS fecha_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.activo AS activo_12,
  t0.habilitado AS habilitado_13,
  t0.licencia_corta AS licencia_corta_14,
  t0.email AS email_15,
  t0.email_cod AS email_cod_16,
  t0.tlfn AS tlfn_17,
  t0.telefono AS telefono_18,
  t0.tlfn_updated_at AS tlfn_updated_at_19,
  t0.num_competiciones AS num_competiciones_20,
  t0.created_by AS created_by_21,
  t0.creation_data AS creation_data_22,
  t0.Club_id AS Club_id_23,
  t0.Nivel_id AS Nivel_id_24,
  t0.Pais_id AS Pais_id_25,
  t26.id AS id_27,
  t26.nombre AS nombre_28,
  t0.User_id AS User_id_29,
  t0.user_app AS user_app_30
FROM
  Jugador t0
  LEFT JOIN Pais t26 ON t0.Pais_id = t26.id
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.licencia AS licencia_2, t0.nombre AS nombre_3, t0.sexo AS sexo_4, t0.apellidos AS apellidos_5, t0.hcp AS hcp_6, t0.tipo_hcp AS tipo_hcp_7, t0.estado_hcp AS estado_hcp_8, t0.fecha AS fecha_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.activo AS activo_12, t0.habilitado AS habilitado_13, t0.licencia_corta AS licencia_corta_14, t0.email AS email_15, t0.email_cod AS email_cod_16, t0.tlfn AS tlfn_17, t0.telefono AS telefono_18, t0.tlfn_updated_at AS tlfn_updated_at_19, t0.num_competiciones AS num_competiciones_20, t0.created_by AS created_by_21, t0.creation_data AS creation_data_22, t0.Club_id AS Club_id_23, t0.Nivel_id AS Nivel_id_24, t0.Pais_id AS Pais_id_25, t26.id AS id_27, t26.nombre AS nombre_28, t0.User_id AS User_id_29, t0.user_app AS user_app_30 FROM Jugador t0 LEFT JOIN Pais t26 ON t0.Pais_id = t26.id WHERE t0.id IN (1434772, 1428427, 1452167, 1452695, 1436157, 1284180, 1258596, 1434769, 1473198, 1273031, 1475623, 1428434, 1246683, 1451889, 1452046, 1452178);

SELECT
  t0.id AS id_1,
  t0.orden AS orden_2,
  t0.inicio AS inicio_3,
  t0.fin AS fin_4,
  t0.Competicion_id AS Competicion_id_5,
  t0.Modalidad_id AS Modalidad_id_6,
  t0.jornada_id AS jornada_id_7
FROM
  Ronda t0
WHERE
  t0.Competicion_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.orden AS orden_2, t0.inicio AS inicio_3, t0.fin AS fin_4, t0.Competicion_id AS Competicion_id_5, t0.Modalidad_id AS Modalidad_id_6, t0.jornada_id AS jornada_id_7 FROM Ronda t0 WHERE t0.Competicion_id = 47170 ORDER BY t0.orden ASC;

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.orden AS orden_3,
  t0.created_at AS created_at_4,
  t0.procesada AS procesada_5,
  t0.sms_hcp AS sms_hcp_6,
  t0.asc_valor AS asc_valor_7,
  t0.clima AS clima_8,
  t0.zona_bandera AS zona_bandera_9,
  t0.sensibilidad AS sensibilidad_10,
  t0.bloqueo AS bloqueo_11,
  t0.team_livescoring AS team_livescoring_12,
  t0.scramble_estricto AS scramble_estricto_13,
  t0.Competicion_id AS Competicion_id_14,
  t0.Modalidad_id AS Modalidad_id_15,
  t0.Trazado_id AS Trazado_id_16,
  t17.id AS id_18,
  t17.value AS value_19,
  t17.created_at AS created_at_20,
  t17.updated_at AS updated_at_21,
  t17.jornada_id AS jornada_id_22,
  t17.ranking_id AS ranking_id_23
FROM
  Jornada t0
  LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id
WHERE
  t0.Competicion_id = ?
ORDER BY
  t0.orden ASC

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.orden AS orden_3, t0.created_at AS created_at_4, t0.procesada AS procesada_5, t0.sms_hcp AS sms_hcp_6, t0.asc_valor AS asc_valor_7, t0.clima AS clima_8, t0.zona_bandera AS zona_bandera_9, t0.sensibilidad AS sensibilidad_10, t0.bloqueo AS bloqueo_11, t0.team_livescoring AS team_livescoring_12, t0.scramble_estricto AS scramble_estricto_13, t0.Competicion_id AS Competicion_id_14, t0.Modalidad_id AS Modalidad_id_15, t0.Trazado_id AS Trazado_id_16, t17.id AS id_18, t17.value AS value_19, t17.created_at AS created_at_20, t17.updated_at AS updated_at_21, t17.jornada_id AS jornada_id_22, t17.ranking_id AS ranking_id_23 FROM Jornada t0 LEFT JOIN asc_ranking t17 ON t17.jornada_id = t0.id WHERE t0.Competicion_id = 47170 ORDER BY t0.orden ASC;

SELECT
  t0.id AS id_1,
  t0.sexo AS sexo_2,
  t0.hoyos AS hoyos_3,
  t0.slope AS slope_4,
  t0.campo AS campo_5,
  t0.par AS par_6,
  t0.metros AS metros_7,
  t0.Jornada_id AS Jornada_id_8,
  t0.Barra_id AS Barra_id_9,
  t0.Categoria_id AS Categoria_id_10,
  t0.CatCondicion_id AS CatCondicion_id_11
FROM
  JornadaConfig t0
WHERE
  t0.Jornada_id = ?

SELECT t0.id AS id_1, t0.sexo AS sexo_2, t0.hoyos AS hoyos_3, t0.slope AS slope_4, t0.campo AS campo_5, t0.par AS par_6, t0.metros AS metros_7, t0.Jornada_id AS Jornada_id_8, t0.Barra_id AS Barra_id_9, t0.Categoria_id AS Categoria_id_10, t0.CatCondicion_id AS CatCondicion_id_11 FROM JornadaConfig t0 WHERE t0.Jornada_id = 49113;

SELECT
  r.hoyo AS hole,
  r.bando_id AS sideId
FROM
  Resultado r
  INNER JOIN Bando b ON b.id = r.bando_id
  INNER JOIN Encuentro e ON e.id = b.Encuentro_id
  INNER JOIN Ronda ro ON ro.id = e.Ronda_id
WHERE
  ro.Competicion_id = ?
ORDER BY
  r.created_at DESC,
  r.hoyo DESC

SELECT r.hoyo AS hole, r.bando_id AS sideId
            FROM Resultado r
            INNER JOIN Bando b ON b.id = r.bando_id
            INNER JOIN Encuentro e ON e.id = b.Encuentro_id
            INNER JOIN Ronda ro ON ro.id = e.Ronda_id
            WHERE ro.Competicion_id = 47170
            ORDER BY r.created_at DESC, r.hoyo DESC
        ;

SELECT
  t0.id AS id_1,
  t0.orden AS orden_2,
  t0.inicio AS inicio_3,
  t0.fin AS fin_4,
  t0.Competicion_id AS Competicion_id_5,
  t0.Modalidad_id AS Modalidad_id_6,
  t0.jornada_id AS jornada_id_7
FROM
  Ronda t0
WHERE
  t0.Competicion_id = ?

SELECT t0.id AS id_1, t0.orden AS orden_2, t0.inicio AS inicio_3, t0.fin AS fin_4, t0.Competicion_id AS Competicion_id_5, t0.Modalidad_id AS Modalidad_id_6, t0.jornada_id AS jornada_id_7 FROM Ronda t0 WHERE t0.Competicion_id = 47170;

SELECT
  t0.id AS id_1,
  t0.fecha AS fecha_2,
  t0.clima AS clima_3,
  t0.hora AS hora_4,
  t0.tee AS tee_5,
  t0.orden AS orden_6,
  t0.Trazado_id AS Trazado_id_7,
  t0.Ronda_id AS Ronda_id_8,
  t0.Grupo_id AS Grupo_id_9,
  t0.ganador_id AS ganador_id_10
FROM
  Encuentro t0
WHERE
  t0.Ronda_id = ?

SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.clima AS clima_3, t0.hora AS hora_4, t0.tee AS tee_5, t0.orden AS orden_6, t0.Trazado_id AS Trazado_id_7, t0.Ronda_id AS Ronda_id_8, t0.Grupo_id AS Grupo_id_9, t0.ganador_id AS ganador_id_10 FROM Encuentro t0 WHERE t0.Ronda_id = 24;

SELECT
  t0.id AS id_1,
  t0.resultado AS resultado_2,
  t0.ganador_bando_id AS ganador_bando_id_3,
  t0.encuentro_id AS encuentro_id_4
FROM
  resultado_encuentro t0
WHERE
  t0.encuentro_id = ?

SELECT t0.id AS id_1, t0.resultado AS resultado_2, t0.ganador_bando_id AS ganador_bando_id_3, t0.encuentro_id AS encuentro_id_4 FROM resultado_encuentro t0 WHERE t0.encuentro_id = 161;

SELECT
  t0.id AS id_1,
  t0.equipo AS equipo_2,
  t0.pareja AS pareja_3,
  t0.tarjeta AS tarjeta_4,
  t0.tarjeta_updated_at AS tarjeta_updated_at_5,
  t0.tarjeta_entregada AS tarjeta_entregada_6,
  t0.orden AS orden_7,
  t0.Inscrito_id AS Inscrito_id_8,
  t0.Encuentro_id AS Encuentro_id_9,
  t0.Barra_id AS Barra_id_10,
  t11.id AS id_12,
  t11.resultado AS resultado_13,
  t11.ganador_bando_id AS ganador_bando_id_14,
  t11.encuentro_id AS encuentro_id_15,
  t0.equipo_entidad_id AS equipo_entidad_id_16
FROM
  Bando t0
  LEFT JOIN resultado_encuentro t11 ON t11.ganador_bando_id = t0.id
WHERE
  t0.Encuentro_id = ?

SELECT t0.id AS id_1, t0.equipo AS equipo_2, t0.pareja AS pareja_3, t0.tarjeta AS tarjeta_4, t0.tarjeta_updated_at AS tarjeta_updated_at_5, t0.tarjeta_entregada AS tarjeta_entregada_6, t0.orden AS orden_7, t0.Inscrito_id AS Inscrito_id_8, t0.Encuentro_id AS Encuentro_id_9, t0.Barra_id AS Barra_id_10, t11.id AS id_12, t11.resultado AS resultado_13, t11.ganador_bando_id AS ganador_bando_id_14, t11.encuentro_id AS encuentro_id_15, t0.equipo_entidad_id AS equipo_entidad_id_16 FROM Bando t0 LEFT JOIN resultado_encuentro t11 ON t11.ganador_bando_id = t0.id WHERE t0.Encuentro_id = 161;

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.hcp AS hcp_3,
  t0.scratch AS scratch_4,
  t0.golpes AS golpes_5,
  t0.contrapar_hcp AS contrapar_hcp_6,
  t0.contrapar_scratch AS contrapar_scratch_7,
  t0.stableford_hcp AS stableford_hcp_8,
  t0.stableford_scratch AS stableford_scratch_9,
  t0.hoyo AS hoyo_10,
  t0.equipo AS equipo_11,
  t0.pareja AS pareja_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.golpes_neto AS golpes_neto_15,
  t0.Inscrito_id AS Inscrito_id_16,
  t0.Jornada_id AS Jornada_id_17,
  t0.Especial_id AS Especial_id_18,
  t0.equipo_entidad AS equipo_entidad_19,
  t20.id AS id_21,
  t20.putt AS putt_22,
  t20.fh AS fh_23,
  t20.gir AS gir_24,
  t20.Resultado_id AS Resultado_id_25,
  t0.bando_id AS bando_id_26,
  t27.id AS id_28,
  t27.resultado_value AS resultado_value_29,
  t27.Bando_id AS Bando_id_30,
  t27.resultado_id AS resultado_id_31
FROM
  Resultado t0
  LEFT JOIN TarjetaComplementaria t20 ON t20.Resultado_id = t0.id
  LEFT JOIN ResultadoMatchPlay t27 ON t27.resultado_id = t0.id
WHERE
  t0.bando_id = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.hcp AS hcp_3, t0.scratch AS scratch_4, t0.golpes AS golpes_5, t0.contrapar_hcp AS contrapar_hcp_6, t0.contrapar_scratch AS contrapar_scratch_7, t0.stableford_hcp AS stableford_hcp_8, t0.stableford_scratch AS stableford_scratch_9, t0.hoyo AS hoyo_10, t0.equipo AS equipo_11, t0.pareja AS pareja_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.golpes_neto AS golpes_neto_15, t0.Inscrito_id AS Inscrito_id_16, t0.Jornada_id AS Jornada_id_17, t0.Especial_id AS Especial_id_18, t0.equipo_entidad AS equipo_entidad_19, t20.id AS id_21, t20.putt AS putt_22, t20.fh AS fh_23, t20.gir AS gir_24, t20.Resultado_id AS Resultado_id_25, t0.bando_id AS bando_id_26, t27.id AS id_28, t27.resultado_value AS resultado_value_29, t27.Bando_id AS Bando_id_30, t27.resultado_id AS resultado_id_31 FROM Resultado t0 LEFT JOIN TarjetaComplementaria t20 ON t20.Resultado_id = t0.id LEFT JOIN ResultadoMatchPlay t27 ON t27.resultado_id = t0.id WHERE t0.bando_id = 361;

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.hcp AS hcp_3,
  t0.scratch AS scratch_4,
  t0.golpes AS golpes_5,
  t0.contrapar_hcp AS contrapar_hcp_6,
  t0.contrapar_scratch AS contrapar_scratch_7,
  t0.stableford_hcp AS stableford_hcp_8,
  t0.stableford_scratch AS stableford_scratch_9,
  t0.hoyo AS hoyo_10,
  t0.equipo AS equipo_11,
  t0.pareja AS pareja_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.golpes_neto AS golpes_neto_15,
  t0.Inscrito_id AS Inscrito_id_16,
  t0.Jornada_id AS Jornada_id_17,
  t0.Especial_id AS Especial_id_18,
  t0.equipo_entidad AS equipo_entidad_19,
  t20.id AS id_21,
  t20.putt AS putt_22,
  t20.fh AS fh_23,
  t20.gir AS gir_24,
  t20.Resultado_id AS Resultado_id_25,
  t0.bando_id AS bando_id_26,
  t27.id AS id_28,
  t27.resultado_value AS resultado_value_29,
  t27.Bando_id AS Bando_id_30,
  t27.resultado_id AS resultado_id_31
FROM
  Resultado t0
  LEFT JOIN TarjetaComplementaria t20 ON t20.Resultado_id = t0.id
  LEFT JOIN ResultadoMatchPlay t27 ON t27.resultado_id = t0.id
WHERE
  t0.bando_id = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.hcp AS hcp_3, t0.scratch AS scratch_4, t0.golpes AS golpes_5, t0.contrapar_hcp AS contrapar_hcp_6, t0.contrapar_scratch AS contrapar_scratch_7, t0.stableford_hcp AS stableford_hcp_8, t0.stableford_scratch AS stableford_scratch_9, t0.hoyo AS hoyo_10, t0.equipo AS equipo_11, t0.pareja AS pareja_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.golpes_neto AS golpes_neto_15, t0.Inscrito_id AS Inscrito_id_16, t0.Jornada_id AS Jornada_id_17, t0.Especial_id AS Especial_id_18, t0.equipo_entidad AS equipo_entidad_19, t20.id AS id_21, t20.putt AS putt_22, t20.fh AS fh_23, t20.gir AS gir_24, t20.Resultado_id AS Resultado_id_25, t0.bando_id AS bando_id_26, t27.id AS id_28, t27.resultado_value AS resultado_value_29, t27.Bando_id AS Bando_id_30, t27.resultado_id AS resultado_id_31 FROM Resultado t0 LEFT JOIN TarjetaComplementaria t20 ON t20.Resultado_id = t0.id LEFT JOIN ResultadoMatchPlay t27 ON t27.resultado_id = t0.id WHERE t0.bando_id = 362;

SELECT
  t0.id AS id_1,
  t0.resultado AS resultado_2,
  t0.ganador_bando_id AS ganador_bando_id_3,
  t0.encuentro_id AS encuentro_id_4
FROM
  resultado_encuentro t0
WHERE
  t0.encuentro_id = ?

SELECT t0.id AS id_1, t0.resultado AS resultado_2, t0.ganador_bando_id AS ganador_bando_id_3, t0.encuentro_id AS encuentro_id_4 FROM resultado_encuentro t0 WHERE t0.encuentro_id = 162;

SELECT
  t0.id AS id_1,
  t0.equipo AS equipo_2,
  t0.pareja AS pareja_3,
  t0.tarjeta AS tarjeta_4,
  t0.tarjeta_updated_at AS tarjeta_updated_at_5,
  t0.tarjeta_entregada AS tarjeta_entregada_6,
  t0.orden AS orden_7,
  t0.Inscrito_id AS Inscrito_id_8,
  t0.Encuentro_id AS Encuentro_id_9,
  t0.Barra_id AS Barra_id_10,
  t11.id AS id_12,
  t11.resultado AS resultado_13,
  t11.ganador_bando_id AS ganador_bando_id_14,
  t11.encuentro_id AS encuentro_id_15,
  t0.equipo_entidad_id AS equipo_entidad_id_16
FROM
  Bando t0
  LEFT JOIN resultado_encuentro t11 ON t11.ganador_bando_id = t0.id
WHERE
  t0.Encuentro_id = ?

SELECT t0.id AS id_1, t0.equipo AS equipo_2, t0.pareja AS pareja_3, t0.tarjeta AS tarjeta_4, t0.tarjeta_updated_at AS tarjeta_updated_at_5, t0.tarjeta_entregada AS tarjeta_entregada_6, t0.orden AS orden_7, t0.Inscrito_id AS Inscrito_id_8, t0.Encuentro_id AS Encuentro_id_9, t0.Barra_id AS Barra_id_10, t11.id AS id_12, t11.resultado AS resultado_13, t11.ganador_bando_id AS ganador_bando_id_14, t11.encuentro_id AS encuentro_id_15, t0.equipo_entidad_id AS equipo_entidad_id_16 FROM Bando t0 LEFT JOIN resultado_encuentro t11 ON t11.ganador_bando_id = t0.id WHERE t0.Encuentro_id = 162;

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.hcp AS hcp_3,
  t0.scratch AS scratch_4,
  t0.golpes AS golpes_5,
  t0.contrapar_hcp AS contrapar_hcp_6,
  t0.contrapar_scratch AS contrapar_scratch_7,
  t0.stableford_hcp AS stableford_hcp_8,
  t0.stableford_scratch AS stableford_scratch_9,
  t0.hoyo AS hoyo_10,
  t0.equipo AS equipo_11,
  t0.pareja AS pareja_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.golpes_neto AS golpes_neto_15,
  t0.Inscrito_id AS Inscrito_id_16,
  t0.Jornada_id AS Jornada_id_17,
  t0.Especial_id AS Especial_id_18,
  t0.equipo_entidad AS equipo_entidad_19,
  t20.id AS id_21,
  t20.putt AS putt_22,
  t20.fh AS fh_23,
  t20.gir AS gir_24,
  t20.Resultado_id AS Resultado_id_25,
  t0.bando_id AS bando_id_26,
  t27.id AS id_28,
  t27.resultado_value AS resultado_value_29,
  t27.Bando_id AS Bando_id_30,
  t27.resultado_id AS resultado_id_31
FROM
  Resultado t0
  LEFT JOIN TarjetaComplementaria t20 ON t20.Resultado_id = t0.id
  LEFT JOIN ResultadoMatchPlay t27 ON t27.resultado_id = t0.id
WHERE
  t0.bando_id = ?