Symfony Profiler

Query Metrics

561 Database Queries

61 Different statements

1108.54 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_localized_SCONF_de.id as id, object_localized_SCONF_de.type as `type` FROM object_localized_SCONF_de LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_de `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_de `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_de`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_de.type IN ('object','variant','folder')) AND object_localized_SCONF_de.published = 1 LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_SCONF WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,22225,22218,1548,1544) AND inheritable = 1)
                         OR cid = ? ) AND ctype='object'
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT id FROM classes WHERE name = ?
SELECT * FROM object_relations_prod WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object','variant','folder')) AND object_localized_8_de.published = 1
SELECT name FROM classes WHERE id = ?
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT name FROM classes WHERE id = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM translations_admin LIMIT 1;
SELECT * FROM documents_editables WHERE documentId = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_PCAT WHERE src_id = ?
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
SELECT SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id, priceSystemName  FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') 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 24
SELECT FOUND_ROWS()
SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`)
SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`)
SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`)
SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest
SELECT name FROM classes WHERE id = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`)
SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`)
SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`)
SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`)
SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`)
SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`)
SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`)
SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`)
SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`)
SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`)
SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest
SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`)
SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`)
SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`)
SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`)
SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`)
SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`)
SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`)
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182338' and a.id != '182338') or parentProducts like '%,182338,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182339' and a.id != '182339') or parentProducts like '%,182339,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182310' and a.id != '182310') or parentProducts like '%,182310,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182342' and a.id != '182342') or parentProducts like '%,182342,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182341' and a.id != '182341') or parentProducts like '%,182341,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '25042' and a.id != '25042') or parentProducts like '%,25042,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49047' and a.id != '49047') or parentProducts like '%,49047,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17362' and a.id != '17362') or parentProducts like '%,17362,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '23674' and a.id != '23674') or parentProducts like '%,23674,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '28016' and a.id != '28016') or parentProducts like '%,28016,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '24983' and a.id != '24983') or parentProducts like '%,24983,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26147' and a.id != '26147') or parentProducts like '%,26147,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26148' and a.id != '26148') or parentProducts like '%,26148,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49045' and a.id != '49045') or parentProducts like '%,49045,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17449' and a.id != '17449') or parentProducts like '%,17449,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17452' and a.id != '17452') or parentProducts like '%,17452,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '68109' and a.id != '68109') or parentProducts like '%,68109,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '22719' and a.id != '22719') or parentProducts like '%,22719,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17451' and a.id != '17451') or parentProducts like '%,17451,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17346' and a.id != '17346') or parentProducts like '%,17346,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '24987' and a.id != '24987') or parentProducts like '%,24987,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17447' and a.id != '17447') or parentProducts like '%,17447,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17347' and a.id != '17347') or parentProducts like '%,17347,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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_de a  INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '23671' and a.id != '23671') or parentProducts like '%,23671,%') 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 customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?

#▲	Time	Info
1	0.42 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
2	1.01 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/de/produkte/c/wandleuchten~22227" "path" "auto_create" "/de/produkte/c/wandleuchten~22227" "path_query" "https://testing.weverducre.com/de/produkte/c/wandleuchten~22227" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 1 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/produkte/c/wandleuchten~22227' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/produkte/c/wandleuchten~22227' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/de/produkte/c/wandleuchten~22227' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC;
3	0.69 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
4	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
5	1.30 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/de/produkte/c/" "wandleuchten~22227"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/weverducre.com/de/produkte/c/' AND `key` = BINARY 'wandleuchten~22227';
6	0.32 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/de/produkte/c/wandleuchten~22227"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/weverducre.com/de/produkte/c/wandleuchten~22227';
7	1.37 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/weverducre.com/%" "/de/produkte/c/wandleuchten~22227"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/weverducre.com/%' AND documents_page.prettyUrl = '/de/produkte/c/wandleuchten~22227';
8	0.23 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/de/produkte/" "c"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/weverducre.com/de/produkte/' AND `key` = BINARY 'c';
9	0.61 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/de/produkte/c"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/weverducre.com/de/produkte/c';
10	0.41 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/weverducre.com/%" "/de/produkte/c"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/weverducre.com/%' AND documents_page.prettyUrl = '/de/produkte/c';
11	0.57 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/de/" "produkte"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/weverducre.com/de/' AND `key` = BINARY 'produkte';
12	0.41 ms	SELECT object_localized_SCONF_de.id as id, object_localized_SCONF_de.type as `type` FROM object_localized_SCONF_de LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_de `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_de `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_de`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?)) AND object_localized_SCONF_de.type IN ('object','variant','folder')) AND object_localized_SCONF_de.published = 1 LIMIT 1 Parameters: [`"wdbe" "wdbe"`] View formatted query View runnable query Explain query SELECT object_localized_SCONF_de.id as id, object_localized_SCONF_de.type as `type` FROM object_localized_SCONF_de LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_de `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_de `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_de`.id WHERE ( ( ( EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ? ) ) AND object_localized_SCONF_de.type IN ('object', 'variant', 'folder') ) AND object_localized_SCONF_de.published = 1 LIMIT 1 SELECT object_localized_SCONF_de.id as id, object_localized_SCONF_de.type as `type` FROM object_localized_SCONF_de LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_de `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_de`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_de `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_de`.id WHERE (((EcommerceB2B.dataAreaId = 'wdbe' or EcommerceB2C.dataAreaId = 'wdbe')) AND object_localized_SCONF_de.type IN ('object','variant','folder')) AND object_localized_SCONF_de.published = 1 LIMIT 1;
13	0.42 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SCONF"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SCONF';
14	0.62 ms	SELECT * FROM object_relations_SCONF WHERE src_id = ? Parameters: [`1547`] View formatted query View runnable query Explain query SELECT * FROM object_relations_SCONF WHERE src_id = ? SELECT * FROM object_relations_SCONF WHERE src_id = 1547;
15	6.10 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"prod"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'prod';
16	0.60 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"PCAT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'PCAT';
17	1.18 ms	SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,22225,22218,1548,1544) AND inheritable = 1) OR cid = ? ) AND ctype='object' Parameters: [`22227`] View formatted query View runnable query Explain query SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( ( cid IN (1, 22225, 22218, 1548, 1544) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'object' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,22225,22218,1548,1544) AND inheritable = 1) OR cid = 22227 ) AND ctype='object';
18	16.55 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
19	0.35 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
20	18.57 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
21	7.48 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
22	0.31 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
23	7.55 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
24	0.38 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
25	0.27 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
26	0.25 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
27	0.28 ms	SELECT id FROM classes WHERE name = ? Parameters: [`"Product"`] View formatted query View runnable query Explain query SELECT id FROM classes WHERE name = ? SELECT id FROM classes WHERE name = 'Product';
28	1.53 ms	SELECT * FROM object_relations_prod WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' Parameters: [`22227 "additionalCategories"`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object' SELECT * FROM object_relations_prod WHERE dest_id = 22227 AND fieldname = 'additionalCategories' AND ownertype = 'object';
29	0.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23654`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23654;
30	1.66 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87585`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87585;
31	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`164755`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 164755;
32	0.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`24983`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 24983;
33	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23677`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23677;
34	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120116`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120116;
35	0.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92853`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92853;
36	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92852`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92852;
37	0.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23652`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23652;
38	0.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17311`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17311;
39	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68090`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68090;
40	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`26150`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 26150;
41	0.34 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120117`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120117;
42	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`26148`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 26148;
43	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23375`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23375;
44	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87575`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87575;
45	0.34 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17368`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17368;
46	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17367`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17367;
47	5.75 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49051`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49051;
48	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17314`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17314;
49	0.30 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17322`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17322;
50	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17451`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17451;
51	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120120`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120120;
52	12.44 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23644`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23644;
53	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17461`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17461;
54	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23647`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23647;
55	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87586`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87586;
56	0.40 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`28016`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 28016;
57	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68109`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68109;
58	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87588`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87588;
59	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17332`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17332;
60	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68091`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68091;
61	0.31 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17361`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17361;
62	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17371`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17371;
63	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68088`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68088;
64	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`24987`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 24987;
65	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23679`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23679;
66	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23643`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23643;
67	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17438`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17438;
68	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17319`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17319;
69	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68072`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68072;
70	0.41 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92857`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92857;
71	4.45 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23660`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23660;
72	1.76 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120121`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120121;
73	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87573`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87573;
74	0.21 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`171537`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 171537;
75	0.38 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`25042`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 25042;
76	0.42 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49043`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49043;
77	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68062`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68062;
78	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68074`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68074;
79	0.22 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17318`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17318;
80	0.31 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49044`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49044;
81	0.40 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68093`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68093;
82	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17307`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17307;
83	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17347`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17347;
84	0.78 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23672`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23672;
85	0.21 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17346`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17346;
86	0.41 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68087`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68087;
87	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68077`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68077;
88	0.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23676`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23676;
89	3.55 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23678`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23678;
90	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68100`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68100;
91	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17315`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17315;
92	0.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87574`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87574;
93	0.23 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17452`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17452;
94	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68085`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68085;
95	0.49 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68082`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68082;
96	0.85 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49049`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49049;
97	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23664`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23664;
98	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23648`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23648;
99	0.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68086`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68086;
100	0.39 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68070`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68070;
101	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68105`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68105;
102	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120082`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120082;
103	0.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`26147`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 26147;
104	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87572`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87572;
105	1.43 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23658`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23658;
106	0.49 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87583`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87583;
107	2.04 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17310`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17310;
108	0.55 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87579`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87579;
109	2.19 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23655`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23655;
110	1.54 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23673`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23673;
111	0.24 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17356`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17356;
112	0.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120084`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120084;
113	0.76 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49047`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49047;
114	1.20 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23653`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23653;
115	3.65 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68101`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68101;
116	0.80 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17370`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17370;
117	0.50 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`24984`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 24984;
118	1.60 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23649`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23649;
119	2.14 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68061`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68061;
120	2.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17355`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17355;
121	2.93 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68078`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68078;
122	0.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`22719`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 22719;
123	0.46 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68102`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68102;
124	1.70 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120083`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120083;
125	5.74 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17440`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17440;
126	1.73 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23671`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23671;
127	9.70 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17334`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17334;
128	3.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17373`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17373;
129	3.45 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68073`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68073;
130	3.27 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23659`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23659;
131	2.66 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17342`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17342;
132	2.22 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`171544`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 171544;
133	2.93 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68083`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68083;
134	11.54 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17448`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17448;
135	7.07 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87577`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87577;
136	2.61 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23656`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23656;
137	10.21 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68107`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68107;
138	1.84 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68063`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68063;
139	2.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87581`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87581;
140	8.60 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87584`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87584;
141	6.02 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23674`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23674;
142	5.50 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`120119`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 120119;
143	1.18 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17449`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17449;
144	1.44 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17323`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17323;
145	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68084`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68084;
146	0.44 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17463`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17463;
147	0.70 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49045`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49045;
148	0.32 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68103`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68103;
149	1.62 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`171546`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 171546;
150	0.53 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17447`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17447;
151	0.46 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87582`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87582;
152	0.46 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17362`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17362;
153	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49042`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49042;
154	0.29 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17439`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17439;
155	0.55 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`182310`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 182310;
156	0.46 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68076`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68076;
157	11.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17320`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17320;
158	0.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87580`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87580;
159	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23651`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23651;
160	0.28 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23665`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23665;
161	0.56 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68106`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68106;
162	0.32 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`68110`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 68110;
163	1.02 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`26896`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 26896;
164	5.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49046`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49046;
165	0.32 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49050`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49050;
166	10.69 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17308`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17308;
167	0.51 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92855`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92855;
168	0.25 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17460`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17460;
169	0.39 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17341`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17341;
170	4.97 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92954`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92954;
171	6.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92956`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92956;
172	0.47 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92958`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92958;
173	9.75 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92960`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92960;
174	0.60 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92962`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92962;
175	1.26 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92964`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92964;
176	5.60 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92966`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92966;
177	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92968`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92968;
178	11.04 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92970`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92970;
179	12.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92972`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92972;
180	0.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92910`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92910;
181	0.43 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92913`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92913;
182	9.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92974`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92974;
183	0.45 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92917`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92917;
184	0.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92976`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92976;
185	9.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92921`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92921;
186	0.68 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92925`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92925;
187	0.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92929`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92929;
188	5.97 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92933`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92933;
189	0.49 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92937`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92937;
190	8.88 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92978`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92978;
191	12.10 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92980`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92980;
192	1.65 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92982`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92982;
193	0.44 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92984`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92984;
194	9.51 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92986`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92986;
195	0.49 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92988`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92988;
196	0.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92941`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92941;
197	0.48 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92944`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92944;
198	0.58 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92946`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92946;
199	0.46 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92948`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92948;
200	4.96 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92950`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92950;
201	1.02 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92952`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92952;
202	1.54 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92990`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92990;
203	3.08 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92992`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92992;
204	0.57 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92994`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92994;
205	0.43 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92996`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92996;
206	0.44 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92915`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92915;
207	0.59 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92919`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92919;
208	0.52 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92923`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92923;
209	0.68 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92927`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92927;
210	6.79 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92931`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92931;
211	1.47 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92935`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92935;
212	1.97 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92939`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92939;
213	0.63 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`92942`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 92942;
214	0.29 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
215	0.96 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
216	0.24 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
217	0.49 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
218	0.29 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 16;
219	0.33 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`120`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 120) AND published = 1 ORDER BY `index` ASC ;
220	0.33 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4574046`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4574046;
221	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4574046`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4574046;
222	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4538784`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4538784;
223	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4538784`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4538784;
224	0.26 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
225	0.79 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
226	0.41 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`41`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 41;
227	0.25 ms	SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object','variant','folder')) AND object_localized_8_de.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object', 'variant', 'folder') ) AND object_localized_8_de.published = 1 SELECT object_localized_8_de.id as id, object_localized_8_de.type as `type` FROM object_localized_8_de WHERE ( object_localized_8_de.type IN ('object','variant','folder')) AND object_localized_8_de.published = 1;
228	0.29 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '8';
229	0.22 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1288`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 1288) AND published = 1 ORDER BY `index` ASC ;
230	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`797541`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 797541;
231	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`797541`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 797541;
232	0.25 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"7"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '7';
233	0.27 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`3737995`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 3737995;
234	0.23 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`3737995`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3737995;
235	0.27 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
236	0.65 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
237	0.26 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 38;
238	0.23 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`566`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 566) AND published = 1 ORDER BY `index` ASC ;
239	0.21 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`34`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 34) AND published = 1 ORDER BY `index` ASC ;
240	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5042933`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5042933;
241	0.23 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5042933`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5042933;
242	0.23 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2203379`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2203379;
243	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2203379`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2203379;
244	0.22 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
245	0.60 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
246	0.27 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`39`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 39;
247	0.22 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`25`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 25) AND published = 1 ORDER BY `index` ASC ;
248	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`3737893`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 3737893;
249	0.23 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`3737893`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3737893;
250	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`3737897`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 3737897;
251	0.21 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`3737897`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 3737897;
252	0.30 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
253	0.25 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
254	0.22 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 11;
255	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_FD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_FD';
256	0.30 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22227`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22227;
257	0.43 ms	SELECT * FROM object_relations_EF_FD WHERE src_id = ? Parameters: [`26083`] View formatted query View runnable query Explain query SELECT * FROM object_relations_EF_FD WHERE src_id = ? SELECT * FROM object_relations_EF_FD WHERE src_id = 26083;
258	0.25 ms	SELECT * FROM object_relations_EF_FD WHERE src_id = ? Parameters: [`1551`] View formatted query View runnable query Explain query SELECT * FROM object_relations_EF_FD WHERE src_id = ? SELECT * FROM object_relations_EF_FD WHERE src_id = 1551;
259	15.22 ms	SELECT SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id, priceSystemName FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') 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 24 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id, priceSystemName FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) 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 24 SELECT SQL_CALC_FOUND_ROWS DISTINCT virtualProductId as id, priceSystemName FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') 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 24;
260	0.29 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
261	12.99 ms	SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`scopeName`) SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`);
262	14.40 ms	SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`typeName`) SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`);
263	14.44 ms	SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lampType`) SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`);
264	14.86 ms	SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN ( SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) ) GROUP BY dest SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest;
265	0.30 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"SOPT"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'SOPT';
266	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187931`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187931;
267	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187931`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187931;
268	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187954`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187954;
269	0.23 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187954`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187954;
270	0.27 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187960`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187960;
271	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187960`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187960;
272	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188002`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188002;
273	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188002`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188002;
274	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188008`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188008;
275	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188008`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188008;
276	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188007`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188007;
277	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188007`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188007;
278	0.24 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188006`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188006;
279	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188006`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188006;
280	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188010`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188010;
281	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188010`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188010;
282	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`188004`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 188004;
283	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`188004`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 188004;
284	10.29 ms	SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lightColorTemperature`) SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`);
285	8.49 ms	SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`diameter`) SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`);
286	9.21 ms	SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`ipRating`) SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`);
287	8.60 ms	SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`converterText`) SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`);
288	6.96 ms	SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`recessedDepth`) SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`);
289	6.79 ms	SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`cutOutMin`) SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`);
290	6.71 ms	SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`cutOutMax`) SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`);
291	0.27 ms	SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`scopeName`) SELECT TRIM(`scopeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`scopeName`);
292	0.23 ms	SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`typeName`) SELECT TRIM(`typeName`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`typeName`);
293	0.20 ms	SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lampType`) SELECT TRIM(`lampType`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`);
294	0.30 ms	SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN ( SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) ) GROUP BY dest SELECT dest as `value`, count(DISTINCT src_virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'baseColorObjects' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest;
295	0.23 ms	SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lightColorTemperature`) SELECT TRIM(`lightColorTemperature`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`);
296	0.22 ms	SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`diameter`) SELECT TRIM(`diameter`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`diameter`);
297	0.24 ms	SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`ipRating`) SELECT TRIM(`ipRating`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`ipRating`);
298	0.26 ms	SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`converterText`) SELECT TRIM(`converterText`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`converterText`);
299	0.22 ms	SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`recessedDepth`) SELECT TRIM(`recessedDepth`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`recessedDepth`);
300	0.22 ms	SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`cutOutMin`) SELECT TRIM(`cutOutMin`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMin`);
301	0.21 ms	SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%' ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`cutOutMax`) SELECT TRIM(`cutOutMax`) as `value`, count(DISTINCT virtualProductId) as `count` FROM ecommerceframework_productindex_wdbe_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 '%,22227,%') AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cutOutMax`);
302	9.02 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182338' and a.id != '182338') or parentProducts like '%,182338,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182338' and a.id != '182338' ) or parentProducts like '%,182338,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182338' and a.id != '182338') or parentProducts like '%,182338,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
303	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422480`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422480;
304	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422480`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422480;
305	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422479`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422479;
306	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422479`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422479;
307	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422482`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422482;
308	0.26 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422482`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422482;
309	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422481`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422481;
310	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422481`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422481;
311	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422478`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422478;
312	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422478`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422478;
313	13.91 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182339' and a.id != '182339') or parentProducts like '%,182339,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182339' and a.id != '182339' ) or parentProducts like '%,182339,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182339' and a.id != '182339') or parentProducts like '%,182339,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
314	0.43 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422484`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422484;
315	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422484`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422484;
316	0.47 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422485`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422485;
317	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422485`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422485;
318	0.43 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422483`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422483;
319	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422483`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422483;
320	0.33 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422487`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422487;
321	0.52 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422487`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422487;
322	3.12 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422486`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422486;
323	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422486`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422486;
324	17.89 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182310' and a.id != '182310') or parentProducts like '%,182310,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182310' and a.id != '182310' ) or parentProducts like '%,182310,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182310' and a.id != '182310') or parentProducts like '%,182310,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
325	0.52 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422456`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422456;
326	0.50 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422456`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422456;
327	0.49 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422455`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422455;
328	0.40 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422455`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422455;
329	21.40 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182342' and a.id != '182342') or parentProducts like '%,182342,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182342' and a.id != '182342' ) or parentProducts like '%,182342,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182342' and a.id != '182342') or parentProducts like '%,182342,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
330	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422475`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422475;
331	0.62 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422475`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422475;
332	0.45 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422471`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422471;
333	0.43 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422471`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422471;
334	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422472`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422472;
335	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422472`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422472;
336	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422476`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422476;
337	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422476`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422476;
338	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422474`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422474;
339	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422474`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422474;
340	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422473`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422473;
341	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422473`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422473;
342	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422477`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422477;
343	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422477`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422477;
344	19.97 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182341' and a.id != '182341') or parentProducts like '%,182341,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182341' and a.id != '182341' ) or parentProducts like '%,182341,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '182341' and a.id != '182341') or parentProducts like '%,182341,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
345	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422466`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422466;
346	0.66 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422466`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422466;
347	0.33 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422468`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422468;
348	0.48 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422468`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422468;
349	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422465`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422465;
350	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422465`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422465;
351	0.27 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422464`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422464;
352	0.35 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422464`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422464;
353	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422469`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422469;
354	0.47 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422469`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422469;
355	0.33 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422467`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422467;
356	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422467`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422467;
357	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`5422470`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 5422470;
358	0.53 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`5422470`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 5422470;
359	19.49 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '25042' and a.id != '25042') or parentProducts like '%,25042,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '25042' and a.id != '25042' ) or parentProducts like '%,25042,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '25042' and a.id != '25042') or parentProducts like '%,25042,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
360	0.60 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976431`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976431;
361	0.47 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976431`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976431;
362	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976433`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976433;
363	0.58 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976433`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976433;
364	0.41 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976430`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976430;
365	1.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976430`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976430;
366	1.01 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976432`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976432;
367	0.56 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976432`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976432;
368	0.32 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
369	0.88 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AdisturberAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AdisturberAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AdisturberAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AdisturberAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
370	0.42 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`303`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 303;
371	0.44 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`241833`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 241833;
372	0.38 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`241833`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 241833;
373	21.86 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49047' and a.id != '49047') or parentProducts like '%,49047,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49047' and a.id != '49047' ) or parentProducts like '%,49047,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49047' and a.id != '49047') or parentProducts like '%,49047,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
374	0.65 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`952014`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 952014;
375	0.55 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`952014`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 952014;
376	0.47 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951872`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951872;
377	0.43 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951872`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951872;
378	0.44 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976458`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976458;
379	0.45 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976458`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976458;
380	0.52 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951803`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951803;
381	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951803`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951803;
382	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951797`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951797;
383	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951797`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951797;
384	0.42 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951734`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951734;
385	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951734`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951734;
386	19.05 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17362' and a.id != '17362') or parentProducts like '%,17362,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17362' and a.id != '17362' ) or parentProducts like '%,17362,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17362' and a.id != '17362') or parentProducts like '%,17362,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
387	0.57 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`391361`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 391361;
388	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`391361`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 391361;
389	0.43 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`625`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 625;
390	0.48 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`625`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 625;
391	0.40 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`48507`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 48507;
392	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`48507`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 48507;
393	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`413851`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 413851;
394	0.65 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`413851`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 413851;
395	18.28 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '23674' and a.id != '23674') or parentProducts like '%,23674,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '23674' and a.id != '23674' ) or parentProducts like '%,23674,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '23674' and a.id != '23674') or parentProducts like '%,23674,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
396	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`225273`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 225273;
397	0.45 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`225273`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 225273;
398	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`319914`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 319914;
399	0.36 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`319914`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 319914;
400	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`225441`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 225441;
401	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`225441`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 225441;
402	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221859`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221859;
403	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221859`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221859;
404	19.43 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '28016' and a.id != '28016') or parentProducts like '%,28016,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '28016' and a.id != '28016' ) or parentProducts like '%,28016,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '28016' and a.id != '28016') or parentProducts like '%,28016,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
405	0.51 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`451`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 451;
406	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`451`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 451;
407	0.43 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`469`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 469;
408	0.61 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`469`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 469;
409	0.54 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1869`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1869;
410	0.46 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1869`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1869;
411	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976386`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976386;
412	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976386`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976386;
413	0.38 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951821`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951821;
414	0.37 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951821`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951821;
415	0.48 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`424`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 424;
416	0.41 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`424`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 424;
417	0.95 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '24983' and a.id != '24983') or parentProducts like '%,24983,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '24983' and a.id != '24983' ) or parentProducts like '%,24983,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '24983' and a.id != '24983') or parentProducts like '%,24983,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
418	0.23 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976435`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976435;
419	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976435`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976435;
420	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976434`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976434;
421	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976434`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976434;
422	18.10 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26147' and a.id != '26147') or parentProducts like '%,26147,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26147' and a.id != '26147' ) or parentProducts like '%,26147,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26147' and a.id != '26147') or parentProducts like '%,26147,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
423	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976437`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976437;
424	0.60 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976437`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976437;
425	0.32 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976438`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976438;
426	0.49 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976438`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976438;
427	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976436`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976436;
428	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976436`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976436;
429	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4976439`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4976439;
430	0.48 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4976439`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4976439;
431	20.03 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26148' and a.id != '26148') or parentProducts like '%,26148,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26148' and a.id != '26148' ) or parentProducts like '%,26148,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '26148' and a.id != '26148') or parentProducts like '%,26148,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
432	0.40 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`366963`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 366963;
433	0.57 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`366963`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 366963;
434	0.32 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951689`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951689;
435	0.45 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951689`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951689;
436	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`367078`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 367078;
437	0.38 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`367078`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 367078;
438	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`367081`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 367081;
439	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`367081`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 367081;
440	18.54 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49045' and a.id != '49045') or parentProducts like '%,49045,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49045' and a.id != '49045' ) or parentProducts like '%,49045,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '49045' and a.id != '49045') or parentProducts like '%,49045,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
441	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951490`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951490;
442	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951490`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951490;
443	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951956`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951956;
444	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951956`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951956;
445	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951516`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951516;
446	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951516`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951516;
447	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951980`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951980;
448	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951980`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951980;
449	18.76 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17449' and a.id != '17449') or parentProducts like '%,17449,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17449' and a.id != '17449' ) or parentProducts like '%,17449,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17449' and a.id != '17449') or parentProducts like '%,17449,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
450	0.27 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951177`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951177;
451	0.89 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951177`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951177;
452	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1571393`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1571393;
453	0.56 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1571393`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1571393;
454	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221946`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221946;
455	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221946`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221946;
456	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221715`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221715;
457	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221715`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221715;
458	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`225265`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 225265;
459	0.43 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`225265`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 225265;
460	17.93 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17452' and a.id != '17452') or parentProducts like '%,17452,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17452' and a.id != '17452' ) or parentProducts like '%,17452,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17452' and a.id != '17452') or parentProducts like '%,17452,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
461	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`386716`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 386716;
462	0.52 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`386716`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 386716;
463	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1571566`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1571566;
464	0.53 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1571566`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1571566;
465	0.28 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`386707`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 386707;
466	0.44 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`386707`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 386707;
467	0.27 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`386715`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 386715;
468	0.34 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`386715`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 386715;
469	18.55 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '68109' and a.id != '68109') or parentProducts like '%,68109,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '68109' and a.id != '68109' ) or parentProducts like '%,68109,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '68109' and a.id != '68109') or parentProducts like '%,68109,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
470	0.32 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221573`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221573;
471	0.51 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221573`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221573;
472	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2361070`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2361070;
473	0.48 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2361070`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2361070;
474	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`4545001`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 4545001;
475	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4545001`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4545001;
476	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`225409`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 225409;
477	0.50 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`225409`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 225409;
478	18.34 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '22719' and a.id != '22719') or parentProducts like '%,22719,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '22719' and a.id != '22719' ) or parentProducts like '%,22719,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '22719' and a.id != '22719') or parentProducts like '%,22719,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
479	0.29 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951075`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951075;
480	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951075`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951075;
481	0.30 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`222148`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 222148;
482	0.54 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`222148`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 222148;
483	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1726747`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1726747;
484	0.45 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1726747`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1726747;
485	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`222371`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 222371;
486	0.55 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`222371`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 222371;
487	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221149`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221149;
488	0.39 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221149`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221149;
489	17.73 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17451' and a.id != '17451') or parentProducts like '%,17451,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17451' and a.id != '17451' ) or parentProducts like '%,17451,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17451' and a.id != '17451') or parentProducts like '%,17451,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
490	0.40 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`386708`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 386708;
491	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`386708`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 386708;
492	0.40 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1571493`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1571493;
493	0.31 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1571493`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1571493;
494	0.31 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`265`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 265;
495	0.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`265`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 265;
496	0.25 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`181`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 181;
497	0.29 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`181`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 181;
498	23.15 ms	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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17346' and a.id != '17346') or parentProducts like '%,17346,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc Parameters: [] View formatted query View runnable query Explain query 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17346' and a.id != '17346' ) or parentProducts like '%,17346,%' ) 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_de a INNER JOIN ecommerceframework_productindex_wdbe_de_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 = '17346' and a.id != '17346') or parentProducts like '%,17346,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
499	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`755`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 755;
500	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`755`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 755;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
ax	doctrine.dbal.ax_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://testing.weverducre.com/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DApp%255CController%255CSnippetController%253A%253AfooterAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping