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

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.latitud AS latitud_7,
  t0.longitud AS longitud_8,
  t0.poblacioncliente AS poblacioncliente_9,
  t0.provinciacliente AS provinciacliente_10,
  t0.paiscliente AS paiscliente_11,
  t0.telefonocliente AS telefonocliente_12,
  t0.telefono2cliente AS telefono2cliente_13,
  t0.movilcliente AS movilcliente_14,
  t0.emailcliente AS emailcliente_15,
  t0.codmonedaminuta AS codmonedaminuta_16,
  t0.nifcliente AS nifcliente_17,
  t0.zona AS zona_18,
  t0.fechareserva AS fechareserva_19,
  t0.codcliente AS codcliente_20,
  t0.direccion2cliente AS direccion2cliente_21,
  t0.total AS total_22,
  t0.totalsiniva AS totalsiniva_23,
  t0.sucursal AS sucursal_24,
  t0.comentario AS comentario_25,
  t0.is_finalizada AS is_finalizada_26,
  t0.metododepago AS metododepago_27,
  t0.tipodeservicio AS tipodeservicio_28,
  t0.is_enviado AS is_enviado_29,
  t0.filename AS filename_30,
  t0.estado AS estado_31,
  t0.propinatotal AS propinatotal_32,
  t0.propinaporcentaje AS propinaporcentaje_33,
  t0.linkdepago AS linkdepago_34,
  t0.facturaelectronica AS facturaelectronica_35,
  t0.DIRECCION_2 AS DIRECCION_2_36,
  t0.NOMBRE_1 AS NOMBRE_1_37,
  t0.OTROS_NOMBRES AS OTROS_NOMBRES_38,
  t0.APELLIDO_1 AS APELLIDO_1_39,
  t0.APELLIDO_2 AS APELLIDO_2_40,
  t0.FE_MUNICIPIO AS FE_MUNICIPIO_41,
  t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42,
  t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43,
  t0.TIPOPERSONA AS TIPOPERSONA_44,
  t0.FE_REGIMEN AS FE_REGIMEN_45,
  t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46,
  t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47,
  t0.CENTRO_COSTOS AS CENTRO_COSTOS_48,
  t0.CENTRO_OPERACION AS CENTRO_OPERACION_49,
  t0.alias AS alias_50,
  t0.email_linkdepago AS email_linkdepago_51,
  t0.nombre_receptor AS nombre_receptor_52,
  t0.telefono_receptor AS telefono_receptor_53,
  t0.observaciones_receptor AS observaciones_receptor_54,
  t0.connector_order_id AS connector_order_id_55,
  t0.created_at AS created_at_56,
  t0.updated_at AS updated_at_57,
  t0.user_id AS user_id_58,
  t0.connector_store_id AS connector_store_id_59
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.latitud AS latitud_7, t0.longitud AS longitud_8, t0.poblacioncliente AS poblacioncliente_9, t0.provinciacliente AS provinciacliente_10, t0.paiscliente AS paiscliente_11, t0.telefonocliente AS telefonocliente_12, t0.telefono2cliente AS telefono2cliente_13, t0.movilcliente AS movilcliente_14, t0.emailcliente AS emailcliente_15, t0.codmonedaminuta AS codmonedaminuta_16, t0.nifcliente AS nifcliente_17, t0.zona AS zona_18, t0.fechareserva AS fechareserva_19, t0.codcliente AS codcliente_20, t0.direccion2cliente AS direccion2cliente_21, t0.total AS total_22, t0.totalsiniva AS totalsiniva_23, t0.sucursal AS sucursal_24, t0.comentario AS comentario_25, t0.is_finalizada AS is_finalizada_26, t0.metododepago AS metododepago_27, t0.tipodeservicio AS tipodeservicio_28, t0.is_enviado AS is_enviado_29, t0.filename AS filename_30, t0.estado AS estado_31, t0.propinatotal AS propinatotal_32, t0.propinaporcentaje AS propinaporcentaje_33, t0.linkdepago AS linkdepago_34, t0.facturaelectronica AS facturaelectronica_35, t0.DIRECCION_2 AS DIRECCION_2_36, t0.NOMBRE_1 AS NOMBRE_1_37, t0.OTROS_NOMBRES AS OTROS_NOMBRES_38, t0.APELLIDO_1 AS APELLIDO_1_39, t0.APELLIDO_2 AS APELLIDO_2_40, t0.FE_MUNICIPIO AS FE_MUNICIPIO_41, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43, t0.TIPOPERSONA AS TIPOPERSONA_44, t0.FE_REGIMEN AS FE_REGIMEN_45, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47, t0.CENTRO_COSTOS AS CENTRO_COSTOS_48, t0.CENTRO_OPERACION AS CENTRO_OPERACION_49, t0.alias AS alias_50, t0.email_linkdepago AS email_linkdepago_51, t0.nombre_receptor AS nombre_receptor_52, t0.telefono_receptor AS telefono_receptor_53, t0.observaciones_receptor AS observaciones_receptor_54, t0.connector_order_id AS connector_order_id_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57, t0.user_id AS user_id_58, t0.connector_store_id AS connector_store_id_59 FROM cabecera t0 WHERE t0.id = 379538;

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,
  t0.costo_domicilio AS costo_domicilio_32,
  t0.connector_catalog_id AS connector_catalog_id_33,
  t0.connector_store_id AS connector_store_id_34
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, t0.costo_domicilio AS costo_domicilio_32, t0.connector_catalog_id AS connector_catalog_id_33, t0.connector_store_id AS connector_store_id_34 FROM sucursal t0 WHERE t0.nombre = 'OCCIDENTE DOMICILIOS' LIMIT 1;

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.comentario AS comentario_20,
  t0.cabecera_id AS cabecera_id_21,
  t0.tree_root AS tree_root_22,
  t0.parent_id AS parent_id_23
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.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.cabecera_id = 379538 ORDER BY t0.tree_root ASC, t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.name AS name_3,
  t0.system_name AS system_name_4,
  t0.`desc` AS desc_5,
  t0.price AS price_6,
  t0.is_option AS is_option_7,
  t0.internal_notes AS internal_notes_8,
  t0.ean AS ean_9,
  t0.pos_product AS pos_product_10,
  t0.channels_fine_tuning AS channels_fine_tuning_11,
  t0.images AS images_12,
  t0.cod_impuesto AS cod_impuesto_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  connector_products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.system_name AS system_name_4, t0.`desc` AS desc_5, t0.price AS price_6, t0.is_option AS is_option_7, t0.internal_notes AS internal_notes_8, t0.ean AS ean_9, t0.pos_product AS pos_product_10, t0.channels_fine_tuning AS channels_fine_tuning_11, t0.images AS images_12, t0.cod_impuesto AS cod_impuesto_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM connector_products t0 WHERE t0.id = '06ff1ef0-584b-4fbd-9a49-fe20ee4e1b1c';

SELECT
  t0.codigo AS codigo_1,
  t0.porcentaje AS porcentaje_2,
  t0.descripcion AS descripcion_3,
  t0.activo AS activo_4,
  t0.creado_en AS creado_en_5,
  t0.actualizado_en AS actualizado_en_6
FROM
  codigos_impuesto t0
WHERE
  t0.codigo = ?

SELECT t0.codigo AS codigo_1, t0.porcentaje AS porcentaje_2, t0.descripcion AS descripcion_3, t0.activo AS activo_4, t0.creado_en AS creado_en_5, t0.actualizado_en AS actualizado_en_6 FROM codigos_impuesto t0 WHERE t0.codigo = 19;

"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, comentario, 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, comentario, cabecera_id, tree_root, parent_id) VALUES ('2026-02-11 19:37:26', '06ff1ef0-584b-4fbd-9a49-fe20ee4e1b1c', 'Ensalada Mediterránea', NULL, '41800', '38703.703703704', '3096.2962962963', 19, NULL, 0, NULL, 0, 0, 0, 1, 41800, NULL, 41800, NULL, 379538, NULL, NULL);

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

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

UPDATE
  codigos_impuesto
SET
  porcentaje = ?
WHERE
  codigo = ?

UPDATE codigos_impuesto SET porcentaje = 8 WHERE codigo = 19;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.system_name AS system_name_3,
  t0.`desc` AS desc_4,
  t0.price AS price_5,
  t0.discount_price AS discount_price_6,
  t0.is_option AS is_option_7,
  t0.internal_notes AS internal_notes_8,
  t0.sku AS sku_9,
  t0.ean AS ean_10,
  t0.pos_product_ext_id AS pos_product_ext_id_11,
  t0.option_order AS option_order_12,
  t0.cod_impuesto AS cod_impuesto_13,
  t0.images AS images_14,
  t0.original_option_id AS original_option_id_15,
  t0.connector_group_id AS connector_group_id_16
FROM
  connector_group_options t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.`desc` AS desc_4, t0.price AS price_5, t0.discount_price AS discount_price_6, t0.is_option AS is_option_7, t0.internal_notes AS internal_notes_8, t0.sku AS sku_9, t0.ean AS ean_10, t0.pos_product_ext_id AS pos_product_ext_id_11, t0.option_order AS option_order_12, t0.cod_impuesto AS cod_impuesto_13, t0.images AS images_14, t0.original_option_id AS original_option_id_15, t0.connector_group_id AS connector_group_id_16 FROM connector_group_options t0 WHERE t0.id = 'bd08f72b-799a-43b0-8ca1-53a612d2345f';

SELECT
  t0.codigo AS codigo_1,
  t0.porcentaje AS porcentaje_2,
  t0.descripcion AS descripcion_3,
  t0.activo AS activo_4,
  t0.creado_en AS creado_en_5,
  t0.actualizado_en AS actualizado_en_6
FROM
  codigos_impuesto t0
WHERE
  t0.codigo = ?

SELECT t0.codigo AS codigo_1, t0.porcentaje AS porcentaje_2, t0.descripcion AS descripcion_3, t0.activo AS activo_4, t0.creado_en AS creado_en_5, t0.actualizado_en AS actualizado_en_6 FROM codigos_impuesto t0 WHERE t0.codigo = 5;

"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, comentario, 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, comentario, cabecera_id, tree_root, parent_id) VALUES ('2026-02-11 19:37:26', 'bd08f72b-799a-43b0-8ca1-53a612d2345f', 'Sin Cubiertos', NULL, '0', '0', '0', 5, 0, 0, 0, 0, 0, 0, 1, 0, NULL, 0, NULL, 379538, NULL, 2823630);

UPDATE
  lineas
SET
  lft = lft + 2
WHERE
  lft >= 2
  AND tree_root = ?

UPDATE lineas SET lft = lft + 2 WHERE lft >= 2 AND tree_root = 2823630;

UPDATE
  lineas
SET
  rgt = rgt + 2
WHERE
  rgt >= 2
  AND tree_root = ?

UPDATE lineas SET rgt = rgt + 2 WHERE rgt >= 2 AND tree_root = 2823630;

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

UPDATE lineas SET tree_root = 2823630, lvl = 1, lft = 2, rgt = 3 WHERE id = 2823631;

UPDATE
  codigos_impuesto
SET
  porcentaje = ?
WHERE
  codigo = ?

UPDATE codigos_impuesto SET porcentaje = 0 WHERE codigo = 5;

"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.comentario AS comentario_20,
  t0.cabecera_id AS cabecera_id_21,
  t0.tree_root AS tree_root_22,
  t0.parent_id AS parent_id_23
FROM
  lineas t0
WHERE
  t0.id = ?

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.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.id = 2823630;

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.comentario AS comentario_20,
  t0.cabecera_id AS cabecera_id_21,
  t0.tree_root AS tree_root_22,
  t0.parent_id AS parent_id_23
FROM
  lineas t0
WHERE
  t0.parent_id = ?

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.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.parent_id = 2823630;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  lineas
SET
  preciosiniva = ?,
  precioiva = ?,
  numlineasmodif = ?
WHERE
  id = ?

UPDATE lineas SET preciosiniva = '38703.703703704', precioiva = '3096.2962962963', numlineasmodif = 1 WHERE id = 2823630;

"COMMIT"

"COMMIT";

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.latitud AS latitud_7,
  t0.longitud AS longitud_8,
  t0.poblacioncliente AS poblacioncliente_9,
  t0.provinciacliente AS provinciacliente_10,
  t0.paiscliente AS paiscliente_11,
  t0.telefonocliente AS telefonocliente_12,
  t0.telefono2cliente AS telefono2cliente_13,
  t0.movilcliente AS movilcliente_14,
  t0.emailcliente AS emailcliente_15,
  t0.codmonedaminuta AS codmonedaminuta_16,
  t0.nifcliente AS nifcliente_17,
  t0.zona AS zona_18,
  t0.fechareserva AS fechareserva_19,
  t0.codcliente AS codcliente_20,
  t0.direccion2cliente AS direccion2cliente_21,
  t0.total AS total_22,
  t0.totalsiniva AS totalsiniva_23,
  t0.sucursal AS sucursal_24,
  t0.comentario AS comentario_25,
  t0.is_finalizada AS is_finalizada_26,
  t0.metododepago AS metododepago_27,
  t0.tipodeservicio AS tipodeservicio_28,
  t0.is_enviado AS is_enviado_29,
  t0.filename AS filename_30,
  t0.estado AS estado_31,
  t0.propinatotal AS propinatotal_32,
  t0.propinaporcentaje AS propinaporcentaje_33,
  t0.linkdepago AS linkdepago_34,
  t0.facturaelectronica AS facturaelectronica_35,
  t0.DIRECCION_2 AS DIRECCION_2_36,
  t0.NOMBRE_1 AS NOMBRE_1_37,
  t0.OTROS_NOMBRES AS OTROS_NOMBRES_38,
  t0.APELLIDO_1 AS APELLIDO_1_39,
  t0.APELLIDO_2 AS APELLIDO_2_40,
  t0.FE_MUNICIPIO AS FE_MUNICIPIO_41,
  t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42,
  t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43,
  t0.TIPOPERSONA AS TIPOPERSONA_44,
  t0.FE_REGIMEN AS FE_REGIMEN_45,
  t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46,
  t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47,
  t0.CENTRO_COSTOS AS CENTRO_COSTOS_48,
  t0.CENTRO_OPERACION AS CENTRO_OPERACION_49,
  t0.alias AS alias_50,
  t0.email_linkdepago AS email_linkdepago_51,
  t0.nombre_receptor AS nombre_receptor_52,
  t0.telefono_receptor AS telefono_receptor_53,
  t0.observaciones_receptor AS observaciones_receptor_54,
  t0.connector_order_id AS connector_order_id_55,
  t0.created_at AS created_at_56,
  t0.updated_at AS updated_at_57,
  t0.user_id AS user_id_58,
  t0.connector_store_id AS connector_store_id_59
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.latitud AS latitud_7, t0.longitud AS longitud_8, t0.poblacioncliente AS poblacioncliente_9, t0.provinciacliente AS provinciacliente_10, t0.paiscliente AS paiscliente_11, t0.telefonocliente AS telefonocliente_12, t0.telefono2cliente AS telefono2cliente_13, t0.movilcliente AS movilcliente_14, t0.emailcliente AS emailcliente_15, t0.codmonedaminuta AS codmonedaminuta_16, t0.nifcliente AS nifcliente_17, t0.zona AS zona_18, t0.fechareserva AS fechareserva_19, t0.codcliente AS codcliente_20, t0.direccion2cliente AS direccion2cliente_21, t0.total AS total_22, t0.totalsiniva AS totalsiniva_23, t0.sucursal AS sucursal_24, t0.comentario AS comentario_25, t0.is_finalizada AS is_finalizada_26, t0.metododepago AS metododepago_27, t0.tipodeservicio AS tipodeservicio_28, t0.is_enviado AS is_enviado_29, t0.filename AS filename_30, t0.estado AS estado_31, t0.propinatotal AS propinatotal_32, t0.propinaporcentaje AS propinaporcentaje_33, t0.linkdepago AS linkdepago_34, t0.facturaelectronica AS facturaelectronica_35, t0.DIRECCION_2 AS DIRECCION_2_36, t0.NOMBRE_1 AS NOMBRE_1_37, t0.OTROS_NOMBRES AS OTROS_NOMBRES_38, t0.APELLIDO_1 AS APELLIDO_1_39, t0.APELLIDO_2 AS APELLIDO_2_40, t0.FE_MUNICIPIO AS FE_MUNICIPIO_41, t0.FE_RESPONSABILIDADES AS FE_RESPONSABILIDADES_42, t0.TIPO_DE_DOCUMENTO AS TIPO_DE_DOCUMENTO_43, t0.TIPOPERSONA AS TIPOPERSONA_44, t0.FE_REGIMEN AS FE_REGIMEN_45, t0.FE_DET_TRIBUTARIO AS FE_DET_TRIBUTARIO_46, t0.CUENTA_ALIMENTACION AS CUENTA_ALIMENTACION_47, t0.CENTRO_COSTOS AS CENTRO_COSTOS_48, t0.CENTRO_OPERACION AS CENTRO_OPERACION_49, t0.alias AS alias_50, t0.email_linkdepago AS email_linkdepago_51, t0.nombre_receptor AS nombre_receptor_52, t0.telefono_receptor AS telefono_receptor_53, t0.observaciones_receptor AS observaciones_receptor_54, t0.connector_order_id AS connector_order_id_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57, t0.user_id AS user_id_58, t0.connector_store_id AS connector_store_id_59 FROM cabecera t0 WHERE t0.id = 379538;

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.comentario AS comentario_20,
  t0.cabecera_id AS cabecera_id_21,
  t0.tree_root AS tree_root_22,
  t0.parent_id AS parent_id_23
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.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.cabecera_id = 379538 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.comentario AS comentario_20,
  t0.cabecera_id AS cabecera_id_21,
  t0.tree_root AS tree_root_22,
  t0.parent_id AS parent_id_23
FROM
  lineas t0
WHERE
  t0.parent_id = ?
ORDER BY
  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.comentario AS comentario_20, t0.cabecera_id AS cabecera_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM lineas t0 WHERE t0.parent_id = 2823628 ORDER BY t0.lft ASC;