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

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 = '347462';

SELECT
  a0_.CODARTICULO AS CODARTICULO_0,
  a0_.DESCRIPCION AS DESCRIPCION_1,
  p1_.PNETO AS PNETO_2,
  i2_.IVA AS IVA_3,
  i2_.TIPOIVA AS TIPOIVA_4,
  f3_.CODFAVORITO AS CODFAVORITO_5
FROM
  articulos a0_
  INNER JOIN preciosventa p1_ ON (
    a0_.CODARTICULO = p1_.CODARTICULO
  )
  INNER JOIN impuestos i2_ ON (a0_.TIPOIMPUESTO = i2_.TIPOIVA)
  INNER JOIN favoritoslin f3_ ON (
    a0_.CODARTICULO = f3_.CODARTICULO
  )
WHERE
  a0_.CODARTICULO = ?
  AND p1_.IDTARIFAV = 1
  AND f3_.CODFAVORITO = ?

SELECT a0_.CODARTICULO AS CODARTICULO_0, a0_.DESCRIPCION AS DESCRIPCION_1, p1_.PNETO AS PNETO_2, i2_.IVA AS IVA_3, i2_.TIPOIVA AS TIPOIVA_4, f3_.CODFAVORITO AS CODFAVORITO_5 FROM articulos a0_ INNER JOIN preciosventa p1_ ON (a0_.CODARTICULO = p1_.CODARTICULO) INNER JOIN impuestos i2_ ON (a0_.TIPOIMPUESTO = i2_.TIPOIVA) INNER JOIN favoritoslin f3_ ON (a0_.CODARTICULO = f3_.CODARTICULO) WHERE a0_.CODARTICULO = 10826 AND p1_.IDTARIFAV = 1 AND f3_.CODFAVORITO = 221;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO lineas (
  create_at, codarticulo, descripcion,
  codfavorito, precio, preciosiniva,
  precioiva, codimpuesto, codmodificador,
  numlineasmodif, codfavoritos, lft,
  lvl, rgt, unidades, preciototal, posicion,
  preciounidad, cabecera_id, tree_root,
  parent_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

INSERT INTO lineas (create_at, codarticulo, descripcion, codfavorito, precio, preciosiniva, precioiva, codimpuesto, codmodificador, numlineasmodif, codfavoritos, lft, lvl, rgt, unidades, preciototal, posicion, preciounidad, cabecera_id, tree_root, parent_id) VALUES (NULL, 10826, 'DOMICILIO', NULL, '6500', '5462.1848739496', NULL, 19, NULL, NULL, 221, 0, 0, 0, 1, 6500, NULL, 6500, 347462, NULL, NULL);

UPDATE
  lineas
SET
  tree_root = ?,
  lvl = 0,
  lft = 1,
  rgt = 2
WHERE
  id = ?

UPDATE lineas SET tree_root = 2603902, lvl = 0, lft = 1, rgt = 2 WHERE id = 2603902;

UPDATE
  cabecera
SET
  total = ?,
  totalsiniva = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE cabecera SET total = '6500', totalsiniva = '5462.1848739496', updated_at = '2025-08-27 20:22:16' WHERE id = 347462;

"COMMIT"

"COMMIT";

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 = 347462 ORDER BY t0.tree_root ASC, t0.lft ASC;