13.79 ms (12.68%) 
                                 
                                1 
                                                        
                                
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 : 
[
  "/detail/01907cd55f81722995538a7e6530352f "
  "/navigation/088cce47075247e08e3a872d5916d8b5 "
  "/navigation/6146db238319420ca6ea5301e64aeab9 "
  "/navigation/fda06120bc4d4a9895503a850a4bbc2c "
  "/navigation/d3e6454efa2f4989afd0d1dce8c23d3f "
  "/navigation/82294566c4064694a25d801ce8c4cf89 "
  "/navigation/2adfa32a66574a40b6f721e2e5489a32 "
  "/navigation/f85ebb51b0834eec8880888fe17570e1 "
  "/navigation/d0b7686808c34439a974f217eae792aa "
  "/navigation/85ed4b988f1b499eb869a5fc03b5d36f "
  "/navigation/39e90e2776d4401dad8e83ed0cbcac3a "
  "/navigation/e3760ec9b03e4181aebc48a799eadeda "
  "/navigation/0e8d5f3598004c47888eef56f76c268a "
  "/navigation/f8c558b68e804990b91b6f71242b5f15 "
  "/navigation/7cc0d0f72de24f089aafa2343e8cc1ea "
  "/navigation/9a0c19c9e21749709c8b7f2dbe833ef7 "
  "/navigation/92a0905322144e7b9f56e1bfccad3ff9 "
  "/navigation/788ed152e8b349889bb94e773c9683ac "
  "/navigation/222017e254114dad9cc8902ebedc295e "
  "/navigation/37deff31f6594da5a91d95e572eb3579 "
  "/navigation/cf33e089be3f45a182da22417e0ae177 "
  "/navigation/b508f3c54230428fbbd2177df060e408 "
  "/navigation/f105f3c43c934df1bcee839bcb830777 "
  "/navigation/782dd780c4ff42ff883f4c632448ccba "
  "/navigation/0fe8b77df58b46779275294c947bd905 "
  "/navigation/b383e1d650f646cda0d10f523762a8c5 "
  "/navigation/3f646aca9f284851b7cd74c811dabf9d "
  "/navigation/db61e315195b457cbedca5787f203ada "
  "/navigation/469391a875a5492fa5b63c5f1ee61d69 "
  "/navigation/7a1709a514064f3684b7c5d50c42c3ad "
  "/navigation/425505f74c5c49a48bf55fe0b36f6efa "
  "/navigation/75a4d83adc9c4761b558ef79e16e83d9 "
  "/navigation/cb2c63b1273145be9e3380d1a3e505f7 "
  "/navigation/f7ee2e72e77f464983f9cf727bef6d32 "
  "/navigation/47cfd1b5825742769946ec6179ec906f "
  "/navigation/3f4c23c1903541e199cacdde0159e768 "
  "/navigation/09c96cbea6694721a641557e3899f793 "
  "/navigation/af025bc2d1464b98b4869434b37bded9 "
  "/navigation/e2a5facc79e44d169f8906b0f08c7c86 "
  "/navigation/c59c194ab1514f10b10bfcf705e727be "
  "/navigation/ceee4a8debab47529cca2c7f0209d4e1 "
  "/navigation/0b38c87530e648a089d3e4d8bb1adcf0 "
  "/navigation/c5ab2a1861d74a9981261d7e5d43922b "
  "/navigation/696637456b3e497993ca7eadbfca5ddd "
  "/navigation/0975e541afe0417d9509ba869616d5c6 "
  "/navigation/0d0a2d21bfc1496fbe4139eaaa6def23 "
  "/navigation/be0a563d3c5c48a2a88556dc2cf6919e "
  "/navigation/67fd433bda244bf8b4af59d4190e03c7 "
  "/navigation/c26fe1dcd7e54fd0ab7d58f0ad513239 "
  "/navigation/ccdbc5e4b8c7408daf4c410159b8d4dc "
  "/navigation/f42a467083b04e38a38e0372b6900f62 "
  "/navigation/52a13a086e634ce18f6f72b637e3f7e7 "
  "/navigation/d67377796c8f4a3cb60b1b950c9f9968 "
  "/navigation/afe1cb74876647e1a90db46c70bccebd "
  "/navigation/eda38c72035d4089a07c8c7201e9f65d "
  "/navigation/062f14f9c9a0487db02eae5a3e9adb11 "
  "/navigation/bb5f7881fa724731bc790b6584dc01e2 "
  "/navigation/5a6c761d8c164263ae56c5c605788f1f "
  "/navigation/c556325d1dc54036acd3d1a0c19b0734 "
  "/navigation/1719dabe0e6347acb3219a77f5c9bdef "
  "/navigation/1a0d277741964e2bb69537fe7c9fff8d "
  "/navigation/52946dabdeb34e4faa80bc43b8754e48 "
  "/navigation/24d27889234f4f95888b48e7f94953bc "
  "/navigation/74ec89fc157143b8b1e54404e6927a0b "
  "/navigation/f8400603f7f34ab1b16afe1e55f9bd89 "
  "/navigation/fe16ab5555ca4b5bb56b4c3c7cf43487 "
  "/navigation/075ee8e3fef6445e94a3471140baa5fe "
  "/navigation/8bd5623be4cf4805b79b1dc61b73f4a9 "
  "/navigation/256506a01f184cc6879e658b483d48cc "
  "/navigation/d5be655976be4259b7d6a6c88436090b "
  "/navigation/52edf1c9d90e4907a30d3d9c121358eb "
  "/navigation/e252159a06e6408ab9d546d5b0b375ed "
  "/navigation/3a5c913adb774d99ab0245a1735f0a97 "
  "/navigation/998a2987292f4040a20e495a584dc033 "
  "/navigation/90a0c113abcf42c08b0588b40bbebb6e "
  "/navigation/ea795d635cc4409baafc3c091e50d55d "
  "/navigation/db7c411e11044d64b8fe4491836d1498 "
  "/navigation/60d8b4a0293a498a99576b1864e05aa8 "
  "/navigation/fb94d9f77b1648a599ecfce531b61579 "
  "/navigation/9c24edcd5f9d4defafe656b3bb87eab4 "
  "/navigation/4fac7ef61f48411ba03fe3749d90c071 "
  "/navigation/eed6fce7b4a346c3b778ccdded7325ba "
  "/navigation/538934efa9804fcaa043a17b1cdaa3d8 "
  "/navigation/57705ed93cc140bcb5417f2892c19499 "
  "/navigation/8d38a5ff1e9243a186bd2115ff9eadc2 "
  "/navigation/c32fa5d21dea40529095be5925262783 "
  "/navigation/67f198396c94456190f14358f931c26a "
  "/navigation/025cbb13c47f42968331904c0259de0e "
  "/navigation/b72d96e714ad474eb1f1a4766cdd3aa7 "
  "/navigation/c3e7a0014e394592ad0a18a8cfaf3372 "
  "/navigation/8380c2c0292e4c2b995f17ac96fc221a "
  "/navigation/8ed7c5c8ce2042b3aa14428457c2a6d2 "
  "/navigation/2ffd9e9d00f64b7ca75bbe1e2c061f9c "
  "/navigation/018a1991bbce4cc3a0b36881e0609858 "
  "/navigation/80275fec53cc4418b13757780d0a391a "
  "/navigation/7d831bc424f94acbaded4c192b90ab00 "
  "/navigation/c13385ceea66432ebf9c90b5241245fa "
  "/navigation/c21ad6b9a2674c9bbc7fc887a8f4baf8 "
  "/navigation/1bfc9663a98d43ee976a5d72a1f6f952 "
  "/navigation/d0b5244b803e4d8689f0cf29d1783d69 "
  "/navigation/7d696320009349f59d8b4d4ae689fa0e "
  "/navigation/e162efe6834c4c18a37d89df24a85ee9 "
  "/navigation/6b17b411b0894416bbec2e6152923c55 "
  "/navigation/788233ee30fd4dd5bccdf1cc78307e71 "
  "/navigation/68058afef9e146cfa6ac22b9ddc9b259 "
  "/navigation/b34c881b75064164b353bc1dec6ac68e "
  "/navigation/c7785ee97b314f3db03edee3d9737975 "
  "/navigation/93402c7a97f949a096f24dfb66d62f12 "
  "/navigation/705c5df17ecd4d4e8b66cb875c4ac4a4 "
  "/navigation/95e119c707fb4f108af00dabc98c1b59 "
  "/navigation/517d5b4be04e48ccba78dc027a40488f "
  "/navigation/8298961aeeeb4684acbb6dbd68f4f6fa "
  "/navigation/abe4e14d48e6413d9388df40cbe44f08 "
  "/navigation/a3a47692c1f14c2c8db71eecce611eca "
  "/navigation/61deb88a56e04e1c928430569113bfba "
  "/navigation/10c26629e81346f194fe697b7a75e294 "
  "/navigation/9e5251b3eb3f4a268bcae8a4a30ff7f2 "
  "/navigation/b589d61a2f434726a18b59767a95b99e "
  "/navigation/4400d71f465e4cd7b4242b941296f472 "
  "/navigation/b732f1a97a4e44c2be17c49db554a84d "
  "/navigation/4cf6563db8b14e28b849ce9332d755ec "
  "/navigation/6e95e7e6d0f84c22ba20dfd7981594cb "
  "/navigation/ff333e1dabef4c5983af1122ed798d3e "
  "/navigation/4d22db93233d4086bfee36ef3b1f35f6 "
  "/navigation/4d02dbf4122e4058bf2080900a44455a "
  "/navigation/119ae3d12644495fa6f3618364cbb727 "
  "/navigation/e46870e430b747ecb2d349c455263141 "
  "/navigation/be23eb58dd78417f8787ee0c6ebe330c "
  "/navigation/466647936cab40d3904d2d31ca2cf3e6 "
  "/navigation/f4a44516f22b4cc8954b3cb231002411 "
  "/navigation/7df08da7978d4247900f9270108bb595 "
  "/navigation/d59c6fa53fc64f14ae6ee401298ee9ec "
  "/navigation/3647c4d5b9864b9797613bd740285d81 "
  "/navigation/11aa8af2e5914337b80147fb3b417f01 "
  "/navigation/c35da5cb62394401bb4b8a27e9e9e4ba "
  "/navigation/482b53ae8e0342b0959994dcfd22ebef "
  "/navigation/e0b14a92d05640fe9aaa7f5838123bed "
  "/navigation/2cc6f0ad58cc41f7a1e0fee5a8d69afd "
  "/navigation/522abd10811146118388dd8d252c644a "
  "/navigation/f16e91784bf44ba98025bf6d4b960eff "
  "/navigation/09e908767248492d933a52cb3f9f117b "
  "/navigation/5a365c2907fc4b92ad6865ca0dce12d4 "
  "/navigation/50590070321b4992b1815c059ad59ca4 "
  "/navigation/99a15c90b32244f29da88b4ab4ee3239 "
  "/navigation/c2f3b04dff2648469829fa9e2f5705f9 "
  "/navigation/935166103a3e490095790d4ccc314086 "
  "/navigation/a25c08ee2a204af59f5efa21e30090f4 "
  "/navigation/361443a7216249de96928e3d5004f452 "
  "/navigation/e5b8cb522b544f1c99362ac233994e00 "
  "/navigation/afc70d4cc4704282906ced99404f7a72 "
  "/navigation/82b3c25a888a4ebeb5fb661ec00b8abb "
  "/navigation/cd6a8dabe66241b5ab003a60e73670fe "
  "/navigation/d84d88b1caa34b40ae32fc89a82632aa "
  "/navigation/1832298afded43d0bafb4f9adffb7f7b "
  "/navigation/47d9feac11ec4dd4aa2ca28ef647487d "
  "/navigation/11e80a654d334dae8b0a865222914898 "
  "/navigation/6b1f36d3c3c74106a1e79c36f4213bc7 "
  "/navigation/f4b7603bafc44414ab117c8b38cfd878 "
  "/navigation/e5ce80e45abd415f8d0895ab89e06f77 "
  "/navigation/cef44518aa174c05973fcdc34d5422c6 "
  "/navigation/60bb56d041354f1e939e88f666a9cd65 "
  "/navigation/94b5cd34662b47de98a5ca08a153d540 "
  "/navigation/ee22b10674724db0b93bbefb3a53b000 "
  "/navigation/051fa87536b24ad5888de4352eb66dcd "
  "/navigation/a3325dcd976744a9b7f2990703246ef7 "
  "/navigation/2b60a69d4a5a47e0a3fdbf9f6d58f7e8 "
  "/navigation/cfc787d6fdfa46a989f2f9ac405eb28c "
  "/navigation/4cac06891e084b4ab42034389be686a6 "
  "/navigation/592dc6a003174c72939f9c9206bb9fc8 "
  "/navigation/f1ebd70a55c3423d87cfc3e3b6c47a3a "
  "/navigation/97dca773c7e64a0a9382c62cbb3c3092 "
  "/navigation/0d45ecb6ed3d4fd685bc2fbbc1203ecc "
  "/navigation/907f84eb71d047498c4d4a61c44c4978 "
  "/navigation/742aa3c20c5f4e36977fd1158c36916a "
  "/navigation/16ad571d128444849fd08837180a1ef0 "
  "/navigation/8544509a798e4615af5b534b5a35f5b5 "
  "/navigation/c2c220b6478248989238c07e245fca35 "
  "/navigation/a3c71aa0afd94c9aa1fe66ecd777206b "
  "/navigation/e7b72d5fccc1493c971eccb526f6d12d "
  "/navigation/7dddc7d8d1d74ef28f9c12e2e8aac677 "
  "/navigation/b03a2c463c93486eacc93f4f742ea1f2 "
  "/navigation/21bfb02687734332811066e98085ba11 "
  "/navigation/fbbc83de22664f7994df395b2a340613 "
  "/navigation/563f957f228a48fb9ef95efbe8f1ad83 "
  "/navigation/15d9c5b6e04d4646a3050fc3fc2f84df "
  "/navigation/02455587dbe7441cb30b620bd222ac3b "
  "/navigation/460ad71b0a9d4b96aed25472735f4777 "
  "/navigation/c0140d331b1d4802a60de10691fc3d5f "
  "/navigation/4d01fc191f9740149fdc6102711c6823 "
  "/navigation/92fb2b306b8842d6a71b326857b5cbb5 "
  "/navigation/40a3b520ae5d4017b6eefe15e75e1980 "
  "/navigation/1392601f332c428abd4cc7398f071259 "
  "/navigation/e8c6a616d32c4892998f7a8b86fba4ef "
  "/navigation/105fc3f5c83d46778ded9b38355ddb5e "
  "/navigation/abd9631fe49b40e6ac10a17cc6181df7 "
  "/navigation/825c3e44198b41f48e881e722033fb9b "
  "/navigation/be585685fec1422fabf9556c5b1d4955 "
  "/navigation/ee446ee6cc7b40f2903bd25891a18890 "
  "/navigation/2be391b2a29a4bfeb14b1b990081ce28 "
  "/navigation/614fba7efeaa40808b12f5dc90501757 "
  "/navigation/ee1fb9bf87f14ec086eb23f3e27b84d0 "
  "/navigation/5ec40e618a4d4e56a4f9302f29258d39 "
  "/navigation/c056c12aacce442987daca041ac61028 "
  "/navigation/0e837b0d82d54343bf02a58c3012111c "
  "/navigation/7ed8bb18171341e1b1cd7f0a31de5cc0 "
  "/navigation/d276ad2d62db43f9bca54b5a5c8d5baf "
  "/navigation/1be5d8d2204a4fc1b589197b9c5a9db4 "
  "/navigation/9b106747cfe141409c036310400259e4 "
  "/navigation/6d1782600e1546f7aefc9fbde46336fe "
  "/navigation/d3584a9491e44ee5bf068f19ee855a6c "
  "/navigation/3bb178ff44ab4ecbbd4f4f6fbc99ac7b "
  "/navigation/9a7c6dfbf50a4b52927d9585366175a8 "
  "/navigation/018f6e8823ec73e281019fb0a0c6ffc4?freeInput=TR-VWOT318Y "
  "/detail/01907cd149c170838e086c3ad74b59dd "
  "/detail/01907cd55f537197a6171ad02db4ff4c "
  "/detail/01907cd149d670c5a8419b1a9cf93eb0 "
  "/navigation/16d6820611844818b21f02db155f5571 "
  "/navigation/a803fe72ddfd4c7a963fc7aef88d2982 "
  "/navigation/9407783af883403f9ae466523d9ba969 "
  "/navigation/6b3e2cceaff847288ce982185d3eb159 "
  "/navigation/14411d2ca159444f8c88440374da98ce "
  "/navigation/d02b90bca7924fde90435125dbfd115f "
  "/navigation/c4bb4c0d23994ba3b1ccae2515ca72ab "
  b"/»_ââšMpªXTÎ|ãâ\v  "
  b"4U0/þõH÷—÷5’6\x1C ç¡ "
 ] 
                                 
                                
                                
                                    
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 ) 
                                    Copy 
                                 
                                                                    
                                                                                
SELECT  seo_path_info ,  path_info ,  sales_channel_id  FROM  seo_url  WHERE  (seo_url . is_canonical  =  1 ) AND  (seo_url . path_info  IN  ('/detail/01907cd55f81722995538a7e6530352f' ,  '/navigation/088cce47075247e08e3a872d5916d8b5' ,  '/navigation/6146db238319420ca6ea5301e64aeab9' ,  '/navigation/fda06120bc4d4a9895503a850a4bbc2c' ,  '/navigation/d3e6454efa2f4989afd0d1dce8c23d3f' ,  '/navigation/82294566c4064694a25d801ce8c4cf89' ,  '/navigation/2adfa32a66574a40b6f721e2e5489a32' ,  '/navigation/f85ebb51b0834eec8880888fe17570e1' ,  '/navigation/d0b7686808c34439a974f217eae792aa' ,  '/navigation/85ed4b988f1b499eb869a5fc03b5d36f' ,  '/navigation/39e90e2776d4401dad8e83ed0cbcac3a' ,  '/navigation/e3760ec9b03e4181aebc48a799eadeda' ,  '/navigation/0e8d5f3598004c47888eef56f76c268a' ,  '/navigation/f8c558b68e804990b91b6f71242b5f15' ,  '/navigation/7cc0d0f72de24f089aafa2343e8cc1ea' ,  '/navigation/9a0c19c9e21749709c8b7f2dbe833ef7' ,  '/navigation/92a0905322144e7b9f56e1bfccad3ff9' ,  '/navigation/788ed152e8b349889bb94e773c9683ac' ,  '/navigation/222017e254114dad9cc8902ebedc295e' ,  '/navigation/37deff31f6594da5a91d95e572eb3579' ,  '/navigation/cf33e089be3f45a182da22417e0ae177' ,  '/navigation/b508f3c54230428fbbd2177df060e408' ,  '/navigation/f105f3c43c934df1bcee839bcb830777' ,  '/navigation/782dd780c4ff42ff883f4c632448ccba' ,  '/navigation/0fe8b77df58b46779275294c947bd905' ,  '/navigation/b383e1d650f646cda0d10f523762a8c5' ,  '/navigation/3f646aca9f284851b7cd74c811dabf9d' ,  '/navigation/db61e315195b457cbedca5787f203ada' ,  '/navigation/469391a875a5492fa5b63c5f1ee61d69' ,  '/navigation/7a1709a514064f3684b7c5d50c42c3ad' ,  '/navigation/425505f74c5c49a48bf55fe0b36f6efa' ,  '/navigation/75a4d83adc9c4761b558ef79e16e83d9' ,  '/navigation/cb2c63b1273145be9e3380d1a3e505f7' ,  '/navigation/f7ee2e72e77f464983f9cf727bef6d32' ,  '/navigation/47cfd1b5825742769946ec6179ec906f' ,  '/navigation/3f4c23c1903541e199cacdde0159e768' ,  '/navigation/09c96cbea6694721a641557e3899f793' ,  '/navigation/af025bc2d1464b98b4869434b37bded9' ,  '/navigation/e2a5facc79e44d169f8906b0f08c7c86' ,  '/navigation/c59c194ab1514f10b10bfcf705e727be' ,  '/navigation/ceee4a8debab47529cca2c7f0209d4e1' ,  '/navigation/0b38c87530e648a089d3e4d8bb1adcf0' ,  '/navigation/c5ab2a1861d74a9981261d7e5d43922b' ,  '/navigation/696637456b3e497993ca7eadbfca5ddd' ,  '/navigation/0975e541afe0417d9509ba869616d5c6' ,  '/navigation/0d0a2d21bfc1496fbe4139eaaa6def23' ,  '/navigation/be0a563d3c5c48a2a88556dc2cf6919e' ,  '/navigation/67fd433bda244bf8b4af59d4190e03c7' ,  '/navigation/c26fe1dcd7e54fd0ab7d58f0ad513239' ,  '/navigation/ccdbc5e4b8c7408daf4c410159b8d4dc' ,  '/navigation/f42a467083b04e38a38e0372b6900f62' ,  '/navigation/52a13a086e634ce18f6f72b637e3f7e7' ,  '/navigation/d67377796c8f4a3cb60b1b950c9f9968' ,  '/navigation/afe1cb74876647e1a90db46c70bccebd' ,  '/navigation/eda38c72035d4089a07c8c7201e9f65d' ,  '/navigation/062f14f9c9a0487db02eae5a3e9adb11' ,  '/navigation/bb5f7881fa724731bc790b6584dc01e2' ,  '/navigation/5a6c761d8c164263ae56c5c605788f1f' ,  '/navigation/c556325d1dc54036acd3d1a0c19b0734' ,  '/navigation/1719dabe0e6347acb3219a77f5c9bdef' ,  '/navigation/1a0d277741964e2bb69537fe7c9fff8d' ,  '/navigation/52946dabdeb34e4faa80bc43b8754e48' ,  '/navigation/24d27889234f4f95888b48e7f94953bc' ,  '/navigation/74ec89fc157143b8b1e54404e6927a0b' ,  '/navigation/f8400603f7f34ab1b16afe1e55f9bd89' ,  '/navigation/fe16ab5555ca4b5bb56b4c3c7cf43487' ,  '/navigation/075ee8e3fef6445e94a3471140baa5fe' ,  '/navigation/8bd5623be4cf4805b79b1dc61b73f4a9' ,  '/navigation/256506a01f184cc6879e658b483d48cc' ,  '/navigation/d5be655976be4259b7d6a6c88436090b' ,  '/navigation/52edf1c9d90e4907a30d3d9c121358eb' ,  '/navigation/e252159a06e6408ab9d546d5b0b375ed' ,  '/navigation/3a5c913adb774d99ab0245a1735f0a97' ,  '/navigation/998a2987292f4040a20e495a584dc033' ,  '/navigation/90a0c113abcf42c08b0588b40bbebb6e' ,  '/navigation/ea795d635cc4409baafc3c091e50d55d' ,  '/navigation/db7c411e11044d64b8fe4491836d1498' ,  '/navigation/60d8b4a0293a498a99576b1864e05aa8' ,  '/navigation/fb94d9f77b1648a599ecfce531b61579' ,  '/navigation/9c24edcd5f9d4defafe656b3bb87eab4' ,  '/navigation/4fac7ef61f48411ba03fe3749d90c071' ,  '/navigation/eed6fce7b4a346c3b778ccdded7325ba' ,  '/navigation/538934efa9804fcaa043a17b1cdaa3d8' ,  '/navigation/57705ed93cc140bcb5417f2892c19499' ,  '/navigation/8d38a5ff1e9243a186bd2115ff9eadc2' ,  '/navigation/c32fa5d21dea40529095be5925262783' ,  '/navigation/67f198396c94456190f14358f931c26a' ,  '/navigation/025cbb13c47f42968331904c0259de0e' ,  '/navigation/b72d96e714ad474eb1f1a4766cdd3aa7' ,  '/navigation/c3e7a0014e394592ad0a18a8cfaf3372' ,  '/navigation/8380c2c0292e4c2b995f17ac96fc221a' ,  '/navigation/8ed7c5c8ce2042b3aa14428457c2a6d2' ,  '/navigation/2ffd9e9d00f64b7ca75bbe1e2c061f9c' ,  '/navigation/018a1991bbce4cc3a0b36881e0609858' ,  '/navigation/80275fec53cc4418b13757780d0a391a' ,  '/navigation/7d831bc424f94acbaded4c192b90ab00' ,  '/navigation/c13385ceea66432ebf9c90b5241245fa' ,  '/navigation/c21ad6b9a2674c9bbc7fc887a8f4baf8' ,  '/navigation/1bfc9663a98d43ee976a5d72a1f6f952' ,  '/navigation/d0b5244b803e4d8689f0cf29d1783d69' ,  '/navigation/7d696320009349f59d8b4d4ae689fa0e' ,  '/navigation/e162efe6834c4c18a37d89df24a85ee9' ,  '/navigation/6b17b411b0894416bbec2e6152923c55' ,  '/navigation/788233ee30fd4dd5bccdf1cc78307e71' ,  '/navigation/68058afef9e146cfa6ac22b9ddc9b259' ,  '/navigation/b34c881b75064164b353bc1dec6ac68e' ,  '/navigation/c7785ee97b314f3db03edee3d9737975' ,  '/navigation/93402c7a97f949a096f24dfb66d62f12' ,  '/navigation/705c5df17ecd4d4e8b66cb875c4ac4a4' ,  '/navigation/95e119c707fb4f108af00dabc98c1b59' ,  '/navigation/517d5b4be04e48ccba78dc027a40488f' ,  '/navigation/8298961aeeeb4684acbb6dbd68f4f6fa' ,  '/navigation/abe4e14d48e6413d9388df40cbe44f08' ,  '/navigation/a3a47692c1f14c2c8db71eecce611eca' ,  '/navigation/61deb88a56e04e1c928430569113bfba' ,  '/navigation/10c26629e81346f194fe697b7a75e294' ,  '/navigation/9e5251b3eb3f4a268bcae8a4a30ff7f2' ,  '/navigation/b589d61a2f434726a18b59767a95b99e' ,  '/navigation/4400d71f465e4cd7b4242b941296f472' ,  '/navigation/b732f1a97a4e44c2be17c49db554a84d' ,  '/navigation/4cf6563db8b14e28b849ce9332d755ec' ,  '/navigation/6e95e7e6d0f84c22ba20dfd7981594cb' ,  '/navigation/ff333e1dabef4c5983af1122ed798d3e' ,  '/navigation/4d22db93233d4086bfee36ef3b1f35f6' ,  '/navigation/4d02dbf4122e4058bf2080900a44455a' ,  '/navigation/119ae3d12644495fa6f3618364cbb727' ,  '/navigation/e46870e430b747ecb2d349c455263141' ,  '/navigation/be23eb58dd78417f8787ee0c6ebe330c' ,  '/navigation/466647936cab40d3904d2d31ca2cf3e6' ,  '/navigation/f4a44516f22b4cc8954b3cb231002411' ,  '/navigation/7df08da7978d4247900f9270108bb595' ,  '/navigation/d59c6fa53fc64f14ae6ee401298ee9ec' ,  '/navigation/3647c4d5b9864b9797613bd740285d81' ,  '/navigation/11aa8af2e5914337b80147fb3b417f01' ,  '/navigation/c35da5cb62394401bb4b8a27e9e9e4ba' ,  '/navigation/482b53ae8e0342b0959994dcfd22ebef' ,  '/navigation/e0b14a92d05640fe9aaa7f5838123bed' ,  '/navigation/2cc6f0ad58cc41f7a1e0fee5a8d69afd' ,  '/navigation/522abd10811146118388dd8d252c644a' ,  '/navigation/f16e91784bf44ba98025bf6d4b960eff' ,  '/navigation/09e908767248492d933a52cb3f9f117b' ,  '/navigation/5a365c2907fc4b92ad6865ca0dce12d4' ,  '/navigation/50590070321b4992b1815c059ad59ca4' ,  '/navigation/99a15c90b32244f29da88b4ab4ee3239' ,  '/navigation/c2f3b04dff2648469829fa9e2f5705f9' ,  '/navigation/935166103a3e490095790d4ccc314086' ,  '/navigation/a25c08ee2a204af59f5efa21e30090f4' ,  '/navigation/361443a7216249de96928e3d5004f452' ,  '/navigation/e5b8cb522b544f1c99362ac233994e00' ,  '/navigation/afc70d4cc4704282906ced99404f7a72' ,  '/navigation/82b3c25a888a4ebeb5fb661ec00b8abb' ,  '/navigation/cd6a8dabe66241b5ab003a60e73670fe' ,  '/navigation/d84d88b1caa34b40ae32fc89a82632aa' ,  '/navigation/1832298afded43d0bafb4f9adffb7f7b' ,  '/navigation/47d9feac11ec4dd4aa2ca28ef647487d' ,  '/navigation/11e80a654d334dae8b0a865222914898' ,  '/navigation/6b1f36d3c3c74106a1e79c36f4213bc7' ,  '/navigation/f4b7603bafc44414ab117c8b38cfd878' ,  '/navigation/e5ce80e45abd415f8d0895ab89e06f77' ,  '/navigation/cef44518aa174c05973fcdc34d5422c6' ,  '/navigation/60bb56d041354f1e939e88f666a9cd65' ,  '/navigation/94b5cd34662b47de98a5ca08a153d540' ,  '/navigation/ee22b10674724db0b93bbefb3a53b000' ,  '/navigation/051fa87536b24ad5888de4352eb66dcd' ,  '/navigation/a3325dcd976744a9b7f2990703246ef7' ,  '/navigation/2b60a69d4a5a47e0a3fdbf9f6d58f7e8' ,  '/navigation/cfc787d6fdfa46a989f2f9ac405eb28c' ,  '/navigation/4cac06891e084b4ab42034389be686a6' ,  '/navigation/592dc6a003174c72939f9c9206bb9fc8' ,  '/navigation/f1ebd70a55c3423d87cfc3e3b6c47a3a' ,  '/navigation/97dca773c7e64a0a9382c62cbb3c3092' ,  '/navigation/0d45ecb6ed3d4fd685bc2fbbc1203ecc' ,  '/navigation/907f84eb71d047498c4d4a61c44c4978' ,  '/navigation/742aa3c20c5f4e36977fd1158c36916a' ,  '/navigation/16ad571d128444849fd08837180a1ef0' ,  '/navigation/8544509a798e4615af5b534b5a35f5b5' ,  '/navigation/c2c220b6478248989238c07e245fca35' ,  '/navigation/a3c71aa0afd94c9aa1fe66ecd777206b' ,  '/navigation/e7b72d5fccc1493c971eccb526f6d12d' ,  '/navigation/7dddc7d8d1d74ef28f9c12e2e8aac677' ,  '/navigation/b03a2c463c93486eacc93f4f742ea1f2' ,  '/navigation/21bfb02687734332811066e98085ba11' ,  '/navigation/fbbc83de22664f7994df395b2a340613' ,  '/navigation/563f957f228a48fb9ef95efbe8f1ad83' ,  '/navigation/15d9c5b6e04d4646a3050fc3fc2f84df' ,  '/navigation/02455587dbe7441cb30b620bd222ac3b' ,  '/navigation/460ad71b0a9d4b96aed25472735f4777' ,  '/navigation/c0140d331b1d4802a60de10691fc3d5f' ,  '/navigation/4d01fc191f9740149fdc6102711c6823' ,  '/navigation/92fb2b306b8842d6a71b326857b5cbb5' ,  '/navigation/40a3b520ae5d4017b6eefe15e75e1980' ,  '/navigation/1392601f332c428abd4cc7398f071259' ,  '/navigation/e8c6a616d32c4892998f7a8b86fba4ef' ,  '/navigation/105fc3f5c83d46778ded9b38355ddb5e' ,  '/navigation/abd9631fe49b40e6ac10a17cc6181df7' ,  '/navigation/825c3e44198b41f48e881e722033fb9b' ,  '/navigation/be585685fec1422fabf9556c5b1d4955' ,  '/navigation/ee446ee6cc7b40f2903bd25891a18890' ,  '/navigation/2be391b2a29a4bfeb14b1b990081ce28' ,  '/navigation/614fba7efeaa40808b12f5dc90501757' ,  '/navigation/ee1fb9bf87f14ec086eb23f3e27b84d0' ,  '/navigation/5ec40e618a4d4e56a4f9302f29258d39' ,  '/navigation/c056c12aacce442987daca041ac61028' ,  '/navigation/0e837b0d82d54343bf02a58c3012111c' ,  '/navigation/7ed8bb18171341e1b1cd7f0a31de5cc0' ,  '/navigation/d276ad2d62db43f9bca54b5a5c8d5baf' ,  '/navigation/1be5d8d2204a4fc1b589197b9c5a9db4' ,  '/navigation/9b106747cfe141409c036310400259e4' ,  '/navigation/6d1782600e1546f7aefc9fbde46336fe' ,  '/navigation/d3584a9491e44ee5bf068f19ee855a6c' ,  '/navigation/3bb178ff44ab4ecbbd4f4f6fbc99ac7b' ,  '/navigation/9a7c6dfbf50a4b52927d9585366175a8' ,  '/navigation/018f6e8823ec73e281019fb0a0c6ffc4?freeInput=TR-VWOT318Y' ,  '/detail/01907cd149c170838e086c3ad74b59dd' ,  '/detail/01907cd55f537197a6171ad02db4ff4c' ,  '/detail/01907cd149d670c5a8419b1a9cf93eb0' ,  '/navigation/16d6820611844818b21f02db155f5571' ,  '/navigation/a803fe72ddfd4c7a963fc7aef88d2982' ,  '/navigation/9407783af883403f9ae466523d9ba969' ,  '/navigation/6b3e2cceaff847288ce982185d3eb159' ,  '/navigation/14411d2ca159444f8c88440374da98ce' ,  '/navigation/d02b90bca7924fde90435125dbfd115f' ,  '/navigation/c4bb4c0d23994ba3b1ccae2515ca72ab' )) AND  (seo_url . language_id  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND  (seo_url . sales_channel_id  =  0x3455302FFEF548F797F73592361CE7A1  OR  seo_url . sales_channel_id  IS  NULL ) AND  (seo_url . is_deleted  =  0 );  
                                        Copy 
                                     
                                
                                                                    
                                
                                                                    
                                                             
                         
                                                                    
                                                            
                                     
                                    3.91 ms (3.60%) 
                                 
                                4 
                                                        
                                SELECT  `app` . `id`  as  `app.id` ,  `app` . `name`  as  `app.name` ,  `app` . `path`  as  `app.path` ,  `app` . `author`  as  `app.author` ,  `app` . `copyright`  as  `app.copyright` ,  `app` . `license`  as  `app.license` ,  `app` . `active`  as  `app.active` ,  `app` . `configurable`  as  `app.configurable` ,  `app` . `privacy`  as  `app.privacy` ,  `app` . `version`  as  `app.version` ,  `app` . `icon`  as  `app.iconRaw` ,  `app` . `app_secret`  as  `app.appSecret` ,  `app` . `modules`  as  `app.modules` ,  `app` . `main_module`  as  `app.mainModule` ,  `app` . `cookies`  as  `app.cookies` ,  `app` . `allow_disable`  as  `app.allowDisable` ,  `app` . `base_app_url`  as  `app.baseAppUrl` ,  `app` . `allowed_hosts`  as  `app.allowedHosts` ,  `app` . `template_load_priority`  as  `app.templateLoadPriority` ,  `app` . `checkout_gateway_url`  as  `app.checkoutGatewayUrl` ,  `app` . `in_app_purchases_gateway_url`  as  `app.inAppPurchasesGatewayUrl` ,  `app` . `source_type`  as  `app.sourceType` ,  `app` . `source_config`  as  `app.sourceConfig` ,  `app` . `self_managed`  as  `app.selfManaged` ,  `app` . `integration_id`  as  `app.integrationId` ,  `app.integration` . `id`  as  `app.integration.id` ,  `app.integration` . `label`  as  `app.integration.label` ,  `app.integration` . `access_key`  as  `app.integration.accessKey` ,  `app.integration` . `secret_access_key`  as  `app.integration.secretAccessKey` ,  `app.integration` . `last_usage_at`  as  `app.integration.lastUsageAt` ,  `app.integration` . `admin`  as  `app.integration.admin` ,  `app.integration` . `custom_fields`  as  `app.integration.customFields` ,  `app.integration` . `deleted_at`  as  `app.integration.deletedAt` ,  `app.integration` . `created_at`  as  `app.integration.createdAt` ,  `app.integration` . `updated_at`  as  `app.integration.updatedAt` ,  `app` . `acl_role_id`  as  `app.aclRoleId` ,  `app.aclRole` . `id`  as  `app.aclRole.id` ,  `app.aclRole` . `name`  as  `app.aclRole.name` ,  `app.aclRole` . `description`  as  `app.aclRole.description` ,  `app.aclRole` . `privileges`  as  `app.aclRole.privileges` ,  `app.aclRole` . `deleted_at`  as  `app.aclRole.deletedAt` ,  `app.aclRole` . `created_at`  as  `app.aclRole.createdAt` ,  `app.aclRole` . `updated_at`  as  `app.aclRole.updatedAt` ,  `app` . `created_at`  as  `app.createdAt` ,  `app` . `updated_at`  as  `app.updatedAt` ,  `app.translation.label` ,  `app.translation.label`  as  `app.label` ,  `app.translation.description` ,  `app.translation.description`  as  `app.description` ,  `app.translation.privacyPolicyExtensions` ,  `app.translation.privacyPolicyExtensions`  as  `app.privacyPolicyExtensions` ,  `app.translation.customFields` ,  `app.translation.customFields`  as  `app.customFields`  FROM  `app`  LEFT JOIN  `integration`  `app.integration`  ON  `app` . `integration_id`  =  `app.integration` . `id`  LEFT JOIN  `acl_role`  `app.aclRole`  ON  `app` . `acl_role_id`  =  `app.aclRole` . `id`  LEFT JOIN  (SELECT  `app.translation` . `app_id` ,  `app.translation` . `label`  as  `app.translation.label` ,  `app.translation` . `description`  as  `app.translation.description` ,  `app.translation` . `privacy_policy_extensions`  as  `app.translation.privacyPolicyExtensions` ,  `app.translation` . `custom_fields`  as  `app.translation.customFields`  FROM  `app_translation`  `app.translation`  WHERE  `app.translation` . `language_id`  =  ? ) `app.app_translation`  ON  `app.app_translation` . `app_id`  =  `app` . `id`  WHERE  (`app` . `name`  =  ? ) 
                                
                                    Parameters : 
[
  b"/»_ââšMpªXTÎ|ãâ\v  "
  "NINJAManufacturerExtension "
 ] 
                                 
                                
                                
                                    SELECT 
  `app` . `id`  as  `app.id` , 
  `app` . `name`  as  `app.name` , 
  `app` . `path`  as  `app.path` , 
  `app` . `author`  as  `app.author` , 
  `app` . `copyright`  as  `app.copyright` , 
  `app` . `license`  as  `app.license` , 
  `app` . `active`  as  `app.active` , 
  `app` . `configurable`  as  `app.configurable` , 
  `app` . `privacy`  as  `app.privacy` , 
  `app` . `version`  as  `app.version` , 
  `app` . `icon`  as  `app.iconRaw` , 
  `app` . `app_secret`  as  `app.appSecret` , 
  `app` . `modules`  as  `app.modules` , 
  `app` . `main_module`  as  `app.mainModule` , 
  `app` . `cookies`  as  `app.cookies` , 
  `app` . `allow_disable`  as  `app.allowDisable` , 
  `app` . `base_app_url`  as  `app.baseAppUrl` , 
  `app` . `allowed_hosts`  as  `app.allowedHosts` , 
  `app` . `template_load_priority`  as  `app.templateLoadPriority` , 
  `app` . `checkout_gateway_url`  as  `app.checkoutGatewayUrl` , 
  `app` . `in_app_purchases_gateway_url`  as  `app.inAppPurchasesGatewayUrl` , 
  `app` . `source_type`  as  `app.sourceType` , 
  `app` . `source_config`  as  `app.sourceConfig` , 
  `app` . `self_managed`  as  `app.selfManaged` , 
  `app` . `integration_id`  as  `app.integrationId` , 
  `app.integration` . `id`  as  `app.integration.id` , 
  `app.integration` . `label`  as  `app.integration.label` , 
  `app.integration` . `access_key`  as  `app.integration.accessKey` , 
  `app.integration` . `secret_access_key`  as  `app.integration.secretAccessKey` , 
  `app.integration` . `last_usage_at`  as  `app.integration.lastUsageAt` , 
  `app.integration` . `admin`  as  `app.integration.admin` , 
  `app.integration` . `custom_fields`  as  `app.integration.customFields` , 
  `app.integration` . `deleted_at`  as  `app.integration.deletedAt` , 
  `app.integration` . `created_at`  as  `app.integration.createdAt` , 
  `app.integration` . `updated_at`  as  `app.integration.updatedAt` , 
  `app` . `acl_role_id`  as  `app.aclRoleId` , 
  `app.aclRole` . `id`  as  `app.aclRole.id` , 
  `app.aclRole` . `name`  as  `app.aclRole.name` , 
  `app.aclRole` . `description`  as  `app.aclRole.description` , 
  `app.aclRole` . `privileges`  as  `app.aclRole.privileges` , 
  `app.aclRole` . `deleted_at`  as  `app.aclRole.deletedAt` , 
  `app.aclRole` . `created_at`  as  `app.aclRole.createdAt` , 
  `app.aclRole` . `updated_at`  as  `app.aclRole.updatedAt` , 
  `app` . `created_at`  as  `app.createdAt` , 
  `app` . `updated_at`  as  `app.updatedAt` , 
  `app.translation.label` , 
  `app.translation.label`  as  `app.label` , 
  `app.translation.description` , 
  `app.translation.description`  as  `app.description` , 
  `app.translation.privacyPolicyExtensions` , 
  `app.translation.privacyPolicyExtensions`  as  `app.privacyPolicyExtensions` , 
  `app.translation.customFields` , 
  `app.translation.customFields`  as  `app.customFields` 
FROM 
  `app` 
  LEFT JOIN  `integration`  `app.integration`  ON  `app` . `integration_id`  =  `app.integration` . `id` 
  LEFT JOIN  `acl_role`  `app.aclRole`  ON  `app` . `acl_role_id`  =  `app.aclRole` . `id` 
  LEFT JOIN  (
    SELECT 
      `app.translation` . `app_id` , 
      `app.translation` . `label`  as  `app.translation.label` , 
      `app.translation` . `description`  as  `app.translation.description` , 
      `app.translation` . `privacy_policy_extensions`  as  `app.translation.privacyPolicyExtensions` , 
      `app.translation` . `custom_fields`  as  `app.translation.customFields` 
    FROM 
      `app_translation`  `app.translation` 
    WHERE 
      `app.translation` . `language_id`  =  ? 
  ) `app.app_translation`  ON  `app.app_translation` . `app_id`  =  `app` . `id` 
WHERE 
  (`app` . `name`  =  ? ) 
                                    Copy 
                                 
                                                                    
                                                                                SELECT  `app` . `id`  as  `app.id` ,  `app` . `name`  as  `app.name` ,  `app` . `path`  as  `app.path` ,  `app` . `author`  as  `app.author` ,  `app` . `copyright`  as  `app.copyright` ,  `app` . `license`  as  `app.license` ,  `app` . `active`  as  `app.active` ,  `app` . `configurable`  as  `app.configurable` ,  `app` . `privacy`  as  `app.privacy` ,  `app` . `version`  as  `app.version` ,  `app` . `icon`  as  `app.iconRaw` ,  `app` . `app_secret`  as  `app.appSecret` ,  `app` . `modules`  as  `app.modules` ,  `app` . `main_module`  as  `app.mainModule` ,  `app` . `cookies`  as  `app.cookies` ,  `app` . `allow_disable`  as  `app.allowDisable` ,  `app` . `base_app_url`  as  `app.baseAppUrl` ,  `app` . `allowed_hosts`  as  `app.allowedHosts` ,  `app` . `template_load_priority`  as  `app.templateLoadPriority` ,  `app` . `checkout_gateway_url`  as  `app.checkoutGatewayUrl` ,  `app` . `in_app_purchases_gateway_url`  as  `app.inAppPurchasesGatewayUrl` ,  `app` . `source_type`  as  `app.sourceType` ,  `app` . `source_config`  as  `app.sourceConfig` ,  `app` . `self_managed`  as  `app.selfManaged` ,  `app` . `integration_id`  as  `app.integrationId` ,  `app.integration` . `id`  as  `app.integration.id` ,  `app.integration` . `label`  as  `app.integration.label` ,  `app.integration` . `access_key`  as  `app.integration.accessKey` ,  `app.integration` . `secret_access_key`  as  `app.integration.secretAccessKey` ,  `app.integration` . `last_usage_at`  as  `app.integration.lastUsageAt` ,  `app.integration` . `admin`  as  `app.integration.admin` ,  `app.integration` . `custom_fields`  as  `app.integration.customFields` ,  `app.integration` . `deleted_at`  as  `app.integration.deletedAt` ,  `app.integration` . `created_at`  as  `app.integration.createdAt` ,  `app.integration` . `updated_at`  as  `app.integration.updatedAt` ,  `app` . `acl_role_id`  as  `app.aclRoleId` ,  `app.aclRole` . `id`  as  `app.aclRole.id` ,  `app.aclRole` . `name`  as  `app.aclRole.name` ,  `app.aclRole` . `description`  as  `app.aclRole.description` ,  `app.aclRole` . `privileges`  as  `app.aclRole.privileges` ,  `app.aclRole` . `deleted_at`  as  `app.aclRole.deletedAt` ,  `app.aclRole` . `created_at`  as  `app.aclRole.createdAt` ,  `app.aclRole` . `updated_at`  as  `app.aclRole.updatedAt` ,  `app` . `created_at`  as  `app.createdAt` ,  `app` . `updated_at`  as  `app.updatedAt` ,  `app.translation.label` ,  `app.translation.label`  as  `app.label` ,  `app.translation.description` ,  `app.translation.description`  as  `app.description` ,  `app.translation.privacyPolicyExtensions` ,  `app.translation.privacyPolicyExtensions`  as  `app.privacyPolicyExtensions` ,  `app.translation.customFields` ,  `app.translation.customFields`  as  `app.customFields`  FROM  `app`  LEFT JOIN  `integration`  `app.integration`  ON  `app` . `integration_id`  =  `app.integration` . `id`  LEFT JOIN  `acl_role`  `app.aclRole`  ON  `app` . `acl_role_id`  =  `app.aclRole` . `id`  LEFT JOIN  (SELECT  `app.translation` . `app_id` ,  `app.translation` . `label`  as  `app.translation.label` ,  `app.translation` . `description`  as  `app.translation.description` ,  `app.translation` . `privacy_policy_extensions`  as  `app.translation.privacyPolicyExtensions` ,  `app.translation` . `custom_fields`  as  `app.translation.customFields`  FROM  `app_translation`  `app.translation`  WHERE  `app.translation` . `language_id`  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation`  ON  `app.app_translation` . `app_id`  =  `app` . `id`  WHERE  (`app` . `name`  =  'NINJAManufacturerExtension' );  
                                        Copy 
                                     
                                
                                                                    
                                
                                                                    
                                                             
                         
                                                                    
                                                            
                                     
                                    1.70 ms (1.57%) 
                                 
                                1 
                                                        
                                SELECT  `sales_channel_domain` . `id`  as  `sales_channel_domain.id` ,  `sales_channel_domain` . `url`  as  `sales_channel_domain.url` ,  `sales_channel_domain` . `sales_channel_id`  as  `sales_channel_domain.salesChannelId` ,  `sales_channel_domain` . `language_id`  as  `sales_channel_domain.languageId` ,  `sales_channel_domain` . `currency_id`  as  `sales_channel_domain.currencyId` ,  `sales_channel_domain` . `snippet_set_id`  as  `sales_channel_domain.snippetSetId` ,  `sales_channel_domain` . `hreflang_use_only_locale`  as  `sales_channel_domain.hreflangUseOnlyLocale` ,  `sales_channel_domain` . `custom_fields`  as  `sales_channel_domain.customFields` ,  `sales_channel_domain` . `created_at`  as  `sales_channel_domain.createdAt` ,  `sales_channel_domain` . `updated_at`  as  `sales_channel_domain.updatedAt` ,  `sales_channel_domain.language` . `id`  as  `sales_channel_domain.language.id` ,  `sales_channel_domain.language` . `parent_id`  as  `sales_channel_domain.language.parentId` ,  `sales_channel_domain.language` . `locale_id`  as  `sales_channel_domain.language.localeId` ,  `sales_channel_domain.language` . `translation_code_id`  as  `sales_channel_domain.language.translationCodeId` ,  `sales_channel_domain.language` . `name`  as  `sales_channel_domain.language.name` ,  `sales_channel_domain.language` . `custom_fields`  as  `sales_channel_domain.language.customFields` ,  `sales_channel_domain.language` . `created_at`  as  `sales_channel_domain.language.createdAt` ,  `sales_channel_domain.language` . `updated_at`  as  `sales_channel_domain.language.updatedAt` ,  `sales_channel_domain.language.locale` . `id`  as  `sales_channel_domain.language.locale.id` ,  `sales_channel_domain.language.locale` . `code`  as  `sales_channel_domain.language.locale.code` ,  `sales_channel_domain.language.locale` . `created_at`  as  `sales_channel_domain.language.locale.createdAt` ,  `sales_channel_domain.language.locale` . `updated_at`  as  `sales_channel_domain.language.locale.updatedAt` ,  `sales_channel_domain.language.locale.translation.name` ,  `sales_channel_domain.language.locale.translation.name`  as  `sales_channel_domain.language.locale.name` ,  `sales_channel_domain.language.locale.translation.territory` ,  `sales_channel_domain.language.locale.translation.territory`  as  `sales_channel_domain.language.locale.territory` ,  `sales_channel_domain.language.locale.translation.customFields` ,  `sales_channel_domain.language.locale.translation.customFields`  as  `sales_channel_domain.language.locale.customFields` ,  `sales_channel_domain.currency` . `id`  as  `sales_channel_domain.currency.id` ,  `sales_channel_domain.currency` . `factor`  as  `sales_channel_domain.currency.factor` ,  `sales_channel_domain.currency` . `symbol`  as  `sales_channel_domain.currency.symbol` ,  `sales_channel_domain.currency` . `iso_code`  as  `sales_channel_domain.currency.isoCode` ,  `sales_channel_domain.currency` . `position`  as  `sales_channel_domain.currency.position` ,  `sales_channel_domain.currency` . `tax_free_from`  as  `sales_channel_domain.currency.taxFreeFrom` ,  `sales_channel_domain.currency` . `item_rounding`  as  `sales_channel_domain.currency.itemRounding` ,  `sales_channel_domain.currency` . `total_rounding`  as  `sales_channel_domain.currency.totalRounding` ,  `sales_channel_domain.currency` . `created_at`  as  `sales_channel_domain.currency.createdAt` ,  `sales_channel_domain.currency` . `updated_at`  as  `sales_channel_domain.currency.updatedAt` ,  `sales_channel_domain.currency.netiCurrency` . `id`  as  `sales_channel_domain.currency.netiCurrency.id` ,  `sales_channel_domain.currency.netiCurrency` . `currency_id`  as  `sales_channel_domain.currency.netiCurrency.currencyID` ,  `sales_channel_domain.currency.netiCurrency` . `active`  as  `sales_channel_domain.currency.netiCurrency.active` ,  `sales_channel_domain.currency.netiCurrency` . `buffer`  as  `sales_channel_domain.currency.netiCurrency.buffer` ,  `sales_channel_domain.currency.netiCurrency` . `last_factor`  as  `sales_channel_domain.currency.netiCurrency.lastFactor` ,  `sales_channel_domain.currency.netiCurrency` . `last_update`  as  `sales_channel_domain.currency.netiCurrency.lastUpdate` ,  `sales_channel_domain.currency.netiCurrency` . `created_at`  as  `sales_channel_domain.currency.netiCurrency.createdAt` ,  `sales_channel_domain.currency.netiCurrency` . `updated_at`  as  `sales_channel_domain.currency.netiCurrency.updatedAt` ,  `sales_channel_domain.currency.translation.shortName` ,  `sales_channel_domain.currency.translation.shortName`  as  `sales_channel_domain.currency.shortName` ,  `sales_channel_domain.currency.translation.name` ,  `sales_channel_domain.currency.translation.name`  as  `sales_channel_domain.currency.name` ,  `sales_channel_domain.currency.translation.customFields` ,  `sales_channel_domain.currency.translation.customFields`  as  `sales_channel_domain.currency.customFields`  FROM  `sales_channel_domain`  LEFT JOIN  `language`  `sales_channel_domain.language`  ON  `sales_channel_domain` . `language_id`  =  `sales_channel_domain.language` . `id`  LEFT JOIN  `currency`  `sales_channel_domain.currency`  ON  `sales_channel_domain` . `currency_id`  =  `sales_channel_domain.currency` . `id`  LEFT JOIN  `locale`  `sales_channel_domain.language.locale`  ON  `sales_channel_domain.language` . `locale_id`  =  `sales_channel_domain.language.locale` . `id`  LEFT JOIN  (SELECT  `sales_channel_domain.language.locale.translation` . `locale_id` ,  `sales_channel_domain.language.locale.translation` . `name`  as  `sales_channel_domain.language.locale.translation.name` ,  `sales_channel_domain.language.locale.translation` . `territory`  as  `sales_channel_domain.language.locale.translation.territory` ,  `sales_channel_domain.language.locale.translation` . `custom_fields`  as  `sales_channel_domain.language.locale.translation.customFields`  FROM  `locale_translation`  `sales_channel_domain.language.locale.translation`  WHERE  `sales_channel_domain.language.locale.translation` . `language_id`  =  ? ) `sales_channel_domain.language.locale.locale_translation`  ON  `sales_channel_domain.language.locale.locale_translation` . `locale_id`  =  `sales_channel_domain.language.locale` . `id`  LEFT JOIN  `neti_current_currencies_currency`  `sales_channel_domain.currency.netiCurrency`  ON  `sales_channel_domain.currency` . `id`  =  `sales_channel_domain.currency.netiCurrency` . `currency_id`  LEFT JOIN  (SELECT  `sales_channel_domain.currency.translation` . `currency_id` ,  `sales_channel_domain.currency.translation` . `short_name`  as  `sales_channel_domain.currency.translation.shortName` ,  `sales_channel_domain.currency.translation` . `name`  as  `sales_channel_domain.currency.translation.name` ,  `sales_channel_domain.currency.translation` . `custom_fields`  as  `sales_channel_domain.currency.translation.customFields`  FROM  `currency_translation`  `sales_channel_domain.currency.translation`  WHERE  `sales_channel_domain.currency.translation` . `language_id`  =  ? ) `sales_channel_domain.currency.currency_translation`  ON  `sales_channel_domain.currency.currency_translation` . `currency_id`  =  `sales_channel_domain.currency` . `id`  WHERE  `sales_channel_domain` . `id`  IN  (? ) 
                                
                                    Parameters : 
[
  b"/»_ââšMpªXTÎ|ãâ\v  "
  b"/»_ââšMpªXTÎ|ãâ\v  "
  b"\x01 X<lŒx»‹tFª£Gx  "
 ] 
                                 
                                
                                
                                    SELECT 
  `sales_channel_domain` . `id`  as  `sales_channel_domain.id` , 
  `sales_channel_domain` . `url`  as  `sales_channel_domain.url` , 
  `sales_channel_domain` . `sales_channel_id`  as  `sales_channel_domain.salesChannelId` , 
  `sales_channel_domain` . `language_id`  as  `sales_channel_domain.languageId` , 
  `sales_channel_domain` . `currency_id`  as  `sales_channel_domain.currencyId` , 
  `sales_channel_domain` . `snippet_set_id`  as  `sales_channel_domain.snippetSetId` , 
  `sales_channel_domain` . `hreflang_use_only_locale`  as  `sales_channel_domain.hreflangUseOnlyLocale` , 
  `sales_channel_domain` . `custom_fields`  as  `sales_channel_domain.customFields` , 
  `sales_channel_domain` . `created_at`  as  `sales_channel_domain.createdAt` , 
  `sales_channel_domain` . `updated_at`  as  `sales_channel_domain.updatedAt` , 
  `sales_channel_domain.language` . `id`  as  `sales_channel_domain.language.id` , 
  `sales_channel_domain.language` . `parent_id`  as  `sales_channel_domain.language.parentId` , 
  `sales_channel_domain.language` . `locale_id`  as  `sales_channel_domain.language.localeId` , 
  `sales_channel_domain.language` . `translation_code_id`  as  `sales_channel_domain.language.translationCodeId` , 
  `sales_channel_domain.language` . `name`  as  `sales_channel_domain.language.name` , 
  `sales_channel_domain.language` . `custom_fields`  as  `sales_channel_domain.language.customFields` , 
  `sales_channel_domain.language` . `created_at`  as  `sales_channel_domain.language.createdAt` , 
  `sales_channel_domain.language` . `updated_at`  as  `sales_channel_domain.language.updatedAt` , 
  `sales_channel_domain.language.locale` . `id`  as  `sales_channel_domain.language.locale.id` , 
  `sales_channel_domain.language.locale` . `code`  as  `sales_channel_domain.language.locale.code` , 
  `sales_channel_domain.language.locale` . `created_at`  as  `sales_channel_domain.language.locale.createdAt` , 
  `sales_channel_domain.language.locale` . `updated_at`  as  `sales_channel_domain.language.locale.updatedAt` , 
  `sales_channel_domain.language.locale.translation.name` , 
  `sales_channel_domain.language.locale.translation.name`  as  `sales_channel_domain.language.locale.name` , 
  `sales_channel_domain.language.locale.translation.territory` , 
  `sales_channel_domain.language.locale.translation.territory`  as  `sales_channel_domain.language.locale.territory` , 
  `sales_channel_domain.language.locale.translation.customFields` , 
  `sales_channel_domain.language.locale.translation.customFields`  as  `sales_channel_domain.language.locale.customFields` , 
  `sales_channel_domain.currency` . `id`  as  `sales_channel_domain.currency.id` , 
  `sales_channel_domain.currency` . `factor`  as  `sales_channel_domain.currency.factor` , 
  `sales_channel_domain.currency` . `symbol`  as  `sales_channel_domain.currency.symbol` , 
  `sales_channel_domain.currency` . `iso_code`  as  `sales_channel_domain.currency.isoCode` , 
  `sales_channel_domain.currency` . `position`  as  `sales_channel_domain.currency.position` , 
  `sales_channel_domain.currency` . `tax_free_from`  as  `sales_channel_domain.currency.taxFreeFrom` , 
  `sales_channel_domain.currency` . `item_rounding`  as  `sales_channel_domain.currency.itemRounding` , 
  `sales_channel_domain.currency` . `total_rounding`  as  `sales_channel_domain.currency.totalRounding` , 
  `sales_channel_domain.currency` . `created_at`  as  `sales_channel_domain.currency.createdAt` , 
  `sales_channel_domain.currency` . `updated_at`  as  `sales_channel_domain.currency.updatedAt` , 
  `sales_channel_domain.currency.netiCurrency` . `id`  as  `sales_channel_domain.currency.netiCurrency.id` , 
  `sales_channel_domain.currency.netiCurrency` . `currency_id`  as  `sales_channel_domain.currency.netiCurrency.currencyID` , 
  `sales_channel_domain.currency.netiCurrency` . `active`  as  `sales_channel_domain.currency.netiCurrency.active` , 
  `sales_channel_domain.currency.netiCurrency` . `buffer`  as  `sales_channel_domain.currency.netiCurrency.buffer` , 
  `sales_channel_domain.currency.netiCurrency` . `last_factor`  as  `sales_channel_domain.currency.netiCurrency.lastFactor` , 
  `sales_channel_domain.currency.netiCurrency` . `last_update`  as  `sales_channel_domain.currency.netiCurrency.lastUpdate` , 
  `sales_channel_domain.currency.netiCurrency` . `created_at`  as  `sales_channel_domain.currency.netiCurrency.createdAt` , 
  `sales_channel_domain.currency.netiCurrency` . `updated_at`  as  `sales_channel_domain.currency.netiCurrency.updatedAt` , 
  `sales_channel_domain.currency.translation.shortName` , 
  `sales_channel_domain.currency.translation.shortName`  as  `sales_channel_domain.currency.shortName` , 
  `sales_channel_domain.currency.translation.name` , 
  `sales_channel_domain.currency.translation.name`  as  `sales_channel_domain.currency.name` , 
  `sales_channel_domain.currency.translation.customFields` , 
  `sales_channel_domain.currency.translation.customFields`  as  `sales_channel_domain.currency.customFields` 
FROM 
  `sales_channel_domain` 
  LEFT JOIN  `language`  `sales_channel_domain.language`  ON  `sales_channel_domain` . `language_id`  =  `sales_channel_domain.language` . `id` 
  LEFT JOIN  `currency`  `sales_channel_domain.currency`  ON  `sales_channel_domain` . `currency_id`  =  `sales_channel_domain.currency` . `id` 
  LEFT JOIN  `locale`  `sales_channel_domain.language.locale`  ON  `sales_channel_domain.language` . `locale_id`  =  `sales_channel_domain.language.locale` . `id` 
  LEFT JOIN  (
    SELECT 
      `sales_channel_domain.language.locale.translation` . `locale_id` , 
      `sales_channel_domain.language.locale.translation` . `name`  as  `sales_channel_domain.language.locale.translation.name` , 
      `sales_channel_domain.language.locale.translation` . `territory`  as  `sales_channel_domain.language.locale.translation.territory` , 
      `sales_channel_domain.language.locale.translation` . `custom_fields`  as  `sales_channel_domain.language.locale.translation.customFields` 
    FROM 
      `locale_translation`  `sales_channel_domain.language.locale.translation` 
    WHERE 
      `sales_channel_domain.language.locale.translation` . `language_id`  =  ? 
  ) `sales_channel_domain.language.locale.locale_translation`  ON  `sales_channel_domain.language.locale.locale_translation` . `locale_id`  =  `sales_channel_domain.language.locale` . `id` 
  LEFT JOIN  `neti_current_currencies_currency`  `sales_channel_domain.currency.netiCurrency`  ON  `sales_channel_domain.currency` . `id`  =  `sales_channel_domain.currency.netiCurrency` . `currency_id` 
  LEFT JOIN  (
    SELECT 
      `sales_channel_domain.currency.translation` . `currency_id` , 
      `sales_channel_domain.currency.translation` . `short_name`  as  `sales_channel_domain.currency.translation.shortName` , 
      `sales_channel_domain.currency.translation` . `name`  as  `sales_channel_domain.currency.translation.name` , 
      `sales_channel_domain.currency.translation` . `custom_fields`  as  `sales_channel_domain.currency.translation.customFields` 
    FROM 
      `currency_translation`  `sales_channel_domain.currency.translation` 
    WHERE 
      `sales_channel_domain.currency.translation` . `language_id`  =  ? 
  ) `sales_channel_domain.currency.currency_translation`  ON  `sales_channel_domain.currency.currency_translation` . `currency_id`  =  `sales_channel_domain.currency` . `id` 
WHERE 
  `sales_channel_domain` . `id`  IN  (? ) 
                                    Copy 
                                 
                                                                    
                                                                                SELECT  `sales_channel_domain` . `id`  as  `sales_channel_domain.id` ,  `sales_channel_domain` . `url`  as  `sales_channel_domain.url` ,  `sales_channel_domain` . `sales_channel_id`  as  `sales_channel_domain.salesChannelId` ,  `sales_channel_domain` . `language_id`  as  `sales_channel_domain.languageId` ,  `sales_channel_domain` . `currency_id`  as  `sales_channel_domain.currencyId` ,  `sales_channel_domain` . `snippet_set_id`  as  `sales_channel_domain.snippetSetId` ,  `sales_channel_domain` . `hreflang_use_only_locale`  as  `sales_channel_domain.hreflangUseOnlyLocale` ,  `sales_channel_domain` . `custom_fields`  as  `sales_channel_domain.customFields` ,  `sales_channel_domain` . `created_at`  as  `sales_channel_domain.createdAt` ,  `sales_channel_domain` . `updated_at`  as  `sales_channel_domain.updatedAt` ,  `sales_channel_domain.language` . `id`  as  `sales_channel_domain.language.id` ,  `sales_channel_domain.language` . `parent_id`  as  `sales_channel_domain.language.parentId` ,  `sales_channel_domain.language` . `locale_id`  as  `sales_channel_domain.language.localeId` ,  `sales_channel_domain.language` . `translation_code_id`  as  `sales_channel_domain.language.translationCodeId` ,  `sales_channel_domain.language` . `name`  as  `sales_channel_domain.language.name` ,  `sales_channel_domain.language` . `custom_fields`  as  `sales_channel_domain.language.customFields` ,  `sales_channel_domain.language` . `created_at`  as  `sales_channel_domain.language.createdAt` ,  `sales_channel_domain.language` . `updated_at`  as  `sales_channel_domain.language.updatedAt` ,  `sales_channel_domain.language.locale` . `id`  as  `sales_channel_domain.language.locale.id` ,  `sales_channel_domain.language.locale` . `code`  as  `sales_channel_domain.language.locale.code` ,  `sales_channel_domain.language.locale` . `created_at`  as  `sales_channel_domain.language.locale.createdAt` ,  `sales_channel_domain.language.locale` . `updated_at`  as  `sales_channel_domain.language.locale.updatedAt` ,  `sales_channel_domain.language.locale.translation.name` ,  `sales_channel_domain.language.locale.translation.name`  as  `sales_channel_domain.language.locale.name` ,  `sales_channel_domain.language.locale.translation.territory` ,  `sales_channel_domain.language.locale.translation.territory`  as  `sales_channel_domain.language.locale.territory` ,  `sales_channel_domain.language.locale.translation.customFields` ,  `sales_channel_domain.language.locale.translation.customFields`  as  `sales_channel_domain.language.locale.customFields` ,  `sales_channel_domain.currency` . `id`  as  `sales_channel_domain.currency.id` ,  `sales_channel_domain.currency` . `factor`  as  `sales_channel_domain.currency.factor` ,  `sales_channel_domain.currency` . `symbol`  as  `sales_channel_domain.currency.symbol` ,  `sales_channel_domain.currency` . `iso_code`  as  `sales_channel_domain.currency.isoCode` ,  `sales_channel_domain.currency` . `position`  as  `sales_channel_domain.currency.position` ,  `sales_channel_domain.currency` . `tax_free_from`  as  `sales_channel_domain.currency.taxFreeFrom` ,  `sales_channel_domain.currency` . `item_rounding`  as  `sales_channel_domain.currency.itemRounding` ,  `sales_channel_domain.currency` . `total_rounding`  as  `sales_channel_domain.currency.totalRounding` ,  `sales_channel_domain.currency` . `created_at`  as  `sales_channel_domain.currency.createdAt` ,  `sales_channel_domain.currency` . `updated_at`  as  `sales_channel_domain.currency.updatedAt` ,  `sales_channel_domain.currency.netiCurrency` . `id`  as  `sales_channel_domain.currency.netiCurrency.id` ,  `sales_channel_domain.currency.netiCurrency` . `currency_id`  as  `sales_channel_domain.currency.netiCurrency.currencyID` ,  `sales_channel_domain.currency.netiCurrency` . `active`  as  `sales_channel_domain.currency.netiCurrency.active` ,  `sales_channel_domain.currency.netiCurrency` . `buffer`  as  `sales_channel_domain.currency.netiCurrency.buffer` ,  `sales_channel_domain.currency.netiCurrency` . `last_factor`  as  `sales_channel_domain.currency.netiCurrency.lastFactor` ,  `sales_channel_domain.currency.netiCurrency` . `last_update`  as  `sales_channel_domain.currency.netiCurrency.lastUpdate` ,  `sales_channel_domain.currency.netiCurrency` . `created_at`  as  `sales_channel_domain.currency.netiCurrency.createdAt` ,  `sales_channel_domain.currency.netiCurrency` . `updated_at`  as  `sales_channel_domain.currency.netiCurrency.updatedAt` ,  `sales_channel_domain.currency.translation.shortName` ,  `sales_channel_domain.currency.translation.shortName`  as  `sales_channel_domain.currency.shortName` ,  `sales_channel_domain.currency.translation.name` ,  `sales_channel_domain.currency.translation.name`  as  `sales_channel_domain.currency.name` ,  `sales_channel_domain.currency.translation.customFields` ,  `sales_channel_domain.currency.translation.customFields`  as  `sales_channel_domain.currency.customFields`  FROM  `sales_channel_domain`  LEFT JOIN  `language`  `sales_channel_domain.language`  ON  `sales_channel_domain` . `language_id`  =  `sales_channel_domain.language` . `id`  LEFT JOIN  `currency`  `sales_channel_domain.currency`  ON  `sales_channel_domain` . `currency_id`  =  `sales_channel_domain.currency` . `id`  LEFT JOIN  `locale`  `sales_channel_domain.language.locale`  ON  `sales_channel_domain.language` . `locale_id`  =  `sales_channel_domain.language.locale` . `id`  LEFT JOIN  (SELECT  `sales_channel_domain.language.locale.translation` . `locale_id` ,  `sales_channel_domain.language.locale.translation` . `name`  as  `sales_channel_domain.language.locale.translation.name` ,  `sales_channel_domain.language.locale.translation` . `territory`  as  `sales_channel_domain.language.locale.translation.territory` ,  `sales_channel_domain.language.locale.translation` . `custom_fields`  as  `sales_channel_domain.language.locale.translation.customFields`  FROM  `locale_translation`  `sales_channel_domain.language.locale.translation`  WHERE  `sales_channel_domain.language.locale.translation` . `language_id`  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel_domain.language.locale.locale_translation`  ON  `sales_channel_domain.language.locale.locale_translation` . `locale_id`  =  `sales_channel_domain.language.locale` . `id`  LEFT JOIN  `neti_current_currencies_currency`  `sales_channel_domain.currency.netiCurrency`  ON  `sales_channel_domain.currency` . `id`  =  `sales_channel_domain.currency.netiCurrency` . `currency_id`  LEFT JOIN  (SELECT  `sales_channel_domain.currency.translation` . `currency_id` ,  `sales_channel_domain.currency.translation` . `short_name`  as  `sales_channel_domain.currency.translation.shortName` ,  `sales_channel_domain.currency.translation` . `name`  as  `sales_channel_domain.currency.translation.name` ,  `sales_channel_domain.currency.translation` . `custom_fields`  as  `sales_channel_domain.currency.translation.customFields`  FROM  `currency_translation`  `sales_channel_domain.currency.translation`  WHERE  `sales_channel_domain.currency.translation` . `language_id`  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel_domain.currency.currency_translation`  ON  `sales_channel_domain.currency.currency_translation` . `currency_id`  =  `sales_channel_domain.currency` . `id`  WHERE  `sales_channel_domain` . `id`  IN  (0x018F583C6C8C78BB8B7446AAA3477820 );  
                                        Copy 
                                     
                                
                                                                    
                                
                                                                    
                                                             
                         
                                                                    
                                                            
                                     
                                    0.94 ms (0.86%) 
                                 
                                1 
                                                        
                                SELECT  `country` . `id`  as  `country.id` ,  `country` . `iso`  as  `country.iso` ,  `country` . `position`  as  `country.position` ,  `country` . `active`  as  `country.active` ,  `country` . `shipping_available`  as  `country.shippingAvailable` ,  `country` . `iso3`  as  `country.iso3` ,  `country` . `display_state_in_registration`  as  `country.displayStateInRegistration` ,  `country` . `force_state_in_registration`  as  `country.forceStateInRegistration` ,  `country` . `check_vat_id_pattern`  as  `country.checkVatIdPattern` ,  `country` . `vat_id_required`  as  `country.vatIdRequired` ,  `country` . `vat_id_pattern`  as  `country.vatIdPattern` ,  `country` . `customer_tax`  as  `country.customerTax` ,  `country` . `company_tax`  as  `country.companyTax` ,  `country` . `postal_code_required`  as  `country.postalCodeRequired` ,  `country` . `check_postal_code_pattern`  as  `country.checkPostalCodePattern` ,  `country` . `check_advanced_postal_code_pattern`  as  `country.checkAdvancedPostalCodePattern` ,  `country` . `advanced_postal_code_pattern`  as  `country.advancedPostalCodePattern` ,  `country` . `default_postal_code_pattern`  as  `country.defaultPostalCodePattern` ,  `country` . `is_eu`  as  `country.isEu` ,  `country` . `created_at`  as  `country.createdAt` ,  `country` . `updated_at`  as  `country.updatedAt` ,  `country.translation.name` ,  `country.translation.name`  as  `country.name` ,  `country.translation.addressFormat` ,  `country.translation.addressFormat`  as  `country.addressFormat` ,  `country.translation.customFields` ,  `country.translation.customFields`  as  `country.customFields`  FROM  `country`  LEFT JOIN  (SELECT  `country.translation` . `country_id` ,  `country.translation` . `name`  as  `country.translation.name` ,  `country.translation` . `custom_fields`  as  `country.translation.customFields` ,  `country.translation` . `address_format`  as  `country.translation.addressFormat`  FROM  `country_translation`  `country.translation`  WHERE  `country.translation` . `language_id`  =  ? ) `country.country_translation`  ON  `country.country_translation` . `country_id`  =  `country` . `id`  WHERE  `country` . `id`  IN  (? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ) 
                                
                                    Parameters : 
[
  b"/»_ââšMpªXTÎ|ãâ\v  "
  b"\x11  \x11 €ŽÛDÞõA´8R´\x18  "
  b"\x15 žK¥H\x16 J–„\x07 •1ÓtàÀ "
  b"\x1A\x15 %=°:O\x04 –¾§èÊᎣ "
  b"\e v>³ó\x07 EN¤˜\x0F ‚9“¡‚ "
  b""Òµµ\x04 ÈL²˜Ð½oQ·\x19 ¾ "
  b"9£â„µZHŸªK\x1E æ\e kÕœ "
  b"?«¾ÁH A·¯\x7F óÀh@3½ "
  b"IcôÔxUII‰ÞC¥\x11 ‡\f r "
  b"P\x0F\x14 ½UÊD\x18 »ôÛŽ&x\x1A n "
  b"Pß|Š¡>L™€´+\x1F\x04 ã¬ò "
  b"""
    Ua\n  
    ’ýˆDr€\x12\x15 À“ÍSÕ 
    """
  b"[öï\e `LH5¥1(ʼUÜ "
  b"]#„ôY®F-†gö`B3ìú "
  b"kð\x15 kQ‘OÔ¶b[oì\x16 JT "
  b"‡BH\x1D\x19 ‚B\t oæXšÃ\³ "
  b"Š\x1F ÉD€—Nà§\¤ç^ï©[ "
  b"ŠMólç\x18 Nìž\x05 –n\x1F u "
  b"޳6ƒ"øNÕºìâÈAéçß "
  b"‰˜¡‹`Mb…\x17 süQ}»V "
  b"£ƒ‚´Ñ0EÕ¼+HyhTÑ^ "
  b"¥\x15 ¤_’ÍFá¹Î¾®ÿWz‚ "
  b"¥d%ÖöOAˆ¹|¦»‘µAs "
  b"©\x06 {\x0E gENÛ¸G\x15\x12\x11 µÍÛ "
  b"Õ®kP•ôAPªÒÉqÞØ[= "
  b"ÝDää ²K!±3§•Š\x10 ‚ "
  b"äÌí“ÓíBÜ·>€ÝËþkï "
 ] 
                                 
                                
                                
                                    SELECT 
  `country` . `id`  as  `country.id` , 
  `country` . `iso`  as  `country.iso` , 
  `country` . `position`  as  `country.position` , 
  `country` . `active`  as  `country.active` , 
  `country` . `shipping_available`  as  `country.shippingAvailable` , 
  `country` . `iso3`  as  `country.iso3` , 
  `country` . `display_state_in_registration`  as  `country.displayStateInRegistration` , 
  `country` . `force_state_in_registration`  as  `country.forceStateInRegistration` , 
  `country` . `check_vat_id_pattern`  as  `country.checkVatIdPattern` , 
  `country` . `vat_id_required`  as  `country.vatIdRequired` , 
  `country` . `vat_id_pattern`  as  `country.vatIdPattern` , 
  `country` . `customer_tax`  as  `country.customerTax` , 
  `country` . `company_tax`  as  `country.companyTax` , 
  `country` . `postal_code_required`  as  `country.postalCodeRequired` , 
  `country` . `check_postal_code_pattern`  as  `country.checkPostalCodePattern` , 
  `country` . `check_advanced_postal_code_pattern`  as  `country.checkAdvancedPostalCodePattern` , 
  `country` . `advanced_postal_code_pattern`  as  `country.advancedPostalCodePattern` , 
  `country` . `default_postal_code_pattern`  as  `country.defaultPostalCodePattern` , 
  `country` . `is_eu`  as  `country.isEu` , 
  `country` . `created_at`  as  `country.createdAt` , 
  `country` . `updated_at`  as  `country.updatedAt` , 
  `country.translation.name` , 
  `country.translation.name`  as  `country.name` , 
  `country.translation.addressFormat` , 
  `country.translation.addressFormat`  as  `country.addressFormat` , 
  `country.translation.customFields` , 
  `country.translation.customFields`  as  `country.customFields` 
FROM 
  `country` 
  LEFT JOIN  (
    SELECT 
      `country.translation` . `country_id` , 
      `country.translation` . `name`  as  `country.translation.name` , 
      `country.translation` . `custom_fields`  as  `country.translation.customFields` , 
      `country.translation` . `address_format`  as  `country.translation.addressFormat` 
    FROM 
      `country_translation`  `country.translation` 
    WHERE 
      `country.translation` . `language_id`  =  ? 
  ) `country.country_translation`  ON  `country.country_translation` . `country_id`  =  `country` . `id` 
WHERE 
  `country` . `id`  IN  (
    ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , 
    ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? 
  ) 
                                    Copy 
                                 
                                                                    
                                                                                SELECT  `country` . `id`  as  `country.id` ,  `country` . `iso`  as  `country.iso` ,  `country` . `position`  as  `country.position` ,  `country` . `active`  as  `country.active` ,  `country` . `shipping_available`  as  `country.shippingAvailable` ,  `country` . `iso3`  as  `country.iso3` ,  `country` . `display_state_in_registration`  as  `country.displayStateInRegistration` ,  `country` . `force_state_in_registration`  as  `country.forceStateInRegistration` ,  `country` . `check_vat_id_pattern`  as  `country.checkVatIdPattern` ,  `country` . `vat_id_required`  as  `country.vatIdRequired` ,  `country` . `vat_id_pattern`  as  `country.vatIdPattern` ,  `country` . `customer_tax`  as  `country.customerTax` ,  `country` . `company_tax`  as  `country.companyTax` ,  `country` . `postal_code_required`  as  `country.postalCodeRequired` ,  `country` . `check_postal_code_pattern`  as  `country.checkPostalCodePattern` ,  `country` . `check_advanced_postal_code_pattern`  as  `country.checkAdvancedPostalCodePattern` ,  `country` . `advanced_postal_code_pattern`  as  `country.advancedPostalCodePattern` ,  `country` . `default_postal_code_pattern`  as  `country.defaultPostalCodePattern` ,  `country` . `is_eu`  as  `country.isEu` ,  `country` . `created_at`  as  `country.createdAt` ,  `country` . `updated_at`  as  `country.updatedAt` ,  `country.translation.name` ,  `country.translation.name`  as  `country.name` ,  `country.translation.addressFormat` ,  `country.translation.addressFormat`  as  `country.addressFormat` ,  `country.translation.customFields` ,  `country.translation.customFields`  as  `country.customFields`  FROM  `country`  LEFT JOIN  (SELECT  `country.translation` . `country_id` ,  `country.translation` . `name`  as  `country.translation.name` ,  `country.translation` . `custom_fields`  as  `country.translation.customFields` ,  `country.translation` . `address_format`  as  `country.translation.addressFormat`  FROM  `country_translation`  `country.translation`  WHERE  `country.translation` . `language_id`  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation`  ON  `country.country_translation` . `country_id`  =  `country` . `id`  WHERE  `country` . `id`  IN  (0x11A011808DDB44DE90F541B43852B418 ,  0x159E4BA548164A9684079531D374E0C0 ,  0x1A15253DB03A4F0496BEA7E8CAE18DA3 ,  0x1B763EB3F307454EA4980F823993A182 ,  0x22D2B5B504C84CB298D0BD6F51B719BE ,  0x39A3E284B55A489FAA4B1EE61B6BD59C ,  0x3FABBEC148A041B7AF7FF3C0684033BD ,  0x4963F4D47855494989DE43A511870C72 ,  0x500F14BD55CA4418BBF4DB8E26781A6E ,  0x50DF7C8AA13E4C9980B42B1F04E3ACF2 ,  0x55610A92FD884472801215C093CD53D5 ,  0x5BF6EF1B604C4835A5312890CABC55DC ,  0x5D2384F459AE462D8667F6604233ECFA ,  0x6BF0156B51914FD4B6625B6FEC164A54 ,  0x8742481D198242098F6FE6589AC35CB3 ,  0x8A1FC94480974EE0A75CA4E75EEFA95B ,  0x8A4DF36CE7184EC3AC9E9005966E1F75 ,  0x8EB3368322F84ED5BAECE2C841E9E7DF ,  0x908998A18B604D62851773FC517DBB56 ,  0xA38382B4D13045D5BC2B48796854D15E ,  0xA515A45F92CD46E1B9CEBEAEFF577A82 ,  0xA56425D6F64F4188B97CA6BB91B54173 ,  0xA9067B0E67454EDBB847151211B5CDDB ,  0xD5AE6B5095F44150AAD2C971DED85B3D ,  0xDD44E4E4A0B24B21B1338FA7958A1082 ,  0xE4CCED93D3ED42DCB73E80DDCBFE6BEF );  
                                        Copy 
                                     
                                
                                                                    
                                
                                                                    
                                                             
                         
                                                                    
                                                            
                                     
                                    0.89 ms (0.82%) 
                                 
                                1 
                                                        
                                
SELECT  `category` . `id`  as  `category.id` ,  `category` . `version_id`  as  `category.versionId` ,  `category` . `parent_id`  as  `category.parentId` ,  `category` . `parent_version_id`  as  `category.parentVersionId` ,  `category` . `after_category_id`  as  `category.afterCategoryId` ,  `category` . `after_category_version_id`  as  `category.afterCategoryVersionId` ,  `category` . `media_id`  as  `category.mediaId` ,  `category` . `display_nested_products`  as  `category.displayNestedProducts` ,  `category` . `auto_increment`  as  `category.autoIncrement` ,  `category` . `level`  as  `category.level` ,  `category` . `path`  as  `category.path` ,  `category` . `child_count`  as  `category.childCount` ,  `category` . `type`  as  `category.type` ,  `category` . `product_assignment_type`  as  `category.productAssignmentType` ,  `category` . `visible`  as  `category.visible` ,  `category` . `active`  as  `category.active` ,  `category` . `cms_page_id`  as  `category.cmsPageId` ,  `category` . `cms_page_version_id`  as  `category.cmsPageVersionId` ,  `category` . `product_stream_id`  as  `category.productStreamId` ,  `category` . `custom_entity_type_id`  as  `category.customEntityTypeId` ,  `category` . `created_at`  as  `category.createdAt` ,  `category` . `updated_at`  as  `category.updatedAt` ,  `category.translation.name` ,  `category.translation.name`  as  `category.name` ,  `category.translation.breadcrumb` ,  `category.translation.breadcrumb`  as  `category.breadcrumb` ,  `category.translation.slotConfig` ,  `category.translation.slotConfig`  as  `category.slotConfig` ,  `category.translation.linkType` ,  `category.translation.linkType`  as  `category.linkType` ,  `category.translation.internalLink` ,  `category.translation.internalLink`  as  `category.internalLink` ,  `category.translation.externalLink` ,  `category.translation.externalLink`  as  `category.externalLink` ,  `category.translation.linkNewTab` ,  `category.translation.linkNewTab`  as  `category.linkNewTab` ,  `category.translation.description` ,  `category.translation.description`  as  `category.description` ,  `category.translation.metaTitle` ,  `category.translation.metaTitle`  as  `category.metaTitle` ,  `category.translation.metaDescription` ,  `category.translation.metaDescription`  as  `category.metaDescription` ,  `category.translation.keywords` ,  `category.translation.keywords`  as  `category.keywords` ,  `category.translation.customFields` ,  `category.translation.customFields`  as  `category.customFields`  FROM  `category`  LEFT JOIN  (SELECT  `category.translation` . `category_id` ,  `category.translation` . `category_version_id` ,  `category.translation` . `breadcrumb`  as  `category.translation.breadcrumb` ,  `category.translation` . `name`  as  `category.translation.name` ,  `category.translation` . `custom_fields`  as  `category.translation.customFields` ,  `category.translation` . `slot_config`  as  `category.translation.slotConfig` ,  `category.translation` . `link_type`  as  `category.translation.linkType` ,  `category.translation` . `internal_link`  as  `category.translation.internalLink` ,  `category.translation` . `external_link`  as  `category.translation.externalLink` ,  `category.translation` . `link_new_tab`  as  `category.translation.linkNewTab` ,  `category.translation` . `description`  as  `category.translation.description` ,  `category.translation` . `meta_title`  as  `category.translation.metaTitle` ,  `category.translation` . `meta_description`  as  `category.translation.metaDescription` ,  `category.translation` . `keywords`  as  `category.translation.keywords`  FROM  `category_translation`  `category.translation`  WHERE  `category.translation` . `language_id`  =  ? ) `category.category_translation`  ON  `category.category_translation` . `category_id`  =  `category` . `id`  AND  `category.category_translation` . `category_version_id`  =  `category` . `version_id`  WHERE  (`category` . `version_id`  =  ? ) AND  (`category` . `id`  IN  (? ,  ? ,  ? )) 
                                
                                    Parameters : 
[
  b"/»_ââšMpªXTÎ|ãâ\v  "
  b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
  b"|ÀÐ÷-âO\x08 š¯¢4>ŒÁê "
  b"ç·-_ÌÁI<—\x1E ̵&öÑ- "
  b"M\x01 ü\x19\x1F —@\x14 ŸÜa\x02 q\x1C h# "
 ] 
                                 
                                
                                
                                    
SELECT 
  `category` . `id`  as  `category.id` , 
  `category` . `version_id`  as  `category.versionId` , 
  `category` . `parent_id`  as  `category.parentId` , 
  `category` . `parent_version_id`  as  `category.parentVersionId` , 
  `category` . `after_category_id`  as  `category.afterCategoryId` , 
  `category` . `after_category_version_id`  as  `category.afterCategoryVersionId` , 
  `category` . `media_id`  as  `category.mediaId` , 
  `category` . `display_nested_products`  as  `category.displayNestedProducts` , 
  `category` . `auto_increment`  as  `category.autoIncrement` , 
  `category` . `level`  as  `category.level` , 
  `category` . `path`  as  `category.path` , 
  `category` . `child_count`  as  `category.childCount` , 
  `category` . `type`  as  `category.type` , 
  `category` . `product_assignment_type`  as  `category.productAssignmentType` , 
  `category` . `visible`  as  `category.visible` , 
  `category` . `active`  as  `category.active` , 
  `category` . `cms_page_id`  as  `category.cmsPageId` , 
  `category` . `cms_page_version_id`  as  `category.cmsPageVersionId` , 
  `category` . `product_stream_id`  as  `category.productStreamId` , 
  `category` . `custom_entity_type_id`  as  `category.customEntityTypeId` , 
  `category` . `created_at`  as  `category.createdAt` , 
  `category` . `updated_at`  as  `category.updatedAt` , 
  `category.translation.name` , 
  `category.translation.name`  as  `category.name` , 
  `category.translation.breadcrumb` , 
  `category.translation.breadcrumb`  as  `category.breadcrumb` , 
  `category.translation.slotConfig` , 
  `category.translation.slotConfig`  as  `category.slotConfig` , 
  `category.translation.linkType` , 
  `category.translation.linkType`  as  `category.linkType` , 
  `category.translation.internalLink` , 
  `category.translation.internalLink`  as  `category.internalLink` , 
  `category.translation.externalLink` , 
  `category.translation.externalLink`  as  `category.externalLink` , 
  `category.translation.linkNewTab` , 
  `category.translation.linkNewTab`  as  `category.linkNewTab` , 
  `category.translation.description` , 
  `category.translation.description`  as  `category.description` , 
  `category.translation.metaTitle` , 
  `category.translation.metaTitle`  as  `category.metaTitle` , 
  `category.translation.metaDescription` , 
  `category.translation.metaDescription`  as  `category.metaDescription` , 
  `category.translation.keywords` , 
  `category.translation.keywords`  as  `category.keywords` , 
  `category.translation.customFields` , 
  `category.translation.customFields`  as  `category.customFields` 
FROM 
  `category` 
  LEFT JOIN  (
    SELECT 
      `category.translation` . `category_id` , 
      `category.translation` . `category_version_id` , 
      `category.translation` . `breadcrumb`  as  `category.translation.breadcrumb` , 
      `category.translation` . `name`  as  `category.translation.name` , 
      `category.translation` . `custom_fields`  as  `category.translation.customFields` , 
      `category.translation` . `slot_config`  as  `category.translation.slotConfig` , 
      `category.translation` . `link_type`  as  `category.translation.linkType` , 
      `category.translation` . `internal_link`  as  `category.translation.internalLink` , 
      `category.translation` . `external_link`  as  `category.translation.externalLink` , 
      `category.translation` . `link_new_tab`  as  `category.translation.linkNewTab` , 
      `category.translation` . `description`  as  `category.translation.description` , 
      `category.translation` . `meta_title`  as  `category.translation.metaTitle` , 
      `category.translation` . `meta_description`  as  `category.translation.metaDescription` , 
      `category.translation` . `keywords`  as  `category.translation.keywords` 
    FROM 
      `category_translation`  `category.translation` 
    WHERE 
      `category.translation` . `language_id`  =  ? 
  ) `category.category_translation`  ON  `category.category_translation` . `category_id`  =  `category` . `id` 
  AND  `category.category_translation` . `category_version_id`  =  `category` . `version_id` 
WHERE 
  (`category` . `version_id`  =  ? )
  AND  (
    `category` . `id`  IN  (? ,  ? ,  ? )
  ) 
                                    Copy 
                                 
                                                                    
                                                                                
SELECT  `category` . `id`  as  `category.id` ,  `category` . `version_id`  as  `category.versionId` ,  `category` . `parent_id`  as  `category.parentId` ,  `category` . `parent_version_id`  as  `category.parentVersionId` ,  `category` . `after_category_id`  as  `category.afterCategoryId` ,  `category` . `after_category_version_id`  as  `category.afterCategoryVersionId` ,  `category` . `media_id`  as  `category.mediaId` ,  `category` . `display_nested_products`  as  `category.displayNestedProducts` ,  `category` . `auto_increment`  as  `category.autoIncrement` ,  `category` . `level`  as  `category.level` ,  `category` . `path`  as  `category.path` ,  `category` . `child_count`  as  `category.childCount` ,  `category` . `type`  as  `category.type` ,  `category` . `product_assignment_type`  as  `category.productAssignmentType` ,  `category` . `visible`  as  `category.visible` ,  `category` . `active`  as  `category.active` ,  `category` . `cms_page_id`  as  `category.cmsPageId` ,  `category` . `cms_page_version_id`  as  `category.cmsPageVersionId` ,  `category` . `product_stream_id`  as  `category.productStreamId` ,  `category` . `custom_entity_type_id`  as  `category.customEntityTypeId` ,  `category` . `created_at`  as  `category.createdAt` ,  `category` . `updated_at`  as  `category.updatedAt` ,  `category.translation.name` ,  `category.translation.name`  as  `category.name` ,  `category.translation.breadcrumb` ,  `category.translation.breadcrumb`  as  `category.breadcrumb` ,  `category.translation.slotConfig` ,  `category.translation.slotConfig`  as  `category.slotConfig` ,  `category.translation.linkType` ,  `category.translation.linkType`  as  `category.linkType` ,  `category.translation.internalLink` ,  `category.translation.internalLink`  as  `category.internalLink` ,  `category.translation.externalLink` ,  `category.translation.externalLink`  as  `category.externalLink` ,  `category.translation.linkNewTab` ,  `category.translation.linkNewTab`  as  `category.linkNewTab` ,  `category.translation.description` ,  `category.translation.description`  as  `category.description` ,  `category.translation.metaTitle` ,  `category.translation.metaTitle`  as  `category.metaTitle` ,  `category.translation.metaDescription` ,  `category.translation.metaDescription`  as  `category.metaDescription` ,  `category.translation.keywords` ,  `category.translation.keywords`  as  `category.keywords` ,  `category.translation.customFields` ,  `category.translation.customFields`  as  `category.customFields`  FROM  `category`  LEFT JOIN  (SELECT  `category.translation` . `category_id` ,  `category.translation` . `category_version_id` ,  `category.translation` . `breadcrumb`  as  `category.translation.breadcrumb` ,  `category.translation` . `name`  as  `category.translation.name` ,  `category.translation` . `custom_fields`  as  `category.translation.customFields` ,  `category.translation` . `slot_config`  as  `category.translation.slotConfig` ,  `category.translation` . `link_type`  as  `category.translation.linkType` ,  `category.translation` . `internal_link`  as  `category.translation.internalLink` ,  `category.translation` . `external_link`  as  `category.translation.externalLink` ,  `category.translation` . `link_new_tab`  as  `category.translation.linkNewTab` ,  `category.translation` . `description`  as  `category.translation.description` ,  `category.translation` . `meta_title`  as  `category.translation.metaTitle` ,  `category.translation` . `meta_description`  as  `category.translation.metaDescription` ,  `category.translation` . `keywords`  as  `category.translation.keywords`  FROM  `category_translation`  `category.translation`  WHERE  `category.translation` . `language_id`  =  0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation`  ON  `category.category_translation` . `category_id`  =  `category` . `id`  AND  `category.category_translation` . `category_version_id`  =  `category` . `version_id`  WHERE  (`category` . `version_id`  =  0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND  (`category` . `id`  IN  (0x7CC0D0F72DE24F089AAFA2343E8CC1EA ,  0xE7B72D5FCCC1493C971ECCB526F6D12D ,  0x4D01FC191F9740149FDC6102711C6823 ));  
                                        Copy