GET https://hauptverlag.staging.eurosoft.network/author/Schnidrig-Petrig,%20Reinhard

Response
200 OK
IP
216.73.216.6
Profiled on
Token
a771e4

Query Metrics

64 Database Queries
49 Different statements
45.10 ms Query time

Queries

Group similar statements

#▲ Time Info
1 0.49 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.46 ms 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.26 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',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.56 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.68 ms 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.72 ms 
-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "author/Schnidrig-Petrig,%20Reinhard"
  "author/Schnidrig-Petrig,%20Reinhard/"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.41 ms 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "/author/Schnidrig-Petrig,%20Reinhard"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.39 ms 
SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1
Parameters: 
[
  "//en/author/Schnidrig-Petrig,%20Reinhard"
  "/en/author/Schnidrig-Petrig,%20Reinhard"
  "https://hauptverlag.staging.eurosoft.network/en/author/Schnidrig-Petrig,%20Reinhard"
  "https://hauptverlag.staging.eurosoft.network//en/author/Schnidrig-Petrig,%20Reinhard"
  "/en/author/Schnidrig-Petrig,%20Reinhard"
  "//en/author/Schnidrig-Petrig,%20Reinhard"
  "en/author/Schnidrig-Petrig,%20Reinhard"
  true
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.34 ms 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.77 ms 
SELECT LOWER(HEX(`id`)) AS `id` FROM `moorl_magazine_article` WHERE (`updated_at` IS NULL OR (`show_from` > `updated_at` AND `show_from` < '2026-04-08T12:22:10+00:00') OR (`show_until` > `updated_at` AND `show_until` < '2026-04-08T12:22:10+00:00')) AND `active` = '1';
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.60 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  "r5n1VNojI3oAEGAK0jBdtOpcprnAbnzv"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.34 ms 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "r5n1VNojI3oAEGAK0jBdtOpcprnAbnzv"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.29 ms 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 1.37 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` = ?) GROUP BY `country`.`id`
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 5.52 ms 
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, (SELECT GROUP_CONCAT(HEX(`country.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `sales_channel_country` `country.salesChannels.mapping`
                  WHERE `country.salesChannels.mapping`.`country_id` = `country`.`id` ) as `country.salesChannels.id_mapping`, `country.translation.override_1.name`, `country.translation.name`, COALESCE(`country.translation.override_1.name`,`country.translation.name`) as `country.name`, `country.translation.override_1.addressFormat`, `country.translation.addressFormat`, COALESCE(`country.translation.override_1.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.override_1.customFields`, `country.translation.customFields`, COALESCE(`country.translation.override_1.customFields`,`country.translation.customFields`) as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation.override_1`.`name` as `country.translation.override_1.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation.override_1`.`custom_fields` as `country.translation.override_1.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat`, `country.translation.override_1`.`address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation`.`country_id` = `country.translation.override_1`.`country_id` AND `country.translation.override_1`.`language_id` = ? WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ð¶œsu€\x1DPx\rF\x1C´"
  b"\x01¥Ð¶äqסÔ\x18­‚\x1E\x17“"
  b"\x01¥Ð¶èsÞ¨Õ\x06\x06ÂÚ,Ç"
  b"\x01¥Ð¹CpѮç¥\x10\x1F¸»"
  b"\x01¥Ð¹Fp§·bS±víeÌ"
  b"\x01¥Ð¹IqµŒUû¯ÄrŽ"
  b"\x01¥Ð¹Mq¡ŸØŒœ\x13ºŸí"
  b"\x01¥Ð¹Qq\x1C¡±ÏŸpeõ™"
  b"\x01¥Ð¹Ur\x00—ߎ´\A=ú"
  b"\x01¥Ð¹Yqv“ \f/3•]]"
  b"\x01¥Ð¹\r\x05”k\{œ4Æ\x1F"
  b"\x01¥Ð¹_s²½yñÿ\x15ÅLÏ"
  b"\x01¥Ð¹csIœ\x0E\x0F}`qûA"
  b"\x01¥Ð¹gpÍ°\x1AQ7›Ûr¤"
  b"\x01¥Ð¹jpÚª—º\x14.#Èi"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
  b"\x01¥Ð¹pr0Ÿ/†ÁºÿâÆ"
  b"\x01¥Ð¹spohJ±\x05–\x18–"
  b"\x01¥Ðº\x1Cqò­b\x1C,h—{"
  b"\x01¥Ðº#pÁ‚rº\x07IÐ\n"
  b"""
    \x01¥Ðº*r\x06†g3ÝŽ‘\n
    ç
    """
  b"\x01¥Ðº.sv®ª\x13làÛÉ6"
  b"\x01¥Ðº2s&³\x15”‰~–~ø"
  b"\x01¥Ðº7sð¬,:M³¾6Ö"
  b"\x01¥Ðº;s;°¨c\x1Aç° €"
  b"\x01¥Ðº?rJžD:žr±ßî"
  b"\x01¥ÐºBpò·B\eÓ\x03Ö˜B"
  b"\x01¥ÐºFqp˜4\x1Ab\x15ùX "
  b"\x01¥ÐºKp\x16®ß´Ö\x05÷)ò"
  b"\x01¥ÐºNp:±^‹M¯z,Ü"
  b"\x01¥ÐºSpIŽÿ\x00OODˆ\x1D"
  b"\x01¥ÐºYp¦KÆ\x00ÊmJ"
  b"\x01¥Ðº_pI¶áÁB·«Ãù"
  b"\x01¥Ñ\x07xpv°’½ºëvÌõ"
  b"\x01¥Ñ\x07‹sÍ¡ž\vsv\x12\x13â"
  b"\x01¥Ñ\x07 p/ºJÐΔq¢"
  b"\x01¥Ñ\x07´sÍ¢£;\x03+™|š"
  b"\x01¥Ñ\x07Épȹáé}ƒP¢E"
  b"\x01¥Ñ\x07àrÏ‹J¾-YÊó®"
  b"\x01¥Ñ\x07óp+®KÅ\rœä™˜"
  b"\x01¥Ñ\x08\x06p.¨”\x15: &ö"
  b"\x01¥Ñ\x08\x1Aq\t»g\x07\x0EP’P\x1D"
  b"\x01¥Ñ\x08.r¾–LÏ"V¶A\f"
  b"\x01¥Ñ\x08Ap\x7F²ñ9E,\x19W\v"
  b"\x01¥Ñ\x08Wsô¨Mõ™\ëò"
  b"\x01¥Ñ\x08ksݘ¿æTgr ª"
  b"\x01¥Ñ\x08\x7Frþ‹˜0Šõ\x1E.Ð"
  b"\x01¥Ñ\x08•så«"âØÇ7&V"
  b"\x01¥Ñ\x08«qè†÷±\x00ÔÏ»+"
  b"\x01¥Ñ\x08Àpw‹ƒ¨ŸŸT_b"
  b"\x01¥Ñ\x08Ôs˪5»Y°´Ñ\x11"
  b"\x01¥Ñ\x08ìpܼÖ\x7FAÂÊîü"
  b"\x01¥Ñ\t\x02qt„[ÛLY¢J¶"
  b"\x01¥Ñ\t\x18rèË¦«œó¯Q"
  b"\x01¥Ñ\tOs\x0F™N\x7Fª‘\tJ"
  b"\x01¥Ñ\t|rü“MQè©\x00í"
  b"\x01¥Ñ\t¤rVœ\x12̐®,¦\x10"
  b"\x01¥Ñ\tÙpJŽ\x07uúÓ㬭"
  b"\x01¥Ñ\tðp€¥²×E”Åqú"
  b"""
    \x01¥Ñ\n
    \x03pÒ°(ŒÖ\x08|ñÂ
    """
  b"""
    \x01¥Ñ\n
    \x17s]“Ï‹Žãvû®
    """
  b"""
    \x01¥Ñ\n
    -s>¥ôé-š\x1Eö€
    """
  b"""
    \x01¥Ñ\n
    Bs¿™\x07ZÃh»r¯
    """
  b"""
    \x01¥Ñ\n
    XsLšê¯œ7ZH¶
    """
  b"""
    \x01¥Ñ\n
    lsÙ' À„À”<
    """
  b"""
    \x01¥Ñ\n
    pß‘`â\x12\x1C.™3
    """
  b"""
    \x01¥Ñ\n
    ™r£¥@:’.¡\x07\x13
    """
  b"""
    \x01¥Ñ\n
    ¬sO‘ô\eG*ùèT
    """
  b"""
    \x01¥Ñ\n
    ÀrIŒ‘pæhq‡a
    """
  b"""
    \x01¥Ñ\n
    Óq›—úñ‚ËIÄì
    """
  b"\x01¥Ñ\nêq[‡7\x00èÜDí\x1C"
  b"""
    \x01¥Ñ\n
    ÿsQ™‘\x1A\x18‘ÛV„
    """
  b"\x01¥Ñ\v\x13sг§!¿ü"
  b"\x01¥Ñ\v&qç¡Ã\x1Cå?ë\x05@"
  b"\x01¥Ñ\v9rä‹¥Ñ\r|'cH"
  b"\x01¥Ñ\vLs¯©Y\x0F\x0F™Sß "
  b"\x01¥Ñ\vgr<…Gj\x06:ªÑ"
  b"\x01¥Ñ\v{qõˆÅ;LŽ†ü¸"
  b"\x01¥Ñ\vq[±×\tépä“Ç"
  b"\x01¥Ñ\v¥sɻ˕\x11ªY\x7Fì"
  b"\x01¥Ñ\vºq\x03—\x15}q—b‘Õ"
  b"\x01¥Ñ\vÎpú„\tµx» ™ü"
  b"\x01¥Ñ\vãqF—\x1DÙ‹t\x02ò["
  b"\x01¥Ñ\vús\x1D†R²±›Øeå"
  b"\x01¥Ñ\f\rq‚ŽDƒS­ì"
  b"\x01¥Ñ\f$p5¢ñÞí`”áF"
  b"\x01¥Ñ\f7p€¯\x1D«èpُº"
  b"""
    \x01¥Ñ\fMsv\n
    \r$¡ÏcE
    """
  b"\x01¥Ñ\fapn‚¨•‡®\x19h"
  b"\x01¥Ñ\fwp¦¤6*€º;²\x11"
  b"\x01¥Ñ\f‹q…ŸXsò;à‰!"
  b"\x01¥Ñ\fŸq5»\x08u6­ÀâÙ"
  b"\x01¥Ñ\f³r–§YÛ\x00\x1C˜Ä@"
  b"\x01¥Ñ\fÇpW·À\x0FèBÆàm"
  b"\x01¥Ñ\fÛr†´\x06$so0­L"
  b"\x01¥Ñ\fðr\ršNj$l3‘\x1A"
  b"\x01¥Ñ\r\rróœc2‚\f|›`"
  b"\x01¥Ñ\r0pû *÷R¢Å«M"
  b"\x01¥Ñ\r[q\x0F‰gm˜@¯­*"
  b"\x01¥Ñ\r\x7Fq&˜P\x1Ax‚qj"
  b"\x01¥Ñ\r‘põٺ˜:\x0F'"
  b"\x01¥Ñ\r¦pv‰¹5áXú\x1A\n"
  b"\x01¥Ñ\r½r\v—GŽV–…Àñ"
  b"\x01¥Ñ\rÑrÞ²áßc(A\x03Ó"
  b"\x01¥Ñ\rãpR²wì¥ãpWh"
  b"\x01¥Ñ\r÷s–´å\x7FéuÆ›x"
  b"\x01¥Ñ\x0E\vqè˜Nu\x0F\x16‰l"
  b"\x01¥Ñ\x0E q;±ÌÊP\tnå…"
  b"\x01¥Ñ\x0E5r]‚Ù(`£­$H"
  b"\x01¥Ñ\x0EUr\e‘\x02“Q˜\x12~É"
  b"\x01¥Ñ\x0EjqEŽtÀ<ˆÿ ª"
  b"\x01¥Ñ\x0E~qjš—;ê­Ž@y"
  b"\x01¥Ñ\x0E“rê‚\x0EŸ\x154ë:T"
  b"\x01¥Ñ\x0E¦qúšóh‰ãÅ1\"
  b"\x01¥Ñ\x0E¸sc°!·cà-qL"
  b"\x01¥Ñ\x0EÌq[»¹IŒL:@™"
  b"\x01¥Ñ\x0Eßq0ž\x7F\x1En\x05VæØ"
  b"\x01¥Ñ\x0Eór²J³èM%ñ7"
  b"\x01¥Ñ\x0F\x06qo>_qä²Æü"
  b"\x01¥Ñ\x0F\x19sS‰—‚\x007\x7F\x1C9"
  b"\x01¥Ñ\x0F,rê®;Ãî~]å\v"
  b"\x01¥Ñ\x0FAq\x00 Õ\x16rêŸ\x15\v"
  b"\x01¥Ñ\x0FUr ²\f„oðd2f"
  b"\x01¥Ñ\x0Fip§†üî»kŠëx"
  b"\x01¥Ñ\x0Fzs_‡¾ü¦\x16ðZ×"
  b"\x01¥Ñ\x0FŽrP«ªE¼nŽr\x19"
  b"\x01¥Ñ\x0F¢pÿ€šd‰øb²ý"
  b"\x01¥Ñ\x0F¸q?“ŽNC\x03­Çè"
  b"\x01¥Ñ\x0FËq1€Ø&É+rµ\x04"
  b"\x01¥Ñ\x0FÞrK nÙÅ…¢zZ"
  b"\x01¥Ñ\x0Fñp\x04+üÁ<æ;Ž"
  b"\x01¥Ñ\x10\x05pHŠx ˆ \ÎË"
  b"\x01¥Ñ\x10\x18q?¸µa•iR "
  b"\x01¥Ñ\x10*p\x03‡øß\x0E\x05_±Ý"
  b"\x01¥Ñ\x10FqŽ¿£ê/éu\x1FÌ"
  b"\x01¥Ñ\x10Sp“Ÿî\x08jÔþhE"
  b"\x01¥Ñ\x10ksü»‹å~{d ¿"
  b"\x01¥Ñ\x10…r\x1A¿as‘zÖ\x160"
  b"\x01¥Ñ\x10¶sí­ŽÔ\x02òî–Ä"
  b"\x01¥Ñ\x10¿pVš²#¥#­Px"
  b"\x01¥Ñ\x10Åsr¾:\tJ‰\x1D4"
  b"\x01¥Ñ\x10ÌrûŸ\x02ÜãƒÈ;\x12"
  b"\x01¥Ñ\x10àrQŽQÿ¹Ð°’E"
  b"\x01¥Ñ\x10÷r¤Žo\x14Éí¶ì¾"
  b"\x01¥Ñ\x11"qp¤¯HŒRu¯ƒ"
  b"\x01¥Ñ\x11Qsà€”'$r’5\x11"
  b"\x01¥Ñ\x11}p$”¨–Þ‹\x1D\x05j"
  b"\x01¥Ñ\x11±p!­\x02¬"p¦›."
  b"\x01¥Ñ\x11ýr!¶Kóÿ\x0Eƒu\x03"
  b"\x01¥Ñ\x12\x03s?ŠÉï</\x00H-"
  b"\x01¥Ñ\x12\x08pݹI\Ú!kQþ"
  b"\x01¥Ñ\x12\x12q>³›,/`ýÆZ"
  b"\x01¥Ñ\x12%s݆ØÙMŠ£\f"
  b"""
    \x01¥Ñ\x12<q\n
    ‡\x19«¾u¯Öc
    """
  b"\x01¥Ñ\x12OrÀ¨Kêy^wèf"
  b"\x01¥Ñ\x12€q-¬çjá[†šö"
  b"\x01¥Ñ\x12†p…‚4[p¸Ìü¨"
  b"\x01¥Ñ\x12‹q\x07¡¤ï,uÌ÷s"
  b"\x01¥Ñ\x12’r!´)Á\x1C«—3\x0F"
  b"\x01¥Ñ\x12©r>½®‚¹GÃ9\x1C"
  b"\x01¥Ñ\x12»pžúú•û\x00ùù"
  b"\x01¥Ñ\x12Ñr¦§­×yòC\x02""
  b"\x01¥Ñ\x12òp˜¦•R\x15[Ÿ\x16Ù"
  b"\x01¥Ñ\x13\x03pø«¼ºsoÕh\x02"
  b"\x01¥Ñ\x13\x16s\x1A°æ^}Vföz"
  b"\x01¥Ñ\x13*s8°ãH…ʤF¿"
  b"\x01¥Ñ\x13=p¶©gk¿-ƒJÄ"
  b"\x01¥Ñ\x13Pq4›ðL¨\x19fŽÁ"
  b"\x01¥Ñ\x13asRˆ(üEV¡\x10Z"
  b"\x01¥Ñ\x13sqû²Qjÿ\x0EP\x045"
  b"\x01¥Ñ\x13‡q?½¡\x03œIM\x07¼"
  b"\x01¥Ñ\x13šrWŒŒÇò`\x1C­"
  b"\x01¥Ñ\x13´rõ½\x00f\x02É\x134¾"
  b"\x01¥Ñ\x13½r%¢\x13\x1A…-èÁ2"
  b"\x01¥Ñ\x13Òq\t•“\x15Þ´»üÞ"
  b"\x01¥Ñ\x13æp\x01 Eúª’^\x00&"
  b"\x01¥Ñ\x14\fsQ›Kïù$¸\f"
  b"\x01¥Ñ\x14\x12rK·f¹\eaâÀ_"
  b"\x01¥Ñ\x14\x1Fs£µçÙÒØ»Ž«"
  b"\x01¥Ñ\x140s˜»)g}Ü\x17Ú‰"
  b"\x01¥Ñ\x14Dqú¦\ÏŒp\x13\x14¼"
  b"\x01¥Ñ\x14\råŽlxá~´¶O"
  b"\x01¥Ñ\x14oqÍœîfÌXB\x01c"
  b"\x01¥Ñ\x14„rò¡ÐspŽtþN"
  b"\x01¥Ñ\x14œráôƒ—Z\x04ØY"
  b"\x01¥Ñ\x14¯s”fÊ•hÒ2§"
  b"\x01¥Ñ\x14Ås¶’Á•!\x17¢¬ä"
  b"\x01¥Ñ\x14çpÕ‹òÇ“•¥×ç"
  b"\x01¥Ñ\x15\x0EpK¹ÇŒý\x0E$Ü€"
  b"\x01¥Ñ\x15<qޏÙa|\x01”€c"
  b"\x01¥Ñ\x15bs.˜¨K\x08¾R\x01\x04"
  b"\x01¥Ñ\x15Œrɾö±^d›ç›"
  b"\x01¥Ñ\x15²pM–èxL"þU\x0F"
  b"\x01¥Ñ\x15Çqó¦ã\x0EFT‰úÏ"
  b"\x01¥Ñ\x15Ùp¶¢AáÙ~ÂáJ"
  b"\x01¥Ñ\x15ìq³‹Mý}—kÑž"
  b"\x01¥Ñ\x15ÿro‰Úæ‚Mwþ\x06"
  b"\x01¥Ñ\x16\x12qQ‰\x07[\rEI‹"
  b"\x01¥Ñ\x16'rd­t†ã£½ªm"
  b"\x01¥Ñ\x168p\x19–¥>øô»ZÝ"
  b"\x01¥Ñ\x16Mq…š\x07áH²UVj"
  b"\x01¥Ñ\x16`q-‡\x04‘kp\x10H"
  b"\x01¥Ñ\x16sr\x02››¿L¨ý¢"
  b"\x01¥Ñ\x16…quŒ\x7F÷áÅÄØÖ"
  b"\x01¥Ñ\x16™r!´Ü\r‹Ä\x17j<"
  b"\x01¥Ñ\x16­p ’ÑN:‰‰ù"
  b"\x01¥Ñ\x16ÂrP“–.•\x18\x1CþR"
  b"\x01¥Ñ\x16Ös\x01»°ïw_B¬*"
  b"\x01¥Ñ\x16ést°Ù\x13ëÁm\x1Dz"
  b"\x01¥Ñ\x16úr&Šž¸%®Ï¯{"
  b"\x01¥Ñ\x17\x11sA¶v\x05;n´ª\r"
  b"\x01¥Ñ\x17"s¬¬%oâ]7æ\x10"
  b"\x01¥Ñ\x176r§ŒVöÒg^Ò;"
  b"\x01¥Ñ\x17Jrá½}c—x/\x1D¡"
  b"\x01¥Ñ\x17^p¡»kÙ[?Š,W"
  b"\x01¥Ñ\x17qs\x04£\x14œ1; ¢Ž"
  b"\x01¥Ñ\x17…pŸŽÝ¡V¶\eÐÍ"
  b"\x01¥Ñ\x17¦p蕧|Éèïΰ"
  b"""
    \x01¥Ñ\x17¾r·–ºÀ\n
    Œq\x055
    """
  b"\x01¥Ñ\x17ÖsA…ôàãùËo\x00"
  b"\x01¥Ñ\x17åqí£ß+yÌ,\fÍ"
  b"\x01¥Ñ\x18 s®¥¤MU\x18PÚ"
  b"\x01¥Ñ\x182q+“+Ü“éÑ\x1DE"
  b"\x01¥Ñ\x18Hr®ºãi\x17;Z÷±"
  b"\x01¥Ñ\x18\qþ˜I¹e[úÚ\x04"
  b"\x01¥Ñ\x18rp¤Ý\x7FݔɄÃ"
  b"\x01¥Ñ\x18†pÓ-ǬÉð·_"
  b"\x01¥Ñ\x18™pp³\x04ÆiÈPÜ\x19"
  b"\x01¥Ñ\x18®pS°ûL-Ï>£l"
  b"\x01¥Ñ\x18Ñs-Ž\x18¼÷BZ™"
  b"\x01¥Ñ\x18âqÛ‰G}\v‡4Ñf"
  b"\x01¥Ñ\x18ùsr¤\vcíûŒGC"
  b"""
    \x01¥Ñ\x19\n
    q„¨¸¤rêÀ)ª
    """
  b"\x01¥Ñ\x19!q\x7Fªöë/“(H"
  b"\x01¥Ñ\x195q”¯98Í-ÖÚ:"
  b"\x01¥Ñ\x19Nq#¡÷+¾Ù9Fá"
  b"\x01¥Ñ\x19bpr€§>\x15g7üq"
  b"\x01¥Ñ\x19xq˜‰—úP\x1A£v€"
  b"\x01¥Ñ\x19Žs(¸ùýx-\x01J"
  b"\x01¥Ñ\x19 qO¢‰e(Ê\XŠ"
  b"\x01¥Ñ\x19²rè¸Ú|Ã’¦ñ¿"
  b"\x01¥Ñ\x19ÇriL\x7FÑ°Â.A"
  b"\x01¥Ñ\x19Ør†±Gñì÷]”“"
  b"\x01¥Ñ\x19îs`€ŠäeÈ6ºƒ"
  b"\x01¥Ñ\x1A\x04p—«šÐº\x17\x1489"
  b"\x01¥Ñ\x1A\x17s\x1F²ØÙÉcá6˜"
  b"\x01¥Ñ\x1A)r·“‰ËjDú‹±"
  b"\x01¥Ñ\x1A<q\x00¶`L»…ô­—"
  b"\x01¥Ñ\x1ASpÕŠ-ןQBÊÙ"
  b"\x01¥Ñ\x1AfpH´¸\x05\x16àŠ\x11×"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 2.11 ms 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.override_1.name`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.override_1.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.override_1.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.override_1.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.override_1.homeName`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.override_1.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.override_1.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.override_1.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.override_1.homeKeywords`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.override_1.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.override_1.customFields`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.override_1.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation.override_1`.`name` as `sales_channel.translation.override_1.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation.override_1`.`custom_fields` as `sales_channel.translation.override_1.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.override_1`.`home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation.override_1`.`home_enabled` as `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation.override_1`.`home_name` as `sales_channel.translation.override_1.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.override_1`.`home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.override_1`.`home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords`, `sales_channel.translation.override_1`.`home_keywords` as `sales_channel.translation.override_1.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.override_1`.`sales_channel_id` AND `sales_channel.translation.override_1`.`language_id` = ? WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01‘J13£x"‰m\fp²ý;g"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.20 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.override_1.name`, `property_group.translation.name`, COALESCE(`property_group.translation.override_1.name`,`property_group.translation.name`) as `property_group.name`, `property_group.translation.override_1.description`, `property_group.translation.description`, COALESCE(`property_group.translation.override_1.description`,`property_group.translation.description`) as `property_group.description`, `property_group.translation.override_1.position`, `property_group.translation.position`, COALESCE(`property_group.translation.override_1.position`,`property_group.translation.position`) as `property_group.position`, `property_group.translation.override_1.customFields`, `property_group.translation.customFields`, COALESCE(`property_group.translation.override_1.customFields`,`property_group.translation.customFields`) as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation.override_1`.`name` as `property_group.translation.override_1.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation.override_1`.`description` as `property_group.translation.override_1.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation.override_1`.`position` as `property_group.translation.override_1.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields`, `property_group.translation.override_1`.`custom_fields` as `property_group.translation.override_1.customFields` FROM `property_group_translation` `property_group.translation` LEFT JOIN `property_group_translation` `property_group.translation.override_1` ON `property_group.translation`.`property_group_id` = `property_group.translation.override_1`.`property_group_id` AND `property_group.translation.override_1`.`language_id` = ? WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE (`property_group`.`filterable` = ?)
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.29 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.35 ms 
SELECT `product_search_config`.`id` FROM `product_search_config` WHERE (`product_search_config`.`language_id` = ?) LIMIT 1
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.33 ms 
SELECT `product_search_config`.`id` as `product_search_config.id`, `product_search_config`.`language_id` as `product_search_config.languageId`, `product_search_config`.`and_logic` as `product_search_config.andLogic`, `product_search_config`.`min_search_length` as `product_search_config.minSearchLength`, `product_search_config`.`excluded_terms` as `product_search_config.excludedTerms`, `product_search_config`.`created_at` as `product_search_config.createdAt`, `product_search_config`.`updated_at` as `product_search_config.updatedAt` FROM `product_search_config` WHERE `product_search_config`.`id` IN (?)
Parameters: 
[
  b"\x01¥ÑLÂqà²x,ÉùÚßn"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.64 ms 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "en-GB"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.78 ms 
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ð¹ms\x03¿5=Ó\x03å¹'"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.62 ms 
SELECT `delivery_time`.`id` as `delivery_time.id`, `delivery_time`.`min` as `delivery_time.min`, `delivery_time`.`max` as `delivery_time.max`, `delivery_time`.`unit` as `delivery_time.unit`, `delivery_time`.`created_at` as `delivery_time.createdAt`, `delivery_time`.`updated_at` as `delivery_time.updatedAt`, `delivery_time.translation.name`, `delivery_time.translation.name` as `delivery_time.name`, `delivery_time.translation.customFields`, `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation`.`delivery_time_id`, `delivery_time.translation`.`name` as `delivery_time.translation.name`, `delivery_time.translation`.`custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation`.`language_id` = ?) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation`.`delivery_time_id` = `delivery_time`.`id` WHERE `delivery_time`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ðº¥qh“?6:þÇ,\x02"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 1.24 ms 
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.customFields`,`currency.translation.customFields`) as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE (`currency`.`iso_code` IN (?, ?))
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CHF"
  "EUR"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.38 ms 
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.91 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.override_1.name`, `property_group.translation.name`, COALESCE(`property_group.translation.override_1.name`,`property_group.translation.name`) as `property_group.name`, `property_group.translation.override_1.description`, `property_group.translation.description`, COALESCE(`property_group.translation.override_1.description`,`property_group.translation.description`) as `property_group.description`, `property_group.translation.override_1.position`, `property_group.translation.position`, COALESCE(`property_group.translation.override_1.position`,`property_group.translation.position`) as `property_group.position`, `property_group.translation.override_1.customFields`, `property_group.translation.customFields`, COALESCE(`property_group.translation.override_1.customFields`,`property_group.translation.customFields`) as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation.override_1`.`name` as `property_group.translation.override_1.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation.override_1`.`description` as `property_group.translation.override_1.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation.override_1`.`position` as `property_group.translation.override_1.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields`, `property_group.translation.override_1`.`custom_fields` as `property_group.translation.override_1.customFields` FROM `property_group_translation` `property_group.translation` LEFT JOIN `property_group_translation` `property_group.translation.override_1` ON `property_group.translation`.`property_group_id` = `property_group.translation.override_1`.`property_group_id` AND `property_group.translation.override_1`.`language_id` = ? WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id`
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.81 ms 
SELECT `delivery_time`.`id` as `delivery_time.id`, `delivery_time`.`min` as `delivery_time.min`, `delivery_time`.`max` as `delivery_time.max`, `delivery_time`.`unit` as `delivery_time.unit`, `delivery_time`.`created_at` as `delivery_time.createdAt`, `delivery_time`.`updated_at` as `delivery_time.updatedAt`, `delivery_time.translation.name`, `delivery_time.translation.name` as `delivery_time.name`, `delivery_time.translation.customFields`, `delivery_time.translation.customFields` as `delivery_time.customFields` FROM `delivery_time` LEFT JOIN (SELECT `delivery_time.translation`.`delivery_time_id`, `delivery_time.translation`.`name` as `delivery_time.translation.name`, `delivery_time.translation`.`custom_fields` as `delivery_time.translation.customFields` FROM `delivery_time_translation` `delivery_time.translation` WHERE `delivery_time.translation`.`language_id` = ?) `delivery_time.delivery_time_translation` ON `delivery_time.delivery_time_translation`.`delivery_time_id` = `delivery_time`.`id` WHERE `delivery_time`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ñ¨ipžP¡ž¶\x12\x18­"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.97 ms 
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.customFields`,`currency.translation.customFields`) as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE (`currency`.`iso_code` IN (?))
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CHF"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.73 ms 
SELECT DISTINCT
               LOWER(HEX(sales_channel.id)) AS salesChannelId,
               LOWER(HEX(domains.language_id)) AS languageId
             FROM sales_channel_domain AS domains
             INNER JOIN sales_channel
               ON domains.sales_channel_id = sales_channel.id
               AND sales_channel.active = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.30 ms 
SELECT LOWER(HEX(sales_channel_id)) AS sales_channel_id, route_name, template
             FROM seo_url_template
             WHERE route_name IN (?)
Parameters: 
[
  "frontend.detail.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.30 ms 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.31 ms 
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters: 
[
  "0190a5d21558701cb17a1f89991d17e2"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.22 ms 
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters: 
[
  "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 0.66 ms 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.63 ms 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?))
Parameters: 
[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 0.27 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
37 0.55 ms 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.18 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.57 ms 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?))
Parameters: 
[
  "frontend.detail.page"
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.28 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.52 ms 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.14 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.65 ms 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?))
Parameters: 
[
  "frontend.detail.page"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.21 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.31 ms 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
  b"\x01‘J13£x"‰m\fp²ý;g"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.15 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.62 ms 
SELECT LOWER(HEX(seo_url.id)) as id, LOWER(HEX(seo_url.foreign_key)) foreignKey, LOWER(HEX(seo_url.sales_channel_id)) salesChannelId, seo_url.is_modified as isModified, seo_url.seo_path_info seoPathInfo FROM seo_url seo_url WHERE (seo_url.route_name = ?) AND (seo_url.language_id = ?) AND (seo_url.is_canonical = 1) AND (seo_url.foreign_key IN (?, ?))
Parameters: 
[
  "frontend.detail.page"
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.15 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.32 ms 
UPDATE seo_url SET is_deleted = 0 WHERE (foreign_key IN (?, ?)) AND (sales_channel_id = ?)
Parameters: 
[
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
  b"˜C-ï9üF$³2\x13¥kŒ”M"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.14 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.62 ms 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.override_1.shortCode`, `unit.translation.shortCode`, COALESCE(`unit.translation.override_1.shortCode`,`unit.translation.shortCode`) as `unit.shortCode`, `unit.translation.override_1.name`, `unit.translation.name`, COALESCE(`unit.translation.override_1.name`,`unit.translation.name`) as `unit.name`, `unit.translation.override_1.customFields`, `unit.translation.customFields`, COALESCE(`unit.translation.override_1.customFields`,`unit.translation.customFields`) as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation.override_1`.`short_code` as `unit.translation.override_1.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation.override_1`.`name` as `unit.translation.override_1.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields`, `unit.translation.override_1`.`custom_fields` as `unit.translation.override_1.customFields` FROM `unit_translation` `unit.translation` LEFT JOIN `unit_translation` `unit.translation.override_1` ON `unit.translation`.`unit_id` = `unit.translation.override_1`.`unit_id` AND `unit.translation.override_1`.`language_id` = ? WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.50 ms 
-- product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
53 0.79 ms 
-- product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.override_1.label`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.override_1.label`,`product_sorting.translation.label`) as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label`, `product_sorting.translation.override_1`.`label` as `product_sorting.translation.override_1.label` FROM `product_sorting_translation` `product_sorting.translation` LEFT JOIN `product_sorting_translation` `product_sorting.translation.override_1` ON `product_sorting.translation`.`product_sorting_id` = `product_sorting.translation.override_1`.`product_sorting_id` AND `product_sorting.translation.override_1`.`language_id` = ? WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¦\üqs™Ì[Îj¥dj"
  b"\x01¥Ñ*ÿsç˜Ã-Œ²5w\n"
  b"\x01¥Ñ*ÿsç˜Ã-Œ² é\x10"
  b"\x01¥Ñ*ÿsç˜Ã-Œ³vœ\x07"
  b"\x01¥Ñ*ÿsç˜Ã-Œ´W\x10ý"
  b"\x01¥Ñ*ÿsç˜Ã-Œµ\x1Dìy"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.35 ms 
-- sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01—œHí<wEªXfÔ5¸·Þ"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.46 ms 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.63 ms 
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?)
Parameters: 
[
  "/author/Schnidrig-Petrig,%20Reinhard"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.68 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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.42 ms 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"\x01‘™\x1A\x10Qtď\e(ÀˆˆVh"
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.25 ms 
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.93 ms 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘™\x1A\x10Qtď\e(ÀˆˆVh"
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.87 ms 
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.override_1.label`, `plugin.translation.label`, COALESCE(`plugin.translation.override_1.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.override_1.description`, `plugin.translation.description`, COALESCE(`plugin.translation.override_1.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.override_1.manufacturerLink`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.override_1.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.override_1.supportLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.override_1.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.override_1.customFields`, `plugin.translation.customFields`, COALESCE(`plugin.translation.override_1.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.`plugin_id`, `plugin.translation`.`label` as `plugin.translation.label`, `plugin.translation.override_1`.`label` as `plugin.translation.override_1.label`, `plugin.translation`.`description` as `plugin.translation.description`, `plugin.translation.override_1`.`description` as `plugin.translation.override_1.description`, `plugin.translation`.`manufacturer_link` as `plugin.translation.manufacturerLink`, `plugin.translation.override_1`.`manufacturer_link` as `plugin.translation.override_1.manufacturerLink`, `plugin.translation`.`support_link` as `plugin.translation.supportLink`, `plugin.translation.override_1`.`support_link` as `plugin.translation.override_1.supportLink`, `plugin.translation`.`custom_fields` as `plugin.translation.customFields`, `plugin.translation.override_1`.`custom_fields` as `plugin.translation.override_1.customFields` FROM `plugin_translation` `plugin.translation` LEFT JOIN `plugin_translation` `plugin.translation.override_1` ON `plugin.translation`.`plugin_id` = `plugin.translation.override_1`.`plugin_id` AND `plugin.translation.override_1`.`language_id` = ? WHERE `plugin.translation`.`language_id` = ?) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = ?)
Parameters: 
[
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"/»_ââšMpªXTÎ|ãâ\v"
  "esMetaCatalog6"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 4.11 ms 
-- seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/0191991d5eb67fd4b567fba328e920b9"
  "/navigation/0191ee79a6787f3ebee5fac531dd762f"
  "/navigation/0191ee79d625774ea134623944f3fcbb"
  "/navigation/0191ee79f4297d84b7916c7493090310"
  "/navigation/0191ee8834aa7e0bacebfed3705d2f42"
  "/navigation/0191ee7b08dc78f49e8cc3d05be28f77"
  "/navigation/0191ee6d4d6b7fc5bcad94019bf1e96b"
  "/navigation/0191ee6d70757a6ca9c423539622f9ae"
  "/navigation/0191ee6d8fb27f8eb69858c1e836a16a"
  "/navigation/0191ee6db9f3790d80e39026e4cd8ebb"
  "/navigation/0191ee6ddae6739ba84e5b6196ec2c88"
  "/navigation/0191ee6dfd087c0dacb354db6e3d36ef"
  "/navigation/0191ee6e265d768a91a683a7ef2d63fc"
  "/navigation/0191ee6e4a32731a900bb77db5d36c32"
  "/navigation/0191ee6e78d2746ca16d6b93bada0a81"
  "/navigation/0191ee6ea63a7c8bbdbda9515feddae9"
  "/navigation/0191ee6edf2d765283cc5d79189f0394"
  "/navigation/0191ee6ef1fe75429f15660a27ec31ba"
  "/navigation/019bbc13360772d48aa0e775b36078fc"
  "/navigation/0191ee7a8eff7f1ebc65845f5e28284c"
  "/navigation/0191ee8f84c671d78bd828bdfaa24128"
  "/navigation/0191ee8fb87e7680b42765fffe64b6c2"
  "/navigation/0191ee8fcf8c70738480b2ab98219716"
  "/navigation/019bbc8addde7ec0b9de3c09f9d67c79"
  "/navigation/0191ee8b859d7e7da514bdc0768cc521"
  "/navigation/0191ee8ba2087cf980fe6bcb30af6db2"
  "/navigation/0191ee8bbda37bd7b9e0fad4751a32ce"
  "/navigation/0191ee8bcfe27cbaa3ff3939db0de93a"
  "/navigation/0191ee8bf4fb72e48edc1694c64a24be"
  "/navigation/0191ee8bfdd076bbb2a4eb12e1fbb085"
  "/navigation/0191ee8c0f2a7b958b4976e43d13f1bd"
  "/navigation/0191ee8c2af57498845593f11f801c1e"
  "/navigation/0191ee8c39b071929ec9011fc654c0d4"
  "/navigation/0191ee8c48587f56b6507202f96c078a"
  "/navigation/0191ee8c6b317bf8bac59dd0539ee242"
  "/navigation/0191ee8c9ffd7531921fa96cd08e6870"
  "/navigation/019bbc1f5a437136aab323feda1d2318"
  "/navigation/0191ee88ef8870e39e23e5c220b067fb"
  "/navigation/0191ee8904567fe7adbab40cfc5d69d5"
  "/navigation/0191ee8923c472ab81aa73663f7cf3f7"
  "/navigation/0191ee894a09763b8057e91754cef150"
  "/navigation/0191ee8968177963ac3aa14c10d37bc9"
  "/navigation/0191ee89779879ef963e6f1540030795"
  "/navigation/0191ee89884e78368492ab963012db6c"
  "/navigation/0191ee8998cc7222b91ba046b53192f9"
  "/navigation/019bbc8c364e78b38debf325c0948ed3"
  "/navigation/0197eab99a3e75dd8ad2c73889740341"
  "/navigation/0197d448ba2c7b199942eb3f22924203"
  "/navigation/0197eaba7b8c7e55abd85d988e9cee74"
  "/navigation/0197eaba9d2e7732bf768c604fd3f081"
  "/navigation/0191ee7ba89c75a2ba0ab988a5d8eb41"
  "/navigation/0197c6cd65837af7b7b5bb1d07118f90"
  "/navigation/0197c6cda35d73078fe33fce062c3f8f"
  "/navigation/0197c6cdef4e7480ad18f56a29f1c2de"
  "/navigation/0197c6ce0f52712a82719412b96a72cc"
  "/navigation/0197c6ce2a9d71d29ab20a61450751f4"
  "/navigation/0197c6ce5f5877dab18548a7feca9cb0"
  "/navigation/0191ee7bbca17c70b8fafb3b5ba5e986"
  "/navigation/0197cbf7289070ac9957fb8239ac36f3"
  "/navigation/0197cbf7897d714382426d8376f4bfc8"
  "/navigation/0191ee7bd61d725cb9b1f1665a57ff2b"
  "/navigation/0191ee7bf27c7f0b9d4b926ed5083238"
  "/navigation/0197e971cb747e65b6c65a1d256f4ea2"
  "/navigation/0197e97244247d2bb74e791fd85fb1fd"
  "/navigation/019690bc6707711e88da28969c511a89"
  "/navigation/0197cbb94c187370ae556386a7468a03"
  "/navigation/0197cbb986f570fb8b2eed529ea53e75"
  "/navigation/0191ee7c21677f4595a2b91b0303681d"
  "/detail/62b3b5cde81591fdc35a82e982f79219"
  "/detail/1e14446a0e9acb345e9bc5846cf12724"
  "/navigation/0190ba53fe0673a28d789f957f8c8db7"
  "/navigation/0190ba542b957fab996cb7ede232036e"
  "/navigation/0190ba5447c07f729e5aac14ab3977b8"
  "/navigation/0190ba546be170968b14cb8c25875a2a"
  "/navigation/0190ba58be4b7a20a08c5bb8c1a6daaf"
  "/navigation/0190ba556daf75c1a2780021b765e2d9"
  "/navigation/0190ba558dea7f4ca2e1a2d8a22b1081"
  "/navigation/0190ba55964f7ad9bcf0d435407e367f"
  "/navigation/0190ba55c18b70218fa12367468dc14a"
  "/navigation/0190ba5826c97e72ad021d9ac2ab2ffb"
  "/navigation/0190ba583d7d773387a1506471bed744"
  "/navigation/0190ba5869fe70f79e656dfa6b015df2"
  "/navigation/01968c734b3f7eef8c0efce23dddc529"
  "/navigation/0190ba58834b73568e28fef89cb2b86f"
  b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
  b"\x01¦Jœ&p•²ÇŠÿÞ“šà"
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.66 ms 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x01˜3\x1Aì†sÞºð\x19KHB\x00Ï"
  b"\x01˜8\x07³.su·M\x1Fàë\x042‰"
  b"\x01˜8\x1DJ$y\x04‰²±!øË\t5"
  b"\x01‘jÿ\x7FíqÔŽ\x11\x1DñMˆwÃ"
  b"\x01‘k\x06àŽr\x16‡BÁ¶ûƒ9i"
  b"\x01‘k\x07õ>xý©g\x0Fó~\eÿ«"
  b"\x01–g^Ü\x1Ar1™ŽnÉf™’²"
  b"""
    \x01—Àï¿ýp\x0E´ë%¬óf\n
    õ
    """
  b"\x01˜,\x033Õr©€AÃ\x1Aݯßï"
  b"\x01˜6Sà\x01}þ‹|&Y¹Íå¥"
  b"\x01˜7ú\x1Ccr²¦¸foB$\x16é"
  b"\x01˜­\x04y/y\x0F¤úé4Z˜\x11Ô"
  b"\x01¥Ðºzs:‹Uo¨üG"
  b"\x01¥ÐºÇsl´Çäæ:\x7Fj7"
  b"\x01¥ÐøápQ…·ÄÏCª\x1E\t"
  b"\x01‘™IY\x7F|ù•/ˆÓÉ’!‚"
  b"\x01¥Ð»ds”†6…LhKŸÙ"
  b"\x01—ù%gŽr\x08®xàxv9RÎ"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.76 ms 
SELECT `meta_catalog_id`.`id` FROM `meta_catalog_id` WHERE `meta_catalog_id`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"·é˜\vg\x18\x1CÌ?Ùä$÷µ°"
  b"\x1F\tnû(•ñï"hœ\x08\x13U"
  b"d\x02Îõ„K’Èßàéö3"ok"
  b"P\x1DþdióÒ™¦/w\x02ސ”‚"
  b"[{ñ\x0E¸\v­¦\eÖ\x1E\x16ç?Íb"
  b"¿ÕЮu{\x18°’ûº”…¿/Ÿ"
  b"‡Ö\x1Dµ\x1DÉž+ó\x06·wò\x08´P"
  b"MD½@RNûa¹$\x16\x7FŽÏþ("
  b"yGEáD\x7F·×E*\x02æRN\"
  b"TŒ£Û¤ŸóÍ^\vû¨»Òÿë"
  b"b³µÍè\x15‘ýÃZ‚é‚÷’\x19"
  b"\x1E\x14Dj\x0EšË4^›Å„lñ'$"
  b"œñÆÅ2àæ\x06’#Îq\x1C6]y"
  b"É\x19V” ÙI«e£0Z»Rç3"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.