Symfony Profiler

Query Metrics

245 Database Queries

83 Different statements

930.24 ms Query time

1 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 `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
select `iconLabels` from object_store_prod where oo_id  = 69430
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_classificationstore_groups_prod WHERE id = 69430 AND fieldname = 'attributes'
SELECT * FROM object_classificationstore_data_prod WHERE id = 69430 AND fieldname = 'attributes'
select `combinedBlock` from object_store_prod where oo_id  = 69430
select `colorMatchExceptions` from object_store_prod where oo_id  = 69430
select `accessoryDemand` from object_store_prod where oo_id  = 69430
select `accessoryFilterGroups` from object_store_prod where oo_id  = 69430
select `combinedImage` from object_store_prod where oo_id  = 69430
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
select `iconLabels` from object_store_prod where oo_id  = 23655
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_classificationstore_groups_prod WHERE id = 23655 AND fieldname = 'attributes'
SELECT * FROM object_classificationstore_data_prod WHERE id = 23655 AND fieldname = 'attributes'
select `combinedBlock` from object_store_prod where oo_id  = 23655
select `colorMatchExceptions` from object_store_prod where oo_id  = 23655
select `accessoryDemand` from object_store_prod where oo_id  = 23655
select `accessoryFilterGroups` from object_store_prod where oo_id  = 23655
select `combinedImage` from object_store_prod where oo_id  = 23655
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_collection_AxVersion_prod WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1  ORDER BY `prio` ASC
SELECT COUNT(*) FROM object_localized_7_de WHERE ((ifnull(headline, "") != "")  AND (products like ?)  AND  object_localized_7_de.type IN ('object','variant','folder')) AND object_localized_7_de.published = 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 * 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 id FROM assets WHERE id IN (951656,2298678,2298744,167740,2298453,2298651,2298608,4691649,4691652,4691714,4975448,167173,1713478,4975787,4975791,5043368,5043369)
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') 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 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 object_relations_PCAT WHERE src_id = ?
SELECT * FROM object_relations_PCAT WHERE src_id = ?
SELECT * FROM object_relations_PCAT WHERE src_id = ?
SELECT * FROM object_relations_PCAT WHERE src_id = ?
SELECT * FROM object_relations_PCAT WHERE src_id = ?
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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') 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 TRIM(`lampType`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`)
SELECT 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0)
SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_SOPT WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_SOPT WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
SELECT * FROM object_brick_store_SocialMedia_SOPT WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_ColorObject_SOPT WHERE id = ? AND fieldname = ?
SELECT * FROM object_brick_store_AccessoryType_SOPT WHERE id = ? AND fieldname = ?
SELECT * FROM object_relations_SOPT WHERE src_id = ?
SELECT dest FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect')) GROUP BY dest
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(`mountingText`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`)
SELECT TRIM(`lightColorTemperature`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`)
SELECT `lightColorTemperature` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `lightColorTemperature`
SELECT TRIM(`resultPowerPerLengthSelect`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`resultPowerPerLengthSelect`)
SELECT TRIM(`opticsCategory`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`opticsCategory`)
SELECT TRIM(`itemNumber`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`)
SELECT `itemNumber` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `itemNumber`
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE
SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es')
select `iconLabels` from object_store_prod where oo_id  = 28044
SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ?
SELECT * FROM object_classificationstore_groups_prod WHERE id = 28044 AND fieldname = 'attributes'
SELECT * FROM object_classificationstore_data_prod WHERE id = 28044 AND fieldname = 'attributes'
select `combinedBlock` from object_store_prod where oo_id  = 28044
select `colorMatchExceptions` from object_store_prod where oo_id  = 28044
select `accessoryDemand` from object_store_prod where oo_id  = 28044
select `accessoryFilterGroups` from object_store_prod where oo_id  = 28044
select `combinedImage` from object_store_prod where oo_id  = 28044
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ?
SELECT name FROM classes WHERE id = ?
SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (`itemNumber` = '317778G5'  AND  object_localized_prod_de.type IN ('variant','object')) AND object_localized_prod_de.published = 1 LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
(
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.chapterId = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.lineName = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.itemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale`
            from object_localized_prod_de as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale`
            from object_localized_prod_de as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1
SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
SELECT classificationstore_relations.*,classificationstore_keys.* FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?)   AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1
(
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.chapterId = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.productType = ? and o.lineName = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.itemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale`
            from
                object_localized_prod_de as o
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id
                left outer join
                (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id

            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale`
            from object_localized_prod_de as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
               union
               (
            select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale`
            from object_localized_prod_de as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC
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.52 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.73 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/p/miles-3.0-round~69430" "path" "auto_create" "/de/produkte/p/miles-3.0-round~69430?parameters[parameters][page]=0" "path_query" "https://testing.weverducre.com/de/produkte/p/miles-3.0-round~69430?parameters[parameters][page]=0" "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/p/miles-3.0-round~69430' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/produkte/p/miles-3.0-round~69430?parameters[parameters][page]=0' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/de/produkte/p/miles-3.0-round~69430?parameters[parameters][page]=0' 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.39 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.36 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	0.63 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/de/produkte/p/" "miles-3.0-round~69430"`] 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/p/' AND `key` = BINARY 'miles-3.0-round~69430';
6	0.63 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/de/produkte/p/miles-3.0-round~69430"`] 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/p/miles-3.0-round~69430';
7	0.74 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/p/miles-3.0-round~69430"`] 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/p/miles-3.0-round~69430';
8	0.36 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/de/produkte/" "p"`] 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 'p';
9	0.34 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/de/produkte/p"`] 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/p';
10	0.34 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/p"`] 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/p';
11	0.36 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.37 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.31 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.87 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	0.35 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.59 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`69430`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 69430;
17	0.71 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`69430`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 69430;
18	1.17 ms	SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE Parameters: [`69430`] View formatted query View runnable query Explain query SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_prod WHERE oo_id = 69430 FOR UPDATE;
19	0.95 ms	SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') Parameters: [`69430`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'it', 'fr', 'nl', 'es') SELECT * FROM object_localized_data_prod WHERE ooo_id = 69430 AND language IN ('en','de','it','fr','nl','es');
20	0.53 ms	select `iconLabels` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `iconLabels` from object_store_prod where oo_id = 69430 select `iconLabels` from object_store_prod where oo_id = 69430;
21	0.57 ms	SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? Parameters: [`69430 "videos"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = 69430 AND fieldname = 'videos';
22	0.73 ms	SELECT * FROM object_classificationstore_groups_prod WHERE id = 69430 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_prod WHERE id = 69430 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_groups_prod WHERE id = 69430 AND fieldname = 'attributes';
23	1.94 ms	SELECT * FROM object_classificationstore_data_prod WHERE id = 69430 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_prod WHERE id = 69430 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_data_prod WHERE id = 69430 AND fieldname = 'attributes';
24	0.52 ms	select `combinedBlock` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `combinedBlock` from object_store_prod where oo_id = 69430 select `combinedBlock` from object_store_prod where oo_id = 69430;
25	0.57 ms	select `colorMatchExceptions` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `colorMatchExceptions` from object_store_prod where oo_id = 69430 select `colorMatchExceptions` from object_store_prod where oo_id = 69430;
26	0.64 ms	select `accessoryDemand` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `accessoryDemand` from object_store_prod where oo_id = 69430 select `accessoryDemand` from object_store_prod where oo_id = 69430;
27	0.56 ms	select `accessoryFilterGroups` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `accessoryFilterGroups` from object_store_prod where oo_id = 69430 select `accessoryFilterGroups` from object_store_prod where oo_id = 69430;
28	0.49 ms	select `combinedImage` from object_store_prod where oo_id = 69430 Parameters: [] View formatted query View runnable query Explain query select `combinedImage` from object_store_prod where oo_id = 69430 select `combinedImage` from object_store_prod where oo_id = 69430;
29	0.37 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`69430`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 69430;
30	0.50 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`23655`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 23655;
31	0.67 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`23655`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 23655;
32	0.61 ms	SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE Parameters: [`23655`] View formatted query View runnable query Explain query SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_prod WHERE oo_id = 23655 FOR UPDATE;
33	0.82 ms	SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') Parameters: [`23655`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'it', 'fr', 'nl', 'es') SELECT * FROM object_localized_data_prod WHERE ooo_id = 23655 AND language IN ('en','de','it','fr','nl','es');
34	0.53 ms	select `iconLabels` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `iconLabels` from object_store_prod where oo_id = 23655 select `iconLabels` from object_store_prod where oo_id = 23655;
35	0.55 ms	SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? Parameters: [`23655 "videos"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = 23655 AND fieldname = 'videos';
36	0.63 ms	SELECT * FROM object_classificationstore_groups_prod WHERE id = 23655 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_prod WHERE id = 23655 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_groups_prod WHERE id = 23655 AND fieldname = 'attributes';
37	0.68 ms	SELECT * FROM object_classificationstore_data_prod WHERE id = 23655 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_prod WHERE id = 23655 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_data_prod WHERE id = 23655 AND fieldname = 'attributes';
38	0.50 ms	select `combinedBlock` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `combinedBlock` from object_store_prod where oo_id = 23655 select `combinedBlock` from object_store_prod where oo_id = 23655;
39	0.49 ms	select `colorMatchExceptions` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `colorMatchExceptions` from object_store_prod where oo_id = 23655 select `colorMatchExceptions` from object_store_prod where oo_id = 23655;
40	0.49 ms	select `accessoryDemand` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `accessoryDemand` from object_store_prod where oo_id = 23655 select `accessoryDemand` from object_store_prod where oo_id = 23655;
41	0.49 ms	select `accessoryFilterGroups` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `accessoryFilterGroups` from object_store_prod where oo_id = 23655 select `accessoryFilterGroups` from object_store_prod where oo_id = 23655;
42	0.55 ms	select `combinedImage` from object_store_prod where oo_id = 23655 Parameters: [] View formatted query View runnable query Explain query select `combinedImage` from object_store_prod where oo_id = 23655 select `combinedImage` from object_store_prod where oo_id = 23655;
43	0.45 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;
44	0.44 ms	SELECT * FROM object_collection_AxVersion_prod WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`69430 "axVersions"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AxVersion_prod WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AxVersion_prod WHERE id = 69430 AND fieldname = 'axVersions' ORDER BY `index` ASC;
45	0.57 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;;
46	0.46 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;;
47	0.62 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23650`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23650;
48	0.34 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17328`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17328;
49	0.34 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';
50	0.58 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`159`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 159) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
51	0.35 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 11) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
52	0.29 ms	SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = ?) AND (val = ?) AND object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1 Parameters: [`"color" "Gold"`] View formatted query View runnable query Explain query SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ( (context = ?) AND (val = ?) AND object_localized_SOPT_de.type IN ('object', 'variant', 'folder') ) AND object_localized_SOPT_de.published = 1 LIMIT 1 SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = 'color') AND (val = 'Gold') AND object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1;
53	0.35 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';
54	0.42 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`48`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 48) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
55	0.38 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`26`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 26) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
56	0.40 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`106`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 106) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
57	0.34 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`20`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 20) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
58	0.29 ms	SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = ?) AND (val = ?) AND object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1 Parameters: [`"color" "Gold"`] View formatted query View runnable query Explain query SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ( (context = ?) AND (val = ?) AND object_localized_SOPT_de.type IN ('object', 'variant', 'folder') ) AND object_localized_SOPT_de.published = 1 LIMIT 1 SELECT object_localized_SOPT_de.id as id, object_localized_SOPT_de.type as `type` FROM object_localized_SOPT_de WHERE ((context = 'color') AND (val = 'Gold') AND object_localized_SOPT_de.type IN ('object','variant','folder')) AND object_localized_SOPT_de.published = 1 LIMIT 1;
59	0.28 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';
60	0.29 ms	SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC;
61	2.94 ms	SELECT COUNT() FROM object_localized_7_de WHERE ((ifnull(headline, "") != "") AND (products like ?) AND object_localized_7_de.type IN ('object','variant','folder')) AND object_localized_7_de.published = 1 Parameters: [`"%,23655,%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_7_de WHERE ( ( ifnull(headline, "") != "" ) AND (products like ?) AND object_localized_7_de.type IN ('object', 'variant', 'folder') ) AND object_localized_7_de.published = 1 SELECT COUNT(*) FROM object_localized_7_de WHERE ((ifnull(headline, "") != "") AND (products like '%,23655,%') AND object_localized_7_de.type IN ('object','variant','folder')) AND object_localized_7_de.published = 1;
62	0.64 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;
63	0.39 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;
64	0.39 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;
65	0.35 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;
66	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;
67	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;
68	0.32 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;
69	0.54 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';
70	1.34 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;
71	0.33 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';
72	1.00 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;
73	0.42 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;
74	0.39 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 ;
75	0.47 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;
76	0.45 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;
77	0.55 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;
78	0.38 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;
79	0.41 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';
80	1.29 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;
81	0.48 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;
82	0.35 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;
83	0.34 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';
84	0.40 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 ;
85	0.38 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;
86	0.36 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;
87	0.40 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';
88	0.39 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;
89	0.47 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;
90	0.37 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';
91	1.30 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;
92	0.41 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;
93	0.33 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 ;
94	0.34 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 ;
95	0.32 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;
96	0.35 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;
97	0.35 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;
98	0.37 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;
99	0.31 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';
100	1.22 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;
101	0.39 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;
102	0.30 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 ;
103	0.32 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;
104	0.34 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;
105	0.53 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;
106	0.44 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;
107	0.45 ms	SELECT id FROM assets WHERE id IN (951656,2298678,2298744,167740,2298453,2298651,2298608,4691649,4691652,4691714,4975448,167173,1713478,4975787,4975791,5043368,5043369) Parameters: [] View formatted query View runnable query Explain query SELECT id FROM assets WHERE id IN ( 951656, 2298678, 2298744, 167740, 2298453, 2298651, 2298608, 4691649, 4691652, 4691714, 4975448, 167173, 1713478, 4975787, 4975791, 5043368, 5043369 ) SELECT id FROM assets WHERE id IN (951656,2298678,2298744,167740,2298453,2298651,2298608,4691649,4691652,4691714,4975448,167173,1713478,4975787,4975791,5043368,5043369);
108	0.41 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 951656 "projectImages" "object" "" "0" 1`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 951656 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1 AND `type` = 'asset';
109	0.37 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 2298678 "projectImages" "object" "" "0" 2`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 2298678 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 2 AND `type` = 'asset';
110	0.37 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 2298744 "projectImages" "object" "" "0" 3`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 2298744 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 3 AND `type` = 'asset';
111	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 167740 "projectImages" "object" "" "0" 4`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 167740 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 4 AND `type` = 'asset';
112	0.36 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 2298453 "projectImages" "object" "" "0" 5`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 2298453 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 5 AND `type` = 'asset';
113	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 2298651 "projectImages" "object" "" "0" 6`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 2298651 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 6 AND `type` = 'asset';
114	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 2298608 "projectImages" "object" "" "0" 7`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 2298608 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 7 AND `type` = 'asset';
115	0.34 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4691649 "projectImages" "object" "" "0" 8`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4691649 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 8 AND `type` = 'asset';
116	0.40 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4691652 "projectImages" "object" "" "0" 9`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4691652 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 9 AND `type` = 'asset';
117	0.34 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4691714 "projectImages" "object" "" "0" 10`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4691714 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 10 AND `type` = 'asset';
118	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4975448 "projectImages" "object" "" "0" 11`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4975448 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 11 AND `type` = 'asset';
119	0.36 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 167173 "projectImages" "object" "" "0" 12`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 167173 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 12 AND `type` = 'asset';
120	0.38 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 1713478 "projectImages" "object" "" "0" 13`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 1713478 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 13 AND `type` = 'asset';
121	0.35 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4975787 "projectImages" "object" "" "0" 14`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4975787 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 14 AND `type` = 'asset';
122	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 4975791 "projectImages" "object" "" "0" 15`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 4975791 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 15 AND `type` = 'asset';
123	0.33 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 5043368 "projectImages" "object" "" "0" 16`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 5043368 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 16 AND `type` = 'asset';
124	0.35 ms	SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`23655 5043369 "projectImages" "object" "" "0" 17`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_prod WHERE object_metadata_prod.id = 23655 AND dest_id = 5043369 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 17 AND `type` = 'asset';
125	39.48 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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') 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 = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) 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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
126	0.42 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2298678`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2298678;
127	0.76 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2298678`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2298678;
128	0.39 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`391211`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 391211;
129	0.70 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`391211`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 391211;
130	0.55 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`391348`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 391348;
131	0.64 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`391348`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 391348;
132	0.38 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2298698`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2298698;
133	0.73 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2298698`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2298698;
134	0.44 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2298467`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2298467;
135	0.65 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2298467`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2298467;
136	0.42 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221723`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221723;
137	0.80 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221723`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221723;
138	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`221827`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 221827;
139	0.66 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`221827`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 221827;
140	0.38 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`225434`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 225434;
141	0.77 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`225434`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 225434;
142	0.35 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`222372`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 222372;
143	0.69 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`222372`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 222372;
144	0.37 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`222192`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 222192;
145	0.82 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`222192`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 222192;
146	0.37 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;
147	0.33 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22223`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22223;
148	0.37 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22237`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22237;
149	0.38 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22236`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22236;
150	0.40 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`186999`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 186999;
151	0.61 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2298744`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2298744;
152	0.64 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2298744`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2298744;
153	2.78 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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') 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 = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) 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 = '23655' and a.id != '23655') or parentProducts like '%,23655,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
154	27.92 ms	SELECT TRIM(`lampType`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lampType`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lampType`) SELECT TRIM(`lampType`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`);
155	23.52 ms	SELECT 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) Parameters: [] View formatted query View runnable query Explain query SELECT 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) SELECT 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) ;
156	21.49 ms	SELECT dest as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) ) GROUP BY dest SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest;
157	0.32 ms	SELECT * FROM object_relations_EF_FD WHERE src_id = ? Parameters: [`1553`] 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 = 1553;
158	0.51 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`86795`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 86795;
159	0.51 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`86795`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 86795;
160	0.48 ms	SELECT * FROM object_store_SOPT WHERE oo_id = ? FOR UPDATE Parameters: [`86795`] View formatted query View runnable query Explain query SELECT * FROM object_store_SOPT WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_SOPT WHERE oo_id = 86795 FOR UPDATE;
161	0.66 ms	SELECT * FROM object_localized_data_SOPT WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') Parameters: [`86795`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_SOPT WHERE ooo_id = ? AND language IN ('en', 'de', 'it', 'fr', 'nl', 'es') SELECT * FROM object_localized_data_SOPT WHERE ooo_id = 86795 AND language IN ('en','de','it','fr','nl','es');
162	0.52 ms	SELECT * FROM object_brick_store_SocialMedia_SOPT WHERE id = ? AND fieldname = ? Parameters: [`86795 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_SocialMedia_SOPT WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_SocialMedia_SOPT WHERE id = 86795 AND fieldname = 'attributes';
163	0.49 ms	SELECT * FROM object_brick_store_ColorObject_SOPT WHERE id = ? AND fieldname = ? Parameters: [`86795 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_ColorObject_SOPT WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_ColorObject_SOPT WHERE id = 86795 AND fieldname = 'attributes';
164	0.41 ms	SELECT * FROM object_brick_store_AccessoryType_SOPT WHERE id = ? AND fieldname = ? Parameters: [`86795 "attributes"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_AccessoryType_SOPT WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_AccessoryType_SOPT WHERE id = 86795 AND fieldname = 'attributes';
165	0.47 ms	SELECT * FROM object_relations_SOPT WHERE src_id = ? Parameters: [`86795`] View formatted query View runnable query Explain query SELECT * FROM object_relations_SOPT WHERE src_id = ? SELECT * FROM object_relations_SOPT WHERE src_id = 86795;
166	21.18 ms	SELECT dest FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect')) GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( TRIM(`lampType`) = 'LED' ) AND ( TRIM(`lightColorTemperature`) = '3000 K' ) AND ( TRIM(`opticsCategory`) = 'Indirect' ) ) GROUP BY dest SELECT dest FROM ecommerceframework_productindex_wdbe_de_relations a WHERE fieldname = 'colorObject' 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect')) GROUP BY dest;
167	0.41 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;
168	0.36 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;
169	0.42 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187946`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187946;
170	0.61 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187946`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187946;
171	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187948`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187948;
172	0.62 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187948`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187948;
173	0.37 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;
174	0.40 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;
175	0.40 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;
176	0.37 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;
177	0.37 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1571336`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1571336;
178	0.38 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1571336`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1571336;
179	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187916`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187916;
180	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187916`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187916;
181	0.38 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187977`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187977;
182	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187977`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187977;
183	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2360897`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2360897;
184	0.53 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2360897`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2360897;
185	21.40 ms	SELECT TRIM(`mountingText`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`mountingText`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`mountingText`) SELECT TRIM(`mountingText`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`);
186	20.84 ms	SELECT TRIM(`lightColorTemperature`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`lightColorTemperature`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lightColorTemperature`) SELECT TRIM(`lightColorTemperature`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lightColorTemperature`);
187	38.37 ms	SELECT `lightColorTemperature` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `lightColorTemperature` Parameters: [] View formatted query View runnable query Explain query SELECT `lightColorTemperature` 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 a.id IN ( SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499' ) AND ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( TRIM(`lampType`) = 'LED' ) AND ( TRIM(`opticsCategory`) = 'Indirect' ) GROUP BY `lightColorTemperature` SELECT `lightColorTemperature` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `lightColorTemperature`;
188	20.97 ms	SELECT TRIM(`resultPowerPerLengthSelect`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`resultPowerPerLengthSelect`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`resultPowerPerLengthSelect`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`resultPowerPerLengthSelect`) SELECT TRIM(`resultPowerPerLengthSelect`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`resultPowerPerLengthSelect`);
189	20.70 ms	SELECT TRIM(`opticsCategory`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`opticsCategory`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`opticsCategory`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`opticsCategory`) SELECT TRIM(`opticsCategory`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`opticsCategory`);
190	20.87 ms	SELECT TRIM(`itemNumber`) as `value`, count() 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`itemNumber`) as `value`, count() 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 ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`itemNumber`) SELECT TRIM(`itemNumber`) as `value`, count(*) 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 (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`);
191	39.25 ms	SELECT `itemNumber` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `itemNumber` Parameters: [] View formatted query View runnable query Explain query SELECT `itemNumber` 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 a.id IN ( SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499' ) AND ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND ( TRIM(`lampType`) = 'LED' ) AND ( TRIM(`lightColorTemperature`) = '3000 K' ) AND ( TRIM(`opticsCategory`) = 'Indirect' ) GROUP BY `itemNumber` SELECT `itemNumber` 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 a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_de_relations WHERE `fieldname` = 'colorObject' AND dest = '23499') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (TRIM(`lampType`) = 'LED') AND (TRIM(`lightColorTemperature`) = '3000 K') AND (TRIM(`opticsCategory`) = 'Indirect') GROUP BY `itemNumber`;
192	0.60 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`28044`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 28044;
193	0.68 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`28044`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 28044;
194	0.59 ms	SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE Parameters: [`28044`] View formatted query View runnable query Explain query SELECT * FROM object_store_prod WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_prod WHERE oo_id = 28044 FOR UPDATE;
195	0.81 ms	SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en','de','it','fr','nl','es') Parameters: [`28044`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_prod WHERE ooo_id = ? AND language IN ('en', 'de', 'it', 'fr', 'nl', 'es') SELECT * FROM object_localized_data_prod WHERE ooo_id = 28044 AND language IN ('en','de','it','fr','nl','es');
196	0.49 ms	select `iconLabels` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `iconLabels` from object_store_prod where oo_id = 28044 select `iconLabels` from object_store_prod where oo_id = 28044;
197	0.44 ms	SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? Parameters: [`28044 "videos"`] View formatted query View runnable query Explain query SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = ? AND fieldname = ? SELECT * FROM object_brick_store_ProductVideo_prod WHERE id = 28044 AND fieldname = 'videos';
198	0.50 ms	SELECT * FROM object_classificationstore_groups_prod WHERE id = 28044 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_groups_prod WHERE id = 28044 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_groups_prod WHERE id = 28044 AND fieldname = 'attributes';
199	0.81 ms	SELECT * FROM object_classificationstore_data_prod WHERE id = 28044 AND fieldname = 'attributes' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_classificationstore_data_prod WHERE id = 28044 AND fieldname = 'attributes' SELECT * FROM object_classificationstore_data_prod WHERE id = 28044 AND fieldname = 'attributes';
200	0.40 ms	select `combinedBlock` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `combinedBlock` from object_store_prod where oo_id = 28044 select `combinedBlock` from object_store_prod where oo_id = 28044;
201	0.47 ms	select `colorMatchExceptions` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `colorMatchExceptions` from object_store_prod where oo_id = 28044 select `colorMatchExceptions` from object_store_prod where oo_id = 28044;
202	0.49 ms	select `accessoryDemand` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `accessoryDemand` from object_store_prod where oo_id = 28044 select `accessoryDemand` from object_store_prod where oo_id = 28044;
203	0.38 ms	select `accessoryFilterGroups` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `accessoryFilterGroups` from object_store_prod where oo_id = 28044 select `accessoryFilterGroups` from object_store_prod where oo_id = 28044;
204	0.37 ms	select `combinedImage` from object_store_prod where oo_id = 28044 Parameters: [] View formatted query View runnable query Explain query select `combinedImage` from object_store_prod where oo_id = 28044 select `combinedImage` from object_store_prod where oo_id = 28044;
205	2.52 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`28044`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 28044;
206	0.46 ms	SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ? Parameters: [`"000496517"`] View formatted query View runnable query Explain query SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ? SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = '000496517';
207	0.44 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"LCONF"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'LCONF';
208	1.96 ms	SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (`itemNumber` = '317778G5' AND object_localized_prod_de.type IN ('variant','object')) AND object_localized_prod_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE ( `itemNumber` = '317778G5' AND object_localized_prod_de.type IN ('variant', 'object') ) AND object_localized_prod_de.published = 1 LIMIT 1 SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (`itemNumber` = '317778G5' AND object_localized_prod_de.type IN ('variant','object')) AND object_localized_prod_de.published = 1 LIMIT 1;
209	0.52 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`146`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 146) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
210	0.42 ms	SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC Parameters: [`1196332`] View formatted query View runnable query Explain query SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC SELECT assets.id, assets.type FROM assets WHERE parentId = 1196332 ORDER BY `filename` ASC ;
211	0.48 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`177`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 177) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
212	137.61 ms	( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.chapterId = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.lineName = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) Parameters: [`"chapter" "924" "line" "MILES 3.0 ROUND" "317778G5" "article" "317778G5" "aspect" "317778G5" "aspect" "317778G5" "aspect"`] View formatted query View runnable query Explain query ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.chapterId = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.lineName = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = 'chapter' and o.chapterId = '924' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = 'line' and o.lineName = 'MILES 3.0 ROUND' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = '317778G5' and o.productType = 'article' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) ;
213	0.40 ms	SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_de.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = 'article') AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1;
214	1.38 ms	SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber = ?) AND (productType = ?) AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"317778G5" "article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber = ?) AND (productType = ?) AND object_localized_prod_de.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber = '317778G5') AND (productType = 'article') AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1;
215	0.45 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`41`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 41) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
216	0.41 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`12`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 12) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
217	0.38 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`13`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 13) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
218	0.40 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`14`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 14) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
219	0.42 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`37`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 37) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
220	0.39 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`225`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 225) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
221	0.38 ms	SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 Parameters: [`31`] View formatted query View runnable query Explain query SELECT classificationstore_relations., classificationstore_keys. FROM classificationstore_relations, classificationstore_keys WHERE (keyId = ?) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1 SELECT classificationstore_relations.,classificationstore_keys. FROM classificationstore_relations,classificationstore_keys WHERE (keyId = 31) AND classificationstore_relations.keyId = classificationstore_keys.id LIMIT 1;
222	0.51 ms	( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.chapterId = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.lineName = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) Parameters: [`"chapter" "924" "line" "MILES 3.0 ROUND" "317778G5" "article" "317778G5" "aspect" "317778G5" "aspect" "317778G5" "aspect"`] View formatted query View runnable query Explain query ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.chapterId = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = ? and o.lineName = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join ( select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage' ) as u on o.id = u.id left outer join ( select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale' ) as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = 'chapter' and o.chapterId = '924' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.productType = 'line' and o.lineName = 'MILES 3.0 ROUND' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'manualDocuments' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.itemNumber = '317778G5' and o.productType = 'article' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, u.dest_id as `usageDestId`, l.dest_id as `localeDestId`, u.data as `usage`, l.data as `locale` from object_localized_prod_de as o left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'usage') as u on o.id = u.id left outer join (select * from object_metadata_prod where fieldname = 'documents' and `column` = 'locale') as l on o.id = l.id and u.dest_id = l.dest_id where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainImage as `usageDestId`, mainImage as `localeDestId`, 'Product' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) union ( select o.itemNumber as `itemNumber`, o.itemNumberAnnotation as `itemNumberAnnotation`, mainDrawing__id as `usageDestId`, mainDrawing__id as `localeDestId`, 'Drawing' as `usage`, '' as `locale` from object_localized_prod_de as o where o.published = 1 and o.actualItemNumber = '317778G5' and o.productType = 'aspect' ) ;
223	0.33 ms	SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_de.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_de.id as id, object_localized_prod_de.type as `type` FROM object_localized_prod_de WHERE (itemNumber is null) AND (productType = 'article') AND object_localized_prod_de.type IN ('object','variant','folder') LIMIT 1;
224	0.38 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`222099`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 222099;
225	0.60 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`222099`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 222099;
226	0.43 ms	SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC Parameters: [`1196331`] View formatted query View runnable query Explain query SELECT assets.id, assets.type FROM assets WHERE parentId = ? ORDER BY `filename` ASC SELECT assets.id, assets.type FROM assets WHERE parentId = 1196331 ORDER BY `filename` ASC ;
227	0.45 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1196336`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1196336;
228	0.42 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1196336`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1196336;
229	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';
230	1.26 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%3AfooterAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction" "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%3AfooterAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction' 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;
231	0.50 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 10;

ax connection


select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
SELECT *
            FROM WS_SALESPRICE
            WHERE ITEMNUMBER IN (?)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)
select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID
            and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ?
            and (b.TYPE = 2 OR b.TYPE = 0)

#▲	Time	Info
1	28.50 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
2	26.84 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;
3	27.96 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
4	29.70 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;
5	29.15 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
6	28.90 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;
7	33.25 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
8	32.14 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;
9	1.18 ms	SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY Parameters: [`"000496517"`] View formatted query View runnable query Explain query SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = ? ORDER BY ( SELECT 0 ) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = '000496517' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;
10	0.72 ms	SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN (?) Parameters: [`"000687241"`] View formatted query View runnable query Explain query SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN (?) SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN ('000687241') ;
11	31.37 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
12	28.19 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;
13	29.57 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000496517"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000496517' and (b.TYPE = 2 OR b.TYPE = 0) ;
14	31.93 ms	select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and (b.TYPE = 2 OR b.TYPE = 0) Parameters: [`"wdbe" "G_SBOM_ALL" "000687241"`] View formatted query View runnable query Explain query select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = ? and b.ITEMGROUPID = ? and a.ITEMNUMBER = ? and ( b.TYPE = 2 OR b.TYPE = 0 ) select 1 from WS_PRODUCT a join WS_CONTROLPRODUCTSSALES b on a.DATAAREAID = b.DATAAREAID and a.ITEMGROUPID = b.ITEMGROUPID where a.DATAAREAID = 'wdbe' and b.ITEMGROUPID = 'G_SBOM_ALL' and a.ITEMNUMBER = '000687241' and (b.TYPE = 2 OR b.TYPE = 0) ;

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

Class	Mapping errors
App\Entity\StockReservation	The field 'App\Entity\StockReservation#amount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.

Symfony Profiler

GET https://testing.weverducre.com/de/produkte/p/miles-3.0-round~69430?parameters%5Bparameters%5D%5Bpage%5D=0

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

ax connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping