Symfony Profiler

SELECT
  MAX(c0_.id) AS sclr_0
FROM
  Competicion c0_
WHERE
  (c0_.deleted_at IS NULL)

SELECT MAX(c0_.id) AS sclr_0 FROM Competicion c0_ WHERE (c0_.deleted_at IS NULL);

SELECT
  CAST(
    MAX(id) -496781 AS SIGNED
  ) AS resultado
FROM
  Inscrito

SELECT CAST(MAX(id) - 496781 AS SIGNED) AS resultado FROM Inscrito;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c1_.nombre AS nombre_2,
  DATE_FORMAT(c0_.fecha, '%Y-%m-%dT%H:%i:%s') AS sclr_3,
  DATE_FORMAT(c0_.fin, '%Y-%m-%dT%H:%i:%s') AS sclr_4,
  c0_.plazas AS plazas_5,
  c0_.lista_espera AS lista_espera_6
FROM
  Competicion c0_
  INNER JOIN Club c2_ ON (c2_.id = c0_.Organizador_id)
  INNER JOIN Club c1_ ON (c1_.id = c0_.Club_id)
  INNER JOIN Modo m3_ ON (m3_.id = c0_.Modo_id)
WHERE
  (
    c0_.estado = 'abierta'
    AND m3_.codigo = 'ONL'
    AND c0_.visible = 1
    AND c0_.fin >= ?
    AND c2_.id LIKE '%00'
  )
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.fin ASC
LIMIT
  12

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c1_.nombre AS nombre_2, DATE_FORMAT(c0_.fecha, '%Y-%m-%dT%H:%i:%s') AS sclr_3, DATE_FORMAT(c0_.fin, '%Y-%m-%dT%H:%i:%s') AS sclr_4, c0_.plazas AS plazas_5, c0_.lista_espera AS lista_espera_6 FROM Competicion c0_ INNER JOIN Club c2_ ON (c2_.id = c0_.Organizador_id) INNER JOIN Club c1_ ON (c1_.id = c0_.Club_id) INNER JOIN Modo m3_ ON (m3_.id = c0_.Modo_id) WHERE (c0_.estado = 'abierta' AND m3_.codigo = 'ONL' AND c0_.visible = 1 AND c0_.fin >= '25-12-09' AND c2_.id LIKE '%00') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fin ASC LIMIT 12;

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_
  INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id
WHERE
  i0_.Competicion_id = ?
  AND i0_.participa IN (?)
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC

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_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = 60419 AND i0_.participa IN (1) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC;

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_
  INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id
WHERE
  i0_.Competicion_id = ?
  AND i0_.participa IN (?)
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC

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_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = 59549 AND i0_.participa IN (1) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC;

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_
  INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id
WHERE
  i0_.Competicion_id = ?
  AND i0_.participa IN (?)
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC

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_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = 60294 AND i0_.participa IN (1) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC;

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_
  INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id
WHERE
  i0_.Competicion_id = ?
  AND i0_.participa IN (?)
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC

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_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = 60426 AND i0_.participa IN (1) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC;

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_
  INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id
WHERE
  i0_.Competicion_id = ?
  AND i0_.participa IN (?)
  AND i0_.estado = 'pagado'
ORDER BY
  i0_.participa DESC

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_ INNER JOIN Jugador j1_ ON i0_.Jugador_id = j1_.id WHERE i0_.Competicion_id = 61317 AND i0_.participa IN (1) AND i0_.estado = 'pagado' ORDER BY i0_.participa DESC;