Symfony Profiler

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id0 
    FROM 
      (
        SELECT 
          p0_.id AS id0, 
          p0_.nombre AS nombre1, 
          p0_.nombreURL AS nombreURL2, 
          p0_.fechaAlta AS fechaAlta3, 
          p0_.codigo AS codigo4, 
          p0_.pathqr AS pathqr5, 
          p0_.descripcion AS descripcion6, 
          p0_.especificaciones AS especificaciones7, 
          p0_.eliminado AS eliminado8, 
          p0_.stockTotal AS stockTotal9, 
          p0_.stockReal AS stockReal10, 
          p0_.mostrarPrincipal AS mostrarPrincipal11, 
          p0_.title AS title12, 
          p0_.metadescription AS metadescription13, 
          p0_.activo AS activo14, 
          p0_.md5qr AS md5qr15, 
          p1_.precioDia AS precioDia16, 
          p1_.fianza AS fianza17, 
          p1_.descuento37 AS descuento3718, 
          p1_.descuento830 AS descuento83019, 
          p1_.descuento31 AS descuento3120, 
          p1_.desgaste AS desgaste21, 
          p1_.tipoDesgaste AS tipoDesgaste22, 
          p1_.precioDesgaste AS precioDesgaste23, 
          p1_.precioSuciedad AS precioSuciedad24, 
          p1_.precioRecargo AS precioRecargo25, 
          p1_.suplementoTorre AS suplementoTorre26, 
          p1_.mostrarrotura AS mostrarrotura27, 
          p0_.tipo AS tipo28 
        FROM 
          productalquiler p1_ 
          INNER JOIN Product p0_ ON p1_.id = p0_.id 
        WHERE 
          p0_.activo = 1
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id0 FROM (SELECT p0_.id AS id0, p0_.nombre AS nombre1, p0_.nombreURL AS nombreURL2, p0_.fechaAlta AS fechaAlta3, p0_.codigo AS codigo4, p0_.pathqr AS pathqr5, p0_.descripcion AS descripcion6, p0_.especificaciones AS especificaciones7, p0_.eliminado AS eliminado8, p0_.stockTotal AS stockTotal9, p0_.stockReal AS stockReal10, p0_.mostrarPrincipal AS mostrarPrincipal11, p0_.title AS title12, p0_.metadescription AS metadescription13, p0_.activo AS activo14, p0_.md5qr AS md5qr15, p1_.precioDia AS precioDia16, p1_.fianza AS fianza17, p1_.descuento37 AS descuento3718, p1_.descuento830 AS descuento83019, p1_.descuento31 AS descuento3120, p1_.desgaste AS desgaste21, p1_.tipoDesgaste AS tipoDesgaste22, p1_.precioDesgaste AS precioDesgaste23, p1_.precioSuciedad AS precioSuciedad24, p1_.precioRecargo AS precioRecargo25, p1_.suplementoTorre AS suplementoTorre26, p1_.mostrarrotura AS mostrarrotura27, p0_.tipo AS tipo28 FROM productalquiler p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id WHERE p0_.activo = 1) dctrn_result) dctrn_table;

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

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

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

SELECT 
  p0_.id AS id0, 
  p0_.nombre AS nombre1, 
  p0_.nombreURL AS nombreURL2, 
  p0_.fechaAlta AS fechaAlta3, 
  p0_.codigo AS codigo4, 
  p0_.pathqr AS pathqr5, 
  p0_.descripcion AS descripcion6, 
  p0_.especificaciones AS especificaciones7, 
  p0_.eliminado AS eliminado8, 
  p0_.stockTotal AS stockTotal9, 
  p0_.stockReal AS stockReal10, 
  p0_.mostrarPrincipal AS mostrarPrincipal11, 
  p0_.title AS title12, 
  p0_.metadescription AS metadescription13, 
  p0_.activo AS activo14, 
  p0_.md5qr AS md5qr15, 
  p1_.precioDia AS precioDia16, 
  p1_.fianza AS fianza17, 
  p1_.descuento37 AS descuento3718, 
  p1_.descuento830 AS descuento83019, 
  p1_.descuento31 AS descuento3120, 
  p1_.desgaste AS desgaste21, 
  p1_.tipoDesgaste AS tipoDesgaste22, 
  p1_.precioDesgaste AS precioDesgaste23, 
  p1_.precioSuciedad AS precioSuciedad24, 
  p1_.precioRecargo AS precioRecargo25, 
  p1_.suplementoTorre AS suplementoTorre26, 
  p1_.mostrarrotura AS mostrarrotura27, 
  p0_.tipo AS tipo28, 
  p0_.subcategoria_id AS subcategoria_id29, 
  p0_.tipoIVA_id AS tipoIVA_id30, 
  p1_.contrato_id AS contrato_id31 
FROM 
  productalquiler p1_ 
  INNER JOIN Product p0_ ON p1_.id = p0_.id 
WHERE 
  p0_.activo = 1 
  AND p0_.id IN (?)

SELECT p0_.id AS id0, p0_.nombre AS nombre1, p0_.nombreURL AS nombreURL2, p0_.fechaAlta AS fechaAlta3, p0_.codigo AS codigo4, p0_.pathqr AS pathqr5, p0_.descripcion AS descripcion6, p0_.especificaciones AS especificaciones7, p0_.eliminado AS eliminado8, p0_.stockTotal AS stockTotal9, p0_.stockReal AS stockReal10, p0_.mostrarPrincipal AS mostrarPrincipal11, p0_.title AS title12, p0_.metadescription AS metadescription13, p0_.activo AS activo14, p0_.md5qr AS md5qr15, p1_.precioDia AS precioDia16, p1_.fianza AS fianza17, p1_.descuento37 AS descuento3718, p1_.descuento830 AS descuento83019, p1_.descuento31 AS descuento3120, p1_.desgaste AS desgaste21, p1_.tipoDesgaste AS tipoDesgaste22, p1_.precioDesgaste AS precioDesgaste23, p1_.precioSuciedad AS precioSuciedad24, p1_.precioRecargo AS precioRecargo25, p1_.suplementoTorre AS suplementoTorre26, p1_.mostrarrotura AS mostrarrotura27, p0_.tipo AS tipo28, p0_.subcategoria_id AS subcategoria_id29, p0_.tipoIVA_id AS tipoIVA_id30, p1_.contrato_id AS contrato_id31 FROM productalquiler p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id WHERE p0_.activo = 1 AND p0_.id IN ('3', '4', '6', '7', '8', '10', '11', '13', '14', '16');

SELECT 
  DISTINCT id0 
FROM 
  (
    SELECT 
      p0_.id AS id0, 
      p0_.nombre AS nombre1, 
      p0_.nombreURL AS nombreURL2, 
      p0_.fechaAlta AS fechaAlta3, 
      p0_.codigo AS codigo4, 
      p0_.pathqr AS pathqr5, 
      p0_.descripcion AS descripcion6, 
      p0_.especificaciones AS especificaciones7, 
      p0_.eliminado AS eliminado8, 
      p0_.stockTotal AS stockTotal9, 
      p0_.stockReal AS stockReal10, 
      p0_.mostrarPrincipal AS mostrarPrincipal11, 
      p0_.title AS title12, 
      p0_.metadescription AS metadescription13, 
      p0_.activo AS activo14, 
      p0_.md5qr AS md5qr15, 
      p1_.precioDia AS precioDia16, 
      p1_.fianza AS fianza17, 
      p1_.descuento37 AS descuento3718, 
      p1_.descuento830 AS descuento83019, 
      p1_.descuento31 AS descuento3120, 
      p1_.desgaste AS desgaste21, 
      p1_.tipoDesgaste AS tipoDesgaste22, 
      p1_.precioDesgaste AS precioDesgaste23, 
      p1_.precioSuciedad AS precioSuciedad24, 
      p1_.precioRecargo AS precioRecargo25, 
      p1_.suplementoTorre AS suplementoTorre26, 
      p1_.mostrarrotura AS mostrarrotura27, 
      p0_.tipo AS tipo28 
    FROM 
      productalquiler p1_ 
      INNER JOIN Product p0_ ON p1_.id = p0_.id 
    WHERE 
      p0_.activo = 1
  ) dctrn_result 
LIMIT 
  10 OFFSET 0

SELECT DISTINCT id0 FROM (SELECT p0_.id AS id0, p0_.nombre AS nombre1, p0_.nombreURL AS nombreURL2, p0_.fechaAlta AS fechaAlta3, p0_.codigo AS codigo4, p0_.pathqr AS pathqr5, p0_.descripcion AS descripcion6, p0_.especificaciones AS especificaciones7, p0_.eliminado AS eliminado8, p0_.stockTotal AS stockTotal9, p0_.stockReal AS stockReal10, p0_.mostrarPrincipal AS mostrarPrincipal11, p0_.title AS title12, p0_.metadescription AS metadescription13, p0_.activo AS activo14, p0_.md5qr AS md5qr15, p1_.precioDia AS precioDia16, p1_.fianza AS fianza17, p1_.descuento37 AS descuento3718, p1_.descuento830 AS descuento83019, p1_.descuento31 AS descuento3120, p1_.desgaste AS desgaste21, p1_.tipoDesgaste AS tipoDesgaste22, p1_.precioDesgaste AS precioDesgaste23, p1_.precioSuciedad AS precioSuciedad24, p1_.precioRecargo AS precioRecargo25, p1_.suplementoTorre AS suplementoTorre26, p1_.mostrarrotura AS mostrarrotura27, p0_.tipo AS tipo28 FROM productalquiler p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id WHERE p0_.activo = 1) dctrn_result LIMIT 10 OFFSET 0;

SELECT 
  t1.id AS id2, 
  t1.firstname AS firstname3, 
  t1.lastname AS lastname4, 
  t1.email AS email5, 
  t1.username AS username6, 
  t1.password AS password7, 
  t1.nif AS nif8, 
  t1.company AS company9, 
  t1.address AS address10, 
  t1.cp AS cp11, 
  t1.localidad AS localidad12, 
  t1.provincia AS provincia13, 
  t1.comunity AS comunity14, 
  t1.phone AS phone15, 
  t1.mphone AS mphone16, 
  t1.salt AS salt17, 
  t1.rol AS rol18, 
  t1.codigorecuperacion AS codigorecuperacion19, 
  t1.pathdnifrontal AS pathdnifrontal20, 
  t1.pathdnitrasera AS pathdnitrasera21, 
  t1.pathfoto AS pathfoto22, 
  t1.pathrgpdfirmadofisico AS pathrgpdfirmadofisico23, 
  t1.pathrgpdfirma AS pathrgpdfirma24, 
  t1.firmadorgpdelectronico AS firmadorgpdelectronico25, 
  t1.tieneCuenta AS tieneCuenta26, 
  t1.tipoFianza AS tipoFianza27, 
  t1.activo AS activo28, 
  t1.bloqueado AS bloqueado29, 
  t1.expirado AS expirado30, 
  t0.gestorzona_id AS gestorzona_id31, 
  t1.tipo 
FROM 
  gestorZonaUser t0 
  INNER JOIN User t1 ON t0.id = t1.id 
WHERE 
  t0.gestorzona_id = ?

SELECT t1.id AS id2, t1.firstname AS firstname3, t1.lastname AS lastname4, t1.email AS email5, t1.username AS username6, t1.password AS password7, t1.nif AS nif8, t1.company AS company9, t1.address AS address10, t1.cp AS cp11, t1.localidad AS localidad12, t1.provincia AS provincia13, t1.comunity AS comunity14, t1.phone AS phone15, t1.mphone AS mphone16, t1.salt AS salt17, t1.rol AS rol18, t1.codigorecuperacion AS codigorecuperacion19, t1.pathdnifrontal AS pathdnifrontal20, t1.pathdnitrasera AS pathdnitrasera21, t1.pathfoto AS pathfoto22, t1.pathrgpdfirmadofisico AS pathrgpdfirmadofisico23, t1.pathrgpdfirma AS pathrgpdfirma24, t1.firmadorgpdelectronico AS firmadorgpdelectronico25, t1.tieneCuenta AS tieneCuenta26, t1.tipoFianza AS tipoFianza27, t1.activo AS activo28, t1.bloqueado AS bloqueado29, t1.expirado AS expirado30, t0.gestorzona_id AS gestorzona_id31, t1.tipo FROM gestorZonaUser t0 INNER JOIN User t1 ON t0.id = t1.id WHERE t0.gestorzona_id = 6;

SELECT 
  t0.id AS id1, 
  t0.nombre AS nombre2, 
  t0.telefono AS telefono3, 
  t0.email AS email4 
FROM 
  gestorZona t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id1, t0.nombre AS nombre2, t0.telefono AS telefono3, t0.email AS email4 FROM gestorZona t0 WHERE t0.id = '6';