https://sw08.sw.dev.aidup.io/note

Query Metrics

32 Database Queries
Different statements
74.88 ms Query time
Invalid entities

Queries

Group similar statements

# Time Info
1 0.35 ms
SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
2 0.46 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
3 1.26 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
4 0.94 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;
5 0.43 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = :salesChannelId) AND (token = :token) LIMIT 1
6 1.47 ms
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
7 0.24 ms
#cart-persister::load
                SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = :token
8 0.45 ms
SELECT `country_translation`.`country_id`, `country_translation`.`language_id` FROM `country_translation` WHERE (`country_translation`.`name` = :param_f2818463cf954853896df83c5ad37129)
9 1.49 ms
# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = :param_8930f90ecc5f43c4a3bee6eb2581f3ba AND `promotion.salesChannels`.`sales_channel_id` = :param_07847c6430f341dcbe445e6b856c96e2 AND ((`promotion`.`valid_from` <=> :param_0e495b28534748d1990024cf5b0fd670 AND `promotion`.`valid_until` <=> :param_e606f1cb944442bfb2d5d802d870ec9a) OR (`promotion`.`valid_from` <=> :param_57b1bc8fd05d466fab1bb32ef648d8ae AND (`promotion`.`valid_until` > :param_588a5607cbcb41198a93b63033ac7f6b)) OR ((`promotion`.`valid_from` <= :param_b192298b337541f2986d302548939cac) AND `promotion`.`valid_until` <=> :param_69726e68016d4f8387759c857eea7bf4) OR ((`promotion`.`valid_from` <= :param_f992d339e3114704a200d2d6bfa61be9) AND (`promotion`.`valid_until` > :param_d4031a50c469494c9777be5d3e917865))) AND `promotion`.`use_codes` = :param_278d4ef9ce47406eb9eac24ed112e043)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
10 5.89 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)
11 0.68 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_4696f785974e4d06bfe8f9f335a74d7a))
12 2.66 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_e171759f4b8e4b609327ef07b1be7bb9)
13 0.29 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`
14 0.20 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
15 0.42 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_acf9fd160ab14951a32dc2ff61f35ad6)) AND (`country`.`id` IN (:ids)) GROUP BY `country`.`id`
16 2.66 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_6bdd6b2dde2b464798343c1434480ebc)
17 0.22 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`
18 0.19 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`
19 0.49 ms
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_c53b6a61755844aeaed0bddfcb3e7f67 AND `script_manager`.`location` = :param_35fb6b5a350841ccb260e9b87ac1ae3d) ORDER BY `script_manager`.`priority` DESC
20 0.47 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)
21 0.70 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_e41e6787a6934298ba78a48dca632a87 AND `top_banner`.`sales_channel_ids` LIKE :param_b36372d435bb4c8cbd68fa86e408d8c6 AND (((`top_banner`.`banner_start_Date` <= :param_0b8e513b714a41369e317fe7152faf8a) OR `top_banner`.`banner_start_Date` <=> :param_46a0feeaa35544878ab324be768db58f) AND ((`top_banner`.`banner_end_Date` >= :param_5719545a8a6346d5a80d7d89aea90fa0) OR `top_banner`.`banner_end_Date` <=> :param_c1b2bb5ff32f4fb6ba23a49531269d31)))
22 0.38 ms
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_8ec5a98ab854468b8682e4a005a423a0 AND `script_manager`.`location` = :param_55949c860dc149629f2c597aba904aa6) ORDER BY `script_manager`.`priority` DESC
23 1.03 ms
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`session_id` = :param_d558cc6e84f141b59d2cc12290922779) ORDER BY `coe_wishlist`.`created_at` DESC
24 2.64 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`.`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` WHERE `coe_wishlist`.`id` IN (:ids)
25 41.33 ms
SELECT `coe_wishlist_note`.`id` as `coe_wishlist_note.id`, `coe_wishlist_note`.`wishlist_id` as `coe_wishlist_note.wishlistId`, `coe_wishlist_note`.`product_id` as `coe_wishlist_note.productId`, `coe_wishlist_note`.`quantity` as `coe_wishlist_note.quantity`, `coe_wishlist_note`.`custom_fields` as `coe_wishlist_note.customFields`, `coe_wishlist_note`.`created_at` as `coe_wishlist_note.createdAt`, `coe_wishlist_note`.`updated_at` as `coe_wishlist_note.updatedAt`, `coe_wishlist_note.product`.`id` as `coe_wishlist_note.product.id`, `coe_wishlist_note.product`.`version_id` as `coe_wishlist_note.product.versionId`, `coe_wishlist_note.product`.`parent_id` as `coe_wishlist_note.product.parentId`, `coe_wishlist_note.product`.`parent_version_id` as `coe_wishlist_note.product.parentVersionId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_id`) as `coe_wishlist_note.product.manufacturerId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_version_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_version_id`) as `coe_wishlist_note.product.productManufacturerVersionId`, COALESCE(`coe_wishlist_note.product`.`unit_id`, `coe_wishlist_note.product.parent`.`unit_id`) as `coe_wishlist_note.product.unitId`, COALESCE(`coe_wishlist_note.product`.`tax_id`, `coe_wishlist_note.product.parent`.`tax_id`) as `coe_wishlist_note.product.taxId`, COALESCE(`coe_wishlist_note.product`.`product_media_id`, `coe_wishlist_note.product.parent`.`product_media_id`) as `coe_wishlist_note.product.coverId`, COALESCE(`coe_wishlist_note.product`.`product_media_version_id`, `coe_wishlist_note.product.parent`.`product_media_version_id`) as `coe_wishlist_note.product.productMediaVersionId`, COALESCE(`coe_wishlist_note.product`.`delivery_time_id`, `coe_wishlist_note.product.parent`.`delivery_time_id`) as `coe_wishlist_note.product.deliveryTimeId`, COALESCE(`coe_wishlist_note.product`.`product_feature_set_id`, `coe_wishlist_note.product.parent`.`product_feature_set_id`) as `coe_wishlist_note.product.featureSetId`, COALESCE(`coe_wishlist_note.product`.`canonical_product_id`, `coe_wishlist_note.product.parent`.`canonical_product_id`) as `coe_wishlist_note.product.canonicalProductId`, COALESCE(`coe_wishlist_note.product`.`cms_page_id`, `coe_wishlist_note.product.parent`.`cms_page_id`) as `coe_wishlist_note.product.cmsPageId`, COALESCE(`coe_wishlist_note.product`.`cms_page_version_id`, `coe_wishlist_note.product.parent`.`cms_page_version_id`) as `coe_wishlist_note.product.cmsPageVersionId`, `coe_wishlist_note.product.parent`.`price` as `coe_wishlist_note.product.price.inherited`, COALESCE(`coe_wishlist_note.product`.`price`, `coe_wishlist_note.product.parent`.`price`) as `coe_wishlist_note.product.price`, `coe_wishlist_note.product`.`product_number` as `coe_wishlist_note.product.productNumber`, `coe_wishlist_note.product`.`stock` as `coe_wishlist_note.product.stock`, COALESCE(`coe_wishlist_note.product`.`restock_time`, `coe_wishlist_note.product.parent`.`restock_time`) as `coe_wishlist_note.product.restockTime`, `coe_wishlist_note.product`.`auto_increment` as `coe_wishlist_note.product.autoIncrement`, COALESCE(`coe_wishlist_note.product`.`active`, `coe_wishlist_note.product.parent`.`active`) as `coe_wishlist_note.product.active`, `coe_wishlist_note.product`.`available_stock` as `coe_wishlist_note.product.availableStock`, `coe_wishlist_note.product`.`available` as `coe_wishlist_note.product.available`, COALESCE(`coe_wishlist_note.product`.`is_closeout`, `coe_wishlist_note.product.parent`.`is_closeout`) as `coe_wishlist_note.product.isCloseout`, `coe_wishlist_note.product`.`display_group` as `coe_wishlist_note.product.displayGroup`, `coe_wishlist_note.product.parent`.`configurator_group_config` as `coe_wishlist_note.product.configuratorGroupConfig.inherited`, COALESCE(`coe_wishlist_note.product`.`configurator_group_config`, `coe_wishlist_note.product.parent`.`configurator_group_config`) as `coe_wishlist_note.product.configuratorGroupConfig`, COALESCE(`coe_wishlist_note.product`.`main_variant_id`, `coe_wishlist_note.product.parent`.`main_variant_id`) as `coe_wishlist_note.product.mainVariantId`, `coe_wishlist_note.product`.`variant_restrictions` as `coe_wishlist_note.product.variantRestrictions`, COALESCE(`coe_wishlist_note.product`.`manufacturer_number`, `coe_wishlist_note.product.parent`.`manufacturer_number`) as `coe_wishlist_note.product.manufacturerNumber`, COALESCE(`coe_wishlist_note.product`.`ean`, `coe_wishlist_note.product.parent`.`ean`) as `coe_wishlist_note.product.ean`, COALESCE(`coe_wishlist_note.product`.`purchase_steps`, `coe_wishlist_note.product.parent`.`purchase_steps`) as `coe_wishlist_note.product.purchaseSteps`, COALESCE(`coe_wishlist_note.product`.`max_purchase`, `coe_wishlist_note.product.parent`.`max_purchase`) as `coe_wishlist_note.product.maxPurchase`, COALESCE(`coe_wishlist_note.product`.`min_purchase`, `coe_wishlist_note.product.parent`.`min_purchase`) as `coe_wishlist_note.product.minPurchase`, COALESCE(`coe_wishlist_note.product`.`purchase_unit`, `coe_wishlist_note.product.parent`.`purchase_unit`) as `coe_wishlist_note.product.purchaseUnit`, COALESCE(`coe_wishlist_note.product`.`reference_unit`, `coe_wishlist_note.product.parent`.`reference_unit`) as `coe_wishlist_note.product.referenceUnit`, COALESCE(`coe_wishlist_note.product`.`shipping_free`, `coe_wishlist_note.product.parent`.`shipping_free`) as `coe_wishlist_note.product.shippingFree`, `coe_wishlist_note.product.parent`.`purchase_prices` as `coe_wishlist_note.product.purchasePrices.inherited`, COALESCE(`coe_wishlist_note.product`.`purchase_prices`, `coe_wishlist_note.product.parent`.`purchase_prices`) as `coe_wishlist_note.product.purchasePrices`, COALESCE(`coe_wishlist_note.product`.`mark_as_topseller`, `coe_wishlist_note.product.parent`.`mark_as_topseller`) as `coe_wishlist_note.product.markAsTopseller`, COALESCE(`coe_wishlist_note.product`.`weight`, `coe_wishlist_note.product.parent`.`weight`) as `coe_wishlist_note.product.weight`, COALESCE(`coe_wishlist_note.product`.`width`, `coe_wishlist_note.product.parent`.`width`) as `coe_wishlist_note.product.width`, COALESCE(`coe_wishlist_note.product`.`height`, `coe_wishlist_note.product.parent`.`height`) as `coe_wishlist_note.product.height`, COALESCE(`coe_wishlist_note.product`.`length`, `coe_wishlist_note.product.parent`.`length`) as `coe_wishlist_note.product.length`, COALESCE(`coe_wishlist_note.product`.`release_date`, `coe_wishlist_note.product.parent`.`release_date`) as `coe_wishlist_note.product.releaseDate`, COALESCE(`coe_wishlist_note.product`.`rating_average`, `coe_wishlist_note.product.parent`.`rating_average`) as `coe_wishlist_note.product.ratingAverage`, `coe_wishlist_note.product.parent`.`category_tree` as `coe_wishlist_note.product.categoryTree.inherited`, COALESCE(`coe_wishlist_note.product`.`category_tree`, `coe_wishlist_note.product.parent`.`category_tree`) as `coe_wishlist_note.product.categoryTree`, `coe_wishlist_note.product.parent`.`property_ids` as `coe_wishlist_note.product.propertyIds.inherited`, COALESCE(`coe_wishlist_note.product`.`property_ids`, `coe_wishlist_note.product.parent`.`property_ids`) as `coe_wishlist_note.product.propertyIds`, `coe_wishlist_note.product.parent`.`option_ids` as `coe_wishlist_note.product.optionIds.inherited`, COALESCE(`coe_wishlist_note.product`.`option_ids`, `coe_wishlist_note.product.parent`.`option_ids`) as `coe_wishlist_note.product.optionIds`, `coe_wishlist_note.product.parent`.`stream_ids` as `coe_wishlist_note.product.streamIds.inherited`, COALESCE(`coe_wishlist_note.product`.`stream_ids`, `coe_wishlist_note.product.parent`.`stream_ids`) as `coe_wishlist_note.product.streamIds`, `coe_wishlist_note.product.parent`.`tag_ids` as `coe_wishlist_note.product.tagIds.inherited`, COALESCE(`coe_wishlist_note.product`.`tag_ids`, `coe_wishlist_note.product.parent`.`tag_ids`) as `coe_wishlist_note.product.tagIds`, `coe_wishlist_note.product.parent`.`category_ids` as `coe_wishlist_note.product.categoryIds.inherited`, COALESCE(`coe_wishlist_note.product`.`category_ids`, `coe_wishlist_note.product.parent`.`category_ids`) as `coe_wishlist_note.product.categoryIds`, `coe_wishlist_note.product`.`child_count` as `coe_wishlist_note.product.childCount`, COALESCE(`coe_wishlist_note.product`.`custom_field_set_selection_active`, `coe_wishlist_note.product.parent`.`custom_field_set_selection_active`) as `coe_wishlist_note.product.customFieldSetSelectionActive`, `coe_wishlist_note.product`.`sales` as `coe_wishlist_note.product.sales`, `coe_wishlist_note.product.tax`.`id` as `coe_wishlist_note.product.tax.id`, `coe_wishlist_note.product.tax`.`tax_rate` as `coe_wishlist_note.product.tax.taxRate`, `coe_wishlist_note.product.tax`.`name` as `coe_wishlist_note.product.tax.name`, `coe_wishlist_note.product.tax`.`position` as `coe_wishlist_note.product.tax.position`, `coe_wishlist_note.product.tax`.`custom_fields` as `coe_wishlist_note.product.tax.customFields`, `coe_wishlist_note.product.tax`.`created_at` as `coe_wishlist_note.product.tax.createdAt`, `coe_wishlist_note.product.tax`.`updated_at` as `coe_wishlist_note.product.tax.updatedAt`, `coe_wishlist_note.product.parent`.`cheapest_price` as `coe_wishlist_note.product.cheapestPrice.inherited`, COALESCE(`coe_wishlist_note.product`.`cheapest_price`, `coe_wishlist_note.product.parent`.`cheapest_price`) as `coe_wishlist_note.product.cheapestPrice`, `coe_wishlist_note.product`.`created_at` as `coe_wishlist_note.product.createdAt`, `coe_wishlist_note.product`.`updated_at` as `coe_wishlist_note.product.updatedAt`, `coe_wishlist_note.product.additionalProductInfo`.`id` as `coe_wishlist_note.product.additionalProductInfo.id`, `coe_wishlist_note.product.additionalProductInfo`.`product_id` as `coe_wishlist_note.product.additionalProductInfo.productId`, `coe_wishlist_note.product.additionalProductInfo`.`created_at` as `coe_wishlist_note.product.additionalProductInfo.createdAt`, `coe_wishlist_note.product.additionalProductInfo`.`updated_at` as `coe_wishlist_note.product.additionalProductInfo.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`) as `coe_wishlist_note.product.additionalProductInfo.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,`coe_wishlist_note.product.additionalProductInfo.translation.customField1`) as `coe_wishlist_note.product.additionalProductInfo.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,`coe_wishlist_note.product.additionalProductInfo.translation.customField2`) as `coe_wishlist_note.product.additionalProductInfo.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,`coe_wishlist_note.product.additionalProductInfo.translation.customField3`) as `coe_wishlist_note.product.additionalProductInfo.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,`coe_wishlist_note.product.additionalProductInfo.translation.customField4`) as `coe_wishlist_note.product.additionalProductInfo.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation.languageId`, `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.parent.translation.metaDescription`, COALESCE(`coe_wishlist_note.product.translation.metaDescription`,`coe_wishlist_note.product.parent.translation.metaDescription`,`coe_wishlist_note.product.translation.metaDescription`) as `coe_wishlist_note.product.metaDescription`, `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.parent.translation.name`, COALESCE(`coe_wishlist_note.product.translation.name`,`coe_wishlist_note.product.parent.translation.name`,`coe_wishlist_note.product.translation.name`) as `coe_wishlist_note.product.name`, `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.parent.translation.keywords`, COALESCE(`coe_wishlist_note.product.translation.keywords`,`coe_wishlist_note.product.parent.translation.keywords`,`coe_wishlist_note.product.translation.keywords`) as `coe_wishlist_note.product.keywords`, `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.parent.translation.description`, COALESCE(`coe_wishlist_note.product.translation.description`,`coe_wishlist_note.product.parent.translation.description`,`coe_wishlist_note.product.translation.description`) as `coe_wishlist_note.product.description`, `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.parent.translation.metaTitle`, COALESCE(`coe_wishlist_note.product.translation.metaTitle`,`coe_wishlist_note.product.parent.translation.metaTitle`,`coe_wishlist_note.product.translation.metaTitle`) as `coe_wishlist_note.product.metaTitle`, `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.parent.translation.packUnit`, COALESCE(`coe_wishlist_note.product.translation.packUnit`,`coe_wishlist_note.product.parent.translation.packUnit`,`coe_wishlist_note.product.translation.packUnit`) as `coe_wishlist_note.product.packUnit`, `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation.packUnitPlural`, COALESCE(`coe_wishlist_note.product.translation.packUnitPlural`,`coe_wishlist_note.product.parent.translation.packUnitPlural`,`coe_wishlist_note.product.translation.packUnitPlural`) as `coe_wishlist_note.product.packUnitPlural`, `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation.customSearchKeywords`, COALESCE(`coe_wishlist_note.product.translation.customSearchKeywords`,`coe_wishlist_note.product.parent.translation.customSearchKeywords`,`coe_wishlist_note.product.translation.customSearchKeywords`) as `coe_wishlist_note.product.customSearchKeywords`, `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.parent.translation.slotConfig`, COALESCE(`coe_wishlist_note.product.translation.slotConfig`,`coe_wishlist_note.product.parent.translation.slotConfig`,`coe_wishlist_note.product.translation.slotConfig`) as `coe_wishlist_note.product.slotConfig`, `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.parent.translation.customFields`, COALESCE(`coe_wishlist_note.product.translation.customFields`,`coe_wishlist_note.product.parent.translation.customFields`,`coe_wishlist_note.product.translation.customFields`) as `coe_wishlist_note.product.customFields`, `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.translation.productVersionId`, `coe_wishlist_note.product.parent.translation.productVersionId` FROM `coe_wishlist_note` LEFT JOIN `product` `coe_wishlist_note.product` ON `coe_wishlist_note`.`product_id` = `coe_wishlist_note.product`.`id` LEFT JOIN `product` `coe_wishlist_note.product.parent` ON `coe_wishlist_note.product`.`parent_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product`.`version_id` = `coe_wishlist_note.product.parent`.`version_id` LEFT JOIN (SELECT `coe_wishlist_note.product.translation`.product_id, `coe_wishlist_note.product.translation`.product_version_id, `coe_wishlist_note.product.translation`.meta_description as `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.translation`.name as `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.translation`.keywords as `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.translation`.description as `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.translation`.meta_title as `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.translation`.pack_unit as `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.translation`.pack_unit_plural as `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.translation`.custom_search_keywords as `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.translation`.slot_config as `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.translation`.custom_fields as `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.translation`.created_at as `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.translation`.updated_at as `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.translation`.product_id as `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.translation`.language_id as `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.translation`.product_version_id as `coe_wishlist_note.product.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.translation` WHERE `coe_wishlist_note.product.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation` ON `coe_wishlist_note.product.product_translation`.`product_id` = `coe_wishlist_note.product`.`id` AND `coe_wishlist_note.product.product_translation`.product_version_id = `coe_wishlist_note.product`.version_id LEFT JOIN (SELECT `coe_wishlist_note.product.parent.translation`.product_id, `coe_wishlist_note.product.parent.translation`.product_version_id, `coe_wishlist_note.product.parent.translation`.meta_description as `coe_wishlist_note.product.parent.translation.metaDescription`, `coe_wishlist_note.product.parent.translation`.name as `coe_wishlist_note.product.parent.translation.name`, `coe_wishlist_note.product.parent.translation`.keywords as `coe_wishlist_note.product.parent.translation.keywords`, `coe_wishlist_note.product.parent.translation`.description as `coe_wishlist_note.product.parent.translation.description`, `coe_wishlist_note.product.parent.translation`.meta_title as `coe_wishlist_note.product.parent.translation.metaTitle`, `coe_wishlist_note.product.parent.translation`.pack_unit as `coe_wishlist_note.product.parent.translation.packUnit`, `coe_wishlist_note.product.parent.translation`.pack_unit_plural as `coe_wishlist_note.product.parent.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation`.custom_search_keywords as `coe_wishlist_note.product.parent.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation`.slot_config as `coe_wishlist_note.product.parent.translation.slotConfig`, `coe_wishlist_note.product.parent.translation`.custom_fields as `coe_wishlist_note.product.parent.translation.customFields`, `coe_wishlist_note.product.parent.translation`.created_at as `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.parent.translation`.updated_at as `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.parent.translation`.product_id as `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.parent.translation`.language_id as `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.parent.translation`.product_version_id as `coe_wishlist_note.product.parent.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.parent.translation` WHERE `coe_wishlist_note.product.parent.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation.parent` ON `coe_wishlist_note.product.product_translation.parent`.`product_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product.product_translation.parent`.product_version_id = `coe_wishlist_note.product.parent`.version_id LEFT JOIN `tax` `coe_wishlist_note.product.tax` ON `coe_wishlist_note.product`.`tax` = `coe_wishlist_note.product.tax`.`id` LEFT JOIN `additional_product_info` `coe_wishlist_note.product.additionalProductInfo` ON `coe_wishlist_note.product`.`id` = `coe_wishlist_note.product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id, `coe_wishlist_note.product.additionalProductInfo.translation`.alternative_name as `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_1 as `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_2 as `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_3 as `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_4 as `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation`.created_at as `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.updated_at as `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id as `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation`.language_id as `coe_wishlist_note.product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `coe_wishlist_note.product.additionalProductInfo.translation` WHERE `coe_wishlist_note.product.additionalProductInfo.translation`.language_id = :languageId) `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation` ON `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `coe_wishlist_note.product.additionalProductInfo`.`id` WHERE (`coe_wishlist_note`.`wishlist_id` IN (:param_b94d72e204984101b2928e35c1335be5))
26 0.32 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
27 0.34 ms
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
28 0.41 ms
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = :param_48de2b3e744f41c7b599b07f3a9672d7 AND (`rhiem_ar_group`.`channel_ids` = :param_174d216957624a369da1d9e05880ee3e OR `rhiem_ar_group`.`channel_ids` <=> :param_fbaf6fcfec5a4dc98256a500fb4c1301 OR `rhiem_ar_group`.`channel_ids` LIKE :param_99d45e1dddc54c61878eb7bb5cd7124c)) ORDER BY `rhiem_ar_group`.`position` ASC
29 0.85 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)
30 1.87 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_b4f8b29fe7d64148a1ba8ec0cb786450 AND (`rhiem_ar_attribute`.`channel_ids` = :param_26f598a05ba843cd82d3bfd7211691cb OR `rhiem_ar_attribute`.`channel_ids` <=> :param_85a9a3a06b6f4be68ae7f421559dcf18 OR `rhiem_ar_attribute`.`channel_ids` LIKE :param_5289bf98cce54a13991b45ee4d3b3235) AND `rhiem_ar_attribute`.`group_id` IN (:param_fcc413a84f0c422f8c813d3be55eb5b9)) ORDER BY `rhiem_ar_attribute`.`position` ASC
31 0.68 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_15f8ab25e3994733bdafcb973449190d)) ORDER BY `rhiem_ar_so`.`position` ASC
32 3.06 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

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