Query Metrics
64
Database Queries
49
Different statements
45.10 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.52 ms (12.25%) |
1 |
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¥Ð¹spohJ±\x05–\x18–" b"\x01¥Ðº\x1Cqòb\x1C,h—{" b"\x01¥Ðº#pÁ‚rº\x07IÐ\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¥Ñ\vq[±×\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‚¨•‡®\x19h" b"\x01¥Ñ\fwp¦¤6*€º;²\x11" b"\x01¥Ñ\f‹q…Xsò;à‰!" b"\x01¥Ñ\fq5»\x08u6ÀâÙ" b"\x01¥Ñ\f³r–§YÛ\x00\x1C˜Ä@" b"\x01¥Ñ\fÇpW·À\x0FèBÆàm" b"\x01¥Ñ\fÛr†´\x06$so0L" 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¼nr\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'rdt†ã£½ª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¥Ñ\x16p ’Ñ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¼÷BZ™" 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¥Ñ\x19s(¸ùýx-\x01J" b"\x01¥Ñ\x19 qO¢‰e(Ê\XŠ" b"\x01¥Ñ\x19²rè¸Ú|Ã’¦ñ¿" b"\x01¥Ñ\x19ÇriL\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×" ] |
||||||||||||||||||||
|
4.11 ms (9.11%) |
1 |
-- 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•²ÇŠÿÞ“šà" ] |
||||||||||||||||||||
|
2.47 ms (5.47%) |
4 |
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ñ'$" ] |
||||||||||||||||||||
|
2.11 ms (4.67%) |
1 |
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•²ÇŠÿÞ“šà" ] |
||||||||||||||||||||
|
1.69 ms (3.75%) |
4 |
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•²ÇŠÿÞ“šà" ] |
||||||||||||||||||||
|
1.43 ms (3.17%) |
2 |
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" ] |
||||||||||||||||||||
|
1.39 ms (3.07%) |
1 |
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 ] |
||||||||||||||||||||
|
1.37 ms (3.03%) |
1 |
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•²ÇŠÿÞ“šà"
]
|
||||||||||||||||||||
|
1.24 ms (2.76%) |
1 |
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" ] |
||||||||||||||||||||
|
1.20 ms (2.65%) |
1 |
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 ] |
||||||||||||||||||||
|
1.05 ms (2.32%) |
2 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
|
0.97 ms (2.16%) |
1 |
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" ] |
||||||||||||||||||||
|
0.93 ms (2.07%) |
1 |
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" ] |
||||||||||||||||||||
|
0.91 ms (2.03%) |
4 |
"START TRANSACTION"
Parameters:
[] |
||||||||||||||||||||
|
0.91 ms (2.02%) |
1 |
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" ] |
||||||||||||||||||||
|
0.87 ms (1.94%) |
1 |
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" ] |
||||||||||||||||||||
|
0.79 ms (1.76%) |
1 |
-- 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" ] |
||||||||||||||||||||
|
0.78 ms (1.74%) |
1 |
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å¹'" ] |
||||||||||||||||||||
|
0.77 ms (1.71%) |
1 |
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:
[] |
||||||||||||||||||||
|
0.76 ms (1.69%) |
1 |
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" ] |
||||||||||||||||||||
|
0.73 ms (1.62%) |
1 |
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:
[] |
||||||||||||||||||||
|
0.72 ms (1.61%) |
1 |
-- 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/" ] |
||||||||||||||||||||
|
0.68 ms (1.51%) |
1 |
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:
[]
|
||||||||||||||||||||
|
0.68 ms (1.50%) |
1 |
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:
[] |
||||||||||||||||||||
|
0.66 ms (1.47%) |
1 |
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"
]
|
||||||||||||||||||||
|
0.66 ms (1.46%) |
1 |
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Î" ] |
||||||||||||||||||||
|
0.64 ms (1.42%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"en-GB"
]
|
||||||||||||||||||||
|
0.63 ms (1.40%) |
1 |
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â" ] |
||||||||||||||||||||
|
0.62 ms (1.38%) |
1 |
-- 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" ] |
||||||||||||||||||||
|
0.61 ms (1.36%) |
4 |
"COMMIT"
Parameters:
[] |
||||||||||||||||||||
|
0.60 ms (1.33%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01¦Jœ&p•²ÇŠÿÞ“šà" "r5n1VNojI3oAEGAK0jBdtOpcprnAbnzv" ] |
||||||||||||||||||||
|
0.53 ms (1.18%) |
2 |
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters:
[
"0190a5d21558701cb17a1f89991d17e2"
]
|
||||||||||||||||||||
|
0.50 ms (1.11%) |
1 |
-- 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
]
|
||||||||||||||||||||
|
0.46 ms (1.02%) |
1 |
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•²ÇŠÿÞ“šà"
]
|
||||||||||||||||||||
|
0.46 ms (1.01%) |
1 |
# 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:
[]
|
||||||||||||||||||||
|
0.42 ms (0.93%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"\x01‘™\x1A\x10QtÄ\e(ÀˆˆVh"
]
|
||||||||||||||||||||
|
0.41 ms (0.91%) |
1 |
-- 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" ] |
||||||||||||||||||||
|
0.38 ms (0.85%) |
1 |
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:
[] |
||||||||||||||||||||
|
0.35 ms (0.78%) |
1 |
-- 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¸·Þ"
]
|
||||||||||||||||||||
|
0.35 ms (0.78%) |
1 |
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â"
]
|
||||||||||||||||||||
|
0.34 ms (0.77%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.34 ms (0.76%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"r5n1VNojI3oAEGAK0jBdtOpcprnAbnzv"
]
|
||||||||||||||||||||
|
0.33 ms (0.74%) |
1 |
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"
]
|
||||||||||||||||||||
|
0.30 ms (0.67%) |
1 |
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"
]
|
||||||||||||||||||||
|
0.30 ms (0.67%) |
1 |
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:
[] |
||||||||||||||||||||
|
0.29 ms (0.65%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.29 ms (0.64%) |
1 |
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å¹'" ] |
||||||||||||||||||||
|
0.26 ms (0.58%) |
1 |
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:
[]
|
||||||||||||||||||||
|
0.25 ms (0.55%) |
1 |
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters:
[
b"\x01¥Ò\x15Xp\x1C±z\x1F‰™\x1D\x17â"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.