Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nombre AS nombre_5,
  t0.codvendedor AS codvendedor_6,
  t0.is_enabled AS is_enabled_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = 8;

SELECT
  c0_.id AS id_0,
  c0_.nombrecliente AS nombrecliente_1,
  c0_.nombres AS nombres_2,
  c0_.apellidos AS apellidos_3,
  c0_.codpostalcliente AS codpostalcliente_4,
  c0_.direccioncliente AS direccioncliente_5,
  c0_.poblacioncliente AS poblacioncliente_6,
  c0_.provinciacliente AS provinciacliente_7,
  c0_.paiscliente AS paiscliente_8,
  c0_.telefonocliente AS telefonocliente_9,
  c0_.telefono2cliente AS telefono2cliente_10,
  c0_.movilcliente AS movilcliente_11,
  c0_.emailcliente AS emailcliente_12,
  c0_.codmonedaminuta AS codmonedaminuta_13,
  c0_.nifcliente AS nifcliente_14,
  c0_.zona AS zona_15,
  c0_.fechareserva AS fechareserva_16,
  c0_.codcliente AS codcliente_17,
  c0_.direccion2cliente AS direccion2cliente_18,
  c0_.total AS total_19,
  c0_.totalsiniva AS totalsiniva_20,
  c0_.sucursal AS sucursal_21,
  c0_.comentario AS comentario_22,
  c0_.is_finalizada AS is_finalizada_23,
  c0_.metododepago AS metododepago_24,
  c0_.tipodeservicio AS tipodeservicio_25,
  c0_.is_enviado AS is_enviado_26,
  c0_.filename AS filename_27,
  c0_.estado AS estado_28,
  c0_.propinatotal AS propinatotal_29,
  c0_.propinaporcentaje AS propinaporcentaje_30,
  c0_.linkdepago AS linkdepago_31,
  c0_.facturaelectronica AS facturaelectronica_32,
  c0_.DIRECCION_2 AS DIRECCION_2_33,
  c0_.NOMBRE_1 AS NOMBRE_1_34,
  c0_.OTROS_NOMBRES AS OTROS_NOMBRES_35,
  c0_.APELLIDO_1 AS APELLIDO_1_36,
  c0_.APELLIDO_2 AS APELLIDO_2_37,
  c0_.FE_MUNICIPIO AS FE_MUNICIPIO_38,
  c0_.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_39,
  c0_.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_40,
  c0_.TIPOPERSONA AS TIPOPERSONA_41,
  c0_.FE_REGIMEN AS FE_REGIMEN_42,
  c0_.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_43,
  c0_.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_44,
  c0_.CENTRO_COSTOS AS CENTRO_COSTOS_45,
  c0_.CENTRO_OPERACION AS CENTRO_OPERACION_46,
  c0_.alias AS alias_47,
  c0_.email_linkdepago AS email_linkdepago_48,
  c0_.nombre_receptor AS nombre_receptor_49,
  c0_.telefono_receptor AS telefono_receptor_50,
  c0_.observaciones_receptor AS observaciones_receptor_51,
  c0_.created_at AS created_at_52,
  c0_.updated_at AS updated_at_53,
  c0_.user_id AS user_id_54
FROM
  cabecera c0_
WHERE
  c0_.is_enviado = ?
  AND c0_.is_finalizada = ?
  AND c0_.estado = ?
  AND c0_.updated_at < ?
  AND c0_.updated_at > ?
ORDER BY
  c0_.updated_at ASC

SELECT c0_.id AS id_0, c0_.nombrecliente AS nombrecliente_1, c0_.nombres AS nombres_2, c0_.apellidos AS apellidos_3, c0_.codpostalcliente AS codpostalcliente_4, c0_.direccioncliente AS direccioncliente_5, c0_.poblacioncliente AS poblacioncliente_6, c0_.provinciacliente AS provinciacliente_7, c0_.paiscliente AS paiscliente_8, c0_.telefonocliente AS telefonocliente_9, c0_.telefono2cliente AS telefono2cliente_10, c0_.movilcliente AS movilcliente_11, c0_.emailcliente AS emailcliente_12, c0_.codmonedaminuta AS codmonedaminuta_13, c0_.nifcliente AS nifcliente_14, c0_.zona AS zona_15, c0_.fechareserva AS fechareserva_16, c0_.codcliente AS codcliente_17, c0_.direccion2cliente AS direccion2cliente_18, c0_.total AS total_19, c0_.totalsiniva AS totalsiniva_20, c0_.sucursal AS sucursal_21, c0_.comentario AS comentario_22, c0_.is_finalizada AS is_finalizada_23, c0_.metododepago AS metododepago_24, c0_.tipodeservicio AS tipodeservicio_25, c0_.is_enviado AS is_enviado_26, c0_.filename AS filename_27, c0_.estado AS estado_28, c0_.propinatotal AS propinatotal_29, c0_.propinaporcentaje AS propinaporcentaje_30, c0_.linkdepago AS linkdepago_31, c0_.facturaelectronica AS facturaelectronica_32, c0_.DIRECCION_2 AS DIRECCION_2_33, c0_.NOMBRE_1 AS NOMBRE_1_34, c0_.OTROS_NOMBRES AS OTROS_NOMBRES_35, c0_.APELLIDO_1 AS APELLIDO_1_36, c0_.APELLIDO_2 AS APELLIDO_2_37, c0_.FE_MUNICIPIO AS FE_MUNICIPIO_38, c0_.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_39, c0_.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_40, c0_.TIPOPERSONA AS TIPOPERSONA_41, c0_.FE_REGIMEN AS FE_REGIMEN_42, c0_.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_43, c0_.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_44, c0_.CENTRO_COSTOS AS CENTRO_COSTOS_45, c0_.CENTRO_OPERACION AS CENTRO_OPERACION_46, c0_.alias AS alias_47, c0_.email_linkdepago AS email_linkdepago_48, c0_.nombre_receptor AS nombre_receptor_49, c0_.telefono_receptor AS telefono_receptor_50, c0_.observaciones_receptor AS observaciones_receptor_51, c0_.created_at AS created_at_52, c0_.updated_at AS updated_at_53, c0_.user_id AS user_id_54 FROM cabecera c0_ WHERE c0_.is_enviado = 0 AND c0_.is_finalizada = 1 AND c0_.estado = 'PROCESANDO' AND c0_.updated_at < '2025-08-27 14:51:54' AND c0_.updated_at > '2025-08-26 14:56:54' ORDER BY c0_.updated_at ASC;

SELECT
  c0_.sucursal AS sucursal_0,
  s1_.id AS id_1,
  s1_.nombre AS nombre_2,
  s1_.lat AS lat_3,
  s1_.lng AS lng_4,
  s1_.poligono AS poligono_5,
  s1_.color AS color_6,
  s1_.mon_open_at AS mon_open_at_7,
  s1_.mon_closed_at AS mon_closed_at_8,
  s1_.tue_open_at AS tue_open_at_9,
  s1_.tue_closed_at AS tue_closed_at_10,
  s1_.wed_open_at AS wed_open_at_11,
  s1_.wed_closed_at AS wed_closed_at_12,
  s1_.thu_open_at AS thu_open_at_13,
  s1_.thu_closed_at AS thu_closed_at_14,
  s1_.fri_open_at AS fri_open_at_15,
  s1_.fri_closed_at AS fri_closed_at_16,
  s1_.sat_open_at AS sat_open_at_17,
  s1_.sat_closed_at AS sat_closed_at_18,
  s1_.sun_open_at AS sun_open_at_19,
  s1_.sun_closed_at AS sun_closed_at_20,
  s1_.is_enabled AS is_enabled_21,
  s1_.is_enabled_programming AS is_enabled_programming_22,
  s1_.is_enabled_reservation AS is_enabled_reservation_23,
  s1_.is_active AS is_active_24,
  s1_.delivery_capacity AS delivery_capacity_25,
  s1_.number_delivery_men AS number_delivery_men_26,
  s1_.codalmvent AS codalmvent_27,
  s1_.server AS server_28,
  s1_.server_db AS server_db_29,
  s1_.server_user AS server_user_30,
  s1_.server_pass AS server_pass_31,
  COUNT(
    DISTINCT (
      CASE WHEN c0_.estado = 'PREPARANDO' THEN
        c0_.id
      ELSE
        ?
      END
    )
  ) AS sclr_32,
  COUNT(
    DISTINCT (
      CASE WHEN c0_.estado = 'REPARTO' THEN
        c0_.id
      ELSE
        ?
      END
    )
  ) AS sclr_33
FROM
  cabecera c0_
  INNER JOIN sucursal s1_ ON (s1_.nombre = c0_.sucursal)
WHERE
  c0_.updated_at > ?
GROUP BY
  c0_.sucursal
ORDER BY
  c0_.updated_at ASC

SELECT c0_.sucursal AS sucursal_0, s1_.id AS id_1, s1_.nombre AS nombre_2, s1_.lat AS lat_3, s1_.lng AS lng_4, s1_.poligono AS poligono_5, s1_.color AS color_6, s1_.mon_open_at AS mon_open_at_7, s1_.mon_closed_at AS mon_closed_at_8, s1_.tue_open_at AS tue_open_at_9, s1_.tue_closed_at AS tue_closed_at_10, s1_.wed_open_at AS wed_open_at_11, s1_.wed_closed_at AS wed_closed_at_12, s1_.thu_open_at AS thu_open_at_13, s1_.thu_closed_at AS thu_closed_at_14, s1_.fri_open_at AS fri_open_at_15, s1_.fri_closed_at AS fri_closed_at_16, s1_.sat_open_at AS sat_open_at_17, s1_.sat_closed_at AS sat_closed_at_18, s1_.sun_open_at AS sun_open_at_19, s1_.sun_closed_at AS sun_closed_at_20, s1_.is_enabled AS is_enabled_21, s1_.is_enabled_programming AS is_enabled_programming_22, s1_.is_enabled_reservation AS is_enabled_reservation_23, s1_.is_active AS is_active_24, s1_.delivery_capacity AS delivery_capacity_25, s1_.number_delivery_men AS number_delivery_men_26, s1_.codalmvent AS codalmvent_27, s1_.server AS server_28, s1_.server_db AS server_db_29, s1_.server_user AS server_user_30, s1_.server_pass AS server_pass_31, COUNT(DISTINCT (CASE WHEN c0_.estado = 'PREPARANDO' THEN c0_.id ELSE NULL END)) AS sclr_32, COUNT(DISTINCT (CASE WHEN c0_.estado = 'REPARTO' THEN c0_.id ELSE NULL END)) AS sclr_33 FROM cabecera c0_ INNER JOIN sucursal s1_ ON (s1_.nombre = c0_.sucursal) WHERE c0_.updated_at > '2025-08-26 14:56:54' GROUP BY c0_.sucursal ORDER BY c0_.updated_at ASC;

SELECT
  e0_.sucursal AS sucursal_0,
  s1_.id AS id_1,
  s1_.nombre AS nombre_2,
  s1_.lat AS lat_3,
  s1_.lng AS lng_4,
  s1_.poligono AS poligono_5,
  s1_.color AS color_6,
  s1_.mon_open_at AS mon_open_at_7,
  s1_.mon_closed_at AS mon_closed_at_8,
  s1_.tue_open_at AS tue_open_at_9,
  s1_.tue_closed_at AS tue_closed_at_10,
  s1_.wed_open_at AS wed_open_at_11,
  s1_.wed_closed_at AS wed_closed_at_12,
  s1_.thu_open_at AS thu_open_at_13,
  s1_.thu_closed_at AS thu_closed_at_14,
  s1_.fri_open_at AS fri_open_at_15,
  s1_.fri_closed_at AS fri_closed_at_16,
  s1_.sat_open_at AS sat_open_at_17,
  s1_.sat_closed_at AS sat_closed_at_18,
  s1_.sun_open_at AS sun_open_at_19,
  s1_.sun_closed_at AS sun_closed_at_20,
  s1_.is_enabled AS is_enabled_21,
  s1_.is_enabled_programming AS is_enabled_programming_22,
  s1_.is_enabled_reservation AS is_enabled_reservation_23,
  s1_.is_active AS is_active_24,
  s1_.delivery_capacity AS delivery_capacity_25,
  s1_.number_delivery_men AS number_delivery_men_26,
  s1_.codalmvent AS codalmvent_27,
  s1_.server AS server_28,
  s1_.server_db AS server_db_29,
  s1_.server_user AS server_user_30,
  s1_.server_pass AS server_pass_31,
  COUNT(
    DISTINCT (
      CASE WHEN e0_.estado = 'PREPARACION' THEN
        e0_.id
      ELSE
        ?
      END
    )
  ) AS sclr_32,
  COUNT(
    DISTINCT (
      CASE WHEN e0_.estado = 'REPARTO' THEN
        e0_.id
      ELSE
        ?
      END
    )
  ) AS sclr_33
FROM
  ecommerce_cabecera e0_
  INNER JOIN sucursal s1_ ON (s1_.nombre = e0_.sucursal)
WHERE
  e0_.updated_at > ?
GROUP BY
  e0_.sucursal
ORDER BY
  e0_.updated_at ASC

SELECT e0_.sucursal AS sucursal_0, s1_.id AS id_1, s1_.nombre AS nombre_2, s1_.lat AS lat_3, s1_.lng AS lng_4, s1_.poligono AS poligono_5, s1_.color AS color_6, s1_.mon_open_at AS mon_open_at_7, s1_.mon_closed_at AS mon_closed_at_8, s1_.tue_open_at AS tue_open_at_9, s1_.tue_closed_at AS tue_closed_at_10, s1_.wed_open_at AS wed_open_at_11, s1_.wed_closed_at AS wed_closed_at_12, s1_.thu_open_at AS thu_open_at_13, s1_.thu_closed_at AS thu_closed_at_14, s1_.fri_open_at AS fri_open_at_15, s1_.fri_closed_at AS fri_closed_at_16, s1_.sat_open_at AS sat_open_at_17, s1_.sat_closed_at AS sat_closed_at_18, s1_.sun_open_at AS sun_open_at_19, s1_.sun_closed_at AS sun_closed_at_20, s1_.is_enabled AS is_enabled_21, s1_.is_enabled_programming AS is_enabled_programming_22, s1_.is_enabled_reservation AS is_enabled_reservation_23, s1_.is_active AS is_active_24, s1_.delivery_capacity AS delivery_capacity_25, s1_.number_delivery_men AS number_delivery_men_26, s1_.codalmvent AS codalmvent_27, s1_.server AS server_28, s1_.server_db AS server_db_29, s1_.server_user AS server_user_30, s1_.server_pass AS server_pass_31, COUNT(DISTINCT (CASE WHEN e0_.estado = 'PREPARACION' THEN e0_.id ELSE NULL END)) AS sclr_32, COUNT(DISTINCT (CASE WHEN e0_.estado = 'REPARTO' THEN e0_.id ELSE NULL END)) AS sclr_33 FROM ecommerce_cabecera e0_ INNER JOIN sucursal s1_ ON (s1_.nombre = e0_.sucursal) WHERE e0_.updated_at > '2025-08-26 14:56:54' GROUP BY e0_.sucursal ORDER BY e0_.updated_at ASC;