Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.89 ms Query time

3 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.42 ms	SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = ? Parameters: [`"AM16"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = 'AM16';
2	1.47 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_ WHERE (c0_.fecha >= ? AND c0_.fecha <= ? AND ((c0_.Organizador_id = ? OR c0_.Club_id = ?)) AND c0_.visible = 1 AND c0_.rfc = 0) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC Parameters: [`"2025-01-01" "2025-12-31" "AM16" "AM16"`] 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_ WHERE ( c0_.fecha >= ? AND c0_.fecha <= ? AND ( ( c0_.Organizador_id = ? OR c0_.Club_id = ? ) ) AND c0_.visible = 1 AND c0_.rfc = 0 ) 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_ WHERE (c0_.fecha >= '2025-01-01' AND c0_.fecha <= '2025-12-31' AND ((c0_.Organizador_id = 'AM16' OR c0_.Club_id = 'AM16')) AND c0_.visible = 1 AND c0_.rfc = 0) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC;

#▲

Time

Info

0.42 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = ?

Parameters:

[
  "AM16"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nombre_canonical AS nombre_canonical_3,
  t0.created_at AS created_at_4,
  t0.nombre_corto AS nombre_corto_5,
  t0.direccion AS direccion_6,
  t0.telefono AS telefono_7,
  t0.web AS web_8,
  t0.rfeg_id AS rfeg_id_9,
  t0.intervalo_facturacion AS intervalo_facturacion_10,
  t0.minimo_factura AS minimo_factura_11,
  t0.latitud AS latitud_12,
  t0.longitud AS longitud_13,
  t0.habilitado AS habilitado_14,
  t0.graphql_enabled AS graphql_enabled_15,
  t0.graphql_key AS graphql_key_16,
  t0.graphql_signature AS graphql_signature_17,
  t0.visible AS visible_18,
  t0.allowTpv AS allowTpv_19,
  t0.externalId AS externalId_20,
  t0.rfc_seguro AS rfc_seguro_21,
  t0.flickr_gallery AS flickr_gallery_22,
  t0.livescoring_policy AS livescoring_policy_23,
  t0.localidad_id AS localidad_id_24,
  t0.User_id AS User_id_25,
  t0.Cliente_id AS Cliente_id_26,
  t0.timezone_id AS timezone_id_27
FROM
  Club t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_canonical AS nombre_canonical_3, t0.created_at AS created_at_4, t0.nombre_corto AS nombre_corto_5, t0.direccion AS direccion_6, t0.telefono AS telefono_7, t0.web AS web_8, t0.rfeg_id AS rfeg_id_9, t0.intervalo_facturacion AS intervalo_facturacion_10, t0.minimo_factura AS minimo_factura_11, t0.latitud AS latitud_12, t0.longitud AS longitud_13, t0.habilitado AS habilitado_14, t0.graphql_enabled AS graphql_enabled_15, t0.graphql_key AS graphql_key_16, t0.graphql_signature AS graphql_signature_17, t0.visible AS visible_18, t0.allowTpv AS allowTpv_19, t0.externalId AS externalId_20, t0.rfc_seguro AS rfc_seguro_21, t0.flickr_gallery AS flickr_gallery_22, t0.livescoring_policy AS livescoring_policy_23, t0.localidad_id AS localidad_id_24, t0.User_id AS User_id_25, t0.Cliente_id AS Cliente_id_26, t0.timezone_id AS timezone_id_27 FROM Club t0 WHERE t0.id = 'AM16';

1.47 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_ WHERE (c0_.fecha >= ? AND c0_.fecha <= ? AND ((c0_.Organizador_id = ? OR c0_.Club_id = ?)) AND c0_.visible = 1 AND c0_.rfc = 0) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC

Parameters:

[
  "2025-01-01"
  "2025-12-31"
  "AM16"
  "AM16"
]

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_
WHERE
  (
    c0_.fecha >= ?
    AND c0_.fecha <= ?
    AND (
      (
        c0_.Organizador_id = ?
        OR c0_.Club_id = ?
      )
    )
    AND c0_.visible = 1
    AND c0_.rfc = 0
  )
  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_ WHERE (c0_.fecha >= '2025-01-01' AND c0_.fecha <= '2025-12-31' AND ((c0_.Organizador_id = 'AM16' OR c0_.Club_id = 'AM16')) AND c0_.visible = 1 AND c0_.rfc = 0) AND (c0_.deleted_at IS NULL) ORDER BY c0_.fecha ASC;

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\Club	No errors.
App\Entity\Backend\Localidad	The field App\Entity\Backend\Localidad#clubes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Backend\Club#localidad does not contain the required 'inversedBy="clubes"' attribute.
App\Entity\User\User	No errors.
App\Entity\Backend\Cliente	No errors.
App\Entity\Backend\Timezone	No 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\Socio	No errors.
App\Entity\Backend\Empleado	No errors.
App\Entity\Backend\Federacion	No errors.
App\Entity\Backend\Voucher	No errors.
App\Entity\Gestion\Ranking	The association App\Entity\Gestion\Ranking#ranking_point_position_template refers to the inverse side field App\Entity\Backend\RankingPointPositionTemplate#rankings which does not exist.
App\Entity\Backend\RankingPointPositionTemplate	No errors.
App\Entity\Backend\ExternalCompetition	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.

encrypt entity manager

No loaded entities.