Symfony Profiler

SELECT
  e0_.CODARTICULO AS CODARTICULO_0,
  MAX(e0_.frecuencia) AS sclr_1
FROM
  estadisticas_articulos_cliente e0_
WHERE
  e0_.nifcliente = ?
GROUP BY
  e0_.CODARTICULO
ORDER BY
  sclr_1 DESC
LIMIT
  10

SELECT e0_.CODARTICULO AS CODARTICULO_0, MAX(e0_.frecuencia) AS sclr_1 FROM estadisticas_articulos_cliente e0_ WHERE e0_.nifcliente = '43626974' GROUP BY e0_.CODARTICULO ORDER BY sclr_1 DESC LIMIT 10;

SELECT
  a0_.CODARTICULO AS CODARTICULO_0,
  a0_.DESCRIPCION AS DESCRIPCION_1,
  f1_.CODFAVORITO AS CODFAVORITO_2,
  f2_.DESCRIPCION AS DESCRIPCION_3,
  c3_.bloqueado AS bloqueado_4
FROM
  articulos a0_
  LEFT JOIN favoritoslin f1_ ON (
    a0_.CODARTICULO = f1_.CODARTICULO
  )
  LEFT JOIN favoritoscab f2_ ON (
    f1_.CODFAVORITO = f2_.CODFAVORITO
  )
  LEFT JOIN cc_articulos_bloqueados c3_ ON (
    a0_.CODARTICULO = c3_.codarticulo
    AND c3_.sucursal = ?
  )
WHERE
  a0_.CODARTICULO IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  a0_.CODARTICULO

SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, f1_.CODFAVORITO AS CODFAVORITO_2, f2_.DESCRIPCION AS DESCRIPCION_3, c3_.bloqueado AS bloqueado_4 FROM articulos a0_ LEFT JOIN favoritoslin f1_ ON (a0_.CODARTICULO = f1_.CODARTICULO) LEFT JOIN favoritoscab f2_ ON (f1_.CODFAVORITO = f2_.CODFAVORITO) LEFT JOIN cc_articulos_bloqueados c3_ ON (a0_.CODARTICULO = c3_.codarticulo AND c3_.sucursal = 'C01') WHERE a0_.CODARTICULO IN (128, 264, 1882, 415, 63, 202, 321, 426, 164, 200) GROUP BY a0_.CODARTICULO;

SELECT
  t0.id AS id_1,
  t0.nombrecliente AS nombrecliente_2,
  t0.nombres AS nombres_3,
  t0.apellidos AS apellidos_4,
  t0.codpostalcliente AS codpostalcliente_5,
  t0.direccioncliente AS direccioncliente_6,
  t0.poblacioncliente AS poblacioncliente_7,
  t0.provinciacliente AS provinciacliente_8,
  t0.paiscliente AS paiscliente_9,
  t0.telefonocliente AS telefonocliente_10,
  t0.telefono2cliente AS telefono2cliente_11,
  t0.movilcliente AS movilcliente_12,
  t0.emailcliente AS emailcliente_13,
  t0.codmonedaminuta AS codmonedaminuta_14,
  t0.nifcliente AS nifcliente_15,
  t0.zona AS zona_16,
  t0.fechareserva AS fechareserva_17,
  t0.codcliente AS codcliente_18,
  t0.direccion2cliente AS direccion2cliente_19,
  t0.total AS total_20,
  t0.totalsiniva AS totalsiniva_21,
  t0.sucursal AS sucursal_22,
  t0.comentario AS comentario_23,
  t0.is_finalizada AS is_finalizada_24,
  t0.metododepago AS metododepago_25,
  t0.tipodeservicio AS tipodeservicio_26,
  t0.is_enviado AS is_enviado_27,
  t0.filename AS filename_28,
  t0.estado AS estado_29,
  t0.propinatotal AS propinatotal_30,
  t0.propinaporcentaje AS propinaporcentaje_31,
  t0.linkdepago AS linkdepago_32,
  t0.facturaelectronica AS facturaelectronica_33,
  t0.DIRECCION_2 AS DIRECCION_2_34,
  t0.NOMBRE_1 AS NOMBRE_1_35,
  t0.OTROS_NOMBRES AS OTROS_NOMBRES_36,
  t0.APELLIDO_1 AS APELLIDO_1_37,
  t0.APELLIDO_2 AS APELLIDO_2_38,
  t0.FE_MUNICIPIO AS FE_MUNICIPIO_39,
  t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_40,
  t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_41,
  t0.TIPOPERSONA AS TIPOPERSONA_42,
  t0.FE_REGIMEN AS FE_REGIMEN_43,
  t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_44,
  t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_45,
  t0.CENTRO_COSTOS AS CENTRO_COSTOS_46,
  t0.CENTRO_OPERACION AS CENTRO_OPERACION_47,
  t0.alias AS alias_48,
  t0.email_linkdepago AS email_linkdepago_49,
  t0.nombre_receptor AS nombre_receptor_50,
  t0.telefono_receptor AS telefono_receptor_51,
  t0.observaciones_receptor AS observaciones_receptor_52,
  t0.created_at AS created_at_53,
  t0.updated_at AS updated_at_54,
  t0.user_id AS user_id_55
FROM
  cabecera t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombrecliente AS nombrecliente_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.codpostalcliente AS codpostalcliente_5, t0.direccioncliente AS direccioncliente_6, t0.poblacioncliente AS poblacioncliente_7, t0.provinciacliente AS provinciacliente_8, t0.paiscliente AS paiscliente_9, t0.telefonocliente AS telefonocliente_10, t0.telefono2cliente AS telefono2cliente_11, t0.movilcliente AS movilcliente_12, t0.emailcliente AS emailcliente_13, t0.codmonedaminuta AS codmonedaminuta_14, t0.nifcliente AS nifcliente_15, t0.zona AS zona_16, t0.fechareserva AS fechareserva_17, t0.codcliente AS codcliente_18, t0.direccion2cliente AS direccion2cliente_19, t0.total AS total_20, t0.totalsiniva AS totalsiniva_21, t0.sucursal AS sucursal_22, t0.comentario AS comentario_23, t0.is_finalizada AS is_finalizada_24, t0.metododepago AS metododepago_25, t0.tipodeservicio AS tipodeservicio_26, t0.is_enviado AS is_enviado_27, t0.filename AS filename_28, t0.estado AS estado_29, t0.propinatotal AS propinatotal_30, t0.propinaporcentaje AS propinaporcentaje_31, t0.linkdepago AS linkdepago_32, t0.facturaelectronica AS facturaelectronica_33, t0.DIRECCION_2 AS DIRECCION_2_34, t0.NOMBRE_1 AS NOMBRE_1_35, t0.OTROS_NOMBRES AS OTROS_NOMBRES_36, t0.APELLIDO_1 AS APELLIDO_1_37, t0.APELLIDO_2 AS APELLIDO_2_38, t0.FE_MUNICIPIO AS FE_MUNICIPIO_39, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_40, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_41, t0.TIPOPERSONA AS TIPOPERSONA_42, t0.FE_REGIMEN AS FE_REGIMEN_43, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_44, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_45, t0.CENTRO_COSTOS AS CENTRO_COSTOS_46, t0.CENTRO_OPERACION AS CENTRO_OPERACION_47, t0.alias AS alias_48, t0.email_linkdepago AS email_linkdepago_49, t0.nombre_receptor AS nombre_receptor_50, t0.telefono_receptor AS telefono_receptor_51, t0.observaciones_receptor AS observaciones_receptor_52, t0.created_at AS created_at_53, t0.updated_at AS updated_at_54, t0.user_id AS user_id_55 FROM cabecera t0 WHERE t0.id = 347669;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.codarticulo AS codarticulo_3,
  t0.descripcion AS descripcion_4,
  t0.codfavorito AS codfavorito_5,
  t0.precio AS precio_6,
  t0.preciosiniva AS preciosiniva_7,
  t0.precioiva AS precioiva_8,
  t0.codimpuesto AS codimpuesto_9,
  t0.codmodificador AS codmodificador_10,
  t0.numlineasmodif AS numlineasmodif_11,
  t0.codfavoritos AS codfavoritos_12,
  t0.lft AS lft_13,
  t0.lvl AS lvl_14,
  t0.rgt AS rgt_15,
  t0.unidades AS unidades_16,
  t0.preciototal AS preciototal_17,
  t0.posicion AS posicion_18,
  t0.preciounidad AS preciounidad_19,
  t0.cabecera_id AS cabecera_id_20,
  t0.tree_root AS tree_root_21,
  t0.parent_id AS parent_id_22
FROM
  lineas t0
WHERE
  t0.cabecera_id = ?
ORDER BY
  t0.tree_root ASC,
  t0.lft ASC

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.codarticulo AS codarticulo_3, t0.descripcion AS descripcion_4, t0.codfavorito AS codfavorito_5, t0.precio AS precio_6, t0.preciosiniva AS preciosiniva_7, t0.precioiva AS precioiva_8, t0.codimpuesto AS codimpuesto_9, t0.codmodificador AS codmodificador_10, t0.numlineasmodif AS numlineasmodif_11, t0.codfavoritos AS codfavoritos_12, t0.lft AS lft_13, t0.lvl AS lvl_14, t0.rgt AS rgt_15, t0.unidades AS unidades_16, t0.preciototal AS preciototal_17, t0.posicion AS posicion_18, t0.preciounidad AS preciounidad_19, t0.cabecera_id AS cabecera_id_20, t0.tree_root AS tree_root_21, t0.parent_id AS parent_id_22 FROM lineas t0 WHERE t0.cabecera_id = 347669 ORDER BY t0.tree_root ASC, t0.lft ASC;

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 = 10;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.lat AS lat_3,
  t0.lng AS lng_4,
  t0.poligono AS poligono_5,
  t0.color AS color_6,
  t0.mon_open_at AS mon_open_at_7,
  t0.mon_closed_at AS mon_closed_at_8,
  t0.tue_open_at AS tue_open_at_9,
  t0.tue_closed_at AS tue_closed_at_10,
  t0.wed_open_at AS wed_open_at_11,
  t0.wed_closed_at AS wed_closed_at_12,
  t0.thu_open_at AS thu_open_at_13,
  t0.thu_closed_at AS thu_closed_at_14,
  t0.fri_open_at AS fri_open_at_15,
  t0.fri_closed_at AS fri_closed_at_16,
  t0.sat_open_at AS sat_open_at_17,
  t0.sat_closed_at AS sat_closed_at_18,
  t0.sun_open_at AS sun_open_at_19,
  t0.sun_closed_at AS sun_closed_at_20,
  t0.is_enabled AS is_enabled_21,
  t0.is_enabled_programming AS is_enabled_programming_22,
  t0.is_enabled_reservation AS is_enabled_reservation_23,
  t0.is_active AS is_active_24,
  t0.delivery_capacity AS delivery_capacity_25,
  t0.number_delivery_men AS number_delivery_men_26,
  t0.codalmvent AS codalmvent_27,
  t0.server AS server_28,
  t0.server_db AS server_db_29,
  t0.server_user AS server_user_30,
  t0.server_pass AS server_pass_31
FROM
  sucursal t0
WHERE
  t0.nombre = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.poligono AS poligono_5, t0.color AS color_6, t0.mon_open_at AS mon_open_at_7, t0.mon_closed_at AS mon_closed_at_8, t0.tue_open_at AS tue_open_at_9, t0.tue_closed_at AS tue_closed_at_10, t0.wed_open_at AS wed_open_at_11, t0.wed_closed_at AS wed_closed_at_12, t0.thu_open_at AS thu_open_at_13, t0.thu_closed_at AS thu_closed_at_14, t0.fri_open_at AS fri_open_at_15, t0.fri_closed_at AS fri_closed_at_16, t0.sat_open_at AS sat_open_at_17, t0.sat_closed_at AS sat_closed_at_18, t0.sun_open_at AS sun_open_at_19, t0.sun_closed_at AS sun_closed_at_20, t0.is_enabled AS is_enabled_21, t0.is_enabled_programming AS is_enabled_programming_22, t0.is_enabled_reservation AS is_enabled_reservation_23, t0.is_active AS is_active_24, t0.delivery_capacity AS delivery_capacity_25, t0.number_delivery_men AS number_delivery_men_26, t0.codalmvent AS codalmvent_27, t0.server AS server_28, t0.server_db AS server_db_29, t0.server_user AS server_user_30, t0.server_pass AS server_pass_31 FROM sucursal t0 WHERE t0.nombre = 'ENVIGADO DOMICILIOS' LIMIT 1;

SELECT
  f0_.CODFAVORITO AS CODFAVORITO_0,
  f0_.DESCRIPCION AS DESCRIPCION_1
FROM
  favoritoscab f0_
  INNER JOIN favoritostiposterminal f1_ ON (
    f0_.CODFAVORITO = f1_.CODFAVORITO
  )
WHERE
  f1_.IDTIPOTERMINAL = ?

SELECT f0_.CODFAVORITO AS CODFAVORITO_0, f0_.DESCRIPCION AS DESCRIPCION_1 FROM favoritoscab f0_ INNER JOIN favoritostiposterminal f1_ ON (f0_.CODFAVORITO = f1_.CODFAVORITO) WHERE f1_.IDTIPOTERMINAL = 10;