Symfony Profiler

SELECT
  t0.m_product_id AS m_product_id_1,
  t0.ad_client_id AS ad_client_id_2,
  t0.ad_org_id AS ad_org_id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.sm_marca_id AS sm_marca_id_6,
  t0.sku AS sku_7,
  t0.value AS value_8,
  t0.m_product_category_id AS m_product_category_id_9,
  t0.isactive AS isactive_10,
  t0.issold AS issold_11,
  t0.sm_modelo_producto_id AS sm_modelo_producto_id_12,
  t0.created AS created_13,
  t0.createdby AS createdby_14,
  t0.updated AS updated_15,
  t0.updatedby AS updatedby_16,
  t0.c_taxcategory_id AS c_taxcategory_id_17,
  t0.c_uom_id AS c_uom_id_18,
  t0.issummary AS issummary_19,
  t0.allegation AS allegation_20,
  t0.sm_characteristicset_id AS sm_characteristicset_id_21,
  t0.m_attributeset_id AS m_attributeset_id_22,
  t0.comercialname AS comercialname_23,
  t0.m_attributesetinstance_id AS m_attributesetinstance_id_24,
  t0.iswebstorefeatured AS iswebstorefeatured_25,
  t0.discontinued AS discontinued_26,
  t0.sm_marca_id AS sm_marca_id_27,
  t0.m_product_category_id AS m_product_category_id_28,
  t0.sm_modelo_producto_id AS sm_modelo_producto_id_29,
  t0.createdby AS createdby_30,
  t0.sm_characteristicset_id AS sm_characteristicset_id_31,
  t0.m_attributeset_id AS m_attributeset_id_32,
  t0.m_attributesetinstance_id AS m_attributesetinstance_id_33
FROM
  M_Product t0
WHERE
  t0.sm_marca_id = ?

SELECT t0.m_product_id AS m_product_id_1, t0.ad_client_id AS ad_client_id_2, t0.ad_org_id AS ad_org_id_3, t0.name AS name_4, t0.description AS description_5, t0.sm_marca_id AS sm_marca_id_6, t0.sku AS sku_7, t0.value AS value_8, t0.m_product_category_id AS m_product_category_id_9, t0.isactive AS isactive_10, t0.issold AS issold_11, t0.sm_modelo_producto_id AS sm_modelo_producto_id_12, t0.created AS created_13, t0.createdby AS createdby_14, t0.updated AS updated_15, t0.updatedby AS updatedby_16, t0.c_taxcategory_id AS c_taxcategory_id_17, t0.c_uom_id AS c_uom_id_18, t0.issummary AS issummary_19, t0.allegation AS allegation_20, t0.sm_characteristicset_id AS sm_characteristicset_id_21, t0.m_attributeset_id AS m_attributeset_id_22, t0.comercialname AS comercialname_23, t0.m_attributesetinstance_id AS m_attributesetinstance_id_24, t0.iswebstorefeatured AS iswebstorefeatured_25, t0.discontinued AS discontinued_26, t0.sm_marca_id AS sm_marca_id_27, t0.m_product_category_id AS m_product_category_id_28, t0.sm_modelo_producto_id AS sm_modelo_producto_id_29, t0.createdby AS createdby_30, t0.sm_characteristicset_id AS sm_characteristicset_id_31, t0.m_attributeset_id AS m_attributeset_id_32, t0.m_attributesetinstance_id AS m_attributesetinstance_id_33 FROM M_Product t0 WHERE t0.sm_marca_id = 1000000;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      DISTINCT mp.m_product_id
    FROM
      adempiere.m_product mp
      JOIN adempiere.sm_marca sm ON sm.sm_marca_id = mp.sm_marca_id
      JOIN adempiere.m_product_category mpc ON mpc.m_product_category_id = mp.m_product_category_id
      LEFT JOIN LATERAL (
        SELECT
          SUM(s.qtyonhand) AS qtyonhand,
          SUM(s.qtyordered) AS qtyordered
        FROM
          adempiere.m_storage s
          JOIN adempiere.m_locator l ON l.m_locator_id = s.m_locator_id
        WHERE
          s.m_product_id = mp.m_product_id
          AND l.m_warehouse_id = :warehouseId
      ) ms ON true
      LEFT JOIN LATERAL (
        SELECT
          pp.pricelimit,
          pp.price,
          pp.pricelist,
          pp.pricestd,
          ve.validfrom
        FROM
          adempiere.m_pricelist lp
          JOIN adempiere.m_pricelist_version ve ON ve.m_pricelist_version_id = (
            SELECT
              ve2.m_pricelist_version_id
            FROM
              adempiere.m_pricelist_version ve2
            WHERE
              ve2.m_pricelist_id = lp.m_pricelist_id
              AND ve2.isweb = 'Y'
            ORDER BY
              ve2.validfrom DESC,
              ve2.m_pricelist_version_id DESC
            LIMIT
              1
          ) JOIN adempiere.m_productprice pp ON pp.m_pricelist_version_id = ve.m_pricelist_version_id
          AND pp.m_product_id = mp.m_product_id
        WHERE
          lp.issopricelist = 'Y'
          AND (
            (
              sm.sm_marca_id IN (
                :brandPriceListBrand1000010_0, :brandPriceListBrand1000010_1,
                :brandPriceListBrand1000010_2,
                :brandPriceListBrand1000010_3,
                :brandPriceListBrand1000010_4
              )
              AND lp.m_pricelist_id = :brandPriceList1000010
            )
            OR (
              sm.sm_marca_id IN (:brandPriceListBrand1000011_0)
              AND lp.m_pricelist_id = :brandPriceList1000011
            )
          )
        LIMIT
          1
      ) pricing ON true
      LEFT JOIN LATERAL (
        SELECT
          d.downloadurl
        FROM
          adempiere.m_productdownload d
        WHERE
          d.m_product_id = mp.m_product_id
          AND d.iscatalog = 'Y'
          AND d.isonline = 'Y'
        ORDER BY
          d.m_productdownload_id DESC
        LIMIT
          1
      ) mp2 ON true
    WHERE
      1 = 1
      AND COALESCE(
        NULLIF(
          UPPER(
            TRIM(mp.iswebstorefeatured)
          ),
          ''
        ),
        'N'
      ) = 'Y'
  ) t

SELECT COUNT(*)
            FROM (
                SELECT DISTINCT mp.m_product_id
                
            FROM adempiere.m_product mp
            JOIN adempiere.sm_marca sm
                ON sm.sm_marca_id = mp.sm_marca_id
            JOIN adempiere.m_product_category mpc
                ON mpc.m_product_category_id = mp.m_product_category_id
            LEFT JOIN LATERAL (
                SELECT
                    SUM(s.qtyonhand)  AS qtyonhand,
                    SUM(s.qtyordered) AS qtyordered
                FROM adempiere.m_storage s
                JOIN adempiere.m_locator l
                    ON l.m_locator_id = s.m_locator_id
                WHERE s.m_product_id = mp.m_product_id
                  AND l.m_warehouse_id = 1000003
            ) ms ON true
            LEFT JOIN LATERAL (
                SELECT
                    pp.pricelimit,
                    pp.price,
                    pp.pricelist,
                    pp.pricestd,
                    ve.validfrom
                FROM adempiere.m_pricelist lp
                JOIN adempiere.m_pricelist_version ve
                    ON ve.m_pricelist_version_id = (
                        SELECT ve2.m_pricelist_version_id
                        FROM adempiere.m_pricelist_version ve2
                        WHERE ve2.m_pricelist_id = lp.m_pricelist_id
                          AND ve2.isweb = 'Y'
                        ORDER BY ve2.validfrom DESC, ve2.m_pricelist_version_id DESC
                        LIMIT 1
                    )
                JOIN adempiere.m_productprice pp
                    ON pp.m_pricelist_version_id = ve.m_pricelist_version_id
                   AND pp.m_product_id = mp.m_product_id
                WHERE lp.issopricelist = 'Y'
                  AND ((sm.sm_marca_id IN (1000000, 1000002, 1000003, 1000008, 1000009) AND lp.m_pricelist_id = 1000010) OR (sm.sm_marca_id IN (1000004) AND lp.m_pricelist_id = 1000011))
                LIMIT 1
            ) pricing ON true
            LEFT JOIN LATERAL (
                SELECT d.downloadurl
                FROM adempiere.m_productdownload d
                WHERE d.m_product_id = mp.m_product_id
                  AND d.iscatalog = 'Y'
                  AND d.isonline = 'Y'
                ORDER BY d.m_productdownload_id DESC
                LIMIT 1
            ) mp2 ON true
        
                WHERE 1=1 AND COALESCE(NULLIF(UPPER(TRIM(mp.iswebstorefeatured)), ''), 'N') = 'Y'
            ) t
        ;

SELECT
  t0.m_product_category_id AS m_product_category_id_1,
  t0.ad_client_id AS ad_client_id_2,
  t0.name AS name_3,
  t0.isactive AS isactive_4,
  t0.value AS value_5,
  t0.m_product_category_parent_id AS m_product_category_parent_id_6
FROM
  m_product_category t0
WHERE
  t0.m_product_category_id = ?

SELECT t0.m_product_category_id AS m_product_category_id_1, t0.ad_client_id AS ad_client_id_2, t0.name AS name_3, t0.isactive AS isactive_4, t0.value AS value_5, t0.m_product_category_parent_id AS m_product_category_parent_id_6 FROM m_product_category t0 WHERE t0.m_product_category_id = 1000002;

SELECT
  mp.m_product_id,
  pricing.validfrom,
  mp.value AS code,
  mp.sku,
  mp.name,
  mp.comercialname,
  mp.allegation,
  ms.qtyonhand,
  ms.qtyordered,
  (
    CASE WHEN mp.sm_marca_id = 1000004 THEN
      1000000
    ELSE
      sm.sm_marca_id
    END
  ) AS sm_marca_id,
  mp2.downloadurl,
  pricing.pricelimit,
  pricing.price,
  pricing.pricelist,
  pricing.pricestd,
  CASE WHEN mp.sm_marca_id = 1000004 THEN
    'GPLUS'
  ELSE
    sm.name
  END AS brand_name,
  CASE WHEN mp.sm_marca_id = 1000004 THEN
    'COCINA'
  ELSE
    mpc.name
  END AS category_name,
  (
    CASE WHEN mp.sm_marca_id = 1000004 THEN
      1000014
    ELSE
      mp.m_product_category_id
    END
  ) AS m_product_category_id
FROM
  adempiere.m_product mp
  JOIN adempiere.sm_marca sm ON sm.sm_marca_id = mp.sm_marca_id
  JOIN adempiere.m_product_category mpc ON mpc.m_product_category_id = mp.m_product_category_id
  LEFT JOIN LATERAL (
    SELECT
      SUM(s.qtyonhand) AS qtyonhand,
      SUM(s.qtyordered) AS qtyordered
    FROM
      adempiere.m_storage s
      JOIN adempiere.m_locator l ON l.m_locator_id = s.m_locator_id
    WHERE
      s.m_product_id = mp.m_product_id
      AND l.m_warehouse_id = :warehouseId
  ) ms ON true
  LEFT JOIN LATERAL (
    SELECT
      pp.pricelimit,
      pp.price,
      pp.pricelist,
      pp.pricestd,
      ve.validfrom
    FROM
      adempiere.m_pricelist lp
      JOIN adempiere.m_pricelist_version ve ON ve.m_pricelist_version_id = (
        SELECT
          ve2.m_pricelist_version_id
        FROM
          adempiere.m_pricelist_version ve2
        WHERE
          ve2.m_pricelist_id = lp.m_pricelist_id
          AND ve2.isweb = 'Y'
        ORDER BY
          ve2.validfrom DESC,
          ve2.m_pricelist_version_id DESC
        LIMIT
          1
      ) JOIN adempiere.m_productprice pp ON pp.m_pricelist_version_id = ve.m_pricelist_version_id
      AND pp.m_product_id = mp.m_product_id
    WHERE
      lp.issopricelist = 'Y'
      AND (
        (
          sm.sm_marca_id IN (
            :brandPriceListBrand1000010_0, :brandPriceListBrand1000010_1,
            :brandPriceListBrand1000010_2,
            :brandPriceListBrand1000010_3,
            :brandPriceListBrand1000010_4
          )
          AND lp.m_pricelist_id = :brandPriceList1000010
        )
        OR (
          sm.sm_marca_id IN (:brandPriceListBrand1000011_0)
          AND lp.m_pricelist_id = :brandPriceList1000011
        )
      )
    LIMIT
      1
  ) pricing ON true
  LEFT JOIN LATERAL (
    SELECT
      d.downloadurl
    FROM
      adempiere.m_productdownload d
    WHERE
      d.m_product_id = mp.m_product_id
      AND d.iscatalog = 'Y'
      AND d.isonline = 'Y'
    ORDER BY
      d.m_productdownload_id DESC
    LIMIT
      1
  ) mp2 ON true
WHERE
  1 = 1
  AND COALESCE(
    NULLIF(
      UPPER(
        TRIM(mp.iswebstorefeatured)
      ),
      ''
    ),
    'N'
  ) = 'Y'
ORDER BY
  mp.comercialname ASC
LIMIT
  :length
OFFSET
  :start

SELECT
                mp.m_product_id,
                pricing.validfrom,
                mp.value AS code,
                mp.sku,
                mp.name,
                mp.comercialname,
                mp.allegation,
                ms.qtyonhand,
                ms.qtyordered,
                (CASE WHEN mp.sm_marca_id = 1000004 THEN 1000000 ELSE sm.sm_marca_id END) AS sm_marca_id,
                mp2.downloadurl,
                pricing.pricelimit,
                pricing.price,
                pricing.pricelist,
                pricing.pricestd,
                CASE WHEN mp.sm_marca_id = 1000004 THEN 'GPLUS' ELSE sm.name END AS brand_name,
                CASE WHEN mp.sm_marca_id = 1000004 THEN 'COCINA' ELSE mpc.name END AS category_name,
                (CASE WHEN mp.sm_marca_id = 1000004 THEN 1000014 ELSE mp.m_product_category_id END) AS m_product_category_id
            
            FROM adempiere.m_product mp
            JOIN adempiere.sm_marca sm
                ON sm.sm_marca_id = mp.sm_marca_id
            JOIN adempiere.m_product_category mpc
                ON mpc.m_product_category_id = mp.m_product_category_id
            LEFT JOIN LATERAL (
                SELECT
                    SUM(s.qtyonhand)  AS qtyonhand,
                    SUM(s.qtyordered) AS qtyordered
                FROM adempiere.m_storage s
                JOIN adempiere.m_locator l
                    ON l.m_locator_id = s.m_locator_id
                WHERE s.m_product_id = mp.m_product_id
                  AND l.m_warehouse_id = 1000003
            ) ms ON true
            LEFT JOIN LATERAL (
                SELECT
                    pp.pricelimit,
                    pp.price,
                    pp.pricelist,
                    pp.pricestd,
                    ve.validfrom
                FROM adempiere.m_pricelist lp
                JOIN adempiere.m_pricelist_version ve
                    ON ve.m_pricelist_version_id = (
                        SELECT ve2.m_pricelist_version_id
                        FROM adempiere.m_pricelist_version ve2
                        WHERE ve2.m_pricelist_id = lp.m_pricelist_id
                          AND ve2.isweb = 'Y'
                        ORDER BY ve2.validfrom DESC, ve2.m_pricelist_version_id DESC
                        LIMIT 1
                    )
                JOIN adempiere.m_productprice pp
                    ON pp.m_pricelist_version_id = ve.m_pricelist_version_id
                   AND pp.m_product_id = mp.m_product_id
                WHERE lp.issopricelist = 'Y'
                  AND ((sm.sm_marca_id IN (1000000, 1000002, 1000003, 1000008, 1000009) AND lp.m_pricelist_id = 1000010) OR (sm.sm_marca_id IN (1000004) AND lp.m_pricelist_id = 1000011))
                LIMIT 1
            ) pricing ON true
            LEFT JOIN LATERAL (
                SELECT d.downloadurl
                FROM adempiere.m_productdownload d
                WHERE d.m_product_id = mp.m_product_id
                  AND d.iscatalog = 'Y'
                  AND d.isonline = 'Y'
                ORDER BY d.m_productdownload_id DESC
                LIMIT 1
            ) mp2 ON true
        
            WHERE 1=1 AND COALESCE(NULLIF(UPPER(TRIM(mp.iswebstorefeatured)), ''), 'N') = 'Y'
            ORDER BY mp.comercialname ASC
            LIMIT 1000 OFFSET 0
        ;

SELECT
  pel.m_product_id --, age(min(pel.created)) AS creado_minimo
FROM
  sm_precio_estimadoline pel
  JOIN sm_precio_estimado spe ON spe.sm_precio_estimado_id = pel.sm_precio_estimado_id
WHERE
  pel.listo = 'Y'
  AND spe.docstatus = 'Y' --AND pel.m_product_id = :m_product_id
GROUP BY
  pel.m_product_id
HAVING
  min(pel.created) > ?
ORDER BY
  pel.m_product_id;

SELECT
    pel.m_product_id
    --, age(min(pel.created)) AS creado_minimo
FROM sm_precio_estimadoline pel
JOIN sm_precio_estimado spe
    ON spe.sm_precio_estimado_id = pel.sm_precio_estimado_id
WHERE
    pel.listo = 'Y' 
    AND spe.docstatus = 'Y'
    --AND pel.m_product_id = '2025-10-22 05:16:52'
GROUP BY pel.m_product_id
HAVING min(pel.created) > ?
ORDER BY pel.m_product_id;;

SELECT
  sm_m_promotion_id as id,
  "name",
  description,
  m_pricelist_id as listaPrecioId,
  sm_marca_id,
  startdate as fechaInicio,
  enddate as fechaFin,
  qty,
  qtylimit,
  qtymax,
  qtymaxseller,
  (
    SELECT
      COALESCE(
        SUM(
          (
            CASE WHEN qtybook = 0 THEN
              1
            ELSE
              qtybook
            END
          ) * amt
        ),
        0
      )
    FROM
      sm_m_promotionprecondition precondition
    WHERE
      precondition.sm_m_promotion_id = sm_m_promotion.sm_m_promotion_id
  ) AS "Amt"
FROM
  sm_m_promotion
WHERE
  isactive = 'Y'
  AND NOW() BETWEEN "startdate"
  AND (
    "enddate" :: date + interval '1 day' - interval '1 second'
  )

SELECT sm_m_promotion_id as id, "name", description, m_pricelist_id as listaPrecioId, sm_marca_id, startdate as fechaInicio, enddate as fechaFin, qty, qtylimit, qtymax, qtymaxseller, (SELECT COALESCE(SUM((CASE WHEN qtybook = 0 THEN 1 ELSE qtybook END) * amt), 0) FROM sm_m_promotionprecondition precondition WHERE precondition.sm_m_promotion_id = sm_m_promotion.sm_m_promotion_id) AS "Amt" FROM sm_m_promotion WHERE isactive = 'Y' AND NOW() BETWEEN "startdate" AND ("enddate"::date + interval '1 day' - interval '1 second');

SELECT
  t0.sm_marca_id AS sm_marca_id_1,
  t0.sm_marca_uu AS sm_marca_uu_2,
  t0.ad_client_id AS ad_client_id_3,
  t0.ad_org_id AS ad_org_id_4,
  t0.name AS name_5,
  t0.isactive AS isactive_6,
  t0.sm_bp_item_id AS sm_bp_item_id_7,
  t0.issold AS issold_8,
  t0.IsWeb AS isweb_9
FROM
  sm_marca t0
WHERE
  t0.IsWeb = ?

SELECT t0.sm_marca_id AS sm_marca_id_1, t0.sm_marca_uu AS sm_marca_uu_2, t0.ad_client_id AS ad_client_id_3, t0.ad_org_id AS ad_org_id_4, t0.name AS name_5, t0.isactive AS isactive_6, t0.sm_bp_item_id AS sm_bp_item_id_7, t0.issold AS issold_8, t0.IsWeb AS isweb_9 FROM sm_marca t0 WHERE t0.IsWeb = 'Y';