Symfony Profiler

SELECT 
  t1.id AS id2, 
  t1.nombre AS nombre3, 
  t1.nombreURL AS nombreURL4, 
  t1.fechaAlta AS fechaAlta5, 
  t1.codigo AS codigo6, 
  t1.pathqr AS pathqr7, 
  t1.descripcion AS descripcion8, 
  t1.especificaciones AS especificaciones9, 
  t1.eliminado AS eliminado10, 
  t1.stockTotal AS stockTotal11, 
  t1.stockReal AS stockReal12, 
  t1.mostrarPrincipal AS mostrarPrincipal13, 
  t1.title AS title14, 
  t1.metadescription AS metadescription15, 
  t1.activo AS activo16, 
  t1.md5qr AS md5qr17, 
  t0.precioDia AS precioDia18, 
  t0.fianza AS fianza19, 
  t0.descuento37 AS descuento3720, 
  t0.descuento830 AS descuento83021, 
  t0.descuento31 AS descuento3122, 
  t0.desgaste AS desgaste23, 
  t0.tipoDesgaste AS tipoDesgaste24, 
  t0.precioDesgaste AS precioDesgaste25, 
  t0.precioSuciedad AS precioSuciedad26, 
  t0.precioRecargo AS precioRecargo27, 
  t0.suplementoTorre AS suplementoTorre28, 
  t0.mostrarrotura AS mostrarrotura29, 
  t1.subcategoria_id AS subcategoria_id30, 
  t1.tipoIVA_id AS tipoIVA_id31, 
  t0.contrato_id AS contrato_id32, 
  t1.tipo 
FROM 
  productalquiler t0 
  INNER JOIN Product t1 ON t0.id = t1.id 
  INNER JOIN alquilertodesgaste ON t0.id = alquilertodesgaste.relation_product_id 
WHERE 
  alquilertodesgaste.product_id = ? 
ORDER BY 
  t1.nombre ASC

SELECT t1.id AS id2, t1.nombre AS nombre3, t1.nombreURL AS nombreURL4, t1.fechaAlta AS fechaAlta5, t1.codigo AS codigo6, t1.pathqr AS pathqr7, t1.descripcion AS descripcion8, t1.especificaciones AS especificaciones9, t1.eliminado AS eliminado10, t1.stockTotal AS stockTotal11, t1.stockReal AS stockReal12, t1.mostrarPrincipal AS mostrarPrincipal13, t1.title AS title14, t1.metadescription AS metadescription15, t1.activo AS activo16, t1.md5qr AS md5qr17, t0.precioDia AS precioDia18, t0.fianza AS fianza19, t0.descuento37 AS descuento3720, t0.descuento830 AS descuento83021, t0.descuento31 AS descuento3122, t0.desgaste AS desgaste23, t0.tipoDesgaste AS tipoDesgaste24, t0.precioDesgaste AS precioDesgaste25, t0.precioSuciedad AS precioSuciedad26, t0.precioRecargo AS precioRecargo27, t0.suplementoTorre AS suplementoTorre28, t0.mostrarrotura AS mostrarrotura29, t1.subcategoria_id AS subcategoria_id30, t1.tipoIVA_id AS tipoIVA_id31, t0.contrato_id AS contrato_id32, t1.tipo FROM productalquiler t0 INNER JOIN Product t1 ON t0.id = t1.id INNER JOIN alquilertodesgaste ON t0.id = alquilertodesgaste.relation_product_id WHERE alquilertodesgaste.product_id = 147 ORDER BY t1.nombre ASC;

SELECT 
  t0.id AS id6, 
  t0.firstname AS firstname7, 
  t0.lastname AS lastname8, 
  t0.email AS email9, 
  t0.username AS username10, 
  t0.password AS password11, 
  t0.nif AS nif12, 
  t0.company AS company13, 
  t0.address AS address14, 
  t0.cp AS cp15, 
  t0.localidad AS localidad16, 
  t0.provincia AS provincia17, 
  t0.comunity AS comunity18, 
  t0.phone AS phone19, 
  t0.mphone AS mphone20, 
  t0.salt AS salt21, 
  t0.rol AS rol22, 
  t0.codigorecuperacion AS codigorecuperacion23, 
  t0.pathdnifrontal AS pathdnifrontal24, 
  t0.pathdnitrasera AS pathdnitrasera25, 
  t0.pathfoto AS pathfoto26, 
  t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, 
  t0.pathrgpdfirma AS pathrgpdfirma28, 
  t0.firmadorgpdelectronico AS firmadorgpdelectronico29, 
  t0.tieneCuenta AS tieneCuenta30, 
  t0.tipoFianza AS tipoFianza31, 
  t0.activo AS activo32, 
  t0.bloqueado AS bloqueado33, 
  t0.expirado AS expirado34, 
  t0.tipo, 
  t1.nombre AS nombre35, 
  t1.latitud AS latitud36, 
  t1.longitud AS longitud37, 
  t1.especial AS especial38, 
  t1.sendSMS AS sendSMS39, 
  t1.entregadirectaacliente AS entregadirectaacliente40, 
  t1.categorydistributor_id AS categorydistributor_id41, 
  t1.gestorZona_id AS gestorZona_id42, 
  t3.pagoWeb AS pagoWeb43, 
  t3.descuento AS descuento44, 
  t3.aceptacondiciones AS aceptacondiciones45, 
  t3.distribuidor_id AS distribuidor_id46, 
  t5.gestorzona_id AS gestorzona_id47 
FROM 
  User t0 
  LEFT JOIN Distributor t1 ON t0.id = t1.id 
  LEFT JOIN admin t2 ON t0.id = t2.id 
  LEFT JOIN UserWeb t3 ON t0.id = t3.id 
  LEFT JOIN little t4 ON t0.id = t4.id 
  LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = 2;

"COMMIT"

"COMMIT";

SELECT 
  t0.id AS id1, 
  t0.texto AS texto2, 
  t0.coste AS coste3, 
  t0.textovisual AS textovisual4 
FROM 
  rangosserviciodomicilio t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.texto AS texto2, t0.coste AS coste3, t0.textovisual AS textovisual4 FROM rangosserviciodomicilio t0 WHERE t0.id = 2;

SELECT 
  t0.id AS id1, 
  t0.numeroPedido AS numeroPedido2, 
  t0.tipoPedido AS tipoPedido3, 
  t0.subNumeroPedido AS subNumeroPedido4, 
  t0.parcial AS parcial5, 
  t0.stringnumeropedido AS stringnumeropedido6, 
  t0.diasPedido AS diasPedido7, 
  t0.fechaCreacion AS fechaCreacion8, 
  t0.fechaEntrega AS fechaEntrega9, 
  t0.fechaDevolucion AS fechaDevolucion10, 
  t0.fechaEstimadaDevolucion AS fechaEstimadaDevolucion11, 
  t0.momentoentrega AS momentoentrega12, 
  t0.estado AS estado13, 
  t0.deposito AS deposito14, 
  t0.metodopago AS metodopago15, 
  t0.importecobrado AS importecobrado16, 
  t0.horaRecogidaCliente AS horaRecogidaCliente17, 
  t0.horaRecogidaDistribuidor AS horaRecogidaDistribuidor18, 
  t0.servicioExpress AS servicioExpress19, 
  t0.serviciodomicilio AS serviciodomicilio20, 
  t0.recogidadomicilio AS recogidadomicilio21, 
  t0.recogidadistribuidor AS recogidadistribuidor22, 
  t0.recogidacentral AS recogidacentral23, 
  t0.importeRecargo AS importeRecargo24, 
  t0.direccion AS direccion25, 
  t0.cp AS cp26, 
  t0.localidad AS localidad27, 
  t0.provincia AS provincia28, 
  t0.personacontacto AS personacontacto29, 
  t0.telefonodomicilio AS telefonodomicilio30, 
  t0.observaciones AS observaciones31, 
  t0.observacionesDevolucion AS observacionesDevolucion32, 
  t0.entregadopor AS entregadopor33, 
  t0.numeropedidointerno AS numeropedidointerno34, 
  t0.numeropedidointernotemporal AS numeropedidointernotemporal35, 
  t0.personaentrega AS personaentrega36, 
  t0.costeserviciodomicilio AS costeserviciodomicilio37, 
  t0.especial AS especial38, 
  t0.inicial AS inicial39, 
  t0.devuelta AS devuelta40, 
  t0.copia AS copia41, 
  t0.notas AS notas42, 
  t0.saltarCargoLogistico AS saltarCargoLogistico43, 
  t0.temporal AS temporal44, 
  t0.albaraninterno AS albaraninterno45, 
  t0.personarecoge AS personarecoge46, 
  t0.personarealizapedido AS personarealizapedido47, 
  t0.origen AS origen48, 
  t0.signature AS signature49, 
  t0.tokeninfoentrega AS tokeninfoentrega50, 
  t0.smsenviado AS smsenviado51, 
  t0.denysendSMStoclient AS denysendSMStoclient52, 
  t0.latitud AS latitud53, 
  t0.longitud AS longitud54, 
  t0.distribuidor_id AS distribuidor_id55, 
  t0.pago_id AS pago_id56, 
  t0.usuario_id AS usuario_id57, 
  t0.rangosserviciodomicilio_id AS rangosserviciodomicilio_id58, 
  t0.codigoPromocional_id AS codigoPromocional_id59 
FROM 
  Orders t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.numeroPedido AS numeroPedido2, t0.tipoPedido AS tipoPedido3, t0.subNumeroPedido AS subNumeroPedido4, t0.parcial AS parcial5, t0.stringnumeropedido AS stringnumeropedido6, t0.diasPedido AS diasPedido7, t0.fechaCreacion AS fechaCreacion8, t0.fechaEntrega AS fechaEntrega9, t0.fechaDevolucion AS fechaDevolucion10, t0.fechaEstimadaDevolucion AS fechaEstimadaDevolucion11, t0.momentoentrega AS momentoentrega12, t0.estado AS estado13, t0.deposito AS deposito14, t0.metodopago AS metodopago15, t0.importecobrado AS importecobrado16, t0.horaRecogidaCliente AS horaRecogidaCliente17, t0.horaRecogidaDistribuidor AS horaRecogidaDistribuidor18, t0.servicioExpress AS servicioExpress19, t0.serviciodomicilio AS serviciodomicilio20, t0.recogidadomicilio AS recogidadomicilio21, t0.recogidadistribuidor AS recogidadistribuidor22, t0.recogidacentral AS recogidacentral23, t0.importeRecargo AS importeRecargo24, t0.direccion AS direccion25, t0.cp AS cp26, t0.localidad AS localidad27, t0.provincia AS provincia28, t0.personacontacto AS personacontacto29, t0.telefonodomicilio AS telefonodomicilio30, t0.observaciones AS observaciones31, t0.observacionesDevolucion AS observacionesDevolucion32, t0.entregadopor AS entregadopor33, t0.numeropedidointerno AS numeropedidointerno34, t0.numeropedidointernotemporal AS numeropedidointernotemporal35, t0.personaentrega AS personaentrega36, t0.costeserviciodomicilio AS costeserviciodomicilio37, t0.especial AS especial38, t0.inicial AS inicial39, t0.devuelta AS devuelta40, t0.copia AS copia41, t0.notas AS notas42, t0.saltarCargoLogistico AS saltarCargoLogistico43, t0.temporal AS temporal44, t0.albaraninterno AS albaraninterno45, t0.personarecoge AS personarecoge46, t0.personarealizapedido AS personarealizapedido47, t0.origen AS origen48, t0.signature AS signature49, t0.tokeninfoentrega AS tokeninfoentrega50, t0.smsenviado AS smsenviado51, t0.denysendSMStoclient AS denysendSMStoclient52, t0.latitud AS latitud53, t0.longitud AS longitud54, t0.distribuidor_id AS distribuidor_id55, t0.pago_id AS pago_id56, t0.usuario_id AS usuario_id57, t0.rangosserviciodomicilio_id AS rangosserviciodomicilio_id58, t0.codigoPromocional_id AS codigoPromocional_id59 FROM Orders t0 WHERE t0.id = '44749';

SELECT 
  t0.id AS id4, 
  t0.nombre AS nombre5, 
  t0.nombreURL AS nombreURL6, 
  t0.fechaAlta AS fechaAlta7, 
  t0.codigo AS codigo8, 
  t0.pathqr AS pathqr9, 
  t0.descripcion AS descripcion10, 
  t0.especificaciones AS especificaciones11, 
  t0.eliminado AS eliminado12, 
  t0.stockTotal AS stockTotal13, 
  t0.stockReal AS stockReal14, 
  t0.mostrarPrincipal AS mostrarPrincipal15, 
  t0.title AS title16, 
  t0.metadescription AS metadescription17, 
  t0.activo AS activo18, 
  t0.md5qr AS md5qr19, 
  t0.subcategoria_id AS subcategoria_id20, 
  t0.tipoIVA_id AS tipoIVA_id21, 
  t0.tipo, 
  t1.precioDia AS precioDia22, 
  t1.fianza AS fianza23, 
  t1.descuento37 AS descuento3724, 
  t1.descuento830 AS descuento83025, 
  t1.descuento31 AS descuento3126, 
  t1.desgaste AS desgaste27, 
  t1.tipoDesgaste AS tipoDesgaste28, 
  t1.precioDesgaste AS precioDesgaste29, 
  t1.precioSuciedad AS precioSuciedad30, 
  t1.precioRecargo AS precioRecargo31, 
  t1.suplementoTorre AS suplementoTorre32, 
  t1.mostrarrotura AS mostrarrotura33, 
  t1.contrato_id AS contrato_id34, 
  t2.precio AS precio35, 
  t3.precio AS precio36 
FROM 
  Product t0 
  LEFT JOIN productalquiler t1 ON t0.id = t1.id 
  LEFT JOIN productconsumible t2 ON t0.id = t2.id 
  LEFT JOIN productsegundamano t3 ON t0.id = t3.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id4, t0.nombre AS nombre5, t0.nombreURL AS nombreURL6, t0.fechaAlta AS fechaAlta7, t0.codigo AS codigo8, t0.pathqr AS pathqr9, t0.descripcion AS descripcion10, t0.especificaciones AS especificaciones11, t0.eliminado AS eliminado12, t0.stockTotal AS stockTotal13, t0.stockReal AS stockReal14, t0.mostrarPrincipal AS mostrarPrincipal15, t0.title AS title16, t0.metadescription AS metadescription17, t0.activo AS activo18, t0.md5qr AS md5qr19, t0.subcategoria_id AS subcategoria_id20, t0.tipoIVA_id AS tipoIVA_id21, t0.tipo, t1.precioDia AS precioDia22, t1.fianza AS fianza23, t1.descuento37 AS descuento3724, t1.descuento830 AS descuento83025, t1.descuento31 AS descuento3126, t1.desgaste AS desgaste27, t1.tipoDesgaste AS tipoDesgaste28, t1.precioDesgaste AS precioDesgaste29, t1.precioSuciedad AS precioSuciedad30, t1.precioRecargo AS precioRecargo31, t1.suplementoTorre AS suplementoTorre32, t1.mostrarrotura AS mostrarrotura33, t1.contrato_id AS contrato_id34, t2.precio AS precio35, t3.precio AS precio36 FROM Product t0 LEFT JOIN productalquiler t1 ON t0.id = t1.id LEFT JOIN productconsumible t2 ON t0.id = t2.id LEFT JOIN productsegundamano t3 ON t0.id = t3.id WHERE t0.id = 147;

SELECT 
  t0.id AS id1, 
  t0.precio AS precio2, 
  t0.mostrardevolucionacero AS mostrardevolucionacero3, 
  t0.desgasteSalida AS desgasteSalida4, 
  t0.desgasteEntrada AS desgasteEntrada5, 
  t0.importeRotura AS importeRotura6, 
  t0.descripcionRotura AS descripcionRotura7, 
  t0.importeSuciedad AS importeSuciedad8, 
  t0.sucia AS sucia9, 
  t0.cantidad AS cantidad10, 
  t0.alquiler AS alquiler11, 
  t0.importeExpress AS importeExpress12, 
  t0.codigoMaquina AS codigoMaquina13, 
  t0.fechaDevolucion AS fechaDevolucion14, 
  t0.fechaAlarma AS fechaAlarma15, 
  t0.fechaEntrega AS fechaEntrega16, 
  t0.gestorZ_entrega AS gestorZ_entrega17, 
  t0.horassalida AS horassalida18, 
  t0.minutossalida AS minutossalida19, 
  t0.horasentrada AS horasentrada20, 
  t0.minutosentrada AS minutosentrada21, 
  t0.gestorZ_recogida AS gestorZ_recogida22, 
  t0.estadoOrderLine AS estadoOrderLine23, 
  t0.cantidaddevuelta AS cantidaddevuelta24, 
  t0.mostrar AS mostrar25, 
  t0.saltardiasminimos AS saltardiasminimos26, 
  t0.saltarfianza AS saltarfianza27, 
  t0.pagoiniciallinea AS pagoiniciallinea28, 
  t0.descripcion AS descripcion29, 
  t0.fechadevolucionorig AS fechadevolucionorig30, 
  t0.fechaentregaorig AS fechaentregaorig31, 
  t0.fechainicial AS fechainicial32, 
  t0.descuento AS descuento33, 
  t0.barCode AS barCode34, 
  t0.estarealquilada AS estarealquilada35, 
  t0.precioDiaActual AS precioDiaActual36, 
  t0.precioSuciedadActual AS precioSuciedadActual37, 
  t0.precioDesgasteActual AS precioDesgasteActual38, 
  t0.fotoEntrega AS fotoEntrega39, 
  t0.fotoRecogida AS fotoRecogida40, 
  t0.Orders_id AS Orders_id41, 
  t0.product_id AS product_id42, 
  t0.productorderlinecerrado_id AS productorderlinecerrado_id43, 
  t0.rotura_id AS rotura_id44, 
  t0.gestorZona_id AS gestorZona_id45, 
  t0.idlineacopia AS idlineacopia46, 
  t0.idlineaorigen AS idlineaorigen47 
FROM 
  OrderLine t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.precio AS precio2, t0.mostrardevolucionacero AS mostrardevolucionacero3, t0.desgasteSalida AS desgasteSalida4, t0.desgasteEntrada AS desgasteEntrada5, t0.importeRotura AS importeRotura6, t0.descripcionRotura AS descripcionRotura7, t0.importeSuciedad AS importeSuciedad8, t0.sucia AS sucia9, t0.cantidad AS cantidad10, t0.alquiler AS alquiler11, t0.importeExpress AS importeExpress12, t0.codigoMaquina AS codigoMaquina13, t0.fechaDevolucion AS fechaDevolucion14, t0.fechaAlarma AS fechaAlarma15, t0.fechaEntrega AS fechaEntrega16, t0.gestorZ_entrega AS gestorZ_entrega17, t0.horassalida AS horassalida18, t0.minutossalida AS minutossalida19, t0.horasentrada AS horasentrada20, t0.minutosentrada AS minutosentrada21, t0.gestorZ_recogida AS gestorZ_recogida22, t0.estadoOrderLine AS estadoOrderLine23, t0.cantidaddevuelta AS cantidaddevuelta24, t0.mostrar AS mostrar25, t0.saltardiasminimos AS saltardiasminimos26, t0.saltarfianza AS saltarfianza27, t0.pagoiniciallinea AS pagoiniciallinea28, t0.descripcion AS descripcion29, t0.fechadevolucionorig AS fechadevolucionorig30, t0.fechaentregaorig AS fechaentregaorig31, t0.fechainicial AS fechainicial32, t0.descuento AS descuento33, t0.barCode AS barCode34, t0.estarealquilada AS estarealquilada35, t0.precioDiaActual AS precioDiaActual36, t0.precioSuciedadActual AS precioSuciedadActual37, t0.precioDesgasteActual AS precioDesgasteActual38, t0.fotoEntrega AS fotoEntrega39, t0.fotoRecogida AS fotoRecogida40, t0.Orders_id AS Orders_id41, t0.product_id AS product_id42, t0.productorderlinecerrado_id AS productorderlinecerrado_id43, t0.rotura_id AS rotura_id44, t0.gestorZona_id AS gestorZona_id45, t0.idlineacopia AS idlineacopia46, t0.idlineaorigen AS idlineaorigen47 FROM OrderLine t0 WHERE t0.id = '86574';

SELECT 
  t0.id AS id1, 
  t0.precio AS precio2, 
  t0.mostrardevolucionacero AS mostrardevolucionacero3, 
  t0.desgasteSalida AS desgasteSalida4, 
  t0.desgasteEntrada AS desgasteEntrada5, 
  t0.importeRotura AS importeRotura6, 
  t0.descripcionRotura AS descripcionRotura7, 
  t0.importeSuciedad AS importeSuciedad8, 
  t0.sucia AS sucia9, 
  t0.cantidad AS cantidad10, 
  t0.alquiler AS alquiler11, 
  t0.importeExpress AS importeExpress12, 
  t0.codigoMaquina AS codigoMaquina13, 
  t0.fechaDevolucion AS fechaDevolucion14, 
  t0.fechaAlarma AS fechaAlarma15, 
  t0.fechaEntrega AS fechaEntrega16, 
  t0.gestorZ_entrega AS gestorZ_entrega17, 
  t0.horassalida AS horassalida18, 
  t0.minutossalida AS minutossalida19, 
  t0.horasentrada AS horasentrada20, 
  t0.minutosentrada AS minutosentrada21, 
  t0.gestorZ_recogida AS gestorZ_recogida22, 
  t0.estadoOrderLine AS estadoOrderLine23, 
  t0.cantidaddevuelta AS cantidaddevuelta24, 
  t0.mostrar AS mostrar25, 
  t0.saltardiasminimos AS saltardiasminimos26, 
  t0.saltarfianza AS saltarfianza27, 
  t0.pagoiniciallinea AS pagoiniciallinea28, 
  t0.descripcion AS descripcion29, 
  t0.fechadevolucionorig AS fechadevolucionorig30, 
  t0.fechaentregaorig AS fechaentregaorig31, 
  t0.fechainicial AS fechainicial32, 
  t0.descuento AS descuento33, 
  t0.barCode AS barCode34, 
  t0.estarealquilada AS estarealquilada35, 
  t0.precioDiaActual AS precioDiaActual36, 
  t0.precioSuciedadActual AS precioSuciedadActual37, 
  t0.precioDesgasteActual AS precioDesgasteActual38, 
  t0.fotoEntrega AS fotoEntrega39, 
  t0.fotoRecogida AS fotoRecogida40, 
  t0.Orders_id AS Orders_id41, 
  t0.product_id AS product_id42, 
  t0.productorderlinecerrado_id AS productorderlinecerrado_id43, 
  t0.rotura_id AS rotura_id44, 
  t0.gestorZona_id AS gestorZona_id45, 
  t0.idlineacopia AS idlineacopia46, 
  t0.idlineaorigen AS idlineaorigen47 
FROM 
  OrderLine t0 
WHERE 
  t0.Orders_id = ?

SELECT t0.id AS id1, t0.precio AS precio2, t0.mostrardevolucionacero AS mostrardevolucionacero3, t0.desgasteSalida AS desgasteSalida4, t0.desgasteEntrada AS desgasteEntrada5, t0.importeRotura AS importeRotura6, t0.descripcionRotura AS descripcionRotura7, t0.importeSuciedad AS importeSuciedad8, t0.sucia AS sucia9, t0.cantidad AS cantidad10, t0.alquiler AS alquiler11, t0.importeExpress AS importeExpress12, t0.codigoMaquina AS codigoMaquina13, t0.fechaDevolucion AS fechaDevolucion14, t0.fechaAlarma AS fechaAlarma15, t0.fechaEntrega AS fechaEntrega16, t0.gestorZ_entrega AS gestorZ_entrega17, t0.horassalida AS horassalida18, t0.minutossalida AS minutossalida19, t0.horasentrada AS horasentrada20, t0.minutosentrada AS minutosentrada21, t0.gestorZ_recogida AS gestorZ_recogida22, t0.estadoOrderLine AS estadoOrderLine23, t0.cantidaddevuelta AS cantidaddevuelta24, t0.mostrar AS mostrar25, t0.saltardiasminimos AS saltardiasminimos26, t0.saltarfianza AS saltarfianza27, t0.pagoiniciallinea AS pagoiniciallinea28, t0.descripcion AS descripcion29, t0.fechadevolucionorig AS fechadevolucionorig30, t0.fechaentregaorig AS fechaentregaorig31, t0.fechainicial AS fechainicial32, t0.descuento AS descuento33, t0.barCode AS barCode34, t0.estarealquilada AS estarealquilada35, t0.precioDiaActual AS precioDiaActual36, t0.precioSuciedadActual AS precioSuciedadActual37, t0.precioDesgasteActual AS precioDesgasteActual38, t0.fotoEntrega AS fotoEntrega39, t0.fotoRecogida AS fotoRecogida40, t0.Orders_id AS Orders_id41, t0.product_id AS product_id42, t0.productorderlinecerrado_id AS productorderlinecerrado_id43, t0.rotura_id AS rotura_id44, t0.gestorZona_id AS gestorZona_id45, t0.idlineacopia AS idlineacopia46, t0.idlineaorigen AS idlineaorigen47 FROM OrderLine t0 WHERE t0.Orders_id = 44749;

SELECT 
  m0_.id AS id0, 
  m0_.codigo AS codigo1, 
  m0_.numero AS numero2, 
  m0_.pedirCodigo AS pedirCodigo3, 
  m0_.estado AS estado4, 
  m0_.eliminada AS eliminada5, 
  m0_.barCode AS barCode6, 
  m0_.maquinaId AS maquinaId7, 
  m0_.ordersIdActual AS ordersIdActual8, 
  m0_.orderLineActual AS orderLineActual9, 
  m0_.ordersIdOld AS ordersIdOld10, 
  m0_.orderLineOld AS orderLineOld11 
FROM 
  maquina m0_ 
WHERE 
  m0_.orderLineActual = 86574 
  AND m0_.eliminada = 0

SELECT m0_.id AS id0, m0_.codigo AS codigo1, m0_.numero AS numero2, m0_.pedirCodigo AS pedirCodigo3, m0_.estado AS estado4, m0_.eliminada AS eliminada5, m0_.barCode AS barCode6, m0_.maquinaId AS maquinaId7, m0_.ordersIdActual AS ordersIdActual8, m0_.orderLineActual AS orderLineActual9, m0_.ordersIdOld AS ordersIdOld10, m0_.orderLineOld AS orderLineOld11 FROM maquina m0_ WHERE m0_.orderLineActual = 86574 AND m0_.eliminada = 0;

UPDATE 
  OrderLine 
SET 
  fechaDevolucion = ?, 
  fechaAlarma = ? 
WHERE 
  id = ?

UPDATE OrderLine SET fechaDevolucion = '2025-09-29 07:32:00', fechaAlarma = '2025-09-29 07:32:00' WHERE id = 86574;

"START TRANSACTION"

"START TRANSACTION";