Symfony Profiler

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.nameURL AS nameURL3, 
  t0.codigo AS codigo4, 
  t0.title AS title5, 
  t0.metadescription AS metadescription6, 
  t0.category_id AS category_id7 
FROM 
  Subcategory t0 
WHERE 
  t0.category_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6, t0.category_id AS category_id7 FROM Subcategory t0 WHERE t0.category_id = 1;

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_.subcategoria_id = 40

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_.subcategoria_id = 40;

SELECT 
  s0_.id AS id0, 
  s0_.name AS name1, 
  s0_.nameURL AS nameURL2, 
  s0_.codigo AS codigo3, 
  s0_.title AS title4, 
  s0_.metadescription AS metadescription5, 
  s0_.category_id AS category_id6 
FROM 
  Subcategory s0_ 
WHERE 
  s0_.nameURL = 'GeneradoresVapor'

SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'GeneradoresVapor';

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_.precio AS precio16, 
  p0_.tipo AS tipo17, 
  p0_.subcategoria_id AS subcategoria_id18, 
  p0_.tipoIVA_id AS tipoIVA_id19 
FROM 
  productconsumible p1_ 
  INNER JOIN Product p0_ ON p1_.id = p0_.id 
WHERE 
  p0_.activo = 1 
  AND p0_.subcategoria_id = 40

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_.precio AS precio16, p0_.tipo AS tipo17, p0_.subcategoria_id AS subcategoria_id18, p0_.tipoIVA_id AS tipoIVA_id19 FROM productconsumible p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id WHERE p0_.activo = 1 AND p0_.subcategoria_id = 40;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.nameURL AS nameURL3, 
  t0.codigo AS codigo4, 
  t0.title AS title5, 
  t0.metadescription AS metadescription6 
FROM 
  Category t0

SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0;