# seo_url::replacementSELECTseo_path_info,path_info,sales_channel_idFROMseo_urlWHERE (seo_url.is_canonical=1) AND (seo_url.path_infoIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (seo_url.language_id=?) AND (seo_url.sales_channel_id=?ORseo_url.sales_channel_idISNULL) AND (seo_url.is_deleted=0)
# seo_url::replacementSELECTseo_path_info,path_info,sales_channel_idFROMseo_urlWHERE
(seo_url.is_canonical=1)
AND (
seo_url.path_infoIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
AND (seo_url.language_id=?)
AND (
seo_url.sales_channel_id=?ORseo_url.sales_channel_idISNULL
)
AND (seo_url.is_deleted=0)
# seo_url::replacementSELECTseo_path_info,path_info,sales_channel_idFROMseo_urlWHERE (seo_url.is_canonical=1) AND (seo_url.path_infoIN ('/navigation/01918e4757337158a5d95ed3b53a109d','/navigation/01918e44035c7dc4a99bc47f495a0711','/navigation/01918e441648700e84ab007847d14512','/navigation/0197b0e006967583a7245f4339110739','/navigation/01918e4433887438a3185dfc267b9174','/navigation/01918e4448a17cb7a6646183e26966fd','/navigation/01918e4464247aa5bb2372768ea01664','/navigation/01918e4473d2731eade248d232e85ad9','/navigation/01918e46601f7eab9c3a08cb62266585','/navigation/01918e46f43b76e490998278ab83a15e','/navigation/01918e4733ab7ce4a04db008d6a0571e','/navigation/01918e473c867224a4cd794a3490c061','/navigation/01918e477ca57fc0a0939f9d671ba749','/navigation/01918e47a64570b59e89994cd433f4d1','/navigation/01918e47bf7374f7b87f760ad53a6f9f','/navigation/01918e47d74f74c2aedd9ad470bb4737','/navigation/0191ee9a80f5792aa4470bc1bb7ddabd','/navigation/01936d7a6944779cb990d593d7d9b140','/navigation/01936d7b874370fa909a2becef1ac7f3','/navigation/01936d7badff7c64aece3984ce06f2c7','/navigation/01936d7bdb987601b94de98ae7052632','/navigation/01936d7c04c47d08af4b053e0605b585','/navigation/0197b1c1191b74fb913d877e813e9a33','/navigation/0197b1d5eefe74abbe9ec5ee2606a746','/navigation/0197b1d662ba7f6eab0d5b1e1cd0e781','/navigation/0197b1d741c77750808bb080c573fb3e','/navigation/0197b1c1616279c9a4d8e781cbf173cf','/navigation/0197b1defcd8701ebb59303fe3ee4e79','/navigation/0197b1e740ce74b3b95fa94eb90d6482','/navigation/0197b212ee197f59aba350173d0f3870','/navigation/0197b213d68170518b54ec3e38fa07c7','/navigation/0197b213f7187e429075394413321bad','/navigation/0197b1e7605170709081ec0aeb90cca7','/navigation/0197b228d5577f7196f05c286b6607de','/navigation/0197b22a1f0c7d9a97bc1e3859bb6740','/navigation/0197b22a2dad7566a2eda9c10bc43d14','/navigation/0197b22a3664705db9413337a7a2dd63','/navigation/0197b22a3a3f7957be91e796f89378b9','/navigation/0197b22a45e6768d82b1b08c10a3a7fe','/navigation/0197b22a4c8f7054bfddd2570ea510eb','/navigation/0197b22a3e767cb1a01f7ee9c5ec7457','/navigation/0197b22a426d7966ba8e1f01a46eefbf','/navigation/0197b22967937c8387711229c2ba42f6','/navigation/0197b22d432c7aa18713d9633996a846','/navigation/0197b22d5c18798ca5d6235a91ae9faa','/navigation/0197b22d617977b1b4bcd1907752f260','/navigation/0197b22d670b79859e22dafbc6a8361e','/navigation/0197b22d6a9e7827acd9a4db7458b21a','/navigation/0197b22d6d5f7c899774d5c5a00c4431','/navigation/0197b22d72767ff4adffaa731821c543','/navigation/0197b22d756c71bca58843309235dcb3','/navigation/0197b22d784d716684949235c56d44d1','/navigation/0191ee9ae9317bd79b501cffd3fb613e','/navigation/0197d0fd7b077c55b800312ed2c2cf29','/navigation/0191ee9b16a97cc9a147cd4449f46348','/navigation/0191ee9b239e7c9181e6964082608c6b','/navigation/0191ee9b38a0746aa93998ef15d3fe6c','/navigation/0191ee9b475670c983a8fc836aa5cc22','/navigation/0191ee9b55af7827a4968f0e9846b94d','/navigation/0191ee9d0a8e741d8bd582aac09faa8f','/navigation/0191ee9ce967784a97d4bbe54c5ea62f','/navigation/019909cb27c97a0ead2c5b9206adefb4','/navigation/0191ee9d1b347e3481f4071ff5017ee8','/navigation/0191ee9e54a076ddaa4463979f50a4a7','/navigation/0191ee9e6a3b7f28b0b45df9da9cc4c0','/navigation/0191ee9e7b6d7435858c66f429866305','/navigation/0191ee9eaa9c75ba8a3843b3ce4fa334','/navigation/0191ee9ecac979659c233713313910fb','/navigation/0191ee9fac45736e8d462a8a87cc0a31','/navigation/0191ee9fc09d7248bdf68188b88be38a','/navigation/0191ee9fc9117f43a3303ae736f72e6c','/detail/225d65df8675436fc6a39f61ce19916d','/detail/c825e40bebb52bb8b27b5aa2bb4044a1','/detail/1c665bd2fe0f886c7cd3b1b683a5f5d3','/detail/ea894288b0b7ada588f84cdd968e64a2','/detail/4a5d9437fbdf7a6eab08831f8ccce708','/detail/0ecbb1b9cbc9766d9b812dba379c94b8','/detail/c404fa685b5b38c25dff74a556a208ef','/detail/9579c0b2fa9945a274476562c60591fc','/detail/38f7ca7dacfef20c12039b125c0779fa','/detail/dc4c07689228aeae0f20c4e9b411574d','/detail/336db6112733ba3a1b7c2a8062ab391c','/detail/2b70654a9412e914eefc7a0e5db7e46d','/detail/482130cae1fba855d2e4293eccad622d','/detail/9bcc3809aa5140c56ae3436a24590dab','/detail/e7a8e3b468d2c76d81fa05dcb7b31ac7','/detail/eb7403d2f886f420b6907348dfac02d3','/detail/a39103bf60db010de6e8766b11687521','/detail/8c5a8960b7f5a949ec305ce005fedbc0','/detail/a05d003e60655a79f2e837fe8eb82bb4','/detail/51b476d83ae88a59d45b4fc8dbcc2aff','/detail/2d95bb194f75179701e3b85363f6b226','/detail/efdce2d8fdfe45cec2481a652d8f7228','/detail/d358a9d9c461169a2ae226a95a788600','/detail/261beb58c30b8fab2fe2a769162bf838','/navigation/01968c8c36bf7d64a6458dea553bd083','/navigation/01968c8c66857cbdaa3fe53f64460992','/navigation/01968c8c819b7a3f80b7123704ac53e6','/navigation/01968c8ca8b57752817b01710b71694a','/navigation/01968c8e2d3a74a38a6c10f9f8460cea','/navigation/01968c8e463172098d9fdfbd02e7079a','/navigation/01968c8e5ce473fd981f91192b9ea060','/navigation/01968c8e70bd7f69b2d493c206e115cb','/navigation/01968c8eb0427cb382bf2677391a27af','/navigation/01968c8f733271dda4a6b5b5769d6a3d','/navigation/01968c8fcbcb7e17b2c838cd17eec670','/navigation/01968c904e6a7dc795fb655c6bba1a6c','/navigation/01968c910b567b13bd06bf0bb60f3a0d','/navigation/01968c91ed89784c83a9842c8cea2016','/navigation/01968c9316807749a8a0e77442aec819')) AND (seo_url.language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id=0x01914A3133A37822896D0C70B2FD3B67ORseo_url.sales_channel_idISNULL) AND (seo_url.is_deleted=0);
SELECTLOWER(HEX(seo_url.id)) asid,LOWER(HEX(seo_url.foreign_key)) foreignKey,LOWER(HEX(seo_url.sales_channel_id)) salesChannelId,seo_url.is_modifiedasisModified,seo_url.seo_path_infoseoPathInfoFROMseo_urlseo_urlWHERE (seo_url.route_name=?) AND (seo_url.language_id=?) AND (seo_url.is_canonical=1) AND (seo_url.foreign_keyIN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?))
SELECTLOWER(
HEX(seo_url.id)
) asid,LOWER(
HEX(seo_url.foreign_key)
) foreignKey,LOWER(
HEX(seo_url.sales_channel_id)
) salesChannelId,seo_url.is_modifiedasisModified,seo_url.seo_path_infoseoPathInfoFROMseo_urlseo_urlWHERE
(seo_url.route_name=?)
AND (seo_url.language_id=?)
AND (seo_url.is_canonical=1)
AND (
seo_url.foreign_keyIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
SELECTLOWER(HEX(seo_url.id)) asid,LOWER(HEX(seo_url.foreign_key)) foreignKey,LOWER(HEX(seo_url.sales_channel_id)) salesChannelId,seo_url.is_modifiedasisModified,seo_url.seo_path_infoseoPathInfoFROMseo_urlseo_urlWHERE (seo_url.route_name='frontend.detail.page') AND (seo_url.language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.is_canonical=1) AND (seo_url.foreign_keyIN (0x225D65DF8675436FC6A39F61CE19916D,0xC825E40BEBB52BB8B27B5AA2BB4044A1,0x1C665BD2FE0F886C7CD3B1B683A5F5D3,0xEA894288B0B7ADA588F84CDD968E64A2,0x4A5D9437FBDF7A6EAB08831F8CCCE708,0x0ECBB1B9CBC9766D9B812DBA379C94B8,0xC404FA685B5B38C25DFF74A556A208EF,0x9579C0B2FA9945A274476562C60591FC,0x38F7CA7DACFEF20C12039B125C0779FA,0xDC4C07689228AEAE0F20C4E9B411574D,0x336DB6112733BA3A1B7C2A8062AB391C,0x2B70654A9412E914EEFC7A0E5DB7E46D,0x482130CAE1FBA855D2E4293ECCAD622D,0x9BCC3809AA5140C56AE3436A24590DAB,0xE7A8E3B468D2C76D81FA05DCB7B31AC7,0xEB7403D2F886F420B6907348DFAC02D3,0xA39103BF60DB010DE6E8766B11687521,0x8C5A8960B7F5A949EC305CE005FEDBC0,0xA05D003E60655A79F2E837FE8EB82BB4,0x51B476D83AE88A59D45B4FC8DBCC2AFF,0x2D95BB194F75179701E3B85363F6B226,0xEFDCE2D8FDFE45CEC2481A652D8F7228,0xD358A9D9C461169A2AE226A95A788600,0x261BEB58C30B8FAB2FE2A769162BF838));
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`=?)) AND (`meta_catalog_id`.`id`IN (?))
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE
(
(`meta_catalog_id`.`type`=?)
)
AND (
`meta_catalog_id`.`id`IN (?)
)
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`='facet_F_ONLYSTOCK')) AND (`meta_catalog_id`.`id`IN (0xF9911BF8BB9CA0852F63EE2D73328043));
UPDATEseo_urlSETis_deleted=0WHERE
(
foreign_keyIN (
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
)
)
AND (sales_channel_id=?)
UPDATEseo_urlSETis_deleted=0WHERE (foreign_keyIN (0x225D65DF8675436FC6A39F61CE19916D,0xC825E40BEBB52BB8B27B5AA2BB4044A1,0x1C665BD2FE0F886C7CD3B1B683A5F5D3,0xEA894288B0B7ADA588F84CDD968E64A2,0x4A5D9437FBDF7A6EAB08831F8CCCE708,0x0ECBB1B9CBC9766D9B812DBA379C94B8,0xC404FA685B5B38C25DFF74A556A208EF,0x9579C0B2FA9945A274476562C60591FC,0x38F7CA7DACFEF20C12039B125C0779FA,0xDC4C07689228AEAE0F20C4E9B411574D,0x336DB6112733BA3A1B7C2A8062AB391C,0x2B70654A9412E914EEFC7A0E5DB7E46D,0x482130CAE1FBA855D2E4293ECCAD622D,0x9BCC3809AA5140C56AE3436A24590DAB,0xE7A8E3B468D2C76D81FA05DCB7B31AC7,0xEB7403D2F886F420B6907348DFAC02D3,0xA39103BF60DB010DE6E8766B11687521,0x8C5A8960B7F5A949EC305CE005FEDBC0,0xA05D003E60655A79F2E837FE8EB82BB4,0x51B476D83AE88A59D45B4FC8DBCC2AFF,0x2D95BB194F75179701E3B85363F6B226,0xEFDCE2D8FDFE45CEC2481A652D8F7228,0xD358A9D9C461169A2AE226A95A788600,0x261BEB58C30B8FAB2FE2A769162BF838)) AND (sales_channel_id=0x0190A64A9C267095B2C78AFFDE939AE0);
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`=?)) AND (`meta_catalog_id`.`id`IN (?,?,?))
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE
(
(`meta_catalog_id`.`type`=?)
)
AND (
`meta_catalog_id`.`id`IN (?,?,?)
)
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`='facet_F_Properties_WARENGRUPPE')) AND (`meta_catalog_id`.`id`IN (0x71AB7014B6EB99354F58311E180C89BF,0xCC8AA4BE7C14689B20747E04F58D9B63,0xCED7FBCBDE10B3FCC57CDE2DE23F2126));
# seo-url::resolveSELECTid,path_infopathInfo,is_canonicalisCanonical,sales_channel_idsalesChannelIdFROMseo_urlWHERE (language_id=?) AND ((sales_channel_id=?ORsales_channel_idISNULL)) AND ((seo_path_info=?ORseo_path_info=?))
# seo-url::resolveSELECTid,path_infopathInfo,is_canonicalisCanonical,sales_channel_idsalesChannelIdFROMseo_urlWHERE
(language_id=?)
AND (
(
sales_channel_id=?ORsales_channel_idISNULL
)
)
AND (
(
seo_path_info=?ORseo_path_info=?
)
)
# seo-url::resolveSELECTid,path_infopathInfo,is_canonicalisCanonical,sales_channel_idsalesChannelIdFROMseo_urlWHERE (language_id=0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id=0x01914A3133A37822896D0C70B2FD3B67ORsales_channel_idISNULL)) AND ((seo_path_info='buecher/gestalten-textiles'ORseo_path_info='buecher/gestalten-textiles/'));
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`=?)) AND (`meta_catalog_id`.`id`IN (?,?))
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE
(
(`meta_catalog_id`.`type`=?)
)
AND (
`meta_catalog_id`.`id`IN (?,?)
)
SELECT`meta_catalog_id`.`id`as`meta_catalog_id.id`,`meta_catalog_id`.`type`as`meta_catalog_id.type`,`meta_catalog_id`.`number`as`meta_catalog_id.number`,`meta_catalog_id`.`created_at`as`meta_catalog_id.createdAt`,`meta_catalog_id`.`updated_at`as`meta_catalog_id.updatedAt`FROM`meta_catalog_id`WHERE ((`meta_catalog_id`.`type`='facet_Productform')) AND (`meta_catalog_id`.`id`IN (0x430EF8454AD8CA53C733264F92AF63AB,0x7C8B13DAE802690C5B0BE91196DA4B1B));
# product-listing::load-sortings::search-idsSELECT`product_sorting`.`id`FROM`product_sorting`WHERE (`product_sorting`.`active`=?) ORDER BY`product_sorting`.`priority`DESC
# product-listing::load-sortings::search-idsSELECT`product_sorting`.`id`FROM`product_sorting`WHERE
(`product_sorting`.`active`=?)
ORDER BY`product_sorting`.`priority`DESC
# product-listing::load-sortings::search-idsSELECT`product_sorting`.`id`FROM`product_sorting`WHERE (`product_sorting`.`active`=1) ORDER BY`product_sorting`.`priority`DESC;