Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

11.88 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	11.51 ms	SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.codigo_contable AS codigo_contable_2, c0_.nombre AS nombre_3, c0_.fecha AS fecha_4, c0_.inicio AS inicio_5, c0_.fin AS fin_6, c0_.plazas AS plazas_7, c0_.jugadores AS jugadores_8, c0_.observaciones AS observaciones_9, c0_.observaciones_planificacion AS observaciones_planificacion_10, c0_.aviso AS aviso_11, c0_.informacion AS informacion_12, c0_.rfeg_id AS rfeg_id_13, c0_.cartel AS cartel_14, c0_.horario AS horario_15, c0_.fichero_inscritos AS fichero_inscritos_16, c0_.fichero_clasificaciones AS fichero_clasificaciones_17, c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18, c0_.fichero_banner_schedule AS fichero_banner_schedule_19, c0_.fichero_reglas AS fichero_reglas_20, c0_.fichero_varios_nombre AS fichero_varios_nombre_21, c0_.fichero_varios AS fichero_varios_22, c0_.circular AS circular_23, c0_.nombre_observaciones AS nombre_observaciones_24, c0_.hash AS hash_25, c0_.estado AS estado_26, c0_.estado_corte AS estado_corte_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.tarifa_reglamento AS tarifa_reglamento_30, c0_.redireccion AS redireccion_31, c0_.wagr AS wagr_32, c0_.subvencion_junta AS subvencion_junta_33, c0_.galeria AS galeria_34, c0_.informacion_popup AS informacion_popup_35, c0_.reglas AS reglas_36, c0_.num_competiciones AS num_competiciones_37, c0_.tag_color AS tag_color_38, c0_.show_live_scoring AS show_live_scoring_39, c0_.rfc AS rfc_40, c0_.estricto AS estricto_41, c0_.hcp_estricto AS hcp_estricto_42, c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43, c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44, c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45, c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46, c0_.hcp_juego_masculino AS hcp_juego_masculino_47, c0_.hcp_juego_femenino AS hcp_juego_femenino_48, c0_.hcp_juego_pareja AS hcp_juego_pareja_49, c0_.hcp_juego_equipo AS hcp_juego_equipo_50, c0_.premios AS premios_51, c0_.arbitrable AS arbitrable_52, c0_.direccion_torneos AS direccion_torneos_53, c0_.asistencia_presidente AS asistencia_presidente_54, c0_.institucional AS institucional_55, c0_.voluntarios AS voluntarios_56, c0_.flyer AS flyer_57, c0_.permitir AS permitir_58, c0_.social AS social_59, c0_.visible AS visible_60, c0_.seguimiento AS seguimiento_61, c0_.popup_inscripcion AS popup_inscripcion_62, c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63, c0_.mostrar_sorteo AS mostrar_sorteo_64, c0_.malaga2020 AS malaga2020_65, c0_.lista_espera AS lista_espera_66, c0_.restringir_licencia AS restringir_licencia_67, c0_.seleccion_tarifas AS seleccion_tarifas_68, c0_.permitir_extranjeros AS permitir_extranjeros_69, c0_.plazas_manana AS plazas_manana_70, c0_.plazas_tarde AS plazas_tarde_71, c0_.tarjeta_electronica AS tarjeta_electronica_72, c0_.auto_assign_marker AS auto_assign_marker_73, c0_.livescoring_comunidad AS livescoring_comunidad_74, c0_.plazas_lista_espera AS plazas_lista_espera_75, c0_.deleted_at AS deleted_at_76, c0_.contacto AS contacto_77, c0_.benefico AS benefico_78, c0_.flickr_gallery AS flickr_gallery_79, c0_.barra_salida AS barra_salida_80, c0_.observaciones_frontend AS observaciones_frontend_81, c0_.mostrar_plazas AS mostrar_plazas_82, c0_.politica_inicio AS politica_inicio_83, c0_.politica_entrega AS politica_entrega_84, c0_.short_url AS short_url_85, c0_.privada AS privada_86, c0_.camera_url AS camera_url_87, c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88, c0_.liquidation_date AS liquidation_date_89, c0_.collection_date AS collection_date_90, c0_.livescoring_policy AS livescoring_policy_91, c0_.livescoring_formula AS livescoring_formula_92, c0_.show_events AS show_events_93, c0_.destacada AS destacada_94, c0_.Formula_id AS Formula_id_95, c0_.Modo_id AS Modo_id_96, c0_.Calculo_id AS Calculo_id_97, c0_.Club_id AS Club_id_98, c0_.Organizador_id AS Organizador_id_99, c0_.Criterio_id AS Criterio_id_100, c0_.Criterio2_id AS Criterio2_id_101 FROM Competicion c0_ INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id WHERE (((c0_.Modo_id = 3 AND '2025-12-11' <= c0_.fin OR c0_.Modo_id = 5)) AND c0_.estado IN ('abierta', 'congelada') AND c0_.visible = 1 AND c1_.Cliente_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.codigo_contable AS codigo_contable_2, c0_.nombre AS nombre_3, c0_.fecha AS fecha_4, c0_.inicio AS inicio_5, c0_.fin AS fin_6, c0_.plazas AS plazas_7, c0_.jugadores AS jugadores_8, c0_.observaciones AS observaciones_9, c0_.observaciones_planificacion AS observaciones_planificacion_10, c0_.aviso AS aviso_11, c0_.informacion AS informacion_12, c0_.rfeg_id AS rfeg_id_13, c0_.cartel AS cartel_14, c0_.horario AS horario_15, c0_.fichero_inscritos AS fichero_inscritos_16, c0_.fichero_clasificaciones AS fichero_clasificaciones_17, c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18, c0_.fichero_banner_schedule AS fichero_banner_schedule_19, c0_.fichero_reglas AS fichero_reglas_20, c0_.fichero_varios_nombre AS fichero_varios_nombre_21, c0_.fichero_varios AS fichero_varios_22, c0_.circular AS circular_23, c0_.nombre_observaciones AS nombre_observaciones_24, c0_.hash AS hash_25, c0_.estado AS estado_26, c0_.estado_corte AS estado_corte_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.tarifa_reglamento AS tarifa_reglamento_30, c0_.redireccion AS redireccion_31, c0_.wagr AS wagr_32, c0_.subvencion_junta AS subvencion_junta_33, c0_.galeria AS galeria_34, c0_.informacion_popup AS informacion_popup_35, c0_.reglas AS reglas_36, c0_.num_competiciones AS num_competiciones_37, c0_.tag_color AS tag_color_38, c0_.show_live_scoring AS show_live_scoring_39, c0_.rfc AS rfc_40, c0_.estricto AS estricto_41, c0_.hcp_estricto AS hcp_estricto_42, c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43, c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44, c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45, c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46, c0_.hcp_juego_masculino AS hcp_juego_masculino_47, c0_.hcp_juego_femenino AS hcp_juego_femenino_48, c0_.hcp_juego_pareja AS hcp_juego_pareja_49, c0_.hcp_juego_equipo AS hcp_juego_equipo_50, c0_.premios AS premios_51, c0_.arbitrable AS arbitrable_52, c0_.direccion_torneos AS direccion_torneos_53, c0_.asistencia_presidente AS asistencia_presidente_54, c0_.institucional AS institucional_55, c0_.voluntarios AS voluntarios_56, c0_.flyer AS flyer_57, c0_.permitir AS permitir_58, c0_.social AS social_59, c0_.visible AS visible_60, c0_.seguimiento AS seguimiento_61, c0_.popup_inscripcion AS popup_inscripcion_62, c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63, c0_.mostrar_sorteo AS mostrar_sorteo_64, c0_.malaga2020 AS malaga2020_65, c0_.lista_espera AS lista_espera_66, c0_.restringir_licencia AS restringir_licencia_67, c0_.seleccion_tarifas AS seleccion_tarifas_68, c0_.permitir_extranjeros AS permitir_extranjeros_69, c0_.plazas_manana AS plazas_manana_70, c0_.plazas_tarde AS plazas_tarde_71, c0_.tarjeta_electronica AS tarjeta_electronica_72, c0_.auto_assign_marker AS auto_assign_marker_73, c0_.livescoring_comunidad AS livescoring_comunidad_74, c0_.plazas_lista_espera AS plazas_lista_espera_75, c0_.deleted_at AS deleted_at_76, c0_.contacto AS contacto_77, c0_.benefico AS benefico_78, c0_.flickr_gallery AS flickr_gallery_79, c0_.barra_salida AS barra_salida_80, c0_.observaciones_frontend AS observaciones_frontend_81, c0_.mostrar_plazas AS mostrar_plazas_82, c0_.politica_inicio AS politica_inicio_83, c0_.politica_entrega AS politica_entrega_84, c0_.short_url AS short_url_85, c0_.privada AS privada_86, c0_.camera_url AS camera_url_87, c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88, c0_.liquidation_date AS liquidation_date_89, c0_.collection_date AS collection_date_90, c0_.livescoring_policy AS livescoring_policy_91, c0_.livescoring_formula AS livescoring_formula_92, c0_.show_events AS show_events_93, c0_.destacada AS destacada_94, c0_.Formula_id AS Formula_id_95, c0_.Modo_id AS Modo_id_96, c0_.Calculo_id AS Calculo_id_97, c0_.Club_id AS Club_id_98, c0_.Organizador_id AS Organizador_id_99, c0_.Criterio_id AS Criterio_id_100, c0_.Criterio2_id AS Criterio2_id_101 FROM Competicion c0_ INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id WHERE ( ( ( c0_.Modo_id = 3 AND '2025-12-11' <= c0_.fin OR c0_.Modo_id = 5 ) ) AND c0_.estado IN ('abierta', 'congelada') AND c0_.visible = 1 AND c1_.Cliente_id = ? ) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.codigo_contable AS codigo_contable_2, c0_.nombre AS nombre_3, c0_.fecha AS fecha_4, c0_.inicio AS inicio_5, c0_.fin AS fin_6, c0_.plazas AS plazas_7, c0_.jugadores AS jugadores_8, c0_.observaciones AS observaciones_9, c0_.observaciones_planificacion AS observaciones_planificacion_10, c0_.aviso AS aviso_11, c0_.informacion AS informacion_12, c0_.rfeg_id AS rfeg_id_13, c0_.cartel AS cartel_14, c0_.horario AS horario_15, c0_.fichero_inscritos AS fichero_inscritos_16, c0_.fichero_clasificaciones AS fichero_clasificaciones_17, c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18, c0_.fichero_banner_schedule AS fichero_banner_schedule_19, c0_.fichero_reglas AS fichero_reglas_20, c0_.fichero_varios_nombre AS fichero_varios_nombre_21, c0_.fichero_varios AS fichero_varios_22, c0_.circular AS circular_23, c0_.nombre_observaciones AS nombre_observaciones_24, c0_.hash AS hash_25, c0_.estado AS estado_26, c0_.estado_corte AS estado_corte_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.tarifa_reglamento AS tarifa_reglamento_30, c0_.redireccion AS redireccion_31, c0_.wagr AS wagr_32, c0_.subvencion_junta AS subvencion_junta_33, c0_.galeria AS galeria_34, c0_.informacion_popup AS informacion_popup_35, c0_.reglas AS reglas_36, c0_.num_competiciones AS num_competiciones_37, c0_.tag_color AS tag_color_38, c0_.show_live_scoring AS show_live_scoring_39, c0_.rfc AS rfc_40, c0_.estricto AS estricto_41, c0_.hcp_estricto AS hcp_estricto_42, c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43, c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44, c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45, c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46, c0_.hcp_juego_masculino AS hcp_juego_masculino_47, c0_.hcp_juego_femenino AS hcp_juego_femenino_48, c0_.hcp_juego_pareja AS hcp_juego_pareja_49, c0_.hcp_juego_equipo AS hcp_juego_equipo_50, c0_.premios AS premios_51, c0_.arbitrable AS arbitrable_52, c0_.direccion_torneos AS direccion_torneos_53, c0_.asistencia_presidente AS asistencia_presidente_54, c0_.institucional AS institucional_55, c0_.voluntarios AS voluntarios_56, c0_.flyer AS flyer_57, c0_.permitir AS permitir_58, c0_.social AS social_59, c0_.visible AS visible_60, c0_.seguimiento AS seguimiento_61, c0_.popup_inscripcion AS popup_inscripcion_62, c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63, c0_.mostrar_sorteo AS mostrar_sorteo_64, c0_.malaga2020 AS malaga2020_65, c0_.lista_espera AS lista_espera_66, c0_.restringir_licencia AS restringir_licencia_67, c0_.seleccion_tarifas AS seleccion_tarifas_68, c0_.permitir_extranjeros AS permitir_extranjeros_69, c0_.plazas_manana AS plazas_manana_70, c0_.plazas_tarde AS plazas_tarde_71, c0_.tarjeta_electronica AS tarjeta_electronica_72, c0_.auto_assign_marker AS auto_assign_marker_73, c0_.livescoring_comunidad AS livescoring_comunidad_74, c0_.plazas_lista_espera AS plazas_lista_espera_75, c0_.deleted_at AS deleted_at_76, c0_.contacto AS contacto_77, c0_.benefico AS benefico_78, c0_.flickr_gallery AS flickr_gallery_79, c0_.barra_salida AS barra_salida_80, c0_.observaciones_frontend AS observaciones_frontend_81, c0_.mostrar_plazas AS mostrar_plazas_82, c0_.politica_inicio AS politica_inicio_83, c0_.politica_entrega AS politica_entrega_84, c0_.short_url AS short_url_85, c0_.privada AS privada_86, c0_.camera_url AS camera_url_87, c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88, c0_.liquidation_date AS liquidation_date_89, c0_.collection_date AS collection_date_90, c0_.livescoring_policy AS livescoring_policy_91, c0_.livescoring_formula AS livescoring_formula_92, c0_.show_events AS show_events_93, c0_.destacada AS destacada_94, c0_.Formula_id AS Formula_id_95, c0_.Modo_id AS Modo_id_96, c0_.Calculo_id AS Calculo_id_97, c0_.Club_id AS Club_id_98, c0_.Organizador_id AS Organizador_id_99, c0_.Criterio_id AS Criterio_id_100, c0_.Criterio2_id AS Criterio2_id_101 FROM Competicion c0_ INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id WHERE (((c0_.Modo_id = 3 AND '2025-12-11' <= c0_.fin OR c0_.Modo_id = 5)) AND c0_.estado IN ('abierta', 'congelada') AND c0_.visible = 1 AND c1_.Cliente_id = '3') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC;
2	0.37 ms	SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = '3';

#▲

Time

Info

11.51 ms

SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.codigo_contable AS codigo_contable_2, c0_.nombre AS nombre_3, c0_.fecha AS fecha_4, c0_.inicio AS inicio_5, c0_.fin AS fin_6, c0_.plazas AS plazas_7, c0_.jugadores AS jugadores_8, c0_.observaciones AS observaciones_9, c0_.observaciones_planificacion AS observaciones_planificacion_10, c0_.aviso AS aviso_11, c0_.informacion AS informacion_12, c0_.rfeg_id AS rfeg_id_13, c0_.cartel AS cartel_14, c0_.horario AS horario_15, c0_.fichero_inscritos AS fichero_inscritos_16, c0_.fichero_clasificaciones AS fichero_clasificaciones_17, c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18, c0_.fichero_banner_schedule AS fichero_banner_schedule_19, c0_.fichero_reglas AS fichero_reglas_20, c0_.fichero_varios_nombre AS fichero_varios_nombre_21, c0_.fichero_varios AS fichero_varios_22, c0_.circular AS circular_23, c0_.nombre_observaciones AS nombre_observaciones_24, c0_.hash AS hash_25, c0_.estado AS estado_26, c0_.estado_corte AS estado_corte_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.tarifa_reglamento AS tarifa_reglamento_30, c0_.redireccion AS redireccion_31, c0_.wagr AS wagr_32, c0_.subvencion_junta AS subvencion_junta_33, c0_.galeria AS galeria_34, c0_.informacion_popup AS informacion_popup_35, c0_.reglas AS reglas_36, c0_.num_competiciones AS num_competiciones_37, c0_.tag_color AS tag_color_38, c0_.show_live_scoring AS show_live_scoring_39, c0_.rfc AS rfc_40, c0_.estricto AS estricto_41, c0_.hcp_estricto AS hcp_estricto_42, c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43, c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44, c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45, c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46, c0_.hcp_juego_masculino AS hcp_juego_masculino_47, c0_.hcp_juego_femenino AS hcp_juego_femenino_48, c0_.hcp_juego_pareja AS hcp_juego_pareja_49, c0_.hcp_juego_equipo AS hcp_juego_equipo_50, c0_.premios AS premios_51, c0_.arbitrable AS arbitrable_52, c0_.direccion_torneos AS direccion_torneos_53, c0_.asistencia_presidente AS asistencia_presidente_54, c0_.institucional AS institucional_55, c0_.voluntarios AS voluntarios_56, c0_.flyer AS flyer_57, c0_.permitir AS permitir_58, c0_.social AS social_59, c0_.visible AS visible_60, c0_.seguimiento AS seguimiento_61, c0_.popup_inscripcion AS popup_inscripcion_62, c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63, c0_.mostrar_sorteo AS mostrar_sorteo_64, c0_.malaga2020 AS malaga2020_65, c0_.lista_espera AS lista_espera_66, c0_.restringir_licencia AS restringir_licencia_67, c0_.seleccion_tarifas AS seleccion_tarifas_68, c0_.permitir_extranjeros AS permitir_extranjeros_69, c0_.plazas_manana AS plazas_manana_70, c0_.plazas_tarde AS plazas_tarde_71, c0_.tarjeta_electronica AS tarjeta_electronica_72, c0_.auto_assign_marker AS auto_assign_marker_73, c0_.livescoring_comunidad AS livescoring_comunidad_74, c0_.plazas_lista_espera AS plazas_lista_espera_75, c0_.deleted_at AS deleted_at_76, c0_.contacto AS contacto_77, c0_.benefico AS benefico_78, c0_.flickr_gallery AS flickr_gallery_79, c0_.barra_salida AS barra_salida_80, c0_.observaciones_frontend AS observaciones_frontend_81, c0_.mostrar_plazas AS mostrar_plazas_82, c0_.politica_inicio AS politica_inicio_83, c0_.politica_entrega AS politica_entrega_84, c0_.short_url AS short_url_85, c0_.privada AS privada_86, c0_.camera_url AS camera_url_87, c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88, c0_.liquidation_date AS liquidation_date_89, c0_.collection_date AS collection_date_90, c0_.livescoring_policy AS livescoring_policy_91, c0_.livescoring_formula AS livescoring_formula_92, c0_.show_events AS show_events_93, c0_.destacada AS destacada_94, c0_.Formula_id AS Formula_id_95, c0_.Modo_id AS Modo_id_96, c0_.Calculo_id AS Calculo_id_97, c0_.Club_id AS Club_id_98, c0_.Organizador_id AS Organizador_id_99, c0_.Criterio_id AS Criterio_id_100, c0_.Criterio2_id AS Criterio2_id_101 FROM Competicion c0_ INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id WHERE (((c0_.Modo_id = 3 AND '2025-12-11' <= c0_.fin OR c0_.Modo_id = 5)) AND c0_.estado IN ('abierta', 'congelada') AND c0_.visible = 1 AND c1_.Cliente_id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.codigo AS codigo_1,
  c0_.codigo_contable AS codigo_contable_2,
  c0_.nombre AS nombre_3,
  c0_.fecha AS fecha_4,
  c0_.inicio AS inicio_5,
  c0_.fin AS fin_6,
  c0_.plazas AS plazas_7,
  c0_.jugadores AS jugadores_8,
  c0_.observaciones AS observaciones_9,
  c0_.observaciones_planificacion AS observaciones_planificacion_10,
  c0_.aviso AS aviso_11,
  c0_.informacion AS informacion_12,
  c0_.rfeg_id AS rfeg_id_13,
  c0_.cartel AS cartel_14,
  c0_.horario AS horario_15,
  c0_.fichero_inscritos AS fichero_inscritos_16,
  c0_.fichero_clasificaciones AS fichero_clasificaciones_17,
  c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18,
  c0_.fichero_banner_schedule AS fichero_banner_schedule_19,
  c0_.fichero_reglas AS fichero_reglas_20,
  c0_.fichero_varios_nombre AS fichero_varios_nombre_21,
  c0_.fichero_varios AS fichero_varios_22,
  c0_.circular AS circular_23,
  c0_.nombre_observaciones AS nombre_observaciones_24,
  c0_.hash AS hash_25,
  c0_.estado AS estado_26,
  c0_.estado_corte AS estado_corte_27,
  c0_.created_at AS created_at_28,
  c0_.updated_at AS updated_at_29,
  c0_.tarifa_reglamento AS tarifa_reglamento_30,
  c0_.redireccion AS redireccion_31,
  c0_.wagr AS wagr_32,
  c0_.subvencion_junta AS subvencion_junta_33,
  c0_.galeria AS galeria_34,
  c0_.informacion_popup AS informacion_popup_35,
  c0_.reglas AS reglas_36,
  c0_.num_competiciones AS num_competiciones_37,
  c0_.tag_color AS tag_color_38,
  c0_.show_live_scoring AS show_live_scoring_39,
  c0_.rfc AS rfc_40,
  c0_.estricto AS estricto_41,
  c0_.hcp_estricto AS hcp_estricto_42,
  c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43,
  c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44,
  c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45,
  c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46,
  c0_.hcp_juego_masculino AS hcp_juego_masculino_47,
  c0_.hcp_juego_femenino AS hcp_juego_femenino_48,
  c0_.hcp_juego_pareja AS hcp_juego_pareja_49,
  c0_.hcp_juego_equipo AS hcp_juego_equipo_50,
  c0_.premios AS premios_51,
  c0_.arbitrable AS arbitrable_52,
  c0_.direccion_torneos AS direccion_torneos_53,
  c0_.asistencia_presidente AS asistencia_presidente_54,
  c0_.institucional AS institucional_55,
  c0_.voluntarios AS voluntarios_56,
  c0_.flyer AS flyer_57,
  c0_.permitir AS permitir_58,
  c0_.social AS social_59,
  c0_.visible AS visible_60,
  c0_.seguimiento AS seguimiento_61,
  c0_.popup_inscripcion AS popup_inscripcion_62,
  c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63,
  c0_.mostrar_sorteo AS mostrar_sorteo_64,
  c0_.malaga2020 AS malaga2020_65,
  c0_.lista_espera AS lista_espera_66,
  c0_.restringir_licencia AS restringir_licencia_67,
  c0_.seleccion_tarifas AS seleccion_tarifas_68,
  c0_.permitir_extranjeros AS permitir_extranjeros_69,
  c0_.plazas_manana AS plazas_manana_70,
  c0_.plazas_tarde AS plazas_tarde_71,
  c0_.tarjeta_electronica AS tarjeta_electronica_72,
  c0_.auto_assign_marker AS auto_assign_marker_73,
  c0_.livescoring_comunidad AS livescoring_comunidad_74,
  c0_.plazas_lista_espera AS plazas_lista_espera_75,
  c0_.deleted_at AS deleted_at_76,
  c0_.contacto AS contacto_77,
  c0_.benefico AS benefico_78,
  c0_.flickr_gallery AS flickr_gallery_79,
  c0_.barra_salida AS barra_salida_80,
  c0_.observaciones_frontend AS observaciones_frontend_81,
  c0_.mostrar_plazas AS mostrar_plazas_82,
  c0_.politica_inicio AS politica_inicio_83,
  c0_.politica_entrega AS politica_entrega_84,
  c0_.short_url AS short_url_85,
  c0_.privada AS privada_86,
  c0_.camera_url AS camera_url_87,
  c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88,
  c0_.liquidation_date AS liquidation_date_89,
  c0_.collection_date AS collection_date_90,
  c0_.livescoring_policy AS livescoring_policy_91,
  c0_.livescoring_formula AS livescoring_formula_92,
  c0_.show_events AS show_events_93,
  c0_.destacada AS destacada_94,
  c0_.Formula_id AS Formula_id_95,
  c0_.Modo_id AS Modo_id_96,
  c0_.Calculo_id AS Calculo_id_97,
  c0_.Club_id AS Club_id_98,
  c0_.Organizador_id AS Organizador_id_99,
  c0_.Criterio_id AS Criterio_id_100,
  c0_.Criterio2_id AS Criterio2_id_101
FROM
  Competicion c0_
  INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id
WHERE
  (
    (
      (
        c0_.Modo_id = 3
        AND '2025-12-11' <= c0_.fin
        OR c0_.Modo_id = 5
      )
    )
    AND c0_.estado IN ('abierta', 'congelada')
    AND c0_.visible = 1
    AND c1_.Cliente_id = ?
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.fecha ASC

SELECT c0_.id AS id_0, c0_.codigo AS codigo_1, c0_.codigo_contable AS codigo_contable_2, c0_.nombre AS nombre_3, c0_.fecha AS fecha_4, c0_.inicio AS inicio_5, c0_.fin AS fin_6, c0_.plazas AS plazas_7, c0_.jugadores AS jugadores_8, c0_.observaciones AS observaciones_9, c0_.observaciones_planificacion AS observaciones_planificacion_10, c0_.aviso AS aviso_11, c0_.informacion AS informacion_12, c0_.rfeg_id AS rfeg_id_13, c0_.cartel AS cartel_14, c0_.horario AS horario_15, c0_.fichero_inscritos AS fichero_inscritos_16, c0_.fichero_clasificaciones AS fichero_clasificaciones_17, c0_.fichero_localeRulePdf AS fichero_localeRulePdf_18, c0_.fichero_banner_schedule AS fichero_banner_schedule_19, c0_.fichero_reglas AS fichero_reglas_20, c0_.fichero_varios_nombre AS fichero_varios_nombre_21, c0_.fichero_varios AS fichero_varios_22, c0_.circular AS circular_23, c0_.nombre_observaciones AS nombre_observaciones_24, c0_.hash AS hash_25, c0_.estado AS estado_26, c0_.estado_corte AS estado_corte_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.tarifa_reglamento AS tarifa_reglamento_30, c0_.redireccion AS redireccion_31, c0_.wagr AS wagr_32, c0_.subvencion_junta AS subvencion_junta_33, c0_.galeria AS galeria_34, c0_.informacion_popup AS informacion_popup_35, c0_.reglas AS reglas_36, c0_.num_competiciones AS num_competiciones_37, c0_.tag_color AS tag_color_38, c0_.show_live_scoring AS show_live_scoring_39, c0_.rfc AS rfc_40, c0_.estricto AS estricto_41, c0_.hcp_estricto AS hcp_estricto_42, c0_.hcp_inscrito_masculino AS hcp_inscrito_masculino_43, c0_.hcp_inscrito_masculino_min AS hcp_inscrito_masculino_min_44, c0_.hcp_inscrito_femenino AS hcp_inscrito_femenino_45, c0_.hcp_inscrito_femenino_min AS hcp_inscrito_femenino_min_46, c0_.hcp_juego_masculino AS hcp_juego_masculino_47, c0_.hcp_juego_femenino AS hcp_juego_femenino_48, c0_.hcp_juego_pareja AS hcp_juego_pareja_49, c0_.hcp_juego_equipo AS hcp_juego_equipo_50, c0_.premios AS premios_51, c0_.arbitrable AS arbitrable_52, c0_.direccion_torneos AS direccion_torneos_53, c0_.asistencia_presidente AS asistencia_presidente_54, c0_.institucional AS institucional_55, c0_.voluntarios AS voluntarios_56, c0_.flyer AS flyer_57, c0_.permitir AS permitir_58, c0_.social AS social_59, c0_.visible AS visible_60, c0_.seguimiento AS seguimiento_61, c0_.popup_inscripcion AS popup_inscripcion_62, c0_.popup_inscripcion_texto AS popup_inscripcion_texto_63, c0_.mostrar_sorteo AS mostrar_sorteo_64, c0_.malaga2020 AS malaga2020_65, c0_.lista_espera AS lista_espera_66, c0_.restringir_licencia AS restringir_licencia_67, c0_.seleccion_tarifas AS seleccion_tarifas_68, c0_.permitir_extranjeros AS permitir_extranjeros_69, c0_.plazas_manana AS plazas_manana_70, c0_.plazas_tarde AS plazas_tarde_71, c0_.tarjeta_electronica AS tarjeta_electronica_72, c0_.auto_assign_marker AS auto_assign_marker_73, c0_.livescoring_comunidad AS livescoring_comunidad_74, c0_.plazas_lista_espera AS plazas_lista_espera_75, c0_.deleted_at AS deleted_at_76, c0_.contacto AS contacto_77, c0_.benefico AS benefico_78, c0_.flickr_gallery AS flickr_gallery_79, c0_.barra_salida AS barra_salida_80, c0_.observaciones_frontend AS observaciones_frontend_81, c0_.mostrar_plazas AS mostrar_plazas_82, c0_.politica_inicio AS politica_inicio_83, c0_.politica_entrega AS politica_entrega_84, c0_.short_url AS short_url_85, c0_.privada AS privada_86, c0_.camera_url AS camera_url_87, c0_.tipo_configuracion_matchplay AS tipo_configuracion_matchplay_88, c0_.liquidation_date AS liquidation_date_89, c0_.collection_date AS collection_date_90, c0_.livescoring_policy AS livescoring_policy_91, c0_.livescoring_formula AS livescoring_formula_92, c0_.show_events AS show_events_93, c0_.destacada AS destacada_94, c0_.Formula_id AS Formula_id_95, c0_.Modo_id AS Modo_id_96, c0_.Calculo_id AS Calculo_id_97, c0_.Club_id AS Club_id_98, c0_.Organizador_id AS Organizador_id_99, c0_.Criterio_id AS Criterio_id_100, c0_.Criterio2_id AS Criterio2_id_101 FROM Competicion c0_ INNER JOIN Club c1_ ON c0_.Organizador_id = c1_.id WHERE (((c0_.Modo_id = 3 AND '2025-12-11' <= c0_.fin OR c0_.Modo_id = 5)) AND c0_.estado IN ('abierta', 'congelada') AND c0_.visible = 1 AND c1_.Cliente_id = '3') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC;

0.37 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = ?

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nombre_corto AS nombre_corto_3,
  t0.url_privacidad AS url_privacidad_4,
  t0.cif AS cif_5,
  t0.prioridad AS prioridad_6,
  t0.iban AS iban_7,
  t0.comision AS comision_8,
  t0.minimo_competicion AS minimo_competicion_9,
  t0.minimo_inscripcion AS minimo_inscripcion_10,
  t0.comision_devolucion AS comision_devolucion_11,
  t0.comision_cancelacion AS comision_cancelacion_12,
  t0.comision_sustitucion AS comision_sustitucion_13,
  t0.letra_facturacion AS letra_facturacion_14,
  t0.habilitado_contabilidad AS habilitado_contabilidad_15,
  t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16,
  t0.limite_devoluciones AS limite_devoluciones_17,
  t0.cod_cliente AS cod_cliente_18,
  t0.razon_social AS razon_social_19,
  t0.direccion_facturacion AS direccion_facturacion_20,
  t0.politica_entrega AS politica_entrega_21,
  t0.politica_inicio AS politica_inicio_22,
  t0.tipo AS tipo_23,
  t24.id AS id_25,
  t24.nombre AS nombre_26,
  t24.Cliente_id AS Cliente_id_27,
  t24.Region_id AS Region_id_28
FROM
  Cliente t0
  LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_corto AS nombre_corto_3, t0.url_privacidad AS url_privacidad_4, t0.cif AS cif_5, t0.prioridad AS prioridad_6, t0.iban AS iban_7, t0.comision AS comision_8, t0.minimo_competicion AS minimo_competicion_9, t0.minimo_inscripcion AS minimo_inscripcion_10, t0.comision_devolucion AS comision_devolucion_11, t0.comision_cancelacion AS comision_cancelacion_12, t0.comision_sustitucion AS comision_sustitucion_13, t0.letra_facturacion AS letra_facturacion_14, t0.habilitado_contabilidad AS habilitado_contabilidad_15, t0.comision_devolucion_alternativa AS comision_devolucion_alternativa_16, t0.limite_devoluciones AS limite_devoluciones_17, t0.cod_cliente AS cod_cliente_18, t0.razon_social AS razon_social_19, t0.direccion_facturacion AS direccion_facturacion_20, t0.politica_entrega AS politica_entrega_21, t0.politica_inicio AS politica_inicio_22, t0.tipo AS tipo_23, t24.id AS id_25, t24.nombre AS nombre_26, t24.Cliente_id AS Cliente_id_27, t24.Region_id AS Region_id_28 FROM Cliente t0 LEFT JOIN Federacion t24 ON t24.Cliente_id = t0.id WHERE t0.id = '3';

Database Connections

Name	Service
default	doctrine.dbal.default_connection
encrypt	doctrine.dbal.encrypt_connection
nodoql	doctrine.dbal.nodoql_connection
copy_to_check	doctrine.dbal.copy_to_check_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
encrypt	doctrine.orm.encrypt_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Backend\Competicion	The mappings App\Entity\Backend\Competicion#competitionSectionHidden and App\Entity\Backend\CompetitionSectionHidden#competition are inconsistent with each other.
App\Entity\Backend\Club	No errors.
App\Entity\Backend\Destacada	No errors.
App\Entity\Backend\Formula	No errors.
App\Entity\Backend\Modo	No errors.
App\Entity\Backend\Calculo	No errors.
App\Entity\Backend\Criterio	No errors.
App\Entity\Backend\Cliente	No errors.
App\Entity\Backend\Federacion	No errors.
App\Entity\Backend\Comunidad	No errors.
App\Entity\Backend\ExternalCompetition	No errors.
App\Entity\Backend\Sede	No errors.

encrypt entity manager

No loaded entities.