Query Metrics
49
Database Queries
40
Different statements
20.37 ms
Query time
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2.79 ms (13.72%) |
1 |
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, ? REGEXP `old_url_regex` as regex0, ? REGEXP `old_url_regex` as regex2, ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ?) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ?))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex`)))) LIMIT 6;
Parameters:
[ "/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "https://stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" 1 "regex" "/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "https://stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "regex" "/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "https://stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "stage-sw6.radwelt-shop.de/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" ]
|
||||||||||||||||||||||||||||||
2.25 ms (11.05%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.media`.`id` as `product_manufacturer.media.id`, `product_manufacturer.media`.`user_id` as `product_manufacturer.media.userId`, `product_manufacturer.media`.`media_folder_id` as `product_manufacturer.media.mediaFolderId`, `product_manufacturer.media`.`mime_type` as `product_manufacturer.media.mimeType`, `product_manufacturer.media`.`file_extension` as `product_manufacturer.media.fileExtension`, `product_manufacturer.media`.`uploaded_at` as `product_manufacturer.media.uploadedAt`, `product_manufacturer.media`.`file_name` as `product_manufacturer.media.fileName`, `product_manufacturer.media`.`file_size` as `product_manufacturer.media.fileSize`, `product_manufacturer.media`.`media_type` as `product_manufacturer.media.mediaTypeRaw`, `product_manufacturer.media`.`meta_data` as `product_manufacturer.media.metaData`, `product_manufacturer.media`.`config` as `product_manufacturer.media.config`, `product_manufacturer.media`.`path` as `product_manufacturer.media.path`, `product_manufacturer.media`.`private` as `product_manufacturer.media.private`, `product_manufacturer.media`.`thumbnails_ro` as `product_manufacturer.media.thumbnailsRo`, `product_manufacturer.media`.`created_at` as `product_manufacturer.media.createdAt`, `product_manufacturer.media`.`updated_at` as `product_manufacturer.media.updatedAt`, `product_manufacturer.media.translation.title`, COALESCE(`product_manufacturer.media.translation.title`,`product_manufacturer.media.translation.title`) as `product_manufacturer.media.title`, `product_manufacturer.media.translation.alt`, COALESCE(`product_manufacturer.media.translation.alt`,`product_manufacturer.media.translation.alt`) as `product_manufacturer.media.alt`, `product_manufacturer.media.translation.customFields`, COALESCE(`product_manufacturer.media.translation.customFields`,`product_manufacturer.media.translation.customFields`) as `product_manufacturer.media.customFields`, `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation.languageId`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id LEFT JOIN `media` `product_manufacturer.media` ON `product_manufacturer`.`media_id` = `product_manufacturer.media`.`id` LEFT JOIN (SELECT `product_manufacturer.media.translation`.media_id, `product_manufacturer.media.translation`.title as `product_manufacturer.media.translation.title`, `product_manufacturer.media.translation`.alt as `product_manufacturer.media.translation.alt`, `product_manufacturer.media.translation`.custom_fields as `product_manufacturer.media.translation.customFields`, `product_manufacturer.media.translation`.created_at as `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation`.updated_at as `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation`.media_id as `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation`.language_id as `product_manufacturer.media.translation.languageId` FROM `media_translation` `product_manufacturer.media.translation` WHERE `product_manufacturer.media.translation`.language_id = ?) `product_manufacturer.media.media_translation` ON `product_manufacturer.media.media_translation`.`media_id` = `product_manufacturer.media`.`id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ø"Úðµô1a╦ã/;\x1A7n█" b"9\x0Föê\x18„…ˆ\x18\x13¨ätåÅŽ" b""" K½œ#è\x10¡\n )“WêL+”ÿ """ b"¿ëì49█fÔªp)@gÝ´┐" b"D½Îã‚ DÂK§G{3±b\e" b"…~¨ª'cÞ\x1C2öÄÓ·èµ" b"£å:\x18wí\x03¾åÚÛê•k\x00þ" b"q©$tµÄ\x1A@#0ùÜÖ6²ü" b"«ùÍA,¦xêë\f"<Q\x06Æ«" b"ÏŠ?Y«éP"\x11oZflƒgÿ" b"÷ˆ3´\Fó-Y" 6°`b " b"ëä¬!%\x06\x10PêoOaÐÿÁÝ" b"O\x0Eh´\x7FDYl\x1Dl&‚}g³&" b"oøº¶Ö®\x1CÈî,\r\x16°V \e" b"¶6´P\x06ôìõÂ$\fEYý╝½" b"ó,"ÊÂó\x05ÄCÒúÉ\x03V\x08Ì" b"┘\x084Mü╚0\x101E─ƒÇ\x03:Ã" b"Û\x1C‡@-þµÝ\x00¯E˜Ð¢Wº" b"db3\x1AiÍÇ·mÈ\x116Ê'\x13Ý" b"äÚ;\x7F»Î#E×w+\x06t£\x18Õ" b"\x10Ð0|\x11QCëä!&9qu\x1A " b"jÞe•+>†Þu†]1tž;u" b"åL¢\n\x00¸.‘ãÁõq\x06¼‡Î" b"Æ╚\x7FÆë'ü/\x15ê¡Å\x1FÝÍË" b"AY"\x16ÿÎ]vXÞÚ\e~¡I©" b"–È4\x17‘Y›×\x05¥\x16–² \x05" b"åÚ\x13hPúÆN§ùd~atR7" b"ÞL\x01iæ”Oý\g$^Ò|(U" b"Ø\x08E»\x7FË_½”×\x02‹òãE\t" b""" 6$\n └╝'ìí\x10:>§.¾°A """ b"ÁÌ$öâf¡18©ÅSÉ¿ªH" b"–Ž\x12äË°\x08#¥Vû^ñZÛs" b"©S─Ã\x1A©3²NØ┼Y1Øu\x15" b"ä\x10\x0EŽ¹È\tÝN¸ÐT^˜ÞH" b"─uFü=¨Süñ@\x1D¾I Õ|" b"¦y8ž¹—ž\x15òõåÆHTèJ" b"'6\x11\x01§O\x1E߈$ñPÐ;Vž" b"#¶Þwh\x16^ù¦‡˜‡±ç\t´" b"L■>í\x07±iü├åÒ&ù\x7FÚ~" b"9^"â\x16Áv–¸—<Â,ßÿ\x01" b"^─Åc░║#¨,Å·îé\x12s¨" b"4║╩@ì*\x10ÊhÑÉ[ú&aG" b"'HY[\x07‡Í"žÕ)v“nÌS" b"™\x14´¡dSK|Õ©8^£k°ù" b";$°\x05põa<Èpnã—°À" b"Ål©&sÏ~\x7Fñ\x11{×q┌█Y" b"¢”È\f>íåñL–éu6ï\x08\x0E" b""ðÑÛŠKÿáʤQm9\x15ˆ¥" b""" è{*Ùs\x02ŽU\n Ó\ezAÓ-ñ """ b"ˆö\x01…P$7Ö\edʤÈàRÀ" b"ÝÙ<¹ÀN…XÀ¤Û{ÅHíL" b"\vr$ÿ°çk`(\x12âx™Æß\x7F" b"øŸ…i(Qö|¥úþ¼"S[ö" b"¿ya/8û‡#‚Ý‚tŸï\\x07" b"myé\eý\tvv™\x05\x1E¤£€QÃ" b"\x0Fߎæñ˜\x17d\x1Dý¹\x18Åí\r§" b"▒ää\x03iiÅ|7ÓÆ\tC×åã" b"\ewf:Õ}hüe#í¶…\x18G\x19" b"ÊÉ‘ÌGõÈs\x04d\x7Fm†ºM‹" b"‘H#„Ñ\x12ð¼PÿŠ‚W\x06×\x0F" b"┬wØþ\x1E╣ æüÛ(æÚ;╬" b""" ÜÕõ\r"\n ú²¯Ÿ·2Ý›¿ """ b"Í•nt,Wöô1„ßÌ/e«Î" b"`ˆ\x18$•\x143l\x0Eë\x06t{´>" b"~æq\x00ï\v\rX:P9^¯?2…" b">ï¹èļ\x10ªwú`Hg-\x03ª" b"=7\x06'\v¸V±Á·\x11ïÓ^\x08*" b"ËÃ\x1F\x02 0ÍK©Í#hÌzÌÝ" b"ûYJY¥)ìP†\x05gèë[_é" b"ÙxãSðßO$\x04Sáór|˜§" b"¢Â\x1D\x10–XáY\x1Dã‘\x03Ô{¯" b"@ùSafç*ØäAYÇûuW\e" b"\x01m\x08]¥áaG¢°Û…µZß" b"╦│Û~ú├─"\\x13Êà¨NüÈ" b"j´(³\x16±Å\fjÚïÝQŠý\x00" b"\x06S>‡Œ\x07ïÕ\e#Ï4RÛle" b"\x08†Ž¢˜~ü)V«„.\x01ÅÒú" b"~÷\x02†ÏkéÎ\x1Džþÿ®¿ºG" b"…Ÿðzó]@¤é63]b¼²" b""" _QfÁñ7WÇ.\n ¶\x05ÊC p """ b"ÄÊB8 ¹#‚\rÌPšou„›" b"Âø\vÑ\x13¨‚žén·E|dI;" b"J¤\x7FÎ%Åt‰31´5ýÝì×" b"uk>*ïö‘·ÖtÚb•)•\x18" b"\x02q[&Kæ2\r\t ú*„\x1EeQ" b"EÄŒÎ.-\x7F½ê\x1AüQÇÆ&" b"VÙ¹┘Åƨ\x07\x04¾è\x00¥@B\x0E" b"\x14Jò¹j4ÿB´x65ûâci" b"t\x07¨§Ód?\x03Ò:}_\e\x1F\x0E\x00" b"Éí¾§BÓÚ^B¨\x10X\rÞ╗[" b"äÎ"˜[þ\f¨\vÔ\tçî ý" b"È\x1Dî┘Å\x00▓\x04ÚÇ\tÿý°B~" b"…\x02\x01<èE˜J\r#\x0F\æÜWl" b"\x00~\x03µ\f¢Ý\x06Ïî\Š*»ü•" b"ïâ>&U\x0EW«\x1A2;ÞÆ~\x0E÷" b"š)Å'saæ»–žÅÛ¼aû¢" b"ü\x17ºy‹çq¦]¤P€ô†Ã‡" b"Ò‰SÜX;ÛÈì€:Ò9Bi¼" b""" u\e├¬Õ¡¸▓É%×\n ¢õV """ b"ú$m\x02bÃ’V\x17°Ç+²\x0Eë\x1D" b"^Š\x19¹ó[4 ”¢5¾s\x031Ý" b"\x17ÙÏò¬¡KVQþlq\x19Kî" b"│U\x06Ȥ*ì│üX╚├\º2v" b"Áé\x16£_¬‹80ò-èëØðÙ" b"ªØ®ráÇ┬\f«¯èc!ä<Ë" b"\e³S¡ÏÒ¯álÚF;\x07\x1F-ƒ" b"\x16\x04ÜÒUM║&n³╔ø╠<Pü" b"Ôsµ\t\t\x0FÔã\x1E_¦snþ½ï" b"Ѐ‹\x1C7°Ìó:"øȯÃÅ¢" b"骾\rwÕbº\x12+6'#•ng" b"\x11ú0\x16Îö{2暨1’œÊ" b"hj\x08ÐûرGü>ª\x18╦╬v¥" b"\x15ÕÖÔ ïÝá¿:QîÆœ—J" b"\fE©\x01C\x0E-UOS:6ÞR´Ê" b"\x11:€%žê-«ì´ñÓ_Z¯¸" b"2¸Ø?A\x1EÏ\r6 …\rÑÔDª" b"ÈÕ4Ô0§Ä\x14°Y“d¾ØíQ" b""" ¯þßµÅ╚ÕÓ\x1CÆ8òßW\n ¤ """ b"¢òõ`è\x19Ÿ!5ò À\x1AøtJ" b"oÈijDXüÜA%1M║Ø╩Ê" b"ËNù®\x00±‰@d^Iª[–‰Ä" b"\r†K\x0E÷ö o\x14j»Î³Òø\x1A" b"░ÕÈ?ô│U²\x0E¢Å:KåÑ" b"ª\x00³hg`ýñõ@¾l3fb–" b"\x1Ea=Í\x06±û˜.mq^¨ßW" b"ú?Ë›~â\x1DaBiB¹j®3é" b"áøÕé¯}¶ª¶\x157P\x11\x119ü" ] |
||||||||||||||||||||||||||||||
1.85 ms (9.06%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ø"Úðµô1a╦ã/;\x1A7n█" b"9\x0Föê\x18„…ˆ\x18\x13¨ätåÅŽ" b""" K½œ#è\x10¡\n )“WêL+”ÿ """ b"¿ëì49█fÔªp)@gÝ´┐" b"D½Îã‚ DÂK§G{3±b\e" b"…~¨ª'cÞ\x1C2öÄÓ·èµ" b"£å:\x18wí\x03¾åÚÛê•k\x00þ" b"q©$tµÄ\x1A@#0ùÜÖ6²ü" b"«ùÍA,¦xêë\f"<Q\x06Æ«" b"ÏŠ?Y«éP"\x11oZflƒgÿ" b"÷ˆ3´\Fó-Y" 6°`b " b"ëä¬!%\x06\x10PêoOaÐÿÁÝ" b"O\x0Eh´\x7FDYl\x1Dl&‚}g³&" b"oøº¶Ö®\x1CÈî,\r\x16°V \e" b"¶6´P\x06ôìõÂ$\fEYý╝½" b"ó,"ÊÂó\x05ÄCÒúÉ\x03V\x08Ì" b"┘\x084Mü╚0\x101E─ƒÇ\x03:Ã" b"Û\x1C‡@-þµÝ\x00¯E˜Ð¢Wº" b"db3\x1AiÍÇ·mÈ\x116Ê'\x13Ý" b"äÚ;\x7F»Î#E×w+\x06t£\x18Õ" b"\x10Ð0|\x11QCëä!&9qu\x1A " b"jÞe•+>†Þu†]1tž;u" b"åL¢\n\x00¸.‘ãÁõq\x06¼‡Î" b"Æ╚\x7FÆë'ü/\x15ê¡Å\x1FÝÍË" b"AY"\x16ÿÎ]vXÞÚ\e~¡I©" b"–È4\x17‘Y›×\x05¥\x16–² \x05" b"åÚ\x13hPúÆN§ùd~atR7" b"ÞL\x01iæ”Oý\g$^Ò|(U" b"Ø\x08E»\x7FË_½”×\x02‹òãE\t" b""" 6$\n └╝'ìí\x10:>§.¾°A """ b"ÁÌ$öâf¡18©ÅSÉ¿ªH" b"–Ž\x12äË°\x08#¥Vû^ñZÛs" b"©S─Ã\x1A©3²NØ┼Y1Øu\x15" b"ä\x10\x0EŽ¹È\tÝN¸ÐT^˜ÞH" b"─uFü=¨Süñ@\x1D¾I Õ|" b"¦y8ž¹—ž\x15òõåÆHTèJ" b"'6\x11\x01§O\x1E߈$ñPÐ;Vž" b"#¶Þwh\x16^ù¦‡˜‡±ç\t´" b"L■>í\x07±iü├åÒ&ù\x7FÚ~" b"9^"â\x16Áv–¸—<Â,ßÿ\x01" b"^─Åc░║#¨,Å·îé\x12s¨" b"4║╩@ì*\x10ÊhÑÉ[ú&aG" b"'HY[\x07‡Í"žÕ)v“nÌS" b"™\x14´¡dSK|Õ©8^£k°ù" b";$°\x05põa<Èpnã—°À" b"Ål©&sÏ~\x7Fñ\x11{×q┌█Y" b"¢”È\f>íåñL–éu6ï\x08\x0E" b""ðÑÛŠKÿáʤQm9\x15ˆ¥" b""" è{*Ùs\x02ŽU\n Ó\ezAÓ-ñ """ b"ˆö\x01…P$7Ö\edʤÈàRÀ" b"ÝÙ<¹ÀN…XÀ¤Û{ÅHíL" b"\vr$ÿ°çk`(\x12âx™Æß\x7F" b"øŸ…i(Qö|¥úþ¼"S[ö" b"¿ya/8û‡#‚Ý‚tŸï\\x07" b"myé\eý\tvv™\x05\x1E¤£€QÃ" b"\x0Fߎæñ˜\x17d\x1Dý¹\x18Åí\r§" b"▒ää\x03iiÅ|7ÓÆ\tC×åã" b"\ewf:Õ}hüe#í¶…\x18G\x19" b"ÊÉ‘ÌGõÈs\x04d\x7Fm†ºM‹" b"‘H#„Ñ\x12ð¼PÿŠ‚W\x06×\x0F" b"┬wØþ\x1E╣ æüÛ(æÚ;╬" b""" ÜÕõ\r"\n ú²¯Ÿ·2Ý›¿ """ b"Í•nt,Wöô1„ßÌ/e«Î" b"`ˆ\x18$•\x143l\x0Eë\x06t{´>" b"~æq\x00ï\v\rX:P9^¯?2…" b">ï¹èļ\x10ªwú`Hg-\x03ª" b"=7\x06'\v¸V±Á·\x11ïÓ^\x08*" b"ËÃ\x1F\x02 0ÍK©Í#hÌzÌÝ" b"ûYJY¥)ìP†\x05gèë[_é" b"ÙxãSðßO$\x04Sáór|˜§" b"¢Â\x1D\x10–XáY\x1Dã‘\x03Ô{¯" b"@ùSafç*ØäAYÇûuW\e" b"\x01m\x08]¥áaG¢°Û…µZß" b"╦│Û~ú├─"\\x13Êà¨NüÈ" b"j´(³\x16±Å\fjÚïÝQŠý\x00" b"\x06S>‡Œ\x07ïÕ\e#Ï4RÛle" b"\x08†Ž¢˜~ü)V«„.\x01ÅÒú" b"~÷\x02†ÏkéÎ\x1Džþÿ®¿ºG" b"…Ÿðzó]@¤é63]b¼²" b""" _QfÁñ7WÇ.\n ¶\x05ÊC p """ b"ÄÊB8 ¹#‚\rÌPšou„›" b"Âø\vÑ\x13¨‚žén·E|dI;" b"J¤\x7FÎ%Åt‰31´5ýÝì×" b"uk>*ïö‘·ÖtÚb•)•\x18" b"\x02q[&Kæ2\r\t ú*„\x1EeQ" b"EÄŒÎ.-\x7F½ê\x1AüQÇÆ&" b"VÙ¹┘Åƨ\x07\x04¾è\x00¥@B\x0E" b"\x14Jò¹j4ÿB´x65ûâci" b"t\x07¨§Ód?\x03Ò:}_\e\x1F\x0E\x00" b"Éí¾§BÓÚ^B¨\x10X\rÞ╗[" b"äÎ"˜[þ\f¨\vÔ\tçî ý" b"È\x1Dî┘Å\x00▓\x04ÚÇ\tÿý°B~" b"…\x02\x01<èE˜J\r#\x0F\æÜWl" b"\x00~\x03µ\f¢Ý\x06Ïî\Š*»ü•" b"ïâ>&U\x0EW«\x1A2;ÞÆ~\x0E÷" b"š)Å'saæ»–žÅÛ¼aû¢" b"ü\x17ºy‹çq¦]¤P€ô†Ã‡" b"Ò‰SÜX;ÛÈì€:Ò9Bi¼" b""" u\e├¬Õ¡¸▓É%×\n ¢õV """ b"ú$m\x02bÃ’V\x17°Ç+²\x0Eë\x1D" b"^Š\x19¹ó[4 ”¢5¾s\x031Ý" b"\x17ÙÏò¬¡KVQþlq\x19Kî" b"│U\x06Ȥ*ì│üX╚├\º2v" b"Áé\x16£_¬‹80ò-èëØðÙ" b"ªØ®ráÇ┬\f«¯èc!ä<Ë" b"\e³S¡ÏÒ¯álÚF;\x07\x1F-ƒ" b"\x16\x04ÜÒUM║&n³╔ø╠<Pü" b"Ôsµ\t\t\x0FÔã\x1E_¦snþ½ï" b"Ѐ‹\x1C7°Ìó:"øȯÃÅ¢" b"骾\rwÕbº\x12+6'#•ng" b"\x11ú0\x16Îö{2暨1’œÊ" b"hj\x08ÐûرGü>ª\x18╦╬v¥" b"\x15ÕÖÔ ïÝá¿:QîÆœ—J" b"\fE©\x01C\x0E-UOS:6ÞR´Ê" b"\x11:€%žê-«ì´ñÓ_Z¯¸" b"2¸Ø?A\x1EÏ\r6 …\rÑÔDª" b"ÈÕ4Ô0§Ä\x14°Y“d¾ØíQ" b""" ¯þßµÅ╚ÕÓ\x1CÆ8òßW\n ¤ """ b"¢òõ`è\x19Ÿ!5ò À\x1AøtJ" b"oÈijDXüÜA%1M║Ø╩Ê" b"ËNù®\x00±‰@d^Iª[–‰Ä" b"\r†K\x0E÷ö o\x14j»Î³Òø\x1A" b"░ÕÈ?ô│U²\x0E¢Å:KåÑ" b"ª\x00³hg`ýñõ@¾l3fb–" b"\x1Ea=Í\x06±û˜.mq^¨ßW" b"ú?Ë›~â\x1DaBiB¹j®3é" b"áøÕé¯}¶ª¶\x157P\x11\x119ü" ] |
||||||||||||||||||||||||||||||
1.72 ms (8.43%) |
2 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01èÀ\x13Â_\x7FrÉ▒ú§ÒäÒ+" ] |
||||||||||||||||||||||||||||||
1.04 ms (5.12%) |
1 |
# Manufacturer getManufacturer manufacturer::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.media`.`id` as `product_manufacturer.media.id`, `product_manufacturer.media`.`user_id` as `product_manufacturer.media.userId`, `product_manufacturer.media`.`media_folder_id` as `product_manufacturer.media.mediaFolderId`, `product_manufacturer.media`.`mime_type` as `product_manufacturer.media.mimeType`, `product_manufacturer.media`.`file_extension` as `product_manufacturer.media.fileExtension`, `product_manufacturer.media`.`uploaded_at` as `product_manufacturer.media.uploadedAt`, `product_manufacturer.media`.`file_name` as `product_manufacturer.media.fileName`, `product_manufacturer.media`.`file_size` as `product_manufacturer.media.fileSize`, `product_manufacturer.media`.`media_type` as `product_manufacturer.media.mediaTypeRaw`, `product_manufacturer.media`.`meta_data` as `product_manufacturer.media.metaData`, `product_manufacturer.media`.`config` as `product_manufacturer.media.config`, `product_manufacturer.media`.`path` as `product_manufacturer.media.path`, `product_manufacturer.media`.`private` as `product_manufacturer.media.private`, `product_manufacturer.media`.`thumbnails_ro` as `product_manufacturer.media.thumbnailsRo`, `product_manufacturer.media`.`created_at` as `product_manufacturer.media.createdAt`, `product_manufacturer.media`.`updated_at` as `product_manufacturer.media.updatedAt`, `product_manufacturer.media.translation.title`, COALESCE(`product_manufacturer.media.translation.title`,`product_manufacturer.media.translation.title`) as `product_manufacturer.media.title`, `product_manufacturer.media.translation.alt`, COALESCE(`product_manufacturer.media.translation.alt`,`product_manufacturer.media.translation.alt`) as `product_manufacturer.media.alt`, `product_manufacturer.media.translation.customFields`, COALESCE(`product_manufacturer.media.translation.customFields`,`product_manufacturer.media.translation.customFields`) as `product_manufacturer.media.customFields`, `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation.languageId`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id LEFT JOIN `media` `product_manufacturer.media` ON `product_manufacturer`.`media_id` = `product_manufacturer.media`.`id` LEFT JOIN (SELECT `product_manufacturer.media.translation`.media_id, `product_manufacturer.media.translation`.title as `product_manufacturer.media.translation.title`, `product_manufacturer.media.translation`.alt as `product_manufacturer.media.translation.alt`, `product_manufacturer.media.translation`.custom_fields as `product_manufacturer.media.translation.customFields`, `product_manufacturer.media.translation`.created_at as `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation`.updated_at as `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation`.media_id as `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation`.language_id as `product_manufacturer.media.translation.languageId` FROM `media_translation` `product_manufacturer.media.translation` WHERE `product_manufacturer.media.translation`.language_id = ?) `product_manufacturer.media.media_translation` ON `product_manufacturer.media.media_translation`.`media_id` = `product_manufacturer.media`.`id` WHERE (`product_manufacturer`.`version_id` = ?) AND ((`product_manufacturer`.`id` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"È\x1Dî┘Å\x00▓\x04ÚÇ\tÿý°B~" ] |
||||||||||||||||||||||||||||||
0.98 ms (4.82%) |
1 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01ï\x1Ed╗¼yÅûO¹\x0E\x07E\x04ï" b"\x01‹\x1E„¥ðqï¿Ùÿ.‘~&ñ" b"\x01‹\x1E…F'}@§\x13kßeíI½" b"\x01‹\x1E…¸àr©œ8ßDsMŽ" ] |
||||||||||||||||||||||||||||||
0.83 ms (4.06%) |
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/df41b8ba15674e349cacdfff2f86650c" "/navigation/018b227d792f7f719cdcbe4a61f4cdf8" "/navigation/10026ccddbed4da3b2057bf7aac9f4a5" "/navigation/f79fd420473142efbbd7c3bc4aa2f070" "/navigation/fc490ca45c00b1249bbe3554a4fdf6fb" "/navigation/33e75ff09dd601bbe69f351039152189" "/navigation/28dd2c7955ce926456240b2ff0100bde" "/navigation/f033ab37c30201f73f142449d037028d" "/navigation/3295c76acbf4caaed33c36b1b5fc2cb1" "/navigation/9dfcd5e558dfa04aaf37f137a1d9d3e5" "/navigation/950a4152c2b4aa3ad78bdd6b366cc179" "/navigation/3fe94a002317b5f9259f82690aeea4cd" "/navigation/bbf94b34eb32268ada57a3be5062fe7d" "/navigation/4f4adcbf8c6f66dcfc8a3282ac2bf10a" "/navigation/8d3bba7425e7c98c50f52ca1b52d3735" "/navigation/bbcbff5c1f1ded46c25d28119a85c6c2" "/navigation/8cb22bdd0b7ba1ab13d742e22eed8da2" "/navigation/5737c6ec2e0716f3d8a7a5c4e0de0d9a" "/navigation/352fe25daf686bdb4edca223c921acea" "/navigation/d1f255a373a3cef72e03aa9d980c7eca" "/navigation/735b90b4568125ed6c3f678819b6e058" "/navigation/ad13a2a07ca4b7642959dc0c4c740ab6" "/navigation/a3f390d88e4c41f2747bfa2f1b5f87db" "/navigation/a666587afda6e89aec274a3657558a27" "/navigation/40008b9a5380fcacce3976bf7c08af5b" "/navigation/310dcbbf4cce62f762a2aaa148d556bd" "/navigation/018e603168d27b5ba5dfa4eded2b9143" "/navigation/34173cb38f07f89ddbebc2ac9128303f" "/navigation/c16a5320fa475530d9583c34fd356ef5" "/navigation/6364d3f0f495b6ab9dcf8d3b5c6e0b01" "/navigation/182be0c5cdcd5072bb1864cdee4d3d6e" "/navigation/a5771bce93e200c36f7cd9dfd0e5deaa" "/navigation/d67d8ab4f4c10bf22aa353e27879133c" "/navigation/d645920e395fedad7bbbed0eca3fe2e0" "/navigation/3416a75f4cea9109507cacd8e2f2aefc" "/navigation/a1d0c6e83f027327d8461063f4ac58a6" "/navigation/17e62166fc8586dfa4d1bc0e1742c08b" "/navigation/f7177163c833dff4b38fc8d2872f1ec6" "/navigation/6c8349cc7260ae62e3b1396831a8398f" "/navigation/d9d4f495e875a2e075a1a4a6e1b9770f" "/navigation/e369853df766fa44e1ed0ff613f563bd" "/navigation/0deb1c54814305ca9ad266f53bc82511" "/navigation/66808e327dc79d135ba18e051673d906" "/navigation/19ca14e7ea6328a42e0eb13d585e4c22" "/navigation/1c383cd30b7c298ab50293adfecb7b18" "/navigation/a5bfc9e07964f8dddeb95fc584cd965d" "/navigation/67c6a1e7ce56d3d6fa748ab6d9af3fd7" "/navigation/642e92efb79421734881b53e1e1b18b6" "/navigation/f457c545a9ded88f18ecee47145a72c0" "/navigation/72b32a1f754ba1c09b3695e0cb6cde7f" "/navigation/cf004fdc76fa1a4f25f62e0eb5261ca3" "/navigation/66f041e16a60928b05a7e228a89c3799" "/navigation/093f65e080a295f8076b1c5722a46aa2" "/navigation/072b030ba126b2f4b2374f342be9ed44" "/navigation/c0c7c76d30bd3dcaefc96f40275bdc0a" "/navigation/2838023a778dfaecdc212708f721b788" "/navigation/9a1158154dfa42caddbd0694a4e9bdc8" "/navigation/14bfa6bb14875e45bba028a21ed38046" "/navigation/7cbbc409ec990f19c78c75bd1e06f215" "/navigation/6855456e2fe46a9d49d3d3af4f57443d" "/navigation/41ae36ecb9b3eee609d05b90c14222fb" "/navigation/bd686fd640be98efaae0091fa301e613" "/navigation/289dff07669d7a23de0ef88d2f7129e7" "/navigation/a4f23670e1833f3fdb077ca70bbd5d66" "/navigation/577ef1154f3240ad5b9b413aa7346a1e" "/navigation/c5ff2543b53f4cc0ad3819a36752467b" "/navigation/0bb4aec1710521c12ee76289d9440817" "/navigation/854d6fae5ee42911677c739ee1734486" "/navigation/01386bd6d8e091c2ab4c7c7de644d37b" "/navigation/35f4a8d465e6e1edc05f3d8ab658c551" "/navigation/f7664060cc52bc6f3d620bcedc94a4b6" "/navigation/13f9896df61279c928f19721878fac41" "/navigation/8f121ce07d74717e0b1f21d122e04521" "/navigation/39059724f73a9969845dfe4146c5660e" "/navigation/7f100b7b36092fb9b06dfb4fac360931" "/navigation/9872ed9fc22fc182d371c3e9ed316094" "/navigation/31fefc0e570cb3860f2a6d4b38c6490d" "/navigation/0aa1883c6411f7873cb83dacb17b0afc" "/navigation/fb7b9ffa5462084c5f4e7e85a093e6d7" "/navigation/9dcb88e0137649590b755372b040afad" "/navigation/a2557a7b2e94197ff767970b67041697" "/navigation/58a2fc6ed39fd083f55d4182bf88826d" "/navigation/9fc3d7152ba9336a670e36d0ed79bc43" "/navigation/3988c7f88ebcb58c6ce932b957b6f332" "/navigation/1385974ed5904a438616ff7bdb3f7439" "/navigation/9de6d14fff9806d4bcd1ef555be766cd" "/navigation/903ce9225fca3e988c2af215d4e544d3" "/navigation/0a09c8844ba8f0936c20bd791130d6b6" "/navigation/02522a2b2726fb0a03bb19f2d8d9524d" "/navigation/8d5e957f297893487bd98fa830fa6413" "/navigation/357a6fdf7642bf815a88822c447d9dc4" "/navigation/a49e9411d64ff53eccfdd09ad10a15b3" "/navigation/e2ef524fbf3d9fe611d5a8e90fefdc9c" "/navigation/140f6969d5213fd0ece03148e62e461e" "/navigation/36660e59856b4de58a219bcf4e27eba3" "/navigation/e96ed478dab8595a7dbda4cbcbee168f" "/navigation/f340f1b1f65b6df5b5e3f94d95b11daf" "/navigation/d1fe173d08e959397adf34b1d77e88d7" "/navigation/43ec517d68b6edd3015b3edc9a11367b" "/navigation/9778d5d219c5080b9a6a17bef029331c" "/navigation/c7e1249ffc03eb9ded908c236bd1996d" "/navigation/fe9fc289c3ff0af142b6d3bead98a923" "/navigation/26657d5ff9020d2abefe558796b99584" "/navigation/82cec96096d4281b7c95cd7e74623496" "/navigation/d1f491a404d6854880943e5c3cd9ca25" "/navigation/819f46e52c25763a55cc642422644317" "/navigation/13fe9d84310e77f13a6d184dbf1232f3" "/navigation/eddea82ad2755b24c4e168c5fc2ebd40" "/navigation/cb70ab375662576bd1ac5aaf16b3fca4" "/navigation/1d7f7abc18fcb43975065399b0d1e48e" "/navigation/e4a6222cdb5b34375400904f03d8e6a5" "/navigation/37bc2f75bf1bcfe8450a1a41c200364c" "/navigation/496e05e1aea0a9c4655800e8a7b9ea28" "/navigation/6faa8040da20ef399b63a72d0e4ab575" "/navigation/816b112c6105b3ebd537828a39af4818" "/navigation/b83aac23b9528732c23cc7352950e880" "/navigation/d947bf06a885db0d477d707121934ff8" "/navigation/63923f49e5241343aa7acb6a06a751e7" "/navigation/0f49c89d1e7298bb9930789c8ed59d48" "/navigation/16a5cdae362b8d27a1d8f8c7b78b4330" "/navigation/5a4b25aaed25c2ee1b74de72dc03c14e" "/navigation/d395771085aab05244a4fb8fd91bf4ee" "/navigation/839ab46820b524afda05122893c2fe8e" "/navigation/1700002963a49da13542e0726b7bb758" "/navigation/49182f81e6a13cf5eaa496d51fea6406" "/navigation/a01a0380ca3c61428c26a231f0e49a09" "/navigation/18d8042386b79e2c279fd162df0205c8" "/navigation/69cb3ea317a32c4e6143e665fdb20b14" "/cbax/manufacturer/index" "/cbax/manufacturer/detail/4bbd9c23e810a10a299357ea4c2b94ff" "/cbax/manufacturer/detail/a8898d3439db66e2a670294067edefbf" "/cbax/manufacturer/detail/44bdcee382a044c24ba7477b33b1621b" "/cbax/manufacturer/detail/857ea8aa2763de1c32f6adc4d3b7e8b5" "/cbax/manufacturer/detail/a3e53a1877ed03bee5dadbea956b00fe" "/cbax/manufacturer/detail/71b82474e68e1a402330979a9936fd81" "/cbax/manufacturer/detail/abf9cd412ca678eaeb0c223c5106c6ab" "/cbax/manufacturer/detail/cf8a3f59abe95022116f5a666c8367ff" "/cbax/manufacturer/detail/f78833b45c46f32d5922a036b06062a0" "/cbax/manufacturer/detail/ebe4ac2125061050ea6f4f61d0ffc1dd" "/cbax/manufacturer/detail/2748595b0787cd229ed52976936ecc53" "/cbax/manufacturer/detail/9914b4a164534b7cd5a9385ea36bb0f9" "/cbax/manufacturer/detail/3b24adb00570f5613cc8706ee397b0c0" "/cbax/manufacturer/detail/8f6cb82673d87e7fa4117b9e71dadb59" "/cbax/manufacturer/detail/a294c80c3eede5f14c96e97536ef080e" "/cbax/manufacturer/detail/22f0d1db8a4bffe1caa4516d391588a5" "/cbax/manufacturer/detail/e87b2ad973028e550ad31b7a41d32df1" "/cbax/manufacturer/detail/88f60185502437d61b64caa4c8e052c0" "/cbax/manufacturer/detail/ddd93cb9c04e8558c0a4db7bc548ed4c" "/cbax/manufacturer/detail/0b7224ffb0e76b602812e27899c6df7f" "/cbax/manufacturer/detail/859ff07af35d40a4e936ad335d62bcb2" "/cbax/manufacturer/detail/5f5166c1f13757c72e0ab605ca43a070" "/cbax/manufacturer/detail/c4ca4238a0b923820dcc509a6f75849b" "/cbax/manufacturer/detail/c2f80bd113a8829ee96eb7457c64493b" "/cbax/manufacturer/detail/4aa47fce25c574893331b435fdddecd7" "/cbax/manufacturer/detail/756b3e2aeff691b7d674da6295299518" "/cbax/manufacturer/detail/02715b264be6320d09a0fa2a841e6551" "/cbax/manufacturer/detail/45c48cce2e2d7fbdea1afc51c7c6ad26" "/cbax/manufacturer/detail/56ebfbd98f92f90704f38a00be40420e" "/cbax/manufacturer/detail/144af2b96a34ff42b4783635fbe26369" "/cbax/manufacturer/detail/11fa3016cef67b32c3a69aa831929cca" "/cbax/manufacturer/detail/686a08d1969df147813ea618cbce76be" "/cbax/manufacturer/detail/15d5d6d420efdde1bf3a51eec69c974a" "/cbax/manufacturer/detail/0c45a901430e2d554f533a36de52b4ca" "/cbax/manufacturer/detail/113a80259eea2dabecb4f1d35f5aafb8" "/cbax/manufacturer/detail/32b8d83f411ecf0d3620850dd1d444aa" "/cbax/manufacturer/detail/c8d534d430a7c414b0599364bed8ed51" "/cbax/manufacturer/detail/eee7e1e68fc8e5e01c923895e1570acf" "/cbax/manufacturer/detail/a2f2f560e8199f2135f220c01af8744a" "/cbax/manufacturer/detail/6fd4696a4458819a4125314dba9dcad2" "/navigation/76d6a1a64bf74ee4a9a5c7a9ea81ff74" "/navigation/6ac18b0184b3472081d23c6cd0d3be6c" "/navigation/b5cd3fd52922492086dd9e6ecd2bdd08" "/navigation/376550aa4fad477d83174e95f685ad1f" "/navigation/cdbbb71db836462f817b5d5a17b396e9" "/navigation/6fa6434adc0e4725bf4dc803abea1d07" "/navigation/0e99b11ddff84bb5a3c3f03ba80c4652" "/navigation/481dcdf7f3a54443987980964e9a1ca3" "/navigation/1aa59333e7a04ba2ba93897cc60f8554" "/navigation/32179757e8974da692a79af3f6b969f5" "/landingPage/018a4565d4d7781396db135e242125ff" "/navigation/2f500e3e758341aa9b9d7595d40828fd" "/navigation/6ffaa09bc4534c6cb5761cbd54e16519" "/navigation/514eeeca73964ea2a6a289046ec7b626" "/navigation/b70da7099682416db74698c21feb6794" "/navigation/f9cb4618268d4a76b8085a5ea63ada80" "/navigation/f3da3ade5d2a4072b3ff8ebf04258029" "/cbax/manufacturer/detail/9d22e9d0e6933161cbc62f3b1a376edb" "/cbax/manufacturer/detail/390ff6ea188485881813a8e474e5c58e" "/cbax/manufacturer/detail/4f0e68b47f44596c1d6c26827d67b326" "/cbax/manufacturer/detail/6ff8bab6d6ae1cc8ee2c0d16b056201b" "/cbax/manufacturer/detail/f436ef5006938de4b6240c4559ecbcab" "/cbax/manufacturer/detail/f32c22cac2f305c443d2fac9035608cc" "/cbax/manufacturer/detail/d908344d81c830103145c49f80033ac7" "/cbax/manufacturer/detail/db1c87402dfeb5dd00af4598d0a257ba" "/cbax/manufacturer/detail/6462331a69cdc7b76dc81136ca2713dd" "/cbax/manufacturer/detail/e4da3b7fbbce2345d7772b0674a318d5" "/cbax/manufacturer/detail/10d0307c115143ebe421263971751a20" "/cbax/manufacturer/detail/6ade65952b3e86de75865d31749e3b75" "/cbax/manufacturer/detail/e54ca20a00b82e91e3c1f57106bc87ce" "/cbax/manufacturer/detail/92c87f928927812f1588ad8f1fedd6d3" "/cbax/manufacturer/detail/41592216ffce5d7658deda1b7ea149a9" "/cbax/manufacturer/detail/96c388341791599bd705a51696b2a005" "/cbax/manufacturer/detail/e5da136850fac64ea7f9647e61745237" "/cbax/manufacturer/detail/de4c0169e6944ffd5c67245ed27c2855" "/cbax/manufacturer/detail/d80845bb7fcb5fbd94d7028bf2e34509" "/cbax/manufacturer/detail/36240ac0bc278da1103a3ef52ef3f841" "/cbax/manufacturer/detail/b5de24948366ad3138b88f5390a8a648" "/cbax/manufacturer/detail/968e12e4cbb00823a556fb5ef15adb73" "/cbax/manufacturer/detail/b853c4c71ab833fd4e9dc559319d7515" "/cbax/manufacturer/detail/e4100e8eb9c809dd4eb8d0545e98de48" "/cbax/manufacturer/detail/c47546813df95381a4401df34920e57c" "/cbax/manufacturer/detail/a679389eb9979e15f2f5e5c64854e84a" "/cbax/manufacturer/detail/27361101a74f1edf8824f150d03b569e" "/cbax/manufacturer/detail/23b6de7768165ef9a6879887b1e709b4" "/cbax/manufacturer/detail/4cfe3ea107f16981c386e326977fe97e" "/cbax/manufacturer/detail/395e22e216c17696b8973cc22cdfff01" "/cbax/manufacturer/detail/5ec48f63b0ba23f92c8ffa8c821273f9" "/cbax/manufacturer/detail/34baca408d2a10d268a5905ba3266147" "/cbax/manufacturer/detail/f89f85692851f67ca5fafebc22535bf6" "/cbax/manufacturer/detail/bf79612f38fb872382dd82749fef5c07" "/cbax/manufacturer/detail/6d79e91bfd09767699051ea4a38051c3" "/cbax/manufacturer/detail/0fdf8ee6f19817641dfdb918c5ed0da7" "/cbax/manufacturer/detail/b184840369698f7c37e09209439e86c6" "/cbax/manufacturer/detail/1b77663ad57d68fc6523edb685184719" "/cbax/manufacturer/detail/cac991cc47f5c87304647f6d86ba4d8b" "/cbax/manufacturer/detail/91482384d112f0bc50ff8a825706d70f" "/cbax/manufacturer/detail/c2779de71eb9ff9181eaf02891e93bce" "/cbax/manufacturer/detail/dcd5f50d22ad0afab2af9fb732dd9bbf" "/cbax/manufacturer/detail/cd956e742c57f6f43184dfcc2f65abce" "/cbax/manufacturer/detail/60cb8618249514336c0eeb06747bb43e" "/cbax/manufacturer/detail/7ee67100ef0b0d583a50395eaf3f3285" "/cbax/manufacturer/detail/3eefb9e8c4bc10aa77fa6048672d03aa" "/cbax/manufacturer/detail/3d3706270bb856b1c1b711efd35e082a" "/cbax/manufacturer/detail/cbc31f02a030cd4ba9cd2368cc7accdd" "/cbax/manufacturer/detail/fb594a59a529ec50860567e8eb5b5fe9" "/cbax/manufacturer/detail/d978e353f0df4f240453e1f3727c98a7" "/cbax/manufacturer/detail/a2c21d109658c3a1591de39103d47baf" "/cbax/manufacturer/detail/40f9536166e72ad8e44159c7fb75571b" "/cbax/manufacturer/detail/ad016d085da5e16147a2b0db85b55adf" "/cbax/manufacturer/detail/cbb3ea7ea3c3c4225c13d285f94e81d4" "/cbax/manufacturer/detail/6ab428b316b1c50c6adaefdd518afd00" "/cbax/manufacturer/detail/06533e878c07efd51b23cf3452db6c65" "/cbax/manufacturer/detail/08868ea2987efc2956ab842e01c5d2fa" "/cbax/manufacturer/detail/7ef70286cf6be9ce1d9efeffaebfba47" "/cbax/manufacturer/detail/7407a8a7d3643f03d23a7d5f1b1f0e00" "/cbax/manufacturer/detail/90a1f3f542e0e95e42f910580de8bb5b" "/cbax/manufacturer/detail/c3a4ce22985bfe0ca80bd409e7ee20fd" "/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "/cbax/manufacturer/detail/8502013ce845984a0d230f5ce6dc576c" "/cbax/manufacturer/detail/007e03b50ca2dd06cfee5c8a2abbfc95" "/cbax/manufacturer/detail/efe23e26550e57ab1a323bdec67e0ef7" "/cbax/manufacturer/detail/9a29c5277361e6bb969ec5dbbc61fba2" "/cbax/manufacturer/detail/fc17ba798be771a65da45080f486c387" "/cbax/manufacturer/detail/d28953dc583bdbc8ec803ad2394269bc" "/cbax/manufacturer/detail/751bc3aae5adf7b290259e0abde4f056" "/cbax/manufacturer/detail/fa246d0262c3925617b0c72bb20eeb1d" "/cbax/manufacturer/detail/5e8a19b9f35b342094a235be730331dd" "/cbax/manufacturer/detail/17d9cff2aca14b5651adfe6c71194bee" "/cbax/manufacturer/detail/b35506d4cf2a8db38158c8c35ca73276" "/cbax/manufacturer/detail/c1e916a35fac8b3830f22de8ebd8f0d9" "/cbax/manufacturer/detail/a69da972a080c20caeee8a6321843cd3" "/cbax/manufacturer/detail/1bb353a1cfd2afe16cda463b071f2d83" "/cbax/manufacturer/detail/16049ae3554dba266efcc99bcc3c5081" "/cbax/manufacturer/detail/d473b509090fd4e31e5fa6736efebdef" "/cbax/manufacturer/detail/d0808b1c37b0ccf33a22f8c8afc3c5a2" "/cbax/manufacturer/detail/e9aabe0d77d562ba122b362723956e67" "/cbax/manufacturer/detail/cb4ef9ae00b18940645e49aa5b9689c4" "/cbax/manufacturer/detail/0d864b0ef7f6206f146abbceb3d2f81a" "/cbax/manufacturer/detail/b0e5f0d43f93b355fd0ebd8f3a4b86a5" "/cbax/manufacturer/detail/aa00b3686760fdf1f540be6c33666296" "/cbax/manufacturer/detail/1e613dcd06adb1fb982e6d715ea8df57" "/cbax/manufacturer/detail/fa3fcb9b7ee21d61426942b96aae33e9" "/cbax/manufacturer/detail/e1f8d5e9af7db6aab6153750111139fc" "/navigation/018a685be96f7db891bcc2c1b5624790" "/navigation/018a685c4d6a727eb8c8b0607c5fdc34" "/navigation/018a685d6f887ddd96b1fc32f074fc45" "/navigation/018a685dd5117b59a78e507c94b046c3" "/navigation/174e6ad734ab403abbccba761868f03a" "/navigation/7698c7806a2b4c93b4beac1cccc5431e" "/navigation/6e355d018d19491a92c3c7628185932c" "/navigation/d2375b3fb5ed4247a58ddcc97aad1a44" "/navigation/3df26b12819d4725995e5a930a2de526" "/navigation/bc41d588c9f54f70b76cd1a6d52023b6" "/navigation/6e5293e04f2f414cb4ec33c894df6948" "/navigation/434b6b89aaef4df9a574c26253117bfd" "/navigation/3fde9c65ad334285a4783d0c642c5cba" "/navigation/4b3cc5d817784bde9846b23b574406a2" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
0.75 ms (3.69%) |
2 |
SELECT seo_path_info FROM seo_url WHERE language_id = ? AND sales_channel_id = ? AND route_name = ? AND path_info = ? AND is_deleted = ? AND is_canonical = ? LIMIT 1;
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "frontend.cbax.manufacturer.index" "/cbax/manufacturer/index" 0 1 ] |
||||||||||||||||||||||||||||||
0.72 ms (3.55%) |
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"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" "cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e/" ] |
||||||||||||||||||||||||||||||
0.44 ms (2.15%) |
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 (2.04%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "tkjBlVGR7XRGiK0nBTOGC22J1uctub6U" ] |
||||||||||||||||||||||||||||||
0.41 ms (2.02%) |
3 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||||||||||||||
0.41 ms (2.00%) |
2 |
# Manufacturer getManufacturerByChar manufacturer::search-ids SELECT `product_manufacturer`.`id` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE `product_manufacturer`.`version_id` = ? ORDER BY COALESCE(`product_manufacturer.translation.name`) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||||||||
0.40 ms (1.97%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||||||||
0.38 ms (1.88%) |
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"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "/cbax/manufacturer/detail/d41d8cd98f00b204e9800998ecf8427e" ] |
||||||||||||||||||||||||||||||
0.33 ms (1.62%) |
3 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||||||||
0.31 ms (1.51%) |
1 |
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰NÒÃûsú´¶½\x03Dh{â" b""" \x01‰NÓ\n ¸q豬ÿJÎ%\x03: """ b""" \x01‰NÓ\n ºr\x17•j\z€úƒ> """ b""" \x01‰NÓ\n »r\x06 Ù½¿UÀå\x19 """ b""" \x01ëNË\n ╝rØÜ0.BÞçR█ """ b""" \x01ëNË\n ╝rØÜ0.BÚ+\t╠ """ b"\x01ëdch?p\x06ÅÁôòjÈh®" b"\x01‰dg§Ðq?¼÷7„\x01l9¾" b"\x01‰dg§Ðq?¼÷7„\x027€" b"\x01‰dg§Ðq?¼÷7„\x02æ\x16\x03" b"\x01‰dg§Ðq?¼÷7„\x03=‹u" b"\x01‰dg§Ðq?¼÷7„\x04ŸµÛ" b"\x01‰dg§Ðq?¼÷7„\x04´\x17" b"\x01‰dg§Ðq?¼÷7„\x05ÆÏç" b"\x01‰dg§Ðq?¼÷7„\x06YRõ" b"\x01‰dg§Ðq?¼÷7„\x07:ײ" b"\x01‰dg§Ðq?¼÷7„\x08\x01\x03ß" b"\x01Œ «\x1DŠ\x7F®‡Ì¤@œ\x1D•\x12" b"\x01Ä\x07ø[¢q ØÊk<┤\x06ÝZ" b"\x01Ä\x18eÒËs7ÿ=IØ\x02\x1688" b"\x01Ž1Ë‘Tq˜Ÿ—D „„Ûö" b"\UùŠ9my!eE^\x07Š<_" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
0.30 ms (1.50%) |
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.30 ms (1.45%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "EasyCreditRatenkauf.config.%" ] |
||||||||||||||||||||||||||||||
0.26 ms (1.28%) |
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‰NÒÃùrXƒý>,˜\n Úª """ b"\x01ëNÊ├■r>×~gÉ╗b¡┴" b"\x01‰NÒÆ1psŠÁû\x06âù£Ï" b"\x01‰NÒÄ\vsç¢y%ý±g\x01«" b"\x01‹)\x15Ü\x11uošã3\x1D‹#½å" b"\x01‹4Lˆ0q¼€£P›Ä\x041@" b"\x01‹4MV1|B¿D»s6—2D" b"\x01‹4O[ }š˜¸l[ÇÑA\n" b"\x01‹4P\x0E…zã«\x1CÿÏ\x15”×{" b"\x01‹8ܱ9rm§çö/¯ñ`ú" b"\x01‹8áNw~8š8ŒÙ\x17\@Ì" b"\x01‹®\x1Di¼u±ª‚\x03\x16«â\x11ò" b"\x01‹×?\t×pU•ºÿ,Œù"\x03" b"\x01Œ\x15¸Þœp•™ßvŒ¶¢$¾" b"\x01î\x19¨ê¬|±║Åöc╦9\x04è" b"äNg‚ÆBG·–¸‘Ï%®8÷" ] |
||||||||||||||||||||||||||||||
0.25 ms (1.20%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"tkjBlVGR7XRGiK0nBTOGC22J1uctub6U"
]
|
||||||||||||||||||||||||||||||
0.24 ms (1.20%) |
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`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||') FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `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`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` 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` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
0.23 ms (1.13%) |
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.22 ms (1.07%) |
3 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||||||||
0.21 ms (1.02%) |
1 |
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters:
[] |
||||||||||||||||||||||||||||||
0.21 ms (1.01%) |
1 |
# Manufacturer getCmsPage::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.language_id = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01ŠùàP2s²‰x+û#Y\x1A\x02" b"\x01è¨Õü\x00u:ç\x12\x02Ýi\x03dù" ] |
||||||||||||||||||||||||||||||
0.20 ms (0.97%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
0.20 ms (0.97%) |
1 |
# finsearch-config::load::search-ids SELECT `finsearch_config`.`id` FROM `finsearch_config` WHERE ((`finsearch_config`.`sales_channel_id` = ? AND `finsearch_config`.`language_id` = ?)) ORDER BY `finsearch_config`.`sales_channel_id` ASC, `finsearch_config`.`id` ASC LIMIT 500
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
0.19 ms (0.93%) |
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Æ2:«ðt═®®»½ø\x13ÄÉ"
]
|
||||||||||||||||||||||||||||||
0.19 ms (0.91%) |
1 |
# Manufacturer getCmsPage::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.language_id = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01è¨ÓP)q\x0EÁö└É▒\x0F*▓" ] |
||||||||||||||||||||||||||||||
0.18 ms (0.90%) |
1 |
# Manufacturer getCmsPage::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, COALESCE(`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields`, `cms_page.translation.createdAt`, `cms_page.translation.updatedAt`, `cms_page.translation.cmsPageId`, `cms_page.translation.languageId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id as `cms_page.translation.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.language_id = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = ?) AND ((`cms_page`.`id` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01è¨ÓP)q\x0EÁö└É▒\x0F*▓" ] |
||||||||||||||||||||||||||||||
0.16 ms (0.80%) |
1 |
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id` WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"¸©Å╔└\x10G\x02®ofM½■&V" true ] |
||||||||||||||||||||||||||||||
0.15 ms (0.75%) |
1 |
# Manufacturer getCmsPage::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01ŠùàP2s²‰x+û$0l_" b"\x01ŠùàP2s²‰x+û$¦Øé" b"\x01ŠùàP2s²‰x+û%š\x13Â" b"\x01ŠùàP2s²‰x+û'@Õ€" b"\x01Šùà{›q¨¿Á!Ìð\x10µ#" ] |
||||||||||||||||||||||||||||||
0.13 ms (0.66%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||||||||
0.13 ms (0.63%) |
1 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ?)
Parameters:
[
"Netzkollektiv\EasyCredit\Payment\Handler"
]
|
||||||||||||||||||||||||||||||
0.13 ms (0.63%) |
1 |
# finsearch-config::load::read SELECT `finsearch_config`.`id` as `finsearch_config.id`, `finsearch_config`.`configuration_key` as `finsearch_config.configurationKey`, `finsearch_config`.`configuration_value` as `finsearch_config.configurationValue`, `finsearch_config`.`sales_channel_id` as `finsearch_config.salesChannelId`, `finsearch_config`.`language_id` as `finsearch_config.languageId`, `finsearch_config`.`created_at` as `finsearch_config.createdAt`, `finsearch_config`.`updated_at` as `finsearch_config.updatedAt` FROM `finsearch_config` WHERE `finsearch_config`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x01‹\x04—pÄr¿¦\t¢šR²E·" b"\x01ï\x04ùp╠rÂáôârÅB§Ä" b"\x01‹\x04—pÏs„VD´\x06\x11›O" b"\x01ï\x04ùpËq~ú2¬rÌþ\x05Ø" b"\x01‹\x04—pÕp˜…þæ;"öI€" b"\x01‹\x04—p×p\x0FŽ8¥ø0_í¸" b"\x01ï\x04ùp┘rÔüt\x02┐-/á╝" b"\x01ï\x04ùu!s$ü¤<×■^~4" b"\x01‹\x04—u(qÔ½¬TQ\x061¹2" b"\x01‹A\x05¾ÜqU®,/\x18êf>“" b"\x01‹A\x05¾ÝsE‘£µ\v®#4W" b"\x01‹KDÃ-r<•ž\x00L\nÑR\x13" ] |
||||||||||||||||||||||||||||||
0.12 ms (0.59%) |
1 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||||||||||||||
0.12 ms (0.58%) |
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.12 ms (0.57%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
0.11 ms (0.53%) |
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‰R&g\x0Er¤¡_7\x1AÜâ—" b"\x01‰NÒâq囩±â4Rú¤" ] |
Database Connections
Name | Service |
---|---|
0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.