Symfony Profiler

Query Metrics

197 Database Queries

47 Different statements

807.72 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_nl.id as id, object_localized_SCONF_nl.type as `type` FROM object_localized_SCONF_nl LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_nl `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_nl `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_nl`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_nl.type IN ('object','variant','folder')) AND object_localized_SCONF_nl.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 * 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 * 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_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.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 * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1
SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = ?)  AND (val = ?)  AND  object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.published = 1 LIMIT 1
SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 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_nl WHERE ((ifnull(headline, "") != "")  AND (products like ?)  AND  object_localized_7_nl.type IN ('object','variant','folder')) AND object_localized_7_nl.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 * 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 * FROM documents_editables WHERE documentId = ?
SELECT object_localized_8_nl.id as id, object_localized_8_nl.type as `type` FROM object_localized_8_nl WHERE ( object_localized_8_nl.type IN ('object','variant','folder')) AND object_localized_8_nl.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 * 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 * 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 (46131,34348,34060,34336,108492,35412,34315,25846,48453,34334,167135,48490,166785,34318,34330,166588,47217,109787,166805,166789,23966,855666,855733,855717,855821,951798,951749,951600,2121212,2298588)
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 * 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_relations_prod WHERE src_id = ?
select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') 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 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 * 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 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 name FROM classes WHERE id = ?
select
                a.*,
                max(mainProductInLine) as maxMainProductInLine,
                group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids,
                group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds
            from ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id 
            where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') 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_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`)
SELECT count(*) FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0)
SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
SELECT dest FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27')) 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 TRIM(`mountingText`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`)
SELECT TRIM(`cableLength`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cableLength`)
SELECT TRIM(`itemNumber`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`)
SELECT `itemNumber` FROM ecommerceframework_productindex_wdbe_nl a  INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_customer_aggregated_score
            WHERE
                name = 'sellable' AND
                customerId is null
        ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_nl_relations WHERE `fieldname` = 'colorObject' AND dest = '78321') AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27') GROUP BY `itemNumber`
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 = ?
SELECT name FROM classes WHERE id = ?
SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (`itemNumber` = '2093E0B0'  AND  object_localized_prod_nl.type IN ('variant','object')) AND object_localized_prod_nl.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_nl 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_nl 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_nl 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_nl 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_nl 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_nl as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1
SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber = ?)  AND (productType = ?)  AND  object_localized_prod_nl.type IN ('object','variant','folder') 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 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_nl 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_nl 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_nl 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_nl 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_nl 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_nl as o
            where o.published = 1 and o.actualItemNumber = ? and o.productType = ?
        )
SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null)  AND (productType = ?)  AND  object_localized_prod_nl.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 * 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 * FROM documents_editables WHERE documentId = ?

#▲	Time	Info
1	0.53 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.64 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: [`"/nl/producten/p/wiro-3.8~70193" "path" "auto_create" "/nl/producten/p/wiro-3.8~70193" "path_query" "https://testing.weverducre.com/nl/producten/p/wiro-3.8~70193" "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 = '/nl/producten/p/wiro-3.8~70193' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/producten/p/wiro-3.8~70193' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/nl/producten/p/wiro-3.8~70193' 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.50 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.56 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.76 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/nl/producten/p/" "wiro-3.8~70193"`] 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/nl/producten/p/' AND `key` = BINARY 'wiro-3.8~70193';
6	0.68 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/nl/producten/p/wiro-3.8~70193"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/weverducre.com/nl/producten/p/wiro-3.8~70193';
7	0.91 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/%" "/nl/producten/p/wiro-3.8~70193"`] 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 = '/nl/producten/p/wiro-3.8~70193';
8	0.50 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/nl/producten/" "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/nl/producten/' AND `key` = BINARY 'p';
9	0.50 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/nl/producten/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/nl/producten/p';
10	0.42 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/%" "/nl/producten/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 = '/nl/producten/p';
11	0.47 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/nl/" "producten"`] 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/nl/' AND `key` = BINARY 'producten';
12	0.38 ms	SELECT object_localized_SCONF_nl.id as id, object_localized_SCONF_nl.type as `type` FROM object_localized_SCONF_nl LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_nl `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_nl `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_nl`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?)) AND object_localized_SCONF_nl.type IN ('object','variant','folder')) AND object_localized_SCONF_nl.published = 1 LIMIT 1 Parameters: [`"wdbe" "wdbe"`] View formatted query View runnable query Explain query SELECT object_localized_SCONF_nl.id as id, object_localized_SCONF_nl.type as `type` FROM object_localized_SCONF_nl LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_nl `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_nl `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_nl`.id WHERE ( ( ( EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ? ) ) AND object_localized_SCONF_nl.type IN ('object', 'variant', 'folder') ) AND object_localized_SCONF_nl.published = 1 LIMIT 1 SELECT object_localized_SCONF_nl.id as id, object_localized_SCONF_nl.type as `type` FROM object_localized_SCONF_nl LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_nl `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_nl`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_nl `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_nl`.id WHERE (((EcommerceB2B.dataAreaId = 'wdbe' or EcommerceB2C.dataAreaId = 'wdbe')) AND object_localized_SCONF_nl.type IN ('object','variant','folder')) AND object_localized_SCONF_nl.published = 1 LIMIT 1;
13	0.33 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.82 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.42 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.93 ms	SELECT * FROM object_collection_AxVersion_prod WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`70193 "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 = 70193 AND fieldname = 'axVersions' ORDER BY `index` ASC;
17	0.61 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;;
18	0.52 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
19	0.97 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`70193`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 70193;
20	1.09 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17278`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17278;
21	0.42 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17275`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17275;
22	0.41 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';
23	0.53 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;
24	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: [`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;
25	0.41 ms	SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = ?) AND (val = ?) AND object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.published = 1 LIMIT 1 Parameters: [`"color" "Black Steel"`] View formatted query View runnable query Explain query SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ( (context = ?) AND (val = ?) AND object_localized_SOPT_nl.type IN ('object', 'variant', 'folder') ) AND object_localized_SOPT_nl.published = 1 LIMIT 1 SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = 'color') AND (val = 'Black Steel') AND object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.published = 1 LIMIT 1;
26	0.48 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';
27	0.51 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;
28	0.48 ms	SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1 SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1;
29	0.52 ms	SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = ?) AND (val = ?) AND object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.published = 1 LIMIT 1 Parameters: [`"color" "Black Steel"`] View formatted query View runnable query Explain query SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ( (context = ?) AND (val = ?) AND object_localized_SOPT_nl.type IN ('object', 'variant', 'folder') ) AND object_localized_SOPT_nl.published = 1 LIMIT 1 SELECT object_localized_SOPT_nl.id as id, object_localized_SOPT_nl.type as `type` FROM object_localized_SOPT_nl WHERE ((context = 'color') AND (val = 'Black Steel') AND object_localized_SOPT_nl.type IN ('object','variant','folder')) AND object_localized_SOPT_nl.published = 1 LIMIT 1;
30	0.47 ms	SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1 SELECT * FROM classificationstore_keys WHERE name = 'e_cable_length' and storeId = 1;
31	0.37 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';
32	0.37 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;
33	2.93 ms	SELECT COUNT() FROM object_localized_7_nl WHERE ((ifnull(headline, "") != "") AND (products like ?) AND object_localized_7_nl.type IN ('object','variant','folder')) AND object_localized_7_nl.published = 1 Parameters: [`"%,17278,%"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_localized_7_nl WHERE ( ( ifnull(headline, "") != "" ) AND (products like ?) AND object_localized_7_nl.type IN ('object', 'variant', 'folder') ) AND object_localized_7_nl.published = 1 SELECT COUNT(*) FROM object_localized_7_nl WHERE ((ifnull(headline, "") != "") AND (products like '%,17278,%') AND object_localized_7_nl.type IN ('object','variant','folder')) AND object_localized_7_nl.published = 1;
34	0.42 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;
35	0.33 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;
36	0.34 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;
37	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;
38	0.34 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;
39	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;
40	0.37 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;
41	0.44 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';
42	1.53 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=nl&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
43	0.47 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';
44	1.44 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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
45	0.49 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1134`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1134;
46	0.52 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;
47	0.45 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1139`] 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 = 1139) AND published = 1 ORDER BY `index` ASC ;
48	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;
49	0.36 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;
50	0.43 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;
51	0.49 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;
52	0.43 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';
53	1.41 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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
54	0.42 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1138`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1138;
55	0.47 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;
56	0.43 ms	SELECT object_localized_8_nl.id as id, object_localized_8_nl.type as `type` FROM object_localized_8_nl WHERE ( object_localized_8_nl.type IN ('object','variant','folder')) AND object_localized_8_nl.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_8_nl.id as id, object_localized_8_nl.type as `type` FROM object_localized_8_nl WHERE ( object_localized_8_nl.type IN ('object', 'variant', 'folder') ) AND object_localized_8_nl.published = 1 SELECT object_localized_8_nl.id as id, object_localized_8_nl.type as `type` FROM object_localized_8_nl WHERE ( object_localized_8_nl.type IN ('object','variant','folder')) AND object_localized_8_nl.published = 1;
57	0.40 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';
58	0.45 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1296`] 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 = 1296) AND published = 1 ORDER BY `index` ASC ;
59	0.41 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;
60	0.38 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;
61	0.39 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';
62	0.46 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;
63	0.49 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;
64	0.36 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';
65	1.41 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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
66	0.50 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1135`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1135;
67	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;
68	0.31 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1110`] 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 = 1110) AND published = 1 ORDER BY `index` ASC ;
69	0.36 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1147`] 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 = 1147) AND published = 1 ORDER BY `index` ASC ;
70	0.41 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;
71	0.36 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;
72	0.46 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;
73	0.44 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;
74	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';
75	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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
76	0.39 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1137`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1137;
77	0.49 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;
78	0.36 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`1107`] 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 = 1107) AND published = 1 ORDER BY `index` ASC ;
79	0.37 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;
80	0.37 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;
81	0.47 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;
82	0.38 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;
83	0.97 ms	SELECT id FROM assets WHERE id IN (46131,34348,34060,34336,108492,35412,34315,25846,48453,34334,167135,48490,166785,34318,34330,166588,47217,109787,166805,166789,23966,855666,855733,855717,855821,951798,951749,951600,2121212,2298588) Parameters: [] View formatted query View runnable query Explain query SELECT id FROM assets WHERE id IN ( 46131, 34348, 34060, 34336, 108492, 35412, 34315, 25846, 48453, 34334, 167135, 48490, 166785, 34318, 34330, 166588, 47217, 109787, 166805, 166789, 23966, 855666, 855733, 855717, 855821, 951798, 951749, 951600, 2121212, 2298588 ) SELECT id FROM assets WHERE id IN (46131,34348,34060,34336,108492,35412,34315,25846,48453,34334,167135,48490,166785,34318,34330,166588,47217,109787,166805,166789,23966,855666,855733,855717,855821,951798,951749,951600,2121212,2298588);
84	1.11 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: [`17278 46131 "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 = 17278 AND dest_id = 46131 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1 AND `type` = 'asset';
85	0.91 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: [`17278 34348 "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 = 17278 AND dest_id = 34348 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 2 AND `type` = 'asset';
86	0.90 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: [`17278 34060 "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 = 17278 AND dest_id = 34060 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 3 AND `type` = 'asset';
87	0.96 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: [`17278 34336 "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 = 17278 AND dest_id = 34336 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 4 AND `type` = 'asset';
88	0.96 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: [`17278 108492 "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 = 17278 AND dest_id = 108492 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 5 AND `type` = 'asset';
89	0.94 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: [`17278 35412 "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 = 17278 AND dest_id = 35412 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 6 AND `type` = 'asset';
90	0.88 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: [`17278 34315 "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 = 17278 AND dest_id = 34315 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 7 AND `type` = 'asset';
91	0.86 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: [`17278 25846 "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 = 17278 AND dest_id = 25846 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 8 AND `type` = 'asset';
92	0.87 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: [`17278 48453 "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 = 17278 AND dest_id = 48453 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 9 AND `type` = 'asset';
93	0.85 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: [`17278 34334 "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 = 17278 AND dest_id = 34334 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 10 AND `type` = 'asset';
94	0.83 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: [`17278 167135 "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 = 17278 AND dest_id = 167135 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 11 AND `type` = 'asset';
95	0.82 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: [`17278 48490 "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 = 17278 AND dest_id = 48490 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 12 AND `type` = 'asset';
96	0.79 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: [`17278 166785 "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 = 17278 AND dest_id = 166785 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 13 AND `type` = 'asset';
97	0.81 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: [`17278 34318 "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 = 17278 AND dest_id = 34318 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 14 AND `type` = 'asset';
98	0.80 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: [`17278 34330 "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 = 17278 AND dest_id = 34330 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 15 AND `type` = 'asset';
99	0.79 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: [`17278 166588 "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 = 17278 AND dest_id = 166588 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 16 AND `type` = 'asset';
100	0.78 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: [`17278 47217 "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 = 17278 AND dest_id = 47217 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 17 AND `type` = 'asset';
101	0.76 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: [`17278 109787 "projectImages" "object" "" "0" 18`] 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 = 17278 AND dest_id = 109787 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 18 AND `type` = 'asset';
102	0.73 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: [`17278 166805 "projectImages" "object" "" "0" 19`] 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 = 17278 AND dest_id = 166805 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 19 AND `type` = 'asset';
103	0.75 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: [`17278 166789 "projectImages" "object" "" "0" 20`] 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 = 17278 AND dest_id = 166789 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 20 AND `type` = 'asset';
104	0.80 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: [`17278 23966 "projectImages" "object" "" "0" 21`] 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 = 17278 AND dest_id = 23966 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 21 AND `type` = 'asset';
105	0.81 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: [`17278 855666 "projectImages" "object" "" "0" 22`] 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 = 17278 AND dest_id = 855666 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 22 AND `type` = 'asset';
106	0.79 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: [`17278 855733 "projectImages" "object" "" "0" 23`] 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 = 17278 AND dest_id = 855733 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 23 AND `type` = 'asset';
107	0.77 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: [`17278 855717 "projectImages" "object" "" "0" 24`] 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 = 17278 AND dest_id = 855717 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 24 AND `type` = 'asset';
108	0.75 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: [`17278 855821 "projectImages" "object" "" "0" 25`] 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 = 17278 AND dest_id = 855821 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 25 AND `type` = 'asset';
109	0.80 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: [`17278 951798 "projectImages" "object" "" "0" 26`] 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 = 17278 AND dest_id = 951798 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 26 AND `type` = 'asset';
110	0.88 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: [`17278 951749 "projectImages" "object" "" "0" 27`] 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 = 17278 AND dest_id = 951749 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 27 AND `type` = 'asset';
111	0.82 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: [`17278 951600 "projectImages" "object" "" "0" 28`] 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 = 17278 AND dest_id = 951600 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 28 AND `type` = 'asset';
112	0.72 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: [`17278 2121212 "projectImages" "object" "" "0" 29`] 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 = 17278 AND dest_id = 2121212 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 29 AND `type` = 'asset';
113	0.73 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: [`17278 2298588 "projectImages" "object" "" "0" 30`] 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 = 17278 AND dest_id = 2298588 AND fieldname = 'projectImages' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 30 AND `type` = 'asset';
114	0.31 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17228`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17228;
115	31.22 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) and IFNULL(isSalesItem, 0) = 0 and ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) group by color order by maxMainProductInLine desc select a.*, max(mainProductInLine) as maxMainProductInLine, group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids, group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds from ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
116	0.71 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`34315`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 34315;
117	0.70 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`34315`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 34315;
118	0.60 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`34334`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 34334;
119	0.73 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`34334`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 34334;
120	0.59 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2565374`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2565374;
121	0.64 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2565374`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2565374;
122	0.69 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2565359`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2565359;
123	0.68 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`2565359`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 2565359;
124	0.36 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`2565374`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 2565374;
125	0.31 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22242`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22242;
126	0.41 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;
127	0.36 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;
128	0.35 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`23479`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 23479;
129	0.30 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`22232`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 22232;
130	0.31 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;
131	0.31 ms	SELECT * FROM object_relations_PCAT WHERE src_id = ? Parameters: [`113113`] View formatted query View runnable query Explain query SELECT * FROM object_relations_PCAT WHERE src_id = ? SELECT * FROM object_relations_PCAT WHERE src_id = 113113;
132	0.49 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`25846`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 25846;
133	0.64 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`25846`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 25846;
134	0.44 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`48490`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 48490;
135	0.63 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`48490`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 48490;
136	0.49 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`951600`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 951600;
137	0.64 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`951600`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 951600;
138	0.35 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"ACPAL"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'ACPAL';
139	1.11 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) and IFNULL(isSalesItem, 0) = 0 and ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) group by color order by maxMainProductInLine desc select a.*, max(mainProductInLine) as maxMainProductInLine, group_concat(a.id order by a.mainProductInLine desc, a.mainColorProductInLine desc) as ids, group_concat(a.mainImageId order by a.mainProductInLine desc, a.mainColorProductInLine desc) as mainImageIds from ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id where active = 1 and virtualProductActive = 1 and ((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%') and IFNULL(isSalesItem, 0) = 0 and (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) group by color order by maxMainProductInLine desc ;
140	26.76 ms	SELECT TRIM(`lampType`) as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`lampType`) SELECT TRIM(`lampType`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`lampType`);
141	23.22 ms	SELECT count() FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) Parameters: [] View formatted query View runnable query Explain query SELECT count() FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) SELECT count(*) FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) ;
142	20.90 ms	SELECT dest as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) 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_nl_relations a WHERE fieldname = 'colorObject' AND src IN ( SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) ) GROUP BY dest SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0)) GROUP BY dest;
143	0.36 ms	SELECT * FROM object_relations_EF_FD WHERE src_id = ? Parameters: [`27988`] 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 = 27988;
144	20.81 ms	SELECT dest FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27')) GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN ( SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( TRIM(`lampType`) = 'E27' ) ) GROUP BY dest SELECT dest FROM ecommerceframework_productindex_wdbe_nl_relations a WHERE fieldname = 'colorObject' AND src IN (SELECT a.id FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27')) GROUP BY dest;
145	0.42 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187912`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187912;
146	0.47 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187912`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187912;
147	0.36 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`187973`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 187973;
148	0.33 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`187973`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 187973;
149	21.60 ms	SELECT TRIM(`mountingText`) as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`mountingText`) SELECT TRIM(`mountingText`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`mountingText`);
150	21.25 ms	SELECT TRIM(`cableLength`) as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cableLength`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`cableLength`) as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`cableLength`) SELECT TRIM(`cableLength`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`cableLength`);
151	21.70 ms	SELECT TRIM(`itemNumber`) as `value`, count() as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) 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_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND ( b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( IFNULL(isSalesItem, 0) = 0 ) GROUP BY TRIM(`itemNumber`) SELECT TRIM(`itemNumber`) as `value`, count(*) as `count` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (b.subtenant_id = 2 AND isCombinedProduct != 1 OR isCombinedProduct IS NULL) AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (IFNULL(isSalesItem, 0) = 0) GROUP BY TRIM(`itemNumber`);
152	38.61 ms	SELECT `itemNumber` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_nl_relations WHERE `fieldname` = 'colorObject' AND dest = '78321') AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27') GROUP BY `itemNumber` Parameters: [] View formatted query View runnable query Explain query SELECT `itemNumber` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND a.id IN ( SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_nl_relations WHERE `fieldname` = 'colorObject' AND dest = '78321' ) AND ( ( ( virtualProductId = '17278' and a.id != '17278' ) or parentProducts like '%,17278,%' ) ) AND ( TRIM(`lampType`) = 'E27' ) GROUP BY `itemNumber` SELECT `itemNumber` FROM ecommerceframework_productindex_wdbe_nl a INNER JOIN ecommerceframework_productindex_wdbe_nl_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_customer_aggregated_score WHERE name = 'sellable' AND customerId is null ) AS s ON s.targetId = a.id WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND b.subtenant_id = 2 AND a.id IN (SELECT DISTINCT src FROM ecommerceframework_productindex_wdbe_nl_relations WHERE `fieldname` = 'colorObject' AND dest = '78321') AND (((virtualProductId = '17278' and a.id != '17278') or parentProducts like '%,17278,%')) AND (TRIM(`lampType`) = 'E27') GROUP BY `itemNumber`;
153	1.06 ms	SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ? Parameters: [`"000506596"`] 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 = '000506596';
154	0.66 ms	SELECT sum(a0_.amount) AS sclr_0 FROM app_stock_reservation a0_ WHERE a0_.itemNumber = ? Parameters: [`"000513155"`] 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 = '000513155';
155	0.42 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';
156	2.03 ms	SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (`itemNumber` = '2093E0B0' AND object_localized_prod_nl.type IN ('variant','object')) AND object_localized_prod_nl.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE ( `itemNumber` = '2093E0B0' AND object_localized_prod_nl.type IN ('variant', 'object') ) AND object_localized_prod_nl.published = 1 LIMIT 1 SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (`itemNumber` = '2093E0B0' AND object_localized_prod_nl.type IN ('variant','object')) AND object_localized_prod_nl.published = 1 LIMIT 1;
157	0.43 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;
158	0.49 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 ;
159	0.50 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;
160	131.15 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_nl 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_nl 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_nl 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_nl 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_nl 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_nl as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) Parameters: [`"chapter" "918" "line" "WIRO 3.8" "2093E0B0" "article" "2093E0B0" "aspect" "2093E0B0" "aspect" "2093E0B0" "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_nl 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_nl 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_nl 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_nl 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_nl 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_nl 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_nl 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 = '918' ) 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_nl 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 = 'WIRO 3.8' ) 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_nl 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 = '2093E0B0' 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_nl 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 = '2093E0B0' 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_nl as o where o.published = 1 and o.actualItemNumber = '2093E0B0' 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_nl as o where o.published = 1 and o.actualItemNumber = '2093E0B0' and o.productType = 'aspect' ) ;
161	0.42 ms	SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_nl.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = 'article') AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1;
162	1.32 ms	SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber = ?) AND (productType = ?) AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"2093E0B0" "article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber = ?) AND (productType = ?) AND object_localized_prod_nl.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber = '2093E0B0') AND (productType = 'article') AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1;
163	0.37 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"ACCES"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'ACCES';
164	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: [`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;
165	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: [`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;
166	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: [`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;
167	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: [`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;
168	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: [`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;
169	0.32 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;
170	0.32 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;
171	0.33 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;
172	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: [`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;
173	0.47 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_nl 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_nl 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_nl 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_nl 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_nl 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_nl as o where o.published = 1 and o.actualItemNumber = ? and o.productType = ? ) Parameters: [`"chapter" "918" "line" "WIRO 3.8" "2093E0B0" "article" "2093E0B0" "aspect" "2093E0B0" "aspect" "2093E0B0" "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_nl 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_nl 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_nl 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_nl 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_nl 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_nl 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_nl 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 = '918' ) 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_nl 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 = 'WIRO 3.8' ) 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_nl 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 = '2093E0B0' 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_nl 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 = '2093E0B0' 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_nl as o where o.published = 1 and o.actualItemNumber = '2093E0B0' 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_nl as o where o.published = 1 and o.actualItemNumber = '2093E0B0' and o.productType = 'aspect' ) ;
174	0.29 ms	SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1 Parameters: [`"article"`] View formatted query View runnable query Explain query SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = ?) AND object_localized_prod_nl.type IN ('object', 'variant', 'folder') LIMIT 1 SELECT object_localized_prod_nl.id as id, object_localized_prod_nl.type as `type` FROM object_localized_prod_nl WHERE (itemNumber is null) AND (productType = 'article') AND object_localized_prod_nl.type IN ('object','variant','folder') LIMIT 1;
175	0.54 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`48533`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 48533;
176	0.55 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`48533`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 48533;
177	0.39 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 ;
178	0.36 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';
179	0.98 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=nl&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=nl&_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=nl&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=nl&_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;
180	0.40 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1133`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1133;
181	0.44 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_MAXREPORTASFINISHEDWITHEXPECTEDAVAILABLE WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
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	25.99 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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
2	25.95 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" "000513155"`] 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 = '000513155' and (b.TYPE = 2 OR b.TYPE = 0) ;
3	26.04 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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
4	27.13 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" "000513155"`] 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 = '000513155' and (b.TYPE = 2 OR b.TYPE = 0) ;
5	25.83 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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
6	25.75 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" "000513155"`] 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 = '000513155' and (b.TYPE = 2 OR b.TYPE = 0) ;
7	25.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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
8	26.27 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" "000513155"`] 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 = '000513155' and (b.TYPE = 2 OR b.TYPE = 0) ;
9	1.29 ms	SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY Parameters: [`"000506596"`] 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 = '000506596' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;
10	25.34 ms	SELECT * FROM WS_MAXREPORTASFINISHEDWITHEXPECTEDAVAILABLE WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY Parameters: [`"000506596"`] View formatted query View runnable query Explain query SELECT * FROM WS_MAXREPORTASFINISHEDWITHEXPECTEDAVAILABLE WHERE ITEMID = ? ORDER BY ( SELECT 0 ) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY SELECT * FROM WS_MAXREPORTASFINISHEDWITHEXPECTEDAVAILABLE WHERE ITEMID = '000506596' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;
11	0.94 ms	SELECT * FROM WS_MAXREPORTASFINISHED WHERE ITEMID = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY Parameters: [`"000513155"`] 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 = '000513155' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;
12	1.13 ms	SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN (?) Parameters: [`"000513155"`] View formatted query View runnable query Explain query SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN (?) SELECT * FROM WS_SALESPRICE WHERE ITEMNUMBER IN ('000513155') ;
13	26.21 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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
14	27.00 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" "000513155"`] 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 = '000513155' and (b.TYPE = 2 OR b.TYPE = 0) ;
15	30.43 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" "000506596"`] 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 = '000506596' and (b.TYPE = 2 OR b.TYPE = 0) ;
16	25.64 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" "000513155"`] 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 = '000513155' 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/nl/producten/p/wiro-3.8~70193

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