Symfony Profiler

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;

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

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 alquilertoalquiler ON t0.id = alquilertoalquiler.relation_product_id 
WHERE 
  alquilertoalquiler.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 alquilertoalquiler ON t0.id = alquilertoalquiler.relation_product_id WHERE alquilertoalquiler.product_id = 138 ORDER BY t1.nombre ASC;

SELECT 
  o0_.id AS id0, 
  o0_.precio AS precio1, 
  o0_.mostrardevolucionacero AS mostrardevolucionacero2, 
  o0_.desgasteSalida AS desgasteSalida3, 
  o0_.desgasteEntrada AS desgasteEntrada4, 
  o0_.importeRotura AS importeRotura5, 
  o0_.descripcionRotura AS descripcionRotura6, 
  o0_.importeSuciedad AS importeSuciedad7, 
  o0_.sucia AS sucia8, 
  o0_.cantidad AS cantidad9, 
  o0_.alquiler AS alquiler10, 
  o0_.importeExpress AS importeExpress11, 
  o0_.codigoMaquina AS codigoMaquina12, 
  o0_.fechaDevolucion AS fechaDevolucion13, 
  o0_.fechaAlarma AS fechaAlarma14, 
  o0_.fechaEntrega AS fechaEntrega15, 
  o0_.gestorZ_entrega AS gestorZ_entrega16, 
  o0_.horassalida AS horassalida17, 
  o0_.minutossalida AS minutossalida18, 
  o0_.horasentrada AS horasentrada19, 
  o0_.minutosentrada AS minutosentrada20, 
  o0_.gestorZ_recogida AS gestorZ_recogida21, 
  o0_.estadoOrderLine AS estadoOrderLine22, 
  o0_.cantidaddevuelta AS cantidaddevuelta23, 
  o0_.mostrar AS mostrar24, 
  o0_.saltardiasminimos AS saltardiasminimos25, 
  o0_.saltarfianza AS saltarfianza26, 
  o0_.pagoiniciallinea AS pagoiniciallinea27, 
  o0_.descripcion AS descripcion28, 
  o0_.fechadevolucionorig AS fechadevolucionorig29, 
  o0_.fechaentregaorig AS fechaentregaorig30, 
  o0_.fechainicial AS fechainicial31, 
  o0_.descuento AS descuento32, 
  o0_.barCode AS barCode33, 
  o0_.estarealquilada AS estarealquilada34, 
  o0_.precioDiaActual AS precioDiaActual35, 
  o0_.precioSuciedadActual AS precioSuciedadActual36, 
  o0_.precioDesgasteActual AS precioDesgasteActual37, 
  o0_.fotoEntrega AS fotoEntrega38, 
  o0_.fotoRecogida AS fotoRecogida39, 
  o0_.Orders_id AS Orders_id40, 
  o0_.product_id AS product_id41, 
  o0_.productorderlinecerrado_id AS productorderlinecerrado_id42, 
  o0_.rotura_id AS rotura_id43, 
  o0_.gestorZona_id AS gestorZona_id44, 
  o0_.idlineacopia AS idlineacopia45, 
  o0_.idlineaorigen AS idlineaorigen46 
FROM 
  OrderLine o0_ 
WHERE 
  (
    o0_.estadoOrderLine = 'alquilado' 
    OR o0_.estadoOrderLine = 'recogida' 
    OR o0_.estadoOrderLine = 'pendiente' 
    OR o0_.estadoOrderLine = 'preparacion' 
    OR o0_.estadoOrderLine = 'entregadistribuidor' 
    OR o0_.estadoOrderLine = 'enviado'
  ) 
  AND o0_.product_id = 371 
  AND o0_.fechaDevolucion >= '2025-10-02 00:00:00'

SELECT o0_.id AS id0, o0_.precio AS precio1, o0_.mostrardevolucionacero AS mostrardevolucionacero2, o0_.desgasteSalida AS desgasteSalida3, o0_.desgasteEntrada AS desgasteEntrada4, o0_.importeRotura AS importeRotura5, o0_.descripcionRotura AS descripcionRotura6, o0_.importeSuciedad AS importeSuciedad7, o0_.sucia AS sucia8, o0_.cantidad AS cantidad9, o0_.alquiler AS alquiler10, o0_.importeExpress AS importeExpress11, o0_.codigoMaquina AS codigoMaquina12, o0_.fechaDevolucion AS fechaDevolucion13, o0_.fechaAlarma AS fechaAlarma14, o0_.fechaEntrega AS fechaEntrega15, o0_.gestorZ_entrega AS gestorZ_entrega16, o0_.horassalida AS horassalida17, o0_.minutossalida AS minutossalida18, o0_.horasentrada AS horasentrada19, o0_.minutosentrada AS minutosentrada20, o0_.gestorZ_recogida AS gestorZ_recogida21, o0_.estadoOrderLine AS estadoOrderLine22, o0_.cantidaddevuelta AS cantidaddevuelta23, o0_.mostrar AS mostrar24, o0_.saltardiasminimos AS saltardiasminimos25, o0_.saltarfianza AS saltarfianza26, o0_.pagoiniciallinea AS pagoiniciallinea27, o0_.descripcion AS descripcion28, o0_.fechadevolucionorig AS fechadevolucionorig29, o0_.fechaentregaorig AS fechaentregaorig30, o0_.fechainicial AS fechainicial31, o0_.descuento AS descuento32, o0_.barCode AS barCode33, o0_.estarealquilada AS estarealquilada34, o0_.precioDiaActual AS precioDiaActual35, o0_.precioSuciedadActual AS precioSuciedadActual36, o0_.precioDesgasteActual AS precioDesgasteActual37, o0_.fotoEntrega AS fotoEntrega38, o0_.fotoRecogida AS fotoRecogida39, o0_.Orders_id AS Orders_id40, o0_.product_id AS product_id41, o0_.productorderlinecerrado_id AS productorderlinecerrado_id42, o0_.rotura_id AS rotura_id43, o0_.gestorZona_id AS gestorZona_id44, o0_.idlineacopia AS idlineacopia45, o0_.idlineaorigen AS idlineaorigen46 FROM OrderLine o0_ WHERE (o0_.estadoOrderLine = 'alquilado' OR o0_.estadoOrderLine = 'recogida' OR o0_.estadoOrderLine = 'pendiente' OR o0_.estadoOrderLine = 'preparacion' OR o0_.estadoOrderLine = 'entregadistribuidor' OR o0_.estadoOrderLine = 'enviado') AND o0_.product_id = 371 AND o0_.fechaDevolucion >= '2025-10-02 00:00:00';

SELECT 
  t0.id AS id1, 
  t0.diasminimos AS diasminimos2, 
  t0.productalquiler_id AS productalquiler_id3, 
  t0.categoriadistribuidor_id AS categoriadistribuidor_id4 
FROM 
  alquilercategoriadistribuidor t0 
WHERE 
  t0.productalquiler_id = ?

SELECT t0.id AS id1, t0.diasminimos AS diasminimos2, t0.productalquiler_id AS productalquiler_id3, t0.categoriadistribuidor_id AS categoriadistribuidor_id4 FROM alquilercategoriadistribuidor t0 WHERE t0.productalquiler_id = 371;

SELECT 
  SUM(o0_.cantidad) AS sclr0 
FROM 
  OrderLine o0_ 
WHERE 
  (
    o0_.estadoOrderLine = 'revision' 
    OR o0_.estadoOrderLine = 'entregadistribuidor' 
    OR o0_.estadoOrderLine = 'alquilado' 
    OR o0_.estadoOrderLine = 'recogida' 
    OR o0_.estadoOrderLine = 'preparacion' 
    OR o0_.estadoOrderLine = 'enviado' 
    OR (
      (
        o0_.estadoOrderLine = 'pendiente'
      ) 
      AND o0_.fechaEntrega <= '2025-10-03 23:59:59 ' 
      AND o0_.fechaDevolucion >= '2025-10-01 00:00:00'
    )
  ) 
  AND o0_.Orders_id <> -1 
  AND o0_.product_id = 371

SELECT SUM(o0_.cantidad) AS sclr0 FROM OrderLine o0_ WHERE (o0_.estadoOrderLine = 'revision' OR o0_.estadoOrderLine = 'entregadistribuidor' OR o0_.estadoOrderLine = 'alquilado' OR o0_.estadoOrderLine = 'recogida' OR o0_.estadoOrderLine = 'preparacion' OR o0_.estadoOrderLine = 'enviado' OR ((o0_.estadoOrderLine = 'pendiente') AND o0_.fechaEntrega <= '2025-10-03 23:59:59 ' AND o0_.fechaDevolucion >= '2025-10-01 00:00:00')) AND o0_.Orders_id <> -1 AND o0_.product_id = 371;

SELECT 
  SUM(o0_.cantidad) AS sclr0 
FROM 
  OrderLine o0_ 
WHERE 
  (
    o0_.estadoOrderLine = 'revision' 
    OR o0_.estadoOrderLine = 'entregadistribuidor' 
    OR o0_.estadoOrderLine = 'alquilado' 
    OR o0_.estadoOrderLine = 'recogida' 
    OR o0_.estadoOrderLine = 'preparacion' 
    OR o0_.estadoOrderLine = 'enviado' 
    OR (
      (
        o0_.estadoOrderLine = 'pendiente'
      ) 
      AND o0_.fechaEntrega <= '2025-10-03 23:59:59 ' 
      AND o0_.fechaDevolucion >= '2025-10-01 00:00:00'
    )
  ) 
  AND o0_.Orders_id <> -1 
  AND o0_.product_id = 371

SELECT SUM(o0_.cantidad) AS sclr0 FROM OrderLine o0_ WHERE (o0_.estadoOrderLine = 'revision' OR o0_.estadoOrderLine = 'entregadistribuidor' OR o0_.estadoOrderLine = 'alquilado' OR o0_.estadoOrderLine = 'recogida' OR o0_.estadoOrderLine = 'preparacion' OR o0_.estadoOrderLine = 'enviado' OR ((o0_.estadoOrderLine = 'pendiente') AND o0_.fechaEntrega <= '2025-10-03 23:59:59 ' AND o0_.fechaDevolucion >= '2025-10-01 00:00:00')) AND o0_.Orders_id <> -1 AND o0_.product_id = 371;

SELECT 
  t0.id AS id1, 
  t0.descripcion AS descripcion2, 
  t0.coste AS coste3, 
  t0.eliminada AS eliminada4, 
  t0.productalquiler_id AS productalquiler_id5 
FROM 
  rotura t0 
WHERE 
  t0.productalquiler_id = ?

SELECT t0.id AS id1, t0.descripcion AS descripcion2, t0.coste AS coste3, t0.eliminada AS eliminada4, t0.productalquiler_id AS productalquiler_id5 FROM rotura t0 WHERE t0.productalquiler_id = 371;

SELECT 
  t0.id AS id1, 
  t0.path AS path2, 
  t0.titulo AS titulo3, 
  t0.product_id AS product_id4 
FROM 
  Images t0 
WHERE 
  t0.product_id = ?

SELECT t0.id AS id1, t0.path AS path2, t0.titulo AS titulo3, t0.product_id AS product_id4 FROM Images t0 WHERE t0.product_id = 371;

SELECT 
  t0.id AS id1, 
  t0.tipoIva AS tipoIva2, 
  t0.valor AS valor3, 
  t0.recargo AS recargo4, 
  t0.eliminado AS eliminado5 
FROM 
  TipoIVA t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.tipoIva AS tipoIva2, t0.valor AS valor3, t0.recargo AS recargo4, t0.eliminado AS eliminado5 FROM TipoIVA t0 WHERE t0.id = '1';