https://efb-elektronik.dev.mc.emzcustomers.de/landingPage/828e6eeab03848b9931edbe2c8e7b741

Method
GET
HTTP Status
200
IP
18.224.38.15
Profiled on
Token
23a472

Query Metrics

62 Database Queries
Different statements
351.45 ms Query time
Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.60 ms 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
View formatted query    View runnable query    View query stack
2 0.26 ms 
SELECT custom_entity.name, custom_entity.fields
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
View formatted query    View runnable query    View query stack
3 0.50 ms 
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
View formatted query    View runnable query    View query stack
4 2.58 ms 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1566896378_IS_ACTIVE = TRUE;SET @MIGRATION_1579597261_IS_ACTIVE = TRUE;SET @MIGRATION_1580742497_IS_ACTIVE = TRUE;SET @MIGRATION_1584020367_IS_ACTIVE = TRUE;SET @MIGRATION_1584615734_IS_ACTIVE = TRUE;SET @MIGRATION_1588138609_IS_ACTIVE = TRUE;SET @MIGRATION_1597841941_IS_ACTIVE = TRUE;SET @MIGRATION_1603726376_IS_ACTIVE = TRUE;SET @MIGRATION_1620989898_IS_ACTIVE = TRUE;SET @MIGRATION_1621518771_IS_ACTIVE = TRUE;SET @MIGRATION_1634193548_IS_ACTIVE = TRUE;SET @MIGRATION_1652779309_IS_ACTIVE = TRUE;SET @MIGRATION_1572944593_IS_ACTIVE = TRUE;SET @MIGRATION_1573045796_IS_ACTIVE = TRUE;SET @MIGRATION_1573135374_IS_ACTIVE = TRUE;SET @MIGRATION_1573139562_IS_ACTIVE = TRUE;SET @MIGRATION_1573140186_IS_ACTIVE = TRUE;SET @MIGRATION_1573209317_IS_ACTIVE = TRUE;SET @MIGRATION_1573209481_IS_ACTIVE = TRUE;SET @MIGRATION_1574072727_IS_ACTIVE = TRUE;SET @MIGRATION_1576497438_IS_ACTIVE = TRUE;SET @MIGRATION_1576497500_IS_ACTIVE = TRUE;SET @MIGRATION_1576503670_IS_ACTIVE = TRUE;SET @MIGRATION_1576505995_IS_ACTIVE = TRUE;SET @MIGRATION_1577972394_IS_ACTIVE = TRUE;SET @MIGRATION_1578049087_IS_ACTIVE = TRUE;SET @MIGRATION_1578066584_IS_ACTIVE = TRUE;SET @MIGRATION_1584096712_IS_ACTIVE = TRUE;SET @MIGRATION_1585054485_IS_ACTIVE = TRUE;SET @MIGRATION_1585055462_IS_ACTIVE = TRUE;SET @MIGRATION_1587976714_IS_ACTIVE = TRUE;SET @MIGRATION_1587988241_IS_ACTIVE = TRUE;SET @MIGRATION_1592301104_IS_ACTIVE = TRUE;SET @MIGRATION_1602233999_IS_ACTIVE = TRUE;SET @MIGRATION_1602832962_IS_ACTIVE = TRUE;SET @MIGRATION_1607683101_IS_ACTIVE = TRUE;SET @MIGRATION_1611068135_IS_ACTIVE = TRUE;SET @MIGRATION_1614764106_IS_ACTIVE = TRUE;SET @MIGRATION_1625817765_IS_ACTIVE = TRUE;SET @MIGRATION_1630049295_IS_ACTIVE = TRUE;SET @MIGRATION_1636367162_IS_ACTIVE = TRUE;SET @MIGRATION_1642147726_IS_ACTIVE = TRUE;SET @MIGRATION_1646304817_IS_ACTIVE = TRUE;SET @MIGRATION_1648797644_IS_ACTIVE = TRUE;SET @MIGRATION_1649245702_IS_ACTIVE = TRUE;SET @MIGRATION_1652692175_IS_ACTIVE = TRUE;SET @MIGRATION_1653310700_IS_ACTIVE = TRUE;SET @MIGRATION_1653661469_IS_ACTIVE = TRUE;SET @MIGRATION_1680157673_IS_ACTIVE = TRUE;SET @MIGRATION_1695646927_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1580372363_IS_ACTIVE = TRUE;SET @MIGRATION_1572516630_IS_ACTIVE = TRUE;SET @MIGRATION_1608027541_IS_ACTIVE = TRUE;SET @MIGRATION_1614589470_IS_ACTIVE = TRUE;SET @MIGRATION_1621937029_IS_ACTIVE = TRUE;SET @MIGRATION_1643985460_IS_ACTIVE = TRUE;SET @MIGRATION_1654223780_IS_ACTIVE = TRUE;SET @MIGRATION_1659962090_IS_ACTIVE = TRUE;SET @MIGRATION_1666007247_IS_ACTIVE = TRUE;SET @MIGRATION_1675941088_IS_ACTIVE = TRUE;SET @MIGRATION_1678198528_IS_ACTIVE = TRUE;SET @MIGRATION_1679899712_IS_ACTIVE = TRUE;SET @MIGRATION_1607943579_IS_ACTIVE = TRUE;SET @MIGRATION_1574369764_IS_ACTIVE = TRUE;SET @MIGRATION_1591973412_IS_ACTIVE = TRUE;SET @MIGRATION_1614600908_IS_ACTIVE = TRUE;SET @MIGRATION_1678420300_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1599061470_IS_ACTIVE = TRUE;SET @MIGRATION_1601109049_IS_ACTIVE = TRUE;SET @MIGRATION_1601644745_IS_ACTIVE = TRUE;SET @MIGRATION_1612123152_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1630528279_IS_ACTIVE = TRUE;SET @MIGRATION_1630568533_IS_ACTIVE = TRUE;SET @MIGRATION_1631877763_IS_ACTIVE = TRUE;SET @MIGRATION_1637415594_IS_ACTIVE = TRUE;SET @MIGRATION_1649840360_IS_ACTIVE = TRUE;SET @MIGRATION_1629959675_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1641220571_IS_ACTIVE = TRUE;SET @MIGRATION_1641220589_IS_ACTIVE = TRUE;SET @MIGRATION_1641294288_IS_ACTIVE = TRUE;SET @MIGRATION_1641301453_IS_ACTIVE = TRUE;SET @MIGRATION_1654076295_IS_ACTIVE = TRUE;SET @MIGRATION_1634908696_IS_ACTIVE = TRUE;SET @MIGRATION_1634908697_IS_ACTIVE = TRUE;SET @MIGRATION_1651055336_IS_ACTIVE = TRUE;SET @MIGRATION_1651055337_IS_ACTIVE = TRUE;SET @MIGRATION_1651055338_IS_ACTIVE = TRUE;SET @MIGRATION_1651055339_IS_ACTIVE = TRUE;SET @MIGRATION_1651055340_IS_ACTIVE = TRUE;SET @MIGRATION_1664523803_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1635807588_IS_ACTIVE = TRUE;SET @MIGRATION_1647868754_IS_ACTIVE = TRUE;SET @MIGRATION_1651153687_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205551_IS_ACTIVE = TRUE;SET @MIGRATION_1580205552_IS_ACTIVE = TRUE;SET @MIGRATION_1603787192_IS_ACTIVE = TRUE;SET @MIGRATION_1603787193_IS_ACTIVE = TRUE;SET @MIGRATION_1608909056_IS_ACTIVE = TRUE;SET @MIGRATION_1608909057_IS_ACTIVE = TRUE;SET @MIGRATION_1608909058_IS_ACTIVE = TRUE;SET @MIGRATION_1609840337_IS_ACTIVE = TRUE;SET @MIGRATION_1609840338_IS_ACTIVE = TRUE;SET @MIGRATION_1610290148_IS_ACTIVE = TRUE;SET @MIGRATION_1615974752_IS_ACTIVE = TRUE;SET @MIGRATION_1615974753_IS_ACTIVE = TRUE;SET @MIGRATION_1615974754_IS_ACTIVE = TRUE;SET @MIGRATION_1616854566_IS_ACTIVE = TRUE;SET @MIGRATION_1641641753_IS_ACTIVE = TRUE;SET @MIGRATION_1652087759_IS_ACTIVE = TRUE;SET @MIGRATION_1652087760_IS_ACTIVE = TRUE;SET @MIGRATION_1606161592_IS_ACTIVE = TRUE;SET @MIGRATION_1631562038_IS_ACTIVE = TRUE;SET @MIGRATION_1677008121_IS_ACTIVE = TRUE;SET @MIGRATION_1644444653_IS_ACTIVE = TRUE;SET @MIGRATION_1646323046_IS_ACTIVE = TRUE;SET @MIGRATION_1649757031_IS_ACTIVE = TRUE;SET @MIGRATION_1649855500_IS_ACTIVE = TRUE;SET @MIGRATION_1652378950_IS_ACTIVE = TRUE;SET @MIGRATION_1655284154_IS_ACTIVE = TRUE;SET @MIGRATION_1647442805_IS_ACTIVE = TRUE;SET @MIGRATION_1667823008_IS_ACTIVE = TRUE;SET @MIGRATION_1688564727_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1605903707_IS_ACTIVE = TRUE;SET @MIGRATION_1614425911_IS_ACTIVE = TRUE;SET @MIGRATION_1614437579_IS_ACTIVE = TRUE;SET @MIGRATION_1636555285_IS_ACTIVE = TRUE;SET @MIGRATION_1641824954_IS_ACTIVE = TRUE;SET @MIGRATION_1682496975_IS_ACTIVE = TRUE;SET @MIGRATION_1684135126_IS_ACTIVE = TRUE;SET @MIGRATION_1684309102_IS_ACTIVE = TRUE;SET @MIGRATION_1698047116_IS_ACTIVE = TRUE;SET @MIGRATION_1709034389_IS_ACTIVE = TRUE;SET @MIGRATION_1634173028_IS_ACTIVE = TRUE;SET @MIGRATION_1634662636_IS_ACTIVE = TRUE;SET @MIGRATION_1634662646_IS_ACTIVE = TRUE;SET @MIGRATION_1639405394_IS_ACTIVE = TRUE;SET @MIGRATION_1639405394_IS_ACTIVE = TRUE;SET @MIGRATION_1644950735_IS_ACTIVE = TRUE;SET @MIGRATION_1645014339_IS_ACTIVE = TRUE;SET @MIGRATION_1652433261_IS_ACTIVE = TRUE;SET @MIGRATION_1654696633_IS_ACTIVE = TRUE;SET @MIGRATION_1657212609_IS_ACTIVE = TRUE;SET @MIGRATION_1670321918_IS_ACTIVE = TRUE;SET @MIGRATION_1673875083_IS_ACTIVE = TRUE;SET @MIGRATION_1641558248_IS_ACTIVE = TRUE;SET @MIGRATION_1574147416_IS_ACTIVE = TRUE;SET @MIGRATION_1592389364_IS_ACTIVE = TRUE;SET @MIGRATION_1678444985_IS_ACTIVE = TRUE
View formatted query    View runnable query    View query stack
5 0.32 ms 
SELECT configuration_value FROM system_config WHERE (configuration_key = :configurationKey) AND ((sales_channel_id = :salesChannelId OR sales_channel_id IS NULL)) ORDER BY sales_channel_id IS NULL ASC LIMIT 1
View formatted query    View runnable query    View query stack
6 0.93 ms 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
View formatted query    View runnable query    View query stack
7 0.74 ms 
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = :param_70a20d209dba4035ab0d8d351720c909 AND `dreisc_seo_redirect`.`source_type` = :param_b6479de9d7d9496782a1cb95fc2f6a7a AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = :param_de76dd4bccc84112bcdc084f97a6c46f AND `dreisc_seo_redirect`.`source_path` = :param_067ed5ac6a8e42bb9bc0a1fa90f2bf47))
View formatted query    View runnable query    View query stack
8 5.68 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1
View formatted query    View runnable query    View query stack
9 1.06 ms 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
View formatted query    View runnable query    View query stack
10 0.24 ms 
#cart-persister::load
                SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = :token
View formatted query    View runnable query    View query stack
11 0.49 ms 
# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = :param_d1b4d43637214715b867a0e0c7805b28 AND `promotion.salesChannels`.`sales_channel_id` = :param_eb413a48319c434fb3a2a139256629b9 AND ((`promotion`.`valid_from` <=> :param_609f2f2d6f6e440b82f4b250790676ca AND `promotion`.`valid_until` <=> :param_2c0ff6a2b1d44642b0a75163f85a84b3) OR (`promotion`.`valid_from` <=> :param_a45ae8084d5f43c5ae2ed6a268ae551e AND (`promotion`.`valid_until` > :param_9a81c88d17734a47a5398a1598920347)) OR ((`promotion`.`valid_from` <= :param_23d20c512d3943468237463da6055655) AND `promotion`.`valid_until` <=> :param_20af3342f1a04d3daeb23f1352154ef3) OR ((`promotion`.`valid_from` <= :param_d43bc0e78c6b4dc6a30b2ccbdf9e21f2) AND (`promotion`.`valid_until` > :param_bece5b5889594ffd905c258849b41a8d))) AND `promotion`.`use_codes` = :param_43363085ab024e9b814bcaec205642ca)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
View formatted query    View runnable query    View query stack
12 1.90 ms 
# cart::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.ociShippingMethod`.`id` as `shipping_method.ociShippingMethod.id`, `shipping_method.ociShippingMethod`.`shipping_method_id` as `shipping_method.ociShippingMethod.shippingMethodId`, `shipping_method.ociShippingMethod`.`shipping_number` as `shipping_method.ociShippingMethod.shippingNumber`, `shipping_method.ociShippingMethod`.`shipping_intern_article_number` as `shipping_method.ociShippingMethod.shippingInternArticleNumber`, `shipping_method.ociShippingMethod`.`shipping_name` as `shipping_method.ociShippingMethod.shippingName`, `shipping_method.ociShippingMethod`.`created_at` as `shipping_method.ociShippingMethod.createdAt`, `shipping_method.ociShippingMethod`.`updated_at` as `shipping_method.ociShippingMethod.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = :languageId) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `agiqon_oci_shipping_method` `shipping_method.ociShippingMethod` ON `shipping_method`.`id` = `shipping_method.ociShippingMethod`.`shipping_method_id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = :languageId) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
13 0.31 ms 
# cart::shipping-methods::association::prices::read
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (:param_0e51e0ab93b741e78fbda649dcf96f71))
View formatted query    View runnable query    View query stack
14 3.75 ms 
SELECT `m28_scg_free_product`.`id` as `m28_scg_free_product.id`, `m28_scg_free_product`.`active` as `m28_scg_free_product.active`, `m28_scg_free_product`.`cart_value_net` as `m28_scg_free_product.cartValueNet`, `m28_scg_free_product`.`cart_value_gross` as `m28_scg_free_product.cartValueGross`, `m28_scg_free_product`.`add_link_to_product` as `m28_scg_free_product.addLinkToProduct`, `m28_scg_free_product`.`add_product_to_cart` as `m28_scg_free_product.addProductToCart`, `m28_scg_free_product`.`use_alternative_name` as `m28_scg_free_product.useAlternativeName`, `m28_scg_free_product`.`prevent_sale` as `m28_scg_free_product.preventSale`, `m28_scg_free_product`.`non_zero_product_price` as `m28_scg_free_product.nonZeroProductPrice`, `m28_scg_free_product`.`created_at` as `m28_scg_free_product.createdAt`, `m28_scg_free_product`.`updated_at` as `m28_scg_free_product.updatedAt`, `m28_scg_free_product`.`product_id` as `m28_scg_free_product.productId`, `m28_scg_free_product`.`rule_id` as `m28_scg_free_product.ruleId`, `m28_scg_free_product`.`count` as `m28_scg_free_product.count`, `m28_scg_free_product.translation.suffix`, COALESCE(`m28_scg_free_product.translation.suffix`,`m28_scg_free_product.translation.suffix`) as `m28_scg_free_product.suffix`, `m28_scg_free_product.translation.prefix`, COALESCE(`m28_scg_free_product.translation.prefix`,`m28_scg_free_product.translation.prefix`) as `m28_scg_free_product.prefix`, `m28_scg_free_product.translation.name`, COALESCE(`m28_scg_free_product.translation.name`,`m28_scg_free_product.translation.name`) as `m28_scg_free_product.name`, `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product` LEFT JOIN (SELECT `m28_scg_free_product.translation`.m28_scg_free_product_id, `m28_scg_free_product.translation`.suffix as `m28_scg_free_product.translation.suffix`, `m28_scg_free_product.translation`.prefix as `m28_scg_free_product.translation.prefix`, `m28_scg_free_product.translation`.name as `m28_scg_free_product.translation.name`, `m28_scg_free_product.translation`.created_at as `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation`.updated_at as `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation`.m28_scg_free_product_id as `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation`.language_id as `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product_translation` `m28_scg_free_product.translation` WHERE `m28_scg_free_product.translation`.language_id = :languageId) `m28_scg_free_product.m28_scg_free_product_translation` ON `m28_scg_free_product.m28_scg_free_product_translation`.`m28_scg_free_product_id` = `m28_scg_free_product`.`id`
View formatted query    View runnable query    View query stack
15 5.87 ms 
SELECT `m28_scg_free_product`.`id` as `m28_scg_free_product.id`, `m28_scg_free_product`.`active` as `m28_scg_free_product.active`, `m28_scg_free_product`.`cart_value_net` as `m28_scg_free_product.cartValueNet`, `m28_scg_free_product`.`cart_value_gross` as `m28_scg_free_product.cartValueGross`, `m28_scg_free_product`.`add_link_to_product` as `m28_scg_free_product.addLinkToProduct`, `m28_scg_free_product`.`add_product_to_cart` as `m28_scg_free_product.addProductToCart`, `m28_scg_free_product`.`use_alternative_name` as `m28_scg_free_product.useAlternativeName`, `m28_scg_free_product`.`prevent_sale` as `m28_scg_free_product.preventSale`, `m28_scg_free_product`.`non_zero_product_price` as `m28_scg_free_product.nonZeroProductPrice`, `m28_scg_free_product`.`created_at` as `m28_scg_free_product.createdAt`, `m28_scg_free_product`.`updated_at` as `m28_scg_free_product.updatedAt`, `m28_scg_free_product`.`product_id` as `m28_scg_free_product.productId`, `m28_scg_free_product`.`rule_id` as `m28_scg_free_product.ruleId`, `m28_scg_free_product`.`count` as `m28_scg_free_product.count`, `m28_scg_free_product.translation.suffix`, COALESCE(`m28_scg_free_product.translation.suffix`,`m28_scg_free_product.translation.suffix`) as `m28_scg_free_product.suffix`, `m28_scg_free_product.translation.prefix`, COALESCE(`m28_scg_free_product.translation.prefix`,`m28_scg_free_product.translation.prefix`) as `m28_scg_free_product.prefix`, `m28_scg_free_product.translation.name`, COALESCE(`m28_scg_free_product.translation.name`,`m28_scg_free_product.translation.name`) as `m28_scg_free_product.name`, `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product` LEFT JOIN (SELECT `m28_scg_free_product.translation`.m28_scg_free_product_id, `m28_scg_free_product.translation`.suffix as `m28_scg_free_product.translation.suffix`, `m28_scg_free_product.translation`.prefix as `m28_scg_free_product.translation.prefix`, `m28_scg_free_product.translation`.name as `m28_scg_free_product.translation.name`, `m28_scg_free_product.translation`.created_at as `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation`.updated_at as `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation`.m28_scg_free_product_id as `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation`.language_id as `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product_translation` `m28_scg_free_product.translation` WHERE `m28_scg_free_product.translation`.language_id = :languageId) `m28_scg_free_product.m28_scg_free_product_translation` ON `m28_scg_free_product.m28_scg_free_product_translation`.`m28_scg_free_product_id` = `m28_scg_free_product`.`id`
View formatted query    View runnable query    View query stack
16 1.30 ms 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_87c386463608410d84f0d0e5bdbdbbac)
View formatted query    View runnable query    View query stack
17 0.33 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
18 0.20 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
19 4.71 ms 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = :param_cb1e66bb6fb04b8fa0c7d5f474b63424)) AND (`country`.`id` IN (:ids)) GROUP BY `country`.`id`
View formatted query    View runnable query    View query stack
20 0.94 ms 
SELECT `m28_scg_free_product`.`id` as `m28_scg_free_product.id`, `m28_scg_free_product`.`active` as `m28_scg_free_product.active`, `m28_scg_free_product`.`cart_value_net` as `m28_scg_free_product.cartValueNet`, `m28_scg_free_product`.`cart_value_gross` as `m28_scg_free_product.cartValueGross`, `m28_scg_free_product`.`add_link_to_product` as `m28_scg_free_product.addLinkToProduct`, `m28_scg_free_product`.`add_product_to_cart` as `m28_scg_free_product.addProductToCart`, `m28_scg_free_product`.`use_alternative_name` as `m28_scg_free_product.useAlternativeName`, `m28_scg_free_product`.`prevent_sale` as `m28_scg_free_product.preventSale`, `m28_scg_free_product`.`non_zero_product_price` as `m28_scg_free_product.nonZeroProductPrice`, `m28_scg_free_product`.`created_at` as `m28_scg_free_product.createdAt`, `m28_scg_free_product`.`updated_at` as `m28_scg_free_product.updatedAt`, `m28_scg_free_product`.`product_id` as `m28_scg_free_product.productId`, `m28_scg_free_product`.`rule_id` as `m28_scg_free_product.ruleId`, `m28_scg_free_product`.`count` as `m28_scg_free_product.count`, `m28_scg_free_product.translation.suffix`, COALESCE(`m28_scg_free_product.translation.suffix`,`m28_scg_free_product.translation.suffix`) as `m28_scg_free_product.suffix`, `m28_scg_free_product.translation.prefix`, COALESCE(`m28_scg_free_product.translation.prefix`,`m28_scg_free_product.translation.prefix`) as `m28_scg_free_product.prefix`, `m28_scg_free_product.translation.name`, COALESCE(`m28_scg_free_product.translation.name`,`m28_scg_free_product.translation.name`) as `m28_scg_free_product.name`, `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product` LEFT JOIN (SELECT `m28_scg_free_product.translation`.m28_scg_free_product_id, `m28_scg_free_product.translation`.suffix as `m28_scg_free_product.translation.suffix`, `m28_scg_free_product.translation`.prefix as `m28_scg_free_product.translation.prefix`, `m28_scg_free_product.translation`.name as `m28_scg_free_product.translation.name`, `m28_scg_free_product.translation`.created_at as `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation`.updated_at as `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation`.m28_scg_free_product_id as `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation`.language_id as `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product_translation` `m28_scg_free_product.translation` WHERE `m28_scg_free_product.translation`.language_id = :languageId) `m28_scg_free_product.m28_scg_free_product_translation` ON `m28_scg_free_product.m28_scg_free_product_translation`.`m28_scg_free_product_id` = `m28_scg_free_product`.`id`
View formatted query    View runnable query    View query stack
21 1.57 ms 
SELECT `m28_scg_free_product`.`id` as `m28_scg_free_product.id`, `m28_scg_free_product`.`active` as `m28_scg_free_product.active`, `m28_scg_free_product`.`cart_value_net` as `m28_scg_free_product.cartValueNet`, `m28_scg_free_product`.`cart_value_gross` as `m28_scg_free_product.cartValueGross`, `m28_scg_free_product`.`add_link_to_product` as `m28_scg_free_product.addLinkToProduct`, `m28_scg_free_product`.`add_product_to_cart` as `m28_scg_free_product.addProductToCart`, `m28_scg_free_product`.`use_alternative_name` as `m28_scg_free_product.useAlternativeName`, `m28_scg_free_product`.`prevent_sale` as `m28_scg_free_product.preventSale`, `m28_scg_free_product`.`non_zero_product_price` as `m28_scg_free_product.nonZeroProductPrice`, `m28_scg_free_product`.`created_at` as `m28_scg_free_product.createdAt`, `m28_scg_free_product`.`updated_at` as `m28_scg_free_product.updatedAt`, `m28_scg_free_product`.`product_id` as `m28_scg_free_product.productId`, `m28_scg_free_product`.`rule_id` as `m28_scg_free_product.ruleId`, `m28_scg_free_product`.`count` as `m28_scg_free_product.count`, `m28_scg_free_product.translation.suffix`, COALESCE(`m28_scg_free_product.translation.suffix`,`m28_scg_free_product.translation.suffix`) as `m28_scg_free_product.suffix`, `m28_scg_free_product.translation.prefix`, COALESCE(`m28_scg_free_product.translation.prefix`,`m28_scg_free_product.translation.prefix`) as `m28_scg_free_product.prefix`, `m28_scg_free_product.translation.name`, COALESCE(`m28_scg_free_product.translation.name`,`m28_scg_free_product.translation.name`) as `m28_scg_free_product.name`, `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product` LEFT JOIN (SELECT `m28_scg_free_product.translation`.m28_scg_free_product_id, `m28_scg_free_product.translation`.suffix as `m28_scg_free_product.translation.suffix`, `m28_scg_free_product.translation`.prefix as `m28_scg_free_product.translation.prefix`, `m28_scg_free_product.translation`.name as `m28_scg_free_product.translation.name`, `m28_scg_free_product.translation`.created_at as `m28_scg_free_product.translation.createdAt`, `m28_scg_free_product.translation`.updated_at as `m28_scg_free_product.translation.updatedAt`, `m28_scg_free_product.translation`.m28_scg_free_product_id as `m28_scg_free_product.translation.m28ScgFreeProductId`, `m28_scg_free_product.translation`.language_id as `m28_scg_free_product.translation.languageId` FROM `m28_scg_free_product_translation` `m28_scg_free_product.translation` WHERE `m28_scg_free_product.translation`.language_id = :languageId) `m28_scg_free_product.m28_scg_free_product_translation` ON `m28_scg_free_product.m28_scg_free_product_translation`.`m28_scg_free_product_id` = `m28_scg_free_product`.`id`
View formatted query    View runnable query    View query stack
22 7.33 ms 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_78a47c691cd34ccca18ffeed8b06d957)
View formatted query    View runnable query    View query stack
23 0.45 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
24 0.23 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
25 3.13 ms 
# landing-page::data::search-ids
SELECT `landing_page`.`id` FROM `landing_page` LEFT JOIN `swag_dynamic_access_landing_page_rule` `landing_page.swagDynamicAccessRules.mapping` ON `landing_page`.`id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_id`  AND `landing_page`.`version_id` = `landing_page.swagDynamicAccessRules.mapping`.`landing_page_version_id` LEFT JOIN `landing_page_sales_channel` `landing_page.salesChannels.mapping` ON `landing_page`.`id` = `landing_page.salesChannels.mapping`.`landing_page_id`  AND `landing_page`.`version_id` = `landing_page.salesChannels.mapping`.`landing_page_version_id` LEFT JOIN `rule` `landing_page.swagDynamicAccessRules` ON `landing_page.swagDynamicAccessRules.mapping`.`rule_id` = `landing_page.swagDynamicAccessRules`.`id`  LEFT JOIN `sales_channel` `landing_page.salesChannels` ON `landing_page.salesChannels.mapping`.`sales_channel_id` = `landing_page.salesChannels`.`id`  WHERE (`landing_page`.`version_id` = :version) AND ((`landing_page`.`active` = :param_22e252d263a04738b880000e121561a8 AND `landing_page.salesChannels`.`id` = :param_da73f3173b374abfba62184d1eb32c15 AND (`landing_page.swagDynamicAccessRules`.`id` IN (:param_841be86ed7324f919027b22dafb6425c) OR `landing_page.swagDynamicAccessRules`.`id` <=> :param_e5c9cda228964b6aa5cc11c14e9aa920))) AND (`landing_page`.`id` IN (:ids)) GROUP BY `landing_page`.`id`
View formatted query    View runnable query    View query stack
26 2.33 ms 
# landing-page::data::read
SELECT `landing_page`.`id` as `landing_page.id`, `landing_page`.`version_id` as `landing_page.versionId`, `landing_page`.`active` as `landing_page.active`, `landing_page`.`cms_page_id` as `landing_page.cmsPageId`, `landing_page`.`cms_page_version_id` as `landing_page.cmsPageVersionId`, `landing_page`.`created_at` as `landing_page.createdAt`, `landing_page`.`updated_at` as `landing_page.updatedAt`, `landing_page.translation.name`, COALESCE(`landing_page.translation.name`,`landing_page.translation.name`) as `landing_page.name`, `landing_page.translation.url`, COALESCE(`landing_page.translation.url`,`landing_page.translation.url`) as `landing_page.url`, `landing_page.translation.slotConfig`, COALESCE(`landing_page.translation.slotConfig`,`landing_page.translation.slotConfig`) as `landing_page.slotConfig`, `landing_page.translation.metaTitle`, COALESCE(`landing_page.translation.metaTitle`,`landing_page.translation.metaTitle`) as `landing_page.metaTitle`, `landing_page.translation.metaDescription`, COALESCE(`landing_page.translation.metaDescription`,`landing_page.translation.metaDescription`) as `landing_page.metaDescription`, `landing_page.translation.keywords`, COALESCE(`landing_page.translation.keywords`,`landing_page.translation.keywords`) as `landing_page.keywords`, `landing_page.translation.customFields`, COALESCE(`landing_page.translation.customFields`,`landing_page.translation.customFields`) as `landing_page.customFields`, `landing_page.translation.createdAt`, `landing_page.translation.updatedAt`, `landing_page.translation.landingPageId`, `landing_page.translation.languageId`, `landing_page.translation.landingPageVersionId` FROM `landing_page` LEFT JOIN (SELECT `landing_page.translation`.landing_page_id, `landing_page.translation`.landing_page_version_id, `landing_page.translation`.name as `landing_page.translation.name`, `landing_page.translation`.url as `landing_page.translation.url`, `landing_page.translation`.slot_config as `landing_page.translation.slotConfig`, `landing_page.translation`.meta_title as `landing_page.translation.metaTitle`, `landing_page.translation`.meta_description as `landing_page.translation.metaDescription`, `landing_page.translation`.keywords as `landing_page.translation.keywords`, `landing_page.translation`.custom_fields as `landing_page.translation.customFields`, `landing_page.translation`.created_at as `landing_page.translation.createdAt`, `landing_page.translation`.updated_at as `landing_page.translation.updatedAt`, `landing_page.translation`.landing_page_id as `landing_page.translation.landingPageId`, `landing_page.translation`.language_id as `landing_page.translation.languageId`, `landing_page.translation`.landing_page_version_id as `landing_page.translation.landingPageVersionId` FROM `landing_page_translation` `landing_page.translation` WHERE `landing_page.translation`.language_id = :languageId) `landing_page.landing_page_translation` ON `landing_page.landing_page_translation`.`landing_page_id` = `landing_page`.`id` AND `landing_page.landing_page_translation`.landing_page_version_id = `landing_page`.version_id WHERE (`landing_page`.`version_id` = :version) AND (`landing_page`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
27 1.73 ms 
# landing-page::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields`, `cms_page.translation.createdAt`, `cms_page.translation.updatedAt`, `cms_page.translation.cmsPageId`, `cms_page.translation.languageId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id as `cms_page.translation.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = :languageId) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = :version) AND (`cms_page`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
28 2.88 ms 
# landing-page::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.uandiMediaExtension`.`id` as `cms_section.backgroundMedia.uandiMediaExtension.id`, `cms_section.backgroundMedia.uandiMediaExtension`.`media_id` as `cms_section.backgroundMedia.uandiMediaExtension.mediaId`, `cms_section.backgroundMedia.uandiMediaExtension`.`priority` as `cms_section.backgroundMedia.uandiMediaExtension.priority`, `cms_section.backgroundMedia.uandiMediaExtension`.`created_at` as `cms_section.backgroundMedia.uandiMediaExtension.createdAt`, `cms_section.backgroundMedia.uandiMediaExtension`.`updated_at` as `cms_section.backgroundMedia.uandiMediaExtension.updatedAt`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = :languageId) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN `uandi_media_extension` `cms_section.backgroundMedia.uandiMediaExtension` ON `cms_section.backgroundMedia`.`id` = `cms_section.backgroundMedia.uandiMediaExtension`.`media_id` WHERE (`cms_section`.`version_id` = :version) AND ((`cms_section`.`cms_page_id` IN (:param_1c3ae3beac60425a91b354edf889446c)))
View formatted query    View runnable query    View query stack
29 0.19 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
View formatted query    View runnable query    View query stack
30 5.66 ms 
# landing-page::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.uandiMediaExtension`.`id` as `cms_block.backgroundMedia.uandiMediaExtension.id`, `cms_block.backgroundMedia.uandiMediaExtension`.`media_id` as `cms_block.backgroundMedia.uandiMediaExtension.mediaId`, `cms_block.backgroundMedia.uandiMediaExtension`.`priority` as `cms_block.backgroundMedia.uandiMediaExtension.priority`, `cms_block.backgroundMedia.uandiMediaExtension`.`created_at` as `cms_block.backgroundMedia.uandiMediaExtension.createdAt`, `cms_block.backgroundMedia.uandiMediaExtension`.`updated_at` as `cms_block.backgroundMedia.uandiMediaExtension.updatedAt`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = :languageId) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN `uandi_media_extension` `cms_block.backgroundMedia.uandiMediaExtension` ON `cms_block.backgroundMedia`.`id` = `cms_block.backgroundMedia.uandiMediaExtension`.`media_id` WHERE (`cms_block`.`version_id` = :version) AND ((`cms_block`.`cms_section_id` IN (:param_17a294fc89c74b638b854f6b1008faa2)))
View formatted query    View runnable query    View query stack
31 8.53 ms 
# landing-page::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = :languageId) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = :version) AND ((`cms_slot`.`cms_block_id` IN (:param_0b69a8309c2f41c699e2ffc620a740c1)))
View formatted query    View runnable query    View query stack
32 2.63 ms 
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.uandiMediaExtension`.`id` as `media.uandiMediaExtension.id`, `media.uandiMediaExtension`.`media_id` as `media.uandiMediaExtension.mediaId`, `media.uandiMediaExtension`.`priority` as `media.uandiMediaExtension.priority`, `media.uandiMediaExtension`.`created_at` as `media.uandiMediaExtension.createdAt`, `media.uandiMediaExtension`.`updated_at` as `media.uandiMediaExtension.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = :languageId) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `uandi_media_extension` `media.uandiMediaExtension` ON `media`.`id` = `media.uandiMediaExtension`.`media_id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = :param_486ef70ef62448a685bb369093a3249e OR (`media`.`private` = :param_3314f486789a4eceabab6b4b6c09d037 AND `media.mediaFolder.defaultFolder`.`entity` = :param_e1d437d2b9e348f69ff05ca80df79c49)))) AND (`media`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
33 3.51 ms 
# cms::netzp-blog-listing::aggregation::categories
SELECT LOWER(HEX(`s_plugin_netzp_blog.category`.`id`)) as `categories` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_6f7602eb0dc7441f88d142d7eb6f3e98))) `s_plugin_netzp_blog.categories_1` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_1`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_215d63ef97cf4c849ea22155f578732f))) `s_plugin_netzp_blog.categories_2` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_2`.`id` WHERE ((`s_plugin_netzp_blog`.`categoryid` = :param_2d36e1d6638249309018a961d4a1eea9 OR `s_plugin_netzp_blog.categories_1`.id IS NOT NULL) AND ((`s_plugin_netzp_blog`.`showfrom` <= :param_0e82e0d2562741b1a45f626dbbb751e0) OR `s_plugin_netzp_blog`.`showfrom` <=> :param_23adfd9823284100844f6c0ae42df6bd) AND ((`s_plugin_netzp_blog`.`showuntil` >= :param_819a05e2e0124315a6c62cf41cff72a9) OR `s_plugin_netzp_blog`.`showuntil` <=> :param_2f4fdfac0bdd4337a72399fc74c9fa19) AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> :param_adb3d7e484d84595b2728d8be214efa7 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_7e6a983e91454611a76811e3be4b4975 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_05eeaef9ab004bad94e61bc0144df33d) AND (`s_plugin_netzp_blog`.`categoryid` = :param_4b7c4615878f404bafb27c1f90f4968f OR `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_d45553cb0b0c46dc9fdfaa347e732478 OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = :param_a4520edbe8e2431d81360ce44001510a AND `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_8946dc143b27485599982c7a8581480a)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_a6cd7ccf1c024f80a52e700e2eebc503 OR `s_plugin_netzp_blog.category`.`customergroup_id` = :param_4ff2e429bd01460a9d479f6ccb2987aa OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_185ccf6b01c04431a4711298969e2008) AND `s_plugin_netzp_blog.category`.`customergroup_id` = :param_f3964064c0ea4762b6accea596c2f8d9)) AND (`s_plugin_netzp_blog`.`categoryid` = :param_849f3f7194f3467a82ff6d313e52080a OR `s_plugin_netzp_blog.categories_2`.id IS NOT NULL)) GROUP BY `s_plugin_netzp_blog.category`.`id`
View formatted query    View runnable query    View query stack
34 8.53 ms 
# categories-aggregation::read
SELECT `s_plugin_netzp_blog_category`.`id` as `s_plugin_netzp_blog_category.id`, `s_plugin_netzp_blog_category`.`cmspageid` as `s_plugin_netzp_blog_category.cmspageid`, `s_plugin_netzp_blog_category`.`saleschannel_id` as `s_plugin_netzp_blog_category.saleschannelid`, `s_plugin_netzp_blog_category`.`customergroup_id` as `s_plugin_netzp_blog_category.customergroupid`, `s_plugin_netzp_blog_category`.`onlyloggedin` as `s_plugin_netzp_blog_category.onlyloggedin`, `s_plugin_netzp_blog_category`.`includeinrss` as `s_plugin_netzp_blog_category.includeinrss`, `s_plugin_netzp_blog_category.saleschannel`.`id` as `s_plugin_netzp_blog_category.saleschannel.id`, `s_plugin_netzp_blog_category.saleschannel`.`type_id` as `s_plugin_netzp_blog_category.saleschannel.typeId`, `s_plugin_netzp_blog_category.saleschannel`.`language_id` as `s_plugin_netzp_blog_category.saleschannel.languageId`, `s_plugin_netzp_blog_category.saleschannel`.`customer_group_id` as `s_plugin_netzp_blog_category.saleschannel.customerGroupId`, `s_plugin_netzp_blog_category.saleschannel`.`currency_id` as `s_plugin_netzp_blog_category.saleschannel.currencyId`, `s_plugin_netzp_blog_category.saleschannel`.`payment_method_id` as `s_plugin_netzp_blog_category.saleschannel.paymentMethodId`, `s_plugin_netzp_blog_category.saleschannel`.`shipping_method_id` as `s_plugin_netzp_blog_category.saleschannel.shippingMethodId`, `s_plugin_netzp_blog_category.saleschannel`.`country_id` as `s_plugin_netzp_blog_category.saleschannel.countryId`, `s_plugin_netzp_blog_category.saleschannel`.`analytics_id` as `s_plugin_netzp_blog_category.saleschannel.analyticsId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_id` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_depth` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryDepth`, `s_plugin_netzp_blog_category.saleschannel`.`footer_category_id` as `s_plugin_netzp_blog_category.saleschannel.footerCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`footer_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.footerCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`service_category_id` as `s_plugin_netzp_blog_category.saleschannel.serviceCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`service_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.serviceCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`mail_header_footer_id` as `s_plugin_netzp_blog_category.saleschannel.mailHeaderFooterId`, `s_plugin_netzp_blog_category.saleschannel`.`hreflang_default_domain_id` as `s_plugin_netzp_blog_category.saleschannel.hreflangDefaultDomainId`, `s_plugin_netzp_blog_category.saleschannel`.`short_name` as `s_plugin_netzp_blog_category.saleschannel.shortName`, `s_plugin_netzp_blog_category.saleschannel`.`tax_calculation_type` as `s_plugin_netzp_blog_category.saleschannel.taxCalculationType`, `s_plugin_netzp_blog_category.saleschannel`.`access_key` as `s_plugin_netzp_blog_category.saleschannel.accessKey`, `s_plugin_netzp_blog_category.saleschannel`.`configuration` as `s_plugin_netzp_blog_category.saleschannel.configuration`, `s_plugin_netzp_blog_category.saleschannel`.`active` as `s_plugin_netzp_blog_category.saleschannel.active`, `s_plugin_netzp_blog_category.saleschannel`.`hreflang_active` as `s_plugin_netzp_blog_category.saleschannel.hreflangActive`, `s_plugin_netzp_blog_category.saleschannel`.`maintenance` as `s_plugin_netzp_blog_category.saleschannel.maintenance`, `s_plugin_netzp_blog_category.saleschannel`.`maintenance_ip_whitelist` as `s_plugin_netzp_blog_category.saleschannel.maintenanceIpWhitelist`, `s_plugin_netzp_blog_category.saleschannel`.`payment_method_ids` as `s_plugin_netzp_blog_category.saleschannel.paymentMethodIds`, `s_plugin_netzp_blog_category.saleschannel`.`home_cms_page_id` as `s_plugin_netzp_blog_category.saleschannel.homeCmsPageId`, `s_plugin_netzp_blog_category.saleschannel`.`home_cms_page_version_id` as `s_plugin_netzp_blog_category.saleschannel.homeCmsPageVersionId`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`id` as `s_plugin_netzp_blog_category.saleschannel.analytics.id`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`tracking_id` as `s_plugin_netzp_blog_category.saleschannel.analytics.trackingId`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`active` as `s_plugin_netzp_blog_category.saleschannel.analytics.active`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`track_orders` as `s_plugin_netzp_blog_category.saleschannel.analytics.trackOrders`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`anonymize_ip` as `s_plugin_netzp_blog_category.saleschannel.analytics.anonymizeIp`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`created_at` as `s_plugin_netzp_blog_category.saleschannel.analytics.createdAt`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`updated_at` as `s_plugin_netzp_blog_category.saleschannel.analytics.updatedAt`, `s_plugin_netzp_blog_category.saleschannel`.`created_at` as `s_plugin_netzp_blog_category.saleschannel.createdAt`, `s_plugin_netzp_blog_category.saleschannel`.`updated_at` as `s_plugin_netzp_blog_category.saleschannel.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation.name`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.name`,`s_plugin_netzp_blog_category.saleschannel.translation.name`) as `s_plugin_netzp_blog_category.saleschannel.name`, `s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`,`s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`) as `s_plugin_netzp_blog_category.saleschannel.homeSlotConfig`, `s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`,`s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`) as `s_plugin_netzp_blog_category.saleschannel.homeEnabled`, `s_plugin_netzp_blog_category.saleschannel.translation.homeName`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeName`,`s_plugin_netzp_blog_category.saleschannel.translation.homeName`) as `s_plugin_netzp_blog_category.saleschannel.homeName`, `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`,`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`) as `s_plugin_netzp_blog_category.saleschannel.homeMetaTitle`, `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`,`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`) as `s_plugin_netzp_blog_category.saleschannel.homeMetaDescription`, `s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`,`s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`) as `s_plugin_netzp_blog_category.saleschannel.homeKeywords`, `s_plugin_netzp_blog_category.saleschannel.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.customFields`,`s_plugin_netzp_blog_category.saleschannel.translation.customFields`) as `s_plugin_netzp_blog_category.saleschannel.customFields`, `s_plugin_netzp_blog_category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog_category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog_category.saleschannel.translation.languageId`, `s_plugin_netzp_blog_category.customergroup`.`id` as `s_plugin_netzp_blog_category.customergroup.id`, `s_plugin_netzp_blog_category.customergroup`.`display_gross` as `s_plugin_netzp_blog_category.customergroup.displayGross`, `s_plugin_netzp_blog_category.customergroup`.`registration_active` as `s_plugin_netzp_blog_category.customergroup.registrationActive`, `s_plugin_netzp_blog_category.customergroup`.`created_at` as `s_plugin_netzp_blog_category.customergroup.createdAt`, `s_plugin_netzp_blog_category.customergroup`.`updated_at` as `s_plugin_netzp_blog_category.customergroup.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation.name`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.name`,`s_plugin_netzp_blog_category.customergroup.translation.name`) as `s_plugin_netzp_blog_category.customergroup.name`, `s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`,`s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`) as `s_plugin_netzp_blog_category.customergroup.registrationTitle`, `s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`,`s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`) as `s_plugin_netzp_blog_category.customergroup.registrationIntroduction`, `s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`,`s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`) as `s_plugin_netzp_blog_category.customergroup.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`,`s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`) as `s_plugin_netzp_blog_category.customergroup.registrationSeoMetaDescription`, `s_plugin_netzp_blog_category.customergroup.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.customFields`,`s_plugin_netzp_blog_category.customergroup.translation.customFields`) as `s_plugin_netzp_blog_category.customergroup.customFields`, `s_plugin_netzp_blog_category.customergroup.translation.createdAt`, `s_plugin_netzp_blog_category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog_category.customergroup.translation.languageId`, `s_plugin_netzp_blog_category`.`created_at` as `s_plugin_netzp_blog_category.createdAt`, `s_plugin_netzp_blog_category`.`updated_at` as `s_plugin_netzp_blog_category.updatedAt`, `s_plugin_netzp_blog_category.translation.title`, COALESCE(`s_plugin_netzp_blog_category.translation.title`,`s_plugin_netzp_blog_category.translation.title`) as `s_plugin_netzp_blog_category.title`, `s_plugin_netzp_blog_category.translation.teaser`, COALESCE(`s_plugin_netzp_blog_category.translation.teaser`,`s_plugin_netzp_blog_category.translation.teaser`) as `s_plugin_netzp_blog_category.teaser`, `s_plugin_netzp_blog_category.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.translation.customFields`,`s_plugin_netzp_blog_category.translation.customFields`) as `s_plugin_netzp_blog_category.customFields`, `s_plugin_netzp_blog_category.translation.createdAt`, `s_plugin_netzp_blog_category.translation.updatedAt`, `s_plugin_netzp_blog_category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog_category.translation.languageId` FROM `s_plugin_netzp_blog_category` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.translation`.s_plugin_netzp_blog_category_id, `s_plugin_netzp_blog_category.translation`.title as `s_plugin_netzp_blog_category.translation.title`, `s_plugin_netzp_blog_category.translation`.teaser as `s_plugin_netzp_blog_category.translation.teaser`, `s_plugin_netzp_blog_category.translation`.custom_fields as `s_plugin_netzp_blog_category.translation.customFields`, `s_plugin_netzp_blog_category.translation`.created_at as `s_plugin_netzp_blog_category.translation.createdAt`, `s_plugin_netzp_blog_category.translation`.updated_at as `s_plugin_netzp_blog_category.translation.updatedAt`, `s_plugin_netzp_blog_category.translation`.s_plugin_netzp_blog_category_id as `s_plugin_netzp_blog_category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog_category.translation`.language_id as `s_plugin_netzp_blog_category.translation.languageId` FROM `s_plugin_netzp_blog_category_translation` `s_plugin_netzp_blog_category.translation` WHERE `s_plugin_netzp_blog_category.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.s_plugin_netzp_blog_category_translation` ON `s_plugin_netzp_blog_category.s_plugin_netzp_blog_category_translation`.`s_plugin_netzp_blog_category_id` = `s_plugin_netzp_blog_category`.`id` LEFT JOIN `sales_channel` `s_plugin_netzp_blog_category.saleschannel` ON `s_plugin_netzp_blog_category`.`saleschannel_id` = `s_plugin_netzp_blog_category.saleschannel`.`id` LEFT JOIN `customer_group` `s_plugin_netzp_blog_category.customergroup` ON `s_plugin_netzp_blog_category`.`customergroup_id` = `s_plugin_netzp_blog_category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.saleschannel.translation`.sales_channel_id, `s_plugin_netzp_blog_category.saleschannel.translation`.name as `s_plugin_netzp_blog_category.saleschannel.translation.name`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_slot_config as `s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_enabled as `s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_name as `s_plugin_netzp_blog_category.saleschannel.translation.homeName`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_meta_title as `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_meta_description as `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_keywords as `s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`, `s_plugin_netzp_blog_category.saleschannel.translation`.custom_fields as `s_plugin_netzp_blog_category.saleschannel.translation.customFields`, `s_plugin_netzp_blog_category.saleschannel.translation`.created_at as `s_plugin_netzp_blog_category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog_category.saleschannel.translation`.updated_at as `s_plugin_netzp_blog_category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation`.sales_channel_id as `s_plugin_netzp_blog_category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog_category.saleschannel.translation`.language_id as `s_plugin_netzp_blog_category.saleschannel.translation.languageId` FROM `sales_channel_translation` `s_plugin_netzp_blog_category.saleschannel.translation` WHERE `s_plugin_netzp_blog_category.saleschannel.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.saleschannel.sales_channel_translation` ON `s_plugin_netzp_blog_category.saleschannel.sales_channel_translation`.`sales_channel_id` = `s_plugin_netzp_blog_category.saleschannel`.`id` LEFT JOIN `sales_channel_analytics` `s_plugin_netzp_blog_category.saleschannel.analytics` ON `s_plugin_netzp_blog_category.saleschannel`.`analytics_id` = `s_plugin_netzp_blog_category.saleschannel.analytics`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.customergroup.translation`.customer_group_id, `s_plugin_netzp_blog_category.customergroup.translation`.name as `s_plugin_netzp_blog_category.customergroup.translation.name`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_title as `s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_introduction as `s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_only_company_registration as `s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_seo_meta_description as `s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`, `s_plugin_netzp_blog_category.customergroup.translation`.custom_fields as `s_plugin_netzp_blog_category.customergroup.translation.customFields`, `s_plugin_netzp_blog_category.customergroup.translation`.created_at as `s_plugin_netzp_blog_category.customergroup.translation.createdAt`, `s_plugin_netzp_blog_category.customergroup.translation`.updated_at as `s_plugin_netzp_blog_category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation`.customer_group_id as `s_plugin_netzp_blog_category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog_category.customergroup.translation`.language_id as `s_plugin_netzp_blog_category.customergroup.translation.languageId` FROM `customer_group_translation` `s_plugin_netzp_blog_category.customergroup.translation` WHERE `s_plugin_netzp_blog_category.customergroup.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.customergroup.customer_group_translation` ON `s_plugin_netzp_blog_category.customergroup.customer_group_translation`.`customer_group_id` = `s_plugin_netzp_blog_category.customergroup`.`id` WHERE `s_plugin_netzp_blog_category`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
35 2.37 ms 
# cms::netzp-blog-listing::aggregation::authors
SELECT LOWER(HEX(`s_plugin_netzp_blog.author`.`id`)) as `authors` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_3840f403986044f3becaddbf3fa2d277))) `s_plugin_netzp_blog.categories_1` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_1`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_61800fdc61a74901bb5456cd88db63ef))) `s_plugin_netzp_blog.categories_2` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_2`.`id` LEFT JOIN `s_plugin_netzp_blog_author` `s_plugin_netzp_blog.author` ON `s_plugin_netzp_blog`.`authorid` = `s_plugin_netzp_blog.author`.`id` WHERE ((`s_plugin_netzp_blog`.`categoryid` = :param_3ba33c6378ba4a14b77749df894a7f1e OR `s_plugin_netzp_blog.categories_1`.id IS NOT NULL) AND ((`s_plugin_netzp_blog`.`showfrom` <= :param_d250130fafeb420aac5738b5163f5f4b) OR `s_plugin_netzp_blog`.`showfrom` <=> :param_4b6af11f3ab1454a99e35d367fa309f4) AND ((`s_plugin_netzp_blog`.`showuntil` >= :param_33038348f31240a8bd594c4643931d13) OR `s_plugin_netzp_blog`.`showuntil` <=> :param_40b1546a765f47f199019ec79149bb71) AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> :param_713d6540fb244afda3f02294b59fb374 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_741d0c92033547a8ac620d230554a36e OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_3b7967028933408a8351cc1807551927) AND (`s_plugin_netzp_blog`.`categoryid` = :param_2b5d1cb712b74cf6a4fc3b790200461d OR `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_6b0bd226e8cd4ed2beec92813c4f9a4a OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = :param_a43c5688e95c422c9ef471da2ae6aa45 AND `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_c3fd35e929dd4b30befac16a193cd152)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_a7d0ed624cc747aa83f0ff6c8359f503 OR `s_plugin_netzp_blog.category`.`customergroup_id` = :param_eb90d19a344f4e4da3de299807c16729 OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_821cd0e8e1a449949d242672c8e16fee) AND `s_plugin_netzp_blog.category`.`customergroup_id` = :param_5087e4272f4b4ccfa22d7c5d3c23a447)) AND (`s_plugin_netzp_blog`.`categoryid` = :param_d30c0bc6fcd242058abb6f0e0ec5753d OR `s_plugin_netzp_blog.categories_2`.id IS NOT NULL)) GROUP BY `s_plugin_netzp_blog.author`.`id`
View formatted query    View runnable query    View query stack
36 3.08 ms 
# authors-aggregation::read
SELECT `s_plugin_netzp_blog_author`.`id` as `s_plugin_netzp_blog_author.id`, `s_plugin_netzp_blog_author`.`imageid` as `s_plugin_netzp_blog_author.imageid`, `s_plugin_netzp_blog_author.image`.`id` as `s_plugin_netzp_blog_author.image.id`, `s_plugin_netzp_blog_author.image`.`user_id` as `s_plugin_netzp_blog_author.image.userId`, `s_plugin_netzp_blog_author.image`.`media_folder_id` as `s_plugin_netzp_blog_author.image.mediaFolderId`, `s_plugin_netzp_blog_author.image`.`mime_type` as `s_plugin_netzp_blog_author.image.mimeType`, `s_plugin_netzp_blog_author.image`.`file_extension` as `s_plugin_netzp_blog_author.image.fileExtension`, `s_plugin_netzp_blog_author.image`.`uploaded_at` as `s_plugin_netzp_blog_author.image.uploadedAt`, `s_plugin_netzp_blog_author.image`.`file_name` as `s_plugin_netzp_blog_author.image.fileName`, `s_plugin_netzp_blog_author.image`.`file_size` as `s_plugin_netzp_blog_author.image.fileSize`, `s_plugin_netzp_blog_author.image`.`media_type` as `s_plugin_netzp_blog_author.image.mediaTypeRaw`, `s_plugin_netzp_blog_author.image`.`meta_data` as `s_plugin_netzp_blog_author.image.metaData`, `s_plugin_netzp_blog_author.image`.`private` as `s_plugin_netzp_blog_author.image.private`, `s_plugin_netzp_blog_author.image`.`thumbnails_ro` as `s_plugin_netzp_blog_author.image.thumbnailsRo`, `s_plugin_netzp_blog_author.image`.`created_at` as `s_plugin_netzp_blog_author.image.createdAt`, `s_plugin_netzp_blog_author.image`.`updated_at` as `s_plugin_netzp_blog_author.image.updatedAt`, `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`id` as `s_plugin_netzp_blog_author.image.uandiMediaExtension.id`, `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`media_id` as `s_plugin_netzp_blog_author.image.uandiMediaExtension.mediaId`, `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`priority` as `s_plugin_netzp_blog_author.image.uandiMediaExtension.priority`, `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`created_at` as `s_plugin_netzp_blog_author.image.uandiMediaExtension.createdAt`, `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`updated_at` as `s_plugin_netzp_blog_author.image.uandiMediaExtension.updatedAt`, `s_plugin_netzp_blog_author.image.translation.title`, COALESCE(`s_plugin_netzp_blog_author.image.translation.title`,`s_plugin_netzp_blog_author.image.translation.title`) as `s_plugin_netzp_blog_author.image.title`, `s_plugin_netzp_blog_author.image.translation.alt`, COALESCE(`s_plugin_netzp_blog_author.image.translation.alt`,`s_plugin_netzp_blog_author.image.translation.alt`) as `s_plugin_netzp_blog_author.image.alt`, `s_plugin_netzp_blog_author.image.translation.customFields`, COALESCE(`s_plugin_netzp_blog_author.image.translation.customFields`,`s_plugin_netzp_blog_author.image.translation.customFields`) as `s_plugin_netzp_blog_author.image.customFields`, `s_plugin_netzp_blog_author.image.translation.createdAt`, `s_plugin_netzp_blog_author.image.translation.updatedAt`, `s_plugin_netzp_blog_author.image.translation.mediaId`, `s_plugin_netzp_blog_author.image.translation.languageId`, `s_plugin_netzp_blog_author`.`created_at` as `s_plugin_netzp_blog_author.createdAt`, `s_plugin_netzp_blog_author`.`updated_at` as `s_plugin_netzp_blog_author.updatedAt`, `s_plugin_netzp_blog_author.translation.name`, COALESCE(`s_plugin_netzp_blog_author.translation.name`,`s_plugin_netzp_blog_author.translation.name`) as `s_plugin_netzp_blog_author.name`, `s_plugin_netzp_blog_author.translation.bio`, COALESCE(`s_plugin_netzp_blog_author.translation.bio`,`s_plugin_netzp_blog_author.translation.bio`) as `s_plugin_netzp_blog_author.bio`, `s_plugin_netzp_blog_author.translation.customFields`, COALESCE(`s_plugin_netzp_blog_author.translation.customFields`,`s_plugin_netzp_blog_author.translation.customFields`) as `s_plugin_netzp_blog_author.customFields`, `s_plugin_netzp_blog_author.translation.createdAt`, `s_plugin_netzp_blog_author.translation.updatedAt`, `s_plugin_netzp_blog_author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog_author.translation.languageId` FROM `s_plugin_netzp_blog_author` LEFT JOIN (SELECT `s_plugin_netzp_blog_author.translation`.s_plugin_netzp_blog_author_id, `s_plugin_netzp_blog_author.translation`.name as `s_plugin_netzp_blog_author.translation.name`, `s_plugin_netzp_blog_author.translation`.bio as `s_plugin_netzp_blog_author.translation.bio`, `s_plugin_netzp_blog_author.translation`.custom_fields as `s_plugin_netzp_blog_author.translation.customFields`, `s_plugin_netzp_blog_author.translation`.created_at as `s_plugin_netzp_blog_author.translation.createdAt`, `s_plugin_netzp_blog_author.translation`.updated_at as `s_plugin_netzp_blog_author.translation.updatedAt`, `s_plugin_netzp_blog_author.translation`.s_plugin_netzp_blog_author_id as `s_plugin_netzp_blog_author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog_author.translation`.language_id as `s_plugin_netzp_blog_author.translation.languageId` FROM `s_plugin_netzp_blog_author_translation` `s_plugin_netzp_blog_author.translation` WHERE `s_plugin_netzp_blog_author.translation`.language_id = :languageId) `s_plugin_netzp_blog_author.s_plugin_netzp_blog_author_translation` ON `s_plugin_netzp_blog_author.s_plugin_netzp_blog_author_translation`.`s_plugin_netzp_blog_author_id` = `s_plugin_netzp_blog_author`.`id` LEFT JOIN `media` `s_plugin_netzp_blog_author.image` ON `s_plugin_netzp_blog_author`.`imageid` = `s_plugin_netzp_blog_author.image`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog_author.image.translation`.media_id, `s_plugin_netzp_blog_author.image.translation`.title as `s_plugin_netzp_blog_author.image.translation.title`, `s_plugin_netzp_blog_author.image.translation`.alt as `s_plugin_netzp_blog_author.image.translation.alt`, `s_plugin_netzp_blog_author.image.translation`.custom_fields as `s_plugin_netzp_blog_author.image.translation.customFields`, `s_plugin_netzp_blog_author.image.translation`.created_at as `s_plugin_netzp_blog_author.image.translation.createdAt`, `s_plugin_netzp_blog_author.image.translation`.updated_at as `s_plugin_netzp_blog_author.image.translation.updatedAt`, `s_plugin_netzp_blog_author.image.translation`.media_id as `s_plugin_netzp_blog_author.image.translation.mediaId`, `s_plugin_netzp_blog_author.image.translation`.language_id as `s_plugin_netzp_blog_author.image.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog_author.image.translation` WHERE `s_plugin_netzp_blog_author.image.translation`.language_id = :languageId) `s_plugin_netzp_blog_author.image.media_translation` ON `s_plugin_netzp_blog_author.image.media_translation`.`media_id` = `s_plugin_netzp_blog_author.image`.`id` LEFT JOIN `uandi_media_extension` `s_plugin_netzp_blog_author.image.uandiMediaExtension` ON `s_plugin_netzp_blog_author.image`.`id` = `s_plugin_netzp_blog_author.image.uandiMediaExtension`.`media_id` WHERE `s_plugin_netzp_blog_author`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
37 3.59 ms 
# cms::netzp-blog-listing::aggregation::tags
SELECT LOWER(HEX(`s_plugin_netzp_blog.tags`.`id`)) as `tags` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_ef8f67d2358247f8bd49944c5afdbefc))) `s_plugin_netzp_blog.categories_1` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_1`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_90d5f67091d44834a7f91f6873a4d237))) `s_plugin_netzp_blog.categories_2` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_2`.`id` LEFT JOIN `s_plugin_netzp_blog_tag` `s_plugin_netzp_blog.tags.mapping` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.tags.mapping`.`blog_id`  LEFT JOIN `tag` `s_plugin_netzp_blog.tags` ON `s_plugin_netzp_blog.tags.mapping`.`tag_id` = `s_plugin_netzp_blog.tags`.`id`  WHERE ((`s_plugin_netzp_blog`.`categoryid` = :param_fe01ea9ffc5a4df48ba031df547130db OR `s_plugin_netzp_blog.categories_1`.id IS NOT NULL) AND ((`s_plugin_netzp_blog`.`showfrom` <= :param_8833b19e509249c48f9bcf0f78d82783) OR `s_plugin_netzp_blog`.`showfrom` <=> :param_fd8bf974a70441c3a686a01236d25616) AND ((`s_plugin_netzp_blog`.`showuntil` >= :param_6eaf7aaae84b44debaa6f009472823d8) OR `s_plugin_netzp_blog`.`showuntil` <=> :param_4c07e76e78b54d9796ef534648138cf0) AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> :param_9926db504f27441a9a01da8d299924b4 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_44fc11cdba3646838cb559be636fc420 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_b6bd49c847e546859208abce7b672f02) AND (`s_plugin_netzp_blog`.`categoryid` = :param_7eb43e5db0214dbbb4e1ea1fdc87d71c OR `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_5d6648a84bb344fda33aba1897869961 OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = :param_790a0b71da654a129962895ee8a33c96 AND `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_11d87a2dacbe4d84a47387935841ca53)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_aea3502e309249bd9b609aaeb1e047ac OR `s_plugin_netzp_blog.category`.`customergroup_id` = :param_ec87a946887c4347bf0a1835b233fc69 OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_ee9886a8f8fd4b80b24964ba9c7158c6) AND `s_plugin_netzp_blog.category`.`customergroup_id` = :param_a4fb4b4a1d92498b9076eed6b4d9a19b)) AND (`s_plugin_netzp_blog`.`categoryid` = :param_a1421ba77da94469b6d8a85254f0947c OR `s_plugin_netzp_blog.categories_2`.id IS NOT NULL)) GROUP BY `s_plugin_netzp_blog.tags`.`id`
View formatted query    View runnable query    View query stack
38 0.24 ms 
# tags-aggregation::read
SELECT `tag`.`id` as `tag.id`, `tag`.`name` as `tag.name`, `tag`.`created_at` as `tag.createdAt`, `tag`.`updated_at` as `tag.updatedAt` FROM `tag` WHERE `tag`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
39 4.14 ms 
# cms::netzp-blog-listing::search-ids
SELECT `s_plugin_netzp_blog`.`id` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_86d119d9e5b24b12800a25659842e100))) `s_plugin_netzp_blog.categories_1` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_1`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_ad387abb66b54e0ea124146364645cc5))) `s_plugin_netzp_blog.categories_2` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_2`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id, `s_plugin_netzp_blog.translation`.title as `s_plugin_netzp_blog.translation.title`, `s_plugin_netzp_blog.translation`.teaser as `s_plugin_netzp_blog.translation.teaser`, `s_plugin_netzp_blog.translation`.slug as `s_plugin_netzp_blog.translation.slug`, `s_plugin_netzp_blog.translation`.contents as `s_plugin_netzp_blog.translation.contents`, `s_plugin_netzp_blog.translation`.custom as `s_plugin_netzp_blog.translation.custom`, `s_plugin_netzp_blog.translation`.metatitle as `s_plugin_netzp_blog.translation.metatitle`, `s_plugin_netzp_blog.translation`.metadescription as `s_plugin_netzp_blog.translation.metadescription`, `s_plugin_netzp_blog.translation`.custom_fields as `s_plugin_netzp_blog.translation.customFields`, `s_plugin_netzp_blog.translation`.created_at as `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation`.updated_at as `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id as `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation`.language_id as `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog_translation` `s_plugin_netzp_blog.translation` WHERE `s_plugin_netzp_blog.translation`.language_id = :languageId) `s_plugin_netzp_blog.s_plugin_netzp_blog_translation` ON `s_plugin_netzp_blog.s_plugin_netzp_blog_translation`.`s_plugin_netzp_blog_id` = `s_plugin_netzp_blog`.`id` WHERE ((`s_plugin_netzp_blog`.`categoryid` = :param_fe39213442a642628c3ad4cdb0e9e167 OR `s_plugin_netzp_blog.categories_1`.id IS NOT NULL) AND ((`s_plugin_netzp_blog`.`showfrom` <= :param_998cf5befd3d4605996484f015b1a61d) OR `s_plugin_netzp_blog`.`showfrom` <=> :param_88c3ece0694648acb19bf7e20c990968) AND ((`s_plugin_netzp_blog`.`showuntil` >= :param_89fca358bba44bfe81873144ab97c8bc) OR `s_plugin_netzp_blog`.`showuntil` <=> :param_0250935790b340d89e21581e84956031) AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> :param_938a22a4be314a888d4ea3a324e85714 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_35bbcd3e1430481da38775d3fae8ec60 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_3ae1c5439fcd4c7ba31bdb25a541879d) AND (`s_plugin_netzp_blog`.`categoryid` = :param_755da18331c24edf9e020401831f0948 OR `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_7e5afbc90666411bb8a853181172fc34 OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = :param_1c0a66c634224a83ab500be96bdd28d5 AND `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_a7cb6c15a7544181a275c4403adeb9ee)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_08859cc783fb48d4888d39d5ab1285fb OR `s_plugin_netzp_blog.category`.`customergroup_id` = :param_675170a3fbf248dd896e9151c564ace5 OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_a7b87824a8954af18ef3a119f0a37904) AND `s_plugin_netzp_blog.category`.`customergroup_id` = :param_20062cb6788245769a43db9e23e6482d)) AND (`s_plugin_netzp_blog`.`categoryid` = :param_0b1949a050fd45df96304ace66436044 OR `s_plugin_netzp_blog.categories_2`.id IS NOT NULL)) GROUP BY `s_plugin_netzp_blog`.`id` ORDER BY MAX(`s_plugin_netzp_blog`.`sticky`) DESC, MAX(`s_plugin_netzp_blog`.`postdate`) DESC, MIN(COALESCE(`s_plugin_netzp_blog.translation.title`)) ASC LIMIT 5
View formatted query    View runnable query    View query stack
40 1.26 ms 
SELECT COUNT(*) FROM (# cms::netzp-blog-listing::search-ids
SELECT `s_plugin_netzp_blog`.`id` FROM `s_plugin_netzp_blog` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_86d119d9e5b24b12800a25659842e100))) `s_plugin_netzp_blog.categories_1` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_1`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.categories.mapping`.`blog_id` as id FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.categories` ON `s_plugin_netzp_blog.categories.mapping`.`category_id` = `s_plugin_netzp_blog.categories`.`id`  WHERE (`s_plugin_netzp_blog.categories`.`id` IN (:param_ad387abb66b54e0ea124146364645cc5))) `s_plugin_netzp_blog.categories_2` ON `s_plugin_netzp_blog`.`id` = `s_plugin_netzp_blog.categories_2`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id, `s_plugin_netzp_blog.translation`.title as `s_plugin_netzp_blog.translation.title`, `s_plugin_netzp_blog.translation`.teaser as `s_plugin_netzp_blog.translation.teaser`, `s_plugin_netzp_blog.translation`.slug as `s_plugin_netzp_blog.translation.slug`, `s_plugin_netzp_blog.translation`.contents as `s_plugin_netzp_blog.translation.contents`, `s_plugin_netzp_blog.translation`.custom as `s_plugin_netzp_blog.translation.custom`, `s_plugin_netzp_blog.translation`.metatitle as `s_plugin_netzp_blog.translation.metatitle`, `s_plugin_netzp_blog.translation`.metadescription as `s_plugin_netzp_blog.translation.metadescription`, `s_plugin_netzp_blog.translation`.custom_fields as `s_plugin_netzp_blog.translation.customFields`, `s_plugin_netzp_blog.translation`.created_at as `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation`.updated_at as `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id as `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation`.language_id as `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog_translation` `s_plugin_netzp_blog.translation` WHERE `s_plugin_netzp_blog.translation`.language_id = :languageId) `s_plugin_netzp_blog.s_plugin_netzp_blog_translation` ON `s_plugin_netzp_blog.s_plugin_netzp_blog_translation`.`s_plugin_netzp_blog_id` = `s_plugin_netzp_blog`.`id` WHERE ((`s_plugin_netzp_blog`.`categoryid` = :param_fe39213442a642628c3ad4cdb0e9e167 OR `s_plugin_netzp_blog.categories_1`.id IS NOT NULL) AND ((`s_plugin_netzp_blog`.`showfrom` <= :param_998cf5befd3d4605996484f015b1a61d) OR `s_plugin_netzp_blog`.`showfrom` <=> :param_88c3ece0694648acb19bf7e20c990968) AND ((`s_plugin_netzp_blog`.`showuntil` >= :param_89fca358bba44bfe81873144ab97c8bc) OR `s_plugin_netzp_blog`.`showuntil` <=> :param_0250935790b340d89e21581e84956031) AND (`s_plugin_netzp_blog.category`.`saleschannel_id` <=> :param_938a22a4be314a888d4ea3a324e85714 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_35bbcd3e1430481da38775d3fae8ec60 OR `s_plugin_netzp_blog.category`.`saleschannel_id` = :param_3ae1c5439fcd4c7ba31bdb25a541879d) AND (`s_plugin_netzp_blog`.`categoryid` = :param_755da18331c24edf9e020401831f0948 OR `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_7e5afbc90666411bb8a853181172fc34 OR (`s_plugin_netzp_blog.category`.`onlyloggedin` = :param_1c0a66c634224a83ab500be96bdd28d5 AND `s_plugin_netzp_blog.category`.`onlyloggedin` = :param_a7cb6c15a7544181a275c4403adeb9ee)) AND (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_08859cc783fb48d4888d39d5ab1285fb OR `s_plugin_netzp_blog.category`.`customergroup_id` = :param_675170a3fbf248dd896e9151c564ace5 OR (NOT (`s_plugin_netzp_blog.category`.`customergroup_id` <=> :param_a7b87824a8954af18ef3a119f0a37904) AND `s_plugin_netzp_blog.category`.`customergroup_id` = :param_20062cb6788245769a43db9e23e6482d)) AND (`s_plugin_netzp_blog`.`categoryid` = :param_0b1949a050fd45df96304ace66436044 OR `s_plugin_netzp_blog.categories_2`.id IS NOT NULL)) GROUP BY `s_plugin_netzp_blog`.`id`) total
View formatted query    View runnable query    View query stack
41 143.85 ms 
# cms::netzp-blog-listing::read
SELECT `s_plugin_netzp_blog`.`id` as `s_plugin_netzp_blog.id`, `s_plugin_netzp_blog`.`postdate` as `s_plugin_netzp_blog.postdate`, `s_plugin_netzp_blog`.`showfrom` as `s_plugin_netzp_blog.showfrom`, `s_plugin_netzp_blog`.`showuntil` as `s_plugin_netzp_blog.showuntil`, `s_plugin_netzp_blog`.`noindex` as `s_plugin_netzp_blog.noindex`, `s_plugin_netzp_blog`.`sticky` as `s_plugin_netzp_blog.sticky`, `s_plugin_netzp_blog`.`isproductstream` as `s_plugin_netzp_blog.isproductstream`, `s_plugin_netzp_blog`.`imageid` as `s_plugin_netzp_blog.imageid`, `s_plugin_netzp_blog`.`imagepreviewid` as `s_plugin_netzp_blog.imagepreviewid`, `s_plugin_netzp_blog`.`categoryid` as `s_plugin_netzp_blog.categoryid`, `s_plugin_netzp_blog`.`authorid` as `s_plugin_netzp_blog.authorid`, `s_plugin_netzp_blog`.`productstreamid` as `s_plugin_netzp_blog.productstreamid`, `s_plugin_netzp_blog.category`.`id` as `s_plugin_netzp_blog.category.id`, `s_plugin_netzp_blog.category`.`cmspageid` as `s_plugin_netzp_blog.category.cmspageid`, `s_plugin_netzp_blog.category`.`saleschannel_id` as `s_plugin_netzp_blog.category.saleschannelid`, `s_plugin_netzp_blog.category`.`customergroup_id` as `s_plugin_netzp_blog.category.customergroupid`, `s_plugin_netzp_blog.category`.`onlyloggedin` as `s_plugin_netzp_blog.category.onlyloggedin`, `s_plugin_netzp_blog.category`.`includeinrss` as `s_plugin_netzp_blog.category.includeinrss`, `s_plugin_netzp_blog.category.saleschannel`.`id` as `s_plugin_netzp_blog.category.saleschannel.id`, `s_plugin_netzp_blog.category.saleschannel`.`type_id` as `s_plugin_netzp_blog.category.saleschannel.typeId`, `s_plugin_netzp_blog.category.saleschannel`.`language_id` as `s_plugin_netzp_blog.category.saleschannel.languageId`, `s_plugin_netzp_blog.category.saleschannel`.`customer_group_id` as `s_plugin_netzp_blog.category.saleschannel.customerGroupId`, `s_plugin_netzp_blog.category.saleschannel`.`currency_id` as `s_plugin_netzp_blog.category.saleschannel.currencyId`, `s_plugin_netzp_blog.category.saleschannel`.`payment_method_id` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodId`, `s_plugin_netzp_blog.category.saleschannel`.`shipping_method_id` as `s_plugin_netzp_blog.category.saleschannel.shippingMethodId`, `s_plugin_netzp_blog.category.saleschannel`.`country_id` as `s_plugin_netzp_blog.category.saleschannel.countryId`, `s_plugin_netzp_blog.category.saleschannel`.`analytics_id` as `s_plugin_netzp_blog.category.saleschannel.analyticsId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`navigation_category_depth` as `s_plugin_netzp_blog.category.saleschannel.navigationCategoryDepth`, `s_plugin_netzp_blog.category.saleschannel`.`footer_category_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`footer_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.footerCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`service_category_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryId`, `s_plugin_netzp_blog.category.saleschannel`.`service_category_version_id` as `s_plugin_netzp_blog.category.saleschannel.serviceCategoryVersionId`, `s_plugin_netzp_blog.category.saleschannel`.`mail_header_footer_id` as `s_plugin_netzp_blog.category.saleschannel.mailHeaderFooterId`, `s_plugin_netzp_blog.category.saleschannel`.`hreflang_default_domain_id` as `s_plugin_netzp_blog.category.saleschannel.hreflangDefaultDomainId`, `s_plugin_netzp_blog.category.saleschannel`.`short_name` as `s_plugin_netzp_blog.category.saleschannel.shortName`, `s_plugin_netzp_blog.category.saleschannel`.`tax_calculation_type` as `s_plugin_netzp_blog.category.saleschannel.taxCalculationType`, `s_plugin_netzp_blog.category.saleschannel`.`access_key` as `s_plugin_netzp_blog.category.saleschannel.accessKey`, `s_plugin_netzp_blog.category.saleschannel`.`configuration` as `s_plugin_netzp_blog.category.saleschannel.configuration`, `s_plugin_netzp_blog.category.saleschannel`.`active` as `s_plugin_netzp_blog.category.saleschannel.active`, `s_plugin_netzp_blog.category.saleschannel`.`hreflang_active` as `s_plugin_netzp_blog.category.saleschannel.hreflangActive`, `s_plugin_netzp_blog.category.saleschannel`.`maintenance` as `s_plugin_netzp_blog.category.saleschannel.maintenance`, `s_plugin_netzp_blog.category.saleschannel`.`maintenance_ip_whitelist` as `s_plugin_netzp_blog.category.saleschannel.maintenanceIpWhitelist`, `s_plugin_netzp_blog.category.saleschannel`.`payment_method_ids` as `s_plugin_netzp_blog.category.saleschannel.paymentMethodIds`, `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageId`, `s_plugin_netzp_blog.category.saleschannel`.`home_cms_page_version_id` as `s_plugin_netzp_blog.category.saleschannel.homeCmsPageVersionId`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`id` as `s_plugin_netzp_blog.category.saleschannel.analytics.id`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`tracking_id` as `s_plugin_netzp_blog.category.saleschannel.analytics.trackingId`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`active` as `s_plugin_netzp_blog.category.saleschannel.analytics.active`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`track_orders` as `s_plugin_netzp_blog.category.saleschannel.analytics.trackOrders`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`anonymize_ip` as `s_plugin_netzp_blog.category.saleschannel.analytics.anonymizeIp`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`created_at` as `s_plugin_netzp_blog.category.saleschannel.analytics.createdAt`, `s_plugin_netzp_blog.category.saleschannel.analytics`.`updated_at` as `s_plugin_netzp_blog.category.saleschannel.analytics.updatedAt`, `s_plugin_netzp_blog.category.saleschannel`.`created_at` as `s_plugin_netzp_blog.category.saleschannel.createdAt`, `s_plugin_netzp_blog.category.saleschannel`.`updated_at` as `s_plugin_netzp_blog.category.saleschannel.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation.name`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.name`,`s_plugin_netzp_blog.category.saleschannel.translation.name`) as `s_plugin_netzp_blog.category.saleschannel.name`, `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`,`s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`) as `s_plugin_netzp_blog.category.saleschannel.homeSlotConfig`, `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`,`s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`) as `s_plugin_netzp_blog.category.saleschannel.homeEnabled`, `s_plugin_netzp_blog.category.saleschannel.translation.homeName`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeName`,`s_plugin_netzp_blog.category.saleschannel.translation.homeName`) as `s_plugin_netzp_blog.category.saleschannel.homeName`, `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`,`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`) as `s_plugin_netzp_blog.category.saleschannel.homeMetaTitle`, `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`,`s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`) as `s_plugin_netzp_blog.category.saleschannel.homeMetaDescription`, `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`,`s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`) as `s_plugin_netzp_blog.category.saleschannel.homeKeywords`, `s_plugin_netzp_blog.category.saleschannel.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.saleschannel.translation.customFields`,`s_plugin_netzp_blog.category.saleschannel.translation.customFields`) as `s_plugin_netzp_blog.category.saleschannel.customFields`, `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog.category.saleschannel.translation.languageId`, `s_plugin_netzp_blog.category.customergroup`.`id` as `s_plugin_netzp_blog.category.customergroup.id`, `s_plugin_netzp_blog.category.customergroup`.`display_gross` as `s_plugin_netzp_blog.category.customergroup.displayGross`, `s_plugin_netzp_blog.category.customergroup`.`registration_active` as `s_plugin_netzp_blog.category.customergroup.registrationActive`, `s_plugin_netzp_blog.category.customergroup`.`created_at` as `s_plugin_netzp_blog.category.customergroup.createdAt`, `s_plugin_netzp_blog.category.customergroup`.`updated_at` as `s_plugin_netzp_blog.category.customergroup.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation.name`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.name`,`s_plugin_netzp_blog.category.customergroup.translation.name`) as `s_plugin_netzp_blog.category.customergroup.name`, `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`,`s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`) as `s_plugin_netzp_blog.category.customergroup.registrationTitle`, `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`,`s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`) as `s_plugin_netzp_blog.category.customergroup.registrationIntroduction`, `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`,`s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`) as `s_plugin_netzp_blog.category.customergroup.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`,`s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`) as `s_plugin_netzp_blog.category.customergroup.registrationSeoMetaDescription`, `s_plugin_netzp_blog.category.customergroup.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.customergroup.translation.customFields`,`s_plugin_netzp_blog.category.customergroup.translation.customFields`) as `s_plugin_netzp_blog.category.customergroup.customFields`, `s_plugin_netzp_blog.category.customergroup.translation.createdAt`, `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog.category.customergroup.translation.languageId`, `s_plugin_netzp_blog.category`.`created_at` as `s_plugin_netzp_blog.category.createdAt`, `s_plugin_netzp_blog.category`.`updated_at` as `s_plugin_netzp_blog.category.updatedAt`, `s_plugin_netzp_blog.category.translation.title`, COALESCE(`s_plugin_netzp_blog.category.translation.title`,`s_plugin_netzp_blog.category.translation.title`) as `s_plugin_netzp_blog.category.title`, `s_plugin_netzp_blog.category.translation.teaser`, COALESCE(`s_plugin_netzp_blog.category.translation.teaser`,`s_plugin_netzp_blog.category.translation.teaser`) as `s_plugin_netzp_blog.category.teaser`, `s_plugin_netzp_blog.category.translation.customFields`, COALESCE(`s_plugin_netzp_blog.category.translation.customFields`,`s_plugin_netzp_blog.category.translation.customFields`) as `s_plugin_netzp_blog.category.customFields`, `s_plugin_netzp_blog.category.translation.createdAt`, `s_plugin_netzp_blog.category.translation.updatedAt`, `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog.category.translation.languageId`, `s_plugin_netzp_blog.author`.`id` as `s_plugin_netzp_blog.author.id`, `s_plugin_netzp_blog.author`.`imageid` as `s_plugin_netzp_blog.author.imageid`, `s_plugin_netzp_blog.author.image`.`id` as `s_plugin_netzp_blog.author.image.id`, `s_plugin_netzp_blog.author.image`.`user_id` as `s_plugin_netzp_blog.author.image.userId`, `s_plugin_netzp_blog.author.image`.`media_folder_id` as `s_plugin_netzp_blog.author.image.mediaFolderId`, `s_plugin_netzp_blog.author.image`.`mime_type` as `s_plugin_netzp_blog.author.image.mimeType`, `s_plugin_netzp_blog.author.image`.`file_extension` as `s_plugin_netzp_blog.author.image.fileExtension`, `s_plugin_netzp_blog.author.image`.`uploaded_at` as `s_plugin_netzp_blog.author.image.uploadedAt`, `s_plugin_netzp_blog.author.image`.`file_name` as `s_plugin_netzp_blog.author.image.fileName`, `s_plugin_netzp_blog.author.image`.`file_size` as `s_plugin_netzp_blog.author.image.fileSize`, `s_plugin_netzp_blog.author.image`.`media_type` as `s_plugin_netzp_blog.author.image.mediaTypeRaw`, `s_plugin_netzp_blog.author.image`.`meta_data` as `s_plugin_netzp_blog.author.image.metaData`, `s_plugin_netzp_blog.author.image`.`private` as `s_plugin_netzp_blog.author.image.private`, `s_plugin_netzp_blog.author.image`.`thumbnails_ro` as `s_plugin_netzp_blog.author.image.thumbnailsRo`, `s_plugin_netzp_blog.author.image`.`created_at` as `s_plugin_netzp_blog.author.image.createdAt`, `s_plugin_netzp_blog.author.image`.`updated_at` as `s_plugin_netzp_blog.author.image.updatedAt`, `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`id` as `s_plugin_netzp_blog.author.image.uandiMediaExtension.id`, `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`media_id` as `s_plugin_netzp_blog.author.image.uandiMediaExtension.mediaId`, `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`priority` as `s_plugin_netzp_blog.author.image.uandiMediaExtension.priority`, `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`created_at` as `s_plugin_netzp_blog.author.image.uandiMediaExtension.createdAt`, `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`updated_at` as `s_plugin_netzp_blog.author.image.uandiMediaExtension.updatedAt`, `s_plugin_netzp_blog.author.image.translation.title`, COALESCE(`s_plugin_netzp_blog.author.image.translation.title`,`s_plugin_netzp_blog.author.image.translation.title`) as `s_plugin_netzp_blog.author.image.title`, `s_plugin_netzp_blog.author.image.translation.alt`, COALESCE(`s_plugin_netzp_blog.author.image.translation.alt`,`s_plugin_netzp_blog.author.image.translation.alt`) as `s_plugin_netzp_blog.author.image.alt`, `s_plugin_netzp_blog.author.image.translation.customFields`, COALESCE(`s_plugin_netzp_blog.author.image.translation.customFields`,`s_plugin_netzp_blog.author.image.translation.customFields`) as `s_plugin_netzp_blog.author.image.customFields`, `s_plugin_netzp_blog.author.image.translation.createdAt`, `s_plugin_netzp_blog.author.image.translation.updatedAt`, `s_plugin_netzp_blog.author.image.translation.mediaId`, `s_plugin_netzp_blog.author.image.translation.languageId`, `s_plugin_netzp_blog.author`.`created_at` as `s_plugin_netzp_blog.author.createdAt`, `s_plugin_netzp_blog.author`.`updated_at` as `s_plugin_netzp_blog.author.updatedAt`, `s_plugin_netzp_blog.author.translation.name`, COALESCE(`s_plugin_netzp_blog.author.translation.name`,`s_plugin_netzp_blog.author.translation.name`) as `s_plugin_netzp_blog.author.name`, `s_plugin_netzp_blog.author.translation.bio`, COALESCE(`s_plugin_netzp_blog.author.translation.bio`,`s_plugin_netzp_blog.author.translation.bio`) as `s_plugin_netzp_blog.author.bio`, `s_plugin_netzp_blog.author.translation.customFields`, COALESCE(`s_plugin_netzp_blog.author.translation.customFields`,`s_plugin_netzp_blog.author.translation.customFields`) as `s_plugin_netzp_blog.author.customFields`, `s_plugin_netzp_blog.author.translation.createdAt`, `s_plugin_netzp_blog.author.translation.updatedAt`, `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog.author.translation.languageId`, `s_plugin_netzp_blog.image`.`id` as `s_plugin_netzp_blog.image.id`, `s_plugin_netzp_blog.image`.`user_id` as `s_plugin_netzp_blog.image.userId`, `s_plugin_netzp_blog.image`.`media_folder_id` as `s_plugin_netzp_blog.image.mediaFolderId`, `s_plugin_netzp_blog.image`.`mime_type` as `s_plugin_netzp_blog.image.mimeType`, `s_plugin_netzp_blog.image`.`file_extension` as `s_plugin_netzp_blog.image.fileExtension`, `s_plugin_netzp_blog.image`.`uploaded_at` as `s_plugin_netzp_blog.image.uploadedAt`, `s_plugin_netzp_blog.image`.`file_name` as `s_plugin_netzp_blog.image.fileName`, `s_plugin_netzp_blog.image`.`file_size` as `s_plugin_netzp_blog.image.fileSize`, `s_plugin_netzp_blog.image`.`media_type` as `s_plugin_netzp_blog.image.mediaTypeRaw`, `s_plugin_netzp_blog.image`.`meta_data` as `s_plugin_netzp_blog.image.metaData`, `s_plugin_netzp_blog.image`.`private` as `s_plugin_netzp_blog.image.private`, `s_plugin_netzp_blog.image`.`thumbnails_ro` as `s_plugin_netzp_blog.image.thumbnailsRo`, `s_plugin_netzp_blog.image`.`created_at` as `s_plugin_netzp_blog.image.createdAt`, `s_plugin_netzp_blog.image`.`updated_at` as `s_plugin_netzp_blog.image.updatedAt`, `s_plugin_netzp_blog.image.uandiMediaExtension`.`id` as `s_plugin_netzp_blog.image.uandiMediaExtension.id`, `s_plugin_netzp_blog.image.uandiMediaExtension`.`media_id` as `s_plugin_netzp_blog.image.uandiMediaExtension.mediaId`, `s_plugin_netzp_blog.image.uandiMediaExtension`.`priority` as `s_plugin_netzp_blog.image.uandiMediaExtension.priority`, `s_plugin_netzp_blog.image.uandiMediaExtension`.`created_at` as `s_plugin_netzp_blog.image.uandiMediaExtension.createdAt`, `s_plugin_netzp_blog.image.uandiMediaExtension`.`updated_at` as `s_plugin_netzp_blog.image.uandiMediaExtension.updatedAt`, `s_plugin_netzp_blog.image.translation.title`, COALESCE(`s_plugin_netzp_blog.image.translation.title`,`s_plugin_netzp_blog.image.translation.title`) as `s_plugin_netzp_blog.image.title`, `s_plugin_netzp_blog.image.translation.alt`, COALESCE(`s_plugin_netzp_blog.image.translation.alt`,`s_plugin_netzp_blog.image.translation.alt`) as `s_plugin_netzp_blog.image.alt`, `s_plugin_netzp_blog.image.translation.customFields`, COALESCE(`s_plugin_netzp_blog.image.translation.customFields`,`s_plugin_netzp_blog.image.translation.customFields`) as `s_plugin_netzp_blog.image.customFields`, `s_plugin_netzp_blog.image.translation.createdAt`, `s_plugin_netzp_blog.image.translation.updatedAt`, `s_plugin_netzp_blog.image.translation.mediaId`, `s_plugin_netzp_blog.image.translation.languageId`, `s_plugin_netzp_blog.imagepreview`.`id` as `s_plugin_netzp_blog.imagepreview.id`, `s_plugin_netzp_blog.imagepreview`.`user_id` as `s_plugin_netzp_blog.imagepreview.userId`, `s_plugin_netzp_blog.imagepreview`.`media_folder_id` as `s_plugin_netzp_blog.imagepreview.mediaFolderId`, `s_plugin_netzp_blog.imagepreview`.`mime_type` as `s_plugin_netzp_blog.imagepreview.mimeType`, `s_plugin_netzp_blog.imagepreview`.`file_extension` as `s_plugin_netzp_blog.imagepreview.fileExtension`, `s_plugin_netzp_blog.imagepreview`.`uploaded_at` as `s_plugin_netzp_blog.imagepreview.uploadedAt`, `s_plugin_netzp_blog.imagepreview`.`file_name` as `s_plugin_netzp_blog.imagepreview.fileName`, `s_plugin_netzp_blog.imagepreview`.`file_size` as `s_plugin_netzp_blog.imagepreview.fileSize`, `s_plugin_netzp_blog.imagepreview`.`media_type` as `s_plugin_netzp_blog.imagepreview.mediaTypeRaw`, `s_plugin_netzp_blog.imagepreview`.`meta_data` as `s_plugin_netzp_blog.imagepreview.metaData`, `s_plugin_netzp_blog.imagepreview`.`private` as `s_plugin_netzp_blog.imagepreview.private`, `s_plugin_netzp_blog.imagepreview`.`thumbnails_ro` as `s_plugin_netzp_blog.imagepreview.thumbnailsRo`, `s_plugin_netzp_blog.imagepreview`.`created_at` as `s_plugin_netzp_blog.imagepreview.createdAt`, `s_plugin_netzp_blog.imagepreview`.`updated_at` as `s_plugin_netzp_blog.imagepreview.updatedAt`, `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`id` as `s_plugin_netzp_blog.imagepreview.uandiMediaExtension.id`, `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`media_id` as `s_plugin_netzp_blog.imagepreview.uandiMediaExtension.mediaId`, `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`priority` as `s_plugin_netzp_blog.imagepreview.uandiMediaExtension.priority`, `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`created_at` as `s_plugin_netzp_blog.imagepreview.uandiMediaExtension.createdAt`, `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`updated_at` as `s_plugin_netzp_blog.imagepreview.uandiMediaExtension.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation.title`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.title`,`s_plugin_netzp_blog.imagepreview.translation.title`) as `s_plugin_netzp_blog.imagepreview.title`, `s_plugin_netzp_blog.imagepreview.translation.alt`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.alt`,`s_plugin_netzp_blog.imagepreview.translation.alt`) as `s_plugin_netzp_blog.imagepreview.alt`, `s_plugin_netzp_blog.imagepreview.translation.customFields`, COALESCE(`s_plugin_netzp_blog.imagepreview.translation.customFields`,`s_plugin_netzp_blog.imagepreview.translation.customFields`) as `s_plugin_netzp_blog.imagepreview.customFields`, `s_plugin_netzp_blog.imagepreview.translation.createdAt`, `s_plugin_netzp_blog.imagepreview.translation.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation.mediaId`, `s_plugin_netzp_blog.imagepreview.translation.languageId`, `s_plugin_netzp_blog.productstream`.`id` as `s_plugin_netzp_blog.productstream.id`, `s_plugin_netzp_blog.productstream`.`api_filter` as `s_plugin_netzp_blog.productstream.apiFilter`, `s_plugin_netzp_blog.productstream`.`invalid` as `s_plugin_netzp_blog.productstream.invalid`, `s_plugin_netzp_blog.productstream`.`created_at` as `s_plugin_netzp_blog.productstream.createdAt`, `s_plugin_netzp_blog.productstream`.`updated_at` as `s_plugin_netzp_blog.productstream.updatedAt`, `s_plugin_netzp_blog.productstream.translation.name`, COALESCE(`s_plugin_netzp_blog.productstream.translation.name`,`s_plugin_netzp_blog.productstream.translation.name`) as `s_plugin_netzp_blog.productstream.name`, `s_plugin_netzp_blog.productstream.translation.description`, COALESCE(`s_plugin_netzp_blog.productstream.translation.description`,`s_plugin_netzp_blog.productstream.translation.description`) as `s_plugin_netzp_blog.productstream.description`, `s_plugin_netzp_blog.productstream.translation.customFields`, COALESCE(`s_plugin_netzp_blog.productstream.translation.customFields`,`s_plugin_netzp_blog.productstream.translation.customFields`) as `s_plugin_netzp_blog.productstream.customFields`, `s_plugin_netzp_blog.productstream.translation.createdAt`, `s_plugin_netzp_blog.productstream.translation.updatedAt`, `s_plugin_netzp_blog.productstream.translation.productStreamId`, `s_plugin_netzp_blog.productstream.translation.languageId`, `s_plugin_netzp_blog`.`created_at` as `s_plugin_netzp_blog.createdAt`, `s_plugin_netzp_blog`.`updated_at` as `s_plugin_netzp_blog.updatedAt`, (SELECT GROUP_CONCAT(HEX(`s_plugin_netzp_blog.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `s_plugin_netzp_blog_categories` `s_plugin_netzp_blog.categories.mapping`
                  WHERE `s_plugin_netzp_blog.categories.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id` ) as `s_plugin_netzp_blog.categories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`s_plugin_netzp_blog.tags.mapping`.`tag_id`) SEPARATOR '||')
                  FROM `s_plugin_netzp_blog_tag` `s_plugin_netzp_blog.tags.mapping`
                  WHERE `s_plugin_netzp_blog.tags.mapping`.`blog_id` = `s_plugin_netzp_blog`.`id` ) as `s_plugin_netzp_blog.tags.id_mapping`, `s_plugin_netzp_blog.translation.title`, COALESCE(`s_plugin_netzp_blog.translation.title`,`s_plugin_netzp_blog.translation.title`) as `s_plugin_netzp_blog.title`, `s_plugin_netzp_blog.translation.teaser`, COALESCE(`s_plugin_netzp_blog.translation.teaser`,`s_plugin_netzp_blog.translation.teaser`) as `s_plugin_netzp_blog.teaser`, `s_plugin_netzp_blog.translation.slug`, COALESCE(`s_plugin_netzp_blog.translation.slug`,`s_plugin_netzp_blog.translation.slug`) as `s_plugin_netzp_blog.slug`, `s_plugin_netzp_blog.translation.contents`, COALESCE(`s_plugin_netzp_blog.translation.contents`,`s_plugin_netzp_blog.translation.contents`) as `s_plugin_netzp_blog.contents`, `s_plugin_netzp_blog.translation.custom`, COALESCE(`s_plugin_netzp_blog.translation.custom`,`s_plugin_netzp_blog.translation.custom`) as `s_plugin_netzp_blog.custom`, `s_plugin_netzp_blog.translation.metatitle`, COALESCE(`s_plugin_netzp_blog.translation.metatitle`,`s_plugin_netzp_blog.translation.metatitle`) as `s_plugin_netzp_blog.metatitle`, `s_plugin_netzp_blog.translation.metadescription`, COALESCE(`s_plugin_netzp_blog.translation.metadescription`,`s_plugin_netzp_blog.translation.metadescription`) as `s_plugin_netzp_blog.metadescription`, `s_plugin_netzp_blog.translation.customFields`, COALESCE(`s_plugin_netzp_blog.translation.customFields`,`s_plugin_netzp_blog.translation.customFields`) as `s_plugin_netzp_blog.customFields`, `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog` LEFT JOIN (SELECT `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id, `s_plugin_netzp_blog.translation`.title as `s_plugin_netzp_blog.translation.title`, `s_plugin_netzp_blog.translation`.teaser as `s_plugin_netzp_blog.translation.teaser`, `s_plugin_netzp_blog.translation`.slug as `s_plugin_netzp_blog.translation.slug`, `s_plugin_netzp_blog.translation`.contents as `s_plugin_netzp_blog.translation.contents`, `s_plugin_netzp_blog.translation`.custom as `s_plugin_netzp_blog.translation.custom`, `s_plugin_netzp_blog.translation`.metatitle as `s_plugin_netzp_blog.translation.metatitle`, `s_plugin_netzp_blog.translation`.metadescription as `s_plugin_netzp_blog.translation.metadescription`, `s_plugin_netzp_blog.translation`.custom_fields as `s_plugin_netzp_blog.translation.customFields`, `s_plugin_netzp_blog.translation`.created_at as `s_plugin_netzp_blog.translation.createdAt`, `s_plugin_netzp_blog.translation`.updated_at as `s_plugin_netzp_blog.translation.updatedAt`, `s_plugin_netzp_blog.translation`.s_plugin_netzp_blog_id as `s_plugin_netzp_blog.translation.sPluginNetzpBlogId`, `s_plugin_netzp_blog.translation`.language_id as `s_plugin_netzp_blog.translation.languageId` FROM `s_plugin_netzp_blog_translation` `s_plugin_netzp_blog.translation` WHERE `s_plugin_netzp_blog.translation`.language_id = :languageId) `s_plugin_netzp_blog.s_plugin_netzp_blog_translation` ON `s_plugin_netzp_blog.s_plugin_netzp_blog_translation`.`s_plugin_netzp_blog_id` = `s_plugin_netzp_blog`.`id` LEFT JOIN `s_plugin_netzp_blog_category` `s_plugin_netzp_blog.category` ON `s_plugin_netzp_blog`.`categoryid` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN `s_plugin_netzp_blog_author` `s_plugin_netzp_blog.author` ON `s_plugin_netzp_blog`.`authorid` = `s_plugin_netzp_blog.author`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.image` ON `s_plugin_netzp_blog`.`imageid` = `s_plugin_netzp_blog.image`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.imagepreview` ON `s_plugin_netzp_blog`.`imagepreviewid` = `s_plugin_netzp_blog.imagepreview`.`id` LEFT JOIN `product_stream` `s_plugin_netzp_blog.productstream` ON `s_plugin_netzp_blog`.`productstreamid` = `s_plugin_netzp_blog.productstream`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id, `s_plugin_netzp_blog.category.translation`.title as `s_plugin_netzp_blog.category.translation.title`, `s_plugin_netzp_blog.category.translation`.teaser as `s_plugin_netzp_blog.category.translation.teaser`, `s_plugin_netzp_blog.category.translation`.custom_fields as `s_plugin_netzp_blog.category.translation.customFields`, `s_plugin_netzp_blog.category.translation`.created_at as `s_plugin_netzp_blog.category.translation.createdAt`, `s_plugin_netzp_blog.category.translation`.updated_at as `s_plugin_netzp_blog.category.translation.updatedAt`, `s_plugin_netzp_blog.category.translation`.s_plugin_netzp_blog_category_id as `s_plugin_netzp_blog.category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog.category.translation`.language_id as `s_plugin_netzp_blog.category.translation.languageId` FROM `s_plugin_netzp_blog_category_translation` `s_plugin_netzp_blog.category.translation` WHERE `s_plugin_netzp_blog.category.translation`.language_id = :languageId) `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation` ON `s_plugin_netzp_blog.category.s_plugin_netzp_blog_category_translation`.`s_plugin_netzp_blog_category_id` = `s_plugin_netzp_blog.category`.`id` LEFT JOIN `sales_channel` `s_plugin_netzp_blog.category.saleschannel` ON `s_plugin_netzp_blog.category`.`saleschannel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id` LEFT JOIN `customer_group` `s_plugin_netzp_blog.category.customergroup` ON `s_plugin_netzp_blog.category`.`customergroup_id` = `s_plugin_netzp_blog.category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id, `s_plugin_netzp_blog.category.saleschannel.translation`.name as `s_plugin_netzp_blog.category.saleschannel.translation.name`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_slot_config as `s_plugin_netzp_blog.category.saleschannel.translation.homeSlotConfig`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_enabled as `s_plugin_netzp_blog.category.saleschannel.translation.homeEnabled`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_name as `s_plugin_netzp_blog.category.saleschannel.translation.homeName`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_title as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaTitle`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_meta_description as `s_plugin_netzp_blog.category.saleschannel.translation.homeMetaDescription`, `s_plugin_netzp_blog.category.saleschannel.translation`.home_keywords as `s_plugin_netzp_blog.category.saleschannel.translation.homeKeywords`, `s_plugin_netzp_blog.category.saleschannel.translation`.custom_fields as `s_plugin_netzp_blog.category.saleschannel.translation.customFields`, `s_plugin_netzp_blog.category.saleschannel.translation`.created_at as `s_plugin_netzp_blog.category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog.category.saleschannel.translation`.updated_at as `s_plugin_netzp_blog.category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog.category.saleschannel.translation`.sales_channel_id as `s_plugin_netzp_blog.category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog.category.saleschannel.translation`.language_id as `s_plugin_netzp_blog.category.saleschannel.translation.languageId` FROM `sales_channel_translation` `s_plugin_netzp_blog.category.saleschannel.translation` WHERE `s_plugin_netzp_blog.category.saleschannel.translation`.language_id = :languageId) `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation` ON `s_plugin_netzp_blog.category.saleschannel.sales_channel_translation`.`sales_channel_id` = `s_plugin_netzp_blog.category.saleschannel`.`id` LEFT JOIN `sales_channel_analytics` `s_plugin_netzp_blog.category.saleschannel.analytics` ON `s_plugin_netzp_blog.category.saleschannel`.`analytics_id` = `s_plugin_netzp_blog.category.saleschannel.analytics`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id, `s_plugin_netzp_blog.category.customergroup.translation`.name as `s_plugin_netzp_blog.category.customergroup.translation.name`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_title as `s_plugin_netzp_blog.category.customergroup.translation.registrationTitle`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_introduction as `s_plugin_netzp_blog.category.customergroup.translation.registrationIntroduction`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_only_company_registration as `s_plugin_netzp_blog.category.customergroup.translation.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog.category.customergroup.translation`.registration_seo_meta_description as `s_plugin_netzp_blog.category.customergroup.translation.registrationSeoMetaDescription`, `s_plugin_netzp_blog.category.customergroup.translation`.custom_fields as `s_plugin_netzp_blog.category.customergroup.translation.customFields`, `s_plugin_netzp_blog.category.customergroup.translation`.created_at as `s_plugin_netzp_blog.category.customergroup.translation.createdAt`, `s_plugin_netzp_blog.category.customergroup.translation`.updated_at as `s_plugin_netzp_blog.category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog.category.customergroup.translation`.customer_group_id as `s_plugin_netzp_blog.category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog.category.customergroup.translation`.language_id as `s_plugin_netzp_blog.category.customergroup.translation.languageId` FROM `customer_group_translation` `s_plugin_netzp_blog.category.customergroup.translation` WHERE `s_plugin_netzp_blog.category.customergroup.translation`.language_id = :languageId) `s_plugin_netzp_blog.category.customergroup.customer_group_translation` ON `s_plugin_netzp_blog.category.customergroup.customer_group_translation`.`customer_group_id` = `s_plugin_netzp_blog.category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id, `s_plugin_netzp_blog.author.translation`.name as `s_plugin_netzp_blog.author.translation.name`, `s_plugin_netzp_blog.author.translation`.bio as `s_plugin_netzp_blog.author.translation.bio`, `s_plugin_netzp_blog.author.translation`.custom_fields as `s_plugin_netzp_blog.author.translation.customFields`, `s_plugin_netzp_blog.author.translation`.created_at as `s_plugin_netzp_blog.author.translation.createdAt`, `s_plugin_netzp_blog.author.translation`.updated_at as `s_plugin_netzp_blog.author.translation.updatedAt`, `s_plugin_netzp_blog.author.translation`.s_plugin_netzp_blog_author_id as `s_plugin_netzp_blog.author.translation.sPluginNetzpBlogAuthorId`, `s_plugin_netzp_blog.author.translation`.language_id as `s_plugin_netzp_blog.author.translation.languageId` FROM `s_plugin_netzp_blog_author_translation` `s_plugin_netzp_blog.author.translation` WHERE `s_plugin_netzp_blog.author.translation`.language_id = :languageId) `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation` ON `s_plugin_netzp_blog.author.s_plugin_netzp_blog_author_translation`.`s_plugin_netzp_blog_author_id` = `s_plugin_netzp_blog.author`.`id` LEFT JOIN `media` `s_plugin_netzp_blog.author.image` ON `s_plugin_netzp_blog.author`.`imageid` = `s_plugin_netzp_blog.author.image`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog.author.image.translation`.media_id, `s_plugin_netzp_blog.author.image.translation`.title as `s_plugin_netzp_blog.author.image.translation.title`, `s_plugin_netzp_blog.author.image.translation`.alt as `s_plugin_netzp_blog.author.image.translation.alt`, `s_plugin_netzp_blog.author.image.translation`.custom_fields as `s_plugin_netzp_blog.author.image.translation.customFields`, `s_plugin_netzp_blog.author.image.translation`.created_at as `s_plugin_netzp_blog.author.image.translation.createdAt`, `s_plugin_netzp_blog.author.image.translation`.updated_at as `s_plugin_netzp_blog.author.image.translation.updatedAt`, `s_plugin_netzp_blog.author.image.translation`.media_id as `s_plugin_netzp_blog.author.image.translation.mediaId`, `s_plugin_netzp_blog.author.image.translation`.language_id as `s_plugin_netzp_blog.author.image.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.author.image.translation` WHERE `s_plugin_netzp_blog.author.image.translation`.language_id = :languageId) `s_plugin_netzp_blog.author.image.media_translation` ON `s_plugin_netzp_blog.author.image.media_translation`.`media_id` = `s_plugin_netzp_blog.author.image`.`id` LEFT JOIN `uandi_media_extension` `s_plugin_netzp_blog.author.image.uandiMediaExtension` ON `s_plugin_netzp_blog.author.image`.`id` = `s_plugin_netzp_blog.author.image.uandiMediaExtension`.`media_id` LEFT JOIN (SELECT `s_plugin_netzp_blog.image.translation`.media_id, `s_plugin_netzp_blog.image.translation`.title as `s_plugin_netzp_blog.image.translation.title`, `s_plugin_netzp_blog.image.translation`.alt as `s_plugin_netzp_blog.image.translation.alt`, `s_plugin_netzp_blog.image.translation`.custom_fields as `s_plugin_netzp_blog.image.translation.customFields`, `s_plugin_netzp_blog.image.translation`.created_at as `s_plugin_netzp_blog.image.translation.createdAt`, `s_plugin_netzp_blog.image.translation`.updated_at as `s_plugin_netzp_blog.image.translation.updatedAt`, `s_plugin_netzp_blog.image.translation`.media_id as `s_plugin_netzp_blog.image.translation.mediaId`, `s_plugin_netzp_blog.image.translation`.language_id as `s_plugin_netzp_blog.image.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.image.translation` WHERE `s_plugin_netzp_blog.image.translation`.language_id = :languageId) `s_plugin_netzp_blog.image.media_translation` ON `s_plugin_netzp_blog.image.media_translation`.`media_id` = `s_plugin_netzp_blog.image`.`id` LEFT JOIN `uandi_media_extension` `s_plugin_netzp_blog.image.uandiMediaExtension` ON `s_plugin_netzp_blog.image`.`id` = `s_plugin_netzp_blog.image.uandiMediaExtension`.`media_id` LEFT JOIN (SELECT `s_plugin_netzp_blog.imagepreview.translation`.media_id, `s_plugin_netzp_blog.imagepreview.translation`.title as `s_plugin_netzp_blog.imagepreview.translation.title`, `s_plugin_netzp_blog.imagepreview.translation`.alt as `s_plugin_netzp_blog.imagepreview.translation.alt`, `s_plugin_netzp_blog.imagepreview.translation`.custom_fields as `s_plugin_netzp_blog.imagepreview.translation.customFields`, `s_plugin_netzp_blog.imagepreview.translation`.created_at as `s_plugin_netzp_blog.imagepreview.translation.createdAt`, `s_plugin_netzp_blog.imagepreview.translation`.updated_at as `s_plugin_netzp_blog.imagepreview.translation.updatedAt`, `s_plugin_netzp_blog.imagepreview.translation`.media_id as `s_plugin_netzp_blog.imagepreview.translation.mediaId`, `s_plugin_netzp_blog.imagepreview.translation`.language_id as `s_plugin_netzp_blog.imagepreview.translation.languageId` FROM `media_translation` `s_plugin_netzp_blog.imagepreview.translation` WHERE `s_plugin_netzp_blog.imagepreview.translation`.language_id = :languageId) `s_plugin_netzp_blog.imagepreview.media_translation` ON `s_plugin_netzp_blog.imagepreview.media_translation`.`media_id` = `s_plugin_netzp_blog.imagepreview`.`id` LEFT JOIN `uandi_media_extension` `s_plugin_netzp_blog.imagepreview.uandiMediaExtension` ON `s_plugin_netzp_blog.imagepreview`.`id` = `s_plugin_netzp_blog.imagepreview.uandiMediaExtension`.`media_id` LEFT JOIN (SELECT `s_plugin_netzp_blog.productstream.translation`.product_stream_id, `s_plugin_netzp_blog.productstream.translation`.name as `s_plugin_netzp_blog.productstream.translation.name`, `s_plugin_netzp_blog.productstream.translation`.description as `s_plugin_netzp_blog.productstream.translation.description`, `s_plugin_netzp_blog.productstream.translation`.custom_fields as `s_plugin_netzp_blog.productstream.translation.customFields`, `s_plugin_netzp_blog.productstream.translation`.created_at as `s_plugin_netzp_blog.productstream.translation.createdAt`, `s_plugin_netzp_blog.productstream.translation`.updated_at as `s_plugin_netzp_blog.productstream.translation.updatedAt`, `s_plugin_netzp_blog.productstream.translation`.product_stream_id as `s_plugin_netzp_blog.productstream.translation.productStreamId`, `s_plugin_netzp_blog.productstream.translation`.language_id as `s_plugin_netzp_blog.productstream.translation.languageId` FROM `product_stream_translation` `s_plugin_netzp_blog.productstream.translation` WHERE `s_plugin_netzp_blog.productstream.translation`.language_id = :languageId) `s_plugin_netzp_blog.productstream.product_stream_translation` ON `s_plugin_netzp_blog.productstream.product_stream_translation`.`product_stream_id` = `s_plugin_netzp_blog.productstream`.`id` WHERE `s_plugin_netzp_blog`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
42 34.36 ms 
# cms::netzp-blog-listing::association::categories::read
SELECT `s_plugin_netzp_blog_category`.`id` as `s_plugin_netzp_blog_category.id`, `s_plugin_netzp_blog_category`.`cmspageid` as `s_plugin_netzp_blog_category.cmspageid`, `s_plugin_netzp_blog_category`.`saleschannel_id` as `s_plugin_netzp_blog_category.saleschannelid`, `s_plugin_netzp_blog_category`.`customergroup_id` as `s_plugin_netzp_blog_category.customergroupid`, `s_plugin_netzp_blog_category`.`onlyloggedin` as `s_plugin_netzp_blog_category.onlyloggedin`, `s_plugin_netzp_blog_category`.`includeinrss` as `s_plugin_netzp_blog_category.includeinrss`, `s_plugin_netzp_blog_category.saleschannel`.`id` as `s_plugin_netzp_blog_category.saleschannel.id`, `s_plugin_netzp_blog_category.saleschannel`.`type_id` as `s_plugin_netzp_blog_category.saleschannel.typeId`, `s_plugin_netzp_blog_category.saleschannel`.`language_id` as `s_plugin_netzp_blog_category.saleschannel.languageId`, `s_plugin_netzp_blog_category.saleschannel`.`customer_group_id` as `s_plugin_netzp_blog_category.saleschannel.customerGroupId`, `s_plugin_netzp_blog_category.saleschannel`.`currency_id` as `s_plugin_netzp_blog_category.saleschannel.currencyId`, `s_plugin_netzp_blog_category.saleschannel`.`payment_method_id` as `s_plugin_netzp_blog_category.saleschannel.paymentMethodId`, `s_plugin_netzp_blog_category.saleschannel`.`shipping_method_id` as `s_plugin_netzp_blog_category.saleschannel.shippingMethodId`, `s_plugin_netzp_blog_category.saleschannel`.`country_id` as `s_plugin_netzp_blog_category.saleschannel.countryId`, `s_plugin_netzp_blog_category.saleschannel`.`analytics_id` as `s_plugin_netzp_blog_category.saleschannel.analyticsId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_id` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`navigation_category_depth` as `s_plugin_netzp_blog_category.saleschannel.navigationCategoryDepth`, `s_plugin_netzp_blog_category.saleschannel`.`footer_category_id` as `s_plugin_netzp_blog_category.saleschannel.footerCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`footer_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.footerCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`service_category_id` as `s_plugin_netzp_blog_category.saleschannel.serviceCategoryId`, `s_plugin_netzp_blog_category.saleschannel`.`service_category_version_id` as `s_plugin_netzp_blog_category.saleschannel.serviceCategoryVersionId`, `s_plugin_netzp_blog_category.saleschannel`.`mail_header_footer_id` as `s_plugin_netzp_blog_category.saleschannel.mailHeaderFooterId`, `s_plugin_netzp_blog_category.saleschannel`.`hreflang_default_domain_id` as `s_plugin_netzp_blog_category.saleschannel.hreflangDefaultDomainId`, `s_plugin_netzp_blog_category.saleschannel`.`short_name` as `s_plugin_netzp_blog_category.saleschannel.shortName`, `s_plugin_netzp_blog_category.saleschannel`.`tax_calculation_type` as `s_plugin_netzp_blog_category.saleschannel.taxCalculationType`, `s_plugin_netzp_blog_category.saleschannel`.`access_key` as `s_plugin_netzp_blog_category.saleschannel.accessKey`, `s_plugin_netzp_blog_category.saleschannel`.`configuration` as `s_plugin_netzp_blog_category.saleschannel.configuration`, `s_plugin_netzp_blog_category.saleschannel`.`active` as `s_plugin_netzp_blog_category.saleschannel.active`, `s_plugin_netzp_blog_category.saleschannel`.`hreflang_active` as `s_plugin_netzp_blog_category.saleschannel.hreflangActive`, `s_plugin_netzp_blog_category.saleschannel`.`maintenance` as `s_plugin_netzp_blog_category.saleschannel.maintenance`, `s_plugin_netzp_blog_category.saleschannel`.`maintenance_ip_whitelist` as `s_plugin_netzp_blog_category.saleschannel.maintenanceIpWhitelist`, `s_plugin_netzp_blog_category.saleschannel`.`payment_method_ids` as `s_plugin_netzp_blog_category.saleschannel.paymentMethodIds`, `s_plugin_netzp_blog_category.saleschannel`.`home_cms_page_id` as `s_plugin_netzp_blog_category.saleschannel.homeCmsPageId`, `s_plugin_netzp_blog_category.saleschannel`.`home_cms_page_version_id` as `s_plugin_netzp_blog_category.saleschannel.homeCmsPageVersionId`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`id` as `s_plugin_netzp_blog_category.saleschannel.analytics.id`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`tracking_id` as `s_plugin_netzp_blog_category.saleschannel.analytics.trackingId`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`active` as `s_plugin_netzp_blog_category.saleschannel.analytics.active`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`track_orders` as `s_plugin_netzp_blog_category.saleschannel.analytics.trackOrders`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`anonymize_ip` as `s_plugin_netzp_blog_category.saleschannel.analytics.anonymizeIp`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`created_at` as `s_plugin_netzp_blog_category.saleschannel.analytics.createdAt`, `s_plugin_netzp_blog_category.saleschannel.analytics`.`updated_at` as `s_plugin_netzp_blog_category.saleschannel.analytics.updatedAt`, `s_plugin_netzp_blog_category.saleschannel`.`created_at` as `s_plugin_netzp_blog_category.saleschannel.createdAt`, `s_plugin_netzp_blog_category.saleschannel`.`updated_at` as `s_plugin_netzp_blog_category.saleschannel.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation.name`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.name`,`s_plugin_netzp_blog_category.saleschannel.translation.name`) as `s_plugin_netzp_blog_category.saleschannel.name`, `s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`,`s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`) as `s_plugin_netzp_blog_category.saleschannel.homeSlotConfig`, `s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`,`s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`) as `s_plugin_netzp_blog_category.saleschannel.homeEnabled`, `s_plugin_netzp_blog_category.saleschannel.translation.homeName`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeName`,`s_plugin_netzp_blog_category.saleschannel.translation.homeName`) as `s_plugin_netzp_blog_category.saleschannel.homeName`, `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`,`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`) as `s_plugin_netzp_blog_category.saleschannel.homeMetaTitle`, `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`,`s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`) as `s_plugin_netzp_blog_category.saleschannel.homeMetaDescription`, `s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`,`s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`) as `s_plugin_netzp_blog_category.saleschannel.homeKeywords`, `s_plugin_netzp_blog_category.saleschannel.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.saleschannel.translation.customFields`,`s_plugin_netzp_blog_category.saleschannel.translation.customFields`) as `s_plugin_netzp_blog_category.saleschannel.customFields`, `s_plugin_netzp_blog_category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog_category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog_category.saleschannel.translation.languageId`, `s_plugin_netzp_blog_category.customergroup`.`id` as `s_plugin_netzp_blog_category.customergroup.id`, `s_plugin_netzp_blog_category.customergroup`.`display_gross` as `s_plugin_netzp_blog_category.customergroup.displayGross`, `s_plugin_netzp_blog_category.customergroup`.`registration_active` as `s_plugin_netzp_blog_category.customergroup.registrationActive`, `s_plugin_netzp_blog_category.customergroup`.`created_at` as `s_plugin_netzp_blog_category.customergroup.createdAt`, `s_plugin_netzp_blog_category.customergroup`.`updated_at` as `s_plugin_netzp_blog_category.customergroup.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation.name`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.name`,`s_plugin_netzp_blog_category.customergroup.translation.name`) as `s_plugin_netzp_blog_category.customergroup.name`, `s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`,`s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`) as `s_plugin_netzp_blog_category.customergroup.registrationTitle`, `s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`,`s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`) as `s_plugin_netzp_blog_category.customergroup.registrationIntroduction`, `s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`,`s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`) as `s_plugin_netzp_blog_category.customergroup.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`,`s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`) as `s_plugin_netzp_blog_category.customergroup.registrationSeoMetaDescription`, `s_plugin_netzp_blog_category.customergroup.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.customergroup.translation.customFields`,`s_plugin_netzp_blog_category.customergroup.translation.customFields`) as `s_plugin_netzp_blog_category.customergroup.customFields`, `s_plugin_netzp_blog_category.customergroup.translation.createdAt`, `s_plugin_netzp_blog_category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog_category.customergroup.translation.languageId`, `s_plugin_netzp_blog_category`.`created_at` as `s_plugin_netzp_blog_category.createdAt`, `s_plugin_netzp_blog_category`.`updated_at` as `s_plugin_netzp_blog_category.updatedAt`, `s_plugin_netzp_blog_category.translation.title`, COALESCE(`s_plugin_netzp_blog_category.translation.title`,`s_plugin_netzp_blog_category.translation.title`) as `s_plugin_netzp_blog_category.title`, `s_plugin_netzp_blog_category.translation.teaser`, COALESCE(`s_plugin_netzp_blog_category.translation.teaser`,`s_plugin_netzp_blog_category.translation.teaser`) as `s_plugin_netzp_blog_category.teaser`, `s_plugin_netzp_blog_category.translation.customFields`, COALESCE(`s_plugin_netzp_blog_category.translation.customFields`,`s_plugin_netzp_blog_category.translation.customFields`) as `s_plugin_netzp_blog_category.customFields`, `s_plugin_netzp_blog_category.translation.createdAt`, `s_plugin_netzp_blog_category.translation.updatedAt`, `s_plugin_netzp_blog_category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog_category.translation.languageId` FROM `s_plugin_netzp_blog_category` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.translation`.s_plugin_netzp_blog_category_id, `s_plugin_netzp_blog_category.translation`.title as `s_plugin_netzp_blog_category.translation.title`, `s_plugin_netzp_blog_category.translation`.teaser as `s_plugin_netzp_blog_category.translation.teaser`, `s_plugin_netzp_blog_category.translation`.custom_fields as `s_plugin_netzp_blog_category.translation.customFields`, `s_plugin_netzp_blog_category.translation`.created_at as `s_plugin_netzp_blog_category.translation.createdAt`, `s_plugin_netzp_blog_category.translation`.updated_at as `s_plugin_netzp_blog_category.translation.updatedAt`, `s_plugin_netzp_blog_category.translation`.s_plugin_netzp_blog_category_id as `s_plugin_netzp_blog_category.translation.sPluginNetzpBlogCategoryId`, `s_plugin_netzp_blog_category.translation`.language_id as `s_plugin_netzp_blog_category.translation.languageId` FROM `s_plugin_netzp_blog_category_translation` `s_plugin_netzp_blog_category.translation` WHERE `s_plugin_netzp_blog_category.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.s_plugin_netzp_blog_category_translation` ON `s_plugin_netzp_blog_category.s_plugin_netzp_blog_category_translation`.`s_plugin_netzp_blog_category_id` = `s_plugin_netzp_blog_category`.`id` LEFT JOIN `sales_channel` `s_plugin_netzp_blog_category.saleschannel` ON `s_plugin_netzp_blog_category`.`saleschannel_id` = `s_plugin_netzp_blog_category.saleschannel`.`id` LEFT JOIN `customer_group` `s_plugin_netzp_blog_category.customergroup` ON `s_plugin_netzp_blog_category`.`customergroup_id` = `s_plugin_netzp_blog_category.customergroup`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.saleschannel.translation`.sales_channel_id, `s_plugin_netzp_blog_category.saleschannel.translation`.name as `s_plugin_netzp_blog_category.saleschannel.translation.name`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_slot_config as `s_plugin_netzp_blog_category.saleschannel.translation.homeSlotConfig`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_enabled as `s_plugin_netzp_blog_category.saleschannel.translation.homeEnabled`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_name as `s_plugin_netzp_blog_category.saleschannel.translation.homeName`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_meta_title as `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaTitle`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_meta_description as `s_plugin_netzp_blog_category.saleschannel.translation.homeMetaDescription`, `s_plugin_netzp_blog_category.saleschannel.translation`.home_keywords as `s_plugin_netzp_blog_category.saleschannel.translation.homeKeywords`, `s_plugin_netzp_blog_category.saleschannel.translation`.custom_fields as `s_plugin_netzp_blog_category.saleschannel.translation.customFields`, `s_plugin_netzp_blog_category.saleschannel.translation`.created_at as `s_plugin_netzp_blog_category.saleschannel.translation.createdAt`, `s_plugin_netzp_blog_category.saleschannel.translation`.updated_at as `s_plugin_netzp_blog_category.saleschannel.translation.updatedAt`, `s_plugin_netzp_blog_category.saleschannel.translation`.sales_channel_id as `s_plugin_netzp_blog_category.saleschannel.translation.salesChannelId`, `s_plugin_netzp_blog_category.saleschannel.translation`.language_id as `s_plugin_netzp_blog_category.saleschannel.translation.languageId` FROM `sales_channel_translation` `s_plugin_netzp_blog_category.saleschannel.translation` WHERE `s_plugin_netzp_blog_category.saleschannel.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.saleschannel.sales_channel_translation` ON `s_plugin_netzp_blog_category.saleschannel.sales_channel_translation`.`sales_channel_id` = `s_plugin_netzp_blog_category.saleschannel`.`id` LEFT JOIN `sales_channel_analytics` `s_plugin_netzp_blog_category.saleschannel.analytics` ON `s_plugin_netzp_blog_category.saleschannel`.`analytics_id` = `s_plugin_netzp_blog_category.saleschannel.analytics`.`id` LEFT JOIN (SELECT `s_plugin_netzp_blog_category.customergroup.translation`.customer_group_id, `s_plugin_netzp_blog_category.customergroup.translation`.name as `s_plugin_netzp_blog_category.customergroup.translation.name`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_title as `s_plugin_netzp_blog_category.customergroup.translation.registrationTitle`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_introduction as `s_plugin_netzp_blog_category.customergroup.translation.registrationIntroduction`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_only_company_registration as `s_plugin_netzp_blog_category.customergroup.translation.registrationOnlyCompanyRegistration`, `s_plugin_netzp_blog_category.customergroup.translation`.registration_seo_meta_description as `s_plugin_netzp_blog_category.customergroup.translation.registrationSeoMetaDescription`, `s_plugin_netzp_blog_category.customergroup.translation`.custom_fields as `s_plugin_netzp_blog_category.customergroup.translation.customFields`, `s_plugin_netzp_blog_category.customergroup.translation`.created_at as `s_plugin_netzp_blog_category.customergroup.translation.createdAt`, `s_plugin_netzp_blog_category.customergroup.translation`.updated_at as `s_plugin_netzp_blog_category.customergroup.translation.updatedAt`, `s_plugin_netzp_blog_category.customergroup.translation`.customer_group_id as `s_plugin_netzp_blog_category.customergroup.translation.customerGroupId`, `s_plugin_netzp_blog_category.customergroup.translation`.language_id as `s_plugin_netzp_blog_category.customergroup.translation.languageId` FROM `customer_group_translation` `s_plugin_netzp_blog_category.customergroup.translation` WHERE `s_plugin_netzp_blog_category.customergroup.translation`.language_id = :languageId) `s_plugin_netzp_blog_category.customergroup.customer_group_translation` ON `s_plugin_netzp_blog_category.customergroup.customer_group_translation`.`customer_group_id` = `s_plugin_netzp_blog_category.customergroup`.`id` WHERE `s_plugin_netzp_blog_category`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
43 4.85 ms 
# cms::netzp-blog-listing::association::tags::read
SELECT `tag`.`id` as `tag.id`, `tag`.`name` as `tag.name`, `tag`.`created_at` as `tag.createdAt`, `tag`.`updated_at` as `tag.updatedAt` FROM `tag` WHERE `tag`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
44 9.43 ms 
SELECT `rhiem_userproducts_productgroup`.`id` as `rhiem_userproducts_productgroup.id`, `rhiem_userproducts_productgroup`.`name` as `rhiem_userproducts_productgroup.name`, `rhiem_userproducts_productgroup`.`group_mode` as `rhiem_userproducts_productgroup.groupMode`, `rhiem_userproducts_productgroup`.`active` as `rhiem_userproducts_productgroup.active`, `rhiem_userproducts_productgroup`.`categories` as `rhiem_userproducts_productgroup.categories`, `rhiem_userproducts_productgroup`.`customer_groups` as `rhiem_userproducts_productgroup.customerGroups`, `rhiem_userproducts_productgroup`.`fallback` as `rhiem_userproducts_productgroup.fallback`, `rhiem_userproducts_productgroup`.`created_at` as `rhiem_userproducts_productgroup.createdAt`, `rhiem_userproducts_productgroup`.`updated_at` as `rhiem_userproducts_productgroup.updatedAt` FROM `rhiem_userproducts_productgroup` WHERE (`rhiem_userproducts_productgroup`.`customer_groups` LIKE :param_fdbf72b181ee4ac3bcfd95cdc1425d89)
View formatted query    View runnable query    View query stack
45 0.50 ms 
SELECT `rhiem_userproducts_productgroup`.`id` as `rhiem_userproducts_productgroup.id`, `rhiem_userproducts_productgroup`.`name` as `rhiem_userproducts_productgroup.name`, `rhiem_userproducts_productgroup`.`group_mode` as `rhiem_userproducts_productgroup.groupMode`, `rhiem_userproducts_productgroup`.`active` as `rhiem_userproducts_productgroup.active`, `rhiem_userproducts_productgroup`.`categories` as `rhiem_userproducts_productgroup.categories`, `rhiem_userproducts_productgroup`.`customer_groups` as `rhiem_userproducts_productgroup.customerGroups`, `rhiem_userproducts_productgroup`.`fallback` as `rhiem_userproducts_productgroup.fallback`, `rhiem_userproducts_productgroup`.`created_at` as `rhiem_userproducts_productgroup.createdAt`, `rhiem_userproducts_productgroup`.`updated_at` as `rhiem_userproducts_productgroup.updatedAt` FROM `rhiem_userproducts_productgroup` WHERE `rhiem_userproducts_productgroup`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
46 16.70 ms 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = :languageId) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = :version) AND (`category`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
47 0.29 ms 
SELECT `rhiem_userproducts_productgroup`.`id` as `rhiem_userproducts_productgroup.id`, `rhiem_userproducts_productgroup`.`name` as `rhiem_userproducts_productgroup.name`, `rhiem_userproducts_productgroup`.`group_mode` as `rhiem_userproducts_productgroup.groupMode`, `rhiem_userproducts_productgroup`.`active` as `rhiem_userproducts_productgroup.active`, `rhiem_userproducts_productgroup`.`categories` as `rhiem_userproducts_productgroup.categories`, `rhiem_userproducts_productgroup`.`customer_groups` as `rhiem_userproducts_productgroup.customerGroups`, `rhiem_userproducts_productgroup`.`fallback` as `rhiem_userproducts_productgroup.fallback`, `rhiem_userproducts_productgroup`.`created_at` as `rhiem_userproducts_productgroup.createdAt`, `rhiem_userproducts_productgroup`.`updated_at` as `rhiem_userproducts_productgroup.updatedAt` FROM `rhiem_userproducts_productgroup` WHERE (`rhiem_userproducts_productgroup`.`customer_groups` LIKE :param_70a333b17bab420696c15198ef33da1a)
View formatted query    View runnable query    View query stack
48 0.24 ms 
SELECT `rhiem_userproducts_productgroup`.`id` as `rhiem_userproducts_productgroup.id`, `rhiem_userproducts_productgroup`.`name` as `rhiem_userproducts_productgroup.name`, `rhiem_userproducts_productgroup`.`group_mode` as `rhiem_userproducts_productgroup.groupMode`, `rhiem_userproducts_productgroup`.`active` as `rhiem_userproducts_productgroup.active`, `rhiem_userproducts_productgroup`.`categories` as `rhiem_userproducts_productgroup.categories`, `rhiem_userproducts_productgroup`.`customer_groups` as `rhiem_userproducts_productgroup.customerGroups`, `rhiem_userproducts_productgroup`.`fallback` as `rhiem_userproducts_productgroup.fallback`, `rhiem_userproducts_productgroup`.`created_at` as `rhiem_userproducts_productgroup.createdAt`, `rhiem_userproducts_productgroup`.`updated_at` as `rhiem_userproducts_productgroup.updatedAt` FROM `rhiem_userproducts_productgroup` WHERE `rhiem_userproducts_productgroup`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
49 2.70 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY sales_channel_id ASC
View formatted query    View runnable query    View query stack
50 0.24 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY sales_channel_id ASC
View formatted query    View runnable query    View query stack
51 4.57 ms 
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`, `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`, `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`, `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`, `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`, `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`, `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`, `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`, `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`, `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`, `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`, `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`, `sales_channel_domain.language.locale.translation.name`, COALESCE(`sales_channel_domain.language.locale.translation.name`,`sales_channel_domain.language.locale.translation.name`) as `sales_channel_domain.language.locale.name`, `sales_channel_domain.language.locale.translation.territory`, COALESCE(`sales_channel_domain.language.locale.translation.territory`,`sales_channel_domain.language.locale.translation.territory`) as `sales_channel_domain.language.locale.territory`, `sales_channel_domain.language.locale.translation.customFields`, COALESCE(`sales_channel_domain.language.locale.translation.customFields`,`sales_channel_domain.language.locale.translation.customFields`) as `sales_channel_domain.language.locale.customFields`, `sales_channel_domain.language.locale.translation.createdAt`, `sales_channel_domain.language.locale.translation.updatedAt`, `sales_channel_domain.language.locale.translation.localeId`, `sales_channel_domain.language.locale.translation.languageId`, `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`, `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`, `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`, `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`, `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`, `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`, `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`, `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`, `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`, `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`, `sales_channel_domain.currency.translation.shortName`, COALESCE(`sales_channel_domain.currency.translation.shortName`,`sales_channel_domain.currency.translation.shortName`) as `sales_channel_domain.currency.shortName`, `sales_channel_domain.currency.translation.name`, COALESCE(`sales_channel_domain.currency.translation.name`,`sales_channel_domain.currency.translation.name`) as `sales_channel_domain.currency.name`, `sales_channel_domain.currency.translation.customFields`, COALESCE(`sales_channel_domain.currency.translation.customFields`,`sales_channel_domain.currency.translation.customFields`) as `sales_channel_domain.currency.customFields`, `sales_channel_domain.currency.translation.createdAt`, `sales_channel_domain.currency.translation.updatedAt`, `sales_channel_domain.currency.translation.currencyId`, `sales_channel_domain.currency.translation.languageId` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation`.locale_id, `sales_channel_domain.language.locale.translation`.name as `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation`.territory as `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation`.custom_fields as `sales_channel_domain.language.locale.translation.customFields`, `sales_channel_domain.language.locale.translation`.created_at as `sales_channel_domain.language.locale.translation.createdAt`, `sales_channel_domain.language.locale.translation`.updated_at as `sales_channel_domain.language.locale.translation.updatedAt`, `sales_channel_domain.language.locale.translation`.locale_id as `sales_channel_domain.language.locale.translation.localeId`, `sales_channel_domain.language.locale.translation`.language_id as `sales_channel_domain.language.locale.translation.languageId` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation`.language_id = :languageId) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation`.currency_id, `sales_channel_domain.currency.translation`.short_name as `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation`.name as `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation`.custom_fields as `sales_channel_domain.currency.translation.customFields`, `sales_channel_domain.currency.translation`.created_at as `sales_channel_domain.currency.translation.createdAt`, `sales_channel_domain.currency.translation`.updated_at as `sales_channel_domain.currency.translation.updatedAt`, `sales_channel_domain.currency.translation`.currency_id as `sales_channel_domain.currency.translation.currencyId`, `sales_channel_domain.currency.translation`.language_id as `sales_channel_domain.currency.translation.languageId` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation`.language_id = :languageId) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id` WHERE `sales_channel_domain`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
52 0.84 ms 
SELECT `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`, `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`, `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`, `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`, `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`, `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`, `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`, `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`, `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`, `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`, `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`, `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`, `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer`.`domain_id` = :param_899c553b7db24d01bc2e5cb3a71135b2)
View formatted query    View runnable query    View query stack
53 3.55 ms 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = :languageId) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
54 5.42 ms 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = :languageId) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
55 7.34 ms 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_fe8a6674d0b34e20aad9aacdf53d7b89)
View formatted query    View runnable query    View query stack
56 0.49 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
57 0.22 ms 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
View formatted query    View runnable query    View query stack
58 0.18 ms 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
View formatted query    View runnable query    View query stack
59 0.28 ms 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
View formatted query    View runnable query    View query stack
60 3.21 ms 
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> :param_7f6914cf12c94bbd847148d63682cb3a)
View formatted query    View runnable query    View query stack
61 6.55 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1
View formatted query    View runnable query    View query stack
62 9.50 ms 
SELECT seo_path_info, path_info FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (:pathInfo)) AND (seo_url.language_id = :languageId) AND (seo_url.sales_channel_id = :salesChannelId OR seo_url.sales_channel_id IS NULL) AND (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC
View formatted query    View runnable query    View query stack

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping