https://sw08.sw.dev.aidup.io/account/rma/create/0f31c4d663fc4cd0ae2320bed0db4cab

Method
GET
HTTP Status
200
IP
185.17.218.86
Profiled on
Token
fb8c85

Query Metrics

46 Database Queries
Different statements
146.67 ms Query time
Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.16 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 4.55 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.88 ms 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
View formatted query    View runnable query    View query stack
4 0.54 ms 
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1
View formatted query    View runnable query    View query stack
5 0.67 ms 
SELECT seo_path_info as seoPathInfo, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath OR seo_path_info = :seoPathWithSlash) ORDER BY sales_channel_id IS NULL ASC, LENGTH(seoPathInfo) ASC, is_canonical DESC LIMIT 1
View formatted query    View runnable query    View query stack
6 0.11 ms 
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1
View formatted query    View runnable query    View query stack
7 0.17 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 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 (`search_url_by` = :searchByUrlRegex AND ((:url0 REGEXP `old_url_regex` OR :url2 REGEXP `old_url_regex` OR :url3 REGEXP `old_url_regex`)))) LIMIT 6;
View formatted query    View runnable query    View query stack
8 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
9 4.37 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_5117d736bbc74f108f5f78a8add73733 OR `customer`.`bound_sales_channel_id` = :param_1910a734308b437e914facb032276f93))) AND (`customer`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
10 0.11 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
View formatted query    View runnable query    View query stack
11 0.51 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_ebfc4155a9194a4f88f181711f84c307)
View formatted query    View runnable query    View query stack
12 3.81 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
13 0.55 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
14 0.89 ms 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
View formatted query    View runnable query    View query stack
15 0.15 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
16 0.24 ms 
SELECT `country_translation`.`country_id`, `country_translation`.`language_id` FROM `country_translation` WHERE (`country_translation`.`name` = :param_e972a48ad23a4df98eaced4d17040a67)
View formatted query    View runnable query    View query stack
17 0.87 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_a67008ca7a6f47f19846209937f2325a AND `promotion.salesChannels`.`sales_channel_id` = :param_4a8a68f06cee460583ac9d963d7de731 AND ((`promotion`.`valid_from` <=> :param_acabff00cd194afa942088234e2d8eae AND `promotion`.`valid_until` <=> :param_3fe2a58a938942d69d20d4ea88c13425) OR (`promotion`.`valid_from` <=> :param_9623df38356a4fce9516bcc0239c16ac AND (`promotion`.`valid_until` > :param_9c0103bdb9844769a0680cf0b2d236f5)) OR ((`promotion`.`valid_from` <= :param_3efdda0c68914dcebc525d7466d15b93) AND `promotion`.`valid_until` <=> :param_843abe4e60334c46a3ff22d31ff0adba) OR ((`promotion`.`valid_from` <= :param_c3fc94ed13054fbd8abc4d68816e603e) AND (`promotion`.`valid_until` > :param_ce928d05d9d34401a2bac6af4c9a0e65))) AND `promotion`.`use_codes` = :param_ee85aa4eb5c547408bdd4d9f419f62f3)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
View formatted query    View runnable query    View query stack
18 13.77 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
19 0.29 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_c5447e4b54c544d29e06a0cf70cce238))
View formatted query    View runnable query    View query stack
20 1.30 ms 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_ab86fc36fa534a9e825f7158ced750a4)
View formatted query    View runnable query    View query stack
21 0.10 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.09 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.20 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_2cbdc9f20a474d6aae6aac131453abfa)) AND (`country`.`id` IN (:ids)) GROUP BY `country`.`id`
View formatted query    View runnable query    View query stack
24 1.25 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_88c25c28361f437780150b566b7a59ca)
View formatted query    View runnable query    View query stack
25 0.09 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
26 0.07 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
27 12.87 ms 
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_8fedd473737c40bb98c1e2d6678a620f AND `script_manager`.`location` = :param_a03add077fe24b0ab6291c288e252ea1) ORDER BY `script_manager`.`priority` DESC
View formatted query    View runnable query    View query stack
28 0.24 ms 
SELECT `script_manager`.`id` as `script_manager.id`, `script_manager`.`name` as `script_manager.name`, `script_manager`.`location` as `script_manager.location`, `script_manager`.`priority` as `script_manager.priority`, `script_manager`.`sales_channel` as `script_manager.salesChannel`, `script_manager`.`script` as `script_manager.script`, `script_manager`.`active` as `script_manager.active`, `script_manager`.`created_at` as `script_manager.createdAt`, `script_manager`.`updated_at` as `script_manager.updatedAt` FROM `script_manager` WHERE `script_manager`.`id` IN (:ids)
View formatted query    View runnable query    View query stack
29 0.31 ms 
SELECT `top_banner`.`id` as `top_banner.id`, `top_banner`.`active` as `top_banner.active`, `top_banner`.`sales_channel_ids` as `top_banner.salesChannelIds`, `top_banner`.`banner_name` as `top_banner.bannerName`, `top_banner`.`banner_background_color` as `top_banner.bannerBackgroundColor`, `top_banner`.`banner_text_color` as `top_banner.bannerTextColor`, `top_banner`.`banner_text` as `top_banner.bannerText`, `top_banner`.`banner_link` as `top_banner.bannerLink`, `top_banner`.`banner_position` as `top_banner.bannerPosition`, `top_banner`.`banner_class` as `top_banner.bannerClass`, `top_banner`.`banner_start_Date` as `top_banner.bannerStartDate`, `top_banner`.`banner_end_Date` as `top_banner.bannerEndDate`, `top_banner`.`created_at` as `top_banner.createdAt`, `top_banner`.`updated_at` as `top_banner.updatedAt` FROM `top_banner` WHERE (`top_banner`.`active` = :param_df618ca11e5b4750a8eee7babbfef197 AND `top_banner`.`sales_channel_ids` LIKE :param_848f9928951b49b2a55b9d04647a4a72 AND (((`top_banner`.`banner_start_Date` <= :param_d793c0653b8942b3b0c6ee93e683c667) OR `top_banner`.`banner_start_Date` <=> :param_e7c3a19fbfc640ad95ae732a86906b73) AND ((`top_banner`.`banner_end_Date` >= :param_d83b898f271c4791a557a9cc241ff85d) OR `top_banner`.`banner_end_Date` <=> :param_ad411249868748e8b114ce0a1a105dec)))
View formatted query    View runnable query    View query stack
30 0.26 ms 
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_f7b4039553d54dfd91f34992e201370e AND `script_manager`.`location` = :param_97cfa2e8687c44d8ae3359192f6ee728) ORDER BY `script_manager`.`priority` DESC
View formatted query    View runnable query    View query stack
31 0.68 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_56df967af39943179b59412dbda7f1be) ORDER BY `coe_wishlist`.`created_at` DESC
View formatted query    View runnable query    View query stack
32 12.30 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
33 35.30 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_a01922634e6f40c19517e63fc0318d1a))
View formatted query    View runnable query    View query stack
34 0.36 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
35 0.13 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_7f39534304db426ba6533d0877bc6faa)
View formatted query    View runnable query    View query stack
36 0.12 ms 
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`customer_id` = :param_6ca08f881c704c72b2ca817a1376b9eb)
View formatted query    View runnable query    View query stack
37 0.48 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
38 6.66 ms 
SELECT `order`.`id` as `order.id`, `order`.`version_id` as `order.versionId`, `order`.`auto_increment` as `order.autoIncrement`, `order`.`order_number` as `order.orderNumber`, `order`.`billing_address_id` as `order.billingAddressId`, `order`.`billing_address_version_id` as `order.billingAddressVersionId`, `order`.`currency_id` as `order.currencyId`, `order`.`language_id` as `order.languageId`, `order`.`sales_channel_id` as `order.salesChannelId`, `order`.`order_date_time` as `order.orderDateTime`, `order`.`order_date` as `order.orderDate`, `order`.`price` as `order.price`, `order`.`amount_total` as `order.amountTotal`, `order`.`amount_net` as `order.amountNet`, `order`.`position_price` as `order.positionPrice`, `order`.`tax_status` as `order.taxStatus`, `order`.`shipping_costs` as `order.shippingCosts`, `order`.`shipping_total` as `order.shippingTotal`, `order`.`currency_factor` as `order.currencyFactor`, `order`.`deep_link_code` as `order.deepLinkCode`, `order`.`affiliate_code` as `order.affiliateCode`, `order`.`campaign_code` as `order.campaignCode`, `order`.`customer_comment` as `order.customerComment`, `order`.`state_id` as `order.stateId`, `order.stateMachineState`.`id` as `order.stateMachineState.id`, `order.stateMachineState`.`technical_name` as `order.stateMachineState.technicalName`, `order.stateMachineState`.`state_machine_id` as `order.stateMachineState.stateMachineId`, `order.stateMachineState`.`created_at` as `order.stateMachineState.createdAt`, `order.stateMachineState`.`updated_at` as `order.stateMachineState.updatedAt`, `order.stateMachineState.translation.name`, COALESCE(`order.stateMachineState.translation.name`,`order.stateMachineState.translation.name`) as `order.stateMachineState.name`, `order.stateMachineState.translation.customFields`, COALESCE(`order.stateMachineState.translation.customFields`,`order.stateMachineState.translation.customFields`) as `order.stateMachineState.customFields`, `order.stateMachineState.translation.createdAt`, `order.stateMachineState.translation.updatedAt`, `order.stateMachineState.translation.stateMachineStateId`, `order.stateMachineState.translation.languageId`, `order`.`rule_ids` as `order.ruleIds`, `order`.`custom_fields` as `order.customFields`, `order`.`created_by_id` as `order.createdById`, `order`.`updated_by_id` as `order.updatedById`, `order.orderCustomer`.`id` as `order.orderCustomer.id`, `order.orderCustomer`.`version_id` as `order.orderCustomer.versionId`, `order.orderCustomer`.`customer_id` as `order.orderCustomer.customerId`, `order.orderCustomer`.`order_id` as `order.orderCustomer.orderId`, `order.orderCustomer`.`order_version_id` as `order.orderCustomer.orderVersionId`, `order.orderCustomer`.`email` as `order.orderCustomer.email`, `order.orderCustomer`.`salutation_id` as `order.orderCustomer.salutationId`, `order.orderCustomer`.`first_name` as `order.orderCustomer.firstName`, `order.orderCustomer`.`last_name` as `order.orderCustomer.lastName`, `order.orderCustomer`.`company` as `order.orderCustomer.company`, `order.orderCustomer`.`title` as `order.orderCustomer.title`, `order.orderCustomer`.`vat_ids` as `order.orderCustomer.vatIds`, `order.orderCustomer`.`customer_number` as `order.orderCustomer.customerNumber`, `order.orderCustomer`.`custom_fields` as `order.orderCustomer.customFields`, `order.orderCustomer`.`remote_address` as `order.orderCustomer.remoteAddress`, `order.orderCustomer`.`created_at` as `order.orderCustomer.createdAt`, `order.orderCustomer`.`updated_at` as `order.orderCustomer.updatedAt`, `order`.`item_rounding` as `order.itemRounding`, `order`.`total_rounding` as `order.totalRounding`, `order`.`created_at` as `order.createdAt`, `order`.`updated_at` as `order.updatedAt`, `order.parcelShop`.`id` as `order.parcelShop.id`, `order.parcelShop`.`order_id` as `order.parcelShop.orderId`, `order.parcelShop`.`order_version_id` as `order.parcelShop.orderVersionId`, `order.parcelShop`.`provider_id` as `order.parcelShop.providerId`, `order.parcelShop`.`type_key` as `order.parcelShop.typeKey`, `order.parcelShop`.`latitude` as `order.parcelShop.latitude`, `order.parcelShop`.`longitude` as `order.parcelShop.longitude`, `order.parcelShop`.`name` as `order.parcelShop.name`, `order.parcelShop`.`street` as `order.parcelShop.street`, `order.parcelShop`.`zip_code` as `order.parcelShop.zipCode`, `order.parcelShop`.`country_code` as `order.parcelShop.countryCode`, `order.parcelShop`.`city` as `order.parcelShop.city`, `order.parcelShop`.`note` as `order.parcelShop.note`, `order.parcelShop`.`telephone` as `order.parcelShop.telephone`, `order.parcelShop`.`created_at` as `order.parcelShop.createdAt`, `order.parcelShop`.`updated_at` as `order.parcelShop.updatedAt`, `order.shippingComment`.`id` as `order.shippingComment.id`, `order.shippingComment`.`order_id` as `order.shippingComment.orderId`, `order.shippingComment`.`order_version_id` as `order.shippingComment.orderVersionId`, `order.shippingComment`.`comment` as `order.shippingComment.comment`, `order.shippingComment`.`created_at` as `order.shippingComment.createdAt`, `order.shippingComment`.`updated_at` as `order.shippingComment.updatedAt`, `order.integrationOrder`.`order_id` as `order.integrationOrder.orderId`, `order.integrationOrder`.`order_version_id` as `order.integrationOrder.orderVersionId`, `order.integrationOrder`.`exported` as `order.integrationOrder.exported`, `order.integrationOrder`.`error_message` as `order.integrationOrder.errorMessage`, `order.integrationOrder`.`attempts` as `order.integrationOrder.attempts`, `order.integrationOrder`.`exported_date` as `order.integrationOrder.exportedDate`, `order.integrationOrder`.`order_data` as `order.integrationOrder.orderData`, `order.integrationOrder`.`created_at` as `order.integrationOrder.createdAt`, `order.integrationOrder`.`updated_at` as `order.integrationOrder.updatedAt`, `order.billingAddress`.`id` as `order.billingAddress.id`, `order.billingAddress`.`version_id` as `order.billingAddress.versionId`, `order.billingAddress`.`country_id` as `order.billingAddress.countryId`, `order.billingAddress`.`country_state_id` as `order.billingAddress.countryStateId`, `order.billingAddress`.`order_id` as `order.billingAddress.orderId`, `order.billingAddress`.`order_version_id` as `order.billingAddress.orderVersionId`, `order.billingAddress`.`salutation_id` as `order.billingAddress.salutationId`, `order.billingAddress`.`first_name` as `order.billingAddress.firstName`, `order.billingAddress`.`last_name` as `order.billingAddress.lastName`, `order.billingAddress`.`street` as `order.billingAddress.street`, `order.billingAddress`.`zipcode` as `order.billingAddress.zipcode`, `order.billingAddress`.`city` as `order.billingAddress.city`, `order.billingAddress`.`company` as `order.billingAddress.company`, `order.billingAddress`.`department` as `order.billingAddress.department`, `order.billingAddress`.`title` as `order.billingAddress.title`, `order.billingAddress`.`vat_id` as `order.billingAddress.vatId`, `order.billingAddress`.`phone_number` as `order.billingAddress.phoneNumber`, `order.billingAddress`.`additional_address_line1` as `order.billingAddress.additionalAddressLine1`, `order.billingAddress`.`additional_address_line2` as `order.billingAddress.additionalAddressLine2`, `order.billingAddress`.`custom_fields` as `order.billingAddress.customFields`, `order.billingAddress`.`created_at` as `order.billingAddress.createdAt`, `order.billingAddress`.`updated_at` as `order.billingAddress.updatedAt` FROM `order` LEFT JOIN `state_machine_state` `order.stateMachineState` ON `order`.`state_id` = `order.stateMachineState`.`id` LEFT JOIN `order_customer` `order.orderCustomer` ON `order`.`id` = `order.orderCustomer`.`order_id` AND `order`.`version_id` = `order.orderCustomer`.`version_id` LEFT JOIN `wexo_parcel_shop` `order.parcelShop` ON `order`.`id` = `order.parcelShop`.`order_id` LEFT JOIN `wexo_shipping_comment` `order.shippingComment` ON `order`.`id` = `order.shippingComment`.`order_id` LEFT JOIN `wexo_integration_business_central_order` `order.integrationOrder` ON `order`.`id` = `order.integrationOrder`.`order_id` LEFT JOIN `order_address` `order.billingAddress` ON `order`.`billing_address_id` = `order.billingAddress`.`id` AND `order`.`version_id` = `order.billingAddress`.`version_id` LEFT JOIN (SELECT `order.stateMachineState.translation`.state_machine_state_id, `order.stateMachineState.translation`.name as `order.stateMachineState.translation.name`, `order.stateMachineState.translation`.custom_fields as `order.stateMachineState.translation.customFields`, `order.stateMachineState.translation`.created_at as `order.stateMachineState.translation.createdAt`, `order.stateMachineState.translation`.updated_at as `order.stateMachineState.translation.updatedAt`, `order.stateMachineState.translation`.state_machine_state_id as `order.stateMachineState.translation.stateMachineStateId`, `order.stateMachineState.translation`.language_id as `order.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order.stateMachineState.translation` WHERE `order.stateMachineState.translation`.language_id = :languageId) `order.stateMachineState.state_machine_state_translation` ON `order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order.stateMachineState`.`id` WHERE (`order`.`version_id` = :version) AND (`order`.`id` IN (:ids))
View formatted query    View runnable query    View query stack
39 21.88 ms 
SELECT `order_line_item`.`id` as `order_line_item.id`, `order_line_item`.`version_id` as `order_line_item.versionId`, `order_line_item`.`order_id` as `order_line_item.orderId`, `order_line_item`.`order_version_id` as `order_line_item.orderVersionId`, `order_line_item`.`product_id` as `order_line_item.productId`, `order_line_item`.`product_version_id` as `order_line_item.productVersionId`, `order_line_item`.`promotion_id` as `order_line_item.promotionId`, `order_line_item`.`parent_id` as `order_line_item.parentId`, `order_line_item`.`parent_version_id` as `order_line_item.parentVersionId`, `order_line_item`.`cover_id` as `order_line_item.coverId`, `order_line_item`.`identifier` as `order_line_item.identifier`, `order_line_item`.`referenced_id` as `order_line_item.referencedId`, `order_line_item`.`quantity` as `order_line_item.quantity`, `order_line_item`.`label` as `order_line_item.label`, `order_line_item`.`payload` as `order_line_item.payload`, `order_line_item`.`good` as `order_line_item.good`, `order_line_item`.`removable` as `order_line_item.removable`, `order_line_item`.`stackable` as `order_line_item.stackable`, `order_line_item`.`position` as `order_line_item.position`, `order_line_item`.`price` as `order_line_item.price`, `order_line_item`.`price_definition` as `order_line_item.priceDefinition`, `order_line_item`.`unit_price` as `order_line_item.unitPrice`, `order_line_item`.`total_price` as `order_line_item.totalPrice`, `order_line_item`.`description` as `order_line_item.description`, `order_line_item`.`type` as `order_line_item.type`, `order_line_item`.`custom_fields` as `order_line_item.customFields`, `order_line_item`.`created_at` as `order_line_item.createdAt`, `order_line_item`.`updated_at` as `order_line_item.updatedAt`, `order_line_item.product`.`id` as `order_line_item.product.id`, `order_line_item.product`.`version_id` as `order_line_item.product.versionId`, `order_line_item.product`.`parent_id` as `order_line_item.product.parentId`, `order_line_item.product`.`parent_version_id` as `order_line_item.product.parentVersionId`, COALESCE(`order_line_item.product`.`product_manufacturer_id`, `order_line_item.product.parent`.`product_manufacturer_id`) as `order_line_item.product.manufacturerId`, COALESCE(`order_line_item.product`.`product_manufacturer_version_id`, `order_line_item.product.parent`.`product_manufacturer_version_id`) as `order_line_item.product.productManufacturerVersionId`, COALESCE(`order_line_item.product`.`unit_id`, `order_line_item.product.parent`.`unit_id`) as `order_line_item.product.unitId`, COALESCE(`order_line_item.product`.`tax_id`, `order_line_item.product.parent`.`tax_id`) as `order_line_item.product.taxId`, COALESCE(`order_line_item.product`.`product_media_id`, `order_line_item.product.parent`.`product_media_id`) as `order_line_item.product.coverId`, COALESCE(`order_line_item.product`.`product_media_version_id`, `order_line_item.product.parent`.`product_media_version_id`) as `order_line_item.product.productMediaVersionId`, COALESCE(`order_line_item.product`.`delivery_time_id`, `order_line_item.product.parent`.`delivery_time_id`) as `order_line_item.product.deliveryTimeId`, COALESCE(`order_line_item.product`.`product_feature_set_id`, `order_line_item.product.parent`.`product_feature_set_id`) as `order_line_item.product.featureSetId`, COALESCE(`order_line_item.product`.`canonical_product_id`, `order_line_item.product.parent`.`canonical_product_id`) as `order_line_item.product.canonicalProductId`, COALESCE(`order_line_item.product`.`cms_page_id`, `order_line_item.product.parent`.`cms_page_id`) as `order_line_item.product.cmsPageId`, COALESCE(`order_line_item.product`.`cms_page_version_id`, `order_line_item.product.parent`.`cms_page_version_id`) as `order_line_item.product.cmsPageVersionId`, `order_line_item.product.parent`.`price` as `order_line_item.product.price.inherited`, COALESCE(`order_line_item.product`.`price`, `order_line_item.product.parent`.`price`) as `order_line_item.product.price`, `order_line_item.product`.`product_number` as `order_line_item.product.productNumber`, `order_line_item.product`.`stock` as `order_line_item.product.stock`, COALESCE(`order_line_item.product`.`restock_time`, `order_line_item.product.parent`.`restock_time`) as `order_line_item.product.restockTime`, `order_line_item.product`.`auto_increment` as `order_line_item.product.autoIncrement`, COALESCE(`order_line_item.product`.`active`, `order_line_item.product.parent`.`active`) as `order_line_item.product.active`, `order_line_item.product`.`available_stock` as `order_line_item.product.availableStock`, `order_line_item.product`.`available` as `order_line_item.product.available`, COALESCE(`order_line_item.product`.`is_closeout`, `order_line_item.product.parent`.`is_closeout`) as `order_line_item.product.isCloseout`, `order_line_item.product`.`display_group` as `order_line_item.product.displayGroup`, `order_line_item.product.parent`.`configurator_group_config` as `order_line_item.product.configuratorGroupConfig.inherited`, COALESCE(`order_line_item.product`.`configurator_group_config`, `order_line_item.product.parent`.`configurator_group_config`) as `order_line_item.product.configuratorGroupConfig`, COALESCE(`order_line_item.product`.`main_variant_id`, `order_line_item.product.parent`.`main_variant_id`) as `order_line_item.product.mainVariantId`, `order_line_item.product`.`variant_restrictions` as `order_line_item.product.variantRestrictions`, COALESCE(`order_line_item.product`.`manufacturer_number`, `order_line_item.product.parent`.`manufacturer_number`) as `order_line_item.product.manufacturerNumber`, COALESCE(`order_line_item.product`.`ean`, `order_line_item.product.parent`.`ean`) as `order_line_item.product.ean`, COALESCE(`order_line_item.product`.`purchase_steps`, `order_line_item.product.parent`.`purchase_steps`) as `order_line_item.product.purchaseSteps`, COALESCE(`order_line_item.product`.`max_purchase`, `order_line_item.product.parent`.`max_purchase`) as `order_line_item.product.maxPurchase`, COALESCE(`order_line_item.product`.`min_purchase`, `order_line_item.product.parent`.`min_purchase`) as `order_line_item.product.minPurchase`, COALESCE(`order_line_item.product`.`purchase_unit`, `order_line_item.product.parent`.`purchase_unit`) as `order_line_item.product.purchaseUnit`, COALESCE(`order_line_item.product`.`reference_unit`, `order_line_item.product.parent`.`reference_unit`) as `order_line_item.product.referenceUnit`, COALESCE(`order_line_item.product`.`shipping_free`, `order_line_item.product.parent`.`shipping_free`) as `order_line_item.product.shippingFree`, `order_line_item.product.parent`.`purchase_prices` as `order_line_item.product.purchasePrices.inherited`, COALESCE(`order_line_item.product`.`purchase_prices`, `order_line_item.product.parent`.`purchase_prices`) as `order_line_item.product.purchasePrices`, COALESCE(`order_line_item.product`.`mark_as_topseller`, `order_line_item.product.parent`.`mark_as_topseller`) as `order_line_item.product.markAsTopseller`, COALESCE(`order_line_item.product`.`weight`, `order_line_item.product.parent`.`weight`) as `order_line_item.product.weight`, COALESCE(`order_line_item.product`.`width`, `order_line_item.product.parent`.`width`) as `order_line_item.product.width`, COALESCE(`order_line_item.product`.`height`, `order_line_item.product.parent`.`height`) as `order_line_item.product.height`, COALESCE(`order_line_item.product`.`length`, `order_line_item.product.parent`.`length`) as `order_line_item.product.length`, COALESCE(`order_line_item.product`.`release_date`, `order_line_item.product.parent`.`release_date`) as `order_line_item.product.releaseDate`, COALESCE(`order_line_item.product`.`rating_average`, `order_line_item.product.parent`.`rating_average`) as `order_line_item.product.ratingAverage`, `order_line_item.product.parent`.`category_tree` as `order_line_item.product.categoryTree.inherited`, COALESCE(`order_line_item.product`.`category_tree`, `order_line_item.product.parent`.`category_tree`) as `order_line_item.product.categoryTree`, `order_line_item.product.parent`.`property_ids` as `order_line_item.product.propertyIds.inherited`, COALESCE(`order_line_item.product`.`property_ids`, `order_line_item.product.parent`.`property_ids`) as `order_line_item.product.propertyIds`, `order_line_item.product.parent`.`option_ids` as `order_line_item.product.optionIds.inherited`, COALESCE(`order_line_item.product`.`option_ids`, `order_line_item.product.parent`.`option_ids`) as `order_line_item.product.optionIds`, `order_line_item.product.parent`.`stream_ids` as `order_line_item.product.streamIds.inherited`, COALESCE(`order_line_item.product`.`stream_ids`, `order_line_item.product.parent`.`stream_ids`) as `order_line_item.product.streamIds`, `order_line_item.product.parent`.`tag_ids` as `order_line_item.product.tagIds.inherited`, COALESCE(`order_line_item.product`.`tag_ids`, `order_line_item.product.parent`.`tag_ids`) as `order_line_item.product.tagIds`, `order_line_item.product.parent`.`category_ids` as `order_line_item.product.categoryIds.inherited`, COALESCE(`order_line_item.product`.`category_ids`, `order_line_item.product.parent`.`category_ids`) as `order_line_item.product.categoryIds`, `order_line_item.product`.`child_count` as `order_line_item.product.childCount`, COALESCE(`order_line_item.product`.`custom_field_set_selection_active`, `order_line_item.product.parent`.`custom_field_set_selection_active`) as `order_line_item.product.customFieldSetSelectionActive`, `order_line_item.product`.`sales` as `order_line_item.product.sales`, `order_line_item.product.tax`.`id` as `order_line_item.product.tax.id`, `order_line_item.product.tax`.`tax_rate` as `order_line_item.product.tax.taxRate`, `order_line_item.product.tax`.`name` as `order_line_item.product.tax.name`, `order_line_item.product.tax`.`position` as `order_line_item.product.tax.position`, `order_line_item.product.tax`.`custom_fields` as `order_line_item.product.tax.customFields`, `order_line_item.product.tax`.`created_at` as `order_line_item.product.tax.createdAt`, `order_line_item.product.tax`.`updated_at` as `order_line_item.product.tax.updatedAt`, `order_line_item.product.parent`.`cheapest_price` as `order_line_item.product.cheapestPrice.inherited`, COALESCE(`order_line_item.product`.`cheapest_price`, `order_line_item.product.parent`.`cheapest_price`) as `order_line_item.product.cheapestPrice`, `order_line_item.product`.`created_at` as `order_line_item.product.createdAt`, `order_line_item.product`.`updated_at` as `order_line_item.product.updatedAt`, `order_line_item.product.additionalProductInfo`.`id` as `order_line_item.product.additionalProductInfo.id`, `order_line_item.product.additionalProductInfo`.`product_id` as `order_line_item.product.additionalProductInfo.productId`, `order_line_item.product.additionalProductInfo`.`created_at` as `order_line_item.product.additionalProductInfo.createdAt`, `order_line_item.product.additionalProductInfo`.`updated_at` as `order_line_item.product.additionalProductInfo.updatedAt`, `order_line_item.product.additionalProductInfo.translation.alternativeName`, COALESCE(`order_line_item.product.additionalProductInfo.translation.alternativeName`,`order_line_item.product.additionalProductInfo.translation.alternativeName`) as `order_line_item.product.additionalProductInfo.alternativeName`, `order_line_item.product.additionalProductInfo.translation.customField1`, COALESCE(`order_line_item.product.additionalProductInfo.translation.customField1`,`order_line_item.product.additionalProductInfo.translation.customField1`) as `order_line_item.product.additionalProductInfo.customField1`, `order_line_item.product.additionalProductInfo.translation.customField2`, COALESCE(`order_line_item.product.additionalProductInfo.translation.customField2`,`order_line_item.product.additionalProductInfo.translation.customField2`) as `order_line_item.product.additionalProductInfo.customField2`, `order_line_item.product.additionalProductInfo.translation.customField3`, COALESCE(`order_line_item.product.additionalProductInfo.translation.customField3`,`order_line_item.product.additionalProductInfo.translation.customField3`) as `order_line_item.product.additionalProductInfo.customField3`, `order_line_item.product.additionalProductInfo.translation.customField4`, COALESCE(`order_line_item.product.additionalProductInfo.translation.customField4`,`order_line_item.product.additionalProductInfo.translation.customField4`) as `order_line_item.product.additionalProductInfo.customField4`, `order_line_item.product.additionalProductInfo.translation.createdAt`, `order_line_item.product.additionalProductInfo.translation.updatedAt`, `order_line_item.product.additionalProductInfo.translation.additionalProductInfoId`, `order_line_item.product.additionalProductInfo.translation.languageId`, `order_line_item.product.translation.metaDescription`, `order_line_item.product.parent.translation.metaDescription`, COALESCE(`order_line_item.product.translation.metaDescription`,`order_line_item.product.parent.translation.metaDescription`,`order_line_item.product.translation.metaDescription`) as `order_line_item.product.metaDescription`, `order_line_item.product.translation.name`, `order_line_item.product.parent.translation.name`, COALESCE(`order_line_item.product.translation.name`,`order_line_item.product.parent.translation.name`,`order_line_item.product.translation.name`) as `order_line_item.product.name`, `order_line_item.product.translation.keywords`, `order_line_item.product.parent.translation.keywords`, COALESCE(`order_line_item.product.translation.keywords`,`order_line_item.product.parent.translation.keywords`,`order_line_item.product.translation.keywords`) as `order_line_item.product.keywords`, `order_line_item.product.translation.description`, `order_line_item.product.parent.translation.description`, COALESCE(`order_line_item.product.translation.description`,`order_line_item.product.parent.translation.description`,`order_line_item.product.translation.description`) as `order_line_item.product.description`, `order_line_item.product.translation.metaTitle`, `order_line_item.product.parent.translation.metaTitle`, COALESCE(`order_line_item.product.translation.metaTitle`,`order_line_item.product.parent.translation.metaTitle`,`order_line_item.product.translation.metaTitle`) as `order_line_item.product.metaTitle`, `order_line_item.product.translation.packUnit`, `order_line_item.product.parent.translation.packUnit`, COALESCE(`order_line_item.product.translation.packUnit`,`order_line_item.product.parent.translation.packUnit`,`order_line_item.product.translation.packUnit`) as `order_line_item.product.packUnit`, `order_line_item.product.translation.packUnitPlural`, `order_line_item.product.parent.translation.packUnitPlural`, COALESCE(`order_line_item.product.translation.packUnitPlural`,`order_line_item.product.parent.translation.packUnitPlural`,`order_line_item.product.translation.packUnitPlural`) as `order_line_item.product.packUnitPlural`, `order_line_item.product.translation.customSearchKeywords`, `order_line_item.product.parent.translation.customSearchKeywords`, COALESCE(`order_line_item.product.translation.customSearchKeywords`,`order_line_item.product.parent.translation.customSearchKeywords`,`order_line_item.product.translation.customSearchKeywords`) as `order_line_item.product.customSearchKeywords`, `order_line_item.product.translation.slotConfig`, `order_line_item.product.parent.translation.slotConfig`, COALESCE(`order_line_item.product.translation.slotConfig`,`order_line_item.product.parent.translation.slotConfig`,`order_line_item.product.translation.slotConfig`) as `order_line_item.product.slotConfig`, `order_line_item.product.translation.customFields`, `order_line_item.product.parent.translation.customFields`, COALESCE(`order_line_item.product.translation.customFields`,`order_line_item.product.parent.translation.customFields`,`order_line_item.product.translation.customFields`) as `order_line_item.product.customFields`, `order_line_item.product.translation.createdAt`, `order_line_item.product.parent.translation.createdAt`, `order_line_item.product.translation.updatedAt`, `order_line_item.product.parent.translation.updatedAt`, `order_line_item.product.translation.productId`, `order_line_item.product.parent.translation.productId`, `order_line_item.product.translation.languageId`, `order_line_item.product.parent.translation.languageId`, `order_line_item.product.translation.productVersionId`, `order_line_item.product.parent.translation.productVersionId` FROM `order_line_item` LEFT JOIN `product` `order_line_item.product` ON `order_line_item`.`product_id` = `order_line_item.product`.`id` AND `order_line_item`.`version_id` = `order_line_item.product`.`version_id` LEFT JOIN `product` `order_line_item.product.parent` ON `order_line_item.product`.`parent_id` = `order_line_item.product.parent`.`id` AND `order_line_item.product`.`version_id` = `order_line_item.product.parent`.`version_id` LEFT JOIN (SELECT `order_line_item.product.translation`.product_id, `order_line_item.product.translation`.product_version_id, `order_line_item.product.translation`.meta_description as `order_line_item.product.translation.metaDescription`, `order_line_item.product.translation`.name as `order_line_item.product.translation.name`, `order_line_item.product.translation`.keywords as `order_line_item.product.translation.keywords`, `order_line_item.product.translation`.description as `order_line_item.product.translation.description`, `order_line_item.product.translation`.meta_title as `order_line_item.product.translation.metaTitle`, `order_line_item.product.translation`.pack_unit as `order_line_item.product.translation.packUnit`, `order_line_item.product.translation`.pack_unit_plural as `order_line_item.product.translation.packUnitPlural`, `order_line_item.product.translation`.custom_search_keywords as `order_line_item.product.translation.customSearchKeywords`, `order_line_item.product.translation`.slot_config as `order_line_item.product.translation.slotConfig`, `order_line_item.product.translation`.custom_fields as `order_line_item.product.translation.customFields`, `order_line_item.product.translation`.created_at as `order_line_item.product.translation.createdAt`, `order_line_item.product.translation`.updated_at as `order_line_item.product.translation.updatedAt`, `order_line_item.product.translation`.product_id as `order_line_item.product.translation.productId`, `order_line_item.product.translation`.language_id as `order_line_item.product.translation.languageId`, `order_line_item.product.translation`.product_version_id as `order_line_item.product.translation.productVersionId` FROM `product_translation` `order_line_item.product.translation` WHERE `order_line_item.product.translation`.language_id = :languageId) `order_line_item.product.product_translation` ON `order_line_item.product.product_translation`.`product_id` = `order_line_item.product`.`id` AND `order_line_item.product.product_translation`.product_version_id = `order_line_item.product`.version_id LEFT JOIN (SELECT `order_line_item.product.parent.translation`.product_id, `order_line_item.product.parent.translation`.product_version_id, `order_line_item.product.parent.translation`.meta_description as `order_line_item.product.parent.translation.metaDescription`, `order_line_item.product.parent.translation`.name as `order_line_item.product.parent.translation.name`, `order_line_item.product.parent.translation`.keywords as `order_line_item.product.parent.translation.keywords`, `order_line_item.product.parent.translation`.description as `order_line_item.product.parent.translation.description`, `order_line_item.product.parent.translation`.meta_title as `order_line_item.product.parent.translation.metaTitle`, `order_line_item.product.parent.translation`.pack_unit as `order_line_item.product.parent.translation.packUnit`, `order_line_item.product.parent.translation`.pack_unit_plural as `order_line_item.product.parent.translation.packUnitPlural`, `order_line_item.product.parent.translation`.custom_search_keywords as `order_line_item.product.parent.translation.customSearchKeywords`, `order_line_item.product.parent.translation`.slot_config as `order_line_item.product.parent.translation.slotConfig`, `order_line_item.product.parent.translation`.custom_fields as `order_line_item.product.parent.translation.customFields`, `order_line_item.product.parent.translation`.created_at as `order_line_item.product.parent.translation.createdAt`, `order_line_item.product.parent.translation`.updated_at as `order_line_item.product.parent.translation.updatedAt`, `order_line_item.product.parent.translation`.product_id as `order_line_item.product.parent.translation.productId`, `order_line_item.product.parent.translation`.language_id as `order_line_item.product.parent.translation.languageId`, `order_line_item.product.parent.translation`.product_version_id as `order_line_item.product.parent.translation.productVersionId` FROM `product_translation` `order_line_item.product.parent.translation` WHERE `order_line_item.product.parent.translation`.language_id = :languageId) `order_line_item.product.product_translation.parent` ON `order_line_item.product.product_translation.parent`.`product_id` = `order_line_item.product.parent`.`id` AND `order_line_item.product.product_translation.parent`.product_version_id = `order_line_item.product.parent`.version_id LEFT JOIN `tax` `order_line_item.product.tax` ON `order_line_item.product`.`tax` = `order_line_item.product.tax`.`id` LEFT JOIN `additional_product_info` `order_line_item.product.additionalProductInfo` ON `order_line_item.product`.`id` = `order_line_item.product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `order_line_item.product.additionalProductInfo.translation`.additional_product_info_id, `order_line_item.product.additionalProductInfo.translation`.alternative_name as `order_line_item.product.additionalProductInfo.translation.alternativeName`, `order_line_item.product.additionalProductInfo.translation`.custom_field_1 as `order_line_item.product.additionalProductInfo.translation.customField1`, `order_line_item.product.additionalProductInfo.translation`.custom_field_2 as `order_line_item.product.additionalProductInfo.translation.customField2`, `order_line_item.product.additionalProductInfo.translation`.custom_field_3 as `order_line_item.product.additionalProductInfo.translation.customField3`, `order_line_item.product.additionalProductInfo.translation`.custom_field_4 as `order_line_item.product.additionalProductInfo.translation.customField4`, `order_line_item.product.additionalProductInfo.translation`.created_at as `order_line_item.product.additionalProductInfo.translation.createdAt`, `order_line_item.product.additionalProductInfo.translation`.updated_at as `order_line_item.product.additionalProductInfo.translation.updatedAt`, `order_line_item.product.additionalProductInfo.translation`.additional_product_info_id as `order_line_item.product.additionalProductInfo.translation.additionalProductInfoId`, `order_line_item.product.additionalProductInfo.translation`.language_id as `order_line_item.product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `order_line_item.product.additionalProductInfo.translation` WHERE `order_line_item.product.additionalProductInfo.translation`.language_id = :languageId) `order_line_item.product.additionalProductInfo.additional_product_info_translation` ON `order_line_item.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `order_line_item.product.additionalProductInfo`.`id` WHERE (`order_line_item`.`version_id` = :version) AND ((`order_line_item`.`order_id` IN (:param_43c2f33c9fd44267a7487d252b07080e)))
View formatted query    View runnable query    View query stack
40 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
41 0.20 ms 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
View formatted query    View runnable query    View query stack
42 5.43 ms 
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = :param_4bb75bb0e19345f2a1c54efd4c2c528d AND (`rhiem_ar_group`.`channel_ids` = :param_79fd7784459946d3a6224aff9664b413 OR `rhiem_ar_group`.`channel_ids` <=> :param_6cefa5543d1b48db920cc84871d93c63 OR `rhiem_ar_group`.`channel_ids` LIKE :param_a312184ff5aa49bea0ed7ef0ebaa3f9a)) ORDER BY `rhiem_ar_group`.`position` ASC
View formatted query    View runnable query    View query stack
43 8.56 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
44 0.90 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_8bfcd46348fd4e51a823192a302e56ec AND (`rhiem_ar_attribute`.`channel_ids` = :param_723cf0d757e6487291c7825f10681fbc OR `rhiem_ar_attribute`.`channel_ids` <=> :param_0ec319d95997488ab9ba0319c94eddbe OR `rhiem_ar_attribute`.`channel_ids` LIKE :param_61f9abc586e34e6fbea0467630b7d38e) AND `rhiem_ar_attribute`.`group_id` IN (:param_9c9b78a8666844ac80e35c381555bfc1)) ORDER BY `rhiem_ar_attribute`.`position` ASC
View formatted query    View runnable query    View query stack
45 1.57 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_6d68c78a209b4729a9b2efe5d893daf1)) ORDER BY `rhiem_ar_so`.`position` ASC
View formatted query    View runnable query    View query stack
46 2.28 ms 
SELECT seo_path_info, path_info FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (:pathInfo)) AND (seo_url.language_id = :languageId) AND (seo_url.sales_channel_id = :salesChannelId OR seo_url.sales_channel_id IS NULL) AND (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC
View formatted query    View runnable query    View query stack

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping