https://sw08.sw.dev.aidup.io/account/assortment/list/null?only-aggregations=1&reduce-aggregations=1

Method
GET
HTTP Status
500
IP
127.0.0.1
Profiled on
Token
640ade

Query Metrics

57 Database Queries
Different statements
423.89 ms Query time
Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.14 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
2 2.79 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_1587111506_IS_ACTIVE = TRUE;SET @MIGRATION_1588143272_IS_ACTIVE = TRUE;SET @MIGRATION_1588144801_IS_ACTIVE = TRUE;SET @MIGRATION_1588153272_IS_ACTIVE = TRUE;SET @MIGRATION_1589178550_IS_ACTIVE = TRUE;SET @MIGRATION_1589357321_IS_ACTIVE = TRUE;SET @MIGRATION_1589359936_IS_ACTIVE = TRUE;SET @MIGRATION_1589379060_IS_ACTIVE = TRUE;SET @MIGRATION_1589447332_IS_ACTIVE = TRUE;SET @MIGRATION_1589458026_IS_ACTIVE = TRUE;SET @MIGRATION_1590408550_IS_ACTIVE = TRUE;SET @MIGRATION_1590409548_IS_ACTIVE = TRUE;SET @MIGRATION_1590566018_IS_ACTIVE = TRUE;SET @MIGRATION_1590566405_IS_ACTIVE = TRUE;SET @MIGRATION_1590579986_IS_ACTIVE = TRUE;SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591052278_IS_ACTIVE = TRUE;SET @MIGRATION_1591167126_IS_ACTIVE = TRUE;SET @MIGRATION_1591253089_IS_ACTIVE = TRUE;SET @MIGRATION_1591259559_IS_ACTIVE = TRUE;SET @MIGRATION_1591272594_IS_ACTIVE = TRUE;SET @MIGRATION_1591361320_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1591817370_IS_ACTIVE = TRUE;SET @MIGRATION_1592466717_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1592978289_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1594650256_IS_ACTIVE = TRUE;SET @MIGRATION_1594885630_IS_ACTIVE = TRUE;SET @MIGRATION_1594886106_IS_ACTIVE = TRUE;SET @MIGRATION_1594886773_IS_ACTIVE = TRUE;SET @MIGRATION_1594886895_IS_ACTIVE = TRUE;SET @MIGRATION_1594887027_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595480600_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595499689_IS_ACTIVE = TRUE;SET @MIGRATION_1595553089_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_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_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_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_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1589199909_IS_ACTIVE = TRUE;SET @MIGRATION_1649838053_IS_ACTIVE = TRUE;SET @MIGRATION_1570025268_IS_ACTIVE = TRUE;SET @MIGRATION_1596438247_IS_ACTIVE = TRUE;SET @MIGRATION_1635756230_IS_ACTIVE = TRUE;SET @MIGRATION_1635757867_IS_ACTIVE = TRUE;SET @MIGRATION_1635849633_IS_ACTIVE = TRUE;SET @MIGRATION_1635849637_IS_ACTIVE = TRUE;SET @MIGRATION_1644313669_IS_ACTIVE = TRUE;SET @MIGRATION_1646119820_IS_ACTIVE = TRUE;SET @MIGRATION_1601622132_IS_ACTIVE = TRUE;SET @MIGRATION_1602761577_IS_ACTIVE = TRUE;SET @MIGRATION_1606987075_IS_ACTIVE = TRUE;SET @MIGRATION_1609856970_IS_ACTIVE = TRUE;SET @MIGRATION_1609929616_IS_ACTIVE = TRUE;SET @MIGRATION_1610107035_IS_ACTIVE = TRUE;SET @MIGRATION_1611047410_IS_ACTIVE = TRUE;SET @MIGRATION_1611309499_IS_ACTIVE = TRUE;SET @MIGRATION_1611655657_IS_ACTIVE = TRUE;SET @MIGRATION_1611749679_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1585052822_IS_ACTIVE = TRUE;SET @MIGRATION_1651059763_IS_ACTIVE = TRUE;SET @MIGRATION_1661102992_IS_ACTIVE = TRUE;SET @MIGRATION_1661103992_IS_ACTIVE = TRUE;SET @MIGRATION_1609921248_IS_ACTIVE = TRUE;SET @MIGRATION_1609939597_IS_ACTIVE = TRUE;SET @MIGRATION_1613038572_IS_ACTIVE = TRUE;SET @MIGRATION_1606731597_IS_ACTIVE = TRUE;SET @MIGRATION_1607003943_IS_ACTIVE = TRUE;SET @MIGRATION_1607602993_IS_ACTIVE = TRUE;SET @MIGRATION_1610977013_IS_ACTIVE = TRUE;SET @MIGRATION_1612101832_IS_ACTIVE = TRUE;SET @MIGRATION_1613385682_IS_ACTIVE = TRUE;SET @MIGRATION_1616678164_IS_ACTIVE = TRUE;SET @MIGRATION_1620389895_IS_ACTIVE = TRUE;SET @MIGRATION_1642753264_IS_ACTIVE = TRUE;SET @MIGRATION_1617014641_IS_ACTIVE = TRUE;SET @MIGRATION_1625059909_IS_ACTIVE = TRUE;SET @MIGRATION_1626340031_IS_ACTIVE = TRUE;SET @MIGRATION_1626855189_IS_ACTIVE = TRUE;SET @MIGRATION_1626908569_IS_ACTIVE = TRUE;SET @MIGRATION_1637910884_IS_ACTIVE = TRUE;SET @MIGRATION_1649771353_IS_ACTIVE = TRUE;SET @MIGRATION_1606722461_IS_ACTIVE = TRUE;SET @MIGRATION_1606743724_IS_ACTIVE = TRUE;SET @MIGRATION_1608123054_IS_ACTIVE = TRUE;SET @MIGRATION_1608301193_IS_ACTIVE = TRUE;SET @MIGRATION_1608301201_IS_ACTIVE = TRUE;SET @MIGRATION_1608301204_IS_ACTIVE = TRUE;SET @MIGRATION_1610024634_IS_ACTIVE = TRUE;SET @MIGRATION_1644908809_IS_ACTIVE = TRUE;SET @MIGRATION_1624447994_IS_ACTIVE = TRUE;SET @MIGRATION_1656082538_IS_ACTIVE = TRUE;SET @MIGRATION_1625645868_IS_ACTIVE = TRUE;SET @MIGRATION_1626259853_IS_ACTIVE = TRUE;SET @MIGRATION_1580730959_IS_ACTIVE = TRUE;SET @MIGRATION_1623051960_IS_ACTIVE = TRUE;SET @MIGRATION_1624023259_IS_ACTIVE = TRUE;SET @MIGRATION_1558500331_IS_ACTIVE = TRUE;SET @MIGRATION_1615911875_IS_ACTIVE = TRUE;SET @MIGRATION_1646211291_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1583481305_IS_ACTIVE = TRUE;SET @MIGRATION_1583481306_IS_ACTIVE = TRUE;SET @MIGRATION_1625729418_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1699006548_IS_ACTIVE = TRUE;SET @MIGRATION_1710492785_IS_ACTIVE = TRUE;SET @MIGRATION_1724409931_IS_ACTIVE = TRUE;SET @MIGRATION_1724228341_IS_ACTIVE = TRUE
View formatted query    View runnable query    View query stack
3 0.22 ms 
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, :url0 REGEXP `old_url_regex` as regex0, :url2 REGEXP `old_url_regex` as regex2, :url3 REGEXP `old_url_regex` as regex3, :url4 REGEXP `old_url_regex` as regex4 FROM `acris_seo_redirect` WHERE `active` = :active AND ((NOT (`search_url_by` = :searchByUrlRegex) AND ((`old_url` = :url0 OR `old_url` = :url2 OR `old_url` = :url3 OR `old_url` = :url4))) OR (`search_url_by` = :searchByUrlRegex AND ((:url0 REGEXP `old_url_regex` OR :url2 REGEXP `old_url_regex` OR :url3 REGEXP `old_url_regex` OR :url4 REGEXP `old_url_regex`)))) LIMIT 6;
View formatted query    View runnable query    View query stack
4 0.22 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
5 7.55 ms 
# context-factory::customer::read
SELECT `customer`.`id` as `customer.id`, `customer`.`customer_group_id` as `customer.groupId`, `customer`.`default_payment_method_id` as `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` as `customer.salesChannelId`, `customer`.`language_id` as `customer.languageId`, `customer`.`last_payment_method_id` as `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` as `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` as `customer.defaultShippingAddressId`, `customer`.`auto_increment` as `customer.autoIncrement`, `customer`.`customer_number` as `customer.customerNumber`, `customer`.`salutation_id` as `customer.salutationId`, `customer`.`first_name` as `customer.firstName`, `customer`.`last_name` as `customer.lastName`, `customer`.`company` as `customer.company`, `customer`.`password` as `customer.password`, `customer`.`email` as `customer.email`, `customer`.`title` as `customer.title`, `customer`.`vat_ids` as `customer.vatIds`, `customer`.`affiliate_code` as `customer.affiliateCode`, `customer`.`campaign_code` as `customer.campaignCode`, `customer`.`active` as `customer.active`, `customer`.`double_opt_in_registration` as `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` as `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` as `customer.doubleOptInConfirmDate`, `customer`.`hash` as `customer.hash`, `customer`.`guest` as `customer.guest`, `customer`.`first_login` as `customer.firstLogin`, `customer`.`last_login` as `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` as `customer.newsletterSalesChannelIds`, `customer`.`newsletter` as `customer.newsletter`, `customer`.`birthday` as `customer.birthday`, `customer`.`last_order_date` as `customer.lastOrderDate`, `customer`.`order_count` as `customer.orderCount`, `customer`.`order_total_amount` as `customer.orderTotalAmount`, `customer`.`custom_fields` as `customer.customFields`, `customer`.`legacy_password` as `customer.legacyPassword`, `customer`.`legacy_encoder` as `customer.legacyEncoder`, `customer`.`remote_address` as `customer.remoteAddress`, `customer`.`tag_ids` as `customer.tagIds`, `customer`.`requested_customer_group_id` as `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` as `customer.boundSalesChannelId`, `customer`.`created_at` as `customer.createdAt`, `customer`.`updated_at` as `customer.updatedAt`, `customer.customerUser`.`id` as `customer.customerUser.id`, `customer.customerUser`.`customer_id` as `customer.customerUser.customerId`, `customer.customerUser`.`group_id` as `customer.customerUser.groupId`, `customer.customerUser`.`parent_customer_id` as `customer.customerUser.parentCustomerId`, `customer.customerUser`.`role` as `customer.customerUser.role`, `customer.customerUser`.`created_at` as `customer.customerUser.createdAt`, `customer.customerUser`.`updated_at` as `customer.customerUser.updatedAt`, `customer.salutation`.`id` as `customer.salutation.id`, `customer.salutation`.`salutation_key` as `customer.salutation.salutationKey`, `customer.salutation`.`created_at` as `customer.salutation.createdAt`, `customer.salutation`.`updated_at` as `customer.salutation.updatedAt`, `customer.salutation.translation.displayName`, COALESCE(`customer.salutation.translation.displayName`,`customer.salutation.translation.displayName`) as `customer.salutation.displayName`, `customer.salutation.translation.letterName`, COALESCE(`customer.salutation.translation.letterName`,`customer.salutation.translation.letterName`) as `customer.salutation.letterName`, `customer.salutation.translation.customFields`, COALESCE(`customer.salutation.translation.customFields`,`customer.salutation.translation.customFields`) as `customer.salutation.customFields`, `customer.salutation.translation.createdAt`, `customer.salutation.translation.updatedAt`, `customer.salutation.translation.salutationId`, `customer.salutation.translation.languageId`, `customer.defaultPaymentMethod`.`id` as `customer.defaultPaymentMethod.id`, `customer.defaultPaymentMethod`.`plugin_id` as `customer.defaultPaymentMethod.pluginId`, `customer.defaultPaymentMethod`.`handler_identifier` as `customer.defaultPaymentMethod.handlerIdentifier`, `customer.defaultPaymentMethod`.`position` as `customer.defaultPaymentMethod.position`, `customer.defaultPaymentMethod`.`active` as `customer.defaultPaymentMethod.active`, `customer.defaultPaymentMethod`.`after_order_enabled` as `customer.defaultPaymentMethod.afterOrderEnabled`, `customer.defaultPaymentMethod`.`availability_rule_id` as `customer.defaultPaymentMethod.availabilityRuleId`, `customer.defaultPaymentMethod`.`media_id` as `customer.defaultPaymentMethod.mediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`id` as `customer.defaultPaymentMethod.appPaymentMethod.id`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_name` as `customer.defaultPaymentMethod.appPaymentMethod.appName`, `customer.defaultPaymentMethod.appPaymentMethod`.`identifier` as `customer.defaultPaymentMethod.appPaymentMethod.identifier`, `customer.defaultPaymentMethod.appPaymentMethod`.`pay_url` as `customer.defaultPaymentMethod.appPaymentMethod.payUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`finalize_url` as `customer.defaultPaymentMethod.appPaymentMethod.finalizeUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`validate_url` as `customer.defaultPaymentMethod.appPaymentMethod.validateUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`capture_url` as `customer.defaultPaymentMethod.appPaymentMethod.captureUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`refund_url` as `customer.defaultPaymentMethod.appPaymentMethod.refundUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_id` as `customer.defaultPaymentMethod.appPaymentMethod.appId`, `customer.defaultPaymentMethod.appPaymentMethod`.`original_media_id` as `customer.defaultPaymentMethod.appPaymentMethod.originalMediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` as `customer.defaultPaymentMethod.appPaymentMethod.paymentMethodId`, `customer.defaultPaymentMethod.appPaymentMethod`.`created_at` as `customer.defaultPaymentMethod.appPaymentMethod.createdAt`, `customer.defaultPaymentMethod.appPaymentMethod`.`updated_at` as `customer.defaultPaymentMethod.appPaymentMethod.updatedAt`, `customer.defaultPaymentMethod`.`created_at` as `customer.defaultPaymentMethod.createdAt`, `customer.defaultPaymentMethod`.`updated_at` as `customer.defaultPaymentMethod.updatedAt`, `customer.defaultPaymentMethod.translation.name`, COALESCE(`customer.defaultPaymentMethod.translation.name`,`customer.defaultPaymentMethod.translation.name`) as `customer.defaultPaymentMethod.name`, `customer.defaultPaymentMethod.translation.distinguishableName`, COALESCE(`customer.defaultPaymentMethod.translation.distinguishableName`,`customer.defaultPaymentMethod.translation.distinguishableName`) as `customer.defaultPaymentMethod.distinguishableName`, `customer.defaultPaymentMethod.translation.description`, COALESCE(`customer.defaultPaymentMethod.translation.description`,`customer.defaultPaymentMethod.translation.description`) as `customer.defaultPaymentMethod.description`, `customer.defaultPaymentMethod.translation.customFields`, COALESCE(`customer.defaultPaymentMethod.translation.customFields`,`customer.defaultPaymentMethod.translation.customFields`) as `customer.defaultPaymentMethod.customFields`, `customer.defaultPaymentMethod.translation.createdAt`, `customer.defaultPaymentMethod.translation.updatedAt`, `customer.defaultPaymentMethod.translation.paymentMethodId`, `customer.defaultPaymentMethod.translation.languageId` FROM `customer` LEFT JOIN `templaid_customer_user` `customer.customerUser` ON `customer`.`id` = `customer.customerUser`.`customer_id` LEFT JOIN `salutation` `customer.salutation` ON `customer`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN `payment_method` `customer.defaultPaymentMethod` ON `customer`.`default_payment_method_id` = `customer.defaultPaymentMethod`.`id` LEFT JOIN (SELECT `customer.salutation.translation`.salutation_id, `customer.salutation.translation`.display_name as `customer.salutation.translation.displayName`, `customer.salutation.translation`.letter_name as `customer.salutation.translation.letterName`, `customer.salutation.translation`.custom_fields as `customer.salutation.translation.customFields`, `customer.salutation.translation`.created_at as `customer.salutation.translation.createdAt`, `customer.salutation.translation`.updated_at as `customer.salutation.translation.updatedAt`, `customer.salutation.translation`.salutation_id as `customer.salutation.translation.salutationId`, `customer.salutation.translation`.language_id as `customer.salutation.translation.languageId` FROM `salutation_translation` `customer.salutation.translation` WHERE `customer.salutation.translation`.language_id = :languageId) `customer.salutation.salutation_translation` ON `customer.salutation.salutation_translation`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN (SELECT `customer.defaultPaymentMethod.translation`.payment_method_id, `customer.defaultPaymentMethod.translation`.name as `customer.defaultPaymentMethod.translation.name`, `customer.defaultPaymentMethod.translation`.distinguishable_name as `customer.defaultPaymentMethod.translation.distinguishableName`, `customer.defaultPaymentMethod.translation`.description as `customer.defaultPaymentMethod.translation.description`, `customer.defaultPaymentMethod.translation`.custom_fields as `customer.defaultPaymentMethod.translation.customFields`, `customer.defaultPaymentMethod.translation`.created_at as `customer.defaultPaymentMethod.translation.createdAt`, `customer.defaultPaymentMethod.translation`.updated_at as `customer.defaultPaymentMethod.translation.updatedAt`, `customer.defaultPaymentMethod.translation`.payment_method_id as `customer.defaultPaymentMethod.translation.paymentMethodId`, `customer.defaultPaymentMethod.translation`.language_id as `customer.defaultPaymentMethod.translation.languageId` FROM `payment_method_translation` `customer.defaultPaymentMethod.translation` WHERE `customer.defaultPaymentMethod.translation`.language_id = :languageId) `customer.defaultPaymentMethod.payment_method_translation` ON `customer.defaultPaymentMethod.payment_method_translation`.`payment_method_id` = `customer.defaultPaymentMethod`.`id` LEFT JOIN `app_payment_method` `customer.defaultPaymentMethod.appPaymentMethod` ON `customer.defaultPaymentMethod`.`id` = `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` WHERE (((`customer`.`bound_sales_channel_id` <=> :param_98224403ca014632ab3d81e1cc7f89e4 OR `customer`.`bound_sales_channel_id` = :param_9192de98395741d48c887747ad713b63))) AND (`customer`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
6 0.12 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
View formatted query    View runnable query    View query stack
7 0.21 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_042fb2f0d6f14954bfa49cdb74f68e1f)
View formatted query    View runnable query    View query stack
8 4.83 ms 
# context-factory::addresses::read
SELECT `customer_address`.`id` as `customer_address.id`, `customer_address`.`customer_id` as `customer_address.customerId`, `customer_address`.`country_id` as `customer_address.countryId`, `customer_address`.`country_state_id` as `customer_address.countryStateId`, `customer_address`.`salutation_id` as `customer_address.salutationId`, `customer_address`.`first_name` as `customer_address.firstName`, `customer_address`.`last_name` as `customer_address.lastName`, `customer_address`.`zipcode` as `customer_address.zipcode`, `customer_address`.`city` as `customer_address.city`, `customer_address`.`company` as `customer_address.company`, `customer_address`.`street` as `customer_address.street`, `customer_address`.`department` as `customer_address.department`, `customer_address`.`title` as `customer_address.title`, `customer_address`.`phone_number` as `customer_address.phoneNumber`, `customer_address`.`additional_address_line1` as `customer_address.additionalAddressLine1`, `customer_address`.`additional_address_line2` as `customer_address.additionalAddressLine2`, `customer_address`.`custom_fields` as `customer_address.customFields`, `customer_address`.`created_at` as `customer_address.createdAt`, `customer_address`.`updated_at` as `customer_address.updatedAt`, `customer_address.salutation`.`id` as `customer_address.salutation.id`, `customer_address.salutation`.`salutation_key` as `customer_address.salutation.salutationKey`, `customer_address.salutation`.`created_at` as `customer_address.salutation.createdAt`, `customer_address.salutation`.`updated_at` as `customer_address.salutation.updatedAt`, `customer_address.salutation.translation.displayName`, COALESCE(`customer_address.salutation.translation.displayName`,`customer_address.salutation.translation.displayName`) as `customer_address.salutation.displayName`, `customer_address.salutation.translation.letterName`, COALESCE(`customer_address.salutation.translation.letterName`,`customer_address.salutation.translation.letterName`) as `customer_address.salutation.letterName`, `customer_address.salutation.translation.customFields`, COALESCE(`customer_address.salutation.translation.customFields`,`customer_address.salutation.translation.customFields`) as `customer_address.salutation.customFields`, `customer_address.salutation.translation.createdAt`, `customer_address.salutation.translation.updatedAt`, `customer_address.salutation.translation.salutationId`, `customer_address.salutation.translation.languageId`, `customer_address.country`.`id` as `customer_address.country.id`, `customer_address.country`.`iso` as `customer_address.country.iso`, `customer_address.country`.`position` as `customer_address.country.position`, `customer_address.country`.`active` as `customer_address.country.active`, `customer_address.country`.`shipping_available` as `customer_address.country.shippingAvailable`, `customer_address.country`.`iso3` as `customer_address.country.iso3`, `customer_address.country`.`display_state_in_registration` as `customer_address.country.displayStateInRegistration`, `customer_address.country`.`force_state_in_registration` as `customer_address.country.forceStateInRegistration`, `customer_address.country`.`company_tax_free` as `customer_address.country.companyTaxFree`, `customer_address.country`.`check_vat_id_pattern` as `customer_address.country.checkVatIdPattern`, `customer_address.country`.`vat_id_required` as `customer_address.country.vatIdRequired`, `customer_address.country`.`tax_free` as `customer_address.country.taxFree`, `customer_address.country`.`vat_id_pattern` as `customer_address.country.vatIdPattern`, `customer_address.country`.`customer_tax` as `customer_address.country.customerTax`, `customer_address.country`.`company_tax` as `customer_address.country.companyTax`, `customer_address.country`.`created_at` as `customer_address.country.createdAt`, `customer_address.country`.`updated_at` as `customer_address.country.updatedAt`, `customer_address.country.translation.name`, COALESCE(`customer_address.country.translation.name`,`customer_address.country.translation.name`) as `customer_address.country.name`, `customer_address.country.translation.customFields`, COALESCE(`customer_address.country.translation.customFields`,`customer_address.country.translation.customFields`) as `customer_address.country.customFields`, `customer_address.country.translation.createdAt`, `customer_address.country.translation.updatedAt`, `customer_address.country.translation.countryId`, `customer_address.country.translation.languageId`, `customer_address.countryState`.`id` as `customer_address.countryState.id`, `customer_address.countryState`.`country_id` as `customer_address.countryState.countryId`, `customer_address.countryState`.`short_code` as `customer_address.countryState.shortCode`, `customer_address.countryState`.`position` as `customer_address.countryState.position`, `customer_address.countryState`.`active` as `customer_address.countryState.active`, `customer_address.countryState`.`created_at` as `customer_address.countryState.createdAt`, `customer_address.countryState`.`updated_at` as `customer_address.countryState.updatedAt`, `customer_address.countryState.translation.name`, COALESCE(`customer_address.countryState.translation.name`,`customer_address.countryState.translation.name`) as `customer_address.countryState.name`, `customer_address.countryState.translation.customFields`, COALESCE(`customer_address.countryState.translation.customFields`,`customer_address.countryState.translation.customFields`) as `customer_address.countryState.customFields`, `customer_address.countryState.translation.createdAt`, `customer_address.countryState.translation.updatedAt`, `customer_address.countryState.translation.countryStateId`, `customer_address.countryState.translation.languageId` FROM `customer_address` LEFT JOIN `salutation` `customer_address.salutation` ON `customer_address`.`salutation_id` = `customer_address.salutation`.`id` LEFT JOIN `country` `customer_address.country` ON `customer_address`.`country_id` = `customer_address.country`.`id` LEFT JOIN `country_state` `customer_address.countryState` ON `customer_address`.`country_state_id` = `customer_address.countryState`.`id` LEFT JOIN (SELECT `customer_address.salutation.translation`.salutation_id, `customer_address.salutation.translation`.display_name as `customer_address.salutation.translation.displayName`, `customer_address.salutation.translation`.letter_name as `customer_address.salutation.translation.letterName`, `customer_address.salutation.translation`.custom_fields as `customer_address.salutation.translation.customFields`, `customer_address.salutation.translation`.created_at as `customer_address.salutation.translation.createdAt`, `customer_address.salutation.translation`.updated_at as `customer_address.salutation.translation.updatedAt`, `customer_address.salutation.translation`.salutation_id as `customer_address.salutation.translation.salutationId`, `customer_address.salutation.translation`.language_id as `customer_address.salutation.translation.languageId` FROM `salutation_translation` `customer_address.salutation.translation` WHERE `customer_address.salutation.translation`.language_id = :languageId) `customer_address.salutation.salutation_translation` ON `customer_address.salutation.salutation_translation`.`salutation_id` = `customer_address.salutation`.`id` LEFT JOIN (SELECT `customer_address.country.translation`.country_id, `customer_address.country.translation`.name as `customer_address.country.translation.name`, `customer_address.country.translation`.custom_fields as `customer_address.country.translation.customFields`, `customer_address.country.translation`.created_at as `customer_address.country.translation.createdAt`, `customer_address.country.translation`.updated_at as `customer_address.country.translation.updatedAt`, `customer_address.country.translation`.country_id as `customer_address.country.translation.countryId`, `customer_address.country.translation`.language_id as `customer_address.country.translation.languageId` FROM `country_translation` `customer_address.country.translation` WHERE `customer_address.country.translation`.language_id = :languageId) `customer_address.country.country_translation` ON `customer_address.country.country_translation`.`country_id` = `customer_address.country`.`id` LEFT JOIN (SELECT `customer_address.countryState.translation`.country_state_id, `customer_address.countryState.translation`.name as `customer_address.countryState.translation.name`, `customer_address.countryState.translation`.custom_fields as `customer_address.countryState.translation.customFields`, `customer_address.countryState.translation`.created_at as `customer_address.countryState.translation.createdAt`, `customer_address.countryState.translation`.updated_at as `customer_address.countryState.translation.updatedAt`, `customer_address.countryState.translation`.country_state_id as `customer_address.countryState.translation.countryStateId`, `customer_address.countryState.translation`.language_id as `customer_address.countryState.translation.languageId` FROM `country_state_translation` `customer_address.countryState.translation` WHERE `customer_address.countryState.translation`.language_id = :languageId) `customer_address.countryState.country_state_translation` ON `customer_address.countryState.country_state_translation`.`country_state_id` = `customer_address.countryState`.`id` WHERE `customer_address`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
9 0.68 ms 
# context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name as `customer_group.translation.name`, `customer_group.translation`.registration_title as `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, `customer_group.translation`.created_at as `customer_group.translation.createdAt`, `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = :languageId) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
10 1.07 ms 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
View formatted query    View runnable query    View query stack
11 0.14 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
12 0.29 ms 
SELECT `country_translation`.`country_id`, `country_translation`.`language_id` FROM `country_translation` WHERE (`country_translation`.`name` = :param_d724bad779ce4a4eb9a8587b39ee83c0)
View formatted query    View runnable query    View query stack
13 12.15 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_da9d2f866962427186d7f00c3bfc23dc AND `promotion.salesChannels`.`sales_channel_id` = :param_54936f6f384941e59a6b9139c72f21ac AND ((`promotion`.`valid_from` <=> :param_c3764e62e7c44fa28a0151df13a69d96 AND `promotion`.`valid_until` <=> :param_e47934ce9e3d4a41af0195508c12b729) OR (`promotion`.`valid_from` <=> :param_85ff9a3b1d8c4de4945dca27deadf415 AND (`promotion`.`valid_until` > :param_e9208019c2264ff588878baa8814d82e)) OR ((`promotion`.`valid_from` <= :param_33e964f0bf6e4409b013827abd7f3edf) AND `promotion`.`valid_until` <=> :param_d3d1b875c8ee46a393651754c68eb3b8) OR ((`promotion`.`valid_from` <= :param_b1b89b08ab5c49778f7972d325ad6b30) AND (`promotion`.`valid_until` > :param_daf779f149104019a233da6c067b9b35))) AND `promotion`.`use_codes` = :param_9a64cef3959c4d679e814755e2a9487c)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
View formatted query    View runnable query    View query stack
14 16.34 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.shippingMethodType`.`id` as `shipping_method.shippingMethodType.id`, `shipping_method.shippingMethodType`.`shipping_method_id` as `shipping_method.shippingMethodType.shippingMethodId`, `shipping_method.shippingMethodType`.`type_key` as `shipping_method.shippingMethodType.typeKey`, `shipping_method.shippingMethodType`.`penalties` as `shipping_method.shippingMethodType.penalties`, `shipping_method.shippingMethodType`.`created_at` as `shipping_method.shippingMethodType.createdAt`, `shipping_method.shippingMethodType`.`updated_at` as `shipping_method.shippingMethodType.updatedAt`, `shipping_method.shippingMethodDeadline`.`id` as `shipping_method.shippingMethodDeadline.id`, `shipping_method.shippingMethodDeadline`.`shipping_method_id` as `shipping_method.shippingMethodDeadline.shippingMethodId`, `shipping_method.shippingMethodDeadline`.`deadlines` as `shipping_method.shippingMethodDeadline.deadlines`, `shipping_method.shippingMethodDeadline`.`excluded_dates` as `shipping_method.shippingMethodDeadline.excludedDates`, `shipping_method.shippingMethodDeadline`.`created_at` as `shipping_method.shippingMethodDeadline.createdAt`, `shipping_method.shippingMethodDeadline`.`updated_at` as `shipping_method.shippingMethodDeadline.updatedAt`, `shipping_method.shippingMethodConfig`.`id` as `shipping_method.shippingMethodConfig.id`, `shipping_method.shippingMethodConfig`.`shipping_method_id` as `shipping_method.shippingMethodConfig.shippingMethodId`, `shipping_method.shippingMethodConfig`.`shipping_comment_required` as `shipping_method.shippingMethodConfig.shippingCommentRequired`, `shipping_method.shippingMethodConfig`.`created_at` as `shipping_method.shippingMethodConfig.createdAt`, `shipping_method.shippingMethodConfig`.`updated_at` as `shipping_method.shippingMethodConfig.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 `wexo_shipping_method_type` `shipping_method.shippingMethodType` ON `shipping_method`.`id` = `shipping_method.shippingMethodType`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_deadline` `shipping_method.shippingMethodDeadline` ON `shipping_method`.`id` = `shipping_method.shippingMethodDeadline`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_config` `shipping_method.shippingMethodConfig` ON `shipping_method`.`id` = `shipping_method.shippingMethodConfig`.`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
15 0.38 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_445a90ca02904f1f904aecc5f10a651d))
View formatted query    View runnable query    View query stack
16 2.53 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_0db8647546f14146a757153c19e61cbc)
View formatted query    View runnable query    View query stack
17 0.15 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.16 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 0.12 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_7e9a5bec53c8448d85df0a00116671f0)) AND (`country`.`id` IN (:ids)) GROUP BY `country`.`id`
View formatted query    View runnable query    View query stack
20 0.90 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_cb9bcda1dbcc467081513f00db7b1b79)
View formatted query    View runnable query    View query stack
21 0.07 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
22 0.05 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
23 0.46 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_db9962bef15941c8bb6ff476925b785b) ORDER BY `coe_wishlist`.`created_at` DESC
View formatted query    View runnable query    View query stack
24 1.59 ms 
SELECT `coe_wishlist`.`id` as `coe_wishlist.id`, `coe_wishlist`.`name` as `coe_wishlist.name`, `coe_wishlist`.`default` as `coe_wishlist.default`, `coe_wishlist`.`customer_id` as `coe_wishlist.customerId`, `coe_wishlist`.`session_id` as `coe_wishlist.sessionId`, `coe_wishlist`.`public` as `coe_wishlist.public`, `coe_wishlist`.`custom_fields` as `coe_wishlist.customFields`, `coe_wishlist.customer`.`id` as `coe_wishlist.customer.id`, `coe_wishlist.customer`.`customer_group_id` as `coe_wishlist.customer.groupId`, `coe_wishlist.customer`.`default_payment_method_id` as `coe_wishlist.customer.defaultPaymentMethodId`, `coe_wishlist.customer`.`sales_channel_id` as `coe_wishlist.customer.salesChannelId`, `coe_wishlist.customer`.`language_id` as `coe_wishlist.customer.languageId`, `coe_wishlist.customer`.`last_payment_method_id` as `coe_wishlist.customer.lastPaymentMethodId`, `coe_wishlist.customer`.`default_billing_address_id` as `coe_wishlist.customer.defaultBillingAddressId`, `coe_wishlist.customer`.`default_shipping_address_id` as `coe_wishlist.customer.defaultShippingAddressId`, `coe_wishlist.customer`.`auto_increment` as `coe_wishlist.customer.autoIncrement`, `coe_wishlist.customer`.`customer_number` as `coe_wishlist.customer.customerNumber`, `coe_wishlist.customer`.`salutation_id` as `coe_wishlist.customer.salutationId`, `coe_wishlist.customer`.`first_name` as `coe_wishlist.customer.firstName`, `coe_wishlist.customer`.`last_name` as `coe_wishlist.customer.lastName`, `coe_wishlist.customer`.`company` as `coe_wishlist.customer.company`, `coe_wishlist.customer`.`password` as `coe_wishlist.customer.password`, `coe_wishlist.customer`.`email` as `coe_wishlist.customer.email`, `coe_wishlist.customer`.`title` as `coe_wishlist.customer.title`, `coe_wishlist.customer`.`vat_ids` as `coe_wishlist.customer.vatIds`, `coe_wishlist.customer`.`affiliate_code` as `coe_wishlist.customer.affiliateCode`, `coe_wishlist.customer`.`campaign_code` as `coe_wishlist.customer.campaignCode`, `coe_wishlist.customer`.`active` as `coe_wishlist.customer.active`, `coe_wishlist.customer`.`double_opt_in_registration` as `coe_wishlist.customer.doubleOptInRegistration`, `coe_wishlist.customer`.`double_opt_in_email_sent_date` as `coe_wishlist.customer.doubleOptInEmailSentDate`, `coe_wishlist.customer`.`double_opt_in_confirm_date` as `coe_wishlist.customer.doubleOptInConfirmDate`, `coe_wishlist.customer`.`hash` as `coe_wishlist.customer.hash`, `coe_wishlist.customer`.`guest` as `coe_wishlist.customer.guest`, `coe_wishlist.customer`.`first_login` as `coe_wishlist.customer.firstLogin`, `coe_wishlist.customer`.`last_login` as `coe_wishlist.customer.lastLogin`, `coe_wishlist.customer`.`newsletter_sales_channel_ids` as `coe_wishlist.customer.newsletterSalesChannelIds`, `coe_wishlist.customer`.`newsletter` as `coe_wishlist.customer.newsletter`, `coe_wishlist.customer`.`birthday` as `coe_wishlist.customer.birthday`, `coe_wishlist.customer`.`last_order_date` as `coe_wishlist.customer.lastOrderDate`, `coe_wishlist.customer`.`order_count` as `coe_wishlist.customer.orderCount`, `coe_wishlist.customer`.`order_total_amount` as `coe_wishlist.customer.orderTotalAmount`, `coe_wishlist.customer`.`custom_fields` as `coe_wishlist.customer.customFields`, `coe_wishlist.customer`.`legacy_password` as `coe_wishlist.customer.legacyPassword`, `coe_wishlist.customer`.`legacy_encoder` as `coe_wishlist.customer.legacyEncoder`, `coe_wishlist.customer`.`remote_address` as `coe_wishlist.customer.remoteAddress`, `coe_wishlist.customer`.`tag_ids` as `coe_wishlist.customer.tagIds`, `coe_wishlist.customer`.`requested_customer_group_id` as `coe_wishlist.customer.requestedGroupId`, `coe_wishlist.customer`.`bound_sales_channel_id` as `coe_wishlist.customer.boundSalesChannelId`, `coe_wishlist.customer`.`created_at` as `coe_wishlist.customer.createdAt`, `coe_wishlist.customer`.`updated_at` as `coe_wishlist.customer.updatedAt`, `coe_wishlist.customer.customerUser`.`id` as `coe_wishlist.customer.customerUser.id`, `coe_wishlist.customer.customerUser`.`customer_id` as `coe_wishlist.customer.customerUser.customerId`, `coe_wishlist.customer.customerUser`.`group_id` as `coe_wishlist.customer.customerUser.groupId`, `coe_wishlist.customer.customerUser`.`parent_customer_id` as `coe_wishlist.customer.customerUser.parentCustomerId`, `coe_wishlist.customer.customerUser`.`role` as `coe_wishlist.customer.customerUser.role`, `coe_wishlist.customer.customerUser`.`created_at` as `coe_wishlist.customer.customerUser.createdAt`, `coe_wishlist.customer.customerUser`.`updated_at` as `coe_wishlist.customer.customerUser.updatedAt`, `coe_wishlist`.`created_at` as `coe_wishlist.createdAt`, `coe_wishlist`.`updated_at` as `coe_wishlist.updatedAt` FROM `coe_wishlist` LEFT JOIN `customer` `coe_wishlist.customer` ON `coe_wishlist`.`customer_id` = `coe_wishlist.customer`.`id` LEFT JOIN `templaid_customer_user` `coe_wishlist.customer.customerUser` ON `coe_wishlist.customer`.`id` = `coe_wishlist.customer.customerUser`.`customer_id` WHERE `coe_wishlist`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
25 14.33 ms 
SELECT `coe_wishlist_note`.`id` as `coe_wishlist_note.id`, `coe_wishlist_note`.`wishlist_id` as `coe_wishlist_note.wishlistId`, `coe_wishlist_note`.`product_id` as `coe_wishlist_note.productId`, `coe_wishlist_note`.`quantity` as `coe_wishlist_note.quantity`, `coe_wishlist_note`.`custom_fields` as `coe_wishlist_note.customFields`, `coe_wishlist_note`.`created_at` as `coe_wishlist_note.createdAt`, `coe_wishlist_note`.`updated_at` as `coe_wishlist_note.updatedAt`, `coe_wishlist_note.product`.`id` as `coe_wishlist_note.product.id`, `coe_wishlist_note.product`.`version_id` as `coe_wishlist_note.product.versionId`, `coe_wishlist_note.product`.`parent_id` as `coe_wishlist_note.product.parentId`, `coe_wishlist_note.product`.`parent_version_id` as `coe_wishlist_note.product.parentVersionId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_id`) as `coe_wishlist_note.product.manufacturerId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_version_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_version_id`) as `coe_wishlist_note.product.productManufacturerVersionId`, COALESCE(`coe_wishlist_note.product`.`unit_id`, `coe_wishlist_note.product.parent`.`unit_id`) as `coe_wishlist_note.product.unitId`, COALESCE(`coe_wishlist_note.product`.`tax_id`, `coe_wishlist_note.product.parent`.`tax_id`) as `coe_wishlist_note.product.taxId`, COALESCE(`coe_wishlist_note.product`.`product_media_id`, `coe_wishlist_note.product.parent`.`product_media_id`) as `coe_wishlist_note.product.coverId`, COALESCE(`coe_wishlist_note.product`.`product_media_version_id`, `coe_wishlist_note.product.parent`.`product_media_version_id`) as `coe_wishlist_note.product.productMediaVersionId`, COALESCE(`coe_wishlist_note.product`.`delivery_time_id`, `coe_wishlist_note.product.parent`.`delivery_time_id`) as `coe_wishlist_note.product.deliveryTimeId`, COALESCE(`coe_wishlist_note.product`.`product_feature_set_id`, `coe_wishlist_note.product.parent`.`product_feature_set_id`) as `coe_wishlist_note.product.featureSetId`, COALESCE(`coe_wishlist_note.product`.`canonical_product_id`, `coe_wishlist_note.product.parent`.`canonical_product_id`) as `coe_wishlist_note.product.canonicalProductId`, COALESCE(`coe_wishlist_note.product`.`cms_page_id`, `coe_wishlist_note.product.parent`.`cms_page_id`) as `coe_wishlist_note.product.cmsPageId`, COALESCE(`coe_wishlist_note.product`.`cms_page_version_id`, `coe_wishlist_note.product.parent`.`cms_page_version_id`) as `coe_wishlist_note.product.cmsPageVersionId`, `coe_wishlist_note.product.parent`.`price` as `coe_wishlist_note.product.price.inherited`, COALESCE(`coe_wishlist_note.product`.`price`, `coe_wishlist_note.product.parent`.`price`) as `coe_wishlist_note.product.price`, `coe_wishlist_note.product`.`product_number` as `coe_wishlist_note.product.productNumber`, `coe_wishlist_note.product`.`stock` as `coe_wishlist_note.product.stock`, COALESCE(`coe_wishlist_note.product`.`restock_time`, `coe_wishlist_note.product.parent`.`restock_time`) as `coe_wishlist_note.product.restockTime`, `coe_wishlist_note.product`.`auto_increment` as `coe_wishlist_note.product.autoIncrement`, COALESCE(`coe_wishlist_note.product`.`active`, `coe_wishlist_note.product.parent`.`active`) as `coe_wishlist_note.product.active`, `coe_wishlist_note.product`.`available_stock` as `coe_wishlist_note.product.availableStock`, `coe_wishlist_note.product`.`available` as `coe_wishlist_note.product.available`, COALESCE(`coe_wishlist_note.product`.`is_closeout`, `coe_wishlist_note.product.parent`.`is_closeout`) as `coe_wishlist_note.product.isCloseout`, `coe_wishlist_note.product`.`display_group` as `coe_wishlist_note.product.displayGroup`, `coe_wishlist_note.product.parent`.`configurator_group_config` as `coe_wishlist_note.product.configuratorGroupConfig.inherited`, COALESCE(`coe_wishlist_note.product`.`configurator_group_config`, `coe_wishlist_note.product.parent`.`configurator_group_config`) as `coe_wishlist_note.product.configuratorGroupConfig`, COALESCE(`coe_wishlist_note.product`.`main_variant_id`, `coe_wishlist_note.product.parent`.`main_variant_id`) as `coe_wishlist_note.product.mainVariantId`, `coe_wishlist_note.product`.`variant_restrictions` as `coe_wishlist_note.product.variantRestrictions`, COALESCE(`coe_wishlist_note.product`.`manufacturer_number`, `coe_wishlist_note.product.parent`.`manufacturer_number`) as `coe_wishlist_note.product.manufacturerNumber`, COALESCE(`coe_wishlist_note.product`.`ean`, `coe_wishlist_note.product.parent`.`ean`) as `coe_wishlist_note.product.ean`, COALESCE(`coe_wishlist_note.product`.`purchase_steps`, `coe_wishlist_note.product.parent`.`purchase_steps`) as `coe_wishlist_note.product.purchaseSteps`, COALESCE(`coe_wishlist_note.product`.`max_purchase`, `coe_wishlist_note.product.parent`.`max_purchase`) as `coe_wishlist_note.product.maxPurchase`, COALESCE(`coe_wishlist_note.product`.`min_purchase`, `coe_wishlist_note.product.parent`.`min_purchase`) as `coe_wishlist_note.product.minPurchase`, COALESCE(`coe_wishlist_note.product`.`purchase_unit`, `coe_wishlist_note.product.parent`.`purchase_unit`) as `coe_wishlist_note.product.purchaseUnit`, COALESCE(`coe_wishlist_note.product`.`reference_unit`, `coe_wishlist_note.product.parent`.`reference_unit`) as `coe_wishlist_note.product.referenceUnit`, COALESCE(`coe_wishlist_note.product`.`shipping_free`, `coe_wishlist_note.product.parent`.`shipping_free`) as `coe_wishlist_note.product.shippingFree`, `coe_wishlist_note.product.parent`.`purchase_prices` as `coe_wishlist_note.product.purchasePrices.inherited`, COALESCE(`coe_wishlist_note.product`.`purchase_prices`, `coe_wishlist_note.product.parent`.`purchase_prices`) as `coe_wishlist_note.product.purchasePrices`, COALESCE(`coe_wishlist_note.product`.`mark_as_topseller`, `coe_wishlist_note.product.parent`.`mark_as_topseller`) as `coe_wishlist_note.product.markAsTopseller`, COALESCE(`coe_wishlist_note.product`.`weight`, `coe_wishlist_note.product.parent`.`weight`) as `coe_wishlist_note.product.weight`, COALESCE(`coe_wishlist_note.product`.`width`, `coe_wishlist_note.product.parent`.`width`) as `coe_wishlist_note.product.width`, COALESCE(`coe_wishlist_note.product`.`height`, `coe_wishlist_note.product.parent`.`height`) as `coe_wishlist_note.product.height`, COALESCE(`coe_wishlist_note.product`.`length`, `coe_wishlist_note.product.parent`.`length`) as `coe_wishlist_note.product.length`, COALESCE(`coe_wishlist_note.product`.`release_date`, `coe_wishlist_note.product.parent`.`release_date`) as `coe_wishlist_note.product.releaseDate`, COALESCE(`coe_wishlist_note.product`.`rating_average`, `coe_wishlist_note.product.parent`.`rating_average`) as `coe_wishlist_note.product.ratingAverage`, `coe_wishlist_note.product.parent`.`category_tree` as `coe_wishlist_note.product.categoryTree.inherited`, COALESCE(`coe_wishlist_note.product`.`category_tree`, `coe_wishlist_note.product.parent`.`category_tree`) as `coe_wishlist_note.product.categoryTree`, `coe_wishlist_note.product.parent`.`property_ids` as `coe_wishlist_note.product.propertyIds.inherited`, COALESCE(`coe_wishlist_note.product`.`property_ids`, `coe_wishlist_note.product.parent`.`property_ids`) as `coe_wishlist_note.product.propertyIds`, `coe_wishlist_note.product.parent`.`option_ids` as `coe_wishlist_note.product.optionIds.inherited`, COALESCE(`coe_wishlist_note.product`.`option_ids`, `coe_wishlist_note.product.parent`.`option_ids`) as `coe_wishlist_note.product.optionIds`, `coe_wishlist_note.product.parent`.`stream_ids` as `coe_wishlist_note.product.streamIds.inherited`, COALESCE(`coe_wishlist_note.product`.`stream_ids`, `coe_wishlist_note.product.parent`.`stream_ids`) as `coe_wishlist_note.product.streamIds`, `coe_wishlist_note.product.parent`.`tag_ids` as `coe_wishlist_note.product.tagIds.inherited`, COALESCE(`coe_wishlist_note.product`.`tag_ids`, `coe_wishlist_note.product.parent`.`tag_ids`) as `coe_wishlist_note.product.tagIds`, `coe_wishlist_note.product.parent`.`category_ids` as `coe_wishlist_note.product.categoryIds.inherited`, COALESCE(`coe_wishlist_note.product`.`category_ids`, `coe_wishlist_note.product.parent`.`category_ids`) as `coe_wishlist_note.product.categoryIds`, `coe_wishlist_note.product`.`child_count` as `coe_wishlist_note.product.childCount`, COALESCE(`coe_wishlist_note.product`.`custom_field_set_selection_active`, `coe_wishlist_note.product.parent`.`custom_field_set_selection_active`) as `coe_wishlist_note.product.customFieldSetSelectionActive`, `coe_wishlist_note.product`.`sales` as `coe_wishlist_note.product.sales`, `coe_wishlist_note.product.tax`.`id` as `coe_wishlist_note.product.tax.id`, `coe_wishlist_note.product.tax`.`tax_rate` as `coe_wishlist_note.product.tax.taxRate`, `coe_wishlist_note.product.tax`.`name` as `coe_wishlist_note.product.tax.name`, `coe_wishlist_note.product.tax`.`position` as `coe_wishlist_note.product.tax.position`, `coe_wishlist_note.product.tax`.`custom_fields` as `coe_wishlist_note.product.tax.customFields`, `coe_wishlist_note.product.tax`.`created_at` as `coe_wishlist_note.product.tax.createdAt`, `coe_wishlist_note.product.tax`.`updated_at` as `coe_wishlist_note.product.tax.updatedAt`, `coe_wishlist_note.product.parent`.`cheapest_price` as `coe_wishlist_note.product.cheapestPrice.inherited`, COALESCE(`coe_wishlist_note.product`.`cheapest_price`, `coe_wishlist_note.product.parent`.`cheapest_price`) as `coe_wishlist_note.product.cheapestPrice`, `coe_wishlist_note.product`.`created_at` as `coe_wishlist_note.product.createdAt`, `coe_wishlist_note.product`.`updated_at` as `coe_wishlist_note.product.updatedAt`, `coe_wishlist_note.product.additionalProductInfo`.`id` as `coe_wishlist_note.product.additionalProductInfo.id`, `coe_wishlist_note.product.additionalProductInfo`.`product_id` as `coe_wishlist_note.product.additionalProductInfo.productId`, `coe_wishlist_note.product.additionalProductInfo`.`created_at` as `coe_wishlist_note.product.additionalProductInfo.createdAt`, `coe_wishlist_note.product.additionalProductInfo`.`updated_at` as `coe_wishlist_note.product.additionalProductInfo.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`) as `coe_wishlist_note.product.additionalProductInfo.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,`coe_wishlist_note.product.additionalProductInfo.translation.customField1`) as `coe_wishlist_note.product.additionalProductInfo.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,`coe_wishlist_note.product.additionalProductInfo.translation.customField2`) as `coe_wishlist_note.product.additionalProductInfo.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,`coe_wishlist_note.product.additionalProductInfo.translation.customField3`) as `coe_wishlist_note.product.additionalProductInfo.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,`coe_wishlist_note.product.additionalProductInfo.translation.customField4`) as `coe_wishlist_note.product.additionalProductInfo.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation.languageId`, `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.parent.translation.metaDescription`, COALESCE(`coe_wishlist_note.product.translation.metaDescription`,`coe_wishlist_note.product.parent.translation.metaDescription`,`coe_wishlist_note.product.translation.metaDescription`) as `coe_wishlist_note.product.metaDescription`, `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.parent.translation.name`, COALESCE(`coe_wishlist_note.product.translation.name`,`coe_wishlist_note.product.parent.translation.name`,`coe_wishlist_note.product.translation.name`) as `coe_wishlist_note.product.name`, `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.parent.translation.keywords`, COALESCE(`coe_wishlist_note.product.translation.keywords`,`coe_wishlist_note.product.parent.translation.keywords`,`coe_wishlist_note.product.translation.keywords`) as `coe_wishlist_note.product.keywords`, `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.parent.translation.description`, COALESCE(`coe_wishlist_note.product.translation.description`,`coe_wishlist_note.product.parent.translation.description`,`coe_wishlist_note.product.translation.description`) as `coe_wishlist_note.product.description`, `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.parent.translation.metaTitle`, COALESCE(`coe_wishlist_note.product.translation.metaTitle`,`coe_wishlist_note.product.parent.translation.metaTitle`,`coe_wishlist_note.product.translation.metaTitle`) as `coe_wishlist_note.product.metaTitle`, `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.parent.translation.packUnit`, COALESCE(`coe_wishlist_note.product.translation.packUnit`,`coe_wishlist_note.product.parent.translation.packUnit`,`coe_wishlist_note.product.translation.packUnit`) as `coe_wishlist_note.product.packUnit`, `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation.packUnitPlural`, COALESCE(`coe_wishlist_note.product.translation.packUnitPlural`,`coe_wishlist_note.product.parent.translation.packUnitPlural`,`coe_wishlist_note.product.translation.packUnitPlural`) as `coe_wishlist_note.product.packUnitPlural`, `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation.customSearchKeywords`, COALESCE(`coe_wishlist_note.product.translation.customSearchKeywords`,`coe_wishlist_note.product.parent.translation.customSearchKeywords`,`coe_wishlist_note.product.translation.customSearchKeywords`) as `coe_wishlist_note.product.customSearchKeywords`, `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.parent.translation.slotConfig`, COALESCE(`coe_wishlist_note.product.translation.slotConfig`,`coe_wishlist_note.product.parent.translation.slotConfig`,`coe_wishlist_note.product.translation.slotConfig`) as `coe_wishlist_note.product.slotConfig`, `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.parent.translation.customFields`, COALESCE(`coe_wishlist_note.product.translation.customFields`,`coe_wishlist_note.product.parent.translation.customFields`,`coe_wishlist_note.product.translation.customFields`) as `coe_wishlist_note.product.customFields`, `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.translation.productVersionId`, `coe_wishlist_note.product.parent.translation.productVersionId` FROM `coe_wishlist_note` LEFT JOIN `product` `coe_wishlist_note.product` ON `coe_wishlist_note`.`product_id` = `coe_wishlist_note.product`.`id` LEFT JOIN `product` `coe_wishlist_note.product.parent` ON `coe_wishlist_note.product`.`parent_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product`.`version_id` = `coe_wishlist_note.product.parent`.`version_id` LEFT JOIN (SELECT `coe_wishlist_note.product.translation`.product_id, `coe_wishlist_note.product.translation`.product_version_id, `coe_wishlist_note.product.translation`.meta_description as `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.translation`.name as `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.translation`.keywords as `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.translation`.description as `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.translation`.meta_title as `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.translation`.pack_unit as `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.translation`.pack_unit_plural as `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.translation`.custom_search_keywords as `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.translation`.slot_config as `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.translation`.custom_fields as `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.translation`.created_at as `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.translation`.updated_at as `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.translation`.product_id as `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.translation`.language_id as `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.translation`.product_version_id as `coe_wishlist_note.product.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.translation` WHERE `coe_wishlist_note.product.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation` ON `coe_wishlist_note.product.product_translation`.`product_id` = `coe_wishlist_note.product`.`id` AND `coe_wishlist_note.product.product_translation`.product_version_id = `coe_wishlist_note.product`.version_id LEFT JOIN (SELECT `coe_wishlist_note.product.parent.translation`.product_id, `coe_wishlist_note.product.parent.translation`.product_version_id, `coe_wishlist_note.product.parent.translation`.meta_description as `coe_wishlist_note.product.parent.translation.metaDescription`, `coe_wishlist_note.product.parent.translation`.name as `coe_wishlist_note.product.parent.translation.name`, `coe_wishlist_note.product.parent.translation`.keywords as `coe_wishlist_note.product.parent.translation.keywords`, `coe_wishlist_note.product.parent.translation`.description as `coe_wishlist_note.product.parent.translation.description`, `coe_wishlist_note.product.parent.translation`.meta_title as `coe_wishlist_note.product.parent.translation.metaTitle`, `coe_wishlist_note.product.parent.translation`.pack_unit as `coe_wishlist_note.product.parent.translation.packUnit`, `coe_wishlist_note.product.parent.translation`.pack_unit_plural as `coe_wishlist_note.product.parent.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation`.custom_search_keywords as `coe_wishlist_note.product.parent.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation`.slot_config as `coe_wishlist_note.product.parent.translation.slotConfig`, `coe_wishlist_note.product.parent.translation`.custom_fields as `coe_wishlist_note.product.parent.translation.customFields`, `coe_wishlist_note.product.parent.translation`.created_at as `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.parent.translation`.updated_at as `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.parent.translation`.product_id as `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.parent.translation`.language_id as `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.parent.translation`.product_version_id as `coe_wishlist_note.product.parent.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.parent.translation` WHERE `coe_wishlist_note.product.parent.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation.parent` ON `coe_wishlist_note.product.product_translation.parent`.`product_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product.product_translation.parent`.product_version_id = `coe_wishlist_note.product.parent`.version_id LEFT JOIN `tax` `coe_wishlist_note.product.tax` ON `coe_wishlist_note.product`.`tax` = `coe_wishlist_note.product.tax`.`id` LEFT JOIN `additional_product_info` `coe_wishlist_note.product.additionalProductInfo` ON `coe_wishlist_note.product`.`id` = `coe_wishlist_note.product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id, `coe_wishlist_note.product.additionalProductInfo.translation`.alternative_name as `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_1 as `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_2 as `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_3 as `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_4 as `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation`.created_at as `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.updated_at as `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id as `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation`.language_id as `coe_wishlist_note.product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `coe_wishlist_note.product.additionalProductInfo.translation` WHERE `coe_wishlist_note.product.additionalProductInfo.translation`.language_id = :languageId) `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation` ON `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `coe_wishlist_note.product.additionalProductInfo`.`id` WHERE (`coe_wishlist_note`.`wishlist_id` IN (:param_062dc98a46c347f79b09a94d6e7b2d74))
View formatted query    View runnable query    View query stack
26 0.30 ms 
# default-salutation-loading::read
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = :languageId) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id` WHERE `salutation`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
27 0.44 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_49e217c1dcd54ce5a7f678a9939fa9c8)
View formatted query    View runnable query    View query stack
28 0.09 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_0eaa1177bbde47d28fa2ec13895362c7)
View formatted query    View runnable query    View query stack
29 0.30 ms 
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, COALESCE(`property_group.translation.name`,`property_group.translation.name`) as `property_group.name`, `property_group.translation.description`, COALESCE(`property_group.translation.description`,`property_group.translation.description`) as `property_group.description`, `property_group.translation.position`, COALESCE(`property_group.translation.position`,`property_group.translation.position`) as `property_group.position`, `property_group.translation.customFields`, COALESCE(`property_group.translation.customFields`,`property_group.translation.customFields`) as `property_group.customFields`, `property_group.translation.createdAt`, `property_group.translation.updatedAt`, `property_group.translation.propertyGroupId`, `property_group.translation.languageId` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.property_group_id, `property_group.translation`.name as `property_group.translation.name`, `property_group.translation`.description as `property_group.translation.description`, `property_group.translation`.position as `property_group.translation.position`, `property_group.translation`.custom_fields as `property_group.translation.customFields`, `property_group.translation`.created_at as `property_group.translation.createdAt`, `property_group.translation`.updated_at as `property_group.translation.updatedAt`, `property_group.translation`.property_group_id as `property_group.translation.propertyGroupId`, `property_group.translation`.language_id as `property_group.translation.languageId` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.language_id = :languageId) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE `property_group`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
30 0.10 ms 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = :param_1cbaf5cb775a412daa732ba4f3a1998d) ORDER BY `product_sorting`.`priority` DESC
View formatted query    View runnable query    View query stack
31 0.23 ms 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = :languageId) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
32 0.44 ms 
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_a97217eb12574ec9a8898920cf837d11) AND `product.visibilities`.`sales_channel_id` = :param_efa8f87398a1461fb56b0c9df29f8cf7 AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_1b98e3187a684246a0e236954eaaf199) AND NOT (`product`.`display_group` <=> :param_357b66c3e5db46779c61becf32e3f6d9) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_576024002e0546fc87163421e68f54d7) AND `product.swagDynamicAccessRules`.`id` <=> :param_ad108fe4625144e4ba35c7f212b5a9bf) OR (`product.swagDynamicAccessRules`.`id` IN (:param_d329ab0e717840388477358f3a8300c2)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_359bba0511464ea484acbf112d49a58f AND `product.swagDynamicAccessRules`.`id` <=> :param_619b5b02f8684e00aac0a77944759422)))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
View formatted query    View runnable query    View query stack
33 0.42 ms 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = :languageId) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = :version) AND (`product_manufacturer`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
34 2.61 ms 
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule3158f4fb6ee44aea90aaa534c5244749.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7ddaa01072254b6fa618781ddc3dbc67.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule94da6b0ca8a74dc7bc6879d949692ed9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled82401f47c524ded983ee9b4b4fde5b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulefe72a3a0b6234ed6828420d6bbf7fae8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule24089e17d5104c31a2dc6380a9a5fff6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule47461a746c6d47b78d41650fac2b6d22.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7a5a09d82f1c4f509e16f2516270ea86.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7d3ac8514bae439890bd29645157e375.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea0f1e258f7c545e49f9ff6e139149a43.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecf8c7e6e6511412f82355b0bc6d771d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule3158f4fb6ee44aea90aaa534c5244749.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7ddaa01072254b6fa618781ddc3dbc67.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule94da6b0ca8a74dc7bc6879d949692ed9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled82401f47c524ded983ee9b4b4fde5b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulefe72a3a0b6234ed6828420d6bbf7fae8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule24089e17d5104c31a2dc6380a9a5fff6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule47461a746c6d47b78d41650fac2b6d22.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7a5a09d82f1c4f509e16f2516270ea86.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7d3ac8514bae439890bd29645157e375.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea0f1e258f7c545e49f9ff6e139149a43.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecf8c7e6e6511412f82355b0bc6d771d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule3158f4fb6ee44aea90aaa534c5244749.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7ddaa01072254b6fa618781ddc3dbc67.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule94da6b0ca8a74dc7bc6879d949692ed9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled82401f47c524ded983ee9b4b4fde5b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulefe72a3a0b6234ed6828420d6bbf7fae8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule24089e17d5104c31a2dc6380a9a5fff6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule47461a746c6d47b78d41650fac2b6d22.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7a5a09d82f1c4f509e16f2516270ea86.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7d3ac8514bae439890bd29645157e375.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea0f1e258f7c545e49f9ff6e139149a43.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulecf8c7e6e6511412f82355b0bc6d771d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule3158f4fb6ee44aea90aaa534c5244749.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7ddaa01072254b6fa618781ddc3dbc67.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule94da6b0ca8a74dc7bc6879d949692ed9.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled82401f47c524ded983ee9b4b4fde5b3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulefe72a3a0b6234ed6828420d6bbf7fae8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule24089e17d5104c31a2dc6380a9a5fff6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule47461a746c6d47b78d41650fac2b6d22.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7a5a09d82f1c4f509e16f2516270ea86.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7d3ac8514bae439890bd29645157e375.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea0f1e258f7c545e49f9ff6e139149a43.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulecf8c7e6e6511412f82355b0bc6d771d3.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.net")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_9cdce5b8cee5467a9c1b1e48ef5538eb) AND `product.visibilities`.`sales_channel_id` = :param_b91d783d19ba4f129d736e131fb55829 AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_108edb68542b4a309d3e40fc7d5a7b47) AND NOT (`product`.`display_group` <=> :param_728d95818c094c38ace803a5e3ec324a) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_4c5640ccea574241b615c7cd28ac7bee) AND `product.swagDynamicAccessRules`.`id` <=> :param_487ec89d60e24496ac6bbc08035db02b) OR (`product.swagDynamicAccessRules`.`id` IN (:param_137638b3e8ab46228fe045b4d88b117a)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_bb07636535ac4df78a0562b6cabed105 AND `product.swagDynamicAccessRules`.`id` <=> :param_c88e72f4860c44f08f76599cbaa4ce3a))))
View formatted query    View runnable query    View query stack
35 0.41 ms 
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_b58ba59dc0b94dd9bbde50ac23f05699) AND `product.visibilities`.`sales_channel_id` = :param_b02dab55a416422d8f31b6d34c533f6c AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_2bb53c63e287490b96acff0e0e20bbf2) AND NOT (`product`.`display_group` <=> :param_4cc68bb56be44408982306dcba5042fa) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_7cf3813f64254c53b426c2de007510b0) AND `product.swagDynamicAccessRules`.`id` <=> :param_947f1ee70dec4e1e9ff1be40cf781a73) OR (`product.swagDynamicAccessRules`.`id` IN (:param_5484f4442ab14aa2a7094c379dc2ccbf)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_82fafdca051d4eb084f0e61eb88e6ce5 AND `product.swagDynamicAccessRules`.`id` <=> :param_710fd887dc4c4433aeb1fb98ab06491c)))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= :param_70b7147c9d494abfa89073d988487dd8)))
View formatted query    View runnable query    View query stack
36 0.42 ms 
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_9e5f0b16df934343bf5eb32f05ff5491) AND `product.visibilities`.`sales_channel_id` = :param_266623e31a8245bab83992ce7b85d66b AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_84399830ba944323a9657ccaaeb21cb2) AND NOT (`product`.`display_group` <=> :param_06014d781c5b452a9d9f9c0ee75c457a) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_128575ccfbb945288c1bf7a7db1d4257) AND `product.swagDynamicAccessRules`.`id` <=> :param_bbf4309dcada4c5a8bcdf5c333fcec13) OR (`product.swagDynamicAccessRules`.`id` IN (:param_f5f596a740a44b52830b7ac39189de00)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_c2881b8f65774a659ece4b36006be72c AND `product.swagDynamicAccessRules`.`id` <=> :param_afc53e0f73464983b0fbe9cfe5ac7d3f)))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = :param_abe82f55cca144e4bf5b8e5d35308247))
View formatted query    View runnable query    View query stack
37 0.69 ms 
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_a2702d0da401429a8918e2124cd73859) AND `product.visibilities`.`sales_channel_id` = :param_5be9a8e6712a481daea4f350ac115cdd AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_b57cb36723ee4960bec5ef3eee197344) AND NOT (`product`.`display_group` <=> :param_f9b14336614248a2bc01fa3ca5b7e336) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_464d046b5248474b96765b475e1dc911) AND `product.swagDynamicAccessRules`.`id` <=> :param_d2294b48cccc48cbad4cb5f35c974dcd) OR (`product.swagDynamicAccessRules`.`id` IN (:param_0d39630201b74e0885f8bc1a0dc8b40b)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_b2afa9f8b7434e54bcc835804fcae496 AND `product.swagDynamicAccessRules`.`id` <=> :param_808345f17a4a4fc4aedfb237190816c9)))) GROUP BY `product.properties`.`id`
View formatted query    View runnable query    View query stack
38 0.51 ms 
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.swagDynamicAccessRules.mapping` ON `product`.`id` = `product.swagDynamicAccessRules.mapping`.`product_id`  AND `product`.`version_id` = `product.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `product` `product.parent.parent` ON `product.parent`.`parent_id` = `product.parent.parent`.`id` AND `product.parent`.`version_id` = `product.parent.parent`.`version_id` LEFT JOIN `swag_dynamic_access_product_rule` `product.parent.swagDynamicAccessRules.mapping` ON `product.parent`.`id` = `product.parent.swagDynamicAccessRules.mapping`.`product_id`  AND `product.parent`.`version_id` = `product.parent.swagDynamicAccessRules.mapping`.`product_version_id` LEFT JOIN `rule` `product.parent.swagDynamicAccessRules` ON `product.parent.swagDynamicAccessRules.mapping`.`rule_id` = `product.parent.swagDynamicAccessRules`.`id`  LEFT JOIN `rule` `product.swagDynamicAccessRules` ON `product.swagDynamicAccessRules.mapping`.`rule_id` = `product.swagDynamicAccessRules`.`id`  LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = :version) AND ((((`product.visibilities`.`visibility` >= :param_08a88da6add7450397c5c245d40b5427) AND `product.visibilities`.`sales_channel_id` = :param_6e7ccb158caa4c50962a1eee5f331ce2 AND IFNULL(`product`.`active`, `product.parent`.`active`) = :param_4129dc7d14df4536b9ed0517b1b10d77) AND NOT (`product`.`display_group` <=> :param_0ce2021abd5a4e3fb1571c7f6b5622c3) AND ((`product.parent.swagDynamicAccessRules`.`id` IN (:param_9fafe5b58044450b9589a418a4279036) AND `product.swagDynamicAccessRules`.`id` <=> :param_02d535309f984138836c70bd1660e474) OR (`product.swagDynamicAccessRules`.`id` IN (:param_e89cd656fe12426b8e3e51d2c3c06d1a)) OR (`product.parent.swagDynamicAccessRules`.`id` <=> :param_b098268aed514f64809d872538e08a67 AND `product.swagDynamicAccessRules`.`id` <=> :param_373a145b42ba4dab93d3f5cd3dc09534)))) GROUP BY `product.options`.`id`
View formatted query    View runnable query    View query stack
39 1.86 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = :param_0a229e286a5949fa9089f89bf33fa741)) AND (`property_group_option`.`id` IN (:ids)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
View formatted query    View runnable query    View query stack
40 2.54 ms 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = :languageId) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = :languageId) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = :languageId) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
41 1.96 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = :param_5591131ae2b24d62a251c034235e252c)) AND (`property_group_option`.`id` IN (:ids)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
View formatted query    View runnable query    View query stack
42 2.57 ms 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = :languageId) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = :languageId) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = :languageId) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
43 1.87 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = :param_ecc8821c83d4426783ada8682cde8f1e)) AND (`property_group_option`.`id` IN (:ids)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 1000
View formatted query    View runnable query    View query stack
44 2.39 ms 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = :languageId) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = :languageId) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = :languageId) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
45 1.98 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = :param_c6f54200867d4cc0be545f3ccda10351)) AND (`property_group_option`.`id` IN (:ids)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 1500
View formatted query    View runnable query    View query stack
46 255.82 ms 
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`configurator_group_config` as `product.configuratorGroupConfig.inherited`, COALESCE(`product`.`configurator_group_config`, `product.parent`.`configurator_group_config`) as `product.configuratorGroupConfig`, COALESCE(`product`.`main_variant_id`, `product.parent`.`main_variant_id`) as `product.mainVariantId`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.additionalProductInfo`.`id` as `product.additionalProductInfo.id`, `product.additionalProductInfo`.`product_id` as `product.additionalProductInfo.productId`, `product.additionalProductInfo`.`created_at` as `product.additionalProductInfo.createdAt`, `product.additionalProductInfo`.`updated_at` as `product.additionalProductInfo.updatedAt`, `product.additionalProductInfo.translation.alternativeName`, COALESCE(`product.additionalProductInfo.translation.alternativeName`,`product.additionalProductInfo.translation.alternativeName`) as `product.additionalProductInfo.alternativeName`, `product.additionalProductInfo.translation.customField1`, COALESCE(`product.additionalProductInfo.translation.customField1`,`product.additionalProductInfo.translation.customField1`) as `product.additionalProductInfo.customField1`, `product.additionalProductInfo.translation.customField2`, COALESCE(`product.additionalProductInfo.translation.customField2`,`product.additionalProductInfo.translation.customField2`) as `product.additionalProductInfo.customField2`, `product.additionalProductInfo.translation.customField3`, COALESCE(`product.additionalProductInfo.translation.customField3`,`product.additionalProductInfo.translation.customField3`) as `product.additionalProductInfo.customField3`, `product.additionalProductInfo.translation.customField4`, COALESCE(`product.additionalProductInfo.translation.customField4`,`product.additionalProductInfo.translation.customField4`) as `product.additionalProductInfo.customField4`, `product.additionalProductInfo.translation.createdAt`, `product.additionalProductInfo.translation.updatedAt`, `product.additionalProductInfo.translation.additionalProductInfoId`, `product.additionalProductInfo.translation.languageId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = :languageId) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, `product.parent.translation`.name as `product.parent.translation.name`, `product.parent.translation`.keywords as `product.parent.translation.keywords`, `product.parent.translation`.description as `product.parent.translation.description`, `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = :languageId) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `additional_product_info` `product.additionalProductInfo` ON `product`.`id` = `product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `product.additionalProductInfo.translation`.additional_product_info_id, `product.additionalProductInfo.translation`.alternative_name as `product.additionalProductInfo.translation.alternativeName`, `product.additionalProductInfo.translation`.custom_field_1 as `product.additionalProductInfo.translation.customField1`, `product.additionalProductInfo.translation`.custom_field_2 as `product.additionalProductInfo.translation.customField2`, `product.additionalProductInfo.translation`.custom_field_3 as `product.additionalProductInfo.translation.customField3`, `product.additionalProductInfo.translation`.custom_field_4 as `product.additionalProductInfo.translation.customField4`, `product.additionalProductInfo.translation`.created_at as `product.additionalProductInfo.translation.createdAt`, `product.additionalProductInfo.translation`.updated_at as `product.additionalProductInfo.translation.updatedAt`, `product.additionalProductInfo.translation`.additional_product_info_id as `product.additionalProductInfo.translation.additionalProductInfoId`, `product.additionalProductInfo.translation`.language_id as `product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `product.additionalProductInfo.translation` WHERE `product.additionalProductInfo.translation`.language_id = :languageId) `product.additionalProductInfo.additional_product_info_translation` ON `product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `product.additionalProductInfo`.`id` WHERE `product`.`version_id` = :version
View formatted query    View runnable query    View query stack
47 72.60 ms 
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, COALESCE(`product_media.media.translation.title`,`product_media.media.translation.title`) as `product_media.media.title`, `product_media.media.translation.alt`, COALESCE(`product_media.media.translation.alt`,`product_media.media.translation.alt`) as `product_media.media.alt`, `product_media.media.translation.customFields`, COALESCE(`product_media.media.translation.customFields`,`product_media.media.translation.customFields`) as `product_media.media.customFields`, `product_media.media.translation.createdAt`, `product_media.media.translation.updatedAt`, `product_media.media.translation.mediaId`, `product_media.media.translation.languageId`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.media_id, `product_media.media.translation`.title as `product_media.media.translation.title`, `product_media.media.translation`.alt as `product_media.media.translation.alt`, `product_media.media.translation`.custom_fields as `product_media.media.translation.customFields`, `product_media.media.translation`.created_at as `product_media.media.translation.createdAt`, `product_media.media.translation`.updated_at as `product_media.media.translation.updatedAt`, `product_media.media.translation`.media_id as `product_media.media.translation.mediaId`, `product_media.media.translation`.language_id as `product_media.media.translation.languageId` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.language_id = :languageId) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = :version) AND ((`product_media`.`product_id` IN (:param_a463d1eecf914038ae9478e479febc73)))
View formatted query    View runnable query    View query stack
48 0.92 ms 
SELECT `wexo_category_banner`.`id` FROM `wexo_category_banner` LEFT JOIN `wexo_marketing_tools_sales_channel` `wexo_category_banner.salesChannels` ON `wexo_category_banner`.`id` = `wexo_category_banner.salesChannels`.`marketing_tools_id` LEFT JOIN `wexo_marketing_tools_category` `wexo_category_banner.categories` ON `wexo_category_banner`.`id` = `wexo_category_banner.categories`.`marketing_tools_id` WHERE (`wexo_category_banner`.`active` = :param_9138bdbfd8b04964bc6b538ad72921ac AND (((`wexo_category_banner`.`date_from` <= :param_b7020b3fc61c483c88906351f9005081) OR `wexo_category_banner`.`date_from` <=> :param_dbc36db55dc84c79b6ef30b6dcbffd95) AND ((`wexo_category_banner`.`date_to` >= :param_26fd19161fc94eeeb56d7673db433902) OR `wexo_category_banner`.`date_to` <=> :param_0b3baa9acf1f4672b824f6e5768b5367)) AND (`wexo_category_banner.salesChannels`.`sales_channel_id` = :param_76d0cb02d2f44766b54ca688efad97e6 OR `wexo_category_banner.salesChannels`.`sales_channel_id` <=> :param_92d3938a5e7046899143ab2407846306) AND (`wexo_category_banner`.`rule_id` IN (:param_7b589056d41140118ed7e2a6dbcdac04) OR `wexo_category_banner`.`rule_id` <=> :param_6951d10ab9964320950b8ca1ddbba325) AND `wexo_category_banner.categories`.`category_id` <=> :param_a127e2f5fb6f4ec39cc9ef12295543d5) GROUP BY `wexo_category_banner`.`id`
View formatted query    View runnable query    View query stack
49 1.01 ms 
SELECT `wexo_category_banner`.`id` as `wexo_category_banner.id`, `wexo_category_banner`.`name` as `wexo_category_banner.name`, `wexo_category_banner`.`active` as `wexo_category_banner.active`, `wexo_category_banner`.`content_html` as `wexo_category_banner.contentHtml`, `wexo_category_banner`.`date_from` as `wexo_category_banner.dateFrom`, `wexo_category_banner`.`date_to` as `wexo_category_banner.dateTo`, `wexo_category_banner`.`campaign_id` as `wexo_category_banner.campaignId`, `wexo_category_banner`.`rule_id` as `wexo_category_banner.ruleId`, `wexo_category_banner`.`media_id` as `wexo_category_banner.mediaId`, `wexo_category_banner.media`.`id` as `wexo_category_banner.media.id`, `wexo_category_banner.media`.`user_id` as `wexo_category_banner.media.userId`, `wexo_category_banner.media`.`media_folder_id` as `wexo_category_banner.media.mediaFolderId`, `wexo_category_banner.media`.`mime_type` as `wexo_category_banner.media.mimeType`, `wexo_category_banner.media`.`file_extension` as `wexo_category_banner.media.fileExtension`, `wexo_category_banner.media`.`uploaded_at` as `wexo_category_banner.media.uploadedAt`, `wexo_category_banner.media`.`file_name` as `wexo_category_banner.media.fileName`, `wexo_category_banner.media`.`file_size` as `wexo_category_banner.media.fileSize`, `wexo_category_banner.media`.`media_type` as `wexo_category_banner.media.mediaTypeRaw`, `wexo_category_banner.media`.`meta_data` as `wexo_category_banner.media.metaData`, `wexo_category_banner.media`.`private` as `wexo_category_banner.media.private`, `wexo_category_banner.media`.`thumbnails_ro` as `wexo_category_banner.media.thumbnailsRo`, `wexo_category_banner.media`.`created_at` as `wexo_category_banner.media.createdAt`, `wexo_category_banner.media`.`updated_at` as `wexo_category_banner.media.updatedAt`, `wexo_category_banner.media.translation.title`, COALESCE(`wexo_category_banner.media.translation.title`,`wexo_category_banner.media.translation.title`) as `wexo_category_banner.media.title`, `wexo_category_banner.media.translation.alt`, COALESCE(`wexo_category_banner.media.translation.alt`,`wexo_category_banner.media.translation.alt`) as `wexo_category_banner.media.alt`, `wexo_category_banner.media.translation.customFields`, COALESCE(`wexo_category_banner.media.translation.customFields`,`wexo_category_banner.media.translation.customFields`) as `wexo_category_banner.media.customFields`, `wexo_category_banner.media.translation.createdAt`, `wexo_category_banner.media.translation.updatedAt`, `wexo_category_banner.media.translation.mediaId`, `wexo_category_banner.media.translation.languageId`, `wexo_category_banner`.`custom_fields` as `wexo_category_banner.customFields`, `wexo_category_banner`.`activate_auto_fit` as `wexo_category_banner.activateAutoFit`, `wexo_category_banner`.`positions` as `wexo_category_banner.positions`, `wexo_category_banner`.`start_from_end` as `wexo_category_banner.startFromEnd`, `wexo_category_banner`.`pages` as `wexo_category_banner.pages`, `wexo_category_banner`.`exclusion_mode` as `wexo_category_banner.exclusionMode`, `wexo_category_banner`.`columns` as `wexo_category_banner.columns`, `wexo_category_banner`.`link` as `wexo_category_banner.link`, `wexo_category_banner`.`link_new_tab` as `wexo_category_banner.linkNewTab`, `wexo_category_banner`.`background_color` as `wexo_category_banner.backgroundColor`, `wexo_category_banner`.`created_at` as `wexo_category_banner.createdAt`, `wexo_category_banner`.`updated_at` as `wexo_category_banner.updatedAt` FROM `wexo_category_banner` LEFT JOIN `media` `wexo_category_banner.media` ON `wexo_category_banner`.`media_id` = `wexo_category_banner.media`.`id` LEFT JOIN (SELECT `wexo_category_banner.media.translation`.media_id, `wexo_category_banner.media.translation`.title as `wexo_category_banner.media.translation.title`, `wexo_category_banner.media.translation`.alt as `wexo_category_banner.media.translation.alt`, `wexo_category_banner.media.translation`.custom_fields as `wexo_category_banner.media.translation.customFields`, `wexo_category_banner.media.translation`.created_at as `wexo_category_banner.media.translation.createdAt`, `wexo_category_banner.media.translation`.updated_at as `wexo_category_banner.media.translation.updatedAt`, `wexo_category_banner.media.translation`.media_id as `wexo_category_banner.media.translation.mediaId`, `wexo_category_banner.media.translation`.language_id as `wexo_category_banner.media.translation.languageId` FROM `media_translation` `wexo_category_banner.media.translation` WHERE `wexo_category_banner.media.translation`.language_id = :languageId) `wexo_category_banner.media.media_translation` ON `wexo_category_banner.media.media_translation`.`media_id` = `wexo_category_banner.media`.`id` WHERE `wexo_category_banner`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
50 0.24 ms 
SELECT `wexo_marketing_tools_sales_channel`.`id` as `wexo_marketing_tools_sales_channel.id`, `wexo_marketing_tools_sales_channel`.`marketing_tools_id` as `wexo_marketing_tools_sales_channel.marketingToolsId`, `wexo_marketing_tools_sales_channel`.`sales_channel_id` as `wexo_marketing_tools_sales_channel.salesChannelId` FROM `wexo_marketing_tools_sales_channel` WHERE (`wexo_marketing_tools_sales_channel`.`marketing_tools_id` IN (:param_6638c6f3c2214a3e9449862d9f920352))
View formatted query    View runnable query    View query stack
51 1.99 ms 
SELECT `wexo_marketing_tools_category`.`id` as `wexo_marketing_tools_category.id`, `wexo_marketing_tools_category`.`marketing_tools_id` as `wexo_marketing_tools_category.marketingToolsId`, `wexo_marketing_tools_category`.`category_id` as `wexo_marketing_tools_category.categoryId`, `wexo_marketing_tools_category.category`.`id` as `wexo_marketing_tools_category.category.id`, `wexo_marketing_tools_category.category`.`version_id` as `wexo_marketing_tools_category.category.versionId`, `wexo_marketing_tools_category.category`.`parent_id` as `wexo_marketing_tools_category.category.parentId`, `wexo_marketing_tools_category.category`.`parent_version_id` as `wexo_marketing_tools_category.category.parentVersionId`, `wexo_marketing_tools_category.category`.`after_category_id` as `wexo_marketing_tools_category.category.afterCategoryId`, `wexo_marketing_tools_category.category`.`after_category_version_id` as `wexo_marketing_tools_category.category.afterCategoryVersionId`, `wexo_marketing_tools_category.category`.`media_id` as `wexo_marketing_tools_category.category.mediaId`, `wexo_marketing_tools_category.category`.`display_nested_products` as `wexo_marketing_tools_category.category.displayNestedProducts`, `wexo_marketing_tools_category.category`.`auto_increment` as `wexo_marketing_tools_category.category.autoIncrement`, `wexo_marketing_tools_category.category`.`level` as `wexo_marketing_tools_category.category.level`, `wexo_marketing_tools_category.category`.`path` as `wexo_marketing_tools_category.category.path`, `wexo_marketing_tools_category.category`.`child_count` as `wexo_marketing_tools_category.category.childCount`, `wexo_marketing_tools_category.category`.`type` as `wexo_marketing_tools_category.category.type`, `wexo_marketing_tools_category.category`.`product_assignment_type` as `wexo_marketing_tools_category.category.productAssignmentType`, `wexo_marketing_tools_category.category`.`visible` as `wexo_marketing_tools_category.category.visible`, `wexo_marketing_tools_category.category`.`active` as `wexo_marketing_tools_category.category.active`, `wexo_marketing_tools_category.category`.`cms_page_id` as `wexo_marketing_tools_category.category.cmsPageId`, `wexo_marketing_tools_category.category`.`cms_page_version_id` as `wexo_marketing_tools_category.category.cmsPageVersionId`, `wexo_marketing_tools_category.category`.`product_stream_id` as `wexo_marketing_tools_category.category.productStreamId`, `wexo_marketing_tools_category.category`.`created_at` as `wexo_marketing_tools_category.category.createdAt`, `wexo_marketing_tools_category.category`.`updated_at` as `wexo_marketing_tools_category.category.updatedAt`, `wexo_marketing_tools_category.category.translation.name`, COALESCE(`wexo_marketing_tools_category.category.translation.name`,`wexo_marketing_tools_category.category.translation.name`) as `wexo_marketing_tools_category.category.name`, `wexo_marketing_tools_category.category.translation.breadcrumb`, COALESCE(`wexo_marketing_tools_category.category.translation.breadcrumb`,`wexo_marketing_tools_category.category.translation.breadcrumb`) as `wexo_marketing_tools_category.category.breadcrumb`, `wexo_marketing_tools_category.category.translation.slotConfig`, COALESCE(`wexo_marketing_tools_category.category.translation.slotConfig`,`wexo_marketing_tools_category.category.translation.slotConfig`) as `wexo_marketing_tools_category.category.slotConfig`, `wexo_marketing_tools_category.category.translation.linkType`, COALESCE(`wexo_marketing_tools_category.category.translation.linkType`,`wexo_marketing_tools_category.category.translation.linkType`) as `wexo_marketing_tools_category.category.linkType`, `wexo_marketing_tools_category.category.translation.internalLink`, COALESCE(`wexo_marketing_tools_category.category.translation.internalLink`,`wexo_marketing_tools_category.category.translation.internalLink`) as `wexo_marketing_tools_category.category.internalLink`, `wexo_marketing_tools_category.category.translation.externalLink`, COALESCE(`wexo_marketing_tools_category.category.translation.externalLink`,`wexo_marketing_tools_category.category.translation.externalLink`) as `wexo_marketing_tools_category.category.externalLink`, `wexo_marketing_tools_category.category.translation.linkNewTab`, COALESCE(`wexo_marketing_tools_category.category.translation.linkNewTab`,`wexo_marketing_tools_category.category.translation.linkNewTab`) as `wexo_marketing_tools_category.category.linkNewTab`, `wexo_marketing_tools_category.category.translation.description`, COALESCE(`wexo_marketing_tools_category.category.translation.description`,`wexo_marketing_tools_category.category.translation.description`) as `wexo_marketing_tools_category.category.description`, `wexo_marketing_tools_category.category.translation.metaTitle`, COALESCE(`wexo_marketing_tools_category.category.translation.metaTitle`,`wexo_marketing_tools_category.category.translation.metaTitle`) as `wexo_marketing_tools_category.category.metaTitle`, `wexo_marketing_tools_category.category.translation.metaDescription`, COALESCE(`wexo_marketing_tools_category.category.translation.metaDescription`,`wexo_marketing_tools_category.category.translation.metaDescription`) as `wexo_marketing_tools_category.category.metaDescription`, `wexo_marketing_tools_category.category.translation.keywords`, COALESCE(`wexo_marketing_tools_category.category.translation.keywords`,`wexo_marketing_tools_category.category.translation.keywords`) as `wexo_marketing_tools_category.category.keywords`, `wexo_marketing_tools_category.category.translation.customFields`, COALESCE(`wexo_marketing_tools_category.category.translation.customFields`,`wexo_marketing_tools_category.category.translation.customFields`) as `wexo_marketing_tools_category.category.customFields`, `wexo_marketing_tools_category.category.translation.createdAt`, `wexo_marketing_tools_category.category.translation.updatedAt`, `wexo_marketing_tools_category.category.translation.categoryId`, `wexo_marketing_tools_category.category.translation.languageId`, `wexo_marketing_tools_category.category.translation.categoryVersionId` FROM `wexo_marketing_tools_category` LEFT JOIN `category` `wexo_marketing_tools_category.category` ON `wexo_marketing_tools_category`.`category_id` = `wexo_marketing_tools_category.category`.`id` LEFT JOIN (SELECT `wexo_marketing_tools_category.category.translation`.category_id, `wexo_marketing_tools_category.category.translation`.category_version_id, `wexo_marketing_tools_category.category.translation`.name as `wexo_marketing_tools_category.category.translation.name`, `wexo_marketing_tools_category.category.translation`.breadcrumb as `wexo_marketing_tools_category.category.translation.breadcrumb`, `wexo_marketing_tools_category.category.translation`.slot_config as `wexo_marketing_tools_category.category.translation.slotConfig`, `wexo_marketing_tools_category.category.translation`.link_type as `wexo_marketing_tools_category.category.translation.linkType`, `wexo_marketing_tools_category.category.translation`.internal_link as `wexo_marketing_tools_category.category.translation.internalLink`, `wexo_marketing_tools_category.category.translation`.external_link as `wexo_marketing_tools_category.category.translation.externalLink`, `wexo_marketing_tools_category.category.translation`.link_new_tab as `wexo_marketing_tools_category.category.translation.linkNewTab`, `wexo_marketing_tools_category.category.translation`.description as `wexo_marketing_tools_category.category.translation.description`, `wexo_marketing_tools_category.category.translation`.meta_title as `wexo_marketing_tools_category.category.translation.metaTitle`, `wexo_marketing_tools_category.category.translation`.meta_description as `wexo_marketing_tools_category.category.translation.metaDescription`, `wexo_marketing_tools_category.category.translation`.keywords as `wexo_marketing_tools_category.category.translation.keywords`, `wexo_marketing_tools_category.category.translation`.custom_fields as `wexo_marketing_tools_category.category.translation.customFields`, `wexo_marketing_tools_category.category.translation`.created_at as `wexo_marketing_tools_category.category.translation.createdAt`, `wexo_marketing_tools_category.category.translation`.updated_at as `wexo_marketing_tools_category.category.translation.updatedAt`, `wexo_marketing_tools_category.category.translation`.category_id as `wexo_marketing_tools_category.category.translation.categoryId`, `wexo_marketing_tools_category.category.translation`.language_id as `wexo_marketing_tools_category.category.translation.languageId`, `wexo_marketing_tools_category.category.translation`.category_version_id as `wexo_marketing_tools_category.category.translation.categoryVersionId` FROM `category_translation` `wexo_marketing_tools_category.category.translation` WHERE `wexo_marketing_tools_category.category.translation`.language_id = :languageId) `wexo_marketing_tools_category.category.category_translation` ON `wexo_marketing_tools_category.category.category_translation`.`category_id` = `wexo_marketing_tools_category.category`.`id` AND `wexo_marketing_tools_category.category.category_translation`.category_version_id = `wexo_marketing_tools_category.category`.version_id WHERE (`wexo_marketing_tools_category`.`marketing_tools_id` IN (:param_0a81f8aedb1b4aa6adafedf668eea0e6))
View formatted query    View runnable query    View query stack
52 0.17 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
53 0.18 ms 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
View formatted query    View runnable query    View query stack
54 0.16 ms 
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = :param_04084eb53152432bb69ef211b9779adc AND (`rhiem_ar_group`.`channel_ids` = :param_3b76b33e831d46b8a76df8189c5684c2 OR `rhiem_ar_group`.`channel_ids` <=> :param_9ff673cb7b974c38b88169655fa89fb7 OR `rhiem_ar_group`.`channel_ids` LIKE :param_255e6830853248288319e46574d5e79e)) ORDER BY `rhiem_ar_group`.`position` ASC
View formatted query    View runnable query    View query stack
55 0.29 ms 
SELECT `rhiem_ar_group`.`id` as `rhiem_ar_group.id`, `rhiem_ar_group`.`name` as `rhiem_ar_group.name`, `rhiem_ar_group`.`active` as `rhiem_ar_group.active`, `rhiem_ar_group`.`position` as `rhiem_ar_group.position`, `rhiem_ar_group`.`channel_ids` as `rhiem_ar_group.channelIds`, `rhiem_ar_group`.`standard` as `rhiem_ar_group.standard`, `rhiem_ar_group`.`created_at` as `rhiem_ar_group.createdAt`, `rhiem_ar_group`.`updated_at` as `rhiem_ar_group.updatedAt`, `rhiem_ar_group.translation.label`, COALESCE(`rhiem_ar_group.translation.label`,`rhiem_ar_group.translation.label`) as `rhiem_ar_group.label`, `rhiem_ar_group.translation.description`, COALESCE(`rhiem_ar_group.translation.description`,`rhiem_ar_group.translation.description`) as `rhiem_ar_group.description`, `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation.languageId` FROM `rhiem_ar_group` LEFT JOIN (SELECT `rhiem_ar_group.translation`.rhiem_ar_group_id, `rhiem_ar_group.translation`.label as `rhiem_ar_group.translation.label`, `rhiem_ar_group.translation`.description as `rhiem_ar_group.translation.description`, `rhiem_ar_group.translation`.created_at as `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation`.updated_at as `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation`.rhiem_ar_group_id as `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation`.language_id as `rhiem_ar_group.translation.languageId` FROM `rhiem_ar_group_translation` `rhiem_ar_group.translation` WHERE `rhiem_ar_group.translation`.language_id = :languageId) `rhiem_ar_group.rhiem_ar_group_translation` ON `rhiem_ar_group.rhiem_ar_group_translation`.`rhiem_ar_group_id` = `rhiem_ar_group`.`id` WHERE `rhiem_ar_group`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
56 0.67 ms 
SELECT `rhiem_ar_attribute`.`id` as `rhiem_ar_attribute.id`, `rhiem_ar_attribute`.`group_id` as `rhiem_ar_attribute.groupId`, `rhiem_ar_attribute`.`type` as `rhiem_ar_attribute.type`, `rhiem_ar_attribute`.`name` as `rhiem_ar_attribute.name`, `rhiem_ar_attribute`.`required` as `rhiem_ar_attribute.required`, `rhiem_ar_attribute`.`value_min` as `rhiem_ar_attribute.valueMin`, `rhiem_ar_attribute`.`value_max` as `rhiem_ar_attribute.valueMax`, `rhiem_ar_attribute`.`min_max` as `rhiem_ar_attribute.minMax`, `rhiem_ar_attribute`.`active` as `rhiem_ar_attribute.active`, `rhiem_ar_attribute`.`position` as `rhiem_ar_attribute.position`, `rhiem_ar_attribute`.`standard` as `rhiem_ar_attribute.standard`, `rhiem_ar_attribute`.`channel_ids` as `rhiem_ar_attribute.channelIds`, `rhiem_ar_attribute`.`created_at` as `rhiem_ar_attribute.createdAt`, `rhiem_ar_attribute`.`updated_at` as `rhiem_ar_attribute.updatedAt`, `rhiem_ar_attribute.translation.label`, COALESCE(`rhiem_ar_attribute.translation.label`,`rhiem_ar_attribute.translation.label`) as `rhiem_ar_attribute.label`, `rhiem_ar_attribute.translation.description`, COALESCE(`rhiem_ar_attribute.translation.description`,`rhiem_ar_attribute.translation.description`) as `rhiem_ar_attribute.description`, `rhiem_ar_attribute.translation.errorMsg`, COALESCE(`rhiem_ar_attribute.translation.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`) as `rhiem_ar_attribute.errorMsg`, `rhiem_ar_attribute.translation.errorMsgMin`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`) as `rhiem_ar_attribute.errorMsgMin`, `rhiem_ar_attribute.translation.errorMsgMax`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`) as `rhiem_ar_attribute.errorMsgMax`, `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation.languageId` FROM `rhiem_ar_attribute` LEFT JOIN (SELECT `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id, `rhiem_ar_attribute.translation`.label as `rhiem_ar_attribute.translation.label`, `rhiem_ar_attribute.translation`.description as `rhiem_ar_attribute.translation.description`, `rhiem_ar_attribute.translation`.error_msg as `rhiem_ar_attribute.translation.errorMsg`, `rhiem_ar_attribute.translation`.error_msg_min as `rhiem_ar_attribute.translation.errorMsgMin`, `rhiem_ar_attribute.translation`.error_msg_max as `rhiem_ar_attribute.translation.errorMsgMax`, `rhiem_ar_attribute.translation`.created_at as `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation`.updated_at as `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation`.language_id as `rhiem_ar_attribute.translation.languageId` FROM `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation` WHERE `rhiem_ar_attribute.translation`.language_id = :languageId) `rhiem_ar_attribute.rhiem_ar_attribute_translation` ON `rhiem_ar_attribute.rhiem_ar_attribute_translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute`.`id` WHERE (`rhiem_ar_attribute`.`active` = :param_6cc9d4c8082f409e93a194f61854ea71 AND (`rhiem_ar_attribute`.`channel_ids` = :param_d4317ef5f4d745bd9e1cd1a68283a0d9 OR `rhiem_ar_attribute`.`channel_ids` <=> :param_81619ad4259f4e01945149249d0ee7d9 OR `rhiem_ar_attribute`.`channel_ids` LIKE :param_ae5f13f8813b4e22ac7a3489e7fa7b62) AND `rhiem_ar_attribute`.`group_id` IN (:param_23a97a6a1d864159a313df5635029e8a)) ORDER BY `rhiem_ar_attribute`.`position` ASC
View formatted query    View runnable query    View query stack
57 0.22 ms 
SELECT `rhiem_ar_so`.`id` as `rhiem_ar_so.id`, `rhiem_ar_so`.`attribute_id` as `rhiem_ar_so.attributeId`, `rhiem_ar_so`.`value` as `rhiem_ar_so.value`, `rhiem_ar_so`.`position` as `rhiem_ar_so.position`, `rhiem_ar_so`.`created_at` as `rhiem_ar_so.createdAt`, `rhiem_ar_so`.`updated_at` as `rhiem_ar_so.updatedAt`, `rhiem_ar_so.translation.label`, COALESCE(`rhiem_ar_so.translation.label`,`rhiem_ar_so.translation.label`) as `rhiem_ar_so.label`, `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation.languageId` FROM `rhiem_ar_so` LEFT JOIN (SELECT `rhiem_ar_so.translation`.rhiem_ar_so_id, `rhiem_ar_so.translation`.label as `rhiem_ar_so.translation.label`, `rhiem_ar_so.translation`.created_at as `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation`.updated_at as `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation`.rhiem_ar_so_id as `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation`.language_id as `rhiem_ar_so.translation.languageId` FROM `rhiem_ar_so_translation` `rhiem_ar_so.translation` WHERE `rhiem_ar_so.translation`.language_id = :languageId) `rhiem_ar_so.rhiem_ar_so_translation` ON `rhiem_ar_so.rhiem_ar_so_translation`.`rhiem_ar_so_id` = `rhiem_ar_so`.`id` WHERE (`rhiem_ar_so`.`attribute_id` IN (:param_645bb45eb16e4287a8769e7f41f8d596)) ORDER BY `rhiem_ar_so`.`position` 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