Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.clave AS clave_2,
  t0.valor AS valor_3,
  t0.descripcion AS descripcion_4,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.fecha_modificacion AS fecha_modificacion_6,
  t0.grupo_listas_precios_id AS grupo_listas_precios_id_7
FROM
  configuracion_general t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.clave AS clave_2, t0.valor AS valor_3, t0.descripcion AS descripcion_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_modificacion AS fecha_modificacion_6, t0.grupo_listas_precios_id AS grupo_listas_precios_id_7 FROM configuracion_general t0 WHERE t0.id = 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  catalogoprecio_producto c0_
  INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id
  INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id
  INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id
  INNER JOIN productos p4_ ON c0_.productos_id = p4_.id
WHERE
  g2_.id = ?
  AND p4_.visible = 1
  AND p4_.is_active = 1
  AND c0_.productos_id IS NOT NULL

SELECT COUNT(c0_.id) AS sclr_0 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN productos p4_ ON c0_.productos_id = p4_.id WHERE g2_.id = 5 AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.productos_id IS NOT NULL;

SELECT
  c0_.id AS id_0,
  c0_.precio AS precio_1,
  c0_.codigointegracion AS codigointegracion_2,
  c0_.catalogoprecio_id AS catalogoprecio_id_3,
  c0_.productos_id AS productos_id_4,
  c0_.paqueteproducto_id AS paqueteproducto_id_5,
  c0_.condicionesvariante_id AS condicionesvariante_id_6
FROM
  catalogoprecio_producto c0_
  INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id
  INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id
  INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id
  INNER JOIN productos p4_ ON c0_.productos_id = p4_.id
WHERE
  g2_.id = ?
  AND p4_.visible = 1
  AND p4_.is_active = 1
  AND c0_.productos_id IS NOT NULL

SELECT c0_.id AS id_0, c0_.precio AS precio_1, c0_.codigointegracion AS codigointegracion_2, c0_.catalogoprecio_id AS catalogoprecio_id_3, c0_.productos_id AS productos_id_4, c0_.paqueteproducto_id AS paqueteproducto_id_5, c0_.condicionesvariante_id AS condicionesvariante_id_6 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN productos p4_ ON c0_.productos_id = p4_.id WHERE g2_.id = 5 AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.productos_id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 90;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 91;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 93;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 94;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 95;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 97;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 98;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 99;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 WHERE t0.id = 81;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  catalogoprecio_producto c0_
  INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id
  INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id
  INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id
  INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id
WHERE
  g2_.id = ?
  AND p4_.visible = 1
  AND p4_.is_active = 1
  AND c0_.paqueteproducto_id IS NOT NULL

SELECT COUNT(c0_.id) AS sclr_0 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id WHERE g2_.id = 5 AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.paqueteproducto_id IS NOT NULL;

SELECT
  c0_.id AS id_0,
  c0_.precio AS precio_1,
  c0_.codigointegracion AS codigointegracion_2,
  c0_.catalogoprecio_id AS catalogoprecio_id_3,
  c0_.productos_id AS productos_id_4,
  c0_.paqueteproducto_id AS paqueteproducto_id_5,
  c0_.condicionesvariante_id AS condicionesvariante_id_6
FROM
  catalogoprecio_producto c0_
  INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id
  INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id
  INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id
  INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id
WHERE
  g2_.id = ?
  AND p4_.visible = 1
  AND p4_.is_active = 1
  AND c0_.paqueteproducto_id IS NOT NULL

SELECT c0_.id AS id_0, c0_.precio AS precio_1, c0_.codigointegracion AS codigointegracion_2, c0_.catalogoprecio_id AS catalogoprecio_id_3, c0_.productos_id AS productos_id_4, c0_.paqueteproducto_id AS paqueteproducto_id_5, c0_.condicionesvariante_id AS condicionesvariante_id_6 FROM catalogoprecio_producto c0_ INNER JOIN catalogoprecio c1_ ON c0_.catalogoprecio_id = c1_.id INNER JOIN grupo_listas_precios_catalogoprecio g3_ ON c1_.id = g3_.catalogoprecio_id INNER JOIN grupo_listas_precios g2_ ON g2_.id = g3_.grupo_listas_precios_id INNER JOIN paqueteproducto p4_ ON c0_.paqueteproducto_id = p4_.id WHERE g2_.id = 5 AND p4_.visible = 1 AND p4_.is_active = 1 AND c0_.paqueteproducto_id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.requiere_agenda AS requiere_agenda_9,
  t0.categoriaproducto_id AS categoriaproducto_id_10,
  t0.tipoproducto_id AS tipoproducto_id_11,
  t0.subtipoproducto_id AS subtipoproducto_id_12
FROM
  paqueteproducto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.requiere_agenda AS requiere_agenda_9, t0.categoriaproducto_id AS categoriaproducto_id_10, t0.tipoproducto_id AS tipoproducto_id_11, t0.subtipoproducto_id AS subtipoproducto_id_12 FROM paqueteproducto t0 WHERE t0.id = 31;