Symfony Profiler

Query Metrics

73 Database Queries

28 Different statements

124.18 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection


SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 1) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT object_localized_SCONF_en.id as id, object_localized_SCONF_en.type as `type` FROM object_localized_SCONF_en LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1
AND `EcommerceB2B`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_en `EcommerceB2B_localized` ON 1
AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1
AND `EcommerceB2C`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_en `EcommerceB2C_localized` ON 1
AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_en`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?))  AND  object_localized_SCONF_en.type IN ('object','variant','folder')) AND object_localized_SCONF_en.published = 1 LIMIT 1
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_SCONF WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_7 WHERE src_id = ?
SELECT * FROM translations_messages LIMIT 1;
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT * FROM sites WHERE rootId = ?
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17171' and a.id != '17171') or parentProducts like '%,17171,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '49029' and a.id != '49029') or parentProducts like '%,49029,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25050' and a.id != '25050') or parentProducts like '%,25050,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25052' and a.id != '25052') or parentProducts like '%,25052,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '87606' and a.id != '87606') or parentProducts like '%,87606,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17145' and a.id != '17145') or parentProducts like '%,17145,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23651' and a.id != '23651') or parentProducts like '%,23651,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName  FROM ecommerceframework_productindex_wdbe_en a  INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id  LEFT OUTER JOIN (
            SELECT targetId, score
            FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25051' and a.id != '25051') or parentProducts like '%,25051,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1
SELECT FOUND_ROWS()
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT name FROM classes WHERE id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM object_relations_prod WHERE src_id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
SELECT * 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 = ?

#▲	Time	Info
1	3.20 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.14 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: [`"/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703" "path" "auto_create" "/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703" "path_query" "https://testing.weverducre.com/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703" "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 = '/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703' 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.32 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
4	0.31 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
5	0.52 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/en/projects/pr/" "lighting-project-asianajoliitto-helsinki~147703"`] 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/en/projects/pr/' AND `key` = BINARY 'lighting-project-asianajoliitto-helsinki~147703';
6	1.32 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/weverducre.com/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703';
7	6.27 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/%" "/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703"`] 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 = '/en/projects/pr/lighting-project-asianajoliitto-helsinki~147703';
8	1.22 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/en/projects/" "pr"`] 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/en/projects/' AND `key` = BINARY 'pr';
9	0.25 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/weverducre.com/en/projects/pr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/weverducre.com/en/projects/pr';
10	0.38 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/%" "/en/projects/pr"`] 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 = '/en/projects/pr';
11	0.21 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/weverducre.com/en/" "projects"`] 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/en/' AND `key` = BINARY 'projects';
12	0.31 ms	SELECT object_localized_SCONF_en.id as id, object_localized_SCONF_en.type as `type` FROM object_localized_SCONF_en LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_en `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_en `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_en`.id WHERE (((EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ?)) AND object_localized_SCONF_en.type IN ('object','variant','folder')) AND object_localized_SCONF_en.published = 1 LIMIT 1 Parameters: [`"wdbe" "wdbe"`] View formatted query View runnable query Explain query SELECT object_localized_SCONF_en.id as id, object_localized_SCONF_en.type as `type` FROM object_localized_SCONF_en LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_en `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_en `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_en`.id WHERE ( ( ( EcommerceB2B.dataAreaId = ? or EcommerceB2C.dataAreaId = ? ) ) AND object_localized_SCONF_en.type IN ('object', 'variant', 'folder') ) AND object_localized_SCONF_en.published = 1 LIMIT 1 SELECT object_localized_SCONF_en.id as id, object_localized_SCONF_en.type as `type` FROM object_localized_SCONF_en LEFT JOIN object_brick_query_EcommerceB2B_SCONF `EcommerceB2B` ON 1 AND `EcommerceB2B`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2B_SCONF_en `EcommerceB2B_localized` ON 1 AND `EcommerceB2B_localized`.ooo_id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_query_EcommerceB2C_SCONF `EcommerceB2C` ON 1 AND `EcommerceB2C`.id = `object_localized_SCONF_en`.id LEFT JOIN object_brick_localized_query_EcommerceB2C_SCONF_en `EcommerceB2C_localized` ON 1 AND `EcommerceB2C_localized`.ooo_id = `object_localized_SCONF_en`.id WHERE (((EcommerceB2B.dataAreaId = 'wdbe' or EcommerceB2C.dataAreaId = 'wdbe')) AND object_localized_SCONF_en.type IN ('object','variant','folder')) AND object_localized_SCONF_en.published = 1 LIMIT 1;
13	3.44 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	15.16 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	1.32 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.48 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';
17	0.55 ms	SELECT * FROM object_relations_7 WHERE src_id = ? Parameters: [`147703`] View formatted query View runnable query Explain query SELECT * FROM object_relations_7 WHERE src_id = ? SELECT * FROM object_relations_7 WHERE src_id = 147703;
18	8.17 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.74 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;
20	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;
21	0.75 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
22	6.69 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
23	1.70 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
24	0.59 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
25	0.59 ms	SELECT * FROM sites WHERE rootId = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM sites WHERE rootId = ? SELECT * FROM sites WHERE rootId = 2;
26	0.38 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17171' and a.id != '17171') or parentProducts like '%,17171,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '17171' and a.id != '17171' ) or parentProducts like '%,17171,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17171' and a.id != '17171') or parentProducts like '%,17171,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
27	0.36 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
28	0.37 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '49029' and a.id != '49029') or parentProducts like '%,49029,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '49029' and a.id != '49029' ) or parentProducts like '%,49029,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '49029' and a.id != '49029') or parentProducts like '%,49029,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
29	5.20 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
30	0.26 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25050' and a.id != '25050') or parentProducts like '%,25050,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '25050' and a.id != '25050' ) or parentProducts like '%,25050,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25050' and a.id != '25050') or parentProducts like '%,25050,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
31	0.22 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
32	0.25 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25052' and a.id != '25052') or parentProducts like '%,25052,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '25052' and a.id != '25052' ) or parentProducts like '%,25052,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25052' and a.id != '25052') or parentProducts like '%,25052,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
33	0.22 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
34	0.25 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '87606' and a.id != '87606') or parentProducts like '%,87606,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '87606' and a.id != '87606' ) or parentProducts like '%,87606,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '87606' and a.id != '87606') or parentProducts like '%,87606,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
35	0.22 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
36	0.25 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17145' and a.id != '17145') or parentProducts like '%,17145,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '17145' and a.id != '17145' ) or parentProducts like '%,17145,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '17145' and a.id != '17145') or parentProducts like '%,17145,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
37	0.21 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
38	0.25 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '23655' and a.id != '23655' ) or parentProducts like '%,23655,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23655' and a.id != '23655') or parentProducts like '%,23655,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
39	0.20 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
40	0.26 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23651' and a.id != '23651') or parentProducts like '%,23651,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '23651' and a.id != '23651' ) or parentProducts like '%,23651,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '23651' and a.id != '23651') or parentProducts like '%,23651,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
41	0.21 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
42	0.26 ms	SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25051' and a.id != '25051') or parentProducts like '%,25051,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 ( parentCategoryIds not like '%,165410,%' ) AND ( ( ( virtualProductId = '25051' and a.id != '25051' ) or parentProducts like '%,25051,%' ) ) AND (isSalesItem = 0) ORDER BY mainProductInLine desc, isPredecessor asc, isCombinedProduct asc, a.id ASC LIMIT 1 SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM ecommerceframework_productindex_wdbe_en a INNER JOIN ecommerceframework_productindex_wdbe_en_subtenant_relations AS b ON a.id = b.id LEFT OUTER JOIN ( SELECT targetId, score FROM app_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 (parentCategoryIds not like '%,165410,%') AND (((virtualProductId = '25051' and a.id != '25051') or parentProducts like '%,25051,%')) AND (isSalesItem = 0) ORDER BY mainProductInLine desc,isPredecessor asc,isCombinedProduct asc,a.id ASC LIMIT 1;
43	0.23 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
44	5.66 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`73205`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 73205;
45	2.68 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17171`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17171;
46	0.36 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';
47	4.31 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`50342`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 50342;
48	1.52 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`49029`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 49029;
49	10.65 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`72668`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 72668;
50	0.56 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`25050`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 25050;
51	8.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`62090`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 62090;
52	2.92 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`25052`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 25052;
53	0.77 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`25326`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 25326;
54	0.71 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`87606`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 87606;
55	3.08 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`73762`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 73762;
56	1.52 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`17145`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 17145;
57	2.76 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`69430`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 69430;
58	0.33 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23655`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23655;
59	2.47 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`69478`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 69478;
60	0.56 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`23651`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 23651;
61	2.05 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`62106`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 62106;
62	0.59 ms	SELECT * FROM object_relations_prod WHERE src_id = ? Parameters: [`25051`] View formatted query View runnable query Explain query SELECT * FROM object_relations_prod WHERE src_id = ? SELECT * FROM object_relations_prod WHERE src_id = 25051;
63	1.41 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
64	1.20 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=en&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=en&_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=en&_format=html&_controller=App%5CController%5CSnippetController%3A%3AheaderAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=en&_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;
65	1.04 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';
66	0.84 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=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction" "path_query" "https://testing.weverducre.com/_fragment?_path=_locale=en&_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=en&_format=html&_controller=App%5CController%5CDefaultController%3A%3AdefaultAction' AND `type` = 'path_query') OR (source = 'https://testing.weverducre.com/_fragment?_path=_locale=en&_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;
67	0.32 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`242`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 242;
68	0.31 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;
69	0.25 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`169`] 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 = 169) AND published = 1 ORDER BY `index` ASC ;
70	0.28 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;
71	0.25 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;
72	0.24 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;
73	0.24 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`4538784`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 4538784;

Database Connections

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

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping