Symfony Profiler

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 69006;

SELECT
  *
FROM
  object_store_prod
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_prod WHERE oo_id = 69006 FOR UPDATE;

SELECT
  *
FROM
  assets_image_thumbnail_cache
WHERE
  cid = ?

SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4574046;

SELECT
  customSettings
FROM
  assets
WHERE
  id = ?

SELECT customSettings FROM assets WHERE id = 4574046;

SELECT
  SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id,
  priceSystemName
FROM
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
WHERE
  active = 1
  AND virtualProductActive = 1
  AND inProductList = 1
  AND (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
  AND a.id != virtualProductId
  AND (
    parentCategoryIds like '%,22237,%'
  )
  AND (
    IFNULL(isSalesItem, 0) = 0
  )
GROUP BY
  virtualProductId,
  priceSystemName
ORDER BY
  min(
    ifnull(featuredPriority, 0)
  ) desc,
  min(
    (promotions like '%#new#%')
  ) desc,
  min(
    ifnull(s.score, 0)
  ) desc,
  min(
    ifnull(rankingMultiplicator, 999999999)
  ) asc,
  min(`a`.`id`) ASC
LIMIT
  120, 24

SELECT SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id, priceSystemName  FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND a.id != virtualProductId  AND (parentCategoryIds like '%,22237,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY virtualProductId, priceSystemName ORDER BY min(ifnull(featuredPriority, 0)) desc,min((promotions like '%#new#%')) desc,min(ifnull(s.score, 0)) desc,min(ifnull(rankingMultiplicator, 999999999)) asc,min(`a`.`id`) ASC LIMIT 120, 24;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68043'
      and a.id != '68043'
    )
    or parentProducts like '%,68043,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68043' and a.id != '68043') or parentProducts like '%,68043,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68047'
      and a.id != '68047'
    )
    or parentProducts like '%,68047,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68047' and a.id != '68047') or parentProducts like '%,68047,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '87575'
      and a.id != '87575'
    )
    or parentProducts like '%,87575,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '87575' and a.id != '87575') or parentProducts like '%,87575,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68083'
      and a.id != '68083'
    )
    or parentProducts like '%,68083,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68083' and a.id != '68083') or parentProducts like '%,68083,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68084'
      and a.id != '68084'
    )
    or parentProducts like '%,68084,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68084' and a.id != '68084') or parentProducts like '%,68084,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68048'
      and a.id != '68048'
    )
    or parentProducts like '%,68048,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68048' and a.id != '68048') or parentProducts like '%,68048,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68045'
      and a.id != '68045'
    )
    or parentProducts like '%,68045,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68045' and a.id != '68045') or parentProducts like '%,68045,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68073'
      and a.id != '68073'
    )
    or parentProducts like '%,68073,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68073' and a.id != '68073') or parentProducts like '%,68073,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68074'
      and a.id != '68074'
    )
    or parentProducts like '%,68074,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68074' and a.id != '68074') or parentProducts like '%,68074,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '23654'
      and a.id != '23654'
    )
    or parentProducts like '%,23654,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '23654' and a.id != '23654') or parentProducts like '%,23654,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68046'
      and a.id != '68046'
    )
    or parentProducts like '%,68046,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68046' and a.id != '68046') or parentProducts like '%,68046,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '87584'
      and a.id != '87584'
    )
    or parentProducts like '%,87584,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '87584' and a.id != '87584') or parentProducts like '%,87584,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68082'
      and a.id != '68082'
    )
    or parentProducts like '%,68082,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68082' and a.id != '68082') or parentProducts like '%,68082,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '23653'
      and a.id != '23653'
    )
    or parentProducts like '%,23653,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '23653' and a.id != '23653') or parentProducts like '%,23653,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '23652'
      and a.id != '23652'
    )
    or parentProducts like '%,23652,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '23652' and a.id != '23652') or parentProducts like '%,23652,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68072'
      and a.id != '68072'
    )
    or parentProducts like '%,68072,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc

select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '68072' and a.id != '68072') or parentProducts like '%,68072,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL)
            group by color
            order by maxMainProductInLine desc
        ;

select
  a.*,
  max(mainProductInLine) as maxMainProductInLine,
  group_concat(
    a.id
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as ids,
  group_concat(
    a.mainImageId
    order by
      a.mainProductInLine desc,
      a.mainColorProductInLine desc
  ) as mainImageIds
from
  ecommerceframework_productindex_wdbe_nl a
  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id
  LEFT OUTER JOIN (
    SELECT
      targetId,
      score
    FROM
      app_customer_aggregated_score
    WHERE
      name = 'sellable'
      AND customerId is null
  ) AS s ON s.targetId = a.id
where
  active = 1
  and virtualProductActive = 1
  and (
    (
      virtualProductId = '68044'
      and a.id != '68044'
    )
    or parentProducts like '%,68044,%'
  )
  and IFNULL(isSalesItem, 0) = 0
  and (
    b.subtenant_id = 2
    AND isCombinedProduct != 1
    OR isCombinedProduct IS NULL
  )
group by
  color
order by
  maxMainProductInLine desc